Page 209 - Grapevine FY22 Adopted Budget v2

FY 2021-22 APPROVED OPERATING BUDGET
STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALAN
UTILITY ENTERPRISE FUND

2018-19 2019-20 2020-21 2020-21 2021-22
Actual Actual Budget Estimate Approved

BEGINNING UNRESTRICTED FUND BALANCE: 16,629,044 16,564,012 23,645,149 23,645,149 27,122,289
OPERATING REVENUE:

Water Sales 14,607,637 15,752,529 15,650,000 16,026,329 15,675,000

Wastewater Sales 8,033,819 7,735,969 8,000,000 8,391,822 8,000,000

Tap & Inspection Fees 151,124 2,543,467 85,000 2,537,656 85,000

Reconnects & Transfers 196,299 106,928 203,000 39,353 160,000

Interest Income 307,081 154,850 300,000 20,382 200,000

Miscellaneous Income 6,935,920 4,508,400 200,000 1,713,442 275,500
Total Operating Revenue 30,231,881 30,802,143 24,438,000 28,728,984 24,395,500
TRANSFERS IN/CONTRIBUTIONS: 556,794 1,740,977 - - -
TOTAL REVENUE AND TRANSFERS 30,788,674 32,543,120 24,438,000 28,728,984 24,395,500

OPERATING EXPENDITURES:
Personnel 3,609,966 3,787,024 3,892,334 3,606,570 4,007,053

Supplies 699,016 660,507 1,184,760 1,149,619 1,209,610

Maintenance 920,689 1,403,191 1,525,900 1,540,992 2,140,900

Services 11,543,196 15,264,220 13,266,549 15,890,121 14,285,362
Debt Service 1,534,798 1,106,203 1,122,619 444 3,000

Insurance 920,619 1,047,340 1,027,743 1,021,385 1,054,912
Capital Outlay 544,005 308,349 330,000 287,030 -

Total Expenditures 19,772,289 23,576,834 22,349,905 23,496,161 22,700,837

TRANSFERS OUT: 6,843,710 1,885,149 1,817,850 1,755,683 1,694,663

TOTAL EXPENDITURES AND TRANSFERS 26,615,999 25,461,983 24,167,755 25,251,844 24,395,500

SURPLUS / (DEFICIT) 4,172,675 7,081,137 270,245 3,477,140 -

ENDING UNRESTRICTED WORKING CAPITAL: 14,139,853 23,645,149 23,915,394 27,122,289 27,122,289

WORKING CAPITAL REQUIREMENT: 3,163,566 3,772,293 3,575,985 3,759,386 3,632,134

* Working capitalrequirement is 16% of total net budgeted expenditures or 60 days of operation.
The FY 2021-22 projected Ending Working Capital Balance represents 436 days of operation.
209