Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
02 August 2010 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2010 – August 2010 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 76,692.25 90,161.00 (13,468.75) -14.9% 166,479.50 187,076.00 (20,596.50) 3,111,458.00 2,944,978.50 5%401000 Miscellaneous Golf Revenue 3,482.00 4,919.00 (1,437.00) -29.2% 8,032.00 14,173.00 (6,141.00) 117,656.00 109,624.00 7%410000 Revenue-Golf Shop 7,240.90 9,143.00 (1,902.10) -20.8% 15,602.45 18,243.00 (2,640.55) 306,492.00 290,889.55 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 6.47 - 6.47 0.0% 10.31 - 10.31 - (10.31) 0%Total Income87,921.62 104,723.00 (16,801.38) -16.0% 191,124.26 220,492.00 (29,367.74) 3,547,606.00 3,356,481.74 5%Cost of Goods Sold510000 COS-Golf Shop 3,641.22 4,852.65 (1,211.43) 25.0% 8,507.51 9,682.65 1,175.14 162,670.60 154,163.09 5%Total COS3,641.22 4,852.65 (1,211.43) 25.0% 8,507.51 9,682.65 1,175.14 162,670.60 154,163.09 5%Gross Profit84,280.40 99,870.35 (15,589.95) -15.6% 182,616.75 210,809.35 (28,192.60) 3,384,935.40 3,202,318.65 5%Expenses610000 Golf Pro Shop 13,995.64 16,374.00 2,378.36 14.5% 29,629.61 33,848.00 4,218.39 230,213.00 200,583.39 13%630000 Course Maintenance 124,341.80 122,802.00 (1,539.80) -1.3% 243,538.30 241,259.00 (2,279.30) 1,541,961.00 1,298,422.70 16%633000 Maintenance Water & Energy 8,858.20 10,000.00 1,141.80 11.4% 17,313.92 19,460.00 2,146.08 85,358.00 68,044.08 20%640000 Outside Services 15,821.10 16,099.00 277.90 1.7% 30,737.12 33,705.00 2,967.88 297,478.00 266,740.88 10%650000 Clubhouse 9,983.91 10,636.00 652.09 6.1% 20,273.52 21,272.00 998.48 132,232.00 111,958.48 15%660000 Marketing 16,534.62 14,741.00 (1,793.62) -12.2% 33,409.68 27,092.00 (6,317.68) 262,644.00 229,234.32 13%670000 General & Administrative24,340.34 25,614.00 1,273.66 5.0% 47,701.79 51,078.00 3,376.21 314,808.00 267,106.21 15%680000 Leases 18,340.98 20,817.00 2,476.02 11.9% 37,117.86 41,634.00 4,516.14 247,740.00 210,622.14 15%690000 Miscellaneous Other Expense 22,913.73 25,313.00 2,399.27 9.5% 48,464.57 64,673.00 16,208.43 192,199.00 143,734.43 25%Total Expenses255,130.32 262,396.00 7,265.68 2.8% 508,186.37 534,021.00 25,834.63 3,304,633.00 2,796,446.63 15%(170,849.92) (162,525.65) (8,324.27) -5.1%(325,569.62) (323,211.65) (2,357.97) 80,302.40 405,872.02 -405%Rounds of Golf PlayedPaid Rounds Played 2,210 2,375 (165) -6.9% 4,806 4,975 (169) 39,150 34,344 12%Ave $ Per Paid Round Green Fee 34.70 37.96 (3.26) -8.6% 34.64 37.60 (2.96) 76.13 41.49 46%Ave $ Per Paid Round Merchandise 3.28 3.85 (0.57) -14.9% 3.25 3.67 (0.42) 8.07 4.82 40%Ave $ Per Paid Miscellaneous 1.58 2.07 (0.50) -23.9% 1.67 2.85 (1.18) 2.06 - 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateAugust 20101 Income August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 76,692.25 90,161.00 (13,468.75) 166,479.50 187,076.00 (20,596.50) 3,111,458.002,944,978.505%4010000 Rider Fee 375.00 238.00 137.00 925.00 2,812.00 (1,887.00) 6,522.005,597.0014%4040000 Club Rental 960.00 1,306.00 (346.00) 2,160.00 2,736.00 (576.00) 28,004.0025,844.008%4050000 Driving Range 2,147.00 2,375.00 (228.00) 3,872.00 5,625.00 (1,753.00) 48,130.0044,258.008%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,075.00 1,000.00 75.00 4,000.00 2,925.0027%4091000 Golf Professional Rental Fee - - - - - - 19,000.00 19,000.00 0%4092000 Golf Lessons - - - - - - - - 0% Total Revenue Fees 80,174.25 95,080.00 (14,905.75) 174,511.50 201,249.00 (26,737.50) 3,229,114.00 3,054,602.50 5%80,174.25 95,080.00 (14,905.75) 174,511.50 201,249.00 (26,737.50) 3,229,114.00 3,054,602.50 5%Total IncomeMonth to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueAugust 20102 Income August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 105.00 - 105.00 396.34 - 396.34 0 0 0%4100110 Sales Hard Goods 3,588.58 3,200.00 388.58 8,297.77 6,385.00 1,912.77 107,272.00 98,974.23 8%4100112 Sales-Soft Goods 4,859.00 5,943.00 (1,084.00) 9,206.50 11,858.00 (2,651.50) 199,220.00 190,013.50 5%5100639 GS-Discounts-Mdse (1,311.68) - (1,311.68) (2,298.16) - (2,298.16) - 2,298.16 0% Total Revenue Golf Shop 7,240.90 9,143.00 (1,902.10) 15,602.45 18,243.00 (2,640.55) 306,492.00 291,285.89 5%COS 5100150 COS-GS-Hard Goods 1,806.51 1,760.00 46.51 4,426.18 3,511.75 914.43 58,999.60 54,573.42 8%5100151 COS-GS-Soft Goods 1,806.43 3,268.65 (1,462.22) 4,008.91 6,521.90 (2,512.99) 109,571.00 105,562.09 4%5100152 COS-GS-Purchase Disc (68.43) (251.00) 182.57 (126.88) (501.00) 374.12 (8,429.00) (8,302.12) -2%5100220 COS-GS-Freight Merch 96.71 75.00 21.71 199.30 150.00 49.30 2,529.00 2,329.70 8%Cost of Sales - Golf Shop 3,641.22 4,852.65 (1,211.43) 8,507.51 9,682.65 (1,175.14) 162,670.60 154,163.09 5%Gross Profit 3,599.68 4,290.35 (690.67) 7,094.94 8,560.35 (1,465.41) 143,821.40 137,122.80 5%COS % 50.3% 53.1% 2.8% 54.5% 53.1% -1.5% 53.1% 52.9% 0%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,986.00 1,986.00 - 4,325.92 3,972.00 353.92 26,811.00 22,485.08 16%6101325 Insurance-Workers Comp 380.87 448.00 (67.13) 768.75 896.00 (127.25) 6,131.00 5,362.25 13%6101720 Salaries 3,900.00 3,750.00 150.00 7,098.49 7,500.00 (401.51) 45,000.00 37,901.51 16%6101800 Taxes-Employer Payroll 739.59 1,353.00 (613.41) 1,505.99 2,706.00 (1,200.01) 18,528.00 17,022.01 8%6101880 Wages-Hourly 5,596.53 7,117.00 (1,520.47) 12,035.28 14,234.00 (2,198.72) 103,818.00 91,782.72 12%6101882 Wages-Overtime 25.28 - 25.28 85.06 - 85.06 - 952.88 0%Total -PS-SALARIES & BENEFITS 12,988.27 15,014.00 (2,025.73) 26,539.49 30,028.00 (3,488.51) 205,688.00 180,186.45 12%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office - 500.00 (500.00) 1,109.20 1,000.00 109.20 6,000.00 4,890.80 18%6109090 Contract Services 500.00 500.00 - 1,000.00 1,000.00 - 6,000.00 5,000.00 17%6109220 Freight & Delivery 33.84 - 33.84 33.84 - 33.84 75.00 41.16 45%6109490 Miscellaneous - - - - - - 450.00 450.00 0%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short (37.47) - (37.47) 10.79 - 10.79 - (10.79) 0%6109722 Seminars/Training 372.75 150.00 222.75 372.75 1,400.00 (1,027.25) 5,890.00 5,517.25 6%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms - 100.00 (100.00) 298.36 200.00 98.36 2,400.00 2,101.64 12%6117840 Telephones 138.25 110.00 28.25 265.18 220.00 45.18 1,320.00 1,054.82 0%Total PS-OTHER EXPENSES 1,007.37 1,360.00 (352.63) 3,090.12 3,820.00 (729.88) 24,525.00 21,434.88 13%13,995.64 16,374.00 (2,378.36) 29,629.61 33,848.00 (4,218.39) 230,213.00 201,621.33 12%Net Income(10,395.96) (12,083.65) 1,687.69 (22,534.67) (25,287.65) 2,752.98 (86,391.60) (64,498.53) -25%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementAugust 20103 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 480.00 480.00 - 2,880.00 2,400.00 83.3%6311320 Insurance-Group 8,740.00 8,740.00 - 17,480.00 17,480.00 - 104,880.00 87,400.00 83.3%6311325 Insurance-Workers Comp 2,161.96 2,237.00 (75.04) 4,314.75 4,474.00 (159.25) 27,638.00 23,323.25 84.4%6311720 Salaries 12,101.76 12,583.00 (481.24) 23,836.80 25,166.00 (1,329.20) 150,996.00 127,159.20 84.2%6311800 Taxes-Employer Payroll 4,308.80 6,761.00 (2,452.20) 8,656.20 13,522.00 (4,865.80) 84,168.00 75,511.80 89.7%6311880 Wages-Hourly 41,700.38 41,725.00 (24.62) 83,584.67 83,450.00 134.67 509,458.00 425,873.33 83.6%6311882 Wages-Overtime 246.96 - 246.96 447.41 - 447.41 15,598.00 15,150.59 97.1%Total-CM-SALARIES & BENEFITS69,499.86 72,286.00 (2,786.14) 138,799.83 144,572.00 (5,772.17) 895,618.00 756,818.17 84.5%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 3,101.44 2,500.00 601.44 6,007.52 6,000.00 7.52 29,300.00 23,292.48 79.5%6313744 Fertilizer 16,604.17 16,000.00 604.17 24,221.43 24,400.00 (178.57) 89,400.00 65,178.57 72.9%6313745 Herbicides - - - - - - 12,000.00 12,000.00 100.0%6313746 Flowers/Plants - - - - - - 3,050.00 3,050.00 100.0%6313748 Fuel-Gasoline 3,557.35 3,600.00 (42.65) 10,243.69 7,200.00 3,043.69 43,100.00 32,856.31 76.2%6313750 Golf Course Accessories 161.17 200.00 (38.83) 585.95 400.00 185.95 12,300.00 11,714.05 95.2%6313756 POA Control 205.15 - 205.15 205.15 - 205.15 7,000.00 6,794.85 97.1%6313758 Miscellaneous Supp 444.10 750.00 (305.90) 1,156.36 1,500.00 (343.64) 4,350.00 3,193.64 0.0%6313762 Supplies-Office - - - 238.13 - 238.13 - (238.13) 0.0%6313774 Sand - 390.00 (390.00) - 780.00 (780.00) 11,460.00 11,460.00 100.0%6313776 Seed 586.16 350.00 236.16 3,767.18 700.00 3,067.18 91,810.00 88,042.82 95.9%6313778 Small Tools & Non-Capital Equip 123.94 100.00 23.94 123.94 200.00 (76.06) 5,000.00 4,876.06 97.5%6313780 Sod 2,812.10 200.00 2,612.10 2,812.10 1,200.00 1,612.10 3,350.00 537.90 16.1%6313782 Topdressing 1,417.75 1,250.00 167.75 5,567.69 2,500.00 3,067.69 7,600.00 2,032.31 26.7%Total-CM-SUPPLIES & MATERIALS29,013.33 25,340.00 3,673.33 54,929.14 44,880.00 10,049.14 319,720.00 264,790.86 82.8%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,761.87 2,055.00 706.87 4,501.24 5,415.00 (913.76) 24,610.00 20,108.76 81.7%6315685 CM-R&M-Bldngs & Othr Structures 125.50 250.00 (124.50) 251.00 500.00 (249.00) 1,750.00 1,499.00 85.7%6315690 CM-R&M-Equipment 2,400.67 1,000.00 1,400.67 4,470.12 2,000.00 2,470.12 20,500.00 16,029.88 78.2%6315692 CM-R&M-Irrigation System 2,325.53 2,100.00 225.53 2,325.53 4,200.00 (1,874.47) 16,050.00 13,724.47 85.5%6315696 CM-R&M-Pumps 710.00 1,000.00 (290.00) 1,855.07 2,000.00 (144.93) 10,500.00 8,644.93 82.3%6315815 CM-R&M-Trees-Pruning Etc - - - - - - 10,050.00 10,050.00 100.0%Total-CM-REPAIRS & MAINTENANCE 8,323.57 6,405.00 1,918.57 13,402.96 14,115.00 (712.04) 83,460.00 70,057.04 83.9%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 26.26 15.00 11.26 48.29 30.00 18.29 180.00 131.71 0.0%6317840 Telephones 1,090.96 850.00 240.96 2,185.75 1,700.00 485.75 10,200.00 8,014.25 78.6%Total-CM-UTILITIES 1,117.22 865.00 252.22 2,234.04 1,730.00 504.04 10,380.00 8,145.96 78.5%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%6319100 Contract Svcs-Soil/Tissue Test - - - - - - 4,000.00 4,000.00 100.0%6319101 Contract Svcs-Trash Removal - 525.00 (525.00) 956.15 1,050.00 (93.85) 6,288.00 5,331.85 0.0%6319150 Dues & Subscriptions - - - - - - 540.00 540.00 100.0%6319170 Employee Education 70.00 50.00 20.00 70.00 100.00 (30.00) 1,550.00 1,480.00 95.5%6319197 Equipment Rental - 150.00 (150.00) - 350.00 (350.00) 4,200.00 4,200.00 100.0%6319206 Licenses & Permits - 100.00 (100.00) 178.98 200.00 (21.02) 1,430.00 1,251.02 87.5%6319490 Miscellaneous - 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0%6319718 Safety Equipment & Training 656.27 100.00 556.27 779.92 300.00 479.92 3,850.00 3,070.08 79.7%6319822 Uniforms 1,446.25 820.00 626.25 2,388.78 1,640.00 748.78 9,840.00 7,451.22 75.7%Total-CM-OTHER EXPENSES 2,672.52 2,345.00 327.52 5,373.83 4,840.00 533.83 38,898.00 33,524.17 86.2%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementAugust 2010Annual Budget4 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,317.00 2,317.00 - 4,634.00 4,634.00 - 27,804.00 23,170.00 83.3%6321325 Insurance-Workers Comp 397.70 445.00 (47.30) 848.90 890.00 (41.10) 5,487.00 4,638.10 84.5%6321800 Taxes-Employer Payroll 760.84 1,346.00 (585.16) 1,627.22 2,692.00 (1,064.78) 16,811.00 15,183.78 90.3%6321880 Wages-Hourly 9,922.19 10,813.00 (890.81) 21,196.50 21,626.00 (429.50) 129,756.00 108,559.50 83.7%6321882 Wages-Overtime 20.22 - 20.22 25.83 - 25.83 5,272.00 5,246.17 99.5%Total-CM-LM-SALARIES & BENEFITS13,417.95 14,921.00 (1,503.05) 28,332.45 29,842.00 (1,509.55) 185,130.00 156,797.55 84.7%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 297.35 290.00 7.35 466.05 580.00 (113.95) 3,480.00 3,013.95 86.6%Total-CM-LM-SUPPLIES & MATERIALS297.35 390.00 (92.65) 466.05 780.00 (313.95) 4,505.00 4,038.95 89.7%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%124,341.80 122,802.00 1,539.80 243,538.30 241,259.00 2,279.30 1,541,961.00 1,298,422.70 84.2% August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 2,915.42 3,800.00 (884.58) 5,815.91 8,300.00 (2,484.09) 42,300.00 36,484.09 86.3%6337842 Utilities-Water5,942.78 6,200.00 (257.22) 11,498.01 11,160.00 338.01 43,058.00 31,559.99 73.3%8,858.20 10,000.00 (1,141.80) 17,313.92 19,460.00 (2,146.08) 85,358.00 68,044.08 79.7%Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetSilverrock ResortCourse Maintenance Water & EnergyAugust 2010Total-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementAugust 2010Annual BudgetMonth to Date Year 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 662.00 662.00 - 1,324.00 1,324.00 - 7,944.00 6,620.00 83.3%6411325 Insurance-Workers Comp 315.16 288.00 27.16 639.36 604.00 35.36 5,096.00 4,456.64 87.5%6411800 Taxes-Employer Payroll 810.44 870.00 (59.56) 1,672.52 1,826.00 (153.48) 15,399.00 13,726.48 89.1%6411880 Wages-Hourly 7,867.86 6,985.00 882.86 15,951.21 14,667.00 1,284.21 123,689.00 107,737.79 87.1%6411882 Wages-Overtime 11.03 - 11.03 32.63 - 32.63 - (32.63) 0.0%Total-CBR-SALARIES & BENEFITS10,086.49 9,225.00 861.49 20,459.72 19,261.00 1,198.72 159,088.00 138,628.28 87.1%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 1,237.03 - 1,237.03 1,237.03 - 1,237.03 2,350.00 1,112.97 47.4%6413742 Supplies-Expendable 513.27 600.00 (86.73) 1,089.58 1,200.00 (110.42) 6,750.00 5,660.42 83.9%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) 1,005.00 1,005.00 100.0%6413796 Supplies-Bottled Water189.82 50.00 139.82 379.64 100.00 279.64 24,500.00 24,120.36 98.5%Total-CBR-SUPPLIES & MATERIALS1,940.12 747.00 1,193.12 2,706.25 1,494.00 1,212.25 41,550.00 38,843.75 93.5%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts - 720.00 (720.00) - 1,440.00 (1,440.00) 8,640.00 8,640.00 100.0%6415690 CBR-R&M-Equipment - 300.00 (300.00) 182.16 600.00 (417.84) 3,600.00 3,417.84 94.9%6415695 CBR-R&M-Cart Maintenance & Repair - 500.00 (500.00) - 1,000.00 (1,000.00) 5,000.00 5,000.00 100.0%Total-CBR-REPAIRS & MAINTENANCE - 1,520.00 (1,520.00) 182.16 3,040.00 (2,857.84) 17,240.00 17,057.84 98.9%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 1,161.36 800.00 361.36 2,179.05 1,600.00 579.05 9,600.00 7,420.95 77.3%6419220 Freight/Delivery 78.96 75.00 3.96 78.96 150.00 (71.04) 450.00 371.04 82.5%6419490 Miscellaneous - 75.00 (75.00) - 200.00 (200.00) 1,150.00 1,150.00 100.0%6419820 Uniforms 375.09 - 375.09 375.09 - 375.09 5,200.00 4,824.91 92.8%Total-CBR-OTHER EXPENSES 1,615.41 950.00 665.41 2,633.10 1,950.00 683.10 16,400.00 13,766.90 83.9%TOTAL-CARTS,BAGROOM & RANGE 13,642.02 12,442.00 1,200.02 25,981.23 25,745.00 236.23 234,278.00 208,296.77 88.9%643-CS-SALARIES & BENEFITS6431175 Employee Meals 180.00 180.00 - 360.00 360.00 - 3,420.00 3,060.00 89.5%6431325 Insurance-Workers Comp 67.68 67.00 0.68 148.82 141.00 7.82 1,738.00 1,589.18 91.4%6431800 Taxes-Employer Payroll 239.40 203.00 36.40 526.47 427.00 99.47 5,251.00 4,724.53 90.0%6431880 Wages-Hourly 1,692.00 3,032.00 (1,340.00) 3,711.60 6,682.00 (2,970.40) 48,816.00 45,104.40 92.4%6431882 Wages-Overtime - - - 9.00 - 9.00 - (9.00) 0.0%Total-CS-SALARIES & BENEFITS2,179.08 3,482.00 (1,302.92) 4,755.89 7,610.00 (2,854.11) 59,225.00 54,469.11 92.0%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) 2,125.00 2,125.00 100.0%Total-CS-OTHER EXPENSES - 175.00 (175.00) - 350.00 (350.00) 3,975.00 3,975.00 100.0%Total-COURSE SERVICES 2,179.08 3,657.00 (1,477.92) 4,755.89 7,960.00 (3,204.11) 63,200.00 58,444.11 92.5%15,821.10 16,099.00 (277.90) 30,737.12 33,705.00 (2,967.88) 297,478.00 262,765.88 88.3%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementAugust 2010Annual 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 Gas280.15 300.00 (19.85) 577.08 600.00 (22.92) 3,600.00 3,022.92 84.0%6507840 Utilities-Telephone1,040.40 1,150.00 (109.60) 2,105.53 2,300.00 (194.47) 13,800.00 11,694.47 84.7%6507842 Utilities-Water1,636.80 321.00 1,315.80 2,582.01 642.00 1,940.01 3,852.00 1,269.99 33.0%6507844 Utilities-Cable336.49 340.00 (3.51) 672.98 680.00 (7.02) 4,080.00 3,407.02 83.5%Total-CH-UTILITIES 3,293.84 2,111.00 1,182.84 5,937.60 4,222.00 1,715.60 25,332.00 19,394.40 76.6%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 3,725.00 3,650.00 75.00 22,500.00 18,775.00 83.4%6509099 Contract Services-Security4,565.04 4,900.00 (334.96) 9,513.12 9,800.00 (286.88) 60,400.00 50,886.88 84.2%6509215 Flowers & Decorations- - - - - - 2,400.00 2,400.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) - 200.00 (200.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES 6,390.04 7,025.00 (634.96) 13,238.12 14,050.00 (811.88) 88,900.00 75,661.88 85.1%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures281.00 300.00 (19.00) 562.00 600.00 (38.00) 3,600.00 3,038.00 84.4%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 307.77 800.00 (492.23) 4,800.00 4,492.23 93.6%6515690 CH-R&M-Equipment Repair19.03 400.00 (380.97) 228.03 800.00 (571.97) 4,800.00 4,571.97 95.2%Total-CH-REPAIRS & MAINTENANCE 300.03 1,100.00 (799.97) 1,097.80 2,200.00 (1,102.20) 13,200.00 12,102.20 91.7%9,983.91 10,636.00 (652.09) 20,273.52 21,272.00 (998.48) 132,232.00 24,204.40 18.3%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementAugust 2010Annual 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 331.00 331.00 - 662.00 662.00 - 3,972.00 3,310.00 83.3%6601325 Insurance-Workers Comp 100.00 103.00 (3.00) 200.00 206.00 (6.00) 1,240.00 1,040.00 83.9%6601720 Salaries 2,500.00 2,508.00 (8.00) 5,000.00 5,016.00 (16.00) 30,096.00 25,096.00 83.4%6601800 Taxes-Employer Payroll 311.00 312.00 (1.00) 622.00 624.00 (2.00) 3,747.00 3,125.00 83.4%Total-MKT-SALARIES & BENEFITS 3,302.00 3,314.00 (12.00) 6,604.00 6,628.00 (24.00) 39,775.00 33,171.00 83.4%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery 35.97 - 35.97 1,985.30 - 1,985.30 4,425.00 2,439.70 55.1%35.97 100.00 (64.03) 1,985.30 200.00 1,785.30 5,625.00 3,639.70 64.7%66-MKT-UTILITIES6607840 Utilities-Telephone 51.15 100.00 (48.85) 102.24 200.00 (97.76) 1,200.00 1,097.76 91.5%Total-MKT-UTILITIES 51.15 100.00 (48.85) 102.24 200.00 (97.76) 1,200.00 1,097.76 91.5%66-MKT-OTHER EXPENSES6609010 Advertising 12,709.48 10,677.00 2,032.48 23,714.62 18,964.00 4,750.62 192,534.00 168,819.38 87.7%6609040 Business Meals - 25.00 (25.00) - 50.00 (50.00) 300.00 300.00 100.0%6609080 Collateral Material - - - - - - 9,000.00 9,000.00 100.0%6609102 Contract Services-Web Page 324.00 400.00 (76.00) 685.50 800.00 (114.50) 4,800.00 4,114.50 85.7%6609490 Miscellaneous - - - - - - 350.00 350.00 100.0%6609620 Postage 112.02 50.00 62.02 178.02 100.00 78.02 600.00 421.98 70.3%6609630 Promotion - - - - - - 3,500.00 3,500.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 - - - - - - 700.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 13,145.50 11,227.00 1,918.50 24,718.14 20,064.00 4,654.14 216,044.00 190,625.86 88.2%16,534.62 14,741.00 1,793.62 33,409.68 27,092.00 6,317.68 262,644.00 228,534.32 87.0%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementAugust 2010Annual 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,095.30 1,458.00 (362.70) 2,553.30 2,916.00 (362.70) 17,496.00 14,942.70 85.4%6701325 Insurance-Workers Comp655.13 707.00 (51.87) 1,295.21 1,414.00 (118.79) 8,480.00 7,184.79 84.7%6701720 Salaries 14,757.88 14,833.34 (75.46) 29,068.56 29,666.68 (598.12) 178,000.00 148,931.44 83.7%6701800 Taxes-Employer Payroll 1,236.96 2,136.00 (899.04) 2,557.35 4,272.00 (1,714.65) 25,627.00 23,069.65 90.0%6701880 Wages-Hourly1,620.38 2,319.66 (699.28) 3,311.81 4,639.32 (1,327.51) 27,835.00 24,523.19 88.1%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 19,545.65 21,634.00 (2,088.35) 39,146.23 43,268.00 (4,121.77) 259,598.00 220,451.77 84.9%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer36.90 400.00 (363.10) 307.69 800.00 (492.31) 5,200.00 4,892.31 94.1%6703762 Supplies-Office 136.98 100.00 36.98 226.26 200.00 26.26 1,200.00 973.74 81.1%6703768 Supplies-Printing & Stationery129.30 100.00 29.30 644.72 200.00 444.72 3,300.00 2,655.28 80.5%Total-G&A-SUPPLIES & MATERIALS 303.18 600.00 (296.82) 1,178.67 1,200.00 (21.33) 9,700.00 8,521.33 87.8%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) - 100.00 (100.00) 1,100.00 1,100.00 100.0%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) - 100.00 (100.00) 1,100.00 1,100.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- - - 271.71 50.00 221.71 1,700.00 1,428.29 84.0%6709180 Employee Recruiting/Relocation112.00 - 112.00 140.00 - 140.00 1,400.00 1,260.00 90.0%6709197 Equipment Rental915.78 480.00 435.78 1,463.94 960.00 503.94 5,760.00 4,296.06 74.6%6709202 Fees-Bank78.76 90.00 (11.24) 122.52 180.00 (57.48) 1,080.00 957.48 88.7%6709208 Fees-Payroll Processing1,195.47 760.00 435.47 2,253.95 1,520.00 733.95 9,120.00 6,866.05 75.3%6709220 Freight/Delivery- 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0%6709490 Miscellaneous - 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0%6709620 Postage/Mail Services 49.00 75.00 (26.00) 109.27 150.00 (40.73) 900.00 790.73 87.9%6709625 Professional Fees1,740.50 850.00 890.50 2,215.50 1,700.00 515.50 10,200.00 7,984.50 78.3%6709636 Promotion/Entertainment- 100.00 (100.00) - 200.00 (200.00) 3,100.00 3,100.00 100.0%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) - 150.00 (150.00) 1,050.00 1,050.00 100.0%Total-G&A-OTHER EXPENSES 4,491.51 3,280.00 1,211.51 7,376.89 6,510.00 866.89 44,410.00 37,033.11 83.4%24,340.34 25,614.00 (1,273.66) 47,701.79 51,078.00 (3,376.21) 314,808.00 267,106.21 84.8%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementAugust 2010Annual Budget9 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 7,247.91 11,581.00 (4,333.09) 16,033.32 23,162.00 (7,128.68) 150,324.00 134,290.68 89.3%6800194 Equipment Leases-Trailer 820.00 600.00 220.00 1,340.00 1,200.00 140.00 7,200.00 5,860.00 81.4%6800196 Equipment Leases-GPS 7,942.00 8,636.00 (694.00) 15,884.00 17,272.00 (1,388.00) 90,216.00 74,332.00 82.4%6800197 Equipment Leases-Others 2,331.07 - 2,331.07 3,860.54 - 3,860.54 - - 0.0%18,340.98 20,817.00 (2,476.02) 37,117.86 41,634.00 (4,516.14) 247,740.00 214,482.68 86.6%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 20,946.44 21,310.00 (363.56) 36,960.80 42,962.00 (6,001.20) 90,000.00 53,039.20 58.9%6900210 FF&E Reserve 1,533.85 1,803.00 (269.15) 3,329.60 3,741.00 (411.40) 62,229.00 58,899.40 94.6%6900800 Personal Property Taxes - - - 5,199.29 13,570.00 (8,370.71) 13,570.00 8,370.71 61.7%6900323 Insurance-Commercial 433.44 2,200.00 (1,766.56) 2,974.88 4,400.00 (1,425.12) 26,400.00 23,425.12 88.7%22,913.73 25,313.00 (2,399.27) 48,464.57 64,673.00 (16,208.43) 192,199.00 143,734.43 74.8%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementAugust 201010 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2010-20112010 2010 2010 2010 2010 2010Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMediaSalesPromotionGolf Industry85VIPCelebrityPGA Comp68 72Charity/Gift CertificateRain/Wind Checks3Club Staff77 68LQ HS Golf15314800002011 2011 2011 2011 2011 2011Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011