|
EXHIBIT D
<br />Fiscal Year 2025
<br />ACTUAL ACTUAL ACTUAL ACTUAL BUDGET EST. ACTUAL BUDGET % Change
<br />12/31/2023
<br />2020 2021 2022 2023 2024 2024 2025 in Budget 14$
<br />OPERATING INCOME
<br />701-3720-0-0-00 SEWER BILLINGS 1,224,881$ 1,314,285$ 1,337,972$ 1,440,378$ 1,475,931$ 1,487,143$ 1,586,785$ 7.51%
<br />Assumes $2.00 increase in quarterly flat fee, 5.6% increase in usage rates which matches the rate
<br />increase for treatment costs paid to Met Council Enviormental services .
<br />TOTAL 1,224,881$ 1,314,285$ 1,337,972$ 1,440,378$ 1,475,931$ 1,487,143$ 1,586,785$ 7.51%
<br />OPERATING EXPENDITURES
<br />701-4110-75-0000 SS REGULAR EMPLOYEE 224,382$ 208,006$ 235,998$ 246,945$ 257,792$ 250,835$ 287,115$ 11.37% DATA FROM 2025 PR SUMMARY -INCLUDES SHARE OF SUSTAINANBILTY POSITION
<br />701-4111-75-0000 SS OVERTIME EMPLOYEE 16,980 16,552 15,187 14,672 7,288 17,954 19,031 161.13% BASED ON 2024 RUN RATE PLUS ESTIMATED 25 WAGE ADJUSTMENTS
<br />701-4121-75-0000 SS PERA 17,067 16,443 20,047 18,937 19,881 20,159 22,586 13.61% BASED ON PERA FUNDING RATE 7.5%
<br />701-4122-75-0000 SS FICA/MEDICARE 17,048 15,509 18,523 17,354 20,279 20,180 22,961 13.23% BASED ON 7.65% OF GROSS
<br />701-4131-75-0000 SS INSURANCE HEALTH 44,245 42,049 39,764 33,720 40,857 35,696 43,075 5.43% DATA FROM -2025 DEPT SUMM HI RATES PRELIMINARY ELECTIONS
<br />701-4135-75-0000 SS INSURANCE WC 4,727 5,994 5,156 5,282 7,054 5,574 5,808 -17.66% BASED ON 2024/2025 RENEWAL
<br />701-4211-75-0000 SS OFFICE SUPPLIES 934 - - - 150 125 150 0.00% 2025 PROJECTED RUN RATE
<br />701-4212-75-0000 SS MOTOR FUELS 7,250 7,022 9,623 10,797 12,849 7,803 11,858 -7.71% From 2025 Fuel Usage Spreadsheet
<br />701-4226-75-0000 SS GENERAL SUPPLIES 2,340 1,721 1,743 1,743 2,500 1,750 1,950 -22.00% 2025 PROJECTED RUN RATE
<br />701-4300-75-0000 SS AUDITOR 6,706 7,799 7,997 8,269 8,682 9,031 9,483 9.22% BASED ON 2024 COST PLUS 5%
<br />701-4303-75-0000 SEWER ENGINEER FEES - - 3,289 4,799 2,750 2,350 2,750 0.00% POS I & I Program assistance
<br />701-4309-75-0000 SS IT & SFTW SUPPORT 19,635 19,168 17,997 20,310 23,710 24,560 25,550 7.76% BASED on 2025 CONTRACTED SERVICES - CONSOLIDATE 4309 2025 TAB
<br />701-4310-75-0000 SS MISC CONTRACTED SERVICES 121 615 4,169 6,244 9,900 4,231 4,350 -56.06% BASED on 2025 CONTRACTED SERVICES - MCS 4310 2025 TAB
<br />701-4325-75-0000 SS COMMUNICATIONS 2,144 4,824 5,748 5,372 4,280 5,832 6,020 40.65% BASED on 2025 CONTRACTED SERVICES - COMMUNICATIONS 4325 2025 TAB
<br />701-4335-75-0000 SS BKUP RESTORATION COSTS 2,624 405 694 - 10,000 10,000 10,000 0.00% Assumes the cost of one full deductable
<br />701-4339-75-0000 SS EQUIP REPAIRS & MAINTENANCE 8,422 8,990 7,898 18,948 15,790 27,941 23,500 48.83% 2025 PROJECTED RUN RATE
<br />701-4341-75-0000 SS TRAINING, CONF. & MTG.780 780 225 - 300 300 300 0.00% 2025 PROJECTED RUN RATE
<br />701-4341-75-0100 SS TUITION- CERTIFICATIONS - 46 23 55 50 50 50 0.00% 2025 PROJECTED RUN RATE
<br />701-4342-75-0000 SS MEMBERSHIP & DUES 260 - - - - - - 2025 PROJECTED RUN RATE
<br />701-4350-75-0000 SS PRINTING AND POSTAGE 4,599 3,145 4,329 4,598 5,670 4,950 5,198 -8.33% 2025 PROJECTED RUN RATE
<br />701-4365-75-0000 SS INSURANCE PROPERTY/ LIABILITY 13,164 13,101 12,771 14,222 14,571 15,196 14,673 0.70% BASED ON 2024/2025 RENEWAL
<br />701-4375-75-0000 SS MCES WASTE TREATMENT CHARGE 712,664 719,437 711,020 760,026 822,704 822,704 949,408 15.40% 2025 MCES increase in volume plus 5.6% increase in rates
<br />701-4381-75-0000 SS ELECTRIC AND GAS UTILITIES 11,934 11,534 10,991 10,894 11,327 11,112 11,779 3.99% 2025 PROJECTED RUN RATE
<br />TOTAL 1,118,027$ 1,103,140$ 1,133,192$ 1,203,188$ 1,298,384$ 1,298,331$ 1,477,594$ 7.91%
<br /> OPERATING INCOME (LOSS)106,854$ 211,145$ 204,780$ 237,190$ 177,547$ 188,812$ 109,191$ 53.03%
<br />OTHER (INCOME) / EXPENSE
<br />701-3723-0-0-00 SEWER CONNECTION FEES (1,750)$ -$ -$ -$ -$ -$ -$ NA CONNECTION FEES PART OF CAPITAL BUDGET SINCE 2021
<br />701-3891-0-0-00 SS MISCELLANEOUS INCOME (650)(1,480)(500)(1,834)(500)(1,550)(500) -15.47%
<br />701-3910-0-0-00 SS SALE OF ASSETS - (600) - - - - - 0.00%
<br />701-4499-75-0000 SS MISCELLANEOUS EXPENSE 1,083 864 1,273 1,974 500 1,500 500 -23.99%
<br />TOTAL (1,317)$ (1,216)$ 773$ 140$ -$ (50)$ -$ -135.73%
<br />NET INCOME (LOSS) BEFORE DEPRECIATION 108,171$ 212,361$ 204,007$ 237,050$ 177,547$ 188,862$ 109,191$ -20.33%
<br />SEWER OPERATIONS
<br />27
|