Loading...
HomeMy WebLinkAbout19 Sewer OperatingBudget Comparison Report 7/25/2017 2:37:30 PM Page 8 of 14 Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison % Budget 1 Budget 2015 2016 2017 2017 2018 Increase / 2019 Increase / Total Activity Total Activity YTD Activity 2017 2018 (Decrease) 2019 fall 2017 (Decrease) Object Through Jul Fund: 620 - SEWER OPERATING Category: 4100 - PERSONAL SERVICES 4100 -SALARY -FULL TIME 93,380,10 129,325.85 59,158.27 167,300,00 174,800.00 7,500.00 4.48% 180,760.00 5,960.00 3.41% 4110 - OVERTIME F. T. 984.15 1,379.40 1,626.39 3,900.00 0.00 -3,900.00 -100.00% 4,130.00 4,130.00 0.00% 4120 - SAL-P.T./TEMP 3,577.00 0,00 0,00 4,920.00 4,920.00 0.00 0.00% 4,920.00 0,00 0.00% 4140 - PENSIONS 0.00 33,442.00 0,00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4141-PERA 9,208.91 9,523.26 4,717.95 13,300.00 13,850.00 550.00 4.14% 14,330.00 480.00 3.47% 4142- FICA 7,159.28 8,992.51 4,462.64 13,500.00 14,060,00 560.00 4.15% 14,530.00 470.00 3.34% 4144 -HEALTH INSURANCE 19,772.04 28,262.96 12,045.81 20,650,00 21,430.00 780.00 3.78% 22,100.00 670.00 3.13% 4148 - WORKERS COMP 3,500.04 5,650.08 3,295.88 5,650,00 6,190.00 540.00 9.56% 6,370.00 180.00 2.91% Total Category: 4100 - PERSONAL SERVICES: 137,581.52 216,576.06 85,306.94 229,220.00 235,250.00 6,030.00 2.63% 247,140.00 11,890.00 5.05% Category: 4200 - COMMODITIES 4200 - OFFICE SUPPLIES 157.40 40.03 0.00 100.00 100.00 0.00 0.00% 100.00 0.00 0.00% 4210 -OP SUPPLY -OTHER 2,102.74 2,000.42 0.00 3,530.00 3,530.00 0.00 0.00% 3,590.00 60.00 1.70% 4211- MOTOR FUELS 4,866.50 3,709.47 1,660.07 7,000.00 4,500.00 -2,500,00 -35.71% 4,500.00 0.00 0.00% 4216-FERTILIZER/CHEM 0.00 3,088.19 2,997.00 3,130.00 3,130.00 0.00 0,00% 3,200.00 70,00 2.24% 4217 - CLOTHING/UNIFORM 0.00 0.00 0.00 930,00 930.00 0.00 0.00% 950.00 20.00 2,15% 4231- SMALL TOOLS 160.24 523,95 0.00 695.00 700.00 5.00 0.72% 710.00 10.00 1,43% 4271- OP SUP -OTHER IMP 0,00 3,479.09 2,353,63 2,500.00 2,500.00 0.00 0.00% 2,500.00 0.00 0.00% Total Category: 4200 - COMMODITIES: 7,286.88 12,841.15 7,010.70 17,885.00 15,390.00 -2,495.00 -13.95% 15,550.00 160.00 1.04% Category: 4300 - CONTRACTUAL SERVICES 4300 -PROF SERVICES 10,801.74 12,441.36 15,922.45 16,700.00 20,200.00 3,500,00 20.96% 20,400.00 200.00 0.99% 4301- ENGINEERING SVS 1,570.00 24,199.65 23,034.75 4,000.00 25,000.00 21,000.00 525.00% 25,000.00 0,00 0,00% 4305 - FEES FOR SERVICE 11,498.00 10,473.00 7,810,00 13,000.00 13,000.00 0.00 0.00% 13,250.00 250.00 1.92% 4309 - CREDIT CARD FEES 2,376,94 4,240.33 2,385.95 5,150.00 5,150.00 0.00 0.00% 5,200.00 50.00 0.97% 4310 -COMMUNICATION 358.66 402.70 210.06 450.00 450.00 0.00 0.00% 460.00 10.00 2.22% 4311 -POSTAGE 20,070.65 20,084.47 11,481.00 21,700.00 21,700.00 0.00 0.00% 22,100.00 400.00 1.84% 4321- DATA PROCESSING 78,746.96 75,150.96 45,854.06 72,775.00 72,780.00 5.00 0.01% 74,300,00 1,520.00 2.09% 4340 -PRINTING 16,561.00 15,820.00 9,553,00 17,000.00 17,000.00 0,00 0.00% 17,340,00 340.00 2,00% 4341- ADVER/PUBLISH 0.00 0.00 332.04 0.00 0.00 0.00 0.00% 0.00 0.00 0,00% 4350 - INSURANCE CHARGE 9,999.96 9,999.96 9,916.69 17,000.00 17,000.00 0.00 0.00% 17,000.00 0.00 0,00% 4360 -UTILITIES 2,071.93 3,954.51 358.24 2,120.00 2,120.00 0.00 0.00% 2,160.00 40.00 1.89% 4363 - MWCC SERVICE 1,586,211.96 1,713,284.40 1,230,427.52 1,846,000.00 1,875,000.00 29,000.00 1.57% 1,920,000.00 45,000.00 2.40% 4370 - MAINT-REPAIR/EQ 0.00 0.00 0.00 500.00 500,00 0.00 0.00% 510.00 10.00 2.00% 4371-MAINT-REPAIR/OTH 109,386,39 142,268.50 129,133.59 180,000.00 180,000,00 0.00 0,00% 183,600.00 3,600.00 2.00% 4375 - CHARGE -FLEET MNT 9,936.10 13,270,69 2,304.07 12,100,00 15,000.00 2,900.00 23,97% 15,000.00 0.00 0.00% 4380 - RENTAL/LEASE 121.50 81.00 0.00 200.00 200.00 0.00 0.00% 200.00 0.00 0.00% 4401- DUES & SUBS 46.00 0.00 0.00 100.00 100.00 0.00 0.00% 100.00 0.00 0.00% 4403-TRAVEL/TRAIN/CON 600.00 1,269.00 1,380.00 4,575.00 4,600.00 25.00 0.55% 4,690.00 90.00 1.96% 7/25/2017 2:37:30 PM Page 8 of 14 Budget Comparison Report 7/25/2017 2:37:30 PM Page 9 of 14 Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent / Budget to Comparison Budget 1 Budget 2015 2016 2017 2017 2018 Increase / 2019 Increase / Total Activity Total Activity YTD Activity 2017 2018 (Decrease) 2019 fall 2017 (Decrease) Object Through Jul 4449 - OTHER CONTRACT 0.00 48.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4300 - CONTRACTUAL SERVICES: 1,860,357.79 2,046,988.53 1,490,103.42 2,213,370.00 2,269,800.00 56,430.00 2.55% 2,321,310.00 51,510.00 2.27% Category: 4500 - CAPITAL OUTLAY 4530 - MACH & EQUIPMENT 0.00 0.00 0.00 0.00 9,000.00 9,000.00 0.00% 85,000.00 76,000.00 844.44% 4540 - OTHER CAP OUTLAY 0.00 0.00 0.00 174,740.00 175,000.00 260.00 0.15% 178,500.00 3,500.00 2.00% 4550 -PROJECT -CONTRACT 0.00 0.00 153,527.79 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4551 -PROJECT -ENGINEER 0.00 0.00 13,351.11 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4559 -PROJECT -OTHER 0.00 0.00 1,246.50 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4500 - CAPITAL OUTLAY: 0.00 0.00 168,125.40 174,740.00 184,000.00 9,260.00 5.30% 263,500.00 79,500.00 43.21% Category: 4720 - DEPRECIATION 4720 - DEPRECIATION -CONTRIBUTED 419,361.71 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4721- DEPRECIATION -PURCHASED 23,556.18 444,686.07 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4720 - DEPRECIATION: 442,917.89 444,686.07 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Category: 4999 - TRANSFERS OUT 4700 - TRANSFERS OUT 279,393.06 181,611.00 109,081.00 187,000.00 187,000.00 0.00 0.00% 0.00 -187,000.00 -100.00% Total Category: 4999 - TRANSFERS OUT: 279,393.06 181,611.00 109,081.00 187,000.00 187,000.00 0.00 0.00% 0.00 -187,000.00 -100.00% Total Fund: 620 - SEWER OPERATING: 2,727,537.14 2,902,702.81 1,859,627.46 2,822,215.00 2,891,440.00 69,225.00 2.45% 2,847,500.00 -43,940.00 -1.52% 7/25/2017 2:37:30 PM Page 9 of 14