Loading...
HomeMy WebLinkAbout01 Parks MaintenanceBudget Comparison Report 7/25/2017 2:19:27 PM Page 28 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: 41- PARKS MAINTENANCE Category: 4100 - PERSONAL SERVICES 4100 -SALARY -FULL TIME 493,877.69 528,624.24 243,498.90 568,900.00 509,620.00 -59,280.00 -10.42% 524,900.00 15,280.00 3.00% 4110 -OVERTIME F. T. 13,212.86 17,648.99 10,292.84 12,000.00 11,970.00 -30.00 -0.25% 11,970.00 0.00 0.00% 4115 - REGULAR-P/T REG STATUS 2,840.19 2,001.25 1,020.19 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4120 - SAL-P.T,/TEMP 63,300.76 65,467.49 17,455.29 106,565.00 94,000.00 -12,565.00 -11.79% 93,960.00 -40.00 -0.04% 4121- O.T. - P.T./TEMP 0.00 16.88 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4140 -PENSIONS 0.00 6,630.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4141- PERA 37,955.33 41,031.95 19,612.78 45,000.00 47,700.00 2,700.00 6.00% 48,890.00 1,190.00 2.49% 4142 - FICA 39,967.82 42,763.79 19,748.44 52,550.00 47,090.00 -5,460.00 -10.39% 48,260.00 1,170.00 2.48% 4144 -HEALTH INSURANCE 45,699.96 58,700.04 31,980.00 63,960.00 72,060.00 8,100.00 12.66% 74,760.00 2,700.00 3.75% 4147 - UNEMPLOYMENT 19.38 0.00 0.00 0.00 0.00 0100 0.00% 0.00 0.00 0.00% 4148 - WORKERS COMP 16,600.08 22,100.04 14,320.02 28,640.00 27,520.00 -1,120.00 -3.91% 28,200.00 680.00 2.47% Total Category: 4100 - PERSONAL SERVICES: 713,474.07 784,984.67 357,928.46 877,615.00 809,960.00 -67,655.00 -7.71% 830,940.00 20,980.00 2.59% Category: 4200 - COMMODITIES 4200 - OFFICE SUPPLIES 0.00 0.00 0.00 1,050.00 1,050.00 0.00 0.00% 1,070.00 20.00 1.90% 4209 - OP SUPPLIES-CLEN 1,142.51 305.24 617.06 550.00 560.00 10.00 1.82% 570.00 10.00 1.79% 4210 -OP SUPPLY -OTHER 52,958.61 62,245.86 28,357.14 75,400.00 67,380.00 -8,020.00 -10.64% 68,770.00 1,390.00 2.06% 4211- MOTOR FUELS 42,354.16 29,903.24 13,275.48 50,000.00 38,000.00 -12,000.00 -24.00% 39,000.00 1,000.00 2.63% 4212 - LUB/ADD 452.27 94.94 324.05 200.00 200.00 0.00 0.00% 200.00 0.00 0.00% 4216-FERTILIZER/CHEM 25,049.79 21,173.31 17,939.39 29,000.00 29,000.00 0.00 0.00% 29,580.00 580.00 2.00% 4217-CLOTHING/UNIFORM 5,228.53 3,757.72 2,403.94 4,400.00 4,400.00 0.00 0.00% 4,500.00 100.00 2.27% 4231 -SMALL TOOLS 3,404.37 1,363.81 453.80 1,000.00 1,000.00 0.00 0.00% 1,020.00 20.00 2.00% 4270 - OP SUP-VEH/EQ 3,256.72 5,396.81 1,054.23 700.00 700.00 0.00 0.00% 715,00 15.00 2.14% 4271- OP SUP -OTHER IMP 9,583.11 9,820.59 123.73 20,000.00 20,000.00 0.00 0.00% 20,400.00 400.00 2.00% 4272 - OP SUP -BUILDINGS 3,267.14 3,286.44 1,705.57 8,500.00 8,500.00 0.00 0.00% 8,670.00 170.00 2,00% 4280 - CAPITAL OUTLAY <$5,000 7,197.00 1,555.75 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4200 - COMMODITIES: 153,894.21 138,903.71 66,254.39 190,800.00 170,790.00 -20,010.00 -10.49% 174,495.00 3,705.00 2.17% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 1,487.76 1,291.50 824.00 2,125.00 2,225.00 100.00 4.71% 2,260.00 35.00 1.57% 4301- ENGINEERING SVS 1,952.50 133.75 4,696.25 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4305 - FEES FOR SERVICE 10,734.77 40,801.73 7,741.43 11,300.00 11,300.00 0.00 0.00% 16,000.00 4,700.00 41.59% 4310 -COMMUNICATION 4,142.69 2,425.95 1,325.06 5,370.00 5,370.00 0.00 0.00% 5,500.00 130.00 2.42% 4311 -POSTAGE 16.93 15.99 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4321- DATA PROCESSING 23,375.04 23,375.04 11,687.52 23,375.00 25,000.00 1,625.00 6.95% 25,000.00 0.00 0.00% 4340 -PRINTING 172.00 0.00 0'.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4341-ADVER/PUBLISH 35.00 47.85 494.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4350 - INSURANCE CHARGE 27,000.00 27,000.00 16,750.02 33,500.00 33,500.00 0.00 0.00% 33,500.00 0.00 0.00% 4360 -UTILITIES 32,722.09 35,438.50 15,274.51 40,000.00 40,800.00 800.00 2.00% 41,600.00 800.00 1.96% 7/25/2017 2:19:27 PM Page 28 of 51 Budget Comparison Report Object 4370 - MAINT-REPAIR/EQ 4371- MAINT-REPAIR/OTH 4372 - MAINT-REPAIR/BLD 4375 - CHARGE -FLEET MNT 4380 - RENTAL/LEASE 4401- DUES & SUBS 4403 - TRAVEL/TRAIN/CON 4405 - CLEAN/WASTE REMV 4449 - OTHER CONTRACT Total Category: 4300 - CONTRACTUAL SERVICES: Category: 4500 - CAPITAL OUTLAY 4530 - MACH & EQUIPMENT 4540 - OTHER CAP OUTLAY Total Category: 4500 - CAPITAL OUTLAY: Total Department: 41- PARKS MAINTENANCE: 1,171,828.37 1,390,245.27 590,305.23 1,384,510.00 1,339,645.00 -44,865.00 -3.24% 1,329,305.00 -10,340.00 -0.77% 7/25/2017 2:19:27 PM Page 29 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) Through Jun 5,013.67 3,427.52 2,370.68 1,025.00 1,050.00 25.00 2.44% 1,070.00 20.00 1.90% 11,443.46 26,924.00 14,550.00 15,000.00 26,000.00 11,000.00 73.33% 15,000.00 -11,000.00 -42.31% 8,155.31 8,805.04 8,976.45 9,500.00 20,000.00 10,500.00 110.53% 9,900.00 -10,100.00 -50.50% 104,538.18 100,569.37 57,154.54 124,700.00 115,000.00 -9,700.00 -7.78% 115,000.00 0.00 0.00% 30,280.58 31,009.44 6,195.59 30,000.00 38,200.00 8,200.00 27.33% 38,200.00 0.00 0.00% 339.00 520.54 192.00 350.00 350.00 0.00 0.00% 350.00 0.00 0.00% 5,218.97 3,430.44 1,810.72 5,700.00 5,700.00 0.00 0.00% 5,800.00 100.00 1.75% 14,684.10 11,960.09 5,114.01 12,750.00 13,000.00 250.00 1.96% 13,260.00 260.00 2.00% 1,013.24 388.00 0.00 1,400.00 1,400.00 0.00 0.00% 1,430.00 30.00 2.14% 282,325.29 317,564.75 155,156.78 316,095.00 338,895.00 22,800.00 7.21% 323,870.00 -15,025.00 -4.43% 0.00 0.00 10,965.60 0.00 20,000.00 20,000.00 0.00% 0.00 -20,000.00 -100.00% 22,134.80 148,792.14 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 22,134.80 148,792.14 10,965.60 0.00 20,000.00 20,000.00 0.00% 0.00 -20,000.00 -100.00% 1,171,828.37 1,390,245.27 590,305.23 1,384,510.00 1,339,645.00 -44,865.00 -3.24% 1,329,305.00 -10,340.00 -0.77% 7/25/2017 2:19:27 PM Page 29 of 51