Loading...
07 January 2012 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2011 – January 2012 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 January Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue390,987.25 388,075.00 2,912.25 0.8% 1,407,173.31 1,347,544.00 59,629.31 3,326,982.00 1,919,808.69 42%401000 Miscellaneous Golf Revenue 25,166.13 16,535.00 8,631.13 52.2% 79,587.51 73,048.00 6,539.51 146,537.00 66,949.49 54%410000 Revenue-Golf Shop 29,160.22 32,251.00 (3,090.78) -9.6% 121,516.87 121,182.00 334.87 310,919.00 189,402.13 39%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0% 7,500.00 7,500.00 - 12,000.00 4,500.00 63%890000 Interest Income0.78 - 0.78 0.0% 21.71 - 21.71 - (21.71) 0%Total Income446,814.38 438,361.00 8,453.38 1.9% 1,615,799.40 1,549,274.00 66,525.40 3,796,438.00 2,180,638.60 43%Cost of Goods Sold510000 COS-Golf Shop 17,180.43 17,117.05 63.38 -0.4% 67,963.74 64,315.10 (3,648.64) 165,020.45 97,056.71 41%Total COS17,180.43 17,117.05 63.38 -0.4% 67,963.74 64,315.10 (3,648.64) 165,020.45 97,056.71 41%Gross Profit429,633.95 421,243.95 8,390.00 2.0% 1,547,835.66 1,484,958.90 62,876.76 3,631,417.55 2,083,581.89 43%Expenses610000 Golf Pro Shop 19,617.78 21,148.00 1,530.22 7.2% 107,885.75 124,570.00 16,684.25 223,325.00 115,439.25 48%630000 Course Maintenance127,116.93 127,025.00 (91.93) -0.1% 1,051,790.06 1,063,056.00 11,265.94 1,638,879.00 587,088.94 64%633000 Maintenance Water & Energy14,611.03 17,876.00 3,264.97 18.3% 121,950.93 155,126.00 33,175.07 270,449.00 148,498.07 45%640000 Outside Services25,775.96 26,956.00 1,180.04 4.4% 154,644.51 154,681.00 36.49 281,023.00 126,378.49 55%650000 Clubhouse 11,626.40 13,236.00 1,609.60 12.2% 73,216.80 78,152.00 4,935.20 132,232.00 59,015.20 55%660000 Marketing 20,357.82 29,086.00 8,728.18 30.0% 126,184.78 158,898.00 32,713.22 254,820.00 128,635.22 50%670000 General & Administrative25,544.79 26,102.00 557.21 2.1% 176,319.38 182,814.00 6,494.62 314,669.00 138,349.62 56%680000 Leases 17,990.79 19,590.00 1,599.21 8.2% 134,152.85 137,130.00 2,977.15 235,080.00 100,927.15 57%690000 Miscellaneous Other Expense14,424.17 14,449.00 24.83 0.2% 137,118.74 145,576.00 8,457.26 197,740.00 60,621.26 69%Total Expenses277,065.67 295,468.00 18,402.33 6.2% 2,083,263.80 2,200,003.00 116,739.20 3,548,217.00 1,464,953.20 59%152,568.28 125,775.95 26,792.33 21.3%(535,428.14) (715,044.10) 179,615.96 83,200.55 618,628.69 -644%Rounds of Golf PlayedPaid Rounds Played 4,772 4,300 472 11.0% 22,403 21,075 1,328 45,625 23,222 49%Ave $ Per Paid Round Green Fee81.93 90.25 (8.32) -9.2% 62.81 63.94 (1.13) 72.92 10.11 86%Ave $ Per Paid Round Merchandise6.11 7.50 (1.39) -18.5% 5.42 5.75 (0.33) 6.81 1.39 80%Ave $ Per Paid Miscellaneous 5.27 3.85 1.43 37.1% 3.55 3.47 0.09 3.21 (0.34) 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateJanuary 20121 Income January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 390,987.25 388,075.00 2,912.25 1,407,173.31 1,347,544.00 59,629.31 3,326,982.001,919,808.6942%4010000 Rider Fee 1,100.00 1,075.00 25.00 7,050.00 3,305.00 3,745.00 7,446.00396.0095%4040000 Club Rental 1,775.00 2,150.00 (375.00) 10,490.00 10,539.00 (49.00) 22,813.0012,323.0046%4050000 Driving Range 12,498.00 7,310.00 5,188.00 35,234.00 34,204.00 1,030.00 73,278.0038,044.0048%4060000 Handicap Fees 1,600.00 - 1,600.00 1,600.00 - 1,600.00 0.000.000%4080000 GPS Advertising 1,101.98 1,000.00 101.98 2,054.48 10,000.00 (7,945.52) 12,000.00 9,945.5217%4090000 Ball Retriever/Subcontract 404.90 1,000.00 (595.10) 1,840.40 3,000.00 (1,159.60) 4,000.00 2,159.6046%4091000 Golf Professional Rental Fee 5,715.50 4,000.00 1,715.50 19,940.50 12,000.00 7,940.50 27,000.00 7,059.50 74%4092000 Golf Lessons 970.75 - 970.75 1,378.13 - 1,378.13 - (1,378.13) 0% Total Revenue Fees 416,153.38 404,610.00 11,543.38 1,486,760.82 1,420,592.00 66,168.82 3,473,519.00 1,988,358.18 43%416,153.38 404,610.00 11,543.38 1,486,760.82 1,420,592.00 66,168.82 3,473,519.00 1,988,358.18 43%SilverRock ResortStatement of Fees RevenueJanuary 2012Total IncomeMonth to Date Year to Date Annual Budget2 Income January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 251.00 - 251.00 1,723.05 - 1,723.05 0 0 0%4100110 Sales Hard Goods 9,030.21 11,288.00 (2,257.79) 49,024.26 42,414.00 6,610.26 108,822.00 59,797.74 45%4100112 Sales-Soft Goods 24,487.57 20,963.00 3,524.57 89,710.54 78,768.00 10,942.54 202,097.00 112,386.46 44%5100639 GS-Discounts-Mdse (4,608.56) - (4,608.56) (18,940.98) - (18,940.98) - 18,940.98 0% Total Revenue Golf Shop 29,160.22 32,251.00 (3,090.78) 121,516.87 121,182.00 334.87 310,919.00 191,125.18 39%COS 5100150 COS-GS-Hard Goods 5,760.60 6,208.40 (447.80) 26,825.43 23,327.70 3,497.73 59,852.10 33,026.67 45%5100151 COS-GS-Soft Goods 10,866.98 11,529.65 (662.67) 39,628.68 43,322.40 (3,693.72) 111,153.35 71,524.67 36%5100152 COS-GS-Purchase Disc (112.52) (887.00) 774.48 (751.53) (3,335.00) 2,583.47 (8,550.00) (7,798.47) -9%5100220 COS-GS-Freight Merch 665.37 266.00 399.37 2,261.16 1,000.00 1,261.16 2,565.00 303.84 88%Cost of Sales - Golf Shop 17,180.43 17,117.05 63.38 67,963.74 64,315.10 3,648.64 165,020.45 97,056.71 41%Gross Profit 11,979.79 15,133.95 (3,154.16) 53,553.13 56,866.90 (3,313.77) 145,898.55 94,068.47 36%COS % 58.9% 53.1% -5.8% 55.9% 53.1% -2.9% 53.1% 50.8% 4%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 2,402.29 2,317.00 85.29 17,662.49 15,226.00 2,436.49 26,811.00 9,148.51 66%6101325 Insurance-Workers Comp 247.68 567.00 (319.32) 2,825.55 3,401.00 (575.45) 6,131.00 3,305.45 46%6101720 Salaries 3,899.99 3,750.00 149.99 27,181.76 26,250.00 931.76 45,000.00 17,818.24 60%6101800 Taxes-Employer Payroll 2,047.55 1,576.00 471.55 6,924.21 9,450.00 (2,525.79) 17,040.00 10,115.79 41%6101880 Wages-Hourly 9,368.15 10,013.00 (644.85) 44,130.05 56,283.00 (12,152.95) 103,818.00 59,687.95 43%6101882 Wages-Overtime 37.50 - 37.50 452.87 - 452.87 - 952.88 0%Total -PS-SALARIES & BENEFITS 18,003.16 18,223.00 (219.84) 99,176.93 110,610.00 (11,433.07) 198,800.00 101,028.82 49%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 370.95 500.00 (129.05) 1,840.14 3,500.00 (1,659.86) 6,000.00 4,159.86 31%6109090 Contract Services 500.00 500.00 - 3,500.00 3,500.00 - 6,000.00 2,500.00 58%6109220 Freight & Delivery - - - 570.32 75.00 495.32 75.00 (495.32) 760%6109490 Miscellaneous 172.27 50.00 122.27 506.23 200.00 306.23 450.00 (56.23) 112%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short (25.20) - (25.20) 86.26 - 86.26 - (86.26) 0%6109722 Seminars/Training - 1,250.00 (1,250.00) 36.71 4,500.00 (4,463.29) 5,890.00 5,853.29 1%6109810 Travel - Merchandise - 15.00 (15.00) - 15.00 (15.00) 90.00 90.00 0%6109820 Uniforms 483.47 500.00 (16.53) 1,275.13 1,400.00 (124.87) 2,400.00 1,124.87 53%6117840 Telephones 113.13 110.00 3.13 894.03 770.00 124.03 1,320.00 425.97 0%Total PS-OTHER EXPENSES 1,614.62 2,925.00 (1,310.38) 8,708.82 13,960.00 (5,251.18) 24,525.00 15,816.18 36%19,617.78 21,148.00 (1,530.22) 107,885.75 124,570.00 (16,684.25) 223,325.00 116,845.00 48%Net Income(7,637.99) (6,014.05) (1,623.94) (54,332.62) (67,703.10) 13,370.48 (77,426.45) (22,776.53) -71%SilverRock ResortGolf Shop Income StatementJanuary 2012Total Expenses-Golf ShopMonth to Date Year to Date Annual Budget3 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 9,034.83 8,740.00 294.83 60,769.22 61,180.00 (410.78) 104,880.00 44,110.78 42.1%6311325 Insurance-Workers Comp 963.30 2,579.00 (1,615.70) 13,058.94 16,604.00 (3,545.06) 28,026.00 14,967.06 53.4%6311720 Salaries 12,101.76 12,583.00 (481.24) 84,345.60 88,081.00 (3,735.40) 150,996.00 66,650.40 44.1%6311800 Taxes-Employer Payroll 8,106.99 7,265.00 841.99 38,465.38 46,650.00 (8,184.62) 78,501.00 40,035.62 51.0%6311880 Wages-Hourly 49,390.04 48,320.00 1,070.04 312,455.53 306,269.00 6,186.53 518,654.00 206,198.47 39.8%6311882 Wages-Overtime 83.90 2,550.00 (2,466.10) 11,181.10 13,076.00 (1,894.90) 15,945.00 4,763.90 29.9%Total-CM-SALARIES & BENEFITS79,680.82 82,037.00 (2,356.18) 520,275.77 531,860.00 (11,584.23) 897,002.00 376,726.23 42.0%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 2,677.34 2,000.00 677.34 22,674.34 20,900.00 1,774.34 29,300.00 6,625.66 22.6%6313744 Fertilizer 6,149.13 6,000.00 149.13 77,129.47 74,400.00 2,729.47 104,400.00 27,270.53 26.1%6313745 Herbicides - - - 17,751.38 17,000.00 751.38 17,000.00 (751.38) -4.4%6313746 Flowers/Plants 531.75 750.00 (218.25) 3,031.69 2,750.00 281.69 3,050.00 18.31 0.6%6313748 Fuel-Gasoline 3,347.12 3,350.00 (2.88) 33,261.13 31,750.00 1,511.13 48,800.00 15,538.87 31.8%6313750 Golf Course Accessories 109.89 200.00 (90.11) 14,380.20 11,800.00 2,580.20 12,300.00 (2,080.20) -16.9%6313756 POA Control 3,711.68 3,500.00 211.68 8,212.10 7,000.00 1,212.10 7,000.00 (1,212.10) -17.3%6313758 Miscellaneous Supp 759.02 100.00 659.02 5,209.51 3,850.00 1,359.51 4,350.00 (859.51) 0.0%6313762 Supplies-Office - - - 271.11 - 271.11 - (271.11) 0.0%6313774 Sand - 380.00 (380.00) 11,809.00 15,960.00 (4,151.00) 16,460.00 4,651.00 28.3%6313776 Seed - 350.00 (350.00) 106,201.53 105,060.00 1,141.53 106,810.00 608.47 0.6%6313778 Small Tools & Non-Capital Equip 358.21 100.00 258.21 4,350.44 4,500.00 (149.56) 5,000.00 649.56 13.0%6313780 Sod - 500.00 (500.00) 6,475.89 5,650.00 825.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 & MATERIALS17,644.14 17,230.00 414.14 314,599.84 305,620.00 8,979.84 368,420.00 53,820.16 14.6%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,800.00 2,600.00 200.00 19,720.00 18,200.00 1,520.00 31,200.00 11,480.00 36.8%6315685 CM-R&M-Bldngs & Othr Structures 95.50 250.00 (154.50) 865.50 1,000.00 (134.50) 1,750.00 884.50 50.5%6315690 CM-R&M-Equipment 1,443.09 1,000.00 443.09 21,728.06 14,000.00 7,728.06 20,500.00 (1,228.06) -6.0%6315692 CM-R&M-Irrigation System 1,232.38 1,200.00 32.38 13,786.93 17,650.00 (3,863.07) 22,650.00 8,863.07 39.1%6315696 CM-R&M-Pumps 122.62 1,000.00 (877.38) 6,800.20 7,000.00 (199.80) 10,500.00 3,699.80 35.2%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,693.59 6,050.00 (356.41) 65,195.69 61,900.00 3,295.69 96,650.00 31,454.31 32.5%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 23.31 15.00 8.31 127.31 105.00 22.31 180.00 52.69 0.0%6317840 Telephones 1,540.56 850.00 690.56 8,435.63 5,950.00 2,485.63 10,200.00 1,764.37 17.3%Total-CM-UTILITIES 1,563.87 865.00 698.87 8,562.94 6,055.00 2,507.94 10,380.00 1,817.06 17.5%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 3,500.00 3,500.00 - 6,000.00 2,500.00 41.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 470.65 524.00 (53.35) 5,660.55 3,668.00 1,992.55 6,288.00 627.45 0.0%6319150 Dues & Subscriptions - - - 560.00 - 560.00 540.00 (20.00) -3.7%6319170 Employee Education - 50.00 (50.00) 59.00 350.00 (291.00) 1,550.00 1,491.00 96.2%6319197 Equipment Rental - 200.00 (200.00) 2,695.38 3,300.00 (604.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 617.50 100.00 517.50 1,407.41 700.00 707.41 1,200.00 (207.41) -17.3%6319718 Safety Equipment & Training 651.50 400.00 251.50 2,228.71 3,150.00 (921.29) 3,850.00 1,621.29 42.1%6319822 Uniforms 1,220.64 920.00 300.64 7,552.19 6,440.00 1,112.19 11,040.00 3,487.81 31.6%Total-CM-OTHER EXPENSES 3,460.29 2,694.00 766.29 25,663.24 23,388.00 2,275.24 40,098.00 14,434.76 36.0%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementJanuary 2012Annual Budget4 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,958.24 2,648.00 310.24 14,722.13 18,536.00 (3,813.87) 31,776.00 17,053.87 53.7%6321325 Insurance-Workers Comp 330.24 531.00 (200.76) 2,815.67 3,862.00 (1,046.33) 6,543.00 3,727.33 57.0%6321800 Taxes-Employer Payroll 1,827.74 1,475.00 352.74 8,328.08 10,932.00 (2,603.92) 18,416.00 10,087.92 54.8%6321880 Wages-Hourly 13,400.36 12,880.00 520.36 86,384.76 90,160.00 (3,775.24) 154,560.00 68,175.24 44.1%6321882 Wages-Overtime 69.19 - 69.19 2,338.13 5,313.00 (2,974.87) 6,279.00 3,940.87 62.8%Total-CM-LM-SALARIES & BENEFITS18,585.77 17,534.00 1,051.77 114,588.77 128,803.00 (14,214.23) 217,574.00 102,985.23 47.3%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools 175.20 75.00 100.20 175.20 650.00 (474.80) 1,025.00 849.80 82.9%6323788 Uniforms 313.25 290.00 23.25 1,656.05 2,030.00 (373.95) 3,480.00 1,823.95 52.4%Total-CM-LM-SUPPLIES & MATERIALS488.45 365.00 123.45 1,831.25 2,680.00 (848.75) 4,505.00 2,673.75 59.4%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 250.00 (250.00) 1,072.56 2,750.00 (1,677.44) 4,250.00 3,177.44 74.8%Total-CM-LM-REPAIRS & MAINTENANCE - 250.00 (250.00) 1,072.56 2,750.00 (1,677.44) 4,250.00 3,177.44 74.8%127,116.93 127,025.00 91.93 1,051,790.06 1,063,056.00 (11,265.94) 1,638,879.00 587,088.94 35.8% January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 12,450.00 16,016.00 (3,566.00) 89,011.83 126,406.00 (37,394.17) 227,391.00 138,379.17 60.9%6337842 Utilities-Water2,161.03 1,860.00 301.03 32,939.10 28,720.00 4,219.10 43,058.00 10,118.90 23.5%14,611.03 17,876.00 (3,264.97) 121,950.93 155,126.00 (33,175.07) 270,449.00 148,498.07 54.9%Silverrock ResortCourse Maintenance Expense StatementJanuary 2012Annual BudgetMonth to Date Year to DateSilverrock ResortCourse Maintenance Water & EnergyJanuary 2012Total-COURSE MAINTENANCETotal-CM-WATER & ENERGYMonth to Date Year to Date Annual Budget5 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group 420.59 662.00 (241.41) 3,051.84 4,634.00 (1,582.16) 7,944.00 4,892.16 61.6%6411325 Insurance-Workers Comp 192.64 565.00 (372.36) 2,514.75 2,647.00 (132.25) 5,096.00 2,581.25 50.7%6411800 Taxes-Employer Payroll 2,055.22 1,707.00 348.22 8,149.12 8,000.00 149.12 15,399.00 7,249.88 47.1%6411880 Wages-Hourly 13,791.81 13,710.00 81.81 67,034.96 64,259.00 2,775.96 123,689.00 56,654.04 45.8%6411882 Wages-Overtime 62.43 - 62.43 694.89 - 694.89 - (694.89) 0.0%Total-CBR-SALARIES & BENEFITS16,522.69 16,644.00 (121.31) 81,445.56 79,540.00 1,905.56 152,128.00 70,682.44 46.5%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 75.00 (75.00) 1,058.54 2,075.00 (1,016.46) 2,350.00 1,291.46 55.0%6413742 Supplies-Expendable 454.14 1,000.00 (545.86) 6,197.66 4,450.00 1,747.66 6,750.00 552.34 8.2%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) - 275.00 (275.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - 70.00 (70.00) 70.40 70.00 0.40 420.00 349.60 83.2%6413786 Supplies-Towels 320.00 72.00 248.00 1,920.00 645.00 1,275.00 1,005.00 (915.00) -91.0%6413796 Supplies-Bottled Water29.95 50.00 (20.05) 11,851.99 12,300.00 (448.01) 24,500.00 12,648.01 51.6%Total-CBR-SUPPLIES & MATERIALS804.09 1,317.00 (512.91) 28,844.44 28,815.00 29.44 44,550.00 15,705.56 35.3%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment 29.33 300.00 (270.67) 1,121.19 2,100.00 (978.81) 3,600.00 2,478.81 68.9%6415695 CBR-R&M-Cart Maintenance & Repair 1,098.68 750.00 348.68 3,373.10 6,000.00 (2,626.90) 9,750.00 6,376.90 65.4%Total-CBR-REPAIRS & MAINTENANCE 1,128.01 1,050.00 78.01 4,494.29 8,100.00 (3,605.71) 13,350.00 8,855.71 66.3%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 340.66 800.00 (459.34) 4,774.32 5,600.00 (825.68) 9,600.00 4,825.68 50.3%6419220 Freight/Delivery - - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous - 75.00 (75.00) 451.78 575.00 (123.22) 1,150.00 698.22 60.7%6419820 Uniforms - - - 2,362.99 3,000.00 (637.01) 5,200.00 2,837.01 54.6%Total-CBR-OTHER EXPENSES 340.66 875.00 (534.34) 7,589.09 9,625.00 (2,035.91) 16,400.00 8,810.91 53.7%TOTAL-CARTS,BAGROOM & RANGE 18,795.45 19,886.00 (1,090.55) 122,373.38 126,080.00 (3,706.62) 226,428.00 104,054.62 46.0%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 192.64 242.00 (49.36) 1,733.34 928.00 805.34 1,805.00 71.66 4.0%6431800 Taxes-Employer Payroll 792.86 673.00 119.86 3,347.47 2,578.00 769.47 5,015.00 1,667.53 33.3%6431880 Wages-Hourly 5,480.40 5,880.00 (399.60) 25,246.00 22,520.00 2,726.00 43,800.00 18,554.00 42.4%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS6,465.90 6,795.00 (329.10) 30,326.81 26,026.00 4,300.81 50,620.00 20,293.19 40.1%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) 629.14 600.00 29.14 1,050.00 420.86 40.1%6439490 Miscellaneous - 50.00 (50.00) 31.37 200.00 (168.63) 200.00 168.63 84.3%6439718 Safety Equipment & Training - 50.00 (50.00) - 350.00 (350.00) 600.00 600.00 100.0%6439820 Uniforms 514.61 75.00 439.61 1,283.81 1,425.00 (141.19) 2,125.00 841.19 39.6%Total-CS-OTHER EXPENSES 514.61 275.00 239.61 1,944.32 2,575.00 (630.68) 3,975.00 2,030.68 51.1%Total-COURSE SERVICES 6,980.51 7,070.00 (89.49) 32,271.13 28,601.00 3,670.13 54,595.00 22,323.87 40.9%25,775.96 26,956.00 (1,180.04) 154,644.51 154,681.00 (36.49) 281,023.00 124,347.81 44.2%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementJanuary 2012Annual Budget6 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable30.85 400.00 (369.15) 901.04 2,800.00 (1,898.96) 4,800.00 3,898.96 81.2%Total-CH-SUPPLIES & MATERIALS 30.85 400.00 (369.15) 901.04 2,800.00 (1,898.96) 4,800.00 3,898.96 81.2%65-CH-UTILITIES6507836 Utilities-Natural Gas589.79 300.00 289.79 2,670.14 2,100.00 570.14 3,600.00 929.86 25.8%6507840 Utilities-Telephone1,142.22 1,150.00 (7.78) 7,696.21 8,050.00 (353.79) 13,800.00 6,103.79 44.2%6507842 Utilities-Water368.07 321.00 47.07 2,590.83 2,247.00 343.83 3,852.00 1,261.17 32.7%6507844 Utilities-Cable336.91 340.00 (3.09) 2,358.25 2,380.00 (21.75) 4,080.00 1,721.75 42.2%Total-CH-UTILITIES 2,436.99 2,111.00 325.99 15,315.43 14,777.00 538.43 25,332.00 10,016.57 39.5%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 10,950.00 13,375.00 (2,425.00) 22,500.00 11,550.00 51.3%6509099 Contract Services-Security5,075.76 6,500.00 (1,424.24) 37,933.48 35,900.00 2,033.48 60,400.00 22,466.52 37.2%6509215 Flowers & Decorations- 1,000.00 (1,000.00) - 1,500.00 (1,500.00) 2,400.00 2,400.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 602.86 1,400.00 (797.14) 2,400.00 1,797.14 74.9%6509718 Safety Equipment & Training- 100.00 (100.00) - 700.00 (700.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES 6,900.76 9,625.00 (2,724.24) 49,486.34 52,875.00 (3,388.66) 88,900.00 39,413.66 44.3%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures592.00 300.00 292.00 3,565.61 2,100.00 1,465.61 3,600.00 34.39 1.0%6515686 CH-R&M-Restaurant Repairs470.00 400.00 70.00 1,086.01 2,800.00 (1,713.99) 4,800.00 3,713.99 77.4%6515690 CH-R&M-Equipment Repair1,195.80 400.00 795.80 2,862.37 2,800.00 62.37 4,800.00 1,937.63 40.4%Total-CH-REPAIRS & MAINTENANCE 2,257.80 1,100.00 1,157.80 7,513.99 7,700.00 (186.01) 13,200.00 5,686.01 43.1%11,626.40 13,236.00 (1,609.60) 73,216.80 78,152.00 (4,935.20) 132,232.00 11,372.02 8.6%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementJanuary 2012Annual Budget7 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 369.78 331.00 38.78 2,058.48 2,317.00 (258.52) 3,972.00 1,913.52 48.2%6601325 Insurance-Workers Comp 82.56 103.00 (20.44) 1,049.83 721.00 328.83 1,240.00 190.17 15.3%6601720 Salaries 1,428.57 2,508.00 (1,079.43) 15,060.86 17,556.00 (2,495.14) 30,096.00 15,035.14 50.0%6601800 Taxes-Employer Payroll 320.30 287.00 33.30 1,648.22 2,009.00 (360.78) 3,446.00 1,797.78 52.2%Total-MKT-SALARIES & BENEFITS 2,201.21 3,229.00 (1,027.79) 19,817.39 22,603.00 (2,785.61) 38,754.00 18,936.61 48.9%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 80.96 100.00 (19.04) 80.96 700.00 (619.04) 1,200.00 1,119.04 93.3%6603768 Supplies-Printing & Stationery 367.85 200.00 167.85 3,708.19 3,800.00 (91.81) 4,425.00 716.81 16.2%448.81 300.00 148.81 3,789.15 4,500.00 (710.85) 5,625.00 1,835.85 32.6%66-MKT-UTILITIES6607840 Utilities-Telephone 105.50 100.00 5.50 549.44 700.00 (150.56) 1,200.00 650.56 54.2%Total-MKT-UTILITIES 105.50 100.00 5.50 549.44 700.00 (150.56) 1,200.00 650.56 54.2%66-MKT-OTHER EXPENSES6609010 Advertising 15,678.16 21,472.00 (5,793.84) 94,556.14 115,135.00 (20,578.86) 185,731.00 91,174.86 49.1%6609040 Business Meals - 25.00 (25.00) - 175.00 (175.00) 300.00 300.00 100.0%6609080 Collateral Material 1,040.56 2,500.00 (1,459.44) 4,810.65 6,000.00 (1,189.35) 9,000.00 4,189.35 46.5%6609102 Contract Services-Web Page 99.00 400.00 (301.00) 693.00 2,800.00 (2,107.00) 4,800.00 4,107.00 85.6%6609490 Miscellaneous - 50.00 (50.00) 102.34 150.00 (47.66) 350.00 247.66 70.8%6609620 Postage - 50.00 (50.00) 430.86 350.00 80.86 600.00 169.14 28.2%6609630 Promotion - 300.00 (300.00) 32.33 450.00 (417.67) 3,500.00 3,467.67 0.0%6609633 Promotion-Community - 75.00 (75.00) - 2,550.00 (2,550.00) 2,925.00 2,925.00 100.0%6609634 Promotion-Media/Vendor 465.00 500.00 (35.00) 465.00 3,000.00 (2,535.00) 700.00 - 0.0%6609150 Dues and Subscriptions - 35.00 (35.00) 124.76 35.00 89.76 735.00 610.24 83.0%6609820 Uniforms 319.58 50.00 269.58 813.72 450.00 363.72 600.00 (213.72) -35.6%Total-MKT-OTHER EXPENSES 17,602.30 25,457.00 (7,854.70) 102,028.80 131,095.00 (29,066.20) 209,241.00 106,977.20 51.1%20,357.82 29,086.00 (8,728.18) 126,184.78 158,898.00 (32,713.22) 254,820.00 128,400.22 50.4%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementJanuary 2012Annual Budget8 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,802.11 1,458.00 344.11 16,846.65 10,206.00 6,640.65 17,496.00 649.35 3.7%6701325 Insurance-Workers Comp302.72 707.00 (404.28) 3,747.92 4,949.00 (1,201.08) 8,480.00 4,732.08 55.8%6701720 Salaries 14,757.88 14,833.34 (75.46) 102,857.99 103,833.38 (975.39) 178,000.00 75,142.01 42.2%6701800 Taxes-Employer Payroll 2,135.22 1,964.00 171.22 9,819.04 13,748.00 (3,928.96) 23,568.00 13,748.96 58.3%6701880 Wages-Hourly2,879.70 2,319.66 560.04 13,266.01 16,237.62 (2,971.61) 27,835.00 14,568.99 52.3%6701882 Wages-Overtime - - - 10.88 - 10.88 - (10.88) 0.0%Total-G&A-SALARIES & BENEFITS 21,877.63 21,282.00 595.63 146,548.49 148,974.00 (2,425.51) 255,379.00 108,830.51 42.6%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 400.00 (400.00) 878.82 2,800.00 (1,921.18) 5,200.00 4,321.18 83.1%6703762 Supplies-Office 22.61 100.00 (77.39) 696.79 700.00 (3.21) 1,200.00 503.21 41.9%6703768 Supplies-Printing & Stationery- 400.00 (400.00) 293.47 1,300.00 (1,006.53) 3,300.00 3,006.53 91.1%Total-G&A-SUPPLIES & MATERIALS 22.61 900.00 (877.39) 1,869.08 4,800.00 (2,930.92) 9,700.00 7,830.92 80.7%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 228.47 600.00 (371.53) 1,100.00 871.53 79.2%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 228.47 600.00 (371.53) 1,100.00 871.53 79.2%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 2,800.00 2,800.00 - 4,800.00 2,000.00 41.7%6709150 Dues & Subscriptions- 100.00 (100.00) 208.17 650.00 (441.83) 1,700.00 1,491.83 87.8%6709180 Employee Recruiting/Relocation- 200.00 (200.00) 434.00 1,000.00 (566.00) 1,400.00 966.00 69.0%6709197 Equipment Rental562.62 480.00 82.62 4,212.68 3,360.00 852.68 5,760.00 1,547.32 26.9%6709202 Fees-Bank30.00 90.00 (60.00) 494.80 630.00 (135.20) 1,080.00 585.20 54.2%6709208 Fees-Payroll Processing1,245.58 1,100.00 145.58 7,250.41 7,700.00 (449.59) 13,200.00 5,949.59 45.1%6709220 Freight/Delivery- 50.00 (50.00) - 350.00 (350.00) 600.00 600.00 100.0%6709490 Miscellaneous - 100.00 (100.00) 476.48 700.00 (223.52) 1,200.00 723.52 60.3%6709620 Postage/Mail Services 101.88 75.00 26.88 577.85 525.00 52.85 900.00 322.15 35.8%6709625 Professional Fees617.50 850.00 (232.50) 6,166.50 5,950.00 216.50 10,200.00 4,033.50 39.5%6709636 Promotion/Entertainment- 100.00 (100.00) 3,000.00 2,600.00 400.00 3,100.00 100.00 3.2%6709722 Seminars & Training295.59 200.00 95.59 1,098.61 1,400.00 (301.39) 2,400.00 1,301.39 54.2%6709810 Travel - - - 224.38 100.00 124.38 1,100.00 875.62 79.6%6709820 Uniforms 391.38 75.00 316.38 729.46 675.00 54.46 1,050.00 320.54 30.5%Total-G&A-OTHER EXPENSES 3,644.55 3,820.00 (175.45) 27,673.34 28,440.00 (766.66) 48,490.00 20,816.66 42.9%25,544.79 26,102.00 (557.21) 176,319.38 182,814.00 (6,494.62) 314,669.00 138,349.62 44.0%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementJanuary 2012Annual Budget9 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,988.25 12,075.00 (86.75) 79,434.65 84,525.00 (5,090.35) 144,900.00 65,465.35 45.2%6800194 Equipment Leases-Trailer 502.54 600.00 (97.46) 3,546.24 4,200.00 (653.76) 7,200.00 3,653.76 50.7%6800196 Equipment Leases-GPS 4,297.00 5,755.00 (1,458.00) 35,990.02 40,285.00 (4,294.98) 69,060.00 33,069.98 47.9%6800197 Equipment Leases-Others 1,203.00 1,160.00 43.00 15,181.94 8,120.00 7,061.94 13,920.00 (1,261.94) 0.0%17,990.79 19,590.00 (1,599.21) 134,152.85 137,130.00 (2,977.15) 235,080.00 100,927.15 42.9%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 3,746.50 4,487.00 (740.50) 79,106.91 88,424.00 (9,317.09) 90,000.00 10,893.09 12.1%6900210 FF&E Reserve 7,819.75 7,762.00 57.75 28,143.43 26,952.00 1,191.43 66,540.00 38,396.57 57.7%6900800 Personal Property Taxes 382.85 - 382.85 13,119.62 14,800.00 (1,680.38) 14,800.00 1,680.38 11.4%6900323 Insurance-Commercial 2,475.07 2,200.00 275.07 16,748.78 15,400.00 1,348.78 26,400.00 9,651.22 36.6%14,424.17 14,449.00 (24.83) 137,118.74 145,576.00 (8,457.26) 197,740.00 60,621.26 30.7%Silverrock ResortOperating Leases & Miscellaneous Other Expense StatementJanuary 2012Annual 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 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 CategoryJanuaryFebruaryMarchAprilMayJuneMedia5SalesPromotion1Golf Industry4VIPCelebrity2PGA Comp37Charity/Gift Certificate8Rain/Wind ChecksClub Staff150LQ HS Golf482550000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2011-2012January 2012 Date Time Description CategoryPlayers1/2/2012 9:30 Eric Andrews - Club Car Sales 41/9/2012 11:15 Kris Long Media 21/21/2012 12:00 Kris Long Media 11/26/2012 1:30 Michael Dante Cel 21/27/2012 10:07 Danny Eaton-Live Nation Media 21/29/2012 11:00 Linda Reid-Golf Digest Panelist Promo 112