Loading...
09 March 2009 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2008 – March 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 March Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 535,867.75 587,050.00 (51,182.25) -8.7% 2,119,994.77 2,376,358.00 (256,363.23) 3,255,761.00 1,135,766.23 65%401000 Miscellaneous Golf Revenue 19,414.50 18,340.00 1,074.50 5.9% 94,237.28 91,577.00 2,660.28 113,217.00 18,979.72 83%410000 Revenue-Golf Shop 38,585.66 59,000.00 (20,414.34) -34.6% 215,479.30 283,951.00 (68,471.70) 375,951.00 160,471.70 57%420000 Revenue-F&B Concession 1,500.00 1,500.00 - 0.0% 10,500.00 10,500.00 - 12,000.00 1,500.00 88%890000 Interest Income 4.95 - 4.95 0.0% 63.05 - 63.05 - (63.05) 0%Total Income595,372.86 665,890.00 (70,517.14) -10.6% 2,440,274.40 2,762,386.00 (322,111.60) 3,756,929.00 1,316,654.60 65%Cost of Goods Sold510000 COS-Golf Shop 21,253.23 31,315.00 (10,061.77) 32.1% 124,854.52 150,708.00 25,853.48 199,538.00 74,683.48 63%Total COS21,253.23 31,315.00 (10,061.77) 32.1% 124,854.52 150,708.00 25,853.48 199,538.00 74,683.48 63%Gross Profit574,119.63 634,575.00 (60,455.37) -9.5% 2,315,419.88 2,611,678.00 (296,258.12) 3,557,391.00 1,241,971.12 65%Expenses610000 Golf Pro Shop 16,608.78 24,952.00 8,343.22 33.4% 166,186.96 204,496.00 38,309.04 279,518.00 113,331.04 59%630000 Course Maintenance 103,765.49 122,570.00 18,804.51 15.3% 1,266,049.01 1,326,520.00 60,470.99 1,699,984.00 433,934.99 74%633000 Maintenance Water & Energy5,287.36 8,504.00 3,216.64 37.8% 64,417.09 79,894.00 15,476.91 105,871.00 41,453.91 61%640000 Outside Services 27,667.61 29,141.00 1,473.39 5.1% 207,301.93 216,874.00 9,572.07 294,037.00 86,735.07 71%650000 Clubhouse 15,687.39 13,842.00 (1,845.39) -13.3% 123,075.71 126,578.00 3,502.29 168,104.00 45,028.29 73%660000 Marketing 22,605.74 29,453.00 6,847.26 23.2% 220,199.49 239,922.00 19,722.51 298,081.00 77,881.51 74%670000 General & Administrative 22,614.99 27,282.00 4,667.01 17.1% 216,005.63 251,338.00 35,332.37 333,834.00 117,828.37 65%680000 Leases 39,277.79 41,106.00 1,828.21 4.4% 362,411.31 369,954.00 7,542.69 493,272.00 130,860.69 73%690000 Miscellaneous Other Expense 6,264.88 7,770.00 1,505.12 19.4% 164,990.34 170,601.00 5,610.66 227,140.00 62,149.66 73%Total Expenses259,780.03 304,620.00 44,839.97 14.7% 2,790,637.47 2,986,177.00 195,539.53 3,899,841.00 1,109,203.53 72%Net Income 314,339.60 329,955.00 (15,615.40) -4.7%(475,217.59) (374,499.00) (100,718.59) (342,450.00) 132,767.59 139%Rounds of Golf PlayedPaid Rounds Played 5,983 5,694 289 5.1% 28,300 29,550 (1,250) 40,580 12,280 70%Ave $ Per Paid Round Green Fee 89.57 103.10 (13.53) -13.1% 74.91 80.42 (5.51) 77.90 2.99 96%Ave $ Per Paid Round Merchandise 6.45 10.36 (3.91) -37.8% 7.61 9.61 (2.00) 8.07 0.46 94%Month to Date Year to DateMarch 2009SilverRock ResortSummary Operating Income Statement1 Income March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 535,867.75 587,050.00 (51,182.25) 2,119,994.77 2,376,358.00 (256,363.23) 3,255,761.001,135,766.2365%4010000 Rider Fee 875.00 590.00 285.00 5,075.00 4,824.00 251.00 5,984.00909.0085%4040000 Club Rental 3,970.00 5,900.00 (1,930.00) 14,830.00 21,203.00 (6,373.00) 27,583.0012,753.0054%4050000 Driving Range 11,946.00 8,850.00 3,096.00 51,338.00 35,050.00 16,288.00 46,650.00-4,688.00110%4060000 Handicap Fees 310.00 500.00 (190.00) 7,110.00 8,000.00 (890.00) 8,000.00 890.0089%4080000 GPS Advertising - 1,000.00 (1,000.00) 5,075.00 12,000.00 (6,925.00) 12,000.00 6,925.0042%4090000 Ball Retriever/Subcontract - - - 1,548.70 3,000.00 (1,451.30) 4,000.00 2,451.3039%4091000 Golf Professional Rental Fee 2,000.00 1,500.00 500.00 8,000.00 7,500.00 500.00 9,000.00 1,000.00 89%4092000 Golf Lessons 313.50 - 313.50 1,260.58 - 1,260.58 - (1,260.58) 0% Total Revenue Fees 555,282.25 605,390.00 (50,107.75) 2,214,232.05 2,467,935.00 (253,702.95) 3,368,978.00 1,154,745.95 66%Total Income 555,282.25 605,390.00 (50,107.75) 2,214,232.05 2,467,935.00 (253,702.95) 3,368,978.00 1,154,745.95 66%Month to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueMarch 20092 Income March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 289.00 - 289.00 5,804.84 - 5,804.84 4100110 Sales Hard Goods 12,594.38 20,650.00 (8,055.62) 85,418.56 99,383.00 (13,964.44) 131,583.00 46,164.44 65%4100112 Sales-Soft Goods 32,125.75 38,350.00 (6,224.25) 158,976.01 184,568.00 (25,591.99) 244,368.00 85,391.99 65%5100639 GS-Discounts-Mdse (6,423.47) - (6,423.47) (34,720.11) - (34,720.11) - 34,720.11 0% Total Revenue Golf Shop 38,585.66 59,000.00 (20,414.34) 215,479.30 283,951.00 (68,471.70) 375,951.00 166,276.54 56%COS 5100150 COS-GS-Hard Goods 6,691.15 11,358.00 (4,666.85) 47,569.04 54,662.00 (7,092.96) 72,373.00 24,803.96 66%5100151 COS-GS-Soft Goods 14,417.68 21,093.00 (6,675.32) 74,259.61 101,513.00 (27,253.39) 134,404.00 60,144.39 55%5100152 COS-GS-Purchase Disc - (1,623.00) 1,623.00 (205.57) (7,810.00) 7,604.43 (10,341.00) (10,135.43) -2%5100220 COS-GS-Freight Merch 144.40 487.00 (342.60) 3,231.44 2,343.00 888.44 3,102.00 (129.44) 104%Cost of Sales - Golf Shop 21,253.23 31,315.00 (10,061.77) 124,854.52 150,708.00 (25,853.48) 199,538.00 74,683.48 63%Gross Profit 17,332.43 27,685.00 (10,352.57) 90,624.78 133,243.00 (42,618.22) 176,413.00 91,593.06 48%COS % 55.1% 53.1% -2.0% 57.9% 53.1% -4.9% 53.1% 44.9% 15%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 480.00 480.00 - 4,020.00 4,020.00 - 5,400.00 1,380.00 74%6101320 Insurance Group 3,310.00 3,150.00 160.00 24,389.76 27,000.00 (2,610.24) 36,450.00 12,060.24 67%6101325 Insurance-Workers Comp 311.74 1,376.00 (1,064.26) 3,822.39 10,832.00 (7,009.61) 14,771.00 10,948.61 26%6101720 Salaries 6,045.46 6,082.00 (36.54) 53,895.07 53,213.00 682.07 71,459.00 17,563.93 75%6101800 Taxes-Employer Payroll 1,258.65 2,090.00 (831.35) 9,817.38 16,449.00 (6,631.62) 22,431.00 12,613.62 44%6101880 Wages-Hourly 4,267.29 10,704.00 (6,436.71) 53,420.45 78,912.00 (25,491.55) 108,712.00 55,291.55 49%6101882 Wages-Overtime 78.29 - 78.29 1,665.16 - 1,665.16 - 952.88 0%Total -PS-SALARIES & BENEFITS 15,751.43 23,882.00 (8,130.57) 151,030.21 190,426.00 (39,395.79) 259,223.00 110,810.83 57%61-PS OTHER EXPENSES6103762 Supplies-Office 135.75 200.00 (64.25) 3,776.59 2,550.00 1,226.59 2,950.00 (826.59) 128%6109090 Contract Services 500.00 500.00 - 4,610.00 4,500.00 110.00 6,000.00 1,390.00 77%6109220 Freight & Delivery 74.66 - 74.66 667.76 75.00 592.76 75.00 (592.76) 890%6109490 Miscellaneous - 50.00 (50.00) 369.68 300.00 69.68 450.00 80.32 82%6109150 Dues and Subscriptions - - - 267.23 - 267.23 2,000.00 1,732.77 13%6109500 ProShop-Over/Short (14.90) - (14.90) 136.73 - 136.73 (136.73) 0%6109722 Seminars/Training - 35.00 (35.00) 2,390.00 4,170.00 (1,780.00) 5,490.00 3,100.00 44%6109810 Travel - Merchandise - 15.00 (15.00) - 45.00 (45.00) 90.00 90.00 0%6109820 Uniforms - 200.00 (200.00) 1,348.00 1,800.00 (452.00) 2,400.00 1,052.00 56%6117840 Telephones 161.84 70.00 91.84 1,590.76 630.00 960.76 840.00 (750.76) 0%Total PS-OTHER EXPENSES 857.35 1,070.00 (212.65) 15,156.75 14,070.00 1,086.75 20,295.00 5,138.25 75%Total Expenses16,608.78 24,952.00 (8,343.22) 166,186.96 204,496.00 (38,309.04) 279,518.00 115,949.08 59%Net Income723.65 2,733.00 (2,009.35) (75,562.18) (71,253.00) (4,309.18) (103,105.00) (24,356.02) -76%Month to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementMarch 20093 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 2,160.00 2,160.00 - 2,880.00 720.00 25.0%6311320 Insurance-Group 11,467.94 12,083.00 (615.06) 99,065.33 108,747.00 (9,681.67) 144,996.00 45,930.67 31.7%6311325 Insurance-Workers Comp 1,551.91 4,842.00 (3,290.09) 18,054.00 44,334.00 (26,280.00) 59,020.00 40,966.00 69.4%6311720 Salaries 11,001.60 12,331.00 (1,329.40) 102,124.80 110,979.00 (8,854.20) 147,978.00 45,853.20 31.0%6311800 Taxes-Employer Payroll 5,628.03 7,352.00 (1,723.97) 50,263.28 67,891.00 (17,627.72) 90,311.00 40,047.72 44.3%6311880 Wages-Hourly 40,675.92 46,708.00 (6,032.08) 402,506.17 420,372.00 (17,865.83) 560,520.00 158,013.83 28.2%6311882 Wages-Overtime 52.83 - 52.83 23,125.28 13,966.00 9,159.28 16,894.00 (6,231.28) -36.9%Total-CM-SALARIES & BENEFITS70,618.23 83,556.00 (12,937.77) 697,298.86 768,449.00 (71,150.14) 1,022,599.00 325,300.14 31.8%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 6,487.52 1,500.00 4,987.52 33,923.88 20,300.00 13,623.88 25,200.00 (8,723.88) -34.6%6313744 Fertilizer 662.51 5,000.00 (4,337.49) 85,919.90 80,200.00 5,719.90 95,200.00 9,280.10 9.7%6313746 Flowers/Plants - 100.00 (100.00) 1,800.52 3,400.00 (1,599.48) 3,500.00 1,699.48 48.6%6313748 Fuel-Gasoline 3,883.65 3,520.00 363.65 33,433.44 35,530.00 (2,096.56) 45,540.00 12,106.56 26.6%6313750 Golf Course Accessories - 100.00 (100.00) 9,581.60 6,700.00 2,881.60 7,000.00 (2,581.60) -36.9%6313756 POA Control 197.33 - 197.33 7,162.46 6,000.00 1,162.46 6,000.00 (1,162.46) -19.4%6313758 Miscellaneous Supp 426.98 100.00 326.98 4,599.93 900.00 3,699.93 - (4,599.93) 0.0%6313762 Supplies-Office - - - 571.40 - 571.40 1,200.00 628.60 52.4%6313774 Sand 340.61 100.00 240.61 6,036.72 6,360.00 (323.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 100,760.00 9,059.49 101,810.00 (8,009.49) -7.9%6313778 Small Tools & Non-Capital Equip 157.85 100.00 57.85 4,796.65 6,700.00 (1,903.35) 7,000.00 2,203.35 31.5%6313780 Sod - - - 5,159.85 4,250.00 909.85 5,750.00 590.15 10.3%6313782 Topdressing - - - 5,035.98 5,000.00 35.98 7,600.00 2,564.02 33.7%Total-CM-SUPPLIES & MATERIALS12,156.45 10,870.00 1,286.45 311,544.49 281,100.00 30,444.49 317,460.00 5,915.51 1.9%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,557.49 1,500.00 57.49 14,258.71 11,500.00 2,758.71 16,000.00 1,741.29 10.9%6315685 CM-R&M-Bldngs & Othr Structures 87.50 - 87.50 1,338.50 500.00 838.50 500.00 (838.50) -167.7%6315690 CM-R&M-Equipment 2,812.81 2,000.00 812.81 40,366.19 40,700.00 (333.81) 46,100.00 5,733.81 12.4%6315692 CM-R&M-Irrigation System 768.71 1,000.00 (231.29) 13,520.62 12,450.00 1,070.62 15,450.00 1,929.38 12.5%6315696 CM-R&M-Pumps 500.00 1,000.00 (500.00) 6,862.44 9,000.00 (2,137.56) 10,500.00 3,637.56 34.6%6315815 CM-R&M-Trees-Pruning Etc - 2,000.00 (2,000.00) 4,054.64 5,000.00 (945.36) 9,000.00 4,945.36 54.9%Total-CM-REPAIRS & MAINTENANCE 5,726.51 7,500.00 (1,773.49) 80,401.10 79,150.00 1,251.10 97,550.00 17,148.90 17.6%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs 5.38 - 5.38 48.42 - 48.42 - (48.42) 0.0%6317836 Utilities-Natural Gas/LPG - 150.00 (150.00) - 1,350.00 (1,350.00) 1,800.00 1,800.00 0.0%6317840 Telephones 956.64 800.00 156.64 7,773.73 7,200.00 573.73 9,600.00 1,826.27 19.0%Total-CM-UTILITIES 962.02 950.00 12.02 7,822.15 8,550.00 (727.85) 11,400.00 3,577.85 31.4%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 4,500.00 4,500.00 - 6,000.00 1,500.00 25.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 502.63 - 502.63 4,557.89 - 4,557.89 - (4,557.89) 0.0%6319150 Dues & Subscriptions - - - 455.00 600.00 (145.00) 900.00 445.00 49.4%6319170 Employee Education - 50.00 (50.00) 560.00 450.00 110.00 600.00 40.00 6.7%6319197 Equipment Rental - 200.00 (200.00) 2,946.41 3,700.00 (753.59) 4,200.00 1,253.59 29.8%6319206 Licenses & Permits - 250.00 (250.00) 60.00 1,450.00 (1,390.00) 1,600.00 1,540.00 96.3%6319490 Miscellaneous - 100.00 (100.00) 618.85 900.00 (281.15) 1,200.00 581.15 48.4%6319718 Safety Equipment & Training 184.57 200.00 (15.43) 2,350.56 3,100.00 (749.44) 3,400.00 1,049.44 30.9%6319822 Uniforms 540.45 820.00 (279.55) 6,670.17 7,380.00 (709.83) 9,840.00 3,169.83 32.2%Total-CM-OTHER EXPENSES 1,727.65 2,120.00 (392.35) 24,218.88 24,080.00 138.88 31,740.00 7,521.12 23.7%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementMarch 2009Annual Budget4 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,140.40 1,104.00 36.40 11,118.90 9,936.00 1,182.90 13,248.00 2,129.10 16.1%6321325 Insurance-Workers Comp 293.91 1,078.00 (784.09) 3,657.94 9,974.00 (6,316.06) 13,257.00 9,599.06 72.4%6321800 Taxes-Employer Payroll 1,159.67 1,636.00 (476.33) 10,539.63 15,347.00 (4,807.37) 20,368.00 9,828.37 48.3%6321880 Wages-Hourly 9,797.00 13,141.00 (3,344.00) 109,511.81 118,269.00 (8,757.19) 157,692.00 48,180.19 30.6%6321882 Wages-Overtime - - - 5,092.68 5,005.00 87.68 5,915.00 822.32 13.9%Total-CM-LM-SALARIES & BENEFITS12,390.98 16,959.00 (4,568.02) 139,920.96 158,531.00 (18,610.04) 210,480.00 70,559.04 33.5%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 367.79 800.00 (432.21) 1,025.00 657.21 64.1%6323788 Uniforms 183.65 290.00 (106.35) 2,648.08 2,610.00 38.08 3,480.00 831.92 23.9%Total-CM-LM-SUPPLIES & MATERIALS183.65 365.00 (181.35) 3,015.87 3,410.00 (394.13) 4,505.00 1,489.13 33.1%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 250.00 (250.00) 1,826.70 3,250.00 (1,423.30) 4,250.00 2,423.30 57.0%Total-CM-LM-REPAIRS & MAINTENANCE - 250.00 (250.00) 1,826.70 3,250.00 (1,423.30) 4,250.00 2,423.30 57.0%103,765.49 122,570.00 (18,804.51) 1,266,049.01 1,326,520.00 (60,470.99) 1,699,984.00 433,934.99 25.5% March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 3,739.41 7,000.00 (3,260.59) 39,850.17 63,000.00 (23,149.83) 84,000.00 44,149.83 52.6%6337842 Utilities-Water1,547.95 1,504.00 43.95 24,566.92 16,894.00 7,672.92 21,871.00 (2,695.92) -12.3%Total-CM-WATER & ENERGY 5,287.36 8,504.00 (3,216.64) 64,417.09 79,894.00 (15,476.91) 105,871.00 41,453.91 39.2%Month to Date Year to Date Annual BudgetYear to DateSilverrock ResortCourse Maintenance Water & EnergyMarch 2009Total -COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementMarch 2009Annual BudgetMonth to Date5 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 600.00 600.00 - 4,620.00 4,620.00 - 6,180.00 1,560.00 25.2%6411320 Insurance-Group 252.98 720.00 (467.02) 828.43 6,480.00 (5,651.57) 8,640.00 7,811.57 90.4%6411325 Insurance-Workers Comp 361.06 1,682.00 (1,320.94) 2,846.97 12,015.00 (9,168.03) 16,511.00 13,664.03 82.8%6411800 Taxes-Employer Payroll 1,679.34 1,459.00 220.34 10,570.07 10,421.00 149.07 14,318.00 3,747.93 26.2%6411880 Wages-Hourly 12,032.25 11,715.00 317.25 86,764.73 83,685.00 3,079.73 114,990.00 28,225.27 24.5%6411882 Wages-Overtime 3.00 - 3.00 852.17 - 852.17 - (852.17) 0.0%Total-CBR-SALARIES & BENEFITS14,928.63 16,176.00 (1,247.37) 106,482.37 117,221.00 (10,738.63) 160,639.00 54,156.63 33.7%641-CBR-SUPPLIES & MATERIALS Supplies-Carts 620.28 50.00 570.28 1,487.25 2,200.00 (712.75) 2,350.00 862.75 36.7%6413742 Supplies-Expendable 1,341.53 150.00 1,191.53 5,420.58 4,700.00 720.58 5,850.00 429.42 7.3%6413752 Supplies-Range Balls - - - 5,820.00 6,000.00 (180.00) 6,000.00 180.00 3.0%6413762 Supplies-Office - 50.00 (50.00) - 375.00 (375.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - 70.00 (70.00) - 210.00 (210.00) 420.00 420.00 100.0%6413786 Supplies-Towels - 72.00 (72.00) 3,974.08 2,076.00 1,898.08 2,292.00 (1,682.08) -73.4%6413796 Supplies-Bottled Water1,668.55 2,700.00 (1,031.45) 12,830.62 16,550.00 (3,719.38) 23,950.00 11,119.38 46.4%Total-CBR-SUPPLIES & MATERIALS3,630.36 3,092.00 538.36 29,532.53 32,111.00 (2,578.47) 41,387.00 11,854.47 28.6%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts 720.00 720.00 - 6,555.00 6,480.00 75.00 8,640.00 2,085.00 24.1%6415690 CBR-R&M-Equipment - 125.00 (125.00) 669.67 1,125.00 (455.33) 1,500.00 830.33 55.4%6415695 CBR-R&M-Cart Maintenance & Repair 888.17 250.00 638.17 4,467.36 3,250.00 1,217.36 4,000.00 (467.36) -11.7%Total-CBR-REPAIRS & MAINTENANCE 1,608.17 1,095.00 513.17 11,692.03 10,855.00 837.03 14,140.00 2,447.97 17.3%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps - 500.00 (500.00) 5,605.00 4,350.00 1,255.00 5,000.00 (605.00) -12.1%6419094 Contract Services-Laundry/Linen 1,108.55 500.00 608.55 3,834.64 4,500.00 (665.36) 6,000.00 2,165.36 36.1%6419220 Freight/Delivery - 75.00 (75.00) 7.56 675.00 (667.44) 900.00 892.44 99.2%6419490 Miscellaneous - 125.00 (125.00) 506.01 775.00 (268.99) 1,150.00 643.99 56.0%6419820 Uniforms - 925.00 (925.00) 1,665.22 3,925.00 (2,259.78) 5,625.00 3,959.78 70.4%Total-CBR-OTHER EXPENSES 1,108.55 2,125.00 (1,016.45) 11,618.43 14,225.00 (2,606.57) 18,675.00 7,056.57 37.8%TOTAL-CARTS,BAGROOM & RANGE 21,275.71 22,488.00 (1,212.29) 159,325.36 174,412.00 (15,086.64) 234,841.00 75,515.64 32.2%643-CS-SALARIES & BENEFITS6431175 Employee Meals 540.00 540.00 - 3,660.00 3,660.00 - 4,860.00 1,200.00 24.7%6431325 Insurance-Workers Comp 151.02 400.00 (248.98) 1,023.48 2,446.00 (1,422.52) 3,446.00 2,422.52 70.3%6431800 Taxes-Employer Payroll 666.88 608.00 58.88 3,974.39 3,716.00 258.39 5,220.00 1,245.61 23.9%6431880 Wages-Hourly 5,010.00 4,880.00 130.00 32,398.00 29,840.00 2,558.00 41,920.00 9,522.00 22.7%6431882 Wages-Overtime 24.00 - 24.00 75.00 - 75.00 - (75.00) 0.0%Total-CS-SALARIES & BENEFITS6,391.90 6,428.00 (36.10) 41,130.87 39,662.00 1,468.87 55,446.00 14,315.13 25.8%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) 4,186.80 800.00 3,386.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 450.00 (406.90) 600.00 556.90 92.8%6439820 Uniforms - 75.00 (75.00) 2,325.25 1,350.00 975.25 1,900.00 (425.25) -22.4%Total-CS-OTHER EXPENSES - 225.00 (225.00) 6,845.70 2,800.00 4,045.70 3,750.00 (3,095.70) -82.6%Total-COURSE SERVICES 6,391.90 6,653.00 (261.10) 47,976.57 42,462.00 5,514.57 59,196.00 11,219.43 19.0%TOTAL OUTSIDE SERVICES 27,667.61 29,141.00 (1,473.39) 207,301.93 216,874.00 (9,572.07) 294,037.00 89,830.77 30.6%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementMarch 2009Annual Budget6 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 383.64 3,600.00 (3,216.36) 4,800.00 4,416.36 92.0%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 383.64 3,600.00 (3,216.36) 4,800.00 4,416.36 92.0%65-CH-UTILITIES6507836 Utilities-Natural Gas445.09 300.00 145.09 3,489.53 2,700.00 789.53 3,600.00 110.47 3.1%6507838 Utilities-Sewer- 200.00 (200.00) 600.00 1,800.00 (1,200.00) 2,400.00 1,800.00 75.0%6507840 Utilities-Telephone1,074.75 1,000.00 74.75 9,585.16 9,000.00 585.16 12,000.00 2,414.84 20.1%6507842 Utilities-Water184.70 200.00 (15.30) 2,831.38 1,800.00 1,031.38 2,400.00 (431.38) -18.0%6507844 Utilities-Cable535.18 317.00 218.18 2,950.28 2,853.00 97.28 3,804.00 853.72 22.4%Total-CH-UTILITIES 2,239.72 2,017.00 222.72 19,456.35 18,153.00 1,303.35 24,204.00 4,747.65 19.6%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,900.00 1,825.00 75.00 16,988.70 17,025.00 (36.30) 22,500.00 5,511.30 24.5%6509099 Contract Services-Security9,946.78 8,200.00 1,746.78 76,675.82 73,800.00 2,875.82 98,400.00 21,724.18 22.1%6509215 Flowers & Decorations- 100.00 (100.00) - 2,300.00 (2,300.00) 2,600.00 2,600.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 193.93 1,800.00 (1,606.07) 2,400.00 2,206.07 91.9%6509718 Safety Equipment & Training- 100.00 (100.00) 108.62 900.00 (791.38) 1,200.00 1,091.38 90.9%Total-CH-OTHER EXPENSES 12,137.87 10,425.00 1,712.87 97,063.82 95,825.00 1,238.82 127,100.00 30,036.18 23.6%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures507.00 200.00 307.00 3,350.00 1,800.00 1,550.00 2,400.00 (950.00) -39.6%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 2,019.10 3,600.00 (1,580.90) 4,800.00 2,780.90 57.9%6515690 CH-R&M-Equipment Repair802.80 400.00 402.80 802.80 3,600.00 (2,797.20) 4,800.00 3,997.20 83.3%Total-CH-REPAIRS & MAINTENANCE 1,309.80 1,000.00 309.80 6,171.90 9,000.00 (2,828.10) 12,000.00 5,828.10 48.6%Total CLUBHOUSE 15,687.39 13,842.00 1,845.39 123,075.71 126,578.00 (3,502.29) 168,104.00 11,656.20 6.9%Month to Date Year to DateSilverRock ResortClubhouse Expense StatementMarch 2009Annual Budget7 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 540.00 540.00 - 720.00 180.00 25.0%6601320 Insurance-Group 373.54 450.00 (76.46) 2,315.34 4,050.00 (1,734.66) 5,400.00 3,084.66 57.1%6601325 Insurance-Workers Comp 75.00 205.00 (130.00) 762.78 1,845.00 (1,082.22) 2,460.00 1,697.22 69.0%6601720 Salaries 2,500.00 2,500.00 - 23,750.00 22,500.00 1,250.00 30,000.00 6,250.00 20.8%6601800 Taxes-Employer Payroll 311.00 311.00 - 3,265.50 2,799.00 466.50 3,732.00 466.50 12.5%Total-MKT-SALARIES & BENEFITS 3,319.54 3,526.00 (206.46) 30,633.62 31,734.00 (1,100.38) 42,312.00 11,678.38 27.6%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 900.00 (900.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery - 125.00 (125.00) 2,755.74 4,050.00 (1,294.26) 4,425.00 1,669.26 37.7%- 225.00 (225.00) 2,755.74 4,950.00 (2,194.26) 5,625.00 2,869.26 51.0%66-MKT-UTILITIES6607840 Utilities-Telephone 56.82 100.00 (43.18) 489.30 900.00 (410.70) 1,200.00 710.70 59.2%Total-MKT-UTILITIES 56.82 100.00 (43.18) 489.30 900.00 (410.70) 1,200.00 710.70 59.2%66-MKT-OTHER EXPENSES6609010 Advertising 18,435.38 24,327.00 (5,891.62) 178,859.23 181,803.00 (2,943.77) 225,134.00 46,274.77 20.6%6609040 Business Meals - 25.00 (25.00) - 225.00 (225.00) 300.00 300.00 100.0%6609080 Collateral Material - 500.00 (500.00) 2,704.05 7,000.00 (4,295.95) 9,000.00 6,295.95 70.0%6609102 Contract Services-Web Page 99.00 175.00 (76.00) 1,287.00 1,575.00 (288.00) 2,100.00 813.00 38.7%6609490 Miscellaneous - 50.00 (50.00) - 250.00 (250.00) 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) 1.59 450.00 (448.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) 197.27 2,700.00 (2,502.73) 2,925.00 2,727.73 93.3%6609634 Promotion-Media/Vendor - 50.00 (50.00) - 550.00 (550.00) 700.00 - 0.0%6609150 Dues and Subscriptions 695.00 300.00 395.00 1,066.71 735.00 331.71 735.00 (331.71) -45.1%6609820 Uniforms - 50.00 (50.00) 38.41 550.00 (511.59) 600.00 561.59 93.6%Total-MKT-OTHER EXPENSES 19,229.38 25,602.00 (6,372.62) 186,320.83 202,338.00 (16,017.17) 248,944.00 61,923.17 24.9%Total-MARKETING 22,605.74 29,453.00 (6,847.26) 220,199.49 239,922.00 (19,722.51) 298,081.00 77,181.51 25.9%Month to Date Year to DateSilverRock ResortMarketing Expense StatementMarch 2009Annual Budget8 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 1,620.00 1,620.00 - 2,160.00 540.00 25.0%6701320 Insurance-Group1,669.55 2,250.00 (580.45) 12,579.84 20,250.00 (7,670.16) 27,000.00 14,420.16 53.4%6701325 Insurance-Workers Comp471.48 1,406.00 (934.52) 4,986.35 12,654.00 (7,667.65) 16,872.00 11,885.65 70.4%6701720 Salaries 13,503.32 14,416.00 (912.68) 130,462.57 129,744.00 718.57 172,992.00 42,529.43 24.6%6701800 Taxes-Employer Payroll 1,278.60 2,135.00 (856.40) 12,490.60 19,215.00 (6,724.40) 25,620.00 13,129.40 51.2%6701880 Wages-Hourly2,212.44 2,730.00 (517.56) 20,792.12 24,570.00 (3,777.88) 32,760.00 11,967.88 36.5%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 19,315.39 23,117.00 (3,801.61) 182,931.48 208,053.00 (25,121.52) 277,404.00 94,472.52 34.1%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer210.11 800.00 (589.89) 2,494.36 8,400.00 (5,905.64) 10,800.00 8,305.64 76.9%6703762 Supplies-Office 100.91 125.00 (24.09) 2,167.16 1,125.00 1,042.16 1,500.00 (667.16) -44.5%6703768 Supplies-Printing & Stationery83.00 400.00 (317.00) 994.61 2,000.00 (1,005.39) 3,200.00 2,205.39 68.9%6703778Supplies-Small Tools/Non-Capital - 100.00 (100.00) 5.39 700.00 (694.61) 900.00 894.61 99.4%Total-G&A-SUPPLIES & MATERIALS 394.02 1,425.00 (1,030.98) 5,661.52 12,225.00 (6,563.48) 16,400.00 10,738.48 65.5%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment288.53 100.00 188.53 790.74 900.00 (109.26) 1,200.00 409.26 34.1%Total-G&A-REPAIRS & MAINTENANCE 288.53 100.00 188.53 790.74 900.00 (109.26) 1,200.00 409.26 34.1%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 3,600.00 3,600.00 - 4,800.00 1,200.00 25.0%6709150 Dues & Subscriptions- 50.00 (50.00) 384.21 900.00 (515.79) 1,500.00 1,115.79 74.4%6709180 Employee Recruiting/Relocation28.00 200.00 (172.00) 725.00 4,600.00 (3,875.00) 4,600.00 3,875.00 84.2%6709197 Equipment Rental631.75 350.00 281.75 4,144.33 3,150.00 994.33 4,200.00 55.67 1.3%6709202 Fees-Bank20.00 90.00 (70.00) 309.75 810.00 (500.25) 1,080.00 770.25 71.3%6709208 Fees-Payroll Processing705.88 550.00 155.88 7,128.60 4,950.00 2,178.60 6,600.00 (528.60) -8.0%6709220 Freight/Delivery46.65 50.00 (3.35) 46.65 450.00 (403.35) 600.00 553.35 92.2%6709490 Miscellaneous 99.96 100.00 (0.04) 542.41 900.00 (357.59) 1,200.00 657.59 54.8%6709620 Postage/Mail Services 156.99 75.00 81.99 1,149.28 675.00 474.28 900.00 (249.28) -27.7%6709625 Professional Fees190.00 400.00 (210.00) 3,540.16 3,600.00 (59.84) 4,800.00 1,259.84 26.2%6709636 Promotion/Entertainment87.82 100.00 (12.18) 2,793.74 3,700.00 (906.26) 4,000.00 1,206.26 30.2%6709722 Seminars & Training250.00 200.00 50.00 1,374.45 1,800.00 (425.55) 2,400.00 1,025.55 42.7%6709810 Travel - - - 240.40 200.00 40.40 1,100.00 859.60 78.1%6709820 Uniforms - 75.00 (75.00) 437.95 825.00 (387.05) 1,050.00 612.05 58.3%Total-G&A-OTHER EXPENSES 2,617.05 2,640.00 (22.95) 26,621.89 30,160.00 (3,538.11) 38,830.00 12,413.07 32.0%Total-GENERAL & ADMINISTRATIVE22,614.99 27,282.00 (4,667.01) 216,005.63 251,338.00 (35,332.37) 333,834.00 118,033.33 35.4%Month to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementMarch 2009Annual Budget9 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,581.04 11,581.00 0.04 100,685.27 104,229.00 (3,543.73) 138,972.00 38,286.73 27.5%6800193 Equipment Leases-Course Maint 16,244.12 20,000.00 (3,755.88) 146,791.37 180,000.00 (33,208.63) 240,000.00 93,208.63 38.8%6800194 Equipment Leases-Trailer 540.00 600.00 (60.00) 5,358.94 5,400.00 (41.06) 7,200.00 1,841.06 25.6%6800195 Equipment Leases-Software 1,791.93 1,525.00 266.93 16,127.37 13,725.00 2,402.37 18,300.00 2,172.63 11.9%6800196 Equipment Leases-GPS 6,840.14 7,400.00 (559.86) 61,561.26 66,600.00 (5,038.74) 88,800.00 27,238.74 30.7%6800197 Equipment Leases-Others 2,280.56 - 2,280.56 31,887.10 - 31,887.10 - - 0.0%Total-LEASES 39,277.79 41,106.00 (1,828.21) 362,411.31 369,954.00 (7,542.69) 493,272.00 162,747.79 33.0%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee (7,961.32) (9,048.00) 1,086.68 77,416.18 63,852.00 13,564.18 90,000.00 12,583.82 14.0%6900210 FF&E Reserve 11,105.65 13,318.00 (2,212.35) 45,139.52 55,249.00 (10,109.48) 75,140.00 30,000.48 39.9%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) 21,622.51 31,500.00 (9,877.49) 42,000.00 20,377.49 48.5%Total-MISC OTHER EXPENSES6,264.88 7,770.00 (1,505.12) 164,990.34 170,601.00 (5,610.66) 227,140.00 62,149.66 27.4%Annual BudgetMonth to Date Year to DateOperating Leases & Miscellaneous Other Expense StatementMarch 200910 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 8Sales11Promotion84Golf Industry9534VIPCelebrity2PGA Comp48 6334Charity/Gift Certificate71534Rain/Wind Checks10 314Club Staff53 70103LQ HS Golf68127 175 301 0 0 011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2008-2009March 2009 Date Time Description CategoryPlayers3/6/2009 11:30 Gino Lamont Media 23/7/2009 1:45 Judd Hirsch Celebrity 23/13/2009 11:30 Gino Lamont Media 23/18/2009 12:00 Yancey Beamer Promotion 23/20/2009 11:30 Gino Lamont Media 23/27/2009 11:30 Gino Lamont Media 23/28/2009 9:15 Angela Bragg w/ West Coast Golfer Promotion 212