|
Fiscal Year 2022 12/31/2018 EXHIBIT C
<br />ACTUAL ACTUAL ACTUAL ACTUAL BUDGET Est. ACTUAL BUDGET % Change
<br />EXHIBIT D
<br />2017 2018 2019 2020 2021 2021 2022 in Budget
<br />OPERATING INCOME
<br />701-3720-0-0-00 SEWER BILLINGS 1,098,938$ 1,136,667$ 1,212,400$ 1,224,881$ 1,270,083$ 1,310,608$ 1,319,981$ 3.93% Includes the 2022 phase in of flat fee, no increase in usage rate
<br />TOTAL 1,098,938$ 1,136,667$ 1,212,400$ 1,224,881$ 1,270,083$ 1,310,608$ 1,319,981$ 3.93%
<br />OPERATING EXPENDITURES
<br />701-4110-75-0000 SS REGULAR EMPLOYEE 218,382$ 219,484$ 226,547$ 224,382$ 236,114$ 211,090$ 236,460$ 0.15% INCLUDES ESTIMATED 2022 WAGE ADJUSTMENT / STAFF TURN OVER
<br />701-4111-75-0000 SS OVERTIME EMPLOYEE 18,028 23,832 24,129 16,980 25,600 18,238 20,714 -19.09% FROM DEPT SUMMARIES OT
<br />701-4121-75-0000 SS PERA 16,431 17,096 17,473 17,067 19,629 17,200 19,288 -1.73% BASED ON PERA FUNDING RATE 7.5%
<br />701-4122-75-0000 SS FICA/MEDICARE 16,437 16,197 17,375 17,048 20,021 17,544 19,674 -1.73% BASED ON ER 7.65% OF GROSS
<br />701-4131-75-0000 SS INSURANCE HEALTH 41,725 42,222 44,277 44,245 48,433 44,890 45,725 -5.59% SPLIT 3.2% PREMUIM DECREASE IN 2022
<br />701-4135-75-0000 SS INSURANCE WC 4,685 4,483 4,546 4,727 6,598 6,141 6,520 -1.18% BASED ON 2021/2022 RENEWAL
<br />701-4211-75-0000 SS OFFICE SUPPLIES - - 100 934 150 150 150 0.00% 2022 PROJECTED RUN RATE
<br />701-4212-75-0000 SS MOTOR FUELS 6,825 8,945 8,607 7,250 9,798 7,178 9,063 -7.50% 2022 PROJECTED RUN RATE
<br />701-4226-75-0000 SS GENERAL SUPPLIES (120) 1,282 1,042 2,340 1,350 1,487 1,561 15.66% 2022 PROJECTED RUN RATE
<br />701-4300-75-0000 SS AUDITOR 6,785 7,443 7,476 6,706 8,072 7,800 8,250 2.21% BASED ON AUDITOR CONTRACT
<br />701-4309-75-0000 SS IT & SFTW SUPPORT 12,205 13,612 15,284 19,635 21,030 20,875 22,128 5.22% BASED ON CONTRACTED IT /SW SPREADSHEET
<br />701-4310-75-0000 SS MISC CONTRACTED SERVICES 273 1,704 2,501 121 3,642 3,017 9,900 171.83% 2022 Includes Invoice Cloud admin/CC fees
<br />701-4325-75-0000 SS COMMUNICATIONS 3,136 3,263 3,267 2,144 3,880 4,541 5,400 39.18% BASED ON COMMUNICATION SPREADSHEET
<br />701-4335-75-0000 SS BKUP RESTORATION COSTS - 5,123 - 2,624 10,000 500 10,000 0.00% Assumes the cost of one full deductable
<br />701-4339-75-0000 SS EQUIP REPAIRS & MAINTENANCE 17,438 35,085 4,690 8,422 9,500 8,128 9,500 0.00% 2022 PROJECTED RUN RATE
<br />701-4341-75-0000 SS TRAINING, CONF. & MTG. 205 - - 780 1,250 780 780 -37.60% 2022 PROJECTED RUN RATE
<br />701-4341-75-0100 SS TUITION- CERTIFICATIONS - 1,170 904 - 600 390 390 -35.00% 2022 PROJECTED RUN RATE
<br />701-4342-75-0000 SS MEMBERSHIP & DUES 238 1,131 - 260 1,250 260 520 -58.40% 2022 PROJECTED RUN RATE
<br />701-4350-75-0000 SS PRINTING AND POSTAGE 4,303 2,476 3,488 4,599 4,400 4,000 4,200 -4.55% 2022 PROJECTED RUN RATE
<br />701-4365-75-0000 SS INSURANCE PROPERTY/ LIABILITY 9,352 11,686 10,414 13,164 15,900 13,100 12,155 -23.55% BASED ON 2021/2022 RENEWAL
<br />701-4375-75-0000 SS MCES WASTE TREATMENT CHARGE 643,390 708,567 733,670 712,664 719,437 719,437 711,023 -1.17% 2022 MCES 4.0% rate increase, lower share of flow volume
<br />701-4381-75-0000 SS ELECTRIC AND GAS UTILITIES 9,654 8,609 8,719 11,934 9,300 10,469 11,097 19.32% 2022 PROJECTED RUN RATE
<br />TOTAL 1,029,372$ 1,133,409$ 1,134,511$ 1,118,027$ 1,175,954$ 1,117,214$ 1,164,498$ -0.97%
<br /> OPERATING INCOME (LOSS)69,566$ 3,258$ 77,889$ 106,854$ 94,129$ 193,394$ 155,483$ 65.18%
<br />OTHER (INCOME) / EXPENSE
<br />701-3723-0-0-00 SEWER CONNECTION FEES (23,800)$ (22,100)$ (1,700)$ (1,750)$ (34,000)$ -$ -$ -100.00%
<br />701-3891-0-0-00 SS MISCELLANEOUS INCOME (12,559) (650) (650) (650) (650)$ (50) (100) -84.62%
<br />701-3910-0-0-00 SS SALE OF ASSETS - - - - - - - 0.00%
<br />701-4499-75-0000 SS MISCELLANEOUS EXPENSE 170 100 100 1,083 100$ 802 500 400.00%
<br />TOTAL (36,189)$ (22,650)$ (2,250)$ (1,317)$ (34,550)$ 752$ 400$ -101.16%
<br />NET INCOME (LOSS) BEFORE DEPRECIATION 105,754$ 25,908$ 80,139$ 108,171$ 128,679$ 192,642$ 155,083$ 20.52%
<br />SEWER OPERATIONS
|