|
Fiscal Year 2020 12/31/2018 14
<br />ACTUAL ACTUAL ACTUAL ACTUAL BUDGET EST. ACTUAL BUDGET % Change EXHIBIT B
<br />2015 2016 2017 2018 2019 2019 2020 in Budget
<br />OPERATING INCOME
<br />701-3720-0-0-00 SEWER BILLINGS 947,618$ 1,005,329$ 1,098,938$ 1,136,667$ 1,213,153$ 1,197,583$ 1,249,355$ 2.98% Includes the 2020 phase in of flat rate increase
<br />TOTAL 947,618$ 1,005,329$ 1,098,938$ 1,136,667$ 1,213,153$ 1,197,583$ 1,249,355$
<br />OPERATING EXPENDITURES
<br />701-4110-75-0000 SS REGULAR EMPLOYEE 200,036$ 203,152$ 218,382$ 219,484$ 229,488$ 222,038$ 227,425$ -0.90% AD/PW wages
<br />701-4111-75-0000 SS OVERTIME EMPLOYEE 20,390 15,398 18,028 23,832 24,606 23,500 25,098 2.00% based on run rates
<br />701-4121-75-0000 SS PERA 15,100 15,730 16,431 17,096 19,057 18,415 18,939 -0.62% 7.50%
<br />701-4122-75-0000 SS FICA/MEDICARE 15,205 15,791 16,437 16,197 19,438 18,784 19,318 -0.62% 7.65%
<br />701-4131-75-0000 SS INSURANCE HEALTH 40,215 42,862 41,725 42,222 44,574 44,277 42,919 -3.71% SPLIT 8.3% PREMUIM INCREASE IN 2020
<br />701-4135-75-0000 SS INSURANCE WC 4,522 5,314 4,685 4,483 4,687 4,687 4,417 -5.76% BASED ON 2019/2020 RENEWAL
<br />701-4211-75-0000 SS OFFICE SUPPLIES - - - - 150 150 150 0.00% based on run rates
<br />701-4212-75-0000 SS MOTOR FUELS 8,710 6,221 6,825 8,945 10,396 8,095 8,860 -14.77% 2019 contracted cost per gallon $2.10/2020 projection $2.88/3yr avg usage +1%
<br />701-4226-75-0000 SS GENERAL SUPPLIES 4,704 3,128 (120) 1,282 1,250 1,150 1,275 2.00% based on run rates
<br />701-4300-75-0000 SS AUDITOR 4,933 5,880 6,785 7,443 7,420 7,350 7,601 2.44% BASED ON AUDITOR CONTRACT
<br />701-4309-75-0000 SS IT & SFTW SUPPORT 7,668 8,148 12,205 13,612 15,405 15,405 16,820 9.19% BASED ON CONTRACTED IT /SW SPREADSHEET
<br />701-4310-75-0000 SS MISC CONTRACTED SERVICES 2,428 331 273 1,704 4,700 1,950 2,350 -50.00% BASED ON MISC CONTRACTED SERVICES SPREADSHEET
<br />701-4325-75-0000 SS COMMUNICATIONS 5,112 3,964 3,136 3,263 3,408 3,560 3,780 10.92% BASED ON COMMUNICATION SPREADSHEET
<br />701-4335-75-0000 SS BKUP RESTORATION COSTS - - - 5,123 10,000 - 10,000 0.00% Assumes the cost of one full deductable
<br />701-4339-75-0000 SS EQUIP REPAIRS & MAINTENANCE 15,700 2,487 17,438 35,085 13,500 11,500 13,770 2.00% 2018 significant repair to Vactor
<br />701-4341-75-0000 SS TRAINING, CONF. & MTG. 885 934 205 - 1,100 650 1,122 2.00% based on average run rate
<br />701-4341-75-0100 SS TUITION- CERTIFICATIONS 245 - - 1,170 575 575 587 2.00% based on average run rate
<br />701-4342-75-0000 SS MEMBERSHIP & DUES - - 238 1,131 - 904 950 0.00% based on average run rate
<br />701-4350-75-0000 SS PRINTING AND POSTAGE 1,688 1,681 4,303 2,476 4,335 2,750 3,250 -25.03% Timing of postage fills vary
<br />701-4365-75-0000 SS INSURANCE PROPERTY/ LIABILITY 16,118 13,100 9,352 11,686 11,134 10,500 9,981 -10.36% BASED ON 2019/2020 RENEWAL
<br />701-4375-75-0000 SS MCES WASTE TREATMENT CHARGE 593,381 576,237 643,390 708,567 733,670 733,670 712,664 -2.86% MCES amount for 2020, 3.6% rate increase, lower flow volume
<br />701-4381-75-0000 SS ELECTRIC AND GAS UTILITIES 6,581 10,301 9,654 8,609 9,866 9,309 10,083 2.20% Xcel increase 2.2% plus Center Point increase
<br />TOTAL 963,621$ 930,659$ 1,029,372$ 1,133,409$ 1,168,759$ 1,139,219$ 1,141,359$ -2.34%
<br /> OPERATING INCOME (LOSS)(16,003)$ 74,670$ 69,566$ 3,258$ 44,394$ 58,364$ 107,996$
<br />OTHER (INCOME) / EXPENSE
<br />701-3723-0-0-00 SEWER CONNECTION FEES (5,950)$ (7,650)$ (23,800)$ (22,100)$ (34,000)$ (34,000)$ (34,000)$
<br />701-3891-0-0-00 SS MISCELLANEOUS INCOME (16,001) (6,305) (12,559) (650) (650) (650) (650)
<br />701-3910-0-0-00 SS SALE OF ASSETS 0 (180) 0
<br />701-4499-75-0000 SS MISCELLANEOUS EXPENSE 813 90 170 100 100 100 100
<br />TOTAL (21,139)$ (14,045)$ (36,189)$ (22,650)$ (34,550)$ (34,550)$ (34,550)$
<br />NET INCOME (LOSS) BEFORE DEPRECIATION 5,135$ 88,715$ 105,754$ 25,908$ 78,944$ 92,914$ 142,546$
<br />SEWER OPERATIONS
|