Loading...
HomeMy WebLinkAbout14 Surface Water ManagementBudget Comparison Report Cottage Grove Group Summary 7/25/2017 2:37:30 PM Page 1 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: 230 - SURFACE WATER MANAGEMENT Category: 4100 - PERSONAL SERVICES 4100 -SALARY -FULL TIME 203,524.04 211,508.52 100,036.14 178,100.00 175,530.00 -2,570.00 -1.44% 178,330.00 2,800.00 1.60% 4110 - OVERTIME F. T. 6,373.09 10,188.47 6,655.96 9,000.00 9,000.00 0.00 0.00% 9,000.00 0.00 0.00% 4120-SAL-P.T./TEMP 4,491.50 7,144.50 1,125.75 8,900.00 8,900.00 0.00 0.00% 8,900.00 0.00 0.00% 4141- PERA 15,437.59 16,511.52 8,401.04 13,800.00 14,300.00 500.00 3.62% 14,520.00 220.00 1.54% 4142 - FICA 14,500.28 15,470.85 7,745.59 14,320.00 14,800.00 480.00 3.35% 15,010.00 210.00 1.42% 4144 -HEALTH INSURANCE 14,300.04 15,600.00 6,475.00 11,100.00 10,290.00 -810.00 -7.30% 10,280.00 -10.00 -0.10% 4148- WORKERS COMP 9,950.04 13,800.00 9,275.00 15,900.00 16,670.00 770.00 4.84% 16,930.00 260.00 1.56% Total Category: 4100 - PERSONAL SERVICES: 268,576.58 290,223.86 139,714.48 251,120.00 249,490.00 -1,630.00 -0.65% 252,970.00 3,480.00 1.39% Category: 4200 - COMMODITIES 4200 - OFFICE SUPPLIES 0.00 0.00 0.00 100.00 100.00 0.00 0.00% 105.00 5.00 5.00% 4210 -OP SUPPLY -OTHER 4,790.43 1,178.36 93.30 1,200.00 1,200.00 0.00 0.00% 1,220.00 20.00 1.67% 4211- MOTOR FUELS 1,579.97 2,084.59 1,116.72 1,600.00 2,000.00 400.00 25.00% 2,000.00 0.00 0.00% 4217-CLOTHING/UNIFORM 0.00 0.00 0.00 530.00 530.00 0.00 0.00% 540.00 10.00 1.89% 4231- SMALL TOOLS 600.00 618.06 39.98 600.00 600.00 0.00 0.00% 610.00 10.00 1.67% 4271- OP SUP -OTHER IMP 3,947.54 8,514.39 2,413.32 20,000.00 20,000.00 0.00 0.00% 20,400.00 400.00 2.00% 4280 - CAPITAL OUTLAY <$5,000 0.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4200 - COMMODITIES: 10,917.94 12,395.40 3,663.32 24,030.00 24,430.00 400.00 1.66% 24,875.00 445.00 1.82% Category: 4300 - CONTRACTUAL SERVICES 4300- PROF SERVICES 1,637.33 3,923.34 1,774.18 7,000.00 7,000.00 0.00 0.00% 7,120.00 120.00 1.71% 4301- ENGINEERING SVS 31,069.50 5,951.25 7,325.23 48,000.00 50,000.00 2,000.00 4.17% 51,000.00 1,000.00 2.00% 4305 - FEES FOR SERVICE 12,988.81 12,773.82 5,927.12 8,280.00 13,280.00 5,000.00 60.39% 13,350.00 70.00 0.53% 4307 -WATERSHED DISTRICT STORM FEE 2,225.00 0.00 0.00 3,300.00 3,300.00 0.00 0.00% 3,400.00 100.00 3.03% 4309 - CREDIT CARD FEES 2,376.94 4,240.30 2,385.95 0.00 3,000.00 3,000.00 0.00% 3,060.00 60.00 2.00% 4310 -COMMUNICATION 1,153.10 952.09 210.06 1,220.00 1,220.00 0.00 0.00% 1,240.00 20.00 1.64% 4311 -POSTAGE 5,239.23 5,421.45 3,129.76 5,800.00 5,800.00 0.00 0.00% 5,900.00 100.00 1.72% 4321- DATA PROCESSING 22,343.00 21,445.00 13,016.50 20,800.00 21,200.00 400.00 1.92% 21,600.00 400.00 1.89% 4340 -PRINTING 4,140.70 3,957.02 2,386.72 4,300.00 4,400.00 100.00 2.33% 4,500.00 100.00 2.27% 4341-ADVER/PUBLISH 128.70 116.80 146.00 150.00 150.00 0.00 0.00% 160.00 10.00 6.67% 4371-MAINT-REPAIR/OTH 69,666.87 78,337.32 18,863.31 192,700.00 100,000.00 -92,700.00 -48.11% 102,000.00 2,000.00 2.00% 4375 - CHARGE -FLEET MNT 5,127.80 5,718.67 3,431.56 3,800.00 6,000.00 2,200.00 57.89% 6,000.00 0.00 0.00% 4380 - RENTAL/LEASE 0.00 0.00 220.00 1,100.00 1,000.00 -100.00 -9.09% 1,020.00 20.00 2.00% 7/25/2017 2:37:30 PM Page 1 of 14 Budget Comparison Report 7/25/2017 2:37:30 PM Page 2 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 4403-TRAVEL/TRAIN/CON 119.90 0.00 0.00 400.00 400.00 0.00 0.00% 410.00 10.00 2.50% 4449 - OTHER CONTRACT 354.20 48.00 0.00 1,000.00 1,000.00 0.00 0.00% 1,020.00 20.00 2.00% Total Category: 4300 - CONTRACTUAL SERVICES: 158,571.08 142,885.06 58,816.39 297,850.00 217,750.00 -80,100.00 -26.89% 221,780.00 4,030.00 1.85% Category: 4500 - CAPITAL OUTLAY 4530 - MACH & EQUIPMENT 12,215.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4500 - CAPITAL OUTLAY: 12,215.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Category: 4999 - TRANSFERS OUT 4700 - TRANSFERS OUT 193,914.04 35,019.00 103,019.00 176,610.00 175,610.00 -1,000.00 -0.57% 0.00 -175,610.00 -100.00% Total Category: 4999 - TRANSFERS OUT: 193,914.04 35,019.00 103,019.00 176,610.00 175,610.00 -1,000.00 -0.57% 0.00 -175,610.00 -100.00% Total Fund: 230 - SURFACE WATER MANAGEMENT: 644,194.64 480,523.32 305,213.19 749,610.00 667,280.00 -82,330.00 -10.98% 499,625.00 -167,655.00 -25.13% 7/25/2017 2:37:30 PM Page 2 of 14