Loading...
03 September 2009 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2009 – September 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 September Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 165,762.00 143,143.00 22,619.00 15.8% 348,346.50 301,834.00 46,512.50 2,980,503.00 2,632,156.50 12%401000 Miscellaneous Golf Revenue 5,824.00 6,115.00 (291.00) -4.8% 15,188.60 17,547.00 (2,358.40) 109,297.00 94,108.40 14%410000 Revenue-Golf Shop 14,865.30 21,700.00 (6,834.70) -31.5% 31,539.12 40,551.00 (9,011.88) 325,551.00 294,011.88 10%420000 Revenue-F&B Concession 500.00 500.00 - 0.0% 1,500.00 1,500.00 - 12,000.00 10,500.00 13%890000 Interest Income 5.35 - 5.35 0.0% 16.86 - 16.86 - (16.86) 0%Total Income186,956.65 171,458.00 15,498.65 9.0% 396,591.08 361,432.00 35,159.08 3,427,351.00 3,030,759.92 12%Cost of Goods Sold510000 COS-Golf Shop 8,709.75 11,517.00 (2,807.25) 24.4% 18,435.91 21,522.05 3,086.14 172,786.05 154,350.14 11%Total COS8,709.75 11,517.00 (2,807.25) 24.4% 18,435.91 21,522.05 3,086.14 172,786.05 154,350.14 11%Gross Profit178,246.90 159,941.00 18,305.90 11.4% 378,155.17 339,909.95 38,245.22 3,254,564.95 2,876,409.78 12%Expenses610000 Golf Pro Shop 13,440.43 20,270.00 6,829.57 33.7% 40,427.58 57,294.00 16,866.42 243,485.00 203,057.42 17%630000 Course Maintenance 136,870.45 141,642.00 4,771.55 3.4% 371,836.95 389,399.00 17,562.05 1,594,579.00 1,222,742.05 23%633000 Maintenance Water & Energy 9,225.18 8,034.00 (1,191.18) -14.8% 25,871.94 21,507.00 (4,364.94) 86,871.00 60,999.06 30%640000 Outside Services 17,543.12 15,928.00 (1,615.12) -10.1% 46,559.23 49,624.00 3,064.77 277,000.00 230,440.77 17%650000 Clubhouse 11,387.51 9,742.00 (1,645.51) -16.9% 33,161.79 29,226.00 (3,935.79) 118,900.00 85,738.21 28%660000 Marketing 27,405.34 20,777.00 (6,628.34) -31.9% 47,277.99 35,881.00 (11,396.99) 256,759.00 209,481.01 18%670000 General & Administrative22,902.30 26,262.00 3,359.70 12.8% 66,023.80 77,236.00 11,212.20 316,394.00 250,370.20 21%680000 Leases 39,572.95 37,453.00 (2,119.95) -5.7% 119,499.47 112,359.00 (7,140.47) 432,204.00 312,704.53 28%690000 Miscellaneous Other Expense 15,311.98 17,157.00 1,845.02 10.8% 68,341.30 95,712.00 27,370.70 211,610.00 143,268.70 32%Total Expenses293,659.26 297,265.00 3,605.74 1.2% 819,000.05 868,238.00 49,237.95 3,537,802.00 2,718,801.95 23%Net Income (115,412.36) (137,324.00) 21,911.64 16.0%(440,844.88) (528,328.05) 87,483.17 (283,237.05) 157,607.83 156%Rounds of Golf PlayedPaid Rounds Played 3,539 3,100 439 14.2% 8,592 7,050 1,542 39,150 30,558 22%Ave $ Per Paid Round Green Fee 46.84 46.18 0.66 1.4% 40.54 42.81 (2.27) 76.13 35.59 53%Ave $ Per Paid Round Merchandise 4.20 7.00 (2.80) -40.0% 3.67 5.75 (2.08) 8.07 4.40 45%Ave $ Per Paid Miscellaneous 1.65 1.97 (0.33) -16.6% 1.77 2.49 (0.72) 2.06 - 0%Month to Date Year to DateSeptember 2009SilverRock ResortSummary Operating Income Statement1 Income September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 165,762.00 143,143.00 22,619.00 348,346.50 301,834.00 46,512.50 2,980,503.002,632,156.5012%4010000 Rider Fee 1,375.00 310.00 1,065.00 3,075.00 2,619.00 456.00 5,829.002,754.0053%4040000 Club Rental 1,735.00 1,705.00 30.00 3,365.00 3,878.00 (513.00) 26,168.0022,803.0013%4050000 Driving Range 2,639.00 3,100.00 (461.00) 6,414.00 7,050.00 (636.00) 44,300.0037,886.0014%4060000 Handicap Fees - - - 235.00 - 235.00 8,000.00 7,765.003%4080000 GPS Advertising - 1,000.00 (1,000.00) - 3,000.00 (3,000.00) 12,000.00 12,000.000%4090000 Ball Retriever/Subcontract - - - 1,904.60 1,000.00 904.60 4,000.00 2,095.4048%4091000 Golf Professional Rental Fee - - - - - - 9,000.00 9,000.00 0%4092000 Golf Lessons 75.00 - 75.00 195.00 - 195.00 - (195.00) 0% Total Revenue Fees 171,586.00 149,258.00 22,328.00 363,535.10 319,381.00 44,154.10 3,089,800.00 2,726,264.90 12%Total Income 171,586.00 149,258.00 22,328.00 363,535.10 319,381.00 44,154.10 3,089,800.00 2,726,264.90 12%Month to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueSeptember 20092 Income September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 576.83 - 576.83 1,002.21 - 1,002.21 4100110 Sales Hard Goods 8,246.32 7,595.00 651.32 16,588.12 14,193.00 2,395.12 113,943.00 97,354.88 15%4100112 Sales-Soft Goods 8,953.39 14,105.00 (5,151.61) 20,102.73 26,358.00 (6,255.27) 211,608.00 191,505.27 9%5100639 GS-Discounts-Mdse (2,911.24) - (2,911.24) (6,153.94) - (6,153.94) - 6,153.94 0% Total Revenue Golf Shop 14,865.30 21,700.00 (6,834.70) 31,539.12 40,551.00 (9,011.88) 325,551.00 295,014.09 9%COS 5100150 COS-GS-Hard Goods 4,940.24 4,177.25 762.99 9,725.11 7,806.15 1,918.96 62,668.65 52,943.54 16%5100151 COS-GS-Soft Goods 3,706.97 7,757.75 (4,050.78) 8,516.00 14,496.90 (5,980.90) 116,384.40 107,868.40 7%5100152 COS-GS-Purchase Disc (20.50) (597.00) 576.50 (99.45) (1,116.00) 1,016.55 (8,953.00) (8,853.55) -1%5100220 COS-GS-Freight Merch 83.04 179.00 (95.96) 294.25 335.00 (40.75) 2,686.00 2,391.75 11%Cost of Sales - Golf Shop 8,709.75 11,517.00 (2,807.25) 18,435.91 21,522.05 (3,086.14) 172,786.05 154,350.14 11%Gross Profit 6,155.55 10,183.00 (4,027.45) 13,103.21 19,028.95 (5,925.74) 152,764.95 140,663.95 8%COS % 58.6% 53.1% -5.5% 58.5% 53.1% -5.4% 53.1% 52.3% 1%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 420.00 420.00 - 1,140.00 1,140.00 - 5,400.00 4,260.00 21%6101320 Insurance Group 1,886.01 1,986.00 (99.99) 5,737.17 5,958.00 (220.83) 26,811.00 21,073.83 21%6101325 Insurance-Workers Comp 356.17 756.00 (399.83) 1,244.57 2,182.00 (937.43) 9,229.00 7,984.43 13%6101720 Salaries 3,545.46 3,582.00 (36.54) 10,636.38 10,746.00 (109.62) 20,796.00 10,159.62 51%6101800 Taxes-Employer Payroll 750.78 1,648.00 (897.22) 2,230.05 4,756.00 (2,525.95) 20,123.00 17,892.95 11%6101880 Wages-Hourly 5,214.97 9,658.00 (4,443.03) 16,632.36 27,452.00 (10,819.64) 140,831.00 124,198.64 12%6101882 Wages-Overtime 143.82 - 143.82 280.30 - 280.30 - 952.88 0%Total -PS-SALARIES & BENEFITS 12,317.21 18,050.00 (5,732.79) 37,900.83 52,234.00 (14,333.17) 223,190.00 186,522.35 16%61-PS OTHER EXPENSES6103762 Supplies-Office 29.26 300.00 (270.74) 139.25 900.00 (760.75) 2,950.00 2,810.75 5%6109090 Contract Services 500.00 500.00 - 1,500.00 1,500.00 - 6,000.00 4,500.00 25%6109220 Freight & Delivery 28.29 - 28.29 94.98 - 94.98 75.00 (19.98) 127%6109490 Miscellaneous - - - - - - 450.00 450.00 0%6109150 Dues and Subscriptions - - - - - - 2,000.00 2,000.00 0%6109500 ProShop-Over/Short 1.68 - 1.68 52.46 - 52.46 - (52.46) 0%6109722 Seminars/Training - 1,250.00 (1,250.00) - 2,150.00 (2,150.00) 5,490.00 5,490.00 0%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms 89.10 100.00 (10.90) 89.10 300.00 (210.90) 2,400.00 2,310.90 4%6117840 Telephones 474.89 70.00 404.89 650.96 210.00 440.96 840.00 189.04 0%Total PS-OTHER EXPENSES 1,123.22 2,220.00 (1,096.78) 2,526.75 5,060.00 (2,533.25) 20,295.00 17,768.25 12%Total Expenses13,440.43 20,270.00 (6,829.57) 40,427.58 57,294.00 (16,866.42) 243,485.00 204,290.60 16%Net Income(7,284.88) (10,087.00) 2,802.12 (27,324.37) (38,265.05) 10,940.68 (90,720.05) (63,626.65) -30%Month to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementSeptember 20093 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 660.00 720.00 (60.00) 2,880.00 2,220.00 77.1%6311320 Insurance-Group 8,748.00 8,740.00 8.00 27,229.54 26,220.00 1,009.54 104,880.00 77,650.46 74.0%6311325 Insurance-Workers Comp 2,110.36 3,226.00 (1,115.64) 7,069.07 9,678.00 (2,608.93) 39,329.00 32,259.93 82.0%6311720 Salaries 11,001.60 12,331.00 (1,329.40) 33,004.80 36,993.00 (3,988.20) 147,972.00 114,967.20 77.7%6311800 Taxes-Employer Payroll 4,297.31 7,033.00 (2,735.69) 12,582.55 21,099.00 (8,516.45) 86,420.00 73,837.45 85.4%6311880 Wages-Hourly 41,757.44 44,159.00 (2,401.56) 123,501.33 132,477.00 (8,975.67) 529,928.00 406,426.67 76.7%6311882 Wages-Overtime - - - 490.66 - 490.66 16,234.00 15,743.34 97.0%Total-CM-SALARIES & BENEFITS68,154.71 75,729.00 (7,574.29) 204,537.95 227,187.00 (22,649.05) 927,643.00 723,105.05 78.0%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 7,170.51 3,500.00 3,670.51 9,925.76 9,500.00 425.76 29,300.00 19,374.24 66.1%6313744 Fertilizer 11,845.41 9,600.00 2,245.41 36,361.50 26,600.00 9,761.50 92,200.00 55,838.50 60.6%6313745 Herbicides - 1,000.00 (1,000.00) - 1,000.00 (1,000.00) 10,000.00 10,000.00 100.0%6313746 Flowers/Plants 1,305.00 1,000.00 305.00 1,305.00 1,000.00 305.00 3,500.00 2,195.00 62.7%6313748 Fuel-Gasoline 3,816.31 3,750.00 66.31 10,931.20 10,950.00 (18.80) 43,100.00 32,168.80 74.6%6313750 Golf Course Accessories 751.19 200.00 551.19 894.74 600.00 294.74 8,000.00 7,105.26 88.8%6313756 POA Control 209.97 - 209.97 400.46 - 400.46 7,000.00 6,599.54 94.3%6313758 Miscellaneous Supp - 750.00 (750.00) 1,344.33 2,250.00 (905.67) 4,350.00 3,005.67 0.0%6313762 Supplies-Office - - - 278.33 - 278.33 - (278.33) 0.0%6313774 Sand 4,465.65 5,000.00 (534.35) 4,465.65 5,780.00 (1,314.35) - (4,465.65) 0.0%6313775 Sand-Bunkers - - - - - - 11,460.00 11,460.00 100.0%6313776 Seed - 250.00 (250.00) 758.53 950.00 (191.47) 91,810.00 91,051.47 99.2%6313778 Small Tools & Non-Capital Equip 549.98 2,000.00 (1,450.02) 1,300.13 2,200.00 (899.87) 5,000.00 3,699.87 74.0%6313780 Sod 3,454.29 1,000.00 2,454.29 6,652.46 3,000.00 3,652.46 5,750.00 (902.46) -15.7%6313782 Topdressing - - - 2,001.98 2,500.00 (498.02) 7,600.00 5,598.02 73.7%Total-CM-SUPPLIES & MATERIALS33,568.31 28,050.00 5,518.31 76,620.07 66,330.00 10,290.07 319,070.00 242,449.93 76.0%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 3,159.37 2,500.00 659.37 7,119.11 5,500.00 1,619.11 17,000.00 9,880.89 58.1%6315685 CM-R&M-Bldngs & Othr Structures 125.50 250.00 (124.50) 737.48 750.00 (12.52) 1,750.00 1,012.52 57.9%6315690 CM-R&M-Equipment 4,857.43 4,400.00 457.43 14,058.51 13,200.00 858.51 35,700.00 21,641.49 60.6%6315692 CM-R&M-Irrigation System 4,582.12 2,200.00 2,382.12 8,939.66 6,400.00 2,539.66 16,050.00 7,110.34 44.3%6315696 CM-R&M-Pumps 926.39 1,000.00 (73.61) 5,963.98 3,000.00 2,963.98 10,500.00 4,536.02 43.2%6315815 CM-R&M-Trees-Pruning Etc 3,239.25 3,500.00 (260.75) 3,239.25 3,500.00 (260.75) 10,050.00 6,810.75 67.8%Total-CM-REPAIRS & MAINTENANCE 16,890.06 13,850.00 3,040.06 40,057.99 32,350.00 7,707.99 91,050.00 50,992.01 56.0%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs 5.38 - 5.38 14.87 - 14.87 (14.87) 0.0%6317836 Utilities-Natural Gas/LPG - 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 0.0%6317840 Telephones 607.82 850.00 (242.18) 2,581.91 2,550.00 31.91 10,200.00 7,618.09 74.7%Total-CM-UTILITIES 613.20 900.00 (286.80) 2,596.78 2,700.00 (103.22) 10,800.00 8,203.22 76.0%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 1,500.00 1,500.00 - 6,000.00 4,500.00 75.0%6319099 Contract Svcs-Security Bldgs 210.00 - 210.00 210.00 - 210.00 (210.00) 0.0%6319100 Contract Svcs-Soil/Tissue Test 1,500.00 2,000.00 (500.00) 1,500.00 2,000.00 (500.00) 4,000.00 2,500.00 62.5%6319101 Contract Svcs-Trash Removal 487.83 524.00 (36.17) 1,463.49 1,572.00 (108.51) 6,288.00 4,824.51 0.0%6319150 Dues & Subscriptions 18.00 - 18.00 18.00 200.00 (182.00) 900.00 882.00 98.0%6319170 Employee Education - 50.00 (50.00) - 150.00 (150.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental - 150.00 (150.00) 461.25 500.00 (38.75) 4,200.00 3,738.75 89.0%6319206 Licenses & Permits 114.05 80.00 34.05 114.05 280.00 (165.95) 680.00 565.95 83.2%6319490 Miscellaneous 3.94 100.00 (96.06) 354.12 300.00 54.12 1,200.00 845.88 70.5%6319718 Safety Equipment & Training 563.33 900.00 (336.67) 892.59 1,100.00 (207.41) 2,600.00 1,707.41 65.7%6319822 Uniforms 861.13 820.00 41.13 2,563.15 2,460.00 103.15 9,840.00 7,276.85 74.0%Total-CM-OTHER EXPENSES 4,258.28 5,124.00 (865.72) 9,076.65 10,062.00 (985.35) 37,258.00 28,181.35 75.6%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementSeptember 2009Annual Budget4 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,247.01 2,317.00 (69.99) 5,171.75 6,951.00 (1,779.25) 27,804.00 22,632.25 81.4%6321325 Insurance-Workers Comp 392.83 700.00 (307.17) 1,323.20 2,038.00 (714.80) 8,229.00 6,905.80 83.9%6321800 Taxes-Employer Payroll 751.29 1,559.00 (807.71) 2,266.42 4,475.00 (2,208.58) 18,154.00 15,887.58 87.5%6321880 Wages-Hourly 9,820.80 11,712.00 (1,891.20) 29,376.80 35,136.00 (5,759.20) 140,544.00 111,167.20 79.1%6321882 Wages-Overtime - 811.00 (811.00) 249.49 - 249.49 5,272.00 5,022.51 95.3%Total-CM-LM-SALARIES & BENEFITS13,211.93 17,099.00 (3,887.07) 38,387.66 48,600.00 (10,212.34) 200,003.00 161,615.34 80.8%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 100.00 (100.00) - 300.00 (300.00) 1,025.00 1,025.00 100.0%6323788 Uniforms 173.96 290.00 (116.04) 559.85 870.00 (310.15) 3,480.00 2,920.15 83.9%Total-CM-LM-SUPPLIES & MATERIALS173.96 390.00 (216.04) 559.85 1,170.00 (610.15) 4,505.00 3,945.15 87.6%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 500.00 (500.00) - 1,000.00 (1,000.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE - 500.00 (500.00) - 1,000.00 (1,000.00) 4,250.00 4,250.00 100.0%136,870.45 141,642.00 (4,771.55) 371,836.95 389,399.00 (17,562.05) 1,594,579.00 1,222,742.05 76.7% August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 3,156.93 5,000.00 (1,843.07) 9,412.46 15,000.00 (5,587.54) 65,000.00 55,587.54 85.5%6337842 Utilities-Water6,068.25 3,034.00 3,034.25 16,459.48 6,507.00 9,952.48 21,871.00 5,411.52 24.7%Total-CM-WATER & ENERGY 9,225.18 8,034.00 1,191.18 25,871.94 21,507.00 4,364.94 86,871.00 60,999.06 70.2%Month to Date Year to Date Annual BudgetYear to DateSilverrock ResortCourse Maintenance Water & EnergyAugust 2009Total -COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementSeptember 2009Annual BudgetMonth to Date5 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 420.00 420.00 - 1,260.00 1,260.00 - 6,960.00 5,700.00 81.9%6411320 Insurance-Group 472.00 662.00 (190.00) 598.50 1,986.00 (1,387.50) 7,944.00 7,345.50 92.5%6411325 Insurance-Workers Comp 340.26 1,016.00 (675.74) 1,017.98 3,294.00 (2,276.02) 16,162.00 15,144.02 93.7%6411800 Taxes-Employer Payroll 1,137.04 881.00 256.04 2,582.53 2,856.00 (273.47) 14,012.00 11,429.47 81.6%6411880 Wages-Hourly 8,506.51 7,075.00 1,431.51 22,621.54 22,940.00 (318.46) 112,549.00 89,927.46 79.9%6411882 Wages-Overtime 511.32 - 511.32 511.32 - 511.32 - (511.32) 0.0%Total-CBR-SALARIES & BENEFITS11,387.13 10,054.00 1,333.13 28,591.87 32,336.00 (3,744.13) 157,627.00 129,035.13 81.9%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 318.57 - 318.57 318.57 - 318.57 2,350.00 2,031.43 86.4%6413742 Supplies-Expendable 486.90 150.00 336.90 2,352.00 450.00 1,902.00 5,000.00 2,648.00 53.0%6413752 Supplies-Range Balls - - - - - - 6,000.00 6,000.00 100.0%6413762 Supplies-Office - 25.00 (25.00) - 75.00 (75.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels - 72.00 (72.00) - 216.00 (216.00) 892.00 892.00 100.0%6413796 Supplies-Bottled Water175.80 400.00 (224.20) 1,055.65 1,200.00 (144.35) 19,400.00 18,344.35 94.6%Total-CBR-SUPPLIES & MATERIALS981.27 647.00 334.27 3,726.22 1,941.00 1,785.22 34,587.00 30,860.78 89.2%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts 720.00 720.00 - 2,160.00 2,160.00 - 8,640.00 6,480.00 75.0%6415690 CBR-R&M-Equipment 399.61 300.00 99.61 491.75 900.00 (408.25) 3,600.00 3,108.25 86.3%6415695 CBR-R&M-Cart Maintenance & Repair 296.06 500.00 (203.94) 777.60 1,500.00 (722.40) 4,000.00 3,222.40 80.6%Total-CBR-REPAIRS & MAINTENANCE 1,415.67 1,520.00 (104.33) 3,429.35 4,560.00 (1,130.65) 16,240.00 12,810.65 78.9%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps - 100.00 (100.00) 755.00 300.00 455.00 5,000.00 4,245.00 84.9%6419094 Contract Services-Laundry/Linen 588.84 500.00 88.84 2,683.64 1,500.00 1,183.64 6,000.00 3,316.36 55.3%6419220 Freight/Delivery - 75.00 (75.00) - 225.00 (225.00) 900.00 900.00 100.0%6419490 Miscellaneous - 75.00 (75.00) - 275.00 (275.00) 1,150.00 1,150.00 100.0%6419820 Uniforms - - - - - - 5,625.00 5,625.00 100.0%Total-CBR-OTHER EXPENSES 588.84 750.00 (161.16) 3,438.64 2,300.00 1,138.64 18,675.00 15,236.36 81.6%TOTAL-CARTS,BAGROOM & RANGE 14,372.91 12,971.00 1,401.91 39,186.08 41,137.00 (1,950.92) 227,129.00 187,942.92 82.7%643-CS-SALARIES & BENEFITS6431175 Employee Meals 180.00 180.00 - 540.00 540.00 - 3,300.00 2,760.00 83.6%6431325 Insurance-Workers Comp 103.92 123.00 (19.08) 261.83 355.00 (93.17) 2,069.00 1,807.17 87.3%6431800 Taxes-Employer Payroll 288.29 269.00 19.29 719.32 777.00 (57.68) 4,512.00 3,792.68 84.1%6431880 Wages-Hourly 2,598.00 2,160.00 438.00 5,852.00 6,240.00 (388.00) 36,240.00 30,388.00 83.9%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS3,170.21 2,732.00 438.21 7,373.15 7,912.00 (538.85) 46,121.00 38,747.85 84.0%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) - 200.00 (200.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous - - - - - - 200.00 200.00 100.0%6439718 Safety Equipment & Training - 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6439820 Uniforms - 75.00 (75.00) - 225.00 (225.00) 1,900.00 1,900.00 100.0%Total-CS-OTHER EXPENSES - 225.00 (225.00) - 575.00 (575.00) 3,750.00 3,750.00 100.0%Total-COURSE SERVICES 3,170.21 2,957.00 213.21 7,373.15 8,487.00 (1,113.85) 49,871.00 42,497.85 85.2%TOTAL OUTSIDE SERVICES 17,543.12 15,928.00 1,615.12 46,559.23 49,624.00 (3,064.77) 277,000.00 226,690.77 81.8%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementSeptember 2009Annual Budget6 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) - 1,200.00 (1,200.00) 4,800.00 4,800.00 100.0%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) - 1,200.00 (1,200.00) 4,800.00 4,800.00 100.0%65-CH-UTILITIES6507836 Utilities-Natural Gas18.90 300.00 (281.10) 481.23 900.00 (418.77) 3,600.00 3,118.77 86.6%6507838 Utilities-Sewer- 200.00 (200.00) - 600.00 (600.00) 2,400.00 2,400.00 100.0%6507840 Utilities-Telephone960.42 1,000.00 (39.58) 3,850.32 3,000.00 850.32 12,000.00 8,149.68 67.9%6507842 Utilities-Water893.22 200.00 693.22 1,601.64 600.00 1,001.64 2,400.00 798.36 33.3%6507844 Utilities-Cable326.47 317.00 9.47 972.84 951.00 21.84 3,800.00 2,827.16 74.4%Total-CH-UTILITIES 2,199.01 2,017.00 182.01 6,906.03 6,051.00 855.03 24,200.00 17,293.97 71.5%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 5,670.00 5,475.00 195.00 22,500.00 16,830.00 74.8%6509098 Contract Services-Refuse Dispose291.34 - 291.34 874.02 - 874.02 - (874.02) 0.0%6509099 Contract Services-Security5,163.88 4,100.00 1,063.88 15,634.60 12,300.00 3,334.60 49,200.00 33,565.40 68.2%6509215 Flowers & Decorations- 100.00 (100.00) - 300.00 (300.00) 2,600.00 2,600.00 100.0%6509490 Miscellaneous- 200.00 (200.00) - 600.00 (600.00) 2,400.00 2,400.00 100.0%6509718 Safety Equipment & Training- 100.00 (100.00) 223.86 300.00 (76.14) 1,200.00 976.14 81.3%Total-CH-OTHER EXPENSES 7,280.22 6,325.00 955.22 22,402.48 18,975.00 3,427.48 77,900.00 55,497.52 71.2%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures431.78 200.00 231.78 2,241.78 600.00 1,641.78 2,400.00 158.22 6.6%6515686 CH-R&M-Restaurant Repairs1,476.50 400.00 1,076.50 1,476.50 1,200.00 276.50 4,800.00 3,323.50 69.2%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 135.00 1,200.00 (1,065.00) 4,800.00 4,665.00 97.2%Total-CH-REPAIRS & MAINTENANCE 1,908.28 1,000.00 908.28 3,853.28 3,000.00 853.28 12,000.00 8,146.72 67.9%Total CLUBHOUSE 11,387.51 9,742.00 1,645.51 33,161.79 29,226.00 3,935.79 118,900.00 16,293.44 13.7%Month to Date Year to DateSilverRock ResortClubhouse Expense StatementSeptember 2009Annual Budget7 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 180.00 180.00 - 720.00 540.00 75.0%6601320 Insurance-Group 329.80 331.00 (1.20) 902.52 993.00 (90.48) 3,972.00 3,069.48 77.3%6601325 Insurance-Workers Comp 101.00 143.00 (42.00) 338.50 429.00 (90.50) 1,713.00 1,374.50 80.2%6601720 Salaries 2,500.00 2,500.00 - 7,500.00 7,500.00 - 30,000.00 22,500.00 75.0%6601800 Taxes-Employer Payroll 311.00 311.00 - 933.00 933.00 - 3,735.00 2,802.00 75.0%Total-MKT-SALARIES & BENEFITS 3,301.80 3,345.00 (43.20) 9,854.02 10,035.00 (180.98) 40,140.00 30,285.98 75.5%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 140.15 300.00 (159.85) 1,200.00 1,059.85 88.3%6603768 Supplies-Printing & Stationery - 200.00 (200.00) 187.43 200.00 (12.57) 4,425.00 4,237.57 95.8%- 300.00 (300.00) 327.58 500.00 (172.42) 5,625.00 5,297.42 94.2%66-MKT-UTILITIES6607840 Utilities-Telephone 48.25 100.00 (51.75) 141.63 300.00 (158.37) 1,200.00 1,058.37 88.2%Total-MKT-UTILITIES 48.25 100.00 (51.75) 141.63 300.00 (158.37) 1,200.00 1,058.37 88.2%66-MKT-OTHER EXPENSES6609010 Advertising 23,862.87 16,207.00 7,655.87 36,186.23 23,571.00 12,615.23 185,984.00 149,797.77 80.5%6609040 Business Meals - 25.00 (25.00) - 75.00 (75.00) 300.00 300.00 100.0%6609080 Collateral Material - - - 163.11 - 163.11 9,000.00 8,836.89 98.2%6609102 Contract Services-Web Page 99.00 175.00 (76.00) 372.00 525.00 (153.00) 2,100.00 1,728.00 82.3%6609490 Miscellaneous - - - - - - 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6609630 Promotion - - - - - - 700.00 700.00 0.0%6609633 Promotion-Community - 75.00 (75.00) - 225.00 (225.00) 2,925.00 2,925.00 100.0%6609634 Promotion-Media/Vendor 93.42 500.00 (406.58) 93.42 500.00 (406.58) 6,500.00 - 0.0%6609150 Dues and Subscriptions - - - 140.00 - 140.00 735.00 595.00 81.0%6609820 Uniforms - - - - - - 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 24,055.29 17,032.00 7,023.29 36,954.76 25,046.00 11,908.76 209,794.00 166,432.66 79.3%Total-MARKETING 27,405.34 20,777.00 6,628.34 47,277.99 35,881.00 11,396.99 256,759.00 203,074.43 79.1%Month to Date Year to DateSilverRock ResortMarketing Expense StatementSeptember 2009Annual Budget8 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 540.00 540.00 - 2,160.00 1,620.00 75.0%6701320 Insurance-Group1,258.00 1,458.00 (200.00) 3,765.37 4,374.00 (608.63) 17,496.00 13,730.63 78.5%6701325 Insurance-Workers Comp622.65 981.00 (358.35) 2,096.48 2,943.00 (846.52) 11,772.00 9,675.52 82.2%6701720 Salaries 13,503.32 14,534.00 (1,030.68) 40,509.96 43,602.00 (3,092.04) 174,408.00 133,898.04 76.8%6701800 Taxes-Employer Payroll 1,190.81 2,140.00 (949.19) 3,570.17 6,420.00 (2,849.83) 25,680.00 22,109.83 86.1%6701880 Wages-Hourly2,062.81 2,654.00 (591.19) 6,158.93 7,962.00 (1,803.07) 31,848.00 25,689.07 80.7%6701882 Wages-Overtime - - - 5.91 - 5.91 - (5.91) 0.0%Total-G&A-SALARIES & BENEFITS 18,817.59 21,947.00 (3,129.41) 56,646.82 65,841.00 (9,194.18) 263,364.00 206,717.18 78.5%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer29.00 800.00 (771.00) 379.00 2,400.00 (2,021.00) 10,800.00 10,421.00 96.5%6703762 Supplies-Office 536.82 125.00 411.82 710.05 375.00 335.05 1,500.00 789.95 52.7%6703768 Supplies-Printing & Stationery- 100.00 (100.00) 83.70 200.00 (116.30) 3,200.00 3,116.30 97.4%6703778Supplies-Small Tools/Non-Capital - 100.00 (100.00) - 100.00 (100.00) 900.00 900.00 100.0%Total-G&A-SUPPLIES & MATERIALS 565.82 1,125.00 (559.18) 1,172.75 3,075.00 (1,902.25) 16,400.00 15,227.25 92.8%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment297.97 100.00 197.97 297.97 300.00 (2.03) 1,200.00 902.03 75.2%Total-G&A-REPAIRS & MAINTENANCE 297.97 100.00 197.97 297.97 300.00 (2.03) 1,200.00 902.03 75.2%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 1,200.00 1,200.00 - 4,800.00 3,600.00 75.0%6709150 Dues & Subscriptions- 200.00 (200.00) - 250.00 (250.00) 1,500.00 1,500.00 100.0%6709180 Employee Recruiting/Relocation28.00 500.00 (472.00) 112.00 500.00 (388.00) 2,600.00 2,488.00 95.7%6709197 Equipment Rental597.27 350.00 247.27 1,509.92 1,050.00 459.92 4,200.00 2,690.08 64.0%6709202 Fees-Bank92.34 90.00 2.34 150.79 270.00 (119.21) 1,080.00 929.21 86.0%6709208 Fees-Payroll Processing692.31 550.00 142.31 2,042.61 1,650.00 392.61 6,600.00 4,557.39 69.1%6709220 Freight/Delivery34.02 50.00 (15.98) 88.29 150.00 (61.71) 600.00 511.71 85.3%6709490 Miscellaneous - 100.00 (100.00) 246.04 300.00 (53.96) 1,200.00 953.96 79.5%6709620 Postage/Mail Services 126.94 75.00 51.94 415.10 225.00 190.10 900.00 484.90 53.9%6709625 Professional Fees1,000.04 400.00 600.04 1,665.04 1,200.00 465.04 4,800.00 3,134.96 65.3%6709636 Promotion/Entertainment- 100.00 (100.00) 134.78 300.00 (165.22) 2,600.00 2,465.22 94.8%6709722 Seminars & Training250.00 200.00 50.00 250.00 600.00 (350.00) 2,400.00 2,150.00 89.6%6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms - 75.00 (75.00) 91.69 225.00 (133.31) 1,050.00 958.31 91.3%Total-G&A-OTHER EXPENSES 3,220.92 3,090.00 130.92 7,906.26 8,020.00 (113.74) 35,430.00 27,523.74 77.7%Total-GENERAL & ADMINISTRATIVE22,902.30 26,262.00 (3,359.70) 66,023.80 77,236.00 (11,212.20) 316,394.00 250,370.20 79.1%Month to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementSeptember 2009Annual Budget9 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,581.04 11,581.00 0.04 34,743.12 34,743.00 0.12 138,972.00 104,228.88 75.0%6800193 Equipment Leases-Course Maint 16,244.12 16,500.00 (255.88) 48,732.36 49,500.00 (767.64) 189,000.00 140,267.64 74.2%6800194 Equipment Leases-Trailer 540.00 600.00 (60.00) 1,629.50 1,800.00 (170.50) 7,200.00 5,570.50 77.4%6800195 Equipment Leases-Software 1,791.93 1,372.00 419.93 5,375.79 4,116.00 1,259.79 8,232.00 2,856.21 34.7%6800196 Equipment Leases-GPS 6,840.14 7,400.00 (559.86) 21,238.23 22,200.00 (961.77) 88,800.00 67,561.77 76.1%6800197 Equipment Leases-Others 2,575.72 - 2,575.72 7,780.47 - 7,780.47 - - 0.0%Total-LEASES 39,572.95 37,453.00 2,119.95 119,499.47 112,359.00 7,140.47 432,204.00 320,485.00 74.2%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,385.57 10,794.00 (2,408.43) 49,002.56 59,175.00 (10,172.44) 90,000.00 40,997.44 45.6%6900210 FF&E Reserve 3,315.24 2,863.00 452.24 6,966.93 6,037.00 929.93 59,610.00 52,643.07 88.3%6900800 Personal Property Taxes 3,611.17 - 3,611.17 8,717.71 20,000.00 (11,282.29) 20,000.00 11,282.29 56.4%6900323 Insurance-Commercial - 3,500.00 (3,500.00) 3,654.10 10,500.00 (6,845.90) 42,000.00 38,345.90 91.3%Total-MISC OTHER EXPENSES15,311.98 17,157.00 (1,845.02) 68,341.30 95,712.00 (27,370.70) 211,610.00 143,268.70 67.7%Annual BudgetMonth to Date Year to DateSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementSeptember 200910 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2009-20102009 2009 2009 2009 2009 2009Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia74SalesPromotionGolf Industry81711VIPCelebrityPGA Comp70 68 67Charity/Gift Certificate14 10Rain/Wind Checks35Club Staff69 105 91LQ HS Golf39161 200 227 0 0 02010 2010 2010 2010 2010 2010Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2009-2010September 2010 Date Time Description CategoryPlayers9/20/2009 11:52 Kris Long KCBS Media 412