Loading...
HomeMy WebLinkAbout05 Golf Course (Revenues)Budget Comparison Report 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 Fund: 255 - GOLF COURSE SPECIAL REVENUE FUND Category: 3400 - CHARGES FOR SERVICES 3400 -GREEN FEES 605,374.42 583,429.81 228,808.93 625,000.00 625,000.00 0.00 0.00% 625,000.00 0.00 0.00% 3418 - HANDICAPS 9,338.00 8,258.00 7,430.00 10,000.00 10,000.00 0.00 0.00% 10,000.00 0.00 0.00% 3420 - RENTAL CLUBS 1,780.79 1,787.38 726.56 1,500.00 1,500.00 0.00 0.00% 1,500.00 0.00 0.00% 3421 -GOLF CARTS 221,476.04 221,819.63 88,189.91 225,000.00 225,000.00 0.00 0.00% 225,000.00 0.00 0.00% 3428 - LESSON 1,395,00 3,200.00 2,100.00 1,700.00 1,700.00 0.00 0.00% 1,700.00 0.00 0.00% 3429 - RANGE 47,710.75 46,670,53 28,778.94 50,000.00 50,000.00 0.00 0.00% 50,000.00 0.00 0.00% 3431- PATRON CARDS 0.00 0.00 0.00 57,000.00 57,000.00 0,00 0,00% 57,000.00 0.00 0.00% 3434 - CIGARS 0.00 1,596.72 286.27 0,00 0.00 0,00 0.00% 0.00 0.00 0,00% 3435 - NON-ALCHOL BEV 22,105.98 23,503.96 5,814.60 44,850.00 34,140.00 -10,710.00 -23.88% 39,820.00 5,680.00 16.64% 3436 -ALCOHOLIC BEVERA 167,451.49 186,102.57 75,171.81 147,330.00 141,850.00 -5,480.00 -3.72% 165,480.00 23,630.00 16.66% 3441- FOOD 259,578.55 291,378.40 140,990.70 565,600.00 383,630.00 -181,970.00 -32,17% 447,570.00 63,940.00 16.67% 3442 - POLICE SECURITY 3,575.00 3,850.00 864.00 5,000.00 5,000.00 0.00 0.00% 5,000.00 0.00 0.00% 3443 - CLUBHOUSE RENTALS 16,461.48 15,511,18 9,724.37 25,000.00 12,800.00 -12,200.00 -48.80% 15,000.00 2,200.00 17.19% 3444 - MANDATORY GRATUITY 39,094.77 47,541,71 26,681.41 37,000,00 27,580.00 -9,420,00 -25.46% 32,130.00 4,550.00 16,50% 3450 -GOLF BALLS 0.00 0.00 0,00 0,00 0.00 0,00 0.00% 0,00 0.00 0,00% 3451 -GOLF ACCESSORIES 31,402.36 28,862.71 11,836.02 45,000.00 45,000.00 0,00 0.00% 45,000,00 0.00 0,00% 3452 - GOLF CLUBS 0.00 7.70 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 3453 - CLOTHING - TAX 0.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 3454 - CLOTH ING-NONTAX 11,267.92 8,971.73 3,583.36 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 3455 - GIFT CERTIFICATE 4,767.04 390.94 9,768.88 1,000.00 1,000.00 0.00 0.00% 1,000.00 0.00 0.00% 3465 - GOLF CLUB REPAIR 456,71 275.41 125.10 1,000.00 1,000.00 0.00 0.00% 1,000.00 0.00 0.00% 3572- VENDING SALE 763.14 910,84 95.56 1,000.00 1,000.00 0,00 0.00% 1,000.00 0.00 0.00% Total Category: 3400 - CHARGES FOR SERVICES: 1,443,999.44 1,474,069.22 640,976.42 1,842,980.00 1,623,200,00 -219,780.00 -11.93% 1,723,200.00 100,000.00 6.16% Category: 3812 - MISCELLANEOUS 3812 - DONATE & CONTRI 0.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 3813 - SALE OF GOODS 13,065,09 1,245.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 3816 - REFUND & REIMERS 1,368.47 1,769,80 514.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 3829 - MISC -OTHER 0.00 0.00 66.00 0,00 0.00 0,00 0.00% 0.00 0.00 0.00% 3830 -CASH OVER 1,123.71 -5,408.00 -22,769,25 0,00 0.00 0,00 0.00% 0.00 0.00 0.00% Total Category: 3812 - MISCELLANEOUS: 15,557.27 -2,393.20 -22,189.25 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Category: 3999 -TRANSFERS IN 3899 - TRANSFER IN 1,200,000.00 100,000.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 3999 - TRANSFERS IN: 1,200,000.00 100,000.00 0,00 0.00 0.00 0.00 0.00% 0,00 0.00 0.00% Total Fund: 255 - GOLF COURSE SPECIAL REVENUE FUND: 2,659,556.71 1,571,676.02 618,787,17 1,842,980.00 1,623,200.00 -219,780.00 -11.93% 1,723,200.00 100,000.00 6.16% 7/25/2017 2:07:00 PM Page 7 of 12 Cottage Grove Object Fund: 255 - GOLF COURSE SPECIAL REVENUE FUND Department: 53 - GOLF COURSE -ADMINISTRATION 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: Budget Comparison Report Group Summary Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison % 1,950.00 Budget 70,752.59 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 22,324.93 1,074.71 2,000.00 84,233.91 86,913.88 30,295.00 69,500.00 67,500.00 -2,000.00 -2.88% 69,450.00 1,950.00 2.89% 70,752.59 93,110.01 26,364.95 77,000.00 77,000.00 0.00 0.00% 77,000.00 0.00 0.00% 2,896.51 22,324.93 1,074.71 2,000.00 2,000.00 0.00 0.00% 0.00 -2,000.00 -100.00% 9,190.37 6,849.02 2,375.10 7,100.00 6,930.00 -170.00 -2.39% 7,090.00 160.00 2.31% 11,432.89 14,947.92 4,509.30 11,200.00 11,100.00 -100.00 -0.89% 11,200.00 100.00 0.90% 9,399.96 10,200.00 4,125.00 8,250.00 8,450.00 200.00 2.42% 8,570.00 120.00 1.42% 5,907.93 10,393.20 8,554.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 3,000.00 3,900.00 1,650.00 3,300.00 3,300.00 0.00 0.00% 3,340.00 40.00 1.21% 196,814.16 248,638.96 78,948.06 178,350.00 176,280.00 -2,070.00 -1.16% 176,650.00 370.00 0.21% Category: 4200 - COMMODITIES 4200 -OFFICE SUPPLIES 430.86 220.60 127.47 1,000.00 1,000.00 0.00 0.00% 1,020.00 20.00 2.00% 4210 -OP SUPPLY -OTHER 4,733.70 3,741.89 3,852.48 6,200.00 6,200.00 0.00 0.00% 6,300.00 100.00 1.61% 4217-CLOTHING/UNIFORM 0.00 0.00 123.03 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4280 - CAPITAL OUTLAY <$5,000 769.16 3,355.61 221.82 0.00 1,000.00 1,000.00 0.00% 1,020.00 20.00 2.00% Total Category: 4200 - COMMODITIES: 5,933.72 7,318.10 4,324.80 7,200.00 8,200.00 1,000.00 13.89% 8,340.00 140.00 1.71% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 1,211.00 1,880.00 800.00 1,500.00 1,530.00 30.00 2.00% 1,560.00 30.00 1.96% 4302 - LEGAL SERVICE 0.00 5,168.50 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4305 - FEES FOR SERVICE 19,883.41 18,121.09 12,867.99 18,000.00 18,360.00 360.00 2.00% 18,730.00 370.00 2.02% 4309 - CREDIT CARD FEES 17,312.55 17,550.48 4,275.24 19,000.00 19,380.00 380.00 2.00% 19,770.00 390.00 2.01% 4310 -COMMUNICATION 6,655.49 7,124.75 2,946.91 7,000.00 7,000.00 0.00 0.00% 7,140.00 140.00 2.00% 4311 -POSTAGE 171.84 164.02 0.00 600.00 600.00 0.00 0.00% 610.00 10.00 1.67% 4321- DATA PROCESSING 17,000.04 17,578.52 8,500.02 17,000.00 18,500.00 1,500.00 8.82% 17,700.00 -800.00 -4.32% 4340 -PRINTING 2,347.56 2,499.91 429.34 2,500.00 2,500.00 0.00 0.00% 2,550.00 50.00 2.00% 4341-ADVER/PUBLISH 15,306.12 10,277.55 781.60 12,000.00 12,240.00 240.00 2,00% 12,500.00 260.00 2.12% 4350- INSURANCE CHARGE 6,000.00 6,000.00 2,500.02 5,000.00 5,000.00 0.00 0100% 5,100.00 100.00 2.00% 4360 - UTILITIES 7,991.27 7,728.03 2,902.97 8,500.00 8,500.00 0.00 0.00% 8,670.00 170.00 2.00% 4370 - MAINT-REPAIR/EQ 1,830.20 1,330.12 0.00 2,500.00 2,550.00 50.00 2.00% 2,600.00 50.00 1.96% 4371-MAINT-REPAIR/OTH 0.00 0.00 0.00 1,000.00 1,100.00 100.00 10.00% 1,120.00 20.00 1.82% 4372-MAINT-REPAIR/BLD 226.10 8,760.00 528.12 3,000.00 3,060.00 60.00 2.00% 3,120.00 60.00 1.96% 7/25/2017 2:47:22 PM Page 1 of 7 Budget Comparison Report Object 4380 - RENTAL/LEASE 4401- DUES & SUBS 4403 - TRAVEL/TRAIN/CON 4405 - CLEAN/WASTE REMV 4407 - PROPERTY TAXES 4438 - PRO/MISC RESALE 4445 - SALES TAX 4449 - OTHER CONTRACT Total Category: 4300 - CONTRACTUAL SERVICES: Category: 4500 - CAPITAL OUTLAY 4540 - OTHER CAP OUTLAY 4550 - PROJECT -CONTRACT Total Category: 4500 - CAPITAL OUTLAY: Category: 4600 - OTHER FINANCING USES 4600 - PRINCIPAL 4610 -INTEREST Total Category: 4600 - OTHER FINANCING USES: Total Department: 53 - GOLF COURSE -ADMINISTRATION: 9,600.00 69,592.50 0.00 0.00 10,135.00 0.00 100,000.00 0.00 Comparison 1 Comparison 1 0.00% 0.00% Comparison 2 Comparison 2 2.00% 0.00% 79,192.50 0.00 10,135.00 Parent Budget Budget to Parent % Budget to Comparison % 36,234.83 37,432.32 0.00 0.00 0.00 ' Budget 0.00% 0.00 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) 0.00% 2019 fall 2017 (Decrease) 0.00% Through Jun 5,948.30 6,301.53 3,132.48 6,000.00 6,000.00 0.00 0.00% 6,120.00 120.00 2.00% 1,331.14 665.91 800.91 2,000.00 2,000.00 0.00 0.00% 2,040.00 40.00 2.00% 0.00 0.00 0.00 1,000.00 2,000.00 1,000.00 100.00% 3,020.00 1,020.00 51,00% 508.56 0.00 254.28 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 970.33 971.20 974.47 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 29,587.58 28,674.90 26,911.08 30,000.00 30,000.00 0.00 0.00% 30,600.00 600.00 2.00% 2,625.21 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 0.00 325.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 136,906.70 141,121.51 68,605.43 136,600.00 140,320.00 3,720.00 2.72% 142,950.00 2,630.00 1.87% 9,600.00 69,592.50 0.00 0.00 10,135.00 0.00 100,000.00 0.00 100,000.00 0.00 0.00 0.00 0.00% 0.00% 102,000.00 0.00 2,000.00 0.00 2.00% 0.00% 79,192.50 0.00 10,135.00 100,000.00 100,000.00 0.00 0.00% 102,000.00 2,000.00 2.00% 36,234.83 37,432.32 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 1,965.67 768,18 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 38,200.50 38,200.50 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 457,047.58 435,279.07 162,013.29 422,150.00 424,800.00 2,650.00 0.63% 429,940.00 5,140.00 1.21% 7/25/2017 2:47:22 PM Page 2 of 7