Loading...
HomeMy WebLinkAbout06 Golf CourseBudget Comparison Report 7/25/2017 2:47:22 PM Page 3 of 7 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: 55 - GOLF COURSE -MAINTENANCE Category: 4100 - PERSONAL SERVICES 4100 -SALARY -FULL TIME 129,665,19 134,563.48 67,458.76 136,000.00 144,350.00 8,350.00 6.14% 146,000.00 1,650.00 1.14% 4120-SAL-P.T./TEMP 110,131.98 117,952.92 53,110.21 110,000.00 120,000.00 10,000.00 9.09% 120,000.00 0.00 0.00% 4121- O.T. - P.T./TEMP 1,816.77 2,797.33 570.58 0.00 3,000.00 3,000.00 0.00% 3,000.00 0.00 0.00% 4141-PERA 11,848.09 12,401.30 6,363.34 15,600.00 14,000.00 -1,600.00 -10.26% 14,000.00 0.00 0.00% 4142 -FICA 17,798.85 18,820.96 9,136.74 18,800.00 20,450.00 1,650.00 8.78% 19,790.00 -660.00 -3.23% 4144 -HEALTH INSURANCE 12,099.96 12,900.00 15,100.02 30,200.00 31,410.00 1,210.00 4.01% 25,660.00 -5,750.00 -18.31% 4148 - WORKERS COMP 4,200.00 5,700.00 2,800.02 5,600.00 6,100.00 500.00 8.93% 5,900.00 -200.00 -3.28% Total Category: 4100 - PERSONAL SERVICES: 287,560.84 305,135.99 154,539.67 316,200.00 339,310.00 23,110.00 7.31% 334,350.00 -4,960.00 -1.46% Category: 4200 - COMMODITIES 4200 - OFFICE SUPPLIES 154.64 533.88 107.11 500.00 510.00 10.00 2.00% 520.00 10.00 1.96% 4210- OP SUPPLY -OTHER 21,257.16 22,896.12 15,664.65 23,500.00 23,500.00 0.00 0.00% 23,970.00 470.00 2.00% 4211- MOTOR FUELS 20,864.57 17,929.22 7,443.41 37,000.00 19,000.00 -18,000.00 -48.65% 20,000.00 1,000.00 5.26% 4212 - LUB/ADD 1,730.69 1,773.77 1,503.90 3,500.00 3,500.00 0.00 0.00% 3,570.00 70.00 2,00% 4216-FERTILIZER/CHEM 27,184.44 32,566.91 16,445.49 37,000.00 37,000.00 0.00 0.00% 37,740.00 740.00 2.00% 4217-CLOTHING/UNIFORM 0.00 0.00 800.00 1,000.00 1,000.00 0.00 0.00% 1,020.00 20.00 2.00% 4231 -SMALL TOOLS 1,284.16 1,209.76 0.00 1,800.00 1,800.00 0.00 0.00% 1,840.00 40.00 2.22% 4270 - OP SUP-VEH/EQ 21,537.17 20,684.70 16,395.03 24,000.00 24,000.00 0.00 0.00% 24,480.00 480.00 2.00% 4271- OP SUP -OTHER IMP 2,983.73 6,210.65 1,257.63 9,000.00 9,000.00 0.00 0.00% 9,180.00 180.00 2.00% 4272-OPSUP-BUILDINGS 302.00 1,231.66 2,281.61 1,800.00 1,800.00 0.00 0.00% 1,840.00 40.00 2.22% 4280 - CAPITAL OUTLAY <$5,000 3,344.12 3,111.50 0.00 3,600.00 3,600.00 0.00 0.00% 3,670.00 70.00 1.94% Total Category: 4200 - COMMODITIES: 100,642.68 108,148.17 61,898.83 142,700.00 124,710.00 -17,990.00 -12.61% 127,830.00 3,120.00 2.50% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 800.00 1,084.35 775.10 0.00 1,000.00 1,000.00 0.00% 1,020.00 20.00 2,00% 4305 - FEES FOR SERVICE 3,691.47 2,915.06 7,904.41 11,800.00 5,800.00 -6,000.00 -50.85% 5,840.00 40.00 0.69% 4310 -COMMUNICATION 2,162.10 3,121.45 1,496.24 2,400.00 2,400.00 0.00 0.00% 2,500.00 100.00 4.17% 4350- INSURANCE CHARGE 699.96 699.96 349.98 700.00 700.00 0.00 0.00% 715.00 15.00 2.14% 4360 -UTILITIES 15,243.71 14,115.92 4,855.95 20,000.00 20,400.00 400.00 2.00% 20,800.00 400.00 1.96% 4370 - MAINT-REPAIR/EQ 2,335.60 13,566.29 4,438.11 6,000.00 6,000.00 0.00 0.00% 6,120.00 120.00 2.00% 4371-MAINT-REPAIR/OTH 1,335.00 563.02 0.00 10,000.00 10,000.00 0.00 0.00% 10,200.00 200.00 2.00% 4372-MAINT-REPAIR/BLD 3,225.47 0.00 640.57 3,500.00 3,500.00 0.00 0.00% 3,570.00 70.00 2.00% 4375- CHARGE -FLEET MNT 1,999.53 0.00 87.72 1,100.00 1,100.00 0.00 0.00% 1,125.00 25.00 2.27% 4380 - RENTAL/LEASE 1,016.48 862.79 0.00 5,000.00 5,000.00 0.00 0.00% 5,100.00 100.00 2.00% 4401- DUES & SUBS 865.00 935.00 875.00 900.00 900.00 0.00 0.00% 920.00 20.00 2.22% 4403-TRAVEL/TRAIN/CON 918.35 849.92 0.00 1,000.00 1,020.00 20.00 2.00% 3,040.00 2,020.00 198.04% 4405 - CLEAN/WASTE REMV 4,585.29 5,736.42 3,293.90 5,000.00 5,000.00 0.00 0.00% 5,100.00 100.00 2.00% 4445 - SALES TAX 0.00 0.00 0.00 6,000.00 0.00 -6,000.00 -100.00% 0.00 0.00 0.00% 7/25/2017 2:47:22 PM Page 3 of 7 Budget Comparison Report 7/25/2017 2:47:22 PM Page 4 of 7 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 4449 - OTHER CONTRACT 1,056.26 699.18 92.75 14,000.00 1,400.00 -12,600.00 -90.00% 1,430.00 30.00 2.14% Total Category: 4300 - CONTRACTUAL SERVICES: 39,934.22 45,149.36 24,809.73 87,400.00 64,220.00 -23,180.00 -26.52% 67,480.00 3,260.00 5.08% Category: 4500 - CAPITAL OUTLAY 4530- MACH & EQUIPMENT 55,517.93 44,901.30 67,198.13 74,500.00 126,000.00 51,500.00 69.13% 79,000.00 -47,000.00 -37.30% Total Category: 4500 - CAPITAL OUTLAY: 55,517.93 44,901.30 67,198.13 74,500.00 126,000.00 51,500.00 69.13% 79,000.00 -47,000.00 -37.30% Total Department: 55 - GOLF COURSE -MAINTENANCE: 483,655.67 503,334.82 308,446.36 620,800.00 654,240.00 33,440.00 5.39% 608,660.00 -45,580.00 -6.97% 7/25/2017 2:47:22 PM Page 4 of 7