Loading...
06 December 2011 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2011 – December 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 December Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue298,788.50 268,229.00 30,559.50 11.4% 1,016,186.06 959,469.00 56,717.06 3,326,982.00 2,310,795.94 31%401000 Miscellaneous Golf Revenue 20,104.50 15,005.00 5,099.50 34.0% 54,421.38 56,513.00 (2,091.62) 146,537.00 92,115.62 37%410000 Revenue-Golf Shop 22,735.25 24,806.00 (2,070.75) -8.3% 92,356.65 88,931.00 3,425.65 310,919.00 218,562.35 30%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0% 6,000.00 6,000.00 - 12,000.00 6,000.00 50%890000 Interest Income0.47 - 0.47 0.0% 20.93 - 20.93 - (20.93) 0%Total Income343,128.72 309,540.00 33,588.72 10.9% 1,168,985.02 1,110,913.00 58,072.02 3,796,438.00 2,627,452.98 31%Cost of Goods Sold510000 COS-Golf Shop 12,823.74 13,166.30 (342.56) 2.6% 50,783.31 47,198.05 (3,585.26) 165,020.45 114,237.14 31%Total COS12,823.74 13,166.30 (342.56) 2.6% 50,783.31 47,198.05 (3,585.26) 165,020.45 114,237.14 31%Gross Profit330,304.98 296,373.70 33,931.28 11.4% 1,118,201.71 1,063,714.95 54,486.76 3,631,417.55 2,513,215.84 31%Expenses610000 Golf Pro Shop 16,622.73 19,708.00 3,085.27 15.7% 88,267.97 103,422.00 15,154.03 223,325.00 135,057.03 40%630000 Course Maintenance127,256.65 123,021.00 (4,235.65) -3.4% 924,673.13 936,031.00 11,357.87 1,638,879.00 714,205.87 56%633000 Maintenance Water & Energy12,058.55 20,415.00 8,356.45 40.9% 107,339.90 137,250.00 29,910.10 270,449.00 163,109.10 40%640000 Outside Services25,019.07 24,631.00 (388.07) -1.6% 128,868.55 127,725.00 (1,143.55) 281,023.00 152,154.45 46%650000 Clubhouse 10,641.84 10,636.00 (5.84) -0.1% 61,590.40 64,916.00 3,325.60 132,232.00 70,641.60 47%660000 Marketing 23,337.47 27,234.00 3,896.53 14.3% 105,826.96 129,812.00 23,985.04 254,820.00 148,993.04 42%670000 General & Administrative27,725.16 28,102.00 376.84 1.3% 150,774.59 156,712.00 5,937.41 314,669.00 163,894.41 48%680000 Leases 19,050.04 19,590.00 539.96 2.8% 116,162.06 117,540.00 1,377.94 235,080.00 118,917.94 49%690000 Miscellaneous Other Expense13,543.34 14,188.00 644.66 4.5% 122,694.57 131,127.00 8,432.43 197,740.00 75,045.43 62%Total Expenses275,254.85 287,525.00 12,270.15 4.3% 1,806,198.13 1,904,535.00 98,336.87 3,548,217.00 1,742,018.87 51%55,050.13 8,848.70 46,201.43 522.1%(687,996.42) (840,820.05) 152,823.63 83,200.55 771,196.97 -827%Rounds of Golf PlayedPaid Rounds Played 3,996 3,675 321 8.7% 17,631 16,775 856 45,625 27,994 39%Ave $ Per Paid Round Green Fee74.77 72.99 1.78 2.4% 57.64 57.20 0.44 72.92 15.28 79%Ave $ Per Paid Round Merchandise5.69 6.75 (1.06) -15.7% 5.24 5.30 (0.06) 6.81 1.58 77%Ave $ Per Paid Miscellaneous 5.03 4.08 0.95 23.2% 3.09 3.37 (0.28) 3.21 0.13 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateDecember 20111 Income December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 298,788.50 268,229.00 30,559.50 1,016,186.06 959,469.00 56,717.06 3,326,982.002,310,795.9431%4010000 Rider Fee 2,200.00 919.00 1,281.00 5,950.00 2,230.00 3,720.00 7,446.001,496.0080%4040000 Club Rental 2,945.00 1,838.00 1,107.00 8,715.00 8,389.00 326.00 22,813.0014,098.0038%4050000 Driving Range 7,813.00 6,248.00 1,565.00 22,736.00 26,894.00 (4,158.00) 73,278.0050,542.0031%4060000 Handicap Fees - - - - - - 0.000.000%4080000 GPS Advertising 198.00 2,000.00 (1,802.00) 952.50 9,000.00 (8,047.50) 12,000.00 11,047.508%4090000 Ball Retriever/Subcontract - - - 1,435.50 2,000.00 (564.50) 4,000.00 2,564.5036%4091000 Golf Professional Rental Fee 6,725.00 4,000.00 2,725.00 14,225.00 8,000.00 6,225.00 27,000.00 12,775.00 53%4092000 Golf Lessons 223.50 - 223.50 407.38 - 407.38 - (407.38) 0% Total Revenue Fees 318,893.00 283,234.00 35,659.00 1,070,607.44 1,015,982.00 54,625.44 3,473,519.00 2,402,911.56 31%318,893.00 283,234.00 35,659.00 1,070,607.44 1,015,982.00 54,625.44 3,473,519.00 2,402,911.56 31%Total IncomeMonth to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueDecember 20112 Income December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 351.03 - 351.03 1,472.05 - 1,472.05 0 0 0%4100110 Sales Hard Goods 9,073.93 8,682.00 391.93 39,994.05 31,126.00 8,868.05 108,822.00 68,827.95 37%4100112 Sales-Soft Goods 17,753.31 16,124.00 1,629.31 65,222.97 57,805.00 7,417.97 202,097.00 136,874.03 32%5100639 GS-Discounts-Mdse (4,443.02) - (4,443.02) (14,332.42) - (14,332.42) - 14,332.42 0% Total Revenue Golf Shop 22,735.25 24,806.00 (2,070.75) 92,356.65 88,931.00 3,425.65 310,919.00 220,034.40 29%COS 5100150 COS-GS-Hard Goods 4,679.79 4,775.10 (95.31) 21,064.83 17,119.30 3,945.53 59,852.10 38,787.27 35%5100151 COS-GS-Soft Goods 7,944.74 8,868.20 (923.46) 28,761.70 31,792.75 (3,031.05) 111,153.35 82,391.65 26%5100152 COS-GS-Purchase Disc (187.64) (682.00) 494.36 (639.01) (2,448.00) 1,808.99 (8,550.00) (7,910.99) -7%5100220 COS-GS-Freight Merch 386.85 205.00 181.85 1,595.79 734.00 861.79 2,565.00 969.21 62%Cost of Sales - Golf Shop 12,823.74 13,166.30 (342.56) 50,783.31 47,198.05 3,585.26 165,020.45 114,237.14 31%Gross Profit 9,911.51 11,639.70 (1,728.19) 41,573.34 41,732.95 (159.61) 145,898.55 105,797.26 27%COS % 56.4% 53.1% -3.3% 55.0% 53.1% -1.9% 53.1% 51.9% 2%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 2,403.29 2,317.00 86.29 15,260.20 12,909.00 2,351.20 26,811.00 11,550.80 57%6101325 Insurance-Workers Comp 501.70 567.00 (65.30) 2,577.87 2,834.00 (256.13) 6,131.00 3,553.13 42%6101720 Salaries 4,018.16 3,750.00 268.16 23,281.77 22,500.00 781.77 45,000.00 21,718.23 52%6101800 Taxes-Employer Payroll 1,239.38 1,576.00 (336.62) 4,876.66 7,874.00 (2,997.34) 17,040.00 12,163.34 29%6101880 Wages-Hourly 7,500.03 10,013.00 (2,512.97) 34,761.90 46,270.00 (11,508.10) 103,818.00 69,056.10 33%6101882 Wages-Overtime 88.03 - 88.03 415.37 - 415.37 - 952.88 0%Total -PS-SALARIES & BENEFITS 15,750.59 18,223.00 (2,472.41) 81,173.77 92,387.00 (11,213.23) 198,800.00 118,994.48 40%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office - 500.00 (500.00) 1,469.19 3,000.00 (1,530.81) 6,000.00 4,530.81 24%6109090 Contract Services 500.00 500.00 - 3,000.00 3,000.00 - 6,000.00 3,000.00 50%6109220 Freight & Delivery - 25.00 (25.00) 570.32 75.00 495.32 75.00 (495.32) 760%6109490 Miscellaneous 170.46 50.00 120.46 333.96 150.00 183.96 450.00 116.04 74%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short 82.62 - 82.62 111.46 - 111.46 - (111.46) 0%6109722 Seminars/Training - 100.00 (100.00) 36.71 3,250.00 (3,213.29) 5,890.00 5,853.29 1%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms - 200.00 (200.00) 791.66 900.00 (108.34) 2,400.00 1,608.34 33%6117840 Telephones 119.06 110.00 9.06 780.90 660.00 120.90 1,320.00 539.10 0%Total PS-OTHER EXPENSES 872.14 1,485.00 (612.86) 7,094.20 11,035.00 (3,940.80) 24,525.00 17,430.80 29%16,622.73 19,708.00 (3,085.27) 88,267.97 103,422.00 (15,154.03) 223,325.00 136,425.28 39%Net Income(6,711.22) (8,068.30) 1,357.08 (46,694.63) (61,689.05) 14,994.42 (77,426.45) (30,628.02) -60%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementDecember 20113 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 10,298.21 8,740.00 1,558.21 51,734.39 52,440.00 (705.61) 104,880.00 53,145.61 50.7%6311325 Insurance-Workers Comp 2,214.02 2,396.00 (181.98) 12,095.64 14,025.00 (1,929.36) 28,026.00 15,930.36 56.8%6311720 Salaries 12,468.48 12,583.00 (114.52) 72,243.84 75,498.00 (3,254.16) 150,996.00 78,752.16 52.2%6311800 Taxes-Employer Payroll 5,929.16 6,660.00 (730.84) 30,358.39 39,385.00 (9,026.61) 78,501.00 48,142.61 61.3%6311880 Wages-Hourly 47,744.35 45,584.00 2,160.35 263,065.49 257,949.00 5,116.49 518,654.00 255,588.51 49.3%6311882 Wages-Overtime 33.91 - 33.91 11,097.20 10,526.00 571.20 15,945.00 4,847.80 30.4%Total-CM-SALARIES & BENEFITS78,688.13 75,963.00 2,725.13 440,594.95 449,823.00 (9,228.05) 897,002.00 456,407.05 50.9%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 2,445.62 2,200.00 245.62 19,997.00 18,900.00 1,097.00 29,300.00 9,303.00 31.8%6313744 Fertilizer 5,560.21 6,000.00 (439.79) 70,980.34 68,400.00 2,580.34 104,400.00 33,419.66 32.0%6313745 Herbicides 6,202.48 5,000.00 1,202.48 17,751.38 17,000.00 751.38 17,000.00 (751.38) -4.4%6313746 Flowers/Plants 377.12 750.00 (372.88) 2,499.94 2,000.00 499.94 3,050.00 550.06 18.0%6313748 Fuel-Gasoline 3,478.33 3,500.00 (21.67) 29,914.01 28,400.00 1,514.01 48,800.00 18,885.99 38.7%6313750 Golf Course Accessories 1,468.39 500.00 968.39 14,270.31 11,600.00 2,670.31 12,300.00 (1,970.31) -16.0%6313756 POA Control - - - 4,500.42 3,500.00 1,000.42 7,000.00 2,499.58 35.7%6313758 Miscellaneous Supp 733.88 500.00 233.88 4,450.49 3,750.00 700.49 4,350.00 (100.49) 0.0%6313762 Supplies-Office - - - 271.11 - 271.11 - (271.11) 0.0%6313774 Sand 1,093.24 800.00 293.24 11,809.00 15,580.00 (3,771.00) 16,460.00 4,651.00 28.3%6313776 Seed - 350.00 (350.00) 106,201.53 104,710.00 1,491.53 106,810.00 608.47 0.6%6313778 Small Tools & Non-Capital Equip - 100.00 (100.00) 3,992.23 4,400.00 (407.77) 5,000.00 1,007.77 20.2%6313780 Sod - 250.00 (250.00) 6,475.89 5,150.00 1,325.89 6,350.00 (125.89) -2.0%6313782 Topdressing - - - 3,842.05 5,000.00 (1,157.95) 7,600.00 3,757.95 49.4%Total-CM-SUPPLIES & MATERIALS21,359.27 19,950.00 1,409.27 296,955.70 288,390.00 8,565.70 368,420.00 71,464.30 19.4%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,800.00 2,600.00 200.00 16,920.00 15,600.00 1,320.00 31,200.00 14,280.00 45.8%6315685 CM-R&M-Bldngs & Othr Structures 95.50 - 95.50 770.00 750.00 20.00 1,750.00 980.00 56.0%6315690 CM-R&M-Equipment 1,246.14 1,000.00 246.14 20,284.97 13,000.00 7,284.97 20,500.00 215.03 1.0%6315692 CM-R&M-Irrigation System 556.28 550.00 6.28 12,554.55 16,450.00 (3,895.45) 22,650.00 10,095.45 44.6%6315696 CM-R&M-Pumps 1,190.15 1,000.00 190.15 6,677.58 6,000.00 677.58 10,500.00 3,822.42 36.4%6315815 CM-R&M-Trees-Pruning Etc - - - 2,295.00 4,050.00 (1,755.00) 10,050.00 7,755.00 77.2%Total-CM-REPAIRS & MAINTENANCE 5,888.07 5,150.00 738.07 59,502.10 55,850.00 3,652.10 96,650.00 37,147.90 38.4%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 29.25 15.00 14.25 104.00 90.00 14.00 180.00 76.00 0.0%6317840 Telephones 1,071.44 850.00 221.44 6,895.07 5,100.00 1,795.07 10,200.00 3,304.93 32.4%Total-CM-UTILITIES 1,100.69 865.00 235.69 6,999.07 5,190.00 1,809.07 10,380.00 3,380.93 32.6%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 3,000.00 3,000.00 - 6,000.00 3,000.00 50.0%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 970.65 524.00 446.65 5,189.90 3,144.00 2,045.90 6,288.00 1,098.10 0.0%6319150 Dues & Subscriptions 350.00 - 350.00 560.00 - 560.00 540.00 (20.00) -3.7%6319170 Employee Education - 50.00 (50.00) 59.00 300.00 (241.00) 1,550.00 1,491.00 96.2%6319197 Equipment Rental - 200.00 (200.00) 2,695.38 3,100.00 (404.62) 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 355.11 100.00 255.11 789.91 600.00 189.91 1,200.00 410.09 34.2%6319718 Safety Equipment & Training 284.34 400.00 (115.66) 1,577.21 2,750.00 (1,172.79) 3,850.00 2,272.79 59.0%6319822 Uniforms 1,275.36 920.00 355.36 6,331.55 5,520.00 811.55 11,040.00 4,708.45 42.6%Total-CM-OTHER EXPENSES 3,735.46 2,694.00 1,041.46 22,202.95 20,694.00 1,508.95 40,098.00 17,895.05 44.6%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementDecember 2011Annual Budget4 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,560.15 2,648.00 (1,087.85) 11,763.89 15,888.00 (4,124.11) 31,776.00 20,012.11 63.0%6321325 Insurance-Workers Comp 640.93 531.00 109.93 2,485.43 3,331.00 (845.57) 6,543.00 4,057.57 62.0%6321800 Taxes-Employer Payroll 1,313.71 1,475.00 (161.29) 6,500.34 9,457.00 (2,956.66) 18,416.00 11,915.66 64.7%6321880 Wages-Hourly 12,724.59 12,880.00 (155.41) 72,984.40 77,280.00 (4,295.60) 154,560.00 81,575.60 52.8%6321882 Wages-Overtime 7.59 - 7.59 2,268.94 5,313.00 (3,044.06) 6,279.00 4,010.06 63.9%Total-CM-LM-SALARIES & BENEFITS16,246.97 17,534.00 (1,287.03) 96,003.00 111,269.00 (15,266.00) 217,574.00 121,571.00 55.9%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) - 575.00 (575.00) 1,025.00 1,025.00 100.0%6323788 Uniforms 238.06 290.00 (51.94) 1,342.80 1,740.00 (397.20) 3,480.00 2,137.20 61.4%Total-CM-LM-SUPPLIES & MATERIALS238.06 365.00 (126.94) 1,342.80 2,315.00 (972.20) 4,505.00 3,162.20 70.2%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 500.00 (500.00) 1,072.56 2,500.00 (1,427.44) 4,250.00 3,177.44 74.8%Total-CM-LM-REPAIRS & MAINTENANCE - 500.00 (500.00) 1,072.56 2,500.00 (1,427.44) 4,250.00 3,177.44 74.8%127,256.65 123,021.00 4,235.65 924,673.13 936,031.00 (11,357.87) 1,638,879.00 714,205.87 43.6% December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 9,440.36 18,090.00 (8,649.64) 76,561.83 110,390.00 (33,828.17) 227,391.00 150,829.17 66.3%6337842 Utilities-Water2,618.19 2,325.00 293.19 30,778.07 26,860.00 3,918.07 43,058.00 12,279.93 28.5%12,058.55 20,415.00 (8,356.45) 107,339.90 137,250.00 (29,910.10) 270,449.00 163,109.10 60.3%Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetSilverrock ResortCourse Maintenance Water & EnergyDecember 2011Total-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementDecember 2011Annual BudgetMonth to Date Year to Date5 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group 421.09 662.00 (240.91) 2,631.25 3,972.00 (1,340.75) 7,944.00 5,312.75 66.9%6411325 Insurance-Workers Comp 401.15 485.00 (83.85) 2,322.11 2,082.00 240.11 5,096.00 2,773.89 54.4%6411800 Taxes-Employer Payroll 1,814.35 1,466.00 348.35 6,093.90 6,293.00 (199.10) 15,399.00 9,305.10 60.4%6411880 Wages-Hourly 13,790.41 11,774.00 2,016.41 53,243.15 50,549.00 2,694.15 123,689.00 70,445.85 57.0%6411882 Wages-Overtime 132.94 - 132.94 632.46 - 632.46 - (632.46) 0.0%Total-CBR-SALARIES & BENEFITS16,559.94 14,387.00 2,172.94 64,922.87 62,896.00 2,026.87 152,128.00 87,205.13 57.3%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 500.00 (500.00) 1,058.54 2,000.00 (941.46) 2,350.00 1,291.46 55.0%6413742 Supplies-Expendable 1,346.67 150.00 1,196.67 5,743.52 3,450.00 2,293.52 6,750.00 1,006.48 14.9%6413752 Supplies-Range Balls - - - 7,745.85 9,000.00 (1,254.15) 9,000.00 1,254.15 13.9%6413762 Supplies-Office - 50.00 (50.00) - 225.00 (225.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - - - 70.40 - 70.40 420.00 349.60 83.2%6413786 Supplies-Towels 320.00 72.00 248.00 1,600.00 573.00 1,027.00 1,005.00 (595.00) -59.2%6413796 Supplies-Bottled Water47.33 50.00 (2.67) 11,822.04 12,250.00 (427.96) 24,500.00 12,677.96 51.7%Total-CBR-SUPPLIES & MATERIALS1,714.00 822.00 892.00 28,040.35 27,498.00 542.35 44,550.00 16,509.65 37.1%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment 17.18 300.00 (282.82) 1,091.86 1,800.00 (708.14) 3,600.00 2,508.14 69.7%6415695 CBR-R&M-Cart Maintenance & Repair - 750.00 (750.00) 2,274.42 5,250.00 (2,975.58) 9,750.00 7,475.58 76.7%Total-CBR-REPAIRS & MAINTENANCE 17.18 1,050.00 (1,032.82) 3,366.28 7,050.00 (3,683.72) 13,350.00 9,983.72 74.8%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 410.56 800.00 (389.44) 4,433.66 4,800.00 (366.34) 9,600.00 5,166.34 53.8%6419220 Freight/Delivery - 75.00 (75.00) - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous - 75.00 (75.00) 451.78 500.00 (48.22) 1,150.00 698.22 60.7%6419820 Uniforms 46.30 500.00 (453.70) 2,362.99 3,000.00 (637.01) 5,200.00 2,837.01 54.6%Total-CBR-OTHER EXPENSES 456.86 1,450.00 (993.14) 7,248.43 8,750.00 (1,501.57) 16,400.00 9,151.57 55.8%TOTAL-CARTS,BAGROOM & RANGE 18,747.98 17,709.00 1,038.98 103,577.93 106,194.00 (2,616.07) 226,428.00 122,850.07 54.3%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 358.70 231.00 127.70 1,540.70 686.00 854.70 1,805.00 264.30 14.6%6431800 Taxes-Employer Payroll 608.12 641.00 (32.88) 2,554.61 1,905.00 649.61 5,015.00 2,460.39 49.1%6431880 Wages-Hourly 5,304.27 5,600.00 (295.73) 19,765.60 16,640.00 3,125.60 43,800.00 24,034.40 54.9%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS6,271.09 6,472.00 (200.91) 23,860.91 19,231.00 4,629.91 50,620.00 26,759.09 52.9%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) 629.14 500.00 129.14 1,050.00 420.86 40.1%6439490 Miscellaneous - 50.00 (50.00) 31.37 150.00 (118.63) 200.00 168.63 84.3%6439718 Safety Equipment & Training - 50.00 (50.00) - 300.00 (300.00) 600.00 600.00 100.0%6439820 Uniforms - 250.00 (250.00) 769.20 1,350.00 (580.80) 2,125.00 1,355.80 63.8%Total-CS-OTHER EXPENSES - 450.00 (450.00) 1,429.71 2,300.00 (870.29) 3,975.00 2,545.29 64.0%Total-COURSE SERVICES 6,271.09 6,922.00 (650.91) 25,290.62 21,531.00 3,759.62 54,595.00 29,304.38 53.7%25,019.07 24,631.00 388.07 128,868.55 127,725.00 1,143.55 281,023.00 149,609.16 53.2%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementDecember 2011Annual Budget6 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 870.19 2,400.00 (1,529.81) 4,800.00 3,929.81 81.9%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 870.19 2,400.00 (1,529.81) 4,800.00 3,929.81 81.9%65-CH-UTILITIES6507836 Utilities-Natural Gas576.30 300.00 276.30 2,080.35 1,800.00 280.35 3,600.00 1,519.65 42.2%6507840 Utilities-Telephone1,159.21 1,150.00 9.21 6,553.99 6,900.00 (346.01) 13,800.00 7,246.01 52.5%6507842 Utilities-Water425.17 321.00 104.17 2,222.76 1,926.00 296.76 3,852.00 1,629.24 42.3%6507844 Utilities-Cable336.89 340.00 (3.11) 2,021.34 2,040.00 (18.66) 4,080.00 2,058.66 50.5%Total-CH-UTILITIES 2,497.57 2,111.00 386.57 12,878.44 12,666.00 212.44 25,332.00 12,453.56 49.2%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning- 1,825.00 (1,825.00) 9,125.00 11,550.00 (2,425.00) 22,500.00 13,375.00 59.4%6509099 Contract Services-Security6,956.56 4,900.00 2,056.56 32,857.72 29,400.00 3,457.72 60,400.00 27,542.28 45.6%6509215 Flowers & Decorations- - - - 500.00 (500.00) 2,400.00 2,400.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 602.86 1,200.00 (597.14) 2,400.00 1,797.14 74.9%6509718 Safety Equipment & Training- 100.00 (100.00) - 600.00 (600.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES 6,956.56 7,025.00 (68.44) 42,585.58 43,250.00 (664.42) 88,900.00 46,314.42 52.1%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures120.00 300.00 (180.00) 2,973.61 1,800.00 1,173.61 3,600.00 626.39 17.4%6515686 CH-R&M-Restaurant Repairs90.01 400.00 (309.99) 616.01 2,400.00 (1,783.99) 4,800.00 4,183.99 87.2%6515690 CH-R&M-Equipment Repair977.70 400.00 577.70 1,666.57 2,400.00 (733.43) 4,800.00 3,133.43 65.3%Total-CH-REPAIRS & MAINTENANCE 1,187.71 1,100.00 87.71 5,256.19 6,600.00 (1,343.81) 13,200.00 7,943.81 60.2%10,641.84 10,636.00 5.84 61,590.40 64,916.00 (3,325.60) 132,232.00 15,887.62 12.0%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementDecember 2011Annual Budget7 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 370.03 331.00 39.03 1,688.70 1,986.00 (297.30) 3,972.00 2,283.30 57.5%6601325 Insurance-Workers Comp 180.55 103.00 77.55 967.27 618.00 349.27 1,240.00 272.73 22.0%6601720 Salaries 2,755.93 2,508.00 247.93 13,632.29 15,048.00 (1,415.71) 30,096.00 16,463.71 54.7%6601800 Taxes-Employer Payroll 362.68 287.00 75.68 1,327.92 1,722.00 (394.08) 3,446.00 2,118.08 61.5%Total-MKT-SALARIES & BENEFITS 3,669.19 3,229.00 440.19 17,616.18 19,374.00 (1,757.82) 38,754.00 21,137.82 54.5%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 600.00 (600.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery 299.80 200.00 99.80 3,340.34 3,600.00 (259.66) 4,425.00 1,084.66 24.5%299.80 300.00 (0.20) 3,340.34 4,200.00 (859.66) 5,625.00 2,284.66 40.6%66-MKT-UTILITIES6607840 Utilities-Telephone 109.45 100.00 9.45 443.94 600.00 (156.06) 1,200.00 756.06 63.0%Total-MKT-UTILITIES 109.45 100.00 9.45 443.94 600.00 (156.06) 1,200.00 756.06 63.0%66-MKT-OTHER EXPENSES6609010 Advertising 17,419.77 21,730.00 (4,310.23) 78,877.98 93,663.00 (14,785.02) 185,731.00 106,853.02 57.5%6609040 Business Meals - 25.00 (25.00) - 150.00 (150.00) 300.00 300.00 100.0%6609080 Collateral Material 1,353.06 - 1,353.06 3,770.09 3,500.00 270.09 9,000.00 5,229.91 58.1%6609102 Contract Services-Web Page 99.00 400.00 (301.00) 594.00 2,400.00 (1,806.00) 4,800.00 4,206.00 87.6%6609490 Miscellaneous 66.34 50.00 16.34 102.34 100.00 2.34 350.00 247.66 70.8%6609620 Postage 147.00 50.00 97.00 430.86 300.00 130.86 600.00 169.14 28.2%6609630 Promotion 32.33 50.00 (17.67) 32.33 150.00 (117.67) 3,500.00 3,467.67 0.0%6609633 Promotion-Community - 750.00 (750.00) - 2,475.00 (2,475.00) 2,925.00 2,925.00 100.0%6609634 Promotion-Media/Vendor - 500.00 (500.00) - 2,500.00 (2,500.00) 700.00 - 0.0%6609150 Dues and Subscriptions - - - 124.76 - 124.76 735.00 610.24 83.0%6609820 Uniforms 141.53 50.00 91.53 494.14 400.00 94.14 600.00 105.86 17.6%Total-MKT-OTHER EXPENSES 19,259.03 23,605.00 (4,345.97) 84,426.50 105,638.00 (21,211.50) 209,241.00 124,114.50 59.3%23,337.47 27,234.00 (3,896.53) 105,826.96 129,812.00 (23,985.04) 254,820.00 148,293.04 58.2%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementDecember 2011Annual Budget8 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,802.86 1,458.00 344.86 15,044.54 8,748.00 6,296.54 17,496.00 2,451.46 14.0%6701325 Insurance-Workers Comp601.40 707.00 (105.60) 3,445.20 4,242.00 (796.80) 8,480.00 5,034.80 59.4%6701720 Salaries 15,205.10 14,833.34 371.76 88,100.11 89,000.04 (899.93) 178,000.00 89,899.89 50.5%6701800 Taxes-Employer Payroll 1,483.06 1,964.00 (480.94) 7,683.82 11,784.00 (4,100.18) 23,568.00 15,884.18 67.4%6701880 Wages-Hourly2,181.77 2,319.66 (137.89) 10,386.31 13,917.96 (3,531.65) 27,835.00 17,448.69 62.7%6701882 Wages-Overtime - - - 10.88 - 10.88 - (10.88) 0.0%Total-G&A-SALARIES & BENEFITS 21,274.19 21,282.00 (7.81) 124,670.86 127,692.00 (3,021.14) 255,379.00 130,708.14 51.2%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 400.00 (400.00) 878.82 2,400.00 (1,521.18) 5,200.00 4,321.18 83.1%6703762 Supplies-Office 226.97 100.00 126.97 674.18 600.00 74.18 1,200.00 525.82 43.8%6703768 Supplies-Printing & Stationery57.12 400.00 (342.88) 293.47 900.00 (606.53) 3,300.00 3,006.53 91.1%Total-G&A-SUPPLIES & MATERIALS 284.09 900.00 (615.91) 1,846.47 3,900.00 (2,053.53) 9,700.00 7,853.53 81.0%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment122.71 100.00 22.71 228.47 500.00 (271.53) 1,100.00 871.53 79.2%Total-G&A-REPAIRS & MAINTENANCE 122.71 100.00 22.71 228.47 500.00 (271.53) 1,100.00 871.53 79.2%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 2,400.00 2,400.00 - 4,800.00 2,400.00 50.0%6709150 Dues & Subscriptions- 200.00 (200.00) 208.17 550.00 (341.83) 1,700.00 1,491.83 87.8%6709180 Employee Recruiting/Relocation98.00 200.00 (102.00) 434.00 800.00 (366.00) 1,400.00 966.00 69.0%6709197 Equipment Rental664.10 480.00 184.10 3,650.06 2,880.00 770.06 5,760.00 2,109.94 36.6%6709202 Fees-Bank93.05 90.00 3.05 464.80 540.00 (75.20) 1,080.00 615.20 57.0%6709208 Fees-Payroll Processing249.09 1,100.00 (850.91) 6,004.83 6,600.00 (595.17) 13,200.00 7,195.17 54.5%6709220 Freight/Delivery- 50.00 (50.00) - 300.00 (300.00) 600.00 600.00 100.0%6709490 Miscellaneous - 100.00 (100.00) 476.48 600.00 (123.52) 1,200.00 723.52 60.3%6709620 Postage/Mail Services - 75.00 (75.00) 475.97 450.00 25.97 900.00 424.03 47.1%6709625 Professional Fees1,229.05 850.00 379.05 5,549.00 5,100.00 449.00 10,200.00 4,651.00 45.6%6709636 Promotion/Entertainment3,000.00 2,000.00 1,000.00 3,000.00 2,500.00 500.00 3,100.00 100.00 3.2%6709722 Seminars & Training250.00 200.00 50.00 803.02 1,200.00 (396.98) 2,400.00 1,596.98 66.5%6709810 Travel - - - 224.38 100.00 124.38 1,100.00 875.62 79.6%6709820 Uniforms 60.88 75.00 (14.12) 338.08 600.00 (261.92) 1,050.00 711.92 67.8%Total-G&A-OTHER EXPENSES 6,044.17 5,820.00 224.17 24,028.79 24,620.00 (591.21) 48,490.00 24,461.21 50.4%27,725.16 28,102.00 (376.84) 150,774.59 156,712.00 (5,937.41) 314,669.00 163,894.41 52.1%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementDecember 2011Annual Budget9 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,988.25 12,075.00 (86.75) 67,446.40 72,450.00 (5,003.60) 144,900.00 77,453.60 53.5%6800194 Equipment Leases-Trailer 502.54 600.00 (97.46) 3,043.70 3,600.00 (556.30) 7,200.00 4,156.30 57.7%6800196 Equipment Leases-GPS 5,356.25 5,755.00 (398.75) 31,693.02 34,530.00 (2,836.98) 69,060.00 37,366.98 54.1%6800197 Equipment Leases-Others 1,203.00 1,160.00 43.00 13,978.94 6,960.00 7,018.94 13,920.00 (58.94) 0.0%19,050.04 19,590.00 (539.96) 116,162.06 117,540.00 (1,377.94) 235,080.00 118,917.94 50.6%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 4,709.65 6,623.00 (1,913.35) 75,360.41 83,937.00 (8,576.59) 90,000.00 14,639.59 16.3%6900210 FF&E Reserve 5,975.77 5,365.00 610.77 20,323.68 19,190.00 1,133.68 66,540.00 46,216.32 69.5%6900800 Personal Property Taxes 382.85 - 382.85 12,736.77 14,800.00 (2,063.23) 14,800.00 2,063.23 13.9%6900323 Insurance-Commercial 2,475.07 2,200.00 275.07 14,273.71 13,200.00 1,073.71 26,400.00 12,126.29 45.9%13,543.34 14,188.00 (644.66) 122,694.57 131,127.00 (8,432.43) 197,740.00 75,045.43 38.0%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementDecember 201110 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2011-20122011 2011 2011 2011 2011 2011Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia51 145Sales4Promotion36Golf Industry6VIPCelebrityPGA Comp64 60 50 5 38 29Charity/Gift Certificate214 430Rain/Wind Checks321 13Club Staff65 62 91 8 66 71LQ HS Golf2 4 12 11 34141 136 162 14 136 2052012 2012 2012 2012 2012 2012Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2011-2012December 2011 Date Time Description CategoryPlayers12/11/2011 10:30-11:30 Greenskeeper.org (rain check from June outing….group Promo 36of online bloggers that write golf reviews. 12/26/2011 10:00 Maga Group Promo 412/28/2011 11:00 John White Media 412/31/2011 11:07 Kris Long Meia 112