Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
03 September 2011 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2011 – September 2011 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 Revenue153,594.50 152,719.00 875.50 0.6% 320,381.21 323,645.00 (3,263.79) 3,326,982.00 3,006,600.79 10%401000 Miscellaneous Golf Revenue 4,158.50 8,089.00 (3,930.50) -48.6% 13,536.90 21,064.00 (7,527.10) 146,537.00 133,000.10 9%410000 Revenue-Golf Shop 16,751.46 15,525.00 1,226.46 7.9% 35,848.68 31,337.00 4,511.68 310,919.00 275,070.32 12%420000 Revenue-F&B Concession500.00 500.00 - 0.0% 1,500.00 1,500.00 - 12,000.00 10,500.00 13%890000 Interest Income2.26 - 2.26 0.0% 12.88 - 12.88 - (12.88) 0%Total Income175,006.72 176,833.00 (1,826.28) -1.0% 371,279.67 377,546.00 (6,266.33) 3,796,438.00 3,425,158.33 10%Cost of Goods Sold510000 COS-Golf Shop 9,229.49 8,239.75 989.74 -12.0% 19,658.09 16,631.35 (3,026.74) 165,020.45 145,362.36 12%Total COS9,229.49 8,239.75 989.74 -12.0% 19,658.09 16,631.35 (3,026.74) 165,020.45 145,362.36 12%Gross Profit165,777.23 168,593.25 (2,816.02) -1.7% 351,621.58 360,914.65 (9,293.07) 3,631,417.55 3,279,795.97 10%Expenses610000 Golf Pro Shop 13,161.78 17,174.00 4,012.22 23.4% 42,255.69 50,084.00 7,828.31 223,325.00 181,069.31 19%630000 Course Maintenance137,570.72 144,033.00 6,462.28 4.5% 382,303.06 398,465.00 16,161.94 1,638,879.00 1,256,575.94 23%633000 Maintenance Water & Energy18,627.27 24,175.00 5,547.73 22.9% 69,309.82 79,720.00 10,410.18 270,449.00 201,139.18 26%640000 Outside Services17,830.26 16,547.00 (1,283.26) -7.8% 50,093.22 44,828.00 (5,265.22) 281,023.00 230,929.78 18%650000 Clubhouse 9,555.32 10,636.00 1,080.68 10.2% 29,285.15 31,908.00 2,622.85 132,232.00 102,946.85 22%660000 Marketing 23,072.52 27,876.00 4,803.48 17.2% 46,184.90 54,568.00 8,383.10 254,820.00 208,635.10 18%670000 General & Administrative24,764.75 25,902.00 1,137.25 4.4% 74,715.28 76,956.00 2,240.72 314,669.00 239,953.72 24%680000 Leases 18,984.29 19,590.00 605.71 3.1% 59,259.17 58,770.00 (489.17) 235,080.00 175,820.83 25%690000 Miscellaneous Other Expense13,493.95 20,192.00 6,698.05 33.2% 64,729.04 77,975.00 13,245.96 197,740.00 133,010.96 33%Total Expenses277,060.86 306,125.00 29,064.14 9.5% 818,135.33 873,274.00 55,138.67 3,548,217.00 2,730,081.67 23%(111,283.63) (137,531.75) 26,248.12 19.1%(466,513.75) (512,359.35) 45,845.60 83,200.55 549,714.30 -561%Rounds of Golf PlayedPaid Rounds Played 3,414 3,375 39 1.2% 8,257 8,125 132 45,625 37,368 18%Ave $ Per Paid Round Green Fee44.99 45.25 (0.26) -0.6% 38.80 39.83 (1.03) 72.92 34.12 53%Ave $ Per Paid Round Merchandise4.91 4.60 0.31 6.7% 4.34 3.86 0.48 6.81 2.47 64%Ave $ Per Paid Miscellaneous 1.22 2.40 (1.18) -49.2% 1.64 2.59 (0.95) 3.21 1.57 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateSeptember 20111 Income September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 153,594.50 152,719.00 875.50 320,381.21 323,645.00 (3,263.79) 3,326,982.003,006,600.7910%4010000 Rider Fee 400.00 338.00 62.00 2,850.00 813.00 2,037.00 7,446.004,596.0038%4040000 Club Rental 1,465.00 1,688.00 (223.00) 3,400.00 4,063.00 (663.00) 22,813.0019,413.0015%4050000 Driving Range 2,284.00 5,063.00 (2,779.00) 5,913.00 12,188.00 (6,275.00) 73,278.0067,365.008%4060000 Handicap Fees - - - - - - 0.000.000%4080000 GPS Advertising - 1,000.00 (1,000.00) 550.00 3,000.00 (2,450.00) 12,000.00 11,450.005%4090000 Ball Retriever/Subcontract - - - 814.40 1,000.00 (185.60) 4,000.00 3,185.6020%4091000 Golf Professional Rental Fee - - - - - - 27,000.00 27,000.00 0%4092000 Golf Lessons 9.50 - 9.50 9.50 - 9.50 - (9.50) 0% Total Revenue Fees 157,753.00 160,808.00 (3,055.00) 333,918.11 344,709.00 (10,790.89) 3,473,519.00 3,139,600.89 10%157,753.00 160,808.00 (3,055.00) 333,918.11 344,709.00 (10,790.89) 3,473,519.00 3,139,600.89 10%Total IncomeMonth to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueSeptember 20112 Income September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 436.00 - 436.00 920.00 - 920.00 0 0 0%4100110 Sales Hard Goods 8,536.35 5,434.00 3,102.35 19,011.04 10,968.00 8,043.04 108,822.00 89,810.96 17%4100112 Sales-Soft Goods 10,374.50 10,091.00 283.50 21,526.48 20,369.00 1,157.48 202,097.00 180,570.52 11%5100639 GS-Discounts-Mdse (2,595.39) - (2,595.39) (5,608.84) - (5,608.84) - 5,608.84 0% Total Revenue Golf Shop 16,751.46 15,525.00 1,226.46 35,848.68 31,337.00 4,511.68 310,919.00 275,990.32 11%COS 5100150 COS-GS-Hard Goods 4,928.24 2,988.70 1,939.54 9,908.42 6,032.40 3,876.02 59,852.10 49,943.68 17%5100151 COS-GS-Soft Goods 4,143.20 5,550.05 (1,406.85) 9,501.73 11,202.95 (1,701.22) 111,153.35 101,651.62 9%5100152 COS-GS-Purchase Disc (111.69) (427.00) 315.31 (111.69) (862.00) 750.31 (8,550.00) (8,438.31) -1%5100220 COS-GS-Freight Merch 269.74 128.00 141.74 359.63 258.00 101.63 2,565.00 2,205.37 14%Cost of Sales - Golf Shop 9,229.49 8,239.75 989.74 19,658.09 16,631.35 3,026.74 165,020.45 145,362.36 12%Gross Profit 7,521.97 7,285.25 236.72 16,190.59 14,705.65 1,484.94 145,898.55 130,627.96 10%COS % 55.1% 53.1% -2.0% 54.8% 53.1% -1.8% 53.1% 52.7% 1%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 2,607.66 1,986.00 621.66 7,822.98 5,958.00 1,864.98 26,811.00 18,988.02 29%6101325 Insurance-Workers Comp 441.74 454.00 (12.26) 1,325.22 1,350.00 (24.78) 6,131.00 4,805.78 22%6101720 Salaries 3,545.44 3,750.00 (204.56) 11,581.82 11,250.00 331.82 45,000.00 33,418.18 26%6101800 Taxes-Employer Payroll 688.54 1,261.00 (572.46) 2,192.33 3,749.00 (1,556.67) 17,040.00 14,847.67 13%6101880 Wages-Hourly 4,957.82 7,263.00 (2,305.18) 16,602.25 21,497.00 (4,894.75) 103,818.00 87,215.75 16%6101882 Wages-Overtime 118.13 - 118.13 297.62 - 297.62 - 952.88 0%Total -PS-SALARIES & BENEFITS 12,359.33 14,714.00 (2,354.67) 39,822.22 43,804.00 (3,981.78) 198,800.00 160,228.28 19%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 184.04 500.00 (315.96) 431.72 1,500.00 (1,068.28) 6,000.00 5,568.28 7%6109090 Contract Services 500.00 500.00 - 1,500.00 1,500.00 - 6,000.00 4,500.00 25%6109220 Freight & Delivery 14.98 - 14.98 33.27 - 33.27 75.00 41.73 44%6109490 Miscellaneous - - - - - - 450.00 450.00 0%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short (15.36) - (15.36) 29.06 - 29.06 - (29.06) 0%6109722 Seminars/Training - 1,250.00 (1,250.00) - 2,650.00 (2,650.00) 5,890.00 5,890.00 0%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms - 100.00 (100.00) 94.49 300.00 (205.51) 2,400.00 2,305.51 4%6117840 Telephones 118.79 110.00 8.79 344.93 330.00 14.93 1,320.00 975.07 0%Total PS-OTHER EXPENSES 802.45 2,460.00 (1,657.55) 2,433.47 6,280.00 (3,846.53) 24,525.00 22,091.53 10%13,161.78 17,174.00 (4,012.22) 42,255.69 50,084.00 (7,828.31) 223,325.00 182,319.81 18%Net Income(5,639.81) (9,888.75) 4,248.94 (26,065.10) (35,378.35) 9,313.25 (77,426.45) (51,691.85) -33%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementSeptember 20113 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 8,015.96 8,740.00 (724.04) 23,628.22 26,220.00 (2,591.78) 104,880.00 81,251.78 77.5%6311325 Insurance-Workers Comp 1,824.54 2,268.00 (443.46) 5,473.62 6,804.00 (1,330.38) 28,026.00 22,552.38 80.5%6311720 Salaries 11,001.60 12,583.00 (1,581.40) 35,938.56 37,749.00 (1,810.44) 150,996.00 115,057.44 76.2%6311800 Taxes-Employer Payroll 4,481.15 6,304.00 (1,822.85) 14,243.08 18,912.00 (4,668.92) 78,501.00 64,257.92 81.9%6311880 Wages-Hourly 43,547.59 42,473.00 1,074.59 130,266.65 127,419.00 2,847.65 518,654.00 388,387.35 74.9%6311882 Wages-Overtime 24.01 - 24.01 248.75 - 248.75 15,945.00 15,696.25 98.4%Total-CM-SALARIES & BENEFITS68,894.85 72,368.00 (3,473.15) 209,798.88 217,104.00 (7,305.12) 897,002.00 687,203.12 76.6%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 3,468.57 3,500.00 (31.43) 9,395.33 9,500.00 (104.67) 29,300.00 19,904.67 67.9%6313744 Fertilizer 11,866.95 11,000.00 866.95 38,140.52 35,400.00 2,740.52 104,400.00 66,259.48 63.5%6313745 Herbicides 6,734.50 7,000.00 (265.50) 6,734.50 7,000.00 (265.50) 17,000.00 10,265.50 60.4%6313746 Flowers/Plants 1,332.18 1,000.00 332.18 1,332.18 1,000.00 332.18 3,050.00 1,717.82 56.3%6313748 Fuel-Gasoline 4,416.03 4,450.00 (33.97) 14,563.98 12,850.00 1,713.98 48,800.00 34,236.02 70.2%6313750 Golf Course Accessories - 500.00 (500.00) 247.82 900.00 (652.18) 12,300.00 12,052.18 98.0%6313756 POA Control 230.80 - 230.80 472.73 - 472.73 7,000.00 6,527.27 93.2%6313758 Miscellaneous Supp 574.95 750.00 (175.05) 2,084.25 2,250.00 (165.75) 4,350.00 2,265.75 0.0%6313762 Supplies-Office - - - 215.48 - 215.48 - (215.48) 0.0%6313774 Sand 3,868.77 5,000.00 (1,131.23) 3,868.77 5,780.00 (1,911.23) 16,460.00 12,591.23 76.5%6313776 Seed 598.93 250.00 348.93 1,630.37 950.00 680.37 106,810.00 105,179.63 98.5%6313778 Small Tools & Non-Capital Equip 1,162.04 2,000.00 (837.96) 1,258.61 2,200.00 (941.39) 5,000.00 3,741.39 74.8%6313780 Sod - 200.00 (200.00) 1,284.84 1,400.00 (115.16) 6,350.00 5,065.16 79.8%6313782 Topdressing - - - 2,321.95 2,500.00 (178.05) 7,600.00 5,278.05 69.4%Total-CM-SUPPLIES & MATERIALS34,253.72 35,650.00 (1,396.28) 83,551.33 81,730.00 1,821.33 368,420.00 284,868.67 77.3%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,830.00 2,600.00 230.00 8,490.00 7,800.00 690.00 31,200.00 22,710.00 72.8%6315685 CM-R&M-Bldngs & Othr Structures 218.50 250.00 (31.50) 483.50 750.00 (266.50) 1,750.00 1,266.50 72.4%6315690 CM-R&M-Equipment 4,491.52 1,000.00 3,491.52 9,716.83 3,000.00 6,716.83 20,500.00 10,783.17 52.6%6315692 CM-R&M-Irrigation System 1,999.52 2,200.00 (200.48) 9,882.14 13,000.00 (3,117.86) 22,650.00 12,767.86 56.4%6315696 CM-R&M-Pumps - 1,000.00 (1,000.00) - 3,000.00 (3,000.00) 10,500.00 10,500.00 100.0%6315815 CM-R&M-Trees-Pruning Etc 2,295.00 3,500.00 (1,205.00) 2,295.00 3,500.00 (1,205.00) 10,050.00 7,755.00 77.2%Total-CM-REPAIRS & MAINTENANCE 11,834.54 10,550.00 1,284.54 30,867.47 31,050.00 (182.53) 96,650.00 65,782.53 68.1%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 18.69 15.00 3.69 48.86 45.00 3.86 180.00 131.14 0.0%6317840 Telephones 1,040.00 850.00 190.00 3,124.00 2,550.00 574.00 10,200.00 7,076.00 69.4%Total-CM-UTILITIES 1,058.69 865.00 193.69 3,172.86 2,595.00 577.86 10,380.00 7,207.14 69.4%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 2,000.00 2,000.00 - 2,000.00 2,000.00 - 4,000.00 2,000.00 50.0%6319102 Contract Svcs-Trash Removal 1,370.65 524.00 846.65 2,377.95 1,572.00 805.95 6,288.00 3,910.05 0.0%6319150 Dues & Subscriptions 210.00 - 210.00 210.00 - 210.00 540.00 330.00 61.1%6319170 Employee Education 59.00 50.00 9.00 59.00 150.00 (91.00) 1,550.00 1,491.00 96.2%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) - 280.00 (280.00) 1,430.00 1,430.00 100.0%6319490 Miscellaneous 190.00 100.00 90.00 434.80 300.00 134.80 1,200.00 765.20 63.8%6319718 Safety Equipment & Training 414.05 750.00 (335.95) 724.47 1,050.00 (325.53) 3,850.00 3,125.53 81.2%6319822 Uniforms 1,432.47 920.00 512.47 2,802.83 2,760.00 42.83 11,040.00 8,237.17 74.6%Total-CM-OTHER EXPENSES 6,176.17 5,074.00 1,102.17 10,109.05 10,112.00 (2.95) 40,098.00 29,988.95 74.8%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementSeptember 2011Annual Budget4 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,615.33 2,648.00 (1,032.67) 4,845.99 7,944.00 (3,098.01) 31,776.00 26,930.01 84.7%6321325 Insurance-Workers Comp 368.90 557.00 (188.10) 1,106.70 1,619.00 (512.30) 6,543.00 5,436.30 83.1%6321800 Taxes-Employer Payroll 1,374.55 1,585.00 (210.45) 3,071.99 4,535.00 (1,463.01) 18,416.00 15,344.01 83.3%6321880 Wages-Hourly 11,659.38 12,880.00 (1,220.62) 35,097.63 38,640.00 (3,542.37) 154,560.00 119,462.37 77.3%6321882 Wages-Overtime - 966.00 (966.00) 64.32 966.00 (901.68) 6,279.00 6,214.68 99.0%Total-CM-LM-SALARIES & BENEFITS15,018.16 18,636.00 (3,617.84) 44,186.63 53,704.00 (9,517.37) 217,574.00 173,387.37 79.7%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 334.59 290.00 44.59 616.84 870.00 (253.16) 3,480.00 2,863.16 82.3%Total-CM-LM-SUPPLIES & MATERIALS334.59 390.00 (55.41) 616.84 1,170.00 (553.16) 4,505.00 3,888.16 86.3%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%137,570.72 144,033.00 (6,462.28) 382,303.06 398,465.00 (16,161.94) 1,638,879.00 1,256,575.94 76.7% September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 12,051.70 18,015.00 (5,963.30) 50,049.47 62,400.00 (12,350.53) 227,391.00 177,341.53 78.0%6337842 Utilities-Water6,575.57 6,160.00 415.57 19,260.35 17,320.00 1,940.35 43,058.00 23,797.65 55.3%18,627.27 24,175.00 (5,547.73) 69,309.82 79,720.00 (10,410.18) 270,449.00 201,139.18 74.4%Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetSilverrock ResortCourse Maintenance Water & EnergySeptember 2011Total-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementSeptember 2011Annual BudgetMonth to Date Year to Date5 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group 446.57 662.00 (215.43) 1,339.71 1,986.00 (646.29) 7,944.00 6,604.29 83.1%6411325 Insurance-Workers Comp 392.19 367.00 25.19 1,176.57 971.00 205.57 5,096.00 3,919.43 76.9%6411800 Taxes-Employer Payroll 786.11 1,110.00 (323.89) 2,463.37 2,936.00 (472.63) 15,399.00 12,935.63 84.0%6411880 Wages-Hourly 7,832.14 8,918.00 (1,085.86) 23,200.71 23,585.00 (384.29) 123,689.00 100,488.29 81.2%6411882 Wages-Overtime 66.56 - 66.56 316.33 - 316.33 - (316.33) 0.0%Total-CBR-SALARIES & BENEFITS9,523.57 11,057.00 (1,533.43) 28,496.69 29,478.00 (981.31) 152,128.00 123,631.31 81.3%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 525.28 - 525.28 633.03 - 633.03 2,350.00 1,716.97 73.1%6413742 Supplies-Expendable 706.10 150.00 556.10 2,215.05 1,350.00 865.05 6,750.00 4,534.95 67.2%6413752 Supplies-Range Balls - - - - - - 9,000.00 9,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 480.00 72.00 408.00 1,120.00 216.00 904.00 1,005.00 (115.00) -11.4%6413796 Supplies-Bottled Water158.69 50.00 108.69 586.07 150.00 436.07 24,500.00 23,913.93 97.6%Total-CBR-SUPPLIES & MATERIALS1,870.07 297.00 1,573.07 4,554.15 1,791.00 2,763.15 44,550.00 39,995.85 89.8%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment - 300.00 (300.00) 680.32 900.00 (219.68) 3,600.00 2,919.68 81.1%6415695 CBR-R&M-Cart Maintenance & Repair 650.69 750.00 (99.31) 1,140.60 2,250.00 (1,109.40) 9,750.00 8,609.40 88.3%Total-CBR-REPAIRS & MAINTENANCE 650.69 1,050.00 (399.31) 1,820.92 3,150.00 (1,329.08) 13,350.00 11,529.08 86.4%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 1,431.63 800.00 631.63 3,575.48 2,400.00 1,175.48 9,600.00 6,024.52 62.8%6419220 Freight/Delivery - 75.00 (75.00) - 225.00 (225.00) 450.00 450.00 100.0%6419490 Miscellaneous - 75.00 (75.00) 310.67 275.00 35.67 1,150.00 839.33 73.0%6419820 Uniforms - - - - - - 5,200.00 5,200.00 100.0%Total-CBR-OTHER EXPENSES 1,431.63 950.00 481.63 3,886.15 2,900.00 986.15 16,400.00 12,513.85 76.3%TOTAL-CARTS,BAGROOM & RANGE 13,475.96 13,354.00 121.96 38,757.91 37,319.00 1,438.91 226,428.00 187,670.09 82.9%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 258.70 106.00 152.70 776.10 247.00 529.10 1,805.00 1,028.90 57.0%6431800 Taxes-Employer Payroll 496.60 294.00 202.60 1,326.21 687.00 639.21 5,015.00 3,688.79 73.6%6431880 Wages-Hourly 3,394.00 2,568.00 826.00 9,028.00 6,000.00 3,028.00 43,800.00 34,772.00 79.4%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS4,149.30 2,968.00 1,181.30 11,130.31 6,934.00 4,196.31 50,620.00 39,489.69 78.0%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 205.00 75.00 130.00 205.00 225.00 (20.00) 2,125.00 1,920.00 90.4%Total-CS-OTHER EXPENSES 205.00 225.00 (20.00) 205.00 575.00 (370.00) 3,975.00 3,770.00 94.8%Total-COURSE SERVICES 4,354.30 3,193.00 1,161.30 11,335.31 7,509.00 3,826.31 54,595.00 43,259.69 79.2%17,830.26 16,547.00 1,283.26 50,093.22 44,828.00 5,265.22 281,023.00 227,159.78 80.8%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementSeptember 2011Annual Budget6 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable29.95 400.00 (370.05) 89.85 1,200.00 (1,110.15) 4,800.00 4,710.15 98.1%Total-CH-SUPPLIES & MATERIALS 29.95 400.00 (370.05) 89.85 1,200.00 (1,110.15) 4,800.00 4,710.15 98.1%65-CH-UTILITIES6507836 Utilities-Natural Gas339.90 300.00 39.90 975.63 900.00 75.63 3,600.00 2,624.37 72.9%6507840 Utilities-Telephone972.76 1,150.00 (177.24) 3,139.61 3,450.00 (310.39) 13,800.00 10,660.39 77.2%6507842 Utilities-Water364.94 321.00 43.94 1,286.60 963.00 323.60 3,852.00 2,565.40 66.6%6507844 Utilities-Cable336.89 340.00 (3.11) 1,010.67 1,020.00 (9.33) 4,080.00 3,069.33 75.2%Total-CH-UTILITIES 2,014.49 2,111.00 (96.51) 6,412.51 6,333.00 79.51 25,332.00 18,919.49 74.7%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 5,475.00 5,475.00 - 22,500.00 17,025.00 75.7%6509099 Contract Services-Security5,078.88 4,900.00 178.88 14,485.48 14,700.00 (214.52) 60,400.00 45,914.52 76.0%6509215 Flowers & Decorations- - - - - - 2,400.00 2,400.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 602.86 600.00 2.86 2,400.00 1,797.14 74.9%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,903.88 7,025.00 (121.12) 20,563.34 21,075.00 (511.66) 88,900.00 68,336.66 76.9%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures296.00 300.00 (4.00) 1,636.21 900.00 736.21 3,600.00 1,963.79 54.5%6515686 CH-R&M-Restaurant Repairs311.00 400.00 (89.00) 526.00 1,200.00 (674.00) 4,800.00 4,274.00 89.0%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 57.24 1,200.00 (1,142.76) 4,800.00 4,742.76 98.8%Total-CH-REPAIRS & MAINTENANCE 607.00 1,100.00 (493.00) 2,219.45 3,300.00 (1,080.55) 13,200.00 10,980.55 83.2%9,555.32 10,636.00 (1,080.68) 29,285.15 31,908.00 (2,622.85) 132,232.00 21,961.10 16.6%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementSeptember 2011Annual Budget7 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 264.78 331.00 (66.22) 680.82 993.00 (312.18) 3,972.00 3,291.18 82.9%6601325 Insurance-Workers Comp 174.88 103.00 71.88 524.64 309.00 215.64 1,240.00 715.36 57.7%6601720 Salaries 2,204.48 2,508.00 (303.52) 6,879.48 7,524.00 (644.52) 30,096.00 23,216.52 77.1%6601800 Taxes-Employer Payroll 186.21 287.00 (100.79) 621.40 861.00 (239.60) 3,446.00 2,824.60 82.0%Total-MKT-SALARIES & BENEFITS 2,830.35 3,229.00 (398.65) 8,706.34 9,687.00 (980.66) 38,754.00 30,047.66 77.5%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 2,235.14 200.00 2,035.14 2,235.14 200.00 2,035.14 4,425.00 2,189.86 49.5%2,235.14 300.00 1,935.14 2,235.14 500.00 1,735.14 5,625.00 3,389.86 60.3%66-MKT-UTILITIES6607840 Utilities-Telephone 48.05 100.00 (51.95) 143.33 300.00 (156.67) 1,200.00 1,056.67 88.1%Total-MKT-UTILITIES 48.05 100.00 (51.95) 143.33 300.00 (156.67) 1,200.00 1,056.67 88.1%66-MKT-OTHER EXPENSES6609010 Advertising 17,759.98 23,197.00 (5,437.02) 34,703.09 41,931.00 (7,227.91) 185,731.00 151,027.91 81.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) 297.00 1,200.00 (903.00) 4,800.00 4,503.00 93.8%6609490 Miscellaneous - - - - - - 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%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 100.00 - 100.00 100.00 - 100.00 735.00 635.00 86.4%6609820 Uniforms - - - - - - 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 17,958.98 24,247.00 (6,288.02) 35,100.09 44,081.00 (8,980.91) 209,241.00 173,440.91 82.9%23,072.52 27,876.00 (4,803.48) 46,184.90 54,568.00 (8,383.10) 254,820.00 207,935.10 81.6%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementSeptember 2011Annual Budget8 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group2,850.25 1,458.00 1,392.25 8,550.75 4,374.00 4,176.75 17,496.00 8,945.25 51.1%6701325 Insurance-Workers Comp588.76 707.00 (118.24) 1,766.28 2,121.00 (354.72) 8,480.00 6,713.72 79.2%6701720 Salaries 14,816.26 14,833.34 (17.08) 43,826.45 44,500.02 (673.57) 178,000.00 134,173.55 75.4%6701800 Taxes-Employer Payroll 1,102.32 1,964.00 (861.68) 3,721.25 5,892.00 (2,170.75) 23,568.00 19,846.75 84.2%6701880 Wages-Hourly993.25 2,319.66 (1,326.41) 4,861.08 6,958.98 (2,097.90) 27,835.00 22,973.92 82.5%6701882 Wages-Overtime - - - 10.88 - 10.88 - (10.88) 0.0%Total-G&A-SALARIES & BENEFITS 20,350.84 21,282.00 (931.16) 62,736.69 63,846.00 (1,109.31) 255,379.00 192,642.31 75.4%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer674.24 400.00 274.24 674.24 1,200.00 (525.76) 5,200.00 4,525.76 87.0%6703762 Supplies-Office 178.59 100.00 78.59 250.21 300.00 (49.79) 1,200.00 949.79 79.1%6703768 Supplies-Printing & Stationery236.35 100.00 136.35 236.35 300.00 (63.65) 3,300.00 3,063.65 92.8%Total-G&A-SUPPLIES & MATERIALS 1,089.18 600.00 489.18 1,160.80 1,800.00 (639.20) 9,700.00 8,539.20 88.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) 150.00 250.00 (100.00) 1,700.00 1,550.00 91.2%6709180 Employee Recruiting/Relocation56.00 200.00 (144.00) 140.00 200.00 (60.00) 1,400.00 1,260.00 90.0%6709197 Equipment Rental700.91 480.00 220.91 1,861.17 1,440.00 421.17 5,760.00 3,898.83 67.7%6709202 Fees-Bank49.78 90.00 (40.22) 253.39 270.00 (16.61) 1,080.00 826.61 76.5%6709208 Fees-Payroll Processing989.30 1,100.00 (110.70) 3,613.78 3,300.00 313.78 13,200.00 9,586.22 72.6%6709220 Freight/Delivery- 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6709490 Miscellaneous - 100.00 (100.00) 365.14 300.00 65.14 1,200.00 834.86 69.6%6709620 Postage/Mail Services 106.99 75.00 31.99 315.98 225.00 90.98 900.00 584.02 64.9%6709625 Professional Fees771.75 850.00 (78.25) 2,443.95 2,550.00 (106.05) 10,200.00 7,756.05 76.0%6709636 Promotion/Entertainment- 100.00 (100.00) - 300.00 (300.00) 3,100.00 3,100.00 100.0%6709722 Seminars & Training250.00 200.00 50.00 250.00 600.00 (350.00) 2,400.00 2,150.00 89.6%6709810 Travel - - - 224.38 100.00 124.38 1,100.00 875.62 79.6%6709820 Uniforms - 75.00 (75.00) - 225.00 (225.00) 1,050.00 1,050.00 100.0%Total-G&A-OTHER EXPENSES 3,324.73 3,920.00 (595.27) 10,817.79 11,110.00 (292.21) 48,490.00 37,672.21 77.7%24,764.75 25,902.00 (1,137.25) 74,715.28 76,956.00 (2,240.72) 314,669.00 239,953.72 76.3%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementSeptember 2011Annual Budget9 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,091.63 12,075.00 (983.37) 33,274.89 36,225.00 (2,950.11) 144,900.00 111,625.11 77.0%6800194 Equipment Leases-Trailer 502.54 600.00 (97.46) 1,536.08 1,800.00 (263.92) 7,200.00 5,663.92 78.7%6800196 Equipment Leases-GPS 5,290.50 5,755.00 (464.50) 15,871.50 17,265.00 (1,393.50) 69,060.00 53,188.50 77.0%6800197 Equipment Leases-Others 2,099.62 1,160.00 939.62 8,576.70 3,480.00 5,096.70 13,920.00 5,343.30 0.0%18,984.29 19,590.00 (605.71) 59,259.17 58,770.00 489.17 235,080.00 175,820.83 74.8%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 10,012.04 14,938.00 (4,925.96) 47,948.52 59,702.00 (11,753.48) 90,000.00 42,051.48 46.7%6900210 FF&E Reserve 3,071.89 3,054.00 17.89 6,407.63 6,473.00 (65.37) 66,540.00 60,132.37 90.4%6900800 Personal Property Taxes 410.02 - 410.02 7,440.69 5,200.00 2,240.69 14,800.00 7,359.31 49.7%6900323 Insurance-Commercial - 2,200.00 (2,200.00) 2,932.20 6,600.00 (3,667.80) 26,400.00 23,467.80 88.9%13,493.95 20,192.00 (6,698.05) 64,729.04 77,975.00 (13,245.96) 197,740.00 133,010.96 67.3%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementSeptember 201110 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2011-20122011 2011 2011 2011 2011 2011Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia51Sales4PromotionGolf Industry6VIPCelebrityPGA Comp64 60 50Charity/Gift Certificate214Rain/Wind Checks321Club Staff65 62 91LQ HS Golf2412141 136 162 0 0 02012 2012 2012 2012 2012 2012Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2011-2012September 2011 Date Time Description CategoryPlayers9/27/2011 7:22 Derrick Eggers-Time Warner Sales 412