Loading...
11 May 2009 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2008 – May 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 May Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 283,183.95 271,650.00 11,533.95 4.2% 2,804,543.22 3,105,253.00 (300,709.78) 3,255,761.00 451,217.78 86%401000 Miscellaneous Golf Revenue 8,489.50 6,600.00 1,889.50 28.6% 118,644.03 109,587.00 9,057.03 113,217.00 (5,427.03) 105%410000 Revenue-Golf Shop 20,723.53 28,000.00 (7,276.47) -26.0% 270,667.01 360,551.00 (89,883.99) 375,951.00 105,283.99 72%420000 Revenue-F&B Concession 500.00 500.00 - 0.0% 11,500.00 11,500.00 - 12,000.00 500.00 96%890000 Interest Income 7.98 - 7.98 0.0% 78.73 - 78.73 - (78.73) 0%Total Income312,904.96 306,750.00 6,154.96 2.0% 3,205,432.99 3,586,891.00 (381,458.01) 3,756,929.00 551,496.01 85%Cost of Goods Sold510000 COS-Golf Shop 11,887.75 14,861.00 (2,973.25) 20.0% 154,706.55 191,364.00 36,657.45 199,538.00 44,831.45 78%Total COS11,887.75 14,861.00 (2,973.25) 20.0% 154,706.55 191,364.00 36,657.45 199,538.00 44,831.45 78%Gross Profit301,017.21 291,889.00 9,128.21 3.1% 3,050,726.44 3,395,527.00 (344,800.56) 3,557,391.00 506,664.56 86%Expenses610000 Golf Pro Shop 15,844.19 27,343.00 11,498.81 42.1% 201,938.55 256,791.00 54,852.45 279,518.00 77,579.45 72%630000 Course Maintenance 106,977.71 122,170.00 15,192.29 12.4% 1,491,957.17 1,574,540.00 82,582.83 1,699,984.00 208,026.83 88%633000 Maintenance Water & Energy 6,316.82 8,659.00 2,342.18 27.0% 77,737.98 97,057.00 19,319.02 105,871.00 28,133.02 73%640000 Outside Services 28,428.87 25,844.00 (2,584.87) -10.0% 264,480.14 270,909.00 6,428.86 294,037.00 29,556.86 90%650000 Clubhouse 13,553.08 13,842.00 288.92 2.1% 152,565.83 154,262.00 1,696.17 168,104.00 15,538.17 91%660000 Marketing 20,563.98 16,953.00 (3,610.98) -21.3% 266,693.99 283,378.00 16,684.01 298,081.00 31,387.01 89%670000 General & Administrative23,727.23 28,032.00 4,304.77 15.4% 263,159.99 306,652.00 43,492.01 333,834.00 70,674.01 79%680000 Leases 39,571.41 41,106.00 1,534.59 3.7% 441,843.71 452,166.00 10,322.29 493,272.00 51,428.29 90%690000 Miscellaneous Other Expense 8,083.06 17,912.00 9,828.94 54.9% 176,003.56 198,481.00 22,477.44 227,140.00 51,136.44 77%Total Expenses263,066.35 301,861.00 38,794.65 12.9% 3,336,380.92 3,594,236.00 257,855.08 3,899,841.00 563,460.08 86%Net Income 37,950.86 (9,972.00) 47,922.86 480.6%(285,654.48) (198,709.00) (86,945.48) (342,450.00) (56,795.52) 83%Rounds of Golf PlayedPaid Rounds Played 4,677 4,000 677 16.9% 38,117 38,950 (833) 40,580 2,463 94%Ave $ Per Paid Round Green Fee 60.55 67.91 (7.36) -10.8% 73.58 79.72 (6.15) 77.90 4.32 94%Ave $ Per Paid Round Merchandise 4.43 7.00 (2.57) -36.7% 7.10 9.26 (2.16) 8.07 0.97 88%Ave $ Per Paid Miscellaneous 1.82 1.65 0.17 10.0% 3.11 2.81 0.30 2.06 - 0%Month to Date Year to DateMay 2009SilverRock ResortSummary Operating Income Statement1 Income May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 283,183.95 271,650.00 11,533.95 2,804,543.22 3,105,253.00 (300,709.78) 3,255,761.00451,217.7886%4010000 Rider Fee 1,150.00 400.00 750.00 7,400.00 5,764.00 1,636.00 5,984.00-1,416.00124%4040000 Club Rental 2,110.00 2,200.00 (90.00) 19,130.00 26,373.00 (7,243.00) 27,583.008,453.0069%4050000 Driving Range 4,080.00 4,000.00 80.00 64,288.00 44,450.00 19,838.00 46,650.00-17,638.00138%4060000 Handicap Fees 100.00 - 100.00 7,810.00 8,000.00 (190.00) 8,000.00 190.0098%4080000 GPS Advertising - - - 5,075.00 12,000.00 (6,925.00) 12,000.00 6,925.0042%4090000 Ball Retriever/Subcontract - - - 2,774.70 4,000.00 (1,225.30) 4,000.00 1,225.3069%4091000 Golf Professional Rental Fee 840.00 - 840.00 10,340.00 9,000.00 1,340.00 9,000.00 -1,340.00 115%4092000 Golf Lessons 209.50 - 209.50 1,826.33 - 1,826.33 - (1,826.33) 0% Total Revenue Fees 291,673.45 278,250.00 13,423.45 2,923,187.25 3,214,840.00 (291,652.75) 3,368,978.00 445,790.75 87%Total Income 291,673.45 278,250.00 13,423.45 2,923,187.25 3,214,840.00 (291,652.75) 3,368,978.00 445,790.75 87%SilverRock ResortStatement of Fees RevenueMay 2009Month to Date Year to Date Annual Budget2 Income May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 382.65 - 382.65 6,733.35 - 6,733.35 4100110 Sales Hard Goods 9,451.26 9,800.00 (348.74) 111,901.49 126,193.00 (14,291.51) 131,583.00 19,681.51 85%4100112 Sales-Soft Goods 14,042.59 18,200.00 (4,157.41) 194,829.16 234,358.00 (39,528.84) 244,368.00 49,538.84 80%5100639 GS-Discounts-Mdse (3,152.97) - (3,152.97) (42,796.99) - (42,796.99) - 42,796.99 0% Total Revenue Golf Shop 20,723.53 28,000.00 (7,276.47) 270,667.01 360,551.00 (89,883.99) 375,951.00 112,017.34 70%COS 5100150 COS-GS-Hard Goods 4,881.69 5,390.00 (508.31) 61,136.39 69,408.00 (8,271.61) 72,373.00 11,236.61 84%5100151 COS-GS-Soft Goods 6,967.29 10,010.00 (3,042.71) 90,430.65 128,898.00 (38,467.35) 134,404.00 43,973.35 67%5100152 COS-GS-Purchase Disc (56.57) (770.00) 713.43 (262.14) (9,917.00) 9,654.86 (10,341.00) (10,078.86) -3%5100220 COS-GS-Freight Merch 95.34 231.00 (135.66) 3,401.65 2,975.00 426.65 3,102.00 (299.65) 110%Cost of Sales - Golf Shop 11,887.75 14,861.00 (2,973.25) 154,706.55 191,364.00 (36,657.45) 199,538.00 44,831.45 78%Gross Profit 8,835.78 13,139.00 (4,303.22) 115,960.46 169,187.00 (53,226.54) 176,413.00 67,185.89 62%COS % 57.4% 53.1% -4.3% 57.2% 53.1% -4.1% 53.1% 40.0% 25%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 480.00 480.00 - 4,980.00 4,980.00 - 5,400.00 420.00 92%6101320 Insurance Group 2,320.36 3,150.00 (829.64) 29,761.20 33,300.00 (3,538.80) 36,450.00 6,688.80 82%6101325 Insurance-Workers Comp 313.31 1,327.00 (1,013.69) 4,375.35 13,535.00 (9,159.65) 14,771.00 10,395.65 30%6101720 Salaries 6,045.46 6,082.00 (36.54) 65,985.99 65,377.00 608.99 71,459.00 5,473.01 92%6101800 Taxes-Employer Payroll 946.94 2,015.00 (1,068.06) 12,009.26 20,554.00 (8,544.74) 22,431.00 10,421.74 54%6101880 Wages-Hourly 4,276.99 10,104.00 (5,827.01) 63,482.24 99,720.00 (36,237.76) 108,712.00 45,229.76 58%6101882 Wages-Overtime 121.13 - 121.13 1,937.98 - 1,937.98 - 952.88 0%Total -PS-SALARIES & BENEFITS 14,504.19 23,158.00 (8,653.81) 182,532.02 237,466.00 (54,933.98) 259,223.00 79,581.84 69%61-PS OTHER EXPENSES6103762 Supplies-Office 239.21 100.00 139.21 4,219.25 2,850.00 1,369.25 2,950.00 (1,269.25) 143%6109090 Contract Services 500.00 500.00 - 5,610.00 5,500.00 110.00 6,000.00 390.00 94%6109220 Freight & Delivery 56.65 - 56.65 852.61 75.00 777.61 75.00 (777.61) 1137%6109490 Miscellaneous 15.00 50.00 (35.00) 384.68 400.00 (15.32) 450.00 65.32 85%6109150 Dues and Subscriptions - 2,000.00 (2,000.00) 2,164.23 2,000.00 164.23 2,000.00 (164.23) 108%6109500 ProShop-Over/Short (18.66) - (18.66) 110.97 - 110.97 (110.97) 0%6109722 Seminars/Training - 1,250.00 (1,250.00) 2,390.00 5,455.00 (3,065.00) 5,490.00 3,100.00 44%6109810 Travel - Merchandise - 15.00 (15.00) - 75.00 (75.00) 90.00 90.00 0%6109820 Uniforms 398.03 200.00 198.03 1,882.80 2,200.00 (317.20) 2,400.00 517.20 78%6117840 Telephones 149.77 70.00 79.77 1,791.99 770.00 1,021.99 840.00 (951.99) 0%Total PS-OTHER EXPENSES 1,340.00 4,185.00 (2,845.00) 19,406.53 19,325.00 81.53 20,295.00 888.47 96%Total Expenses15,844.19 27,343.00 (11,498.81) 201,938.55 256,791.00 (54,852.45) 279,518.00 80,470.31 71%Net Income(7,008.41) (14,204.00) 7,195.59 (85,978.09) (87,604.00) 1,625.91 (103,105.00) (13,284.42) -87%Month to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementMay 20093 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 2,640.00 2,640.00 - 2,880.00 240.00 8.3%6311320 Insurance-Group 11,276.46 12,083.00 (806.54) 121,656.07 132,913.00 (11,256.93) 144,996.00 23,339.93 16.1%6311325 Insurance-Workers Comp 1,580.11 4,842.00 (3,261.89) 20,810.38 54,018.00 (33,207.62) 59,020.00 38,209.62 64.7%6311720 Salaries 12,335.04 12,333.00 2.04 126,695.04 135,645.00 (8,949.96) 147,978.00 21,282.96 14.4%6311800 Taxes-Employer Payroll 4,063.43 7,352.00 (3,288.57) 60,082.74 82,595.00 (22,512.26) 90,311.00 30,228.26 33.5%6311880 Wages-Hourly 40,314.95 46,716.00 (6,401.05) 489,300.35 513,804.00 (24,503.65) 560,520.00 71,219.65 12.7%6311882 Wages-Overtime 20.43 - 20.43 23,264.12 13,966.00 9,298.12 16,894.00 (6,370.12) -37.7%Total-CM-SALARIES & BENEFITS69,830.42 83,566.00 (13,735.58) 844,448.70 935,581.00 (91,132.30) 1,022,599.00 178,150.30 17.4%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 956.94 900.00 56.94 40,425.73 23,200.00 17,225.73 25,200.00 (15,225.73) -60.4%6313744 Fertilizer 6,405.42 5,000.00 1,405.42 96,025.18 90,200.00 5,825.18 95,200.00 (825.18) -0.9%6313746 Flowers/Plants - - - 1,800.52 3,500.00 (1,699.48) 3,500.00 1,699.48 48.6%6313748 Fuel-Gasoline 2,491.85 2,860.00 (368.15) 39,262.28 42,680.00 (3,417.72) 45,540.00 6,277.72 13.8%6313750 Golf Course Accessories - 100.00 (100.00) 9,725.15 6,900.00 2,825.15 7,000.00 (2,725.15) -38.9%6313756 POA Control - - - 7,360.84 6,000.00 1,360.84 6,000.00 (1,360.84) -22.7%6313758 Miscellaneous Supp 562.06 100.00 462.06 5,890.29 1,100.00 4,790.29 - (5,890.29) 0.0%6313762 Supplies-Office 144.92 - 144.92 741.33 - 741.33 1,200.00 458.67 38.2%6313774 Sand - 100.00 (100.00) 6,036.72 6,560.00 (523.28) 6,660.00 623.28 9.4%6313775 Sand-Bunkers - - - 3,702.67 5,000.00 (1,297.33) 5,000.00 1,297.33 25.9%6313776 Seed - 350.00 (350.00) 109,819.49 101,460.00 8,359.49 101,810.00 (8,009.49) -7.9%6313778 Small Tools & Non-Capital Equip 113.77 100.00 13.77 5,448.73 6,900.00 (1,451.27) 7,000.00 1,551.27 22.2%6313780 Sod - 500.00 (500.00) 5,159.85 4,750.00 409.85 5,750.00 590.15 10.3%6313782 Topdressing 1,337.50 1,300.00 37.50 6,373.48 6,300.00 73.48 7,600.00 1,226.52 16.1%Total-CM-SUPPLIES & MATERIALS12,012.46 11,310.00 702.46 337,772.26 304,550.00 33,222.26 317,460.00 (20,312.26) -6.4%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,659.12 1,500.00 159.12 18,132.45 14,500.00 3,632.45 16,000.00 (2,132.45) -13.3%6315685 CM-R&M-Bldngs & Othr Structures 121.00 - 121.00 1,459.50 500.00 959.50 500.00 (959.50) -191.9%6315690 CM-R&M-Equipment 2,243.01 2,000.00 243.01 46,290.94 44,700.00 1,590.94 46,100.00 (190.94) -0.4%6315692 CM-R&M-Irrigation System 1,456.50 1,000.00 456.50 14,982.88 14,450.00 532.88 15,450.00 467.12 3.0%6315696 CM-R&M-Pumps - 500.00 (500.00) 6,862.44 10,500.00 (3,637.56) 10,500.00 3,637.56 34.6%6315815 CM-R&M-Trees-Pruning Etc - - - 6,854.64 9,000.00 (2,145.36) 9,000.00 2,145.36 23.8%Total-CM-REPAIRS & MAINTENANCE 5,479.63 5,000.00 479.63 94,582.85 93,650.00 932.85 97,550.00 2,967.15 3.0%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs 5.38 - 5.38 59.18 - 59.18 - (59.18) 0.0%6317836 Utilities-Natural Gas/LPG - 150.00 (150.00) - 1,650.00 (1,650.00) 1,800.00 1,800.00 0.0%6317840 Telephones 965.29 800.00 165.29 9,675.30 8,800.00 875.30 9,600.00 (75.30) -0.8%Total-CM-UTILITIES 970.67 950.00 20.67 9,734.48 10,450.00 (715.52) 11,400.00 1,665.52 14.6%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 5,500.00 5,500.00 - 6,000.00 500.00 8.3%6319100 Contract Svcs-Soil/Tissue Test 2,000.00 2,000.00 - 3,500.00 4,000.00 (500.00) 4,000.00 500.00 12.5%6319101 Contract Svcs-Trash Removal 487.83 - 487.83 5,533.55 - 5,533.55 - (5,533.55) 0.0%6319150 Dues & Subscriptions 405.00 - 405.00 860.00 800.00 60.00 900.00 40.00 4.4%6319170 Employee Education - 50.00 (50.00) 560.00 550.00 10.00 600.00 40.00 6.7%6319197 Equipment Rental - 200.00 (200.00) 2,946.41 4,100.00 (1,153.59) 4,200.00 1,253.59 29.8%6319206 Licenses & Permits 450.00 - 450.00 2,210.00 1,600.00 610.00 1,600.00 (610.00) -38.1%6319490 Miscellaneous 559.48 100.00 459.48 1,178.33 1,100.00 78.33 1,200.00 21.67 1.8%6319718 Safety Equipment & Training 740.28 100.00 640.28 3,090.84 3,300.00 (209.16) 3,400.00 309.16 9.1%6319822 Uniforms 581.46 820.00 (238.54) 8,020.81 9,020.00 (999.19) 9,840.00 1,819.19 18.5%Total-CM-OTHER EXPENSES 5,724.05 3,770.00 1,954.05 33,399.94 29,970.00 3,429.94 31,740.00 (1,659.94) -5.2%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementMay 2009Annual Budget4 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,599.77 1,104.00 495.77 13,910.47 12,144.00 1,766.47 13,248.00 (662.47) -5.0%6321325 Insurance-Workers Comp 304.14 1,078.00 (773.86) 4,189.76 12,130.00 (7,940.24) 13,257.00 9,067.24 68.4%6321800 Taxes-Employer Payroll 799.23 1,636.00 (836.77) 12,607.88 18,619.00 (6,011.12) 20,368.00 7,760.12 38.1%6321880 Wages-Hourly 10,127.34 13,141.00 (3,013.66) 131,022.99 144,551.00 (13,528.01) 157,692.00 26,669.01 16.9%6321882 Wages-Overtime 10.69 - 10.69 5,103.37 5,005.00 98.37 5,915.00 811.63 13.7%Total-CM-LM-SALARIES & BENEFITS12,841.17 16,959.00 (4,117.83) 166,834.47 192,449.00 (25,614.53) 210,480.00 43,645.53 20.7%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 367.79 950.00 (582.21) 1,025.00 657.21 64.1%6323788 Uniforms 119.31 290.00 (170.69) 2,989.98 3,190.00 (200.02) 3,480.00 490.02 14.1%Total-CM-LM-SUPPLIES & MATERIALS119.31 365.00 (245.69) 3,357.77 4,140.00 (782.23) 4,505.00 1,147.23 25.5%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 250.00 (250.00) 1,826.70 3,750.00 (1,923.30) 4,250.00 2,423.30 57.0%Total-CM-LM-REPAIRS & MAINTENANCE - 250.00 (250.00) 1,826.70 3,750.00 (1,923.30) 4,250.00 2,423.30 57.0%106,977.71 122,170.00 (15,192.29) 1,491,957.17 1,574,540.00 (82,582.83) 1,699,984.00 208,026.83 12.2% May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 2,786.26 7,000.00 (4,213.74) 46,693.56 77,000.00 (30,306.44) 84,000.00 37,306.44 44.4%6337842 Utilities-Water3,530.56 1,659.00 1,871.56 31,044.42 20,057.00 10,987.42 21,871.00 (9,173.42) -41.9%Total-CM-WATER & ENERGY 6,316.82 8,659.00 (2,342.18) 77,737.98 97,057.00 (19,319.02) 105,871.00 28,133.02 26.6%Silverrock ResortCourse Maintenance Expense StatementMay 2009Annual BudgetMonth to DateMonth to Date Year to Date Annual BudgetYear to DateSilverrock ResortCourse Maintenance Water & EnergyMay 2009Total -COURSE MAINTENANCE5 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 480.00 480.00 - 5,700.00 5,700.00 - 6,180.00 480.00 7.8%6411320 Insurance-Group 63.25 720.00 (656.75) 1,354.93 7,920.00 (6,565.07) 8,640.00 7,285.07 84.3%6411325 Insurance-Workers Comp 362.91 1,407.00 (1,044.09) 3,441.33 15,104.00 (11,662.67) 16,511.00 13,069.67 79.2%6411800 Taxes-Employer Payroll 1,675.72 1,219.00 456.72 13,794.16 13,099.00 695.16 14,318.00 523.84 3.7%6411880 Wages-Hourly 12,080.85 9,795.00 2,285.85 110,417.84 105,195.00 5,222.84 114,990.00 4,572.16 4.0%6411882 Wages-Overtime 16.31 - 16.31 868.48 - 868.48 - (868.48) 0.0%Total-CBR-SALARIES & BENEFITS14,679.04 13,621.00 1,058.04 135,576.74 147,018.00 (11,441.26) 160,639.00 25,062.26 15.6%641-CBR-SUPPLIES & MATERIALS Supplies-Carts - 50.00 (50.00) 3,368.15 2,300.00 1,068.15 2,350.00 (1,018.15) -43.3%6413742 Supplies-Expendable 489.91 500.00 (10.09) 7,485.48 5,350.00 2,135.48 5,850.00 (1,635.48) -28.0%6413752 Supplies-Range Balls 734.07 - 734.07 6,554.07 6,000.00 554.07 6,000.00 (554.07) -9.2%6413762 Supplies-Office - 50.00 (50.00) - 475.00 (475.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - 70.00 (70.00) - 350.00 (350.00) 420.00 420.00 100.0%6413786 Supplies-Towels - 72.00 (72.00) 3,974.08 2,220.00 1,754.08 2,292.00 (1,682.08) -73.4%6413796 Supplies-Bottled Water199.20 2,600.00 (2,400.80) 14,751.39 21,750.00 (6,998.61) 23,950.00 9,198.61 38.4%Total-CBR-SUPPLIES & MATERIALS1,423.18 3,342.00 (1,918.82) 36,133.17 38,445.00 (2,311.83) 41,387.00 5,253.83 12.7%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts 720.00 720.00 - 7,995.00 7,920.00 75.00 8,640.00 645.00 7.5%6415690 CBR-R&M-Equipment - 125.00 (125.00) 1,138.67 1,375.00 (236.33) 1,500.00 361.33 24.1%6415695 CBR-R&M-Cart Maintenance & Repair 1,832.77 250.00 1,582.77 6,510.13 3,750.00 2,760.13 4,000.00 (2,510.13) -62.8%Total-CBR-REPAIRS & MAINTENANCE 2,552.77 1,095.00 1,457.77 15,643.80 13,045.00 2,598.80 14,140.00 (1,503.80) -10.6%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps - 200.00 (200.00) 6,210.00 4,800.00 1,410.00 5,000.00 (1,210.00) -24.2%6419094 Contract Services-Laundry/Linen 1,210.71 500.00 710.71 5,942.76 5,500.00 442.76 6,000.00 57.24 1.0%6419220 Freight/Delivery 111.67 75.00 36.67 159.57 825.00 (665.43) 900.00 740.43 82.3%6419490 Miscellaneous - 125.00 (125.00) 506.01 1,025.00 (518.99) 1,150.00 643.99 56.0%6419820 Uniforms 685.13 1,500.00 (814.87) 2,350.35 5,425.00 (3,074.65) 5,625.00 3,274.65 58.2%Total-CBR-OTHER EXPENSES 2,007.51 2,400.00 (392.49) 15,168.69 17,575.00 (2,406.31) 18,675.00 3,506.31 18.8%TOTAL-CARTS,BAGROOM & RANGE 20,662.50 20,458.00 204.50 202,522.40 216,083.00 (13,560.60) 234,841.00 32,318.60 13.8%643-CS-SALARIES & BENEFITS6431175 Employee Meals 360.00 360.00 - 4,560.00 4,560.00 - 4,860.00 300.00 6.2%6431325 Insurance-Workers Comp 178.92 328.00 (149.08) 1,300.88 3,174.00 (1,873.12) 3,446.00 2,145.12 62.2%6431800 Taxes-Employer Payroll 790.17 498.00 292.17 5,416.88 4,822.00 594.88 5,220.00 (196.88) -3.8%6431880 Wages-Hourly 5,964.00 4,000.00 1,964.00 43,280.00 38,720.00 4,560.00 41,920.00 (1,360.00) -3.2%6431882 Wages-Overtime - - - 81.00 - 81.00 - (81.00) 0.0%Total-CS-SALARIES & BENEFITS7,293.09 5,186.00 2,107.09 54,638.76 51,276.00 3,362.76 55,446.00 807.24 1.5%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 75.00 (75.00) 4,186.80 975.00 3,211.80 1,050.00 (3,136.80) -298.7%6439490 Miscellaneous - - - 290.55 200.00 90.55 200.00 (90.55) -45.3%6439718 Safety Equipment & Training - 50.00 (50.00) 43.10 550.00 (506.90) 600.00 556.90 92.8%6439820 Uniforms 473.28 75.00 398.28 2,798.53 1,825.00 973.53 1,900.00 (898.53) -47.3%Total-CS-OTHER EXPENSES 473.28 200.00 273.28 7,318.98 3,550.00 3,768.98 3,750.00 (3,568.98) -95.2%Total-COURSE SERVICES 7,766.37 5,386.00 2,380.37 61,957.74 54,826.00 7,131.74 59,196.00 (2,761.74) -4.7%TOTAL OUTSIDE SERVICES 28,428.87 25,844.00 2,584.87 264,480.14 270,909.00 (6,428.86) 294,037.00 33,125.84 11.3%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementMay 2009Annual Budget6 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 416.16 4,400.00 (3,983.84) 4,800.00 4,383.84 91.3%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 416.16 4,400.00 (3,983.84) 4,800.00 4,383.84 91.3%65-CH-UTILITIES6507836 Utilities-Natural Gas327.81 300.00 27.81 4,194.87 3,300.00 894.87 3,600.00 (594.87) -16.5%6507838 Utilities-Sewer- 200.00 (200.00) 600.00 2,200.00 (1,600.00) 2,400.00 1,800.00 75.0%6507840 Utilities-Telephone1,035.03 1,000.00 35.03 11,654.05 11,000.00 654.05 12,000.00 345.95 2.9%6507842 Utilities-Water335.27 200.00 135.27 3,499.84 2,200.00 1,299.84 2,400.00 (1,099.84) -45.8%6507844 Utilities-Cable124.95 317.00 (192.05) 3,604.46 3,487.00 117.46 3,804.00 199.54 5.2%Total-CH-UTILITIES 1,823.06 2,017.00 (193.94) 23,553.22 22,187.00 1,366.22 24,204.00 650.78 2.7%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning2,355.00 1,825.00 530.00 21,093.70 20,675.00 418.70 22,500.00 1,406.30 6.3%6509098 Contract Services-Refuse Dispose291.34 - 291.34 3,679.43 - 3,679.43 - (3,679.43) #DIV/0!6509099 Contract Services-Security8,140.08 8,200.00 (59.92) 95,669.32 90,200.00 5,469.32 98,400.00 2,730.68 2.8%6509215 Flowers & Decorations- 100.00 (100.00) - 2,500.00 (2,500.00) 2,600.00 2,600.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 193.93 2,200.00 (2,006.07) 2,400.00 2,206.07 91.9%6509718 Safety Equipment & Training- 100.00 (100.00) 108.62 1,100.00 (991.38) 1,200.00 1,091.38 90.9%Total-CH-OTHER EXPENSES 10,786.42 10,425.00 361.42 120,745.00 116,675.00 4,070.00 127,100.00 6,355.00 5.0%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures272.00 200.00 72.00 3,894.00 2,200.00 1,694.00 2,400.00 (1,494.00) -62.3%6515686 CH-R&M-Restaurant Repairs671.60 400.00 271.60 3,154.65 4,400.00 (1,245.35) 4,800.00 1,645.35 34.3%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 802.80 4,400.00 (3,597.20) 4,800.00 3,997.20 83.3%Total-CH-REPAIRS & MAINTENANCE 943.60 1,000.00 (56.40) 7,851.45 11,000.00 (3,148.55) 12,000.00 4,148.55 34.6%Total CLUBHOUSE 13,553.08 13,842.00 (288.92) 152,565.83 154,262.00 (1,696.17) 168,104.00 8,297.10 4.9%Month to Date Year to DateSilverRock ResortClubhouse Expense StatementMay 2009Annual Budget7 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 660.00 660.00 - 720.00 60.00 8.3%6601320 Insurance-Group 286.36 450.00 (163.64) 2,985.51 4,950.00 (1,964.49) 5,400.00 2,414.49 44.7%6601325 Insurance-Workers Comp - 205.00 (205.00) 813.87 2,255.00 (1,441.13) 2,460.00 1,646.13 66.9%6601720 Salaries 2,500.00 2,500.00 - 28,750.00 27,500.00 1,250.00 30,000.00 1,250.00 4.2%6601800 Taxes-Employer Payroll 311.00 311.00 - 3,887.50 3,421.00 466.50 3,732.00 (155.50) -4.2%Total-MKT-SALARIES & BENEFITS 3,157.36 3,526.00 (368.64) 37,096.88 38,786.00 (1,689.12) 42,312.00 5,215.12 12.3%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 100.00 1,100.00 (1,000.00) 1,200.00 1,100.00 91.7%6603768 Supplies-Printing & Stationery - 125.00 (125.00) 4,910.16 4,300.00 610.16 4,425.00 (485.16) -11.0%- 225.00 (225.00) 5,010.16 5,400.00 (389.84) 5,625.00 614.84 10.9%66-MKT-UTILITIES6607840 Utilities-Telephone 57.20 100.00 (42.80) 603.12 1,100.00 (496.88) 1,200.00 596.88 49.7%Total-MKT-UTILITIES 57.20 100.00 (42.80) 603.12 1,100.00 (496.88) 1,200.00 596.88 49.7%66-MKT-OTHER EXPENSES6609010 Advertising 17,250.42 11,677.00 5,573.42 215,578.80 215,157.00 421.80 225,134.00 9,555.20 4.2%6609040 Business Meals - 25.00 (25.00) - 275.00 (275.00) 300.00 300.00 100.0%6609080 Collateral Material - 1,000.00 (1,000.00) 2,704.05 8,500.00 (5,795.95) 9,000.00 6,295.95 70.0%6609102 Contract Services-Web Page 99.00 175.00 (76.00) 1,485.00 1,925.00 (440.00) 2,100.00 615.00 29.3%6609490 Miscellaneous - 50.00 (50.00) - 350.00 (350.00) 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) 1.59 550.00 (548.41) 600.00 598.41 99.7%6609630 Promotion - - - 2,166.57 6,500.00 (4,333.43) 6,500.00 4,333.43 0.0%6609633 Promotion-Community - 75.00 (75.00) 567.70 2,850.00 (2,282.30) 2,925.00 2,357.30 80.6%6609634 Promotion-Media/Vendor - 50.00 (50.00) - 650.00 (650.00) 700.00 - 0.0%6609150 Dues and Subscriptions - - - 1,441.71 735.00 706.71 735.00 (706.71) -96.2%6609820 Uniforms - - - 38.41 600.00 (561.59) 600.00 561.59 93.6%Total-MKT-OTHER EXPENSES 17,349.42 13,102.00 4,247.42 223,983.83 238,092.00 (14,108.17) 248,944.00 24,260.17 9.7%Total-MARKETING 20,563.98 16,953.00 3,610.98 266,693.99 283,378.00 (16,684.01) 298,081.00 30,687.01 10.3%Month to Date Year to DateSilverRock ResortMarketing Expense StatementMay 2009Annual Budget8 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 660.00 660.00 - 720.00 60.00 8.3%6601320 Insurance-Group 286.36 450.00 (163.64) 2,985.51 4,950.00 (1,964.49) 5,400.00 2,414.49 44.7%6601325 Insurance-Workers Comp - 205.00 (205.00) 813.87 2,255.00 (1,441.13) 2,460.00 1,646.13 66.9%6601720 Salaries 2,500.00 2,500.00 - 28,750.00 27,500.00 1,250.00 30,000.00 1,250.00 4.2%6601800 Taxes-Employer Payroll 311.00 311.00 - 3,887.50 3,421.00 466.50 3,732.00 (155.50) -4.2%Total-MKT-SALARIES & BENEFITS 3,157.36 3,526.00 (368.64) 37,096.88 38,786.00 (1,689.12) 42,312.00 5,215.12 12.3%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 100.00 1,100.00 (1,000.00) 1,200.00 1,100.00 91.7%6603768 Supplies-Printing & Stationery - 125.00 (125.00) 4,910.16 4,300.00 610.16 4,425.00 (485.16) -11.0%- 225.00 (225.00) 5,010.16 5,400.00 (389.84) 5,625.00 614.84 10.9%66-MKT-UTILITIES6607840 Utilities-Telephone 57.20 100.00 (42.80) 603.12 1,100.00 (496.88) 1,200.00 596.88 49.7%Total-MKT-UTILITIES 57.20 100.00 (42.80) 603.12 1,100.00 (496.88) 1,200.00 596.88 49.7%66-MKT-OTHER EXPENSES6609010 Advertising 17,250.42 11,677.00 5,573.42 215,578.80 215,157.00 421.80 225,134.00 9,555.20 4.2%6609040 Business Meals - 25.00 (25.00) - 275.00 (275.00) 300.00 300.00 100.0%6609080 Collateral Material - 1,000.00 (1,000.00) 2,704.05 8,500.00 (5,795.95) 9,000.00 6,295.95 70.0%6609102 Contract Services-Web Page 99.00 175.00 (76.00) 1,485.00 1,925.00 (440.00) 2,100.00 615.00 29.3%6609490 Miscellaneous - 50.00 (50.00) - 350.00 (350.00) 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) 1.59 550.00 (548.41) 600.00 598.41 99.7%6609630 Promotion - - - 2,166.57 6,500.00 (4,333.43) 6,500.00 4,333.43 0.0%6609633 Promotion-Community - 75.00 (75.00) 567.70 2,850.00 (2,282.30) 2,925.00 2,357.30 80.6%6609634 Promotion-Media/Vendor - 50.00 (50.00) - 650.00 (650.00) 700.00 - 0.0%6609150 Dues and Subscriptions - - - 1,441.71 735.00 706.71 735.00 (706.71) -96.2%6609820 Uniforms - - - 38.41 600.00 (561.59) 600.00 561.59 93.6%Total-MKT-OTHER EXPENSES 17,349.42 13,102.00 4,247.42 223,983.83 238,092.00 (14,108.17) 248,944.00 24,260.17 9.7%Total-MARKETING 20,563.98 16,953.00 3,610.98 266,693.99 283,378.00 (16,684.01) 298,081.00 30,687.01 10.3%Month to Date Year to DateSilverRock ResortMarketing Expense StatementMay 2009Annual Budget9 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,581.04 11,581.00 0.04 123,847.35 127,391.00 (3,543.65) 138,972.00 15,124.65 10.9%6800193 Equipment Leases-Course Maint 16,244.12 20,000.00 (3,755.88) 179,279.61 220,000.00 (40,720.39) 240,000.00 60,720.39 25.3%6800194 Equipment Leases-Trailer 540.00 600.00 (60.00) 6,438.94 6,600.00 (161.06) 7,200.00 761.06 10.6%6800195 Equipment Leases-Software 1,791.93 1,525.00 266.93 19,711.23 16,775.00 2,936.23 18,300.00 (1,411.23) -7.7%6800196 Equipment Leases-GPS 6,840.14 7,400.00 (559.86) 75,241.54 81,400.00 (6,158.46) 88,800.00 13,558.46 15.3%6800197 Equipment Leases-Others 2,574.18 - 2,574.18 37,325.04 - 37,325.04 - - 0.0%Total-LEASES 39,571.41 41,106.00 (1,534.59) 441,843.71 452,166.00 (10,322.29) 493,272.00 88,753.33 18.0%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee (832.76) 8,277.00 (9,109.76) 68,047.39 68,242.00 (194.61) 90,000.00 21,952.61 24.4%6900210 FF&E Reserve 5,795.27 6,135.00 (339.73) 59,280.43 71,739.00 (12,458.57) 75,140.00 15,859.57 21.1%6900800 Personal Property Taxes - - - 20,812.13 20,000.00 812.13 20,000.00 (812.13) -4.1%6900323 Insurance-Commercial 3,120.55 3,500.00 (379.45) 27,863.61 38,500.00 (10,636.39) 42,000.00 14,136.39 33.7%Total-MISC OTHER EXPENSES8,083.06 17,912.00 (9,828.94) 176,003.56 198,481.00 (22,477.44) 227,140.00 51,136.44 22.5% Operating Leases & Miscellaneous Other Expense StatementMay 2009Annual BudgetMonth to Date Year to Date10 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2008-20092008 2008 2008 2008 2008 2008Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia6182177Sales453PromotionGolf Industry11 16 5 5 4 16VIPCelebrityPGA Comp82 48 84 24 38 104Charity/Gift Certificate14 6 3 29 36Rain/Wind Checks66121319Club Staff137 116 113 21 45 69LQ HS Golf256 193 214 58 151 2542009 2009 2009 2009 2009 2009Comp CategoryJanuaryFebruaryMarchAprilMayJuneMedia 813 15Sales11Promotion84Golf Industry953439 17VIPCelebrity2PGA Comp48 633491 82Charity/Gift Certificate7153437 12Rain/Wind Checks10 31414 7Club Staff53 70103121 99LQ HS Golf68 52127 175 301 367 232 011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2008-2009May 2009 Date Time Description CategoryPlayers5/2/2009 11:22 John White - KESQ Media 45/16/2009 10:22 Michael Dante Media 25/22/2009 11:30 Gino LamontMedia 25/23/2009 10:07 Michael Dante Media 15/27/2009 9:30 Michael Dante Media 25/29/2009 11:07 Gino LamontMedia 212