Loading...
HomeMy WebLinkAbout07 Golf Course ClubhouseBudget Comparison Report Object Department: 56 - GOLF COURSE CLUBHOUSE Category: 4100 - PERSONAL SERVICES 4100 - SALARY -FULL TIME 4120 - SAL-P.T./TEMP 4121- O.T. - P.T./TEMP 4141-PERA 4142 - FICA 4144 - HEALTH INSURANCE 4147- UNEMPLOYMENT 4148 - WORKERS COMP Total Category: 4100 - PERSONAL SERVICES: Category: 4200 - COMMODITIES 4200 - OFFICE SUPPLIES 4210 -OP SUPPLY -OTHER 4217 - CLOTHING/UNIFORM 4271- OP SUP -OTHER IMP 4280 - CAPITAL OUTLAY <$5,000 Total Category: 4200 - COMMODITIES: Category: 4300 - CONTRACTUAL SERVICES 0.00 0.00% 0.00 Comparison 1 Comparison 1 870.00 Comparison 2 Comparison 2 0.00 4302 - LEGAL SERVICE 0.00 0.00 Parent Budget Budget to Parent / Budget to Comparison 42,000.00 4309 - CREDIT CARD FEES 5,710.94 6,706.15 3,224.71 5,400.00 Budget 0.00 157.50 1 Budget 0.00 2015 2016 2017 2017 2018 Increase / 0.00 2019 Increase / 0.00 Total Activity Total Activity YTD Activity 2017 2018 (Decrease) 3,999.96 2019 fall 2017 (Decrease) 4,000.00 4352 - GENERAL LIABILIT 3,398.82 Through Jun 3,255.81 3,600.00 4360 -UTILITIES 25,666.24 27,365.84 12,107.64 28,530.00 111,680.40 183,153.18 24,163.94 110,000.00 115,920.00 5,920.00 5.38% 117,520.00 1,600.00 1,38% 102,354.79 159,166.13 108,478.88 169,000.00 174,000.00 5,000.00 2.96% 174,000.00 0.00 0.00% 991.40 2,938.07 1,322.34 2,000.00 0.00 -2,000.00 -100.00% 0.00 0.00 0.00% 9,440.26 9,336.04 3,387.51 15,000.00 10,000.00 -5,000.00 -33.33% 11,000.00 1,000.00 10.00% 16,922.08 25,954.51 10,557.29 21,000.00 22,200.00 1,200.00 5.71% 22,300.00 100.00 0.45% 12,099.96 12,900.00 8,250.00 16,500.00 16,900.00 400.00 2.42% 17,140.00 240.00 1.42% 0.00 42.77 1,561.72 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4,299.96 5,499.96 3,049.98 6,100.00 6,610.00 510.00 8.36% 6,650.00 40.00 0,61% 257,788.85 398,990.66 160,771.66 339,600.00 345,630.00 6,030.00 1.78% 348,610.00 2,980.00 0.86% 225.09 569.95 333.53 500.00 500.00 0.00 0.00% 510.00 10.00 2.00% 12,556.84 30,802.69 13,035.51 21,500.00 21,500.00 0.00 0.00% 21,930.00 430.00 2.00% 0.00 39.14 42.50 1,500.00 1,500.00 0.00 0.00% 1,530.00 30.00 2.00% 0.00 0.00 31.83 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 0.00 2,362.44 7,232.05 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 12,781.93 33,774.22 20,675.42 23,500.00 23,500.00 0.00 0.00% 23,970.00 470.00 2.00% Category: 4300 - CONTRACTUAL SERVICES 0.00 0.00% 0.00 0.00 4300 - PROF SERVICES 870.00 4,725.00 1,025.00 0.00 4302 - LEGAL SERVICE 0.00 0.00 922.10 0.00 4305 - FEES FOR SERVICE 29,559.09 48,795.07 13,376.04 42,000.00 4309 - CREDIT CARD FEES 5,710.94 6,706.15 3,224.71 5,400.00 4310 -COMMUNICATION 0.00 157.50 1,721.85 0.00 4311 -POSTAGE 261.52 292.83 0.00 0.00 4340 - PRINTING 0.00 68.00 0.00 0.00 4341-ADVER/PUBLISH 93.00 70.00 1,275.90 0.00 4350 - INSURANCE CHARGE 3,999.96 3,999.96 1,999.98 4,000.00 4352 - GENERAL LIABILIT 3,398.82 3,426.83 3,255.81 3,600.00 4360 -UTILITIES 25,666.24 27,365.84 12,107.64 28,530.00 4370 - MAINT-REPAIR/EQ 2,893.59 6,439.07 6,111.52 5,500.00 4371-MAINT-REPAIR/OTH 0.00 64.42 0.00 6,500.00 4372-MAINT-REPAIR/BLD 0.00 6,458.97 3,096.49 6,500.00 4380-RENTAL/LEASE 2,556.94 2,323.85 1,213.13 3,200.00 4401- DUES & SUBS 44.29 64.29 2,113.79 500.00 4403-TRAVEL/TRAIN/CON 0.00 255.00 714.95 500.00 4434 -SPECIAL EVENTS 1,904.00 620.35 179.20 2,000.00 4436 - CONCESSION RESAL 106,254.67 132,029.90 53,713.39 198,000.00 4438 - PRO/MISC RESALE 0.00 11,519.23 5,032.58 9,000.00 0.00 0.00 0.00% 0.00 0.00 0.00% 0.00 0.00 0.00% 0.00 0.00 0.00% 42,000.00 0.00 0.00% 42,840.00 840.00 2.00% 5,400.00 0.00 0.00% 5,500.00 100.00 1.85% 0.00 0.00 0.00% 0.00 0.00 0.00% 0.00 0.00 0,00% 0.00 0.00 0.00% 0.00 0.00 0.00% 0.00 0.00 0.00% 0.00 0.00 0.00% 0.00 0.00 0.00% 4,000.00 0.00 0.00% 4,080.00 80.00 2.00% 3,600.00 0.00 0.00% 3,670.00 70.00 1,94% 28,530.00 0.00 0.00% 29,100.00 570.00 2,00% 5,500.00 0.00 0.00% 5,610.00 110.00 2.00% 6,500.00 0.00 0.00% 6,630.00 130.00 2.00% 6,500.00 0.00 0.00% 6,630.00 130.00 2.00% 3,200.00 0.00 0.00% 3,260.00 60.00 1.88% 500.00 0100 0.00% 510.00 10.00 2.00% 1,000.00 500.00 100.00% 1,000.00 0.00 0.00% 2,000.00 0.00 0.00% 2,040.00 40.00 2.00% 134,270.00 -63,730.00 -32,19% 156,650.00 22,380.00 16.67% 9,200.00 200.00 2.22% 9,400.00 200.00 2.17% 7/25/2017 2:47:22 PM Page 5 of 7 Budget Comparison Report 2015 2016 2017 Total Activity Total Activity YTD Activity Object Through Jun 4439 - LIQUOR - RESALE 40,009.76 41,200.64 21,120.53 4449 - OTHER CONTRACT 7,837.00 7,796.00 6,550.00 Total Category: 4300 - CONTRACTUAL SERVICES: 231,059.82 304,378.90 138,754.61 Category: 4500 - CAPITAL OUTLAY 4520- FURN & OFF EQUIP 0.00 0.00 0.00 4530- MACH & EQUIPMENT 0.00 0.00 1,085.10 4540 -OTHER CAP OUTLAY 0.00 4,110.01 43,195.35 Total Category: 4500 - CAPITAL OUTLAY: 0.00 4,110.01 44,280.45 Total Department: 56 - GOLF COURSE CLUBHOUSE: 501,630.60 741,253.79 Total Fund: 255 - GOLF COURSE SPECIAL REVENUE FUND: 1,442,333.85 1,679,867.68 Report Total: 1,442,333.85 1,679,867.68 364,482.14 739,730.00 676,100.00 -63,630.00 -8.60% 709,230.00 33,130.00 4.90% 834,941.79 1,782,680.00 1,755,140.00 -27,540.00 -1.54% 1,747,830.00 -7,310.00 -0.42% 834,941.79 1,782,680.00 1,755,140.00 -27,540.00 -1.54% 1,747,830.00 -7,310.00 -0.42% 7/25/2017 2:47:22 PM Page 6 of 7 Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison % Budget 1 Budget 2017 2018 Increase / 2019 Increase / 2017 2018 (Decrease) 2019 fall 2017 (Decrease) 30,000.00 28,370.00 -1,630.00 -5.43% 33,100.00 4,730.00 16.67% 11,400.00 11,400.00 0.00 0.00% 11,630.00 230.00 2.02% 356,630.00 291,970.00 -64,660.00 -18.13% 321,650.00 29,680.00 10.17% 20,000.00 0.00 -20,000.00 -100.00% 0.00 0.00 0.00% 0.00 15,000.00 15,000.00 0.00% 15,000.00 0.00 0.00% 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 20,000.00 15,000.00 -5,000.00 -25.00% 15,000.00 0.00 0.00% 364,482.14 739,730.00 676,100.00 -63,630.00 -8.60% 709,230.00 33,130.00 4.90% 834,941.79 1,782,680.00 1,755,140.00 -27,540.00 -1.54% 1,747,830.00 -7,310.00 -0.42% 834,941.79 1,782,680.00 1,755,140.00 -27,540.00 -1.54% 1,747,830.00 -7,310.00 -0.42% 7/25/2017 2:47:22 PM Page 6 of 7