|
EXHIBIT C
<br />Fiscal Year 2023
<br /> ACTUAL ACTUAL ACTUAL ACTUAL EST. ACTUAL BUDGET
<br />2018 2019 2020 2021 2022 2023 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$ 208,006$ 236,365$ 247,229$ 125,904 37,771 30%88,133 70%121,325 6,066 5%115,259 80%247,229
<br />701-4111-75-0000 SS OVERTIME EMPLOYEE 23,832 24,129 16,980 16,552 19,500 14,400 7,333 2,200 30%5,133 70%7,067 353 5%6,713 95%14,400
<br />701-4121-75-0000 SS PERA 17,096 17,473 17,067 16,443 19,190 19,622 9,993 2,998 30%6,995 70%9,629 481 5%9,148 95%19,622
<br />701-4122-75-0000 SS FICA/MEDICARE 16,197 17,375 17,048 15,509 19,574 20,015 10,193 3,058 30%7,135 70%9,822 491 5%9,331 95%20,015
<br />701-4131-75-0000 SS INSURANCE HEALTH 42,222 44,277 44,245 42,049 39,242 47,501 30,302 9,091 30%21,211 70%17,199 860 5%16,339 95%47,501
<br />701-4135-75-0000 SS INSURANCE WC 4,483 4,546 4,727 5,994 5,156 4,985 4,985 1,496 30%3,490 70%- - - - - 4,985
<br />701-4211-75-0000 SS OFFICE SUPPLIES - 100 934 150 150 - - - - - 150 8 5%143 95%150
<br />701-4212-75-0000 SS MOTOR FUELS 8,945 8,607 7,250 7,022 10,094 13,704 13,704 4,111 30%9,593 70%- - - - - 13,704
<br />701-4226-75-0000 SS GENERAL SUPPLIES 1,282 1,042 2,340 1,721 2,042 2,500 2,500 750 30%1,750 70%- - - - - 2,500
<br />701-4300-75-0000 SS AUDITOR 7,443 7,476 6,706 7,799 7,996 8,268 8,268 - 0%8,268 100%- - - - - 8,268
<br />701-4309-75-0000 SS IT & SFTW SUPPORT 13,612 15,284 19,635 19,168 20,220 22,990 2,928 2,928 100%- - 20,062 1,003 5%19,059 95%22,990
<br />701-4310-75-0000 SS MISC CONTRACTED SERVICES 1,704 2,501 121 615 3,138 3,500 3,500 - 0%3,500 100%- - - - - 3,500
<br />701-4325-75-0000 SS COMMUNICATIONS 3,263 3,267 2,144 4,824 4,980 5,378 5,378 - 0%5,378 100%- - - - - 5,378
<br />701-4335-75-0000 SS BKUP RESTORATION COSTS 5,123 - 2,624 405 10,000 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 8,990 4,314 9,250 9,250 7,613 82%1,637 18%- - - - - 9,250
<br />701-4341-75-0000 SS TRAINING, CONF. & MTG. - - 780 780 780 800 800 640 80%160 20%- - - - - 800
<br />701-4342-75-0000 SS MEMBERSHIPS & DUES 1,131 904 - - - - - - 0%- 0%-
<br />701-4341-75-0100 SS TUITION- CERTIFICATIONS 1,170 - 260 46 100 50 50 40 80%10 20%- - - - - 50
<br />701-4350-75-0000 SS PRINTING AND PUBLISHING 2,476 3,488 4,599 3,145 3,706 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 13,101 12,770 14,450 14,450 - 0%14,450 100%- - - - - 14,450
<br />TOTAL COLLECTION SYSTEM 416,233$ 392,122$ 393,430$ 372,169$ 419,317$ 448,992$ 263,738$ 75,695$ 29%188,043$ 71%185,254$ 9,263$ 5%175,991$ 95%448,992
<br />263,738$
<br />TREATMENT EXPENSES
<br />701-4375-75-0000 SS MCES WASTE TREATMENT CHARGE 708,567 733,670 712,664 719,437 711,020$ 760,026 760,026 684,023 90%76,003 10%760,026
<br />701-4381-75-0000 SS ELECTRIC AND GAS UTILITIES 8,609 8,719 11,934 11,534 9,781$ 12,256 12,256 11,643 95%613 5%12,256
<br />TOTAL TREATMENT 717,176 742,389 724,598 730,971 720,801 772,282 772,282 695,667 90%76,615 17%- - - - 772,282
<br />TOTAL OPERATING EXPENSES 1,133,409 1,134,511 1,118,027 1,103,140 1,140,118 1,221,274 1,036,020 771,362 74%264,659 26%185,254 9,263 5%175,991 95%1,221,274
<br />DEPRECIATION EXPENSE
<br />701-4499-80-0000 WT DEPRECIATION MAINTENANCE EQUIP 28,909 31,909 33,409 36,409 36,409 36,409 36,409 10,923 30%25,486 70%36,409
<br />WT DEPRECIATION LINES AND LIFT STATIONS 67,453 74,453 77,953 113,714 121,314 131,314 131,314 39,394 30%91,920 70%131,314
<br />TOTAL DEPRECIATION 96,362 106,362 111,362 150,123 157,723 167,723 167,723 50,317 30%117,406 70%- - - - 167,723
<br />TOTAL OVERALL EXPENSES 1,229,771 1,240,873 1,229,389 1,253,263 1,297,841 1,388,997 1,203,743 821,678 68%382,064 32%185,254 9,263 5%175,991 95%1,388,997
<br />FIXED 440,650 36%117,407 70%558,057 40%
<br />USAGE 780,625 64%50,316 30%830,941 60%
<br />1,221,275 100%167,723 100%1,388,998 100%
<br />SEWER EXPENSES
<br />PW ADMINISTRATIVE COSTS
<br />NO ADMINISTRATIVE COSTS
<br />NO ADMINISTRATIVE COSTS
<br /> OPERATING DEPRECIATION OVERALL
|