Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
APRIL 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: SUN 4/1/2018 28 7 1 2 3 1 8 5 3 58 984.29 136.6 1241.39 2362.28 234.31 392.52 2989.11 209.3 209.2377 0.0623 MON 4/2/2018 37 17 0 3 6 6 34 18 6 8 135 2406.79 279.17 2876.96 5562.92 499.23 807.74 50 160 7079.89 159.72 492.36 492.0727 0.2873 TUE 4/3/2018 47 11 3 0 9 4 26 7 4 16 127 2643.53 176.64 2522.22 5342.39 417.35 829.91 200 -181 6608.65 130 470.63 470.3755 0.2545 WED 4/4/2018 38 12 1 3 14 10 20 20 3 12 15 148 2513.05 244.66 3121.96 5879.67 546.98 4170.45 100 10697.1 1 355 767 766.647 0.353 THURS 4/5/2018 52 12 5 8 6 3 39 11 8 144 2812.44 196.16 3035.69 6044.29 12.88 770.53 30 6857.7 199.72 492.19 491.9194 0.2706 FRI 4/6/2018 43 14 6 1 7 2 70 17 1 12 173 3618.58 294.87 5801.23 9714.68 1323.1 1064.63 12102.41 310 869.29 868.8687 0.4213 SAT 4/7/2018 44 5 0 0 17 1 45 9 11 5 137 2928.62 153.86 4186.57 7269.05 463.61 717.9 100 8550.56 65 596.48 596.0892 0.3908 SUN 4/8/2018 41 9 1 1 5 2 49 4 4 116 2398.84 186.59 3590.16 6175.59 495.22 2781.92 100 9552.73 1 1150 742.34 742.1911 0.1489 MON 4/9/2018 29 63 1 2 4 10 17 7 2 135 1951.45 215.72 1563.2 3730.37 505 594.39 300 480 5609.76 195 351.9 351.7332 0.1668 TUE 4/10/2018 42 15 3 0 12 5 15 5 6 103 2045.46 135.81 1776.15 3957.42 266.75 302.8 30 346.3 4903.27 5 317.06 316.8879 0.1721 WED 4/11/2018 35 9 1 2 13 7 62 9 2 11 10 161 3310.78 213.14 4285.56 7809.48 1305.56 912.51 150 10177.55 1954.72 839.13 838.7589 0.3711 THURS 4/12/2018 72 15 2 3 18 1 35 13 1 11 171 3309.61 361.21 3144.89 6815.71 411.49 895.88 500 8623.08 45 572.07 571.7656 0.3044 FRI 4/13/2018 49 14 3 1 7 1 26 8 4 3 116 2187.88 312.17 2530.9 5030.95 401.95 969.04 80 6481.94 260 466.61 466.3358 0.2742 SAT 4/14/2018 49 5 0 2 22 0 26 16 5 13 138 2840.97 215.42 3641.72 6698.11 537.57 1945.79 150 9331.47 240 659.85 659.5029 0.3471 SUN 4/15/2018 33 19 1 1 2 3 18 8 8 5 98 1515.05 273.8 1797.42 3586.27 233 622.43 200 4641.7 311.03 310.919 0.111 MON 4/16/2018 20 19 0 4 5 7 29 6 6 5 101 1892.01 135.06 672.4 2699.47 421.28 641.56 1710 -730.3 4742.01 195 277.26 277.0117 0.2483 TUE 4/17/2018 60 8 1 1 13 4 37 7 1 14 146 3049.88 209.37 965.04 4224.29 1019.13 768.22 1092.5 309.9 7414.04 69.72 425.98 425.6952 0.2848 WED 4/18/2018 14 12 0 0 3 9 13 15 3 12 5 86 1390.15 105.08 669.49 2164.72 1701.09 3570.18 -30 -484 6921.99 45 523.92 523.6693 0.2507 THURS 4/19/2018 41 9 0 0 8 5 27 13 3 106 2004.32 197.11 746.88 2948.31 748.76 581.67 4278.74 130 308.82 308.6118 0.2082 FRI 4/20/2018 32 13 2 3 5 2 22 21 5 7 112 2130.38 210.38 1131.97 3472.73 1001.13 728.97 -40 5162.83 65 368.95 368.7481 0.2019 SAT 4/21/2018 50 5 0 0 9 -1 39 11 4 6 123 2471.7 231.41 1448.59 4151.7 796.07 592.13 150 5689.9 1 110 395.72 395.493 0.227 SUN 4/22/2018 23 8 0 1 4 0 13 5 10 1 65 1208.15 92.29 559.94 1860.38 254.26 437.38 2552.02 5 36 181.25 181.1614 0.0886 MON 4/23/2018 8 15 0 0 2 2 13 11 3 54 795.96 122.01 399.42 1317.39 96.36 224.3 325 1963.05 1 114.75 114.6635 0.0865 TUE 4/24/2018 36 16 2 0 8 5 6 16 89 1556.93 107.52 417.1 2081.55 489.9 300.67 2872.12 6 65 205.69 205.5984 0.0916 WED 4/25/2018 29 20 0 0 7 10 22 7 4 7 6 112 1833.72 196.3 774.48 2804.5 713.05 2235 500 6252.55 4.72 3250 630.77 630.5089 0.2611 THURS 4/26/2018 29 9 5 0 9 2 18 12 3 1 88 1636.87 137.09 605.94 2379.9 371.6 607.66 50 3409.16 180 247.94 247.7412 0.1988 FRI 4/27/2018 46 9 0 1 7 5 14 6 1 1 90 1594.3 233.89 722.17 2550.36 324.96 252.34 160 3287.66 219.08 218.9362 0.1438 SAT 4/28/2018 35 12 0 0 9 3 9 11 8 10 97 1659.23 197.55 765.09 2621.87 1263.19 529.15 0 4414.21 2448.58 480.55 480.3953 0.1547 SUN 4/29/2018 39 9 0 1 3 1 7 4 3 3 70 1153.35 193.08 353.83 1700.26 338.48 667.29 2706.03 189.5 189.4221 0.0779 MON 4/30/2018 27 14 0 0 8 3 4 4 1 61 1013.39 168.82 218.88 1401.09 508.71 432.31 2390 165 4897.11 164.04 163.9477 0.0923 0 Monthly Total 1128 405 38 40 245 113 763 306 105 0 42 175 3360 62857.68 5932.78 55567.24 124357.7 17701.97 30347.27 8297.5 0 65.9 180770.34 20 0 12891.46 6.5516 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 689327.63 510240.4 36700.28 302843.68 185787.41 4500 3800 -297 88614.19 56800 216818.5 0 6061.68 2101196.77 25832 % 1.05096131739193 0.938633809112967 0.975293117193728 1.05465324743166 0.919512051472408 0.595238095238095 1.11111111111111 0 0.8861419 0.568 0.909000771410843 - 2.02056 0.964367090670014 1.03146462226481 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 23431.26 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 - - - 1139.9 3729 92 February 155354.21 89266.27 5987.64 13267.49 42134.2 14582.5 -740.47 2705.34 2976.03 4415 3 March 165143.02 94306.81 6993.68 18054.25 44256.37 4130 22520.87 4853.9 300 538.95 4759 2 April 55567.24 62857.68 5932.78 17701.97 30347.27 8297.5 1406.85 65.9 3360 20 May June July August September 0 Year-to-Date 689327.63 510240.4 36700.28 88614.19 216818.5 56800 0 302843.68 185787.41 4500 3800 -297 6061.68 0 2101196.77 25832 179.25 PER MUNIS 689327.63 510240.4 36700.28 88614.19 216818.5 56800 302843.68 185787.41 4500 3800 -297 6061.68 2101196.77 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 4415 4759 3360 25832 Difference 77 324 267 -143 346 337 -420 0 0 0 0 0 788 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