Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
05 November 2011 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2011 – November 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 November Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue376,763.85 350,450.00 26,313.85 7.5% 717,397.56 691,240.00 26,157.56 3,326,982.00 2,609,584.44 22%401000 Miscellaneous Golf Revenue 19,796.88 16,754.00 3,042.88 18.2% 34,316.88 41,508.00 (7,191.12) 146,537.00 112,220.12 23%410000 Revenue-Golf Shop 32,254.89 30,388.00 1,866.89 6.1% 69,621.40 64,125.00 5,496.40 310,919.00 241,297.60 22%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 Income2.92 - 2.92 0.0% 20.46 - 20.46 - (20.46) 0%Total Income430,318.54 399,092.00 31,226.54 7.8% 825,856.30 801,373.00 24,483.30 3,796,438.00 2,970,581.70 22%Cost of Goods Sold510000 COS-Golf Shop 17,531.07 16,126.40 1,404.67 -8.7% 37,959.57 34,031.75 (3,927.82) 165,020.45 127,060.88 23%Total COS17,531.07 16,126.40 1,404.67 -8.7% 37,959.57 34,031.75 (3,927.82) 165,020.45 127,060.88 23%Gross Profit412,787.47 382,965.60 29,821.87 7.8% 787,896.73 767,341.25 20,555.48 3,631,417.55 2,843,520.82 22%Expenses610000 Golf Pro Shop 16,785.66 19,708.00 2,922.34 14.8% 71,645.24 83,714.00 12,068.76 223,325.00 151,679.76 32%630000 Course Maintenance160,041.69 153,403.00 (6,638.69) -4.3% 797,416.48 813,010.00 15,593.52 1,638,879.00 841,462.52 49%633000 Maintenance Water & Energy15,005.45 18,905.00 3,899.55 20.6% 95,281.35 116,835.00 21,553.65 270,449.00 175,167.65 35%640000 Outside Services28,343.03 32,968.00 4,624.97 14.0% 103,849.48 103,094.00 (755.48) 281,023.00 177,173.52 37%650000 Clubhouse 8,644.06 10,636.00 1,991.94 18.7% 50,948.56 54,280.00 3,331.44 132,232.00 81,283.44 39%660000 Marketing 22,727.40 28,184.00 5,456.60 19.4% 82,489.49 102,578.00 20,088.51 254,820.00 172,330.51 32%670000 General & Administrative24,724.26 25,827.00 1,102.74 4.3% 123,049.43 128,610.00 5,560.57 314,669.00 191,619.57 39%680000 Leases 18,809.04 19,590.00 780.96 4.0% 97,112.02 97,950.00 837.98 235,080.00 137,967.98 41%690000 Miscellaneous Other Expense7,278.04 3,756.00 (3,522.04) -93.8% 109,151.23 116,939.00 7,787.77 197,740.00 88,588.77 55%Total Expenses302,358.63 312,977.00 10,618.37 3.4% 1,530,943.28 1,617,010.00 86,066.72 3,548,217.00 2,017,273.72 43%110,428.84 69,988.60 40,440.24 57.8%(743,046.55) (849,668.75) 106,622.20 83,200.55 826,247.10 -893%Rounds of Golf PlayedPaid Rounds Played 5,042 4,675 367 7.9% 13,645 13,100 545 45,625 31,980 30%Ave $ Per Paid Round Green Fee74.73 74.96 (0.24) -0.3% 52.58 52.77 (0.19) 72.92 20.34 72%Ave $ Per Paid Round Merchandise6.40 6.50 (0.10) -1.6% 5.10 4.90 0.21 6.81 1.71 75%Ave $ Per Paid Miscellaneous 3.93 3.58 0.34 9.6% 2.51 3.17 (0.65) 3.21 0.70 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateNovember 20111 Income November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 376,763.85 350,450.00 26,313.85 717,397.56 691,240.00 26,157.56 3,326,982.002,609,584.4422%4010000 Rider Fee 900.00 468.00 432.00 3,750.00 1,311.00 2,439.00 7,446.003,696.0050%4040000 Club Rental 2,255.00 2,338.00 (83.00) 5,770.00 6,551.00 (781.00) 22,813.0017,043.0025%4050000 Driving Range 8,763.00 7,948.00 815.00 14,923.00 20,646.00 (5,723.00) 73,278.0058,355.0020%4060000 Handicap Fees - - - - - - 0.000.000%4080000 GPS Advertising 204.50 2,000.00 (1,795.50) 754.50 7,000.00 (6,245.50) 12,000.00 11,245.506%4090000 Ball Retriever/Subcontract - - - 1,435.50 2,000.00 (564.50) 4,000.00 2,564.5036%4091000 Golf Professional Rental Fee 7,500.00 4,000.00 3,500.00 7,500.00 4,000.00 3,500.00 27,000.00 19,500.00 28%4092000 Golf Lessons 174.38 - 174.38 183.88 - 183.88 - (183.88) 0% Total Revenue Fees 396,560.73 367,204.00 29,356.73 751,714.44 732,748.00 18,966.44 3,473,519.00 2,721,804.56 22%396,560.73 367,204.00 29,356.73 751,714.44 732,748.00 18,966.44 3,473,519.00 2,721,804.56 22%SilverRock ResortStatement of Fees RevenueNovember 2011Total IncomeMonth to Date Year to Date Annual Budget2 Income November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 184.75 - 184.75 1,121.02 - 1,121.02 0 0 0%4100110 Sales Hard Goods 11,114.34 10,636.00 478.34 30,920.12 22,444.00 8,476.12 108,822.00 77,901.88 28%4100112 Sales-Soft Goods 24,871.27 19,752.00 5,119.27 47,469.66 41,681.00 5,788.66 202,097.00 154,627.34 23%5100639 GS-Discounts-Mdse (3,915.47) - (3,915.47) (9,889.40) - (9,889.40) - 9,889.40 0% Total Revenue Golf Shop 32,254.89 30,388.00 1,866.89 69,621.40 64,125.00 5,496.40 310,919.00 242,418.62 22%COS 5100150 COS-GS-Hard Goods 5,990.28 5,849.80 140.48 16,385.04 12,344.20 4,040.84 59,852.10 43,467.06 27%5100151 COS-GS-Soft Goods 10,973.64 10,863.60 110.04 20,816.96 22,924.55 (2,107.59) 111,153.35 90,336.39 19%5100152 COS-GS-Purchase Disc (150.57) (838.00) 687.43 (451.37) (1,766.00) 1,314.63 (8,550.00) (8,098.63) -5%5100220 COS-GS-Freight Merch 717.72 251.00 466.72 1,208.94 529.00 679.94 2,565.00 1,356.06 47%Cost of Sales - Golf Shop 17,531.07 16,126.40 1,404.67 37,959.57 34,031.75 3,927.82 165,020.45 127,060.88 23%Gross Profit 14,723.82 14,261.60 462.22 31,661.83 30,093.25 1,568.58 145,898.55 115,357.74 21%COS % 54.4% 53.1% -1.3% 54.5% 53.1% -1.5% 53.1% 52.4% 1%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 2,426.27 2,317.00 109.27 12,856.91 10,592.00 2,264.91 26,811.00 13,954.09 48%6101325 Insurance-Workers Comp 309.21 567.00 (257.79) 2,076.17 2,267.00 (190.83) 6,131.00 4,054.83 34%6101720 Salaries 4,136.35 3,750.00 386.35 19,263.61 18,750.00 513.61 45,000.00 25,736.39 43%6101800 Taxes-Employer Payroll 840.32 1,576.00 (735.68) 3,637.28 6,298.00 (2,660.72) 17,040.00 13,402.72 21%6101880 Wages-Hourly 6,788.43 10,013.00 (3,224.57) 27,261.87 36,257.00 (8,995.13) 103,818.00 76,556.13 26%6101882 Wages-Overtime 29.72 - 29.72 327.34 - 327.34 - 952.88 0%Total -PS-SALARIES & BENEFITS 14,530.30 18,223.00 (3,692.70) 65,423.18 74,164.00 (8,740.82) 198,800.00 134,657.04 32%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 632.40 500.00 132.40 1,469.19 2,500.00 (1,030.81) 6,000.00 4,530.81 24%6109090 Contract Services 500.00 500.00 - 2,500.00 2,500.00 - 6,000.00 3,500.00 42%6109220 Freight & Delivery 139.20 25.00 114.20 570.32 50.00 520.32 75.00 (495.32) 760%6109490 Miscellaneous 163.50 50.00 113.50 163.50 100.00 63.50 450.00 286.50 36%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short (0.14) - (0.14) 28.84 - 28.84 - (28.84) 0%6109722 Seminars/Training 36.71 - 36.71 36.71 3,150.00 (3,113.29) 5,890.00 5,853.29 1%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms 577.30 300.00 277.30 791.66 700.00 91.66 2,400.00 1,608.34 33%6117840 Telephones 206.39 110.00 96.39 661.84 550.00 111.84 1,320.00 658.16 0%Total PS-OTHER EXPENSES 2,255.36 1,485.00 770.36 6,222.06 9,550.00 (3,327.94) 24,525.00 18,302.94 25%16,785.66 19,708.00 (2,922.34) 71,645.24 83,714.00 (12,068.76) 223,325.00 152,959.98 32%Net Income(2,061.84) (5,446.40) 3,384.56 (39,983.41) (53,620.75) 13,637.34 (77,426.45) (37,602.24) -51%SilverRock ResortGolf Shop Income StatementNovember 2011Total Expenses-Golf ShopMonth to Date Year to Date Annual Budget3 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 9,887.67 8,740.00 1,147.67 41,436.18 43,700.00 (2,263.82) 104,880.00 63,443.82 60.5%6311325 Insurance-Workers Comp 2,583.46 2,268.00 315.46 9,881.62 11,629.00 (1,747.38) 28,026.00 18,144.38 64.7%6311720 Salaries 12,835.20 12,583.00 252.20 59,775.36 62,915.00 (3,139.64) 150,996.00 91,220.64 60.4%6311800 Taxes-Employer Payroll 4,752.53 6,304.00 (1,551.47) 24,429.23 32,725.00 (8,295.77) 78,501.00 54,071.77 68.9%6311880 Wages-Hourly 42,157.82 42,473.00 (315.18) 215,321.14 212,365.00 2,956.14 518,654.00 303,332.86 58.5%6311882 Wages-Overtime 11.90 - 11.90 11,063.29 10,526.00 537.29 15,945.00 4,881.71 30.6%Total-CM-SALARIES & BENEFITS72,228.58 72,368.00 (139.42) 361,906.82 373,860.00 (11,953.18) 897,002.00 535,095.18 59.7%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 3,430.45 2,700.00 730.45 17,551.38 16,700.00 851.38 29,300.00 11,748.62 40.1%6313744 Fertilizer 9,692.71 9,500.00 192.71 65,420.13 62,400.00 3,020.13 104,400.00 38,979.87 37.3%6313745 Herbicides 4,814.40 5,000.00 (185.60) 11,548.90 12,000.00 (451.10) 17,000.00 5,451.10 32.1%6313746 Flowers/Plants 638.71 - 638.71 2,122.82 1,250.00 872.82 3,050.00 927.18 30.4%6313748 Fuel-Gasoline 4,754.80 4,850.00 (95.20) 26,435.68 24,900.00 1,535.68 48,800.00 22,364.32 45.8%6313750 Golf Course Accessories 321.50 200.00 121.50 12,801.92 11,100.00 1,701.92 12,300.00 (501.92) -4.1%6313756 POA Control 4,027.69 3,500.00 527.69 4,500.42 3,500.00 1,000.42 7,000.00 2,499.58 35.7%6313758 Miscellaneous Supp 592.93 500.00 92.93 3,716.61 3,250.00 466.61 4,350.00 633.39 0.0%6313762 Supplies-Office 55.63 - 55.63 271.11 - 271.11 - (271.11) 0.0%6313774 Sand 5,238.71 7,000.00 (1,761.29) 10,715.76 14,780.00 (4,064.24) 16,460.00 5,744.24 34.9%6313776 Seed 15,807.21 15,350.00 457.21 106,201.53 104,360.00 1,841.53 106,810.00 608.47 0.6%6313778 Small Tools & Non-Capital Equip 376.16 100.00 276.16 3,992.23 4,300.00 (307.77) 5,000.00 1,007.77 20.2%6313780 Sod 2,115.39 3,250.00 (1,134.61) 6,475.89 4,900.00 1,575.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 & MATERIALS51,866.29 51,950.00 (83.71) 275,596.43 268,440.00 7,156.43 368,420.00 92,823.57 25.2%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,800.00 2,600.00 200.00 14,120.00 13,000.00 1,120.00 31,200.00 17,080.00 54.7%6315685 CM-R&M-Bldngs & Othr Structures 95.50 - 95.50 674.50 750.00 (75.50) 1,750.00 1,075.50 61.5%6315690 CM-R&M-Equipment 2,036.97 1,000.00 1,036.97 19,038.83 12,000.00 7,038.83 20,500.00 1,461.17 7.1%6315692 CM-R&M-Irrigation System 430.71 900.00 (469.29) 11,998.27 15,900.00 (3,901.73) 22,650.00 10,651.73 47.0%6315696 CM-R&M-Pumps 4,990.43 1,000.00 3,990.43 5,487.43 5,000.00 487.43 10,500.00 5,012.57 47.7%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 10,353.61 5,500.00 4,853.61 53,614.03 50,700.00 2,914.03 96,650.00 43,035.97 44.5%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 15.28 15.00 0.28 74.75 75.00 (0.25) 180.00 105.25 0.0%6317840 Telephones 1,368.09 850.00 518.09 5,823.63 4,250.00 1,573.63 10,200.00 4,376.37 42.9%Total-CM-UTILITIES 1,383.37 865.00 518.37 5,898.38 4,325.00 1,573.38 10,380.00 4,481.62 43.2%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.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 920.65 524.00 396.65 4,219.25 2,620.00 1,599.25 6,288.00 2,068.75 0.0%6319150 Dues & Subscriptions - - - 210.00 - 210.00 540.00 330.00 61.1%6319170 Employee Education - 50.00 (50.00) 59.00 250.00 (191.00) 1,550.00 1,491.00 96.2%6319197 Equipment Rental - 600.00 (600.00) 2,695.38 2,900.00 (204.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 - 100.00 (100.00) 434.80 500.00 (65.20) 1,200.00 765.20 63.8%6319718 Safety Equipment & Training 416.63 500.00 (83.37) 1,292.87 2,350.00 (1,057.13) 3,850.00 2,557.13 66.4%6319822 Uniforms 1,224.93 920.00 304.93 5,056.19 4,600.00 456.19 11,040.00 5,983.81 54.2%Total-CM-OTHER EXPENSES 3,062.21 3,194.00 (131.79) 18,467.49 18,000.00 467.49 40,098.00 21,630.51 53.9%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementNovember 2011Annual Budget4 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 3,742.42 2,648.00 1,094.42 10,203.74 13,240.00 (3,036.26) 31,776.00 21,572.26 67.9%6321325 Insurance-Workers Comp 368.90 557.00 (188.10) 1,844.50 2,800.00 (955.50) 6,543.00 4,698.50 71.8%6321800 Taxes-Employer Payroll 1,269.54 1,585.00 (315.46) 5,186.63 7,982.00 (2,795.37) 18,416.00 13,229.37 71.8%6321880 Wages-Hourly 14,813.77 12,880.00 1,933.77 60,259.81 64,400.00 (4,140.19) 154,560.00 94,300.19 61.0%6321882 Wages-Overtime 7.59 966.00 (958.41) 2,261.35 5,313.00 (3,051.65) 6,279.00 4,017.65 64.0%Total-CM-LM-SALARIES & BENEFITS20,202.22 18,636.00 1,566.22 79,756.03 93,735.00 (13,978.97) 217,574.00 137,817.97 63.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 Uniforms 250.78 290.00 (39.22) 1,104.74 1,450.00 (345.26) 3,480.00 2,375.26 68.3%Total-CM-LM-SUPPLIES & MATERIALS250.78 390.00 (139.22) 1,104.74 1,950.00 (845.26) 4,505.00 3,400.26 75.5%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation 694.63 500.00 194.63 1,072.56 2,000.00 (927.44) 4,250.00 3,177.44 74.8%Total-CM-LM-REPAIRS & MAINTENANCE 694.63 500.00 194.63 1,072.56 2,000.00 (927.44) 4,250.00 3,177.44 74.8%160,041.69 153,403.00 6,638.69 797,416.48 813,010.00 (15,593.52) 1,638,879.00 841,462.52 51.3% November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 11,022.00 15,650.00 (4,628.00) 67,121.47 92,300.00 (25,178.53) 227,391.00 160,269.53 70.5%6337842 Utilities-Water3,983.45 3,255.00 728.45 28,159.88 24,535.00 3,624.88 43,058.00 14,898.12 34.6%15,005.45 18,905.00 (3,899.55) 95,281.35 116,835.00 (21,553.65) 270,449.00 175,167.65 64.8%Silverrock ResortCourse Maintenance Expense StatementNovember 2011Annual BudgetMonth to Date Year to DateSilverrock ResortCourse Maintenance Water & EnergyNovember 2011Total-COURSE MAINTENANCETotal-CM-WATER & ENERGYMonth to Date Year to Date Annual Budget5 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group 423.88 662.00 (238.12) 2,210.16 3,310.00 (1,099.84) 7,944.00 5,733.84 72.2%6411325 Insurance-Workers Comp 352.20 445.00 (92.80) 1,920.96 1,597.00 323.96 5,096.00 3,175.04 62.3%6411800 Taxes-Employer Payroll 1,409.78 1,345.00 64.78 4,279.55 4,827.00 (547.45) 15,399.00 11,119.45 72.2%6411880 Wages-Hourly 11,926.34 10,802.00 1,124.34 39,452.74 38,775.00 677.74 123,689.00 84,236.26 68.1%6411882 Wages-Overtime 130.88 - 130.88 499.52 - 499.52 - (499.52) 0.0%Total-CBR-SALARIES & BENEFITS14,243.08 13,254.00 989.08 48,362.93 48,509.00 (146.07) 152,128.00 103,765.07 68.2%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 425.51 1,000.00 (574.49) 1,058.54 1,500.00 (441.46) 2,350.00 1,291.46 55.0%6413742 Supplies-Expendable 519.35 1,800.00 (1,280.65) 4,396.85 3,300.00 1,096.85 6,750.00 2,353.15 34.9%6413752 Supplies-Range Balls 7,745.85 9,000.00 (1,254.15) 7,745.85 9,000.00 (1,254.15) 9,000.00 1,254.15 13.9%6413762 Supplies-Office - 50.00 (50.00) - 175.00 (175.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 160.00 185.00 (25.00) 1,280.00 501.00 779.00 1,005.00 (275.00) -27.4%6413796 Supplies-Bottled Water- 50.00 (50.00) 11,774.71 12,200.00 (425.29) 24,500.00 12,725.29 51.9%Total-CBR-SUPPLIES & MATERIALS8,850.71 12,085.00 (3,234.29) 26,326.35 26,676.00 (349.65) 44,550.00 18,223.65 40.9%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment 251.15 300.00 (48.85) 1,074.68 1,500.00 (425.32) 3,600.00 2,525.32 70.1%6415695 CBR-R&M-Cart Maintenance & Repair (995.30) 750.00 (1,745.30) 2,274.42 4,500.00 (2,225.58) 9,750.00 7,475.58 76.7%Total-CBR-REPAIRS & MAINTENANCE (744.15) 1,050.00 (1,794.15) 3,349.10 6,000.00 (2,650.90) 13,350.00 10,000.90 74.9%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 447.62 800.00 (352.38) 4,023.10 4,000.00 23.10 9,600.00 5,576.90 58.1%6419220 Freight/Delivery - 75.00 (75.00) - 375.00 (375.00) 450.00 450.00 100.0%6419490 Miscellaneous 29.00 75.00 (46.00) 451.78 425.00 26.78 1,150.00 698.22 60.7%6419820 Uniforms 396.87 500.00 (103.13) 2,316.69 2,500.00 (183.31) 5,200.00 2,883.31 55.4%Total-CBR-OTHER EXPENSES 873.49 1,450.00 (576.51) 6,791.57 7,300.00 (508.43) 16,400.00 9,608.43 58.6%TOTAL-CARTS,BAGROOM & RANGE 23,223.13 27,839.00 (4,615.87) 84,829.95 88,485.00 (3,655.05) 226,428.00 141,598.05 62.5%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 147.20 173.00 (25.80) 1,182.00 455.00 727.00 1,805.00 623.00 34.5%6431800 Taxes-Employer Payroll 485.71 481.00 4.71 1,946.49 1,264.00 682.49 5,015.00 3,068.51 61.2%6431880 Wages-Hourly 4,223.33 4,200.00 23.33 14,461.33 11,040.00 3,421.33 43,800.00 29,338.67 67.0%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS4,856.24 4,854.00 2.24 17,589.82 12,759.00 4,830.82 50,620.00 33,030.18 65.3%643-CS-OTHER EXPENSES6433742 Supplies Expendable 194.49 100.00 94.49 629.14 400.00 229.14 1,050.00 420.86 40.1%6439490 Miscellaneous 31.37 50.00 (18.63) 31.37 100.00 (68.63) 200.00 168.63 84.3%6439718 Safety Equipment & Training - 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0%6439820 Uniforms 37.80 75.00 (37.20) 769.20 1,100.00 (330.80) 2,125.00 1,355.80 63.8%Total-CS-OTHER EXPENSES 263.66 275.00 (11.34) 1,429.71 1,850.00 (420.29) 3,975.00 2,545.29 64.0%Total-COURSE SERVICES 5,119.90 5,129.00 (9.10) 19,019.53 14,609.00 4,410.53 54,595.00 35,575.47 65.2%28,343.03 32,968.00 (4,624.97) 103,849.48 103,094.00 755.48 281,023.00 174,628.23 62.1%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementNovember 2011Annual Budget6 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable29.95 400.00 (370.05) 870.19 2,000.00 (1,129.81) 4,800.00 3,929.81 81.9%Total-CH-SUPPLIES & MATERIALS 29.95 400.00 (370.05) 870.19 2,000.00 (1,129.81) 4,800.00 3,929.81 81.9%65-CH-UTILITIES6507836 Utilities-Natural Gas328.97 300.00 28.97 1,504.05 1,500.00 4.05 3,600.00 2,095.95 58.2%6507840 Utilities-Telephone1,129.97 1,150.00 (20.03) 5,394.78 5,750.00 (355.22) 13,800.00 8,405.22 60.9%6507842 Utilities-Water97.24 321.00 (223.76) 1,797.59 1,605.00 192.59 3,852.00 2,054.41 53.3%6507844 Utilities-Cable336.89 340.00 (3.11) 1,684.45 1,700.00 (15.55) 4,080.00 2,395.55 58.7%Total-CH-UTILITIES 1,893.07 2,111.00 (217.93) 10,380.87 10,555.00 (174.13) 25,332.00 14,951.13 59.0%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 9,125.00 9,725.00 (600.00) 22,500.00 13,375.00 59.4%6509099 Contract Services-Security4,600.04 4,900.00 (299.96) 25,901.16 24,500.00 1,401.16 60,400.00 34,498.84 57.1%6509215 Flowers & Decorations- - - - 500.00 (500.00) 2,400.00 2,400.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 602.86 1,000.00 (397.14) 2,400.00 1,797.14 74.9%6509718 Safety Equipment & Training- 100.00 (100.00) - 500.00 (500.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES 6,425.04 7,025.00 (599.96) 35,629.02 36,225.00 (595.98) 88,900.00 53,270.98 59.9%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures296.00 300.00 (4.00) 2,853.61 1,500.00 1,353.61 3,600.00 746.39 20.7%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 526.00 2,000.00 (1,474.00) 4,800.00 4,274.00 89.0%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 688.87 2,000.00 (1,311.13) 4,800.00 4,111.13 85.6%Total-CH-REPAIRS & MAINTENANCE 296.00 1,100.00 (804.00) 4,068.48 5,500.00 (1,431.52) 13,200.00 9,131.52 69.2%8,644.06 10,636.00 (1,991.94) 50,948.56 54,280.00 (3,331.44) 132,232.00 18,263.04 13.8%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementNovember 2011Annual Budget7 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 373.07 331.00 42.07 1,318.67 1,655.00 (336.33) 3,972.00 2,653.33 66.8%6601325 Insurance-Workers Comp 87.20 103.00 (15.80) 786.72 515.00 271.72 1,240.00 453.28 36.6%6601720 Salaries 2,156.12 2,508.00 (351.88) 10,876.36 12,540.00 (1,663.64) 30,096.00 19,219.64 63.9%6601800 Taxes-Employer Payroll 197.28 287.00 (89.72) 965.24 1,435.00 (469.76) 3,446.00 2,480.76 72.0%Total-MKT-SALARIES & BENEFITS 2,813.67 3,229.00 (415.33) 13,946.99 16,145.00 (2,198.01) 38,754.00 24,807.01 64.0%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 500.00 (500.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery 274.46 200.00 74.46 3,040.54 3,400.00 (359.46) 4,425.00 1,384.46 31.3%274.46 300.00 (25.54) 3,040.54 3,900.00 (859.46) 5,625.00 2,584.46 45.9%66-MKT-UTILITIES6607840 Utilities-Telephone 142.81 100.00 42.81 334.49 500.00 (165.51) 1,200.00 865.51 72.1%Total-MKT-UTILITIES 142.81 100.00 42.81 334.49 500.00 (165.51) 1,200.00 865.51 72.1%66-MKT-OTHER EXPENSES6609010 Advertising 17,161.42 21,180.00 (4,018.58) 61,458.21 71,933.00 (10,474.79) 185,731.00 124,272.79 66.9%6609040 Business Meals - 25.00 (25.00) - 125.00 (125.00) 300.00 300.00 100.0%6609080 Collateral Material 1,731.03 1,000.00 731.03 2,417.03 3,500.00 (1,082.97) 9,000.00 6,582.97 73.1%6609102 Contract Services-Web Page 99.00 400.00 (301.00) 495.00 2,000.00 (1,505.00) 4,800.00 4,305.00 89.7%6609490 Miscellaneous 36.00 50.00 (14.00) 36.00 50.00 (14.00) 350.00 314.00 89.7%6609620 Postage 91.64 50.00 41.64 283.86 250.00 33.86 600.00 316.14 52.7%6609630 Promotion - 50.00 (50.00) - 100.00 (100.00) 3,500.00 3,500.00 0.0%6609633 Promotion-Community - 750.00 (750.00) - 1,725.00 (1,725.00) 2,925.00 2,925.00 100.0%6609634 Promotion-Media/Vendor - 1,000.00 (1,000.00) - 2,000.00 (2,000.00) 700.00 - 0.0%6609150 Dues and Subscriptions 24.76 - 24.76 124.76 - 124.76 735.00 610.24 83.0%6609820 Uniforms 352.61 50.00 302.61 352.61 350.00 2.61 600.00 247.39 41.2%Total-MKT-OTHER EXPENSES 19,496.46 24,555.00 (5,058.54) 65,167.47 82,033.00 (16,865.53) 209,241.00 143,373.53 68.5%22,727.40 28,184.00 (5,456.60) 82,489.49 102,578.00 (20,088.51) 254,820.00 171,630.51 67.4%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementNovember 2011Annual Budget8 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,819.51 1,458.00 361.51 13,241.68 7,290.00 5,951.68 17,496.00 4,254.32 24.3%6701325 Insurance-Workers Comp488.76 707.00 (218.24) 2,843.80 3,535.00 (691.20) 8,480.00 5,636.20 66.5%6701720 Salaries 15,652.30 14,833.34 818.96 72,895.01 74,166.70 (1,271.69) 178,000.00 105,104.99 59.0%6701800 Taxes-Employer Payroll 1,264.57 1,964.00 (699.43) 6,200.76 9,820.00 (3,619.24) 23,568.00 17,367.24 73.7%6701880 Wages-Hourly2,219.70 2,319.66 (99.96) 8,204.54 11,598.30 (3,393.76) 27,835.00 19,630.46 70.5%6701882 Wages-Overtime - - - 10.88 - 10.88 - (10.88) 0.0%Total-G&A-SALARIES & BENEFITS 21,444.84 21,282.00 162.84 103,396.67 106,410.00 (3,013.33) 255,379.00 151,982.33 59.5%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer204.58 400.00 (195.42) 878.82 2,000.00 (1,121.18) 5,200.00 4,321.18 83.1%6703762 Supplies-Office 36.09 100.00 (63.91) 447.21 500.00 (52.79) 1,200.00 752.79 62.7%6703768 Supplies-Printing & Stationery- 100.00 (100.00) 236.35 500.00 (263.65) 3,300.00 3,063.65 92.8%Total-G&A-SUPPLIES & MATERIALS 240.67 600.00 (359.33) 1,562.38 3,000.00 (1,437.62) 9,700.00 8,137.62 83.9%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 105.76 400.00 (294.24) 1,100.00 994.24 90.4%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 105.76 400.00 (294.24) 1,100.00 994.24 90.4%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 2,000.00 2,000.00 - 4,800.00 2,800.00 58.3%6709150 Dues & Subscriptions58.17 50.00 8.17 208.17 350.00 (141.83) 1,700.00 1,491.83 87.8%6709180 Employee Recruiting/Relocation112.00 200.00 (88.00) 336.00 600.00 (264.00) 1,400.00 1,064.00 76.0%6709197 Equipment Rental561.81 480.00 81.81 2,985.96 2,400.00 585.96 5,760.00 2,774.04 48.2%6709202 Fees-Bank58.65 90.00 (31.35) 371.75 450.00 (78.25) 1,080.00 708.25 65.6%6709208 Fees-Payroll Processing1,109.18 1,100.00 9.18 5,755.74 5,500.00 255.74 13,200.00 7,444.26 56.4%6709220 Freight/Delivery- 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0%6709490 Miscellaneous - 100.00 (100.00) 476.48 500.00 (23.52) 1,200.00 723.52 60.3%6709620 Postage/Mail Services 159.99 75.00 84.99 475.97 375.00 100.97 900.00 424.03 47.1%6709625 Professional Fees439.25 850.00 (410.75) 4,319.95 4,250.00 69.95 10,200.00 5,880.05 57.6%6709636 Promotion/Entertainment- 100.00 (100.00) - 500.00 (500.00) 3,100.00 3,100.00 100.0%6709722 Seminars & Training- 200.00 (200.00) 553.02 1,000.00 (446.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 139.70 150.00 (10.30) 277.20 525.00 (247.80) 1,050.00 772.80 73.6%Total-G&A-OTHER EXPENSES 3,038.75 3,845.00 (806.25) 17,984.62 18,800.00 (815.38) 48,490.00 30,505.38 62.9%24,724.26 25,827.00 (1,102.74) 123,049.43 128,610.00 (5,560.57) 314,669.00 191,619.57 60.9%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementNovember 2011Annual Budget9 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,091.63 12,075.00 (983.37) 55,458.15 60,375.00 (4,916.85) 144,900.00 89,441.85 61.7%6800194 Equipment Leases-Trailer 502.54 600.00 (97.46) 2,541.16 3,000.00 (458.84) 7,200.00 4,658.84 64.7%6800196 Equipment Leases-GPS 5,115.25 5,755.00 (639.75) 26,336.77 28,775.00 (2,438.23) 69,060.00 42,723.23 61.9%6800197 Equipment Leases-Others 2,099.62 1,160.00 939.62 12,775.94 5,800.00 6,975.94 13,920.00 1,144.06 0.0%18,809.04 19,590.00 (780.96) 97,112.02 97,950.00 (837.98) 235,080.00 137,967.98 58.7%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee (1,047.90) (5,453.00) 4,405.10 70,650.76 77,314.00 (6,663.24) 90,000.00 19,349.24 21.5%6900210 FF&E Reserve 7,535.28 7,009.00 526.28 14,347.91 13,825.00 522.91 66,540.00 52,192.09 78.4%6900800 Personal Property Taxes 382.85 - 382.85 12,353.92 14,800.00 (2,446.08) 14,800.00 2,446.08 16.5%6900323 Insurance-Commercial 407.81 2,200.00 (1,792.19) 11,798.64 11,000.00 798.64 26,400.00 14,601.36 55.3%7,278.04 3,756.00 3,522.04 109,151.23 116,939.00 (7,787.77) 197,740.00 88,588.77 44.8%Silverrock ResortOperating Leases & Miscellaneous Other Expense StatementNovember 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 14Sales4PromotionGolf Industry6VIPCelebrityPGA Comp64 60 50 5 38Charity/Gift Certificate214 4Rain/Wind Checks321 13Club Staff65 62 91 8 66LQ HS Golf2 4 12 11141 136 162 14 136 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-2012Nov-11 Date Time Description CategoryPlayers11/5/2011 9:45 Michael Dante Media 112