Loading...
02 August 2016 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2016 – August 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 AugustFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue71,244.75 31,755.00 39,489.75 124.4% 141,074.05 58,403.00 82,671.05 3,199,237.00 3,058,162.95 4%401000 Miscellaneous Golf Revenue5,407.00 2,460.00 2,947.00 119.8% 13,538.80 5,420.00 8,118.80 349,259.00 335,720.20 4%410000 Revenue-Golf Shop7,716.86 3,900.00 3,816.86 97.9% 16,181.89 7,323.00 8,858.89 278,585.00 262,403.11 6%420000 Revenue-F&B Concession500.00 500.00 - 0.0%1,000.00 1,000.00 - 12,000.00 11,000.00 8%890000 Interest Income0.13 - 0.13 0.13 - 0.13 - (0.13) 0%Total Income84,868.74 38,615.00 46,253.74 119.8% 171,794.87 72,146.00 99,648.87 3,839,081.00 3,667,286.13 4%Cost of Goods Sold510000 COS-Golf Shop5,145.74 2,183.00 2,962.74 -135.7% 9,861.96 4,099.34 (5,762.62) 155,924.00 146,062.04 6%Total COS5,145.74 2,183.00 2,962.74 -135.7% 9,861.96 4,099.34 (5,762.62) 155,924.00 146,062.04 6%Gross Profit79,723.00 36,432.00 43,291.00 118.8% 161,932.91 68,046.66 93,886.25 3,683,157.00 3,521,224.09 4%Expenses610000 Golf Pro Shop 13,528.94 12,827.00 701.94 -5.5% 25,508.90 25,654.00 (145.10) 204,827.00 179,318.10 12%630000 Course Maintenance126,363.77 123,480.00 2,883.77 -2.3% 239,750.45 237,510.00 2,240.45 1,712,795.00 1,473,044.55 14%633000 Maintenance Water & Energy21,715.48 22,810.00 (1,094.52) 4.8% 41,335.91 46,225.00 (4,889.09) 225,129.00 183,793.09 18%640000 Outside Services20,972.38 17,151.00 3,821.38 -22.3% 36,261.56 32,185.00 4,076.56 309,830.00 273,568.44 12%650000 Clubhouse11,397.73 10,636.00 761.73 -7.2% 20,852.74 21,272.00 (419.26) 136,332.00 115,479.26 15%660000 Marketing10,614.00 7,539.00 3,075.00 -40.8% 18,693.88 15,078.00 3,615.88 240,177.00 221,483.12 8%670000 General & Administrative23,292.56 25,598.00 (2,305.44) 9.0% 46,270.49 50,339.00 (4,068.51) 327,511.00 281,240.51 14%680000 Leases22,642.66 22,550.00 92.66 -0.4% 50,482.26 45,100.00 5,382.26 271,050.00 220,567.74 19%690000 Miscellaneous Other Expense12,879.52 11,988.00 891.52 -7.4% 31,880.16 29,074.00 2,806.16 202,025.00 170,144.84 16%Total Expenses263,407.04 254,579.00 8,828.04 -3.5% 511,036.35 502,437.00 (8,599.35) 3,629,676.00 3,118,639.65 14%(183,684.04) (218,147.00) 34,462.96 15.8%(349,103.44) (434,390.34) 85,286.90 53,481.00 402,584.44 0%Rounds of Golf PlayedPaid Rounds Played2,187 1,200 987 82.3%4,735 2,207 2,528 46,475 41,740 10%Ave $ Per Paid Round Green Fee32.58 26.46 6.11 23.1%29.79 26.46 3.33 68.84 39.04 43%Ave $ Per Paid Round Merchandise3.53 3.25 0.28 8.6%3.42 3.32 0.10 5.99 2.58 57%Ave $ Per Paid Miscellaneous 2.47 2.05 0.42 20.6%2.86 2.46 0.40 7.51 4.66 38%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateAugust 20161 Income AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees71,244.75 31,755.00 39,489.75 141,074.05 58,403.00 82,671.05 3,199,237.00 3,058,162.95 95.6%4010000 Rider Fee375.00 120.00 255.00 817.50 221.00 596.50 7,738.00 6,920.50 89.4%4040000 Club Rental575.00 600.00 (25.00) 1,575.00 1,104.00 471.00 23,238.00 21,663.00 93.2%4050000 Driving Range1,892.00 1,140.00 752.00 3,836.00 1,895.00 1,941.00 100,984.00 97,148.00 96.2%4060000 Handicap Fees- - - - - - 2,500.00 2,500.00 100.0%4080000 GPS Advertising- 100.00 (100.00) - 200.00 (200.00) 2,600.00 2,600.00 100.0%4090000 Ball Retriever/Subcontract - - - 995.30 1,000.00 (4.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 Issue2,565.00 500.00 2,065.00 6,315.00 1,000.00 5,315.00 171,200.00 164,885.00 96.3% Total Revenue Fees76,651.75 34,215.00 42,436.75 154,612.85 63,823.00 90,789.85 3,548,497.00 3,393,884.15 95.6%76,651.75 34,215.00 42,436.75 154,612.85 63,823.00 90,789.85 3,548,497.00 3,393,884.15 95.6%SilverRock ResortStatement of Fees RevenueAugust 2016Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$71,244.75$31,755.0039,489.75Favorable: At time of budget, back 9 was projected to be closed through October, however, the back 9 never closed, therefore rounds and revenues are above budget.ActualBudgetVariance$5,407.00 $2,460.00 2,947.00Favorable: At time of budget, back 9 was projected to be closed through October, however, the back 9 never closed, therefore Misc Revenues are above budget.ActualBudgetVariance$7,716.86 $3,900.00 3,816.86Favorable: At time of budget, back 9 was projected to be closed through October, however, the back 9 never closed, therefore Pro Shop Merchandise Sales are above budget.ExpensesPro Shop Cost of SalesActualBudgetVariance$5,145.74 $2,183.00 2,962.74Unfavorable: COS high due to discounting current inventory in an effort to move merchandise that wasn’t selling. With a new line coming out shortly inventory has to be reduced.ActualBudgetVariance$20,972.38$17,151.003,821.38Unfavorable: Due to timing of shipment of bottled water from Niagara, normally order 1/2 but the cost savings was significant enough to order a full shipment.ActualBudgetVariance$10,614.00$7,539.003,075.00Unfavorable: Due to timing of invoices for advertising and increased marketing expenses needed to inform golfers that all 18 holes are open. Pro Shop Merchandise SalesGolf Green Fee RevenueMiscellaneous Golf RevenueMarketingCartbarn-Course Servicesprovided for those cost of sales percentage that are greater than 5%.Variance ExplanationAugust 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 are3-20-133 Income AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous357.57 - 357.57 1,060.04 - 1,060.04 00 0%4100110 Sales Hard Goods3,845.41 1,365.00 2,480.41 7,644.55 2,563.00 5,081.55 97,505.00 89,860.45 92.2%4100112 Sales-Soft Goods4,845.00 2,535.00 2,310.00 9,581.00 4,760.00 4,821.00 181,080.00 171,499.00 94.7%5100639 GS-Discounts-Mdse (1,331.12) - (1,331.12) (2,103.70) - (2,103.70) - 2,103.70 0.0% Total Revenue Golf Shop7,716.86 3,900.00 3,816.86 16,181.89 7,323.00 8,858.89 278,585.00 263,463.15 94.6%COS 5100150 COS-GS-Hard Goods 2,107.24 791.70 1,315.54 4,081.79 1,486.54 2,595.25 56,552.90 52,471.11 92.8%5100151 COS-GS-Soft Goods 2,962.85 1,470.30 1,492.55 5,572.02 2,760.80 2,811.22 105,026.40 99,454.38 94.7%5100152 COS-GS-Purchase Disc- (113.00) 113.00 (5.77) (212.00) 206.23 (8,079.00) (8,073.23) 99.9%5100220 COS-GS-Freight Merch 75.65 34.00 41.65 213.92 64.00 149.92 2,424.00 2,210.08 91.2%Cost of Sales - Golf Shop5,145.74 2,183.00 2,962.74 9,861.96 4,099.34 5,762.62 155,924.30 146,062.34 93.7%Gross Profit 2,571.12 1,717.00 854.12 6,319.93 3,223.66 3,096.27 122,660.70 117,400.81 95.7%COS % 66.7% 56.0% -10.7% 60.9% 56.0% -5.0% 53.1% 55.4% 104.4%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group1,713.23 1,705.00 8.23 2,658.31 3,410.00 (751.69) 27,621.00 24,962.69 90.4%6101325 Insurance-Workers Comp 558.93 319.00 239.93 879.99 638.00 241.99 5,042.00 4,162.01 82.5%6101720 Salaries4,002.00 4,001.00 1.00 8,004.00 8,002.00 2.00 45,000.00 36,996.00 82.2%6101800 Taxes-Employer Payroll 748.21 1,190.00 (441.79) 1,478.94 2,380.00 (901.06) 18,825.00 17,346.06 92.1%6101880 Wages-Hourly5,320.06 4,502.00 818.06 10,696.03 9,004.00 1,692.03 89,463.00 78,766.97 88.0%6101882 Wages-Overtime- - - - - - - 952.88 0.0%Total -PS-SALARIES & BENEFITS 12,342.43 11,717.00 625.43 23,717.27 23,434.00 283.27 185,951.00 163,186.61 87.8%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office- 250.00 (250.00) - 500.00 (500.00) 3,000.00 3,000.00 100.0%6109220 Freight & Delivery25.33 - 25.33 2.33 - 2.33 75.00 72.67 96.9%6109490 Miscellaneous500.00 500.00 - 1,000.00 1,000.00 - 6,000.00 5,000.00 83.3%6109150 Dues and Subscriptions- - - - - - 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short(0.91) - (0.91) 55.02 - 55.02 - (55.02) 0.0%6109722 Seminars/Training- 150.00 (150.00) - 300.00 (300.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- - - - - - 90.00 90.00 100.0%6109820 Uniforms603.03 100.00 503.03 616.16 200.00 416.16 2,400.00 1,783.84 74.3%6117840 Telephones59.06 110.00 (50.94) 118.12 220.00 (101.88) 1,320.00 1,201.88 91.1%1,186.51 1,110.00 76.51 1,791.63 2,220.00 (428.37) 18,875.00 17,083.37 90.5%13,528.94 12,827.00 701.94 25,508.90 25,654.00 (145.10) 204,826.00 180,269.98 88.0%Net Income(10,957.82) (11,110.00) 152.18 (19,188.97) (22,430.34) 3,241.37 (82,165.30) (62,869.17) 76.5%SilverRock ResortGolf Shop Income StatementAugust 2016Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group10,969.74 8,990.00 1,979.74 19,006.29 17,980.00 1,026.29 107,880.00 88,873.71 82.4%6311325 Insurance-Workers Comp2,558.76 1,663.00 895.76 3,959.96 3,326.00 633.96 24,794.00 20,834.04 84.0%6311720 Salaries10,620.80 9,333.33 1,287.47 21,241.60 18,666.66 2,574.94 142,017.20 120,775.60 85.0%6311800 Taxes-Employer Payroll3,925.06 6,207.00 (2,281.94) 7,810.01 12,414.00 (4,603.99) 93,302.00 85,491.99 91.6%6311880 Wages-Hourly37,810.28 35,003.67 2,806.61 77,478.18 70,007.34 7,470.84 508,481.80 431,003.62 84.8%6311882 Wages-Overtime6.19 - 6.19 56.41 - 56.41 15,945.00 15,888.59 99.6%Total-CM-SALARIES & BENEFITS65,890.83 61,197.00 4,693.83 129,552.45 122,394.00 7,158.45 892,420.00 762,867.55 85.5%63-CM-SUPPLIES & MATERIALS6313734 Chemicals- 2,500.00 (2,500.00) 4,818.61 5,500.00 (681.39) 34,600.00 29,781.39 86.1%6313744 Fertilizer13,218.70 16,000.00 (2,781.30) 18,733.09 25,000.00 (6,266.91) 112,500.00 93,766.91 83.3%6313745 Herbicides- - - - - - 17,000.00 17,000.00 100.0%6313746 Flowers/Plants- - - - - - 3,050.00 3,050.00 100.0%6313748 Fuel-Gasoline4,645.89 4,800.00 (154.11) 8,143.17 9,600.00 (1,456.83) 55,020.00 46,876.83 85.2%6313750 Golf Course Accessories- 200.00 (200.00) 110.85 400.00 (289.15) 13,000.00 12,889.15 99.1%6313756 POA Control- - - - - - 7,000.00 7,000.00 100.0%6313758 Miscellaneous Supp774.43 750.00 24.43 1,603.17 1,500.00 103.17 4,350.00 2,746.83 63.1%6313762 Supplies-Office557.65 - 557.65 645.39 - 645.39 - (645.39) 0.0%6313774 Sand740.57 390.00 350.57 1,928.57 780.00 1,148.57 13,460.00 11,531.43 85.7%6313776 Seed1,754.46 350.00 1,404.46 2,618.46 700.00 1,918.46 125,900.00 123,281.54 97.9%6313778 Small Tools & Non-Capital Equip371.19 100.00 271.19 470.32 200.00 270.32 5,000.00 4,529.68 90.6%6313780 Sod4,813.83 2,500.00 2,313.83 6,696.89 3,500.00 3,196.89 10,450.00 3,753.11 35.9%6313782 Topdressing2,251.34 2,500.00 (248.66) 2,251.34 2,500.00 (248.66) 10,600.00 8,348.66 78.8%Total-CM-SUPPLIES & MATERIALS29,128.06 30,090.00 (961.94) 48,019.86 49,680.00 (1,660.14) 411,930.00 363,910.14 88.3%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint3,070.00 2,600.00 470.00 5,660.00 5,200.00 460.00 31,200.00 25,540.00 81.9%6315685 CM-R&M-Bldngs & Othr Structures 763.05 750.00 13.05 913.33 2,000.00 (1,086.67) 5,550.00 4,636.67 83.5%6315690 CM-R&M-Equipment2,792.21 2,500.00 292.21 5,028.80 4,500.00 528.80 40,000.00 34,971.20 87.4%6315692 CM-R&M-Irrigation System1,539.89 3,500.00 (1,960.11) 5,023.56 7,900.00 (2,876.44) 19,050.00 14,026.44 73.6%6315696 CM-R&M-Pumps1,191.39 1,000.00 191.39 2,609.15 2,000.00 609.15 10,500.00 7,890.85 75.2%6315815 CM-R&M-Trees-Pruning Etc- - - - - - 12,050.00 12,050.00 100.0%Total-CM-REPAIRS & MAINTENANCE9,356.54 10,350.00 (993.46) 19,234.84 21,600.00 (2,365.16) 118,350.00 99,115.16 83.7%6317836 Utilities-Natural Gas/LPG 38.61 15.00 23.61 38.61 30.00 8.61 180.00 141.39 0.0%6317840 Telephones739.83 850.00 (110.17) 1,917.39 1,700.00 217.39 10,200.00 8,282.61 81.2%Total-CM-UTILITIES778.44 865.00 (86.56) 1,956.00 1,730.00 226.00 10,380.00 8,424.00 81.2%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 500.00 (100.00) 800.00 1,000.00 (200.00) 6,000.00 5,200.00 86.7%6319100 Contract Svcs-Soil/Tissue Test- - - - - - 4,000.00 4,000.00 100.0%6319102 Contract Svcs-Trash Removal694.00 524.00 170.00 1,470.00 1,048.00 422.00 6,288.00 4,818.00 76.6%6319150 Dues & Subscriptions- - - - - - 540.00 540.00 100.0%6319170 Employee Education- 50.00 (50.00) - 100.00 (100.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental- 150.00 (150.00) - 350.00 (350.00) 3,400.00 3,400.00 100.0%6319206 Licenses & Permits750.00 100.00 650.00 1,200.00 200.00 1,000.00 4,180.00 2,980.00 71.3%6319490 Miscellaneous130.50 100.00 30.50 458.33 200.00 258.33 1,200.00 741.67 61.8%6319718 Safety Equipment & Training602.06 100.00 502.06 602.06 300.00 302.06 3,850.00 3,247.94 84.4%6319822 Uniforms741.50 920.00 (178.50) 1,435.60 1,840.00 (404.40) 11,040.00 9,604.40 87.0%Total-CM-OTHER EXPENSES3,318.06 2,444.00 874.06 5,965.99 5,038.00 927.99 42,048.00 36,082.01 85.8%Month to DateYear to DateSilverRock ResortCourse Maintenance Expense StatementAugust 2016Annual Budget5 AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,200.00 2,728.00 (528.00) 4,851.00 5,456.00 (605.00) 32,736.00 27,885.00 85.2%6321325 Insurance-Workers Comp498.79 483.00 15.79 939.99 966.00 (26.01) 6,171.00 5,231.01 84.8%6321800 Taxes-Employer Payroll935.81 1,803.00 (867.19) 1,878.25 3,606.00 (1,727.75) 23,334.00 21,455.75 92.0%6321880 Wages-Hourly13,889.58 12,880.00 1,009.58 26,741.55 25,760.00 981.55 160,320.00 133,578.45 83.3%6321882 Wages-Overtime- - - 24.33 - 24.33 6,351.00 6,326.67 99.6%Total-CM-LM-SALARIES & BENEFITS17,524.18 17,894.00 (369.82) 34,435.12 35,788.00 (1,352.88) 228,912.00 194,476.88 85.0%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 100.00 (100.00) - 200.00 (200.00) 1,025.00 1,025.00 100.0%6323788 Uniforms367.66 290.00 77.66 586.19 580.00 6.19 3,480.00 2,893.81 83.2%Total-CM-LM-SUPPLIES & MATERIALS367.66 390.00 (22.34) 586.19 780.00 (193.81) 4,505.00 3,918.81 87.0%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 250.00 (250.00) - 500.00 (500.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE- 250.00 (250.00) - 500.00 (500.00) 4,250.00 4,250.00 100.0%126,363.77 123,480.00 2,883.77 239,750.45 237,510.00 2,240.45 1,712,795.00 1,473,044.55 86.0% AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 12,183.24 13,820.00 (1,636.76) 24,448.24 27,085.00 (2,636.76) 179,791.00 155,342.76 86.4%6337842 Utilities-Water9,532.24 8,990.00 542.24 16,887.67 19,140.00 (2,252.33) 45,338.00 28,450.33 62.8%21,715.48 22,810.00 (1,094.52) 41,335.91 46,225.00 (4,889.09) 225,129.00 183,793.09 81.6%Total-COURSE MAINTENANCECourse Maintenance Expense StatementAugust 2016Silverrock ResortAnnual BudgetMonth to DateYear to DateSilverrock ResortCourse Maintenance Water & EnergyAugust 2016Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual Budget6 AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 682.00 (682.00) - 1,364.00 (1,364.00) 8,184.00 8,184.00 100.0%6411325 Insurance-Workers Comp225.16 215.00 10.16 466.66 473.00 (6.34) 5,229.00 4,762.34 91.1%6411800 Taxes-Employer Payroll685.32 714.00 (28.68) 1,403.52 1,571.00 (167.48) 17,360.00 15,956.48 91.9%6411880 Wages-Hourly6,432.52 5,738.00 694.52 13,935.02 12,623.00 1,312.02 139,434.00 125,498.98 90.0%6411882 Wages-Overtime 322.50 - 322.50 390.00 - 390.00 - (390.00) 0.0%Total-CBR-SALARIES & BENEFITS7,665.50 7,349.00 316.50 16,195.20 16,031.00 164.20 170,207.00 154,011.80 90.5%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- - - - - - 1,850.00 `0.0%6413742 Supplies-Expendable338.04 600.00 (261.96) 1,147.56 1,200.00 (52.44) 6,750.00 5,602.44 83.0%6413748 Supplies-Fuel for Shuttle- - - - - - 3,000.00 3,000.00 100.0%6413752 Supplies-Range Balls- - - - - - 9,000.00 9,000.00 100.0%6413762 Supplies-Office- 25.00 (25.00) - 50.00 (50.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels 240.00 120.00 120.00 560.00 240.00 320.00 2,182.00 1,622.00 74.3%6413796 Supplies-Bottled Water7,258.15 3,500.00 3,758.15 7,685.54 3,550.00 4,135.54 11,000.00 3,314.46 30.1%Total-CBR-SUPPLIES & MATERIALS7,836.19 4,245.00 3,591.19 9,393.10 5,040.00 4,353.10 34,727.00 23,483.90 67.6%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment- 300.00 (300.00) - 600.00 (600.00) 3,600.00 3,600.00 100.0%6415695 CBR-R&M-Cart Maintenance & Repair 500.00 500.00 - 1,456.45 1,000.00 456.45 6,450.00 4,993.55 77.4%Total-CBR-REPAIRS & MAINTENANCE500.00 800.00 (300.00) 1,456.45 1,600.00 (143.55) 10,050.00 8,593.55 85.5%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen863.73 800.00 63.73 1,523.79 1,600.00 (76.21) 9,600.00 8,076.21 84.1%6419220 Freight/Delivery- 75.00 (75.00) - 150.00 (150.00) 450.00 450.00 100.0%6419490 Miscellaneous57.88 600.00 (542.12) 57.88 1,200.00 (1,142.12) 7,200.00 7,142.12 99.2%6419820 Uniforms - - - - - - 5,200.00 5,200.00 100.0%Total-CBR-OTHER EXPENSES921.61 1,475.00 (553.39) 1,581.67 2,950.00 (1,368.33) 22,450.00 20,868.33 93.0%TOTAL-CARTS,BAGROOM & RANGE16,923.30 13,869.00 (553.39) 28,626.42 25,621.00 3,005.42 237,434.00 206,957.58 87.2%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp198.30 99.00 99.30 280.00 198.00 82.00 2,179.00 1,899.00 87.2%6431800 Taxes-Employer Payroll340.64 369.00 (28.36) 628.16 738.00 (109.84) 8,135.00 7,506.84 92.3%6431880 Wages-Hourly3,442.50 2,639.00 803.50 6,537.50 5,278.00 1,259.50 58,108.00 51,570.50 88.7%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS3,981.44 3,107.00 874.44 7,445.66 6,214.00 1,231.66 68,422.00 60,976.34 89.1%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 50.00 (50.00) 121.84 100.00 21.84 1,050.00 928.16 88.4%6439490 Miscellaneous- - - - - - 200.00 200.00 100.0%6439718 Safety Equipment & Training- 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0%6439820 Uniforms 67.64 75.00 (7.36) 67.64 150.00 (82.36) 2,125.00 2,057.36 96.8%Total-CS-OTHER EXPENSES67.64 175.00 (107.36) 189.48 350.00 (160.52) 3,975.00 3,785.52 95.2%Total-COURSE SERVICES4,049.08 3,282.00 767.08 7,635.14 6,564.00 1,071.14 72,397.00 64,761.86 89.5%20,972.38 17,151.00 3,821.38 36,261.56 32,185.00 4,076.56 309,831.00 267,933.92 86.5%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementAugust 2016Annual Budget7 AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 800.00 800.00 - 4,800.00 4,000.00 83.3%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 800.00 800.00 - 4,800.00 4,000.00 83.3%65-CH-UTILITIES6507836 Utilities-Natural Gas359.16 300.00 59.16 531.17 600.00 (68.83) 3,600.00 3,068.83 85.2%6507840 Utilities-Telephone1,186.52 1,150.00 36.52 2,276.52 2,300.00 (23.48) 13,800.00 11,523.48 83.5%6507842 Utilities-Water- 321.00 (321.00) - 642.00 (642.00) 3,852.00 3,852.00 100.0%6507844 Utilities-Cable485.47 340.00 145.47 970.94 680.00 290.94 4,080.00 3,109.06 76.2%Total-CH-UTILITIES2,031.15 2,111.00 (79.85) 3,778.63 4,222.00 (443.37) 25,332.00 21,553.37 85.1%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 1,825.00 1,825.00 - 3,650.00 3,650.00 - 22,500.00 18,850.00 83.8%6509099 Contract Services-Security5,094.72 4,900.00 194.72 10,253.28 9,800.00 453.28 60,400.00 50,146.72 83.0%6509215 Flowers & Decorations- - - 63.73 - 63.73 1,900.00 1,836.27 96.6%6509490 Miscellaneous- 200.00 (200.00) 24.68 400.00 (375.32) 7,000.00 6,975.32 99.6%6509718 Safety Equipment & Training258.26 100.00 158.26 258.26 200.00 58.26 1,200.00 941.74 78.5%Total-CH-OTHER EXPENSES7,177.98 7,025.00 152.98 14,249.95 14,050.00 199.95 93,000.00 78,750.05 84.7%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures288.60 300.00 (11.40) 524.16 600.00 (75.84) 3,600.00 3,075.84 85.4%6515686 CH-R&M-Restaurant Repairs 1,500.00 400.00 1,100.00 1,500.00 800.00 700.00 4,800.00 3,300.00 68.8%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) - 800.00 (800.00) 4,800.00 4,800.00 100.0%Total-CH-REPAIRS & MAINTENANCE1,788.60 1,100.00 688.60 2,024.16 2,200.00 (175.84) 13,200.00 11,175.84 84.7%11,397.73 10,636.00 761.73 20,852.74 21,272.00 (419.26) 136,332.00 22,351.68 16.4%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementAugust 2016Annual Budget8 AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 54.00 341.00 (287.00) 392.00 682.00 (290.00) 4,092.00 3,700.00 90.4%6601325 Insurance-Workers Comp87.00 94.00 (7.00) 174.90 188.00 (13.10) 1,129.00 954.10 84.5%6601720 Salaries2,404.96 2,508.00 (103.04) 4,309.92 5,016.00 (706.08) 30,096.00 25,786.08 85.7%6601800 Taxes-Employer Payroll145.20 351.00 (205.80) 290.40 702.00 (411.60) 4,213.00 3,922.60 93.1%Total-MKT-SALARIES & BENEFITS2,691.16 3,294.00 (602.84) 5,167.22 6,588.00 (1,420.78) 39,530.00 34,362.78 86.9%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery 258.54 - 258.54 534.47 - 534.47 4,425.00 3,890.53 87.9%258.54 100.00 158.54 534.47 200.00 334.47 5,625.00 5,090.53 90.5%66-MKT-UTILITIES6607840 Utilities-Telephone 63.08 100.00 (36.92) 130.16 200.00 (69.84) 1,200.00 1,069.84 89.2%Total-MKT-UTILITIES63.08 100.00 (36.92) 130.16 200.00 (69.84) 1,200.00 1,069.84 89.2%66-MKT-OTHER EXPENSES6609010 Advertising 7,191.95 3,745.00 3,446.95 12,353.76 7,490.00 4,863.76 178,987.00 166,633.24 93.1%6609040 Business Meals- 25.00 (25.00) - 50.00 (50.00) 300.00 300.00 100.0%6609080 Collateral Material- - - - - - 5,500.00 5,500.00 100.0%6609102 Contract Services-Web Page99.00 150.00 (51.00) 198.00 300.00 (102.00) 1,800.00 1,602.00 89.0%6609490 Miscellaneous- - - - - - 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0%6609630 Promotion- - - - - - 700.00 700.00 100.0%6609633 Promotion-Community310.27 75.00 235.27 310.27 150.00 160.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- - - - - - 735.00 735.00 100.0%6609820 Uniforms- - - - - - 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES7,601.22 4,045.00 3,556.22 12,862.03 8,090.00 4,772.03 193,822.00 180,959.97 93.4%10,614.00 7,539.00 3,075.00 18,693.88 15,078.00 3,615.88 240,177.00 221,483.12 92.2%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementAugust 2016Annual Budget9 AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group979.86 1,488.00 (508.14) 2,260.86 2,976.00 (715.14) 17,856.00 15,595.14 87.3%6701325 Insurance-Workers Comp550.00 617.00 (67.00) 1,131.50 1,211.00 (79.50) 7,717.00 6,585.50 85.3%6701720 Salaries13,821.00 13,850.00 (29.00) 26,242.00 27,100.00 (858.00) 177,996.00 151,754.00 85.3%6701800 Taxes-Employer Payroll1,256.08 2,303.00 (1,046.92) 2,565.23 4,522.00 (1,956.77) 28,812.00 26,246.77 91.1%6701880 Wages-Hourly2,598.20 2,600.00 (1.80) 6,632.40 5,200.00 1,432.40 27,800.00 21,167.60 76.1%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS19,205.14 20,858.00 (1,652.86) 38,831.99 41,009.00 (2,177.01) 260,181.00 221,349.01 85.1%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer429.00 500.00 (71.00) 429.00 1,000.00 (571.00) 6,300.00 5,871.00 93.2%6703762 Supplies-Office- 150.00 (150.00) - 300.00 (300.00) 1,800.00 1,800.00 100.0%6703768 Supplies-Printing & Stationery128.96 100.00 28.96 128.96 200.00 (71.04) 3,300.00 3,171.04 96.1%Total-G&A-SUPPLIES & MATERIALS557.96 750.00 (192.04) 557.96 1,500.00 (942.04) 11,400.00 10,842.04 95.1%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment 19.00 100.00 (81.00) 19.00 100.00 (81.00) 1,900.00 1,881.00 99.0%Total-G&A-REPAIRS & MAINTENANCE19.00 100.00 (81.00) 19.00 100.00 (81.00) 1,900.00 1,881.00 99.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 1,000.00 1,000.00 - 4,800.00 3,800.00 79.2%6709150 Dues & Subscriptions- - - - 50.00 (50.00) 1,700.00 1,700.00 100.0%6709180 Employee Recruiting/Relocation- - - - - - 1,400.00 1,400.00 100.0%6709197 Equipment Rental461.53 550.00 (88.47) 851.09 1,100.00 (248.91) 6,600.00 5,748.91 87.1%6709202 Fees-Bank117.04 90.00 27.04 232.88 180.00 52.88 1,080.00 847.12 78.4%6709208 Fees-Payroll Processing1,127.02 1,200.00 (72.98) 2,141.04 2,400.00 (258.96) 14,400.00 12,258.96 85.1%6709220 Freight/Delivery20.97 50.00 (29.03) 31.72 100.00 (68.28) 600.00 568.28 94.7%6709490 Miscellaneous7.17 100.00 (92.83) 7.17 200.00 (192.83) 1,200.00 1,192.83 99.4%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services220.23 75.00 145.23 273.22 150.00 123.22 900.00 626.78 69.6%6709625 Professional Fees1,056.50 850.00 206.50 2,324.42 1,700.00 624.42 10,200.00 7,875.58 77.2%6709636 Promotion/Entertainment- 100.00 (100.00) - 200.00 (200.00) 6,600.00 6,600.00 100.0%6709722 Seminars & Training- 200.00 (200.00) - 400.00 (400.00) 2,400.00 2,400.00 100.0%6709810 Travel- 100.00 (100.00) - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 900.00 - 150.00 (150.00) 1,050.00 1,050.00 100.0%Total-G&A-OTHER EXPENSES3,510.46 3,890.00 595.46 6,861.54 7,730.00 (868.46) 54,030.00 47,168.46 87.3%23,292.56 25,598.00 (2,305.44) 46,270.49 50,339.00 (4,068.51) 327,511.00 281,240.51 85.9%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementAugust 2016Annual Budget10 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts10,363.45 10,050.00 313.45 10,363.45 10,050.00 313.45 121,050.00 110,686.55 91.4%6800193 Equipment Leases-Maintenance 5,571.50 6,050.00 (478.50) 5,571.50 6,050.00 (478.50) 72,600.00 67,028.50 92.3%6800194 Equipment Leases-Trailer542.07 600.00 (57.93) 542.07 600.00 (57.93) 7,200.00 6,657.93 92.5%6800196 Equipment Leases-GPS4,480.00 4,700.00 (220.00) 4,480.00 4,700.00 (220.00) 56,400.00 51,920.00 92.1%6800197 Equipment Leases-Others2,022.58 1,150.00 872.58 2,022.58 1,150.00 872.58 13,800.00 11,777.42 0.0%22,979.60 22,550.00 429.60 22,979.60 22,550.00 429.60 271,050.00 248,070.40 91.5%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,652.80 8,653.00 (0.20) 8,652.80 8,653.00 (0.20) 99,840.00 91,187.20 91.3%6900210 FF&E Reserve1,396.59 533.00 863.59 1,396.59 533.00 863.59 63,985.00 62,588.41 97.8%6900800 Personal Property Taxes5,540.00 5,200.00 340.00 5,540.00 5,200.00 340.00 11,800.00 6,260.00 53.1%6900323 Insurance-Commercial3,405.25 2,700.00 705.25 3,405.25 2,700.00 705.25 26,400.00 22,994.75 87.1%18,994.64 17,086.00 1,908.64 18,994.64 17,086.00 1,908.64 202,025.00 183,030.36 90.6%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementJuly 2016Annual BudgetMonth to DateYear to Date11 AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts10,363.45 10,050.00 313.45 20,726.90 20,100.00 626.90 121,050.00 100,323.10 82.9%6800193 Equipment Leases-Maintenance 5,571.50 6,050.00 (478.50) 11,143.00 12,100.00 (957.00) 72,600.00 61,457.00 84.7%6800194 Equipment Leases-Trailer802.07 600.00 202.07 1,344.14 1,200.00 144.14 7,200.00 5,855.86 81.3%6800196 Equipment Leases-GPS4,520.00 4,700.00 (180.00) 13,860.00 9,400.00 4,460.00 56,400.00 42,540.00 75.4%6800197 Equipment Leases-Others1,385.64 1,150.00 235.64 3,408.22 2,300.00 1,108.22 13,800.00 10,391.78 0.0%22,642.66 22,550.00 92.66 50,482.26 45,100.00 5,382.26 271,050.00 220,567.74 81.4%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,652.80 8,653.00 (0.20) 17,305.60 17,306.00 (0.40) 99,840.00 82,534.40 82.7%6900210 FF&E Reserve1,424.90 635.00 789.90 2,821.49 1,168.00 1,653.49 63,985.00 61,163.51 95.6%6900800 Personal Property Taxes(60.27) - (60.27) 5,479.73 5,200.00 279.73 11,800.00 6,320.27 53.6%6900323 Insurance-Commercial2,862.09 2,700.00 162.09 6,273.34 5,400.00 873.34 26,400.00 20,126.66 76.2%12,879.52 11,988.00 891.52 31,880.16 29,074.00 2,806.16 202,025.00 170,144.84 84.2%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementAugust 2016Annual BudgetMonth to Date Year to Date12 SilverRock Resort‐Arnold Palmer Classic CourseComp Golf Report‐2016‐20172016 2016 2016 2016 2016 2016Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia4SalesPromotionGolf IndustryVIPCelebrityPGA Comp34 45Charity/Gift Certificate18Rain/Wind Checks1Club Staff47 61LQ HS Golf589212200002017 2017 2017 2017 2017 2017Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000013