Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
05 November 2016 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2016 – November 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 NovemberFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue294,662.08 334,335.00 (39,672.92) -11.9% 626,969.73 445,036.00 181,933.73 3,199,237.00 2,572,267.27 20%401000 Miscellaneous Golf Revenue43,471.12 48,403.00 (4,931.88) -10.2% 81,282.92 66,063.00 15,219.92 349,259.00 267,976.08 23%410000Revenue-Golf Shop26,091.39 30,225.00 (4,133.61) -13.7%59,058.78 46,488.00 12,570.78 278,585.00 219,526.22 21%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0%4,500.00 4,500.00 - 12,000.00 7,500.00 38%890000 Interest Income0.09 - 0.09 0.26 - 0.26 - (0.26) 0%Total Income365,724.68 414,463.00 (48,738.32) -11.8% 771,811.69 562,087.00 209,724.69 3,839,081.00 3,067,269.31 20%Cost of Goods Sold510000 COS-Golf Shop13,676.68 16,916.50 (3,239.82) 19.2% 33,053.36 26,019.04 (7,034.32) 155,924.00 122,870.64 21%Total COS13,676.68 16,916.50 (3,239.82) 19.2% 33,053.36 26,019.04 (7,034.32) 155,924.00 122,870.64 21%Gross Profit352,048.00 397,546.50 (45,498.50) -11.4% 738,758.33 536,067.96 202,690.37 3,683,157.00 2,944,398.67 20%Expenses610000 Golf Pro Shop18,671.86 18,594.00 77.86 -0.4% 70,238.60 68,255.00 1,983.60 204,827.00 134,588.40 34%630000 Course Maintenance136,174.39 166,337.00 (30,162.61) 18.1% 775,379.26 822,756.00 (47,376.74) 1,712,795.00 937,415.74 45%633000 Maintenance Water & Energy14,987.90 15,369.00 (381.10) 2.5% 95,335.60 102,581.00 (7,245.40) 225,129.00 129,793.40 42%640000 Outside Services32,456.55 34,470.00 (2,013.45) 5.8% 104,180.91 99,590.00 4,590.91 309,830.00 205,649.09 34%650000 Clubhouse12,917.73 12,936.00 (18.27) 0.1% 54,668.09 56,580.00 (1,911.91) 136,332.00 81,663.91 40%660000 Marketing27,024.63 32,494.00 (5,469.37) 16.8% 88,511.80 83,229.00 5,282.80 240,177.00 151,665.20 37%670000 General & Administrative26,442.11 30,686.00 (4,243.89) 13.8% 124,664.47 132,039.00 (7,374.53) 327,511.00 202,846.53 38%680000 Leases26,665.03 28,800.00 (2,134.97) 7.4% 125,133.29 119,450.00 5,683.29 271,050.00 145,916.71 46%690000 Miscellaneous Other Expense17,932.61 18,040.00 (107.39) 0.6% 89,035.11 77,466.00 11,569.11 202,025.00 112,989.89 44%Total Expenses313,272.81 357,726.00 (44,453.19) 12.4% 1,527,147.13 1,561,946.00 34,798.87 3,629,676.00 2,102,528.87 42%38,775.19 39,820.50 (1,045.31) -2.6%(788,388.80) (1,025,878.04) 237,489.24 53,481.00 841,869.80 0%Rounds of Golf PlayedPaid Rounds Played4,073 4,650 (577) -12.4%13,189 8,757 4,432 46,475 33,286 28%Ave $ Per Paid Round Green Fee72.35 71.90 0.45 0.6%47.54 50.82 (3.28) 68.84 21.30 69%Ave $ Per Paid Round Merchandise6.41 6.50 (0.09) -1.4%4.48 5.31 (0.83) 5.99 1.52 75%Ave $ Per Paid Miscellaneous 10.67 10.41 0.26 2.5%6.16 7.54 (1.38) 7.51 1.35 82%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateNovember 20161 Income NovemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees294,662.08 334,335.00 (39,672.92) 626,969.73 445,036.00 181,933.73 3,199,237.00 2,572,267.27 80.4%4010000 Rider Fee925.00 465.00 460.00 2,542.50 876.00 1,666.50 7,738.00 5,195.50 67.1%4040000 Club Rental2,610.00 2,325.00 285.00 7,190.00 4,379.00 2,811.00 23,238.00 16,048.00 69.1%4050000 Driving Range9,258.00 15,113.00 (5,855.00) 17,782.00 18,908.00 (1,126.00) 100,984.00 83,202.00 82.4%4060000 Handicap Fees33.12 - 33.12 33.12 - 33.12 2,500.00 2,466.88 98.7%4080000 GPS Advertising- 500.00 (500.00) - 900.00 (900.00) 2,600.00 2,600.00 100.0%4090000 Ball Retriever/Subcontract- - - 995.30 2,000.00 (1,004.70) 4,000.00 3,004.70 75.1%4091000 Golf Professional Rental Fee6,000.00 5,000.00 1,000.00 6,000.00 5,000.00 1,000.00 37,000.00 31,000.00 83.8%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue24,645.00 25,000.00 (355.00) 46,740.00 34,000.00 12,740.00 171,200.00 124,460.00 72.7% Total Revenue Fees338,133.20 382,738.00 (44,604.80) 708,252.65 511,099.00 197,153.65 3,548,497.00 2,840,244.35 80.0%338,133.20 382,738.00 (44,604.80) 708,252.65 511,099.00 197,153.65 3,548,497.00 2,840,244.35 80.0%SilverRock ResortStatement of Fees RevenueNovember 2016Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$294,662.08$334,335.00(39,672.92)Unfavorable: Rounds down 577 to budget due to a reduced amount of winter residents & unexpected frost delays in November.ActualBudgetVariance$43,471.12$48,403.00(4,931.88)Unfavorable: Due to reduced usage of the driving range. ActualBudgetVariance$26,091.39$30,225.00(4,133.61)Unfavorable: Due to reduced rounds of play.ExpensesActualBudgetVariance$136,174.39$166,337.00(30,162.61)Favorable: Due to reduction in usage of seed. We reduced the amount applied per square acre in an effort to reduce costs.ActualBudgetVariance$27,024.63$32,494.00(5,469.37)Favorable: Due to timing of invoices.ActualBudgetVariance$26,442.11$30,686.00(4,243.89)Favorable: Due to reduced wages, and line items in an effort to reduce expenses to offset revenue shortfall.General and Administrativeprovided for those cost of sales percentage that are greater than 5%.Variance ExplanationNovember 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 RevenueMarketingMaintenance3-20-133 Income NovemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 1,642.00 - 1,642.00 3,653.29 - 3,653.29 00 0%4100110 Sales Hard Goods8,377.95 10,579.00 (2,201.05) 23,467.35 16,271.00 7,196.35 97,505.00 74,037.65 75.9%4100112 Sales-Soft Goods19,569.00 19,646.00 (77.00) 40,645.50 30,217.00 10,428.50 181,080.00 140,434.50 77.6%5100639 GS-Discounts-Mdse (3,497.56) - (3,497.56) (8,707.36) - (8,707.36) - 8,707.36 0.0% Total Revenue Golf Shop26,091.39 30,225.00 (4,133.61) 59,058.78 46,488.00 12,570.78 278,585.00 223,179.51 80.1%COS 5100150 COS-GS-Hard Goods 3,400.60 6,135.82 (2,735.22) 11,267.21 9,437.18 1,830.03 56,552.90 45,285.69 80.1%5100151 COS-GS-Soft Goods 9,760.68 11,394.68 (1,634.00) 20,393.35 17,525.86 2,867.49 105,026.40 84,633.05 80.6%5100152 COS-GS-Purchase Disc (9.12) (877.00) 867.88 (59.49) (1,349.00) 1,289.51 (8,079.00) (8,019.51) 99.3%5100220 COS-GS-Freight Merch 524.52 263.00 261.52 1,452.29 405.00 1,047.29 2,424.00 971.71 40.1%Cost of Sales - Golf Shop13,676.68 16,916.50 (3,239.82) 33,053.36 26,019.04 7,034.32 155,924.30 122,870.94 78.8%Gross Profit12,414.71 13,308.50 (893.79) 26,005.42 20,468.96 5,536.46 122,660.70 100,308.57 81.8%COS %52.4% 56.0% 3.6% 56.0% 56.0% 0.0% 53.1% 55.1% 103.7%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group2,698.51 2,387.00 311.51 9,517.31 9,548.00 (30.69) 27,621.00 18,103.69 65.5%6101325 Insurance-Workers Comp 455.00 478.00 (23.00) 1,963.07 1,679.00 284.07 5,042.00 3,078.93 61.1%6101720 Salaries4,000.00 4,001.00 (1.00) 20,007.00 20,005.00 2.00 45,000.00 24,993.00 55.5%6101800 Taxes-Employer Payroll 1,777.14 1,786.00 (8.86) 4,560.82 6,266.00 (1,705.18) 18,825.00 14,264.18 75.8%6101880 Wages-Hourly8,807.80 8,757.00 50.80 27,713.03 24,757.00 2,956.03 89,463.00 61,749.97 69.0%6101882 Wages-Overtime76.13 - 76.13 76.13 - 76.13 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 17,814.58 17,409.00 405.58 63,837.36 62,255.00 1,582.36 185,951.00 123,142.65 66.2%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office166.10 250.00 (83.90) 511.85 1,250.00 (738.15) 3,000.00 2,488.15 82.9%6109220 Freight & Delivery- 25.00 (25.00) 16.80 50.00 (33.20) 75.00 58.20 77.6%6109490 Miscellaneous500.00 500.00 - 2,500.00 2,500.00 - 6,000.00 3,500.00 58.3%6109150 Dues and Subscriptions- - - 1,103.62 - 1,103.62 2,300.00 1,196.38 52.0%6109500 ProShop-Over/Short(47.41) - (47.41) 61.50 - 61.50 - (61.50) 0.0%6109722 Seminars/Training- - - - 950.00 (950.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- - - - - - 90.00 90.00 100.0%6109820 Uniforms181.45 300.00 (118.55) 1,921.64 700.00 1,221.64 2,400.00 478.36 19.9%6117840 Telephones57.14 110.00 (52.86) 285.83 550.00 (264.17) 1,320.00 1,034.17 78.3%857.28 1,185.00 (327.72) 6,401.24 6,000.00 401.24 18,875.00 12,473.76 66.1%18,671.86 18,594.00 77.86 70,238.60 68,255.00 1,983.60 204,826.00 135,616.41 66.2%Net Income(6,257.15) (5,285.50) (971.65) (44,233.18) (47,786.04) 3,552.86 (82,165.30) (35,307.84) 43.0%SilverRock ResortGolf Shop Income StatementNovember 2016Total Expenses-Golf ShopMonth to Date Year to Date Annual Budget4 NovemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group5,411.37 8,990.00 (3,578.63) 38,553.29 44,950.00 (6,396.71) 107,880.00 69,326.71 64.3%6311325 Insurance-Workers Comp2,065.00 2,065.00 - 9,715.51 9,382.00 333.51 24,794.00 15,078.49 60.8%6311720 Salaries11,338.40 9,333.33 2,005.07 54,180.40 46,666.65 7,513.75 142,017.20 87,836.80 61.8%6311800 Taxes-Employer Payroll7,634.23 7,708.00 (73.77) 27,602.60 35,510.00 (7,907.40) 93,302.00 65,699.40 70.4%6311880 Wages-Hourly47,088.01 45,722.67 1,365.34 208,997.22 196,456.35 12,540.87 508,481.80 299,484.58 58.9%6311882 Wages-Overtime946.21 - 946.21 11,576.30 10,526.00 1,050.30 15,945.00 4,368.70 27.4%Total-CM-SALARIES & BENEFITS74,483.22 73,819.00 664.22 350,625.32 343,491.00 7,134.32 892,420.00 541,794.68 60.7%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 4,691.01 6,900.00 (2,208.99) 13,017.29 20,500.00 (7,482.71) 34,600.00 21,582.71 62.4%6313744 Fertilizer3,707.58 7,500.00 (3,792.42) 52,777.20 61,000.00 (8,222.80) 112,500.00 59,722.80 53.1%6313745 Herbicides1,236.24 5,000.00 (3,763.76) 7,882.04 12,000.00 (4,117.96) 17,000.00 9,117.96 53.6%6313746 Flowers/Plants1,240.00 - 1,240.00 1,240.00 1,250.00 (10.00) 3,050.00 1,810.00 59.3%6313748 Fuel-Gasoline923.93 5,100.00 (4,176.07) 14,805.50 27,600.00 (12,794.50) 55,020.00 40,214.50 73.1%6313750 Golf Course Accessories4,914.19 200.00 4,714.19 6,279.49 11,100.00 (4,820.51) 13,000.00 6,720.51 51.7%6313756 POA Control6,349.28 3,500.00 2,849.28 6,349.28 3,500.00 2,849.28 7,000.00 650.72 9.3%6313758 Miscellaneous Supp247.33 500.00 (252.67) 3,350.29 3,250.00 100.29 4,350.00 999.71 23.0%6313762 Supplies-Office421.98 - 421.98 1,325.60 - 1,325.60 - (1,325.60) 0.0%6313774 Sand2,857.05 4,000.00 (1,142.95) 8,806.17 11,780.00 (2,973.83) 13,460.00 4,653.83 34.6%6313776 Seed2,200.00 20,500.00 (18,300.00) 117,164.38 123,450.00 (6,285.62) 125,900.00 8,735.62 6.9%6313778 Small Tools & Non-Capital Equip464.40 100.00 364.40 1,877.78 4,300.00 (2,422.22) 5,000.00 3,122.22 62.4%6313780 Sod3,100.00 3,250.00 (150.00) 11,636.88 9,000.00 2,636.88 10,450.00 (1,186.88) -11.4%6313782 Topdressing- 3,000.00 (3,000.00) 4,582.66 8,000.00 (3,417.34) 10,600.00 6,017.34 56.8%Total-CM-SUPPLIES & MATERIALS32,352.99 59,550.00 (27,197.01) 251,094.56 296,730.00 (45,635.44) 411,930.00 160,835.44 39.0%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 3,660.00 2,600.00 1,060.00 14,150.00 13,000.00 1,150.00 31,200.00 17,050.00 54.6%6315685 CM-R&M-Bldngs & Othr Structures 107.12 500.00 (392.88) 1,543.60 3,550.00 (2,006.40) 5,550.00 4,006.40 72.2%6315690 CM-R&M-Equipment2,999.58 4,000.00 (1,000.42) 20,278.50 21,500.00 (1,221.50) 40,000.00 19,721.50 49.3%6315692 CM-R&M-Irrigation System1,081.64 900.00 181.64 13,985.82 12,300.00 1,685.82 19,050.00 5,064.18 26.6%6315696 CM-R&M-Pumps- 1,000.00 (1,000.00) 3,465.55 5,000.00 (1,534.45) 10,500.00 7,034.45 67.0%6315815 CM-R&M-Trees-Pruning Etc- - - 6,071.00 6,050.00 21.00 12,050.00 5,979.00 49.6%Total-CM-REPAIRS & MAINTENANCE7,848.34 9,000.00 (1,151.66) 59,494.47 61,400.00 (1,905.53) 118,350.00 58,855.53 49.7%6317836 Utilities-Natural Gas/LPG20.28 15.00 5.28 117.61 75.00 42.61 180.00 62.39 0.0%6317840 Telephones666.82 850.00 (183.18) 4,391.25 4,250.00 141.25 10,200.00 5,808.75 56.9%Total-CM-UTILITIES 687.10 865.00 (177.90) 4,508.86 4,325.00 183.86 10,380.00 5,871.14 56.6%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 400.00 500.00 (100.00) 2,000.00 2,500.00 (500.00) 6,000.00 4,000.00 66.7%6319100 Contract Svcs-Soil/Tissue Test504.12 - 504.12 730.80 2,000.00 (1,269.20) 4,000.00 3,269.20 81.7%6319102 Contract Svcs-Trash Removal694.00 524.00 170.00 3,813.86 2,620.00 1,193.86 6,288.00 2,474.14 39.3%6319150 Dues & Subscriptions- - - 265.00 - 265.00 540.00 275.00 50.9%6319170 Employee Education- 50.00 (50.00) - 250.00 (250.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental- 600.00 (600.00) 737.04 2,100.00 (1,362.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 Miscellaneous- 100.00 (100.00) 569.55 500.00 69.55 1,200.00 630.45 52.5%6319718 Safety Equipment & Training204.66 500.00 (295.34) 1,783.03 2,350.00 (566.97) 3,850.00 2,066.97 53.7%6319822 Uniforms1,343.96 920.00 423.96 3,989.27 4,600.00 (610.73) 11,040.00 7,050.73 63.9%Total-CM-OTHER EXPENSES3,146.74 3,194.00 (47.26) 15,317.81 17,200.00 (1,882.19) 42,048.00 26,730.19 63.6%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementNovember 2016Annual Budget5 NovemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group2,731.25 2,728.00 3.25 14,337.25 13,640.00 697.25 32,736.00 18,398.75 56.2%6321325 Insurance-Workers Comp501.50 507.00 (5.50) 2,162.71 2,548.00 (385.29) 6,171.00 4,008.29 65.0%6321800 Taxes-Employer Payroll13.82 1,938.00 (1,924.18) 4,924.67 9,759.00 (4,834.33) 23,334.00 18,409.33 78.9%6321880 Wages-Hourly13,434.99 12,880.00 554.99 66,547.06 64,400.00 2,147.06 160,320.00 93,772.94 58.5%6321882 Wages-Overtime974.44 966.00 8.44 5,458.15 5,313.00 145.15 6,351.00 892.85 14.1%Total-CM-LM-SALARIES & BENEFITS 17,656.00 19,019.00 (1,363.00) 93,429.84 95,660.00 (2,230.16) 228,912.00 135,482.16 59.2%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 100.00 (100.00) - 500.00 (500.00) 1,025.00 1,025.00 100.0%6323788 Uniforms- 290.00 (290.00) 908.40 1,450.00 (541.60) 3,480.00 2,571.60 73.9%Total-CM-LM-SUPPLIES & MATERIALS - 390.00 (390.00) 908.40 1,950.00 (1,041.60) 4,505.00 3,596.60 79.8%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 500.00 (500.00) - 2,000.00 (2,000.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE- 500.00 (500.00) - 2,000.00 (2,000.00) 4,250.00 4,250.00 100.0%136,174.39 166,337.00 (30,162.61) 775,379.26 822,756.00 (47,376.74) 1,712,795.00 937,415.74 54.7% NovemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping9,673.32 10,650.00 (976.68) 58,191.92 63,700.00 (5,508.08) 179,791.00 121,599.08 67.6%6337842 Utilities-Water5,314.58 4,719.00 595.58 37,143.68 38,881.00 (1,737.32) 45,338.00 8,194.32 18.1%14,987.90 15,369.00 (381.10) 95,335.60 102,581.00 (7,245.40) 225,129.00 129,793.40 57.7%Total-COURSE MAINTENANCECourse Maintenance Expense StatementNovember 2016Silverrock ResortAnnual BudgetMonth to Date Year to DateSilverrock ResortCourse Maintenance Water & EnergyNovember 2016Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual Budget6 NovemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 682.00 (682.00) - 3,410.00 (3,410.00) 8,184.00 8,184.00 100.0%6411325 Insurance-Workers Comp401.50 412.00 (10.50) 1,703.15 1,414.00 289.15 5,229.00 3,525.85 67.4%6411800 Taxes-Employer Payroll497.07 1,367.00 (869.93) 3,379.63 4,694.00 (1,314.37) 17,360.00 13,980.37 80.5%6411880 Wages-Hourly11,367.50 10,980.00 387.50 42,375.81 37,705.00 4,670.81 139,434.00 97,058.19 69.6%6411882 Wages-Overtime236.25 - 236.25 930.00 - 930.00 - (930.00) 0.0%Total-CBR-SALARIES & BENEFITS12,502.32 13,441.00 (938.68) 48,388.59 47,223.00 1,165.59 170,207.00 121,818.41 71.6%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- 500.00 (500.00) - 1,000.00 (1,000.00) 1,850.00 `0.0%6413742 Supplies-Expendable813.40 1,800.00 (986.60) 2,125.18 3,300.00 (1,174.82) 6,750.00 4,624.82 68.5%6413748 Supplies-Fuel for Shuttle- 300.00 (300.00) - 500.00 (500.00) 3,000.00 3,000.00 100.0%6413752 Supplies-Range Balls10,692.00 9,000.00 1,692.00 10,692.00 9,000.00 1,692.00 9,000.00 (1,692.00) -18.8%6413762 Supplies-Office- 50.00 (50.00) - 175.00 (175.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels240.00 185.00 55.00 1,520.00 665.00 855.00 2,182.00 662.00 30.3%6413796 Supplies-Bottled Water- 50.00 (50.00) 8,117.54 3,700.00 4,417.54 11,000.00 2,882.46 26.2%Total-CBR-SUPPLIES & MATERIALS11,745.40 11,885.00 (139.60) 22,454.72 18,340.00 4,114.72 34,727.00 10,422.28 30.0%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment1,356.42 300.00 1,056.42 1,648.55 1,500.00 148.55 3,600.00 1,951.45 54.2%6415695 CBR-R&M-Cart Maintenance & Repair500.00 500.00 - 2,956.45 2,950.00 6.45 6,450.00 3,493.55 54.2%Total-CBR-REPAIRS & MAINTENANCE1,856.42 800.00 1,056.42 4,605.00 4,450.00 155.00 10,050.00 5,445.00 54.2%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen414.82 800.00 (385.18) 3,449.67 4,000.00 (550.33) 9,600.00 6,150.33 64.1%6419220 Freight/Delivery- 75.00 (75.00) - 375.00 (375.00) 450.00 450.00 100.0%6419490 Miscellaneous172.49 600.00 (427.51) 257.10 3,000.00 (2,742.90) 7,200.00 6,942.90 96.4%6419820 Uniforms- 500.00 (500.00) 2,880.44 2,500.00 380.44 5,200.00 2,319.56 44.6%Total-CBR-OTHER EXPENSES587.31 1,975.00 (1,387.69) 6,587.21 9,875.00 (3,287.79) 22,450.00 15,862.79 70.7%TOTAL-CARTS,BAGROOM & RANGE26,691.45 28,101.00 (1,387.69) 82,035.52 79,888.00 2,147.52 237,434.00 153,548.48 64.7%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp190.20 194.00 (3.80) 937.03 568.00 369.03 2,179.00 1,241.97 57.0%6431800 Taxes-Employer Payroll157.25 725.00 (567.75) 1,334.76 2,122.00 (787.24) 8,135.00 6,800.24 83.6%6431880 Wages-Hourly5,270.23 5,175.00 95.23 18,370.23 15,162.00 3,208.23 58,108.00 39,737.77 68.4%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS5,617.68 6,094.00 (476.32) 20,642.02 17,852.00 2,790.02 68,422.00 47,779.98 69.8%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 100.00 (100.00) 121.84 400.00 (278.16) 1,050.00 928.16 88.4%6439490 Miscellaneous- 50.00 (50.00) - 100.00 (100.00) 200.00 200.00 100.0%6439718 Safety Equipment & Training- 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0%6439820 Uniforms147.42 75.00 72.42 1,381.53 1,100.00 281.53 2,125.00 743.47 35.0%Total-CS-OTHER EXPENSES147.42 275.00 (127.58) 1,503.37 1,850.00 (346.63) 3,975.00 2,471.63 62.2%Total-COURSE SERVICES5,765.10 6,369.00 (603.90) 22,145.39 19,702.00 2,443.39 72,397.00 50,251.61 69.4%32,456.55 34,470.00 (2,013.45) 104,180.91 99,590.00 4,590.91 309,831.00 201,328.46 65.0%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementNovember 2016Annual Budget7 NovemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable400.00 400.00 - 2,000.00 2,000.00 - 4,800.00 2,800.00 58.3%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 2,000.00 2,000.00 - 4,800.00 2,800.00 58.3%65-CH-UTILITIES6507836 Utilities-Natural Gas318.68 300.00 18.68 1,630.82 1,500.00 130.82 3,600.00 1,969.18 54.7%6507840 Utilities-Telephone1,126.46 1,150.00 (23.54) 5,679.78 5,750.00 (70.22) 13,800.00 8,120.22 58.8%6507842 Utilities-Water614.12 321.00 293.12 764.03 1,605.00 (840.97) 3,852.00 3,087.97 80.2%6507844 Utilities-Cable493.70 340.00 153.70 2,435.58 1,700.00 735.58 4,080.00 1,644.42 40.3%Total-CH-UTILITIES2,552.96 2,111.00 441.96 10,510.21 10,555.00 (44.79) 25,332.00 14,821.79 58.5%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 9,230.00 9,725.00 (495.00) 22,500.00 13,270.00 59.0%6509099 Contract Services-Security5,094.72 4,900.00 194.72 26,051.28 24,500.00 1,551.28 60,400.00 34,348.72 56.9%6509215 Flowers & Decorations63.73 - 63.73 318.65 500.00 (181.35) 1,900.00 1,581.35 83.2%6509490 Miscellaneous1,496.00 2,500.00 (1,004.00) 1,627.98 3,300.00 (1,672.02) 7,000.00 5,372.02 76.7%6509718 Safety Equipment & Training- 100.00 (100.00) 258.26 500.00 (241.74) 1,200.00 941.74 78.5%Total-CH-OTHER EXPENSES8,479.45 9,325.00 (845.55) 37,486.17 38,525.00 (1,038.83) 93,000.00 55,513.83 59.7%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures567.32 300.00 267.32 2,058.71 1,500.00 558.71 3,600.00 1,541.29 42.8%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 1,695.00 2,000.00 (305.00) 4,800.00 3,105.00 64.7%6515690 CH-R&M-Equipment Repair918.00 400.00 518.00 918.00 2,000.00 (1,082.00) 4,800.00 3,882.00 80.9%Total-CH-REPAIRS & MAINTENANCE1,485.32 1,100.00 385.32 4,671.71 5,500.00 (828.29) 13,200.00 8,528.29 64.6%12,917.73 12,936.00 (18.27) 54,668.09 56,580.00 (1,911.91) 136,332.00 17,056.58 12.5%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementNovember 2016Annual Budget8 NovemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group340.00 341.00 (1.00) 1,392.00 1,705.00 (313.00) 4,092.00 2,700.00 66.0%6601325 Insurance-Workers Comp91.20 94.00 (2.80) 451.30 470.00 (18.70) 1,129.00 677.70 60.0%6601720 Salaries2,804.96 2,508.00 296.96 11,524.80 12,540.00 (1,015.20) 30,096.00 18,571.20 61.7%6601800 Taxes-Employer Payroll145.20 351.00 (205.80) 725.60 1,755.00 (1,029.40) 4,213.00 3,487.40 82.8%Total-MKT-SALARIES & BENEFITS 3,381.36 3,294.00 87.36 14,093.70 16,470.00 (2,376.30) 39,530.00 25,436.30 64.3%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 404.74 100.00 304.74 1,003.47 500.00 503.47 1,200.00 196.53 16.4%6603768 Supplies-Printing & Stationery 215.84 200.00 15.84 1,433.08 3,400.00 (1,966.92) 4,425.00 2,991.92 67.6%620.58 300.00 320.58 2,436.55 3,900.00 (1,463.45) 5,625.00 3,188.45 56.7%66-MKT-UTILITIES6607840 Utilities-Telephone 99.16 100.00 (0.84) 328.40 500.00 (171.60) 1,200.00 871.60 72.6%Total-MKT-UTILITIES99.16 100.00 (0.84) 328.40 500.00 (171.60) 1,200.00 871.60 72.6%66-MKT-OTHER EXPENSES6609010 Advertising21,371.35 26,175.00 (4,803.65) 66,912.41 57,684.00 9,228.41 178,987.00 112,074.59 62.6%6609040 Business Meals- 25.00 (25.00) - 125.00 (125.00) 300.00 300.00 100.0%6609080 Collateral Material1,036.42 1,000.00 36.42 3,036.42 1,500.00 1,536.42 5,500.00 2,463.58 44.8%6609102 Contract Services-Web Page99.00 150.00 (51.00) 495.00 750.00 (255.00) 1,800.00 1,305.00 72.5%6609490 Miscellaneous231.00 50.00 181.00 533.70 50.00 483.70 350.00 (183.70) -52.5%6609620 Postage- 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0%6609630 Promotion- 50.00 (50.00) 97.09 100.00 (2.91) 700.00 602.91 86.1%6609633 Promotion-Community- 750.00 (750.00) 310.27 1,050.00 (739.73) 2,250.00 1,939.73 86.2%6609634 Promotion-Media/Vendor- 500.00 (500.00) - 500.00 (500.00) 2,000.00 2,000.00 100.0%6609150 Dues and Subscriptions- - - 82.50 - 82.50 735.00 652.50 88.8%6609820 Uniforms185.76 50.00 135.76 185.76 350.00 (164.24) 600.00 414.24 69.0%Total-MKT-OTHER EXPENSES22,923.53 28,800.00 (5,876.47) 71,653.15 62,359.00 9,294.15 193,822.00 122,168.85 63.0%27,024.63 32,494.00 (5,469.37) 88,511.80 83,229.00 5,282.80 240,177.00 151,665.20 63.1%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementNovember 2016Annual Budget9 NovemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group 1,002.10 1,488.00 (485.90) 5,387.95 7,440.00 (2,052.05) 17,856.00 12,468.05 69.8%6701325 Insurance-Workers Comp660.20 662.00 (1.80) 2,868.92 3,084.00 (215.08) 7,717.00 4,848.08 62.8%6701720 Salaries14,179.20 15,050.00 (870.80) 66,542.30 69,250.00 (2,707.70) 177,996.00 111,453.70 62.6%6701800 Taxes-Employer Payroll1,275.96 2,471.00 (1,195.04) 6,225.42 11,515.00 (5,289.58) 28,812.00 22,586.58 78.4%6701880 Wages-Hourly2,500.00 2,750.00 (250.00) 14,177.70 13,150.00 1,027.70 27,800.00 13,622.30 49.0%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 19,617.46 22,421.00 (2,803.54) 95,202.29 104,439.00 (9,236.71) 260,181.00 164,978.71 63.4%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer476.47 500.00 (23.53) 1,691.86 2,500.00 (808.14) 6,300.00 4,608.14 73.1%6703762 Supplies-Office109.20 150.00 (40.80) 265.93 750.00 (484.07) 1,800.00 1,534.07 85.2%6703768 Supplies-Printing & Stationery- 100.00 (100.00) 476.87 500.00 (23.13) 3,300.00 2,823.13 85.5%Total-G&A-SUPPLIES & MATERIALS585.67 750.00 (164.33) 2,434.66 3,750.00 (1,315.34) 11,400.00 8,965.34 78.6%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment 627.55 900.00 (272.45) 5,055.93 1,200.00 3,855.93 1,900.00 (3,155.93) -166.1%Total-G&A-REPAIRS & MAINTENANCE 627.55 900.00 (272.45) 5,055.93 1,200.00 3,855.93 1,900.00 (3,155.93) -166.1%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance 500.00 500.00 - 2,500.00 2,500.00 - 4,800.00 2,300.00 47.9%6709150 Dues & Subscriptions- 50.00 (50.00) - 350.00 (350.00) 1,700.00 1,700.00 100.0%6709180 Employee Recruiting/Relocation90.00 200.00 (110.00) 150.00 600.00 (450.00) 1,400.00 1,250.00 89.3%6709197 Equipment Rental465.00 550.00 (85.00) 2,866.38 2,750.00 116.38 6,600.00 3,733.62 56.6%6709202 Fees-Bank82.43 90.00 (7.57) 570.25 450.00 120.25 1,080.00 509.75 47.2%6709208 Fees-Payroll Processing196.39 1,200.00 (1,003.61) 4,459.56 6,000.00 (1,540.44) 14,400.00 9,940.44 69.0%6709220 Freight/Delivery- 50.00 (50.00) 31.72 250.00 (218.28) 600.00 568.28 94.7%6709490 Miscellaneous2,701.50 2,600.00 101.50 2,872.37 3,000.00 (127.63) 1,200.00 (1,672.37) -139.4%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services107.99 75.00 32.99 507.77 375.00 132.77 900.00 392.23 43.6%6709625 Professional Fees1,147.00 850.00 297.00 6,892.42 4,250.00 2,642.42 10,200.00 3,307.58 32.4%6709636 Promotion/Entertainment- 100.00 (100.00) - 500.00 (500.00) 6,600.00 6,600.00 100.0%6709722 Seminars & Training- 200.00 (200.00) 800.00 1,000.00 (200.00) 2,400.00 1,600.00 66.7%6709810 Travel- - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms321.12 150.00 900.00 321.12 525.00 (203.88) 1,050.00 728.88 69.4%Total-G&A-OTHER EXPENSES 5,611.43 6,615.00 (274.69) 21,971.59 22,650.00 (678.41) 54,030.00 32,058.41 59.3%26,442.11 30,686.00 (4,243.89) 124,664.47 132,039.00 (7,374.53) 327,511.00 202,846.53 61.9%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementNovember 2016Annual Budget10 NovemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts10,063.45 10,050.00 13.45 51,353.80 50,700.00 653.80 121,050.00 69,696.20 57.6%6800193 Equipment Leases-Maintenance 11,400.00 11,500.00 (100.00) 33,614.50 35,700.00 (2,085.50) 72,600.00 38,985.50 53.7%6800194 Equipment Leases-Trailer802.07 600.00 202.07 2,970.35 3,000.00 (29.65) 7,200.00 4,229.65 58.7%6800196 Equipment Leases-GPS3,870.00 4,700.00 (830.00) 26,730.00 23,500.00 3,230.00 56,400.00 29,670.00 52.6%6800197 Equipment Leases-Others529.51 1,950.00 (1,420.49) 10,464.64 6,550.00 3,914.64 13,800.00 3,335.36 0.0%26,665.03 28,800.00 (2,134.97) 125,133.29 119,450.00 5,683.29 271,050.00 145,916.71 53.8%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,652.60 8,653.00 (0.40) 43,264.00 43,265.00 (1.00) 99,840.00 56,576.00 56.7%6900210 FF&E Reserve5,893.24 6,687.00 (793.76) 12,539.40 8,901.00 3,638.40 63,985.00 51,445.60 80.4%6900800 Personal Property Taxes- - - 10,871.10 11,800.00 (928.90) 11,800.00 928.90 7.9%6900323 Insurance-Commercial3,386.77 2,700.00 686.77 22,360.61 13,500.00 8,860.61 26,400.00 4,039.39 15.3%17,932.61 18,040.00 (107.39) 89,035.11 77,466.00 11,569.11 202,025.00 112,989.89 55.9%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementNovember 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 20 13Charity/Gift Certificate184Rain/Wind Checks11Club Staff47 61 63 19 25LQ HS Golf5884492 122 130 43 4302017 2017 2017 2017 2017 2017Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf Industry12 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2016-2017November 2016 Date TimeDescriptionCategoryPlayers11/14/2016 12:00 p.m. Judd Spicer Golf WriterMedia411/19/2016 11:53 p.m. Kris LongMedia 413