Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
03 September 2016 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2016 – September 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 SeptemberFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue116,837.60 38,535.00 78,302.60 203.2% 257,911.65 96,938.00 160,973.65 3,199,237.00 2,941,325.35 8%401000 Miscellaneous Golf Revenue11,844.00 2,840.00 9,004.00 317.0% 25,382.80 8,260.00 17,122.80 349,259.00 323,876.20 7%410000 Revenue-Golf Shop10,637.45 6,440.00 4,197.45 65.2% 26,819.34 13,763.00 13,056.34 278,585.00 251,765.66 10%420000 Revenue-F&B Concession500.00 500.00 - 0.0%1,500.00 1,500.00 - 12,000.00 10,500.00 13%890000 Interest Income0.04 - 0.04 0.17 - 0.17 - (0.17) 0%Total Income139,819.09 48,315.00 91,504.09 189.4% 311,613.96 120,461.00 191,152.96 3,839,081.00 3,527,467.04 8%Cost of Goods Sold510000 COS-Golf Shop5,934.93 3,604.20 2,330.73 -64.7% 15,796.89 7,703.54 (8,093.35) 155,924.00 140,127.11 10%Total COS5,934.93 3,604.20 2,330.73 -64.7% 15,796.89 7,703.54 (8,093.35) 155,924.00 140,127.11 10%Gross Profit133,884.16 44,710.80 89,173.36 199.4% 295,817.07 112,757.46 183,059.61 3,683,157.00 3,387,339.93 8%Expenses610000 Golf Pro Shop 13,251.17 12,452.00 799.17 -6.4% 38,761.07 38,106.00 655.07 204,827.00 166,065.93 19%630000 Course Maintenance134,706.52 138,095.00 (3,388.48) 2.5% 374,456.97 375,605.00 (1,148.03) 1,712,795.00 1,338,338.03 22%633000 Maintenance Water & Energy20,987.75 22,747.00 (1,759.25) 7.7% 62,323.66 68,972.00 (6,648.34) 225,129.00 162,805.34 28%640000 Outside Services16,445.05 16,704.00 (258.95) 1.6% 52,706.61 48,889.00 3,817.61 309,830.00 257,123.39 17%650000 Clubhouse10,571.74 10,636.00 (64.26) 0.6% 31,424.48 31,908.00 (483.52) 136,332.00 104,907.52 23%660000 Marketing20,175.28 14,691.00 5,484.28 -37.3% 38,869.16 29,769.00 9,100.16 240,177.00 201,307.84 16%670000 General & Administrative21,563.97 25,003.00 (3,439.03) 13.8% 67,834.46 75,342.00 (7,507.54) 327,511.00 259,676.54 21%680000 Leases26,830.30 22,550.00 4,280.30 -19.0% 77,312.56 67,650.00 9,662.56 271,050.00 193,737.44 29%690000 Miscellaneous Other Expense16,380.92 16,124.00 256.92 -1.6% 48,261.08 45,198.00 3,063.08 202,025.00 153,763.92 24%Total Expenses280,912.70 279,002.00 1,910.70 -0.7% 791,950.05 781,439.00 (10,511.05) 3,629,676.00 2,837,725.95 22%(147,028.54) (234,291.20) 87,262.66 37.2%(496,132.98) (668,681.54) 172,548.56 53,481.00 549,613.98 0%Rounds of Golf PlayedPaid Rounds Played3,015 1,400 1,615 115.4%7,750 3,600 4,150 46,475 38,725 17%Ave $ Per Paid Round Green Fee38.75 27.53 11.23 40.8%33.28 26.93 6.35 68.84 35.56 48%Ave $ Per Paid Round Merchandise3.53 4.60 (1.07) -23.3%3.46 3.82 (0.36) 5.99 2.53 58%Ave $ Per Paid Miscellaneous 3.93 2.03 1.90 93.7%3.28 2.29 0.98 7.51 4.24 44%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateSeptember 20161 Income SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees116,837.60 38,535.00 78,302.60 257,911.65 96,938.00 160,973.65 3,199,237.00 2,941,325.35 91.9%4010000 Rider Fee600.00 140.00 460.00 1,417.50 361.00 1,056.50 7,738.00 6,320.50 81.7%4040000 Club Rental1,410.00 700.00 710.00 2,985.00 1,804.00 1,181.00 23,238.00 20,253.00 87.2%4050000 Driving Range3,069.00 1,400.00 1,669.00 6,905.00 3,295.00 3,610.00 100,984.00 94,079.00 93.2%4060000 Handicap Fees- - - - - - 2,500.00 2,500.00 100.0%4080000 GPS Advertising- 100.00 (100.00) - 300.00 (300.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 Issue6,765.00 500.00 6,265.00 13,080.00 1,500.00 11,580.00 171,200.00 158,120.00 92.4% Total Revenue Fees128,681.60 41,375.00 87,306.60 283,294.45 105,198.00 178,096.45 3,548,497.00 3,265,202.55 92.0%128,681.60 41,375.00 87,306.60 283,294.45 105,198.00 178,096.45 3,548,497.00 3,265,202.55 92.0%SilverRock ResortStatement of Fees RevenueSeptember 2016Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$116,837.60 $38,535.00 78,302.60Favorable: Back 9 was scheduled & budgeted to be closed this summer, however, all 18 holes remained open and revenues are higher than budgeted as a result. ActualBudgetVariance$11,844.00$2,840.009,004.00Favorable: Due to projected closure of nine holes budget projections were reduced, also, sale of resident cards was high.ActualBudgetVariance$10,637.45$6,440.004,197.45Favorable: Due to projected closure of nine holes budget projections were reduced.ExpensesActualBudgetVariance$20,175.28$14,691.005,484.28Unfavorable: Marketing budget was orginally reduced as a result of the back 9 closure. However, the back 9 never closed so additional marketing efforts were needed advertise that all 18 holes are open. ActualBudgetVariance$26,830.30$22,550.004,280.30Unfavorable: Due to initial payment for golf cart fleet and yearly property tax.ActualBudgetVariance$16,380.92$16,124.00256.92Unfavorable: Due to increase in reserve as a result of higher revenues.Pro Shop Merchandise SalesGolf Green Fee RevenueMiscellaneous Golf RevenueMarketingLeasesMiscellaneous Other Expensesprovided for those cost of sales percentage that are greater than 5%.Variance ExplanationSeptember 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 SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous699.71 - 699.71 1,759.75 - 1,759.75 00 0%4100110 Sales Hard Goods4,402.14 2,254.00 2,148.14 12,046.69 4,817.00 7,229.69 97,505.00 85,458.31 87.6%4100112 Sales-Soft Goods7,715.00 4,186.00 3,529.00 17,296.00 8,946.00 8,350.00 181,080.00 163,784.00 90.4%5100639 GS-Discounts-Mdse (2,179.40) - (2,179.40) (4,283.10) - (4,283.10) - 4,283.10 0.0% Total Revenue Golf Shop10,637.45 6,440.00 4,197.45 26,819.34 13,763.00 13,056.34 278,585.00 253,525.41 91.0%COS 5100150 COS-GS-Hard Goods 2,334.73 1,307.32 1,027.41 6,416.52 2,793.86 3,622.66 56,552.90 50,136.38 88.7%5100151 COS-GS-Soft Goods 3,510.39 2,427.88 1,082.51 9,082.41 5,188.68 3,893.73 105,026.40 95,943.99 91.4%5100152 COS-GS-Purchase Disc (20.00) (187.00) 167.00 (25.77) (399.00) 373.23 (8,079.00) (8,053.23) 99.7%5100220 COS-GS-Freight Merch 109.81 56.00 53.81 323.73 120.00 203.73 2,424.00 2,100.27 86.6%Cost of Sales - Golf Shop5,934.93 3,604.20 2,330.73 15,796.89 7,703.54 8,093.35 155,924.30 140,127.41 89.9%Gross Profit 4,702.52 2,835.80 1,866.72 11,022.45 6,059.46 4,962.99 122,660.70 113,398.00 92.4%COS % 55.8% 56.0% 0.2% 58.9% 56.0% -2.9% 53.1% 55.3% 104.1%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group1,455.73 1,705.00 (249.27) 4,114.04 5,115.00 (1,000.96) 27,621.00 23,506.96 85.1%6101325 Insurance-Workers Comp 400.08 307.00 93.08 1,280.07 945.00 335.07 5,042.00 3,761.93 74.6%6101720 Salaries4,002.00 4,001.00 1.00 12,006.00 12,003.00 3.00 45,000.00 32,994.00 73.3%6101800 Taxes-Employer Payroll 621.80 1,146.00 (524.20) 2,100.74 3,526.00 (1,425.26) 18,825.00 16,724.26 88.8%6101880 Wages-Hourly3,679.29 4,183.00 (503.71) 14,375.32 13,187.00 1,188.32 89,463.00 75,087.68 83.9%6101882 Wages-Overtime- - - - - - - 952.88 0.0%Total -PS-SALARIES & BENEFITS 10,158.90 11,342.00 (1,183.10) 33,876.17 34,776.00 (899.83) 185,951.00 153,027.71 82.3%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office345.75 250.00 95.75 345.75 750.00 (404.25) 3,000.00 2,654.25 88.5%6109220 Freight & Delivery14.47 - 14.47 16.80 - 16.80 75.00 58.20 77.6%6109490 Miscellaneous500.00 500.00 - 1,500.00 1,500.00 - 6,000.00 4,500.00 75.0%6109150 Dues and Subscriptions 1,103.62 - 1,103.62 1,103.62 - 1,103.62 2,300.00 1,196.38 52.0%6109500 ProShop-Over/Short43.89 - 43.89 99.91 - 99.91 - (99.91) 0.0%6109722 Seminars/Training- 150.00 (150.00) - 450.00 (450.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- - - - - - 90.00 90.00 100.0%6109820 Uniforms1,025.48 100.00 925.48 1,641.64 300.00 1,341.64 2,400.00 758.36 31.6%6117840 Telephones59.06 110.00 (50.94) 177.18 330.00 (152.82) 1,320.00 1,142.82 86.6%3,092.27 1,110.00 1,982.27 4,884.90 3,330.00 1,554.90 18,875.00 13,990.10 74.1%13,251.17 12,452.00 799.17 38,761.07 38,106.00 655.07 204,826.00 167,017.81 81.5%Net Income(8,548.65) (9,616.20) 1,067.55 (27,738.62) (32,046.54) 4,307.92 (82,165.30) (53,619.81) 65.3%SilverRock ResortGolf Shop Income StatementSeptember 2016Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group8,507.01 8,990.00 (482.99) 27,513.30 26,970.00 543.30 107,880.00 80,366.70 74.5%6311325 Insurance-Workers Comp1,440.15 1,663.00 (222.85) 5,400.11 4,989.00 411.11 24,794.00 19,393.89 78.2%6311720 Salaries10,620.80 9,333.33 1,287.47 31,862.40 27,999.99 3,862.41 142,017.20 110,154.80 77.6%6311800 Taxes-Employer Payroll3,850.34 6,207.00 (2,356.66) 11,660.35 18,621.00 (6,960.65) 93,302.00 81,641.65 87.5%6311880 Wages-Hourly38,418.76 35,003.67 3,415.09 115,896.94 105,011.01 10,885.93 508,481.80 392,584.86 77.2%6311882 Wages-Overtime8.44 - 8.44 64.85 - 64.85 15,945.00 15,880.15 99.6%Total-CM-SALARIES & BENEFITS62,845.50 61,197.00 1,648.50 192,397.95 183,591.00 8,806.95 892,420.00 700,022.05 78.4%63-CM-SUPPLIES & MATERIALS6313734 Chemicals3,420.01 3,500.00 (79.99) 8,238.62 9,000.00 (761.38) 34,600.00 26,361.38 76.2%6313744 Fertilizer11,201.83 11,000.00 201.83 29,934.92 36,000.00 (6,065.08) 112,500.00 82,565.08 73.4%6313745 Herbicides6,645.80 7,000.00 (354.20) 6,645.80 7,000.00 (354.20) 17,000.00 10,354.20 60.9%6313746 Flowers/Plants- 1,000.00 (1,000.00) - 1,000.00 (1,000.00) 3,050.00 3,050.00 100.0%6313748 Fuel-Gasoline3,551.60 4,900.00 (1,348.40) 11,694.77 14,500.00 (2,805.23) 55,020.00 43,325.23 78.7%6313750 Golf Course Accessories1,121.70 500.00 621.70 1,232.55 900.00 332.55 13,000.00 11,767.45 90.5%6313756 POA Control- - - - - - 7,000.00 7,000.00 100.0%6313758 Miscellaneous Supp485.94 750.00 (264.06) 2,089.11 2,250.00 (160.89) 4,350.00 2,260.89 52.0%6313762 Supplies-Office- - - 645.39 - 645.39 - (645.39) 0.0%6313774 Sand3,643.00 5,000.00 (1,357.00) 5,571.57 5,780.00 (208.43) 13,460.00 7,888.43 58.6%6313776 Seed391.50 250.00 141.50 3,009.96 950.00 2,059.96 125,900.00 122,890.04 97.6%6313778 Small Tools & Non-Capital Equip943.06 2,000.00 (1,056.94) 1,413.38 2,200.00 (786.62) 5,000.00 3,586.62 71.7%6313780 Sod1,739.99 2,000.00 (260.01) 8,436.88 5,500.00 2,936.88 10,450.00 2,013.12 19.3%6313782 Topdressing- - - 2,251.34 2,500.00 (248.66) 10,600.00 8,348.66 78.8%Total-CM-SUPPLIES & MATERIALS33,144.43 37,900.00 (4,755.57) 81,164.29 87,580.00 (6,415.71) 411,930.00 330,765.71 80.3%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint2,560.00 2,600.00 (40.00) 8,220.00 7,800.00 420.00 31,200.00 22,980.00 73.7%6315685 CM-R&M-Bldngs & Othr Structures 246.48 550.00 (303.52) 1,159.81 2,550.00 (1,390.19) 5,550.00 4,390.19 79.1%6315690 CM-R&M-Equipment2,635.59 2,000.00 635.59 7,664.39 6,500.00 1,164.39 40,000.00 32,335.61 80.8%6315692 CM-R&M-Irrigation System4,591.04 1,500.00 3,091.04 9,614.60 9,400.00 214.60 19,050.00 9,435.40 49.5%6315696 CM-R&M-Pumps856.40 1,000.00 (143.60) 3,465.55 3,000.00 465.55 10,500.00 7,034.45 67.0%6315815 CM-R&M-Trees-Pruning Etc5,446.00 5,500.00 (54.00) 5,446.00 5,500.00 (54.00) 12,050.00 6,604.00 54.8%Total-CM-REPAIRS & MAINTENANCE16,335.51 13,150.00 3,185.51 35,570.35 34,750.00 820.35 118,350.00 82,779.65 69.9%6317836 Utilities-Natural Gas/LPG 38.57 15.00 23.57 77.18 45.00 32.18 180.00 102.82 0.0%6317840 Telephones1,127.08 850.00 277.08 3,044.47 2,550.00 494.47 10,200.00 7,155.53 70.2%Total-CM-UTILITIES1,165.65 865.00 300.65 3,121.65 2,595.00 526.65 10,380.00 7,258.35 69.9%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 500.00 (100.00) 1,200.00 1,500.00 (300.00) 6,000.00 4,800.00 80.0%6319100 Contract Svcs-Soil/Tissue Test226.68 2,000.00 (1,773.32) 226.68 2,000.00 (1,773.32) 4,000.00 3,773.32 94.3%6319102 Contract Svcs-Trash Removal955.86 524.00 431.86 2,425.86 1,572.00 853.86 6,288.00 3,862.14 61.4%6319150 Dues & Subscriptions210.00 - 210.00 210.00 - 210.00 540.00 330.00 61.1%6319170 Employee Education- 50.00 (50.00) - 150.00 (150.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental- 150.00 (150.00) - 500.00 (500.00) 3,400.00 3,400.00 100.0%6319206 Licenses & Permits229.26 80.00 149.26 1,429.26 280.00 1,149.26 4,180.00 2,750.74 65.8%6319490 Miscellaneous78.92 100.00 (21.08) 537.25 300.00 237.25 1,200.00 662.75 55.2%6319718 Safety Equipment & Training414.72 750.00 (335.28) 1,016.78 1,050.00 (33.22) 3,850.00 2,833.22 73.6%6319822 Uniforms650.82 920.00 (269.18) 2,086.42 2,760.00 (673.58) 11,040.00 8,953.58 81.1%Total-CM-OTHER EXPENSES3,166.26 5,074.00 (1,907.74) 9,132.25 10,112.00 (979.75) 42,048.00 32,915.75 78.3%Month to DateYear to DateSilverRock ResortCourse Maintenance Expense StatementSeptember 2016Annual Budget5 SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,223.75 2,728.00 (504.25) 7,074.75 8,184.00 (1,109.25) 32,736.00 25,661.25 78.4%6321325 Insurance-Workers Comp260.02 507.00 (246.98) 1,200.01 1,473.00 (272.99) 6,171.00 4,970.99 80.6%6321800 Taxes-Employer Payroll939.65 1,938.00 (998.35) 2,817.90 5,544.00 (2,726.10) 23,334.00 20,516.10 87.9%6321880 Wages-Hourly13,430.32 12,880.00 550.32 40,171.87 38,640.00 1,531.87 160,320.00 120,148.13 74.9%6321882 Wages-Overtime1,059.49 966.00 93.49 1,083.82 966.00 117.82 6,351.00 5,267.18 82.9%Total-CM-LM-SALARIES & BENEFITS17,913.23 19,019.00 (1,105.77) 52,348.35 54,807.00 (2,458.65) 228,912.00 176,563.65 77.1%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 100.00 (100.00) - 300.00 (300.00) 1,025.00 1,025.00 100.0%6323788 Uniforms135.94 290.00 (154.06) 722.13 870.00 (147.87) 3,480.00 2,757.87 79.2%Total-CM-LM-SUPPLIES & MATERIALS135.94 390.00 (254.06) 722.13 1,170.00 (447.87) 4,505.00 3,782.87 84.0%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 500.00 (500.00) - 1,000.00 (1,000.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE- 500.00 (500.00) - 1,000.00 (1,000.00) 4,250.00 4,250.00 100.0%134,706.52 138,095.00 (3,388.48) 374,456.97 375,605.00 (1,148.03) 1,712,795.00 1,338,338.03 78.1% SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 12,079.74 13,815.00 (1,735.26) 36,527.98 40,900.00 (4,372.02) 179,791.00 143,263.02 79.7%6337842 Utilities-Water8,908.01 8,932.00 (23.99) 25,795.68 28,072.00 (2,276.32) 45,338.00 19,542.32 43.1%20,987.75 22,747.00 (1,759.25) 62,323.66 68,972.00 (6,648.34) 225,129.00 162,805.34 72.3%Total-COURSE MAINTENANCECourse Maintenance Expense StatementSeptember 2016Silverrock ResortAnnual BudgetMonth to DateYear to DateSilverrock ResortCourse Maintenance Water & EnergySeptember 2016Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual Budget6 SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 682.00 (682.00) - 2,046.00 (2,046.00) 8,184.00 8,184.00 100.0%6411325 Insurance-Workers Comp633.39 301.00 332.39 1,100.05 774.00 326.05 5,229.00 4,128.95 79.0%6411800 Taxes-Employer Payroll742.45 1,000.00 (257.55) 2,145.97 2,571.00 (425.03) 17,360.00 15,214.03 87.6%6411880 Wages-Hourly8,370.79 8,033.00 337.79 22,305.81 20,656.00 1,649.81 139,434.00 117,128.19 84.0%6411882 Wages-Overtime 153.75 - 153.75 543.75 - 543.75 - (543.75) 0.0%Total-CBR-SALARIES & BENEFITS9,900.38 10,016.00 (115.62) 26,095.58 26,047.00 48.58 170,207.00 144,111.42 84.7%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- - - - - - 1,850.00 `0.0%6413742 Supplies-Expendable50.82 150.00 (99.18) 1,198.38 1,350.00 (151.62) 6,750.00 5,551.62 82.2%6413748 Supplies-Fuel for Shuttle- 100.00 (100.00) - 100.00 (100.00) 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) - 75.00 (75.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels 480.00 120.00 360.00 1,040.00 360.00 680.00 2,182.00 1,142.00 52.3%6413796 Supplies-Bottled Water324.00 50.00 274.00 8,009.54 3,600.00 4,409.54 11,000.00 2,990.46 27.2%Total-CBR-SUPPLIES & MATERIALS854.82 445.00 409.82 10,247.92 5,485.00 4,762.92 34,727.00 22,629.08 65.2%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment- 300.00 (300.00) - 900.00 (900.00) 3,600.00 3,600.00 100.0%6415695 CBR-R&M-Cart Maintenance & Repair 500.00 500.00 - 1,956.45 1,500.00 456.45 6,450.00 4,493.55 69.7%Total-CBR-REPAIRS & MAINTENANCE500.00 800.00 (300.00) 1,956.45 2,400.00 (443.55) 10,050.00 8,093.55 80.5%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen1,063.69 800.00 263.69 2,587.48 2,400.00 187.48 9,600.00 7,012.52 73.0%6419220 Freight/Delivery- 75.00 (75.00) - 225.00 (225.00) 450.00 450.00 100.0%6419490 Miscellaneous- 600.00 (600.00) 57.88 1,800.00 (1,742.12) 7,200.00 7,142.12 99.2%6419820 Uniforms - - - - - - 5,200.00 5,200.00 100.0%Total-CBR-OTHER EXPENSES1,063.69 1,475.00 (411.31) 2,645.36 4,425.00 (1,779.64) 22,450.00 19,804.64 88.2%TOTAL-CARTS,BAGROOM & RANGE12,318.89 12,736.00 (411.31) 40,945.31 38,357.00 2,588.31 237,434.00 194,638.69 82.0%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp420.03 119.00 301.03 700.03 317.00 383.03 2,179.00 1,478.97 67.9%6431800 Taxes-Employer Payroll286.13 445.00 (158.87) 914.29 1,183.00 (268.71) 8,135.00 7,220.71 88.8%6431880 Wages-Hourly3,420.00 3,179.00 241.00 9,957.50 8,457.00 1,500.50 58,108.00 48,150.50 82.9%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS4,126.16 3,743.00 383.16 11,571.82 9,957.00 1,614.82 68,422.00 56,850.18 83.1%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 100.00 (100.00) 121.84 200.00 (78.16) 1,050.00 928.16 88.4%6439490 Miscellaneous- - - - - - 200.00 200.00 100.0%6439718 Safety Equipment & Training- 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6439820 Uniforms - 75.00 (75.00) 67.64 225.00 (157.36) 2,125.00 2,057.36 96.8%Total-CS-OTHER EXPENSES- 225.00 (225.00) 189.48 575.00 (385.52) 3,975.00 3,785.52 95.2%Total-COURSE SERVICES4,126.16 3,968.00 158.16 11,761.30 10,532.00 1,229.30 72,397.00 60,635.70 83.8%16,445.05 16,704.00 (258.95) 52,706.61 48,889.00 3,817.61 309,831.00 251,488.87 81.2%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementSeptember 2016Annual Budget7 SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 1,200.00 1,200.00 - 4,800.00 3,600.00 75.0%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 1,200.00 1,200.00 - 4,800.00 3,600.00 75.0%65-CH-UTILITIES6507836 Utilities-Natural Gas377.05 300.00 77.05 908.22 900.00 8.22 3,600.00 2,691.78 74.8%6507840 Utilities-Telephone1,135.12 1,150.00 (14.88) 3,411.64 3,450.00 (38.36) 13,800.00 10,388.36 75.3%6507842 Utilities-Water- 321.00 (321.00) - 963.00 (963.00) 3,852.00 3,852.00 100.0%6507844 Utilities-Cable485.47 340.00 145.47 1,456.41 1,020.00 436.41 4,080.00 2,623.59 64.3%Total-CH-UTILITIES1,997.64 2,111.00 (113.36) 5,776.27 6,333.00 (556.73) 25,332.00 19,555.73 77.2%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 1,900.00 1,825.00 75.00 5,550.00 5,475.00 75.00 22,500.00 16,950.00 75.3%6509099 Contract Services-Security5,736.24 4,900.00 836.24 15,989.52 14,700.00 1,289.52 60,400.00 44,410.48 73.5%6509215 Flowers & Decorations- - - 63.73 - 63.73 1,900.00 1,836.27 96.6%6509490 Miscellaneous107.30 200.00 (92.70) 131.98 600.00 (468.02) 7,000.00 6,868.02 98.1%6509718 Safety Equipment & Training- 100.00 (100.00) 258.26 300.00 (41.74) 1,200.00 941.74 78.5%Total-CH-OTHER EXPENSES7,743.54 7,025.00 718.54 21,993.49 21,075.00 918.49 93,000.00 71,006.51 76.4%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures235.56 300.00 (64.44) 759.72 900.00 (140.28) 3,600.00 2,840.28 78.9%6515686 CH-R&M-Restaurant Repairs195.00 400.00 (205.00) 1,695.00 1,200.00 495.00 4,800.00 3,105.00 64.7%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) - 1,200.00 (1,200.00) 4,800.00 4,800.00 100.0%Total-CH-REPAIRS & MAINTENANCE430.56 1,100.00 (669.44) 2,454.72 3,300.00 (845.28) 13,200.00 10,745.28 81.4%10,571.74 10,636.00 (64.26) 31,424.48 31,908.00 (483.52) 136,332.00 21,490.56 15.8%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementSeptember 2016Annual Budget8 SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 340.00 341.00 (1.00) 732.00 1,023.00 (291.00) 4,092.00 3,360.00 82.1%6601325 Insurance-Workers Comp98.00 94.00 4.00 272.90 282.00 (9.10) 1,129.00 856.10 75.8%6601720 Salaries1,904.96 2,508.00 (603.04) 6,214.88 7,524.00 (1,309.12) 30,096.00 23,881.12 79.3%6601800 Taxes-Employer Payroll145.20 351.00 (205.80) 435.60 1,053.00 (617.40) 4,213.00 3,777.40 89.7%Total-MKT-SALARIES & BENEFITS2,488.16 3,294.00 (805.84) 7,655.38 9,882.00 (2,226.62) 39,530.00 31,874.62 80.6%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 386.02 100.00 286.02 386.02 300.00 86.02 1,200.00 813.98 67.8%6603768 Supplies-Printing & Stationery 466.93 200.00 266.93 1,001.40 200.00 801.40 4,425.00 3,423.60 77.4%852.95 300.00 552.95 1,387.42 500.00 887.42 5,625.00 4,237.58 75.3%66-MKT-UTILITIES6607840 Utilities-Telephone 99.08 100.00 (0.92) 229.24 300.00 (70.76) 1,200.00 970.76 80.9%Total-MKT-UTILITIES99.08 100.00 (0.92) 229.24 300.00 (70.76) 1,200.00 970.76 80.9%66-MKT-OTHER EXPENSES6609010 Advertising16,153.80 10,697.00 5,456.80 28,507.56 18,187.00 10,320.56 178,987.00 150,479.44 84.1%6609040 Business Meals- 25.00 (25.00) - 75.00 (75.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) 297.00 450.00 (153.00) 1,800.00 1,503.00 83.5%6609490 Miscellaneous302.70 - 302.70 302.70 - 302.70 350.00 47.30 13.5%6609620 Postage- 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6609630 Promotion97.09 - 97.09 97.09 - 97.09 700.00 602.91 86.1%6609633 Promotion-Community- 75.00 (75.00) 310.27 225.00 85.27 2,250.00 1,939.73 86.2%6609634 Promotion-Media/Vendor- - - - - - 2,000.00 2,000.00 100.0%6609150 Dues and Subscriptions82.50 - 82.50 82.50 - 82.50 735.00 652.50 88.8%6609820 Uniforms- - - - - - 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES16,735.09 10,997.00 5,738.09 29,597.12 19,087.00 10,510.12 193,822.00 164,224.88 84.7%20,175.28 14,691.00 5,484.28 38,869.16 29,769.00 9,100.16 240,177.00 201,307.84 83.8%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementSeptember 2016Annual Budget9 SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,122.89 1,488.00 (365.11) 3,383.75 4,464.00 (1,080.25) 17,856.00 14,472.25 81.0%6701325 Insurance-Workers Comp260.02 594.00 (333.98) 1,391.52 1,805.00 (413.48) 7,717.00 6,325.48 82.0%6701720 Salaries12,621.00 13,250.00 (629.00) 38,863.00 40,350.00 (1,487.00) 177,996.00 139,133.00 78.2%6701800 Taxes-Employer Payroll1,170.69 2,219.00 (1,048.31) 3,735.92 6,741.00 (3,005.08) 28,812.00 25,076.08 87.0%6701880 Wages-Hourly2,682.20 2,412.00 270.20 9,314.60 7,612.00 1,702.60 27,800.00 18,485.40 66.5%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS17,856.80 19,963.00 (2,106.20) 56,688.79 60,972.00 (4,283.21) 260,181.00 203,492.21 78.2%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer86.39 500.00 (413.61) 515.39 1,500.00 (984.61) 6,300.00 5,784.61 91.8%6703762 Supplies-Office156.73 150.00 6.73 156.73 450.00 (293.27) 1,800.00 1,643.27 91.3%6703768 Supplies-Printing & Stationery347.91 100.00 247.91 476.87 300.00 176.87 3,300.00 2,823.13 85.5%Total-G&A-SUPPLIES & MATERIALS591.03 750.00 (158.97) 1,148.99 2,250.00 (1,101.01) 11,400.00 10,251.01 89.9%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 19.00 200.00 (181.00) 1,900.00 1,881.00 99.0%Total-G&A-REPAIRS & MAINTENANCE- 100.00 (100.00) 19.00 200.00 (181.00) 1,900.00 1,881.00 99.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 1,500.00 1,500.00 - 4,800.00 3,300.00 68.8%6709150 Dues & Subscriptions- 200.00 (200.00) - 250.00 (250.00) 1,700.00 1,700.00 100.0%6709180 Employee Recruiting/Relocation30.00 200.00 (170.00) 30.00 200.00 (170.00) 1,400.00 1,370.00 97.9%6709197 Equipment Rental485.22 550.00 (64.78) 1,336.31 1,650.00 (313.69) 6,600.00 5,263.69 79.8%6709202 Fees-Bank120.70 90.00 30.70 353.58 270.00 83.58 1,080.00 726.42 67.3%6709208 Fees-Payroll Processing1,013.52 1,200.00 (186.48) 3,154.56 3,600.00 (445.44) 14,400.00 11,245.44 78.1%6709220 Freight/Delivery- 50.00 (50.00) 31.72 150.00 (118.28) 600.00 568.28 94.7%6709490 Miscellaneous163.70 100.00 63.70 170.87 300.00 (129.13) 1,200.00 1,029.13 85.8%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services- 75.00 (75.00) 273.22 225.00 48.22 900.00 626.78 69.6%6709625 Professional Fees553.00 850.00 (297.00) 2,877.42 2,550.00 327.42 10,200.00 7,322.58 71.8%6709636 Promotion/Entertainment- 100.00 (100.00) - 300.00 (300.00) 6,600.00 6,600.00 100.0%6709722 Seminars & Training250.00 200.00 50.00 250.00 600.00 (350.00) 2,400.00 2,150.00 89.6%6709810 Travel- - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 900.00 - 225.00 (225.00) 1,050.00 1,050.00 100.0%Total-G&A-OTHER EXPENSES3,116.14 4,190.00 (98.86) 9,977.68 11,920.00 (1,942.32) 54,030.00 44,052.32 81.5%21,563.97 25,003.00 (3,439.03) 67,834.46 75,342.00 (7,507.54) 327,511.00 259,676.54 79.3%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementSeptember 2016Annual Budget10 SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts10,363.45 10,050.00 313.45 31,090.35 30,150.00 940.35 121,050.00 89,959.65 74.3%6800193 Equipment Leases-Maintenance 5,571.50 6,050.00 (478.50) 16,714.50 18,150.00 (1,435.50) 72,600.00 55,885.50 77.0%6800194 Equipment Leases-Trailer282.07 600.00 (317.93) 1,626.21 1,800.00 (173.79) 7,200.00 5,573.79 77.4%6800196 Equipment Leases-GPS4,500.00 4,700.00 (200.00) 18,360.00 14,100.00 4,260.00 56,400.00 38,040.00 67.4%6800197 Equipment Leases-Others6,113.28 1,150.00 4,963.28 9,521.50 3,450.00 6,071.50 13,800.00 4,278.50 0.0%26,830.30 22,550.00 4,280.30 77,312.56 67,650.00 9,662.56 271,050.00 193,737.44 71.5%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,652.80 8,653.00 (0.20) 25,958.40 25,959.00 (0.60) 99,840.00 73,881.60 74.0%6900210 FF&E Reserve2,336.75 771.00 1,565.75 5,158.24 1,939.00 3,219.24 63,985.00 58,826.76 91.9%6900800 Personal Property Taxes5,391.37 4,000.00 1,391.37 10,871.10 9,200.00 1,671.10 11,800.00 928.90 7.9%6900323 Insurance-Commercial- 2,700.00 (2,700.00) 6,273.34 8,100.00 (1,826.66) 26,400.00 20,126.66 76.2%16,380.92 16,124.00 256.92 48,261.08 45,198.00 3,063.08 202,025.00 153,763.92 76.1%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementSeptember 2016Annual BudgetMonth to DateYear to Date11 SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts10,363.45 10,050.00 313.45 31,090.35 30,150.00 940.35 121,050.00 89,959.65 74.3%6800193 Equipment Leases-Maintenance 5,571.50 6,050.00 (478.50) 16,714.50 18,150.00 (1,435.50) 72,600.00 55,885.50 77.0%6800194 Equipment Leases-Trailer282.07 600.00 (317.93) 1,626.21 1,800.00 (173.79) 7,200.00 5,573.79 77.4%6800196 Equipment Leases-GPS4,500.00 4,700.00 (200.00) 18,360.00 14,100.00 4,260.00 56,400.00 38,040.00 67.4%6800197 Equipment Leases-Others6,113.28 1,150.00 4,963.28 9,521.50 3,450.00 6,071.50 13,800.00 4,278.50 0.0%26,830.30 22,550.00 4,280.30 77,312.56 67,650.00 9,662.56 271,050.00 193,737.44 71.5%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,652.80 8,653.00 (0.20) 25,958.40 25,959.00 (0.60) 99,840.00 73,881.60 74.0%6900210 FF&E Reserve2,336.75 771.00 1,565.75 5,158.24 1,939.00 3,219.24 63,985.00 58,826.76 91.9%6900800 Personal Property Taxes5,391.37 4,000.00 1,391.37 10,871.10 9,200.00 1,671.10 11,800.00 928.90 7.9%6900323 Insurance-Commercial- 2,700.00 (2,700.00) 6,273.34 8,100.00 (1,826.66) 26,400.00 20,126.66 76.2%16,380.92 16,124.00 256.92 48,261.08 45,198.00 3,063.08 202,025.00 153,763.92 76.1%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementSeptember 2016Annual BudgetMonth to DateYear to Date12 SilverRock Resort‐Arnold Palmer Classic CourseComp Golf Report‐2016‐20172016 2016 2016 2016 2016 2016Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia48SalesPromotionGolf IndustryVIPCelebrityPGA Comp34 45 47Charity/Gift Certificate184Rain/Wind Checks1Club Staff47 61 63LQ HS Golf58892 122 130 0002017 2017 2017 2017 2017 2017Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf Industry13 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2016‐2017September 2016 Date Time DescriptionCategoryPlayers9/10/2016 12:00 p.m. John White - KESQ Media 49/29/2016 6:30 a.m. Locale Magazine Media 414