Loading...
04 October 2011 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2011 – October 2011 TABLE OF CONTENTS Summary Operating Income Expense 1 Statement of Fee Revenue 2 Golf Shop Income Statement 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 October Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue20,252.50 17,145.00 3,107.50 18.1% 340,633.71 340,790.00 (156.29) 3,326,982.00 2,986,348.29 10%401000 Miscellaneous Golf Revenue 983.10 3,690.00 (2,706.90) -73.4% 14,520.00 24,754.00 (10,234.00) 146,537.00 132,017.00 10%410000 Revenue-Golf Shop 1,517.83 2,400.00 (882.17) -36.8% 37,366.51 33,737.00 3,629.51 310,919.00 273,552.49 12%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0% 3,000.00 3,000.00 - 12,000.00 9,000.00 25%890000 Interest Income4.66 - 4.66 0.0% 17.54 - 17.54 - (17.54) 0%Total Income24,258.09 24,735.00 (476.91) -1.9% 395,537.76 402,281.00 (6,743.24) 3,796,438.00 3,400,900.24 10%Cost of Goods Sold510000 COS-Golf Shop 770.41 1,274.00 (503.59) 39.5% 20,428.50 17,905.35 (2,523.15) 165,020.45 144,591.95 12%Total COS770.41 1,274.00 (503.59) 39.5% 20,428.50 17,905.35 (2,523.15) 165,020.45 144,591.95 12%Gross Profit23,487.68 23,461.00 26.68 0.1% 375,109.26 384,375.65 (9,266.39) 3,631,417.55 3,256,308.29 10%Expenses610000 Golf Pro Shop 12,603.89 13,922.00 1,318.11 9.5% 54,859.58 64,006.00 9,146.42 223,325.00 168,465.42 25%630000 Course Maintenance255,071.73 261,142.00 6,070.27 2.3% 637,374.79 659,607.00 22,232.21 1,638,879.00 1,001,504.21 39%633000 Maintenance Water & Energy10,966.08 18,210.00 7,243.92 39.8% 80,275.90 97,930.00 17,654.10 270,449.00 190,173.10 30%640000 Outside Services25,413.23 25,298.00 (115.23) -0.5% 75,506.45 70,126.00 (5,380.45) 281,023.00 205,516.55 27%650000 Clubhouse 13,019.35 11,736.00 (1,283.35) -10.9% 42,304.50 43,644.00 1,339.50 132,232.00 89,927.50 32%660000 Marketing 13,577.19 19,826.00 6,248.81 31.5% 59,762.09 74,394.00 14,631.91 254,820.00 195,057.91 23%670000 General & Administrative23,609.89 25,827.00 2,217.11 8.6% 98,325.17 102,783.00 4,457.83 314,669.00 216,343.83 31%680000 Leases 19,043.81 19,590.00 546.19 2.8% 78,302.98 78,360.00 57.02 235,080.00 156,777.02 33%690000 Miscellaneous Other Expense37,144.15 35,208.00 (1,936.15) -5.5% 101,873.19 113,183.00 11,309.81 197,740.00 95,866.81 52%Total Expenses410,449.32 430,759.00 20,309.68 4.7% 1,228,584.65 1,304,033.00 75,448.35 3,548,217.00 2,319,632.35 35%(386,961.64) (407,298.00) 20,336.36 5.0%(853,475.39) (919,657.35) 66,181.96 83,200.55 936,675.94 -1026%Rounds of Golf PlayedPaid Rounds Played 336 300 36 12.0% 8,530 8,425 105 45,625 37,095 19%Ave $ Per Paid Round Green Fee60.28 57.15 3.13 5.5% 39.93 40.45 (0.52) 72.92 32.99 55%Ave $ Per Paid Round Merchandise4.52 8.00 (3.48) -43.5% 4.38 4.00 0.38 6.81 2.43 64%Ave $ Per Paid Miscellaneous 2.93 12.30 (9.37) -76.2% 1.70 2.94 (1.24) 3.21 1.51 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateOctober 20111 Income October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 20,252.50 17,145.00 3,107.50 340,633.71 340,790.00 (156.29) 3,326,982.002,986,348.2910%4010000 Rider Fee - 30.00 (30.00) 2,850.00 843.00 2,007.00 7,446.004,596.0038%4040000 Club Rental 115.00 150.00 (35.00) 3,515.00 4,213.00 (698.00) 22,813.0019,298.0015%4050000 Driving Range 247.00 510.00 (263.00) 6,160.00 12,698.00 (6,538.00) 73,278.0067,118.008%4060000 Handicap Fees - - - - - - 0.000.000%4080000 GPS Advertising - 2,000.00 (2,000.00) 550.00 5,000.00 (4,450.00) 12,000.00 11,450.005%4090000 Ball Retriever/Subcontract 621.10 1,000.00 (378.90) 1,435.50 2,000.00 (564.50) 4,000.00 2,564.5036%4091000 Golf Professional Rental Fee - - - - - - 27,000.00 27,000.00 0%4092000 Golf Lessons - - - 9.50 - 9.50 - (9.50) 0% Total Revenue Fees 21,235.60 20,835.00 400.60 355,153.71 365,544.00 (10,390.29) 3,473,519.00 3,118,365.29 10%21,235.60 20,835.00 400.60 355,153.71 365,544.00 (10,390.29) 3,473,519.00 3,118,365.29 10%SilverRock ResortStatement of Fees RevenueOctober 2011Total IncomeMonth to Date Year to Date Annual Budget2 Income October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 16.27 - 16.27 936.27 - 936.27 0 0 0%4100110 Sales Hard Goods 794.74 840.00 (45.26) 19,805.78 11,808.00 7,997.78 108,822.00 89,016.22 18%4100112 Sales-Soft Goods 1,071.91 1,560.00 (488.09) 22,598.39 21,929.00 669.39 202,097.00 179,498.61 11%5100639 GS-Discounts-Mdse (365.09) - (365.09) (5,973.93) - (5,973.93) - 5,973.93 0% Total Revenue Golf Shop 1,517.83 2,400.00 (882.17) 37,366.51 33,737.00 3,629.51 310,919.00 274,488.76 12%COS 5100150 COS-GS-Hard Goods 486.34 462.00 24.34 10,394.76 6,494.40 3,900.36 59,852.10 49,457.34 17%5100151 COS-GS-Soft Goods 341.59 858.00 (516.41) 9,843.32 12,060.95 (2,217.63) 111,153.35 101,310.03 9%5100152 COS-GS-Purchase Disc (189.11) (66.00) (123.11) (300.80) (928.00) 627.20 (8,550.00) (8,249.20) -4%5100220 COS-GS-Freight Merch 131.59 20.00 111.59 491.22 278.00 213.22 2,565.00 2,073.78 19%Cost of Sales - Golf Shop 770.41 1,274.00 (503.59) 20,428.50 17,905.35 2,523.15 165,020.45 144,591.95 12%Gross Profit 747.42 1,126.00 (378.58) 16,938.01 15,831.65 1,106.36 145,898.55 129,896.81 11%COS % 50.8% 53.1% 2.3% 54.7% 53.1% -1.6% 53.1% 52.7% 1%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 2,607.66 2,317.00 290.66 10,430.64 8,275.00 2,155.64 26,811.00 16,380.36 39%6101325 Insurance-Workers Comp 441.74 350.00 91.74 1,766.96 1,700.00 66.96 6,131.00 4,364.04 29%6101720 Salaries 3,545.44 3,750.00 (204.56) 15,127.26 15,000.00 127.26 45,000.00 29,872.74 34%6101800 Taxes-Employer Payroll 604.63 973.00 (368.37) 2,796.96 4,722.00 (1,925.04) 17,040.00 14,243.04 16%6101880 Wages-Hourly 3,871.19 4,747.00 (875.81) 20,473.44 26,244.00 (5,770.56) 103,818.00 83,344.56 20%6101882 Wages-Overtime - - - 297.62 - 297.62 - 952.88 0%Total -PS-SALARIES & BENEFITS 11,070.66 12,137.00 (1,066.34) 50,892.88 55,941.00 (5,048.12) 198,800.00 149,157.62 25%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 405.07 500.00 (94.93) 836.79 2,000.00 (1,163.21) 6,000.00 5,163.21 14%6109090 Contract Services 500.00 500.00 - 2,000.00 2,000.00 - 6,000.00 4,000.00 33%6109220 Freight & Delivery 397.85 25.00 372.85 431.12 25.00 406.12 75.00 (356.12) 575%6109490 Miscellaneous - 50.00 (50.00) - 50.00 (50.00) 450.00 450.00 0%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short (0.08) - (0.08) 28.98 - 28.98 - (28.98) 0%6109722 Seminars/Training - 500.00 (500.00) - 3,150.00 (3,150.00) 5,890.00 5,890.00 0%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms 119.87 100.00 19.87 214.36 400.00 (185.64) 2,400.00 2,185.64 9%6117840 Telephones 110.52 110.00 0.52 455.45 440.00 15.45 1,320.00 864.55 0%Total PS-OTHER EXPENSES 1,533.23 1,785.00 (251.77) 3,966.70 8,065.00 (4,098.30) 24,525.00 20,558.30 16%12,603.89 13,922.00 (1,318.11) 54,859.58 64,006.00 (9,146.42) 223,325.00 169,715.92 24%Net Income(11,856.47) (12,796.00) 939.53 (37,921.57) (48,174.35) 10,252.78 (77,426.45) (39,819.11) -49%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementOctober 20113 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 7,920.29 8,740.00 (819.71) 31,548.51 34,960.00 (3,411.49) 104,880.00 73,331.49 69.9%6311325 Insurance-Workers Comp 1,824.54 2,557.00 (732.46) 7,298.16 9,361.00 (2,062.84) 28,026.00 20,727.84 74.0%6311720 Salaries 11,001.60 12,583.00 (1,581.40) 46,940.16 50,332.00 (3,391.84) 150,996.00 104,055.84 68.9%6311800 Taxes-Employer Payroll 5,433.62 7,509.00 (2,075.38) 19,676.70 26,421.00 (6,744.30) 78,501.00 58,824.30 74.9%6311880 Wages-Hourly 42,896.67 42,473.00 423.67 173,163.32 169,892.00 3,271.32 518,654.00 345,490.68 66.6%6311882 Wages-Overtime 10,802.64 10,526.00 276.64 11,051.39 10,526.00 525.39 15,945.00 4,893.61 30.7%Total-CM-SALARIES & BENEFITS79,879.36 84,388.00 (4,508.64) 289,678.24 301,492.00 (11,813.76) 897,002.00 607,323.76 67.7%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 4,725.60 4,500.00 225.60 14,120.93 14,000.00 120.93 29,300.00 15,179.07 51.8%6313744 Fertilizer 17,586.90 17,500.00 86.90 55,727.42 52,900.00 2,827.42 104,400.00 48,672.58 46.6%6313745 Herbicides - - - 6,734.50 7,000.00 (265.50) 17,000.00 10,265.50 60.4%6313746 Flowers/Plants 151.93 250.00 (98.07) 1,484.11 1,250.00 234.11 3,050.00 1,565.89 51.3%6313748 Fuel-Gasoline 7,116.90 7,200.00 (83.10) 21,680.88 20,050.00 1,630.88 48,800.00 27,119.12 55.6%6313750 Golf Course Accessories 12,232.60 10,000.00 2,232.60 12,480.42 10,900.00 1,580.42 12,300.00 (180.42) -1.5%6313756 POA Control - - - 472.73 - 472.73 7,000.00 6,527.27 93.2%6313758 Miscellaneous Supp 1,039.43 500.00 539.43 3,123.68 2,750.00 373.68 4,350.00 1,226.32 0.0%6313762 Supplies-Office - - - 215.48 - 215.48 - (215.48) 0.0%6313774 Sand 1,608.28 2,000.00 (391.72) 5,477.05 7,780.00 (2,302.95) 16,460.00 10,982.95 66.7%6313776 Seed 88,763.95 88,060.00 703.95 90,394.32 89,010.00 1,384.32 106,810.00 16,415.68 15.4%6313778 Small Tools & Non-Capital Equip 2,357.46 2,000.00 357.46 3,616.07 4,200.00 (583.93) 5,000.00 1,383.93 27.7%6313780 Sod 3,075.66 250.00 2,825.66 4,360.50 1,650.00 2,710.50 6,350.00 1,989.50 31.3%6313782 Topdressing 1,520.10 2,500.00 (979.90) 3,842.05 5,000.00 (1,157.95) 7,600.00 3,757.95 49.4%Total-CM-SUPPLIES & MATERIALS140,178.81 134,760.00 5,418.81 223,730.14 216,490.00 7,240.14 368,420.00 144,689.86 39.3%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,830.00 2,600.00 230.00 11,320.00 10,400.00 920.00 31,200.00 19,880.00 63.7%6315685 CM-R&M-Bldngs & Othr Structures 95.50 - 95.50 579.00 750.00 (171.00) 1,750.00 1,171.00 66.9%6315690 CM-R&M-Equipment 7,285.03 8,000.00 (714.97) 17,001.86 11,000.00 6,001.86 20,500.00 3,498.14 17.1%6315692 CM-R&M-Irrigation System 1,685.42 2,000.00 (314.58) 11,567.56 15,000.00 (3,432.44) 22,650.00 11,082.44 48.9%6315696 CM-R&M-Pumps 497.00 1,000.00 (503.00) 497.00 4,000.00 (3,503.00) 10,500.00 10,003.00 95.3%6315815 CM-R&M-Trees-Pruning Etc - 550.00 (550.00) 2,295.00 4,050.00 (1,755.00) 10,050.00 7,755.00 77.2%Total-CM-REPAIRS & MAINTENANCE 12,392.95 14,150.00 (1,757.05) 43,260.42 45,200.00 (1,939.58) 96,650.00 53,389.58 55.2%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 10.61 15.00 (4.39) 59.47 60.00 (0.53) 180.00 120.53 0.0%6317840 Telephones 1,331.54 850.00 481.54 4,455.54 3,400.00 1,055.54 10,200.00 5,744.46 56.3%Total-CM-UTILITIES 1,342.15 865.00 477.15 4,515.01 3,460.00 1,055.01 10,380.00 5,864.99 56.5%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 2,000.00 2,000.00 - 6,000.00 4,000.00 66.7%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 920.65 524.00 396.65 3,298.60 2,096.00 1,202.60 6,288.00 2,989.40 0.0%6319150 Dues & Subscriptions - - - 210.00 - 210.00 540.00 330.00 61.1%6319170 Employee Education - 50.00 (50.00) 59.00 200.00 (141.00) 1,550.00 1,491.00 96.2%6319197 Equipment Rental 2,695.38 1,800.00 895.38 2,695.38 2,300.00 395.38 4,200.00 1,504.62 35.8%6319206 Licenses & Permits - - - - 280.00 (280.00) 1,430.00 1,430.00 100.0%6319490 Miscellaneous - 100.00 (100.00) 434.80 400.00 34.80 1,200.00 765.20 63.8%6319718 Safety Equipment & Training 151.77 800.00 (648.23) 876.24 1,850.00 (973.76) 3,850.00 2,973.76 77.2%6319822 Uniforms 1,028.43 920.00 108.43 3,831.26 3,680.00 151.26 11,040.00 7,208.74 65.3%Total-CM-OTHER EXPENSES 5,296.23 4,694.00 602.23 15,405.28 14,806.00 599.28 40,098.00 24,692.72 61.6%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementOctober 2011Annual Budget4 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,615.33 2,648.00 (1,032.67) 6,461.32 10,592.00 (4,130.68) 31,776.00 25,314.68 79.7%6321325 Insurance-Workers Comp 368.90 624.00 (255.10) 1,475.60 2,243.00 (767.40) 6,543.00 5,067.40 77.4%6321800 Taxes-Employer Payroll 845.10 1,862.00 (1,016.90) 3,917.09 6,397.00 (2,479.91) 18,416.00 14,498.91 78.7%6321880 Wages-Hourly 10,348.41 12,880.00 (2,531.59) 45,446.04 51,520.00 (6,073.96) 154,560.00 109,113.96 70.6%6321882 Wages-Overtime 2,189.44 3,381.00 (1,191.56) 2,253.76 4,347.00 (2,093.24) 6,279.00 4,025.24 64.1%Total-CM-LM-SALARIES & BENEFITS15,367.18 21,395.00 (6,027.82) 59,553.81 75,099.00 (15,545.19) 217,574.00 158,020.19 72.6%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 100.00 (100.00) - 400.00 (400.00) 1,025.00 1,025.00 100.0%6323788 Uniforms 237.12 290.00 (52.88) 853.96 1,160.00 (306.04) 3,480.00 2,626.04 75.5%Total-CM-LM-SUPPLIES & MATERIALS237.12 390.00 (152.88) 853.96 1,560.00 (706.04) 4,505.00 3,651.04 81.0%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation 377.93 500.00 (122.07) 377.93 1,500.00 (1,122.07) 4,250.00 3,872.07 91.1%Total-CM-LM-REPAIRS & MAINTENANCE 377.93 500.00 (122.07) 377.93 1,500.00 (1,122.07) 4,250.00 3,872.07 91.1%255,071.73 261,142.00 (6,070.27) 637,374.79 659,607.00 (22,232.21) 1,638,879.00 1,001,504.21 61.1% October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 6,050.00 14,250.00 (8,200.00) 56,099.47 76,650.00 (20,550.53) 227,391.00 171,291.53 75.3%6337842 Utilities-Water4,916.08 3,960.00 956.08 24,176.43 21,280.00 2,896.43 43,058.00 18,881.57 43.9%10,966.08 18,210.00 (7,243.92) 80,275.90 97,930.00 (17,654.10) 270,449.00 190,173.10 70.3%Silverrock ResortCourse Maintenance Expense StatementOctober 2011Annual BudgetMonth to Date Year to DateSilverrock ResortCourse Maintenance Water & EnergyOctober 2011Total-COURSE MAINTENANCETotal-CM-WATER & ENERGYMonth to Date Year to Date Annual Budget5 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group 446.57 662.00 (215.43) 1,786.28 2,648.00 (861.72) 7,944.00 6,157.72 77.5%6411325 Insurance-Workers Comp 392.19 181.00 211.19 1,568.76 1,152.00 416.76 5,096.00 3,527.24 69.2%6411800 Taxes-Employer Payroll 406.40 546.00 (139.60) 2,869.77 3,482.00 (612.23) 15,399.00 12,529.23 81.4%6411880 Wages-Hourly 4,325.69 4,388.00 (62.31) 27,526.40 27,973.00 (446.60) 123,689.00 96,162.60 77.7%6411882 Wages-Overtime 52.31 - 52.31 368.64 - 368.64 - (368.64) 0.0%Total-CBR-SALARIES & BENEFITS5,623.16 5,777.00 (153.84) 34,119.85 35,255.00 (1,135.15) 152,128.00 118,008.15 77.6%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 500.00 (500.00) 633.03 500.00 133.03 2,350.00 1,716.97 73.1%6413742 Supplies-Expendable 1,662.45 150.00 1,512.45 3,877.50 1,500.00 2,377.50 6,750.00 2,872.50 42.6%6413752 Supplies-Range Balls - - - - - - 9,000.00 9,000.00 100.0%6413762 Supplies-Office - 50.00 (50.00) - 125.00 (125.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary 70.40 - 70.40 70.40 - 70.40 420.00 349.60 83.2%6413786 Supplies-Towels - 100.00 (100.00) 1,120.00 316.00 804.00 1,005.00 (115.00) -11.4%6413796 Supplies-Bottled Water11,188.64 12,000.00 (811.36) 11,774.71 12,150.00 (375.29) 24,500.00 12,725.29 51.9%Total-CBR-SUPPLIES & MATERIALS12,921.49 12,800.00 121.49 17,475.64 14,591.00 2,884.64 44,550.00 27,074.36 60.8%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment 143.21 300.00 (156.79) 823.53 1,200.00 (376.47) 3,600.00 2,776.47 77.1%6415695 CBR-R&M-Cart Maintenance & Repair 2,129.12 1,500.00 629.12 3,269.72 3,750.00 (480.28) 9,750.00 6,480.28 66.5%Total-CBR-REPAIRS & MAINTENANCE 2,272.33 1,800.00 472.33 4,093.25 4,950.00 (856.75) 13,350.00 9,256.75 69.3%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen - 800.00 (800.00) 3,575.48 3,200.00 375.48 9,600.00 6,024.52 62.8%6419220 Freight/Delivery - 75.00 (75.00) - 300.00 (300.00) 450.00 450.00 100.0%6419490 Miscellaneous 112.11 75.00 37.11 422.78 350.00 72.78 1,150.00 727.22 63.2%6419820 Uniforms 1,919.82 2,000.00 (80.18) 1,919.82 2,000.00 (80.18) 5,200.00 3,280.18 63.1%Total-CBR-OTHER EXPENSES 2,031.93 2,950.00 (918.07) 5,918.08 5,850.00 68.08 16,400.00 10,481.92 63.9%TOTAL-CARTS,BAGROOM & RANGE 22,848.91 23,327.00 (478.09) 61,606.82 60,646.00 960.82 226,428.00 164,821.18 72.8%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 258.70 35.00 223.70 1,034.80 282.00 752.80 1,805.00 770.20 42.7%6431800 Taxes-Employer Payroll 134.57 96.00 38.57 1,460.78 783.00 677.78 5,015.00 3,554.22 70.9%6431880 Wages-Hourly 1,210.00 840.00 370.00 10,238.00 6,840.00 3,398.00 43,800.00 33,562.00 76.6%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS1,603.27 971.00 632.27 12,733.58 7,905.00 4,828.58 50,620.00 37,886.42 74.8%643-CS-OTHER EXPENSES6433742 Supplies Expendable 434.65 100.00 334.65 434.65 300.00 134.65 1,050.00 615.35 58.6%6439490 Miscellaneous - 50.00 (50.00) - 50.00 (50.00) 200.00 200.00 100.0%6439718 Safety Equipment & Training - 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6439820 Uniforms 526.40 800.00 (273.60) 731.40 1,025.00 (293.60) 2,125.00 1,393.60 65.6%Total-CS-OTHER EXPENSES 961.05 1,000.00 (38.95) 1,166.05 1,575.00 (408.95) 3,975.00 2,808.95 70.7%Total-COURSE SERVICES 2,564.32 1,971.00 593.32 13,899.63 9,480.00 4,419.63 54,595.00 40,695.37 74.5%25,413.23 25,298.00 115.23 75,506.45 70,126.00 5,380.45 281,023.00 202,707.60 72.1%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementOctober 2011Annual Budget6 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable750.39 400.00 350.39 840.24 1,600.00 (759.76) 4,800.00 3,959.76 82.5%Total-CH-SUPPLIES & MATERIALS 750.39 400.00 350.39 840.24 1,600.00 (759.76) 4,800.00 3,959.76 82.5%65-CH-UTILITIES6507836 Utilities-Natural Gas199.45 300.00 (100.55) 1,175.08 1,200.00 (24.92) 3,600.00 2,424.92 67.4%6507840 Utilities-Telephone1,125.20 1,150.00 (24.80) 4,264.81 4,600.00 (335.19) 13,800.00 9,535.19 69.1%6507842 Utilities-Water413.75 321.00 92.75 1,700.35 1,284.00 416.35 3,852.00 2,151.65 55.9%6507844 Utilities-Cable336.89 340.00 (3.11) 1,347.56 1,360.00 (12.44) 4,080.00 2,732.44 67.0%Total-CH-UTILITIES 2,075.29 2,111.00 (35.71) 8,487.80 8,444.00 43.80 25,332.00 16,844.20 66.5%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 2,425.00 (600.00) 7,300.00 7,900.00 (600.00) 22,500.00 15,200.00 67.6%6509099 Contract Services-Security6,815.64 4,900.00 1,915.64 21,301.12 19,600.00 1,701.12 60,400.00 39,098.88 64.7%6509215 Flowers & Decorations- 500.00 (500.00) - 500.00 (500.00) 2,400.00 2,400.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 602.86 800.00 (197.14) 2,400.00 1,797.14 74.9%6509718 Safety Equipment & Training- 100.00 (100.00) - 400.00 (400.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES 8,640.64 8,125.00 515.64 29,203.98 29,200.00 3.98 88,900.00 59,696.02 67.1%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures921.40 300.00 621.40 2,557.61 1,200.00 1,357.61 3,600.00 1,042.39 29.0%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 526.00 1,600.00 (1,074.00) 4,800.00 4,274.00 89.0%6515690 CH-R&M-Equipment Repair631.63 400.00 231.63 688.87 1,600.00 (911.13) 4,800.00 4,111.13 85.6%Total-CH-REPAIRS & MAINTENANCE 1,553.03 1,100.00 453.03 3,772.48 4,400.00 (627.52) 13,200.00 9,427.52 71.4%13,019.35 11,736.00 1,283.35 42,304.50 43,644.00 (1,339.50) 132,232.00 18,855.04 14.3%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementOctober 2011Annual Budget7 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 264.78 331.00 (66.22) 945.60 1,324.00 (378.40) 3,972.00 3,026.40 76.2%6601325 Insurance-Workers Comp 174.88 103.00 71.88 699.52 412.00 287.52 1,240.00 540.48 43.6%6601720 Salaries 1,840.76 2,508.00 (667.24) 8,720.24 10,032.00 (1,311.76) 30,096.00 21,375.76 71.0%6601800 Taxes-Employer Payroll 146.56 287.00 (140.44) 767.96 1,148.00 (380.04) 3,446.00 2,678.04 77.7%Total-MKT-SALARIES & BENEFITS 2,426.98 3,229.00 (802.02) 11,133.32 12,916.00 (1,782.68) 38,754.00 27,620.68 71.3%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 400.00 (400.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery 530.94 3,000.00 (2,469.06) 2,766.08 3,200.00 (433.92) 4,425.00 1,658.92 37.5%530.94 3,100.00 (2,569.06) 2,766.08 3,600.00 (833.92) 5,625.00 2,858.92 50.8%66-MKT-UTILITIES6607840 Utilities-Telephone 48.35 100.00 (51.65) 191.68 400.00 (208.32) 1,200.00 1,008.32 84.0%Total-MKT-UTILITIES 48.35 100.00 (51.65) 191.68 400.00 (208.32) 1,200.00 1,008.32 84.0%66-MKT-OTHER EXPENSES6609010 Advertising 9,593.70 8,822.00 771.70 44,296.79 50,753.00 (6,456.21) 185,731.00 141,434.21 76.2%6609040 Business Meals - 25.00 (25.00) - 100.00 (100.00) 300.00 300.00 100.0%6609080 Collateral Material 686.00 2,500.00 (1,814.00) 686.00 2,500.00 (1,814.00) 9,000.00 8,314.00 92.4%6609102 Contract Services-Web Page 99.00 400.00 (301.00) 396.00 1,600.00 (1,204.00) 4,800.00 4,404.00 91.8%6609490 Miscellaneous - - - - - - 350.00 350.00 100.0%6609620 Postage 192.22 50.00 142.22 192.22 200.00 (7.78) 600.00 407.78 68.0%6609630 Promotion - 50.00 (50.00) - 50.00 (50.00) 3,500.00 3,500.00 0.0%6609633 Promotion-Community - 750.00 (750.00) - 975.00 (975.00) 2,925.00 2,925.00 100.0%6609634 Promotion-Media/Vendor - 500.00 (500.00) - 1,000.00 (1,000.00) 700.00 - 0.0%6609150 Dues and Subscriptions - - - 100.00 - 100.00 735.00 635.00 86.4%6609820 Uniforms - 300.00 (300.00) - 300.00 (300.00) 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 10,570.92 13,397.00 (2,826.08) 45,671.01 57,478.00 (11,806.99) 209,241.00 162,869.99 77.8%13,577.19 19,826.00 (6,248.81) 59,762.09 74,394.00 (14,631.91) 254,820.00 194,357.91 76.3%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementOctober 2011Annual Budget8 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group2,871.42 1,458.00 1,413.42 11,422.17 5,832.00 5,590.17 17,496.00 6,073.83 34.7%6701325 Insurance-Workers Comp588.76 707.00 (118.24) 2,355.04 2,828.00 (472.96) 8,480.00 6,124.96 72.2%6701720 Salaries 13,416.26 14,833.34 (1,417.08) 57,242.71 59,333.36 (2,090.65) 178,000.00 120,757.29 67.8%6701800 Taxes-Employer Payroll 1,214.94 1,964.00 (749.06) 4,936.19 7,856.00 (2,919.81) 23,568.00 18,631.81 79.1%6701880 Wages-Hourly1,123.76 2,319.66 (1,195.90) 5,984.84 9,278.64 (3,293.80) 27,835.00 21,850.16 78.5%6701882 Wages-Overtime - - - 10.88 - 10.88 - (10.88) 0.0%Total-G&A-SALARIES & BENEFITS 19,215.14 21,282.00 (2,066.86) 81,951.83 85,128.00 (3,176.17) 255,379.00 173,427.17 67.9%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 400.00 (400.00) 674.24 1,600.00 (925.76) 5,200.00 4,525.76 87.0%6703762 Supplies-Office 160.91 100.00 60.91 411.12 400.00 11.12 1,200.00 788.88 65.7%6703768 Supplies-Printing & Stationery- 100.00 (100.00) 236.35 400.00 (163.65) 3,300.00 3,063.65 92.8%Total-G&A-SUPPLIES & MATERIALS 160.91 600.00 (439.09) 1,321.71 2,400.00 (1,078.29) 9,700.00 8,378.29 86.4%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment105.76 100.00 5.76 105.76 300.00 (194.24) 1,100.00 994.24 90.4%Total-G&A-REPAIRS & MAINTENANCE 105.76 100.00 5.76 105.76 300.00 (194.24) 1,100.00 994.24 90.4%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7%6709150 Dues & Subscriptions- 50.00 (50.00) 150.00 300.00 (150.00) 1,700.00 1,550.00 91.2%6709180 Employee Recruiting/Relocation84.00 200.00 (116.00) 224.00 400.00 (176.00) 1,400.00 1,176.00 84.0%6709197 Equipment Rental562.98 480.00 82.98 2,424.15 1,920.00 504.15 5,760.00 3,335.85 57.9%6709202 Fees-Bank59.71 90.00 (30.29) 313.10 360.00 (46.90) 1,080.00 766.90 71.0%6709208 Fees-Payroll Processing1,032.78 1,100.00 (67.22) 4,646.56 4,400.00 246.56 13,200.00 8,553.44 64.8%6709220 Freight/Delivery- 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6709490 Miscellaneous 111.34 100.00 11.34 476.48 400.00 76.48 1,200.00 723.52 60.3%6709620 Postage/Mail Services - 75.00 (75.00) 315.98 300.00 15.98 900.00 584.02 64.9%6709625 Professional Fees1,436.75 850.00 586.75 3,880.70 3,400.00 480.70 10,200.00 6,319.30 62.0%6709636 Promotion/Entertainment- 100.00 (100.00) - 400.00 (400.00) 3,100.00 3,100.00 100.0%6709722 Seminars & Training303.02 200.00 103.02 553.02 800.00 (246.98) 2,400.00 1,846.98 77.0%6709810 Travel - - - 224.38 100.00 124.38 1,100.00 875.62 79.6%6709820 Uniforms 137.50 150.00 (12.50) 137.50 375.00 (237.50) 1,050.00 912.50 86.9%Total-G&A-OTHER EXPENSES 4,128.08 3,845.00 283.08 14,945.87 14,955.00 (9.13) 48,490.00 33,544.13 69.2%23,609.89 25,827.00 (2,217.11) 98,325.17 102,783.00 (4,457.83) 314,669.00 216,343.83 68.8%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementOctober 2011Annual Budget9 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,091.63 12,075.00 (983.37) 44,366.52 48,300.00 (3,933.48) 144,900.00 100,533.48 69.4%6800194 Equipment Leases-Trailer 502.54 600.00 (97.46) 2,038.62 2,400.00 (361.38) 7,200.00 5,161.38 71.7%6800196 Equipment Leases-GPS 5,350.02 5,755.00 (404.98) 21,221.52 23,020.00 (1,798.48) 69,060.00 47,838.48 69.3%6800197 Equipment Leases-Others 2,099.62 1,160.00 939.62 10,676.32 4,640.00 6,036.32 13,920.00 3,243.68 0.0%19,043.81 19,590.00 (546.19) 78,302.98 78,360.00 (57.02) 235,080.00 156,777.02 66.7%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 23,750.14 23,065.00 685.14 71,698.66 82,767.00 (11,068.34) 90,000.00 18,301.34 20.3%6900210 FF&E Reserve 405.00 343.00 62.00 6,812.63 6,816.00 (3.37) 66,540.00 59,727.37 89.8%6900800 Personal Property Taxes 4,530.38 9,600.00 (5,069.62) 11,971.07 14,800.00 (2,828.93) 14,800.00 2,828.93 19.1%6900323 Insurance-Commercial 8,458.63 2,200.00 6,258.63 11,390.83 8,800.00 2,590.83 26,400.00 15,009.17 56.9%37,144.15 35,208.00 1,936.15 101,873.19 113,183.00 (11,309.81) 197,740.00 95,866.81 48.5%Silverrock ResortOperating Leases & Miscellaneous Other Expense StatementOctober 2011Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSES10 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2011-20122011 2011 2011 2011 2011 2011Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia51 1Sales4PromotionGolf Industry6VIPCelebrityPGA Comp64 60 50 5Charity/Gift Certificate214Rain/Wind Checks321Club Staff65 62 91 8LQ HS Golf2412141 136 162 14 0 02012 2012 2012 2012 2012 2012Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2011-2012October 2011 Date Time Description CategoryPlayers10/1/2011 12:15 Kris Long Media 112