Page 51 - City of Westworth Village FY22 Budget

51

Actual Actual Actual Adopted Projected Proposed
ACCT 2018 2019 2020 2021 2021 2022
Miscellaneous
09-670-635001 Miscellaneous Expense $ 61 $ 16 $ - $ 500 $ - $ 500
09-670-635023 Sales & Use Tax $ 11,509 $ 10,408 $ 9,082 $ 8,498 $ 8,333 $ 8,498
09-670-635024 Mixed Beverage Tax $ 9,070 $ 9,143 $ 8,972 $ 9,908 $ 5,787 $ 9,908
09-670-635025 Liquor Tax 6.7% Gross Sales $ 7,366 $ 7,479 $ 7,287 $ 8,047 $ 7,913 $ 8,047
09-670-635030 Waste Disposal $ 910 $ 1,030 $ 810 $ 1,080 $ 1,080 $ 1,080
09-670-635040 Licenses & Permits $ 430 $ 3,367 $ 582 $ 4,000 $ 4,000 $ 4,000
Total Miscellaneous $ 29,346 $ 31,443 $ 26,733 $ 32,032 $ 27,113 $ 32,032
Total Food & Beverages Expenses $ 219,010 $ 228,330 $ 252,220 $ 289,239 $ 299,710 $ 277,166
Pro Shop Expenses
Payroll
09-671-610001 Salaries $ 195,783 $ 165,477 $ 136,218 $ 212,718 $ 160,871 $ 226,462
09-671-610002 TMRS Retirement $ 18,900 $ 20,811 $ 15,894 $ 17,008 $ 22,512 $ 21,843
09-671-610003 Workers' Compensation $ 5,808 $ 5,569 $ 4,940 $ 6,820 $ 6,613 $ 7,260
09-671-610004 Unemployment Comp $ 1,276 $ 648 $ 50 $ 1,296 $ 564 $ 1,296
06-671-610005 Group Health Insurance $ 26,680 $ 17,284 $ 16,626 $ 24,900 $ 21,590 $ 25,500
09-671-610006 Medicare $ 2,775 $ 2,392 $ 2,027 $ 3,091 $ 2,353 $ 3,290
09-671-610007 FICA Social Security $ 3,016 $ 1 $ 430 $ 4,427 $ 49 $ 3,224
09-671-610008 Over Time Pay $ 1,370 $ 4,187 $ 2,053 $ - $ - $ -
09-671-610009 Cell Phone Allowance $ 245 $ 210 $ 420 $ 420 $ 420 $ 420
09-671-610025 Retirement Stipend $ 3,600 $ 3,600 $ 3,600 $ 3,600
09-671-610030 Tips Earned $ 654 $ 73 $ 1,032 $ - $ 1,809 $ -
09-672-610013 Holiday Pay $ - $ - $ - $ 5,860 $ - $ 6,822
Total Payroll $ 256,507 $ 216,651 $ 183,292 $ 280,141 $ 220,381 $ 299,716
Supplies
09-671-615002 Supplies $ 4,782 $ 6,286 $ 2,594 $ 6,000 $ 6,000 $ 6,000
09-671-615003 Printing $ 440 $ 65 $ 193 $ 500 $ 500 $ 500
09-671-615004 Postage $ 627 $ 65 $ 50 $ 500 $ 500 $ 500
09-671-615005 Electric $ 21,712 $ 22,719 $ 18,828 $ 20,000 $ 27,293 $ 20,000
09-671-615006 Water $ 5,681 $ 4,013 $ 5,388 $ 6,000 $ 9,558 $ 6,000
09-671-615007 Natural Gas $ 2,449 $ 3,089 $ 2,767 $ 3,100 $ 4,597 $ 3,100
09-671-615008 Telephone & Cable $ 8,918 $ 9,313 $ 9,485 $ 9,000 $ 8,736 $ 9,000
09-671-615020 Tournament Supplies $ 104 $ 104 $ (104) $ 200 $ 200 $ 200
09-671-615030 Merchandise $ 92,510 $ 93,952 $ 111,296 $ 90,000 $ 120,762 $ 90,000
Total Supplies $ 137,223 $ 139,605 $ 150,496 $ 135,300 $ 178,146 $ 135,300
Training
09-671-620001 Training $ 3,064 $ 1,190 $ 1,822 $ 1,500 $ 2,137 $ 1,500
09-671-620002 Dues & Memberships $ 6,000 $ 5,389 $ 2,272 $ 5,000 $ 5,000 $ 5,000
Total Supplies $ 9,064 $ 6,579 $ 4,094 $ 6,500 $ 7,137 $ 6,500

Equipment
09-671-625000 New Equipment $ 3,635 $ 200 $ - $ 1,500 $ 1,500 $ 1,500
09-671-625003 Equipment Lease $ - $ - $ 4,194 $ - $ - $ -
09-671-625004 Carts Repair & Maint $ 3,675 $ 2,044 $ 5,789 $ 4,500 $ 4,532 $ 5,000
09-671-625014 Building Maintenance $ - $ 17,779 $ 28,544 $ 15,000 $ 71,094 $ 15,000
09-671-625021 Computer Repairs $ - $ - $ - $ 500 $ 500 $ 500
09-671-625025 Range Ball/Club Rentals $ 6,317 $ 5,880 $ 4,804 $ 12,000 $ 9,000 $ 12,000
09-671-625030 Cart Lease $ 90,658 $ 85,583 $ 49,043 $ 53,600 $ 53,886 $ 53,600

Total Equipment $ 104,285 $ 111,485 $ 92,375 $ 87,100 $ 140,512 $ 87,600

www.cityofwestworth.com