Loading...
03 September 2014 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2013 – September 2014 TABLE OF CONTENTS Summary Operating Income Expense 1 Statement of Fee Revenue 2 Variance Report 3 Course Maintenance Expense Statement 4 Outside Service Expense Statement 6 Clubhouse Expense Statement 7 Marketing Expense Statement 8 General & Administrative Expense Statement 9 Operating Leases & Miscellaneous Expense Statement 10 Complimentary Report 11 Annual BudgetAccount Description September Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue37,014.55 36,219.00 795.55 2.2% 89,943.80 83,359.00 6,584.80 3,043,760.00 2,953,816.20 3%401000 Miscellaneous Golf Revenue6,625.00 6,930.00 (305.00) -4.4% 16,566.90 19,530.00 (2,963.10) 430,315.00 413,748.10 4%410000 Revenue-Golf Shop5,100.39 4,371.00 729.39 16.7% 12,948.27 9,706.00 3,242.27 258,680.00 245,731.73 5%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 Income1.98 - 1.98 0.0%4.89 - 4.89 - (4.89) 0%Total Income49,241.92 48,020.00 1,221.92 2.5% 120,963.86 114,095.00 6,868.86 3,744,755.00 3,623,791.14 3%Cost of Goods Sold510000 COS-Golf Shop2,666.23 2,446.18 220.05 -9.0% 7,151.24 5,432.48 (1,718.76) 144,783.40 137,632.16 5%Total COS2,666.23 2,446.18 220.05 -9.0% 7,151.24 5,432.48 (1,718.76) 144,783.40 137,632.16 5%Gross Profit46,575.69 45,573.82 1,001.87 2.2% 113,812.62 108,662.52 5,150.10 3,599,971.60 3,486,158.98 3%Expenses610000 Golf Pro Shop 11,980.66 13,897.00 1,916.34 13.8% 33,445.38 41,777.00 8,331.62 204,190.00 170,744.62 16%630000 Course Maintenance133,540.94 142,774.00 9,233.06 6.5% 359,050.86 390,060.00 (31,009.14) 1,697,652.00 1,338,601.14 21%633000 Maintenance Water & Energy20,360.10 19,975.00 (385.10) -1.9% 52,015.46 65,560.00 (13,544.54) 223,629.00 171,613.54 23%640000 Outside Services11,866.07 15,213.00 3,346.93 22.0% 34,235.73 43,830.00 (9,594.27) 285,234.00 250,998.27 12%650000 Clubhouse11,012.73 10,636.00 (376.73) -3.5% 28,307.82 31,908.00 (3,600.18) 131,732.00 103,424.18 21%660000 Marketing23,954.92 21,166.00 (2,788.92) -13.2% 42,147.15 38,194.00 3,953.15 239,875.00 197,727.85 18%670000 General & Administrative24,698.65 24,932.00 233.35 0.9% 70,943.89 74,747.00 (3,803.11) 320,052.00 249,108.11 22%680000 Leases16,580.13 16,500.00 (80.13) -0.5% 45,179.41 49,500.00 (4,320.59) 246,850.00 201,670.59 18%690000 Miscellaneous Other Expense12,711.96 10,924.00 1,787.96 -16.4% 40,755.51 37,466.00 3,289.51 198,074.00 157,318.49 21%Total Expenses266,706.16 276,017.00 12,886.76 3.4% 706,081.21 773,042.00 66,960.79 3,547,288.00 2,841,206.79 20%(220,130.47) (230,443.18) 10,312.71 4.5%(592,268.59) (664,379.48) 72,110.89 52,683.60 644,952.19 0%Rounds of Golf PlayedPaid Rounds Played1,422 950 472 49.7%3,668 2,550 1,118 41,100 37,432 9%Ave $ Per Paid Round Green Fee26.03 38.13 (12.10) -31.7%24.52 32.69 (8.17) 74.06 49.54 33%Ave $ Per Paid Round Merchandise3.59 4.60 (1.01) -22.0%3.53 3.81 (0.28) 6.29 2.76 56%Ave $ Per Paid Miscellaneous 4.66 7.29 (2.64) -36.1%4.52 7.66 (3.14) 10.47 5.95 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateSeptember 20141 ExpensesActual BudgetVariance$11,980.66 $13,897.00(1,916.34)Favorable: Due to reduced salaries and benefits in an effort to reduce payroll while only having 9 holes open. Actual BudgetVariance$133,540.94 $142,774.00(9,233.06)Favorable: Due to reduced salaries and benefits, tree trimming was expensed in August.Actual BudgetVariance11,866.07 15,213.00 (3,346.93)Favorable: Due to reduced salaries and benefits in an effort to reduce payroll while only having 9 holes open. Actual BudgetVariance$23,954.92 $21,166.002,788.92Unfavorable: Due to timing of advertising invoices and a prepaid online marketing invoice. Actual BudgetVariance$12,711.96 $10,924.001,787.96Favorable: Annual property tax paid on golf cart fleet which was budgeted to be paid for in October 2014.provided for those cost of sales percentage that are greater than 5%.Variance ExplanationSeptember 2014The 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 ExpensesGolf ShopCartbarn-Course ServicesMaintenance10-20-142 Income September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees37,014.55 36,219.00 795.55 89,943.80 83,359.00 6,584.80 3,043,760.00 2,953,816.20 97.0%4010000 Rider Fee240.00 95.00 145.00 435.00 255.00 180.00 7,230.00 6,795.00 94.0%4040000 Club Rental445.00 475.00 (30.00) 1,105.00 1,275.00 (170.00) 20,550.00 19,445.00 94.6%4050000 Driving Range2,640.00 950.00 1,690.00 6,855.00 2,150.00 4,705.00 86,435.00 79,580.00 92.1%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 - - - 791.90 1,000.00 (208.10) 4,000.00 3,208.10 80.2%4091000 Golf Professional Rental Fee - - - - - - 37,000.00 37,000.00 100.0%4092000 Golf Lessons - - - - - - - - 0.0%4093000 Resident Card Issue3,300.00 5,310.00 (2,010.00) 7,380.00 14,550.00 (7,170.00) 135,000.00 127,620.00 94.5% Total Revenue Fees43,639.55 43,149.00 490.55 106,510.70 102,889.00 3,621.70 3,339,075.00 3,232,564.30 96.8%43,639.55 43,149.00 490.55 106,510.70 102,889.00 3,621.70 3,339,075.00 3,232,564.30 96.8%SilverRock ResortStatement of Fees RevenueSeptember 2014Total IncomeMonth to DateYear to DateAnnual Budget3 Income September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 428.77 - 428.77 1,011.33 - 1,011.33 00 0%4100110 Sales Hard Goods1,680.76 1,530.00 150.76 5,048.87 3,397.00 1,651.87 90,538.00 85,489.13 94.4%4100112 Sales-Soft Goods4,110.00 2,841.00 1,269.00 8,990.00 6,309.00 2,681.00 168,142.00 159,152.00 94.7%5100639 GS-Discounts-Mdse (1,119.14) - (1,119.14) (2,101.93) - (2,101.93) - 2,101.93 0.0% Total Revenue Golf Shop5,100.39 4,371.00 729.39 12,948.27 9,706.00 3,242.27 258,680.00 246,743.06 95.4%COS 5100150 COS-GS-Hard Goods 1,013.55 887.40 126.15 3,560.89 1,970.26 1,590.63 52,512.04 48,951.15 93.2%5100151 COS-GS-Soft Goods 1,602.38 1,647.78 (45.40) 3,459.12 3,659.22 (200.10) 97,522.36 94,063.24 96.5%5100152 COS-GS-Purchase Disc - (127.00) 127.00 - (282.00) 282.00 (7,502.00) (7,502.00) 100.0%5100220 COS-GS-Freight Merch 50.30 38.00 12.30 131.23 85.00 46.23 2,251.00 2,119.77 94.2%Cost of Sales - Golf Shop2,666.23 2,446.18 220.05 7,151.24 5,432.48 1,718.76 144,783.40 137,632.16 95.1%Gross Profit2,434.16 1,924.82 509.34 5,797.03 4,273.52 1,523.51 113,896.60 109,110.90 95.8%COS %52.3% 56.0% 3.7% 55.2% 56.0% 0.7% 53.1% 55.8% 105.1%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group1,625.74 2,046.00 (420.26) 4,375.80 6,138.00 (1,762.20) 27,621.00 23,245.20 84.2%6101325 Insurance-Workers Comp 314.99 345.00 (30.01) 944.97 1,037.00 (92.03) 5,062.00 4,117.03 81.3%6101720 Salaries3,839.44 3,750.00 89.44 10,930.32 11,250.00 (319.68) 45,000.00 34,069.68 75.7%6101800 Taxes-Employer Payroll 600.03 1,196.00 (595.97) 2,616.06 3,598.00 (981.94) 17,562.00 14,945.94 85.1%6101880 Wages-Hourly3,576.50 5,450.00 (1,873.50) 12,222.05 16,424.00 (4,201.95) 90,070.00 77,847.95 86.4%6101882 Wages-Overtime52.98 - 52.98 73.61 - 73.61 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 10,009.68 12,787.00 (2,777.32) 31,162.81 38,447.00 (7,284.19) 185,315.00 155,178.68 83.7%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office314.80 250.00 64.80 314.80 750.00 (435.20) 3,000.00 2,685.20 89.5%6109220 Freight & Delivery- - - - - - 75.00 75.00 100.0%6109490 Miscellaneous950.00 500.00 450.00 950.00 1,500.00 (550.00) 6,000.00 5,050.00 84.2%6109150 Dues and Subscriptions- - - - - - 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short9.10 - 9.10 (2.73) - (2.73) - 2.73 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 Uniforms618.03 100.00 518.03 775.45 300.00 475.45 2,400.00 1,624.55 67.7%6117840 Telephones79.05 110.00 (30.95) 245.05 330.00 (84.95) 1,320.00 1,074.95 81.4%training expenses for the month and miscell1,970.98 1,110.00 860.98 2,282.57 3,330.00 (1,047.43) 18,875.00 16,592.43 87.9%11,980.66 13,897.00 (1,916.34) 33,445.38 41,777.00 (8,331.62) 204,190.00 171,771.11 84.1%SilverRock ResortGolf Shop Income StatementSeptember 2014Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group7,360.79 8,990.00 (1,629.21) 25,759.69 26,970.00 (1,210.31) 107,880.00 82,120.31 76.1%6311325 Insurance-Workers Comp2,742.65 1,825.00 917.65 8,227.95 5,475.00 2,752.95 24,794.00 16,566.05 66.8%6311720 Salaries10,620.80 11,001.60 (380.80) 31,862.40 33,004.80 (1,142.40) 132,019.20 100,156.80 75.9%6311800 Taxes-Employer Payroll5,944.42 6,327.00 (382.58) 14,376.10 18,981.00 (4,604.90) 86,638.00 72,261.90 83.4%6311880 Wages-Hourly36,362.90 37,670.40 (1,307.50) 110,413.39 113,011.20 (2,597.81) 518,478.80 408,065.41 78.7%6311882 Wages-Overtime- - - - - - 15,945.00 15,945.00 100.0%Total-CM-SALARIES & BENEFITS 63,031.56 65,814.00 (2,782.44) 190,639.53 197,442.00 (2,714.29) 885,755.00 695,115.47 78.5%63-CM-SUPPLIES & MATERIALS6313734 Chemicals2,190.27 3,500.00 (1,309.73) 4,990.87 9,000.00 (4,009.13) 34,600.00 29,609.13 85.6%6313744 Fertilizer11,414.00 11,000.00 414.00 35,603.66 36,000.00 (396.34) 112,500.00 76,896.34 68.4%6313745 Herbicides6,778.80 7,000.00 (221.20) 6,778.80 7,000.00 (221.20) 17,000.00 10,221.20 60.1%6313746 Flowers/Plants45.06 1,000.00 (954.94) 45.06 1,000.00 (954.94) 3,050.00 3,004.94 98.5%6313748 Fuel-Gasoline5,982.02 5,100.00 882.02 13,189.33 15,500.00 (2,310.67) 55,020.00 41,830.67 76.0%6313750 Golf Course Accessories567.81 500.00 67.81 1,028.57 900.00 128.57 13,000.00 11,971.43 92.1%6313756 POA Control- - - 242.03 - 242.03 7,000.00 6,757.97 96.5%6313758 Miscellaneous Supp2,826.06 750.00 2,076.06 3,619.79 2,250.00 1,369.79 4,350.00 730.21 16.8%6313762 Supplies-Office- - - - - - - - 0.0%6313774 Sand4,480.70 5,000.00 (519.30) 4,480.70 5,780.00 (1,299.30) 13,460.00 8,979.30 66.7%6313776 Seed- 250.00 (250.00) - 950.00 (950.00) 125,900.00 125,900.00 100.0%6313778 Small Tools & Non-Capital Equip1,409.57 2,000.00 (590.43) 1,454.60 2,200.00 (745.40) 5,000.00 3,545.40 70.9%6313780 Sod1,941.40 2,000.00 (58.60) 4,314.48 5,500.00 (1,185.52) 10,450.00 6,135.52 58.7%6313782 Topdressing- - - 768.75 2,500.00 (1,731.25) 10,600.00 9,831.25 92.7%Total-CM-SUPPLIES & MATERIALS 37,635.69 38,100.00 (464.31) 76,516.64 88,580.00 (4,495.51) 411,930.00 335,413.36 81.4%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint2,830.00 2,600.00 230.00 8,490.00 7,800.00 690.00 31,200.00 22,710.00 72.8%6315685 CM-R&M-Bldngs & Othr Structures548.46 550.00 (1.54) 1,875.04 2,550.00 (674.96) 5,550.00 3,674.96 66.2%6315690 CM-R&M-Equipment2,921.06 2,000.00 921.06 10,184.13 6,500.00 3,684.13 40,000.00 29,815.87 74.5%6315692 CM-R&M-Irrigation System1,297.49 1,500.00 (202.51) 5,562.31 9,400.00 (3,837.69) 19,050.00 13,487.69 70.8%6315696 CM-R&M-Pumps- 1,000.00 (1,000.00) - 3,000.00 (3,000.00) 10,500.00 10,500.00 100.0%6315815 CM-R&M-Trees-Pruning Etc2,770.00 5,500.00 (2,730.00) 5,770.00 5,500.00 270.00 12,050.00 6,280.00 52.1%Total-CM-REPAIRS & MAINTENANCE 10,367.01 13,150.00 (2,782.99) 31,881.48 34,750.00 (2,868.52) 118,350.00 86,468.52 73.1%6317836 Utilities-Natural Gas/LPG19.51 15.00 4.51 62.18 45.00 17.18 180.00 117.82 0.0%6317840 Telephones1,485.75 850.00 635.75 3,101.29 2,550.00 551.29 10,200.00 7,098.71 69.6%Total-CM-UTILITIES1,505.26 865.00 640.26 3,163.47 2,595.00 568.47 10,380.00 7,216.53 69.5%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance500.00 500.00 - 1,500.00 1,500.00 - 6,000.00 4,500.00 75.0%6319100 Contract Svcs-Soil/Tissue Test2,000.00 2,000.00 - 2,000.00 2,000.00 - 4,000.00 2,000.00 50.0%6319102 Contract Svcs-Trash Removal752.46 524.00 228.46 1,504.92 1,572.00 (67.08) 6,288.00 4,783.08 76.1%6319150 Dues & Subscriptions270.00 - 270.00 270.00 - 270.00 540.00 270.00 50.0%6319170 Employee Education69.00 50.00 19.00 69.00 150.00 (81.00) 1,550.00 1,481.00 95.5%6319197 Equipment Rental- 150.00 (150.00) - 500.00 (500.00) 3,400.00 3,400.00 100.0%6319206 Licenses & Permits217.86 80.00 137.86 227.86 280.00 (52.14) 4,180.00 3,952.14 94.5%6319490 Miscellaneous116.28 100.00 16.28 235.80 300.00 (64.20) 1,200.00 964.20 80.4%6319718 Safety Equipment & Training974.48 750.00 224.48 1,109.43 1,050.00 59.43 3,850.00 2,740.57 71.2%6319822 Uniforms587.63 920.00 (332.37) 1,919.17 2,760.00 (840.83) 11,040.00 9,120.83 82.6%Total-CM-OTHER EXPENSES 5,487.71 5,074.00 413.71 8,836.18 10,112.00 (1,275.82) 42,048.00 33,211.82 79.0%SilverRock ResortCourse Maintenance Expense StatementSeptember 2014Annual BudgetMonth to DateYear to Date5 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,868.05 2,728.00 (859.95) 5,604.15 8,184.00 (2,579.85) 32,736.00 27,131.85 82.9%6321325 Insurance-Workers Comp402.41 507.00 (104.59) 1,207.23 1,473.00 (265.77) 5,953.00 4,745.77 79.7%6321800 Taxes-Employer Payroll1,057.49 1,800.00 (742.51) 4,651.36 5,148.00 (496.64) 20,906.00 16,254.64 77.8%6321880 Wages-Hourly12,061.60 12,880.00 (818.40) 37,013.94 38,640.00 (1,626.06) 154,560.00 117,546.06 76.1%6321882 Wages-Overtime- 966.00 (966.00) 8.06 966.00 (957.94) 6,279.00 6,270.94 99.9%Total-CM-LM-SALARIES & BENEFITS15,389.55 18,881.00 (3,491.45) 48,484.74 54,411.00 (5,926.26) 220,434.00 171,949.26 78.0%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 100.00 (100.00) - 300.00 (300.00) 1,025.00 1,025.00 100.0%6323788 Uniforms124.16 290.00 (165.84) 404.52 870.00 (465.48) 3,480.00 3,075.48 88.4%Total-CM-LM-SUPPLIES & MATERIALS124.16 390.00 (265.84) 93.12 1,170.00 (1,076.88) 4,505.00 4,100.48 91.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%133,540.94 142,774.00 (9,233.06) 359,050.86 390,060.00 (31,009.14) 1,697,652.00 1,338,289.74 78.8% September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 14,589.26 13,815.00 774.26 39,552.54 46,200.00 (6,647.46) 178,291.00 138,738.46 77.8%6337842 Utilities-Water5,770.84 6,160.00 (389.16) 12,462.92 19,360.00 (6,897.08) 45,338.00 32,875.08 72.5%20,360.10 19,975.00 385.10 52,015.46 65,560.00 (13,544.54) 223,629.00 171,613.54 76.7%Silverrock ResortCourse Maintenance Water & EnergySeptember 2014Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementSeptember 2014Silverrock ResortAnnual BudgetMonth to Date Year to Date6 September Final 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 Comp286.85 301.00 (14.15) 860.55 774.00 86.55 4,976.00 4,115.45 82.7%6411800 Taxes-Employer Payroll604.83 1,000.00 (395.17) 2,003.80 2,571.00 (567.20) 16,514.00 14,510.20 87.9%6411880 Wages-Hourly6,547.11 8,033.00 (1,485.89) 18,573.01 20,656.00 (2,082.99) 132,655.00 114,081.99 86.0%6411882 Wages-Overtime58.32 - 58.32 97.32 - 97.32 - (97.32) 0.0%Total-CBR-SALARIES & BENEFITS7,497.11 10,016.00 (2,518.89) 21,534.68 26,047.00 (4,512.32) 162,329.00 140,794.32 86.7%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - - - - - - 1,850.00 `0.0%6413742 Supplies-Expendable336.96 150.00 186.96 1,328.46 1,350.00 (21.54) 6,750.00 5,421.54 80.3%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-Towels320.00 120.00 200.00 960.00 360.00 600.00 2,182.00 1,222.00 56.0%6413796 Supplies-Bottled Water202.50 50.00 152.50 418.50 150.00 268.50 8,550.00 8,131.50 95.1%Total-CBR-SUPPLIES & MATERIALS859.46 445.00 414.46 2,706.96 2,035.00 671.96 32,277.00 27,720.04 85.9%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment - 300.00 (300.00) 104.21 900.00 (795.79) 3,600.00 3,495.79 97.1%6415695 CBR-R&M-Cart Maintenance & Repair - 500.00 (500.00) - 1,500.00 (1,500.00) 6,450.00 6,450.00 100.0%Total-CBR-REPAIRS & MAINTENANCE- 800.00 (800.00) 104.21 2,400.00 (2,295.79) 10,050.00 9,945.79 99.0%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 495.59 800.00 (304.41) 1,163.45 2,400.00 (1,236.55) 9,600.00 8,436.55 87.9%6419220 Freight/Delivery- 75.00 (75.00) - 225.00 (225.00) 450.00 450.00 100.0%6419490 Miscellaneous- 75.00 (75.00) - 275.00 (275.00) 1,150.00 1,150.00 100.0%6419820 Uniforms- - - - - - 5,200.00 5,200.00 100.0%Total-CBR-OTHER EXPENSES495.59 950.00 (701.89) 1,163.45 2,900.00 (1,736.55) 16,400.00 15,236.55 92.9%TOTAL-CARTS,BAGROOM & RANGE 9,217.87 11,277.00 (2,059.13) 25,509.30 33,382.00 (7,872.70) 221,056.00 193,696.70 87.6%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%training expen Insurance-Workers Comp133.75 119.00 14.75 401.25 317.00 84.25 1,933.00 1,531.75 79.2%6431800 Taxes-Employer Payroll234.45 413.00 (178.55) 818.18 1,099.00 (280.82) 6,703.00 5,884.82 87.8%6431880 Wages-Hourly2,280.00 3,179.00 (899.00) 7,507.00 8,457.00 (950.00) 51,567.00 44,060.00 85.4%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS2,648.20 3,711.00 (1,062.80) 8,726.43 9,873.00 (1,146.57) 60,203.00 51,476.57 85.5%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) - 200.00 (200.00) 1,050.00 1,050.00 100.0%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) - 225.00 (225.00) 2,125.00 2,125.00 100.0%Total-CS-OTHER EXPENSES- 225.00 (225.00) - 575.00 (575.00) 3,975.00 3,975.00 100.0%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementSeptember 2014Annual Budget7 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 450.00 400.00 50.00 1,585.00 1,200.00 385.00 4,800.00 3,215.00 67.0%Total-CH-SUPPLIES & MATERIALS450.00 400.00 50.00 396.50 1,200.00 (803.50) 4,800.00 3,215.00 67.0%65-CH-UTILITIES6507836 Utilities-Natural Gas285.85 300.00 (14.15) 925.78 900.00 25.78 3,600.00 2,674.22 74.3%6507840 Utilities-Telephone1,236.42 1,150.00 86.42 2,484.47 3,450.00 (965.53) 13,800.00 11,315.53 82.0%6507842 Utilities-Water663.02 321.00 342.02 1,059.20 963.00 96.20 3,852.00 2,792.80 72.5%6507844 Utilities-Cable 457.31 340.00 117.31 1,371.93 1,020.00 351.93 4,080.00 2,708.07 66.4%Total-CH-UTILITIES2,642.60 2,111.00 531.60 5,841.38 6,333.00 (491.62) 25,332.00 19,490.62 76.9%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 1,750.00 1,825.00 (75.00) 5,475.00 5,475.00 - 22,500.00 17,025.00 75.7%6509099 Contract Services-Security5,693.56 4,900.00 793.56 15,548.20 14,700.00 848.20 60,400.00 44,851.80 74.3%6509215 Flowers & Decorations- - - - - - 1,900.00 1,900.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 49.50 600.00 (550.50) 2,400.00 2,350.50 97.9%6509718 Safety Equipment & Training - 100.00 (100.00) - 300.00 (300.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES7,443.56 7,025.00 418.56 21,072.70 21,075.00 (2.30) 88,400.00 67,327.30 76.2%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures319.34 300.00 19.34 840.01 900.00 (59.99) 3,600.00 2,759.99 76.7%6515686 CH-R&M-Restaurant Repairs157.23 400.00 (242.77) 157.23 1,200.00 (1,042.77) 4,800.00 4,642.77 96.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 & MAINTENANCE476.57 1,100.00 (623.43) 997.24 3,300.00 (2,302.76) 13,200.00 12,202.76 92.4%11,012.73 10,636.00 376.73 28,307.82 31,908.00 (3,600.18) 131,732.00 24,405.52 18.5%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementSeptember 2014Annual Budget8 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 373.61 341.00 32.61 1,120.83 1,023.00 97.83 4,092.00 2,971.17 72.6%6601325 Insurance-Workers Comp101.49 94.00 7.49 304.47 282.00 22.47 1,128.00 823.53 73.0%6601720 Salaries2,085.22 2,508.00 (422.78) 6,032.08 7,524.00 (1,491.92) 30,096.00 24,063.92 80.0%6601800 Taxes-Employer Payroll181.45 326.00 (144.55) 502.90 978.00 (475.10) 3,912.00 3,409.10 87.1%Total-MKT-SALARIES & BENEFITS2,741.77 3,269.00 (527.23) 7,960.28 9,807.00 (1,846.72) 39,228.00 31,267.72 79.7%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 100.00 300.00 (200.00) 1,200.00 1,100.00 91.7%6603768 Supplies-Printing & Stationery 282.12 200.00 82.12 1,541.62 200.00 1,341.62 4,425.00 2,883.38 65.2%282.12 300.00 (17.88) 1,641.62 500.00 1,141.62 5,625.00 3,983.38 70.8%66-MKT-UTILITIES6607840 Utilities-Telephone 63.08 100.00 (36.92) 327.62 300.00 27.62 1,200.00 872.38 72.7%Total-MKT-UTILITIES63.08 100.00 (36.92) 327.62 300.00 27.62 1,200.00 872.38 72.7%66-MKT-OTHER EXPENSES6609010 Advertising 20,867.95 17,197.00 3,670.95 32,019.63 26,687.00 5,332.63 178,987.00 146,967.37 82.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 Page- 150.00 (150.00) 198.00 450.00 (252.00) 1,800.00 1,602.00 89.0%6609490 Miscellaneous- - - - - - 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6609630 Promotion- - - - - - 700.00 700.00 100.0%6609633 Promotion-Community- 75.00 (75.00) - 225.00 (225.00) 2,250.00 2,250.00 100.0%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 EXPENSES20,867.95 17,497.00 3,370.95 32,217.63 27,587.00 4,630.63 193,822.00 161,604.37 83.4%23,954.92 21,166.00 2,788.92 42,147.15 38,194.00 3,953.15 239,875.00 197,727.85 82.4%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementSeptember 2014Annual Budget9 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group 1,332.83 1,488.00 (155.17) 3,809.22 4,464.00 (654.78) 17,856.00 14,046.78 78.7%6701325 Insurance-Workers Comp 707.13 594.00 113.13 2,121.39 1,805.00 316.39 7,718.00 5,596.61 72.5%6701720 Salaries13,769.60 14,833.34 (1,063.74) 40,848.80 44,500.02 (3,651.22) 178,000.00 137,151.20 77.1%6701800 Taxes-Employer Payroll 1,198.97 2,060.00 (861.03) 3,590.64 6,258.00 (2,667.36) 26,748.00 23,157.36 86.6%6701880 Wages-Hourly1,638.80 1,016.66 622.14 5,163.68 3,649.98 1,513.70 27,800.00 22,636.32 81.4%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 18,647.33 19,992.00 (1,344.67) 55,533.73 60,677.00 (5,143.27) 258,122.00 202,588.27 78.5%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer2,000.25 500.00 1,500.25 3,909.02 1,500.00 2,409.02 6,300.00 2,390.98 38.0%6703762 Supplies-Office299.20 150.00 149.20 404.30 450.00 (45.70) 1,800.00 1,395.70 77.5%6703768 Supplies-Printing & Stationery 200.75 100.00 100.75 269.69 300.00 (30.31) 3,300.00 3,030.31 91.8%Total-G&A-SUPPLIES & MATERIALS 2,500.20 750.00 1,750.20 4,583.01 2,250.00 2,333.01 11,400.00 6,816.99 59.8%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipm- 100.00 (100.00) - 200.00 (200.00) 1,900.00 1,900.00 100.0%Total-G&A-REPAIRS & MAINTENANCE- 100.00 (100.00) - 200.00 (200.00) 1,900.00 1,900.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance 400.00 400.00 - 1,200.00 1,200.00 - 4,800.00 3,600.00 75.0%6709150 Dues & Subscriptions- 200.00 (200.00) - 250.00 (250.00) 1,700.00 1,700.00 100.0%6709180 Employee Recruiting/Relocatio- 200.00 (200.00) 234.57 200.00 34.57 1,400.00 1,165.43 83.2%6709197 Equipment Rental1,245.42 550.00 695.42 2,242.21 1,650.00 592.21 6,600.00 4,357.79 66.0%6709202 Fees-Bank120.24 90.00 30.24 545.61 270.00 275.61 1,080.00 534.39 49.5%6709208 Fees-Payroll Processing 1,034.96 1,200.00 (165.04) 3,038.93 3,600.00 (561.07) 14,400.00 11,361.07 78.9%6709220 Freight/Delivery- 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6709490 Miscellaneous- 100.00 (100.00) - 300.00 (300.00) 1,200.00 1,200.00 100.0%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services49.00 75.00 (26.00) 307.25 225.00 82.25 900.00 592.75 65.9%6709625 Professional Fees701.50 850.00 (148.50) 2,722.00 2,550.00 172.00 10,200.00 7,478.00 73.3%6709636 Promotion/Entertainment- 100.00 (100.00) - 300.00 (300.00) 1,200.00 1,200.00 100.0%6709722 Seminars & Training- 200.00 (200.00) 500.00 600.00 (100.00) 2,400.00 1,900.00 79.2%6709810 Travel- - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%training expe Uniforms- 75.00 900.00 36.58 225.00 (188.42) 1,050.00 1,013.42 96.5%Total-G&A-OTHER EXPENSES3,551.12 4,090.00 436.12 10,827.15 11,620.00 (792.85) 48,630.00 37,802.85 77.7%Month to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementSeptember 2014Annual Budget10 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts10,363.45 10,050.00 313.45 27,090.35 30,150.00 (3,059.65) 121,050.00 93,959.65 77.6%6800193 Equipment Leases-Maintenance48,400.00 48,400.00 100.0%6800194 Equipment Leases-Trailer505.50 600.00 (94.50) 1,821.72 1,800.00 21.72 7,200.00 5,378.28 74.7%6800196 Equipment Leases-GPS4,424.80 4,700.00 (275.20) 12,860.00 14,100.00 (1,240.00) 56,400.00 43,540.00 77.2%6800197 Equipment Leases-Others1,286.38 1,150.00 136.38 3,407.34 3,450.00 (42.66) 13,800.00 10,392.66 0.0%16,580.13 16,500.00 80.13 45,179.41 49,500.00 (4,320.59) 246,850.00 201,670.59 81.7%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,000.00 8,000.00 - 24,000.00 24,000.00 - 96,000.00 72,000.00 75.0%6900210 FF&E Reserve740.30 724.00 16.30 1,798.89 1,666.00 132.89 60,874.00 59,075.11 97.0%6900800 Personal Property Taxes3,971.66 - 3,971.66 9,449.03 5,200.00 4,249.03 14,800.00 5,350.97 36.2%6900323 Insurance-Commercial- 2,200.00 (2,200.00) 5,507.59 6,600.00 (1,092.41) 26,400.00 20,892.41 79.1%12,711.96 10,924.00 1,787.96 40,755.51 37,466.00 3,289.51 198,074.00 157,318.49 79.4%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementSeptember 2014Annual BudgetMonth to DateYear to Date11 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2014‐20152014 2014 2014 2014 2014 2014Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMediaSalesPromotionGolf IndustryVIPCelebrityPGA Comp989Charity/Gift Certificate4Rain/Wind Checks12Club Staff728360LQ HS Golf2101084105810002015 2015 2015 2015 2015 2015Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012