Loading...
04 October 2009 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2009 – October 2009 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 Revenue 33,504.00 29,881.00 3,623.00 12.1% 381,850.50 331,715.00 50,135.50 2,980,503.00 2,598,652.50 13%401000 Miscellaneous Golf Revenue 3,146.00 5,325.00 (2,179.00) -40.9% 18,334.60 22,872.00 (4,537.40) 109,297.00 90,962.40 17%410000 Revenue-Golf Shop 2,954.87 3,000.00 (45.13) -1.5% 34,493.99 43,551.00 (9,057.01) 325,551.00 291,057.01 11%420000 Revenue-F&B Concession 1,500.00 1,500.00 - 0.0% 3,000.00 3,000.00 - 12,000.00 9,000.00 25%890000 Interest Income 5.03 - 5.03 0.0% 21.89 - 21.89 - (21.89) 0%Total Income41,109.90 39,706.00 1,403.90 3.5% 437,700.98 401,138.00 36,562.98 3,427,351.00 2,989,650.02 13%Cost of Goods Sold510000 COS-Golf Shop 1,644.82 1,592.00 52.82 -3.3% 20,080.73 23,114.05 3,033.32 172,786.05 152,705.32 12%Total COS1,644.82 1,592.00 52.82 -3.3% 20,080.73 23,114.05 3,033.32 172,786.05 152,705.32 12%Gross Profit39,465.08 38,114.00 1,351.08 3.5% 417,620.25 378,023.95 39,596.30 3,254,564.95 2,836,944.70 13%Expenses610000 Golf Pro Shop 13,787.21 11,663.00 (2,124.21) -18.2% 54,214.79 68,957.00 14,742.21 243,485.00 189,270.21 22%630000 Course Maintenance 247,622.38 256,418.00 8,795.62 3.4% 619,459.33 645,378.00 25,918.67 1,594,579.00 975,119.67 39%633000 Maintenance Water & Energy 13,078.55 8,254.00 (4,824.55) -58.5% 38,950.49 29,761.00 (9,189.49) 86,871.00 47,920.51 45%640000 Outside Services 26,604.46 26,959.00 354.54 1.3% 73,163.69 76,583.00 3,419.31 277,000.00 203,836.31 26%650000 Clubhouse 11,595.36 10,342.00 (1,253.36) -12.1% 44,757.15 39,568.00 (5,189.15) 118,900.00 74,142.85 38%660000 Marketing 11,402.42 22,282.00 10,879.58 48.8% 58,680.41 58,163.00 (517.41) 256,759.00 198,078.59 23%670000 General & Administrative20,968.83 26,187.00 5,218.17 19.9% 86,992.63 103,423.00 16,430.37 316,394.00 229,401.37 27%680000 Leases 39,753.19 37,453.00 (2,300.19) -6.1% 159,252.66 149,812.00 (9,440.66) 432,204.00 272,951.34 37%690000 Miscellaneous Other Expense 18,261.95 19,759.00 1,497.05 7.6% 86,603.25 115,471.00 28,867.75 211,610.00 125,006.75 41%Total Expenses403,074.35 419,317.00 16,242.65 3.9% 1,222,074.40 1,287,116.00 65,041.60 3,537,802.00 2,315,727.60 35%Net Income (363,609.27) (381,203.00) 17,593.73 4.6%(804,454.15) (909,092.05) 104,637.90 (283,237.05) 521,217.10 284%Rounds of Golf PlayedPaid Rounds Played 596 500 96 19.2% 9,184 7,550 1,634 39,150 29,966 23%Ave $ Per Paid Round Green Fee 56.21 59.76 (3.55) -5.9% 41.58 43.94 (2.36) 76.13 34.55 55%Ave $ Per Paid Round Merchandise 4.96 6.00 (1.04) -17.4% 3.76 5.77 (2.01) 8.07 4.31 47%Ave $ Per Paid Miscellaneous 5.28 10.65 (5.37) -50.4% 2.00 3.03 (1.03) 2.06 - 0%Month to Date Year to DateOctober 2009SilverRock ResortSummary Operating Income Statement1 Income October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 33,504.00 29,881.00 3,623.00 381,850.50 331,715.00 50,135.50 2,980,503.002,598,652.5013%4010000 Rider Fee 100.00 50.00 50.00 3,175.00 2,669.00 506.00 5,829.002,654.0054%4040000 Club Rental 405.00 275.00 130.00 3,770.00 4,153.00 (383.00) 26,168.0022,398.0014%4050000 Driving Range 786.00 500.00 286.00 7,200.00 7,550.00 (350.00) 44,300.0037,100.0016%4060000 Handicap Fees 1,855.00 1,500.00 355.00 2,090.00 1,500.00 590.00 8,000.00 5,910.0026%4080000 GPS Advertising - 2,000.00 (2,000.00) - 5,000.00 (5,000.00) 12,000.00 12,000.000%4090000 Ball Retriever/Subcontract - 1,000.00 (1,000.00) 1,904.60 2,000.00 (95.40) 4,000.00 2,095.4048%4091000 Golf Professional Rental Fee - - - - - - 9,000.00 9,000.00 0%4092000 Golf Lessons - - - 195.00 - 195.00 - (195.00) 0% Total Revenue Fees 36,650.00 35,206.00 1,444.00 400,185.10 354,587.00 45,598.10 3,089,800.00 2,689,614.90 13%Total Income 36,650.00 35,206.00 1,444.00 400,185.10 354,587.00 45,598.10 3,089,800.00 2,689,614.90 13%SilverRock ResortStatement of Fees RevenueOctober 2009Month to Date Year to Date Annual Budget2 Income October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 223.00 - 223.00 1,225.21 - 1,225.21 4100110 Sales Hard Goods 1,940.96 1,050.00 890.96 18,529.08 15,243.00 3,286.08 113,943.00 95,413.92 16%4100112 Sales-Soft Goods 1,199.68 1,950.00 (750.32) 21,302.41 28,308.00 (7,005.59) 211,608.00 190,305.59 10%5100639 GS-Discounts-Mdse (408.77) - (408.77) (6,562.71) - (6,562.71) - 6,562.71 0% Total Revenue Golf Shop 2,954.87 3,000.00 (45.13) 34,493.99 43,551.00 (9,057.01) 325,551.00 292,282.22 10%COS 5100150 COS-GS-Hard Goods 559.31 577.50 (18.19) 10,284.42 8,383.65 1,900.77 62,668.65 52,384.23 16%5100151 COS-GS-Soft Goods 663.76 1,072.50 (408.74) 9,179.76 15,569.40 (6,389.64) 116,384.40 107,204.64 8%5100152 COS-GS-Purchase Disc 5.21 (83.00) 88.21 (94.24) (1,199.00) 1,104.76 (8,953.00) (8,858.76) -1%5100220 COS-GS-Freight Merch 416.54 25.00 391.54 710.79 360.00 350.79 2,686.00 1,975.21 26%Cost of Sales - Golf Shop 1,644.82 1,592.00 52.82 20,080.73 23,114.05 (3,033.32) 172,786.05 152,705.32 12%Gross Profit 1,310.05 1,408.00 (97.95) 14,413.26 20,436.95 (6,023.69) 152,764.95 139,576.90 9%COS % 55.7% 53.1% -2.6% 58.2% 53.1% -5.1% 53.1% 52.2% 2%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 480.00 480.00 - 1,620.00 1,620.00 - 5,400.00 3,780.00 30%6101320 Insurance Group 2,316.20 2,317.00 (0.80) 8,053.37 8,275.00 (221.63) 26,811.00 18,757.63 30%6101325 Insurance-Workers Comp 333.09 344.00 (10.91) 1,577.66 2,526.00 (948.34) 9,229.00 7,651.34 17%6101720 Salaries 3,545.46 3,582.00 (36.54) 14,181.84 14,328.00 (146.16) 20,796.00 6,614.16 68%6101800 Taxes-Employer Payroll 648.61 750.00 (101.39) 2,878.66 5,506.00 (2,627.34) 20,123.00 17,244.34 14%6101880 Wages-Hourly 4,703.03 2,445.00 2,258.03 21,335.39 29,897.00 (8,561.61) 140,831.00 119,495.61 15%6101882 Wages-Overtime 78.75 - 78.75 359.05 - 359.05 - 952.88 0%Total -PS-SALARIES & BENEFITS 12,105.14 9,918.00 2,187.14 50,005.97 62,152.00 (12,146.03) 223,190.00 174,495.96 22%61-PS OTHER EXPENSES6103762 Supplies-Office 272.33 500.00 (227.67) 411.58 1,400.00 (988.42) 2,950.00 2,538.42 14%6109090 Contract Services 500.00 500.00 - 2,000.00 2,000.00 - 6,000.00 4,000.00 33%6109220 Freight & Delivery 152.35 25.00 127.35 247.33 25.00 222.33 75.00 (172.33) 330%6109490 Miscellaneous - 50.00 (50.00) - 50.00 (50.00) 450.00 450.00 0%6109150 Dues and Subscriptions - - - - - - 2,000.00 2,000.00 0%6109500 ProShop-Over/Short 0.15 - 0.15 52.61 - 52.61 - (52.61) 0%6109722 Seminars/Training 174.00 500.00 (326.00) 174.00 2,650.00 (2,476.00) 5,490.00 5,316.00 3%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms 397.60 100.00 297.60 486.70 400.00 86.70 2,400.00 1,913.30 20%6117840 Telephones 185.64 70.00 115.64 836.60 280.00 556.60 840.00 3.40 0%Total PS-OTHER EXPENSES 1,682.07 1,745.00 (62.93) 4,208.82 6,805.00 (2,596.18) 20,295.00 16,086.18 21%Total Expenses13,787.21 11,663.00 2,124.21 54,214.79 68,957.00 (14,742.21) 243,485.00 190,582.14 22%Net Income(12,477.16) (10,255.00) (2,222.16) (39,801.53) (48,520.05) 8,718.52 (90,720.05) (51,005.24) -44%Month to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementOctober 20093 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 900.00 960.00 (60.00) 2,880.00 1,980.00 68.8%6311320 Insurance-Group 8,739.08 8,740.00 (0.92) 35,968.62 34,960.00 1,008.62 104,880.00 68,911.38 65.7%6311325 Insurance-Workers Comp 2,497.91 3,618.00 (1,120.09) 9,566.98 13,296.00 (3,729.02) 39,329.00 29,762.02 75.7%6311720 Salaries 11,001.60 12,331.00 (1,329.40) 44,006.40 49,324.00 (5,317.60) 147,972.00 103,965.60 70.3%6311800 Taxes-Employer Payroll 5,017.83 8,317.00 (3,299.17) 17,600.38 29,416.00 (11,815.62) 86,420.00 68,819.62 79.6%6311880 Wages-Hourly 41,973.91 44,159.00 (2,185.09) 165,475.24 176,636.00 (11,160.76) 529,928.00 364,452.76 68.8%6311882 Wages-Overtime 9,472.16 10,312.00 (839.84) 9,962.82 10,312.00 (349.18) 16,234.00 6,271.18 38.6%Total-CM-SALARIES & BENEFITS78,942.49 87,717.00 (8,774.51) 283,480.44 314,904.00 (31,423.56) 927,643.00 644,162.56 69.4%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 9,322.52 4,500.00 4,822.52 19,248.28 14,000.00 5,248.28 29,300.00 10,051.72 34.3%6313744 Fertilizer 17,536.76 16,600.00 936.76 53,898.26 43,200.00 10,698.26 92,200.00 38,301.74 41.5%6313745 Herbicides - 250.00 (250.00) - - - 10,000.00 10,000.00 100.0%6313746 Flowers/Plants 473.05 250.00 223.05 1,778.05 1,250.00 528.05 3,500.00 1,721.95 49.2%6313748 Fuel-Gasoline 4,796.91 6,500.00 (1,703.09) 15,728.11 17,450.00 (1,721.89) 43,100.00 27,371.89 63.5%6313750 Golf Course Accessories 10,137.06 6,000.00 4,137.06 11,031.80 6,600.00 4,431.80 8,000.00 (3,031.80) -37.9%6313756 POA Control 203.33 - 203.33 603.79 - 603.79 7,000.00 6,396.21 91.4%6313758 Miscellaneous Supp 501.76 500.00 1.76 1,846.09 2,750.00 (903.91) 4,350.00 2,503.91 0.0%6313762 Supplies-Office 64.33 - 64.33 342.66 - 342.66 - (342.66) 0.0%6313774 Sand 168.36 2,000.00 (1,831.64) 4,634.01 7,780.00 (3,145.99) - (4,634.01) 0.0%6313775 Sand-Bunkers 2,300.69 - 2,300.69 2,300.69 - 2,300.69 11,460.00 9,159.31 79.9%6313776 Seed 87,340.93 88,060.00 (719.07) 88,099.46 89,010.00 (910.54) 91,810.00 3,710.54 4.0%6313778 Small Tools & Non-Capital Equip 2,112.48 2,000.00 112.48 3,412.61 4,200.00 (787.39) 5,000.00 1,587.39 31.7%6313780 Sod - 250.00 (250.00) 6,652.46 3,250.00 3,402.46 5,750.00 (902.46) -15.7%6313782 Topdressing 1,088.00 2,500.00 (1,412.00) 3,089.98 5,000.00 (1,910.02) 7,600.00 4,510.02 59.3%Total-CM-SUPPLIES & MATERIALS136,046.18 129,410.00 6,636.18 212,666.25 194,490.00 18,176.25 319,070.00 106,403.75 33.3%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,679.84 500.00 1,179.84 8,798.95 6,000.00 2,798.95 17,000.00 8,201.05 48.2%6315685 CM-R&M-Bldngs & Othr Structures 90.50 - 90.50 827.98 750.00 77.98 1,750.00 922.02 52.7%6315690 CM-R&M-Equipment 7,294.80 10,000.00 (2,705.20) 21,353.31 23,200.00 (1,846.69) 35,700.00 14,346.69 40.2%6315692 CM-R&M-Irrigation System 1,768.73 2,000.00 (231.27) 10,708.39 8,400.00 2,308.39 16,050.00 5,341.61 33.3%6315696 CM-R&M-Pumps 120.82 1,000.00 (879.18) 6,084.80 4,000.00 2,084.80 10,500.00 4,415.20 42.0%6315815 CM-R&M-Trees-Pruning Etc 96.34 550.00 (453.66) 3,335.59 4,050.00 (714.41) 10,050.00 6,714.41 66.8%Total-CM-REPAIRS & MAINTENANCE 11,051.03 14,050.00 (2,998.97) 51,109.02 46,400.00 4,709.02 91,050.00 39,940.98 43.9%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs 5.38 - 5.38 20.25 - 20.25 (20.25) 0.0%6317836 Utilities-Natural Gas/LPG - 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 0.0%6317840 Telephones 793.44 850.00 (56.56) 3,375.35 3,400.00 (24.65) 10,200.00 6,824.65 66.9%Total-CM-UTILITIES 798.82 900.00 (101.18) 3,395.60 3,600.00 (204.40) 10,800.00 7,404.40 68.6%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%6319099 Contract Svcs-Security Bldgs - - - 210.00 - 210.00 (210.00) 0.0%6319100 Contract Svcs-Soil/Tissue Test - - - 1,500.00 2,000.00 (500.00) 4,000.00 2,500.00 62.5%6319101 Contract Svcs-Trash Removal 975.66 524.00 451.66 2,439.15 2,096.00 343.15 6,288.00 3,848.85 0.0%6319150 Dues & Subscriptions - - - 18.00 200.00 (182.00) 900.00 882.00 98.0%6319170 Employee Education - 50.00 (50.00) - 200.00 (200.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental 1,981.25 1,800.00 181.25 2,442.50 2,300.00 142.50 4,200.00 1,757.50 41.8%6319206 Licenses & Permits 114.05 - 114.05 228.10 280.00 (51.90) 680.00 451.90 66.5%6319490 Miscellaneous - 100.00 (100.00) 354.12 400.00 (45.88) 1,200.00 845.88 70.5%6319718 Safety Equipment & Training 827.00 200.00 627.00 1,719.59 1,300.00 419.59 2,600.00 880.41 33.9%6319822 Uniforms 1,016.83 820.00 196.83 3,579.98 3,280.00 299.98 9,840.00 6,260.02 63.6%Total-CM-OTHER EXPENSES 5,414.79 3,994.00 1,420.79 14,491.44 14,056.00 435.44 37,258.00 22,766.56 61.1%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementOctober 2009Annual Budget4 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,317.00 2,317.00 - 7,488.75 9,268.00 (1,779.25) 27,804.00 20,315.25 73.1%6321325 Insurance-Workers Comp 462.14 777.00 (314.86) 1,785.34 2,815.00 (1,029.66) 8,229.00 6,443.66 78.3%6321800 Taxes-Employer Payroll 883.85 1,812.00 (928.15) 3,150.27 6,287.00 (3,136.73) 18,154.00 15,003.73 82.6%6321880 Wages-Hourly 9,631.38 11,712.00 (2,080.62) 39,008.18 46,848.00 (7,839.82) 140,544.00 101,535.82 72.2%6321882 Wages-Overtime 1,922.24 2,839.00 (916.76) 2,171.73 3,650.00 (1,478.27) 5,272.00 3,100.27 58.8%Total-CM-LM-SALARIES & BENEFITS15,216.61 19,457.00 (4,240.39) 53,604.27 68,868.00 (15,263.73) 200,003.00 146,398.73 73.2%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 152.46 290.00 (137.54) 712.31 1,160.00 (447.69) 3,480.00 2,767.69 79.5%Total-CM-LM-SUPPLIES & MATERIALS152.46 390.00 (237.54) 712.31 1,560.00 (847.69) 4,505.00 3,792.69 84.2%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 500.00 (500.00) - 1,500.00 (1,500.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE - 500.00 (500.00) - 1,500.00 (1,500.00) 4,250.00 4,250.00 100.0%247,622.38 256,418.00 (8,795.62) 619,459.33 645,378.00 (25,918.67) 1,594,579.00 975,119.67 61.2% October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 2,415.59 5,000.00 (2,584.41) 11,828.05 20,000.00 (8,171.95) 65,000.00 53,171.95 81.8%6337842 Utilities-Water10,662.96 3,254.00 7,408.96 27,122.44 9,761.00 17,361.44 21,871.00 (5,251.44) -24.0%Total-CM-WATER & ENERGY 13,078.55 8,254.00 4,824.55 38,950.49 29,761.00 9,189.49 86,871.00 47,920.51 55.2%Silverrock ResortCourse Maintenance Expense StatementOctober 2009Annual BudgetMonth to DateMonth to Date Year to Date Annual BudgetYear to DateSilverrock ResortCourse Maintenance Water & EnergyOctober 2009Total -COURSE MAINTENANCE5 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 540.00 540.00 - 1,800.00 1,800.00 - 6,960.00 5,160.00 74.1%6411320 Insurance-Group 661.10 662.00 (0.90) 1,259.60 2,648.00 (1,388.40) 7,944.00 6,684.40 84.1%6411325 Insurance-Workers Comp 167.25 361.00 (193.75) 1,185.23 3,655.00 (2,469.77) 16,162.00 14,976.77 92.7%6411800 Taxes-Employer Payroll 347.07 313.00 34.07 2,929.60 3,169.00 (239.40) 14,012.00 11,082.40 79.1%6411880 Wages-Hourly 4,181.27 2,516.00 1,665.27 26,802.81 25,456.00 1,346.81 112,549.00 85,746.19 76.2%6411882 Wages-Overtime - - - 511.32 - 511.32 - (511.32) 0.0%Total-CBR-SALARIES & BENEFITS5,896.69 4,392.00 1,504.69 34,488.56 36,728.00 (2,239.44) 157,627.00 123,138.44 78.1%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 1,009.24 500.00 509.24 1,327.81 500.00 827.81 2,350.00 1,022.19 43.5%6413742 Supplies-Expendable - 150.00 (150.00) 2,352.00 600.00 1,752.00 5,000.00 2,648.00 53.0%6413752 Supplies-Range Balls 143.75 - 143.75 143.75 - 143.75 6,000.00 5,856.25 97.6%6413762 Supplies-Office - 50.00 (50.00) - 125.00 (125.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary 131.08 - 131.08 131.08 - 131.08 420.00 288.92 68.8%6413786 Supplies-Towels 779.61 100.00 679.61 779.61 316.00 463.61 892.00 112.39 12.6%6413796 Supplies-Bottled Water12,758.46 15,000.00 (2,241.54) 13,814.11 16,200.00 (2,385.89) 19,400.00 5,585.89 28.8%Total-CBR-SUPPLIES & MATERIALS14,822.14 15,800.00 (977.86) 18,548.36 17,741.00 807.36 34,587.00 16,038.64 46.4%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts 720.00 720.00 - 2,880.00 2,880.00 - 8,640.00 5,760.00 66.7%6415690 CBR-R&M-Equipment 69.60 300.00 (230.40) 561.35 1,200.00 (638.65) 3,600.00 3,038.65 84.4%6415695 CBR-R&M-Cart Maintenance & Repair 871.04 500.00 371.04 1,648.64 2,000.00 (351.36) 4,000.00 2,351.36 58.8%Total-CBR-REPAIRS & MAINTENANCE 1,660.64 1,520.00 140.64 5,089.99 6,080.00 (990.01) 16,240.00 11,150.01 68.7%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps 140.00 400.00 (260.00) 895.00 700.00 195.00 5,000.00 4,105.00 82.1%6419094 Contract Services-Laundry/Linen - 500.00 (500.00) 2,683.64 2,000.00 683.64 6,000.00 3,316.36 55.3%6419220 Freight/Delivery - 75.00 (75.00) - 300.00 (300.00) 900.00 900.00 100.0%6419490 Miscellaneous 509.66 75.00 434.66 509.66 350.00 159.66 1,150.00 640.34 55.7%6419820 Uniforms 1,588.92 2,500.00 (911.08) 1,588.92 2,500.00 (911.08) 5,625.00 4,036.08 71.8%Total-CBR-OTHER EXPENSES 2,238.58 3,550.00 (1,311.42) 5,677.22 5,850.00 (172.78) 18,675.00 12,997.78 69.6%TOTAL-CARTS,BAGROOM & RANGE 24,618.05 25,262.00 (643.95) 63,804.13 66,399.00 (2,594.87) 227,129.00 163,324.87 71.9%643-CS-SALARIES & BENEFITS6431175 Employee Meals 180.00 180.00 - 720.00 720.00 - 3,300.00 2,580.00 78.2%6431325 Insurance-Workers Comp 32.32 27.00 5.32 294.15 382.00 (87.85) 2,069.00 1,774.85 85.8%6431800 Taxes-Employer Payroll 79.89 60.00 19.89 799.21 837.00 (37.79) 4,512.00 3,712.79 82.3%6431880 Wages-Hourly 808.00 480.00 328.00 6,660.00 6,720.00 (60.00) 36,240.00 29,580.00 81.6%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS1,100.21 747.00 353.21 8,473.36 8,659.00 (185.64) 46,121.00 37,647.64 81.6%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) - 300.00 (300.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous - 50.00 (50.00) - 50.00 (50.00) 200.00 200.00 100.0%6439718 Safety Equipment & Training 87.00 50.00 37.00 87.00 200.00 (113.00) 600.00 513.00 85.5%6439820 Uniforms 799.20 750.00 49.20 799.20 975.00 (175.80) 1,900.00 1,100.80 57.9%Total-CS-OTHER EXPENSES 886.20 950.00 (63.80) 886.20 1,525.00 (638.80) 3,750.00 2,863.80 76.4%Total-COURSE SERVICES 1,986.41 1,697.00 289.41 9,359.56 10,184.00 (824.44) 49,871.00 40,511.44 81.2%TOTAL OUTSIDE SERVICES 26,604.46 26,959.00 (354.54) 73,163.69 76,583.00 (3,419.31) 277,000.00 200,972.51 72.6%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementOctober 2009Annual Budget6 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) - 1,600.00 (1,600.00) 4,800.00 4,800.00 100.0%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) - 1,600.00 (1,600.00) 4,800.00 4,800.00 100.0%65-CH-UTILITIES6507836 Utilities-Natural Gas350.18 300.00 50.18 831.41 1,200.00 (368.59) 3,600.00 2,768.59 76.9%6507838 Utilities-Sewer- 200.00 (200.00) - 800.00 (800.00) 2,400.00 2,400.00 100.0%6507840 Utilities-Telephone984.67 1,000.00 (15.33) 4,834.99 4,000.00 834.99 12,000.00 7,165.01 59.7%6507842 Utilities-Water1,073.25 200.00 873.25 2,674.89 800.00 1,874.89 2,400.00 (274.89) -11.5%6507844 Utilities-Cable527.99 317.00 210.99 1,500.83 1,268.00 232.83 3,800.00 2,299.17 60.5%Total-CH-UTILITIES 2,936.09 2,017.00 919.09 9,842.12 8,068.00 1,774.12 24,200.00 14,357.88 59.3%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning2,045.00 2,425.00 (380.00) 7,715.00 7,900.00 (185.00) 22,500.00 14,785.00 65.7%6509098 Contract Services-Refuse Dispose582.68 - 582.68 1,456.70 - 1,456.70 - (1,456.70) 0.0%6509099 Contract Services-Security4,565.04 4,100.00 465.04 20,199.64 16,400.00 3,799.64 49,200.00 29,000.36 58.9%6509215 Flowers & Decorations- 100.00 (100.00) - 400.00 (400.00) 2,600.00 2,600.00 100.0%6509490 Miscellaneous28.55 200.00 (171.45) 28.55 800.00 (771.45) 2,400.00 2,371.45 98.8%6509718 Safety Equipment & Training- 100.00 (100.00) 223.86 400.00 (176.14) 1,200.00 976.14 81.3%Total-CH-OTHER EXPENSES 7,221.27 6,925.00 296.27 29,623.75 25,900.00 3,723.75 77,900.00 48,276.25 62.0%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures738.00 200.00 538.00 2,979.78 800.00 2,179.78 2,400.00 (579.78) -24.2%6515686 CH-R&M-Restaurant Repairs700.00 400.00 300.00 2,176.50 1,600.00 576.50 4,800.00 2,623.50 54.7%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 135.00 1,600.00 (1,465.00) 4,800.00 4,665.00 97.2%Total-CH-REPAIRS & MAINTENANCE 1,438.00 1,000.00 438.00 5,291.28 4,000.00 1,291.28 12,000.00 6,708.72 55.9%Total CLUBHOUSE 11,595.36 10,342.00 1,253.36 44,757.15 39,568.00 5,189.15 118,900.00 13,417.44 11.3%Month to Date Year to DateSilverRock ResortClubhouse Expense StatementOctober 2009Annual Budget7 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 240.00 240.00 - 720.00 480.00 66.7%6601320 Insurance-Group 330.60 331.00 (0.40) 1,233.12 1,324.00 (90.88) 3,972.00 2,738.88 69.0%6601325 Insurance-Workers Comp 101.30 143.00 (41.70) 439.80 572.00 (132.20) 1,713.00 1,273.20 74.3%6601720 Salaries 2,500.00 2,500.00 - 10,000.00 10,000.00 - 30,000.00 20,000.00 66.7%6601800 Taxes-Employer Payroll 311.00 311.00 - 1,244.00 1,244.00 - 3,735.00 2,491.00 66.7%Total-MKT-SALARIES & BENEFITS 3,302.90 3,345.00 (42.10) 13,156.92 13,380.00 (223.08) 40,140.00 26,983.08 67.2%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 140.15 400.00 (259.85) 1,200.00 1,059.85 88.3%6603768 Supplies-Printing & Stationery - 3,000.00 (3,000.00) 187.43 3,200.00 (3,012.57) 4,425.00 4,237.57 95.8%- 3,100.00 (3,100.00) 327.58 3,600.00 (3,272.42) 5,625.00 5,297.42 94.2%66-MKT-UTILITIES6607840 Utilities-Telephone 167.82 100.00 67.82 309.45 400.00 (90.55) 1,200.00 890.55 74.2%Total-MKT-UTILITIES 167.82 100.00 67.82 309.45 400.00 (90.55) 1,200.00 890.55 74.2%66-MKT-OTHER EXPENSES6609010 Advertising 7,705.22 11,387.00 (3,681.78) 43,891.45 34,958.00 8,933.45 185,984.00 142,092.55 76.4%6609040 Business Meals 25.00 25.00 - 25.00 100.00 (75.00) 300.00 275.00 91.7%6609080 Collateral Material - 2,500.00 (2,500.00) 163.11 2,500.00 (2,336.89) 9,000.00 8,836.89 98.2%6609102 Contract Services-Web Page 99.00 175.00 (76.00) 471.00 700.00 (229.00) 2,100.00 1,629.00 77.6%6609490 Miscellaneous - - - - - - 350.00 350.00 100.0%6609620 Postage 102.48 50.00 52.48 102.48 200.00 (97.52) 600.00 497.52 82.9%6609630 Promotion - 50.00 (50.00) - 50.00 (50.00) 700.00 700.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) 93.42 1,000.00 (906.58) 6,500.00 - 0.0%6609150 Dues and Subscriptions - - - 140.00 - 140.00 735.00 595.00 81.0%6609820 Uniforms - 300.00 (300.00) - 300.00 (300.00) 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 7,931.70 15,737.00 (7,805.30) 44,886.46 40,783.00 4,103.46 209,794.00 158,500.96 75.6%Total-MARKETING 11,402.42 22,282.00 (10,879.58) 58,680.41 58,163.00 517.41 256,759.00 191,672.01 74.7%Month to Date Year to DateSilverRock ResortMarketing Expense StatementOctober 2009Annual Budget8 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 720.00 720.00 - 2,160.00 1,440.00 66.7%6701320 Insurance-Group1,457.67 1,458.00 (0.33) 5,223.04 5,832.00 (608.96) 17,496.00 12,272.96 70.1%6701325 Insurance-Workers Comp580.37 981.00 (400.63) 2,676.85 3,924.00 (1,247.15) 11,772.00 9,095.15 77.3%6701720 Salaries 13,459.79 14,534.00 (1,074.21) 53,969.75 58,136.00 (4,166.25) 174,408.00 120,438.25 69.1%6701800 Taxes-Employer Payroll 1,109.95 2,140.00 (1,030.05) 4,680.12 8,560.00 (3,879.88) 25,680.00 20,999.88 81.8%6701880 Wages-Hourly1,049.37 2,654.00 (1,604.63) 7,208.30 10,616.00 (3,407.70) 31,848.00 24,639.70 77.4%6701882 Wages-Overtime - - - 5.91 - 5.91 - (5.91) 0.0%Total-G&A-SALARIES & BENEFITS 17,837.15 21,947.00 (4,109.85) 74,483.97 87,788.00 (13,304.03) 263,364.00 188,880.03 71.7%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer820.16 800.00 20.16 1,199.16 3,200.00 (2,000.84) 10,800.00 9,600.84 88.9%6703762 Supplies-Office - 125.00 (125.00) 710.05 500.00 210.05 1,500.00 789.95 52.7%6703768 Supplies-Printing & Stationery142.99 100.00 42.99 226.69 300.00 (73.31) 3,200.00 2,973.31 92.9%6703778Supplies-Small Tools/Non-Capital - 100.00 (100.00) - 200.00 (200.00) 900.00 900.00 100.0%Total-G&A-SUPPLIES & MATERIALS 963.15 1,125.00 (161.85) 2,135.90 4,200.00 (2,064.10) 16,400.00 14,264.10 87.0%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 297.97 400.00 (102.03) 1,200.00 902.03 75.2%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 297.97 400.00 (102.03) 1,200.00 902.03 75.2%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) - 300.00 (300.00) 1,500.00 1,500.00 100.0%6709180 Employee Recruiting/Relocation84.00 500.00 (416.00) 196.00 1,000.00 (804.00) 2,600.00 2,404.00 92.5%6709197 Equipment Rental535.36 350.00 185.36 2,045.28 1,400.00 645.28 4,200.00 2,154.72 51.3%6709202 Fees-Bank46.04 90.00 (43.96) 196.83 360.00 (163.17) 1,080.00 883.17 81.8%6709208 Fees-Payroll Processing556.78 550.00 6.78 2,599.39 2,200.00 399.39 6,600.00 4,000.61 60.6%6709220 Freight/Delivery- 50.00 (50.00) 88.29 200.00 (111.71) 600.00 511.71 85.3%6709490 Miscellaneous 32.35 100.00 (67.65) 278.39 400.00 (121.61) 1,200.00 921.61 76.8%6709620 Postage/Mail Services - 75.00 (75.00) 415.10 300.00 115.10 900.00 484.90 53.9%6709625 Professional Fees285.00 400.00 (115.00) 1,950.04 1,600.00 350.04 4,800.00 2,849.96 59.4%6709636 Promotion/Entertainment- 100.00 (100.00) 134.78 400.00 (265.22) 2,600.00 2,465.22 94.8%6709722 Seminars & Training229.00 200.00 29.00 479.00 800.00 (321.00) 2,400.00 1,921.00 80.0%6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms - 150.00 (150.00) 91.69 375.00 (283.31) 1,050.00 958.31 91.3%Total-G&A-OTHER EXPENSES 2,168.53 3,015.00 (846.47) 10,074.79 11,035.00 (960.21) 35,430.00 25,355.21 71.6%Total-GENERAL & ADMINISTRATIVE20,968.83 26,187.00 (5,218.17) 86,992.63 103,423.00 (16,430.37) 316,394.00 229,401.37 72.5%Month to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementOctober 2009Annual Budget9 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,581.04 11,581.00 0.04 46,324.16 46,324.00 0.16 138,972.00 92,647.84 66.7%6800193 Equipment Leases-Course Maint 16,244.12 16,500.00 (255.88) 64,976.48 66,000.00 (1,023.52) 189,000.00 124,023.52 65.6%6800194 Equipment Leases-Trailer 540.00 600.00 (60.00) 2,169.50 2,400.00 (230.50) 7,200.00 5,030.50 69.9%6800195 Equipment Leases-Software 1,791.93 1,372.00 419.93 7,167.72 5,488.00 1,679.72 8,232.00 1,064.28 12.9%6800196 Equipment Leases-GPS 6,840.14 7,400.00 (559.86) 28,078.37 29,600.00 (1,521.63) 88,800.00 60,721.63 68.4%6800197 Equipment Leases-Others 2,755.96 - 2,755.96 10,536.43 - 10,536.43 - - 0.0%Total-LEASES 39,753.19 37,453.00 2,300.19 159,252.66 149,812.00 9,440.66 432,204.00 283,487.77 65.6%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 15,531.88 15,661.00 (129.12) 64,534.44 74,836.00 (10,301.56) 90,000.00 25,465.56 28.3%6900210 FF&E Reserve 670.08 598.00 72.08 7,637.01 6,635.00 1,002.01 59,610.00 51,972.99 87.2%6900800 Personal Property Taxes 2,059.99 - 2,059.99 10,777.70 20,000.00 (9,222.30) 20,000.00 9,222.30 46.1%6900323 Insurance-Commercial - 3,500.00 (3,500.00) 3,654.10 14,000.00 (10,345.90) 42,000.00 38,345.90 91.3%Total-MISC OTHER EXPENSES18,261.95 19,759.00 (1,497.05) 86,603.25 115,471.00 (28,867.75) 211,610.00 125,006.75 59.1%Silverrock ResortOperating Leases & Miscellaneous Other Expense StatementOctober 2009Annual BudgetMonth to Date Year to Date10 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2009-20102009 2009 2009 2009 2009 2009Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia74SalesPromotionGolf Industry81711VIPCelebrityPGA Comp70 68 67 9Charity/Gift Certificate14 10 4Rain/Wind Checks35Club Staff69 105 91 6LQ HS Golf39161 200 227 19 0 02010 2010 2010 2010 2010 2010Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011