Loading...
03 September 2008 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2008 – September 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 September Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 132,020.25 164,572.00 (32,551.75) -19.8% 298,615.75 348,008.00 (49,392.25) 3,255,761.00 2,957,145.25 9%401000 Miscellaneous Golf Revenue 5,169.50 6,363.00 (1,193.50) -18.8% 13,330.50 18,162.00 (4,831.50) 113,217.00 99,886.50 12%410000 Revenue-Golf Shop 22,929.12 22,751.00 178.12 0.8% 42,422.94 52,151.00 (9,728.06) 375,951.00 333,528.06 11%420000 Revenue-F&B Concession 500.00 500.00 - 0.0% 1,500.00 1,500.00 - 12,000.00 10,500.00 13%890000 Interest Income 8.32 - 8.32 0.0% 30.32 - 30.32 - (30.32) 0%Total Income160,627.19 194,186.00 (33,558.81) -17.3% 355,899.51 419,821.00 (63,921.49) 3,756,929.00 3,401,029.49 9%Cost of Goods Sold510000 COS-Golf Shop 12,725.34 12,074.00 651.34 -5.4% 23,385.31 27,678.00 4,292.69 199,538.00 176,152.69 12%Total COS12,725.34 12,074.00 651.34 -5.4% 23,385.31 27,678.00 4,292.69 199,538.00 176,152.69 12%Gross Profit147,901.85 182,112.00 (34,210.15) -18.8% 332,514.20 392,143.00 (59,628.80) 3,557,391.00 3,224,876.80 9%Expenses610000 Golf Pro Shop 16,573.19 23,054.00 6,480.81 28.1% 56,187.87 64,210.00 8,022.13 279,518.00 223,330.13 20%630000 Course Maintenance 140,918.53 153,768.00 12,849.47 8.4% 416,981.90 431,395.00 14,413.10 1,805,855.00 1,388,873.10 23%640000 Outside Services 17,612.26 20,676.00 3,063.74 14.8% 54,974.69 60,348.00 5,373.31 294,037.00 239,062.31 19%650000 Clubhouse 14,016.28 13,842.00 (174.28) -1.3% 40,489.07 41,526.00 1,036.93 168,104.00 127,614.93 24%660000 Marketing 20,740.78 24,158.00 3,417.22 14.1% 50,455.32 46,774.00 (3,681.32) 298,081.00 247,625.68 17%670000 General & Administrative 23,064.69 27,932.00 4,867.31 17.4% 70,283.16 81,246.00 10,962.84 333,834.00 263,550.84 21%680000 Leases 40,094.92 41,106.00 1,011.08 2.5% 120,250.87 123,318.00 3,067.13 493,272.00 373,021.13 24%690000 Miscellaneous Other Expense 19,899.29 19,778.00 (121.29) -0.6% 76,803.66 83,184.00 6,380.34 227,140.00 150,336.34 34%Total Expenses292,919.94 324,314.00 31,394.06 9.7% 886,426.54 932,001.00 45,574.46 3,899,841.00 3,013,414.46 23%Net Income (145,018.09) (142,202.00) (2,816.09) -2.0%(553,912.34) (539,858.00) (14,054.34) (342,450.00) 211,462.34 162%Rounds of Golf PlayedPaid Rounds Played 2,924 3,364 (440) -13.1% 7,076 7,672 (596) 40,580 33,504 17%Ave $ Per Paid Round Green Fee 45.15 48.92 (3.77) -7.7% 42.20 45.36 (3.16) 77.90 35.70 54%Ave $ Per Paid Round Merchandise 7.84 6.76 1.08 15.9% 6.00 6.80 (0.80) 8.07 2.07 74%Ave $ Per Paid Miscellaneous 1.77 1.89 (0.13) -6.6% 1.88 2.37 (0.48) 2.06 - 0%Month to Date Year to DateSeptember 2008SilverRock ResortSummary Operating Income Statement1 Income September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 132,020.25 164,572.00 (32,551.75) 298,615.75 348,008.00 (49,392.25) 3,255,761.002,957,145.259%4010000 Rider Fee 1,225.00 325.00 900.00 1,750.00 2,614.00 (864.00) 5,984.004,234.0029%4040000 Club Rental 900.00 1,788.00 (888.00) 2,910.00 4,098.00 (1,188.00) 27,583.0024,673.0011%4050000 Driving Range 2,811.00 3,250.00 (439.00) 6,657.00 7,450.00 (793.00) 46,650.0039,993.0014%4060000 Handicap Fees - - - 205.00 - 205.00 8,000.00 7,795.003%4080000 GPS Advertising - 1,000.00 (1,000.00) 1,575.00 3,000.00 (1,425.00) 12,000.00 10,425.0013%4090000 Ball Retriever/Subcontract - - - - 1,000.00 (1,000.00) 4,000.00 4,000.000%4091000 Golf Professional Rental Fee - - - - - - 9,000.00 9,000.00 0%4092000 Golf Lessons 233.50 - 233.50 233.50 - 233.50 - (233.50) 0% Total Revenue Fees 137,189.75 170,935.00 (33,745.25) 311,946.25 366,170.00 (54,223.75) 3,368,978.00 3,057,031.75 9%Total Income 137,189.75 170,935.00 (33,745.25) 311,946.25 366,170.00 (54,223.75) 3,368,978.00 3,057,031.75 9%SilverRock ResortStatement of Fees RevenueSeptember 2008Month to Date Year to Date Annual Budget2 Income September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 878.01 - 878.01 2,279.66 - 2,279.66 4100110 Sales Hard Goods 16,230.10 7,963.00 8,267.10 24,589.13 18,253.00 6,336.13 131,583.00 106,993.87 19%4100112 Sales-Soft Goods 11,364.51 14,788.00 (3,423.49) 24,605.85 33,898.00 (9,292.15) 244,368.00 219,762.15 10%5100639 GS-Discounts-Mdse (5,543.50) - (5,543.50) (9,051.70) - (9,051.70) - 9,051.70 0% Total Revenue Golf Shop 22,929.12 22,751.00 178.12 42,422.94 52,151.00 (9,728.06) 375,951.00 335,807.72 11%COS 5100150 COS-GS-Hard Goods 8,558.53 4,379.00 4,179.53 13,298.71 10,039.00 3,259.71 72,373.00 59,074.29 18%5100151 COS-GS-Soft Goods 4,039.86 8,133.00 (4,093.14) 9,796.73 18,643.00 (8,846.27) 134,404.00 124,607.27 7%5100152 COS-GS-Purchase Disc - (626.00) 626.00 13.68 (1,434.00) 1,447.68 (10,341.00) (10,354.68) 0%5100220 COS-GS-Freight Merch 126.95 188.00 (61.05) 276.19 430.00 (153.81) 3,102.00 2,825.81 9%Cost of Sales - Golf Shop 12,725.34 12,074.00 651.34 23,385.31 27,678.00 (4,292.69) 199,538.00 176,152.69 12%Gross Profit 10,203.78 10,677.00 (473.22) 19,037.63 24,473.00 (5,435.37) 176,413.00 159,655.03 9%COS % 55.5% 53.1% -2.4% 55.1% 53.1% -2.1% 53.1% 52.5% 1%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 420.00 420.00 - 1,140.00 1,140.00 - 5,400.00 4,260.00 21%6101320 Insurance Group 2,026.03 2,700.00 (673.97) 8,239.93 8,100.00 139.93 36,450.00 28,210.07 23%6101325 Insurance-Workers Comp 365.93 1,204.00 (838.07) 1,379.27 3,392.00 (2,012.73) 14,771.00 13,391.73 9%6101720 Salaries 7,122.66 6,082.00 1,040.66 18,054.31 18,246.00 (191.69) 71,459.00 53,404.69 25%6101800 Taxes-Employer Payroll 528.56 1,828.00 (1,299.44) 2,649.65 5,150.00 (2,500.35) 22,431.00 19,781.35 12%6101880 Wages-Hourly 5,040.97 8,600.00 (3,559.03) 20,215.21 23,122.00 (2,906.79) 108,712.00 88,496.79 19%6101882 Wages-Overtime 33.84 - 33.84 192.31 - 192.31 - 952.88 0%Total -PS-SALARIES & BENEFITS 15,537.99 20,834.00 (5,296.01) 51,870.68 59,150.00 (7,279.32) 259,223.00 208,497.51 20%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 283.14 300.00 (16.86) 1,396.00 900.00 496.00 2,950.00 1,554.00 47%6109090 Contract Services 500.00 500.00 - 1,500.00 1,500.00 - 6,000.00 4,500.00 25%6109220 Freight & Delivery - - - 131.10 - 131.10 75.00 (56.10) 175%6109490 Miscellaneous - - - - - - 450.00 450.00 0%6109150 Dues and Subscriptions - - - 51.53 - 51.53 2,000.00 1,948.47 3%6109500 ProShop-Over/Short 50.51 - 50.51 125.74 - 125.74 (125.74) 0%6109722 Seminars/Training - 1,250.00 (1,250.00) 555.00 2,150.00 (1,595.00) 5,490.00 4,935.00 10%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms 64.06 100.00 (35.94) 145.09 300.00 (154.91) 2,400.00 2,254.91 6%6117840 Telephones 137.49 70.00 67.49 412.73 210.00 202.73 840.00 427.27 0%Total PS-OTHER EXPENSES 1,035.20 2,220.00 (1,184.80) 4,317.19 5,060.00 (742.81) 20,295.00 15,977.81 21%Total Expenses16,573.19 23,054.00 (6,480.81) 56,187.87 64,210.00 (8,022.13) 279,518.00 224,475.32 20%Net Income(6,369.41) (12,377.00) 6,007.59 (37,150.24) (39,737.00) 2,586.76 (103,105.00) (64,820.29) -37%Month to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementSeptember 20083 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 720.00 720.00 - 2,880.00 2,160.00 75.0%6311320 Insurance-Group 9,407.39 12,083.00 (2,675.61) 38,673.26 36,249.00 2,424.26 144,996.00 106,322.74 73.3%6311325 Insurance-Workers Comp 1,722.76 4,841.00 (3,118.24) 6,476.76 14,523.00 (8,046.24) 59,020.00 52,543.24 89.0%6311720 Salaries 11,833.80 12,331.00 (497.20) 36,115.20 36,993.00 (877.80) 147,978.00 111,862.80 75.6%6311800 Taxes-Employer Payroll 4,755.29 7,350.00 (2,594.71) 14,451.18 22,050.00 (7,598.82) 90,311.00 75,859.82 84.0%6311880 Wages-Hourly 45,171.05 46,708.00 (1,536.95) 136,370.46 140,124.00 (3,753.54) 560,520.00 424,149.54 75.7%6311882 Wages-Overtime 420.46 - 420.46 2,319.49 - 2,319.49 16,894.00 14,574.51 86.3%Total-CM-SALARIES & BENEFITS73,550.75 83,553.00 (10,002.25) 235,126.35 250,659.00 (15,532.65) 1,022,599.00 787,472.65 77.0%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 4,258.81 2,000.00 2,258.81 9,625.93 5,400.00 4,225.93 25,200.00 15,574.07 61.8%6313744 Fertilizer 6,365.83 9,600.00 (3,234.17) 24,039.48 26,600.00 (2,560.52) 95,200.00 71,160.52 74.7%6313746 Flowers/Plants 808.12 1,000.00 (191.88) 808.12 1,000.00 (191.88) 3,500.00 2,691.88 76.9%6313748 Fuel-Gasoline 3,880.60 3,740.00 140.60 10,902.70 11,220.00 (317.30) 45,540.00 34,637.30 76.1%6313750 Golf Course Accessories 113.14 200.00 (86.86) 347.68 600.00 (252.32) 7,000.00 6,652.32 95.0%6313756 POA Control 196.56 - 196.56 637.41 - 637.41 6,000.00 5,362.59 89.4%6313758 Miscellaneous Supp 528.16 100.00 428.16 1,978.39 300.00 1,678.39 - (1,978.39) 0.0%6313762 Supplies-Office 24.56 - 24.56 95.64 - 95.64 1,200.00 1,104.36 92.0%6313774 Sand - - - 1,885.71 780.00 1,105.71 6,660.00 4,774.29 71.7%6313775 Sand-Bunkers 3,702.67 5,000.00 (1,297.33) 3,702.67 5,000.00 (1,297.33) 5,000.00 1,297.33 25.9%6313776 Seed - 250.00 (250.00) 848.53 950.00 (101.47) 101,810.00 100,961.47 99.2%6313778 Small Tools & Non-Capital Equip 2,819.69 3,000.00 (180.31) 2,993.36 3,200.00 (206.64) 7,000.00 4,006.64 57.2%6313780 Sod 645.94 1,000.00 (354.06) 5,159.85 3,000.00 2,159.85 5,750.00 590.15 10.3%6313782 Topdressing - - - 2,150.43 2,500.00 (349.57) 7,600.00 5,449.57 71.7%Total-CM-SUPPLIES & MATERIALS23,344.08 25,890.00 (2,545.92) 65,175.90 60,550.00 4,625.90 317,460.00 252,284.10 79.5%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,509.87 1,500.00 1,009.87 4,669.99 4,500.00 169.99 16,000.00 11,330.01 70.8%6315685 CM-R&M-Bldngs & Othr Structures 207.00 - 207.00 453.50 - 453.50 500.00 46.50 9.3%6315690 CM-R&M-Equipment 4,951.89 4,400.00 551.89 12,956.73 13,200.00 (243.27) 46,100.00 33,143.27 71.9%6315692 CM-R&M-Irrigation System 2,213.73 2,200.00 13.73 7,406.45 5,800.00 1,606.45 15,450.00 8,043.55 52.1%6315696 CM-R&M-Pumps 1,876.18 1,000.00 876.18 1,953.18 3,000.00 (1,046.82) 10,500.00 8,546.82 81.4%6315815 CM-R&M-Trees-Pruning Etc 3,500.00 - 3,500.00 3,500.00 - 3,500.00 9,000.00 5,500.00 61.1%Total-CM-REPAIRS & MAINTENANCE 15,258.67 9,100.00 6,158.67 30,939.85 26,500.00 4,439.85 97,550.00 66,610.15 68.3%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs 5.38 - 5.38 10.76 - 10.76 - (10.76) 0.0%6317836 Utilities-Natural Gas/LPG - 150.00 (150.00) - 450.00 (450.00) 1,800.00 1,800.00 0.0%6317840 Telephones 866.58 800.00 66.58 2,588.91 2,400.00 188.91 9,600.00 7,011.09 73.0%Total-CM-UTILITIES 871.96 950.00 (78.04) 2,599.67 2,850.00 (250.33) 11,400.00 8,800.33 77.2%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 1,500.00 1,500.00 - 6,000.00 4,500.00 75.0%6319100 Contract Svcs-Soil/Tissue Test 1,500.00 2,000.00 (500.00) 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,435.01 - 1,435.01 - (1,435.01) 0.0%6319150 Dues & Subscriptions 210.00 - 210.00 245.00 200.00 45.00 900.00 655.00 72.8%6319170 Employee Education - 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6319197 Equipment Rental - 150.00 (150.00) - 500.00 (500.00) 4,200.00 4,200.00 100.0%6319206 Licenses & Permits 60.00 - 60.00 60.00 200.00 (140.00) 1,600.00 1,540.00 96.3%6319490 Miscellaneous 143.02 100.00 43.02 143.02 300.00 (156.98) 1,200.00 1,056.98 88.1%6319718 Safety Equipment & Training 853.93 1,700.00 (846.07) 1,203.18 1,900.00 (696.82) 3,400.00 2,196.82 64.6%6319822 Uniforms 589.90 820.00 (230.10) 1,944.35 2,460.00 (515.65) 9,840.00 7,895.65 80.2%Total-CM-OTHER EXPENSES 4,380.90 5,320.00 (939.10) 8,030.56 9,210.00 (1,179.44) 31,740.00 23,709.44 74.7%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementSeptember 2008Annual Budget4 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,104.00 1,104.00 - 3,312.00 3,312.00 - 13,248.00 9,936.00 75.0%6321325 Insurance-Workers Comp 381.88 1,127.00 (745.12) 1,434.33 3,283.00 (1,848.67) 13,257.00 11,822.67 89.2%6321800 Taxes-Employer Payroll 712.47 1,749.00 (1,036.53) 2,607.69 5,021.00 (2,413.31) 20,368.00 17,760.31 87.2%6321880 Wages-Hourly 12,704.06 13,141.00 (436.94) 40,118.42 39,423.00 695.42 157,692.00 117,573.58 74.6%6321882 Wages-Overtime 25.24 910.00 (884.76) 359.30 910.00 (550.70) 5,915.00 5,555.70 93.9%Total-CM-LM-SALARIES & BENEFITS14,927.65 18,031.00 (3,103.35) 47,831.74 51,949.00 (4,117.26) 210,480.00 162,648.26 77.3%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools 253.85 100.00 153.85 253.85 300.00 (46.15) 1,025.00 771.15 75.2%6323788 Uniforms 267.72 290.00 (22.28) 843.49 870.00 (26.51) 3,480.00 2,636.51 75.8%Total-CM-LM-SUPPLIES & MATERIALS521.57 390.00 131.57 1,097.34 1,170.00 (72.66) 4,505.00 3,407.66 75.6%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation 136.12 500.00 (363.88) 136.12 1,000.00 (863.88) 4,250.00 4,113.88 96.8%Total-CM-LM-REPAIRS & MAINTENANCE 136.12 500.00 (363.88) 136.12 1,000.00 (863.88) 4,250.00 4,113.88 96.8%632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 4,639.61 7,000.00 (2,360.39) 15,242.65 21,000.00 (5,757.35) 84,000.00 68,757.35 81.9%6337842 Utilities-Water3,287.22 3,034.00 253.22 10,801.72 6,507.00 4,294.72 21,871.00 11,069.28 50.6%Total-CM-WATER & ENERGY7,926.83 10,034.00 (2,107.17) 26,044.37 27,507.00 (1,462.63) 105,871.00 79,826.63 75.4%140,918.53 153,768.00 (12,849.47) 416,981.90 431,395.00 (14,413.10) 1,805,855.00 1,388,873.10 76.9%Total -COURSE MAINTENANCEMonth to Date Year to DateSilverrock ResortCourse Maintenance Expense StatementSeptember 2008Annual Budget5 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 420.00 420.00 - 1,260.00 1,260.00 - 6,180.00 4,920.00 79.6%6411320 Insurance-Group 9.10 720.00 (710.90) 144.60 2,160.00 (2,015.40) 8,640.00 8,495.40 98.3%6411325 Insurance-Workers Comp 223.81 1,290.00 (1,066.19) 889.79 3,896.00 (3,006.21) 16,511.00 15,621.21 94.6%6411800 Taxes-Employer Payroll 890.67 1,119.00 (228.33) 2,577.18 3,379.00 (801.82) 14,318.00 11,740.82 82.0%6411880 Wages-Hourly 7,381.38 8,985.00 (1,603.62) 23,345.04 27,135.00 (3,789.96) 114,990.00 91,644.96 79.7%6411882 Wages-Overtime 78.94 - 78.94 108.37 - 108.37 - (108.37) 0.0%Total-CBR-SALARIES & BENEFITS9,003.90 12,534.00 (3,530.10) 28,324.98 37,830.00 (9,505.02) 160,639.00 132,314.02 82.4%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - - - 94.55 - 94.55 2,350.00 2,255.45 96.0%6413742 Supplies-Expendable 168.78 150.00 18.78 925.43 450.00 475.43 5,850.00 4,924.57 84.2%6413752 Supplies-Range Balls - - - - - - 6,000.00 6,000.00 100.0%6413762 Supplies-Office - 25.00 (25.00) - 75.00 (75.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels 108.74 72.00 36.74 1,641.05 216.00 1,425.05 2,292.00 650.95 28.4%6413796 Supplies-Bottled Water1,021.25 1,800.00 (778.75) 5,632.51 5,400.00 232.51 23,950.00 18,317.49 76.5%Total-CBR-SUPPLIES & MATERIALS1,298.77 2,047.00 (748.23) 8,293.54 6,141.00 2,152.54 41,387.00 33,093.46 80.0%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts 720.00 720.00 - 2,235.00 2,160.00 75.00 8,640.00 6,405.00 74.1%6415690 CBR-R&M-Equipment - 125.00 (125.00) - 375.00 (375.00) 1,500.00 1,500.00 100.0%6415695 CBR-R&M-Cart Maintenance & Repair - 500.00 (500.00) 1,431.23 1,500.00 (68.77) 4,000.00 2,568.77 64.2%Total-CBR-REPAIRS & MAINTENANCE 720.00 1,345.00 (625.00) 3,666.23 4,035.00 (368.77) 14,140.00 10,473.77 74.1%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps 115.00 100.00 15.00 1,585.00 300.00 1,285.00 5,000.00 3,415.00 68.3%6419094 Contract Services-Laundry/Linen 1,423.61 500.00 923.61 1,423.61 1,500.00 (76.39) 6,000.00 4,576.39 76.3%6419220 Freight/Delivery - 75.00 (75.00) - 225.00 (225.00) 900.00 900.00 100.0%6419490 Miscellaneous - 75.00 (75.00) 88.80 275.00 (186.20) 1,150.00 1,061.20 92.3%6419820 Uniforms - - - - - - 5,625.00 5,625.00 100.0%Total-CBR-OTHER EXPENSES 1,538.61 750.00 788.61 3,097.41 2,300.00 797.41 18,675.00 15,577.59 83.4%TOTAL-CARTS,BAGROOM & RANGE 12,561.28 16,676.00 (4,114.72) 43,382.16 50,306.00 (6,923.84) 234,841.00 191,458.84 81.5%643-CS-SALARIES & BENEFITS6431175 Employee Meals 300.00 300.00 - 780.00 780.00 - 4,860.00 4,080.00 84.0%6431325 Insurance-Workers Comp 75.42 236.00 (160.58) 274.04 590.00 (315.96) 3,446.00 3,171.96 92.0%6431800 Taxes-Employer Payroll 306.52 359.00 (52.48) 952.37 897.00 55.37 5,220.00 4,267.63 81.8%6431880 Wages-Hourly 2,514.00 2,880.00 (366.00) 7,492.00 7,200.00 292.00 41,920.00 34,428.00 82.1%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS3,195.94 3,775.00 (579.06) 9,498.41 9,467.00 31.41 55,446.00 45,947.59 82.9%643-CS-OTHER EXPENSES6433742 Supplies Expendable 1,855.04 100.00 1,755.04 2,094.12 200.00 1,894.12 1,050.00 (1,044.12) -99.4%6439490 Miscellaneous - - - - - - 200.00 200.00 100.0%6439718 Safety Equipment & Training - 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6439820 Uniforms - 75.00 (75.00) - 225.00 (225.00) 1,900.00 1,900.00 100.0%Total-CS-OTHER EXPENSES 1,855.04 225.00 1,630.04 2,094.12 575.00 1,519.12 3,750.00 1,655.88 44.2%Total-COURSE SERVICES 5,050.98 4,000.00 1,050.98 11,592.53 10,042.00 1,550.53 59,196.00 47,603.47 80.4%TOTAL OUTSIDE SERVICES 17,612.26 20,676.00 (3,063.74) 54,974.69 60,348.00 (5,373.31) 294,037.00 237,406.43 80.7%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementSeptember 2008Annual Budget6 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 235.94 1,200.00 (964.06) 4,800.00 4,564.06 95.1%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 235.94 1,200.00 (964.06) 4,800.00 4,564.06 95.1%65-CH-UTILITIES6507836 Utilities-Natural Gas246.24 300.00 (53.76) 878.76 900.00 (21.24) 3,600.00 2,721.24 75.6%6507838 Utilities-Sewer- 200.00 (200.00) 600.00 600.00 - 2,400.00 1,800.00 75.0%6507840 Utilities-Telephone1,023.67 1,000.00 23.67 3,168.54 3,000.00 168.54 12,000.00 8,831.46 73.6%6507842 Utilities-Water391.89 200.00 191.89 1,015.59 600.00 415.59 2,400.00 1,384.41 57.7%6507844 Utilities-Cable333.04 317.00 16.04 874.85 951.00 (76.15) 3,804.00 2,929.15 77.0%Total-CH-UTILITIES 1,994.84 2,017.00 (22.16) 6,537.74 6,051.00 486.74 24,204.00 17,666.26 73.0%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 5,475.00 5,475.00 - 22,500.00 17,025.00 75.7%6509099 Contract Services-Security8,717.76 8,200.00 517.76 25,160.60 24,600.00 560.60 98,400.00 73,239.40 74.4%6509215 Flowers & Decorations- 100.00 (100.00) - 300.00 (300.00) 2,600.00 2,600.00 100.0%6509490 Miscellaneous- 200.00 (200.00) - 600.00 (600.00) 2,400.00 2,400.00 100.0%6509718 Safety Equipment & Training- 100.00 (100.00) - 300.00 (300.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES 10,854.50 10,425.00 429.50 31,882.56 31,275.00 607.56 127,100.00 95,217.44 74.9%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures196.50 200.00 (3.50) 583.00 600.00 (17.00) 2,400.00 1,817.00 75.7%6515686 CH-R&M-Restaurant Repairs970.44 400.00 570.44 1,249.83 1,200.00 49.83 4,800.00 3,550.17 74.0%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) - 1,200.00 (1,200.00) 4,800.00 4,800.00 100.0%Total-CH-REPAIRS & MAINTENANCE 1,166.94 1,000.00 166.94 1,832.83 3,000.00 (1,167.17) 12,000.00 10,167.17 84.7%Total CLUBHOUSE 14,016.28 13,842.00 174.28 40,489.07 41,526.00 (1,036.93) 168,104.00 20,334.34 12.1%Month to Date Year to DateSilverRock ResortClubhouse Expense StatementSeptember 2008Annual Budget7 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 180.00 180.00 - 720.00 540.00 75.0%6601320 Insurance-Group 313.59 450.00 (136.41) 724.59 1,350.00 (625.41) 5,400.00 4,675.41 86.6%6601325 Insurance-Workers Comp 75.09 205.00 (129.91) 275.18 615.00 (339.82) 2,460.00 2,184.82 88.8%6601720 Salaries 2,500.00 2,500.00 - 7,500.00 7,500.00 - 30,000.00 22,500.00 75.0%6601800 Taxes-Employer Payroll 622.00 311.00 311.00 1,244.00 933.00 311.00 3,732.00 2,488.00 66.7%Total-MKT-SALARIES & BENEFITS 3,570.68 3,526.00 44.68 9,923.77 10,578.00 (654.23) 42,312.00 32,388.23 76.5%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 300.00 (300.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery 174.39 200.00 (25.61) 174.39 200.00 (25.61) 4,425.00 4,250.61 96.1%174.39 300.00 (125.61) 174.39 500.00 (325.61) 5,625.00 5,450.61 96.9%66-MKT-UTILITIES6607840 Utilities-Telephone 49.01 100.00 (50.99) 122.89 300.00 (177.11) 1,200.00 1,077.11 89.8%Total-MKT-UTILITIES 49.01 100.00 (50.99) 122.89 300.00 (177.11) 1,200.00 1,077.11 89.8%66-MKT-OTHER EXPENSES6609010 Advertising 16,847.70 19,407.00 (2,559.30) 38,328.19 33,921.00 4,407.19 225,134.00 186,805.81 83.0%6609040 Business Meals - 25.00 (25.00) - 75.00 (75.00) 300.00 300.00 100.0%6609080 Collateral Material - - - - - - 9,000.00 9,000.00 100.0%6609102 Contract Services-Web Page 99.00 175.00 (76.00) 198.00 525.00 (327.00) 2,100.00 1,902.00 90.6%6609490 Miscellaneous - - - - - - 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) 1.59 150.00 (148.41) 600.00 598.41 99.7%6609630 Promotion - 500.00 (500.00) 1,260.04 500.00 760.04 6,500.00 5,239.96 0.0%6609633 Promotion-Community - 75.00 (75.00) 36.33 225.00 (188.67) 2,925.00 2,888.67 98.8%6609634 Promotion-Media/Vendor - - - - - - 700.00 - 0.0%6609150 Dues and Subscriptions - - - 371.71 - 371.71 735.00 363.29 49.4%6609820 Uniforms - - - 38.41 - 38.41 600.00 561.59 93.6%Total-MKT-OTHER EXPENSES 16,946.70 20,232.00 (3,285.30) 40,234.27 35,396.00 4,838.27 248,944.00 208,009.73 83.6%Total-MARKETING 20,740.78 24,158.00 (3,417.22) 50,455.32 46,774.00 3,681.32 298,081.00 246,925.68 82.8%Month to Date Year to DateSilverRock ResortMarketing Expense StatementSeptember 2008Annual Budget8 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 540.00 540.00 - 2,160.00 1,620.00 75.0%6701320 Insurance-Group971.55 2,250.00 (1,278.45) 4,639.75 6,750.00 (2,110.25) 27,000.00 22,360.25 82.8%6701325 Insurance-Workers Comp544.04 1,406.00 (861.96) 1,898.56 4,218.00 (2,319.44) 16,872.00 14,973.44 88.7%6701720 Salaries 14,394.35 14,416.00 (21.65) 43,200.99 43,248.00 (47.01) 172,992.00 129,791.01 75.0%6701800 Taxes-Employer Payroll 1,182.20 2,135.00 (952.80) 4,071.27 6,405.00 (2,333.73) 25,620.00 21,548.73 84.1%6701880 Wages-Hourly2,650.25 2,730.00 (79.75) 7,678.40 8,190.00 (511.60) 32,760.00 25,081.60 76.6%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 19,922.39 23,117.00 (3,194.61) 62,028.97 69,351.00 (7,322.03) 277,404.00 215,375.03 77.6%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer175.00 800.00 (625.00) 349.09 2,400.00 (2,050.91) 10,800.00 10,450.91 96.8%6703762 Supplies-Office 288.07 125.00 163.07 665.22 375.00 290.22 1,500.00 834.78 55.7%6703768 Supplies-Printing & Stationery81.83 100.00 (18.17) 562.16 200.00 362.16 3,200.00 2,637.84 82.4%6703778Supplies-Small Tools/Non-Capital - 100.00 (100.00) - 100.00 (100.00) 900.00 900.00 100.0%Total-G&A-SUPPLIES & MATERIALS 544.90 1,125.00 (580.10) 1,576.47 3,075.00 (1,498.53) 16,400.00 14,823.53 90.4%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 223.21 300.00 (76.79) 1,200.00 976.79 81.4%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 223.21 300.00 (76.79) 1,200.00 976.79 81.4%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 1,200.00 1,200.00 - 4,800.00 3,600.00 75.0%6709090 Contract Services- - - - - - - - 0.0%6709150 Dues & Subscriptions- 200.00 (200.00) - 250.00 (250.00) 1,500.00 1,500.00 100.0%6709180 Employee Recruiting/Relocation- 1,000.00 (1,000.00) 84.00 1,000.00 (916.00) 4,600.00 4,516.00 98.2%6709197 Equipment Rental252.80 350.00 (97.20) 656.49 1,050.00 (393.51) 4,200.00 3,543.51 84.4%6709202 Fees-Bank20.00 90.00 (70.00) 50.00 270.00 (220.00) 1,080.00 1,030.00 95.4%6709208 Fees-Payroll Processing979.40 550.00 429.40 2,096.59 1,650.00 446.59 6,600.00 4,503.41 68.2%6709220 Freight/Delivery- 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6709490 Miscellaneous 13.25 100.00 (86.75) 130.55 300.00 (169.45) 1,200.00 1,069.45 89.1%6709620 Postage/Mail Services 121.94 75.00 46.94 379.39 225.00 154.39 900.00 520.61 57.8%6709625 Professional Fees475.00 400.00 75.00 1,395.67 1,200.00 195.67 4,800.00 3,404.33 70.9%6709636 Promotion/Entertainment85.01 100.00 (14.99) 166.89 300.00 (133.11) 4,000.00 3,833.11 95.8%6709722 Seminars & Training250.00 200.00 50.00 250.00 600.00 (350.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 - 75.00 (75.00) 44.93 225.00 (180.07) 1,050.00 1,005.07 95.7%Total-G&A-OTHER EXPENSES 2,597.40 3,590.00 (992.60) 6,454.51 8,520.00 (2,065.49) 38,830.00 32,375.49 83.4%Total-GENERAL & ADMINISTRATIVE23,064.69 27,932.00 (4,867.31) 70,283.16 81,246.00 (10,962.84) 333,834.00 263,550.84 78.9%Month to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementSeptember 2008Annual Budget9 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,581.04 11,581.00 0.04 34,743.12 34,743.00 0.12 138,972.00 104,228.88 75.0%6800193 Equipment Leases-Course Maint 16,244.12 20,000.00 (3,755.88) 48,732.36 60,000.00 (11,267.64) 240,000.00 191,267.64 79.7%6800194 Equipment Leases-Trailer 617.00 600.00 17.00 1,851.00 1,800.00 51.00 7,200.00 5,349.00 74.3%6800195 Equipment Leases-Software 1,791.93 1,525.00 266.93 5,375.79 4,575.00 800.79 18,300.00 12,924.21 70.6%6800196 Equipment Leases-GPS 6,840.14 7,400.00 (559.86) 20,520.42 22,200.00 (1,679.58) 88,800.00 68,279.58 76.9%6800197 Equipment Leases-Others 3,020.69 - 3,020.69 9,028.18 - 9,028.18 - - 0.0%Total-LEASES 40,094.92 41,106.00 (1,011.08) 120,250.87 123,318.00 (3,067.13) 493,272.00 382,049.31 77.5%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 7,070.12 12,394.00 (5,323.88) 48,388.61 64,287.00 (15,898.39) 90,000.00 41,611.39 46.2%6900210 FF&E Reserve 3,197.71 3,884.00 (686.29) 7,102.92 8,397.00 (1,294.08) 75,140.00 68,037.08 90.5%6900800 Personal Property Taxes 9,631.46 - 9,631.46 20,812.13 - 20,812.13 20,000.00 (812.13) -4.1%6900323 Insurance-Commercial - 3,500.00 (3,500.00) 500.00 10,500.00 (10,000.00) 42,000.00 41,500.00 98.8%Total-MISC OTHER EXPENSES19,899.29 19,778.00 121.29 76,803.66 83,184.00 (6,380.34) 227,140.00 150,336.34 66.2%Annual BudgetMonth to Date Year to Date Operating Leases & Miscellaneous Other Expense StatementSeptember 200810 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2008-20092008 2008 2008 2008 2008 2008Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia618SalesPromotionGolf Industry11 16 5VIPCelebrityPGA Comp82 48 84Charity/Gift Certificate14 6 3Rain/Wind Checks661Club Staff137 116 113LQ HS Golf256 193 214 0 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-2009September 2008Date Time Description CategoryPlayers9/11/2008 8:30 Kris Long - CBS2 Media 49/20/2008 1:30 John White - KESQ Media 412