Loading...
01 July 2007 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2007 – July 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 JulyFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 89,262.50 80,536.00 8,726.50 10.8% 89,262.50 80,536.00 8,726.50 3,161,211.00 3,071,948.50 3%401000 Miscellaneous Golf Revenue 4,558.00 4,375.00 183.00 4.2% 4,558.00 4,375.00 183.00 83,725.00 79,167.00 5%410000 Revenue-Golf Shop 12,075.39 13,300.00 (1,224.61) -9.2% 12,075.39 13,300.00 (1,224.61) 327,370.00 315,294.61 4%420000 Revenue-F&B Concession 500.00 500.00 - 0.0% 500.00 500.00 - 12,000.00 11,500.00 4%890000 Interest Income 35.32 - 35.32 0.0% 35.32 - 35.32 - (35.32) 0%Total Income 106,431.21 98,711.00 7,720.21 7.8% 106,431.21 98,711.00 7,720.21 3,584,306.00 3,477,874.79 3%Cost of Goods Sold510000 COS-Golf Shop 6,468.36 7,059.00 (590.64) 8.4% 6,468.36 7,059.00 590.64 173,752.00 167,283.64 4%Total COS 6,468.36 7,059.00 (590.64) 8.4% 6,468.36 7,059.00 590.64 173,752.00 167,283.64 4%Gross Profit 99,962.85 91,652.00 8,310.85 9.1% 99,962.85 91,652.00 8,310.85 3,410,554.00 3,310,591.15 3%610000 Golf Pro Shop 15,257.30 18,373.00 3,115.70 17.0% 15,257.30 18,373.00 3,115.70 256,699.00 241,441.70 6%630000 Course Maintenance 127,400.03 135,020.00 7,619.97 5.6% 127,400.03 135,020.00 7,619.97 1,796,367.00 1,668,966.97 7%640000 Outside Services 16,674.01 19,839.00 3,164.99 16.0% 16,674.01 19,839.00 3,164.99 297,353.00 280,678.99 6%650000 Clubhouse 12,733.78 14,242.00 1,508.22 10.6% 12,733.78 14,242.00 1,508.22 172,900.00 160,166.22 7%660000 Marketing 14,327.48 6,337.00 (7,990.48) -126.1% 14,327.48 6,337.00 (7,990.48) 252,469.00 238,141.52 6%670000 General & Administrative 21,688.81 25,921.00 4,232.19 16.3% 21,688.81 25,921.00 4,232.19 321,596.00 299,907.19 7%680000 Leases 39,525.86 39,325.00 (200.86) -0.5% 39,525.86 39,325.00 (200.86) 471,900.00 432,374.14 8%690000 Miscellaneous Other Expense 27,130.96 30,516.00 3,385.04 11.1% 27,130.96 30,516.00 3,385.04 253,363.00 226,232.04 11%Total Expenses 274,738.23 289,573.00 14,834.77 5.1% 274,738.23 289,573.00 14,834.77 3,822,647.00 3,547,908.77 7%Net Income(174,775.38) (197,921.00) 23,145.62 11.7%(174,775.38) (197,921.00) 23,145.62 (412,093.00) (237,317.62) 42%Rounds of Golf PlayedPaid Rounds Played 2,072 1,900 172 9.1% 2,072 1,900 172 40,580 38,508 5%Ave $ Per Paid Round Green Fee 43.08 42.39 0.69 1.6% 43.08 42.39 0.69 77.90 34.82 55%Ave $ Per Paid Round Merchandise 5.83 7.00 (1.17) -16.7% 5.83 7.00 (1.17) 8.07 2.24 72%Ave $ Per Paid Miscellaneous 2.20 2.30 (0.10) -4.5% 2.20 2.30 (0.10) 2.06 - 0%Month to Date Year to DateJuly 2007SilverRock ResortSummary Operating Income Statement1 Income JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 89,262.50 80,536.00 8,726.50 89,262.50 80,536.00 8,726.50 3,161,211.003,071,948.503%4010000 Rider Fee 425.00 190.00 235.00 425.00 190.00 235.00 4,058.000.000%4040000 Club Rental 1,240.00 665.00 575.00 1,240.00 665.00 575.00 14,203.0012,963.009%4050000 Driving Range 1,932.00 1,520.00 412.00 1,932.00 1,520.00 412.00 32,464.0030,532.006%4060000 Handicap Fees 45.00 - 45.00 45.00 - 45.00 8,000.00 7,955.001%4080000 GPS Advertising - 1,000.00 (1,000.00) - 1,000.00 (1,000.00) 12,000.00 12,000.000%4090000 Ball Retriever/Subcontract 916.00 1,000.00 (84.00) 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 93,820.50 84,911.00 8,909.50 93,820.50 84,911.00 8,909.50 3,244,936.00 3,138,482.50 3%Total Income93,820.50 84,911.00 8,909.50 93,820.50 84,911.00 8,909.50 3,244,936.00 3,138,482.50 3%SilverRock ResortStatement of Fees RevenueJuly 2007Month to Date Year to Date Annual Budget2 Income JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 1,388.00 - 1,388.00 1,388.00 - 1,388.00 4100110 Sales Hard Goods 4,438.04 4,655.00 (216.96) 4,438.04 4,655.00 (216.96) 114,580.00 110,141.96 4%4100112 Sales-Soft Goods 7,844.25 8,645.00 (800.75) 7,844.25 8,645.00 (800.75) 212,791.00 204,946.75 4%5100639 GS-Discounts-Mdse (1,594.90) - (1,594.90) (1,594.90) - (1,594.90) - 1,594.90 0% Total Revenue Golf Shop 12,075.39 13,300.00 (1,224.61) 12,075.39 13,300.00 (1,224.61) 327,371.00 316,683.61 3%COS 5100150 COS-GS-Hard Goods 2,657.86 2,560.25 97.61 2,657.86 2,560.25 97.61 63,019.00 60,361.14 4%5100151 COS-GS-Soft Goods 3,810.50 4,754.75 (944.25) 3,810.50 4,754.75 (944.25) 117,035.05 113,224.55 3%5100152 COS-GS-Purchase Disc - (366.00) 366.00 - (366.00) 366.00 (9,003.00) (9,003.00) 0%5100220 COS-GS-Freight Merch - 110.00 (110.00) - 110.00 (110.00) 2,701.00 2,701.00 0%Cost of Sales - Golf Shop 6,468.36 7,059.00 (590.64) 6,468.36 7,059.00 (590.64) 173,752.05 167,283.69 4%Gross Profit 5,607.03 6,241.00 (633.97) 5,607.03 6,241.00 (633.97) 153,618.95 149,399.92 3%COS % 53.6% 53.1% -0.5% 53.6% 53.1% -0.5% 53.1% 52.8% 0%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 300.00 300.00 - 300.00 300.00 - 4,680.00 4,380.00 6%6101320 Insurance Group 2,557.62 1,800.00 757.62 2,557.62 1,800.00 757.62 35,640.00 33,082.38 7%6101325 Insurance-Workers Comp 933.01 1,206.00 (272.99) 933.01 1,206.00 (272.99) 16,247.00 15,313.99 6%6101720 Salaries 5,153.90 3,499.00 1,654.90 5,153.90 3,499.00 1,654.90 72,000.00 66,846.10 7%6101800 Taxes-Employer Payroll 890.97 1,502.00 (611.03) 890.97 1,502.00 (611.03) 20,228.00 19,337.03 4%6101880 Wages-Hourly 4,176.19 8,566.00 (4,389.81) 4,176.19 8,566.00 (4,389.81) 90,474.00 86,297.81 5%6101882 Wages-Overtime - - - - - - - 952.88 0%Total -PS-SALARIES & BENEFITS 14,011.69 16,873.00 (2,861.31) 14,011.69 16,873.00 (2,861.31) 239,269.00 226,210.19 5%61-PS OTHER EXPENSES6103762 Supplies-Office 156.17 150.00 6.17 156.17 150.00 6.17 1,525.00 1,368.83 10%6109090 Contract Services 500.00 500.00 - 500.00 500.00 - 6,000.00 5,500.00 8%6109220 Freight & Delivery 102.39 - 102.39 102.39 - 102.39 75.00 (27.39) 137%6109490 Miscellaneous - - - - - - 450.00 450.00 0%6109150 Dues and Subscriptions - - - - - - 2,000.00 2,000.00 0%6109500 ProShop-Over/Short 12.24 - 12.24 12.24 - 12.24 (12.24) 0%6109722 Seminars/Training 372.75 750.00 (377.25) 372.75 750.00 (377.25) 5,490.00 5,117.25 7%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms - 100.00 (100.00) - 100.00 (100.00) 1,800.00 1,800.00 0%6117840 Telephones 102.06 - 102.06 102.06 - 102.06 - (102.06) 0%Total PS-OTHER EXPENSES 1,245.61 1,500.00 (254.39) 1,245.61 1,500.00 (254.39) 17,430.00 16,184.39 7%Total Expenses 15,257.30 18,373.00 (3,115.70) 15,257.30 18,373.00 (3,115.70) 256,699.00 242,394.58 6%Net Income(9,650.27) (12,132.00) 2,481.73 (9,650.27) (12,132.00) 2,481.73 (103,080.05) (92,994.66) -10%Month to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementJuly 20073 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 240.00 240.00 - 2,880.00 2,640.00 91.7%6311320 Insurance-Group 13,443.28 8,850.00 4,593.28 13,443.28 8,850.00 4,593.28 106,200.00 92,756.72 87.3%6311325 Insurance-Workers Comp 5,555.27 5,810.00 (254.73) 5,555.27 5,810.00 (254.73) 72,453.00 66,897.73 92.3%6311720 Salaries 11,038.48 12,331.00 (1,292.52) 11,038.48 12,331.00 (1,292.52) 148,000.00 136,961.52 92.5%6311800 Taxes-Employer Payroll 4,574.26 7,234.00 (2,659.74) 4,574.26 7,234.00 (2,659.74) 90,868.00 86,293.74 95.0%6311880 Wages-Hourly 43,823.63 45,772.00 (1,948.37) 43,823.63 45,772.00 (1,948.37) 565,951.00 522,127.37 92.3%6311882 Wages-Overtime 690.58 - 690.58 690.58 - 690.58 15,916.00 15,225.42 95.7%Total-CM-SALARIES & BENEFITS79,365.50 80,237.00 (871.50) 79,365.50 80,237.00 (871.50) 1,002,268.00 922,902.50 92.1%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 2,058.33 2,400.00 (341.67) 2,058.33 2,400.00 (341.67) 12,300.00 10,241.67 0.0%6313744 Fertilizer 5,483.23 2,000.00 3,483.23 5,483.23 2,000.00 3,483.23 68,950.00 63,466.77 92.0%6313746 Flowers/Plants 425.61 - 425.61 425.61 - 425.61 3,500.00 3,074.39 87.8%6313748 Fuel-Gasoline 3,025.18 3,400.00 (374.82) 3,025.18 3,400.00 (374.82) 41,400.00 38,374.82 92.7%6313750 Golf Course Accessories 64.44 200.00 (135.56) 64.44 200.00 (135.56) 4,200.00 4,135.56 98.5%6313756 POA Control 162.78 - 162.78 162.78 - 162.78 6,000.00 5,837.22 97.3%6313758 Miscellaneous Supp - - - - - - 1,200.00 1,200.00 100.0%6313766 Pesticides 8.00 - 8.00 8.00 - 8.00 11,600.00 11,592.00 99.9%6313762 Supplies-Office - 100.00 (100.00) - 100.00 (100.00) - 0.0%6313774 Sand 1,075.63 390.00 685.63 1,075.63 390.00 685.63 6,660.00 5,584.37 83.8%6313775 Sand-Bunkers - - - - - - 5,000.00 5,000.00 100.0%6313776 Seed 808.13 350.00 458.13 808.13 350.00 458.13 93,750.00 92,941.87 99.1%6313778 Small Tools & Non-Capital Equip 75.22 350.00 (274.78) 75.22 350.00 (274.78) 6,500.00 6,424.78 98.8%6313780 Sod 705.98 1,000.00 (294.02) 705.98 1,000.00 (294.02) 5,750.00 5,044.02 87.7%6313782 Topdressing 2,070.90 1,300.00 770.90 2,070.90 1,300.00 770.90 3,900.00 1,829.10 46.9%Total-CM-SUPPLIES & MATERIALS15,963.43 11,490.00 4,473.43 15,963.43 11,490.00 4,473.43 270,710.00 254,746.57 94.1%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,810.12 1,500.00 310.12 1,810.12 1,500.00 310.12 14,000.00 12,189.88 87.1%6315685 CM-R&M-Bldngs & Othr Structures 114.50 - 114.50 114.50 - 114.50 500.00 385.50 77.1%6315686 CM-R&M- Drainage - - - - - - - 0.0%6315690 CM-R&M-Equipment 2,149.07 1,900.00 249.07 2,149.07 1,900.00 249.07 28,800.00 26,650.93 92.5%6315692 CM-R&M-Irrigation System 566.81 1,500.00 (933.19) 566.81 1,500.00 (933.19) 15,450.00 14,883.19 96.3%6315696 CM-R&M-Pumps 762.59 1,000.00 (237.41) 762.59 1,000.00 (237.41) 5,000.00 4,237.41 84.7%6315815 CM-R&M-Trees-Pruning Etc - - - - - - 4,000.00 4,000.00 100.0%Total-CM-REPAIRS & MAINTENANCE 5,403.09 5,900.00 (496.91) 5,403.09 5,900.00 (496.91) 67,750.00 62,346.91 92.0%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs - 2,274.00 (2,274.00) - 2,274.00 (2,274.00) 22,080.00 22,080.00 100.0%6317836 Utilities-Natural Gas/LPG 2.85 - 2.85 2.85 - 2.85 (2.85) 0.0%6317840 Telephones 1,042.60 600.00 442.60 1,042.60 600.00 442.60 7,200.00 6,157.40 85.5%Total-CM-UTILITIES 1,045.45 2,874.00 (1,828.55) 1,045.45 2,874.00 (1,828.55) 29,280.00 28,234.55 96.4%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 500.00 500.00 - 6,000.00 5,500.00 91.7%6319099 Contract Svcs-Security - - - - - - - 0.0%6319100 Contract Svcs-Soil/Tissue Test - - - - - - 4,000.00 4,000.00 100.0%6319101 Contract Svcs-Trash Removal 2,329.48 600.00 1,729.48 2,329.48 600.00 1,729.48 7,200.00 4,870.52 67.6%6319150 Dues & Subscriptions - 200.00 (200.00) - 200.00 (200.00) 900.00 900.00 100.0%6319170 Employee Education - 50.00 (50.00) - 50.00 (50.00) 600.00 600.00 100.0%6319197 Equipment Rental - 200.00 (200.00) - 200.00 (200.00) 4,200.00 4,200.00 100.0%6319206 Licenses & Permits - 100.00 (100.00) - 100.00 (100.00) 1,600.00 1,600.00 100.0%6319490 Miscellaneous - 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%6319500 Propane/Natural Gas - 150.00 (150.00) - 150.00 (150.00) 1,800.00 1,800.00 100.0%6319718 Safety Equipment & Training 101.52 100.00 1.52 101.52 100.00 1.52 3,400.00 3,298.48 97.0%6319822 Uniforms 666.45 720.00 (53.55) 666.45 720.00 (53.55) 9,390.00 8,723.55 92.9%6319999 Capital Expense-Capex 3,700.00 3,700.00 - 3,700.00 3,700.00 - 44,400.00 40,700.00 91.7%Total-CM-OTHER EXPENSES 7,297.45 6,420.00 877.45 7,297.45 6,420.00 877.45 84,690.00 77,392.55 91.4%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementJuly 2007Annual Budget4 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,104.00 1,104.00 - 1,104.00 1,104.00 - 13,248.00 12,144.00 0.0%6321325 Insurance-Workers Comp 556.53 1,314.00 (757.47) 556.53 1,314.00 (757.47) 16,163.00 15,606.47 96.6%6321800 Taxes-Employer Payroll 425.73 1,636.00 (1,210.27) 425.73 1,636.00 (1,210.27) 20,369.00 19,943.27 97.9%6321880 Wages-Hourly 5,391.75 13,141.00 (7,749.25) 5,391.75 13,141.00 (7,749.25) 157,692.00 152,300.25 96.6%6321882 Wages-Overtime 173.46 - 173.46 173.46 - 173.46 5,915.00 5,741.54 97.1%Total-CM-LM-SALARIES & BENEFITS7,651.47 17,195.00 (9,543.53) 7,651.47 17,195.00 (9,543.53) 213,387.00 193,591.53 90.7%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 100.00 (100.00) - 100.00 (100.00) 1,025.00 1,025.00 100.0%6323788 Uniforms 222.20 240.00 (17.80) 222.20 240.00 (17.80) 2,880.00 2,657.80 92.3%Total-CM-LM-SUPPLIES & MATERIALS222.20 340.00 (117.80) 222.20 340.00 (117.80) 3,905.00 3,682.80 94.3%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 250.00 (250.00) - 250.00 (250.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE - 250.00 (250.00) - 250.00 (250.00) 4,250.00 4,250.00 100.0%632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 7,521.43 8,500.00 (978.57) 7,521.43 8,500.00 (978.57) 102,000.00 94,478.57 92.6%6337842 Utilities-Water2,930.01 1,814.00 1,116.01 2,930.01 1,814.00 1,116.01 18,126.00 15,195.99 83.8%Total-CM-WATER & ENERGY10,451.44 10,314.00 137.44 10,451.44 10,314.00 137.44 120,126.00 109,674.56 91.3%127,400.03 135,020.00 (7,619.97) 127,400.03 135,020.00 (7,619.97) 1,796,366.00 1,656,821.97 92.2%Silverrock ResortCourse Maintenance Expense StatementJuly 2007Annual BudgetTotal -COURSE MAINTENANCEMonth to Date Year to Date5 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 420.00 420.00 - 420.00 420.00 - 6,180.00 5,760.00 93.2%6411320 Insurance-Group 61.77 720.00 (658.23) 61.77 720.00 (658.23) 8,640.00 8,578.23 99.3%6411325 Insurance-Workers Comp 630.58 1,239.00 (608.42) 630.58 1,239.00 (608.42) 16,097.00 15,466.42 96.1%6411800 Taxes-Employer Payroll 721.85 1,074.00 (352.15) 721.85 1,074.00 (352.15) 13,956.00 13,234.15 94.8%6411880 Wages-Hourly 6,266.92 8,625.00 (2,358.08) 6,266.92 8,625.00 (2,358.08) 112,095.00 105,828.08 94.4%6411882 Wages-Overtime 38.86 - 38.86 38.86 - 38.86 - (38.86) 0.0%Total-CBR-SALARIES & BENEFITS8,139.98 12,078.00 (3,938.02) 8,139.98 12,078.00 (3,938.02) 156,968.00 148,828.02 94.8%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 362.60 - 362.60 362.60 - 362.60 2,350.00 1,987.40 84.6%6413742 Supplies-Expendable 434.62 150.00 284.62 434.62 150.00 284.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) - 25.00 (25.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels 625.26 72.00 553.26 625.26 72.00 553.26 2,292.00 1,666.74 72.7%6413796 Supplies-Bottled Water2,027.51 1,571.00 456.51 2,027.51 1,571.00 456.51 22,631.00 20,603.49 91.0%Total-CBR-SUPPLIES & MATERIALS3,449.99 1,818.00 1,631.99 3,449.99 1,818.00 1,631.99 39,268.00 35,818.01 91.2%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts 720.00 720.00 - 720.00 720.00 - 8,640.00 7,920.00 91.7%6415690 CBR-R&M-Equipment - 125.00 (125.00) - 125.00 (125.00) 1,500.00 1,500.00 100.0%6415695 CBR-R&M-Cart Maintenance & Repair - 500.00 (500.00) - 500.00 (500.00) 4,000.00 4,000.00 100.0%Total-CBR-REPAIRS & MAINTENANCE 720.00 1,345.00 (625.00) 720.00 1,345.00 (625.00) 14,140.00 13,420.00 94.9%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps 170.00 100.00 70.00 170.00 100.00 70.00 5,000.00 4,830.00 96.6%6419094 Contract Services-Laundry/Linen - 250.00 (250.00) - 250.00 (250.00) 3,000.00 3,000.00 100.0%6419220 Freight/Delivery - 75.00 (75.00) - 75.00 (75.00) 900.00 900.00 100.0%6419490 Miscellaneous - 125.00 (125.00) - 125.00 (125.00) 1,150.00 1,150.00 100.0%6419820 Uniforms - - - - - - 5,625.00 5,625.00 100.0%Total-CBR-OTHER EXPENSES 170.00 550.00 (380.00) 170.00 550.00 (380.00) 15,675.00 15,505.00 98.9%TOTAL-CARTS,BAGROOM & RANGE 12,479.97 15,791.00 (3,311.03) 12,479.97 15,791.00 (3,311.03) 226,051.00 213,571.03 94.5%643-CS-SALARIES & BENEFITS6431175 Employee Meals 180.00 180.00 - 180.00 180.00 - 3,120.00 2,940.00 94.2%6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 228.19 203.00 25.19 228.19 203.00 25.19 4,073.00 3,844.81 94.4%6431800 Taxes-Employer Payroll 290.95 252.00 38.95 290.95 252.00 38.95 5,071.00 4,780.05 94.3%6431880 Wages-Hourly 2,281.90 2,025.00 256.90 2,281.90 2,025.00 256.90 40,732.00 38,450.10 94.4%6431882 Wages-Overtime - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS2,981.04 2,660.00 321.04 2,981.04 2,660.00 321.04 52,996.00 50,014.96 94.4%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 50.00 (50.00) - 50.00 (50.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) - 50.00 (50.00) 600.00 600.00 100.0%6439820 Uniforms - 75.00 (75.00) - 75.00 (75.00) 1,900.00 1,900.00 100.0%6439999 Capital Expense-Capex 1,213.00 1,213.00 - 1,213.00 1,213.00 - 14,556.00 13,343.00 91.7%Total-CS-OTHER EXPENSES 1,213.00 1,388.00 (175.00) 1,213.00 1,388.00 (175.00) 18,306.00 17,093.00 93.4%Total-COURSE SERVICES 4,194.04 4,048.00 146.04 4,194.04 4,048.00 146.04 71,302.00 67,107.96 94.1%TOTAL OUTSIDE SERVICES16,674.01 19,839.00 (3,164.99) 16,674.01 19,839.00 (3,164.99) 297,353.00 263,585.99 88.6%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementJuly 2007Annual Budget6 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable812.23 400.00 412.23 812.23 400.00 412.23 4,800.00 3,987.77 83.1%Total-CH-SUPPLIES & MATERIALS 812.23 400.00 412.23 812.23 400.00 412.23 4,800.00 3,987.77 83.1%65-CH-UTILITIES6507836 Utilities-Natural Gas371.89 300.00 71.89 371.89 300.00 71.89 3,600.00 3,228.11 89.7%6507838 Utilities-Sewer- 200.00 (200.00) - 200.00 (200.00) 2,400.00 2,400.00 100.0%6507840 Utilities-Telephone991.49 1,000.00 (8.51) 991.49 1,000.00 (8.51) 12,000.00 11,008.51 91.7%6507842 Utilities-Water232.02 200.00 32.02 232.02 200.00 32.02 2,400.00 2,167.98 90.3%6507844 Utilities-Cable336.53 317.00 19.53 336.53 317.00 19.53 3,800.00 3,463.47 0.0%Total-CH-UTILITIES 1,931.93 2,017.00 (85.07) 1,931.93 2,017.00 (85.07) 24,200.00 22,268.07 92.0%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 1,825.00 1,825.00 - 22,500.00 20,675.00 91.9%6509098 Contract Services-Refuse Dispose296.86 500.00 (203.14) 296.86 500.00 (203.14) 6,000.00 5,703.14 95.1%6509099 Contract Services-Security7,867.76 8,100.00 (232.24) 7,867.76 8,100.00 (232.24) 97,200.00 89,332.24 91.9%6509215 Flowers & Decorations- 100.00 (100.00) - 100.00 (100.00) 2,600.00 2,600.00 100.0%6509490 Miscellaneous- 200.00 (200.00) - 200.00 (200.00) 2,400.00 2,400.00 0.0%6509718 Safety Equipment & Training- 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES 9,989.62 10,825.00 (835.38) 9,989.62 10,825.00 (835.38) 131,900.00 121,910.38 92.4%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures- 200.00 (200.00) - 200.00 (200.00) 2,400.00 2,400.00 100.0%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) - 400.00 (400.00) 4,800.00 4,800.00 100.0%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) - 400.00 (400.00) 4,800.00 4,800.00 100.0%Total-CH-REPAIRS & MAINTENANCE - 1,000.00 (1,000.00) - 1,000.00 (1,000.00) 12,000.00 12,000.00 100.0%Total CLUBHOUSE12,733.78 14,242.00 (1,508.22) 12,733.78 14,242.00 (1,508.22) 172,900.00 24,000.00 13.9%Month to Date Year to DateSilverRock ResortClubhouse Expense StatementJuly 2007Annual Budget7 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 287.69 100.00 187.69 287.69 100.00 187.69 1,200.00 912.31 76.0%6603768 Supplies-Printing & Stationery - - - - - - 4,425.00 4,425.00 100.0%287.69 100.00 187.69 287.69 100.00 187.69 5,625.00 5,337.31 94.9%66-MKT-UTILITIES6607840 Utilities-Telephone 75.93 100.00 (24.07) 75.93 100.00 (24.07) 1,200.00 1,124.07 93.7%Total-MKT-UTILITIES 75.93 100.00 (24.07) 75.93 100.00 (24.07) 1,200.00 1,124.07 93.7%66-MKT-OTHER EXPENSES6609010 Advertising 13,519.86 5,812.00 7,707.86 13,519.86 5,812.00 7,707.86 221,834.00 208,314.14 93.9%6609040 Business Meals 25.00 25.00 - 25.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) 99.00 175.00 (76.00) 2,100.00 2,001.00 95.3%6609490 Miscellaneous - - - - - - 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) - 50.00 (50.00) 600.00 600.00 100.0%6609630 Promotion - - - - - - 6,500.00 6,500.00 0.0%6609633 Promotion-Community - 75.00 (75.00) - 75.00 (75.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 320.00 - 320.00 735.00 415.00 0.0%6609820 Uniforms - - - - - - 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 13,963.86 6,137.00 7,826.86 13,963.86 6,137.00 7,826.86 245,644.00 230,980.14 94.0%Total-MARKETING14,327.48 6,337.00 7,990.48 14,327.48 6,337.00 7,990.48 252,469.00 237,441.52 94.0%Month to Date Year to DateSilverRock ResortMarketing Expense StatementJuly 2007Annual Budget8 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 180.00 180.00 - 2,160.00 1,980.00 91.7%6701320 Insurance-Group1,696.92 1,980.00 (283.08) 1,696.92 1,980.00 (283.08) 23,760.00 22,063.08 92.9%6701325 Insurance-Workers Comp1,489.90 1,673.00 (183.10) 1,489.90 1,673.00 (183.10) 20,076.00 18,586.10 92.6%6701720 Salaries 12,434.40 14,000.00 (1,565.60) 12,434.40 14,000.00 (1,565.60) 168,000.00 155,565.60 92.6%6701800 Taxes-Employer Payroll 1,139.78 2,083.00 (943.22) 1,139.78 2,083.00 (943.22) 24,994.00 23,854.22 95.4%6701880 Wages-Hourly2,464.54 2,730.00 (265.46) 2,464.54 2,730.00 (265.46) 32,756.00 30,291.46 92.5%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 19,405.54 22,646.00 (3,240.46) 19,405.54 22,646.00 (3,240.46) 271,746.00 252,340.46 92.9%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer298.23 500.00 (201.77) 298.23 500.00 (201.77) 6,000.00 5,701.77 95.0%6703762 Supplies-Office - 125.00 (125.00) - 125.00 (125.00) 1,500.00 1,500.00 100.0%6703768 Supplies-Printing & Stationery102.07 - 102.07 102.07 - 102.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 400.30 625.00 (224.70) 400.30 625.00 (224.70) 11,600.00 11,199.70 96.5%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 400.00 400.00 - 4,800.00 4,400.00 91.7%6709090 Contract Services80.00 - 80.00 80.00 - 80.00 - 0.0%6709150 Dues & Subscriptions270.00 50.00 220.00 270.00 50.00 220.00 1,500.00 1,230.00 82.0%6709180 Employee Recruiting/Relocation28.00 - 28.00 28.00 - 28.00 4,600.00 4,572.00 99.4%6709197 Equipment Rental444.02 350.00 94.02 444.02 350.00 94.02 4,200.00 3,755.98 89.4%6709202 Fees-Bank20.00 300.00 (280.00) 20.00 300.00 (280.00) 3,600.00 3,580.00 99.4%6709208 Fees-Payroll Processing481.00 550.00 (69.00) 481.00 550.00 (69.00) 6,600.00 6,119.00 92.7%6709220 Freight/Delivery159.95 50.00 109.95 159.95 50.00 109.95 600.00 440.05 73.3%6709490 Miscellaneous - 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%6709620 Postage/Mail Services - 75.00 (75.00) - 75.00 (75.00) 900.00 900.00 100.0%6709625 Professional Fees- 400.00 (400.00) - 400.00 (400.00) 4,800.00 4,800.00 100.0%6709636 Promotion/Entertainment- 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%6709722 Seminars & Training- 100.00 (100.00) - 100.00 (100.00) 900.00 900.00 100.0%6709810 Travel - - - - - - 1,100.00 1,100.00 100.0%6709820 Uniforms - 75.00 (75.00) - 75.00 (75.00) 1,050.00 1,050.00 100.0%Total-G&A-OTHER EXPENSES 1,882.97 2,550.00 (667.03) 1,882.97 2,550.00 (667.03) 37,050.00 35,247.03 95.1%Total-GENERAL & ADMINISTRATIVE21,688.81 25,921.00 (4,232.19) 21,688.81 25,921.00 (4,232.19) 321,596.00 299,987.19 93.3%Month to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementJuly 2007Annual Budget9 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 10,239.47 9,800.00 439.47 10,239.47 9,800.00 439.47 117,600.00 107,360.53 91.3%6800193 Equipment Leases-Course Maint 17,487.00 20,000.00 (2,513.00) 17,487.00 20,000.00 (2,513.00) 240,000.00 222,513.00 92.7%6800194 Equipment Leases-Trailer 1,013.24 600.00 413.24 1,013.24 600.00 413.24 7,200.00 6,186.76 85.9%6800195 Equipment Leases-Software 1,762.93 1,525.00 237.93 1,762.93 1,525.00 237.93 18,300.00 16,537.07 90.4%6800196 Equipment Leases-GPS 6,840.14 7,400.00 (559.86) 6,840.14 7,400.00 (559.86) 88,800.00 81,959.86 92.3%6800198 Equipment Leases-Others 2,183.08 - 2,183.08 2,183.08 - 2,183.08 - - 0.0%Total-LEASES39,525.86 39,325.00 200.86 39,525.86 39,325.00 200.86 471,900.00 434,557.22 92.1%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 21,054.55 24,342.00 (3,287.45) 21,054.55 24,342.00 (3,287.45) 111,277.00 90,222.45 81.1%6900210 FF&E Reserve 1,876.41 1,974.00 (97.59) 1,876.41 1,974.00 (97.59) 71,686.00 69,809.59 97.4%6900800 Personal Property Taxes - - - - - - 20,000.00 20,000.00 100.0%6900323 Insurance-Commercial 4,200.00 4,200.00 - 4,200.00 4,200.00 - 50,400.00 46,200.00 91.7%Total-MISC OTHER EXPENSES27,130.96 30,516.00 (3,385.04) 27,130.96 30,516.00 (3,385.04) 253,363.00 226,232.04 89.3%Annual BudgetMonth to Date Year to Date Operating Leases & Miscellaneous Other Expense StatementJuly 200710 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2007‐20082007 2007 2007 2007 2007 2007Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia1SalesPromotionGolf Industry7VIPCelebrityPGA Comp52Charity/Gift CertificateRain/Wind ChecksClub Staff88LQ HS Golf148000002008 2008 2008 2008 2008 2008Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2007‐2008July 2007Date Time Description CategoryPlayers7/30/2007 9:00 Evan Rothman-Golfweek Media112