|
EXHIBIT D
<br />Fiscal Year 2017 12/31/2015 14
<br />ACTUAL ACTUAL ACTUAL BUDGET
<br />2014 2015 2016 2017 PW Usage %Fixed %AD Usage %Fixed %TOTAL
<br />COLLECTION SYSTEM EXPENSES
<br />701-4110-75-0000 SS REGULAR EMPLOYEE 187,990$ 200,036$ 204,612$ 211,649$ 108,891 32,667 30%76,224 70%102,758 5,138 5%97,620 80%211,649
<br />701-4111-75-0000 SS OVERTIME EMPLOYEE 4,800 20,390 18,110 18,653 9,597 2,879 30%6,718 70%9,056 453 5%8,603 95%18,653
<br />701-4121-75-0000 SS PERA 14,223 15,100 16,704 17,273 8,887 2,666 30%6,221 70%8,386 419 5%7,967 95%17,273
<br />701-4122-75-0000 SS FICA/MEDICARE 14,517 15,205 17,038 17,618 9,064 2,719 30%6,345 70%8,554 428 5%8,126 95%17,618
<br />701-4131-75-0000 SS INSURANCE HEALTH 35,406 40,215 43,305 43,224 40,639 12,192 30%28,447 70%2,585 129 5%2,456 95%43,224
<br />701-4135-75-0000 SS INSURANCE WC 2,818 4,522 5,314 5,292 5,292 1,588 30%3,704 70%- - - - - 5,292
<br />701-4211-75-0000 SS OFFICE SUPPLIES 30 - 150 150 - - - - - 150 8 5%143 95%150
<br />701-4212-75-0000 SS MOTOR FUELS 12,049 8,710 6,490 7,464 7,464 2,239 30%5,224 70%- - - - - 7,464
<br />701-4226-75-0000 SS GENERAL SUPPLIES 4,805 4,704 3,350 4,350 4,350 1,305 30%3,045 70%- - - - - 4,350
<br />701-4300-75-0000 SS AUDITOR 6,200 4,933 5,880 6,120 6,120 - 0%6,120 100%- - - - - 6,120
<br />701-4309-75-0000 SS IT & SFTW SUPPORT 9,997 7,668 9,259 10,428 2,654 2,654 100%- - 7,774 389 5%7,385 95%10,428
<br />701-4310-75-0000 SS MISC CONTRACTED SERVICES 4,659 2,428 400 400 400 - 0%400 100%- - - - - 400
<br />701-4325-75-0000 SS COMMUNICATIONS 4,599 5,112 3,890 4,170 4,170 - 0%4,170 100%- - - - - 4,170
<br />701-4335-75-0000 SS BKUP RESTORATION COSTS 8,785 - - 10,000 10,000 3,000 30%7,000 70%- - - - - 10,000
<br />701-4339-75-0000 SS EQUIP REPAIRS & MAINTENANCE 11,894 15,700 6,550 11,770 11,770 7,613 65%4,157 35%- - - - - 11,770
<br />701-4341-75-0000 SS TRAINING, CONF. & MTG.625 885 950 1,100 1,100 880 80%220 20%- - - - - 1,100
<br />701-4341-75-0100 SS TUITION- CERTIFICATIONS 340 245 - 575 575 460 80%115 20%- - - - - 575
<br />701-4350-75-0000 SS PRINTING AND PUBLISHING 1,914 1,688 1,458 1,487 1,487 - 0%1,487 100%- - - - - 1,487
<br />701-4365-75-0000 SS INSURANCE PROPERTY/ LIABILITY 28,385 16,118 13,218 9,791 9,791 - 0%9,791 100%- - - - - 9,791
<br />TOTAL COLLECTION SYSTEM 354,036$ 363,659$ 356,679$ 381,514$ 242,250$ 72,862$ 30%169,389$ 70%139,263$ 6,963$ 5%132,300$ 95%381,514
<br />TREATMENT EXPENSES
<br />701-4375-75-0000 SS MCES WASTE TREATMENT CHARGE 620,470 593,381 576,237 643,390 643,390 579,051 90%64,339 10%643,390
<br />701-4381-75-0000 SS ELECTRIC AND GAS UTILITIES 8,051 6,581 9,455 9,833 9,833 9,342 95%492 5%9,833
<br />TOTAL TREATMENT 628,521 599,962 585,692 653,224 653,224 588,393 90%64,831 17%- - - - 653,224
<br />TOTAL OPERATING EXPENSES 982,557 963,621 942,371 1,034,737 895,474 661,255 74%234,219 26%139,263 6,963 5%132,300 95%1,034,737
<br />DEPRECIATION EXPENSE
<br />701-4499-80-0000 WT DEPRECIATION MAINTENANCE EQUIP 22,428 22,428 6,728 30%15,700 70%22,428
<br />WT DEPRECIATION LINES AND LIFT STATIONS 127,222 127,222 38,167 30%89,055 70%127,222
<br />TOTAL DEPRECIATION 105,000 120,000 135,000 149,650 149,650 44,895 30%104,755 70%- - - - 149,650
<br />TOTAL OVERALL EXPENSES 982,557 1,083,621 1,077,371 1,184,387 1,045,124 706,150 68%338,974 32%139,263 6,963 5%132,300 95%1,184,387
<br /> OPERATING DEPRECIATION OVERALL
<br />FIXED 366,519 35%104,755 70%471,274 40%
<br />USAGE 668,218 65%44,895 30%713,113 60%
<br />1,034,737 100%149,650 100%1,184,387 100%
<br />SEWER EXPENSES
<br />PW ADMINISTRATIVE COSTS
<br />NO ADMINISTRATIVE COSTS
<br />NO ADMINISTRATIVE COSTS
|