Page 69 - Grapevine Budget FY21

FY 2020-21 APPROVED OPERATING BUDGET
STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCE
GENERAL FUND

2017-18 2018-19 2019-20 2019-20 2020-21
Actual Actual Budget Estimate Approved

BEGINNING FUND BALANCE: 11,452,240 12,851,591 12,185,859 12,185,859 3,571,054
OPERATING REVENUE:
Ad Valorem Taxes 11,332,790 11,765,848 13,043,001 12,734,252 13,494,517
Sales Taxes 28,286,627 29,863,646 29,616,580 25,758,869 24,581,761
Mixed Beverage Taxes 1,792,674 2,145,940 2,057,000 1,477,422 1,899,934
Franchise Fees 6,893,151 6,435,472 6,906,950 6,149,238 6,906,950
Licenses & Permits 1,631,113 1,987,404 1,924,422 1,381,485 1,617,296
Charges for Services 12,535,663 8,607,063 9,134,928 7,108,771 9,068,428
Intergovernmental 321,081 384,454 697,687 327,650 344,094
Fines and Forfeitures 1,584,241 1,542,241 1,728,702 1,026,561 1,377,500
Miscellaneous 3,486,795 2,253,113 1,409,000 1,554,679 999,934
Total Operating Revenue 67,864,135 64,985,182 66,518,270 57,518,927 60,290,414
TRANSFERS IN:
Admin. Fee - Utility Fund 1,919,146 1,743,710 1,865,000 1,713,598 1,817,850
Admin. Fee - CVB Fund 1,347,770 1,498,333 1,455,526 855,718 1,213,537
Admin. Fee - Golf Fund 107,254 106,997 108,000 111,463 108,000
Administrative Fee - SDUS Fund 109,407 112,059 112,000 108,464 108,750
Administrative Fee - Lake Parks Fund 163,088 107,023 689,893 110,113 689,893
Administrative Fee - 4B Fund 326,478 339,626 306,000 297,626 291,204
Transfers In-Housing Authority 109,035 - - - -
Total Transfers In 4,082,178 3,907,797 4,536,419 3,196,982 4,229,234
TOTAL REVENUE AND TRANSFERS 71,946,314 68,892,979 71,054,689 60,715,909 64,519,648
OPERATING EXPENDITURES:
Personnel 32,014,323 33,462,248 34,466,915 34,803,509 34,239,023
Supplies 3,325,681 3,253,195 3,350,597 3,012,467 3,285,739
Maintenance 1,082,247 1,142,288 1,452,632 1,228,508 1,481,235
Services 11,673,960 13,124,614 12,271,761 13,373,652 11,574,422
Debt Service 138,071 122,768 - - -
Capital Outlay 109,711 264,387 105,000 730,116 115,000
Insurance 12,125,820 6,712,060 8,891,956 8,666,634 8,460,337
Total Operating Expenditures 60,469,813 58,081,560 60,538,861 61,814,886 59,155,756
TRANSFERS OUT:
To Permanent Capital Maintenance 2,645,000 3,020,000 3,279,000 3,279,000 -
To Capital Equipment Acquisition Fund - 3,200,000 830,004 830,004 -
To Community Quality of Life Fund 3,000,000 3,000,000 3,000,000 - -
To Crime Control & Prevention District Fund 2,235,000 3,056,630 3,406,824 3,406,824 5,363,892
To Grants Fund 574,200 - - - -
Total Transfers Out 8,454,200 12,276,630 10,515,828 7,515,828 5,363,892
TOTAL EXPENDITURES AND TRANSFERS 68,924,013 70,358,190 71,054,689 69,330,714 64,519,648

SURPLUS (DEFICIT) 3,022,301 (1,465,211) - (8,614,805) -
ENDING FUND BALANCE: 12,851,591 12,185,859 12,185,859 3,571,054 3,571,054
FUND BALANCE REQUIREMENT: 10,501,860 10,770,099 11,372,574 11,592,781 11,831,151
* Fund balance requirement is 20% of total budgeted expenditures (72 days of operation).
The FY 2020-21 projected Ending Fund Balance represents 23% of total budgeted expenditures (72 days of operation).

61