Loading...
HomeMy WebLinkAbout08 Street MaintenanceBudget Comparison Report 7/25/2017 2:19:27 PM Page 21 of 51 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 Jun Department: 31- STREET MAINTENANCE Category: 4100 - PERSONAL SERVICES 4100 -SALARY -FULL TIME 373,888.22 403,239.30 198,651.30 412,050.00 480,210.00 68,160.00 16.54% 497,460.00 17,250.00 3.59% 4110 - OVERTIME F, T. 17,782.92 16,247.93 10,006.86 11,000.00 11,000.00 0.00 0.00% 10,920.00 -80.00 -0.73% 4120-SAL-P,T./TEMP 32,350.50 40,020.88 32,628.51 38,940.00 38,940.00 0.00 0.00% 38,940.00 0.00 0.00% 4141-PERA 29,141.00 31,313.50 16,298.45 32,780.00 38,100.00 5,320.00 16.23% 39,400.00 1,300,00 3.41% 4142 - FICA 28,889.59 31,220.52 17,368.79 35,350.00 40,550.00 5,200.00 14.71% 41,870.00 1,320,00 3.26% 4144 -HEALTH INSURANCE 72,800.04 79,599.96 45,274.98 90,550.00 107,900.00 17,350.00 19.16% 107,900.00 0,00 0.00% 4147 -UNEMPLOYMENT 0.00 479.48 1,198.70 0,00 0.00 0,00 0.00% 0.00 0.00 0.00% 4148 - WORKERS COMP 27,699.96 35,199.96 20,149.98 40,300,00 47,920.00 7,620.00 18.91% 49,500.00 1,580.00 3.30% Total Category: 4100 - PERSONAL SERVICES: 582,552.23 637,321.53 341,577.57 660,970.00 764,620.00 103,650.00 15.68% 785,990.00 21,370.00 2.79% Category: 4200 - COMMODITIES 4210 -OP SUPPLY -OTHER 6,965.45 9,117.38 3,374.94 8,050.00 9,950.00 1,900.00 23.60% 10,150.00 200.00 2.01% 4211- MOTOR FUELS 52,699.86 37,425.98 16,381.05 61,000.00 45,000,00 -16,000,00 -26.23% 45,000.00 0,00 0.00% 4212 - LUB/ADD 268.29 137.96 0.00 100.00 0,00 -100.00 -100.00% 0.00 0.00 0.00% 4216-FERTILIZER/CHEM 1,946.59 8,149.32 4,144.17 8,700.00 8,870,00 170.00 1.95% 9,000.00 130.00 1.47% 4217-CLOTHING/UNIFORM 6,701.97 6,143.37 4,912.24 7,500.00 7,500.00 0.00 0.00% 7,650.00 150.00 2.00% 4231- SMALL TOOLS 913.53 1,086.40 79.98 1,600,00 1,600.00 0.00 0.00% 1,600.00 0.00 0.00% 4270 - OP SUP-VEH/EQ 297.09 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4271 -OP SUP -OTHER IMP 164,123,24 157,865.12 26,522,67 195,000.00 195,000.00 0.00 0.00% 198,900.00 3,900.00 2.00% 4280 - CAPITAL OUTLAY <$5,000 0,00 1,139.02 559.95 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4200 - COMMODITIES: 233,916.02 221,064.55 55,975.00 281,950.00 267,920.00 -14,030.00 -4.98% 272,300.00 4,380.00 1.63% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 1,442.94 1,445.50 738.00 6,000.00 6,120,00 120,00 2.00% 6,200.00 80.00 1.31% 4301- ENGINEERING SVS 4,647.99 8,688.21 1,114.91 8,000.00 8,160.00 160.00 2,00% 8,300.00 140.00 1.72% 4305 - FEES FOR SERVICE 17,078.85 14,056.54 19,772.18 17,800.00 18,100.00 300.00 1.69% 18,400.00 300.00 1,66% 4310 -COMMUNICATION 1,817.82 2,334.68 1,300.16 1,370.00 2,400.00 1,030.00 75.18% 2,500.00 100.00 4.17% 4340 -PRINTING 0,00 41.00 0.00 300.00 300.00 0.00 0.00% 310.00 10.00 3.33% 4341- ADVER/PUBLISH 688,30 0.00 494.80 400.00 400.00 0.00 0.00% 410.00 10.00 2.50% 4350 - INSURANCE CHARGE 12,000.00 12,000.00 5,749.98 11,500.00 11,700.00 200.00 1.74% 11,700.00 0.00 0.00% 4370 - MAINT-REPAIR/EQ 216.46 1,700.14 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4371-MAINT-REPAIR/OTH 1,836.87 17,868.73 0.00 12,000.00 12,000.00 0.00 0.00% 12,240.00 240.00 2.00% 4375 - CHARGE -FLEET MNT 294,230.30 239,139.41 110,641.69 276,600.00 276,600.00 0.00 0.00% 282,000.00 5,400.00 1.95% 4380-RENTAL/LEASE 30,240.00 23,600.00 11,800.00 25,000.00 47,300.00 22,300.00 89.20% 47,300.00 0.00 0.00% 4401- DUES & SUBS 200.75 50,00 180.00 200.00 200.00 0.00 0.00% 205.00 5.00 2.50% 4403-TRAVEL/TRAIN/CON 6,417.36 5,413.05 738,15 9,000,00 9,000.00 0.00 0.00% 9,200.00 200.00 2,22% 4405 - CLEAN/WASTE REMV 10,849.24 9,592.37 13,155,37 11,000,00 13,000.00 2,000.00 18.18% 15,200.00 2,200.00 16.92% 7/25/2017 2:19:27 PM Page 21 of 51 Budget Comparison Report Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent ry Budget to Comparison 414,575.00 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 Jun 4449 - OTHER CONTRACT 0.00 400.00 0.00 600.00 600.00 0.00 0.00% 610.00 10.00 1.67% Total Category: 4300 - CONTRACTUAL SERVICES: 381,666.88 336,329.63 165,685.24 379,770.00 405,880.00 26,110.00 6.88% 414,575.00 Category: 4500 - CAPITAL OUTLAY 4530 - MACH & EQUIPMENT 6,239.00 8,598.00 0.00 0.00 0.00 0.00 0.00% 0.00 Total Category: 4500 - CAPITAL OUTLAY: 6,239.00 8,598.00 0.00 0.00 0.00 0.00 0.00% 0.00 Total Department: 31- STREET MAINTENANCE: 1,204,374.13 1,203,313.71 563,237.81 1,322,690.00 1,438,420.00 115,730.00 8.75% 1,472,865.00 7/25/2017 2:19:27 PM 8,695.00 2.14% 0.00 0.00% 0.00 0.00% 34,445.00 2.39% Page 22 of 51