|
Fiscal Year 2021 12/31/2018
<br />ACTUAL ACTUAL ACTUAL ACTUAL BUDGET EST. ACTUAL BUDGET % Change
<br />EXHIBIT B
<br />2016 2017 2018 2019 2020 2020 2021 in Budget
<br />OPERATING INCOME
<br />701-3720-0-0-00 SEWER BILLINGS 1,005,329$ 1,098,938$ 1,136,667$ 1,212,400$ 1,249,355$ 1,221,468$ 1,270,083$ 3.29% Includes the 2021 phase in of flat rate increase
<br />TOTAL 1,005,329$ 1,098,938$ 1,136,667$ 1,212,400$ 1,249,355$ 1,221,468$ 1,270,083$
<br />OPERATING EXPENDITURES
<br />701-4110-75-0000 SS REGULAR EMPLOYEE 203,152$ 218,382$ 219,484$ 226,547$ 227,425$ 230,028$ 236,114$ 3.82% INCLUDES ESTIMATED 2021 WAGE ADJUSTMENTS
<br />701-4111-75-0000 SS OVERTIME EMPLOYEE 15,398 18,028 23,832 24,129 25,098 21,854 25,600 2.00% FROM DEPT SUMMARIES OT
<br />701-4121-75-0000 SS PERA 15,730 16,431 17,096 17,473 18,939 18,177 19,629 3.64% BASED ON PERA FUNDING RATE 7.5%
<br />701-4122-75-0000 SS FICA/MEDICARE 15,791 16,437 16,197 17,375 19,318 18,541 20,021 3.64% BASED ON ER 7.65% OF GROSS
<br />701-4131-75-0000 SS INSURANCE HEALTH 42,862 41,725 42,222 44,277 42,919 43,905 48,358 12.67% SPLIT 9.4% PREMUIM INCREASE IN 2021
<br />701-4135-75-0000 SS INSURANCE WC 5,314 4,685 4,483 4,546 4,417 4,686 6,409 45.10% BASED ON 2020/2021 RENEWAL
<br />701-4211-75-0000 SS OFFICE SUPPLIES - - - 100 150 150 150 0.00% 2021 PROJECTED RUN RATE
<br />701-4212-75-0000 SS MOTOR FUELS 6,221 6,825 8,945 8,607 8,860 7,960 9,798 10.59% 2021 PROJECTED RUN RATE
<br />701-4226-75-0000 SS GENERAL SUPPLIES 3,128 (120) 1,282 1,042 1,275 1,270 1,350 5.88% 2021 PROJECTED RUN RATE
<br />701-4300-75-0000 SS AUDITOR 5,880 6,785 7,443 7,476 7,601 7,076 8,072 6.20% BASED ON AUDITOR CONTRACT
<br />701-4309-75-0000 SS IT & SFTW SUPPORT 8,148 12,205 13,612 15,284 16,820 19,601 21,030 25.03% BASED ON CONTRACTED IT /SW SPREADSHEET
<br />701-4310-75-0000 SS MISC CONTRACTED SERVICES 331 273 1,704 2,501 3,350 3,386 3,642 8.72% BASED ON MISC CONTRACTED SERVICES SPREADSHEET
<br />701-4325-75-0000 SS COMMUNICATIONS 3,964 3,136 3,263 3,267 3,780 3,600 3,880 2.65% BASED ON COMMUNICATION SPREADSHEET
<br />701-4335-75-0000 SS BKUP RESTORATION COSTS - - 5,123 - 10,000 10,000 10,000 0.00% Assumes the cost of one full deductable
<br />701-4339-75-0000 SS EQUIP REPAIRS & MAINTENANCE 2,487 17,438 35,085 4,690 13,770 9,011 9,500 -31.01% 2021 PROJECTED RUN RATE
<br />701-4341-75-0000 SS TRAINING, CONF. & MTG. 934 205 - - 1,122 1,150 1,250 11.41% 2021 PROJECTED RUN RATE
<br />701-4341-75-0100 SS TUITION- CERTIFICATIONS - - 1,170 904 587 600 600 2.30% 2021 PROJECTED RUN RATE
<br />701-4342-75-0000 SS MEMBERSHIP & DUES - 238 1,131 - 950 1,182 1,250 31.58% 2021 PROJECTED RUN RATE
<br />701-4350-75-0000 SS PRINTING AND POSTAGE 1,681 4,303 2,476 3,488 3,250 3,672 4,400 35.38% 2021 PROJECTED RUN RATE
<br />701-4365-75-0000 SS INSURANCE PROPERTY/ LIABILITY 13,100 9,352 11,686 10,414 9,981 13,215 15,900 59.30% BASED ON 2020/2021 RENEWAL
<br />701-4375-75-0000 SS MCES WASTE TREATMENT CHARGE 576,237 643,390 708,567 733,670 712,664 712,664 719,437 0.95% MCES amount for 2020, 3.6% rate increase, lower flow volume
<br />701-4381-75-0000 SS ELECTRIC AND GAS UTILITIES 10,301 9,654 8,609 8,719 10,083 8,813 9,300 -7.77% 2021 PROJECTED RUN RATE
<br />TOTAL 930,659$ 1,029,372$ 1,133,409$ 1,134,511$ 1,142,359$ 1,140,540$ 1,175,690$ 2.92%
<br /> OPERATING INCOME (LOSS)74,670$ 69,566$ 3,258$ 77,889$ 106,996$ 80,928$ 94,393$
<br />OTHER (INCOME) / EXPENSE
<br />701-3723-0-0-00 SEWER CONNECTION FEES (7,650)$ (23,800)$ (22,100)$ (1,700)$ (34,000)$ (1,750)$ (34,000)$
<br />701-3891-0-0-00 SS MISCELLANEOUS INCOME (6,305) (12,559) (650) (650) (650) (650) (650)
<br />701-3910-0-0-00 SS SALE OF ASSETS (180) 0
<br />701-4499-75-0000 SS MISCELLANEOUS EXPENSE 90 170 100 100 100 100 100
<br />TOTAL (14,045)$ (36,189)$ (22,650)$ (2,250)$ (34,550)$ (2,300)$ (34,550)$
<br />NET INCOME (LOSS) BEFORE DEPRECIATION 88,715$ 105,754$ 25,908$ 80,139$ 141,546$ 83,228$ 128,943$
<br />SEWER OPERATIONS
|