Page 221 - Grapevine FY22 Adopted Budget v2
P. 221
FY 2021-22 APPROVED OPERATING BUDGET
STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCE
GOLF FUND
2018-19 2019-20 2020-21 2020-21 2021-22
Actual Actual Budget Estimate Approved
BEGINNING WORKING CAPITAL: (856,471) (807,602) (643,097) (643,097) (270,451)
OPERATING REVENUES:
Cart and Club Rentals 644,914 647,337 637,440 790,187 680,000
Tournament Fees 1,920 1,430 3,840 6,860 2,500
Driving Range 192,725 176,899 185,908 226,596 240,000
Golf Pro Shop Sales 244,364 193,723 245,000 284,766 250,000
Golf Course Green Fees 1,426,621 1,486,516 1,369,556 1,796,000 1,707,000
Annual Green Fee Memberships 266,750 247,000 312,960 354,250 325,000
Restaurant % of Sales 31,396 33,663 35,520 23,108 60,000
Lesson Income 15,381 14,920 33,600 25,580 15,000
Interest Income 2,962 1,406 3,000 - 3,000
Golf Sub-Lease 267,491 235,264 232,320 307,634 270,000
Miscellaneous Income 235,333 20,489 22,664 27,006 20,000
Total Operating Revenue 3,329,856 3,058,648 3,081,808 3,841,987 3,572,500
TRANSFERS IN/CONTRIBUTIONS: - - - - -
TOTAL REVENUES AND TRANSFERS 3,329,856 3,058,648 3,081,808 3,841,987 3,572,500
OPERATING EXPENDITURES:
Personnel 1,337,802 1,394,369 1,485,633 1,501,717 1,551,359
Supplies 819,182 353,419 387,000 391,039 422,894
Maintenance 107,131 103,616 112,333 139,842 130,600
Services 333,792 361,315 395,135 434,616 457,302
Insurance 426,979 463,485 432,156 424,434 445,975
Capital Outlay 149,104 106,476 145,000 442,701 440,000
Total Operating Expenditures 3,173,990 2,782,680 2,957,257 3,334,349 3,448,130
TRANSFERS OUT:
Transfer to General Fund - Admin Fee 106,997 111,463 108,000 134,992 124,370
Total Transfers Out 106,997 111,463 108,000 134,992 124,370
TOTAL EXPENDITURES AND TRANSFERS 3,280,987 2,894,143 3,065,257 3,469,341 3,572,500
SURPLUS / (DEFICIT) 48,869 164,505 16,551 372,646 -
ENDING WORKING CAPITAL: (807,602) (643,097) (626,546) (270,451) (270,451)
* Fund balance requirement is 25% of total net budgeted expenses or 90 days of operation.
City Council has suspended the fund balance requirement for the Golf Fund for FY 2021-22.
221
