Loading...
02 August 2011 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2011 – August 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 August Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue69,252.46 80,395.00 (11,142.54) -13.9% 166,786.71 170,926.00 (4,139.29) 3,326,982.00 3,160,195.29 5%401000 Miscellaneous Golf Revenue 3,572.00 5,725.00 (2,153.00) -37.6% 9,378.40 12,975.00 (3,596.60) 146,537.00 137,158.60 6%410000 Revenue-Golf Shop 8,036.64 7,312.00 724.64 9.9% 19,097.22 15,812.00 3,285.22 310,919.00 291,821.78 6%420000 Revenue-F&B Concession500.00 500.00 - 0.0% 1,000.00 1,000.00 - 12,000.00 11,000.00 8%890000 Interest Income4.87 - 4.87 0.0% 10.62 - 10.62 - (10.62) 0%Total Income81,365.97 93,932.00 (12,566.03) -13.4% 196,272.95 200,713.00 (4,440.05) 3,796,438.00 3,600,165.05 5%Cost of Goods Sold510000 COS-Golf Shop 4,683.86 3,880.60 803.26 -20.7% 10,428.60 8,391.60 (2,037.00) 165,020.45 154,591.85 6%Total COS4,683.86 3,880.60 803.26 -20.7% 10,428.60 8,391.60 (2,037.00) 165,020.45 154,591.85 6%Gross Profit76,682.11 90,051.40 (13,369.29) -14.8% 185,844.35 192,321.40 (6,477.05) 3,631,417.55 3,445,573.20 5%Expenses610000 Golf Pro Shop 15,625.08 15,905.00 279.92 1.8% 29,093.91 32,910.00 3,816.09 223,325.00 194,231.09 13%630000 Course Maintenance129,566.33 130,041.00 474.67 0.4% 244,732.34 254,432.00 9,699.66 1,638,879.00 1,394,146.66 15%633000 Maintenance Water & Energy23,615.67 29,520.00 5,904.33 20.0% 50,682.55 55,545.00 4,862.45 270,449.00 219,766.45 19%640000 Outside Services15,006.83 13,613.00 (1,393.83) -10.2% 32,262.96 28,281.00 (3,981.96) 281,023.00 248,760.04 11%650000 Clubhouse 9,156.66 10,636.00 1,479.34 13.9% 19,729.83 21,272.00 1,542.17 132,232.00 112,502.17 15%660000 Marketing 11,277.92 14,541.00 3,263.08 22.4% 23,112.38 26,692.00 3,579.62 254,820.00 231,707.62 9%670000 General & Administrative25,433.60 25,602.00 168.40 0.7% 49,950.53 51,054.00 1,103.47 314,669.00 264,718.47 16%680000 Leases 20,228.29 19,590.00 (638.29) -3.3% 40,274.88 39,180.00 (1,094.88) 235,080.00 194,805.12 17%690000 Miscellaneous Other Expense24,728.55 27,351.00 2,622.45 9.6% 51,235.09 57,783.00 6,547.91 197,740.00 146,504.91 26%Total Expenses274,638.93 286,799.00 12,160.07 4.2% 541,074.47 567,149.00 26,074.53 3,548,217.00 3,007,142.53 15%(197,956.82) (196,747.60) (1,209.22) -0.6%(355,230.12) (374,827.60) 19,597.48 83,200.55 438,430.67 -427%Rounds of Golf PlayedPaid Rounds Played 2,090 2,250 (160) -7.1% 4,843 4,750 93 45,625 40,782 11%Ave $ Per Paid Round Green Fee33.14 35.73 (2.60) -7.3% 34.44 35.98 (1.55) 72.92 38.48 47%Ave $ Per Paid Round Merchandise3.85 3.25 0.60 18.3% 3.94 3.33 0.61 6.81 2.87 58%Ave $ Per Paid Miscellaneous 1.71 2.54 (0.84) -32.8% 1.94 2.73 (0.80) 3.21 1.28 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateAugust 20111 Income August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 69,252.46 80,395.00 (11,142.54) 166,786.71 170,926.00 (4,139.29) 3,326,982.003,160,195.295%4010000 Rider Fee 525.00 225.00 300.00 2,450.00 475.00 1,975.00 7,446.004,996.0033%4040000 Club Rental 830.00 1,125.00 (295.00) 1,935.00 2,375.00 (440.00) 22,813.0020,878.008%4050000 Driving Range 1,667.00 3,375.00 (1,708.00) 3,629.00 7,125.00 (3,496.00) 73,278.0069,649.005%4060000 Handicap Fees - - - - - - 0.000.000%4080000 GPS Advertising 550.00 1,000.00 (450.00) 550.00 2,000.00 (1,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 - - - - - - - - 0% Total Revenue Fees 72,824.46 86,120.00 (13,295.54) 176,165.11 183,901.00 (7,735.89) 3,473,519.00 3,297,353.89 5%72,824.46 86,120.00 (13,295.54) 176,165.11 183,901.00 (7,735.89) 3,473,519.00 3,297,353.89 5%SilverRock ResortStatement of Fees RevenueAugust 2011Total IncomeMonth to Date Year to Date Annual Budget2 Income August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 118.00 - 118.00 484.00 - 484.00 0 0 0%4100110 Sales Hard Goods 5,093.98 2,559.00 2,534.98 10,474.69 5,534.00 4,940.69 108,822.00 98,347.31 10%4100112 Sales-Soft Goods 4,373.32 4,753.00 (379.68) 11,151.98 10,278.00 873.98 202,097.00 190,945.02 6%5100639 GS-Discounts-Mdse (1,548.66) - (1,548.66) (3,013.45) - (3,013.45) - 3,013.45 0% Total Revenue Golf Shop 8,036.64 7,312.00 724.64 19,097.22 15,812.00 3,285.22 310,919.00 292,305.78 6%COS 5100150 COS-GS-Hard Goods 2,426.64 1,407.45 1,019.19 4,980.18 3,043.70 1,936.48 59,852.10 54,871.92 8%5100151 COS-GS-Soft Goods 2,167.33 2,614.15 (446.82) 5,358.53 5,652.90 (294.37) 111,153.35 105,794.82 5%5100152 COS-GS-Purchase Disc - (201.00) 201.00 - (435.00) 435.00 (8,550.00) (8,550.00) 0%5100220 COS-GS-Freight Merch 89.89 60.00 29.89 89.89 130.00 (40.11) 2,565.00 2,475.11 4%Cost of Sales - Golf Shop 4,683.86 3,880.60 803.26 10,428.60 8,391.60 2,037.00 165,020.45 154,591.85 6%Gross Profit 3,352.78 3,431.40 (78.62) 8,668.62 7,420.40 1,248.22 145,898.55 137,713.93 6%COS % 58.3% 53.1% -5.2% 54.6% 53.1% -1.5% 53.1% 52.9% 0%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 2,607.66 1,986.00 621.66 5,215.32 3,972.00 1,243.32 26,811.00 21,595.68 19%6101325 Insurance-Workers Comp 441.74 448.00 (6.26) 883.48 896.00 (12.52) 6,131.00 5,247.52 14%6101720 Salaries 4,254.55 3,750.00 504.55 8,036.38 7,500.00 536.38 45,000.00 36,963.62 18%6101800 Taxes-Employer Payroll 757.88 1,244.00 (486.12) 1,503.79 2,488.00 (984.21) 17,040.00 15,536.21 9%6101880 Wages-Hourly 6,554.58 7,117.00 (562.42) 11,644.43 14,234.00 (2,589.57) 103,818.00 92,173.57 11%6101882 Wages-Overtime 105.94 - 105.94 179.49 - 179.49 - 952.88 0%Total -PS-SALARIES & BENEFITS 14,722.35 14,545.00 177.35 27,462.89 29,090.00 (1,627.11) 198,800.00 172,469.48 13%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 187.99 500.00 (312.01) 247.68 1,000.00 (752.32) 6,000.00 5,752.32 4%6109090 Contract Services 500.00 500.00 - 1,000.00 1,000.00 - 6,000.00 5,000.00 17%6109220 Freight & Delivery - - - 18.29 - 18.29 75.00 56.71 24%6109490 Miscellaneous - - - - - - 450.00 450.00 0%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short 6.68 - 6.68 44.42 - 44.42 - (44.42) 0%6109722 Seminars/Training - 150.00 (150.00) - 1,400.00 (1,400.00) 5,890.00 5,890.00 0%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms 94.49 100.00 (5.51) 94.49 200.00 (105.51) 2,400.00 2,305.51 4%6117840 Telephones 113.57 110.00 3.57 226.14 220.00 6.14 1,320.00 1,093.86 0%Total PS-OTHER EXPENSES 902.73 1,360.00 (457.27) 1,631.02 3,820.00 (2,188.98) 24,525.00 22,893.98 7%15,625.08 15,905.00 (279.92) 29,093.91 32,910.00 (3,816.09) 223,325.00 195,363.46 13%Net Income(12,272.30) (12,473.60) 201.30 (20,425.29) (25,489.60) 5,064.31 (77,426.45) (57,649.53) -26%SilverRock ResortGolf Shop Income StatementAugust 2011Total Expenses-Golf ShopMonth to Date Year to Date Annual Budget3 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 8,040.64 8,740.00 (699.36) 15,612.26 17,480.00 (1,867.74) 104,880.00 89,267.74 85.1%6311325 Insurance-Workers Comp 1,824.54 2,268.00 (443.46) 3,649.08 4,536.00 (886.92) 28,026.00 24,376.92 87.0%6311720 Salaries 13,201.92 12,583.00 618.92 24,936.96 25,166.00 (229.04) 150,996.00 126,059.04 83.5%6311800 Taxes-Employer Payroll 4,981.62 6,304.00 (1,322.38) 9,761.93 12,608.00 (2,846.07) 78,501.00 68,739.07 87.6%6311880 Wages-Hourly 43,551.43 42,473.00 1,078.43 86,719.06 84,946.00 1,773.06 518,654.00 431,934.94 83.3%6311882 Wages-Overtime 72.81 - 72.81 224.74 - 224.74 15,945.00 15,720.26 98.6%Total-CM-SALARIES & BENEFITS71,672.96 72,368.00 (695.04) 140,904.03 144,736.00 (3,831.97) 897,002.00 756,097.97 84.3%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 3,063.95 2,500.00 563.95 5,926.76 6,000.00 (73.24) 29,300.00 23,373.24 79.8%6313744 Fertilizer 16,896.51 16,000.00 896.51 26,273.57 24,400.00 1,873.57 104,400.00 78,126.43 74.8%6313745 Herbicides - - - - - - 17,000.00 17,000.00 100.0%6313746 Flowers/Plants - - - - - - 3,050.00 3,050.00 100.0%6313748 Fuel-Gasoline 4,894.44 4,200.00 694.44 10,147.95 8,400.00 1,747.95 48,800.00 38,652.05 79.2%6313750 Golf Course Accessories 123.91 200.00 (76.09) 247.82 400.00 (152.18) 12,300.00 12,052.18 98.0%6313756 POA Control 241.93 - 241.93 241.93 - 241.93 7,000.00 6,758.07 96.5%6313758 Miscellaneous Supp 660.21 750.00 (89.79) 1,509.30 1,500.00 9.30 4,350.00 2,840.70 0.0%6313762 Supplies-Office 215.48 - 215.48 215.48 - 215.48 - (215.48) 0.0%6313774 Sand - 390.00 (390.00) - 780.00 (780.00) 16,460.00 16,460.00 100.0%6313776 Seed 748.60 350.00 398.60 1,031.44 700.00 331.44 106,810.00 105,778.56 99.0%6313778 Small Tools & Non-Capital Equip 96.57 100.00 (3.43) 96.57 200.00 (103.43) 5,000.00 4,903.43 98.1%6313780 Sod 124.01 200.00 (75.99) 1,284.84 1,200.00 84.84 6,350.00 5,065.16 79.8%6313782 Topdressing 1,160.83 1,250.00 (89.17) 2,321.95 2,500.00 (178.05) 7,600.00 5,278.05 69.4%Total-CM-SUPPLIES & MATERIALS28,226.44 25,940.00 2,286.44 49,297.61 46,080.00 3,217.61 368,420.00 319,122.39 86.6%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,830.00 2,600.00 230.00 5,660.00 5,200.00 460.00 31,200.00 25,540.00 81.9%6315685 CM-R&M-Bldngs & Othr Structures 132.50 250.00 (117.50) 265.00 500.00 (235.00) 1,750.00 1,485.00 84.9%6315690 CM-R&M-Equipment 1,939.59 1,000.00 939.59 5,225.31 2,000.00 3,225.31 20,500.00 15,274.69 74.5%6315692 CM-R&M-Irrigation System 4,990.86 5,400.00 (409.14) 7,882.62 10,800.00 (2,917.38) 22,650.00 14,767.38 65.2%6315696 CM-R&M-Pumps - 1,000.00 (1,000.00) - 2,000.00 (2,000.00) 10,500.00 10,500.00 100.0%6315815 CM-R&M-Trees-Pruning Etc - - - - - - 10,050.00 10,050.00 100.0%Total-CM-REPAIRS & MAINTENANCE 9,892.95 10,250.00 (357.05) 19,032.93 20,500.00 (1,467.07) 96,650.00 77,617.07 80.3%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 6.37 15.00 (8.63) 30.17 30.00 0.17 180.00 149.83 0.0%6317840 Telephones 1,057.95 850.00 207.95 2,084.00 1,700.00 384.00 10,200.00 8,116.00 79.6%Total-CM-UTILITIES 1,064.32 865.00 199.32 2,114.17 1,730.00 384.17 10,380.00 8,265.83 79.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%6319100 Contract Svcs-Soil/Tissue Test - - - - - - 4,000.00 4,000.00 100.0%6319102 Contract Svcs-Trash Removal 470.65 524.00 (53.35) 1,007.30 1,048.00 (40.70) 6,288.00 5,280.70 0.0%6319150 Dues & Subscriptions - - - - - - 540.00 540.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 - 150.00 (150.00) - 350.00 (350.00) 4,200.00 4,200.00 100.0%6319206 Licenses & Permits - 100.00 (100.00) - 200.00 (200.00) 1,430.00 1,430.00 100.0%6319490 Miscellaneous 244.80 100.00 144.80 244.80 200.00 44.80 1,200.00 955.20 79.6%6319718 Safety Equipment & Training 229.02 100.00 129.02 310.42 300.00 10.42 3,850.00 3,539.58 91.9%6319822 Uniforms 613.72 920.00 (306.28) 1,370.36 1,840.00 (469.64) 11,040.00 9,669.64 87.6%Total-CM-OTHER EXPENSES 2,058.19 2,444.00 (385.81) 3,932.88 5,038.00 (1,105.12) 40,098.00 36,165.12 90.2%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementAugust 2011Annual Budget4 August 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) 3,230.66 5,296.00 (2,065.34) 31,776.00 28,545.34 89.8%6321325 Insurance-Workers Comp 368.90 531.00 (162.10) 737.80 1,062.00 (324.20) 6,543.00 5,805.20 88.7%6321800 Taxes-Employer Payroll 1,098.28 1,475.00 (376.72) 1,697.44 2,950.00 (1,252.56) 18,416.00 16,718.56 90.8%6321880 Wages-Hourly 13,379.75 12,880.00 499.75 23,438.25 25,760.00 (2,321.75) 154,560.00 131,121.75 84.8%6321882 Wages-Overtime 56.44 - 56.44 64.32 - 64.32 6,279.00 6,214.68 99.0%Total-CM-LM-SALARIES & BENEFITS16,518.70 17,534.00 (1,015.30) 29,168.47 35,068.00 (5,899.53) 217,574.00 188,405.53 86.6%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 132.77 290.00 (157.23) 282.25 580.00 (297.75) 3,480.00 3,197.75 91.9%Total-CM-LM-SUPPLIES & MATERIALS132.77 390.00 (257.23) 282.25 780.00 (497.75) 4,505.00 4,222.75 93.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%129,566.33 130,041.00 (474.67) 244,732.34 254,432.00 (9,699.66) 1,638,879.00 1,394,146.66 85.1% August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 17,000.00 23,320.00 (6,320.00) 37,997.77 44,385.00 (6,387.23) 227,391.00 189,393.23 83.3%6337842 Utilities-Water6,615.67 6,200.00 415.67 12,684.78 11,160.00 1,524.78 43,058.00 30,373.22 70.5%23,615.67 29,520.00 (5,904.33) 50,682.55 55,545.00 (4,862.45) 270,449.00 219,766.45 81.3%Silverrock ResortCourse Maintenance Expense StatementAugust 2011Annual BudgetMonth to Date Year to DateSilverrock ResortCourse Maintenance Water & EnergyAugust 2011Total-COURSE MAINTENANCETotal-CM-WATER & ENERGYMonth to Date Year to Date Annual Budget5 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group 446.57 662.00 (215.43) 893.14 1,324.00 (430.86) 7,944.00 7,050.86 88.8%6411325 Insurance-Workers Comp 392.19 288.00 104.19 784.38 604.00 180.38 5,096.00 4,311.62 84.6%6411800 Taxes-Employer Payroll 770.71 870.00 (99.29) 1,677.26 1,826.00 (148.74) 15,399.00 13,721.74 89.1%6411880 Wages-Hourly 7,499.19 6,985.00 514.19 15,368.57 14,667.00 701.57 123,689.00 108,320.43 87.6%6411882 Wages-Overtime 103.32 - 103.32 249.77 - 249.77 - (249.77) 0.0%Total-CBR-SALARIES & BENEFITS9,211.98 8,805.00 406.98 18,973.12 18,421.00 552.12 152,128.00 133,154.88 87.5%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 107.75 - 107.75 107.75 - 107.75 2,350.00 2,242.25 95.4%6413742 Supplies-Expendable 603.64 600.00 3.64 1,508.95 1,200.00 308.95 6,750.00 5,241.05 77.6%6413752 Supplies-Range Balls - - - - - - 9,000.00 9,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 240.00 72.00 168.00 640.00 144.00 496.00 1,005.00 365.00 36.3%6413796 Supplies-Bottled Water317.38 50.00 267.38 427.38 100.00 327.38 24,500.00 24,072.62 98.3%Total-CBR-SUPPLIES & MATERIALS1,268.77 747.00 521.77 2,684.08 1,494.00 1,190.08 44,550.00 41,865.92 94.0%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment 157.32 300.00 (142.68) 680.32 600.00 80.32 3,600.00 2,919.68 81.1%6415695 CBR-R&M-Cart Maintenance & Repair - 750.00 (750.00) 489.91 1,500.00 (1,010.09) 9,750.00 9,260.09 95.0%Total-CBR-REPAIRS & MAINTENANCE 157.32 1,050.00 (892.68) 1,170.23 2,100.00 (929.77) 13,350.00 12,179.77 91.2%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 698.30 800.00 (101.70) 2,143.85 1,600.00 543.85 9,600.00 7,456.15 77.7%6419220 Freight/Delivery - 75.00 (75.00) - 150.00 (150.00) 450.00 450.00 100.0%6419490 Miscellaneous 72.37 75.00 (2.63) 310.67 200.00 110.67 1,150.00 839.33 73.0%6419820 Uniforms - - - - - - 5,200.00 5,200.00 100.0%Total-CBR-OTHER EXPENSES 770.67 950.00 (179.33) 2,454.52 1,950.00 504.52 16,400.00 13,945.48 85.0%TOTAL-CARTS,BAGROOM & RANGE 11,408.74 11,552.00 (143.26) 25,281.95 23,965.00 1,316.95 226,428.00 201,146.05 88.8%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 258.70 67.00 191.70 517.40 141.00 376.40 1,805.00 1,287.60 71.3%6431800 Taxes-Employer Payroll 432.19 187.00 245.19 829.61 393.00 436.61 5,015.00 4,185.39 83.5%6431880 Wages-Hourly 2,907.20 1,632.00 1,275.20 5,634.00 3,432.00 2,202.00 43,800.00 38,166.00 87.1%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS3,598.09 1,886.00 1,712.09 6,981.01 3,966.00 3,015.01 50,620.00 43,638.99 86.2%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 3,598.09 2,061.00 1,537.09 6,981.01 4,316.00 2,665.01 54,595.00 47,613.99 87.2%15,006.83 13,613.00 1,393.83 32,262.96 28,281.00 3,981.96 281,023.00 244,785.04 87.1%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementAugust 2011Annual Budget6 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable29.95 400.00 (370.05) 59.90 800.00 (740.10) 4,800.00 4,740.10 98.8%Total-CH-SUPPLIES & MATERIALS 29.95 400.00 (370.05) 59.90 800.00 (740.10) 4,800.00 4,740.10 98.8%65-CH-UTILITIES6507836 Utilities-Natural Gas295.22 300.00 (4.78) 635.73 600.00 35.73 3,600.00 2,964.27 82.3%6507840 Utilities-Telephone1,043.13 1,150.00 (106.87) 2,166.85 2,300.00 (133.15) 13,800.00 11,633.15 84.3%6507842 Utilities-Water433.57 321.00 112.57 921.66 642.00 279.66 3,852.00 2,930.34 76.1%6507844 Utilities-Cable336.89 340.00 (3.11) 673.78 680.00 (6.22) 4,080.00 3,406.22 83.5%Total-CH-UTILITIES 2,108.81 2,111.00 (2.19) 4,398.02 4,222.00 176.02 25,332.00 20,933.98 82.6%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 3,650.00 3,650.00 - 22,500.00 18,850.00 83.8%6509099 Contract Services-Security4,565.04 4,900.00 (334.96) 9,406.60 9,800.00 (393.40) 60,400.00 50,993.40 84.4%6509215 Flowers & Decorations- - - - - - 2,400.00 2,400.00 100.0%6509490 Miscellaneous181.86 200.00 (18.14) 602.86 400.00 202.86 2,400.00 1,797.14 74.9%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,571.90 7,025.00 (453.10) 13,659.46 14,050.00 (390.54) 88,900.00 75,240.54 84.6%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures296.00 300.00 (4.00) 1,340.21 600.00 740.21 3,600.00 2,259.79 62.8%6515686 CH-R&M-Restaurant Repairs150.00 400.00 (250.00) 215.00 800.00 (585.00) 4,800.00 4,585.00 95.5%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 57.24 800.00 (742.76) 4,800.00 4,742.76 98.8%Total-CH-REPAIRS & MAINTENANCE 446.00 1,100.00 (654.00) 1,612.45 2,200.00 (587.55) 13,200.00 11,587.55 87.8%9,156.66 10,636.00 (1,479.34) 19,729.83 21,272.00 (1,542.17) 132,232.00 23,175.10 17.5%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementAugust 2011Annual Budget7 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 264.78 331.00 (66.22) 416.04 662.00 (245.96) 3,972.00 3,555.96 89.5%6601325 Insurance-Workers Comp 174.88 103.00 71.88 349.76 206.00 143.76 1,240.00 890.24 71.8%6601720 Salaries 2,349.30 2,508.00 (158.70) 4,675.00 5,016.00 (341.00) 30,096.00 25,421.00 84.5%6601800 Taxes-Employer Payroll 218.80 287.00 (68.20) 435.19 574.00 (138.81) 3,446.00 3,010.81 87.4%Total-MKT-SALARIES & BENEFITS 3,007.76 3,229.00 (221.24) 5,875.99 6,458.00 (582.01) 38,754.00 32,878.01 84.8%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 - - - - - - 4,425.00 4,425.00 100.0%- 100.00 (100.00) - 200.00 (200.00) 5,625.00 5,625.00 100.0%66-MKT-UTILITIES6607840 Utilities-Telephone 47.54 100.00 (52.46) 95.28 200.00 (104.72) 1,200.00 1,104.72 92.1%Total-MKT-UTILITIES 47.54 100.00 (52.46) 95.28 200.00 (104.72) 1,200.00 1,104.72 92.1%66-MKT-OTHER EXPENSES6609010 Advertising 8,123.62 10,562.00 (2,438.38) 16,943.11 18,734.00 (1,790.89) 185,731.00 168,787.89 90.9%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 99.00 400.00 (301.00) 198.00 800.00 (602.00) 4,800.00 4,602.00 95.9%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 - - - - - - 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 - - - - - - 735.00 735.00 100.0%6609820 Uniforms - - - - - - 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 8,222.62 11,112.00 (2,889.38) 17,141.11 19,834.00 (2,692.89) 209,241.00 191,399.89 91.5%11,277.92 14,541.00 (3,263.08) 23,112.38 26,692.00 (3,579.62) 254,820.00 231,007.62 90.7%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementAugust 2011Annual Budget8 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group2,850.25 1,458.00 1,392.25 5,700.50 2,916.00 2,784.50 17,496.00 11,795.50 67.4%6701325 Insurance-Workers Comp588.76 707.00 (118.24) 1,177.52 1,414.00 (236.48) 8,480.00 7,302.48 86.1%6701720 Salaries 14,699.51 14,833.34 (133.83) 29,010.19 29,666.68 (656.49) 178,000.00 148,989.81 83.7%6701800 Taxes-Employer Payroll 1,337.27 1,964.00 (626.73) 2,618.93 3,928.00 (1,309.07) 23,568.00 20,949.07 88.9%6701880 Wages-Hourly1,446.88 2,319.66 (872.78) 3,867.83 4,639.32 (771.49) 27,835.00 23,967.17 86.1%6701882 Wages-Overtime 10.88 - 10.88 10.88 - 10.88 - (10.88) 0.0%Total-G&A-SALARIES & BENEFITS 20,933.55 21,282.00 (348.45) 42,385.85 42,564.00 (178.15) 255,379.00 212,993.15 83.4%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 400.00 (400.00) - 800.00 (800.00) 5,200.00 5,200.00 100.0%6703762 Supplies-Office - 100.00 (100.00) 71.62 200.00 (128.38) 1,200.00 1,128.38 94.0%6703768 Supplies-Printing & Stationery- 100.00 (100.00) - 200.00 (200.00) 3,300.00 3,300.00 100.0%Total-G&A-SUPPLIES & MATERIALS - 600.00 (600.00) 71.62 1,200.00 (1,128.38) 9,700.00 9,628.38 99.3%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- - - 150.00 50.00 100.00 1,700.00 1,550.00 91.2%6709180 Employee Recruiting/Relocation28.00 - 28.00 84.00 - 84.00 1,400.00 1,316.00 94.0%6709197 Equipment Rental652.74 480.00 172.74 1,160.26 960.00 200.26 5,760.00 4,599.74 79.9%6709202 Fees-Bank61.62 90.00 (28.38) 203.61 180.00 23.61 1,080.00 876.39 81.1%6709208 Fees-Payroll Processing1,424.23 1,100.00 324.23 2,624.48 2,200.00 424.48 13,200.00 10,575.52 80.1%6709220 Freight/Delivery- 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0%6709490 Miscellaneous 365.14 100.00 265.14 365.14 200.00 165.14 1,200.00 834.86 69.6%6709620 Postage/Mail Services 110.99 75.00 35.99 208.99 150.00 58.99 900.00 691.01 76.8%6709625 Professional Fees1,232.95 850.00 382.95 1,672.20 1,700.00 (27.80) 10,200.00 8,527.80 83.6%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 224.38 100.00 124.38 224.38 100.00 124.38 1,100.00 875.62 79.6%6709820 Uniforms - 75.00 (75.00) - 150.00 (150.00) 1,050.00 1,050.00 100.0%Total-G&A-OTHER EXPENSES 4,500.05 3,620.00 880.05 7,493.06 7,190.00 303.06 48,490.00 40,996.94 84.5%25,433.60 25,602.00 (168.40) 49,950.53 51,054.00 (1,103.47) 314,669.00 264,718.47 84.1%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementAugust 2011Annual Budget9 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,091.63 12,075.00 (983.37) 22,183.26 24,150.00 (1,966.74) 144,900.00 122,716.74 84.7%6800194 Equipment Leases-Trailer 502.54 600.00 (97.46) 1,033.54 1,200.00 (166.46) 7,200.00 6,166.46 85.6%6800196 Equipment Leases-GPS 5,290.50 5,755.00 (464.50) 10,581.00 11,510.00 (929.00) 69,060.00 58,479.00 84.7%6800197 Equipment Leases-Others 3,343.62 1,160.00 2,183.62 6,477.08 2,320.00 4,157.08 13,920.00 7,442.92 0.0%20,228.29 19,590.00 638.29 40,274.88 39,180.00 1,094.88 235,080.00 194,805.12 82.9%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 21,759.86 23,543.00 (1,783.14) 37,936.48 44,764.00 (6,827.52) 90,000.00 52,063.52 57.8%6900210 FF&E Reserve 1,385.05 1,608.00 (222.95) 3,335.74 3,419.00 (83.26) 66,540.00 63,204.26 95.0%6900800 Personal Property Taxes 1,246.54 - 1,246.54 7,030.67 5,200.00 1,830.67 14,800.00 7,769.33 52.5%6900323 Insurance-Commercial 337.10 2,200.00 (1,862.90) 2,932.20 4,400.00 (1,467.80) 26,400.00 23,467.80 88.9%24,728.55 27,351.00 (2,622.45) 51,235.09 57,783.00 (6,547.91) 197,740.00 146,504.91 74.1%Silverrock ResortOperating Leases & Miscellaneous Other Expense StatementAugust 2011Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSES10 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2011-20122011 2011 2011 2011 2011 2011Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia51SalesPromotionGolf Industry6VIPCelebrityPGA Comp64 60Charity/Gift Certificate21Rain/Wind Checks32Club Staff65 62LQ HS Golf2414113600002012 2012 2012 2012 2012 2012Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2011-2012August 2011 Date Time Description CategoryPlayers8/15/2011 11:00 Kris Long Media 112