Loading...
08 February 2016 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2015 – February 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 FebruaryFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue524,191.20 496,306.00 27,885.20 5.6% 1,828,833.70 1,810,083.00 18,750.70 3,199,237.00 1,370,403.30 57%401000 Miscellaneous Golf Revenue56,996.50 54,275.00 2,721.50 5.0% 243,586.89 219,780.00 23,806.89 349,259.00 105,672.11 70%410000 Revenue-Golf Shop37,828.08 38,500.00 (671.92) -1.7% 138,272.92 158,437.00 (20,164.08) 278,585.00 140,312.08 50%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0%9,000.00 9,000.00 - 12,000.00 3,000.00 75%890000 Interest Income0.31 - 0.31 11.98 - 11.98 - (11.98) 0%Total Income620,516.09 590,581.00 29,935.09 5.1% 2,219,705.49 2,197,300.00 22,405.49 3,839,081.00 1,619,375.51 58%Cost of Goods Sold510000 COS-Golf Shop20,785.70 21,548.00 (762.30) 3.5% 77,706.55 88,676.46 10,969.91 155,924.00 78,217.45 50%Total COS20,785.70 21,548.00 (762.30) 3.5% 77,706.55 88,676.46 10,969.91 155,924.00 78,217.45 50%Gross Profit599,730.39 569,033.00 30,697.39 5.4% 2,141,998.94 2,108,623.54 33,375.40 3,683,157.00 1,541,158.06 58%Expenses610000 Golf Pro Shop 18,574.40 18,519.00 55.40 -0.3% 123,792.92 129,456.00 (5,663.08) 204,827.00 81,034.08 60%630000 Course Maintenance123,315.02 126,028.00 (2,712.98) 2.2% 1,205,757.56 1,233,948.00 (28,190.44) 1,712,795.00 507,037.44 70%633000 Maintenance Water & Energy17,077.12 16,489.00 588.12 -3.6% 147,730.08 135,295.00 12,435.08 225,129.00 77,398.92 66%640000 Outside Services36,540.96 40,480.00 (3,939.04) 9.7% 205,535.64 204,898.00 637.64 309,830.00 104,294.36 66%650000 Clubhouse11,506.67 10,636.00 870.67 -8.2% 93,945.16 90,588.00 3,357.16 136,332.00 42,386.84 69%660000 Marketing21,011.21 24,581.00 (3,569.79) 14.5% 164,332.93 169,265.00 (4,932.07) 240,177.00 75,844.07 68%670000 General & Administrative24,632.15 27,811.00 (3,178.85) 11.4% 200,185.21 217,020.00 (16,834.79) 327,511.00 127,325.79 61%680000 Leases22,230.83 22,550.00 (319.17) 1.4% 180,136.66 180,850.00 (713.34) 271,050.00 90,913.34 66%690000 Miscellaneous Other Expense26,215.07 20,446.00 5,769.07 -28.2% 144,900.00 132,163.00 12,737.00 202,025.00 57,125.00 72%Total Expenses301,103.43 307,540.00 (6,436.57) 2.1% 2,466,316.16 2,493,483.00 27,166.84 3,629,676.00 1,163,359.84 68%298,626.96 261,493.00 37,133.96 14.2%(324,317.22) (384,859.46) 60,542.24 53,481.00 377,798.22 0%Rounds of Golf PlayedPaid Rounds Played5,764 5,500 264 4.8%27,446 27,475 (29) 41,100 13,654 67%Ave $ Per Paid Round Green Fee90.94 90.24 0.70 0.8%66.63 65.88 0.75 77.84 11.21 86%Ave $ Per Paid Round Merchandise6.56 7.00 (0.44) -6.2%5.04 5.77 (0.73) 6.78 1.74 74%Ave $ Per Paid Miscellaneous 9.89 9.87 0.02 0.2%8.88 8.00 0.88 8.50 (0.38) 104%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateFebruary 20161 Income FebruaryFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees524,191.20 496,306.00 27,885.20 1,828,833.70 1,810,083.00 18,750.70 3,199,237.00 1,370,403.30 42.8%4010000 Rider Fee1,400.00 1,375.00 25.00 6,882.50 4,958.00 1,924.50 7,738.00 855.50 11.1%4040000 Club Rental3,126.00 2,750.00 376.00 13,001.00 13,838.00 (837.00) 23,238.00 10,237.00 44.1%4050000 Driving Range19,280.00 19,250.00 30.00 66,847.00 63,784.00 3,063.00 100,984.00 34,137.00 33.8%4060000 Handicap Fees- 400.00 (400.00) - 2,100.00 (2,100.00) 2,500.00 2,500.00 100.0%4080000 GPS Advertising- 500.00 (500.00) - 2,400.00 (2,400.00) 2,600.00 2,600.00 100.0%4090000 Ball Retriever/Subcontract - - - 1,497.80 3,000.00 (1,502.20) 4,000.00 2,502.20 62.6%4091000 Golf Professional Rental Fee 6,130.50 6,000.00 130.50 23,808.59 21,000.00 2,808.59 37,000.00 13,191.41 35.7%4092000 Golf Lessons - - - - - - - - 0.0%4093000 Resident Card Issue27,060.00 24,000.00 3,060.00 131,550.00 108,700.00 22,850.00 171,200.00 39,650.00 23.2% Total Revenue Fees581,187.70 550,581.00 30,606.70 2,072,420.59 2,029,863.00 42,557.59 3,548,497.00 1,476,076.41 41.6%581,187.70 550,581.00 30,606.70 2,072,420.59 2,029,863.00 42,557.59 3,548,497.00 1,476,076.41 41.6%SilverRock ResortStatement of Fees RevenueFebruary 2016Total IncomeMonth to DateYear to DateAnnual Budget2 ExpensesActualBudgetVariance$21,011.21$24,581.00(3,569.79)Favorable: Due to timing of advertisement invoices, also, we are currently tracking with our year to date budgeted amount.ActualBudgetVariance$24,632.15$27,811.00(3,178.85)Favorable: Due to reduced spending on most of our line items and payroll processing.ActualBudgetVariance$26,215.07$20,446.005,769.07Unfavorable: Due to required payment scheme for our commercial insurance we make 8 payments instead of 12. This will be corrected on new budget year.provided for those cost of sales percentage that are greater than 5%.Variance ExplanationFebruary 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 areMarketingMiscellaneous Other ExpensesGeneral and Administrative3-20-133 Income FebruaryFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous489.33 - 489.33 1,702.02 - 1,702.02 00 0%4100110 Sales Hard Goods 11,686.87 13,475.00 (1,788.13) 49,595.48 55,454.00 (5,858.52) 97,505.00 47,909.52 49.1%4100112 Sales-Soft Goods30,582.00 25,025.00 5,557.00 104,763.00 102,983.00 1,780.00 181,080.00 76,317.00 42.1%5100639 GS-Discounts-Mdse (4,930.12) - (4,930.12) (17,787.58) - (17,787.58) - 17,787.58 0.0% Total Revenue Golf Shop37,828.08 38,500.00 (671.92) 138,272.92 158,437.00 (20,164.08) 278,585.00 142,014.10 51.0%COS 5100150 COS-GS-Hard Goods 6,044.67 7,815.50 (1,770.83) 28,080.14 32,163.32 (4,083.18) 56,552.90 28,472.76 50.3%5100151 COS-GS-Soft Goods 14,441.35 14,514.50 (73.15) 47,105.61 59,730.14 (12,624.53) 105,026.40 57,920.79 55.1%5100152 COS-GS-Purchase Disc (55.29) (1,117.00) 1,061.71 (130.20) (4,596.00) 4,465.80 (8,079.00) (7,948.80) 98.4%5100220 COS-GS-Freight Merch 354.97 335.00 19.97 2,651.00 1,379.00 1,272.00 2,424.00 (227.00) -9.4%Cost of Sales - Golf Shop20,785.70 21,548.00 (762.30) 77,706.55 88,676.46 (10,969.91) 155,924.30 78,217.75 50.2%Gross Profit17,042.38 16,952.00 90.38 60,566.37 69,760.54 (9,194.17) 122,660.70 63,796.35 52.0%COS % 54.9% 56.0% 1.0% 56.2% 56.0% -0.2% 53.1% 55.1% 103.8%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group2,125.63 2,387.00 (261.37) 14,819.63 18,073.00 (3,253.37) 27,621.00 12,801.37 46.3%6101325 Insurance-Workers Comp 651.02 478.00 173.02 4,417.74 3,199.00 1,218.74 5,042.00 624.26 12.4%6101720 Salaries4,002.00 3,950.00 52.00 31,060.35 31,600.00 (539.65) 45,000.00 13,939.65 31.0%6101800 Taxes-Employer Payroll 1,895.45 1,786.00 109.45 10,282.75 11,944.00 (1,661.25) 18,825.00 8,542.25 45.4%6101880 Wages-Hourly9,106.79 8,808.00 298.79 54,695.67 53,720.00 975.67 89,463.00 34,767.33 38.9%6101882 Wages-Overtime54.36 - 54.36 272.06 - 272.06 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 17,835.25 17,409.00 426.25 115,548.20 118,536.00 (2,987.80) 185,951.00 71,627.74 38.5%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - 273.99 - 273.99 - (273.99) 0.0%6103762 Supplies-Office114.12 250.00 (135.88) 973.00 2,000.00 (1,027.00) 3,000.00 2,027.00 67.6%6109220 Freight & Delivery- - - 140.00 75.00 65.00 75.00 (65.00) -86.7%6109490 Miscellaneous500.00 500.00 - 3,582.24 4,000.00 (417.76) 6,000.00 2,417.76 40.3%6109150 Dues and Subscriptions- - - 102.30 - 102.30 2,300.00 2,197.70 95.6%6109500 ProShop-Over/Short11.97 - 11.97 55.15 - 55.15 - (55.15) 0.0%6109722 Seminars/Training- 35.00 (35.00) - 2,335.00 (2,335.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- 15.00 (15.00) - 30.00 (30.00) 90.00 90.00 100.0%6109820 Uniforms- 200.00 (200.00) 2,134.92 1,600.00 534.92 2,400.00 265.08 11.0%6117840 Telephones113.06 110.00 3.06 983.12 880.00 103.12 1,320.00 336.88 25.5%739.15 1,110.00 (370.85) 8,244.72 10,920.00 (2,675.28) 18,875.00 10,630.28 56.3%18,574.40 18,519.00 55.40 123,792.92 129,456.00 (5,663.08) 204,826.00 82,258.02 40.2%Net Income(1,532.02) (1,567.00) 34.98 (63,226.55) (59,695.46) (3,531.09) (82,165.30) (18,461.67) 22.5%SilverRock ResortGolf Shop Income StatementFebruary 2016Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 FebruaryFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group6,464.24 8,990.00 (2,525.76) 64,228.41 71,920.00 (7,691.59) 107,880.00 43,651.59 40.5%6311325 Insurance-Workers Comp2,835.60 2,065.00 770.60 20,540.54 16,462.00 4,078.54 24,794.00 4,253.46 17.2%6311720 Salaries11,920.80 11,900.00 20.80 92,676.80 95,200.00 (2,523.20) 142,017.20 49,340.40 34.7%6311800 Taxes-Employer Payroll4,791.68 7,708.00 (2,916.32) 44,614.49 62,065.00 (17,450.51) 93,302.00 48,687.51 52.2%6311880 Wages-Hourly44,502.82 43,156.00 1,346.82 337,568.89 335,054.00 2,514.89 508,481.80 170,912.91 33.6%6311882 Wages-Overtime- - - 12,421.76 13,076.00 (654.24) 15,945.00 3,523.24 22.1%Total-CM-SALARIES & BENEFITS70,515.14 73,819.00 (3,303.86) 572,050.89 593,777.00 (21,726.11) 892,420.00 320,369.11 35.9%63-CM-SUPPLIES & MATERIALS6313734 Chemicals1,472.33 3,000.00 (1,527.67) 31,907.25 28,200.00 3,707.25 34,600.00 2,692.75 7.8%6313744 Fertilizer14,434.89 12,500.00 1,934.89 100,285.35 91,500.00 8,785.35 112,500.00 12,214.65 10.9%6313745 Herbicides- - - 19,367.52 17,000.00 2,367.52 17,000.00 (2,367.52) -13.9%6313746 Flowers/Plants- 100.00 (100.00) 1,124.44 2,850.00 (1,725.56) 3,050.00 1,925.56 63.1%6313748 Fuel-Gasoline2,315.41 3,820.00 (1,504.59) 30,503.85 40,870.00 (10,366.15) 55,020.00 24,516.15 44.6%6313750 Golf Course Accessories149.25 100.00 49.25 11,228.32 12,600.00 (1,371.68) 13,000.00 1,771.68 13.6%6313756 POA Control- - - 6,757.37 7,000.00 (242.63) 7,000.00 242.63 3.5%6313758 Miscellaneous Supp891.58 100.00 791.58 5,186.82 3,950.00 1,236.82 4,350.00 (836.82) -19.2%6313762 Supplies-Office- - - - - - - - 0.0%6313774 Sand- 100.00 (100.00) 1,879.45 13,060.00 (11,180.55) 13,460.00 11,580.55 86.0%6313776 Seed- 350.00 (350.00) 132,015.98 124,500.00 7,515.98 125,900.00 (6,115.98) -4.9%6313778 Small Tools & Non-Capital Equip177.28 100.00 77.28 3,149.50 4,600.00 (1,450.50) 5,000.00 1,850.50 37.0%6313780 Sod- - - 5,597.26 9,750.00 (4,152.74) 10,450.00 4,852.74 46.4%6313782 Topdressing1,491.88 - 1,491.88 7,213.94 8,000.00 (786.06) 10,600.00 3,386.06 31.9%Total-CM-SUPPLIES & MATERIALS20,932.62 20,170.00 762.62 356,217.05 363,880.00 (7,662.95) 411,930.00 55,712.95 13.5%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint2,830.00 2,600.00 230.00 25,991.50 20,800.00 5,191.50 31,200.00 5,208.50 16.7%6315685 CM-R&M-Bldngs & Othr Structures 107.12 250.00 (142.88) 2,692.94 4,550.00 (1,857.06) 5,550.00 2,857.06 51.5%6315690 CM-R&M-Equipment3,979.48 3,000.00 979.48 35,247.24 31,000.00 4,247.24 40,000.00 4,752.76 11.9%6315692 CM-R&M-Irrigation System765.12 1,000.00 (234.88) 14,174.26 15,050.00 (875.74) 19,050.00 4,875.74 25.6%6315696 CM-R&M-Pumps- 1,000.00 (1,000.00) 10,140.45 8,000.00 2,140.45 10,500.00 359.55 3.4%6315815 CM-R&M-Trees-Pruning Etc- - - 8,555.95 6,050.00 2,505.95 12,050.00 3,494.05 29.0%Total-CM-REPAIRS & MAINTENANCE7,681.72 7,850.00 (168.28) 96,802.34 85,450.00 11,352.34 118,350.00 21,547.66 18.2%6317836 Utilities-Natural Gas/LPG 30.58 15.00 15.58 177.21 120.00 57.21 180.00 2.79 0.0%6317840 Telephones578.35 850.00 (271.65) 8,099.92 6,800.00 1,299.92 10,200.00 2,100.08 20.6%Total-CM-UTILITIES608.93 865.00 (256.07) 8,277.13 6,920.00 1,357.13 10,380.00 2,102.87 20.3%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance500.00 500.00 - 4,000.00 4,000.00 - 6,000.00 2,000.00 33.3%6319100 Contract Svcs-Soil/Tissue Test- - - 2,000.00 2,000.00 - 4,000.00 2,000.00 50.0%6319102 Contract Svcs-Trash Removal666.85 524.00 142.85 5,934.07 4,192.00 1,742.07 6,288.00 353.93 5.6%6319150 Dues & Subscriptions35.00 240.00 (205.00) 960.00 240.00 720.00 540.00 (420.00) -77.8%6319170 Employee Education1,581.99 1,000.00 581.99 1,650.99 1,350.00 300.99 1,550.00 (100.99) -6.5%6319197 Equipment Rental- 200.00 (200.00) 911.44 2,700.00 (1,788.56) 3,400.00 2,488.56 73.2%6319206 Licenses & Permits- - - 223.89 280.00 (56.11) 4,180.00 3,956.11 94.6%6319490 Miscellaneous- 100.00 (100.00) 596.14 800.00 (203.86) 1,200.00 603.86 50.3%6319718 Safety Equipment & Training929.77 200.00 729.77 3,685.58 3,350.00 335.58 3,850.00 164.42 4.3%6319822 Uniforms1,218.26 920.00 298.26 7,855.56 7,360.00 495.56 11,040.00 3,184.44 28.8%Total-CM-OTHER EXPENSES4,931.87 3,684.00 1,247.87 27,817.67 26,272.00 1,545.67 42,048.00 14,230.33 33.8%SilverRock ResortCourse Maintenance Expense StatementFebruary 2016Annual BudgetMonth to DateYear to Date5 FebruaryFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,998.50 2,728.00 (729.50) 15,735.70 21,824.00 (6,088.30) 32,736.00 17,000.30 51.9%6321325 Insurance-Workers Comp325.51 519.00 (193.49) 3,745.98 4,069.00 (323.02) 6,171.00 2,425.02 39.3%6321800 Taxes-Employer Payroll1,415.96 1,938.00 (522.04) 11,371.76 15,438.00 (4,066.24) 23,334.00 11,962.24 51.3%6321880 Wages-Hourly14,646.60 13,840.00 806.60 107,711.50 104,960.00 2,751.50 160,320.00 52,608.50 32.8%6321882 Wages-Overtime- - - 4,181.01 5,313.00 (1,131.99) 6,351.00 2,169.99 34.2%Total-CM-LM-SALARIES & BENEFITS18,386.57 19,025.00 (638.43) 142,745.95 151,604.00 (8,858.05) 228,912.00 86,166.05 37.6%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 75.00 (75.00) - 725.00 (725.00) 1,025.00 1,025.00 100.0%6323788 Uniforms258.17 290.00 (31.83) 1,846.53 2,320.00 (473.47) 3,480.00 1,633.47 46.9%Total-CM-LM-SUPPLIES & MATERIALS258.17 365.00 (106.83) 1,846.53 3,045.00 (1,198.47) 4,505.00 2,658.47 59.0%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 250.00 (250.00) - 3,000.00 (3,000.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE- 250.00 (250.00) - 3,000.00 (3,000.00) 4,250.00 4,250.00 100.0%123,315.02 126,028.00 (2,712.98) 1,205,757.56 1,233,948.00 (28,190.44) 1,712,795.00 507,037.44 29.6% FebruaryFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 15,227.98 15,016.00 211.98 111,878.23 102,822.00 9,056.23 179,791.00 67,912.77 37.8%6337842 Utilities-Water1,849.14 1,473.00 376.14 35,851.85 32,473.00 3,378.85 45,338.00 9,486.15 20.9%17,077.12 16,489.00 588.12 147,730.08 135,295.00 12,435.08 225,129.00 77,398.92 34.4%Silverrock ResortCourse Maintenance Water & EnergyFebruary 2016Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementFebruary 2016Silverrock ResortAnnual BudgetMonth to DateYear to Date6 FebruaryFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 682.00 (682.00) - 5,456.00 (5,456.00) 8,184.00 8,184.00 100.0%6411325 Insurance-Workers Comp1,085.04 613.00 472.04 5,054.28 3,204.00 1,850.28 5,229.00 174.72 3.3%6411800 Taxes-Employer Payroll2,890.02 2,036.00 854.02 11,391.60 10,637.00 754.60 17,360.00 5,968.40 34.4%6411880 Wages-Hourly19,229.23 16,350.00 2,879.23 92,463.12 85,435.00 7,028.12 139,434.00 46,970.88 33.7%6411882 Wages-Overtime 301.88 - 301.88 787.79 - 787.79 - (787.79) 0.0%Total-CBR-SALARIES & BENEFITS23,506.17 19,681.00 3,825.17 109,696.79 104,732.00 4,964.79 170,207.00 60,510.21 35.6%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- 75.00 (75.00) 3,206.88 1,650.00 1,556.88 1,850.00 `0.0%6413742 Supplies-Expendable393.12 1,000.00 (606.88) 4,612.12 5,450.00 (837.88) 6,750.00 2,137.88 31.7%6413748 Supplies-Fuel for Shuttle- 450.00 (450.00) - 1,800.00 (1,800.00) 3,000.00 3,000.00 100.0%6413752 Supplies-Range Balls- - - 9,000.00 9,000.00 - 9,000.00 - 0.0%6413762 Supplies-Office- 50.00 (50.00) - 325.00 (325.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- 70.00 (70.00) - 140.00 (140.00) 420.00 420.00 100.0%6413786 Supplies-Towels 240.00 250.00 (10.00) 2,240.00 1,360.00 880.00 2,182.00 (58.00) -2.7%6413796 Supplies-Bottled Water108.00 7,000.00 (6,892.00) 5,161.20 10,800.00 (5,638.80) 11,000.00 5,838.80 53.1%Total-CBR-SUPPLIES & MATERIALS741.12 8,895.00 (8,153.88) 24,220.20 30,525.00 (6,304.80) 34,727.00 11,863.68 34.2%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment- 300.00 (300.00) 2,135.29 2,400.00 (264.71) 3,600.00 1,464.71 40.7%6415695 CBR-R&M-Cart Maintenance & Repair 1,320.00 500.00 820.00 8,230.68 4,450.00 3,780.68 6,450.00 (1,780.68) -27.6%Total-CBR-REPAIRS & MAINTENANCE1,320.00 800.00 520.00 10,365.97 6,850.00 3,515.97 10,050.00 (315.97) -3.1%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen681.70 800.00 (118.30) 4,520.30 6,400.00 (1,879.70) 9,600.00 5,079.70 52.9%6419220 Freight/Delivery- - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous138.58 600.00 (461.42) 3,435.78 4,800.00 (1,364.22) 7,200.00 3,764.22 52.3%6419820 Uniforms 49.41 - 49.41 2,917.33 3,000.00 (82.67) 5,200.00 2,282.67 43.9%Total-CBR-OTHER EXPENSES869.69 1,400.00 (530.31) 10,873.41 14,650.00 (3,776.59) 22,450.00 11,576.59 51.6%TOTAL-CARTS,BAGROOM & RANGE26,436.98 30,776.00 (530.31) 155,156.37 156,757.00 (1,600.63) 237,434.00 83,634.51 35.2%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp651.02 302.00 349.02 2,413.12 1,444.00 969.12 2,179.00 (234.12) -10.7%6431800 Taxes-Employer Payroll948.48 1,127.00 (178.52) 4,421.97 5,390.00 (968.03) 8,135.00 3,713.03 45.6%6431880 Wages-Hourly8,267.50 8,050.00 217.50 40,610.12 38,507.00 2,103.12 58,108.00 17,497.88 30.1%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS9,867.00 9,479.00 388.00 47,445.21 45,341.00 2,104.21 68,422.00 20,976.79 30.7%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 100.00 (100.00) 200.20 700.00 (499.80) 1,050.00 849.80 80.9%6439490 Miscellaneous236.98 - 236.98 1,031.60 200.00 831.60 200.00 (831.60) -415.8%6439718 Safety Equipment & Training- 50.00 (50.00) - 400.00 (400.00) 600.00 600.00 100.0%6439820 Uniforms - 75.00 (75.00) 1,702.26 1,500.00 202.26 2,125.00 422.74 19.9%Total-CS-OTHER EXPENSES236.98 225.00 11.98 2,934.06 2,800.00 134.06 3,975.00 1,040.94 26.2%Total-COURSE SERVICES10,103.98 9,704.00 399.98 50,379.27 48,141.00 2,238.27 72,397.00 22,017.73 30.4%36,540.96 40,480.00 (3,939.04) 205,535.64 204,898.00 637.64 309,831.00 104,611.30 33.8%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementFebruary 2016Annual Budget7 FebruaryFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 3,205.00 3,200.00 5.00 4,800.00 1,595.00 33.2%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 3,205.00 3,200.00 5.00 4,800.00 1,595.00 33.2%65-CH-UTILITIES6507836 Utilities-Natural Gas728.75 300.00 428.75 3,131.75 2,400.00 731.75 3,600.00 468.25 13.0%6507840 Utilities-Telephone1,095.04 1,150.00 (54.96) 7,506.98 9,200.00 (1,693.02) 13,800.00 6,293.02 45.6%6507842 Utilities-Water1,058.98 321.00 737.98 6,678.57 2,568.00 4,110.57 3,852.00 (2,826.57) -73.4%6507844 Utilities-Cable 482.21 340.00 142.21 3,853.68 2,720.00 1,133.68 4,080.00 226.32 5.5%Total-CH-UTILITIES3,364.98 2,111.00 1,253.98 21,170.98 16,888.00 4,282.98 25,332.00 4,161.02 16.4%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 1,750.00 1,825.00 (75.00) 14,797.00 15,200.00 (403.00) 22,500.00 7,703.00 34.2%6509099 Contract Services-Security5,229.72 4,900.00 329.72 42,300.32 40,800.00 1,500.32 60,400.00 18,099.68 30.0%6509215 Flowers & Decorations63.73 - 63.73 522.43 1,000.00 (477.57) 1,900.00 1,377.57 72.5%6509490 Miscellaneous- 200.00 (200.00) 2,716.16 3,900.00 (1,183.84) 7,000.00 4,283.84 61.2%6509718 Safety Equipment & Training320.32 100.00 220.32 320.32 800.00 (479.68) 1,200.00 879.68 73.3%Total-CH-OTHER EXPENSES7,363.77 7,025.00 338.77 60,656.23 61,700.00 (1,043.77) 93,000.00 32,343.77 34.8%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures377.92 300.00 77.92 3,140.98 2,400.00 740.98 3,600.00 459.02 12.8%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 3,339.93 3,200.00 139.93 4,800.00 1,460.07 30.4%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 2,432.04 3,200.00 (767.96) 4,800.00 2,367.96 49.3%Total-CH-REPAIRS & MAINTENANCE377.92 1,100.00 (722.08) 8,912.95 8,800.00 112.95 13,200.00 4,287.05 32.5%11,506.67 10,636.00 870.67 93,945.16 90,588.00 3,357.16 136,332.00 8,574.10 6.3%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementFebruary 2016Annual Budget8 FebruaryFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 341.00 341.00 - 2,682.00 2,728.00 (46.00) 4,092.00 1,410.00 34.5%6601325 Insurance-Workers Comp94.00 94.00 - 676.20 752.00 (75.80) 1,129.00 452.80 40.1%6601720 Salaries1,904.96 2,508.00 (603.04) 15,991.12 20,064.00 (4,072.88) 30,096.00 14,104.88 46.9%6601800 Taxes-Employer Payroll350.20 351.00 (0.80) 2,022.32 2,808.00 (785.68) 4,213.00 2,190.68 52.0%Total-MKT-SALARIES & BENEFITS2,690.16 3,294.00 (603.84) 21,371.64 26,352.00 (4,980.36) 39,530.00 18,158.36 45.9%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 621.44 800.00 (178.56) 1,200.00 578.56 48.2%6603768 Supplies-Printing & Stationery 345.43 125.00 220.43 4,619.49 3,925.00 694.49 4,425.00 (194.49) -4.4%345.43 225.00 120.43 5,240.93 4,725.00 515.93 5,625.00 384.07 6.8%66-MKT-UTILITIES6607840 Utilities-Telephone54.08 100.00 (45.92) 359.48 800.00 (440.52) 1,200.00 840.52 70.0%Total-MKT-UTILITIES54.08 100.00 (45.92) 359.48 800.00 (440.52) 1,200.00 840.52 70.0%66-MKT-OTHER EXPENSES6609010 Advertising16,745.93 19,112.00 (2,366.07) 129,478.46 127,503.00 1,975.46 178,987.00 49,508.54 27.7%6609040 Business Meals- - - - - - 300.00 300.00 100.0%6609080 Collateral Material482.61 500.00 (17.39) 6,007.49 2,500.00 3,507.49 5,500.00 (507.49) -9.2%6609102 Contract Services-Web Page693.00 150.00 543.00 1,188.00 1,200.00 (12.00) 1,800.00 612.00 34.0%6609490 Miscellaneous- 50.00 (50.00) - 200.00 (200.00) 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 400.00 (400.00) 600.00 600.00 100.0%6609630 Promotion- 25.00 (25.00) - 200.00 (200.00) 700.00 700.00 100.0%6609633 Promotion-Community- 125.00 (125.00) 76.50 2,450.00 (2,373.50) 2,250.00 2,173.50 96.6%6609634 Promotion-Media/Vendor- 500.00 (500.00) - 2,000.00 (2,000.00) 2,000.00 2,000.00 100.0%6609150 Dues and Subscriptions- 400.00 (400.00) 110.00 435.00 (325.00) 735.00 625.00 85.0%6609820 Uniforms- 50.00 (50.00) 500.43 500.00 0.43 600.00 99.57 16.6%Total-MKT-OTHER EXPENSES17,921.54 20,962.00 (3,040.46) 137,360.88 137,388.00 (27.12) 193,822.00 56,461.12 29.1%21,011.21 24,581.00 (3,569.79) 164,332.93 169,265.00 (4,932.07) 240,177.00 75,844.07 31.6%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementFebruary 2016Annual Budget9 FebruaryFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,042.88 1,488.00 (445.12) 8,862.12 11,904.00 (3,041.88) 17,856.00 8,993.88 50.4%6701325 Insurance-Workers Comp325.53 662.00 (336.47) 5,410.01 5,070.00 340.01 7,717.00 2,306.99 29.9%6701720 Salaries15,021.00 15,050.00 (29.00) 110,033.50 114,400.00 (4,366.50) 177,996.00 67,962.50 38.2%6701800 Taxes-Employer Payroll1,918.17 2,471.00 (552.83) 15,499.26 18,928.00 (3,428.74) 28,812.00 13,312.74 46.2%6701880 Wages-Hourly2,574.20 2,600.00 (25.80) 22,537.60 20,798.00 1,739.60 27,800.00 5,262.40 18.9%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS20,881.78 22,271.00 (1,389.22) 162,342.49 171,100.00 (8,757.51) 260,181.00 97,838.51 37.6%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 500.00 (500.00) 1,216.09 4,000.00 (2,783.91) 6,300.00 5,083.91 80.7%6703762 Supplies-Office44.61 150.00 (105.39) 970.56 1,200.00 (229.44) 1,800.00 829.44 46.1%6703768 Supplies-Printing & Stationery505.55 400.00 105.55 1,087.52 1,700.00 (612.48) 3,300.00 2,212.48 67.0%Total-G&A-SUPPLIES & MATERIALS550.16 1,050.00 (499.84) 3,274.17 6,900.00 (3,625.83) 11,400.00 8,125.83 71.3%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment 100.00 100.00 - 1,200.00 1,500.00 (300.00) 1,900.00 700.00 36.8%Total-G&A-REPAIRS & MAINTENANCE100.00 100.00 - 1,200.00 1,500.00 (300.00) 1,900.00 700.00 36.8%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 3,200.00 3,200.00 - 4,800.00 1,600.00 33.3%6709150 Dues & Subscriptions309.00 400.00 (91.00) 309.00 1,050.00 (741.00) 1,700.00 1,391.00 81.8%6709180 Employee Recruiting/Relocation90.00 200.00 (110.00) 1,082.57 1,200.00 (117.43) 1,400.00 317.43 22.7%6709197 Equipment Rental622.50 550.00 72.50 5,412.76 4,400.00 1,012.76 6,600.00 1,187.24 18.0%6709202 Fees-Bank- 90.00 (90.00) 994.04 720.00 274.04 1,080.00 85.96 8.0%6709208 Fees-Payroll Processing793.69 1,200.00 (406.31) 9,674.65 9,600.00 74.65 14,400.00 4,725.35 32.8%6709220 Freight/Delivery- 50.00 (50.00) 10.68 400.00 (389.32) 600.00 589.32 98.2%6709490 Miscellaneous- 100.00 (100.00) 4,223.20 6,200.00 (1,976.80) 1,200.00 (3,023.20) -251.9%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services101.99 75.00 26.99 775.83 600.00 175.83 900.00 124.17 13.8%6709625 Professional Fees652.00 850.00 (198.00) 6,381.62 6,800.00 (418.38) 10,200.00 3,818.38 37.4%6709636 Promotion/Entertainment- 100.00 (100.00) - 800.00 (800.00) 6,600.00 6,600.00 100.0%6709722 Seminars & Training84.70 200.00 (115.30) 584.70 1,600.00 (1,015.30) 2,400.00 1,815.30 75.6%6709810 Travel- 100.00 (100.00) - 200.00 (200.00) 1,100.00 1,100.00 100.0%6709820 Uniforms46.33 75.00 900.00 719.50 750.00 (30.50) 1,050.00 330.50 31.5%Total-G&A-OTHER EXPENSES3,100.21 4,390.00 (361.12) 33,368.55 37,520.00 (4,151.45) 54,030.00 20,661.45 38.2%24,632.15 27,811.00 (3,178.85) 200,185.21 217,020.00 (16,834.79) 327,511.00 127,325.79 38.9%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementFebruary 2016Annual Budget10 FebruaryFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts10,363.45 10,050.00 313.45 82,907.60 80,400.00 2,507.60 121,050.00 38,142.40 31.5%6800193 Equipment Leases-Maintenance 5,571.50 6,050.00 (478.50) 44,572.00 48,850.00 (4,278.00) 72,600.00 28,028.00 38.6%6800194 Equipment Leases-Trailer772.61 600.00 172.61 3,848.27 4,800.00 (951.73) 7,200.00 3,351.73 46.6%6800196 Equipment Leases-GPS4,500.00 4,700.00 (200.00) 36,000.00 37,600.00 (1,600.00) 56,400.00 20,400.00 36.2%6800197 Equipment Leases-Others1,023.27 1,150.00 (126.73) 12,808.79 9,200.00 3,608.79 13,800.00 991.21 0.0%22,230.83 22,550.00 (319.17) 180,136.66 180,850.00 (713.34) 271,050.00 90,913.34 33.5%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,320.00 8,320.00 - 66,560.00 66,560.00 - 99,840.00 33,280.00 33.3%6900210 FF&E Reserve10,483.82 9,926.00 557.82 36,576.67 36,203.00 373.67 63,985.00 27,408.33 42.8%6900800 Personal Property Taxes- - - 12,117.83 11,800.00 317.83 11,800.00 (317.83) -2.7%6900323 Insurance-Commercial7,411.25 2,200.00 5,211.25 29,645.50 17,600.00 12,045.50 26,400.00 (3,245.50) -12.3%26,215.07 20,446.00 5,769.07 144,900.00 132,163.00 12,737.00 202,025.00 57,125.00 28.3%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementFebruary 2016Annual BudgetMonth to Date Year to Date11 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2015‐20162015 2015 2015 2015 2015 2015Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia24414SalesPromotion4Golf IndustryVIPCelebrityPGA Comp383738112366Charity/Gift Certificate72626Rain/Wind Checks12129Club Staff956280652111LQ HS Golf2117182530168 121 14319112 2602016 2016 2016 2016 2016 2016Comp CategoryJanuaryFebruaryMarchAprilMayJuneMedia42SalesPromotion4Golf IndustryVIPCelebrityPGA Comp4342Charity/Gift Certificate42Rain/Wind Checks11Club Staff7766LQ HS Golf2624159137000012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2015‐2016February 2016 Date Time DescriptionCategoryPlayers2/26/2016 2:15:00 PM Chris Byers - Golf Writer CSQ Magazine Media 213