|
EXHIBIT D
<br />Fiscal Year 2023 12/31/2018 EXHIBIT C
<br />ACTUAL ACTUAL ACTUAL ACTUAL BUDGET EST. ACTUAL BUDGET % Change
<br />2018 2019 2020 2021 2022 2022 2023 in Budget
<br />OPERATING INCOME
<br />701-3720-0-0-00 SEWER BILLINGS 1,136,667$ 1,212,400$ 1,224,881$ 1,314,285$ 1,319,981$ 1,347,580$ 1,423,818$ 7.87%
<br />Assumes $2.05 increase in quarterly flat fee, 2.0% increase in usage rates and a
<br />2% increase in 1st Quarter usage.
<br />TOTAL 1,136,667$ 1,212,400$ 1,224,881$ 1,314,285$ 1,319,981$ 1,347,580$ 1,423,818$ 7.87%
<br />OPERATING EXPENDITURES
<br />701-4110-75-0000 SS REGULAR EMPLOYEE 219,484$ 226,547$ 224,382$ 208,006$ 237,546$ 236,365$ 247,229$ 4.08% INCLUDES ESTIMATED 2023 WAGE ADJUSTMENT / STAFF TURN OVER
<br />701-4111-75-0000 SS OVERTIME EMPLOYEE 23,832 24,129 16,980 16,552 20,714 19,500 14,400 -30.48% FROM DEPT SUMMARIES OT
<br />701-4121-75-0000 SS PERA 17,096 17,473 17,067 16,443 19,369 19,190 19,622 1.30% BASED ON PERA FUNDING RATE 7.5%
<br />701-4122-75-0000 SS FICA/MEDICARE 16,197 17,375 17,048 15,509 19,757 19,574 20,015 1.30% BASED ON ER 7.65% OF GROSS
<br />701-4131-75-0000 SS INSURANCE HEALTH 42,222 44,277 44,245 42,049 45,018 39,242 47,501 5.52% SPLIT 10.85% PREMUIM INCREASE 2023/STAFF ELECTIONS
<br />701-4135-75-0000 SS INSURANCE WC 4,483 4,546 4,727 5,994 5,980 5,156 4,985 -16.64% BASED ON 2023/2023 RENEWAL
<br />701-4211-75-0000 SS OFFICE SUPPLIES - 100 934 - 150 150 150 0.00% 2023 PROJECTED RUN RATE
<br />701-4212-75-0000 SS MOTOR FUELS 8,945 8,607 7,250 7,022 9,063 10,094 13,704 51.21% 2023 PROJECTED RUN RATE
<br />701-4226-75-0000 SS GENERAL SUPPLIES 1,282 1,042 2,340 1,721 1,561 2,042 2,500 60.12% 2023 PROJECTED RUN RATE
<br />701-4300-75-0000 SS AUDITOR 7,443 7,476 6,706 7,799 8,250 7,996 8,268 0.22% BASED ON AUDITOR CONTRACT
<br />701-4309-75-0000 SS IT & SFTW SUPPORT 13,612 15,284 19,635 19,168 20,506 20,220 22,990 12.11% BASED ON CONTRACTED IT /SW SPREADSHEET
<br />701-4310-75-0000 SS MISC CONTRACTED SERVICES 1,704 2,501 121 615 9,900 3,138 3,500 -64.65% 2023 Includes Invoice Cloud admin/CC fees
<br />701-4325-75-0000 SS COMMUNICATIONS 3,263 3,267 2,144 4,824 5,400 4,980 5,378 -0.40% BASED ON COMMUNICATION SPREADSHEET
<br />701-4335-75-0000 SS BKUP RESTORATION COSTS 5,123 - 2,624 405 10,000 10,000 10,000 0.00% Assumes the cost of one full deductable
<br />701-4339-75-0000 SS EQUIP REPAIRS & MAINTENANCE 35,085 4,690 8,422 8,990 9,750 4,314 9,250 -5.13% 2023 PROJECTED RUN RATE
<br />701-4341-75-0000 SS TRAINING, CONF. & MTG. - - 780 780 780 780 800 2.56% 2023 PROJECTED RUN RATE
<br />701-4341-75-0100 SS TUITION- CERTIFICATIONS 1,170 904 - 46 390 100 50 -87.18% 2023 PROJECTED RUN RATE
<br />701-4342-75-0000 SS MEMBERSHIP & DUES 1,131 - 260 - 520 - - -100.00% 2023 PROJECTED RUN RATE
<br />701-4350-75-0000 SS PRINTING AND POSTAGE 2,476 3,488 4,599 3,145 4,200 3,706 4,200 0.00% 2023 PROJECTED RUN RATE
<br />701-4365-75-0000 SS INSURANCE PROPERTY/ LIABILITY 11,686 10,414 13,164 13,101 12,155 12,770 14,450 18.88% BASED ON 2022/2023 RENEWAL
<br />701-4375-75-0000 SS MCES WASTE TREATMENT CHARGE 708,567 733,670 712,664 719,437 711,023 711,020 760,026 6.89% 2023 MCES 6.89% rate increase, share of flow volume - flat
<br />701-4381-75-0000 SS ELECTRIC AND GAS UTILITIES 8,609 8,719 11,934 11,534 12,950 9,781 12,256 -5.36% 2023 PROJECTED RUN RATE
<br />TOTAL 1,133,409$ 1,134,511$ 1,118,027$ 1,103,140$ 1,164,982$ 1,140,118$ 1,221,274$ 4.83%
<br /> OPERATING INCOME (LOSS)3,258$ 77,889$ 106,854$ 211,145$ 154,998$ 207,462$ 202,543$ 30.67%
<br />OTHER (INCOME) / EXPENSE
<br />701-3723-0-0-00 SEWER CONNECTION FEES (22,100)$ (1,700)$ (1,750)$ -$ -$ -$ -$ 0.00%
<br />701-3891-0-0-00 SS MISCELLANEOUS INCOME (650) (650) (650) (1,480) (100) (500) (500) 400.00%
<br />701-3910-0-0-00 SS SALE OF ASSETS - - - (600) - - - 0.00%
<br />701-4499-75-0000 SS MISCELLANEOUS EXPENSE 100 100 1,083 864 500 850 950 90.00%
<br />TOTAL (22,650)$ (2,250)$ (1,317)$ (1,216)$ 400$ 350$ 450$ 12.50%
<br />NET INCOME (LOSS) BEFORE DEPRECIATION 25,908$ 80,139$ 108,171$ 212,361$ 154,598$ 207,112$ 202,093$ 30.72%
<br />SEWER OPERATIONS
|