Loading...
03 September 2010 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2010 – September 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 September Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 136,676.50 167,471.00 (30,794.50) -18.4% 303,156.00 354,547.00 (51,391.00) 3,111,458.00 2,808,302.00 10%401000 Miscellaneous Golf Revenue 5,212.00 6,858.00 (1,646.00) -24.0% 13,244.00 21,031.00 (7,787.00) 117,656.00 104,412.00 11%410000 Revenue-Golf Shop 14,412.23 16,863.00 (2,450.77) -14.5% 30,014.68 35,106.00 (5,091.32) 306,492.00 276,477.32 10%420000 Revenue-F&B Concession 500.00 500.00 - 0.0% 1,500.00 1,500.00 - 12,000.00 10,500.00 13%890000 Interest Income 6.26 - 6.26 0.0% 16.57 - 16.57 - (16.57) 0%Total Income156,806.99 191,692.00 (34,885.01) -18.2% 347,931.25 412,184.00 (64,252.75) 3,547,606.00 3,199,674.75 10%Cost of Goods Sold510000 COS-Golf Shop 7,616.14 8,949.65 (1,333.51) 14.9% 16,123.65 18,632.30 2,508.65 162,670.60 146,546.95 10%Total COS7,616.14 8,949.65 (1,333.51) 14.9% 16,123.65 18,632.30 2,508.65 162,670.60 146,546.95 10%Gross Profit149,190.85 182,742.35 (33,551.50) -18.4% 331,807.60 393,551.70 (61,744.10) 3,384,935.40 3,053,127.80 10%Expenses610000 Golf Pro Shop 14,134.96 17,704.00 3,569.04 20.2% 43,764.57 51,552.00 7,787.43 230,213.00 186,448.43 19%630000 Course Maintenance 130,054.54 141,007.00 10,952.46 7.8% 373,592.84 382,266.00 8,673.16 1,541,961.00 1,168,368.16 24%633000 Maintenance Water & Energy 10,173.03 10,160.00 (13.03) -0.1% 27,486.95 29,620.00 2,133.05 85,358.00 57,871.05 32%640000 Outside Services 16,996.60 20,233.00 3,236.40 16.0% 47,733.72 53,938.00 6,204.28 297,478.00 249,744.28 16%650000 Clubhouse 13,511.36 10,636.00 (2,875.36) -27.0% 33,784.88 31,908.00 (1,876.88) 132,232.00 98,447.12 26%660000 Marketing 19,052.65 31,421.00 12,368.35 39.4% 52,462.33 58,513.00 6,050.67 262,644.00 210,181.67 20%670000 General & Administrative24,200.45 25,914.00 1,713.55 6.6% 71,902.24 76,992.00 5,089.76 314,808.00 242,905.76 23%680000 Leases 18,620.10 20,817.00 2,196.90 10.6% 55,737.96 62,451.00 6,713.04 247,740.00 192,002.04 22%690000 Miscellaneous Other Expense 16,416.47 15,575.00 (841.47) -5.4% 64,881.04 80,248.00 15,366.96 192,199.00 127,317.96 34%Total Expenses263,160.16 293,467.00 30,306.84 10.3% 771,346.53 827,488.00 56,141.47 3,304,633.00 2,533,286.47 23%(113,969.31) (110,724.65) (3,244.66) -2.9%(439,538.93) (433,936.30) (5,602.63) 80,302.40 519,841.33 -547%Rounds of Golf PlayedPaid Rounds Played 3,362 3,550 (188) -5.3% 8,168 8,525 (357) 39,150 30,982 21%Ave $ Per Paid Round Green Fee 40.65 47.17 (6.52) -13.8% 37.12 41.59 (4.47) 76.13 39.01 49%Ave $ Per Paid Round Merchandise 4.29 4.75 (0.46) -9.8% 3.67 4.12 (0.44) 8.07 4.40 46%Ave $ Per Paid Miscellaneous 1.55 1.93 (0.38) -19.8% 1.62 2.47 (0.85) 2.06 - 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateSeptember 20101 Income September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 136,676.50 167,471.00 (30,794.50) 303,156.00 354,547.00 (51,391.00) 3,111,458.002,808,302.0010%4010000 Rider Fee 1,575.00 355.00 1,220.00 2,500.00 3,167.00 (667.00) 6,522.004,022.0038%4040000 Club Rental 1,135.00 1,953.00 (818.00) 3,295.00 4,689.00 (1,394.00) 28,004.0024,709.0012%4050000 Driving Range 2,502.00 3,550.00 (1,048.00) 6,374.00 9,175.00 (2,801.00) 48,130.0041,756.0013%4080000 GPS Advertising - 1,000.00 (1,000.00) - 3,000.00 (3,000.00) 12,000.00 12,000.000%4090000 Ball Retriever/Subcontract - - - 1,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 141,888.50 174,329.00 (32,440.50) 316,400.00 375,578.00 (59,178.00) 3,229,114.00 2,912,714.00 10%141,888.50 174,329.00 (32,440.50) 316,400.00 375,578.00 (59,178.00) 3,229,114.00 2,912,714.00 10%SilverRock ResortStatement of Fees RevenueSeptember 2010Total IncomeMonth to Date Year to Date Annual Budget2 Income September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 335.30 - 335.30 731.64 - 731.64 0 0 0%4100110 Sales Hard Goods 6,445.33 5,902.00 543.33 14,743.10 12,287.00 2,456.10 107,272.00 92,528.90 14%4100112 Sales-Soft Goods 9,993.92 10,961.00 (967.08) 19,200.42 22,819.00 (3,618.58) 199,220.00 180,019.58 10%5100639 GS-Discounts-Mdse (2,362.32) - (2,362.32) (4,660.48) - (4,660.48) - 4,660.48 0% Total Revenue Golf Shop 14,412.23 16,863.00 (2,450.77) 30,014.68 35,106.00 (5,091.32) 306,492.00 277,208.96 10%COS 5100150 COS-GS-Hard Goods 3,324.62 3,246.10 78.52 7,750.80 6,757.85 992.95 58,999.60 51,248.80 13%5100151 COS-GS-Soft Goods 4,353.12 6,028.55 (1,675.43) 8,362.03 12,550.45 (4,188.42) 109,571.00 101,208.97 8%5100152 COS-GS-Purchase Disc (164.86) (464.00) 299.14 (291.74) (965.00) 673.26 (8,429.00) (8,137.26) -3%5100220 COS-GS-Freight Merch 103.26 139.00 (35.74) 302.56 289.00 13.56 2,529.00 2,226.44 12%Cost of Sales - Golf Shop 7,616.14 8,949.65 (1,333.51) 16,123.65 18,632.30 (2,508.65) 162,670.60 146,546.95 10%Gross Profit 6,796.09 7,913.35 (1,117.26) 13,891.03 16,473.70 (2,582.67) 143,821.40 130,662.01 9%COS % 52.8% 53.1% 0.2% 53.7% 53.1% -0.6% 53.1% 52.9% 0%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 420.00 420.00 - 1,140.00 1,140.00 - 5,400.00 4,260.00 21%6101320 Insurance Group 1,908.80 1,986.00 (77.20) 6,234.72 5,958.00 276.72 26,811.00 20,576.28 23%6101325 Insurance-Workers Comp 370.83 454.00 (83.17) 1,139.58 1,350.00 (210.42) 6,131.00 4,991.42 19%6101720 Salaries 3,900.01 3,750.00 150.01 10,998.50 11,250.00 (251.50) 45,000.00 34,001.50 24%6101800 Taxes-Employer Payroll 683.95 1,371.00 (687.05) 2,189.94 4,077.00 (1,887.06) 18,528.00 16,338.06 12%6101880 Wages-Hourly 5,352.73 7,263.00 (1,910.27) 17,388.01 21,497.00 (4,108.99) 103,818.00 86,429.99 17%6101882 Wages-Overtime 18.09 - 18.09 103.15 - 103.15 - 952.88 0%Total -PS-SALARIES & BENEFITS 12,654.41 15,244.00 (2,589.59) 39,193.90 45,272.00 (6,078.10) 205,688.00 167,550.13 19%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 376.71 500.00 (123.29) 1,485.91 1,500.00 (14.09) 6,000.00 4,514.09 25%6109090 Contract Services 500.00 500.00 - 1,500.00 1,500.00 - 6,000.00 4,500.00 25%6109220 Freight & Delivery 76.27 - 76.27 110.11 - 110.11 75.00 (35.11) 147%6109490 Miscellaneous 96.00 - 96.00 96.00 - 96.00 450.00 354.00 21%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short (1.48) - (1.48) 9.31 - 9.31 - (9.31) 0%6109722 Seminars/Training 172.32 1,250.00 (1,077.68) 545.07 2,650.00 (2,104.93) 5,890.00 5,344.93 9%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms 136.78 100.00 36.78 435.14 300.00 135.14 2,400.00 1,964.86 18%6117840 Telephones 123.95 110.00 13.95 389.13 330.00 59.13 1,320.00 930.87 0%Total PS-OTHER EXPENSES 1,480.55 2,460.00 (979.45) 4,570.67 6,280.00 (1,709.33) 24,525.00 19,954.33 19%14,134.96 17,704.00 (3,569.04) 43,764.57 51,552.00 (7,787.43) 230,213.00 187,504.46 19%Net Income(7,338.87) (9,790.65) 2,451.78 (29,873.54) (35,078.30) 5,204.76 (86,391.60) (56,842.45) -34%SilverRock ResortGolf Shop Income StatementSeptember 2010Total Expenses-Golf ShopMonth to Date Year to Date Annual Budget3 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 720.00 720.00 - 2,880.00 2,160.00 75.0%6311320 Insurance-Group 7,127.69 8,740.00 (1,612.31) 24,607.69 26,220.00 (1,612.31) 104,880.00 80,272.31 76.5%6311325 Insurance-Workers Comp 2,423.20 2,237.00 186.20 6,737.95 6,711.00 26.95 27,638.00 20,900.05 75.6%6311720 Salaries 12,101.76 12,583.00 (481.24) 35,938.56 37,749.00 (1,810.44) 150,996.00 115,057.44 76.2%6311800 Taxes-Employer Payroll 4,307.26 6,761.00 (2,453.74) 12,963.46 20,283.00 (7,319.54) 84,168.00 71,204.54 84.6%6311880 Wages-Hourly 44,237.40 41,725.00 2,512.40 127,822.07 125,175.00 2,647.07 509,458.00 381,635.93 74.9%6311882 Wages-Overtime 40.94 - 40.94 488.35 - 488.35 15,598.00 15,109.65 96.9%Total-CM-SALARIES & BENEFITS70,478.25 72,286.00 (1,807.75) 209,278.08 216,858.00 (7,579.92) 895,618.00 686,339.92 76.6%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 2,411.78 3,500.00 (1,088.22) 8,419.30 9,500.00 (1,080.70) 29,300.00 20,880.70 71.3%6313744 Fertilizer 10,325.74 11,000.00 (674.26) 34,547.17 35,400.00 (852.83) 89,400.00 54,852.83 61.4%6313745 Herbicides 7,085.29 7,000.00 85.29 7,085.29 7,000.00 85.29 12,000.00 4,914.71 41.0%6313746 Flowers/Plants 1,087.50 1,000.00 87.50 1,087.50 1,000.00 87.50 3,050.00 1,962.50 64.3%6313748 Fuel-Gasoline 3,742.10 3,750.00 (7.90) 13,985.79 10,950.00 3,035.79 43,100.00 29,114.21 67.6%6313750 Golf Course Accessories 588.18 500.00 88.18 1,174.13 900.00 274.13 12,300.00 11,125.87 90.5%6313756 POA Control 218.48 - 218.48 423.63 - 423.63 7,000.00 6,576.37 93.9%6313758 Miscellaneous Supp 641.77 750.00 (108.23) 1,798.13 2,250.00 (451.87) 4,350.00 2,551.87 0.0%6313762 Supplies-Office - - - 238.13 - 238.13 - (238.13) 0.0%6313774 Sand 2,390.24 5,000.00 (2,609.76) 2,390.24 5,780.00 (3,389.76) 11,460.00 9,069.76 79.1%6313776 Seed - 250.00 (250.00) 3,767.18 950.00 2,817.18 91,810.00 88,042.82 95.9%6313778 Small Tools & Non-Capital Equip 1,877.12 2,000.00 (122.88) 2,001.06 2,200.00 (198.94) 5,000.00 2,998.94 60.0%6313780 Sod 366.93 200.00 166.93 3,179.03 1,400.00 1,779.03 3,350.00 170.97 5.1%6313782 Topdressing - - - 5,567.69 2,500.00 3,067.69 7,600.00 2,032.31 26.7%Total-CM-SUPPLIES & MATERIALS30,735.13 34,950.00 (4,214.87) 85,664.27 79,830.00 5,834.27 319,720.00 234,055.73 73.2%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,575.00 3,235.00 (1,660.00) 6,076.24 8,650.00 (2,573.76) 24,610.00 18,533.76 75.3%6315685 CM-R&M-Bldngs & Othr Structures 335.50 250.00 85.50 586.50 750.00 (163.50) 1,750.00 1,163.50 66.5%6315690 CM-R&M-Equipment 2,535.24 1,000.00 1,535.24 7,005.36 3,000.00 4,005.36 20,500.00 13,494.64 65.8%6315692 CM-R&M-Irrigation System 3,230.98 2,200.00 1,030.98 5,556.51 6,400.00 (843.49) 16,050.00 10,493.49 65.4%6315696 CM-R&M-Pumps 985.94 1,000.00 (14.06) 2,841.01 3,000.00 (158.99) 10,500.00 7,658.99 72.9%6315815 CM-R&M-Trees-Pruning Etc 3,495.00 3,500.00 (5.00) 3,495.00 3,500.00 (5.00) 10,050.00 6,555.00 65.2%Total-CM-REPAIRS & MAINTENANCE 12,157.66 11,185.00 972.66 25,560.62 25,300.00 260.62 83,460.00 57,899.38 69.4%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 22.02 15.00 7.02 70.31 45.00 25.31 180.00 109.69 0.0%6317840 Telephones 991.44 850.00 141.44 3,177.19 2,550.00 627.19 10,200.00 7,022.81 68.9%Total-CM-UTILITIES 1,013.46 865.00 148.46 3,247.50 2,595.00 652.50 10,380.00 7,132.50 68.7%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 1,500.00 1,500.00 - 6,000.00 4,500.00 75.0%6319100 Contract Svcs-Soil/Tissue Test 1,500.00 2,000.00 (500.00) 1,500.00 2,000.00 (500.00) 4,000.00 2,500.00 62.5%6319101 Contract Svcs-Trash Removal 509.90 525.00 (15.10) 1,466.05 1,575.00 (108.95) 6,288.00 4,821.95 0.0%6319150 Dues & Subscriptions - - - - - - 540.00 540.00 100.0%6319170 Employee Education - 50.00 (50.00) 70.00 150.00 (80.00) 1,550.00 1,480.00 95.5%6319197 Equipment Rental - 150.00 (150.00) - 500.00 (500.00) 4,200.00 4,200.00 100.0%6319206 Licenses & Permits - 80.00 (80.00) 178.98 280.00 (101.02) 1,430.00 1,251.02 87.5%6319490 Miscellaneous 444.06 100.00 344.06 444.06 300.00 144.06 1,200.00 755.94 63.0%6319718 Safety Equipment & Training 233.43 750.00 (516.57) 1,013.35 1,050.00 (36.65) 3,850.00 2,836.65 73.7%6319822 Uniforms 891.75 820.00 71.75 3,280.53 2,460.00 820.53 9,840.00 6,559.47 66.7%Total-CM-OTHER EXPENSES 4,079.14 4,975.00 (895.86) 9,452.97 9,815.00 (362.03) 38,898.00 29,445.03 75.7%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementSeptember 2010Annual Budget4 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,408.00 2,317.00 (909.00) 6,042.00 6,951.00 (909.00) 27,804.00 21,762.00 78.3%6321325 Insurance-Workers Comp 356.81 468.00 (111.19) 1,205.71 1,358.00 (152.29) 5,487.00 4,281.29 78.0%6321800 Taxes-Employer Payroll 677.30 1,447.00 (769.70) 2,304.52 4,139.00 (1,834.48) 16,811.00 14,506.48 86.3%6321880 Wages-Hourly 8,913.24 10,813.00 (1,899.76) 30,109.74 32,439.00 (2,329.26) 129,756.00 99,646.26 76.8%6321882 Wages-Overtime 7.13 811.00 (803.87) 32.96 811.00 (778.04) 5,272.00 5,239.04 99.4%Total-CM-LM-SALARIES & BENEFITS11,362.48 15,856.00 (4,493.52) 39,694.93 45,698.00 (6,003.07) 185,130.00 145,435.07 78.6%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 100.00 (100.00) - 300.00 (300.00) 1,025.00 1,025.00 100.0%6323788 Uniforms 228.42 290.00 (61.58) 694.47 870.00 (175.53) 3,480.00 2,785.53 80.0%Total-CM-LM-SUPPLIES & MATERIALS228.42 390.00 (161.58) 694.47 1,170.00 (475.53) 4,505.00 3,810.53 84.6%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 500.00 (500.00) - 1,000.00 (1,000.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE - 500.00 (500.00) - 1,000.00 (1,000.00) 4,250.00 4,250.00 100.0%130,054.54 141,007.00 (10,952.46) 373,592.84 382,266.00 (8,673.16) 1,541,961.00 1,168,368.16 75.8% September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 3,205.37 4,000.00 (794.63) 9,021.28 12,300.00 (3,278.72) 42,300.00 33,278.72 78.7%6337842 Utilities-Water6,967.66 6,160.00 807.66 18,465.67 17,320.00 1,145.67 43,058.00 24,592.33 57.1%10,173.03 10,160.00 13.03 27,486.95 29,620.00 (2,133.05) 85,358.00 57,871.05 67.8%Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetSilverrock ResortCourse Maintenance Water & EnergySeptember 2010Total-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementSeptember 2010Annual BudgetMonth to Date Year to Date5 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 420.00 420.00 - 1,260.00 1,260.00 - 6,960.00 5,700.00 81.9%6411320 Insurance-Group 58.60 662.00 (603.40) 1,382.60 1,986.00 (603.40) 7,944.00 6,561.40 82.6%6411325 Insurance-Workers Comp 362.42 367.00 (4.58) 1,001.78 971.00 30.78 5,096.00 4,094.22 80.3%6411800 Taxes-Employer Payroll 1,186.76 1,110.00 76.76 2,859.28 2,936.00 (76.72) 15,399.00 12,539.72 81.4%6411880 Wages-Hourly 8,987.28 8,918.00 69.28 24,938.49 23,585.00 1,353.49 123,689.00 98,750.51 79.8%6411882 Wages-Overtime 73.31 - 73.31 105.94 - 105.94 - (105.94) 0.0%Total-CBR-SALARIES & BENEFITS11,088.37 11,477.00 (388.63) 31,548.09 30,738.00 810.09 159,088.00 127,539.91 80.2%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - - - 1,237.03 - 1,237.03 2,350.00 1,112.97 47.4%6413742 Supplies-Expendable 774.71 150.00 624.71 1,864.29 1,350.00 514.29 6,750.00 4,885.71 72.4%6413752 Supplies-Range Balls - - - - - - 6,000.00 6,000.00 100.0%6413762 Supplies-Office - 25.00 (25.00) - 75.00 (75.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels - 72.00 (72.00) - 216.00 (216.00) 1,005.00 1,005.00 100.0%6413796 Supplies-Bottled Water189.82 50.00 139.82 569.46 150.00 419.46 24,500.00 23,930.54 97.7%Total-CBR-SUPPLIES & MATERIALS964.53 297.00 667.53 3,670.78 1,791.00 1,879.78 41,550.00 37,879.22 91.2%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts - 720.00 (720.00) - 2,160.00 (2,160.00) 8,640.00 8,640.00 100.0%6415690 CBR-R&M-Equipment 380.02 300.00 80.02 562.18 900.00 (337.82) 3,600.00 3,037.82 84.4%6415695 CBR-R&M-Cart Maintenance & Repair 713.18 500.00 213.18 713.18 1,500.00 (786.82) 5,000.00 4,286.82 85.7%Total-CBR-REPAIRS & MAINTENANCE 1,093.20 1,520.00 (426.80) 1,275.36 4,560.00 (3,284.64) 17,240.00 15,964.64 92.6%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 1,033.31 800.00 233.31 3,212.36 2,400.00 812.36 9,600.00 6,387.64 66.5%6419220 Freight/Delivery - 75.00 (75.00) 78.96 225.00 (146.04) 450.00 371.04 82.5%6419490 Miscellaneous - 75.00 (75.00) - 275.00 (275.00) 1,150.00 1,150.00 100.0%6419820 Uniforms - - - 375.09 - 375.09 5,200.00 4,824.91 92.8%Total-CBR-OTHER EXPENSES 1,033.31 950.00 83.31 3,666.41 2,900.00 766.41 16,400.00 12,733.59 77.6%TOTAL-CARTS,BAGROOM & RANGE 14,179.41 14,244.00 (64.59) 40,160.64 39,989.00 171.64 234,278.00 194,117.36 82.9%643-CS-SALARIES & BENEFITS6431175 Employee Meals 180.00 180.00 - 540.00 540.00 - 3,420.00 2,880.00 84.2%6431325 Insurance-Workers Comp 90.18 106.00 (15.82) 239.00 247.00 (8.00) 1,738.00 1,499.00 86.2%6431800 Taxes-Employer Payroll 292.61 320.00 (27.39) 819.08 747.00 72.08 5,251.00 4,431.92 84.4%6431880 Wages-Hourly 2,254.40 5,158.00 (2,903.60) 5,966.00 11,840.00 (5,874.00) 48,816.00 42,850.00 87.8%6431882 Wages-Overtime - - - 9.00 - 9.00 - (9.00) 0.0%Total-CS-SALARIES & BENEFITS2,817.19 5,764.00 (2,946.81) 7,573.08 13,374.00 (5,800.92) 59,225.00 51,651.92 87.2%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) - 200.00 (200.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous - - - - - - 200.00 200.00 100.0%6439718 Safety Equipment & Training - 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6439820 Uniforms - 75.00 (75.00) - 225.00 (225.00) 2,125.00 2,125.00 100.0%Total-CS-OTHER EXPENSES - 225.00 (225.00) - 575.00 (575.00) 3,975.00 3,975.00 100.0%Total-COURSE SERVICES 2,817.19 5,989.00 (3,171.81) 7,573.08 13,949.00 (6,375.92) 63,200.00 55,626.92 88.0%16,996.60 20,233.00 (3,236.40) 47,733.72 53,938.00 (6,204.28) 297,478.00 245,769.28 82.6%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementSeptember 2010Annual Budget6 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable712.50 400.00 312.50 712.50 1,200.00 (487.50) 4,800.00 4,087.50 85.2%Total-CH-SUPPLIES & MATERIALS 712.50 400.00 312.50 712.50 1,200.00 (487.50) 4,800.00 4,087.50 85.2%65-CH-UTILITIES6507836 Utilities-Natural Gas341.56 300.00 41.56 918.64 900.00 18.64 3,600.00 2,681.36 74.5%6507840 Utilities-Telephone1,043.15 1,150.00 (106.85) 3,148.68 3,450.00 (301.32) 13,800.00 10,651.32 77.2%6507842 Utilities-Water2,378.10 321.00 2,057.10 4,960.11 963.00 3,997.11 3,852.00 (1,108.11) -28.8%6507844 Utilities-Cable336.49 340.00 (3.51) 1,009.47 1,020.00 (10.53) 4,080.00 3,070.53 75.3%Total-CH-UTILITIES 4,099.30 2,111.00 1,988.30 10,036.90 6,333.00 3,703.90 25,332.00 15,295.10 60.4%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,750.00 1,825.00 (75.00) 5,475.00 5,475.00 - 22,500.00 17,025.00 75.7%6509099 Contract Services-Security4,756.56 4,900.00 (143.44) 14,269.68 14,700.00 (430.32) 60,400.00 46,130.32 76.4%6509215 Flowers & Decorations- - - - - - 2,400.00 2,400.00 100.0%6509490 Miscellaneous- 200.00 (200.00) - 600.00 (600.00) 2,400.00 2,400.00 100.0%6509718 Safety Equipment & Training- 100.00 (100.00) - 300.00 (300.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES 6,506.56 7,025.00 (518.44) 19,744.68 21,075.00 (1,330.32) 88,900.00 69,155.32 77.8%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures1,406.00 300.00 1,106.00 1,968.00 900.00 1,068.00 3,600.00 1,632.00 45.3%6515686 CH-R&M-Restaurant Repairs722.00 400.00 322.00 1,029.77 1,200.00 (170.23) 4,800.00 3,770.23 78.5%6515690 CH-R&M-Equipment Repair65.00 400.00 (335.00) 293.03 1,200.00 (906.97) 4,800.00 4,506.97 93.9%Total-CH-REPAIRS & MAINTENANCE 2,193.00 1,100.00 1,093.00 3,290.80 3,300.00 (9.20) 13,200.00 9,909.20 75.1%13,511.36 10,636.00 2,875.36 33,784.88 31,908.00 1,876.88 132,232.00 19,818.40 15.0%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementSeptember 2010Annual Budget7 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 180.00 180.00 - 720.00 540.00 75.0%6601320 Insurance-Group 270.60 331.00 (60.40) 932.60 993.00 (60.40) 3,972.00 3,039.40 76.5%6601325 Insurance-Workers Comp 150.00 103.00 47.00 350.00 309.00 41.00 1,240.00 890.00 71.8%6601720 Salaries 3,750.00 2,508.00 1,242.00 8,750.00 7,524.00 1,226.00 30,096.00 21,346.00 70.9%6601800 Taxes-Employer Payroll 466.50 312.00 154.50 1,088.50 936.00 152.50 3,747.00 2,658.50 71.0%Total-MKT-SALARIES & BENEFITS 4,697.10 3,314.00 1,383.10 11,301.10 9,942.00 1,359.10 39,775.00 28,473.90 71.6%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 300.00 (300.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery - 200.00 (200.00) 1,985.30 200.00 1,785.30 4,425.00 2,439.70 55.1%- 300.00 (300.00) 1,985.30 500.00 1,485.30 5,625.00 3,639.70 64.7%66-MKT-UTILITIES6607840 Utilities-Telephone 55.35 100.00 (44.65) 157.59 300.00 (142.41) 1,200.00 1,042.41 86.9%Total-MKT-UTILITIES 55.35 100.00 (44.65) 157.59 300.00 (142.41) 1,200.00 1,042.41 86.9%66-MKT-OTHER EXPENSES6609010 Advertising 14,201.20 26,657.00 (12,455.80) 37,915.82 45,621.00 (7,705.18) 192,534.00 154,618.18 80.3%6609040 Business Meals - 25.00 (25.00) - 75.00 (75.00) 300.00 300.00 100.0%6609080 Collateral Material - - - - - - 9,000.00 9,000.00 100.0%6609102 Contract Services-Web Page 99.00 400.00 (301.00) 784.50 1,200.00 (415.50) 4,800.00 4,015.50 83.7%6609490 Miscellaneous - - - - - - 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) 178.02 150.00 28.02 600.00 421.98 70.3%6609630 Promotion - - - - - - 3,500.00 3,500.00 0.0%6609633 Promotion-Community - 75.00 (75.00) - 225.00 (225.00) 2,925.00 2,925.00 100.0%6609634 Promotion-Media/Vendor - 500.00 (500.00) - 500.00 (500.00) 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 14,300.20 27,707.00 (13,406.80) 39,018.34 47,771.00 (8,752.66) 216,044.00 176,325.66 81.6%19,052.65 31,421.00 (12,368.35) 52,462.33 58,513.00 (6,050.67) 262,644.00 209,481.67 79.8%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementSeptember 2010Annual Budget8 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 540.00 540.00 - 2,160.00 1,620.00 75.0%6701320 Insurance-Group1,100.30 1,458.00 (357.70) 3,653.60 4,374.00 (720.40) 17,496.00 13,842.40 79.1%6701325 Insurance-Workers Comp654.17 707.00 (52.83) 1,949.38 2,121.00 (171.62) 8,480.00 6,530.62 77.0%6701720 Salaries 14,757.89 14,833.34 (75.45) 43,826.45 44,500.02 (673.57) 178,000.00 134,173.55 75.4%6701800 Taxes-Employer Payroll 1,251.10 2,136.00 (884.90) 3,808.45 6,408.00 (2,599.55) 25,627.00 21,818.55 85.1%6701880 Wages-Hourly1,596.46 2,319.66 (723.20) 4,908.27 6,958.98 (2,050.71) 27,835.00 22,926.73 82.4%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 19,539.92 21,634.00 (2,094.08) 58,686.15 64,902.00 (6,215.85) 259,598.00 200,911.85 77.4%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer555.79 400.00 155.79 863.48 1,200.00 (336.52) 5,200.00 4,336.52 83.4%6703762 Supplies-Office 214.55 100.00 114.55 440.81 300.00 140.81 1,200.00 759.19 63.3%6703768 Supplies-Printing & Stationery89.81 100.00 (10.19) 734.53 300.00 434.53 3,300.00 2,565.47 77.7%Total-G&A-SUPPLIES & MATERIALS 860.15 600.00 260.15 2,038.82 1,800.00 238.82 9,700.00 7,661.18 79.0%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) - 200.00 (200.00) 1,100.00 1,100.00 100.0%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) - 200.00 (200.00) 1,100.00 1,100.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 1,200.00 1,200.00 - 4,800.00 3,600.00 75.0%6709150 Dues & Subscriptions- 200.00 (200.00) 271.71 250.00 21.71 1,700.00 1,428.29 84.0%6709180 Employee Recruiting/Relocation84.00 200.00 (116.00) 224.00 200.00 24.00 1,400.00 1,176.00 84.0%6709197 Equipment Rental661.58 480.00 181.58 2,125.52 1,440.00 685.52 5,760.00 3,634.48 63.1%6709202 Fees-Bank53.51 90.00 (36.49) 176.03 270.00 (93.97) 1,080.00 903.97 83.7%6709208 Fees-Payroll Processing1,477.42 760.00 717.42 3,731.37 2,280.00 1,451.37 9,120.00 5,388.63 59.1%6709220 Freight/Delivery- 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6709490 Miscellaneous - 100.00 (100.00) - 300.00 (300.00) 1,200.00 1,200.00 100.0%6709620 Postage/Mail Services 134.87 75.00 59.87 244.14 225.00 19.14 900.00 655.86 72.9%6709625 Professional Fees989.00 850.00 139.00 3,204.50 2,550.00 654.50 10,200.00 6,995.50 68.6%6709636 Promotion/Entertainment- 100.00 (100.00) - 300.00 (300.00) 3,100.00 3,100.00 100.0%6709722 Seminars & Training- 200.00 (200.00) - 600.00 (600.00) 2,400.00 2,400.00 100.0%6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms - 75.00 (75.00) - 225.00 (225.00) 1,050.00 1,050.00 100.0%Total-G&A-OTHER EXPENSES 3,800.38 3,580.00 220.38 11,177.27 10,090.00 1,087.27 44,410.00 33,232.73 74.8%24,200.45 25,914.00 (1,713.55) 71,902.24 76,992.00 (5,089.76) 314,808.00 242,905.76 77.2%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementSeptember 2010Annual Budget9 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 8,156.69 11,581.00 (3,424.31) 24,190.01 34,743.00 (10,552.99) 150,324.00 126,133.99 83.9%6800194 Equipment Leases-Trailer 260.00 600.00 (340.00) 1,600.00 1,800.00 (200.00) 7,200.00 5,600.00 77.8%6800196 Equipment Leases-GPS 7,942.00 8,636.00 (694.00) 23,826.00 25,908.00 (2,082.00) 90,216.00 66,390.00 73.6%6800197 Equipment Leases-Others 2,261.41 - 2,261.41 6,121.95 - 6,121.95 - - 0.0%18,620.10 20,817.00 (2,196.90) 55,737.96 62,451.00 (6,713.04) 247,740.00 198,123.99 80.0%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 13,249.50 10,026.00 3,223.50 50,210.30 52,988.00 (2,777.70) 90,000.00 39,789.70 44.2%6900210 FF&E Reserve 2,733.53 3,349.00 (615.47) 6,063.13 7,090.00 (1,026.87) 62,229.00 56,165.87 90.3%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) 3,408.32 6,600.00 (3,191.68) 26,400.00 22,991.68 87.1%16,416.47 15,575.00 841.47 64,881.04 80,248.00 (15,366.96) 192,199.00 127,317.96 66.2%Silverrock ResortOperating Leases & Miscellaneous Other Expense StatementSeptember 2010Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSES10 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2010-20112010 2010 2010 2010 2010 2010Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMediaSalesPromotionGolf Industry85VIPCelebrityPGA Comp68 72 76Charity/Gift Certificate12Rain/Wind Checks34Club Staff77 68 96LQ HS Golf20153 148 208 0 0 02011 2011 2011 2011 2011 2011Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIP11