Loading...
01 July 2006 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2006 – July 2006 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 Account Description JulyFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 77,260.11 84,389.00 (7,128.89) -8.4% 77,260.11 84,389.00 (7,128.89) 2,985,870.00 2,908,609.89 3%401000 Miscellaneous Golf Revenue 8,190.00 3,974.00 4,216.00 106.1% 8,190.00 3,974.00 4,216.00 62,181.00 53,991.00 13%410000 Revenue-Golf Shop 7,952.73 12,765.00 (4,812.27) -37.7% 7,952.73 12,765.00 (4,812.27) 311,248.00 303,295.27 3%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 - - - 0.0% - - - - - Total Income 93,902.84 101,628.00 (7,725.16) -7.6% 93,902.84 101,628.00 (7,725.16) 3,371,299.00 3,277,396.16 3%Cost of Goods Sold510000 COS-Golf Shop 4,963.31 7,514.00 (2,550.69) 33.9% 4,963.31 7,514.00 2,550.69 180,513.00 175,549.69 3%Total COS 4,963.31 7,514.00 (2,550.69) 33.9% 4,963.31 7,514.00 2,550.69 180,513.00 175,549.69 3%Gross Profit 88,939.53 94,114.00 (5,174.47) -5.5% 88,939.53 94,114.00 (5,174.47) 3,190,786.00 3,101,846.47 3%610000 Golf Pro Shop 13,404.65 14,892.00 1,487.35 10.0% 13,404.65 14,892.00 1,487.35 211,697.00 198,292.35 6%630000 Course Maintenance 122,512.37 136,983.00 14,470.63 10.6% 122,512.37 136,983.00 14,470.63 1,739,809.00 1,617,296.63 7%640000 Outside Services 13,664.54 19,515.00 5,850.46 30.0% 13,664.54 19,515.00 5,850.46 291,576.00 277,911.46 5%650000 Clubhouse 11,853.92 16,815.00 4,961.08 29.5% 11,853.92 16,815.00 4,961.08 197,095.00 185,241.08 6%660000 Marketing 7,378.01 9,698.00 2,319.99 23.9% 7,378.01 9,698.00 2,319.99 248,481.00 241,102.99 3%670000 General & Administrative 20,493.19 25,302.00 4,808.81 19.0% 20,493.19 25,302.00 4,808.81 311,576.00 291,082.81 7%680000 Leases 34,921.16 39,325.00 4,403.84 11.2% 34,921.16 39,325.00 4,403.84 471,900.00 436,978.84 7%690000 Miscellaneous Other Expense 18,919.84 24,971.00 6,051.16 24.2% 18,919.84 24,971.00 6,051.16 263,021.00 244,101.16 7%Total Expenses 243,147.68 287,501.00 44,353.32 15.4% 243,147.68 287,501.00 44,353.32 3,735,155.00 3,492,007.32 7%Net Income(154,208.15) (193,387.00) 39,178.85 20.3%(154,208.15) (193,387.00) 39,178.85 (544,369.00) (390,160.85) 28%Rounds of Golf PlayedRounds Played 1,812 1,880 (68) -3.6% 1,812 1,880 (68) 39,220 37,408 5%Ave $ Per Round Green Fee 42.64 44.89 (2.25) -5.0% 42.64 44.89 (2.25) 76.13 33 56%Ave $ Per Round Merchandise 4.39 6.79 (2.40) -35.4% 4.39 6.79 (2.40) 7.94 4 55%Ave $ Per Miscellaneous 4.52 2.11 2.41 113.8% 4.52 2.11 2.41 1.59 - 0%July 2006SilverRock ResortSummary Operating Income Statement1 Income JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 77,260.11 84,389.00 (7,128.89) 77,260.11 84,389.00 (7,128.89) 2,985,870.00 2,908,609.89 3%4010000 Rider Fee 125.00 - 125.00 125.00 - 125.00 0.00 0.00 0%4040000 Club Rental 550.00 564.00 (14.00) 550.00 564.00 (14.00) 11,766.00 11,216.00 5%4050000 Driving Range 995.00 1,410.00 (415.00) 995.00 1,410.00 (415.00) 29,415.00 28,420.00 3%4060000 Handicap Fees 120.00 - 120.00 120.00 - 120.00 8,000.00 7,880.00 2%4080000 GPS Advertising 6,400.00 1,000.00 5,400.00 6,400.00 1,000.00 5,400.00 9,000.00 2,600.00 71%4090000 Ball Retriever/Subcontract - 1,000.00 (1,000.00) - 1,000.00 (1,000.00) 4,000.00 4,000.00 0% Total Revenue Fees 85,450.11 88,363.00 (2,912.89) 85,450.11 88,363.00 (2,912.89) 3,048,051.00 2,962,725.89 3%Total Income85,450.11 88,363.00 (2,912.89) 85,450.11 88,363.00 (2,912.89) 3,048,051.00 2,962,725.89 3%SilverRock ResortStatement of Fees RevenueJuly 2006Month to Date Year to Date Annual Budget2 Income JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous (857.70) - (857.70) (857.70) - (857.70) 4100110 Sales Hard Goods 4,235.27 4,606.00 (370.73) 4,235.27 4,606.00 (370.73) 108,937.00 104,701.73 4%4100112 Sales-Soft Goods 5,949.24 8,554.00 (2,604.76) 5,949.24 8,554.00 (2,604.76) 202,311.00 196,361.76 3%5100639 GS-Discounts-Mdse (1,374.08) (395.00) (979.08) (1,374.08) (395.00) (979.08) (9,353.00) (7,978.92) -15% Total Revenue Golf Shop 7,952.73 12,765.00 (4,812.27) 7,952.73 12,765.00 (4,812.27) 301,895.00 293,084.57 3%COS 5100150 COS-GS-Hard Goods 2,306.59 2,671.48 (364.89) 2,306.59 2,671.48 (364.89) 63,183.46 60,876.87 4%5100151 COS-GS-Soft Goods 2,656.72 4,842.52 (2,185.80) 2,656.72 4,842.52 (2,185.80) 107,977.38 105,320.66 2%Cost of Sales - Golf Shop 4,963.31 7,514.00 (2,550.69) 4,963.31 7,514.00 (2,550.69) 171,160.84 166,197.53 3%Gross Profit 2,989.42 5,251.00 (2,261.58) 2,989.42 5,251.00 (2,261.58) 130,734.16 126,887.04 3%COS % 56.3% 58.9% 2.5% 62.4% 58.9% -3.5% 61.0% 56.7% 7%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 240.00 240.00 - 240.00 240.00 - 3,960.00 3,720.00 6%6101320 Insurance Group 2,330.36 1,440.00 890.36 2,330.36 1,440.00 890.36 31,320.00 28,989.64 7%6101325 Insurance-Workers Comp 566.73 956.00 (389.27) 566.73 956.00 (389.27) 13,313.00 12,746.27 4%6101720 Salaries 2,615.40 3,333.00 (717.60) 2,615.40 3,333.00 (717.60) 39,992.00 37,376.60 7%6101800 Taxes-Employer Payroll 802.06 1,191.00 (388.94) 802.06 1,191.00 (388.94) 16,575.00 15,772.94 5%6101880 Wages-Hourly 6,618.94 6,232.00 386.94 6,618.94 6,232.00 386.94 93,138.00 86,519.06 7%6101882 Wages-Overtime 86.65 - 86.65 86.65 - 86.65 - 952.88 0%Total -PS-SALARIES & BENEFITS 13,260.14 13,392.00 (131.86) 13,260.14 13,392.00 (131.86) 198,298.00 186,077.39 6%61-PS-SUPPLIES & MATERIALS6103742 Supplies-Expendable 4.26 - 4.26 4.26 - 4.26 - (4.26) #DIV/0!Total PS-SUPPLIES & MATERIALS 4.26 - 4.26 4.26 - 4.26 - (4.26) #DIV/0!61-PS OTHER EXPENSES6103762 Supplies-Office - 150.00 (150.00) - 150.00 (150.00) 1,525.00 1,525.00 0%6109090 Contract Services - 500.00 (500.00) - 500.00 (500.00) 6,000.00 6,000.00 0%6109197 Equipment Rental - - - - - - - - 0%6109220 Freight & Delivery 46.88 - 46.88 46.88 - 46.88 75.00 28.12 63%6109490 Miscellaneous - - - - - - 450.00 450.00 0%6109150 Dues and Subscriptions - - - - - - 1,500.00 1,500.00 0%6109500 ProShop-Over/Short (13.91) - (13.91) (13.91) - (13.91) - 13.91 0%6109722 Seminars/Training - 750.00 (750.00) - 750.00 (750.00) 1,960.00 1,960.00 0%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 107.28 - 107.28 107.28 - 107.28 - (107.28) 0%6119206 License and Permits - - - - - - - - 0%Total PS-OTHER EXPENSES 140.25 1,500.00 (1,359.75) 140.25 1,500.00 (1,359.75) 13,400.00 13,259.75 1%Total Expenses 13,404.65 14,892.00 (1,487.35) 13,404.65 14,892.00 (1,487.35) 211,698.00 199,337.14 6%Net Income(10,415.23) (9,641.00) (774.23) (10,415.23) (9,641.00) (774.23) (80,963.84) (72,450.10) -11%Month to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementJuly 20063 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 11,624.24 5,880.00 5,744.24 11,624.24 5,880.00 5,744.24 70,560.00 58,935.76 83.5%6311325 Insurance-Workers Comp 4,855.44 5,690.00 (834.56) 4,855.44 5,690.00 (834.56) 70,971.00 66,115.56 93.2%6311720 Salaries 10,692.32 11,748.00 (1,055.68) 10,692.32 11,748.00 (1,055.68) 141,000.00 130,307.68 92.4%6311800 Taxes-Employer Payroll 5,402.48 7,084.00 (1,681.52) 5,402.48 7,084.00 (1,681.52) 89,006.00 83,603.52 93.9%6311880 Wages-Hourly 48,394.22 45,148.00 3,246.22 48,394.22 45,148.00 3,246.22 558,230.00 509,835.78 91.3%6311882 Wages-Overtime - - - - - - 15,679.00 15,679.00 100.0%Total-CM-SALARIES & BENEFITS81,208.70 75,790.00 5,418.70 81,208.70 75,790.00 5,418.70 948,326.00 867,117.30 91.4%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 1,617.16 - 1,617.16 1,617.16 - 1,617.16 (1,617.16) 0.0%6313744 Fertilizer 1,979.84 4,000.00 (2,020.16) 1,979.84 4,000.00 (2,020.16) 54,650.00 52,670.16 96.4%6313746 Flowers/Plants - - - - - - 3,500.00 3,500.00 100.0%6313748 Fuel-Gasoline 2,434.29 3,400.00 (965.71) 2,434.29 3,400.00 (965.71) 40,900.00 38,465.71 94.0%6313750 Golf Course Accessories 368.87 200.00 168.87 368.87 200.00 168.87 4,200.00 3,831.13 91.2%6313756 POA Control 162.78 - 162.78 162.78 - 162.78 6,000.00 5,837.22 97.3%6313758 Miscellaneous Supp 73.04 100.00 (26.96) 73.04 100.00 (26.96) 1,200.00 1,126.96 93.9%6313766 Pesticides 807.91 650.00 157.91 807.91 650.00 157.91 14,900.00 14,092.09 94.6%6313774 Sand - 390.00 (390.00) - 390.00 (390.00) 16,660.00 16,660.00 100.0%6313776 Seed - 350.00 (350.00) - 350.00 (350.00) 84,750.00 84,750.00 100.0%6313778 Small Tools & Non-Capital Equip 228.86 350.00 (121.14) 228.86 350.00 (121.14) 6,500.00 6,271.14 96.5%6313780 Sod - 1,000.00 (1,000.00) - 1,000.00 (1,000.00) 5,750.00 5,750.00 100.0%6313782 Topdressing - 1,300.00 (1,300.00) - 1,300.00 (1,300.00) 3,900.00 3,900.00 100.0%Total-CM-SUPPLIES & MATERIALS7,672.75 11,740.00 (4,067.25) 7,672.75 11,740.00 (4,067.25) 242,910.00 235,237.25 96.8%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,816.25 1,500.00 316.25 1,816.25 1,500.00 316.25 14,000.00 12,183.75 87.0%6315685 CM-R&M-Bldngs & Othr Structures 109.00 - 109.00 109.00 - 109.00 500.00 391.00 78.2%6315686 CM-R&M- Drainage 1,595.25 - 1,595.25 1,595.25 - 1,595.25 - (1,595.25) 0.0%6315690 CM-R&M-Equipment 1,896.88 1,000.00 896.88 1,896.88 1,000.00 896.88 14,400.00 12,503.12 86.8%6315692 CM-R&M-Irrigation System 1,560.44 550.00 1,010.44 1,560.44 550.00 1,010.44 8,450.00 6,889.56 81.5%6315696 CM-R&M-Pumps 431.00 1,000.00 (569.00) 431.00 1,000.00 (569.00) 5,000.00 4,569.00 91.4%6315815 CM-R&M-Trees-Pruning Etc- - - - - - 4,000.00 4,000.00 100.0%Total-CM-REPAIRS & MAINTENANCE 7,408.82 4,050.00 3,358.82 7,408.82 4,050.00 3,358.82 46,350.00 38,941.18 84.0%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs 6,772.29 2,274.00 4,498.29 6,772.29 2,274.00 4,498.29 22,080.00 15,307.71 69.3%6317836 Utilities-Natural Gas/LPG 23.02 - 23.02 23.02 - 23.02 - (23.02) 0.0%6317840 Telephones 1,053.94 350.00 703.94 1,053.94 350.00 703.94 4,200.00 3,146.06 74.9%Total-CM-UTILITIES 7,849.25 2,624.00 5,225.25 7,849.25 2,624.00 5,225.25 26,280.00 18,430.75 70.1%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 500.00 500.00 - 6,000.00 5,500.00 91.7%6319100 Contract Svcs-Soil/Tissue Test - - - - - - 4,000.00 4,000.00 100.0%6319101 Contract Svcs-Trash Removal 1,685.09 700.00 985.09 1,685.09 700.00 985.09 18,800.00 17,114.91 91.0%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,800.00 1,800.00 100.0%6319490 Miscellaneous 61.98 100.00 (38.02) 61.98 100.00 (38.02) 1,200.00 1,138.02 94.8%6319500 Propane/Natural Gas - 150.00 (150.00) - 150.00 (150.00) 1,800.00 1,800.00 100.0%6319718 Safety Equipment & Training 119.14 100.00 19.14 119.14 100.00 19.14 3,400.00 3,280.86 96.5%6319822 Uniforms 542.16 720.00 (177.84) 542.16 720.00 (177.84) 9,390.00 8,847.84 94.2%Total-CM-OTHER EXPENSES 2,908.37 2,820.00 88.37 2,908.37 2,820.00 88.37 52,090.00 49,181.63 94.4%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementJuly 2006Annual Budget4 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,010.63 1,104.00 (93.37) 1,010.63 1,104.00 (93.37) 13,248.00 12,237.37 0.0%6321325 Insurance-Workers Comp 494.95 1,314.00 (819.05) 494.95 1,314.00 (819.05) 16,194.00 15,699.05 96.9%6321800 Taxes-Employer Payroll 360.29 1,636.00 (1,275.71) 360.29 1,636.00 (1,275.71) 20,426.00 20,065.71 98.2%6321880 Wages-Hourly 3,936.00 13,141.00 (9,205.00) 3,936.00 13,141.00 (9,205.00) 157,692.00 153,756.00 97.5%6321882 Wages-Overtime - - - - - - 6,370.00 6,370.00 100.0%Total-CM-LM-SALARIES & BENEFITS5,801.87 17,195.00 (11,393.13) 5,801.87 17,195.00 (11,393.13) 213,930.00 195,890.76 91.6%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools 3,932.62 100.00 3,832.62 3,932.62 100.00 3,832.62 1,025.00 (2,907.62) -283.7%6323788 Uniforms 180.74 240.00 (59.26) 180.74 240.00 (59.26) 2,880.00 2,699.26 93.7%Total-CM-LM-SUPPLIES & MATERIALS4,113.36 340.00 3,773.36 4,113.36 340.00 3,773.36 3,905.00 (208.36) -5.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 5,382.49 20,360.00 (14,977.51) 5,382.49 20,360.00 (14,977.51) 183,642.00 178,259.51 97.1%6337842 Utilities-Water166.76 1,814.00 (1,647.24) 166.76 1,814.00 (1,647.24) 18,126.00 17,959.24 99.1%Total-CM-WATER & ENERGY5,549.25 22,174.00 (16,624.75) 5,549.25 22,174.00 (16,624.75) 201,768.00 196,218.75 97.2%Total -COURSE MAINTENANCE122,512.37 136,983.00 (14,470.63) 122,512.37 136,983.00 (14,470.63) 1,739,809.00 1,605,059.26 92.3%Month to Date Year to DateSilverrock ResortCourse Maintenance Expense StatementJuly 2006Annual Budget5 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 420.00 420.00 - 420.00 420.00 - 6,240.00 5,820.00 93.3%6411320 Insurance-Group 1,623.63 720.00 903.63 1,623.63 720.00 903.63 8,640.00 7,016.37 81.2%6411325 Insurance-Workers Comp 379.80 1,293.00 (913.20) 379.80 1,293.00 (913.20) 16,944.00 16,564.20 97.8%6411800 Taxes-Employer Payroll 638.23 1,121.00 (482.77) 638.23 1,121.00 (482.77) 14,690.00 14,051.77 95.7%6411880 Wages-Hourly 4,933.66 9,006.00 (4,072.34) 4,933.66 9,006.00 (4,072.34) 117,992.00 113,058.34 95.8%6411882 Wages-Overtime 41.84 - 41.84 41.84 - 41.84 - (41.84) 0.0%Total-CBR-SALARIES & BENEFITS8,037.16 12,560.00 (4,522.84) 8,037.16 12,560.00 (4,522.84) 164,506.00 156,468.84 95.1%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - - - - - - 2,350.00 2,350.00 100.0%6413742 Supplies-Expendable 40.78 150.00 (109.22) 40.78 150.00 (109.22) 7,550.00 7,509.22 99.5%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 461.56 72.00 389.56 461.56 72.00 389.56 2,292.00 1,830.44 79.9%6413796 Supplies-Bottled Water1,142.32 1,571.00 (428.68) 1,142.32 1,571.00 (428.68) 22,631.00 21,488.68 95.0%Total-CBR-SUPPLIES & MATERIALS1,644.66 1,818.00 (173.34) 1,644.66 1,818.00 (173.34) 41,768.00 40,123.34 96.1%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 1,275.80 125.00 1,150.80 1,275.80 125.00 1,150.80 1,500.00 224.20 14.9%6415695 CBR-R&M-Cart Maintenance & Repair - 250.00 (250.00) - 250.00 (250.00) 3,000.00 3,000.00 100.0%Total-CBR-REPAIRS & MAINTENANCE 1,995.80 1,095.00 900.80 1,995.80 1,095.00 900.80 13,140.00 11,144.20 84.8%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps 60.00 100.00 (40.00) 60.00 100.00 (40.00) 5,000.00 4,940.00 98.8%6419094 Contract Services-Laundry/Linen - 155.00 (155.00) - 155.00 (155.00) 1,690.00 1,690.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 - - - - - - 4,625.00 4,625.00 100.0%Total-CBR-OTHER EXPENSES 60.00 455.00 (395.00) 60.00 455.00 (395.00) 13,365.00 13,305.00 99.6%TOTAL-CARTS,BAGROOM & RANGE 11,737.62 15,928.00 (4,190.38) 11,737.62 15,928.00 (4,190.38) 232,779.00 221,041.38 95.0%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 161.77 264.00 (102.23) 161.77 264.00 (102.23) 4,261.00 4,099.23 96.2%6431800 Taxes-Employer Payroll 95.19 329.00 (233.81) 95.19 329.00 (233.81) 5,305.00 5,209.81 98.2%6431880 Wages-Hourly 1,247.63 2,639.00 (1,391.37) 1,247.63 2,639.00 (1,391.37) 42,611.00 41,363.37 97.1%6431882 Wages-Overtime 11.25 - 11.25 11.25 - 11.25 - (11.25) 0.0%Total-CS-SALARIES & BENEFITS1,695.84 3,412.00 (1,716.16) 1,695.84 3,412.00 (1,716.16) 55,297.00 53,601.16 96.9%643-CS-OTHER EXPENSES6433742 Supplies Expendable 231.08 50.00 181.08 231.08 50.00 181.08 1,050.00 818.92 78.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,650.00 1,650.00 100.0%Total-CS-OTHER EXPENSES 231.08 175.00 56.08 231.08 175.00 56.08 3,500.00 3,268.92 93.4%Total-COURSE SERVICES 1,926.92 3,587.00 (1,660.08) 1,926.92 3,587.00 (1,660.08) 58,797.00 56,870.08 96.7%TOTAL OUTSIDE SERVICES13,664.54 19,515.00 (5,850.46) 13,664.54 19,515.00 (5,850.46) 291,576.00 274,642.54 94.2%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementJuly 2006Annual Budget6 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable490.33 400.00 90.33 490.33 400.00 90.33 4,800.00 4,309.67 89.8%Total-CH-SUPPLIES & MATERIALS 490.33 400.00 90.33 490.33 400.00 90.33 4,800.00 4,309.67 89.8%65-CH-UTILITIES6507830 Utilities-Electric-Bldgs- 4,073.00 (4,073.00) - 4,073.00 (4,073.00) 42,795.00 42,795.00 100.0%6507836 Utilities-Natural Gas281.23 200.00 81.23 281.23 200.00 81.23 2,400.00 2,118.77 88.3%6507838 Utilities-Sewer- 200.00 (200.00) - 200.00 (200.00) 2,400.00 2,400.00 100.0%6507840 Utilities-Telephone1,031.87 675.00 356.87 1,031.87 675.00 356.87 8,100.00 7,068.13 87.3%6507842 Utilities-Water274.67 200.00 74.67 274.67 200.00 74.67 2,400.00 2,125.33 88.6%6507844 Utilities-Cable- 317.00 (317.00) - 317.00 (317.00) 3,800.00 3,800.00 0.0%Total-CH-UTILITIES 1,587.77 5,665.00 (4,077.23) 1,587.77 5,665.00 (4,077.23) 61,895.00 60,307.23 97.4%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,750.00 75.00 1,825.00 1,750.00 75.00 21,000.00 19,175.00 91.3%6509098 Contract Services-Refuse Dispose323.06 400.00 (76.94) 323.06 400.00 (76.94) 4,800.00 4,476.94 93.3%6509099 Contract Services-Security7,627.76 7,800.00 (172.24) 7,627.76 7,800.00 (172.24) 93,600.00 85,972.24 91.9%6509215 Flowers & Decorations- 100.00 (100.00) - 100.00 (100.00) 2,600.00 2,600.00 100.0%6509490 Miscellaneous- - - - - - - - 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,775.82 10,150.00 (374.18) 9,775.82 10,150.00 (374.18) 123,200.00 113,424.18 92.1%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- 200.00 (200.00) - 200.00 (200.00) 2,400.00 2,400.00 100.0%6515690 CH-R&M-Equipment Repair- 200.00 (200.00) - 200.00 (200.00) 2,400.00 2,400.00 100.0%Total-CH-REPAIRS & MAINTENANCE - 600.00 (600.00) - 600.00 (600.00) 7,200.00 7,200.00 100.0%Total CLUBHOUSE11,853.92 16,815.00 (4,961.08) 11,853.92 16,815.00 (4,961.08) 197,095.00 14,400.00 7.3%Month to Date Year to DateSilverRock ResortClubhouse Expense StatementJuly 2006Annual Budget7 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 60.00 60.00 - 720.00 660.00 91.7%6601320 Insurance-Group - 150.00 (150.00) - 150.00 (150.00) 1,800.00 1,800.00 100.0%6601325 Insurance-Workers Comp 191.15 317.00 (125.85) 191.15 317.00 (125.85) 3,800.00 3,608.85 95.0%6601720 Salaries 538.56 3,167.00 (2,628.44) 538.56 3,167.00 (2,628.44) 38,004.00 37,465.44 98.6%6601800 Taxes-Employer Payroll 41.20 394.00 (352.80) 41.20 394.00 (352.80) 4,731.00 4,689.80 99.1%Total-MKT-SALARIES & BENEFITS 830.91 4,088.00 (3,257.09) 830.91 4,088.00 (3,257.09) 49,055.00 48,224.09 98.3%66-MKT-SUPPLIES & MATERIALS6603080 Collateral Material 832.86 - 832.86 832.86 - 832.86 - (832.86) 0.0%6603762 Supplies-Office - 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery - - - - - - 4,425.00 4,425.00 100.0%832.86 100.00 732.86 832.86 100.00 732.86 5,625.00 4,792.14 85.2%66-MKT-UTILITIES6607840 Utilities-Telephone 99.37 100.00 (0.63) 99.37 100.00 (0.63) 1,200.00 1,100.63 91.7%Total-MKT-UTILITIES 99.37 100.00 (0.63) 99.37 100.00 (0.63) 1,200.00 1,100.63 91.7%66-MKT-OTHER EXPENSES6609010 Advertising 5,515.87 5,085.00 430.87 5,515.87 5,085.00 430.87 175,290.00 169,774.13 96.9%6609040 Business Meals - 25.00 (25.00) - 25.00 (25.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) 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 - - - - - - - - 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 - - - - - - 735.00 735.00 0.0%6609820 Uniforms - - - - - - 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 5,614.87 5,410.00 204.87 5,614.87 5,410.00 204.87 192,600.00 186,285.13 96.7%Total-MARKETING7,378.01 9,698.00 (2,319.99) 7,378.01 9,698.00 (2,319.99) 248,480.00 240,401.99 96.7%Month to Date Year to DateSilverRock ResortMarketing Expense StatementJuly 2006Annual 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,506.25 2,280.00 (773.75) 1,506.25 2,280.00 (773.75) 27,360.00 25,853.75 94.5%6701325 Insurance-Workers Comp1,177.42 1,598.00 (420.58) 1,177.42 1,598.00 (420.58) 19,176.00 17,998.58 93.9%6701720 Salaries 11,827.84 13,250.00 (1,422.16) 11,827.84 13,250.00 (1,422.16) 159,000.00 147,172.16 92.6%6701800 Taxes-Employer Payroll 1,126.57 1,989.00 (862.43) 1,126.57 1,989.00 (862.43) 23,874.00 22,747.43 95.3%6701880 Wages-Hourly2,480.08 2,730.00 (249.92) 2,480.08 2,730.00 (249.92) 32,756.00 30,275.92 92.4%6701882 Wages-Overtime 418.50 - 418.50 418.50 - 418.50 - (418.50) 0.0%Total-G&A-SALARIES & BENEFITS 18,716.66 22,027.00 (3,310.34) 18,716.66 22,027.00 (3,310.34) 264,326.00 245,609.34 92.9%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 500.00 (500.00) - 500.00 (500.00) 6,000.00 6,000.00 100.0%6703762 Supplies-Office - 125.00 (125.00) - 125.00 (125.00) 1,500.00 1,500.00 100.0%6703768 Supplies-Printing & Stationery101.49 - 101.49 101.49 - 101.49 3,200.00 3,098.51 96.8%6703778Supplies-Small Tools/Non-Capital - - - - - - 900.00 900.00 100.0%Total-G&A-SUPPLIES & MATERIALS 101.49 625.00 (523.51) 101.49 625.00 (523.51) 11,600.00 11,498.51 99.1%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 Services- - - - - - - 0.0%6709150 Dues & Subscriptions- 50.00 (50.00) - 50.00 (50.00) 1,500.00 1,500.00 100.0%6709180 Employee Recruiting/Relocation193.00 - 193.00 193.00 - 193.00 2,000.00 1,807.00 90.4%6709197 Equipment Rental467.91 350.00 117.91 467.91 350.00 117.91 4,200.00 3,732.09 88.9%6709202 Fees-Bank53.23 300.00 (246.77) 53.23 300.00 (246.77) 3,600.00 3,546.77 98.5%6709208 Fees-Payroll Processing- 550.00 (550.00) - 550.00 (550.00) 6,600.00 6,600.00 0.0%6709220 Freight/Delivery138.60 50.00 88.60 138.60 50.00 88.60 600.00 461.40 76.9%6709490 Miscellaneous - 100.00 (100.00) - 100.00 (100.00) 1,200.00 1,200.00 100.0%6709620 Postage/Mail Services 32.30 75.00 (42.70) 32.30 75.00 (42.70) 900.00 867.70 96.4%6709625 Professional Fees390.00 400.00 (10.00) 390.00 400.00 (10.00) 4,800.00 4,410.00 91.9%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,675.04 2,550.00 (874.96) 1,675.04 2,550.00 (874.96) 34,450.00 32,774.96 95.1%Total-GENERAL & ADMINISTRATIVE20,493.19 25,302.00 (4,808.81) 20,493.19 25,302.00 (4,808.81) 311,576.00 291,082.81 93.4%Month to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementJuly 2006Annual Budget9 JulyFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 8,021.86 9,800.00 (1,778.14) 8,021.86 9,800.00 (1,778.14) 117,600.00 109,578.14 93.2%6800193 Equipment Leases-Course Maint 17,845.71 20,000.00 (2,154.29) 17,845.71 20,000.00 (2,154.29) 240,000.00 222,154.29 92.6%6800194 Equipment Leases-Trailer 310.41 600.00 (289.59) 310.41 600.00 (289.59) 7,200.00 6,889.59 95.7%6800195 Equipment Leases-Software 1,372.93 1,525.00 (152.07) 1,372.93 1,525.00 (152.07) 18,300.00 16,927.07 92.5%6800196 Equipment Leases-GPS 7,370.25 7,400.00 (29.75) 7,370.25 7,400.00 (29.75) 88,800.00 81,429.75 91.7%Total-LEASES34,921.16 39,325.00 (4,403.84) 34,921.16 39,325.00 (4,403.84) 471,900.00 436,978.84 92.6%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 17,210.83 18,731.00 (1,520.17) 17,210.83 18,731.00 (1,520.17) 125,196.00 107,985.17 86.3%6900210 FF&E Reserve 1,709.01 2,040.00 (330.99) 1,709.01 2,040.00 (330.99) 67,426.00 65,716.99 97.5%6900211 Personal Property Taxes20,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 50,400.00 100.0%Total-MISC OTHER EXPENSES18,919.84 24,971.00 (6,051.16) 18,919.84 24,971.00 (6,051.16) 263,022.00 244,102.16 92.8% Operating Leases & Miscellaneous Other Expense StatementJuly 2006Annual BudgetMonth to Date Year to Date10 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2006‐20072006 2006 2006 2006 2006 2006Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia6Sales7Promotion4Golf Industry20VIP6Celebrity0PGA Comp27Charity/Gift Certificate6Rain/Wind Checks0Club Staff20LQ HS Golf096000002007 2007 2007 2007 2007 2007Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011