Loading...
05 November 2014 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2014 – November 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 November Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue336,672.48 320,908.00 15,764.48 4.9% 437,989.28 407,967.00 30,022.28 3,043,760.00 2,605,770.72 14%401000 Miscellaneous Golf Revenue57,010.00 35,935.00 21,075.00 58.6% 81,906.90 68,035.00 13,871.90 430,315.00 348,408.10 19%410000 Revenue-Golf Shop26,496.15 30,225.00 (3,728.85) -12.3% 40,904.46 40,431.00 473.46 258,680.00 217,775.54 16%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 Income1.19 - 1.19 0.0%7.54 - 7.54 - (7.54) 0%Total Income421,679.82 388,568.00 33,111.82 8.5% 565,308.18 520,933.00 44,375.18 3,744,755.00 3,179,446.82 15%Cost of Goods Sold510000 COS-Golf Shop15,414.38 16,916.50 (1,502.12) 8.9% 23,344.80 22,627.98 (716.82) 144,783.40 121,438.60 16%Total COS15,414.38 16,916.50 (1,502.12) 8.9% 23,344.80 22,627.98 (716.82) 144,783.40 121,438.60 16%Gross Profit406,265.44 371,651.50 34,613.94 9.3% 541,963.38 498,305.02 43,658.36 3,599,971.60 3,058,008.22 15%Expenses610000 Golf Pro Shop 15,413.16 18,467.00 3,053.84 16.5% 65,881.85 72,548.00 6,666.15 204,190.00 138,308.15 32%630000 Course Maintenance150,891.63 166,048.00 15,156.37 9.1% 791,441.09 836,104.00 (44,662.91) 1,697,652.00 906,210.91 47%633000 Maintenance Water & Energy14,088.72 13,905.00 (183.72) -1.3% 82,030.23 95,815.00 (13,784.77) 223,629.00 141,598.77 37%640000 Outside Services35,022.00 33,367.00 (1,655.00) -5.0% 80,474.40 92,888.00 (12,413.60) 285,234.00 204,759.60 28%650000 Clubhouse10,641.06 10,636.00 (5.06) 0.0% 50,903.61 54,280.00 (3,376.39) 131,732.00 80,828.39 39%660000 Marketing23,477.36 31,974.00 8,496.64 26.6% 90,423.44 91,609.00 (1,185.56) 239,875.00 149,451.56 38%670000 General & Administrative23,937.96 27,759.00 3,821.04 13.8% 122,525.87 128,064.00 (5,538.13) 320,052.00 197,526.13 38%680000 Leases22,790.16 22,550.00 (240.16) -1.1% 90,185.49 89,000.00 1,185.49 246,850.00 156,664.51 37%690000 Miscellaneous Other Expense26,516.16 16,618.00 9,898.16 -59.6% 78,141.30 73,958.00 4,183.30 198,074.00 119,932.70 39%Total Expenses322,778.21 341,324.00 (18,545.79) 5.4% 1,452,007.28 1,534,266.00 82,258.72 3,547,288.00 2,095,280.72 41%83,487.23 30,327.50 53,159.73 175.3%(910,043.90) (1,035,960.98) 125,917.08 52,683.60 962,727.50 0%Rounds of Golf PlayedPaid Rounds Played4,693 4,650 43 0.9%8,816 7,300 1,516 41,100 32,284 21%Ave $ Per Paid Round Green Fee71.74 69.01 2.73 4.0%49.68 55.89 (6.20) 74.06 24.38 67%Ave $ Per Paid Round Merchandise5.65 6.50 (0.85) -13.1%4.64 5.54 (0.90) 6.29 1.65 74%Ave $ Per Paid Miscellaneous 12.15 7.73 4.42 57.2%9.29 9.32 (0.03) 10.47 1.18 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateNovember 20141 Sales and Cost of SalesActualBudgetVariance$57,010.00$35,935.0021,075.00Favorable: Due to increased revenue for resident cards issuance. Previous two months were down due to golf course being limited to 9-holes. *ActualBudgetVariance$26,496.15$30,225.00(3,728.85)Unfavorable: Retail sales continue to be down, however, we did have some improvement but most of it was on all discounted inventory.ExpensesActualBudgetVariance$15,413.16$18,467.00(3,053.84)Favorable: Due to reduced salaries and benefits; 2 budgeted full time hourly employees were not utilized in November. Hours were picked up by salaried employees. ActualBudgetVariance$23,477.36$31,974.00(8,496.64)Favorable: Due to timing of invoices for advertising. We are currently tracking even on year to date budget.ActualBudgetVariance$23,937.96$27,759.00(3,821.04)Favorable: Due to reduced salaries and benefits and repair and maintenance equipment not utilized.ActualBudgetVariance$26,516.16$16,618.009,898.16Unfavorable: Due to timing of commercial insurance expense. Variance ExplanationNovember 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 areprovided for those cost of sales percentage that are greater than 5%.Misc Golf RevenuePro Shop Merchandise SalesGolf ShopGeneral and AdministrativeMiscellaneous Other ExpensesMarketing2 Income November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees336,672.48 320,908.00 15,764.48 437,989.28 407,967.00 30,022.28 3,043,760.00 2,605,770.72 85.6%4010000 Rider Fee1,100.00 465.00 635.00 1,565.00 730.00 835.00 7,230.00 5,665.00 78.4%4040000 Club Rental2,640.00 2,325.00 315.00 3,820.00 3,650.00 170.00 20,550.00 16,730.00 81.4%4050000 Driving Range12,960.00 8,835.00 4,125.00 20,525.00 11,085.00 9,440.00 86,435.00 65,910.00 76.3%4060000 Handicap Fees- - - - - - 2,500.00 2,500.00 100.0%4080000 GPS Advertising- 500.00 (500.00) - 900.00 (900.00) 2,600.00 2,600.00 100.0%4090000 Ball Retriever/Subcontract- - - 791.90 2,000.00 (1,208.10) 4,000.00 3,208.10 80.2%4091000 Golf Professional Rental Fee 5,750.00 5,000.00 750.00 5,750.00 5,000.00 750.00 37,000.00 31,250.00 84.5%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue34,560.00 18,810.00 15,750.00 49,455.00 44,670.00 4,785.00 135,000.00 85,545.00 63.4% Total Revenue Fees393,682.48 356,843.00 36,839.48 519,896.18 476,002.00 43,894.18 3,339,075.00 2,819,178.82 84.4%393,682.48 356,843.00 36,839.48 519,896.18 476,002.00 43,894.18 3,339,075.00 2,819,178.82 84.4%SilverRock ResortStatement of Fees RevenueNovember 2014Total IncomeMonth to DateYear to DateAnnual Budget3 Income November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 505.00 - 505.00 1,627.51 - 1,627.51 00 0%4100110 Sales Hard Goods8,961.00 10,579.00 (1,618.00) 14,631.57 14,151.00 480.57 90,538.00 75,906.43 83.8%4100112 Sales-Soft Goods 21,240.50 19,646.00 1,594.50 31,273.00 26,280.00 4,993.00 168,142.00 136,869.00 81.4%5100639 GS-Discounts-Mdse (4,210.35) - (4,210.35) (6,627.62) - (6,627.62) - 6,627.62 0.0% Total Revenue Golf Shop26,496.15 30,225.00 (3,728.85) 40,904.46 40,431.00 473.46 258,680.00 219,403.05 84.8%COS 5100150 COS-GS-Hard Goods 6,377.74 6,135.82 241.92 10,348.22 8,207.58 2,140.64 52,512.04 42,163.82 80.3%5100151 COS-GS-Soft Goods 8,351.31 11,394.68 (3,043.37) 12,252.52 15,242.40 (2,989.88) 97,522.36 85,269.84 87.4%5100152 COS-GS-Purchase Disc - (877.00) 877.00 (160.41) (1,174.00) 1,013.59 (7,502.00) (7,341.59) 97.9%5100220 COS-GS-Freight Merch 685.33 263.00 422.33 904.47 352.00 552.47 2,251.00 1,346.53 59.8%Cost of Sales - Golf Shop15,414.38 16,916.50 (1,502.12) 23,344.80 22,627.98 716.82 144,783.40 121,438.60 83.9%Gross Profit11,081.77 13,308.50 (2,226.73) 17,559.66 17,803.02 (243.36) 113,896.60 97,964.45 86.0%COS % 58.2% 56.0% -2.2% 57.1% 56.0% -1.1% 53.1% 55.3% 104.3%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group3,281.56 2,387.00 894.56 9,283.10 10,912.00 (1,628.90) 27,621.00 18,337.90 66.4%6101325 Insurance-Workers Comp 314.99 478.00 (163.01) 1,574.95 1,786.00 (211.05) 5,062.00 3,487.05 68.9%6101720 Salaries3,782.72 3,750.00 32.72 20,509.92 18,750.00 1,759.92 45,000.00 24,490.08 54.4%6101800 Taxes-Employer Payroll 737.93 1,659.00 (921.07) 3,851.59 6,196.00 (2,344.41) 17,562.00 13,710.41 78.1%6101880 Wages-Hourly6,489.20 9,008.00 (2,518.80) 24,454.94 28,904.00 (4,449.06) 90,070.00 65,615.06 72.8%6101882 Wages-Overtime12.76 - 12.76 86.37 - 86.37 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 14,619.16 17,282.00 (2,662.84) 59,760.87 66,548.00 (6,787.13) 185,315.00 126,593.38 68.3%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office169.21 250.00 (80.79) 484.01 1,250.00 (765.99) 3,000.00 2,515.99 83.9%6109220 Freight & Delivery- 25.00 (25.00) 610.00 50.00 560.00 75.00 (535.00) -713.3%6109490 Miscellaneous- 500.00 (500.00) 2,450.00 2,500.00 (50.00) 6,000.00 3,550.00 59.2%6109150 Dues and Subscriptions- - - - - - 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short28.86 - 28.86 26.12 - 26.12 - (26.12) 0.0%6109722 Seminars/Training340.00 - 340.00 407.20 950.00 (542.80) 3,690.00 3,282.80 89.0%6109810 Travel - Merchandise- - - - - - 90.00 90.00 100.0%6109820 Uniforms255.93 300.00 (44.07) 1,819.84 700.00 1,119.84 2,400.00 580.16 24.2%6117840 Telephones- 110.00 (110.00) 323.81 550.00 (226.19) 1,320.00 996.19 75.5%training expenses for the month and miscel 794.00 1,185.00 (391.00) 6,120.98 6,000.00 120.98 18,875.00 12,754.02 67.6%15,413.16 18,467.00 (3,053.84) 65,881.85 72,548.00 (6,666.15) 204,190.00 139,347.40 68.2%Net Income(4,331.39) (5,158.50) 827.11 (48,322.19) (54,744.98) 6,422.79 (90,293.40) (41,382.95) 45.8%SilverRock ResortGolf Shop Income StatementNovember 2014Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group9,996.14 8,990.00 1,006.14 43,116.62 44,950.00 (1,833.38) 107,880.00 64,763.38 60.0%6311325 Insurance-Workers Comp2,742.65 2,065.00 677.65 13,713.25 9,868.00 3,845.25 24,794.00 11,080.75 44.7%6311720 Salaries10,620.80 11,001.60 (380.80) 54,414.40 55,008.00 (593.60) 132,019.20 77,604.80 58.8%6311800 Taxes-Employer Payroll3,219.17 7,157.00 (3,937.83) 21,860.76 34,664.00 (12,803.24) 86,638.00 64,777.24 74.8%6311880 Wages-Hourly42,379.10 44,054.40 (1,675.30) 197,522.07 201,120.00 (3,597.93) 518,478.80 320,956.73 61.9%6311882 Wages-Overtime20.06 - 20.06 6,169.73 10,526.00 (4,356.27) 15,945.00 9,775.27 61.3%Total-CM-SALARIES & BENEFITS68,977.92 73,268.00 (4,290.08) 336,796.83 356,136.00 (19,339.17) 885,755.00 548,958.17 62.0%63-CM-SUPPLIES & MATERIALS6313734 Chemicals8,386.62 6,900.00 1,486.62 20,771.65 20,500.00 271.65 34,600.00 13,828.35 40.0%6313744 Fertilizer7,060.00 7,500.00 (440.00) 56,653.17 61,000.00 (4,346.83) 112,500.00 55,846.83 49.6%6313745 Herbicides9,708.33 5,000.00 4,708.33 18,394.62 12,000.00 6,394.62 17,000.00 (1,394.62) -8.2%6313746 Flowers/Plants- - - 45.06 1,250.00 (1,204.94) 3,050.00 3,004.94 98.5%6313748 Fuel-Gasoline2,732.53 5,500.00 (2,767.47) 24,081.41 29,000.00 (4,918.59) 55,020.00 30,938.59 56.2%6313750 Golf Course Accessories8,990.88 200.00 8,790.88 11,979.77 11,100.00 879.77 13,000.00 1,020.23 7.8%6313756 POA Control2,263.27 3,500.00 (1,236.73) 2,746.97 3,500.00 (753.03) 7,000.00 4,253.03 60.8%6313758 Miscellaneous Supp1,817.09 500.00 1,317.09 5,916.51 3,250.00 2,666.51 4,350.00 (1,566.51) -36.0%6313762 Supplies-Office- - - - - - - - 0.0%6313774 Sand- 4,000.00 (4,000.00) 5,000.00 11,780.00 (6,780.00) 13,460.00 8,460.00 62.9%6313776 Seed7,310.66 20,500.00 (13,189.34) 132,291.96 123,450.00 8,841.96 125,900.00 (6,391.96) -5.1%6313778 Small Tools & Non-Capital Equip 134.19 100.00 34.19 4,287.65 4,300.00 (12.35) 5,000.00 712.35 14.2%6313780 Sod- 3,250.00 (3,250.00) 4,473.08 9,000.00 (4,526.92) 10,450.00 5,976.92 57.2%6313782 Topdressing- 3,000.00 (3,000.00) 768.75 8,000.00 (7,231.25) 10,600.00 9,831.25 92.7%Total-CM-SUPPLIES & MATERIALS48,403.57 59,950.00 (11,546.43) 287,410.60 298,130.00 (10,719.40) 411,930.00 124,519.40 30.2%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,400.00 2,600.00 (200.00) 13,720.00 13,000.00 720.00 31,200.00 17,480.00 56.0%6315685 CM-R&M-Bldngs & Othr Structures 98.27 500.00 (401.73) 2,071.58 3,550.00 (1,478.42) 5,550.00 3,478.42 62.7%6315690 CM-R&M-Equipment5,531.29 4,000.00 1,531.29 24,271.51 21,500.00 2,771.51 40,000.00 15,728.49 39.3%6315692 CM-R&M-Irrigation System550.38 900.00 (349.62) 8,073.39 12,300.00 (4,226.61) 19,050.00 10,976.61 57.6%6315696 CM-R&M-Pumps1,921.42 1,000.00 921.42 4,934.42 5,000.00 (65.58) 10,500.00 5,565.58 53.0%6315815 CM-R&M-Trees-Pruning Etc- - - 5,770.00 6,050.00 (280.00) 12,050.00 6,280.00 52.1%Total-CM-REPAIRS & MAINTENANCE10,501.36 9,000.00 1,501.36 58,840.90 61,400.00 (2,559.10) 118,350.00 59,509.10 50.3%6317836 Utilities-Natural Gas/LPG19.82 15.00 4.82 103.87 75.00 28.87 180.00 76.13 0.0%6317840 Telephones620.83 850.00 (229.17) 4,680.33 4,250.00 430.33 10,200.00 5,519.67 54.1%Total-CM-UTILITIES640.65 865.00 (224.35) 4,784.20 4,325.00 459.20 10,380.00 5,595.80 53.9%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance500.00 500.00 - 2,500.00 2,500.00 - 6,000.00 3,500.00 58.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 Removal 1,504.92 524.00 980.92 3,762.30 2,620.00 1,142.30 6,288.00 2,525.70 40.2%6319150 Dues & Subscriptions85.00 - 85.00 642.20 - 642.20 540.00 (102.20) -18.9%6319170 Employee Education- 50.00 (50.00) 69.00 250.00 (181.00) 1,550.00 1,481.00 95.5%6319197 Equipment Rental- 600.00 (600.00) 732.57 2,100.00 (1,367.43) 3,400.00 2,667.43 78.5%6319206 Licenses & Permits165.00 - 165.00 487.86 280.00 207.86 4,180.00 3,692.14 88.3%6319490 Miscellaneous89.81 100.00 (10.19) 325.61 500.00 (174.39) 1,200.00 874.39 72.9%6319718 Safety Equipment & Training481.55 500.00 (18.45) 2,134.08 2,350.00 (215.92) 3,850.00 1,715.92 44.6%6319822 Uniforms1,451.62 920.00 531.62 4,171.34 4,600.00 (428.66) 11,040.00 6,868.66 62.2%Total-CM-OTHER EXPENSES4,277.90 3,194.00 1,083.90 16,824.96 17,200.00 (375.04) 42,048.00 25,223.04 60.0%Month to DateYear to DateSilverRock ResortCourse Maintenance Expense StatementNovember 2014Annual Budget5 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 3,758.35 2,728.00 1,030.35 11,230.55 13,640.00 (2,409.45) 32,736.00 21,505.45 65.7%6321325 Insurance-Workers Comp503.90 507.00 (3.10) 2,113.54 2,548.00 (434.46) 5,953.00 3,839.46 64.5%6321800 Taxes-Employer Payroll989.68 1,800.00 (810.32) 7,235.75 9,062.00 (1,826.25) 20,906.00 13,670.25 65.4%6321880 Wages-Hourly12,426.67 12,880.00 (453.33) 62,185.61 64,400.00 (2,214.39) 154,560.00 92,374.39 59.8%6321882 Wages-Overtime- 966.00 (966.00) 2,609.09 5,313.00 (2,703.91) 6,279.00 3,669.91 58.4%Total-CM-LM-SALARIES & BENEFITS17,678.60 18,881.00 (1,202.40) 85,374.54 94,963.00 (9,588.46) 220,434.00 135,059.46 61.3%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 100.00 (100.00) - 500.00 (500.00) 1,025.00 1,025.00 100.0%6323788 Uniforms411.63 290.00 121.63 992.76 1,450.00 (457.24) 3,480.00 2,487.24 71.5%Total-CM-LM-SUPPLIES & MATERIALS411.63 390.00 21.63 992.76 1,950.00 (957.24) 4,505.00 3,512.24 78.0%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 500.00 (500.00) 416.30 2,000.00 (1,583.70) 4,250.00 3,833.70 90.2%Total-CM-LM-REPAIRS & MAINTENANCE- 500.00 (500.00) 416.30 2,000.00 (1,583.70) 4,250.00 3,833.70 90.2%150,891.63 166,048.00 (15,156.37) 791,441.09 836,104.00 (44,662.91) 1,697,652.00 906,210.91 53.4% November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 9,400.43 10,650.00 (1,249.57) 59,859.81 69,000.00 (9,140.19) 178,291.00 118,431.19 66.4%6337842 Utilities-Water4,688.29 3,255.00 1,433.29 22,170.42 26,815.00 (4,644.58) 45,338.00 23,167.58 51.1%14,088.72 13,905.00 183.72 82,030.23 95,815.00 (13,784.77) 223,629.00 141,598.77 63.3%Total-COURSE MAINTENANCECourse Maintenance Expense StatementNovember 2014Silverrock ResortAnnual BudgetMonth to Date Year to DateSilverrock ResortCourse Maintenance Water & EnergyNovember 2014Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual Budget6 November Final 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 Comp286.85 412.00 (125.15) 1,434.25 1,414.00 20.25 4,976.00 3,541.75 71.2%6411800 Taxes-Employer Payroll1,064.49 1,367.00 (302.51) 3,783.48 4,694.00 (910.52) 16,514.00 12,730.52 77.1%6411880 Wages-Hourly9,344.71 10,980.00 (1,635.29) 34,783.73 37,705.00 (2,921.27) 132,655.00 97,871.27 73.8%6411882 Wages-Overtime 197.64 - 197.64 345.03 - 345.03 - (345.03) 0.0%Total-CBR-SALARIES & BENEFITS10,893.69 13,441.00 (2,547.31) 40,346.49 47,223.00 (6,876.51) 162,329.00 121,982.51 75.1%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- 500.00 (500.00) - 1,000.00 (1,000.00) 1,850.00 `0.0%6413742 Supplies-Expendable431.46 1,800.00 (1,368.54) 2,173.56 3,300.00 (1,126.44) 6,750.00 4,576.44 67.8%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,200.00 9,000.00 1,200.00 10,200.00 9,000.00 1,200.00 9,000.00 (1,200.00) -13.3%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-Towels 160.00 185.00 (25.00) 1,120.00 665.00 455.00 2,182.00 1,062.00 48.7%6413796 Supplies-Bottled Water108.00 50.00 58.00 742.50 250.00 492.50 8,550.00 7,807.50 91.3%Total-CBR-SUPPLIES & MATERIALS10,899.46 11,885.00 (985.54) 14,236.06 14,890.00 (653.94) 32,277.00 16,190.94 50.2%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment838.14 300.00 538.14 1,026.59 1,500.00 (473.41) 3,600.00 2,573.41 71.5%6415695 CBR-R&M-Cart Maintenance & Repair 5,951.20 500.00 5,451.20 5,951.20 2,950.00 3,001.20 6,450.00 498.80 7.7%Total-CBR-REPAIRS & MAINTENANCE6,789.34 800.00 5,989.34 6,977.79 4,450.00 2,527.79 10,050.00 3,072.21 30.6%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen158.12 800.00 (641.88) 1,321.57 4,000.00 (2,678.43) 9,600.00 8,278.43 86.2%6419220 Freight/Delivery- 75.00 (75.00) - 375.00 (375.00) 450.00 450.00 100.0%6419490 Miscellaneous116.31 75.00 41.31 116.31 425.00 (308.69) 1,150.00 1,033.69 89.9%6419820 Uniforms 1,982.12 500.00 1,482.12 2,589.41 2,500.00 89.41 5,200.00 2,610.59 50.2%Total-CBR-OTHER EXPENSES2,256.55 1,450.00 806.55 4,027.29 7,300.00 (3,272.71) 16,400.00 12,372.71 75.4%TOTAL-CARTS,BAGROOM & RANGE30,839.04 27,576.00 806.55 65,587.63 73,863.00 (8,275.37) 221,056.00 153,618.37 69.5%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%training expe Insurance-Workers Comp133.75 177.00 (43.25) 668.75 551.00 117.75 1,933.00 1,264.25 65.4%6431800 Taxes-Employer Payroll460.86 614.00 (153.14) 1,406.30 1,912.00 (505.70) 6,703.00 5,296.70 79.0%6431880 Wages-Hourly3,462.00 4,725.00 (1,263.00) 12,026.50 14,712.00 (2,685.50) 51,567.00 39,540.50 76.7%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS4,056.61 5,516.00 (1,459.39) 14,101.55 17,175.00 (3,073.45) 60,203.00 46,101.45 76.6%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 100.00 (100.00) - 400.00 (400.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous19.74 50.00 (30.26) 19.74 100.00 (80.26) 200.00 180.26 90.1%6439718 Safety Equipment & Training- 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0%6439820 Uniforms 106.61 75.00 31.61 765.48 1,100.00 (334.52) 2,125.00 1,359.52 64.0%Total-CS-OTHER EXPENSES126.35 275.00 (148.65) 785.22 1,850.00 (1,064.78) 3,975.00 3,189.78 80.2%Total-COURSE SERVICES4,182.96 5,791.00 (1,608.04) 14,886.77 19,025.00 (4,138.23) 64,178.00 49,291.23 76.8%35,022.00 33,367.00 1,655.00 80,474.40 92,888.00 (12,413.60) 285,234.00 199,719.82 70.0%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementNovember 2014Annual Budget7 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 411.50 400.00 11.50 2,396.50 2,000.00 396.50 4,800.00 2,403.50 50.1%Total-CH-SUPPLIES & MATERIALS411.50 400.00 11.50 2,396.50 2,000.00 396.50 4,800.00 2,403.50 50.1%65-CH-UTILITIES6507836 Utilities-Natural Gas176.32 300.00 (123.68) 1,382.52 1,500.00 (117.48) 3,600.00 2,217.48 61.6%6507840 Utilities-Telephone1,174.47 1,150.00 24.47 4,868.98 5,750.00 (881.02) 13,800.00 8,931.02 64.7%6507842 Utilities-Water324.97 321.00 3.97 2,223.15 1,605.00 618.15 3,852.00 1,628.85 42.3%6507844 Utilities-Cable 457.31 340.00 117.31 2,286.55 1,700.00 586.55 4,080.00 1,793.45 44.0%Total-CH-UTILITIES2,133.07 2,111.00 22.07 10,761.20 10,555.00 206.20 25,332.00 14,570.80 57.5%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 2,345.00 1,825.00 520.00 9,856.50 9,725.00 131.50 22,500.00 12,643.50 56.2%6509099 Contract Services-Security5,094.72 4,900.00 194.72 25,719.96 24,500.00 1,219.96 60,400.00 34,680.04 57.4%6509215 Flowers & Decorations- - - - 500.00 (500.00) 1,900.00 1,900.00 100.0%6509490 Miscellaneous184.92 200.00 (15.08) 300.78 1,000.00 (699.22) 2,400.00 2,099.22 87.5%6509718 Safety Equipment & Training - 100.00 (100.00) - 500.00 (500.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES7,624.64 7,025.00 599.64 35,877.24 36,225.00 (347.76) 88,400.00 52,522.76 59.4%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures321.85 300.00 21.85 1,466.44 1,500.00 (33.56) 3,600.00 2,133.56 59.3%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 252.23 2,000.00 (1,747.77) 4,800.00 4,547.77 94.7%6515690 CH-R&M-Equipment Repair 150.00 400.00 (250.00) 150.00 2,000.00 (1,850.00) 4,800.00 4,650.00 96.9%Total-CH-REPAIRS & MAINTENANCE471.85 1,100.00 (628.15) 1,868.67 5,500.00 (3,631.33) 13,200.00 11,331.33 85.8%10,641.06 10,636.00 5.06 50,903.61 54,280.00 (3,376.39) 131,732.00 22,662.66 17.2%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementNovember 2014Annual Budget8 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group - 341.00 (341.00) 1,494.44 1,705.00 (210.56) 4,092.00 2,597.56 63.5%6601325 Insurance-Workers Comp- 94.00 (94.00) 405.96 470.00 (64.04) 1,128.00 722.04 64.0%6601720 Salaries2,511.50 2,508.00 3.50 11,797.03 12,540.00 (742.97) 30,096.00 18,298.97 60.8%6601800 Taxes-Employer Payroll223.65 326.00 (102.35) 822.39 1,630.00 (807.61) 3,912.00 3,089.61 79.0%Total-MKT-SALARIES & BENEFITS2,735.15 3,269.00 (533.85) 14,519.82 16,345.00 (1,825.18) 39,228.00 24,708.18 63.0%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 312.63 500.00 (187.37) 1,200.00 887.37 73.9%6603768 Supplies-Printing & Stationery 586.14 200.00 386.14 5,422.09 3,400.00 2,022.09 4,425.00 (997.09) -22.5%586.14 300.00 286.14 5,734.72 3,900.00 1,834.72 5,625.00 (109.72) -2.0%66-MKT-UTILITIES6607840 Utilities-Telephone63.08 100.00 (36.92) 448.78 500.00 (51.22) 1,200.00 751.22 62.6%Total-MKT-UTILITIES63.08 100.00 (36.92) 448.78 500.00 (51.22) 1,200.00 751.22 62.6%66-MKT-OTHER EXPENSES6609010 Advertising16,974.54 25,680.00 (8,705.46) 66,222.17 66,189.00 33.17 178,987.00 112,764.83 63.0%6609040 Business Meals- 25.00 (25.00) - 125.00 (125.00) 300.00 300.00 100.0%6609080 Collateral Material2,768.17 1,000.00 1,768.17 2,768.17 1,500.00 1,268.17 5,500.00 2,731.83 49.7%6609102 Contract Services-Web Page99.00 150.00 (51.00) 396.00 750.00 (354.00) 1,800.00 1,404.00 78.0%6609490 Miscellaneous- 50.00 (50.00) - 50.00 (50.00) 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0%6609630 Promotion- 50.00 (50.00) - 100.00 (100.00) 700.00 700.00 100.0%6609633 Promotion-Community- 750.00 (750.00) - 1,050.00 (1,050.00) 2,250.00 2,250.00 100.0%6609634 Promotion-Media/Vendor- 500.00 (500.00) - 500.00 (500.00) 2,000.00 2,000.00 100.0%6609150 Dues and Subscriptions114.05 - 114.05 196.55 - 196.55 735.00 538.45 73.3%6609820 Uniforms137.23 50.00 87.23 137.23 350.00 (212.77) 600.00 462.77 77.1%Total-MKT-OTHER EXPENSES20,092.99 28,305.00 (8,212.01) 69,720.12 70,864.00 (1,143.88) 193,822.00 124,101.88 64.0%23,477.36 31,974.00 (8,496.64) 90,423.44 91,609.00 (1,185.56) 239,875.00 149,451.56 62.3%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementNovember 2014Annual Budget9 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,587.76 1,488.00 99.76 6,729.81 7,440.00 (710.19) 17,856.00 11,126.19 62.3%6701325 Insurance-Workers Comp 707.13 662.00 45.13 3,535.65 3,084.00 451.65 7,718.00 4,182.35 54.2%6701720 Salaries14,822.83 14,833.34 (10.51) 70,558.99 74,166.70 (3,607.71) 178,000.00 107,441.01 60.4%6701800 Taxes-Employer Payroll 1,275.42 2,294.00 (1,018.58) 6,637.90 10,690.00 (4,052.10) 26,748.00 20,110.10 75.2%6701880 Wages-Hourly1,796.90 2,816.66 (1,019.76) 9,366.40 8,083.30 1,283.10 27,800.00 18,433.60 66.3%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 20,190.04 22,094.00 (1,903.96) 96,828.75 103,464.00 (6,635.25) 258,122.00 161,293.25 62.5%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer245.59 500.00 (254.41) 5,101.61 2,500.00 2,601.61 6,300.00 1,198.39 19.0%6703762 Supplies-Office130.95 150.00 (19.05) 535.25 750.00 (214.75) 1,800.00 1,264.75 70.3%6703768 Supplies-Printing & Stationery 34.11 100.00 (65.89) 303.80 500.00 (196.20) 3,300.00 2,996.20 90.8%Total-G&A-SUPPLIES & MATERIALS410.65 750.00 (339.35) 5,940.66 3,750.00 2,190.66 11,400.00 5,459.34 47.9%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipm- 900.00 (900.00) - 1,200.00 (1,200.00) 1,900.00 1,900.00 100.0%Total-G&A-REPAIRS & MAINTENANCE- 900.00 (900.00) - 1,200.00 (1,200.00) 1,900.00 1,900.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance 400.00 400.00 - 2,000.00 2,000.00 - 4,800.00 2,800.00 58.3%6709150 Dues & Subscriptions- 50.00 (50.00) - 350.00 (350.00) 1,700.00 1,700.00 100.0%6709180 Employee Recruiting/Relocatio360.00 200.00 160.00 846.57 600.00 246.57 1,400.00 553.43 39.5%6709197 Equipment Rental358.58 550.00 (191.42) 2,983.27 2,750.00 233.27 6,600.00 3,616.73 54.8%6709202 Fees-Bank280.01 90.00 190.01 951.16 450.00 501.16 1,080.00 128.84 11.9%6709208 Fees-Payroll Processing 1,321.47 1,200.00 121.47 5,652.22 6,000.00 (347.78) 14,400.00 8,747.78 60.7%6709220 Freight/Delivery- 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0%6709490 Miscellaneous173.50 100.00 73.50 195.08 500.00 (304.92) 1,200.00 1,004.92 83.7%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services111.25 75.00 36.25 565.50 375.00 190.50 900.00 334.50 37.2%6709625 Professional Fees- 850.00 (850.00) 5,496.42 4,250.00 1,246.42 10,200.00 4,703.58 46.1%6709636 Promotion/Entertainment- 100.00 (100.00) - 500.00 (500.00) 1,200.00 1,200.00 100.0%6709722 Seminars & Training- 200.00 (200.00) 697.20 1,000.00 (302.80) 2,400.00 1,702.80 71.0%6709810 Travel- - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%training expe Uniforms332.46 150.00 900.00 369.04 525.00 (155.96) 1,050.00 680.96 64.9%Total-G&A-OTHER EXPENSES3,337.27 4,015.00 39.81 19,756.46 19,650.00 106.46 48,630.00 28,873.54 59.4%23,937.96 27,759.00 (3,821.04) 122,525.87 128,064.00 (5,538.13) 320,052.00 197,526.13 61.7%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementNovember 2014Annual Budget10 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts10,363.45 10,050.00 313.45 47,817.25 50,700.00 (2,882.75) 121,050.00 73,232.75 60.5%6800193 Equipment Leases-Maintenance 6,017.26 6,050.00 (32.74) 11,553.08 6,050.00 5,503.08 48,400.00 36,846.92 76.1%6800194 Equipment Leases-Trailer700.03 600.00 100.03 2,991.75 3,000.00 (8.25) 7,200.00 4,208.25 58.4%6800196 Equipment Leases-GPS4,500.00 4,700.00 (200.00) 21,620.00 23,500.00 (1,880.00) 56,400.00 34,780.00 61.7%6800197 Equipment Leases-Others1,209.42 1,150.00 59.42 6,203.41 5,750.00 453.41 13,800.00 7,596.59 0.0%22,790.16 22,550.00 240.16 90,185.49 89,000.00 1,185.49 246,850.00 156,664.51 63.5%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,000.00 8,000.00 - 40,000.00 40,000.00 - 96,000.00 56,000.00 58.3%6900210 FF&E Reserve6,733.45 6,418.00 315.45 8,759.80 8,158.00 601.80 60,874.00 52,114.20 85.6%6900800 Personal Property Taxes- - - 9,584.24 14,800.00 (5,215.76) 14,800.00 5,215.76 35.2%6900323 Insurance-Commercial11,782.71 2,200.00 9,582.71 19,797.26 11,000.00 8,797.26 26,400.00 6,602.74 25.0%26,516.16 16,618.00 9,898.16 78,141.30 73,958.00 4,183.30 198,074.00 119,932.70 60.5%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementNovember 2014Annual BudgetMonth to Date Year to Date11 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2014‐20152014 2014 2014 2014 2014 2014Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMediaSalesPromotionGolf IndustryVIPCelebrityPGA Comp98937Charity/Gift Certificate4Rain/Wind Checks1224Club Staff728360854LQ HS Golf2101068410581137102015 2015 2015 2015 2015 2015Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012