Loading...
MARCH 2018 Country Club Revenue ReportGolf 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: THURS 3/1/2018 63 10 5 4 20 4 34 13 2 14 169 3665.98 184.58 5075.52 8926.08 426.12 767.6 90 10209.8 14851.4 4853.9 110.32 240 2112.62 2112.2794 0.3406 FRI 3/2/2018 60 14 1 2 16 3 64 23 5 13 201 3832.34 347.74 7977.77 12157.85 908.99 2200.18 15267.02 899.72 1132.08 1131.6718 0.4082 SAT 3/3/2018 48 8 1 0 22 1 67 0 8 11 166 3713.6 189.83 7595.13 11498.56 457.03 965.28 200 13120.87 195 918.46 918.1109 0.3491 SUN 3/4/2018 52 9 2 1 17 1 29 21 6 27 165 3428.01 216.88 5770.54 9415.43 1142.83 820.83 11379.09 200 810.84 810.5363 0.3037 MON 3/5/2018 37 52 0 4 12 11 22 13 1 4 156 2372.79 232.97 3459.02 6064.78 431 669.6 200 540 7905.38 155 512.62 512.4266 0.1934 TUE 3/6/2018 44 12 6 1 12 6 57 15 2 29 184 4172.87 113.79 6974.83 11261.49 1225.07 2905.27 15391.83 975 1146.14 1145.6781 0.4619 WED 3/7/2018 28 12 2 1 12 6 18 20 4 16 119 2264.92 167.06 3705.99 6137.97 513.31 534.13 150 -631 6704.41 220 3410 757.36 757.0787 0.2813 THURS 3/8/2018 56 8 4 1 17 1 32 27 3 14 163 3317.15 191.85 5241.9 8750.9 642.59 747.4 250 10390.89 260 15 729.4 729.1123 0.2877 FRI 3/9/2018 46 12 4 1 13 6 51 13 0 30 176 3560.68 312.17 7339.67 11212.52 340.24 3356.52 170 15079.28 199.72 1057.96 1057.63 0.33 SAT 3/10/2018 54 9 0 2 18 2 44 14 3 8 154 3204.83 175.88 6132.78 9513.49 560.22 1341.79 200 11615.5 130 808.44 808.185 0.255 SUN 3/11/2018 40 11 3 1 7 15 24 16 2 8 127 2227.32 171.64 4116.8 6515.76 323.25 703.25 7542.26 200 542.11 541.9582 0.1518 MON 3/12/2018 26 9 0 1 3 3 35 7 2 6 92 1859.53 111.57 3427.98 5399.08 457.53 652.52 100 110 6719.13 130 464.96 464.7391 0.2209 TUE 3/13/2018 49 16 6 1 14 1 32 14 14 147 3007.9 180.13 4480.78 7668.81 316.47 1112.59 150 49.95 9297.82 285 657.1 656.8009 0.2991 WED 3/14/2018 35 13 2 1 13 13 52 19 3 22 173 3494.8 233.89 6620.65 10349.34 793.14 3568.36 250 14960.84 650 1075.66 1075.2588 0.4012 THURS 3/15/2018 49 17 4 0 11 1 48 31 2 13 176 3485.27 221.31 6048.95 9755.53 919.44 1703.73 100 12478.7 440 3410 1136.36 1136.009 0.351 FRI 3/16/2018 40 26 2 3 19 2 60 13 7 8 180 3463.65 276.3 7390.06 11130.01 669.55 744.91 230 12774.47 325 -233.65 884.79 884.5074 0.2826 SAT 3/17/2018 79 9 1 0 17 0 33 12 5 4 160 2930.75 375.27 4758.68 8064.7 907.2 2607.63 200 11779.53 549.72 849.26 849.0475 0.2125 SUN 3/18/2018 49 9 5 0 11 2 56 10 3 15 160 3431.19 209.37 6658.06 10298.62 340.09 906.9 11545.61 808.47 808.1927 0.2773 MON 3/19/2018 29 10 6 4 11 8 45 14 8 13 148 2907.55 211.42 5608.02 8726.99 296.9 998.87 190 1050 11262.76 702 701.5932 0.4068 TUE 3/20/2018 47 9 3 5 11 8 41 21 4 1 150 2975.95 154.35 4928.01 8058.31 414.43 758.17 9230.91 646.45 646.1637 0.2863 WED 3/21/2018 33 6 0 0 69 7 9 2 1 127 3030.32 39.28 3255.14 6324.74 1323.88 2849.9 250 50 10798.52 179.72 748.1 747.4768 0.6232 THURS 3/22/2018 49 9 4 2 11 5 56 25 2 11 174 3724.45 169.61 6638.74 10532.8 695.72 1745.18 -50 12923.7 370 4510 1250.13 1249.759 0.371 FRI 3/23/2018 47 9 3 6 13 0 62 21 8 6 175 3424.97 306.9 7551.2 11283.07 418.93 964.49 0 12666.49 404.72 300 21.75 937.79 937.5072 0.2828 SAT 3/24/2018 48 13 1 3 22 1 48 12 1 7 156 3193.8 246.83 6342.92 9783.55 564 995.37 125 11467.92 394.72 821.88 821.6348 0.2452 SUN 3/25/2018 68 13 4 1 3 4 28 10 11 142 2631.6 339.51 3560.49 6531.6 350.95 888.03 7770.58 117 204.44 566.64 566.4414 0.1986 MON 3/26/2018 30 15 1 2 11 7 23 12 5 8 114 2061.98 177.1 3523.82 5762.9 206.07 2809.35 50 120 8948.32 99 155 632.48 632.2624 0.2176 TUE 3/27/2018 48 13 3 4 7 6 26 10 5 122 2378.58 122.34 3303.4 5804.32 305.78 768.49 550 7428.59 65 486.24 486.0513 0.1887 WED 3/28/2018 58 10 5 2 14 7 25 14 5 8 8 156 2715.18 340.74 4214.52 7270.44 685.39 792.96 250 8998.79 3609.72 865.47 865.0957 0.3743 THURS 3/29/2018 54 10 5 2 9 3 24 7 2 6 122 2305.44 267.18 3194.78 5767.4 232.55 2557.94 75 -625 8007.89 264.72 617.83 617.5827 0.2473 FRI 3/30/2018 54 15 4 1 7 1 45 17 7 11 162 2924.65 413.74 5730.56 9068.95 534.17 933.15 0 -75 10461.27 220 753.25 752.9389 0.3111 SAT 3/31/2018 61 6 3 0 13 1 38 8 9 4 143 2706.56 292.45 4728.31 7727.32 651.41 885.98 350 9614.71 128.88 657.82 657.5513 0.2687 Monthly Total 1481 394 90 56 455 136 1228 454 115 0 8 342 4759 94306.81 6993.68 165143.02 266763.31 18054.25 44256.37 4130 0 538.95 333742.88 0 0 26090.71 9.4289 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 633760.39 447382.72 30767.5 302843.68 184380.56 4500 3800 -297 70912.22 48502.5 186471.23 0 5995.78 1919019.58 22472 % 0.966242502690951 0.823001366816348 0.817632208344406 1.05465324743166 0.912549170997278 0.595238095238095 0 0 0.7091222 0.485025 0.78177135214905 - 1.99859333333333 0.880754889654334 0.897300750678805 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 0 March 165143.02 94306.81 6993.68 18054.25 44256.37 4130 22520.87 4853.9 300 538.95 4759 0 April May June July August September 0 Year-to-Date 633760.39 447382.72 30767.5 70912.22 186471.23 48502.5 0 302843.68 184380.56 4500 3800 -297 5995.78 0 1919019.58 22472 154.25 PER MUNIS 633760.39 447382.72 30767.5 70912.22 186471.23 48502.5 302843.68 184380.56 4500 3800 -297 5995.78 1919019.58 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 22472 Difference 77 324 267 -143 346 337 0 0 0 0 0 0 1208 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