Loading...
04 October 2010 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2010 – October 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 October Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 21,336.00 23,905.00 (2,569.00) -10.7% 324,492.00 378,452.00 (53,960.00) 3,111,458.00 2,786,966.00 10%401000 Miscellaneous Golf Revenue 1,312.30 3,660.00 (2,347.70) -64.1% 14,556.30 24,691.00 (10,134.70) 117,656.00 103,099.70 12%410000 Revenue-Golf Shop 2,575.95 2,080.00 495.95 23.8% 32,590.63 37,186.00 (4,595.37) 306,492.00 273,901.37 11%420000 Revenue-F&B Concession 1,500.00 1,500.00 - 0.0% 3,000.00 3,000.00 - 12,000.00 9,000.00 25%890000 Interest Income 4.33 - 4.33 0.0% 20.90 - 20.90 - (20.90) 0%Total Income26,728.58 31,145.00 (4,416.42) -14.2% 374,659.83 443,329.00 (68,669.17) 3,547,606.00 3,172,946.17 11%Cost of Goods Sold510000 COS-Golf Shop 1,606.67 1,104.00 502.67 -45.5% 17,730.32 19,736.30 2,005.98 162,670.60 144,940.28 11%Total COS1,606.67 1,104.00 502.67 -45.5% 17,730.32 19,736.30 2,005.98 162,670.60 144,940.28 11%Gross Profit25,121.91 30,041.00 (4,919.09) -16.4% 356,929.51 423,592.70 (66,663.19) 3,384,935.40 3,028,005.89 11%Expenses610000 Golf Pro Shop 11,455.21 14,487.00 3,031.79 20.9% 55,219.78 66,039.00 10,819.22 230,213.00 174,993.22 24%630000 Course Maintenance 248,956.39 255,809.00 6,852.61 2.7% 622,549.23 638,075.00 15,525.77 1,541,961.00 919,411.77 40%633000 Maintenance Water & Energy 7,213.32 6,960.00 (253.32) -3.6% 34,700.27 36,580.00 1,879.73 85,358.00 50,657.73 41%640000 Outside Services 22,996.46 27,046.00 4,049.54 15.0% 70,730.18 80,984.00 10,253.82 297,478.00 226,747.82 24%650000 Clubhouse 14,175.29 11,736.00 (2,439.29) -20.8% 47,960.17 43,644.00 (4,316.17) 132,232.00 84,271.83 36%660000 Marketing 20,430.41 21,176.00 745.59 3.5% 72,892.74 79,689.00 6,796.26 262,644.00 189,751.26 28%670000 General & Administrative20,474.32 25,839.00 5,364.68 20.8% 92,376.56 102,831.00 10,454.44 314,808.00 222,431.44 29%680000 Leases 18,953.49 20,817.00 1,863.51 9.0% 74,691.45 83,268.00 8,576.55 247,740.00 173,048.55 30%690000 Miscellaneous Other Expense 28,576.65 21,730.00 (6,846.65) -31.5% 93,457.69 101,978.00 8,520.31 192,199.00 98,741.31 49%Total Expenses393,231.54 405,600.00 12,368.46 3.0% 1,164,578.07 1,233,088.00 68,509.93 3,304,633.00 2,140,054.93 35%(368,109.63) (375,559.00) 7,449.37 2.0%(807,648.56) (809,495.30) 1,846.74 80,302.40 887,950.96 -1006%Rounds of Golf PlayedPaid Rounds Played 386 400 (14) -3.5% 8,554 8,927 (373) 39,150 30,596 22%Ave $ Per Paid Round Green Fee 55.27 59.76 (4.49) -7.5% 37.93 42.39 (4.46) 76.13 38.20 50%Ave $ Per Paid Round Merchandise 6.67 5.20 1.47 28.3% 3.81 4.17 (0.36) 8.07 4.26 47%Ave $ Per Paid Miscellaneous 0.39 9.15 (8.76) -95.8% 1.70 2.77 (1.06) 2.06 - 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateOctober 20101 Income October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 21,336.00 23,905.00 (2,569.00) 324,492.00 378,452.00 (53,960.00) 3,111,458.002,786,966.0010%4010000 Rider Fee 175.00 40.00 135.00 2,675.00 3,207.00 (532.00) 6,522.003,847.0041%4040000 Club Rental 95.00 220.00 (125.00) 3,390.00 4,909.00 (1,519.00) 28,004.0024,614.0012%4050000 Driving Range 291.00 400.00 (109.00) 6,665.00 9,575.00 (2,910.00) 48,130.0041,465.0014%4080000 GPS Advertising - 2,000.00 (2,000.00) - 5,000.00 (5,000.00) 12,000.00 12,000.000%4090000 Ball Retriever/Subcontract 751.30 1,000.00 (248.70) 1,826.30 2,000.00 (173.70) 4,000.00 2,173.7046%4091000 Golf Professional Rental Fee - - - - - - 19,000.00 19,000.00 0%4092000 Golf Lessons - - - - - - - - 0% Total Revenue Fees 22,648.30 27,565.00 (4,916.70) 339,048.30 403,143.00 (64,094.70) 3,229,114.00 2,890,065.70 10%22,648.30 27,565.00 (4,916.70) 339,048.30 403,143.00 (64,094.70) 3,229,114.00 2,890,065.70 10%Total IncomeMonth to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueOctober 20102 Income October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 0.88 - 0.88 732.52 - 732.52 0 0 0%4100110 Sales Hard Goods 938.53 728.00 210.53 15,681.63 13,015.00 2,666.63 107,272.00 91,590.37 15%4100112 Sales-Soft Goods 2,405.00 1,352.00 1,053.00 21,605.42 24,171.00 (2,565.58) 199,220.00 177,614.58 11%5100639 GS-Discounts-Mdse (768.46) - (768.46) (5,428.94) - (5,428.94) - 5,428.94 0% Total Revenue Golf Shop 2,575.95 2,080.00 495.95 32,590.63 37,186.00 (4,595.37) 306,492.00 274,633.89 10%COS 5100150 COS-GS-Hard Goods 552.87 400.40 152.47 8,303.67 7,158.25 1,145.42 58,999.60 50,695.93 14%5100151 COS-GS-Soft Goods 1,509.44 743.60 765.84 9,871.47 13,294.05 (3,422.58) 109,571.00 99,699.53 9%5100152 COS-GS-Purchase Disc (455.64) (57.00) (398.64) (747.38) (1,022.00) 274.62 (8,429.00) (7,681.62) -9%5100220 COS-GS-Freight Merch - 17.00 (17.00) 302.56 306.00 (3.44) 2,529.00 2,226.44 12%Cost of Sales - Golf Shop 1,606.67 1,104.00 502.67 17,730.32 19,736.30 (2,005.98) 162,670.60 144,940.28 11%Gross Profit 969.28 976.00 (6.72) 14,860.31 17,449.70 (2,589.39) 143,821.40 129,693.61 10%COS % 62.4% 53.1% -9.3% 54.4% 53.1% -1.3% 53.1% 52.8% 1%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 480.00 480.00 - 1,620.00 1,620.00 - 5,400.00 3,780.00 30%6101320 Insurance Group 2,317.00 2,317.00 - 8,551.72 8,275.00 276.72 26,811.00 18,259.28 32%6101325 Insurance-Workers Comp 277.62 350.00 (72.38) 1,417.20 1,700.00 (282.80) 6,131.00 4,713.80 23%6101720 Salaries 3,545.46 3,750.00 (204.54) 14,543.96 15,000.00 (456.04) 45,000.00 30,456.04 32%6101800 Taxes-Employer Payroll 418.36 1,058.00 (639.64) 2,608.30 5,135.00 (2,526.70) 18,528.00 15,919.70 14%6101880 Wages-Hourly 3,390.65 4,747.00 (1,356.35) 20,778.66 26,244.00 (5,465.34) 103,818.00 83,039.34 20%6101882 Wages-Overtime 4.50 - 4.50 107.65 - 107.65 - 952.88 0%Total -PS-SALARIES & BENEFITS 10,433.59 12,702.00 (2,268.41) 49,627.49 57,974.00 (8,346.51) 205,688.00 157,121.04 24%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 239.35 500.00 (260.65) 1,725.26 2,000.00 (274.74) 6,000.00 4,274.74 29%6109090 Contract Services 500.00 500.00 - 2,000.00 2,000.00 - 6,000.00 4,000.00 33%6109220 Freight & Delivery - 25.00 (25.00) 110.11 25.00 85.11 75.00 (35.11) 147%6109490 Miscellaneous 8.37 50.00 (41.63) 104.37 50.00 54.37 450.00 345.63 23%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short 0.05 - 0.05 9.36 - 9.36 - (9.36) 0%6109722 Seminars/Training - 500.00 (500.00) 545.07 3,150.00 (2,604.93) 5,890.00 5,344.93 9%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms 163.13 100.00 63.13 598.27 400.00 198.27 2,400.00 1,801.73 25%6117840 Telephones 110.72 110.00 0.72 499.85 440.00 59.85 1,320.00 820.15 0%Total PS-OTHER EXPENSES 1,021.62 1,785.00 (763.38) 5,592.29 8,065.00 (2,472.71) 24,525.00 18,932.71 23%11,455.21 14,487.00 (3,031.79) 55,219.78 66,039.00 (10,819.22) 230,213.00 176,053.75 24%Net Income(10,485.93) (13,511.00) 3,025.07 (40,359.47) (48,589.30) 8,229.83 (86,391.60) (46,360.14) -46%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementOctober 20103 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 960.00 960.00 - 2,880.00 1,920.00 66.7%6311320 Insurance-Group 8,740.00 8,740.00 - 33,347.69 34,960.00 (1,612.31) 104,880.00 71,532.31 68.2%6311325 Insurance-Workers Comp 2,610.54 2,521.00 89.54 9,348.49 9,232.00 116.49 27,638.00 18,289.51 66.2%6311720 Salaries 11,001.60 12,583.00 (1,581.40) 46,940.16 50,332.00 (3,391.84) 150,996.00 104,055.84 68.9%6311800 Taxes-Employer Payroll 5,509.57 8,044.00 (2,534.43) 18,473.03 28,327.00 (9,853.97) 84,168.00 65,694.97 78.1%6311880 Wages-Hourly 41,500.14 41,725.00 (224.86) 169,322.21 166,900.00 2,422.21 509,458.00 340,135.79 66.8%6311882 Wages-Overtime 12,761.68 10,306.00 2,455.68 13,250.03 10,306.00 2,944.03 15,598.00 2,347.97 15.1%Total-CM-SALARIES & BENEFITS82,363.53 84,159.00 (1,795.47) 291,641.61 301,017.00 (9,375.39) 895,618.00 603,976.39 67.4%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 8,079.80 4,500.00 3,579.80 16,499.10 14,000.00 2,499.10 29,300.00 12,800.90 43.7%6313744 Fertilizer 13,468.44 17,500.00 (4,031.56) 48,015.61 52,900.00 (4,884.39) 89,400.00 41,384.39 46.3%6313745 Herbicides - - - 7,085.29 7,000.00 85.29 12,000.00 4,914.71 41.0%6313746 Flowers/Plants 166.39 250.00 (83.61) 1,253.89 1,250.00 3.89 3,050.00 1,796.11 58.9%6313748 Fuel-Gasoline 5,694.28 6,500.00 (805.72) 19,680.07 17,450.00 2,230.07 43,100.00 23,419.93 54.3%6313750 Golf Course Accessories 9,713.62 10,000.00 (286.38) 10,887.75 10,900.00 (12.25) 12,300.00 1,412.25 11.5%6313756 POA Control - - - 423.63 - 423.63 7,000.00 6,576.37 93.9%6313758 Miscellaneous Supp 437.23 500.00 (62.77) 2,235.36 2,750.00 (514.64) 4,350.00 2,114.64 0.0%6313762 Supplies-Office - - - 238.13 - 238.13 - (238.13) 0.0%6313774 Sand - 2,000.00 (2,000.00) 2,390.24 7,780.00 (5,389.76) 11,460.00 9,069.76 79.1%6313776 Seed 90,820.20 88,060.00 2,760.20 94,587.38 89,010.00 5,577.38 91,810.00 (2,777.38) -3.0%6313778 Small Tools & Non-Capital Equip 1,937.12 2,000.00 (62.88) 3,938.18 4,200.00 (261.82) 5,000.00 1,061.82 21.2%6313780 Sod - 250.00 (250.00) 3,179.03 1,650.00 1,529.03 3,350.00 170.97 5.1%6313782 Topdressing 2,149.90 2,500.00 (350.10) 7,717.59 5,000.00 2,717.59 7,600.00 (117.59) -1.5%Total-CM-SUPPLIES & MATERIALS132,466.98 134,060.00 (1,593.02) 218,131.25 213,890.00 4,241.25 319,720.00 101,588.75 31.8%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,575.00 1,498.00 77.00 7,651.24 10,148.00 (2,496.76) 24,610.00 16,958.76 68.9%6315685 CM-R&M-Bldngs & Othr Structures 90.50 - 90.50 677.00 750.00 (73.00) 1,750.00 1,073.00 61.3%6315690 CM-R&M-Equipment 9,006.85 8,000.00 1,006.85 16,012.21 11,000.00 5,012.21 20,500.00 4,487.79 21.9%6315692 CM-R&M-Irrigation System 1,067.83 2,000.00 (932.17) 6,624.34 8,400.00 (1,775.66) 16,050.00 9,425.66 58.7%6315696 CM-R&M-Pumps 1,772.69 1,000.00 772.69 4,613.70 4,000.00 613.70 10,500.00 5,886.30 56.1%6315815 CM-R&M-Trees-Pruning Etc - 550.00 (550.00) 3,495.00 4,050.00 (555.00) 10,050.00 6,555.00 65.2%Total-CM-REPAIRS & MAINTENANCE 13,512.87 13,048.00 464.87 39,073.49 38,348.00 725.49 83,460.00 44,386.51 53.2%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 23.47 15.00 8.47 93.78 60.00 33.78 180.00 86.22 0.0%6317840 Telephones 1,057.48 850.00 207.48 4,234.67 3,400.00 834.67 10,200.00 5,965.33 58.5%Total-CM-UTILITIES 1,080.95 865.00 215.95 4,328.45 3,460.00 868.45 10,380.00 6,051.55 58.3%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 2,000.00 2,000.00 - 6,000.00 4,000.00 66.7%6319100 Contract Svcs-Soil/Tissue Test - - - 1,500.00 2,000.00 (500.00) 4,000.00 2,500.00 62.5%6319101 Contract Svcs-Trash Removal 710.08 525.00 185.08 2,176.13 2,100.00 76.13 6,288.00 4,111.87 0.0%6319150 Dues & Subscriptions - - - - - - 540.00 540.00 100.0%6319170 Employee Education - 50.00 (50.00) 70.00 200.00 (130.00) 1,550.00 1,480.00 95.5%6319197 Equipment Rental 2,483.75 1,800.00 683.75 2,483.75 2,300.00 183.75 4,200.00 1,716.25 40.9%6319206 Licenses & Permits 114.05 - 114.05 293.03 280.00 13.03 1,430.00 1,136.97 79.5%6319490 Miscellaneous - 100.00 (100.00) 444.06 400.00 44.06 1,200.00 755.94 63.0%6319718 Safety Equipment & Training 172.63 800.00 (627.37) 1,185.98 1,850.00 (664.02) 3,850.00 2,664.02 69.2%6319822 Uniforms 906.04 820.00 86.04 4,186.57 3,280.00 906.57 9,840.00 5,653.43 57.5%Total-CM-OTHER EXPENSES 4,886.55 4,595.00 291.55 14,339.52 14,410.00 (70.48) 38,898.00 24,558.48 63.1%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementOctober 2010Annual Budget4 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,317.00 2,317.00 - 8,359.00 9,268.00 (909.00) 27,804.00 19,445.00 69.9%6321325 Insurance-Workers Comp 424.34 523.00 (98.66) 1,630.05 1,881.00 (250.95) 5,487.00 3,856.95 70.3%6321800 Taxes-Employer Payroll 811.57 1,700.00 (888.43) 3,116.09 5,839.00 (2,722.91) 16,811.00 13,694.91 81.5%6321880 Wages-Hourly 8,124.84 10,813.00 (2,688.16) 38,234.58 43,252.00 (5,017.42) 129,756.00 91,521.42 70.5%6321882 Wages-Overtime 2,483.68 2,839.00 (355.32) 2,516.64 3,650.00 (1,133.36) 5,272.00 2,755.36 52.3%Total-CM-LM-SALARIES & BENEFITS14,161.43 18,192.00 (4,030.57) 53,856.36 63,890.00 (10,033.64) 185,130.00 131,273.64 70.9%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools 146.28 100.00 46.28 146.28 400.00 (253.72) 1,025.00 878.72 85.7%6323788 Uniforms 212.63 290.00 (77.37) 907.10 1,160.00 (252.90) 3,480.00 2,572.90 73.9%Total-CM-LM-SUPPLIES & MATERIALS358.91 390.00 (31.09) 1,053.38 1,560.00 (506.62) 4,505.00 3,451.62 76.6%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation 125.17 500.00 (374.83) 125.17 1,500.00 (1,374.83) 4,250.00 4,124.83 97.1%Total-CM-LM-REPAIRS & MAINTENANCE 125.17 500.00 (374.83) 125.17 1,500.00 (1,374.83) 4,250.00 4,124.83 97.1%248,956.39 255,809.00 (6,852.61) 622,549.23 638,075.00 (15,525.77) 1,541,961.00 919,411.77 59.6% October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 2,443.16 3,000.00 (556.84) 11,464.44 15,300.00 (3,835.56) 42,300.00 30,835.56 72.9%6337842 Utilities-Water4,770.16 3,960.00 810.16 23,235.83 21,280.00 1,955.83 43,058.00 19,822.17 46.0%7,213.32 6,960.00 253.32 34,700.27 36,580.00 (1,879.73) 85,358.00 50,657.73 59.3%Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetSilverrock ResortCourse Maintenance Water & EnergyOctober 2010Total-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementOctober 2010Annual BudgetMonth to Date Year to Date5 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 540.00 540.00 - 1,800.00 1,800.00 - 6,960.00 5,160.00 74.1%6411320 Insurance-Group 662.00 662.00 - 2,044.60 2,648.00 (603.40) 7,944.00 5,899.40 74.3%6411325 Insurance-Workers Comp 123.43 181.00 (57.57) 1,125.21 1,152.00 (26.79) 5,096.00 3,970.79 77.9%6411800 Taxes-Employer Payroll 314.52 546.00 (231.48) 3,173.80 3,482.00 (308.20) 15,399.00 12,225.20 79.4%6411880 Wages-Hourly 3,076.63 4,388.00 (1,311.37) 28,015.12 27,973.00 42.12 123,689.00 95,673.88 77.4%6411882 Wages-Overtime 9.00 - 9.00 114.94 - 114.94 - (114.94) 0.0%Total-CBR-SALARIES & BENEFITS4,725.58 6,317.00 (1,591.42) 36,273.67 37,055.00 (781.33) 159,088.00 122,814.33 77.2%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 500.00 (500.00) 1,237.03 500.00 737.03 2,350.00 1,112.97 47.4%6413742 Supplies-Expendable 480.68 150.00 330.68 2,344.97 1,500.00 844.97 6,750.00 4,405.03 65.3%6413752 Supplies-Range Balls - - - - - - 6,000.00 6,000.00 100.0%6413762 Supplies-Office - 50.00 (50.00) - 125.00 (125.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels - 100.00 (100.00) - 316.00 (316.00) 1,005.00 1,005.00 100.0%6413796 Supplies-Bottled Water11,493.46 12,000.00 (506.54) 12,062.92 12,150.00 (87.08) 24,500.00 12,437.08 50.8%Total-CBR-SUPPLIES & MATERIALS11,974.14 12,800.00 (825.86) 15,644.92 14,591.00 1,053.92 41,550.00 25,905.08 62.3%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts - 720.00 (720.00) - 2,880.00 (2,880.00) 8,640.00 8,640.00 100.0%6415690 CBR-R&M-Equipment 400.44 300.00 100.44 962.62 1,200.00 (237.38) 3,600.00 2,637.38 73.3%6415695 CBR-R&M-Cart Maintenance & Repair 2,187.00 1,000.00 1,187.00 2,900.18 2,500.00 400.18 5,000.00 2,099.82 42.0%Total-CBR-REPAIRS & MAINTENANCE 2,587.44 2,020.00 567.44 3,862.80 6,580.00 (2,717.20) 17,240.00 13,377.20 77.6%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 729.76 800.00 (70.24) 3,942.12 3,200.00 742.12 9,600.00 5,657.88 58.9%6419220 Freight/Delivery - 75.00 (75.00) 78.96 300.00 (221.04) 450.00 371.04 82.5%6419490 Miscellaneous 41.27 75.00 (33.73) 41.27 350.00 (308.73) 1,150.00 1,108.73 96.4%6419820 Uniforms 1,372.29 2,000.00 (627.71) 1,747.38 2,000.00 (252.62) 5,200.00 3,452.62 66.4%Total-CBR-OTHER EXPENSES 2,143.32 2,950.00 (806.68) 5,809.73 5,850.00 (40.27) 16,400.00 10,590.27 64.6%TOTAL-CARTS,BAGROOM & RANGE 21,430.48 24,087.00 (2,656.52) 61,591.12 64,076.00 (2,484.88) 234,278.00 172,686.88 73.7%643-CS-SALARIES & BENEFITS6431175 Employee Meals 180.00 180.00 - 720.00 720.00 - 3,420.00 2,700.00 78.9%6431325 Insurance-Workers Comp 18.80 35.00 (16.20) 257.80 282.00 (24.20) 1,738.00 1,480.20 85.2%6431800 Taxes-Employer Payroll 59.08 105.00 (45.92) 878.16 852.00 26.16 5,251.00 4,372.84 83.3%6431880 Wages-Hourly 470.00 1,639.00 (1,169.00) 6,436.00 13,479.00 (7,043.00) 48,816.00 42,380.00 86.8%6431882 Wages-Overtime - - - 9.00 - 9.00 - (9.00) 0.0%Total-CS-SALARIES & BENEFITS727.88 1,959.00 (1,231.12) 8,300.96 15,333.00 (7,032.04) 59,225.00 50,924.04 86.0%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) - 300.00 (300.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous - 50.00 (50.00) - 50.00 (50.00) 200.00 200.00 100.0%6439718 Safety Equipment & Training - 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6439820 Uniforms 838.10 800.00 38.10 838.10 1,025.00 (186.90) 2,125.00 1,286.90 60.6%Total-CS-OTHER EXPENSES 838.10 1,000.00 (161.90) 838.10 1,575.00 (736.90) 3,975.00 3,136.90 78.9%Total-COURSE SERVICES 1,565.98 2,959.00 (1,393.02) 9,139.06 16,908.00 (7,768.94) 63,200.00 54,060.94 85.5%22,996.46 27,046.00 (4,049.54) 70,730.18 80,984.00 (10,253.82) 297,478.00 223,610.92 75.2%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementOctober 2010Annual Budget6 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 712.50 1,600.00 (887.50) 4,800.00 4,087.50 85.2%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 712.50 1,600.00 (887.50) 4,800.00 4,087.50 85.2%65-CH-UTILITIES6507836 Utilities-Natural Gas219.65 300.00 (80.35) 1,138.29 1,200.00 (61.71) 3,600.00 2,461.71 68.4%6507840 Utilities-Telephone1,058.14 1,150.00 (91.86) 4,206.82 4,600.00 (393.18) 13,800.00 9,593.18 69.5%6507842 Utilities-Water1,729.74 321.00 1,408.74 6,689.85 1,284.00 5,405.85 3,852.00 (2,837.85) -73.7%6507844 Utilities-Cable336.49 340.00 (3.51) 1,345.96 1,360.00 (14.04) 4,080.00 2,734.04 67.0%Total-CH-UTILITIES 3,344.02 2,111.00 1,233.02 13,380.92 8,444.00 4,936.92 25,332.00 11,951.08 47.2%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 2,425.00 (600.00) 7,300.00 7,900.00 (600.00) 22,500.00 15,200.00 67.6%6509099 Contract Services-Security6,847.56 4,900.00 1,947.56 21,117.24 19,600.00 1,517.24 60,400.00 39,282.76 65.0%6509215 Flowers & Decorations- 500.00 (500.00) - 500.00 (500.00) 2,400.00 2,400.00 100.0%6509490 Miscellaneous891.71 200.00 691.71 891.71 800.00 91.71 2,400.00 1,508.29 62.8%6509718 Safety Equipment & Training- 100.00 (100.00) - 400.00 (400.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES 9,564.27 8,125.00 1,439.27 29,308.95 29,200.00 108.95 88,900.00 59,591.05 67.0%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures281.00 300.00 (19.00) 2,249.00 1,200.00 1,049.00 3,600.00 1,351.00 37.5%6515686 CH-R&M-Restaurant Repairs135.00 400.00 (265.00) 1,164.77 1,600.00 (435.23) 4,800.00 3,635.23 75.7%6515690 CH-R&M-Equipment Repair851.00 400.00 451.00 1,144.03 1,600.00 (455.97) 4,800.00 3,655.97 76.2%Total-CH-REPAIRS & MAINTENANCE 1,267.00 1,100.00 167.00 4,557.80 4,400.00 157.80 13,200.00 8,642.20 65.5%14,175.29 11,736.00 2,439.29 47,960.17 43,644.00 4,316.17 132,232.00 17,284.40 13.1%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementOctober 2010Annual Budget7 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 240.00 240.00 - 720.00 480.00 66.7%6601320 Insurance-Group 331.00 331.00 - 1,263.60 1,324.00 (60.40) 3,972.00 2,708.40 68.2%6601325 Insurance-Workers Comp 100.00 103.00 (3.00) 450.00 412.00 38.00 1,240.00 790.00 63.7%6601720 Salaries 2,500.00 2,508.00 (8.00) 11,250.00 10,032.00 1,218.00 30,096.00 18,846.00 62.6%6601800 Taxes-Employer Payroll 311.00 312.00 (1.00) 1,399.50 1,248.00 151.50 3,747.00 2,347.50 62.7%Total-MKT-SALARIES & BENEFITS 3,302.00 3,314.00 (12.00) 14,603.10 13,256.00 1,347.10 39,775.00 25,171.90 63.3%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 52.81 100.00 (47.19) 52.81 400.00 (347.19) 1,200.00 1,147.19 95.6%6603768 Supplies-Printing & Stationery 2,878.27 3,000.00 (121.73) 4,863.57 3,200.00 1,663.57 4,425.00 (438.57) -9.9%2,931.08 3,100.00 (168.92) 4,916.38 3,600.00 1,316.38 5,625.00 708.62 12.6%66-MKT-UTILITIES6607840 Utilities-Telephone 51.08 100.00 (48.92) 208.67 400.00 (191.33) 1,200.00 991.33 82.6%Total-MKT-UTILITIES 51.08 100.00 (48.92) 208.67 400.00 (191.33) 1,200.00 991.33 82.6%66-MKT-OTHER EXPENSES6609010 Advertising 13,619.35 10,087.00 3,532.35 51,535.17 55,708.00 (4,172.83) 192,534.00 140,998.83 73.2%6609040 Business Meals - 25.00 (25.00) - 100.00 (100.00) 300.00 300.00 100.0%6609080 Collateral Material 322.30 2,500.00 (2,177.70) 322.30 2,500.00 (2,177.70) 9,000.00 8,677.70 96.4%6609102 Contract Services-Web Page 99.00 400.00 (301.00) 883.50 1,600.00 (716.50) 4,800.00 3,916.50 81.6%6609490 Miscellaneous - - - - - - 350.00 350.00 100.0%6609620 Postage 105.60 50.00 55.60 283.62 200.00 83.62 600.00 316.38 52.7%6609630 Promotion - 50.00 (50.00) - 50.00 (50.00) 3,500.00 3,500.00 0.0%6609633 Promotion-Community - 750.00 (750.00) - 975.00 (975.00) 2,925.00 2,925.00 100.0%6609634 Promotion-Media/Vendor - 500.00 (500.00) - 1,000.00 (1,000.00) 700.00 - 0.0%6609150 Dues and Subscriptions - - - 140.00 - 140.00 735.00 595.00 81.0%6609820 Uniforms - 300.00 (300.00) - 300.00 (300.00) 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 14,146.25 14,662.00 (515.75) 53,164.59 62,433.00 (9,268.41) 216,044.00 162,179.41 75.1%20,430.41 21,176.00 (745.59) 72,892.74 79,689.00 (6,796.26) 262,644.00 189,051.26 72.0%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementOctober 2010Annual Budget8 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 720.00 720.00 - 2,160.00 1,440.00 66.7%6701320 Insurance-Group1,458.00 1,458.00 - 5,111.60 5,832.00 (720.40) 17,496.00 12,384.40 70.8%6701325 Insurance-Workers Comp557.24 707.00 (149.76) 2,506.62 2,828.00 (321.38) 8,480.00 5,973.38 70.4%6701720 Salaries 13,416.26 14,833.34 (1,417.08) 57,242.71 59,333.36 (2,090.65) 178,000.00 120,757.29 67.8%6701800 Taxes-Employer Payroll 1,065.71 2,136.00 (1,070.29) 4,874.16 8,544.00 (3,669.84) 25,627.00 20,752.84 81.0%6701880 Wages-Hourly514.75 2,319.66 (1,804.91) 5,423.02 9,278.64 (3,855.62) 27,835.00 22,411.98 80.5%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 17,191.96 21,634.00 (4,442.04) 75,878.11 86,536.00 (10,657.89) 259,598.00 183,719.89 70.8%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 400.00 (400.00) 863.48 1,600.00 (736.52) 5,200.00 4,336.52 83.4%6703762 Supplies-Office - 100.00 (100.00) 440.81 400.00 40.81 1,200.00 759.19 63.3%6703768 Supplies-Printing & Stationery56.61 100.00 (43.39) 791.14 400.00 391.14 3,300.00 2,508.86 76.0%Total-G&A-SUPPLIES & MATERIALS 56.61 600.00 (543.39) 2,095.43 2,400.00 (304.57) 9,700.00 7,604.57 78.4%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) - 300.00 (300.00) 1,100.00 1,100.00 100.0%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) - 300.00 (300.00) 1,100.00 1,100.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7%6709150 Dues & Subscriptions100.00 50.00 50.00 371.71 300.00 71.71 1,700.00 1,328.29 78.1%6709180 Employee Recruiting/Relocation56.00 200.00 (144.00) 280.00 400.00 (120.00) 1,400.00 1,120.00 80.0%6709197 Equipment Rental508.81 480.00 28.81 2,634.33 1,920.00 714.33 5,760.00 3,125.67 54.3%6709202 Fees-Bank54.01 90.00 (35.99) 230.04 360.00 (129.96) 1,080.00 849.96 78.7%6709208 Fees-Payroll Processing1,077.68 760.00 317.68 4,809.05 3,040.00 1,769.05 9,120.00 4,310.95 47.3%6709220 Freight/Delivery- 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6709490 Miscellaneous 186.84 100.00 86.84 186.84 400.00 (213.16) 1,200.00 1,013.16 84.4%6709620 Postage/Mail Services 73.41 75.00 (1.59) 317.55 300.00 17.55 900.00 582.45 64.7%6709625 Professional Fees769.00 850.00 (81.00) 3,973.50 3,400.00 573.50 10,200.00 6,226.50 61.0%6709636 Promotion/Entertainment- 100.00 (100.00) - 400.00 (400.00) 3,100.00 3,100.00 100.0%6709722 Seminars & Training- 200.00 (200.00) - 800.00 (800.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 - 150.00 (150.00) - 375.00 (375.00) 1,050.00 1,050.00 100.0%Total-G&A-OTHER EXPENSES 3,225.75 3,505.00 (279.25) 14,403.02 13,595.00 808.02 44,410.00 30,006.98 67.6%20,474.32 25,839.00 (5,364.68) 92,376.56 102,831.00 (10,454.44) 314,808.00 222,431.44 70.7%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementOctober 2010Annual Budget9 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 8,156.69 11,581.00 (3,424.31) 32,346.70 46,324.00 (13,977.30) 150,324.00 117,977.30 78.5%6800194 Equipment Leases-Trailer 540.00 600.00 (60.00) 2,140.00 2,400.00 (260.00) 7,200.00 5,060.00 70.3%6800196 Equipment Leases-GPS 7,942.00 8,636.00 (694.00) 31,768.00 34,544.00 (2,776.00) 90,216.00 58,448.00 64.8%6800197 Equipment Leases-Others 2,314.80 - 2,314.80 8,436.75 - 8,436.75 - - 0.0%18,953.49 20,817.00 (1,863.51) 74,691.45 83,268.00 (8,576.55) 247,740.00 181,485.30 73.3%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 15,474.60 19,052.00 (3,577.40) 65,684.90 72,040.00 (6,355.10) 90,000.00 24,315.10 27.0%6900210 FF&E Reserve 426.72 478.00 (51.28) 6,489.85 7,568.00 (1,078.15) 62,229.00 55,739.15 89.6%6900800 Personal Property Taxes 6,641.33 - 6,641.33 11,840.62 13,570.00 (1,729.38) 13,570.00 1,729.38 12.7%6900323 Insurance-Commercial 6,034.00 2,200.00 3,834.00 9,442.32 8,800.00 642.32 26,400.00 16,957.68 64.2%28,576.65 21,730.00 6,846.65 93,457.69 101,978.00 (8,520.31) 192,199.00 98,741.31 51.4%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementOctober 201010 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 96 3LQ HS Golf20153 148 208 3 0 02011 2011 2011 2011 2011 2011Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011