Page 215 - Grapevine FY23 Adopted Budget (1)

FY 2022-23 APPROVED OPERATING BUDGET
STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN NET POSITION
UTILITY ENTERPRISE FUND

2019-20 2020-21 2021-22 2021-22 2022-23
Actual Actual Budget Estimate Approved

BEGINNING UNRESTRICTED NET POSITION: 10,871,618 9,291,209 10,947,950 10,947,950 11,707,433
OPERATING REVENUE:
Water Sales 15,752,529 16,062,329 15,675,000 17,563,139 16,995,000
Wastewater Sales 7,735,969 8,391,822 8,000,000 8,650,364 8,895,000
Tap & Inspection Fees 2,543,467 2,537,656 85,000 2,439,485 2,555,000
Reconnects & Transfers 106,928 39,353 160,000 280,444 160,000
Interest Income 154,850 19,334 200,000 90,095 200,000
Miscellaneous Income 4,508,400 9,837,096 275,500 960,478 825,500
Total Operating Revenue 30,802,143 36,887,590 24,395,500 29,984,005 29,630,500
TRANSFERS IN/CONTRIBUTIONS: 1,740,977 4,261,235 - 670,738 661,919

TOTAL REVENUE AND TRANSFERS 32,543,120 41,148,825 24,395,500 30,654,743 30,292,419
OPERATING EXPENDITURES:
Personnel 3,787,024 3,606,570 4,007,053 3,671,345 4,179,063
Supplies 660,507 1,170,392 1,209,610 1,395,527 1,492,805
Maintenance 1,403,191 1,558,015 2,140,900 2,455,752 2,376,100
Services 15,264,220 15,868,434 14,285,362 17,946,107 18,292,296
Debt Service 1,106,203 - 3,000 671,262 664,919
Insurance 1,047,340 1,021,385 1,054,912 931,679 1,202,510
Capital Outlay 308,349 287,030 - 1,346,879 234,665
Total Expenditures 23,576,834 23,511,826 22,700,837 28,418,551 28,442,358

TRANSFERS OUT: 1,885,149 1,817,850 1,694,663 1,476,709 1,773,038
TOTAL EXPENDITURES AND TRANSFERS 25,461,983 25,329,676 24,395,500 29,895,260 30,215,396

SURPLUS / (DEFICIT) 7,081,137 15,819,149 - 759,483 77,023
ENDING UNRESTRICTED NET POSITION: 9,291,209 10,947,950 10,947,950 11,707,433 11,784,456

WORKING CAPITAL REQUIREMENT: 3,772,293 3,761,892 3,632,134 4,546,968 4,550,777
* Working capital requirement is 16% of total net budgeted expenditures or 60 days of operation.
The FY 2022-23 projected Ending Working Capital Balance represents 151 days of operation.

215