Loading...
02 August 2012 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2012 – August 2012 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 Revenue72,014.43 78,609.00 (6,594.57) -8.4% 164,492.95 172,762.00 (8,269.05) 3,350,773.00 3,186,280.05 5%401000 Miscellaneous Golf Revenue 2,802.00 4,720.00 (1,918.00) -40.6% 7,843.90 11,280.00 (3,436.10) 159,973.00 152,129.10 5%410000 Revenue-Golf Shop 6,833.12 7,151.00 (317.88) -4.4% 15,731.91 15,991.00 (259.09) 311,048.00 295,316.09 5%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 Income0.40 - 0.40 0.0% 1.05 - 1.05 - (1.05) 0%Total Income82,149.95 90,980.00 (8,830.05) -9.7% 189,069.81 201,033.00 (11,963.19) 3,833,794.00 3,644,724.19 5%Cost of Goods Sold510000 COS-Golf Shop 3,612.06 3,795.05 (182.99) 4.8% 8,343.37 8,487.05 143.68 165,088.40 156,745.03 5%Total COS3,612.06 3,795.05 (182.99) 4.8% 8,343.37 8,487.05 143.68 165,088.40 156,745.03 5%Gross Profit78,537.89 87,184.95 (8,647.06) -9.9% 180,726.44 192,545.95 (11,819.51) 3,668,705.60 3,487,979.16 5%Expenses610000 Golf Pro Shop 16,690.14 15,785.00 (905.14) -5.7% 32,060.10 32,670.00 609.90 212,986.00 180,925.90 15%630000 Course Maintenance140,944.09 132,086.00 (8,858.09) -6.7% 261,749.03 258,322.00 (3,427.03) 1,664,207.00 1,402,457.97 16%633000 Maintenance Water & Energy22,413.31 20,020.00 (2,393.31) -12.0% 48,415.45 37,645.00 (10,770.45) 221,749.00 173,333.55 22%640000 Outside Services17,062.08 15,496.00 (1,566.08) -10.1% 33,977.06 31,235.00 (2,742.06) 292,671.00 258,693.94 12%650000 Clubhouse 13,529.46 10,636.00 (2,893.46) -27.2% 22,412.56 21,272.00 (1,140.56) 132,232.00 109,819.44 17%660000 Marketing 13,115.41 13,414.00 298.59 2.2% 24,334.68 25,438.00 1,103.32 245,611.00 221,276.32 10%670000 General & Administrative23,969.24 25,411.00 1,441.76 5.7% 44,658.27 50,672.00 6,013.73 312,385.00 267,726.73 14%680000 Leases 17,687.67 18,890.00 1,202.33 6.4% 36,243.96 37,780.00 1,536.04 226,680.00 190,436.04 16%690000 Miscellaneous Other Expense28,628.60 27,315.00 (1,313.60) -4.8% 57,114.25 57,819.00 704.75 198,215.00 141,100.75 29%Total Expenses294,040.00 279,053.00 (14,987.00) -5.4% 560,965.36 552,853.00 (8,112.36) 3,506,736.00 2,945,770.64 16%(215,502.11) (191,868.05) (23,634.06) -12.3%(380,238.92) (360,307.05) (19,931.87) 161,969.60 542,208.52 -235%Rounds of Golf PlayedPaid Rounds Played 2,199 2,200 (1) 0.0% 4,851 4,800 51 45,625 40,774 11%Ave $ Per Paid Round Green Fee32.75 35.73 (2.98) -8.3% 33.91 35.99 (2.08) 73.44 39.53 46%Ave $ Per Paid Round Merchandise3.11 3.25 (0.14) -4.4% 3.24 3.33 (0.09) 6.82 3.57 48%Ave $ Per Paid Miscellaneous 1.27 2.15 (0.87) -40.6% 1.62 2.35 (0.73) 3.51 1.89 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateAugust 20121 Income August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 72,014.43 78,609.00 (6,594.57) 164,492.95 172,762.00 (8,269.05) 3,350,773.003,186,280.055%4010000 Rider Fee 450.00 220.00 230.00 1,050.00 480.00 570.00 7,643.006,593.0014%4040000 Club Rental 695.00 1,100.00 (405.00) 1,780.00 2,400.00 (620.00) 23,325.0021,545.008%4050000 Driving Range 1,657.00 3,300.00 (1,643.00) 3,844.00 7,200.00 (3,356.00) 85,405.0081,561.005%4060000 Handicap Fees - - - - - - 0.000.000%4080000 GPS Advertising - 100.00 (100.00) - 200.00 (200.00) 2,600.00 2,600.000%4090000 Ball Retriever/Subcontract - - - 1,169.90 1,000.00 169.90 4,000.00 2,830.1029%4091000 Golf Professional Rental Fee - - - - - - 37,000.00 37,000.00 0%4092000 Golf Lessons - - - - - - - - 0% Total Revenue Fees 74,816.43 83,329.00 (8,512.57) 172,336.85 184,042.00 (11,705.15) 3,510,746.00 3,338,409.15 5%74,816.43 83,329.00 (8,512.57) 172,336.85 184,042.00 (11,705.15) 3,510,746.00 3,338,409.15 5%SilverRock ResortStatement of Fees RevenueAugust 2012Total IncomeMonth to Date Year to Date Annual Budget2 Income August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 117.91 - 117.91 250.77 - 250.77 0 0 0%4100110 Sales Hard Goods 3,914.21 2,503.00 1,411.21 8,511.44 5,597.00 2,914.44 108,867.00 100,355.56 8%4100112 Sales-Soft Goods 4,386.50 4,648.00 (261.50) 9,656.50 10,394.00 (737.50) 202,181.00 192,524.50 5%5100639 GS-Discounts-Mdse (1,585.50) - (1,585.50) (2,686.80) - (2,686.80) - 2,686.80 0% Total Revenue Golf Shop 6,833.12 7,151.00 (317.88) 15,731.91 15,991.00 (259.09) 311,048.00 295,566.86 5%COS 5100150 COS-GS-Hard Goods 1,679.33 1,376.65 302.68 4,587.18 3,078.35 1,508.83 59,876.85 55,289.67 8%5100151 COS-GS-Soft Goods 1,852.65 2,556.40 (703.75) 3,494.93 5,716.70 (2,221.77) 111,199.55 107,704.62 3%5100152 COS-GS-Purchase Disc (17.90) (197.00) 179.10 (17.90) (440.00) 422.10 (8,554.00) (8,536.10) 0%5100220 COS-GS-Freight Merch 97.98 59.00 38.98 279.16 132.00 147.16 2,566.00 2,286.84 11%Cost of Sales - Golf Shop 3,612.06 3,795.05 (182.99) 8,343.37 8,487.05 (143.68) 165,088.40 156,745.03 5%Gross Profit 3,221.06 3,355.95 (134.89) 7,388.54 7,503.95 (115.41) 145,959.60 138,821.83 5%COS % 52.9% 53.1% 0.2% 53.0% 53.1% 0.0% 53.1% 53.0% 0%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 2,402.29 1,986.00 416.29 4,804.58 3,972.00 832.58 26,811.00 22,006.42 18%6101325 Insurance-Workers Comp 501.70 436.00 65.70 867.01 872.00 (4.99) 5,663.00 4,795.99 15%6101720 Salaries 4,254.53 3,750.00 504.53 7,799.97 7,500.00 299.97 45,000.00 37,200.03 17%6101800 Taxes-Employer Payroll 972.29 1,136.00 (163.71) 1,715.71 2,272.00 (556.29) 14,758.00 13,042.29 12%6101880 Wages-Hourly 7,265.48 7,117.00 148.48 12,871.13 14,234.00 (1,362.87) 96,229.00 83,357.87 13%6101882 Wages-Overtime 274.42 - 274.42 389.93 - 389.93 - 952.88 0%Total -PS-SALARIES & BENEFITS 15,670.71 14,425.00 1,245.71 28,448.33 28,850.00 (401.67) 188,461.00 161,355.48 14%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 137.06 500.00 (362.94) 137.06 1,000.00 (862.94) 6,000.00 5,862.94 2%6109090 Contract Services 500.00 500.00 - 1,000.00 1,000.00 - 6,000.00 5,000.00 17%6109220 Freight & Delivery 77.35 - 77.35 77.35 - 77.35 75.00 (2.35) 103%6109490 Miscellaneous 29.03 - 29.03 777.78 - 777.78 450.00 (327.78) 173%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short 11.31 - 11.31 (1.65) - (1.65) - 1.65 0%6109722 Seminars/Training - 150.00 (150.00) 1,250.00 1,400.00 (150.00) 5,890.00 4,640.00 21%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms 153.93 100.00 53.93 153.93 200.00 (46.07) 2,400.00 2,246.07 6%6117840 Telephones 110.75 110.00 0.75 217.30 220.00 (2.70) 1,320.00 1,102.70 0%Total PS-OTHER EXPENSES 1,019.43 1,360.00 (340.57) 3,611.77 3,820.00 (208.23) 24,525.00 20,913.23 15%16,690.14 15,785.00 905.14 32,060.10 32,670.00 (609.90) 212,986.00 182,268.71 14%Net Income(13,469.08) (12,429.05) (1,040.03) (24,671.56) (25,166.05) 494.49 (67,026.40) (43,446.88) -35%SilverRock ResortGolf Shop Income StatementAugust 2012Total 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 9,111.48 8,740.00 371.48 18,222.96 17,480.00 742.96 104,880.00 86,657.04 82.6%6311325 Insurance-Workers Comp 1,937.02 2,208.00 (270.98) 3,347.45 4,416.00 (1,068.55) 27,280.00 23,932.55 87.7%6311720 Salaries 13,201.92 11,001.60 2,200.32 24,203.52 22,003.20 2,200.32 150,996.00 126,792.48 84.0%6311800 Taxes-Employer Payroll 4,033.77 5,753.00 (1,719.23) 8,425.08 11,506.00 (3,080.92) 71,645.00 63,219.92 88.2%6311880 Wages-Hourly 44,664.72 44,054.40 610.32 90,000.04 88,108.80 1,891.24 518,654.00 428,653.96 82.6%6311882 Wages-Overtime 119.81 - 119.81 254.49 - 254.49 15,945.00 15,690.51 98.4%Total-CM-SALARIES & BENEFITS73,068.72 71,757.00 1,311.72 144,453.54 143,514.00 939.54 889,400.00 744,946.46 83.8%63-CM-SUPPLIES & MATERIALS6313734 Chemicals - - - 917.67 - 917.67 31,100.00 30,182.33 97.0%6313744 Fertilizer 19,045.77 18,500.00 545.77 30,660.43 30,500.00 160.43 114,500.00 83,839.57 73.2%6313745 Herbicides - - - 622.02 - 622.02 17,000.00 16,377.98 96.3%6313746 Flowers/Plants - - - - - - 3,050.00 3,050.00 100.0%6313748 Fuel-Gasoline 5,694.10 5,200.00 494.10 9,789.28 10,400.00 (610.72) 55,020.00 45,230.72 82.2%6313750 Golf Course Accessories - 200.00 (200.00) 79.18 400.00 (320.82) 13,000.00 12,920.82 99.4%6313756 POA Control - - - 230.45 - 230.45 7,000.00 6,769.55 96.7%6313758 Miscellaneous Supp 811.07 750.00 61.07 2,101.91 1,500.00 601.91 4,350.00 2,248.09 0.0%6313762 Supplies-Office 21.54 - 21.54 101.31 - 101.31 - (101.31) 0.0%6313774 Sand - 390.00 (390.00) - 780.00 (780.00) 16,460.00 16,460.00 100.0%6313776 Seed 1,224.91 350.00 874.91 1,224.91 700.00 524.91 106,810.00 105,585.09 98.9%6313778 Small Tools & Non-Capital Equip - 100.00 (100.00) - 200.00 (200.00) 5,000.00 5,000.00 100.0%6313780 Sod 4,292.96 1,000.00 3,292.96 4,675.48 2,000.00 2,675.48 7,950.00 3,274.52 41.2%6313782 Topdressing 1,536.29 1,250.00 286.29 1,536.29 2,500.00 (963.71) 7,600.00 6,063.71 79.8%Total-CM-SUPPLIES & MATERIALS32,626.64 27,740.00 4,886.64 51,938.93 48,980.00 2,958.93 388,840.00 336,901.07 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 136.34 750.00 (613.66) 313.52 2,000.00 (1,686.48) 5,550.00 5,236.48 94.4%6315690 CM-R&M-Equipment 3,956.28 1,500.00 2,456.28 5,934.19 3,000.00 2,934.19 31,000.00 25,065.81 80.9%6315692 CM-R&M-Irrigation System 4,815.24 5,400.00 (584.76) 6,220.16 10,800.00 (4,579.84) 22,650.00 16,429.84 72.5%6315696 CM-R&M-Pumps 1,837.83 1,000.00 837.83 3,787.00 2,000.00 1,787.00 10,500.00 6,713.00 63.9%6315815 CM-R&M-Trees-Pruning Etc - - - - - - 10,050.00 10,050.00 100.0%Total-CM-REPAIRS & MAINTENANCE 13,575.69 11,250.00 2,325.69 21,914.87 23,000.00 (1,085.13) 110,950.00 89,035.13 80.2%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 20.56 15.00 5.56 44.27 30.00 14.27 180.00 135.73 0.0%6317840 Telephones 1,189.87 850.00 339.87 2,412.98 1,700.00 712.98 10,200.00 7,787.02 76.3%Total-CM-UTILITIES 1,210.43 865.00 345.43 2,457.25 1,730.00 727.25 10,380.00 7,922.75 76.3%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 912.70 524.00 388.70 912.70 1,048.00 (135.30) 6,288.00 5,375.30 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 - 100.00 (100.00) 519.55 200.00 319.55 1,200.00 680.45 56.7%6319718 Safety Equipment & Training 167.13 100.00 67.13 638.72 300.00 338.72 3,850.00 3,211.28 83.4%6319822 Uniforms 992.30 920.00 72.30 2,262.42 1,840.00 422.42 11,040.00 8,777.58 79.5%Total-CM-OTHER EXPENSES 2,572.13 2,444.00 128.13 5,333.39 5,038.00 295.39 40,098.00 34,764.61 86.7%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementAugust 2012Annual Budget4 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,958.24 2,648.00 310.24 5,916.48 5,296.00 620.48 31,776.00 25,859.52 81.4%6321325 Insurance-Workers Comp 640.93 516.00 124.93 1,107.62 1,032.00 75.62 6,361.00 5,253.38 82.6%6321800 Taxes-Employer Payroll 1,161.94 1,346.00 (184.06) 2,436.83 2,692.00 (255.17) 16,808.00 14,371.17 85.5%6321880 Wages-Hourly 12,931.20 12,880.00 51.20 25,742.70 25,760.00 (17.30) 154,560.00 128,817.30 83.3%6321882 Wages-Overtime - - - 10.50 - 10.50 6,279.00 6,268.50 99.8%Total-CM-LM-SALARIES & BENEFITS17,692.31 17,390.00 302.31 35,214.13 34,780.00 434.13 215,784.00 180,569.87 83.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 198.17 290.00 (91.83) 436.92 580.00 (143.08) 3,480.00 3,043.08 87.4%Total-CM-LM-SUPPLIES & MATERIALS198.17 390.00 (191.83) 436.92 780.00 (343.08) 4,505.00 4,068.08 90.3%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%140,944.09 132,086.00 8,858.09 261,749.03 258,322.00 3,427.03 1,664,207.00 1,402,457.97 84.3% August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 15,097.98 13,820.00 1,277.98 34,067.33 26,485.00 7,582.33 178,691.00 144,623.67 80.9%6337842 Utilities-Water7,315.33 6,200.00 1,115.33 14,348.12 11,160.00 3,188.12 43,058.00 28,709.88 66.7%22,413.31 20,020.00 2,393.31 48,415.45 37,645.00 10,770.45 221,749.00 173,333.55 78.2%Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetSilverrock ResortCourse Maintenance Water & EnergyAugust 2012Total-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementAugust 2012Annual BudgetMonth to Date Year to Date5 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group 369.78 662.00 (292.22) 739.56 1,324.00 (584.44) 7,944.00 7,204.44 90.7%6411325 Insurance-Workers Comp 401.15 301.00 100.15 693.25 609.00 84.25 5,135.00 4,441.75 86.5%6411800 Taxes-Employer Payroll 1,018.47 936.00 82.47 1,927.54 1,892.00 35.54 15,942.00 14,014.46 87.9%6411880 Wages-Hourly 8,543.21 7,516.00 1,027.21 16,320.95 15,198.00 1,122.95 128,052.00 111,731.05 87.3%6411882 Wages-Overtime 36.01 - 36.01 49.32 - 49.32 - (49.32) 0.0%Total-CBR-SALARIES & BENEFITS10,368.62 9,415.00 953.62 19,730.62 19,023.00 707.62 157,073.00 137,342.38 87.4%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - - - 134.69 - 134.69 2,350.00 2,215.31 94.3%6413742 Supplies-Expendable 1,301.63 600.00 701.63 2,602.74 1,200.00 1,402.74 6,750.00 4,147.26 61.4%6413748 Supplies-Fuel for Shuttle - - - - - - 3,000.00 3,000.00 100.0%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 400.00 72.00 328.00 720.00 144.00 576.00 1,005.00 285.00 28.4%6413796 Supplies-Bottled Water104.27 50.00 54.27 478.37 100.00 378.37 24,500.00 24,021.63 98.0%Total-CBR-SUPPLIES & MATERIALS1,805.90 747.00 1,058.90 3,935.80 1,494.00 2,441.80 47,550.00 43,614.20 91.7%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment - 300.00 (300.00) - 600.00 (600.00) 3,600.00 3,600.00 100.0%6415695 CBR-R&M-Cart Maintenance & Repair - 750.00 (750.00) 1,494.02 1,500.00 (5.98) 9,750.00 8,255.98 84.7%Total-CBR-REPAIRS & MAINTENANCE - 1,050.00 (1,050.00) 1,494.02 2,100.00 (605.98) 13,350.00 11,855.98 88.8%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 1,202.41 800.00 402.41 2,073.54 1,600.00 473.54 9,600.00 7,526.46 78.4%6419220 Freight/Delivery - 75.00 (75.00) - 150.00 (150.00) 450.00 450.00 100.0%6419490 Miscellaneous - 75.00 (75.00) - 200.00 (200.00) 1,150.00 1,150.00 100.0%6419820 Uniforms - - - 287.81 - 287.81 5,200.00 4,912.19 94.5%Total-CBR-OTHER EXPENSES 1,202.41 950.00 252.41 2,361.35 1,950.00 411.35 16,400.00 14,038.65 85.6%TOTAL-CARTS,BAGROOM & RANGE 13,376.93 12,162.00 1,214.93 27,521.79 24,567.00 2,954.79 234,373.00 206,851.21 88.3%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 358.70 111.00 247.70 619.89 222.00 397.89 1,903.00 1,283.11 67.4%6431800 Taxes-Employer Payroll 355.25 288.00 67.25 607.47 576.00 31.47 4,960.00 4,352.53 87.8%6431880 Wages-Hourly 2,971.20 2,760.00 211.20 5,035.20 5,520.00 (484.80) 47,460.00 42,424.80 89.4%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS3,685.15 3,159.00 526.15 6,262.56 6,318.00 (55.44) 54,323.00 48,060.44 88.5%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 50.00 (50.00) - 100.00 (100.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous - - - 192.71 - 192.71 200.00 7.29 3.6%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) 192.71 350.00 (157.29) 3,975.00 3,782.29 95.2%Total-COURSE SERVICES 3,685.15 3,334.00 351.15 6,455.27 6,668.00 (212.73) 58,298.00 51,842.73 88.9%17,062.08 15,496.00 1,566.08 33,977.06 31,235.00 2,742.06 292,671.00 254,911.65 87.1%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementAugust 2012Annual Budget6 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable864.00 400.00 464.00 864.00 800.00 64.00 4,800.00 3,936.00 82.0%Total-CH-SUPPLIES & MATERIALS 864.00 400.00 464.00 864.00 800.00 64.00 4,800.00 3,936.00 82.0%65-CH-UTILITIES6507836 Utilities-Natural Gas- 300.00 (300.00) - 600.00 (600.00) 3,600.00 3,600.00 100.0%6507840 Utilities-Telephone1,215.05 1,150.00 65.05 2,451.37 2,300.00 151.37 13,800.00 11,348.63 82.2%6507842 Utilities-Water376.36 321.00 55.36 832.77 642.00 190.77 3,852.00 3,019.23 78.4%6507844 Utilities-Cable336.91 340.00 (3.09) 673.82 680.00 (6.18) 4,080.00 3,406.18 83.5%Total-CH-UTILITIES 1,928.32 2,111.00 (182.68) 3,957.96 4,222.00 (264.04) 25,332.00 21,374.04 84.4%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-Security6,957.56 4,900.00 2,057.56 11,586.44 9,800.00 1,786.44 60,400.00 48,813.56 80.8%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 8,782.56 7,025.00 1,757.56 15,236.44 14,050.00 1,186.44 88,900.00 73,663.56 82.9%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures304.58 300.00 4.58 609.16 600.00 9.16 3,600.00 2,990.84 83.1%6515686 CH-R&M-Restaurant Repairs1,650.00 400.00 1,250.00 1,745.00 800.00 945.00 4,800.00 3,055.00 63.6%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) - 800.00 (800.00) 4,800.00 4,800.00 100.0%Total-CH-REPAIRS & MAINTENANCE 1,954.58 1,100.00 854.58 2,354.16 2,200.00 154.16 13,200.00 10,845.84 82.2%13,529.46 10,636.00 2,893.46 22,412.56 21,272.00 1,140.56 132,232.00 21,691.68 16.4%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementAugust 2012Annual Budget7 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 369.78 331.00 38.78 739.56 662.00 77.56 3,972.00 3,232.44 81.4%6601325 Insurance-Workers Comp 180.55 101.00 79.55 312.02 202.00 110.02 1,207.00 894.98 74.1%6601720 Salaries 2,635.43 2,508.00 127.43 4,409.27 5,016.00 (606.73) 30,096.00 25,686.73 85.3%6601800 Taxes-Employer Payroll 259.60 262.00 (2.40) 437.96 524.00 (86.04) 3,145.00 2,707.04 86.1%Total-MKT-SALARIES & BENEFITS 3,445.36 3,202.00 243.36 5,898.81 6,404.00 (505.19) 38,420.00 32,521.19 84.6%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 376.79 - 376.79 670.28 - 670.28 4,425.00 3,754.72 84.9%376.79 100.00 276.79 670.28 200.00 470.28 5,625.00 4,954.72 88.1%66-MKT-UTILITIES6607840 Utilities-Telephone 105.42 100.00 5.42 211.04 200.00 11.04 1,200.00 988.96 82.4%Total-MKT-UTILITIES 105.42 100.00 5.42 211.04 200.00 11.04 1,200.00 988.96 82.4%66-MKT-OTHER EXPENSES6609010 Advertising 8,804.61 9,562.00 (757.39) 17,171.32 17,734.00 (562.68) 179,231.00 162,059.68 90.4%6609040 Business Meals - - - - - - 300.00 300.00 100.0%6609080 Collateral Material - - - - - - 9,000.00 9,000.00 100.0%6609102 Contract Services-Web Page - 300.00 (300.00) - 600.00 (600.00) 3,600.00 3,600.00 100.0%6609490 Miscellaneous - - - - - - 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0%6609630 Promotion 104.43 25.00 79.43 104.43 50.00 54.43 3,000.00 2,895.57 0.0%6609633 Promotion-Community 278.80 75.00 203.80 278.80 150.00 128.80 2,250.00 1,971.20 87.6%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 9,187.84 10,012.00 (824.16) 17,554.55 18,634.00 (1,079.45) 200,366.00 182,111.45 90.9%13,115.41 13,414.00 (298.59) 24,334.68 25,438.00 (1,103.32) 245,611.00 220,576.32 89.8%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementAugust 2012Annual Budget8 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,756.80 1,458.00 298.80 3,513.60 2,916.00 597.60 17,496.00 13,982.40 79.9%6701325 Insurance-Workers Comp602.40 688.00 (85.60) 1,041.03 1,376.00 (334.97) 8,254.00 7,212.97 87.4%6701720 Salaries 14,916.26 15,003.00 (86.74) 28,332.52 30,006.00 (1,673.48) 178,000.00 149,667.48 84.1%6701800 Taxes-Employer Payroll 1,329.90 1,792.00 (462.10) 2,447.81 3,584.00 (1,136.19) 21,510.00 19,062.19 88.6%6701880 Wages-Hourly1,284.97 2,150.00 (865.03) 2,476.61 4,300.00 (1,823.39) 27,835.00 25,358.39 91.1%6701882 Wages-Overtime - - - 5.44 - 5.44 - (5.44) 0.0%Total-G&A-SALARIES & BENEFITS 19,890.33 21,091.00 (1,200.67) 37,817.01 42,182.00 (4,364.99) 253,095.00 215,277.99 85.1%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 384.25 100.00 284.25 384.25 200.00 184.25 1,200.00 815.75 68.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 384.25 600.00 (215.75) 384.25 1,200.00 (815.75) 9,700.00 9,315.75 96.0%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- - - 165.00 50.00 115.00 1,700.00 1,535.00 90.3%6709180 Employee Recruiting/Relocation- - - 60.00 - 60.00 1,400.00 1,340.00 95.7%6709197 Equipment Rental558.31 480.00 78.31 1,136.68 960.00 176.68 5,760.00 4,623.32 80.3%6709202 Fees-Bank65.43 90.00 (24.57) 223.58 180.00 43.58 1,080.00 856.42 79.3%6709208 Fees-Payroll Processing1,109.90 1,100.00 9.90 2,237.63 2,200.00 37.63 13,200.00 10,962.37 83.0%6709220 Freight/Delivery- 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0%6709490 Miscellaneous 77.33 100.00 (22.67) 77.33 200.00 (122.67) 1,200.00 1,122.67 93.6%6709620 Postage/Mail Services 136.85 75.00 61.85 292.65 150.00 142.65 900.00 607.35 67.5%6709625 Professional Fees1,310.00 850.00 460.00 1,409.00 1,700.00 (291.00) 10,200.00 8,791.00 86.2%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) 18.30 150.00 (131.70) 1,050.00 1,031.70 98.3%Total-G&A-OTHER EXPENSES 3,657.82 3,620.00 37.82 6,420.17 7,190.00 (769.83) 48,490.00 42,069.83 86.8%23,932.40 25,411.00 (1,478.60) 44,621.43 50,672.00 (6,050.57) 312,385.00 267,763.57 85.7%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementAugust 2012Annual Budget9 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,988.25 12,075.00 (86.75) 23,976.50 24,150.00 (173.50) 144,900.00 120,923.50 83.5%6800194 Equipment Leases-Trailer 502.54 600.00 (97.46) 1,005.08 1,200.00 (194.92) 7,200.00 6,194.92 86.0%6800196 Equipment Leases-GPS 4,940.00 5,755.00 (815.00) 9,880.00 11,510.00 (1,630.00) 69,060.00 59,180.00 85.7%6800197 Equipment Leases-Others 256.88 460.00 (203.12) 1,382.38 920.00 462.38 5,520.00 4,137.62 0.0%17,687.67 18,890.00 (1,202.33) 36,243.96 37,780.00 (1,536.04) 226,680.00 190,436.04 84.0%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 26,805.46 23,543.00 3,262.46 45,172.49 44,764.00 408.49 90,000.00 44,827.51 49.8%6900210 FF&E Reserve 1,440.29 1,572.00 (131.71) 3,289.86 3,455.00 (165.14) 67,015.00 63,725.14 95.1%6900800 Personal Property Taxes 382.85 - 382.85 6,176.83 5,200.00 976.83 14,800.00 8,623.17 58.3%6900323 Insurance-Commercial - 2,200.00 (2,200.00) 2,475.07 4,400.00 (1,924.93) 26,400.00 23,924.93 90.6%28,628.60 27,315.00 1,313.60 57,114.25 57,819.00 (704.75) 198,215.00 141,100.75 71.2%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementAugust 201210 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2012-20132012 2012 2012 2012 2012 2012Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia34SalesPromotionGolf IndustryVIPCelebrityPGA Comp62 16Charity/Gift Certificate615Rain/Wind Checks5Club Staff129 60LQ HS Golf82139500002013 2013 2013 2013 2013 2013Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2012-2013August 2012 Date Time Description CategoryPlayers8/18/2012 11:07 Kris Long / John White Media 412