Page 62 - CityofMansfieldFY23Budget

Utility Fund Strategic Plan Summary

2031
2028
2029
2030
2032
Utility Fund Projected Projected Projected Projected Projected
REVENUE DESCRIPTION:
Water Sales 22,083,206 22,353,194 22,628,582 22,909,477 23,195,990
Wastewater Sales 16,365,524 16,664,860 16,969,902 17,280,762 17,597,554
Wholesale Revenue 8,041,891 7,687,841 9,112,058 7,056,650 7,415,484
Other Revenues 912,873 912,873 912,873 912,873 912,873
TOTAL REVENUE: $ 47,403,494 $ 47,618,768 $ 49,623,415 $ 48,159,763 $ 49,121,902

EXPENSE DESCRIPTION:
Administration 1,721,415 1,771,665 1,823,387 1,876,624 1,931,421
Billing and Collections 1,123,108 1,155,485 1,188,799 1,223,078 1,258,350
Meter Reading and Repair 1,317,519 1,354,625 1,392,782 1,432,020 1,472,369
Water Distribution 1,165,918 1,199,919 1,234,920 1,270,949 1,308,036
Wastewater Collection 13,447,897 14,292,610 15,458,496 16,733,164 18,124,400
Water Treament 15,659,673 16,482,112 17,407,018 18,383,133 19,421,071
Water Quality 717,753 738,939 760,750 783,207 806,329
Other/Non-Departmental 1,098,903 1,124,217 1,150,278 1,177,109 1,204,732
TOTAL OPERATING EXP: 36,252,185 38,119,572 40,416,431 42,879,284 45,526,708

OPERATING REVENUE: 11,151,309 9,499,196 9,206,983 5,280,479 3,595,194
OTHER EXPENSES:
Transfer to General Fund 2,295,947 2,295,947 2,295,947 2,295,947 2,295,947
Cash Capital Outlays 721,405 740,096 759,273 778,949 799,137
Debt Service 3,215,500 3,207,100 1,208,100 468,800 468,400
Surrogate Debt Service 73,827 73,827 73,827 73,827 73,827
Debt Service Reserve 2,632,730 2,865,460 2,465,711 2,468,178 2,549,383
TOTAL OTHER OPERATING: 8,939,409 9,182,431 6,802,859 6,085,702 6,186,694

NET OPERATING ACTIVITY: $ 2,211,901 $ 316,765 $ 2,404,125 $ (805,223) $ (2,591,500)
COVERAGE FACTOR:
Annual Debt Service 2.75 2.25 5.72 6.37 2.77
Maximum Annual Requirement 3.47 2.96 7.62 11.18 7.61

For illustration purposes the plan has been prepared to allow for modest rate adjustments
throughout the decade. Without rate increases, the model suggests fiscal stress will be
encountered during this period unless revenue or expenses are adjusted. The Average
Annual Requirement is the leading indicator of potential fiscal stress. Although
increasing, coverage factors remain constant and suggest a good bill of fiscal health in the
Water and Sewer Fund. Rates during this period may or may not be adjusted depending
upon the factors affecting the economic variables assumed in this model.

61