Page 59 - City of Mansfield FY22 Operarting Budget

Utility Fund Strategic Plan Summary

2027
2028
2030
2031
2029
Utility Fund Projected Projected Projected Projected Projected
REVENUE DESCRIPTION:
Water Sales $ 21,158,519 $ 21,793,274 $ 22,447,072 $ 23,120,484 $ 23,814,099
Sewer Sales 17,255,116 18,117,872 19,023,766 19,974,954 20,973,702
Wholesale 2,876,638 2,905,404 2,934,458 2,963,803 2,993,441
Other fees 1,737,381 1,754,754 1,772,302 1,790,025 1,807,925
Impact Fees 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000
Interest Income 24,000 24,000 24,000 24,000 24,000
TOTAL REVENUE: $ 44,551,653 $ 46,095,305 $ 47,701,598 $ 49,373,266 $ 51,113,167

EXPENSE DESCRIPTION:
Administration: 1,780,116 1,869,122 1,962,578 2,060,707 2,163,743
Billing and Collection: 1,215,439 1,276,211 1,340,022 1,407,023 1,477,374
Meter Reading and Repair: 1,552,978 1,630,627 1,712,158 1,797,766 1,887,655
Water & Distribution: 1,356,511 1,424,336 1,495,553 1,570,331 1,648,847
Waste Water Collection: 11,806,979 12,397,328 13,017,194 13,668,054 14,351,457
Water Quality Control: 13,518,277 14,194,191 14,903,901 15,649,096 16,431,551
Other 5,855,523 6,148,299 6,455,714 6,778,499 7,117,424
TOTAL OPERATING EXP: 37,085,823 38,940,115 40,887,120 42,931,476 45,078,050
OPERATING REVENUE: 7,465,830 7,155,190 6,814,478 6,441,790 6,035,116

OTHER EXPENSES:
Transfers 3,214,393 3,375,113 3,543,868 3,721,062 3,907,115
Debt Service 3,606,700 3,215,500 3,207,100 1,208,100 468,800
TOTAL OTHER OPERATING: 6,821,093 6,590,613 6,750,968 4,929,162 4,375,915
NET OPERATING ACTIVITY: $ 644,737 $ 564,577 $ 63,509 $ 1,512,628 $ 1,659,202
COVERAGE FACTOR:
Annual Debt Service 1.18 1.18 1.02 2.25 4.54
Maximum Annual Require 2.07 1.98 2.12 2.01 5.00
Average Annual Require 4.34 4.74 5.46 6.66 10.17

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.

59