|
EXHIBIT C
<br />Fiscal Year 2022
<br /> ACTUAL ACTUAL ACTUAL BUDGET EST. ACTUAL BUDGET
<br />2018 2019 2020 2021 2021 2022 PW Usage %Fixed %AD Usage %Fixed %TOTAL
<br />COLLECTION SYSTEM EXPENSES
<br />701-4110-75-0000 SS REGULAR EMPLOYEE 219,484$ 226,547$ 224,382$ 236,114$ 211,090$ 236,460$ 115,135 34,541 30%80,595 70%121,325 6,066 5%115,259 80%236,460
<br />701-4111-75-0000 SS OVERTIME EMPLOYEE 23,832 24,129 16,980 25,600$ 18,238 20,714 10,086 3,026 30%7,060 70%10,628 531 5%10,097 95%20,714
<br />701-4121-75-0000 SS PERA 17,096 17,473 17,067 19,629$ 17,200 19,288 9,392 2,817 30%6,574 70%9,896 495 5%9,402 95%19,288
<br />701-4122-75-0000 SS FICA/MEDICARE 16,197 17,375 17,048 20,021$ 17,544 19,674 9,579 2,874 30%6,706 70%10,094 505 5%9,590 95%19,674
<br />701-4131-75-0000 SS INSURANCE HEALTH 42,222 44,277 44,245 48,433$ 44,890 45,725 27,242 8,173 30%19,069 70%18,483 924 5%17,559 95%45,725
<br />701-4135-75-0000 SS INSURANCE WC 4,483 4,546 4,727 6,598$ 6,141 6,520 6,520 1,956 30%4,564 70%- - - - - 6,520
<br />701-4211-75-0000 SS OFFICE SUPPLIES - 100 934 150$ 150 150 - - - - - 150 8 5%143 95%150
<br />701-4212-75-0000 SS MOTOR FUELS 8,945 8,607 7,250 9,798$ 7,178 9,063 9,063 2,719 30%6,344 70%- - - - - 9,063
<br />701-4226-75-0000 SS GENERAL SUPPLIES 1,282 1,042 2,340 1,350$ 1,487 1,561 1,561 468 30%1,093 70%- - - - - 1,561
<br />701-4300-75-0000 SS AUDITOR 7,443 7,476 6,706 8,072$ 7,800 8,250 8,250 - 0%8,250 100%- - - - - 8,250
<br />701-4309-75-0000 SS IT & SFTW SUPPORT 13,612 15,284 19,635 21,030$ 20,875 22,128 2,928 2,928 100%- - 19,200 960 5%18,240 95%22,128
<br />701-4310-75-0000 SS MISC CONTRACTED SERVICES 1,704 2,501 121 3,642$ 3,017 9,900 9,900 - 0%9,900 100%- - - - - 9,900
<br />701-4325-75-0000 SS COMMUNICATIONS 3,263 3,267 2,144 3,880$ 4,541 5,400 5,400 - 0%5,400 100%- - - - - 5,400
<br />701-4335-75-0000 SS BKUP RESTORATION COSTS 5,123 - 2,624 10,000$ 500 10,000 10,000 3,000 30%7,000 70%- - - - - 10,000
<br />701-4339-75-0000 SS EQUIP REPAIRS & MAINTENANCE 35,085 4,690 8,422 9,500$ 8,128 9,500 9,500 7,613 80%1,887 20%- - - - - 9,500
<br />701-4341-75-0000 SS TRAINING, CONF. & MTG. - - 780 1,250$ 780 780 780 624 80%156 20%- - - - - 780
<br />701-4342-75-0000 SS MEMBERSHIPS & DUES 1,131 904 - 600$ 390 390 390 312 80%78 20%390
<br />701-4341-75-0100 SS TUITION- CERTIFICATIONS 1,170 - 260 1,250$ 260 520 520 416 80%104 20%- - - - - 520
<br />701-4350-75-0000 SS PRINTING AND PUBLISHING 2,476 3,488 4,599 4,400$ 4,000 4,200 4,200 - 0%4,200 100%- - - - - 4,200
<br />701-4365-75-0000 SS INSURANCE PROPERTY/ LIABILITY 11,686 10,414 13,164 15,900$ 13,100 12,155 12,155 - 0%12,155 100%- - - - - 12,155
<br />TOTAL COLLECTION SYSTEM 416,233$ 392,122$ 393,430$ 447,217$ 387,308$ 442,377$ 252,601$ 71,466$ 28%181,135$ 72%189,776$ 9,489$ 5%180,288$ 95%442,377
<br />252,601$
<br />TREATMENT EXPENSES
<br />701-4375-75-0000 SS MCES WASTE TREATMENT CHARGE 708,567 733,670 712,664 719,437 719,437$ 711,023 711,023 639,921 90%71,102 10%711,023
<br />701-4381-75-0000 SS ELECTRIC AND GAS UTILITIES 8,609 8,719 11,934 9,300 10,469$ 11,097 11,097 10,542 95%555 5%11,097
<br />TOTAL TREATMENT 717,176 742,389 724,598 728,737 729,906 722,120 722,120 650,463 90%71,657 17%- - - - 722,120
<br />TOTAL OPERATING EXPENSES 1,133,409 1,134,511 1,118,027 1,175,954 1,117,214 1,164,498 974,721 721,929 74%252,792 26%189,776 9,489 5%180,288 95%1,164,498
<br />DEPRECIATION EXPENSE
<br />701-4499-80-0000 WT DEPRECIATION MAINTENANCE EQUIP 28,909 31,909 33,409 36,409 36,409 37,319 37,319 11,196 30%26,123 70%37,319
<br />WT DEPRECIATION LINES AND LIFT STATIONS 67,453 74,453 77,953 84,953 84,953 87,077 87,077 26,123 30%60,954 70%87,077
<br />TOTAL DEPRECIATION 96,362 106,362 111,362 121,362 121,362 124,396 124,396 37,319 30%87,077 70%- - - - 124,396
<br />TOTAL OVERALL EXPENSES 1,229,771 1,240,873 1,229,389 1,297,316 1,238,576 1,288,894 1,099,117 759,248 69%339,869 31%189,776 9,489 5%180,288 95%1,288,894
<br />FIXED 433,079 37%87,078 70%520,157 40%
<br />USAGE 731,419 63%37,318 30%768,737 60%
<br />1,164,498 100%124,396 100%1,288,894 100%
<br />SEWER EXPENSES
<br />PW ADMINISTRATIVE COSTS
<br />NO ADMINISTRATIVE COSTS
<br />NO ADMINISTRATIVE COSTS
<br /> OPERATING DEPRECIATION OVERALL
|