Loading...
12 June 2018 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2017 – June 2018 TABLE OF CONTENTS Summary Operating Income Expense 1 Statement of Fee Revenue 2 Variance Report 3 Golf Shop Income Statement 4 Course Maintenance Expense Statement 5 Outside Service Expense Statement 7 Clubhouse Expense Statement 8 Marketing Expense Statement 9 General & Administrative Expense Statement 10 Operating Leases & Miscellaneous Expense Statement 12 Complimentary Report 13 Annual BudgetAccount Description JuneFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue135,648.75 154,963.00 (19,314.25) -12.5% 3,061,509.93 3,270,481.00 (208,971.07) 3,270,479.00 208,969.07 94%401000 Miscellaneous Golf Revenue10,663.00 20,770.00 (10,107.00) -48.7% 290,542.00 332,068.00 (41,526.00) 332,066.00 41,524.00 87%410000 Revenue-Golf Shop11,970.28 14,700.00 (2,729.72) -18.6% 235,046.00 262,015.00 (26,969.00) 262,017.00 26,971.00 90%420000 Revenue-F&B Concession500.00 500.00 - 0.0% 12,000.00 12,000.00 - 12,000.00 - 100%890000 Interest Income0.04 - 0.04 0.51 - 0.51 - (0.51) 0%Total Income158,782.07 190,933.00 (32,150.93) -16.8% 3,599,098.44 3,876,564.00 (277,465.56) 3,876,562.00 277,463.56 93%Cost of Goods Sold510000 COS-Golf Shop6,510.03 8,228.00 (1,717.97) 20.9% 136,440.70 146,649.70 10,209.00 146,651.00 10,210.30 93%Total COS6,510.03 8,228.00 (1,717.97) 20.9% 136,440.70 146,649.70 10,209.00 146,651.00 10,210.30 93%Gross Profit152,272.04 182,705.00 (30,432.96) -16.7% 3,462,657.74 3,729,914.30 (267,256.56) 3,729,911.00 267,253.26 93%Expenses610000 Golf Pro Shop 19,703.67 17,466.00 2,237.67 -12.8% 206,675.93 199,989.00 6,686.93 199,990.00 (6,685.93) 103%630000 Course Maintenance132,473.88 139,249.66 (6,775.78) 4.9% 1,672,699.69 1,735,790.00 (63,090.31) 1,735,790.00 63,090.31 96%633000 Maintenance Water & Energy28,721.87 30,969.00 (2,247.13) 7.3% 234,268.23 249,838.00 (15,569.77) 249,838.00 15,569.77 94%640000 Outside Services37,231.36 20,041.00 17,190.36 -85.8% 363,114.54 331,962.00 31,152.54 331,964.00 (31,150.54) 109%650000 Clubhouse9,973.06 11,176.00 (1,202.94) 10.8% 134,388.76 136,412.00 (2,023.24) 136,412.00 2,023.24 99%660000 Marketing9,114.76 10,328.00 (1,213.24) 11.7% 225,212.44 230,959.00 (5,746.56) 230,960.00 5,747.56 98%670000 General & Administrative22,975.98 27,881.00 (4,905.02) 17.6% 269,301.27 329,058.00 (59,756.73) 329,053.00 59,751.73 82%680000 Leases25,524.23 28,800.00 (3,275.77) 11.4% 305,023.86 321,050.00 (16,026.14) 321,050.00 16,026.14 95%690000 Miscellaneous Other Expense16,375.00 14,798.00 1,577.00 -10.7% 242,946.51 217,598.00 25,348.51 217,596.00 (25,350.51) 112%Total Expenses302,093.81 300,708.66 1,385.15 -0.5% 3,653,631.23 3,752,656.00 99,024.77 3,752,653.00 99,021.77 97%(149,821.77) (118,003.66) (31,818.11) -27.0%(190,973.49) (22,741.70) (168,231.79) (22,742.00) 168,231.49 0%Rounds of Golf PlayedPaid Rounds Played2,637 2,450 187 7.6%42,590 42,173 417 42,173 (417) 101%Ave $ Per Paid Round Green Fee51.44 63.25 (11.81) -18.7%71.88 77.55 (5.67) 77.55 5.67 93%Ave $ Per Paid Round Merchandise4.54 6.00 (1.46) -24.3%5.52 6.21 (0.69) 6.21 0.69 89%Ave $ Per Paid Miscellaneous 4.04 8.48 (4.43) -52.3%6.82 7.87 (1.05) 7.87 1.05 87%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateJune 20181 Income JuneFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees135,648.75 154,963.00 (19,314.25) 3,061,509.93 3,270,481.00 (208,971.07) 2,964,060.00 (97,449.93) -3.3%4010000 Rider Fee375.00 245.00 130.00 10,980.00 7,308.00 3,672.00 7,307.00 (3,673.00) -50.3%4040000 Club Rental1,205.00 1,225.00 (20.00) 27,640.00 21,088.00 6,552.00 21,087.00 (6,553.00) -31.1%4050000 Driving Range2,970.00 3,675.00 (705.00) 94,104.00 94,872.00 (768.00) 94,872.00 768.00 0.8%4060000 Handicap Fees1,613.00 - 1,613.00 1,613.00 2,500.00 (887.00) 2,500.00 887.00 35.5%4090000 Ball Retriever/Subcontract- - - 1,485.00 4,000.00 (2,515.00) 4,000.00 2,515.00 62.9%4091000 Golf Professional Rental Fee- - - 4,210.00 37,000.00 (32,790.00) 37,000.00 32,790.00 88.6%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue4,500.00 15,625.00 (11,125.00) 150,510.00 165,300.00 (14,790.00) 165,300.00 14,790.00 8.9% Total Revenue Fees146,311.75 175,733.00(29,421.25) 3,352,051.933,602,549.00 (250,497.07)3,296,126.00 (55,925.93) -1.7%146,311.75 175,733.00(29,421.25) 3,352,051.933,602,549.00 (250,497.07)3,296,126.00 (55,925.93) -1.7%SilverRock ResortStatement of Fees RevenueTotal IncomeMonth to DateYear to DateAnnual BudgetJune 20182 RevenuesActualBudgetVariance$135,648.75$154,963.00(19,314.25)Unfavorable: $19K under budget is a result of average rate less than forecasted. Rounds of golf were up by 187, however, the average green fee was more than $10 under budget. This was a result of an UnderPar Promotion run in the month of June to lure in additional golfers. ActualBudgetVariance$10,663.00$20,770.00(10,107.00)Unfavorable: Due to reduction in resident card issue. ActualBudgetVariance$11,970.28$14,700.00(2,729.72)Unfavorable: Consumer spending habits in golf merchandise continue to be less than forecasted. New promotions will be implemented in season to help increase sales. ExpensesActualBudgetVariance$19,703.67$17,466.002,237.67Unfavorable: Due to increased hours worked for the increase in business. ActualBudgetVariance$37,231.36$20,041.0017,190.36Unfavorable: Due to additional manpower and timing of Bottled Water shipment.ActualBudgetVariance$9,973.06$11,176.00(1,202.94)Favorable: Due to elimination of private cleaner which has been done in house in an effort to save expenses.ActualBudgetVariance$9,114.76$10,328.00(1,213.24)Favorable: Due timing of advertising invoices, year to date numbers are in line with budget. ActualBudgetVariance$22,975.98$27,881.00(4,905.02)Favorable: Due to reallocation of accounting payroll. ActualBudgetVariance$25,524.23$28,800.00(3,275.77)Favorable: Due to reduced lease payment from projections, and discounted GPS rental fees.ActualBudgetVariance$16,375.00$14,798.001,577.00Unfavorable: Due to payment of payment to County Tax assessment and increase payment for umbrella insurance policy.Golf ShopVariance ExplanationJune 2018The explanation of variance from budget shown below provide details of variances by revenue and expensecategories of at least $1,000 that are greater than 10% of the budgeted amounts. Separate explanations areprovided for those cost of sales percentage that are greater than 5%.Pro Shop Merchandise SalesGolf Green Fee RevenueMiscellaneous Golf RevenueLeasesMiscellaneous Other ExpenseOutside ServicesClubhouseGeneral and AdministrativeMarketing3-20-133 Income JuneFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous72.87 - 72.87 3,722.63 - 3,722.63 00 0%4100110 Sales Hard Goods5,895.87 5,145.00 750.87 86,154.41 91,706.00 (5,551.59) 91,706.00 5,551.59 6.1%4100112 Sales-Soft Goods8,206.03 9,555.00 (1,348.97) 173,827.01 170,309.00 3,518.01 170,311.00 (3,516.01) -2.1%5100639 GS-Discounts-Mdse (2,204.49) - (2,204.49) (28,658.05) - (28,658.05) - 28,658.05 0.0% Total Revenue Golf Shop11,970.28 14,700.00 (2,729.72) 235,046.00 262,015.00 (26,969.00) 262,017.00 30,693.63 11.7%COS 5100150 COS-GS-Hard Goods 2,803.09 2,984.10 (181.01) 48,862.92 53,189.48 (4,326.56) 53,189.48 4,326.56 8.1%5100151 COS-GS-Soft Goods 3,568.63 5,541.90 (1,973.27) 83,458.28 98,779.22 (15,320.94) 97,137.52 13,679.24 14.1%5100152 COS-GS-Purchase Disc- (426.00) 426.00 (300.17) (7,599.00) 7,298.83 (7,598.00) (7,297.83) 96.0%5100220 COS-GS-Freight Merch 138.31 128.00 10.31 4,419.67 2,280.00 2,139.67 2,280.00 (2,139.67) -93.8%Cost of Sales - Golf Shop6,510.03 8,228.00 (1,717.97) 136,440.70 146,649.70 (10,209.00) 145,009.00 8,568.30 5.9%Gross Profit5,460.25 6,472.00 (1,011.75) 98,605.30 115,365.30 (16,760.00) 117,008.00 22,125.33 18.9%COS % 54.4% 56.0% 1.6% 58.0% 56.0% -2.1% 53.1% 27.9% 52.6%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group1,781.12 2,436.00 (654.88) 19,973.51 26,796.00 (6,822.49) 26,796.00 6,822.49 25.5%6101325 Insurance-Workers Comp 999.46 447.00 552.46 7,401.99 4,955.00 2,446.99 4,957.00 (2,444.99) -49.3%6101720 Salaries4,400.00 4,001.00 399.00 50,600.00 48,012.00 2,588.00 45,000.00 (5,600.00) -12.4%6101800 Taxes-Employer Payroll 1,240.27 1,550.00 (309.73) 17,611.69 17,185.00 426.69 18,825.00 1,213.31 6.4%6101880 Wages-Hourly9,753.25 7,922.00 1,831.25 100,015.30 84,166.00 15,849.30 87,179.00 (12,836.30) -14.7%6101882 Wages-Overtime51.39 - 51.39 1,705.90 - 1,705.90 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 18,225.49 16,356.00 1,869.49 197,308.39 181,114.00 16,194.39 182,757.00 (11,892.61) -6.5%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office180.30 250.00 (69.70) 2,031.40 3,000.00 (968.60) 3,000.00 968.60 32.3%6109220 Freight & Delivery- - - 169.49 75.00 94.49 75.00 (94.49) -126.0%6109490 Miscellaneous- 500.00 (500.00) 1,668.21 6,000.00 (4,331.79) 6,000.00 4,331.79 72.2%6109150 Dues and Subscriptions 983.00 - 983.00 983.00 2,300.00 (1,317.00) 2,300.00 1,317.00 57.3%6109500 ProShop-Over/Short(2.11) - (2.11) 231.47 - 231.47 - (231.47) 0.0%6109722 Seminars/Training- 35.00 (35.00) - 3,690.00 (3,690.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- 15.00 (15.00) - 90.00 (90.00) 90.00 90.00 100.0%6109820 Uniforms254.41 200.00 54.41 3,230.16 2,400.00 830.16 2,400.00 (830.16) -34.6%6117840 Telephones62.58 110.00 (47.42) 1,053.81 1,320.00 (266.19) 1,320.00 266.19 20.2%1,478.18 1,110.00 368.18 9,367.54 18,875.00 (9,507.46) 18,875.00 9,507.46 50.4%19,703.67 17,466.00 2,237.67 206,675.93 199,989.00 6,686.93 201,632.00 (2,385.15) -1.2%Net Income(14,243.42) (10,994.00) (3,249.42) (108,070.63) (84,623.70) (23,446.93) (84,624.00) 24,510.48 -29.0%SilverRock ResortGolf Shop Income StatementTotal Expenses-Golf ShopMonth to DateYear to DateAnnual BudgetJune 20184 JuneFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group8,848.90 9,165.00 (316.10) 99,657.46 103,020.00 (3,362.54) 103,020.00 3,362.54 3.3%6311325 Insurance-Workers Comp3,283.94 2,276.00 1,007.94 30,660.04 26,974.00 3,686.04 26,974.00 (3,686.04) -13.7%6311720 Salaries12,476.92 12,200.00 276.92 145,047.24 146,400.00 (1,352.76) 146,400.00 1,352.76 0.9%6311800 Taxes-Employer Payroll4,348.00 7,891.00 (3,543.00) 70,068.13 94,048.00 (23,979.87) 91,481.00 21,412.87 23.4%6311880 Wages-Hourly43,540.23 53,295.66 (9,755.43) 528,807.81 564,695.00 (35,887.19) 567,262.00 38,454.19 6.8%6311882 Wages-Overtime3,254.98 - 3,254.98 64,218.34 12,350.00 51,868.34 12,350.00 (51,868.34) -420.0%Total-CM-SALARIES & BENEFITS75,752.97 84,827.66 (9,074.69) 938,459.02 947,487.00 (9,027.98) 947,487.00 9,027.98 1.0%63-CM-SUPPLIES & MATERIALS6313734 Chemicals18.00 6,508.00 (6,490.00) 15,210.84 43,278.00 (28,067.16) 17,760.00 2,549.16 14.4%6313744 Fertilizer10,026.14 10,630.00 (603.86) 80,117.90 105,970.00 (25,852.10) 105,970.00 25,852.10 24.4%6313745 Herbicides3,444.89 - 3,444.89 28,590.26 - 28,590.26 25,518.00 (3,072.26) -12.0%6313746 Flowers/Plants72.75 - 72.75 3,204.49 3,050.00 154.49 3,050.00 (154.49) -5.1%6313748 Fuel-Gasoline4,555.24 3,580.00 975.24 38,045.20 48,950.00 (10,904.80) 48,950.00 10,904.80 22.3%6313750 Golf Course Accessories- - - 16,938.49 13,140.00 3,798.49 13,140.00 (3,798.49) -28.9%6313756 POA Control- - - - 9,900.00 (9,900.00) 9,900.00 9,900.00 100.0%6313758 Miscellaneous Supp480.00 100.00 380.00 10,448.78 4,350.00 6,098.78 4,350.00 (6,098.78) -140.2%6313762 Supplies-Office179.59 - 179.59 2,984.20 - 2,984.20 - (2,984.20) 0.0%6313774 Sand1,898.68 100.00 1,798.68 8,962.71 13,460.00 (4,497.29) 13,460.00 4,497.29 33.4%6313776 Seed- - - 104,427.63 117,400.00 (12,972.37) 117,400.00 12,972.37 11.0%6313778 Small Tools & Non-Capital Equip93.75 100.00 (6.25) 5,799.34 5,000.00 799.34 5,000.00 (799.34) -16.0%6313780 Sod1,750.88 3,450.00 (1,699.12) 10,774.25 13,500.00 (2,725.75) 13,500.00 2,725.75 20.2%6313782 Topdressing- 1,500.00 (1,500.00) 6,473.47 10,000.00 (3,526.53) 10,000.00 3,526.53 35.3%Total-CM-SUPPLIES & MATERIALS22,519.92 25,968.00 (3,448.08) 331,977.56 387,998.00 (56,020.44) 387,998.00 56,020.44 14.4%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint3,840.00 2,830.00 1,010.00 44,984.24 33,960.00 11,024.24 33,960.00 (11,024.24) -32.5%6315685 CM-R&M-Bldngs & Othr Structures 390.48 250.00 140.48 8,438.23 5,550.00 2,888.23 5,550.00 (2,888.23) -52.0%6315690 CM-R&M-Equipment5,222.82 2,500.00 2,722.82 39,166.53 38,500.00 666.53 38,500.00 (666.53) -1.7%6315692 CM-R&M-Irrigation System824.09 1,000.00 (175.91) 26,956.80 19,050.00 7,906.80 19,050.00 (7,906.80) -41.5%6315696 CM-R&M-Pumps- - - 13,354.55 10,500.00 2,854.55 10,500.00 (2,854.55) -27.2%6315815 CM-R&M-Trees-Pruning Etc4,025.00 - 4,025.00 10,705.00 12,050.00 (1,345.00) 12,050.00 1,345.00 11.2%Total-CM-REPAIRS & MAINTENANCE14,302.39 6,580.00 7,722.39 143,605.35 119,610.00 23,995.35 119,610.00 (23,995.35) -20.1%6317836 Utilities-Natural Gas/LPG 18.55 15.00 3.55 367.73 180.00 187.73 180.00 (187.73) 0.0%6317840 Telephones 775.11 850.00 (74.89) 10,821.16 10,200.00 621.16 10,200.00 (621.16) -6.1%Total-CM-UTILITIES793.66 865.00 (71.34) 11,188.89 10,380.00 808.89 10,380.00 (808.89) -7.8%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 400.00 - 4,800.00 4,800.00 - 4,800.00 - 0.0%6319100 Contract Svcs-Soil/Tissue Test- - - - 2,000.00 (2,000.00) 2,000.00 2,000.00 100.0%6319102 Contract Svcs-Trash Removal100.23 524.00 (423.77) 219.33 6,288.00 (6,068.67) 6,288.00 6,068.67 96.5%6319150 Dues & Subscriptions210.00 100.00 110.00 1,375.00 680.00 695.00 680.00 (695.00) -102.2%6319170 Employee Education100.00 50.00 50.00 100.00 3,900.00 (3,800.00) 3,900.00 3,800.00 97.4%6319197 Equipment Rental- 100.00 (100.00) 4,407.67 3,400.00 1,007.67 3,400.00 (1,007.67) -29.6%6319206 Licenses & Permits- - - 2,676.29 4,300.00 (1,623.71) 4,300.00 1,623.71 37.8%6319490 Miscellaneous39.11 100.00 (60.89) 856.01 1,200.00 (343.99) 1,200.00 343.99 28.7%6319718 Safety Equipment & Training137.66 100.00 37.66 3,578.51 3,850.00 (271.49) 3,850.00 271.49 7.1%6319822 Uniforms727.24 920.00 (192.76) 9,329.62 11,040.00 (1,710.38) 11,040.00 1,710.38 15.5%Total-CM-OTHER EXPENSES1,714.24 2,294.00 (579.76) 27,342.43 41,458.00 (14,115.57) 41,458.00 14,115.57 34.0%SilverRock ResortCourse Maintenance Expense StatementAnnual BudgetJune 2018Month to DateYear to Date5 MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 3,597.86 2,784.00 813.86 41,692.67 33,408.00 8,284.67 33,408.00 (8,284.67) -24.8%6321325 Insurance-Workers Comp713.90 484.00 229.90 6,789.23 5,955.00 834.23 5,955.00 (834.23) -14.0%6321800 Taxes-Employer Payroll854.87 1,678.00 (823.13) 16,944.93 20,793.00 (3,848.07) 20,793.00 3,848.07 18.5%6321880 Wages-Hourly9,131.04 12,904.00 (3,772.96) 142,609.51 156,528.00 (13,918.49) 156,528.00 13,918.49 8.9%6321882 Wages-Overtime200.52 - 200.52 2,174.38 3,418.00 (1,243.62) 3,418.00 1,243.62 36.4%Total-CM-LM-SALARIES & BENEFITS14,498.19 17,850.00 (3,351.81) 210,210.72 220,102.00 (9,891.28) 220,102.00 9,891.28 4.5%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools862.53 75.00 787.53 1,249.30 1,025.00 224.30 1,025.00 (224.30) -21.9%6323788 Uniforms511.89 290.00 221.89 3,934.63 3,480.00 454.63 3,480.00 (454.63) -13.1%Total-CM-LM-SUPPLIES & MATERIALS1,374.42 365.00 1,009.42 5,183.93 4,505.00 678.93 4,505.00 (678.93) -15.1%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation1,518.09 500.00 1,018.09 4,731.79 4,250.00 481.79 4,250.00 (481.79) -11.3%Total-CM-LM-REPAIRS & MAINTENANCE1,518.09 500.00 1,018.09 4,731.79 4,250.00 481.79 4,250.00 (481.79) -11.3%132,473.88 139,249.66 (6,775.78) 1,672,699.69 1,735,790.00 (63,090.31) 1,735,790.00 63,090.31 3.6% MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 14,286.86 21,530.00 (7,243.14) 143,373.25 179,791.00 (36,417.75) 179,791.00 36,417.75 20.3%6337842 Utilities-Water14,435.01 9,439.00 4,996.01 90,894.98 70,047.00 20,847.98 70,047.00 (20,847.98) -29.8%28,721.87 30,969.00 (2,247.13) 234,268.23 249,838.00 (15,569.77) 249,838.00 15,569.77 6.2%Silverrock ResortCourse Maintenance Water & EnergyJune 2018Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementJune 2018Silverrock ResortAnnual BudgetMonth to DateYear to Date6 JuneFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 696.00 (696.00) - 8,352.00 (8,352.00) 8,352.00 8,352.00 100.0%6411325 Insurance-Workers Comp1,998.92 401.00 1,597.92 9,957.21 5,624.00 4,333.21 5,623.00 (4,334.21) -77.1%6411800 Taxes-Employer Payroll1,517.80 1,332.00 185.80 20,501.93 18,665.00 1,836.93 18,667.00 (1,834.93) -9.8%6411880 Wages-Hourly13,242.88 10,695.00 2,547.88 151,433.97 149,935.00 1,498.97 149,934.00 (1,499.97) -1.0%6411882 Wages-Overtime574.56 - 574.56 6,058.09 - 6,058.09 - (6,058.09) 0.0%Total-CBR-SALARIES & BENEFITS17,334.1613,124.004,210.16 187,951.20182,576.005,375.20 182,576.00 (5,375.20) -2.9%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- 50.00 (50.00) 203.73 1,850.00 (1,646.27) 1,850.00 `0.0%6413742 Supplies-Expendable340.39 500.00 (159.61) 5,403.64 6,750.00 (1,346.36) 6,750.00 1,346.36 19.9%6413748 Supplies-Fuel for Shuttle- 100.00 (100.00) 420.49 3,000.00 (2,579.51) 3,000.00 2,579.51 86.0%6413752 Supplies-Range Balls- - - 10,766.25 9,000.00 1,766.25 9,000.00 (1,766.25) -19.6%6413762 Supplies-Office- 50.00 (50.00) - 525.00 (525.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- 70.00 (70.00) 27.79 420.00 (392.21) 420.00 392.21 93.4%6413786 Supplies-Towels400.00 72.00 328.00 3,941.95 2,182.00 1,759.95 2,182.00 (1,759.95) -80.7%6413796 Supplies-Bottled Water5,789.00 200.00 5,589.00 22,380.25 12,900.00 9,480.25 12,900.00 (9,480.25) -73.5%Total-CBR-SUPPLIES & MATERIALS6,529.39 1,042.00 5,487.39 43,144.10 36,627.00 6,517.10 36,627.00 (8,163.37) -22.3%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment465.00 300.00 165.00 24,599.13 3,600.00 20,999.13 3,600.00 (20,999.13) -583.3%6415695 CBR-R&M-Cart Maintenance & Repair 2,500.00 500.00 2,000.00 3,639.55 6,450.00 (2,810.45) 6,450.00 2,810.45 43.6%Total-CBR-REPAIRS & MAINTENANCE2,965.00 800.00 2,165.00 28,238.68 10,050.00 18,188.68 10,050.00 (18,188.68) -181.0%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen1,399.69 800.00 599.69 11,841.09 9,600.00 2,241.09 9,600.00 (2,241.09) -23.3%6419220 Freight/Delivery- - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous129.41 600.00 (470.59) 2,464.19 7,200.00 (4,735.81) 7,200.00 4,735.81 65.8%6419820 Uniforms- 200.00 (200.00) 2,292.34 5,200.00 (2,907.66) 5,200.00 2,907.66 55.9%Total-CBR-OTHER EXPENSES1,529.10 1,600.00 (70.90) 16,597.62 22,450.00 (5,852.38) 22,450.00 5,852.38 26.1%TOTAL-CARTS,BAGROOM & RANGE28,357.6516,566.00(70.90) 275,931.60251,703.0024,228.60 251,703.00 (25,874.87) -10.3%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp999.46 105.00 894.46 5,682.81 2,448.00 3,234.81 2,450.00 (3,232.81) -132.0%6431800 Taxes-Employer Payroll814.73 365.00 449.73 9,589.74 8,494.00 1,095.74 8,494.00 (1,095.74) -12.9%6431880 Wages-Hourly6,574.34 2,805.00 3,769.34 65,295.62 65,342.00 (46.38) 65,341.00 45.38 0.1%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS8,388.53 3,275.00 5,113.53 80,568.17 76,284.00 4,284.17 76,285.00 (4,283.17) -5.6%643-CS-OTHER EXPENSES6433742 Supplies Expendable485.18 75.00 410.18 1,506.73 1,050.00 456.73 1,050.00 (456.73) -43.5%6439490 Miscellaneous- - - - 200.00 (200.00) 200.00 200.00 100.0%6439718 Safety Equipment & Training- 50.00 (50.00) - 600.00 (600.00) 600.00 600.00 100.0%6439820 Uniforms- 75.00 (75.00) 5,108.04 2,125.00 2,983.04 2,125.00 (2,983.04) -140.4%Total-CS-OTHER EXPENSES485.18 200.00 285.18 6,614.77 3,975.00 2,639.77 3,975.00 (2,639.77) -66.4%Total-COURSE SERVICES8,873.71 3,475.00 5,398.71 87,182.94 80,259.00 6,923.94 80,260.00 (6,922.94) -8.6%37,231.3620,041.0017,190.36 363,114.54331,962.0031,152.54 331,963.00 (30,158.04) -9.1%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementAnnual BudgetJune 20187 JuneFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 4,800.00 4,800.00 - 4,800.00 - 0.0%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 4,800.00 4,800.00 - 4,800.00 - 0.0%65-CH-UTILITIES6507836 Utilities-Natural Gas426.92 300.00 126.92 5,069.95 3,600.00 1,469.95 3,600.00 (1,469.95) -40.8%6507840 Utilities-Telephone1,182.71 1,150.00 32.71 11,588.48 13,800.00 (2,211.52) 13,800.00 2,211.52 16.0%6507842 Utilities-Water733.40 321.00 412.40 5,455.85 3,852.00 1,603.85 3,852.00 (1,603.85) -41.6%6507844 Utilities-Cable495.84 380.00 115.84 5,926.53 4,560.00 1,366.53 4,560.00 (1,366.53) -30.0%Total-CH-UTILITIES2,838.87 2,151.00 687.87 28,040.81 25,812.00 2,228.81 25,812.00 (2,228.81) -8.6%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning275.00 1,825.00 (1,550.00) 13,909.62 22,500.00 (8,590.38) 22,500.00 8,590.38 38.2%6509099 Contract Services-Security5,617.04 5,000.00 617.04 63,266.94 60,000.00 3,266.94 60,000.00 (3,266.94) -5.4%6509215 Flowers & Decorations- 400.00 (400.00) - 1,900.00 (1,900.00) 1,900.00 1,900.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 2,709.15 7,000.00 (4,290.85) 7,000.00 4,290.85 61.3%6509718 Safety Equipment & Training- 100.00 (100.00) 194.15 1,200.00 (1,005.85) 1,200.00 1,005.85 83.8%Total-CH-OTHER EXPENSES5,892.04 7,525.00 (1,632.96)80,079.86 92,600.00 (12,520.14)92,600.00 12,520.14 13.5%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures842.15 300.00 542.15 13,149.03 3,600.00 9,549.03 3,600.00 (9,549.03) -265.3%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 2,481.84 4,800.00 (2,318.16) 4,800.00 2,318.16 48.3%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 5,837.22 4,800.00 1,037.22 4,800.00 (1,037.22) -21.6%Total-CH-REPAIRS & MAINTENANCE842.15 1,100.00 (257.85) 21,468.09 13,200.00 8,268.09 13,200.00 (8,268.09) -62.6%9,973.06 11,176.00(1,202.94)134,388.76136,412.00(2,023.24) 136,412.00 (16,536.18) -12.1%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementAnnual BudgetJune 20188 JuneFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 355.89 348.00 7.89 4,579.72 4,176.00 403.72 4,176.00 (403.72) -9.7%6601325 Insurance-Workers Comp- 94.00 (94.00) 1,060.87 1,128.00 (67.13) 1,129.00 68.13 6.0%6601720 Salaries1,905.20 2,508.00 (602.80) 22,871.84 30,096.00 (7,224.16) 30,096.00 7,224.16 24.0%6601800 Taxes-Employer Payroll145.20 326.00 (180.80) 2,832.40 3,912.00 (1,079.60) 3,912.00 1,079.60 27.6%Total-MKT-SALARIES & BENEFITS2,406.29 3,276.00 (869.71) 31,344.83 39,312.00 (7,967.17) 39,313.00 7,968.17 20.3%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 64.17 100.00 (35.83) 1,117.56 1,200.00 (82.44) 1,200.00 82.44 6.9%6603768 Supplies-Printing & Stationery 138.19 125.00 13.19 9,533.95 4,425.00 5,108.95 4,425.00 (5,108.95) -115.5%202.36 225.00 (22.64) 10,651.51 5,625.00 5,026.51 5,625.00 (5,026.51) -89.4%66-MKT-UTILITIES6607840 Utilities-Telephone 182.61 100.00 82.61 1,741.30 1,200.00 541.30 1,200.00 (541.30) -45.1%Total-MKT-UTILITIES182.61 100.00 82.61 1,741.30 1,200.00 541.30 1,200.00 (541.30) -45.1%66-MKT-OTHER EXPENSES6609010 Advertising6,224.50 5,377.00 847.50 168,243.54 169,987.00 (1,743.46) 169,987.00 1,743.46 1.0%6609040 Business Meals- 25.00 (25.00) - 300.00 (300.00) 300.00 300.00 100.0%6609080 Collateral Material- 1,000.00 (1,000.00) 6,178.41 5,500.00 678.41 5,500.00 (678.41) -12.3%6609102 Contract Services-Web Page99.00 150.00 (51.00) 1,287.00 1,800.00 (513.00) 1,800.00 513.00 28.5%6609490 Miscellaneous- - - 111.87 350.00 (238.13) 350.00 238.13 68.0%6609620 Postage- 50.00 (50.00) - 600.00 (600.00) 600.00 600.00 100.0%6609630 Promotion- 50.00 (50.00) 2,064.31 700.00 1,364.31 700.00 (1,364.31) -194.9%6609633 Promotion-Community- 75.00 (75.00) 824.19 2,250.00 (1,425.81) 2,250.00 1,425.81 63.4%6609634 Promotion-Media/Vendor- - - 1,892.65 2,000.00 (107.35) 2,000.00 107.35 5.4%6609150 Dues and Subscriptions- - - - 735.00 (735.00) 735.00 735.00 100.0%6609820 Uniforms- - - 872.83 600.00 272.83 600.00 (272.83) -45.5%Total-MKT-OTHER EXPENSES6,323.50 6,727.00 (403.50) 181,474.80 184,822.00 (3,347.20) 184,822.00 3,347.20 1.8%9,114.76 10,328.00 (1,213.24) 225,212.44 230,959.00 (5,746.56) 230,960.00 5,747.56 2.5%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementAnnual Budget20189 JuneFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group2,061.11 1,509.00 552.11 22,462.40 18,108.00 4,354.40 18,108.00 (4,354.40) -24.0%6701325 Insurance-Workers Comp428.34 677.00 (248.66) 6,707.07 7,900.00 (1,192.93) 7,905.00 1,197.93 15.2%6701720 Salaries11,494.80 15,465.00 (3,970.20) 145,113.04 178,690.00 (33,576.96) 177,996.00 32,882.96 18.5%6701800 Taxes-Employer Payroll1,094.10 2,349.00 (1,254.90) 12,810.86 27,408.00 (14,597.14) 32,800.00 19,989.14 60.9%6701880 Wages-Hourly2,862.33 2,600.00 262.33 29,546.39 32,076.00 (2,529.61) 27,404.00 (2,142.39) -7.8%6701882 Wages-Overtime- - - 46.59 - 46.59 - (46.59) 0.0%Total-G&A-SALARIES & BENEFITS17,940.68 22,600.00 (4,659.32) 216,686.35 264,182.00 (47,495.65) 264,213.00 47,526.65 18.0%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer57.88 800.00 (742.12) 3,363.11 6,300.00 (2,936.89) 6,300.00 2,936.89 46.6%6703762 Supplies-Office- 105.00 (105.00) 434.28 1,260.00 (825.72) 1,260.00 825.72 65.5%6703768 Supplies-Printing & Stationery261.00 400.00 (139.00) 2,245.12 3,300.00 (1,054.88) 3,300.00 1,054.88 32.0%Total-G&A-SUPPLIES & MATERIALS318.88 1,305.00 (986.12) 6,042.51 10,860.00 (4,817.49) 10,860.00 4,817.49 44.4%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 1,475.00 1,900.00 (425.00) 1,900.00 425.00 22.4%Total-G&A-REPAIRS & MAINTENANCE- 100.00 (100.00) 1,475.00 1,900.00 (425.00) 1,900.00 425.00 22.4%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 6,000.00 6,000.00 - 6,000.00 - 0.0%6709150 Dues & Subscriptions240.00 50.00 190.00 1,245.00 1,150.00 95.00 1,150.00 (95.00) -8.3%6709180 Employee Recruiting/Relocation- - - 1,127.24 1,200.00 (72.76) 1,200.00 72.76 6.1%6709197 Equipment Rental865.94 550.00 315.94 7,454.39 6,600.00 854.39 6,600.00 (854.39) -12.9%6709202 Fees-Bank92.03 90.00 2.03 2,133.70 1,080.00 1,053.70 1,080.00 (1,053.70) -97.6%6709208 Fees-Payroll Processing386.65 1,000.00 (613.35) 8,024.04 12,000.00 (3,975.96) 12,000.00 3,975.96 33.1%6709220 Freight/Delivery- 50.00 (50.00) - 600.00 (600.00) 600.00 600.00 100.0%6709490 Miscellaneous- 100.00 (100.00) 3,577.86 6,600.00 (3,022.14) 6,600.00 3,022.14 45.8%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services158.99 75.00 83.99 1,766.78 900.00 866.78 900.00 (866.78) -96.3%6709625 Professional Fees2,448.69 850.00 1,598.69 9,818.16 10,200.00 (381.84) 10,200.00 381.84 3.7%6709636 Promotion/Entertainment- 100.00 (100.00) 326.10 1,200.00 (873.90) 1,200.00 873.90 72.8%6709722 Seminars & Training- 200.00 (200.00) 2,393.24 2,400.00 (6.76) 2,400.00 6.76 0.3%6709810 Travel- 200.00 (200.00) - 1,100.00 (1,100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms24.12 111.00 900.00 1,230.90 1,086.00 144.90 1,050.00 (180.90) -17.2%Total-G&A-OTHER EXPENSES4,716.42 3,876.00 1,827.30 45,097.41 52,116.00 (7,018.59) 52,080.00 6,982.59 13.4%22,975.98 27,881.00 (4,905.02) 269,301.27 329,058.00 (59,756.73) 329,053.00 59,751.73 18.2%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementAnnual BudgetJune 201810 JuneFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts9,829.27 10,050.00 (220.73) 117,951.24 121,050.00 (3,098.76) 121,050.00 3,098.76 2.6%6800193 Equipment Leases-Maintenance 9,181.20 11,500.00 (2,318.80) 110,174.40 116,200.00 (6,025.60) 116,200.00 6,025.60 5.2%6800194 Equipment Leases-Trailer583.07 600.00 (16.93) 6,244.02 7,200.00 (955.98) 7,200.00 955.98 13.3%6800196 Equipment Leases-GPS3,870.00 4,700.00 (830.00) 46,440.00 56,400.00 (9,960.00) 56,400.00 9,960.00 17.7%6800197 Equipment Leases-Others2,060.69 1,950.00 110.69 24,214.20 20,200.00 4,014.20 20,200.00 (4,014.20) 0.0%25,524.23 28,800.00(3,275.77) 305,023.86321,050.00 (16,026.14)321,050.00 16,026.14 5.0%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,999.00 8,999.00 - 108,488.00 107,988.00 500.00 107,987.00 (501.00) -0.5%6900210 FF&E Reserve2,594.44 3,099.00 (504.56) 61,111.51 65,410.00 (4,298.49) 59,281.00 (1,830.51) -3.1%6900800 Personal Property Taxes- - - 15,099.65 11,800.00 3,299.65 11,800.00 (3,299.65) -28.0%6900323 Insurance-Commercial4,781.56 2,700.00 2,081.56 58,247.35 32,400.00 25,847.35 32,400.00 (25,847.35) -79.8%16,375.00 14,798.001,577.00 242,946.51217,598.00 25,348.51 211,468.00 (31,478.51) -14.9%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementAnnual BudgetMonth to Date Year to DateJune 201811 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2017-20182017 2017 2017 2017 2017 2017Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia13 5SalesPromotionGolf IndustryVIPCelebrityPGA Comp20 12 27516Charity/Gift Certificate2213 10Rain/Wind Checks2Club Staff53 38 65 16 32 66LQ HS Golf1066382685 58 98 19 71 1252018 2018 2018 2018 2018 2018Comp CategoryJanuaryFebruaryMarchAprilMayJuneMedia4 7 1246SalesPromotion4Golf IndustryVIPCelebrityPGA Comp31 41 30 34 25 38Charity/Gift Certificate22614 24 134Rain/Wind Checks5740 133Club Staff31 42 42 39 72 42LQ HS Golf826 51 39812105 129 189 149 125 10212 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2017-2018June 2018 Date TimeDescriptionCategoryPlayers6/2/201811:00 AMJohn White - CBS2Media46/22/2018 7:30 AM Judd Spicer - Golf WriterMedia 213