Loading...
HomeMy WebLinkAbout23 Fleet MaintenanceBudget Comparison Report 7/25/2017 2:37:30 PM Page 12 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: 710 - FLEET MAINTENANCE Category: 4100 - PERSONAL SERVICES 4100 -SALARY -FULL TIME 244,348.01 271,232.23 131,371.80 257,500.00 265,170.00 7,670.00 2.98% 348,940.00 83,770.00 31.59% 4110 - OVERTIME F. T. 11,742.71 10,696.19 7,791.47 7,800.00 8,050.00 250.00 3.21% 8,280.00 230.00 2.86% 4120 - SAL-P.T./TEMP 0.00 0.00 55.00 5,280.00 5,280.00 0.00 0.00% 5,280.00 0.00 0.00% 4140 - PENSIONS 0.00 20,522.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4141- PERA 26,429.63 19,919.33 10,959.50 20,560.00 21,170.00 610.00 2.97% 21,810.00 640.00 3.02% 4142 -FICA 17,989.55 18,917.25 9,957.40 20,700.00 21,200.00 500.00 2.42% 21,930.00 730.00 3.44% 4144- HEALTH INSURANCE 38,190.04 41,436.96 18,176.69 31,160.00 34,280.00 3,120.00 10.01% 34,280.00 0.00 0.00% 4148 - WORKERS COMP 8,100.00 10,700.04 6,533.31 11,200.00 11,600.00 400.00 3.57% 11,960.00 360.00 3.10% Total Category: 4100 - PERSONAL SERVICES: 346,799.94 393,424.00 184,845.17 354,200.00 366,750.00 12,550.00 3.54% 452,480.00 85,730.00 23.38% Category: 4200 - COMMODITIES 4210 -OP SUPPLY -OTHER 3,555.18 8,018.08 3,372.74 6,400.00 6,500.00 100.00 1.56% 6,630.00 130.00 2.00% 4211- MOTOR FUELS 309,230.72 214,168.69 120,529.72 330,000.00 318,000.00 -12,000.00 -3.64% 324,000.00 6,000.00 1.89% 4212-LUB/ADD 14,424.91 10,977.90 5,743.35 15,900.00 16,200.00 300.00 1,89% 16,520.00 320.00 1.98% 4217-CLOTHING/UNIFORM 1,553.76 681.68 967.23 4,520.00 4,520.00 0.00 0.00% 4,520.00 0.00 0.00% 4231 -SMALL TOOLS 1,753.08 4,787.19 634.50 5,120.00 5,000.00 -120.00 -2.34% 5,100.00 100.00 2.00% 4270 - OP SUP-VEH/EQ 224,647.48 189,119.00 106,021.40 222,800.00 227,000.00 4,200.00 1.89% 231,540.00 4,540.00 2.00% 4271- OP SUP -OTHER IMP 6,785.88 451.72 1,159.43 300.00 500.00 200.00 66.67% 500.00 0.00 0.00% 4272-OPSUP-BUILDINGS 35.45 146.41 456.14 0.00 500.00 500.00 0.00% 500.00 0.00 0.00% 4280 - CAPITAL OUTLAY <$5,000 19,811.86 18,864.71 0.00 3,600.00 0.00 -3,600.00 -100.00% 0.00 0.00 0.00% Total Category: 4200 - COMMODITIES: 581,798.32 447,215.38 238,884.51 588,640.00 578,220.00 -10,420.00 -1.77% 589,310.00 11,090.00 1.92% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 1,859.29 1,720.00 564.40 3,000.00 2,550.00 -450.00 -15.00% 2,600.00 50.00 1.96% 4305 - FEES FOR SERVICE 5,011.46 5,663.41 2,127.19 5,750.00 5,800.00 50.00 0.87% 5,920.00 120.00 2.07% 4310 -COMMUNICATION 655.37 2,009.49 1,108.55 1,500.00 1,500.00 0.00 0.00% 1,500.00 0.00 0.00% 4321- DATA PROCESSING 14,874.96 17,354.96 11,207.06 17,375.00 18,000.00 625.00 3.60% 19,000.00 1,000.00 5.56% 4340 -PRINTING 0.00 36.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4341-ADVER/PUBLISH 0.00 0.00 59.00 400.00 400.00 0.00 0.00% 410.00 10.00 2.50% 4350 - INSURANCE CHARGE 1,400.04 1,400.04 816.69 1,400.00 1,400.00 0.00 0.00% 1,400.00 0.00 0,00% 4370 - MAINT-REPAIR/EQ 48,792.70 68,783.51 42,135.01 58,500.00 67,500.00 9,000.00 15.38% 67,500.00 0.00 0.00% 4371- MAINT-REPAIR/0TH 3,295.62 2,516.00 4,009.77 4,000.00 4,000.00 0.00 0.00% 4,080.00 80.00 2.00% 4372-MAINT-REPAIR/BLD 0.00 0.00 104.62 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4401- DUES & SUBS 0.00 0.00 0.00 200.00 200.00 0.00 0.00% 200.00 0.00 0.00% 4403-TRAVEL/TRAIN/CON 892.65 2,126.82 0.00 2,400.00 2,400.00 0.00 0.00% 2,500.00 100.00 4.17% 4445 - SALES TAX 5,524.97 4,595.59 1,914.93 5,000.00 10,700.00 5,700.00 114.00% 10,700.00 0.00 0.00% 4449 - OTHER CONTRACT 0.00 16.00 0.00 200.00 200.00 0.00 0.00% 205.00 5.00 2.50% Total Category: 4300 - CONTRACTUAL SERVICES: 82,307.06 106,221.82 64,047.22 99,725.00 114,650.00 14,925.00 14.97% 116,015.00 1,365.00 1.19% 7/25/2017 2:37:30 PM Page 12 of 14 Budget Comparison Report 7/25/2017 2:37:30 PM Page 13 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 Category: 4500 - CAPITAL OUTLAY 4520 - FURN & OFF EQUIP 0.00 15,640.00 0.00 0.00 8,000.00 8,000.00 0,00% 0.00 -8,000.00 -100.00% 4530 - MACH & EQUIPMENT 0.00 0.00 0.00 42,000.00 125,500.00 83,500.00 198.81% 24,000.00 -101,500.00 -80.88% Total Category: 4500 - CAPITAL OUTLAY: 0.00 15,640.00 0.00 42,000.00 133,500.00 91,500.00 217.86% 24,000.00 -109,500.00 -82.02% Category: 4720 - DEPRECIATION 4720 - DEPRECIATION -CONTRIBUTED 21,244.62 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0,00% 4721 -DEPRECIATION -PURCHASED 6,940.38 30,344.92 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4720 - DEPRECIATION: 28,185.00 30,344.92 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Fund: 710 - FLEET MAINTENANCE: 1,039,090.32 992,846.12 487,776.90 1,084,565.00 1,193,120.00 108,555.00 10.01% 1,181,805.00 -11,315.00 -0.95% Report Total: 9,821,121.56 9,423,766.94 4,711,077.62 10,056,830.00 10,349,995.00 293,165.00 2.92% 9,149,051.00 -1,200,944.00 -11.60% 7/25/2017 2:37:30 PM Page 13 of 14