Page 78 - Grapevine FY22 Adopted Budget v2
P. 78
FY 2021-22 APPROVED OPERATING BUDGET
STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCE
GENERAL FUND
2018-19 2019-20 2020-21 2020-21 2021-22
Actual Actual Budget Estimate Approved
BEGINNING FUND BALANCE: 12,851,591 12,185,859 9,547,363 9,547,363 14,262,582
OPERATING REVENUE:
Ad Valorem Taxes 11,765,848 12,740,172 13,494,517 13,552,956 14,135,767
Sales Taxes 29,863,646 25,758,869 24,581,761 28,590,889 29,147,580
Mixed Beverage Taxes 2,145,940 1,477,422 1,899,934 1,793,124 2,057,000
Franchise Fees 6,435,472 6,216,567 6,906,950 5,850,190 6,216,567
Licenses & Permits 1,987,404 1,385,370 1,617,296 1,470,951 1,624,796
Charges for Services 8,607,063 7,848,563 9,068,428 8,760,496 9,294,760
Intergovernmental 384,454 331,383 344,094 3,542,204 344,094
Fines and Forfeitures 1,542,241 1,026,561 1,377,500 968,204 1,178,550
Miscellaneous 2,253,113 1,680,104 999,934 1,293,564 1,066,800
Total Operating Revenue 64,985,182 58,465,011 60,290,414 65,822,578 65,065,914
TRANSFERS IN:
Admin. Fee - Utility Fund 1,743,710 1,866,000 1,817,850 1,755,683 1,694,663
Admin. Fee - CVB Fund 1,498,333 1,455,526 1,213,537 788,657 1,255,274
Admin. Fee - Golf Fund 106,997 111,463 108,000 134,992 124,370
Administrative Fee - SDUS Fund 112,059 112,000 108,750 108,386 107,775
Administrative Fee - Lake Parks Fund 107,023 689,893 689,893 - -
Administrative Fee - 4B Fund 339,626 306,000 291,204 353,046 281,509
Transfers in - Golf Fund - 3,100,000 - 134,992
Transfers In - Special Revenue Fund - 27,374 - 244,134 -
Transfers In - Economic Development Fund - 149,086 - 353,046
Transfers In-Housing Authority - 170,728 - - -
Total Transfers In 3,907,797 7,988,070 4,229,234 3,872,936 3,463,591
TOTAL REVENUE AND TRANSFERS 68,892,979 66,453,079 64,519,648 69,695,514 68,529,505
OPERATING EXPENDITURES:
Personnel 33,462,248 34,151,272 34,239,023 34,340,657 34,878,522
Supplies 3,253,195 2,997,950 3,285,739 2,967,955 3,269,131
Maintenance 1,142,288 1,228,508 1,481,235 1,452,959 1,569,428
Services 13,124,614 13,341,686 11,574,422 12,836,535 12,521,093
Capital Outlay 264,387 835,033 115,000 112,691 115,000
Insurance 6,712,060 9,021,298 8,460,337 7,898,750 9,603,341
Total Operating Expenditures 58,081,560 61,575,747 59,155,756 59,609,547 61,956,515
TRANSFERS OUT:
To Permanent Capital Maintenance 3,020,000 3,279,000 - - 1,640,000
To Capital Equipment Acquisition Fund 3,200,000 830,004 - -
To Community Quality of Life Fund 3,000,000 - - -
To Crime Control & Prevention District Fund 3,056,630 3,406,824 5,363,892 5,363,892 4,291,740
To Grants Fund - - - 6,856 -
Total Transfers Out 12,276,630 7,515,828 5,363,892 5,370,748 5,931,740
TOTAL EXPENDITURES AND TRANSFERS 70,358,190 69,091,575 64,519,648 64,980,295 67,888,255
SURPLUS (DEFICIT) (1,465,211) (2,638,497) - 4,715,219 641,250
ENDING FUND BALANCE: 12,185,859 9,547,363 9,547,363 14,262,582 14,903,832
FUND BALANCE REQUIREMENT: 10,770,099 12,315,149 11,831,151 11,921,909 12,391,303
* Fund balance requirement is 20% of total budgeted expenditures (72 days of operation).
The FY 2021-22 projected Ending Fund Balance represents 24% of total budgeted expenditures (87 days of operation).
78
