Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
JAN 2018 Country Club Revenue Report
Golf 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 02301 Driving Range 07500 Golf Instruction 02303 Golf Camps/Special Events Tournament Proceeds 08310 9 hole member rounds 9 hole resident rounds 9 hole guest rounds 9 hole "walk-in" rounds cart fee 05232 walking fee 07100 greens fee 05231 Total Revenue WEATHER MAINTENANCE SALES TAX CHECK: OTHER TAXABLE ITEMS 21730 TAX CALCULATION VARIANCE T/E sales: MON 1/1/2018 29 7 2 0 6 1 19 13 6 6 89 1616.03 188.61 2671.58 4476.22 142.23 1059.82 100 5778.27 9181.35 3250 1267.8 1267.6734 0.1266 12431.35 TUE 1/2/2018 2 2 2 0 0 2 1 2 6 17 233.95 19 227.8 480.75 98.5 156.22 735.47 12 51.52 51.4829 0.0371 0 WED 1/3/2018 13 1 0 0 3 0 5 3 25 461.5 61.3 572.53 1095.33 24.95 269.16 1389.44 12 75 30 104.66 . 104.6108 0.0492 105 THURS 1/4/2018 15 5 0 0 10 1 23 6 8 4 72 1369.83 104.29 2155.7 3629.82 512.45 405.79 4548.06 12 325 141.76 30 690 401.63 401.4374 0.1926 1186.76 FRI 1/5/2018 31 4 1 1 8 0 20 14 11 2 92 1449.72 278.44 2518.08 4246.24 324.34 708.41 5278.99 130 50.74 2255 540.22 540.0311 0.1889 2435.74 SAT 1/6/2018 44 9 0 2 14 3 51 15 5 3 146 2938.98 217.6 5336.84 8493.42 338.52 1990.07 150 10972.01 13 265 85.95 3820 1049.79 1049.5072 0.2828 4170.95 SUN 1/7/2018 45 9 0 0 5 0 46 9 7 4 125 2443.61 237.67 4035.05 6716.33 396.74 729.25 550 8392.32 155 560.08 559.8124 0.2676 155 MON 1/8/2018 22 47 0 1 4 4 17 2 5 102 1550.89 161.52 1465.44 3177.85 165.39 246.73 560 4149.97 13538.77 1199.17 1199.0118 0.1582 13538.77 TUE 1/9/2018 27 13 0 1 4 5 11 2 4 67 1310.19 61.3 1266.44 2637.93 122.39 1010.28 110 -304 3576.6 1 130 273.14 273.042 0.098 130 WED 1/10/2018 41 10 2 1 9 5 15 18 2 4 107 1848.13 227.63 2343.4 4419.16 280.87 809.34 200 5709.37 1 8127.25 954.74 954.5634 0.1766 8127.25 THURS 1/11/2018 58 15 0 0 10 3 48 14 3 9 160 3226.37 185.26 4227.3 7638.93 550.02 656.08 150 8995.03 11531.7 1426.68 1426.3711 0.3089 11531.7 FRI 1/12/2018 53 10 1 2 13 3 46 9 3 3 143 2815.91 307.73 4613.54 7737.18 543.53 1306.14 410 9996.85 4 14352.12 1676.05 1675.7279 0.3221 14352.12 SAT 1/13/2018 40 8 2 5 6 1 25 14 12 8 121 3129.78 200.4 5228.04 8558.22 643.6 521.92 575 10298.74 680.98 680.6618 0.3182 0 SUN 1/14/2018 46 7 2 0 13 1 43 21 4 12 149 2173.38 244.1 3275.47 5692.95 99.06 1920.69 0 7712.7 110 547.77 547.589 0.181 110 MON 1/15/2018 41 12 3 1 3 5 35 9 6 1 116 2170.07 196.86 3293.63 5660.56 502.1 482.24 45 170 6859.9 3 260 483.61 483.343 0.267 260 TUE 1/16/2018 44 13 5 1 10 3 56 17 1 5 155 3316.98 114.11 4862.03 8293.12 206.21 551.58 305 9355.91 175 646.19 645.8137 0.3763 175 WED 1/17/2018 36 10 2 3 9 11 43 14 12 140 2701.32 229.17 4296.01 7226.5 305.4 2381.99 225 238.9 10377.79 204 60 45 715.9 715.6023 0.2977 309 THURS 1/18/2018 19 8 3 0 6 2 49 12 2 8 109 2455.17 49.04 4016.88 6521.09 490.54 492.48 225 7729.11 12 69.72 530.45 530.1681 0.2819 69.72 FRI 1/19/2018 49 15 1 2 12 0 41 9 1 15 145 2822.12 307.18 4632.03 7761.33 119.92 615.94 150 8647.19 162.5 606.48 606.1783 0.3017 162.5 SAT 1/20/2018 51 6 5 1 32 0 60 4 5 7 171 3767.77 250.17 6726.25 10744.19 201.92 2697.82 385 14028.93 195 45 972.27 971.8751 0.3949 240 SUN 1/21/2018 48 9 0 5 14 0 34 9 5 2 126 2420.25 229.64 3802.14 6452.03 121.13 770.81 7343.97 514.27 514.0779 0.1921 0 MON 1/22/2018 33 18 7 4 8 5 45 17 1 13 151 3043.79 193.61 5321.04 8558.44 319.23 1788.96 400 150 11216.63 45 155 2255 918.83 918.5141 0.3159 2455 TUE 1/23/2018 46 16 1 4 8 4 25 14 1 1 120 2246.61 150.62 3182.94 5580.17 155.77 556.61 350 6642.55 155 451.52 451.3285 0.1915 155 WED 1/24/2018 48 6 3 3 18 12 21 11 4 126 2307.76 281.98 3892.11 6481.85 346.96 1889.72 8718.53 175 97.88 4350 108.9 941.8 941.5217 0.2783 4731.78 THURS 1/25/2018 59 14 14 1 22 3 24 14 4 7 162 3181.85 217.86 4189.74 7589.45 220.49 1300.47 9110.41 5 30 7600 1172.16 1171.8287 0.3313 7630 FRI 1/26/2018 47 5 6 0 26 1 42 6 5 10 148 3062.53 249.92 6408.89 9721.34 360.03 1276.96 0 11358.33 5 265 813.98 813.6331 0.3469 265 SAT 1/27/2018 39 20 3 3 1 5 61 10 3 12 157 3134.41 277.41 6311.21 9723.03 839.54 1428.7 175 12166.27 5 390 45 870.08 869.8389 0.2411 435 SUN 1/28/2018 40 8 3 2 8 0 49 12 6 7 135 2798.45 201.57 5620.74 8620.76 339.2 700.93 650 10310.89 195 690.17 689.9123 0.2577 195 MON 1/29/2018 27 11 2 0 10 3 28 10 1 10 102 2101.8 112.84 3575.26 5789.9 249.81 1501.87 7541.58 65 30 534.8 534.5606 0.2394 95 TUE 1/30/2018 64 9 5 1 12 4 10 11 4 2 122 2198.79 247.7 2440.15 4886.64 177.8 1495.76 50 6610.2 5 459.39 459.214 0.176 0 WED 1/31/2017 44 10 2 2 11 6 35 12 2 5 129 2392.35 273.17 4267.98 6933.5 238.24 669.15 110 7950.89 2 11.7 65 554.5 554.2313 0.2687 76.7 Monthly Total 1201 337 77 46 315 93 1028 333 119 0 0 180 3729 72690.29 6077.7 116776.24 195544.23 9436.88 32391.89 4990 0 1139.9 243502.9 90 2 22610.63 22603.1638 7.4662 2 49 14 6 4 8 2 43 21 4 8 2909.31 332.49 5802.86 538.73 2190.83 275 130 30 835.7 835.3954 0.3046 3 57 8 2 1 15 1 41 13 4 3 2910.51 206.39 5275.46 396.1 996.7 725 110 692.89 692.6612 0.2288 4 48 13 6 2 3 0 46 16 5 11 2988.65 247.89 5464.18 537.39 723.89 45 130 706.7 706.44 0.26 5 35 16 6 1 5 3 33 11 1 16 2390.92 252.42 3868.36 167.98 1711.57 55 65 15 593.26 592.9875 0.2725 6 53 13 5 3 8 7 22 19 2 4 2688.75 122.06 3570.76 238.82 1924.26 310 90 604.6 604.4255 0.1745 7 46 10 4 2 21 5 45 22 3 3088.4 302.73 5804.88 263.27 700.47 265 90 717.84 717.4825 0.3575 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 Total Total # of Rounds Adopted Budget 655902 543599 37630 287150 202050 7560 3420 0 100000 100000 238524 0 3000 2178835 25044 Year-To-Date 313263.16 263809.64 17786.18 281063.28 176821.32 4200 3800 -297 39590.48 29790 100047.02 0 2480.8 1232354.88 13298 % 0.477606654652677 0.485301922924803 0.472659580122243 0.978802994950374 0.875136451373423 0.555555555555556 0 0 0.3959048 0.2979 0.419442152571649 - 0.826933333333333 0.56560266380887 0.530985465580578 Golf Green Fees Golf Cart Rental Fee Walking Fee Golf Merchandise Driving Range (No Lease-Golf incl.) Lessons Camps/Special Events Membership-Resident Membership-Non Resident Membership-Junior Membership-Business Membership - Summer Tournament Proceeds Total Rounds # OF UNPLAYABLE HOURS Adopted Budget 913172 874771 53818 185000 304953 140000 356290 223400 4500 9200 38245 3000 3106349 October 40044.16 52851.09 2292.6 7652.13 16821.42 4245 182999.6 99149.87 3600 3800 -297 460 2711 33.75 November 65590.11 71238.27 4337.58 9951.59 23397.62 14005 51989 36408.78 300 0 0 710.4 3431 18.5 December 90852.65 67029.99 5078.3 12549.88 27436.09 6550 18188.57 7782.19 300 0 0 170.5 3427 10 January 116776.24 72690.29 6077.7 9436.88 32391.89 4990 27886.11 33480.48 0 0 0 1139.9 3729 92 February March April May June July August September 0 Year-to-Date 313263.16 263809.64 17786.18 39590.48 100047.02 29790 0 281063.28 176821.32 4200 3800 -297 2480.8 0 1232354.88 13298 PER MUNIS 313263.16 263809.64 17786.18 39590.48 100047.02 29790 281063.28 176821.32 4200 3800 -297 2480.8 1232354.88 DIFF 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 2012-2013 Actual 2913 3586 3403 4229 4196 4779 3814 3612 3397 3463 3625 2876 43893 2013-2014 Actual 3126 3252 3682 4094 4647 4947 4006 4377 2673 2952 3798 2251 43805 2014-2015 Actual 3119 3413 3669 4549 4227 5002 4012 4151 2903 2738 2694 2457 42934 2015-2016 Actual 3067 3380 3287 3933 4511 4685 4409 4136 3004 3131 2397 2475 42415 2016-2017 Actual 2592 3564 3576 4426 4824 5054 4180 3983 2746 2805 2656 1573 41979 Projected 2634 3107 3160 3872 4069 4422 3780 0 0 0 0 0 25044 2017-2018 Actual 2711 3431 3427 3729 13298 Difference 77 324 267 -143 0 0 0 0 0 0 0 0 525 Revenues Clear Channel Summer Recipr Industry Rate Golf Revenues Golf Merchandise Golf Instruction Camps/Special Events Membership-Resident Membership-Non Resident Membership - Summer Membership - Business Membership-Junior Tournament Proceeds Food & Beverage Revenue greens fee cart fee walking fee Range Add to 18 Hole Member Add to 18 Hole resident rounds Add to 18 Hole Member L2246-02301 L2246-02303 & L0000-20223/20224/20225 L2246-02341 L2100-05231 L2100-05232 L2100-06621 L2100-06622 L2100-06623 L2100-06625 L2100-06683 L2100-07100 L3200-07500 L2100-08310 L3253- PLUS GRIPS L0000-20228 & L0000-20227 D- & C+ ***L2100:L3700 YTD EXPENDED THRU CURRENT MONTH