Fiscal Year 202112/31/2018EXHIBIT CACTUAL ACTUAL ACTUAL ACTUAL BUDGET EST. ACTUAL BUDGET2016201720182019202020202021WATER OPERATIONSPRODUCTION OPERATING EXPENDITURES701‐4110‐85‐0000 REGULAR EMPLOYEE 56,678 58,161 60,139 62,559 66,075 64,411 66,806 701‐4111‐85‐0000 OVERTIME EMPLOYEE 712 1,024 367 936 1,050 1,800 1,500 701‐4121‐85‐0000 PERA 4,768 4,900 5,078 5,458 5,034 4,966 5,123 701‐4122‐85‐0000 FICA/MEDICARE 4,875 4,973 5,156 5,589 5,135 5,065 5,225 701‐4131‐85‐0000 INSURANCE HEALTH9,235 10,126 11,036 10,339 11,000 12,828 14,020 701‐4135‐85‐0000WTR FILT INSURANCE WC4,328 3,776 3,587 3,505 3,533 3,781 5,278 701‐4221‐85‐0000 SUPPLIES‐ EQUIPMENT3,146 396 772 644 1,301 855 925 701‐4226‐85‐0000 GENERAL SUPPLIES52,187 55,746 55,429 46,794 56,500 51,750 56,500 701‐4226‐85‐0001 CARBON SUPPLY USAGE ‐ 2,654 35,240 33,523 32,500 35,000 35,000 701‐4226‐85‐0200UV BULB SUPPLY USAGE‐ ‐ 112,418 112,337 112,400 112,400 112,400 701‐4226‐85‐0003 PEROXIDE SUPPILES ‐ 27,930 27,920 33,000 28,533 30,000 701‐4303‐85‐0000 ENGINEER EXPENSES13,628 1,952 4,587 1,722 3,500 1,500 1,700 701‐4308‐85‐0000 WATER QUALITY PROTECTION COSTS‐ 12,387 12,644 12,626 14,325 12,400 12,772 701‐4309‐85‐0000 CONTRACTED IT & SFTW SUPPORT330 ‐ 3,659 2,657 3,238 2,740 2,830 701‐4310‐85‐0000 MISC CONTRACTED SERVICES386 330 345 690 570 690 720 701‐4325‐85‐0000 COMMUNICATIONS149 2,143 2,694 2,596 2,550 2,325 2,405 701‐4339‐85‐0000 EQUIP REPAIRS & MAINTENANCE 11,748 14,140 28,468 8,962 14,500 12,950 13,500 701‐4340‐85‐0000 BLDG REPAIRS & MAINTENANCE9,554 5,724 2,656 1,502 2,805 1,450 2,250 701‐4365‐85‐0000 INSURANCE PROPERTY / LIABILITY‐ 14,067 16,552 19,498 19,160 17,297 16,750 701‐4381‐85‐0000 ELECTRIC AND GAS UTILITIES15,527 112,035 129,272 129,626 135,813 140,668 146,295 TOTAL187,251 304,534 518,027 489,484 523,988 513,409 531,999 OPERATING INCOME (LOSS)130,430$ 104,281$ (92,175)$ (94,590)$ (30,837)$ (11,722)$ 17,012$ OTHER (INCOME) / EXPENSE701‐3891‐0‐0‐00 WT MISCELLANEOUS INCOME (2,495) (12,559) (4,350) (7,460) (550) (550) (550) 701‐3620‐0‐1‐00 WT INTEREST INCOME (23,907) (16,714) (24,620) (28,476) (23,000) (12,000) (7,500) 701‐3713‐0‐0‐00 WT WATER CONNECTION FEES (7,650) (23,850) (25,700) (1,750) (34,000) (1,750) (34,000) 701‐3910‐0‐0‐00WT SALE OF ASSETS (1,170) ‐ ‐ ‐ ‐ ‐ ‐ 701‐4335‐80‐0000 WT BKUP RESTORATION COSTS‐ ‐ ‐ ‐ ‐ ‐ ‐ 701‐4499‐80‐0000 WT MISCELLANEOUS EXPENSE172 1,572 1,362 650 650 650 650 TOTAL(35,050)$ (51,551)$ (53,309)$ (37,036)$ (56,900)$ (13,650)$ (41,400)$ OPERATING INCOME BEFORE DEPRECIATION 165,480$ 155,832$ (38,866)$ (57,554)$ 26,063$ 1,928$ 58,412$ 32
|