Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
04 October 2008 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2008 – October 2008 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 35,477.50 49,610.00 (14,132.50) -28.5% 334,093.25 397,618.00 (63,524.75) 3,255,761.00 2,921,667.75 10%401000 Miscellaneous Golf Revenue 4,551.40 5,820.00 (1,268.60) -21.8% 17,881.90 23,982.00 (6,100.10) 113,217.00 95,335.10 16%410000 Revenue-Golf Shop 3,274.34 6,400.00 (3,125.66) -48.8% 45,697.28 58,551.00 (12,853.72) 375,951.00 330,253.72 12%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 9.28 - 9.28 0.0% 39.60 - 39.60 - (39.60) 0%Total Income44,812.52 63,330.00 (18,517.48) -29.2% 400,712.03 483,151.00 (82,438.97) 3,756,929.00 3,356,216.97 11%Cost of Goods Sold510000 COS-Golf Shop 1,899.41 3,397.00 (1,497.59) 44.1% 25,285.74 31,075.00 5,789.26 199,538.00 174,252.26 13%Total COS1,899.41 3,397.00 (1,497.59) 44.1% 25,285.74 31,075.00 5,789.26 199,538.00 174,252.26 13%Gross Profit42,913.11 59,933.00 (17,019.89) -28.4% 375,426.29 452,076.00 (76,649.71) 3,557,391.00 3,181,964.71 11%Expenses610000 Golf Pro Shop 14,522.94 12,646.00 (1,876.94) -14.8% 70,710.81 76,856.00 6,145.19 279,518.00 208,807.19 25%630000 Course Maintenance 293,088.17 289,337.00 (3,751.17) -1.3% 710,070.07 720,732.00 10,661.93 1,805,855.00 1,095,784.93 39%640000 Outside Services 8,948.83 16,898.00 7,949.17 47.0% 63,923.52 77,246.00 13,322.48 294,037.00 230,113.48 22%650000 Clubhouse 14,000.18 14,442.00 441.82 3.1% 54,489.25 55,968.00 1,478.75 168,104.00 113,614.75 32%660000 Marketing 24,510.33 25,663.00 1,152.67 4.5% 74,965.65 72,437.00 (2,528.65) 298,081.00 223,115.35 25%670000 General & Administrative 21,489.98 27,857.00 6,367.02 22.9% 91,773.14 109,103.00 17,329.86 333,834.00 242,060.86 27%680000 Leases 45,617.49 41,106.00 (4,511.49) -11.0% 165,868.36 164,424.00 (1,444.36) 493,272.00 327,403.64 34%690000 Miscellaneous Other Expense 21,067.07 14,137.00 (6,930.07) -49.0% 97,870.73 97,321.00 (549.73) 227,140.00 129,269.27 43%Total Expenses443,244.99 442,086.00 (1,158.99) -0.3% 1,329,671.53 1,374,087.00 44,415.47 3,899,841.00 2,570,169.47 34%Net Income (400,331.88) (382,153.00) (18,178.88) -4.8%(954,245.24) (922,011.00) (32,234.24) (342,450.00) 611,795.24 279%Rounds of Golf PlayedPaid Rounds Played 626 800 (174) -21.8% 7,702 8,250 (548) 40,580 32,878 19%Ave $ Per Paid Round Green Fee 56.67 62.01 (5.34) -8.6% 43.38 48.20 (4.82) 77.90 34.52 56%Ave $ Per Paid Round Merchandise 5.23 8.00 (2.77) -34.6% 5.93 7.10 (1.16) 8.07 2.14 74%Ave $ Per Paid Miscellaneous 7.27 7.28 (0.00) -0.1% 2.32 2.91 (0.59) 2.06 - 0%Month to Date Year to DateOctober 2008SilverRock ResortSummary Operating Income Statement1 Income October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 35,477.50 49,610.00 (14,132.50) 334,093.25 397,618.00 (63,524.75) 3,255,761.002,921,667.7510%4010000 Rider Fee 125.00 80.00 45.00 1,875.00 2,694.00 (819.00) 5,984.004,109.0031%4040000 Club Rental 180.00 440.00 (260.00) 3,090.00 4,538.00 (1,448.00) 27,583.0024,493.0011%4050000 Driving Range 868.00 800.00 68.00 7,525.00 8,250.00 (725.00) 46,650.0039,125.0016%4060000 Handicap Fees 2,385.00 1,500.00 885.00 2,590.00 1,500.00 1,090.00 8,000.00 5,410.0032%4080000 GPS Advertising - 2,000.00 (2,000.00) 1,575.00 5,000.00 (3,425.00) 12,000.00 10,425.0013%4090000 Ball Retriever/Subcontract 993.40 1,000.00 (6.60) 993.40 2,000.00 (1,006.60) 4,000.00 3,006.6025%4091000 Golf Professional Rental Fee - - - - - - 9,000.00 9,000.00 0%4092000 Golf Lessons - - - 233.50 - 233.50 - (233.50) 0% Total Revenue Fees 40,028.90 55,430.00 (15,401.10) 351,975.15 421,600.00 (69,624.85) 3,368,978.00 3,017,002.85 10%Total Income 40,028.90 55,430.00 (15,401.10) 351,975.15 421,600.00 (69,624.85) 3,368,978.00 3,017,002.85 10%SilverRock ResortStatement of Fees RevenueOctober 2008Month to Date Year to Date Annual Budget2 Income October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 27.08 - 27.08 2,306.74 - 2,306.74 4100110 Sales Hard Goods 1,275.34 2,240.00 (964.66) 25,864.47 20,493.00 5,371.47 131,583.00 105,718.53 20%4100112 Sales-Soft Goods 3,101.52 4,160.00 (1,058.48) 27,707.37 38,058.00 (10,350.63) 244,368.00 216,660.63 11%5100639 GS-Discounts-Mdse (1,129.60) - (1,129.60) (10,181.30) - (10,181.30) - 10,181.30 0% Total Revenue Golf Shop 3,274.34 6,400.00 (3,125.66) 45,697.28 58,551.00 (12,853.72) 375,951.00 332,560.46 12%COS 5100150 COS-GS-Hard Goods 379.00 1,232.00 (853.00) 13,678.73 11,271.00 2,407.73 72,373.00 58,694.27 19%5100151 COS-GS-Soft Goods 1,316.30 2,288.00 (971.70) 11,113.03 20,931.00 (9,817.97) 134,404.00 123,290.97 8%5100152 COS-GS-Purchase Disc (585.00) (176.00) (409.00) (571.32) (1,610.00) 1,038.68 (10,341.00) (9,769.68) -6%5100220 COS-GS-Freight Merch 789.11 53.00 736.11 1,065.30 483.00 582.30 3,102.00 2,036.70 34%Cost of Sales - Golf Shop 1,899.41 3,397.00 (1,497.59) 25,285.74 31,075.00 (5,789.26) 199,538.00 174,252.26 13%Gross Profit 1,374.93 3,003.00 (1,628.07) 20,411.54 27,476.00 (7,064.46) 176,413.00 158,308.20 10%COS % 58.0% 53.1% -4.9% 55.3% 53.1% -2.3% 53.1% 52.4% 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,111.91 3,150.00 (1,038.09) 10,351.84 11,250.00 (898.16) 36,450.00 26,098.16 28%6101325 Insurance-Workers Comp 246.91 494.00 (247.09) 1,626.18 3,886.00 (2,259.82) 14,771.00 13,144.82 11%6101720 Salaries 5,872.66 4,557.00 1,315.66 23,926.97 22,803.00 1,123.97 71,459.00 47,532.03 33%6101800 Taxes-Employer Payroll 369.85 750.00 (380.15) 3,019.50 5,900.00 (2,880.50) 22,431.00 19,411.50 13%6101880 Wages-Hourly 2,357.38 1,470.00 887.38 22,572.59 24,592.00 (2,019.41) 108,712.00 86,139.41 21%6101882 Wages-Overtime - - - 192.31 - 192.31 - 952.88 0%Total -PS-SALARIES & BENEFITS 11,438.71 10,901.00 537.71 63,309.39 70,051.00 (6,741.61) 259,223.00 197,058.80 24%61-PS OTHER EXPENSES6103762 Supplies-Office 154.93 500.00 (345.07) 1,550.93 1,400.00 150.93 2,950.00 1,399.07 53%6109090 Contract Services 500.00 500.00 - 2,000.00 2,000.00 - 6,000.00 4,000.00 33%6109220 Freight & Delivery 83.19 25.00 58.19 214.29 25.00 189.29 75.00 (139.29) 286%6109490 Miscellaneous - 50.00 (50.00) - 50.00 (50.00) 450.00 450.00 0%6109150 Dues and Subscriptions 101.52 - 101.52 153.05 - 153.05 2,000.00 1,846.95 8%6109500 ProShop-Over/Short 0.50 - 0.50 126.24 - 126.24 (126.24) 0%6109722 Seminars/Training 1,760.00 500.00 1,260.00 2,315.00 2,650.00 (335.00) 5,490.00 3,175.00 42%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms 316.10 100.00 216.10 461.19 400.00 61.19 2,400.00 1,938.81 19%6117840 Telephones 167.99 70.00 97.99 580.72 280.00 300.72 840.00 259.28 0%Total PS-OTHER EXPENSES 3,084.23 1,745.00 1,339.23 7,401.42 6,805.00 596.42 20,295.00 12,893.58 36%Total Expenses14,522.94 12,646.00 1,876.94 70,710.81 76,856.00 (6,145.19) 279,518.00 209,952.38 25%Net Income(13,148.01) (9,643.00) (3,505.01) (50,299.27) (49,380.00) (919.27) (103,105.00) (51,644.18) -50%Month to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementOctober 20083 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 9,037.53 12,083.00 (3,045.47) 47,710.79 48,332.00 (621.21) 144,996.00 97,285.21 67.1%6311325 Insurance-Workers Comp 2,192.73 5,428.00 (3,235.27) 8,669.49 19,951.00 (11,281.51) 59,020.00 50,350.51 85.3%6311720 Salaries 11,001.60 12,331.00 (1,329.40) 47,116.80 49,324.00 (2,207.20) 147,978.00 100,861.20 68.2%6311800 Taxes-Employer Payroll 5,675.10 8,686.00 (3,010.90) 20,126.28 30,736.00 (10,609.72) 90,311.00 70,184.72 77.7%6311880 Wages-Hourly 44,681.01 46,708.00 (2,026.99) 181,051.47 186,832.00 (5,780.53) 560,520.00 379,468.53 67.7%6311882 Wages-Overtime 17,408.21 10,732.00 6,676.21 19,727.70 10,732.00 8,995.70 16,894.00 (2,833.70) -16.8%Total-CM-SALARIES & BENEFITS90,236.18 96,208.00 (5,971.82) 325,362.53 346,867.00 (21,504.47) 1,022,599.00 697,236.47 68.2%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 5,191.93 4,500.00 691.93 14,817.86 9,900.00 4,917.86 25,200.00 10,382.14 41.2%6313744 Fertilizer 22,283.89 18,100.00 4,183.89 46,323.37 44,700.00 1,623.37 95,200.00 48,876.63 51.3%6313746 Flowers/Plants - 250.00 (250.00) 808.12 1,250.00 (441.88) 3,500.00 2,691.88 76.9%6313748 Fuel-Gasoline 6,427.30 6,490.00 (62.70) 17,330.00 17,710.00 (380.00) 45,540.00 28,210.00 61.9%6313750 Golf Course Accessories 6,378.27 5,000.00 1,378.27 6,725.95 5,600.00 1,125.95 7,000.00 274.05 3.9%6313756 POA Control 204.79 - 204.79 842.20 - 842.20 6,000.00 5,157.80 86.0%6313758 Miscellaneous Supp 369.00 100.00 269.00 2,347.39 400.00 1,947.39 - (2,347.39) 0.0%6313762 Supplies-Office 187.31 - 187.31 282.95 - 282.95 1,200.00 917.05 76.4%6313774 Sand - 2,100.00 (2,100.00) 1,885.71 2,880.00 (994.29) 6,660.00 4,774.29 71.7%6313775 Sand-Bunkers - - - 3,702.67 5,000.00 (1,297.33) 5,000.00 1,297.33 25.9%6313776 Seed 107,139.20 98,060.00 9,079.20 107,987.73 99,010.00 8,977.73 101,810.00 (6,177.73) -6.1%6313778 Small Tools & Non-Capital Equip 1,385.24 3,000.00 (1,614.76) 4,378.60 6,200.00 (1,821.40) 7,000.00 2,621.40 37.4%6313780 Sod - 250.00 (250.00) 5,159.85 3,250.00 1,909.85 5,750.00 590.15 10.3%6313782 Topdressing 2,885.55 2,500.00 385.55 5,035.98 5,000.00 35.98 7,600.00 2,564.02 33.7%Total-CM-SUPPLIES & MATERIALS152,452.48 140,350.00 12,102.48 217,628.38 200,900.00 16,728.38 317,460.00 99,831.62 31.4%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,668.12 500.00 1,168.12 6,338.11 5,000.00 1,338.11 16,000.00 9,661.89 60.4%6315685 CM-R&M-Bldngs & Othr Structures 367.00 - 367.00 820.50 - 820.50 500.00 (320.50) -64.1%6315690 CM-R&M-Equipment 9,723.03 10,000.00 (276.97) 22,679.76 23,200.00 (520.24) 46,100.00 23,420.24 50.8%6315692 CM-R&M-Irrigation System 963.10 2,000.00 (1,036.90) 8,369.55 7,800.00 569.55 15,450.00 7,080.45 45.8%6315696 CM-R&M-Pumps 2,674.26 1,000.00 1,674.26 4,627.44 4,000.00 627.44 10,500.00 5,872.56 55.9%6315815 CM-R&M-Trees-Pruning Etc 554.64 3,000.00 (2,445.36) 4,054.64 3,000.00 1,054.64 9,000.00 4,945.36 54.9%Total-CM-REPAIRS & MAINTENANCE 15,950.15 16,500.00 (549.85) 46,890.00 43,000.00 3,890.00 97,550.00 50,660.00 51.9%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs 5.38 - 5.38 16.14 - 16.14 - (16.14) 0.0%6317836 Utilities-Natural Gas/LPG - 150.00 (150.00) - 600.00 (600.00) 1,800.00 1,800.00 0.0%6317840 Telephones 722.34 800.00 (77.66) 3,311.25 3,200.00 111.25 9,600.00 6,288.75 65.5%Total-CM-UTILITIES 727.72 950.00 (222.28) 3,327.39 3,800.00 (472.61) 11,400.00 8,072.61 70.8%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 524.05 - 524.05 1,959.06 - 1,959.06 - (1,959.06) 0.0%6319150 Dues & Subscriptions - - - 245.00 200.00 45.00 900.00 655.00 72.8%6319170 Employee Education - 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6319197 Equipment Rental 2,416.59 1,800.00 616.59 2,416.59 2,300.00 116.59 4,200.00 1,783.41 42.5%6319206 Licenses & Permits - - - 60.00 200.00 (140.00) 1,600.00 1,540.00 96.3%6319490 Miscellaneous - 100.00 (100.00) 143.02 400.00 (256.98) 1,200.00 1,056.98 88.1%6319718 Safety Equipment & Training - 200.00 (200.00) 1,203.18 2,100.00 (896.82) 3,400.00 2,196.82 64.6%6319822 Uniforms 1,036.26 820.00 216.26 2,980.61 3,280.00 (299.39) 9,840.00 6,859.39 69.7%Total-CM-OTHER EXPENSES 4,476.90 3,470.00 1,006.90 12,507.46 12,680.00 (172.54) 31,740.00 19,232.54 60.6%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementOctober 2008Annual Budget4 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,596.91 1,104.00 492.91 4,908.91 4,416.00 492.91 13,248.00 8,339.09 62.9%6321325 Insurance-Workers Comp 497.33 1,252.00 (754.67) 1,931.66 4,535.00 (2,603.34) 13,257.00 11,325.34 85.4%6321800 Taxes-Employer Payroll 1,191.69 2,033.00 (841.31) 3,799.38 7,054.00 (3,254.62) 20,368.00 16,568.62 81.3%6321880 Wages-Hourly 12,004.11 13,141.00 (1,136.89) 52,122.53 52,564.00 (441.47) 157,692.00 105,569.47 66.9%6321882 Wages-Overtime 4,573.50 3,185.00 1,388.50 4,932.80 4,095.00 837.80 5,915.00 982.20 16.6%Total-CM-LM-SALARIES & BENEFITS19,863.54 20,715.00 (851.46) 67,695.28 72,664.00 (4,968.72) 210,480.00 142,784.72 67.8%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools 64.59 100.00 (35.41) 318.44 400.00 (81.56) 1,025.00 706.56 68.9%6323788 Uniforms 547.44 290.00 257.44 1,390.93 1,160.00 230.93 3,480.00 2,089.07 60.0%Total-CM-LM-SUPPLIES & MATERIALS612.03 390.00 222.03 1,709.37 1,560.00 149.37 4,505.00 2,795.63 62.1%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation 570.39 500.00 70.39 706.51 1,500.00 (793.49) 4,250.00 3,543.49 83.4%Total-CM-LM-REPAIRS & MAINTENANCE 570.39 500.00 70.39 706.51 1,500.00 (793.49) 4,250.00 3,543.49 83.4%632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 5,010.28 7,000.00 (1,989.72) 20,252.93 28,000.00 (7,747.07) 84,000.00 63,747.07 75.9%6337842 Utilities-Water3,188.50 3,254.00 (65.50) 13,990.22 9,761.00 4,229.22 21,871.00 7,880.78 36.0%Total-CM-WATER & ENERGY8,198.78 10,254.00 (2,055.22) 34,243.15 37,761.00 (3,517.85) 105,871.00 71,627.85 67.7%293,088.17 289,337.00 3,751.17 710,070.07 720,732.00 (10,661.93) 1,805,855.00 1,095,784.93 60.7%Silverrock ResortCourse Maintenance Expense StatementOctober 2008Annual BudgetTotal -COURSE MAINTENANCEMonth to Date Year to Date5 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 420.00 420.00 - 1,680.00 1,680.00 - 6,180.00 4,500.00 72.8%6411320 Insurance-Group 63.25 720.00 (656.75) 207.85 2,880.00 (2,672.15) 8,640.00 8,432.15 97.6%6411325 Insurance-Workers Comp 89.94 489.00 (399.06) 979.73 4,385.00 (3,405.27) 16,511.00 15,531.27 94.1%6411800 Taxes-Employer Payroll 309.07 424.00 (114.93) 2,886.25 3,803.00 (916.75) 14,318.00 11,431.75 79.8%6411880 Wages-Hourly 2,990.01 3,406.00 (415.99) 26,335.05 30,541.00 (4,205.95) 114,990.00 88,654.95 77.1%6411882 Wages-Overtime 7.87 - 7.87 116.24 - 116.24 - (116.24) 0.0%Total-CBR-SALARIES & BENEFITS3,880.14 5,459.00 (1,578.86) 32,205.12 43,289.00 (11,083.88) 160,639.00 128,433.88 80.0%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 500.00 (500.00) 94.55 500.00 (405.45) 2,350.00 2,255.45 96.0%6413742 Supplies-Expendable 371.23 1,000.00 (628.77) 1,296.66 1,450.00 (153.34) 5,850.00 4,553.34 77.8%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 - 1,500.00 (1,500.00) 1,641.05 1,716.00 (74.95) 2,292.00 650.95 28.4%6413796 Supplies-Bottled Water158.40 700.00 (541.60) 5,790.91 6,100.00 (309.09) 23,950.00 18,159.09 75.8%Total-CBR-SUPPLIES & MATERIALS529.63 3,750.00 (3,220.37) 8,823.17 9,891.00 (1,067.83) 41,387.00 32,563.83 78.7%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts 720.00 720.00 - 2,955.00 2,880.00 75.00 8,640.00 5,685.00 65.8%6415690 CBR-R&M-Equipment - 125.00 (125.00) - 500.00 (500.00) 1,500.00 1,500.00 100.0%6415695 CBR-R&M-Cart Maintenance & Repair - 500.00 (500.00) 1,431.23 2,000.00 (568.77) 4,000.00 2,568.77 64.2%Total-CBR-REPAIRS & MAINTENANCE 720.00 1,345.00 (625.00) 4,386.23 5,380.00 (993.77) 14,140.00 9,753.77 69.0%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps 45.00 400.00 (355.00) 1,630.00 700.00 930.00 5,000.00 3,370.00 67.4%6419094 Contract Services-Laundry/Linen - 500.00 (500.00) 1,423.61 2,000.00 (576.39) 6,000.00 4,576.39 76.3%6419220 Freight/Delivery - 75.00 (75.00) - 300.00 (300.00) 900.00 900.00 100.0%6419490 Miscellaneous - 75.00 (75.00) 88.80 350.00 (261.20) 1,150.00 1,061.20 92.3%6419820 Uniforms 1,200.00 2,500.00 (1,300.00) 1,200.00 2,500.00 (1,300.00) 5,625.00 4,425.00 78.7%Total-CBR-OTHER EXPENSES 1,245.00 3,550.00 (2,305.00) 4,342.41 5,850.00 (1,507.59) 18,675.00 14,332.59 76.7%TOTAL-CARTS,BAGROOM & RANGE 6,374.77 14,104.00 (7,729.23) 49,756.93 64,410.00 (14,653.07) 234,841.00 185,084.07 78.8%643-CS-SALARIES & BENEFITS6431175 Employee Meals 300.00 300.00 - 1,080.00 1,080.00 - 4,860.00 3,780.00 77.8%6431325 Insurance-Workers Comp 21.66 105.00 (83.34) 295.70 695.00 (399.30) 3,446.00 3,150.30 91.4%6431800 Taxes-Employer Payroll 72.61 159.00 (86.39) 1,024.98 1,056.00 (31.02) 5,220.00 4,195.02 80.4%6431880 Wages-Hourly 722.00 1,280.00 (558.00) 8,214.00 8,480.00 (266.00) 41,920.00 33,706.00 80.4%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS1,116.27 1,844.00 (727.73) 10,614.68 11,311.00 (696.32) 55,446.00 44,831.32 80.9%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) 2,094.12 300.00 1,794.12 1,050.00 (1,044.12) -99.4%6439490 Miscellaneous - 50.00 (50.00) - 50.00 (50.00) 200.00 200.00 100.0%6439718 Safety Equipment & Training 43.10 50.00 (6.90) 43.10 200.00 (156.90) 600.00 556.90 92.8%6439820 Uniforms 1,414.69 750.00 664.69 1,414.69 975.00 439.69 1,900.00 485.31 25.5%Total-CS-OTHER EXPENSES 1,457.79 950.00 507.79 3,551.91 1,525.00 2,026.91 3,750.00 198.09 5.3%Total-COURSE SERVICES 2,574.06 2,794.00 (219.94) 14,166.59 12,836.00 1,330.59 59,196.00 45,029.41 76.1%TOTAL OUTSIDE SERVICES 8,948.83 16,898.00 (7,949.17) 63,923.52 77,246.00 (13,322.48) 294,037.00 229,915.39 78.2%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementOctober 2008Annual Budget6 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 235.94 1,600.00 (1,364.06) 4,800.00 4,564.06 95.1%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 235.94 1,600.00 (1,364.06) 4,800.00 4,564.06 95.1%65-CH-UTILITIES6507836 Utilities-Natural Gas- 300.00 (300.00) 878.76 1,200.00 (321.24) 3,600.00 2,721.24 75.6%6507838 Utilities-Sewer- 200.00 (200.00) 600.00 800.00 (200.00) 2,400.00 1,800.00 75.0%6507840 Utilities-Telephone1,010.96 1,000.00 10.96 4,179.50 4,000.00 179.50 12,000.00 7,820.50 65.2%6507842 Utilities-Water676.36 200.00 476.36 1,691.95 800.00 891.95 2,400.00 708.05 29.5%6507844 Utilities-Cable333.04 317.00 16.04 1,207.89 1,268.00 (60.11) 3,804.00 2,596.11 68.2%Total-CH-UTILITIES 2,020.36 2,017.00 3.36 8,558.10 8,068.00 490.10 24,204.00 15,645.90 64.6%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning2,245.00 2,425.00 (180.00) 7,720.00 7,900.00 (180.00) 22,500.00 14,780.00 65.7%6509099 Contract Services-Security8,175.08 8,200.00 (24.92) 33,335.68 32,800.00 535.68 98,400.00 65,064.32 66.1%6509215 Flowers & Decorations- 100.00 (100.00) - 400.00 (400.00) 2,600.00 2,600.00 100.0%6509490 Miscellaneous- 200.00 (200.00) - 800.00 (800.00) 2,400.00 2,400.00 100.0%6509718 Safety Equipment & Training- 100.00 (100.00) - 400.00 (400.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES 10,731.82 11,025.00 (293.18) 42,614.38 42,300.00 314.38 127,100.00 84,485.62 66.5%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures1,248.00 200.00 1,048.00 1,831.00 800.00 1,031.00 2,400.00 569.00 23.7%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 1,249.83 1,600.00 (350.17) 4,800.00 3,550.17 74.0%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) - 1,600.00 (1,600.00) 4,800.00 4,800.00 100.0%Total-CH-REPAIRS & MAINTENANCE 1,248.00 1,000.00 248.00 3,080.83 4,000.00 (919.17) 12,000.00 8,919.17 74.3%Total CLUBHOUSE 14,000.18 14,442.00 (441.82) 54,489.25 55,968.00 (1,478.75) 168,104.00 17,838.34 10.6%Month to Date Year to DateSilverRock ResortClubhouse Expense StatementOctober 2008Annual 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 - 450.00 (450.00) 724.59 1,800.00 (1,075.41) 5,400.00 4,675.41 86.6%6601325 Insurance-Workers Comp 75.00 205.00 (130.00) 350.18 820.00 (469.82) 2,460.00 2,109.82 85.8%6601720 Salaries 2,500.00 2,500.00 - 10,000.00 10,000.00 - 30,000.00 20,000.00 66.7%6601800 Taxes-Employer Payroll 311.00 311.00 - 1,555.00 1,244.00 311.00 3,732.00 2,177.00 58.3%Total-MKT-SALARIES & BENEFITS 2,946.00 3,526.00 (580.00) 12,869.77 14,104.00 (1,234.23) 42,312.00 29,442.23 69.6%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 400.00 (400.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery 2,581.35 3,000.00 (418.65) 2,755.74 3,200.00 (444.26) 4,425.00 1,669.26 37.7%2,581.35 3,100.00 (518.65) 2,755.74 3,600.00 (844.26) 5,625.00 2,869.26 51.0%66-MKT-UTILITIES6607840 Utilities-Telephone 113.40 100.00 13.40 236.29 400.00 (163.71) 1,200.00 963.71 80.3%Total-MKT-UTILITIES 113.40 100.00 13.40 236.29 400.00 (163.71) 1,200.00 963.71 80.3%66-MKT-OTHER EXPENSES6609010 Advertising 17,033.00 14,587.00 2,446.00 55,361.19 48,508.00 6,853.19 225,134.00 169,772.81 75.4%6609040 Business Meals - 25.00 (25.00) - 100.00 (100.00) 300.00 300.00 100.0%6609080 Collateral Material 1,737.58 2,500.00 (762.42) 1,737.58 2,500.00 (762.42) 9,000.00 7,262.42 80.7%6609102 Contract Services-Web Page 99.00 175.00 (76.00) 297.00 700.00 (403.00) 2,100.00 1,803.00 85.9%6609490 Miscellaneous - - - - - - 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) 1.59 200.00 (198.41) 600.00 598.41 99.7%6609630 Promotion - 500.00 (500.00) 1,260.04 1,000.00 260.04 6,500.00 5,239.96 0.0%6609633 Promotion-Community - 750.00 (750.00) 36.33 975.00 (938.67) 2,925.00 2,888.67 98.8%6609634 Promotion-Media/Vendor - 50.00 (50.00) - 50.00 (50.00) 700.00 - 0.0%6609150 Dues and Subscriptions - - - 371.71 - 371.71 735.00 363.29 49.4%6609820 Uniforms - 300.00 (300.00) 38.41 300.00 (261.59) 600.00 561.59 93.6%Total-MKT-OTHER EXPENSES 18,869.58 18,937.00 (67.42) 59,103.85 54,333.00 4,770.85 248,944.00 189,140.15 76.0%Total-MARKETING 24,510.33 25,663.00 (1,152.67) 74,965.65 72,437.00 2,528.65 298,081.00 222,415.35 74.6%Month to Date Year to DateSilverRock ResortMarketing Expense StatementOctober 2008Annual 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,155.09 2,250.00 (1,094.91) 5,794.84 9,000.00 (3,205.16) 27,000.00 21,205.16 78.5%6701325 Insurance-Workers Comp484.65 1,406.00 (921.35) 2,383.21 5,624.00 (3,240.79) 16,872.00 14,488.79 85.9%6701720 Salaries 14,593.32 14,416.00 177.32 57,794.31 57,664.00 130.31 172,992.00 115,197.69 66.6%6701800 Taxes-Employer Payroll 1,152.46 2,135.00 (982.54) 5,223.73 8,540.00 (3,316.27) 25,620.00 20,396.27 79.6%6701880 Wages-Hourly1,561.66 2,730.00 (1,168.34) 9,240.06 10,920.00 (1,679.94) 32,760.00 23,519.94 71.8%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 19,127.18 23,117.00 (3,989.82) 81,156.15 92,468.00 (11,311.85) 277,404.00 196,247.85 70.7%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 800.00 (800.00) 349.09 3,200.00 (2,850.91) 10,800.00 10,450.91 96.8%6703762 Supplies-Office 496.83 125.00 371.83 1,162.05 500.00 662.05 1,500.00 337.95 22.5%6703768 Supplies-Printing & Stationery- 100.00 (100.00) 562.16 300.00 262.16 3,200.00 2,637.84 82.4%6703778Supplies-Small Tools/Non-Capital - 100.00 (100.00) - 200.00 (200.00) 900.00 900.00 100.0%Total-G&A-SUPPLIES & MATERIALS 496.83 1,125.00 (628.17) 2,073.30 4,200.00 (2,126.70) 16,400.00 14,326.70 87.4%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 223.21 400.00 (176.79) 1,200.00 976.79 81.4%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 223.21 400.00 (176.79) 1,200.00 976.79 81.4%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%6709090 Contract Services- - - - - - - - 0.0%6709150 Dues & Subscriptions- 50.00 (50.00) - 300.00 (300.00) 1,500.00 1,500.00 100.0%6709180 Employee Recruiting/Relocation56.00 1,000.00 (944.00) 140.00 2,000.00 (1,860.00) 4,600.00 4,460.00 97.0%6709197 Equipment Rental502.44 350.00 152.44 1,158.93 1,400.00 (241.07) 4,200.00 3,041.07 72.4%6709202 Fees-Bank20.00 90.00 (70.00) 70.00 360.00 (290.00) 1,080.00 1,010.00 93.5%6709208 Fees-Payroll Processing440.08 550.00 (109.92) 2,536.67 2,200.00 336.67 6,600.00 4,063.33 61.6%6709220 Freight/Delivery- 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6709490 Miscellaneous - 100.00 (100.00) 130.55 400.00 (269.45) 1,200.00 1,069.45 89.1%6709620 Postage/Mail Services 257.45 75.00 182.45 636.84 300.00 336.84 900.00 263.16 29.2%6709625 Professional Fees190.00 400.00 (210.00) 1,585.67 1,600.00 (14.33) 4,800.00 3,214.33 67.0%6709636 Promotion/Entertainment- 100.00 (100.00) 166.89 400.00 (233.11) 4,000.00 3,833.11 95.8%6709722 Seminars & Training- 200.00 (200.00) 250.00 800.00 (550.00) 2,400.00 2,150.00 89.6%6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms - 150.00 (150.00) 44.93 375.00 (330.07) 1,050.00 1,005.07 95.7%Total-G&A-OTHER EXPENSES 1,865.97 3,515.00 (1,649.03) 8,320.48 12,035.00 (3,714.52) 38,830.00 30,509.52 78.6%Total-GENERAL & ADMINISTRATIVE21,489.98 27,857.00 (6,367.02) 91,773.14 109,103.00 (17,329.86) 333,834.00 242,060.86 72.5%Month to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementOctober 2008Annual Budget9 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 8,036.95 11,581.00 (3,544.05) 42,780.07 46,324.00 (3,543.93) 138,972.00 96,191.93 69.2%6800193 Equipment Leases-Course Maint 16,838.41 20,000.00 (3,161.59) 65,570.77 80,000.00 (14,429.23) 240,000.00 174,429.23 72.7%6800194 Equipment Leases-Trailer 625.08 600.00 25.08 2,476.08 2,400.00 76.08 7,200.00 4,723.92 65.6%6800195 Equipment Leases-Software 1,791.93 1,525.00 266.93 7,167.72 6,100.00 1,067.72 18,300.00 11,132.28 60.8%6800196 Equipment Leases-GPS 6,840.14 7,400.00 (559.86) 27,360.56 29,600.00 (2,239.44) 88,800.00 61,439.44 69.2%6800197 Equipment Leases-Others 11,484.98 - 11,484.98 20,513.16 - 20,513.16 - - 0.0%Total-LEASES 45,617.49 41,106.00 4,511.49 165,868.36 164,424.00 1,444.36 493,272.00 347,916.80 70.5%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 20,266.49 9,370.00 10,896.49 68,655.10 73,657.00 (5,001.90) 90,000.00 21,344.90 23.7%6900210 FF&E Reserve 800.58 1,267.00 (466.42) 7,903.50 9,664.00 (1,760.50) 75,140.00 67,236.50 89.5%6900800 Personal Property Taxes - - - 20,812.13 - 20,812.13 20,000.00 (812.13) -4.1%6900323 Insurance-Commercial - 3,500.00 (3,500.00) 500.00 14,000.00 (13,500.00) 42,000.00 41,500.00 98.8%Total-MISC OTHER EXPENSES21,067.07 14,137.00 6,930.07 97,870.73 97,321.00 549.73 227,140.00 129,269.27 56.9% Operating Leases & Miscellaneous Other Expense StatementOctober 2008Annual BudgetMonth to Date Year to Date10 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2008-20092008 2008 2008 2008 2008 2008Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia6182Sales4PromotionGolf Industry11 16 5 5VIPCelebrityPGA Comp82 48 84 24Charity/Gift Certificate14 6 3Rain/Wind Checks6612Club Staff137 116 113 21LQ HS Golf256 193 214 58 0 02009 2009 2009 2009 2009 2009Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2008-2009October 2008Date Time Description CategoryPlayers10/4/2008 7:07 Pete Downs - Spotlight 29 Casino Sales 410/4/2008 8:00 Shawn Royster - Golf Show Producer Media 212