Loading...
02 August 2008 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2008 – August 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 August Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 73,500.50 91,718.00 (18,217.50) -19.9% 166,595.50 183,436.00 (16,840.50) 3,255,761.00 3,089,165.50 5%401000 Miscellaneous Golf Revenue 4,231.00 4,465.00 (234.00) -5.2% 8,161.00 11,799.00 (3,638.00) 113,217.00 105,056.00 7%410000 Revenue-Golf Shop 7,735.62 14,700.00 (6,964.38) -47.4% 19,493.82 29,400.00 (9,906.18) 375,951.00 356,457.18 5%420000 Revenue-F&B Concession 500.00 500.00 - 0.0% 1,000.00 1,000.00 - 12,000.00 11,000.00 8%890000 Interest Income 12.16 - 12.16 0.0% 22.00 - 22.00 - (22.00) 0%Total Income85,979.28 111,383.00 (25,403.72) -22.8% 195,272.32 225,635.00 (30,362.68) 3,756,929.00 3,561,656.68 5%Cost of Goods Sold510000 COS-Golf Shop 4,544.55 7,802.00 (3,257.45) 41.8% 10,659.97 15,604.00 4,944.03 199,538.00 188,878.03 5%Total COS4,544.55 7,802.00 (3,257.45) 41.8% 10,659.97 15,604.00 4,944.03 199,538.00 188,878.03 5%Gross Profit81,434.73 103,581.00 (22,146.27) -21.4% 184,612.35 210,031.00 (25,418.65) 3,557,391.00 3,372,778.65 5%Expenses610000 Golf Pro Shop 18,072.92 20,278.00 2,205.08 10.9% 39,614.68 41,156.00 1,541.32 279,518.00 239,903.32 14%630000 Course Maintenance 139,821.29 141,211.00 1,389.71 1.0% 276,063.37 277,627.00 1,563.63 1,805,855.00 1,529,791.63 15%640000 Outside Services 16,610.11 19,811.00 3,200.89 16.2% 37,362.43 39,672.00 2,309.57 294,037.00 256,674.57 13%650000 Clubhouse 13,923.59 13,842.00 (81.59) -0.6% 26,472.79 27,684.00 1,211.21 168,104.00 141,631.21 16%660000 Marketing 16,966.39 12,478.00 (4,488.39) -36.0% 29,714.54 22,616.00 (7,098.54) 298,081.00 268,366.46 10%670000 General & Administrative 22,713.06 26,732.00 4,018.94 15.0% 47,218.47 53,314.00 6,095.53 333,834.00 286,615.53 14%680000 Leases 41,090.02 41,106.00 15.98 0.0% 80,155.95 82,212.00 2,056.05 493,272.00 413,116.05 16%690000 Miscellaneous Other Expense 22,860.92 28,191.00 5,330.08 18.9% 56,904.37 63,406.00 6,501.63 227,140.00 170,235.63 25%Total Expenses292,058.30 303,649.00 11,590.70 3.8% 593,506.60 607,687.00 14,180.40 3,899,841.00 3,306,334.40 15%Net Income (210,623.57) (200,068.00) (10,555.57) -5.3%(408,894.25) (397,656.00) (11,238.25) (342,450.00) 66,444.25 119%Rounds of Golf PlayedPaid Rounds Played 1,850 2,030 (180) -8.9% 4,207 3,530 677 40,580 36,373 10%Ave $ Per Paid Round Green Fee 39.73 45.18 (5.45) -12.1% 39.60 51.96 (12.37) 77.90 38.30 51%Ave $ Per Paid Round Merchandise 4.18 7.24 (3.06) -42.3% 4.63 8.33 (3.69) 8.07 3.44 57%Ave $ Per Paid Miscellaneous 2.29 2.20 0.09 4.0% 1.94 3.34 (1.40) 2.06 - 0%Month to Date Year to DateAugust 2008SilverRock ResortSummary Operating Income Statement1 Income August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 73,500.50 91,718.00 (18,217.50) 166,595.50 183,436.00 (16,840.50) 3,255,761.003,089,165.505%4010000 Rider Fee 150.00 210.00 (60.00) 525.00 2,289.00 (1,764.00) 5,984.005,459.009%4040000 Club Rental 730.00 1,155.00 (425.00) 2,010.00 2,310.00 (300.00) 27,583.0025,573.007%4050000 Driving Range 1,686.00 2,100.00 (414.00) 3,846.00 4,200.00 (354.00) 46,650.0042,804.008%4060000 Handicap Fees 90.00 - 90.00 205.00 - 205.00 8,000.00 7,795.003%4080000 GPS Advertising 1,575.00 1,000.00 575.00 1,575.00 2,000.00 (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 - - - - - - - - 0% Total Revenue Fees 77,731.50 96,183.00 (18,451.50) 174,756.50 195,235.00 (20,478.50) 3,368,978.00 3,194,221.50 5%Total Income 77,731.50 96,183.00 (18,451.50) 174,756.50 195,235.00 (20,478.50) 3,368,978.00 3,194,221.50 5%SilverRock ResortStatement of Fees RevenueAugust 2008Month to Date Year to Date Annual Budget2 Income August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 133.49 - 133.49 1,401.65 - 1,401.65 4100110 Sales Hard Goods 3,371.47 5,145.00 (1,773.53) 8,359.03 10,290.00 (1,930.97) 131,583.00 123,223.97 6%4100112 Sales-Soft Goods 5,751.20 9,555.00 (3,803.80) 13,241.34 19,110.00 (5,868.66) 244,368.00 231,126.66 5%5100639 GS-Discounts-Mdse (1,520.54) - (1,520.54) (3,508.20) - (3,508.20) - 3,508.20 0% Total Revenue Golf Shop 7,735.62 14,700.00 (6,964.38) 19,493.82 29,400.00 (9,906.18) 375,951.00 357,858.83 5%COS 5100150 COS-GS-Hard Goods 1,631.88 2,830.00 (1,198.12) 4,740.18 5,660.00 (919.82) 72,373.00 67,632.82 7%5100151 COS-GS-Soft Goods 2,749.75 5,255.00 (2,505.25) 5,756.87 10,510.00 (4,753.13) 134,404.00 128,647.13 4%5100152 COS-GS-Purchase Disc 13.68 (404.00) 417.68 13.68 (808.00) 821.68 (10,341.00) (10,354.68) 0%5100220 COS-GS-Freight Merch 149.24 121.00 28.24 149.24 242.00 (92.76) 3,102.00 2,952.76 5%Cost of Sales - Golf Shop 4,544.55 7,802.00 (3,257.45) 10,659.97 15,604.00 (4,944.03) 199,538.00 188,878.03 5%Gross Profit 3,191.07 6,898.00 (3,706.93) 8,833.85 13,796.00 (4,962.15) 176,413.00 168,980.80 4%COS % 58.7% 53.1% -5.7% 54.7% 53.1% -1.6% 53.1% 52.8% 1%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 360.00 360.00 - 720.00 720.00 - 5,400.00 4,680.00 13%6101320 Insurance Group 3,336.45 2,700.00 636.45 6,213.90 5,400.00 813.90 36,450.00 30,236.10 17%6101325 Insurance-Workers Comp 300.27 1,094.00 (793.73) 1,013.34 2,188.00 (1,174.66) 14,771.00 13,757.66 7%6101720 Salaries 4,622.66 6,082.00 (1,459.34) 10,931.65 12,164.00 (1,232.35) 71,459.00 60,527.35 15%6101800 Taxes-Employer Payroll 766.44 1,661.00 (894.56) 2,121.09 3,322.00 (1,200.91) 22,431.00 20,309.91 9%6101880 Wages-Hourly 7,349.76 7,261.00 88.76 15,174.24 14,522.00 652.24 108,712.00 93,537.76 14%6101882 Wages-Overtime 30.59 - 30.59 158.47 - 158.47 - 952.88 0%Total -PS-SALARIES & BENEFITS 16,766.17 19,158.00 (2,391.83) 36,332.69 38,316.00 (1,983.31) 259,223.00 224,001.66 14%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 163.86 300.00 (136.14) 1,112.86 600.00 512.86 2,950.00 1,837.14 38%6109090 Contract Services 500.00 500.00 - 1,000.00 1,000.00 - 6,000.00 5,000.00 17%6109220 Freight & Delivery 78.37 - 78.37 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 76.19 - 76.19 75.23 - 75.23 (75.23) 0%6109722 Seminars/Training 266.25 150.00 116.25 555.00 900.00 (345.00) 5,490.00 4,935.00 10%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms 81.03 100.00 (18.97) 81.03 200.00 (118.97) 2,400.00 2,318.97 3%6117840 Telephones 141.05 70.00 71.05 275.24 140.00 135.24 840.00 564.76 0%Total PS-OTHER EXPENSES 1,306.75 1,120.00 186.75 3,281.99 2,840.00 441.99 20,295.00 17,013.01 16%Total Expenses18,072.92 20,278.00 (2,205.08) 39,614.68 41,156.00 (1,541.32) 279,518.00 241,014.67 14%Net Income(14,881.85) (13,380.00) (1,501.85) (30,780.83) (27,360.00) (3,420.83) (103,105.00) (72,033.87) -30%Month to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementAugust 20083 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 480.00 480.00 - 2,880.00 2,400.00 83.3%6311320 Insurance-Group 15,994.21 12,083.00 3,911.21 29,265.87 24,166.00 5,099.87 144,996.00 115,730.13 79.8%6311325 Insurance-Workers Comp 1,749.25 4,841.00 (3,091.75) 4,754.00 9,682.00 (4,928.00) 59,020.00 54,266.00 91.9%6311720 Salaries 12,131.00 12,331.00 (200.00) 24,281.40 24,662.00 (380.60) 147,978.00 123,696.60 83.6%6311800 Taxes-Employer Payroll 3,364.73 7,350.00 (3,985.27) 9,695.89 14,700.00 (5,004.11) 90,311.00 80,615.11 89.3%6311880 Wages-Hourly 44,822.32 46,708.00 (1,885.68) 91,199.41 93,416.00 (2,216.59) 560,520.00 469,320.59 83.7%6311882 Wages-Overtime 331.55 - 331.55 1,899.03 - 1,899.03 16,894.00 14,994.97 88.8%Total-CM-SALARIES & BENEFITS78,633.06 83,553.00 (4,919.94) 161,575.60 167,106.00 (5,530.40) 1,022,599.00 861,023.40 84.2%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 1,101.56 1,000.00 101.56 5,367.12 3,400.00 1,967.12 25,200.00 19,832.88 78.7%6313744 Fertilizer 11,002.20 11,500.00 (497.80) 17,673.65 17,000.00 673.65 95,200.00 77,526.35 81.4%6313746 Flowers/Plants - - - - - - 3,500.00 3,500.00 100.0%6313748 Fuel-Gasoline 3,351.56 3,740.00 (388.44) 7,022.10 7,480.00 (457.90) 45,540.00 38,517.90 84.6%6313750 Golf Course Accessories 142.23 200.00 (57.77) 234.54 400.00 (165.46) 7,000.00 6,765.46 96.6%6313756 POA Control 259.36 - 259.36 440.85 - 440.85 6,000.00 5,559.15 92.7%6313758 Miscellaneous Supp 639.10 100.00 539.10 1,450.23 200.00 1,250.23 - (1,450.23) 0.0%6313762 Supplies-Office - - - 71.08 - 71.08 1,200.00 1,128.92 94.1%6313774 Sand 1,885.71 390.00 1,495.71 1,885.71 780.00 1,105.71 6,660.00 4,774.29 71.7%6313775 Sand-Bunkers - - - - - - 5,000.00 5,000.00 100.0%6313776 Seed 848.53 350.00 498.53 848.53 700.00 148.53 101,810.00 100,961.47 99.2%6313778 Small Tools & Non-Capital Equip 173.67 100.00 73.67 173.67 200.00 (26.33) 7,000.00 6,826.33 97.5%6313780 Sod 950.06 1,000.00 (49.94) 4,513.91 2,000.00 2,513.91 5,750.00 1,236.09 21.5%6313782 Topdressing - 1,250.00 (1,250.00) 2,150.43 2,500.00 (349.57) 7,600.00 5,449.57 71.7%Total-CM-SUPPLIES & MATERIALS20,353.98 19,630.00 723.98 41,831.82 34,660.00 7,171.82 317,460.00 275,628.18 86.8%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,414.12 1,500.00 (85.88) 2,160.12 3,000.00 (839.88) 16,000.00 13,839.88 86.5%6315685 CM-R&M-Bldngs & Othr Structures 125.50 - 125.50 246.50 - 246.50 500.00 253.50 50.7%6315690 CM-R&M-Equipment 4,250.59 4,400.00 (149.41) 8,004.84 8,800.00 (795.16) 46,100.00 38,095.16 82.6%6315692 CM-R&M-Irrigation System 2,879.51 2,100.00 779.51 5,192.72 3,600.00 1,592.72 15,450.00 10,257.28 66.4%6315696 CM-R&M-Pumps - 1,000.00 (1,000.00) 77.00 2,000.00 (1,923.00) 10,500.00 10,423.00 99.3%6315815 CM-R&M-Trees-Pruning Etc - - - - - - 9,000.00 9,000.00 100.0%Total-CM-REPAIRS & MAINTENANCE 8,669.72 9,000.00 (330.28) 15,681.18 17,400.00 (1,718.82) 97,550.00 81,868.82 83.9%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs 5.38 - 5.38 5.38 - 5.38 - (5.38) 0.0%6317836 Utilities-Natural Gas/LPG - 150.00 (150.00) - 300.00 (300.00) 1,800.00 1,800.00 0.0%6317840 Telephones 882.37 800.00 82.37 1,722.33 1,600.00 122.33 9,600.00 7,877.67 82.1%Total-CM-UTILITIES 887.75 950.00 (62.25) 1,727.71 1,900.00 (172.29) 11,400.00 9,672.29 84.8%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%6319101 Contract Svcs-Trash Removal 524.05 - 524.05 910.96 - 910.96 - (910.96) 0.0%6319150 Dues & Subscriptions 35.00 - 35.00 35.00 200.00 (165.00) 900.00 865.00 96.1%6319170 Employee Education - 50.00 (50.00) - 100.00 (100.00) 600.00 600.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,600.00 1,600.00 100.0%6319490 Miscellaneous - 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0%6319718 Safety Equipment & Training 193.95 100.00 93.95 349.25 200.00 149.25 3,400.00 3,050.75 89.7%6319822 Uniforms 820.42 820.00 0.42 1,354.45 1,640.00 (285.55) 9,840.00 8,485.55 86.2%Total-CM-OTHER EXPENSES 2,073.42 1,820.00 253.42 3,649.66 3,890.00 (240.34) 31,740.00 28,090.34 88.5%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementAugust 2008Annual Budget4 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,104.00 1,104.00 - 2,208.00 2,208.00 - 13,248.00 11,040.00 83.3%6321325 Insurance-Workers Comp 277.47 1,078.00 (800.53) 1,052.45 2,156.00 (1,103.55) 13,257.00 12,204.55 92.1%6321800 Taxes-Employer Payroll 709.51 1,636.00 (926.49) 1,895.22 3,272.00 (1,376.78) 20,368.00 18,472.78 90.7%6321880 Wages-Hourly 12,229.35 13,141.00 (911.65) 27,414.36 26,282.00 1,132.36 157,692.00 130,277.64 82.6%6321882 Wages-Overtime 19.60 - 19.60 334.06 - 334.06 5,915.00 5,580.94 94.4%Total-CM-LM-SALARIES & BENEFITS14,339.93 16,959.00 (2,619.07) 32,904.09 33,918.00 (1,013.91) 210,480.00 177,575.91 84.4%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 346.15 290.00 56.15 575.77 580.00 (4.23) 3,480.00 2,904.23 83.5%Total-CM-LM-SUPPLIES & MATERIALS346.15 390.00 (43.85) 575.77 780.00 (204.23) 4,505.00 3,929.23 87.2%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%632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 10,603.04 7,000.00 3,603.04 10,603.04 14,000.00 (3,396.96) 84,000.00 73,396.96 87.4%6337842 Utilities-Water3,914.24 1,659.00 2,255.24 7,514.50 3,473.00 4,041.50 21,871.00 14,356.50 65.6%Total-CM-WATER & ENERGY14,517.28 8,659.00 5,858.28 18,117.54 17,473.00 644.54 105,871.00 87,753.46 82.9%139,821.29 141,211.00 (1,389.71) 276,063.37 277,627.00 (1,563.63) 1,805,855.00 1,529,791.63 84.7%Silverrock ResortCourse Maintenance Expense StatementAugust 2008Annual BudgetTotal -COURSE MAINTENANCEMonth to Date Year to Date5 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 420.00 420.00 - 840.00 840.00 - 6,180.00 5,340.00 86.4%6411320 Insurance-Group 75.25 720.00 (644.75) 135.50 1,440.00 (1,304.50) 8,640.00 8,504.50 98.4%6411325 Insurance-Workers Comp 200.52 1,303.00 (1,102.48) 665.98 2,606.00 (1,940.02) 16,511.00 15,845.02 96.0%6411800 Taxes-Employer Payroll 682.84 1,130.00 (447.16) 1,686.51 2,260.00 (573.49) 14,318.00 12,631.49 88.2%6411880 Wages-Hourly 6,679.64 9,075.00 (2,395.36) 15,963.66 18,150.00 (2,186.34) 114,990.00 99,026.34 86.1%6411882 Wages-Overtime 4.31 - 4.31 29.43 - 29.43 - (29.43) 0.0%Total-CBR-SALARIES & BENEFITS8,062.56 12,648.00 (4,585.44) 19,321.08 25,296.00 (5,974.92) 160,639.00 141,317.92 88.0%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - - - 94.55 - 94.55 2,350.00 2,255.45 96.0%6413742 Supplies-Expendable 322.93 150.00 172.93 756.65 300.00 456.65 5,850.00 5,093.35 87.1%6413752 Supplies-Range Balls - - - - - - 6,000.00 6,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 1,178.04 72.00 1,106.04 1,532.31 144.00 1,388.31 2,292.00 759.69 33.1%6413796 Supplies-Bottled Water3,206.67 1,800.00 1,406.67 4,611.26 3,600.00 1,011.26 23,950.00 19,338.74 80.7%Total-CBR-SUPPLIES & MATERIALS4,707.64 2,047.00 2,660.64 6,994.77 4,094.00 2,900.77 41,387.00 34,392.23 83.1%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts 720.00 720.00 - 1,515.00 1,440.00 75.00 8,640.00 7,125.00 82.5%6415690 CBR-R&M-Equipment - 125.00 (125.00) - 250.00 (250.00) 1,500.00 1,500.00 100.0%6415695 CBR-R&M-Cart Maintenance & Repair - 500.00 (500.00) 1,431.23 1,000.00 431.23 4,000.00 2,568.77 64.2%Total-CBR-REPAIRS & MAINTENANCE 720.00 1,345.00 (625.00) 2,946.23 2,690.00 256.23 14,140.00 11,193.77 79.2%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps 15.00 100.00 (85.00) 1,470.00 200.00 1,270.00 5,000.00 3,530.00 70.6%6419094 Contract Services-Laundry/Linen - 500.00 (500.00) - 1,000.00 (1,000.00) 6,000.00 6,000.00 100.0%6419220 Freight/Delivery - 75.00 (75.00) - 150.00 (150.00) 900.00 900.00 100.0%6419490 Miscellaneous 88.80 75.00 13.80 88.80 200.00 (111.20) 1,150.00 1,061.20 92.3%6419820 Uniforms - - - - - - 5,625.00 5,625.00 100.0%Total-CBR-OTHER EXPENSES 103.80 750.00 (646.20) 1,558.80 1,550.00 8.80 18,675.00 17,116.20 91.7%TOTAL-CARTS,BAGROOM & RANGE 13,594.00 16,790.00 (3,196.00) 30,820.88 33,630.00 (2,809.12) 234,841.00 204,020.12 86.9%643-CS-SALARIES & BENEFITS6431175 Employee Meals 240.00 240.00 - 480.00 480.00 - 4,860.00 4,380.00 90.1%6431325 Insurance-Workers Comp 75.42 177.00 (101.58) 198.62 354.00 (155.38) 3,446.00 3,247.38 94.2%6431800 Taxes-Employer Payroll 186.69 269.00 (82.31) 645.85 538.00 107.85 5,220.00 4,574.15 87.6%6431880 Wages-Hourly 2,514.00 2,160.00 354.00 4,978.00 4,320.00 658.00 41,920.00 36,942.00 88.1%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS3,016.11 2,846.00 170.11 6,302.47 5,692.00 610.47 55,446.00 49,143.53 88.6%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 50.00 (50.00) 239.08 100.00 139.08 1,050.00 810.92 77.2%6439490 Miscellaneous - - - - - - 200.00 200.00 100.0%6439718 Safety Equipment & Training - 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0%6439820 Uniforms - 75.00 (75.00) - 150.00 (150.00) 1,900.00 1,900.00 100.0%Total-CS-OTHER EXPENSES - 175.00 (175.00) 239.08 350.00 (110.92) 3,750.00 3,510.92 93.6%Total-COURSE SERVICES 3,016.11 3,021.00 (4.89) 6,541.55 6,042.00 499.55 59,196.00 52,654.45 88.9%TOTAL OUTSIDE SERVICES 16,610.11 19,811.00 (3,200.89) 37,362.43 39,672.00 (2,309.57) 294,037.00 253,163.65 86.1%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementAugust 2008Annual Budget6 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 235.94 800.00 (564.06) 4,800.00 4,564.06 95.1%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 235.94 800.00 (564.06) 4,800.00 4,564.06 95.1%65-CH-UTILITIES6507836 Utilities-Natural Gas632.52 300.00 332.52 632.52 600.00 32.52 3,600.00 2,967.48 82.4%6507838 Utilities-Sewer600.00 200.00 400.00 600.00 400.00 200.00 2,400.00 1,800.00 75.0%6507840 Utilities-Telephone988.09 1,000.00 (11.91) 2,144.87 2,000.00 144.87 12,000.00 9,855.13 82.1%6507842 Utilities-Water391.89 200.00 191.89 623.70 400.00 223.70 2,400.00 1,776.30 74.0%6507844 Utilities-Cable333.38 317.00 16.38 541.81 634.00 (92.19) 3,804.00 3,262.19 85.8%Total-CH-UTILITIES 2,945.88 2,017.00 928.88 4,542.90 4,034.00 508.90 24,204.00 19,661.10 81.2%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-Security8,175.08 8,200.00 (24.92) 16,442.84 16,400.00 42.84 98,400.00 81,957.16 83.3%6509215 Flowers & Decorations- 100.00 (100.00) - 200.00 (200.00) 2,600.00 2,600.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 10,311.82 10,425.00 (113.18) 21,028.06 20,850.00 178.06 127,100.00 106,071.94 83.5%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures386.50 200.00 186.50 386.50 400.00 (13.50) 2,400.00 2,013.50 83.9%6515686 CH-R&M-Restaurant Repairs279.39 400.00 (120.61) 279.39 800.00 (520.61) 4,800.00 4,520.61 94.2%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 665.89 1,000.00 (334.11) 665.89 2,000.00 (1,334.11) 12,000.00 11,334.11 94.5%Total CLUBHOUSE 13,923.59 13,842.00 81.59 26,472.79 27,684.00 (1,211.21) 168,104.00 22,668.22 13.5%Month to Date Year to DateSilverRock ResortClubhouse Expense StatementAugust 2008Annual Budget7 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 120.00 120.00 - 720.00 600.00 83.3%6601320 Insurance-Group - 450.00 (450.00) 411.00 900.00 (489.00) 5,400.00 4,989.00 92.4%6601325 Insurance-Workers Comp 75.09 205.00 (129.91) 200.09 410.00 (209.91) 2,460.00 2,259.91 91.9%6601720 Salaries 2,500.00 2,500.00 - 5,000.00 5,000.00 - 30,000.00 25,000.00 83.3%6601800 Taxes-Employer Payroll 311.00 311.00 - 622.00 622.00 - 3,732.00 3,110.00 83.3%Total-MKT-SALARIES & BENEFITS 2,946.09 3,526.00 (579.91) 6,353.09 7,052.00 (698.91) 42,312.00 35,958.91 85.0%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery - - - - - - 4,425.00 4,425.00 100.0%- 100.00 (100.00) - 200.00 (200.00) 5,625.00 5,625.00 100.0%66-MKT-UTILITIES6607840 Utilities-Telephone 36.93 100.00 (63.07) 73.88 200.00 (126.12) 1,200.00 1,126.12 93.8%Total-MKT-UTILITIES 36.93 100.00 (63.07) 73.88 200.00 (126.12) 1,200.00 1,126.12 93.8%66-MKT-OTHER EXPENSES6609010 Advertising 12,547.00 8,427.00 4,120.00 21,480.49 14,514.00 6,966.49 225,134.00 203,653.51 90.5%6609040 Business Meals - 25.00 (25.00) - 50.00 (50.00) 300.00 300.00 100.0%6609080 Collateral Material - - - - - - 9,000.00 9,000.00 100.0%6609102 Contract Services-Web Page - 175.00 (175.00) 99.00 350.00 (251.00) 2,100.00 2,001.00 95.3%6609490 Miscellaneous - - - - - - 350.00 350.00 100.0%6609620 Postage 1.59 50.00 (48.41) 1.59 100.00 (98.41) 600.00 598.41 99.7%6609630 Promotion 1,260.04 - 1,260.04 1,260.04 - 1,260.04 6,500.00 5,239.96 0.0%6609633 Promotion-Community 36.33 75.00 (38.67) 36.33 150.00 (113.67) 2,925.00 2,888.67 98.8%6609634 Promotion-Media/Vendor - - - - - - 700.00 - 0.0%6609150 Dues and Subscriptions 100.00 - 100.00 371.71 - 371.71 735.00 363.29 49.4%6609820 Uniforms 38.41 - 38.41 38.41 - 38.41 600.00 561.59 93.6%Total-MKT-OTHER EXPENSES 13,983.37 8,752.00 5,231.37 23,287.57 15,164.00 8,123.57 248,944.00 224,956.43 90.4%Total-MARKETING 16,966.39 12,478.00 4,488.39 29,714.54 22,616.00 7,098.54 298,081.00 267,666.46 89.8%Month to Date Year to DateSilverRock ResortMarketing Expense StatementAugust 2008Annual Budget8 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 360.00 360.00 - 2,160.00 1,800.00 83.3%6701320 Insurance-Group1,834.10 2,250.00 (415.90) 3,668.20 4,500.00 (831.80) 27,000.00 23,331.80 86.4%6701325 Insurance-Workers Comp505.85 1,406.00 (900.15) 1,354.52 2,812.00 (1,457.48) 16,872.00 15,517.48 92.0%6701720 Salaries 14,351.66 14,416.00 (64.34) 28,806.64 28,832.00 (25.36) 172,992.00 144,185.36 83.3%6701800 Taxes-Employer Payroll 1,146.93 2,135.00 (988.07) 2,889.07 4,270.00 (1,380.93) 25,620.00 22,730.93 88.7%6701880 Wages-Hourly2,509.87 2,730.00 (220.13) 5,028.15 5,460.00 (431.85) 32,760.00 27,731.85 84.7%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 20,528.41 23,117.00 (2,588.59) 42,106.58 46,234.00 (4,127.42) 277,404.00 235,297.42 84.8%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer103.85 800.00 (696.15) 174.09 1,600.00 (1,425.91) 10,800.00 10,625.91 98.4%6703762 Supplies-Office 138.07 125.00 13.07 377.15 250.00 127.15 1,500.00 1,122.85 74.9%6703768 Supplies-Printing & Stationery398.31 100.00 298.31 480.33 100.00 380.33 3,200.00 2,719.67 85.0%6703778Supplies-Small Tools/Non-Capital - - - - - - 900.00 900.00 100.0%Total-G&A-SUPPLIES & MATERIALS 640.23 1,025.00 (384.77) 1,031.57 1,950.00 (918.43) 16,400.00 15,368.43 93.7%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment95.99 100.00 (4.01) 223.21 200.00 23.21 1,200.00 976.79 81.4%Total-G&A-REPAIRS & MAINTENANCE 95.99 100.00 (4.01) 223.21 200.00 23.21 1,200.00 976.79 81.4%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 800.00 800.00 - 4,800.00 4,000.00 83.3%6709090 Contract Services- - - - - - - - 0.0%6709150 Dues & Subscriptions- - - - 50.00 (50.00) 1,500.00 1,500.00 100.0%6709180 Employee Recruiting/Relocation84.00 - 84.00 84.00 - 84.00 4,600.00 4,516.00 98.2%6709197 Equipment Rental198.66 350.00 (151.34) 403.69 700.00 (296.31) 4,200.00 3,796.31 90.4%6709202 Fees-Bank20.00 90.00 (70.00) 30.00 180.00 (150.00) 1,080.00 1,050.00 97.2%6709208 Fees-Payroll Processing311.66 550.00 (238.34) 1,117.19 1,100.00 17.19 6,600.00 5,482.81 83.1%6709220 Freight/Delivery- 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0%6709490 Miscellaneous 117.30 100.00 17.30 117.30 200.00 (82.70) 1,200.00 1,082.70 90.2%6709620 Postage/Mail Services - 75.00 (75.00) 257.45 150.00 107.45 900.00 642.55 71.4%6709625 Professional Fees190.00 400.00 (210.00) 920.67 800.00 120.67 4,800.00 3,879.33 80.8%6709636 Promotion/Entertainment81.88 100.00 (18.12) 81.88 200.00 (118.12) 4,000.00 3,918.12 98.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 44.93 75.00 (30.07) 44.93 150.00 (105.07) 1,050.00 1,005.07 95.7%Total-G&A-OTHER EXPENSES 1,448.43 2,490.00 (1,041.57) 3,857.11 4,930.00 (1,072.89) 38,830.00 34,972.89 90.1%Total-GENERAL & ADMINISTRATIVE22,713.06 26,732.00 (4,018.94) 47,218.47 53,314.00 (6,095.53) 333,834.00 286,615.53 85.9%Month to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementAugust 2008Annual Budget9 August Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,581.04 11,581.00 0.04 23,162.08 23,162.00 0.08 138,972.00 115,809.92 83.3%6800193 Equipment Leases-Course Maint 16,244.12 20,000.00 (3,755.88) 32,488.24 40,000.00 (7,511.76) 240,000.00 207,511.76 86.5%6800194 Equipment Leases-Trailer 877.00 600.00 277.00 1,234.00 1,200.00 34.00 7,200.00 5,966.00 82.9%6800195 Equipment Leases-Software 1,791.93 1,525.00 266.93 3,583.86 3,050.00 533.86 18,300.00 14,716.14 80.4%6800196 Equipment Leases-GPS 6,840.14 7,400.00 (559.86) 13,680.28 14,800.00 (1,119.72) 88,800.00 75,119.72 84.6%6800197 Equipment Leases-Others 3,755.79 - 3,755.79 6,007.49 - 6,007.49 - - 0.0%Total-LEASES 41,090.02 41,106.00 (15.98) 80,155.95 82,212.00 (2,056.05) 493,272.00 419,123.54 85.0%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 17,827.77 22,463.00 (4,635.23) 41,318.49 51,893.00 (10,574.51) 90,000.00 48,681.51 54.1%6900210 FF&E Reserve 1,719.35 2,228.00 (508.65) 3,905.21 4,513.00 (607.79) 75,140.00 71,234.79 94.8%6900800 Personal Property Taxes 2,813.80 - 2,813.80 11,180.67 - 11,180.67 20,000.00 8,819.33 44.1%6900323 Insurance-Commercial 500.00 3,500.00 (3,000.00) 500.00 7,000.00 (6,500.00) 42,000.00 41,500.00 98.8%Total-MISC OTHER EXPENSES22,860.92 28,191.00 (5,330.08) 56,904.37 63,406.00 (6,501.63) 227,140.00 170,235.63 74.9% Operating Leases & Miscellaneous Other Expense StatementAugust 2008Annual BudgetMonth to Date Year to Date10 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2008-20092008 2008 2008 2008 2008 2008Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia61SalesPromotionGolf Industry11 16VIPCelebrityPGA Comp82 48Charity/Gift Certificate14 6Rain/Wind Checks66Club Staff137 116LQ HS Golf25619300002009 2009 2009 2009 2009 2009Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2008-2009August 2008Date Time Description CategoryPlayers8/6/2008 10:22 Kris Long - CBS2 Media 112