Page 50 - City of Westworth Village FY22 Budget

50

Hawks Creek Golf Course Fund Details
Actual Actual Actual Adopted Projected Proposed
ACCT 2018 2019 2020 2021 2021 2022
Hawks Creek Golf Course (HCGC) Fund Revenue
Revenue
09-500-520000 Sales Tax $ 25,216 $ 23,870 $ 22,665 $ 29,453 $ 13,724 $ 29,453
09-500-520007 Mixed Bev Tax Gross 8.25% $ 9,206 $ 9,143 $ 10,185 $ 9,908 $ 5,787 $ 9,908
Total Revenue $ 34,422 $ 33,013 $ 32,849 $ 39,361 $ 19,510 $ 39,361
Miscellaneous Revenue
09-500-565001 Miscellaneous Revenue $ 40,753 $ 11,215 $ 4,730 $ 1,000 $ 5,000 $ 1,000
09-500-565060 Green Fees $ 991,593 $ 977,201 $ 1,164,714 $ 1,184,000 $ 1,258,000 $ 1,326,000
09-500-565065 Food $ 62,391 $ 49,937 $ 38,023 $ 69,000 $ 49,612 $ 69,000
09-500-565066 Wine $ 594 $ 154 $ 86 $ 100 $ 212 $ 100
09-500-565067 Liquor $ 24,709 $ 25,184 $ 24,352 $ 29,500 $ 32,997 $ 29,500
09-500-565068 Beer $ 84,620 $ 84,950 $ 99,035 $ 90,500 $ 109,082 $ 90,500
09-500-565069 Beverage $ 28,291 $ 24,923 $ 27,111 $ 34,000 $ 31,024 $ 34,000
09-500-565070 Tips Earned $ 13,047 $ 12,912 $ 17,963 $ 12,500 $ 23,513 $ 12,500
09-500-565075 Cart Rental $ 38,744 $ 27,278 $ 23,153 $ 42,000 $ 26,120 $ 42,000
09-500-565076 Contract Lessons $ 3,597 $ 3,677 $ 6,374 $ 5,000 $ 8,942 $ 5,000
09-500-565077 Club Rental $ 4,966 $ 4,571 $ 3,132 $ 5,000 $ 3,869 $ 5,000
09-500-565078 Gratuity/lessons $ 1,603 $ 1,139 $ 213 $ 1,000 $ 348 $ 1,000
09-500-565079 Range Balls $ 85,895 $ 90,749 $ 92,756 $ 92,000 $ 112,271 $ 92,000
09-500-565080 Merchandise $ 129,679 $ 129,059 $ 121,841 $ 120,000 $ 134,585 $ 120,000
09-500-565081 Handicap & Association $ 2,695 $ 2,800 $ 2,590 $ 3,500 $ 3,486 $ 3,500
09-500-565082 Daily over/short $ 968 $ 0 $ (284) $ - $ 257 $ -
09-500-565083 City Landscape Maintenance $ 20,549 $ 19,992 $ 30,000 $ 9,996 $ -
09-500-565084 WRA 4B Transfer $ 77,914 $ - $ - $ - $ -
Total Miscellaneous Revenue $ 1,514,145 $ 1,544,212 $ 1,645,781 $ 1,719,100 $ 1,809,316 $ 1,831,100
Total HCGC Revenue $ 1,548,567 $ 1,577,224 $ 1,678,630 $ 1,758,461 $ 1,828,826 $ 1,870,461
Hawks Creek Golf Course (HCGC) Fund Expenses

Food & Beverage Expenses
Payroll
09-670-610001 Salaries $ 69,292 $ 72,670 $ 74,631 $ 70,932 $ 73,000 $ 72,560
09-670-610002 TMRS Retirement $ 8,913 $ 7,950 $ 10,455 $ 6,984 $ 10,232 $ 7,487
09-670-610003 Workers' Compensation $ 2,325 $ 2,030 $ 1,744 $ 2,405 $ 2,413 $ 2,461
09-670-610004 Unemployment Comp $ 659 $ 503 $ 246 $ 559 $ 897 $ 559
09-670-610005 Group Health Insurance $ 14,684 $ 19,594 $ 19,298 $ 16,800 $ 18,000 $ 17,400
09-670-610006 Medicare $ 1,266 $ 1,274 $ 1,306 $ 1,090 $ 1,447 $ 1,115
09-670-610007 FICA Social Security $ 1,246 $ 1,708 $ 1,433 $ 1,052 $ 2,000 $ 1,052
09-670-610009 Cell Phone Allowance $ 385 $ 420 $ 420 $ 420 $ 420 $ 420
09-670-610030 Tips Earned $ 13,733 $ 1,369 $ 16,155 $ 12,500 $ 23,513 $ 12,500
09-670-610040 Over Time $ 6,231 $ 2,970 $ - $ 1,946 $ 5 $ 2,005
09-672-610013 Holiday Pay $ - $ - $ 5,156 $ 1,868 $ 3,901 $ 1,924
Total Payroll $ 118,734 $ 110,488 $ 130,844 $ 116,557 $ 135,828 $ 119,484

Supplies
09-670-615002 Supplies $ 6,599 $ 4,931 $ 6,201 $ 7,000 $ 4,710 $ 7,000
09-670-615021 Wine $ 462 $ - $ - $ 250 $ 166 $ 250
09-670-615022 Bar Supplies $ 281 $ 38 $ 118 $ 400 $ 102 $ 400
09-670-615023 Beer $ 30,937 $ 29,909 $ 37,599 $ 37,000 $ 52,403 $ 37,000
09-670-615024 Beverages $ 15,509 $ 13,988 $ 16,706 $ 18,000 $ 17,384 $ 18,000
09-670-615025 Food $ 29,765 $ 24,788 $ 21,083 $ 43,000 $ 30,135 $ 43,000
09-670-615026 Liquor $ 8,192 $ 7,626 $ 9,162 $ 9,000 $ 17,569 $ 9,000
Total Supplies $ 91,745 $ 81,281 $ 90,869 $ 114,650 $ 122,470 $ 114,650
Equipment
09-670-625000 New Equipment $ 95 $ 351 $ 79 $ 20,000 $ 1,500 $ 5,000
09-670-625003 Equipment Lease $ 3,780 $ 3,780 $ 2,861 $ 3,800 $ 3,800 $ 3,800
09-670-625004 Equipment Maintenance $ 292 $ 442 $ 150 $ 500 $ 8,000 $ 500
09-670-625020 Equipment Repair $ 489 $ 546 $ 424 $ 1,200 $ 500 $ 1,200
09-670-625021 Computer Repairs $ - $ - $ 260 $ 500 $ 500 $ 500

Total Equipment $ 4,656 $ 5,119 $ 3,774 $ 26,000 $ 14,300 $ 11,000

www.cityofwestworth.com