Loading...
NOVEMBER 2012 Country Club Revenue Report.xlsGolf Rounds Revenues 18 hole member rounds 18 hole resident rounds 18 hole guest rounds 18 hole "walk-in" rounds Junior Tournament Rounds League Play 18 Hole Twilight Total Rounds Golf Revenues Total Golf Revenues Golf Merchandise Driving Range Golf Instruction Golf Camps/Special Events Tournament Proceeds Food & Beverage Revenue 9 hole member rounds 9 hole resident rounds 9 hole guest rounds 9 hole "walk-in" rounds cart fee walking fee greens fee Total Revenue WEATHER THU 11/1/2012 53 12 3 0 17 2 24 8 3 7 129 2530 166 1351.4 4047.4 249.37 311.32 80 1207.77 5895.86 nice FRI 11/2/2012 42 11 1 0 14 2 43 13 1 8 135 2696 172 2633.95 5501.95 274.87 902.83 180 1072.15 7931.8 nice SAT 11/3/2012 41 5 1 0 23 4 28 5 4 5 116 2304 156 2203 4663 423.29 647.17 160 862.52 6755.98 nice SUN 11/4/2012 43 8 2 1 10 2 43 11 3 6 129 2580 156 2531.25 5267.25 243 506.61 90 2102.19 8209.05 nice MON 11/5/2012 39 35 1 1 6 3 27 13 4 0 129 2196 152.5 1245.85 3594.35 212.62 406.6 190 310 1367.43 6081 nice TUE 11/6/2012 55 7 1 0 9 2 39 7 6 2 128 2316 231.5 1607 4154.5 360.63 504.72 500 85 1335.71 6940.56 nice WED 11/7/2012 37 6 6 1 6 4 30 1 0 3 94 1976 86 1327.05 3389.05 268.17 492.48 0 1090.85 5240.55 cool THU 11/8/2012 61 12 0 5 8 0 33 8 0 3 130 2416 220 1424.65 4060.65 165.41 685.85 220 2122.37 7254.28 nice FRI 11/9/2012 53 11 3 1 19 0 47 16 3 12 165 3240 227.5 3071.55 6539.05 559.9 707.56 265 1067.9 9139.41 nice SAT 11/10/2012 41 11 1 0 30 0 53 5 19 2 162 3076 238.5 3442.15 6756.65 534.72 953.77 515 2528.42 11288.56 nice SUN 11/11/2012 46 12 4 1 11 0 42 7 4 2 129 2638 140 2344 5122 732.82 554.72 45 1575.93 8030.47 nice MON 11/12/2012 38 7 0 0 6 0 24 10 0 5 90 1756 134 2013.5 3903.5 397.19 486.8 110 569.24 5466.73 nice TUE 11/13/2012 60 12 2 2 6 1 19 1 1 7 111 2056 213.5 1442.75 3712.25 273.89 516.05 0 105 2325.64 6932.83 nice WED 11/14/2012 45 7 3 4 8 5 35 9 2 5 123 2622 67 2541.4 5230.4 181.01 329.25 375 -318 3296.4 9094.06 nice THU 11/15/2012 62 10 0 2 15 0 34 8 1 4 136 2726 198.5 2448.05 5372.55 135.3 702.83 770 2242.86 9223.54 nice FRI 11/16/2012 57 6 1 0 18 0 20 8 8 118 2466 115 2388.75 4969.75 200.49 496.23 788 1181.04 7635.51 cloudy SAT 11/17/2012 38 11 2 1 6 3 9 8 1 2 81 784 309.5 1318.4 2411.9 50.95 1046.24 480 8808.45 12797.54 rain SUN 11/18/2012 49 9 0 1 7 0 38 14 4 2 124 2358 192.5 3018.5 5569 160.3 694.35 140 1080.79 7644.44 windy MON 11/19/2012 50 9 0 0 8 0 24 7 7 1 106 2230 75.5 1612.5 3918 262.66 364.15 135 -205.95 1938.2 6412.06 nice/ cool&windy TUE 11/20/2012 57 8 3 0 7 2 18 7 3 5 110 2098 165 1614.8 3877.8 263.7 356.6 95 834.85 5427.95 cool&windy WED 11/21/2012 41 13 5 4 8 5 27 16 8 13 140 2762 84 2668.4 5514.4 422.09 450.95 732.6 7120.04 nice THU 11/22/2012 24 4 1 0 5 0 21 3 5 63 1332.5 84 1622.82 3039.32 223.85 610.38 45 4982.57 8901.12 nice FRI 11/23/2012 44 7 1 2 14 4 64 11 3 10 160 3540 103 5053.15 8696.15 361.17 930.2 90 1454.86 11532.38 nice SAT 11/24/2012 53 10 0 1 15 6 22 10 2 2 121 2262 160.5 2498.2 4920.7 399.89 735.87 210 1005.26 7271.72 nice SUN 11/25/2012 40 17 0 0 5 2 19 16 2 14 115 2140 120 2277.85 4537.85 280.23 668.86 1061.6 6548.54 nice MON 11/26/2012 42 15 3 2 10 5 45 3 2 3 130 2624 141 2958.5 5723.5 300.39 490.57 100 -228 875.89 7262.35 nice TUE 11/27/2012 54 6 2 0 3 0 9 8 5 87 1582 158 961.75 2701.75 162.26 301.89 80 95 604.26 3945.16 nice WED 11/28/2012 38 12 2 7 10 7 13 0 8 97 1886 74 1488.8 3448.8 510.62 533.96 110 1368.77 5972.15 nice THU 11/29/2012 60 11 0 0 10 0 20 2 0 103 2004 141 1297.5 3442.5 231.99 530.19 265 3694.96 8164.64 nice FRI 11/30/2012 39 12 1 1 14 5 38 9 2 4 125 2526 107 3350.6 5983.6 433.42 644.34 770 3417.41 11248.77 nice 0 0 0 Monthly Total 1402 316 49 37 328 64 908 244 90 0 0 148 3586 69722.5 4589 65758.07 140069.57 0 9276.2 17563.34 6573 0 78.05 57808.89 231369.05 Golf Green Fees Golf Cart Rental Fee Walking Fee Golf Merchandise Driving Range Lessons Camps/Special Events Membership-Resident Membership-Non Resident Membership-Junior Membership-Business Membership - Summer Tournament Proceeds Food & Beverage Revenue Total Rounds # OF RAINY/LIGHTING DAYS % OF RAINY/LIGHTING DAYS Adopted Budget 912480 939400 37520 140150 209026 100000 4000 345870 229900 3600 0 44210 2716 821300 3790172 1 0.032258064516129 October 39938.56 57087.55 2414.5 8336.08 12251.09 8165 226984.47 129560.98 2400 3750 287.08 32197.03 523372.34 2913 November 65758.07 69722.5 4589 9276.2 17563.34 6573 25089.36 13544.32 1173.76 78.05 57808.89 271176.49 3586 December 0 January 0 February 0 March 0 April 0 May 0 June 0 July 0 August 0 September 0 Year-to-Date 105696.63 126810.05 7003.5 17612.28 29814.43 14738 0 252073.83 143105.3 3573.76 3750 0 365.13 90005.92 0 794548.83 6499 PER MUNIS 105696.63 126810.05 7003.5 17612.28 29814.43 14738 252073.83 143105.3 3573.76 3750 365.13 90005.92 794548.83 DIFF 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 YEAR-TO-DATE SUMMARY Golf Green Fees Golf Cart Rental Fee Walking Fee Membership-Resident Membership-Non-Resident Membership-Junior Membership-Business Membership - Summer Golf Merchandise Golf Lessons Driving Range Camps Tournament Proceeds Food & Beverage Revenue Total Total # of Rounds Adopted Budget 912480 939400 37520 345870 229900 3600 0 44210 140150 100000 209026 4000 2716 821300 3790172 48000 Year-To-Date 105696.63 126810.05 7003.5 252073.83 143105.3 3573.76 3750 0 17612.28 14738 29814.43 0 365.13 90005.92 794548.83 6499 % 0.115834462125197 0.134990472642112 0.186660447761194 0.72881091161419 0.622467594606351 0.992711111111111 0 0 0.125667356403853 0.14738 0.142635031048769 0 0 0.109589577499087 0.209633977033232 0.135395833333333 Month October November December January February March April May June July August September TOTAL 2006-2007 Course Renovation & Start-up closed 1925 4813 5597 5305 5728 4825 4251 3863 4118 4185 3430 48040 2007-2008 Actual 3322.5 4733 4007 4644.5 5291.5 5545.5 4931.5 4921.5 3539.5 4334 3838 3209.5 52318 2008-2009 Actual 3667 4084.5 3917 4818.5 4598 4847.5 4960.5 4545 3853.5 4057 3999 3562 50909.5 2009-2010 Actual 3820 4188 3866 4518 4538 4769 4577 4999 4021 4144 3635 3135 50210 2010-2011 Actual 3352 3963 2933 4330 4552 4856 4316 4098 3174 3485 3197 2716 44972 2011-2012 Actual 3036 3797 3521 4201 4364 4836 3946 4075 3414 3723 2927 3305 45145 Projected 3500 4000 3500 4250 4500 4750 4500 4500 3750 3750 3750 3250 48000 2012-2013 Actual 2913 3586 0 0 0 0 0 0 0 0 0 0 6499 Difference -587 -414 -3500 -4250 -4500 -4750 -4500 -4500 -3750 -3750 -3750 -3250 -41501 Revenues Golf Revenues Tournament Proceeds Golf Merchandise Golf Instruction Driving Range Food & Beverage Revenue Membership-Resident Membership-Non Resident Membership-Junior Membership - Summer Membership - Business Camps/Special Events greens fee cart fee walking fee L2100-05231 L2100-05232 L2100-07100 L2100-08310 L2246-02301 L2246-02303 & L0000-20223/20224/20225 L3200-07500 L3253- L2100-06621 L2100-06622 L2100-06683 L2100-06623 L2100-06625 L2246-02341 D- & C+ PLUS GRIPS L0000-20228 & L0000-20227 ***L2100-L3700