Loading...
02 August 2009 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2009 – August 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 August Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 87,994.00 72,315.00 15,679.00 21.7% 182,584.50 158,691.00 23,893.50 2,980,503.00 2,797,918.50 6%401000 Miscellaneous Golf Revenue 3,539.50 3,970.00 (430.50) -10.8% 9,364.60 11,432.00 (2,067.40) 109,297.00 99,932.40 9%410000 Revenue-Golf Shop 8,472.70 8,100.00 372.70 4.6% 16,673.82 18,851.00 (2,177.18) 325,551.00 308,877.18 5%420000 Revenue-F&B Concession 500.00 500.00 - 0.0% 1,000.00 1,000.00 - 12,000.00 11,000.00 8%890000 Interest Income 4.14 - 4.14 0.0% 11.51 - 11.51 - (11.51) 0%Total Income100,510.34 84,885.00 15,625.34 18.4% 209,634.43 189,974.00 19,660.43 3,427,351.00 3,217,716.57 6%Cost of Goods Sold510000 COS-Golf Shop 5,277.03 4,299.00 978.03 -22.8% 9,726.16 10,005.05 278.89 172,786.05 163,059.89 6%Total COS5,277.03 4,299.00 978.03 -22.8% 9,726.16 10,005.05 278.89 172,786.05 163,059.89 6%Gross Profit95,233.31 80,586.00 14,647.31 18.2% 199,908.27 179,968.95 19,939.32 3,254,564.95 3,054,656.68 6%Expenses610000 Golf Pro Shop 13,195.93 18,212.00 5,016.07 27.5% 26,987.15 37,024.00 10,036.85 243,485.00 216,497.85 11%630000 Course Maintenance 125,867.38 126,659.00 791.62 0.6% 234,966.50 248,568.00 13,601.50 1,594,579.00 1,359,612.50 15%633000 Maintenance Water & Energy 9,303.47 6,659.00 (2,644.47) -39.7% 16,646.76 13,473.00 (3,173.76) 86,871.00 70,224.24 19%640000 Outside Services 12,989.55 15,374.00 2,384.45 15.5% 29,016.11 33,696.00 4,679.89 277,000.00 247,983.89 10%650000 Clubhouse 10,775.24 9,742.00 (1,033.24) -10.6% 21,774.28 19,484.00 (2,290.28) 118,900.00 97,125.72 18%660000 Marketing 11,431.80 9,097.00 (2,334.80) -25.7% 19,872.65 15,104.00 (4,768.65) 256,759.00 236,886.35 8%670000 General & Administrative21,361.81 25,562.00 4,200.19 16.4% 43,070.22 50,974.00 7,903.78 316,394.00 273,323.78 14%680000 Leases 39,572.95 37,453.00 (2,119.95) -5.7% 79,926.52 74,906.00 (5,020.52) 432,204.00 352,277.48 18%690000 Miscellaneous Other Expense 23,333.58 27,340.00 4,006.42 14.7% 53,029.32 78,555.00 25,525.68 211,610.00 158,580.68 25%Total Expenses267,831.71 276,098.00 8,266.29 3.0% 525,289.51 571,784.00 46,494.49 3,537,802.00 3,012,512.49 15%Net Income (172,598.40) (195,512.00) 22,913.60 11.7%(325,381.24) (391,815.05) 66,433.81 (283,237.05) 42,144.19 115%Rounds of Golf PlayedPaid Rounds Played 2,356 2,150 206 9.6% 5,053 3,950 1,103 39,150 34,097 13%Ave $ Per Paid Round Green Fee 37.35 33.63 3.71 11.0% 36.13 40.17 (4.04) 76.13 40.00 47%Ave $ Per Paid Round Merchandise 3.60 3.77 (0.17) -4.5% 3.30 4.77 (1.47) 8.07 4.77 41%Ave $ Per Paid Miscellaneous 1.50 1.85 (0.34) -18.6% 1.85 2.89 (1.04) 2.06 - 0%Month to Date Year to DateAugust 2009SilverRock ResortSummary Operating Income Statement1 Income August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 87,994.00 72,315.00 15,679.00 182,584.50 158,691.00 23,893.50 2,980,503.002,797,918.506%4010000 Rider Fee 400.00 180.00 220.00 1,700.00 2,309.00 (609.00) 5,829.004,129.0029%4040000 Club Rental 955.00 990.00 (35.00) 1,630.00 2,173.00 (543.00) 26,168.0024,538.006%4050000 Driving Range 1,942.00 1,800.00 142.00 3,775.00 3,950.00 (175.00) 44,300.0040,525.009%4060000 Handicap Fees 145.00 - 145.00 235.00 - 235.00 8,000.00 7,765.003%4080000 GPS Advertising - 1,000.00 (1,000.00) - 2,000.00 (2,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 97.50 - 97.50 120.00 - 120.00 - (120.00) 0% Total Revenue Fees 91,533.50 76,285.00 15,248.50 191,949.10 170,123.00 21,826.10 3,089,800.00 2,897,850.90 6%Total Income 91,533.50 76,285.00 15,248.50 191,949.10 170,123.00 21,826.10 3,089,800.00 2,897,850.90 6%Month to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueAugust 20092 Income August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 185.39 - 185.39 425.38 - 425.38 4100110 Sales Hard Goods 4,237.38 2,835.00 1,402.38 8,341.80 6,598.00 1,743.80 113,943.00 105,601.20 7%4100112 Sales-Soft Goods 5,951.13 5,265.00 686.13 11,149.34 12,253.00 (1,103.66) 211,608.00 200,458.66 5%5100639 GS-Discounts-Mdse (1,901.20) - (1,901.20) (3,242.70) - (3,242.70) - 3,242.70 0% Total Revenue Golf Shop 8,472.70 8,100.00 372.70 16,673.82 18,851.00 (2,177.18) 325,551.00 309,302.56 5%COS 5100150 COS-GS-Hard Goods 2,630.83 1,559.25 1,071.58 4,784.87 3,628.90 1,155.97 62,668.65 57,883.78 8%5100151 COS-GS-Soft Goods 2,585.81 2,895.75 (309.94) 4,809.03 6,739.15 (1,930.12) 116,384.40 111,575.37 4%5100152 COS-GS-Purchase Disc - (223.00) 223.00 (78.95) (519.00) 440.05 (8,953.00) (8,874.05) -1%5100220 COS-GS-Freight Merch 60.39 67.00 (6.61) 211.21 156.00 55.21 2,686.00 2,474.79 8%Cost of Sales - Golf Shop 5,277.03 4,299.00 978.03 9,726.16 10,005.05 (278.89) 172,786.05 163,059.89 6%Gross Profit 3,195.67 3,801.00 (605.33) 6,947.66 8,845.95 (1,898.29) 152,764.95 146,242.67 4%COS % 62.3% 53.1% -9.2% 58.3% 53.1% -5.3% 53.1% 52.7% 1%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 360.00 360.00 - 720.00 720.00 - 5,400.00 4,680.00 13%6101320 Insurance Group 1,890.98 1,986.00 (95.02) 3,851.16 3,972.00 (120.84) 26,811.00 22,959.84 14%6101325 Insurance-Workers Comp 365.51 713.00 (347.49) 888.40 1,426.00 (537.60) 9,229.00 8,340.60 10%6101720 Salaries 3,545.46 3,582.00 (36.54) 7,090.92 7,164.00 (73.08) 20,796.00 13,705.08 34%6101800 Taxes-Employer Payroll 688.96 1,554.00 (865.04) 1,479.27 3,108.00 (1,628.73) 20,123.00 18,643.73 7%6101880 Wages-Hourly 5,548.17 8,897.00 (3,348.83) 11,417.39 17,794.00 (6,376.61) 140,831.00 129,413.61 8%6101882 Wages-Overtime 44.23 - 44.23 136.48 - 136.48 - 952.88 0%Total -PS-SALARIES & BENEFITS 12,443.31 17,092.00 (4,648.69) 25,583.62 34,184.00 (8,600.38) 223,190.00 198,695.74 11%61-PS OTHER EXPENSES6103762 Supplies-Office 109.99 300.00 (190.01) 109.99 600.00 (490.01) 2,950.00 2,840.01 4%6109090 Contract Services 500.00 500.00 - 1,000.00 1,000.00 - 6,000.00 5,000.00 17%6109220 Freight & Delivery 20.11 - 20.11 66.69 - 66.69 75.00 8.31 89%6109490 Miscellaneous - - - - - - 450.00 450.00 0%6109150 Dues and Subscriptions - - - - - - 2,000.00 2,000.00 0%6109500 ProShop-Over/Short 9.77 - 9.77 50.78 - 50.78 - (50.78) 0%6109722 Seminars/Training - 150.00 (150.00) - 900.00 (900.00) 5,490.00 5,490.00 0%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms - 100.00 (100.00) - 200.00 (200.00) 2,400.00 2,400.00 0%6117840 Telephones 112.75 70.00 42.75 176.07 140.00 36.07 840.00 663.93 0%Total PS-OTHER EXPENSES 752.62 1,120.00 (367.38) 1,403.53 2,840.00 (1,436.47) 20,295.00 18,891.47 7%Total Expenses13,195.93 18,212.00 (5,016.07) 26,987.15 37,024.00 (10,036.85) 243,485.00 217,587.21 11%Net Income(10,000.26) (14,411.00) 4,410.74 (20,039.49) (28,178.05) 8,138.56 (90,720.05) (71,344.54) -21%Month to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementAugust 20093 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 180.00 240.00 (60.00)420.00 480.00 (60.00) 2,880.00 2,460.00 85.4%6311320 Insurance-Group 9,211.37 8,740.00 471.37 18,481.54 17,480.00 1,001.54 104,880.00 86,398.46 82.4%6311325 Insurance-Workers Comp 2,064.99 3,226.00 (1,161.01) 4,958.71 6,452.00 (1,493.29) 39,329.00 34,370.29 87.4%6311720 Salaries 11,001.60 12,331.00 (1,329.40) 22,003.20 24,662.00 (2,658.80) 147,972.00 125,968.80 85.1%6311800 Taxes-Employer Payroll 4,111.63 7,033.00 (2,921.37) 8,285.24 14,066.00 (5,780.76) 86,420.00 78,134.76 90.4%6311880 Wages-Hourly 40,471.87 44,159.00 (3,687.13) 81,743.89 88,318.00 (6,574.11) 529,928.00 448,184.11 84.6%6311882 Wages-Overtime 151.22 - 151.22 490.66 - 490.66 16,234.00 15,743.34 97.0%Total-CM-SALARIES & BENEFITS67,192.68 75,729.00 (8,536.32) 136,383.24 151,458.00 (15,074.76) 927,643.00 791,259.76 85.3%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 924.72 2,500.00 (1,575.28) 2,755.25 6,000.00 (3,244.75) 29,300.00 26,544.75 90.6%6313744 Fertilizer 16,065.12 11,500.00 4,565.12 24,516.09 17,000.00 7,516.09 92,200.00 67,683.91 73.4%6313745 Herbicides - - - - - - 10,000.00 10,000.00 100.0%6313746 Flowers/Plants - - - - - - 3,500.00 3,500.00 100.0%6313748 Fuel-Gasoline 3,439.10 3,600.00 (160.90) 7,114.89 7,200.00 (85.11) 43,100.00 35,985.11 83.5%6313750 Golf Course Accessories - 200.00 (200.00) 143.55 400.00 (256.45) 8,000.00 7,856.45 98.2%6313756 POA Control - - - 190.49 - 190.49 7,000.00 6,809.51 97.3%6313758 Miscellaneous Supp 747.31 750.00 (2.69) 1,344.33 1,500.00 (155.67) 4,350.00 3,005.67 0.0%6313762 Supplies-Office 155.41 - 155.41 278.33 - 278.33 - (278.33) 0.0%6313774 Sand - 390.00 (390.00) - 780.00 (780.00) - - 0.0%6313775 Sand-Bunkers - - - - - - 11,460.00 11,460.00 100.0%6313776 Seed 758.53 350.00 408.53 758.53 700.00 58.53 91,810.00 91,051.47 99.2%6313778 Small Tools & Non-Capital Equip 81.26 100.00 (18.74) 750.15 200.00 550.15 5,000.00 4,249.85 85.0%6313780 Sod 3,198.17 1,000.00 2,198.17 3,198.17 2,000.00 1,198.17 5,750.00 2,551.83 44.4%6313782 Topdressing 2,001.98 1,250.00 751.98 2,001.98 2,500.00 (498.02) 7,600.00 5,598.02 73.7%Total-CM-SUPPLIES & MATERIALS27,371.60 21,640.00 5,731.60 43,051.76 38,280.00 4,771.76 319,070.00 276,018.24 86.5%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,095.99 1,500.00 595.99 3,959.74 3,000.00 959.74 17,000.00 13,040.26 76.7%6315685 CM-R&M-Bldngs & Othr Structures 490.98 250.00 240.98 611.98 500.00 111.98 1,750.00 1,138.02 65.0%6315690 CM-R&M-Equipment 4,557.17 4,400.00 157.17 9,201.08 8,800.00 401.08 35,700.00 26,498.92 74.2%6315692 CM-R&M-Irrigation System 3,017.29 2,100.00 917.29 4,357.54 4,200.00 157.54 16,050.00 11,692.46 72.9%6315696 CM-R&M-Pumps 5,037.59 1,000.00 4,037.59 5,037.59 2,000.00 3,037.59 10,500.00 5,462.41 52.0%6315815 CM-R&M-Trees-Pruning Etc - - - - - - 10,050.00 10,050.00 100.0%Total-CM-REPAIRS & MAINTENANCE 15,199.02 9,250.00 5,949.02 23,167.93 18,500.00 4,667.93 91,050.00 67,882.07 74.6%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs 4.11 - 4.11 9.49 - 9.49 (9.49) 0.0%6317836 Utilities-Natural Gas/LPG - 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 0.0%6317840 Telephones 1,054.63 850.00 204.63 1,974.09 1,700.00 274.09 10,200.00 8,225.91 80.6%Total-CM-UTILITIES 1,058.74 900.00 158.74 1,983.58 1,800.00 183.58 10,800.00 8,816.42 81.6%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 1,000.00 1,000.00 - 6,000.00 5,000.00 83.3%6319099 Contract Svcs-Security Bldgs - - - - - - - 0.0%6319100 Contract Svcs-Soil/Tissue Test - - - - - - 4,000.00 4,000.00 100.0%6319101 Contract Svcs-Trash Removal 487.83 524.00 (36.17) 975.66 1,048.00 (72.34) 6,288.00 5,312.34 0.0%6319150 Dues & Subscriptions - - - - 200.00 (200.00) 900.00 900.00 100.0%6319170 Employee Education - 50.00 (50.00) - 100.00 (100.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental 461.25 150.00 311.25 461.25 350.00 111.25 4,200.00 3,738.75 89.0%6319206 Licenses & Permits - 100.00 (100.00) - 200.00 (200.00) 680.00 680.00 100.0%6319490 Miscellaneous - 100.00 (100.00) 350.18 200.00 150.18 1,200.00 849.82 70.8%6319718 Safety Equipment & Training 117.12 100.00 17.12 329.26 200.00 129.26 2,600.00 2,270.74 87.3%6319822 Uniforms 959.17 820.00 139.17 1,702.02 1,640.00 62.02 9,840.00 8,137.98 82.7%Total-CM-OTHER EXPENSES 2,525.37 2,344.00 181.37 4,818.37 4,938.00 (119.63) 37,258.00 32,439.63 87.1%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementAugust 2009Annual Budget4 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,420.51 2,317.00 (896.49) 2,924.74 4,634.00 (1,709.26) 27,804.00 24,879.26 89.5%6321325 Insurance-Workers Comp 389.64 669.00 (279.36) 930.37 1,338.00 (407.63) 8,229.00 7,298.63 88.7%6321800 Taxes-Employer Payroll 745.20 1,458.00 (712.80) 1,515.13 2,916.00 (1,400.87) 18,154.00 16,638.87 91.7%6321880 Wages-Hourly 9,724.63 11,712.00 (1,987.37) 19,556.00 23,424.00 (3,868.00) 140,544.00 120,988.00 86.1%6321882 Wages-Overtime 16.48 - 16.48 249.49 - 249.49 5,272.00 5,022.51 95.3%Total-CM-LM-SALARIES & BENEFITS12,296.46 16,156.00 (3,859.54) 25,175.73 32,312.00 (7,136.27) 200,003.00 174,827.27 87.4%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 100.00 (100.00) - 200.00 (200.00) 1,025.00 1,025.00 100.0%6323788 Uniforms 223.51 290.00 (66.49) 385.89 580.00 (194.11) 3,480.00 3,094.11 88.9%Total-CM-LM-SUPPLIES & MATERIALS223.51 390.00 (166.49) 385.89 780.00 (394.11) 4,505.00 4,119.11 91.4%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 250.00 (250.00) - 500.00 (500.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE - 250.00 (250.00) - 500.00 (500.00) 4,250.00 4,250.00 100.0%125,867.38 126,659.00 (791.62) 234,966.50 248,568.00 (13,601.50) 1,594,579.00 1,359,612.50 85.3% August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 2,992.69 5,000.00 (2,007.31) 6,255.53 10,000.00 (3,744.47) 65,000.00 58,744.47 90.4%6337842 Utilities-Water6,310.78 1,659.00 4,651.78 10,391.23 3,473.00 6,918.23 21,871.00 11,479.77 52.5%Total-CM-WATER & ENERGY 9,303.47 6,659.00 2,644.47 16,646.76 13,473.00 3,173.76 86,871.00 70,224.24 80.8%Month to Date Year to Date Annual BudgetYear to DateSilverrock ResortCourse Maintenance Water & EnergyAugust 2009Total -COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementAugust 2009Annual BudgetMonth to Date5 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 420.00 420.00 - 840.00 840.00 - 6,960.00 6,120.00 87.9%6411320 Insurance-Group 63.25 662.00 (598.75) 126.50 1,324.00 (1,197.50) 7,944.00 7,817.50 98.4%6411325 Insurance-Workers Comp 262.97 975.00 (712.03) 677.72 2,278.00 (1,600.28) 16,162.00 15,484.28 95.8%6411800 Taxes-Employer Payroll 656.47 845.00 (188.53) 1,445.49 1,975.00 (529.51) 14,012.00 12,566.51 89.7%6411880 Wages-Hourly 6,574.14 6,790.00 (215.86) 14,115.03 15,865.00 (1,749.97) 112,549.00 98,433.97 87.5%6411882 Wages-Overtime - - - - - - - - 0.0%Total-CBR-SALARIES & BENEFITS7,976.83 9,692.00 (1,715.17) 17,204.74 22,282.00 (5,077.26) 157,627.00 140,422.26 89.1%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - - - - - - 2,350.00 2,350.00 100.0%6413742 Supplies-Expendable 1,273.06 150.00 1,123.06 1,865.10 300.00 1,565.10 5,000.00 3,134.90 62.7%6413752 Supplies-Range Balls - - - - - - 6,000.00 6,000.00 100.0%6413762 Supplies-Office - 25.00 (25.00) - 50.00 (50.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) - 144.00 (144.00) 892.00 892.00 100.0%6413796 Supplies-Bottled Water275.56 400.00 (124.44) 879.85 800.00 79.85 19,400.00 18,520.15 95.5%Total-CBR-SUPPLIES & MATERIALS1,548.62 647.00 901.62 2,744.95 1,294.00 1,450.95 34,587.00 31,842.05 92.1%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts 720.00 720.00 - 1,440.00 1,440.00 - 8,640.00 7,200.00 83.3%6415690 CBR-R&M-Equipment - 300.00 (300.00) 92.14 600.00 (507.86) 3,600.00 3,507.86 97.4%6415695 CBR-R&M-Cart Maintenance & Repair - 500.00 (500.00) 481.54 1,000.00 (518.46) 4,000.00 3,518.46 88.0%Total-CBR-REPAIRS & MAINTENANCE 720.00 1,520.00 (800.00) 2,013.68 3,040.00 (1,026.32) 16,240.00 14,226.32 87.6%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps 120.00 100.00 20.00 755.00 200.00 555.00 5,000.00 4,245.00 84.9%6419094 Contract Services-Laundry/Linen 797.95 500.00 297.95 2,094.80 1,000.00 1,094.80 6,000.00 3,905.20 65.1%6419220 Freight/Delivery - 75.00 (75.00) - 150.00 (150.00) 900.00 900.00 100.0%6419490 Miscellaneous - 75.00 (75.00) - 200.00 (200.00) 1,150.00 1,150.00 100.0%6419820 Uniforms - - - - - - 5,625.00 5,625.00 100.0%Total-CBR-OTHER EXPENSES 917.95 750.00 167.95 2,849.80 1,550.00 1,299.80 18,675.00 15,825.20 84.7%TOTAL-CARTS,BAGROOM & RANGE 11,163.40 12,609.00 (1,445.60) 24,813.17 28,166.00 (3,352.83) 227,129.00 202,315.83 89.1%643-CS-SALARIES & BENEFITS6431175 Employee Meals 180.00 180.00 - 360.00 360.00 - 3,300.00 2,940.00 89.1%6431325 Insurance-Workers Comp 56.16 116.00 (59.84) 157.91 232.00 (74.09) 2,069.00 1,911.09 92.4%6431800 Taxes-Employer Payroll 185.99 254.00 (68.01) 431.03 508.00 (76.97) 4,512.00 4,080.97 90.4%6431880 Wages-Hourly 1,404.00 2,040.00 (636.00) 3,254.00 4,080.00 (826.00) 36,240.00 32,986.00 91.0%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS1,826.15 2,590.00 (763.85) 4,202.94 5,180.00 (977.06) 46,121.00 41,918.06 90.9%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 50.00 (50.00) - 100.00 (100.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) - 100.00 (100.00) 600.00 600.00 100.0%6439820 Uniforms - 75.00 (75.00) - 150.00 (150.00) 1,900.00 1,900.00 100.0%Total-CS-OTHER EXPENSES - 175.00 (175.00) - 350.00 (350.00) 3,750.00 3,750.00 100.0%Total-COURSE SERVICES 1,826.15 2,765.00 (938.85) 4,202.94 5,530.00 (1,327.06) 49,871.00 45,668.06 91.6%TOTAL OUTSIDE SERVICES 12,989.55 15,374.00 (2,384.45) 29,016.11 33,696.00 (4,679.89) 277,000.00 244,233.89 88.2%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementAugust 2009Annual Budget6 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) - 800.00 (800.00) 4,800.00 4,800.00 100.0%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) - 800.00 (800.00) 4,800.00 4,800.00 100.0%65-CH-UTILITIES6507836 Utilities-Natural Gas20.81 300.00 (279.19) 462.33 600.00 (137.67) 3,600.00 3,137.67 87.2%6507838 Utilities-Sewer- 200.00 (200.00) - 400.00 (400.00) 2,400.00 2,400.00 100.0%6507840 Utilities-Telephone1,900.82 1,000.00 900.82 2,889.90 2,000.00 889.90 12,000.00 9,110.10 75.9%6507842 Utilities-Water114.76 200.00 (85.24) 708.42 400.00 308.42 2,400.00 1,691.58 70.5%6507844 Utilities-Cable326.47 317.00 9.47 646.37 634.00 12.37 3,800.00 3,153.63 83.0%Total-CH-UTILITIES 2,362.86 2,017.00 345.86 4,707.02 4,034.00 673.02 24,200.00 19,492.98 80.5%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 3,845.00 3,650.00 195.00 22,500.00 18,655.00 82.9%6509098 Contract Services-Refuse Dispose291.34 - 291.34 582.68 - 582.68 - (582.68) 0.0%6509099 Contract Services-Security4,565.04 4,100.00 465.04 10,470.72 8,200.00 2,270.72 49,200.00 38,729.28 78.7%6509215 Flowers & Decorations- 100.00 (100.00) - 200.00 (200.00) 2,600.00 2,600.00 100.0%6509490 Miscellaneous- 200.00 (200.00) - 400.00 (400.00) 2,400.00 2,400.00 100.0%6509718 Safety Equipment & Training- 100.00 (100.00) 223.86 200.00 23.86 1,200.00 976.14 81.3%Total-CH-OTHER EXPENSES 6,681.38 6,325.00 356.38 15,122.26 12,650.00 2,472.26 77,900.00 62,777.74 80.6%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures1,731.00 200.00 1,531.00 1,810.00 400.00 1,410.00 2,400.00 590.00 24.6%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) - 800.00 (800.00) 4,800.00 4,800.00 100.0%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 135.00 800.00 (665.00) 4,800.00 4,665.00 97.2%Total-CH-REPAIRS & MAINTENANCE 1,731.00 1,000.00 731.00 1,945.00 2,000.00 (55.00) 12,000.00 10,055.00 83.8%Total CLUBHOUSE 10,775.24 9,742.00 1,033.24 21,774.28 19,484.00 2,290.28 118,900.00 20,110.00 16.9%Month to Date Year to DateSilverRock ResortClubhouse Expense StatementAugust 2009Annual Budget7 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 120.00 120.00 - 720.00 600.00 83.3%6601320 Insurance-Group 286.36 331.00 (44.64) 572.72 662.00 (89.28) 3,972.00 3,399.28 85.6%6601325 Insurance-Workers Comp 100.00 143.00 (43.00) 237.50 286.00 (48.50) 1,713.00 1,475.50 86.1%6601720 Salaries 2,500.00 2,500.00 - 5,000.00 5,000.00 - 30,000.00 25,000.00 83.3%6601800 Taxes-Employer Payroll 311.00 311.00 - 622.00 622.00 - 3,735.00 3,113.00 83.3%Total-MKT-SALARIES & BENEFITS 3,257.36 3,345.00 (87.64) 6,552.22 6,690.00 (137.78) 40,140.00 33,587.78 83.7%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 140.15 200.00 (59.85) 1,200.00 1,059.85 88.3%6603768 Supplies-Printing & Stationery 187.43 - 187.43 187.43 - 187.43 4,425.00 4,237.57 95.8%187.43 100.00 87.43 327.58 200.00 127.58 5,625.00 5,297.42 94.2%66-MKT-UTILITIES6607840 Utilities-Telephone 47.38 100.00 (52.62) 93.38 200.00 (106.62) 1,200.00 1,106.62 92.2%Total-MKT-UTILITIES 47.38 100.00 (52.62) 93.38 200.00 (106.62) 1,200.00 1,106.62 92.2%66-MKT-OTHER EXPENSES6609010 Advertising 7,840.63 5,227.00 2,613.63 12,323.36 7,364.00 4,959.36 185,984.00 173,660.64 93.4%6609040 Business Meals - 25.00 (25.00) - 50.00 (50.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) 273.00 350.00 (77.00) 2,100.00 1,827.00 87.0%6609490 Miscellaneous - - - - - - 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0%6609630 Promotion - - - - - - 700.00 700.00 0.0%6609633 Promotion-Community - 75.00 (75.00) - 150.00 (150.00) 2,925.00 2,925.00 100.0%6609634 Promotion-Media/Vendor - - - - - - 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 7,939.63 5,552.00 2,387.63 12,899.47 8,014.00 4,885.47 209,794.00 190,394.53 90.8%Total-MARKETING 11,431.80 9,097.00 2,334.80 19,872.65 15,104.00 4,768.65 256,759.00 230,386.35 89.7%Month to Date Year to DateSilverRock ResortMarketing Expense StatementAugust 2009Annual Budget8 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 360.00 360.00 - 2,160.00 1,800.00 83.3%6701320 Insurance-Group1,332.28 1,458.00 (125.72) 2,507.37 2,916.00 (408.63) 17,496.00 14,988.63 85.7%6701325 Insurance-Workers Comp632.41 981.00 (348.59) 1,473.83 1,962.00 (488.17) 11,772.00 10,298.17 87.5%6701720 Salaries 13,503.32 14,534.00 (1,030.68) 27,006.64 29,068.00 (2,061.36) 174,408.00 147,401.36 84.5%6701800 Taxes-Employer Payroll 1,209.49 2,140.00 (930.51) 2,379.36 4,280.00 (1,900.64) 25,680.00 23,300.64 90.7%6701880 Wages-Hourly2,306.95 2,654.00 (347.05) 4,096.12 5,308.00 (1,211.88) 31,848.00 27,751.88 87.1%6701882 Wages-Overtime - - - 5.91 - 5.91 - (5.91) 0.0%Total-G&A-SALARIES & BENEFITS 19,164.45 21,947.00 (2,782.55) 37,829.23 43,894.00 (6,064.77) 263,364.00 225,534.77 85.6%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 800.00 (800.00) 350.00 1,600.00 (1,250.00) 10,800.00 10,450.00 96.8%6703762 Supplies-Office 54.82 125.00 (70.18) 173.23 250.00 (76.77) 1,500.00 1,326.77 88.5%6703768 Supplies-Printing & Stationery83.70 100.00 (16.30) 83.70 100.00 (16.30) 3,200.00 3,116.30 97.4%6703778Supplies-Small Tools/Non-Capital - - - - - - 900.00 900.00 100.0%Total-G&A-SUPPLIES & MATERIALS 138.52 1,025.00 (886.48) 606.93 1,950.00 (1,343.07) 16,400.00 15,793.07 96.3%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 800.00 800.00 - 4,800.00 4,000.00 83.3%6709150 Dues & Subscriptions- - - - 50.00 (50.00) 1,500.00 1,500.00 100.0%6709180 Employee Recruiting/Relocation28.00 - 28.00 84.00 - 84.00 2,600.00 2,516.00 96.8%6709197 Equipment Rental477.14 350.00 127.14 912.65 700.00 212.65 4,200.00 3,287.35 78.3%6709202 Fees-Bank31.49 90.00 (58.51) 58.45 180.00 (121.55) 1,080.00 1,021.55 94.6%6709208 Fees-Payroll Processing675.38 550.00 125.38 1,350.30 1,100.00 250.30 6,600.00 5,249.70 79.5%6709220 Freight/Delivery54.27 50.00 4.27 54.27 100.00 (45.73) 600.00 545.73 91.0%6709490 Miscellaneous 47.78 100.00 (52.22) 246.04 200.00 46.04 1,200.00 953.96 79.5%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services 20.00 75.00 (55.00) 288.16 150.00 138.16 900.00 611.84 68.0%6709625 Professional Fees190.00 400.00 (210.00) 665.00 800.00 (135.00) 4,800.00 4,135.00 86.1%6709636 Promotion/Entertainment134.78 100.00 34.78 134.78 200.00 (65.22) 2,600.00 2,465.22 94.8%6709722 Seminars & Training- 200.00 (200.00) - 400.00 (400.00) 2,400.00 2,400.00 100.0%6709810 Travel - 100.00 (100.00) - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms - 75.00 (75.00) 40.41 150.00 (109.59) 1,050.00 1,009.59 96.2%Total-G&A-OTHER EXPENSES 2,058.84 2,490.00 (431.16) 4,634.06 4,930.00 (295.94) 35,430.00 30,795.94 86.9%Total-GENERAL & ADMINISTRATIVE21,361.81 25,562.00 (4,200.19) 43,070.22 50,974.00 (7,903.78) 316,394.00 273,323.78 86.4%Month to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementAugust 2009Annual Budget9 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,581.04 11,581.00 0.04 23,162.08 23,162.00 0.08 138,972.00 115,809.92 83.3%6800193 Equipment Leases-Course Maint 16,244.12 16,500.00 (255.88) 32,488.24 33,000.00 (511.76) 189,000.00 156,511.76 82.8%6800194 Equipment Leases-Trailer 540.00 600.00 (60.00) 1,089.50 1,200.00 (110.50) 7,200.00 6,110.50 84.9%6800195 Equipment Leases-Software 1,791.93 1,372.00 419.93 3,583.86 2,744.00 839.86 8,232.00 4,648.14 56.5%6800196 Equipment Leases-GPS 6,840.14 7,400.00 (559.86) 14,398.09 14,800.00 (401.91) 88,800.00 74,401.91 83.8%6800197 Equipment Leases-Others 2,575.72 - 2,575.72 5,204.75 - 5,204.75 - - 0.0%Total-LEASES 39,572.95 37,453.00 2,119.95 79,926.52 74,906.00 5,020.52 432,204.00 357,482.23 82.7%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 21,030.15 22,394.00 (1,363.85) 40,616.99 48,381.00 (7,764.01) 90,000.00 49,383.01 54.9%6900210 FF&E Reserve 1,759.88 1,446.00 313.88 3,651.69 3,174.00 477.69 59,610.00 55,958.31 93.9%6900800 Personal Property Taxes - - - 5,106.54 20,000.00 (14,893.46) 20,000.00 14,893.46 74.5%6900323 Insurance-Commercial 543.55 3,500.00 (2,956.45) 3,654.10 7,000.00 (3,345.90) 42,000.00 38,345.90 91.3%Total-MISC OTHER EXPENSES23,333.58 27,340.00 (4,006.42) 53,029.32 78,555.00 (25,525.68) 211,610.00 158,580.68 74.9%Annual BudgetMonth to Date Year to DateSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementAugust 200910 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2009-20102009 2009 2009 2009 2009 2009Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia7SalesPromotionGolf Industry817VIPCelebrityPGA Comp70 68Charity/Gift Certificate14Rain/Wind Checks3Club Staff69 105LQ HS Golf16120000002010 2010 2010 2010 2010 2010Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2009-2010August 2010 Date Time Description CategoryPlayers8/1/2009 11:52 Kris Long - CBS2 Media 18/5/2009 9:30 Michael Dante Media 18/8/2009 9:07 Michael Dante Media 28/20/2009 9:15 Gino Lamont - KMIR Media 28/22/2009 10:00 Gino Lamont - KMIR Media 112