Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
04 October 2016 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2016 – October 2016 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 OctoberFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue74,396.00 13,763.00 60,633.00 440.6% 332,307.65 110,701.00 221,606.65 3,199,237.00 2,866,929.35 10%401000 Miscellaneous Golf Revenue12,429.00 9,400.00 3,029.00 32.2% 37,811.80 17,660.00 20,151.80 349,259.00 311,447.20 11%410000Revenue-Golf Shop6,148.05 2,500.00 3,648.05 145.9%32,967.39 16,263.00 16,704.39 278,585.00 245,617.61 12%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0%3,000.00 3,000.00 - 12,000.00 9,000.00 25%890000 Interest Income- - - 0.17 - 0.17 - (0.17) 0%Total Income94,473.05 27,163.00 67,310.05 247.8% 406,087.01 147,624.00 258,463.01 3,839,081.00 3,432,993.99 11%Cost of Goods Sold510000 COS-Golf Shop3,579.79 1,399.00 2,180.79 -155.9% 19,376.68 9,102.54 (10,274.14) 155,924.00 136,547.32 12%Total COS3,579.79 1,399.00 2,180.79 -155.9% 19,376.68 9,102.54 (10,274.14) 155,924.00 136,547.32 12%Gross Profit90,893.26 25,764.00 65,129.26 252.8% 386,710.33 138,521.46 248,188.87 3,683,157.00 3,296,446.67 10%Expenses610000 Golf Pro Shop12,805.67 11,555.00 1,250.67 -10.8% 51,566.74 49,661.00 1,905.74 204,827.00 153,260.26 25%630000 Course Maintenance264,747.90 280,814.00 (16,066.10) 5.7% 639,204.87 656,419.00 (17,214.13) 1,712,795.00 1,073,590.13 37%633000 Maintenance Water & Energy18,024.04 18,240.00 (215.96) 1.2% 80,347.70 87,212.00 (6,864.30) 225,129.00 144,781.30 36%640000 Outside Services19,017.75 16,231.00 2,786.75 -17.2% 71,724.36 65,120.00 6,604.36 309,830.00 238,105.64 23%650000 Clubhouse10,325.88 11,736.00 (1,410.12) 12.0% 41,750.36 43,644.00 (1,893.64) 136,332.00 94,581.64 31%660000 Marketing22,618.01 20,966.00 1,652.01 -7.9% 61,487.17 50,735.00 10,752.17 240,177.00 178,689.83 26%670000 General & Administrative27,104.49 25,635.00 1,469.49 -5.7% 96,467.71 100,977.00 (4,509.29) 327,511.00 231,043.29 29%680000 Leases21,155.70 23,000.00 (1,844.30) 8.0% 98,468.26 90,650.00 7,818.26 271,050.00 172,581.74 36%690000 Miscellaneous Other Expense22,841.42 14,228.00 8,613.42 -60.5% 71,102.50 59,426.00 11,676.50 202,025.00 130,922.50 35%Total Expenses418,640.86 422,405.00 (3,764.14) 0.9% 1,212,119.67 1,203,844.00 (8,275.67) 3,629,676.00 2,417,556.33 33%(327,747.60) (396,641.00) 68,893.40 17.4%(825,409.34) (1,065,322.54) 239,913.20 53,481.00 878,890.34 0%Rounds of Golf PlayedPaid Rounds Played1,364 500 864 172.8%9,114 4,100 5,014 46,475 37,361 20%Ave $ Per Paid Round Green Fee54.54 27.53 27.02 98.1%36.46 27.00 9.46 68.84 32.38 53%Ave $ Per Paid Round Merchandise4.51 5.00 (0.49) -9.9%3.62 3.97 (0.35) 5.99 2.38 60%Ave $ Per Paid Miscellaneous 9.11 18.80 (9.69) -51.5%4.15 4.31 (0.16) 7.51 3.37 55%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateOctober 20161 Income OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees74,396.00 13,763.00 60,633.00 332,307.65 110,701.00 221,606.65 3,199,237.00 2,866,929.35 89.6%4010000 Rider Fee200.00 50.00 150.00 1,617.50 411.00 1,206.50 7,738.00 6,120.50 79.1%4040000 Club Rental1,595.00 250.00 1,345.00 4,580.00 2,054.00 2,526.00 23,238.00 18,658.00 80.3%4050000 Driving Range1,619.00 500.00 1,119.00 8,524.00 3,795.00 4,729.00 100,984.00 92,460.00 91.6%4060000 Handicap Fees- - - - - - 2,500.00 2,500.00 100.0%4080000 GPS Advertising- 100.00 (100.00) - 400.00 (400.00) 2,600.00 2,600.00 100.0%4090000 Ball Retriever/Subcontract- 1,000.00 (1,000.00) 995.30 2,000.00 (1,004.70) 4,000.00 3,004.70 75.1%4091000 Golf Professional Rental Fee- - - - - - 37,000.00 37,000.00 100.0%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue9,015.00 7,500.00 1,515.00 22,095.00 9,000.00 13,095.00 171,200.00 149,105.00 87.1% Total Revenue Fees86,825.00 23,163.00 63,662.00 370,119.45 128,361.00 241,758.45 3,548,497.00 3,178,377.55 89.6%86,825.00 23,163.00 63,662.00 370,119.45 128,361.00 241,758.45 3,548,497.00 3,178,377.55 89.6%SilverRock ResortStatement of Fees RevenueOctober 2016Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$74,396.00$13,763.0060,633.00Favorable: Due to projected closure of nine holes budget projections were reduced.ActualBudgetVariance$12,429.00$9,400.003,029.00Favorable: Due to projected closure of nine holes budget projections were reduced, also, sale of resident cards was high.ActualBudgetVariance$6,148.05$2,500.003,648.05Favorable: Due to projected closure of nine holes budget projections were reduced.ExpensesActualBudgetVariance$12,805.67$11,555.001,250.67Unfavorable: Due to increased payroll as a result of 18 hole rounds.ActualBudgetVariance$19,017.75$16,231.002,786.75Unfavorable: Due to increased payroll as a result of additional business due to 18 hole rounds.ActualBudgetVariance$10,325.88$11,736.00(1,410.12)Favorable: Due to no expenses for repair and maintenance.ActualBudgetVariance$22,841.42$14,228.008,613.42Unfavorable: Due to initial payment of umbrella insurance policy of 50%.provided for those cost of sales percentage that are greater than 5%.Variance ExplanationOctober 2016The 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 arePro Shop Merchandise SalesGolf Green Fee RevenueMiscellaneous Golf RevenueMiscellaneous Other ExpensesGolf ShopCartbarn-Course ServicesClubhouse3-20-133 Income OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous251.54 - 251.54 2,011.29 - 2,011.29 00 0%4100110 Sales Hard Goods3,042.71 875.00 2,167.71 15,089.40 5,692.00 9,397.40 97,505.00 82,415.60 84.5%4100112 Sales-Soft Goods3,780.50 1,625.00 2,155.50 21,076.50 10,571.00 10,505.50 181,080.00 160,003.50 88.4%5100639 GS-Discounts-Mdse(926.70) - (926.70) (5,209.80) - (5,209.80) - 5,209.80 0.0% Total Revenue Golf Shop6,148.05 2,500.00 3,648.05 32,967.39 16,263.00 16,704.39 278,585.00 247,628.90 88.9%COS 5100150 COS-GS-Hard Goods 1,450.09 507.50 942.59 7,866.61 3,301.36 4,565.25 56,552.90 48,686.29 86.1%5100151 COS-GS-Soft Goods 1,550.26 942.50 607.76 10,632.67 6,131.18 4,501.49 105,026.40 94,393.73 89.9%5100152 COS-GS-Purchase Disc (24.60) (73.00) 48.40 (50.37) (472.00) 421.63 (8,079.00) (8,028.63) 99.4%5100220 COS-GS-Freight Merch 604.04 22.00 582.04 927.77 142.00 785.77 2,424.00 1,496.23 61.7%Cost of Sales - Golf Shop3,579.79 1,399.00 2,180.79 19,376.68 9,102.54 10,274.14 155,924.30 136,547.62 87.6%Gross Profit2,568.26 1,101.00 1,467.26 13,590.71 7,160.46 6,430.25 122,660.70 111,081.28 90.6%COS %58.2% 56.0% -2.3% 58.8% 56.0% -2.8% 53.1% 55.1% 103.9%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group2,704.76 2,046.00 658.76 6,818.80 7,161.00 (342.20) 27,621.00 20,802.20 75.3%6101325 Insurance-Workers Comp 228.00 256.00 (28.00) 1,508.07 1,201.00 307.07 5,042.00 3,533.93 70.1%6101720 Salaries4,001.00 4,001.00 - 16,007.00 16,004.00 3.00 45,000.00 28,993.00 64.4%6101800 Taxes-Employer Payroll 682.94 954.00 (271.06) 2,783.68 4,480.00 (1,696.32) 18,825.00 16,041.32 85.2%6101880 Wages-Hourly4,529.91 2,813.00 1,716.91 18,905.23 16,000.00 2,905.23 89,463.00 70,557.77 78.9%6101882 Wages-Overtime- - - - - - - 952.88 0.0%Total -PS-SALARIES & BENEFITS 12,146.61 10,070.00 2,076.61 46,022.78 44,846.00 1,176.78 185,951.00 140,881.10 75.8%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office- 250.00 (250.00) 345.75 1,000.00 (654.25) 3,000.00 2,654.25 88.5%6109220 Freight & Delivery- 25.00 (25.00) 16.80 25.00 (8.20) 75.00 58.20 77.6%6109490 Miscellaneous500.00 500.00 - 2,000.00 2,000.00 - 6,000.00 4,000.00 66.7%6109150 Dues and Subscriptions- - - 1,103.62 - 1,103.62 2,300.00 1,196.38 52.0%6109500 ProShop-Over/Short9.00 - 9.00 108.91 - 108.91 - (108.91) 0.0%6109722 Seminars/Training- 500.00 (500.00) - 950.00 (950.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- - - - - - 90.00 90.00 100.0%6109820 Uniforms98.55 100.00 (1.45) 1,740.19 400.00 1,340.19 2,400.00 659.81 27.5%6117840 Telephones51.51 110.00 (58.49) 228.69 440.00 (211.31) 1,320.00 1,091.31 82.7%659.06 1,485.00 (825.94) 5,543.96 4,815.00 728.96 18,875.00 13,331.04 70.6%12,805.67 11,555.00 1,250.67 51,566.74 49,661.00 1,905.74 204,826.00 154,212.14 75.3%Net Income(10,237.41) (10,454.00) 216.59 (37,976.03) (42,500.54) 4,524.51 (82,165.30) (43,130.86) 52.5%SilverRock ResortGolf Shop Income StatementOctober 2016Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group5,628.62 8,990.00 (3,361.38) 33,141.92 35,960.00 (2,818.08) 107,880.00 74,738.08 69.3%6311325 Insurance-Workers Comp2,250.40 2,328.00 (77.60) 7,650.51 7,317.00 333.51 24,794.00 17,143.49 69.1%6311720 Salaries10,979.60 9,333.33 1,646.27 42,842.00 37,333.32 5,508.68 142,017.20 99,175.20 69.8%6311800 Taxes-Employer Payroll8,308.02 9,181.00 (872.98) 19,968.37 27,802.00 (7,833.63) 93,302.00 73,333.63 78.6%6311880 Wages-Hourly46,012.27 45,722.67 289.60 161,909.21 150,733.68 11,175.53 508,481.80 346,572.59 68.2%6311882 Wages-Overtime10,565.24 10,526.00 39.24 10,630.09 10,526.00 104.09 15,945.00 5,314.91 33.3%Total-CM-SALARIES & BENEFITS83,744.15 86,081.00 (2,336.85) 276,142.10 269,672.00 6,470.10 892,420.00 616,277.90 69.1%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 87.66 4,600.00 (4,512.34) 8,326.28 13,600.00 (5,273.72) 34,600.00 26,273.72 75.9%6313744 Fertilizer19,134.70 17,500.00 1,634.70 49,069.62 53,500.00 (4,430.38) 112,500.00 63,430.38 56.4%6313745 Herbicides- - - 6,645.80 7,000.00 (354.20) 17,000.00 10,354.20 60.9%6313746 Flowers/Plants- 250.00 (250.00) - 1,250.00 (1,250.00) 3,050.00 3,050.00 100.0%6313748 Fuel-Gasoline2,186.80 8,000.00 (5,813.20) 13,881.57 22,500.00 (8,618.43) 55,020.00 41,138.43 74.8%6313750 Golf Course Accessories132.75 10,000.00 (9,867.25) 1,365.30 10,900.00 (9,534.70) 13,000.00 11,634.70 89.5%6313756 POA Control- - - - - - 7,000.00 7,000.00 100.0%6313758 Miscellaneous Supp1,013.85 500.00 513.85 3,102.96 2,750.00 352.96 4,350.00 1,247.04 28.7%6313762 Supplies-Office258.23 - 258.23 903.62 - 903.62 - (903.62) 0.0%6313774 Sand377.55 2,000.00 (1,622.45) 5,949.12 7,780.00 (1,830.88) 13,460.00 7,510.88 55.8%6313776 Seed111,954.42 102,000.00 9,954.42 114,964.38 102,950.00 12,014.38 125,900.00 10,935.62 8.7%6313778 Small Tools & Non-Capital Equip- 2,000.00 (2,000.00) 1,413.38 4,200.00 (2,786.62) 5,000.00 3,586.62 71.7%6313780 Sod100.00 250.00 (150.00) 8,536.88 5,750.00 2,786.88 10,450.00 1,913.12 18.3%6313782 Topdressing2,331.32 2,500.00 (168.68) 4,582.66 5,000.00 (417.34) 10,600.00 6,017.34 56.8%Total-CM-SUPPLIES & MATERIALS137,577.28 149,600.00 (12,022.72) 218,741.57 237,180.00 (18,438.43) 411,930.00 193,188.43 46.9%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,270.00 2,600.00 (330.00) 10,490.00 10,400.00 90.00 31,200.00 20,710.00 66.4%6315685 CM-R&M-Bldngs & Othr Structures 276.67 500.00 (223.33) 1,436.48 3,050.00 (1,613.52) 5,550.00 4,113.52 74.1%6315690 CM-R&M-Equipment9,614.53 11,000.00 (1,385.47) 17,278.92 17,500.00 (221.08) 40,000.00 22,721.08 56.8%6315692 CM-R&M-Irrigation System3,289.58 2,000.00 1,289.58 12,904.18 11,400.00 1,504.18 19,050.00 6,145.82 32.3%6315696 CM-R&M-Pumps- 1,000.00 (1,000.00) 3,465.55 4,000.00 (534.45) 10,500.00 7,034.45 67.0%6315815 CM-R&M-Trees-Pruning Etc625.00 550.00 75.00 6,071.00 6,050.00 21.00 12,050.00 5,979.00 49.6%Total-CM-REPAIRS & MAINTENANCE16,075.78 17,650.00 (1,574.22) 51,646.13 52,400.00 (753.87) 118,350.00 66,703.87 56.4%6317836 Utilities-Natural Gas/LPG20.15 15.00 5.15 97.33 60.00 37.33 180.00 82.67 0.0%6317840 Telephones679.96 850.00 (170.04) 3,724.43 3,400.00 324.43 10,200.00 6,475.57 63.5%Total-CM-UTILITIES 700.11 865.00 (164.89) 3,821.76 3,460.00 361.76 10,380.00 6,558.24 63.2%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 400.00 500.00 (100.00) 1,600.00 2,000.00 (400.00) 6,000.00 4,400.00 73.3%6319100 Contract Svcs-Soil/Tissue Test- - - 226.68 2,000.00 (1,773.32) 4,000.00 3,773.32 94.3%6319102 Contract Svcs-Trash Removal694.00 524.00 170.00 3,119.86 2,096.00 1,023.86 6,288.00 3,168.14 50.4%6319150 Dues & Subscriptions55.00 - 55.00 265.00 - 265.00 540.00 275.00 50.9%6319170 Employee Education- 50.00 (50.00) - 200.00 (200.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental737.04 1,000.00 (262.96) 737.04 1,500.00 (762.96) 3,400.00 2,662.96 78.3%6319206 Licenses & Permits- - - 1,429.26 280.00 1,149.26 4,180.00 2,750.74 65.8%6319490 Miscellaneous32.30 100.00 (67.70) 569.55 400.00 169.55 1,200.00 630.45 52.5%6319718 Safety Equipment & Training561.59 800.00 (238.41) 1,578.37 1,850.00 (271.63) 3,850.00 2,271.63 59.0%6319822 Uniforms558.89 920.00 (361.11) 2,645.31 3,680.00 (1,034.69) 11,040.00 8,394.69 76.0%Total-CM-OTHER EXPENSES3,038.82 3,894.00 (855.18) 12,171.07 14,006.00 (1,834.93) 42,048.00 29,876.93 71.1%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementOctober 2016Annual Budget5 OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group4,531.25 2,728.00 1,803.25 11,606.00 10,912.00 694.00 32,736.00 21,130.00 64.5%6321325 Insurance-Workers Comp461.20 568.00 (106.80) 1,661.21 2,041.00 (379.79) 6,171.00 4,509.79 73.1%6321800 Taxes-Employer Payroll2,092.95 2,277.00 (184.05) 4,910.85 7,821.00 (2,910.15) 23,334.00 18,423.15 79.0%6321880 Wages-Hourly12,940.20 12,880.00 60.20 53,112.07 51,520.00 1,592.07 160,320.00 107,207.93 66.9%6321882 Wages-Overtime3,399.89 3,381.00 18.89 4,483.71 4,347.00 136.71 6,351.00 1,867.29 29.4%Total-CM-LM-SALARIES & BENEFITS 23,425.49 21,834.00 1,591.49 75,773.84 76,641.00 (867.16) 228,912.00 153,138.16 66.9%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 100.00 (100.00) - 400.00 (400.00) 1,025.00 1,025.00 100.0%6323788 Uniforms186.27 290.00 (103.73) 908.40 1,160.00 (251.60) 3,480.00 2,571.60 73.9%Total-CM-LM-SUPPLIES & MATERIALS 186.27 390.00 (203.73) 908.40 1,560.00 (651.60) 4,505.00 3,596.60 79.8%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 500.00 (500.00) - 1,500.00 (1,500.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE- 500.00 (500.00) - 1,500.00 (1,500.00) 4,250.00 4,250.00 100.0%264,747.90 280,814.00 (16,066.10) 639,204.87 656,419.00 (17,214.13) 1,712,795.00 1,073,590.13 62.7% OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping11,990.62 12,150.00 (159.38) 48,518.60 53,050.00 (4,531.40) 179,791.00 131,272.40 73.0%6337842 Utilities-Water6,033.42 6,090.00 (56.58) 31,829.10 34,162.00 (2,332.90) 45,338.00 13,508.90 29.8%18,024.04 18,240.00 (215.96) 80,347.70 87,212.00 (6,864.30) 225,129.00 144,781.30 64.3%Total-COURSE MAINTENANCECourse Maintenance Expense StatementOctober 2016Silverrock ResortAnnual BudgetMonth to Date Year to DateSilverrock ResortCourse Maintenance Water & EnergyOctober 2016Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual Budget6 OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 682.00 (682.00) - 2,728.00 (2,728.00) 8,184.00 8,184.00 100.0%6411325 Insurance-Workers Comp201.60 228.00 (26.40) 1,301.65 1,002.00 299.65 5,229.00 3,927.35 75.1%6411800 Taxes-Employer Payroll736.59 756.00 (19.41) 2,882.56 3,327.00 (444.44) 17,360.00 14,477.44 83.4%6411880 Wages-Hourly8,702.50 6,069.00 2,633.50 31,008.31 26,725.00 4,283.31 139,434.00 108,425.69 77.8%6411882 Wages-Overtime150.00 - 150.00 693.75 - 693.75 - (693.75) 0.0%Total-CBR-SALARIES & BENEFITS9,790.69 7,735.00 2,055.69 35,886.27 33,782.00 2,104.27 170,207.00 134,320.73 78.9%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- 500.00 (500.00) - 500.00 (500.00) 1,850.00 `0.0%6413742 Supplies-Expendable113.40 150.00 (36.60) 1,311.78 1,500.00 (188.22) 6,750.00 5,438.22 80.6%6413748 Supplies-Fuel for Shuttle- 100.00 (100.00) - 200.00 (200.00) 3,000.00 3,000.00 100.0%6413752 Supplies-Range Balls- - - - - - 9,000.00 9,000.00 100.0%6413762 Supplies-Office- 50.00 (50.00) - 125.00 (125.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels240.00 120.00 120.00 1,280.00 480.00 800.00 2,182.00 902.00 41.3%6413796 Supplies-Bottled Water108.00 50.00 58.00 8,117.54 3,650.00 4,467.54 11,000.00 2,882.46 26.2%Total-CBR-SUPPLIES & MATERIALS461.40 970.00 (508.60) 10,709.32 6,455.00 4,254.32 34,727.00 22,167.68 63.8%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment292.13 300.00 (7.87) 292.13 1,200.00 (907.87) 3,600.00 3,307.87 91.9%6415695 CBR-R&M-Cart Maintenance & Repair500.00 950.00 (450.00) 2,456.45 2,450.00 6.45 6,450.00 3,993.55 61.9%Total-CBR-REPAIRS & MAINTENANCE792.13 1,250.00 (457.87) 2,748.58 3,650.00 (901.42) 10,050.00 7,301.42 72.7%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen447.37 800.00 (352.63) 3,034.85 3,200.00 (165.15) 9,600.00 6,565.15 68.4%6419220 Freight/Delivery- 75.00 (75.00) - 300.00 (300.00) 450.00 450.00 100.0%6419490 Miscellaneous26.73 600.00 (573.27) 84.61 2,400.00 (2,315.39) 7,200.00 7,115.39 98.8%6419820 Uniforms2,880.44 2,000.00 880.44 2,880.44 2,000.00 880.44 5,200.00 2,319.56 44.6%Total-CBR-OTHER EXPENSES3,354.54 3,475.00 (120.46) 5,999.90 7,900.00 (1,900.10) 22,450.00 16,450.10 73.3%TOTAL-CARTS,BAGROOM & RANGE14,398.76 13,430.00 (120.46) 55,344.07 51,787.00 3,557.07 237,434.00 180,239.93 75.9%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp46.80 57.00 (10.20) 746.83 374.00 372.83 2,179.00 1,432.17 65.7%6431800 Taxes-Employer Payroll263.22 214.00 49.22 1,177.51 1,397.00 (219.49) 8,135.00 6,957.49 85.5%6431880 Wages-Hourly3,142.50 1,530.00 1,612.50 13,100.00 9,987.00 3,113.00 58,108.00 45,008.00 77.5%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS3,452.52 1,801.00 1,651.52 15,024.34 11,758.00 3,266.34 68,422.00 53,397.66 78.0%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 100.00 (100.00) 121.84 300.00 (178.16) 1,050.00 928.16 88.4%6439490 Miscellaneous- 50.00 (50.00) - 50.00 (50.00) 200.00 200.00 100.0%6439718 Safety Equipment & Training- 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6439820 Uniforms1,166.47 800.00 366.47 1,234.11 1,025.00 209.11 2,125.00 890.89 41.9%Total-CS-OTHER EXPENSES1,166.47 1,000.00 166.47 1,355.95 1,575.00 (219.05) 3,975.00 2,619.05 65.9%Total-COURSE SERVICES4,618.99 2,801.00 1,817.99 16,380.29 13,333.00 3,047.29 72,397.00 56,016.71 77.4%19,017.75 16,231.00 2,786.75 71,724.36 65,120.00 6,604.36 309,831.00 233,637.59 75.4%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementOctober 2016Annual Budget7 OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7%65-CH-UTILITIES6507836 Utilities-Natural Gas403.92 300.00 103.92 1,312.14 1,200.00 112.14 3,600.00 2,287.86 63.6%6507840 Utilities-Telephone1,141.68 1,150.00 (8.32) 4,553.32 4,600.00 (46.68) 13,800.00 9,246.68 67.0%6507842 Utilities-Water149.91 321.00 (171.09) 149.91 1,284.00 (1,134.09) 3,852.00 3,702.09 96.1%6507844 Utilities-Cable485.47 340.00 145.47 1,941.88 1,360.00 581.88 4,080.00 2,138.12 52.4%Total-CH-UTILITIES2,180.98 2,111.00 69.98 7,957.25 8,444.00 (486.75) 25,332.00 17,374.75 68.6%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,855.00 2,425.00 (570.00) 7,405.00 7,900.00 (495.00) 22,500.00 15,095.00 67.1%6509099 Contract Services-Security4,967.04 4,900.00 67.04 20,956.56 19,600.00 1,356.56 60,400.00 39,443.44 65.3%6509215 Flowers & Decorations191.19 500.00 (308.81) 254.92 500.00 (245.08) 1,900.00 1,645.08 86.6%6509490 Miscellaneous- 200.00 (200.00) 131.98 800.00 (668.02) 7,000.00 6,868.02 98.1%6509718 Safety Equipment & Training- 100.00 (100.00) 258.26 400.00 (141.74) 1,200.00 941.74 78.5%Total-CH-OTHER EXPENSES7,013.23 8,125.00 (1,111.77) 29,006.72 29,200.00 (193.28) 93,000.00 63,993.28 68.8%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures731.67 300.00 431.67 1,491.39 1,200.00 291.39 3,600.00 2,108.61 58.6%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 1,695.00 1,600.00 95.00 4,800.00 3,105.00 64.7%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) - 1,600.00 (1,600.00) 4,800.00 4,800.00 100.0%Total-CH-REPAIRS & MAINTENANCE731.67 1,100.00 (368.33) 3,186.39 4,400.00 (1,213.61) 13,200.00 10,013.61 75.9%10,325.88 11,736.00 (1,410.12) 41,750.36 43,644.00 (1,893.64) 136,332.00 20,027.22 14.7%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementOctober 2016Annual Budget8 OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group320.00 341.00 (21.00) 1,052.00 1,364.00 (312.00) 4,092.00 3,040.00 74.3%6601325 Insurance-Workers Comp87.20 94.00 (6.80) 360.10 376.00 (15.90) 1,129.00 768.90 68.1%6601720 Salaries2,504.96 2,508.00 (3.04) 8,719.84 10,032.00 (1,312.16) 30,096.00 21,376.16 71.0%6601800 Taxes-Employer Payroll144.80 351.00 (206.20) 580.40 1,404.00 (823.60) 4,213.00 3,632.60 86.2%Total-MKT-SALARIES & BENEFITS 3,056.96 3,294.00 (237.04) 10,712.34 13,176.00 (2,463.66) 39,530.00 28,817.66 72.9%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 212.71 100.00 112.71 598.73 400.00 198.73 1,200.00 601.27 50.1%6603768 Supplies-Printing & Stationery 215.84 3,000.00 (2,784.16) 1,217.24 3,200.00 (1,982.76) 4,425.00 3,207.76 72.5%428.55 3,100.00 (2,671.45) 1,815.97 3,600.00 (1,784.03) 5,625.00 3,809.03 67.7%66-MKT-UTILITIES6607840 Utilities-Telephone - 100.00 (100.00) 229.24 400.00 (170.76) 1,200.00 970.76 80.9%Total-MKT-UTILITIES- 100.00 (100.00) 229.24 400.00 (170.76) 1,200.00 970.76 80.9%66-MKT-OTHER EXPENSES6609010 Advertising17,033.50 13,322.00 3,711.50 45,541.06 31,509.00 14,032.06 178,987.00 133,445.94 74.6%6609040 Business Meals- 25.00 (25.00) - 100.00 (100.00) 300.00 300.00 100.0%6609080 Collateral Material2,000.00 500.00 1,500.00 2,000.00 500.00 1,500.00 5,500.00 3,500.00 63.6%6609102 Contract Services-Web Page99.00 150.00 (51.00) 396.00 600.00 (204.00) 1,800.00 1,404.00 78.0%6609490 Miscellaneous- - - 302.70 - 302.70 350.00 47.30 13.5%6609620 Postage- 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6609630 Promotion- 50.00 (50.00) 97.09 50.00 47.09 700.00 602.91 86.1%6609633 Promotion-Community- 75.00 (75.00) 310.27 300.00 10.27 2,250.00 1,939.73 86.2%6609634 Promotion-Media/Vendor- - - - - - 2,000.00 2,000.00 100.0%6609150 Dues and Subscriptions- - - 82.50 - 82.50 735.00 652.50 88.8%6609820 Uniforms- 300.00 (300.00) - 300.00 (300.00) 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES19,132.50 14,472.00 4,660.50 48,729.62 33,559.00 15,170.62 193,822.00 145,092.38 74.9%22,618.01 20,966.00 1,652.01 61,487.17 50,735.00 10,752.17 240,177.00 178,689.83 74.4%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementOctober 2016Annual Budget9 OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group 1,002.10 1,488.00 (485.90) 4,385.85 5,952.00 (1,566.15) 17,856.00 13,470.15 75.4%6701325 Insurance-Workers Comp517.20 617.00 (99.80) 2,208.72 2,422.00 (213.28) 7,717.00 5,508.28 71.4%6701720 Salaries13,500.10 13,850.00 (349.90) 52,363.10 54,200.00 (1,836.90) 177,996.00 125,632.90 70.6%6701800 Taxes-Employer Payroll213.54 2,303.00 (2,089.46) 4,949.46 9,044.00 (4,094.54) 28,812.00 23,862.54 82.8%6701880 Wages-Hourly2,363.10 2,600.00 (236.90) 11,677.70 10,400.00 1,277.70 27,800.00 16,122.30 58.0%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 17,596.04 20,858.00 (3,261.96) 75,584.83 82,018.00 (6,433.17) 260,181.00 184,596.17 70.9%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer471.24 500.00 (28.76) 1,215.39 2,000.00 (784.61) 6,300.00 5,084.61 80.7%6703762 Supplies-Office- 150.00 (150.00) 156.73 600.00 (443.27) 1,800.00 1,643.27 91.3%6703768 Supplies-Printing & Stationery- 100.00 (100.00) 476.87 400.00 76.87 3,300.00 2,823.13 85.5%Total-G&A-SUPPLIES & MATERIALS471.24 750.00 (278.76) 1,848.99 3,000.00 (1,151.01) 11,400.00 9,551.01 83.8%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment 4,409.38 100.00 4,309.38 4,428.38 300.00 4,128.38 1,900.00 (2,528.38) -133.1%Total-G&A-REPAIRS & MAINTENANCE 4,409.38 100.00 4,309.38 4,428.38 300.00 4,128.38 1,900.00 (2,528.38) -133.1%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance 500.00 500.00 - 2,000.00 2,000.00 - 4,800.00 2,800.00 58.3%6709150 Dues & Subscriptions- 50.00 (50.00) - 300.00 (300.00) 1,700.00 1,700.00 100.0%6709180 Employee Recruiting/Relocation30.00 200.00 (170.00) 60.00 400.00 (340.00) 1,400.00 1,340.00 95.7%6709197 Equipment Rental1,065.07 550.00 515.07 2,401.38 2,200.00 201.38 6,600.00 4,198.62 63.6%6709202 Fees-Bank- 90.00 (90.00) 353.58 360.00 (6.42) 1,080.00 726.42 67.3%6709208 Fees-Payroll Processing1,011.20 1,200.00 (188.80) 4,165.76 4,800.00 (634.24) 14,400.00 10,234.24 71.1%6709220 Freight/Delivery- 50.00 (50.00) 31.72 200.00 (168.28) 600.00 568.28 94.7%6709490 Miscellaneous- 100.00 (100.00) 170.87 400.00 (229.13) 1,200.00 1,029.13 85.8%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services126.56 75.00 51.56 399.78 300.00 99.78 900.00 500.22 55.6%6709625 Professional Fees1,345.00 850.00 495.00 4,222.42 3,400.00 822.42 10,200.00 5,977.58 58.6%6709636 Promotion/Entertainment- 100.00 (100.00) - 400.00 (400.00) 6,600.00 6,600.00 100.0%6709722 Seminars & Training550.00 200.00 350.00 800.00 800.00 - 2,400.00 1,600.00 66.7%6709810 Travel- - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 150.00 900.00 - 375.00 (375.00) 1,050.00 1,050.00 100.0%Total-G&A-OTHER EXPENSES 4,627.83 4,115.00 1,562.83 14,605.51 16,035.00 (1,429.49) 54,030.00 39,424.49 73.0%27,104.49 25,823.00 1,281.49 96,467.71 101,353.00 (4,885.29) 327,511.00 231,043.29 70.5%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementOctober 2016Annual Budget10 OctoberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts10,200.00 10,500.00 (300.00) 41,290.35 40,650.00 640.35 121,050.00 79,759.65 65.9%6800193 Equipment Leases-Maintenance 5,500.00 6,050.00 (550.00) 22,214.50 24,200.00 (1,985.50) 72,600.00 50,385.50 69.4%6800194 Equipment Leases-Trailer542.07 600.00 (57.93) 2,168.28 2,400.00 (231.72) 7,200.00 5,031.72 69.9%6800196 Equipment Leases-GPS4,500.00 4,700.00 (200.00) 22,860.00 18,800.00 4,060.00 56,400.00 33,540.00 59.5%6800197 Equipment Leases-Others413.63 1,150.00 (736.37) 9,935.13 4,600.00 5,335.13 13,800.00 3,864.87 0.0%21,155.70 23,000.00 (1,844.30) 98,468.26 90,650.00 7,818.26 271,050.00 172,581.74 63.7%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,653.00 8,653.00 - 34,611.40 34,612.00 (0.60) 99,840.00 65,228.60 65.3%6900210 FF&E Reserve1,487.92 275.00 1,212.92 6,646.16 2,214.00 4,432.16 63,985.00 57,338.84 89.6%6900800 Personal Property Taxes- 2,600.00 (2,600.00) 10,871.10 11,800.00 (928.90) 11,800.00 928.90 7.9%6900323 Insurance-Commercial12,700.50 2,700.00 10,000.50 18,973.84 10,800.00 8,173.84 26,400.00 7,426.16 28.1%22,841.42 14,228.00 8,613.42 71,102.50 59,426.00 11,676.50 202,025.00 130,922.50 64.8%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementOctober 2016Annual BudgetMonth to Date Year to Date11 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2016-20172016 2016 2016 2016 2016 2016Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia4 8SalesPromotionGolf IndustryVIPCelebrityPGA Comp34 45 47 20Charity/Gift Certificate184Rain/Wind Checks1Club Staff47 61 63 19LQ HS Golf588492 122 130 43002017 2017 2017 2017 2017 2017Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf Industry12