Loading...
02 August 2007 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2007 – August 2007 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 AugustFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 91,542.50 80,536.00 11,006.50 13.7% 180,805.00 161,072.00 19,733.00 3,161,211.00 2,980,406.00 6%401000 Miscellaneous Golf Revenue 3,227.00 3,375.00 (148.00) -4.4% 7,785.00 7,750.00 35.00 83,725.00 75,940.00 9%410000 Revenue-Golf Shop 12,096.64 13,300.00 (1,203.36) -9.0% 24,172.03 26,600.00 (2,427.97) 327,370.00 303,197.97 7%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 41.92 - 41.92 0.0% 77.24 - 77.24 - (77.24) 0%Total Income 107,408.06 97,711.00 9,697.06 9.9% 213,839.27 196,422.00 17,417.27 3,584,306.00 3,370,466.73 6%Cost of Goods Sold510000 COS-Golf Shop 6,310.67 7,059.00 (748.33) 10.6% 12,779.03 14,118.00 1,338.97 173,752.00 160,972.97 7%Total COS 6,310.67 7,059.00 (748.33) 10.6% 12,779.03 14,118.00 1,338.97 173,752.00 160,972.97 7%Gross Profit 101,097.39 90,652.00 10,445.39 11.5% 201,060.24 182,304.00 18,756.24 3,410,554.00 3,209,493.76 6%610000 Golf Pro Shop 15,548.71 17,773.00 2,224.29 12.5% 30,806.01 36,146.00 5,339.99 256,699.00 225,892.99 12%630000 Course Maintenance 139,206.63 141,142.00 1,935.37 1.4% 266,606.66 276,162.00 9,555.34 1,796,367.00 1,529,760.34 15%640000 Outside Services 17,338.56 19,827.00 2,488.44 12.6% 34,012.57 39,666.00 5,653.43 297,353.00 263,340.43 11%650000 Clubhouse 14,648.50 14,242.00 (406.50) -2.9% 28,508.06 28,484.00 (24.06) 172,900.00 144,391.94 16%660000 Marketing 13,382.64 8,677.00 (4,705.64) -54.2% 27,710.12 15,014.00 (12,696.12) 252,469.00 224,758.88 11%670000 General & Administrative 23,082.86 26,071.00 2,988.14 11.5% 44,811.19 51,992.00 7,180.81 321,596.00 276,784.81 14%680000 Leases 39,183.74 39,325.00 141.26 0.4% 78,709.60 78,650.00 (59.60) 471,900.00 393,190.40 17%690000 Miscellaneous Other Expense 26,820.36 24,574.00 (2,246.36) -9.1% 53,941.32 55,090.00 1,148.68 253,363.00 199,421.68 21%Total Expenses 289,212.00 291,631.00 2,419.00 0.8% 565,105.53 581,204.00 16,098.47 3,822,647.00 3,257,541.47 15%Net Income(188,114.61) (200,979.00) 12,864.39 6.4%(364,045.29) (398,900.00) 34,854.71 (412,093.00) (48,047.71) 88%Rounds of Golf PlayedPaid Rounds Played 2,036 1,900 136 7.2% 4,108 3,800 308 40,580 36,472 10%Ave $ Per Paid Round Green Fee 44.96 42.39 2.57 6.1% 44.01 42.39 1.63 77.90 33.89 56%Ave $ Per Paid Round Merchandise 5.94 7.00 (1.06) -15.1% 5.88 7.00 (1.12) 8.07 2.19 73%Ave $ Per Paid Miscellaneous 1.58 1.78 (0.19) -10.8% 1.90 2.04 (0.14) 2.06 - 0%Month to Date Year to DateAugust 2007SilverRock ResortSummary Operating Income Statement1 Income AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 91,542.50 80,536.00 11,006.50 180,805.00 161,072.00 19,733.00 3,161,211.002,980,406.006%4010000 Rider Fee 550.00 190.00 360.00 975.00 380.00 595.00 4,058.003,083.0024%4040000 Club Rental 940.00 665.00 275.00 2,180.00 1,330.00 850.00 14,203.0012,023.0015%4050000 Driving Range 1,502.00 1,520.00 (18.00) 3,434.00 3,040.00 394.00 32,464.0029,030.0011%4060000 Handicap Fees 235.00 - 235.00 280.00 - 280.00 8,000.00 7,720.004%4080000 GPS Advertising - 1,000.00 (1,000.00) - 2,000.00 (2,000.00) 12,000.00 12,000.000%4090000 Ball Retriever/Subcontract - - - 916.00 1,000.00 (84.00) 4,000.00 3,084.0023%4091000 Golf Professional Rental Fee - - - - - - 9,000.00 - 0% Total Revenue Fees 94,769.50 83,911.00 10,858.50 188,590.00 168,822.00 19,768.00 3,244,936.00 3,047,346.00 6%Total Income94,769.50 83,911.00 10,858.50 188,590.00 168,822.00 19,768.00 3,244,936.00 3,047,346.00 6%Month to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueAugust 20072 Income AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 158.00 - 158.00 1,546.00 - 1,546.00 4100110 Sales Hard Goods 5,403.54 4,655.00 748.54 9,841.58 9,310.00 531.58 114,580.00 104,738.42 9%4100112 Sales-Soft Goods 8,487.16 8,645.00 (157.84) 16,331.41 17,290.00 (958.59) 212,791.00 196,459.59 8%5100639 GS-Discounts-Mdse (1,952.06) - (1,952.06) (3,546.96) - (3,546.96) - 3,546.96 0% Total Revenue Golf Shop 12,096.64 13,300.00 (1,203.36) 24,172.03 26,600.00 (2,427.97) 327,371.00 304,744.97 7%COS 5100150 COS-GS-Hard Goods 2,752.76 2,560.25 192.51 5,410.62 5,120.50 290.12 63,019.00 57,608.38 9%5100151 COS-GS-Soft Goods 3,557.91 4,754.75 (1,196.84) 7,368.41 9,509.50 (2,141.09) 117,035.05 109,666.64 6%5100152 COS-GS-Purchase Disc - (366.00) 366.00 - (732.00) 732.00 (9,003.00) (9,003.00) 0%5100220 COS-GS-Freight Merch - 110.00 (110.00) - 220.00 (220.00) 2,701.00 2,701.00 0%Cost of Sales - Golf Shop 6,310.67 7,059.00 (748.33) 12,779.03 14,118.00 (1,338.97) 173,752.05 160,973.02 7%Gross Profit 5,785.97 6,241.00 (455.03) 11,393.00 12,482.00 (1,089.00) 153,618.95 143,771.95 6%COS % 52.2% 53.1% 0.9% 52.9% 53.1% 0.2% 53.1% 52.8% 0%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 300.00 300.00 - 600.00 600.00 - 4,680.00 4,080.00 13%6101320 Insurance Group 2,566.49 1,800.00 766.49 5,124.11 3,600.00 1,524.11 35,640.00 30,515.89 14%6101325 Insurance-Workers Comp 955.76 1,206.00 (250.24) 1,888.77 2,412.00 (523.23) 16,247.00 14,358.23 12%6101720 Salaries 5,153.90 3,499.00 1,654.90 10,307.80 6,998.00 3,309.80 72,000.00 61,692.20 14%6101800 Taxes-Employer Payroll 852.55 1,502.00 (649.45) 1,743.52 3,004.00 (1,260.48) 20,228.00 18,484.48 9%6101880 Wages-Hourly 4,403.67 8,566.00 (4,162.33) 8,579.86 17,132.00 (8,552.14) 90,474.00 81,894.14 9%6101882 Wages-Overtime - - - - - - - 952.88 0%Total -PS-SALARIES & BENEFITS 14,232.37 16,873.00 (2,640.63) 28,244.06 33,746.00 (5,501.94) 239,269.00 211,977.82 11%61-PS OTHER EXPENSES6103762 Supplies-Office 393.82 150.00 243.82 549.99 300.00 249.99 1,525.00 975.01 36%6109090 Contract Services 500.00 500.00 - 1,000.00 1,000.00 - 6,000.00 5,000.00 17%6109220 Freight & Delivery 300.96 - 300.96 403.35 - 403.35 75.00 (328.35) 538%6109490 Miscellaneous - - - - - - 450.00 450.00 0%6109150 Dues and Subscriptions - - - - - - 2,000.00 2,000.00 0%6109500 ProShop-Over/Short 19.50 - 19.50 31.74 - 31.74 (31.74) 0%6109722 Seminars/Training - 150.00 (150.00) 372.75 900.00 (527.25) 5,490.00 5,117.25 7%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms - 100.00 (100.00) - 200.00 (200.00) 1,800.00 1,800.00 0%6117840 Telephones 102.06 - 102.06 204.12 - 204.12 - (204.12) 0%Total PS-OTHER EXPENSES 1,316.34 900.00 416.34 2,561.95 2,400.00 161.95 17,430.00 14,868.05 15%Total Expenses 15,548.71 17,773.00 (2,224.29) 30,806.01 36,146.00 (5,339.99) 256,699.00 226,845.87 12%Net Income(9,762.74) (11,532.00) 1,769.26 (19,413.01) (23,664.00) 4,250.99 (103,080.05) (83,073.92) -19%Month to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementAugust 20073 AugustFinal 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 13,586.36 8,850.00 4,736.36 27,029.64 17,700.00 9,329.64 106,200.00 79,170.36 74.5%6311325 Insurance-Workers Comp 5,693.14 5,810.00 (116.86) 11,248.41 11,620.00 (371.59) 72,453.00 61,204.59 84.5%6311720 Salaries 11,038.48 12,331.00 (1,292.52) 22,076.96 24,662.00 (2,585.04) 148,000.00 125,923.04 85.1%6311800 Taxes-Employer Payroll 4,310.38 7,234.00 (2,923.62) 8,884.64 14,468.00 (5,583.36) 90,868.00 81,983.36 90.2%6311880 Wages-Hourly 41,989.33 45,772.00 (3,782.67) 85,812.96 91,544.00 (5,731.04) 565,951.00 480,138.04 84.8%6311882 Wages-Overtime 997.19 - 997.19 1,687.77 - 1,687.77 15,916.00 14,228.23 89.4%Total-CM-SALARIES & BENEFITS77,854.88 80,237.00 (2,382.12) 157,220.38 160,474.00 (3,253.62) 1,002,268.00 845,047.62 84.3%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 1,746.23 1,000.00 746.23 3,804.56 3,400.00 404.56 12,300.00 8,495.44 69.1%6313744 Fertilizer 11,510.08 8,000.00 3,510.08 16,993.31 10,000.00 6,993.31 68,950.00 51,956.69 75.4%6313746 Flowers/Plants 649.19 - 649.19 1,074.80 - 1,074.80 3,500.00 2,425.20 69.3%6313748 Fuel-Gasoline 3,262.87 3,400.00 (137.13) 6,288.05 6,800.00 (511.95) 41,400.00 35,111.95 84.8%6313750 Golf Course Accessories 257.73 200.00 57.73 322.17 400.00 (77.83) 4,200.00 3,877.83 92.3%6313756 POA Control - - - 162.78 - 162.78 6,000.00 5,837.22 97.3%6313766 Pesticides - - - 8.00 - 8.00 11,600.00 11,592.00 99.9%6313762 Supplies-Office 442.36 100.00 342.36 442.36 200.00 242.36 1,200.00 757.64 63.1%6313774 Sand - 390.00 (390.00) 1,075.63 780.00 295.63 6,660.00 5,584.37 83.8%6313775 Sand-Bunkers - - - - - - 5,000.00 5,000.00 100.0%6313776 Seed - 350.00 (350.00) 808.13 700.00 108.13 93,750.00 92,941.87 99.1%6313778 Small Tools & Non-Capital Equip - - - 75.22 350.00 (274.78) 6,500.00 6,424.78 98.8%6313780 Sod 2,088.67 1,000.00 1,088.67 2,794.65 2,000.00 794.65 5,750.00 2,955.35 51.4%6313782 Topdressing 105.11 - 105.11 2,176.01 1,300.00 876.01 3,900.00 1,723.99 44.2%Total-CM-SUPPLIES & MATERIALS20,062.24 14,440.00 5,622.24 36,025.67 25,930.00 10,095.67 270,710.00 234,684.33 86.7%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 909.74 1,500.00 (590.26) 2,719.86 3,000.00 (280.14) 14,000.00 11,280.14 80.6%6315685 CM-R&M-Bldngs & Othr Structures 114.50 - 114.50 229.00 - 229.00 500.00 271.00 54.2%6315690 CM-R&M-Equipment 4,959.99 4,000.00 959.99 7,109.06 5,900.00 1,209.06 28,800.00 21,690.94 75.3%6315692 CM-R&M-Irrigation System 676.53 2,100.00 (1,423.47) 1,243.34 3,600.00 (2,356.66) 15,450.00 14,206.66 92.0%6315696 CM-R&M-Pumps 5,573.76 1,000.00 4,573.76 6,336.35 2,000.00 4,336.35 5,000.00 (1,336.35) -26.7%6315815 CM-R&M-Trees-Pruning Etc 1,905.00 - 1,905.00 1,905.00 - 1,905.00 4,000.00 2,095.00 52.4%Total-CM-REPAIRS & MAINTENANCE 14,139.52 8,600.00 5,539.52 19,542.61 14,500.00 5,042.61 67,750.00 48,207.39 71.2%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs - 3,151.00 (3,151.00) - 5,425.00 (5,425.00) 22,080.00 22,080.00 100.0%6317836 Utilities-Natural Gas/LPG 22.85 - 22.85 25.70 - 25.70 (25.70) 0.0%6317840 Telephones 275.08 600.00 (324.92) 1,317.68 1,200.00 117.68 7,200.00 5,882.32 81.7%Total-CM-UTILITIES 297.93 3,751.00 (3,453.07) 1,343.38 6,625.00 (5,281.62) 29,280.00 27,936.62 95.4%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 1,401.80 600.00 801.80 3,731.28 1,200.00 2,531.28 7,200.00 3,468.72 48.2%6319150 Dues & Subscriptions - - - - 200.00 (200.00) 900.00 900.00 100.0%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 3,868.89 100.00 3,768.89 3,868.89 200.00 3,668.89 1,200.00 (2,668.89) -222.4%6319500 Propane/Natural Gas - 150.00 (150.00) - 300.00 (300.00) 1,800.00 1,800.00 100.0%6319718 Safety Equipment & Training 104.00 100.00 4.00 205.52 200.00 5.52 3,400.00 3,194.48 94.0%6319822 Uniforms 588.74 720.00 (131.26) 1,255.19 1,440.00 (184.81) 9,390.00 8,134.81 86.6%6319999 Capital Expense-Capex 3,700.00 3,700.00 - 7,400.00 7,400.00 - 44,400.00 37,000.00 83.3%Total-CM-OTHER EXPENSES 10,163.43 6,170.00 3,993.43 17,460.88 12,590.00 4,870.88 84,690.00 67,229.12 79.4%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementAugust 2007Annual Budget4 AugustFinal 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 536.07 1,314.00 (777.93) 1,092.60 2,628.00 (1,535.40) 16,163.00 15,070.40 93.2%6321800 Taxes-Employer Payroll 636.22 1,636.00 (999.78) 1,061.95 3,272.00 (2,210.05) 20,369.00 19,307.05 94.8%6321880 Wages-Hourly 5,360.00 13,141.00 (7,781.00) 10,751.75 26,282.00 (15,530.25) 157,692.00 146,940.25 93.2%6321882 Wages-Overtime - - - 173.46 - 173.46 5,915.00 5,741.54 97.1%Total-CM-LM-SALARIES & BENEFITS7,636.29 17,195.00 (9,558.71) 15,287.76 34,390.00 (19,102.24) 213,387.00 187,059.24 87.7%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 100.00 (100.00) - 200.00 (200.00) 1,025.00 1,025.00 100.0%6323788 Uniforms 321.99 240.00 81.99 544.19 480.00 64.19 2,880.00 2,335.81 81.1%Total-CM-LM-SUPPLIES & MATERIALS321.99 340.00 (18.01) 544.19 680.00 (135.81) 3,905.00 3,360.81 86.1%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 6,230.03 8,500.00 (2,269.97) 13,751.46 17,000.00 (3,248.54) 102,000.00 88,248.54 86.5%6337842 Utilities-Water2,500.32 1,659.00 841.32 5,430.33 3,473.00 1,957.33 18,126.00 12,695.67 70.0%Total-CM-WATER & ENERGY8,730.35 10,159.00 (1,428.65) 19,181.79 20,473.00 (1,291.21) 120,126.00 100,944.21 84.0%139,206.63 141,142.00 (1,935.37) 266,606.66 276,162.00 (9,555.34) 1,796,366.00 1,518,719.34 84.5%Silverrock ResortCourse Maintenance Expense StatementAugust 2007Annual BudgetTotal -COURSE MAINTENANCEMonth to Date Year to Date5 AugustFinal 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 62.77 720.00 (657.23) 124.54 1,440.00 (1,315.46) 8,640.00 8,515.46 98.6%6411325 Insurance-Workers Comp 651.70 1,239.00 (587.30) 1,282.28 2,478.00 (1,195.72) 16,097.00 14,814.72 92.0%6411800 Taxes-Employer Payroll 698.39 1,074.00 (375.61) 1,420.24 2,148.00 (727.76) 13,956.00 12,535.76 89.8%6411880 Wages-Hourly 6,503.03 8,625.00 (2,121.97) 12,769.95 17,250.00 (4,480.05) 112,095.00 99,325.05 88.6%6411882 Wages-Overtime 14.08 - 14.08 52.94 - 52.94 - (52.94) 0.0%Total-CBR-SALARIES & BENEFITS8,349.97 12,078.00 (3,728.03) 16,489.95 24,156.00 (7,666.05) 156,968.00 140,478.05 89.5%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 190.97 - 190.97 553.57 - 553.57 2,350.00 1,796.43 76.4%6413742 Supplies-Expendable - 150.00 (150.00) 434.62 300.00 134.62 5,050.00 4,615.38 91.4%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 - 72.00 (72.00) 625.26 144.00 481.26 2,292.00 1,666.74 72.7%6413796 Supplies-Bottled Water1,946.33 1,609.00 337.33 3,973.84 3,180.00 793.84 22,631.00 18,657.16 82.4%Total-CBR-SUPPLIES & MATERIALS2,137.30 1,856.00 281.30 5,587.29 3,674.00 1,913.29 39,268.00 33,680.71 85.8%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts 720.00 720.00 - 1,440.00 1,440.00 - 8,640.00 7,200.00 83.3%6415690 CBR-R&M-Equipment 612.30 125.00 487.30 612.30 250.00 362.30 1,500.00 887.70 59.2%6415695 CBR-R&M-Cart Maintenance & Repair - 500.00 (500.00) - 1,000.00 (1,000.00) 4,000.00 4,000.00 100.0%Total-CBR-REPAIRS & MAINTENANCE 1,332.30 1,345.00 (12.70) 2,052.30 2,690.00 (637.70) 14,140.00 12,087.70 85.5%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps 10.00 100.00 (90.00) 180.00 200.00 (20.00) 5,000.00 4,820.00 96.4%6419094 Contract Services-Laundry/Linen 990.44 250.00 740.44 990.44 500.00 490.44 3,000.00 2,009.56 67.0%6419220 Freight/Delivery - 75.00 (75.00) - 150.00 (150.00) 900.00 900.00 100.0%6419490 Miscellaneous - 75.00 (75.00) - 200.00 (200.00) 1,150.00 1,150.00 100.0%6419820 Uniforms - - - - - - 5,625.00 5,625.00 100.0%Total-CBR-OTHER EXPENSES 1,000.44 500.00 500.44 1,170.44 1,050.00 120.44 15,675.00 14,504.56 92.5%TOTAL-CARTS,BAGROOM & RANGE 12,820.01 15,779.00 (2,958.99) 25,299.98 31,570.00 (6,270.02) 226,051.00 200,751.02 88.8%643-CS-SALARIES & BENEFITS6431175 Employee Meals 180.00 180.00 - 360.00 360.00 - 3,120.00 2,760.00 88.5%6431325 Insurance-Workers Comp 254.60 203.00 51.60 482.79 406.00 76.79 4,073.00 3,590.21 88.1%6431800 Taxes-Employer Payroll 324.67 252.00 72.67 615.62 504.00 111.62 5,071.00 4,455.38 87.9%6431880 Wages-Hourly 2,546.28 2,025.00 521.28 4,828.18 4,050.00 778.18 40,732.00 35,903.82 88.1%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS3,305.55 2,660.00 645.55 6,286.59 5,320.00 966.59 52,996.00 46,709.41 88.1%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 50.00 (50.00) - 100.00 (100.00) 1,050.00 1,050.00 100.0%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%6439999 Capital Expense-Capex 1,213.00 1,213.00 - 2,426.00 2,426.00 - 14,556.00 12,130.00 83.3%Total-CS-OTHER EXPENSES 1,213.00 1,388.00 (175.00) 2,426.00 2,776.00 (350.00) 18,306.00 15,880.00 86.7%Total-COURSE SERVICES 4,518.55 4,048.00 470.55 8,712.59 8,096.00 616.59 71,302.00 62,589.41 87.8%TOTAL OUTSIDE SERVICES17,338.56 19,827.00 (2,488.44) 34,012.57 39,666.00 (5,653.43) 297,353.00 247,460.43 83.2%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementAugust 2007Annual Budget6 AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable299.23 400.00 (100.77) 1,111.46 800.00 311.46 4,800.00 3,688.54 76.8%Total-CH-SUPPLIES & MATERIALS 299.23 400.00 (100.77) 1,111.46 800.00 311.46 4,800.00 3,688.54 76.8%65-CH-UTILITIES6507836 Utilities-Natural Gas284.04 300.00 (15.96) 655.93 600.00 55.93 3,600.00 2,944.07 81.8%6507838 Utilities-Sewer- 200.00 (200.00) - 400.00 (400.00) 2,400.00 2,400.00 100.0%6507840 Utilities-Telephone890.25 1,000.00 (109.75) 3,007.52 2,000.00 1,007.52 12,000.00 8,992.48 74.9%6507842 Utilities-Water- 200.00 (200.00) 232.02 400.00 (167.98) 2,400.00 2,167.98 90.3%6507844 Utilities-Cable336.53 317.00 19.53 673.06 634.00 39.06 3,800.00 3,126.94 82.3%Total-CH-UTILITIES 1,510.82 2,017.00 (506.18) 4,568.53 4,034.00 534.53 24,200.00 19,631.47 81.1%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%6509098 Contract Services-Refuse Dispose243.02 500.00 (256.98) 539.88 1,000.00 (460.12) 6,000.00 5,460.12 91.0%6509099 Contract Services-Security7,740.08 8,100.00 (359.92) 15,607.84 16,200.00 (592.16) 97,200.00 81,592.16 83.9%6509215 Flowers & Decorations36.29 100.00 (63.71) 36.29 200.00 (163.71) 2,600.00 2,563.71 98.6%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 9,844.39 10,825.00 (980.61) 19,834.01 21,650.00 (1,815.99) 131,900.00 112,065.99 85.0%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures2,220.00 200.00 2,020.00 2,220.00 400.00 1,820.00 2,400.00 180.00 7.5%6515686 CH-R&M-Restaurant Repairs606.56 400.00 206.56 606.56 800.00 (193.44) 4,800.00 4,193.44 87.4%6515690 CH-R&M-Equipment Repair167.50 400.00 (232.50) 167.50 800.00 (632.50) 4,800.00 4,632.50 96.5%Total-CH-REPAIRS & MAINTENANCE 2,994.06 1,000.00 1,994.06 2,994.06 2,000.00 994.06 12,000.00 9,005.94 75.0%Total CLUBHOUSE14,648.50 14,242.00 406.50 28,508.06 28,484.00 24.06 172,900.00 18,011.88 10.4%Month to Date Year to DateSilverRock ResortClubhouse Expense StatementAugust 2007Annual Budget7 AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 143.37 100.00 43.37 431.06 200.00 231.06 1,200.00 768.94 64.1%6603768 Supplies-Printing & Stationery - - - - - - 4,425.00 4,425.00 100.0%143.37 100.00 43.37 431.06 200.00 231.06 5,625.00 5,193.94 92.3%66-MKT-UTILITIES6607840 Utilities-Telephone 75.93 100.00 (24.07) 151.86 200.00 (48.14) 1,200.00 1,048.14 87.3%Total-MKT-UTILITIES 75.93 100.00 (24.07) 151.86 200.00 (48.14) 1,200.00 1,048.14 87.3%66-MKT-OTHER EXPENSES6609010 Advertising 13,064.34 8,152.00 4,912.34 26,584.20 13,964.00 12,620.20 221,834.00 195,249.80 88.0%6609040 Business Meals - 25.00 (25.00) 25.00 50.00 (25.00) 300.00 275.00 91.7%6609080 Collateral Material - - - - - - 9,000.00 9,000.00 100.0%6609102 Contract Services-Web Page 99.00 175.00 (76.00) 198.00 350.00 (152.00) 2,100.00 1,902.00 90.6%6609490 Miscellaneous - - - - - - 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0%6609630 Promotion - - - - - - 6,500.00 6,500.00 0.0%6609633 Promotion-Community - 75.00 (75.00) - 150.00 (150.00) 2,925.00 2,925.00 100.0%6609634 Promotion-Media/Vender - - - - - - 700.00 - 0.0%6609150 Dues and Subscriptions - - - 320.00 - 320.00 735.00 415.00 56.5%6609820 Uniforms - - - - - - 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 13,163.34 8,477.00 4,686.34 27,127.20 14,614.00 12,513.20 245,644.00 217,816.80 88.7%Total-MARKETING13,382.64 8,677.00 4,705.64 27,710.12 15,014.00 12,696.12 252,469.00 224,058.88 88.7%Month to Date Year to DateSilverRock ResortMarketing Expense StatementAugust 2007Annual Budget8 AugustFinal 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,697.92 1,980.00 (282.08) 3,394.84 3,960.00 (565.16) 23,760.00 20,365.16 85.7%6701325 Insurance-Workers Comp1,490.20 1,673.00 (182.80) 2,980.10 3,346.00 (365.90) 20,076.00 17,095.90 85.2%6701720 Salaries 12,434.40 14,000.00 (1,565.60) 24,868.80 28,000.00 (3,131.20) 168,000.00 143,131.20 85.2%6701800 Taxes-Employer Payroll 1,140.07 2,083.00 (942.93) 2,279.85 4,166.00 (1,886.15) 24,994.00 22,714.15 90.9%6701880 Wages-Hourly2,468.46 2,730.00 (261.54) 4,933.00 5,460.00 (527.00) 32,756.00 27,823.00 84.9%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 19,411.05 22,646.00 (3,234.95) 38,816.59 45,292.00 (6,475.41) 271,746.00 232,929.41 85.7%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer1,657.71 500.00 1,157.71 1,955.94 1,000.00 955.94 6,000.00 4,044.06 67.4%6703762 Supplies-Office - 125.00 (125.00) - 250.00 (250.00) 1,500.00 1,500.00 100.0%6703768 Supplies-Printing & Stationery- 100.00 (100.00) 102.07 100.00 2.07 3,200.00 3,097.93 96.8%6703778Supplies-Small Tools/Non-Capital - - - - - - 900.00 900.00 100.0%Total-G&A-SUPPLIES & MATERIALS 1,657.71 725.00 932.71 2,058.01 1,350.00 708.01 11,600.00 9,541.99 82.3%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 800.00 800.00 - 4,800.00 4,000.00 83.3%6709090 Contract Services80.00 - 80.00 160.00 - 160.00 - 0.0%6709150 Dues & Subscriptions- - - 270.00 50.00 220.00 1,500.00 1,230.00 82.0%6709180 Employee Recruiting/Relocation184.00 - 184.00 212.00 - 212.00 4,600.00 4,388.00 95.4%6709197 Equipment Rental614.51 350.00 264.51 1,058.53 700.00 358.53 4,200.00 3,141.47 74.8%6709202 Fees-Bank48.50 300.00 (251.50) 68.50 600.00 (531.50) 3,600.00 3,531.50 98.1%6709208 Fees-Payroll Processing536.42 550.00 (13.58) 1,056.94 1,100.00 (43.06) 6,600.00 5,543.06 84.0%6709220 Freight/Delivery74.79 50.00 24.79 234.74 100.00 134.74 600.00 365.26 60.9%6709490 Miscellaneous - 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0%6709620 Postage/Mail Services 75.88 75.00 0.88 75.88 150.00 (74.12) 900.00 824.12 91.6%6709625 Professional Fees- 400.00 (400.00) - 800.00 (800.00) 4,800.00 4,800.00 100.0%6709636 Promotion/Entertainment- 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0%6709722 Seminars & Training- 100.00 (100.00) - 200.00 (200.00) 900.00 900.00 100.0%6709810 Travel - 100.00 (100.00) - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms - 75.00 (75.00) - 150.00 (150.00) 1,050.00 1,050.00 100.0%Total-G&A-OTHER EXPENSES 2,014.10 2,600.00 (585.90) 3,936.59 5,150.00 (1,213.41) 37,050.00 33,273.41 89.8%Total-GENERAL & ADMINISTRATIVE23,082.86 26,071.00 (2,988.14) 44,811.19 51,992.00 (7,180.81) 321,596.00 276,944.81 86.1%Month to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementAugust 2007Annual Budget9 AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 10,239.47 9,800.00 439.47 20,478.94 19,600.00 878.94 117,600.00 97,121.06 82.6%6800193 Equipment Leases-Course Maint 17,487.00 20,000.00 (2,513.00) 34,974.00 40,000.00 (5,026.00) 240,000.00 205,026.00 85.4%6800194 Equipment Leases-Trailer 578.49 600.00 (21.51) 1,591.73 1,200.00 391.73 7,200.00 5,608.27 77.9%6800195 Equipment Leases-Software 1,762.93 1,525.00 237.93 3,525.86 3,050.00 475.86 18,300.00 14,774.14 80.7%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%6800198 Equipment Leases-Others 2,275.71 - 2,275.71 4,458.79 - 4,458.79 - - 0.0%Total-LEASES39,183.74 39,325.00 (141.26) 78,709.60 78,650.00 59.60 471,900.00 397,649.19 84.3%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 18,337.38 18,420.00 (82.62) 39,381.93 42,762.00 (3,380.07) 111,277.00 71,895.07 64.6%6900210 FF&E Reserve 1,830.35 1,954.00 (123.65) 3,706.76 3,928.00 (221.24) 71,686.00 67,979.24 94.8%6900800 Personal Property Taxes 3,133.87 - 3,133.87 3,133.87 - 3,133.87 20,000.00 16,866.13 84.3%6900323 Insurance-Commercial 3,518.76 4,200.00 (681.24) 7,718.76 8,400.00 (681.24) 50,400.00 42,681.24 84.7%Total-MISC OTHER EXPENSES26,820.36 24,574.00 2,246.36 53,941.32 55,090.00 (1,148.68) 253,363.00 199,421.68 78.7%Annual BudgetMonth to Date Year to Date Operating Leases & Miscellaneous Other Expense StatementAugust 200710 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2007‐20082007 2007 2007 2007 2007 2007Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia14SalesPromotionGolf Industry720VIPCelebrityPGA Comp52 54Charity/Gift CertificateRain/Wind ChecksClub Staff88 99LQ HS Golf14817700002008 2008 2008 2008 2008 2008Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2007‐2008August 2007Date Time Description CategoryPlayers8/18/2007 11:07 Chris Long - CBS Media 28/24/2007 12:45 Dan Ball - CBS Media 212