Loading...
01 July 2009 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2009 – July 2009 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 July Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 94,590.50 86,376.00 8,214.50 9.5% 94,590.50 86,376.00 8,214.50 2,980,503.00 2,885,912.50 3%401000 Miscellaneous Golf Revenue 5,825.10 7,462.00 (1,636.90) -21.9% 5,825.10 7,462.00 (1,636.90) 109,297.00 103,471.90 5%410000 Revenue-Golf Shop 8,201.12 10,751.00 (2,549.88) -23.7% 8,201.12 10,751.00 (2,549.88) 325,551.00 317,349.88 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 7.37 - 7.37 0.0% 7.37 - 7.37 - (7.37) 0%Total Income109,124.09 105,089.00 4,035.09 3.8% 109,124.09 105,089.00 4,035.09 3,427,351.00 3,318,226.91 3%Cost of Goods Sold510000 COS-Golf Shop 4,449.13 5,706.05 (1,256.92) 22.0% 4,449.13 5,706.05 1,256.92 172,786.05 168,336.92 3%Total COS4,449.13 5,706.05 (1,256.92) 22.0% 4,449.13 5,706.05 1,256.92 172,786.05 168,336.92 3%Gross Profit104,674.96 99,382.95 5,292.01 5.3% 104,674.96 99,382.95 5,292.01 3,254,564.95 3,149,889.99 3%Expenses610000 Golf Pro Shop 13,791.22 18,812.00 5,020.78 26.7% 13,791.22 18,812.00 5,020.78 243,485.00 229,693.78 6%630000 Course Maintenance 109,099.12 121,909.00 12,809.88 10.5% 109,099.12 121,909.00 12,809.88 1,594,579.00 1,485,479.88 7%633000 Maintenance Water & Energy 7,343.29 6,814.00 (529.29) -7.8% 7,343.29 6,814.00 (529.29) 86,871.00 79,527.71 8%640000 Outside Services 16,026.56 18,322.00 2,295.44 12.5% 16,026.56 18,322.00 2,295.44 277,000.00 260,973.44 6%650000 Clubhouse 10,999.04 9,742.00 (1,257.04) -12.9% 10,999.04 9,742.00 (1,257.04) 118,900.00 107,900.96 9%660000 Marketing 8,440.85 6,007.00 (2,433.85) -40.5% 8,440.85 6,007.00 (2,433.85) 256,759.00 248,318.15 3%670000 General & Administrative21,668.00 25,412.00 3,744.00 14.7% 21,668.00 25,412.00 3,744.00 316,394.00 294,726.00 7%680000 Leases 40,353.57 37,453.00 (2,900.57) -7.7% 40,353.57 37,453.00 (2,900.57) 432,204.00 391,850.43 9%690000 Miscellaneous Other Expense 29,695.74 51,215.00 21,519.26 42.0% 29,695.74 51,215.00 21,519.26 211,610.00 181,914.26 14%Total Expenses257,417.39 295,686.00 38,268.61 12.9% 257,417.39 295,686.00 38,268.61 3,537,802.00 3,280,384.61 7%Net Income (152,742.43) (196,303.05) 43,560.62 22.2%(152,742.43) (196,303.05) 43,560.62 (283,237.05) (130,494.62) 54%Rounds of Golf PlayedPaid Rounds Played 2,697 2,150 547 25.4% 2,697 2,150 547 39,150 36,453 7%Ave $ Per Paid Round Green Fee 35.07 40.17 (5.10) -12.7% 35.07 40.17 (5.10) 76.13 41.06 46%Ave $ Per Paid Round Merchandise 3.04 5.00 (1.96) -39.2% 3.04 5.00 (1.96) 8.07 5.03 38%Ave $ Per Paid Miscellaneous 2.16 3.47 (1.31) -37.8% 2.16 3.47 (1.31) 2.06 - 0%Month to Date Year to DateJuly 2009SilverRock ResortSummary Operating Income Statement Income July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 94,590.50 86,376.00 8,214.50 94,590.50 86,376.00 8,214.50 2,980,503.002,885,912.503%4010000 Rider Fee 1,300.00 2,129.00 (829.00) 1,300.00 2,129.00 (829.00) 5,829.004,529.0022%4040000 Club Rental 675.00 1,183.00 (508.00) 675.00 1,183.00 (508.00) 26,168.0025,493.003%4050000 Driving Range 1,833.00 2,150.00 (317.00) 1,833.00 2,150.00 (317.00) 44,300.0042,467.004%4060000 Handicap Fees 90.00 - 90.00 90.00 - 90.00 8,000.00 7,910.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 1,904.60 1,000.00 904.60 1,904.60 1,000.00 904.60 4,000.00 2,095.4048%4091000 Golf Professional Rental Fee - - - - - - 9,000.00 9,000.00 0%4092000 Golf Lessons 22.50 - 22.50 22.50 - 22.50 - (22.50) 0% Total Revenue Fees 100,415.60 93,838.00 6,577.60 100,415.60 93,838.00 6,577.60 3,089,800.00 2,989,384.40 3%Total Income 100,415.60 93,838.00 6,577.60 100,415.60 93,838.00 6,577.60 3,089,800.00 2,989,384.40 3%SilverRock ResortStatement of Fees RevenueJuly 2009Month to Date Year to Date Annual Budget Income July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 239.99 - 239.99 239.99 - 239.99 4100110 Sales Hard Goods 4,104.42 3,763.00 341.42 4,104.42 3,763.00 341.42 113,943.00 109,838.58 4%4100112 Sales-Soft Goods 5,198.21 6,988.00 (1,789.79) 5,198.21 6,988.00 (1,789.79) 211,608.00 206,409.79 2%5100639 GS-Discounts-Mdse (1,341.50) - (1,341.50) (1,341.50) - (1,341.50) - 1,341.50 0% Total Revenue Golf Shop 8,201.12 10,751.00 (2,549.88) 8,201.12 10,751.00 (2,549.88) 325,551.00 317,589.87 2%COS 5100150 COS-GS-Hard Goods 2,154.04 2,069.65 84.39 2,154.04 2,069.65 84.39 62,668.65 60,514.61 3%5100151 COS-GS-Soft Goods 2,223.22 3,843.40 (1,620.18) 2,223.22 3,843.40 (1,620.18) 116,384.40 114,161.18 2%5100152 COS-GS-Purchase Disc (78.95) (296.00) 217.05 (78.95) (296.00) 217.05 (8,953.00) (8,874.05) -1%5100220 COS-GS-Freight Merch 150.82 89.00 61.82 150.82 89.00 61.82 2,686.00 2,535.18 6%Cost of Sales - Golf Shop 4,449.13 5,706.05 (1,256.92) 4,449.13 5,706.05 (1,256.92) 172,786.05 168,336.92 3%Gross Profit 3,751.99 5,044.95 (1,292.96) 3,751.99 5,044.95 (1,292.96) 152,764.95 149,252.95 2%COS % 54.3% 53.1% -1.2% 54.3% 53.1% -1.2% 53.1% 53.0% 0%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 360.00 360.00 - 360.00 360.00 - 5,400.00 5,040.00 7%6101320 Insurance Group 1,960.18 1,986.00 (25.82) 1,960.18 1,986.00 (25.82) 26,811.00 24,850.82 7%6101325 Insurance-Workers Comp 522.89 713.00 (190.11) 522.89 713.00 (190.11) 9,229.00 8,706.11 6%6101720 Salaries 3,545.46 3,582.00 (36.54) 3,545.46 3,582.00 (36.54) 20,796.00 17,250.54 17%6101800 Taxes-Employer Payroll 790.31 1,554.00 (763.69) 790.31 1,554.00 (763.69) 20,123.00 19,332.69 4%6101880 Wages-Hourly 5,869.22 8,897.00 (3,027.78) 5,869.22 8,897.00 (3,027.78) 140,831.00 134,961.78 4%6101882 Wages-Overtime 92.25 - 92.25 92.25 - 92.25 - 952.88 0%Total -PS-SALARIES & BENEFITS 13,140.31 17,092.00 (3,951.69) 13,140.31 17,092.00 (3,951.69) 223,190.00 211,094.82 5%61-PS OTHER EXPENSES6103762 Supplies-Office - 300.00 (300.00) - 300.00 (300.00) 2,950.00 2,950.00 0%6109090 Contract Services 500.00 500.00 - 500.00 500.00 - 6,000.00 5,500.00 8%6109220 Freight & Delivery 46.58 - 46.58 46.58 - 46.58 75.00 28.42 62%6109490 Miscellaneous - - - - - - 450.00 450.00 0%6109150 Dues and Subscriptions - - - - - - 2,000.00 2,000.00 0%6109500 ProShop-Over/Short 41.01 - 41.01 41.01 - 41.01 - (41.01) 0%6109722 Seminars/Training - 750.00 (750.00) - 750.00 (750.00) 5,490.00 5,490.00 0%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms - 100.00 (100.00) - 100.00 (100.00) 2,400.00 2,400.00 0%6117840 Telephones 63.32 70.00 (6.68) 63.32 70.00 (6.68) 840.00 776.68 0%Total PS-OTHER EXPENSES 650.91 1,720.00 (1,069.09) 650.91 1,720.00 (1,069.09) 20,295.00 19,644.09 3%Total Expenses13,791.22 18,812.00 (5,020.78) 13,791.22 18,812.00 (5,020.78) 243,485.00 230,738.91 5%Net Income(10,039.23) (13,767.05) 3,727.82 (10,039.23) (13,767.05) 3,727.82 (90,720.05) (81,485.96) -10%Month to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementJuly 2009 July Final 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 9,270.17 8,740.00 530.17 9,270.17 8,740.00 530.17 104,880.00 95,609.83 91.2%6311325 Insurance-Workers Comp 2,893.72 3,226.00 (332.28) 2,893.72 3,226.00 (332.28) 39,329.00 36,435.28 92.6%6311720 Salaries 11,001.60 12,331.00 (1,329.40) 11,001.60 12,331.00 (1,329.40) 147,972.00 136,970.40 92.6%6311800 Taxes-Employer Payroll 4,173.61 7,033.00 (2,859.39) 4,173.61 7,033.00 (2,859.39) 86,420.00 82,246.39 95.2%6311880 Wages-Hourly 41,272.02 44,159.00 (2,886.98) 41,272.02 44,159.00 (2,886.98) 529,928.00 488,655.98 92.2%6311882 Wages-Overtime 339.44 - 339.44 339.44 - 339.44 16,234.00 15,894.56 97.9%Total-CM-SALARIES & BENEFITS69,190.56 75,729.00 (6,538.44) 69,190.56 75,729.00 (6,538.44) 927,643.00 858,452.44 92.5%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 1,830.53 3,500.00 (1,669.47) 1,830.53 3,500.00 (1,669.47) 29,300.00 27,469.47 93.8%6313744 Fertilizer 8,450.97 5,500.00 2,950.97 8,450.97 5,500.00 2,950.97 92,200.00 83,749.03 90.8%6313745 Herbicides - - - - - - 10,000.00 10,000.00 100.0%6313746 Flowers/Plants - - - - - - 3,500.00 3,500.00 100.0%6313748 Fuel-Gasoline 3,675.79 3,600.00 75.79 3,675.79 3,600.00 75.79 43,100.00 39,424.21 91.5%6313750 Golf Course Accessories 143.55 200.00 (56.45) 143.55 200.00 (56.45) 8,000.00 7,856.45 98.2%6313756 POA Control 190.49 - 190.49 190.49 - 190.49 7,000.00 6,809.51 97.3%6313758 Miscellaneous Supp 597.02 750.00 (152.98) 597.02 750.00 (152.98) 4,350.00 3,752.98 0.0%6313762 Supplies-Office 122.92 - 122.92 122.92 - 122.92 - (122.92) 0.0%6313774 Sand - 390.00 (390.00) - 390.00 (390.00) - - 0.0%6313775 Sand-Bunkers - - - - - - 11,460.00 11,460.00 100.0%6313776 Seed - 350.00 (350.00) - 350.00 (350.00) 91,810.00 91,810.00 100.0%6313778 Small Tools & Non-Capital Equip 668.89 100.00 568.89 668.89 100.00 568.89 5,000.00 4,331.11 86.6%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,250.00 (1,250.00) - 1,250.00 (1,250.00) 7,600.00 7,600.00 100.0%Total-CM-SUPPLIES & MATERIALS15,680.16 16,640.00 (959.84) 15,680.16 16,640.00 (959.84) 319,070.00 303,389.84 95.1%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,863.75 1,500.00 363.75 1,863.75 1,500.00 363.75 17,000.00 15,136.25 89.0%6315685 CM-R&M-Bldngs & Othr Structures 121.00 250.00 (129.00) 121.00 250.00 (129.00) 1,750.00 1,629.00 93.1%6315690 CM-R&M-Equipment 4,643.91 4,400.00 243.91 4,643.91 4,400.00 243.91 35,700.00 31,056.09 87.0%6315692 CM-R&M-Irrigation System 1,340.25 2,100.00 (759.75) 1,340.25 2,100.00 (759.75) 16,050.00 14,709.75 91.6%6315696 CM-R&M-Pumps - 1,000.00 (1,000.00) - 1,000.00 (1,000.00) 10,500.00 10,500.00 100.0%6315815 CM-R&M-Trees-Pruning Etc - - - - - - 10,050.00 10,050.00 100.0%Total-CM-REPAIRS & MAINTENANCE 7,968.91 9,250.00 (1,281.09) 7,968.91 9,250.00 (1,281.09) 91,050.00 83,081.09 91.2%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs 5.38 - 5.38 5.38 - 5.38 (5.38) 0.0%6317836 Utilities-Natural Gas/LPG - 50.00 (50.00) - 50.00 (50.00) 600.00 600.00 0.0%6317840 Telephones 919.46 850.00 69.46 919.46 850.00 69.46 10,200.00 9,280.54 91.0%Total-CM-UTILITIES 924.84 900.00 24.84 924.84 900.00 24.84 10,800.00 9,875.16 91.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 Bldgs - - - - - - - 0.0%6319100 Contract Svcs-Soil/Tissue Test - - - - - - 4,000.00 4,000.00 100.0%6319101 Contract Svcs-Trash Removal 487.83 524.00 (36.17) 487.83 524.00 (36.17) 6,288.00 5,800.17 0.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) 1,550.00 1,550.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) 680.00 680.00 100.0%6319490 Miscellaneous 350.18 100.00 250.18 350.18 100.00 250.18 1,200.00 849.82 70.8%6319718 Safety Equipment & Training 212.14 100.00 112.14 212.14 100.00 112.14 2,600.00 2,387.86 91.8%6319822 Uniforms 742.85 820.00 (77.15) 742.85 820.00 (77.15) 9,840.00 9,097.15 92.5%Total-CM-OTHER EXPENSES 2,293.00 2,594.00 (301.00) 2,293.00 2,594.00 (301.00) 37,258.00 34,965.00 93.8%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementJuly 2009Annual Budget July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,504.23 2,317.00 (812.77) 1,504.23 2,317.00 (812.77) 27,804.00 26,299.77 94.6%6321325 Insurance-Workers Comp 540.73 669.00 (128.27) 540.73 669.00 (128.27) 8,229.00 7,688.27 93.4%6321800 Taxes-Employer Payroll 769.93 1,458.00 (688.07) 769.93 1,458.00 (688.07) 18,154.00 17,384.07 95.8%6321880 Wages-Hourly 9,831.37 11,712.00 (1,880.63) 9,831.37 11,712.00 (1,880.63) 140,544.00 130,712.63 93.0%6321882 Wages-Overtime 233.01 - 233.01 233.01 - 233.01 5,272.00 5,038.99 95.6%Total-CM-LM-SALARIES & BENEFITS12,879.27 16,156.00 (3,276.73) 12,879.27 16,156.00 (3,276.73) 200,003.00 187,123.73 93.6%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 162.38 290.00 (127.62) 162.38 290.00 (127.62) 3,480.00 3,317.62 95.3%Total-CM-LM-SUPPLIES & MATERIALS162.38 390.00 (227.62) 162.38 390.00 (227.62) 4,505.00 4,342.62 96.4%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%109,099.12 121,909.00 (12,809.88) 109,099.12 121,909.00 (12,809.88) 1,594,579.00 1,485,479.88 93.2% July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 3,262.84 5,000.00 (1,737.16) 3,262.84 5,000.00 (1,737.16) 65,000.00 61,737.16 95.0%6337842 Utilities-Water4,080.45 1,814.00 2,266.45 4,080.45 1,814.00 2,266.45 21,871.00 17,790.55 81.3%Total-CM-WATER & ENERGY 7,343.29 6,814.00 529.29 7,343.29 6,814.00 529.29 86,871.00 79,527.71 91.5%Silverrock ResortCourse Maintenance Expense StatementJuly 2009Annual BudgetMonth to DateMonth to Date Year to Date Annual BudgetYear to DateSilverrock ResortCourse Maintenance Water & EnergyJuly 2009Total -COURSE MAINTENANCE July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 420.00 420.00 - 420.00 420.00 - 6,960.00 6,540.00 94.0%6411320 Insurance-Group 63.25 662.00 (598.75) 63.25 662.00 (598.75) 7,944.00 7,880.75 99.2%6411325 Insurance-Workers Comp 414.75 1,303.00 (888.25) 414.75 1,303.00 (888.25) 16,162.00 15,747.25 97.4%6411800 Taxes-Employer Payroll 789.02 1,130.00 (340.98) 789.02 1,130.00 (340.98) 14,012.00 13,222.98 94.4%6411880 Wages-Hourly 7,540.89 9,075.00 (1,534.11) 7,540.89 9,075.00 (1,534.11) 112,549.00 105,008.11 93.3%6411882 Wages-Overtime - - - - - - - - 0.0%Total-CBR-SALARIES & BENEFITS9,227.91 12,590.00 (3,362.09) 9,227.91 12,590.00 (3,362.09) 157,627.00 148,399.09 94.1%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - - - - - - 2,350.00 2,350.00 100.0%6413742 Supplies-Expendable 592.04 150.00 442.04 592.04 150.00 442.04 5,000.00 4,407.96 88.2%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 - 72.00 (72.00) - 72.00 (72.00) 892.00 892.00 100.0%6413796 Supplies-Bottled Water604.29 400.00 204.29 604.29 400.00 204.29 19,400.00 18,795.71 96.9%Total-CBR-SUPPLIES & MATERIALS1,196.33 647.00 549.33 1,196.33 647.00 549.33 34,587.00 33,390.67 96.5%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 92.14 300.00 (207.86) 92.14 300.00 (207.86) 3,600.00 3,507.86 97.4%6415695 CBR-R&M-Cart Maintenance & Repair 481.54 500.00 (18.46) 481.54 500.00 (18.46) 4,000.00 3,518.46 88.0%Total-CBR-REPAIRS & MAINTENANCE 1,293.68 1,520.00 (226.32) 1,293.68 1,520.00 (226.32) 16,240.00 14,946.32 92.0%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps 635.00 100.00 535.00 635.00 100.00 535.00 5,000.00 4,365.00 87.3%6419094 Contract Services-Laundry/Linen 1,296.85 500.00 796.85 1,296.85 500.00 796.85 6,000.00 4,703.15 78.4%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 1,931.85 800.00 1,131.85 1,931.85 800.00 1,131.85 18,675.00 16,743.15 89.7%TOTAL-CARTS,BAGROOM & RANGE 13,649.77 15,557.00 (1,907.23) 13,649.77 15,557.00 (1,907.23) 227,129.00 213,479.23 94.0%643-CS-SALARIES & BENEFITS6431175 Employee Meals 180.00 180.00 - 180.00 180.00 - 3,300.00 3,120.00 94.5%6431325 Insurance-Workers Comp 101.75 116.00 (14.25) 101.75 116.00 (14.25) 2,069.00 1,967.25 95.1%6431800 Taxes-Employer Payroll 245.04 254.00 (8.96) 245.04 254.00 (8.96) 4,512.00 4,266.96 94.6%6431880 Wages-Hourly 1,850.00 2,040.00 (190.00) 1,850.00 2,040.00 (190.00) 36,240.00 34,390.00 94.9%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS2,376.79 2,590.00 (213.21) 2,376.79 2,590.00 (213.21) 46,121.00 43,744.21 94.8%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%Total-CS-OTHER EXPENSES - 175.00 (175.00) - 175.00 (175.00) 3,750.00 3,750.00 100.0%Total-COURSE SERVICES 2,376.79 2,765.00 (388.21) 2,376.79 2,765.00 (388.21) 49,871.00 47,494.21 95.2%TOTAL OUTSIDE SERVICES 16,026.56 18,322.00 (2,295.44) 16,026.56 18,322.00 (2,295.44) 277,000.00 257,223.44 92.9%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementJuly 2009Annual Budget July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) - 400.00 (400.00) 4,800.00 4,800.00 100.0%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) - 400.00 (400.00) 4,800.00 4,800.00 100.0%65-CH-UTILITIES6507836 Utilities-Natural Gas441.52 300.00 141.52 441.52 300.00 141.52 3,600.00 3,158.48 87.7%6507838 Utilities-Sewer- 200.00 (200.00) - 200.00 (200.00) 2,400.00 2,400.00 100.0%6507840 Utilities-Telephone989.08 1,000.00 (10.92) 989.08 1,000.00 (10.92) 12,000.00 11,010.92 91.8%6507842 Utilities-Water593.66 200.00 393.66 593.66 200.00 393.66 2,400.00 1,806.34 75.3%6507844 Utilities-Cable319.90 317.00 2.90 319.90 317.00 2.90 3,800.00 3,480.10 91.6%Total-CH-UTILITIES 2,344.16 2,017.00 327.16 2,344.16 2,017.00 327.16 24,200.00 21,855.84 90.3%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning2,020.00 1,825.00 195.00 2,020.00 1,825.00 195.00 22,500.00 20,480.00 91.0%6509098 Contract Services-Refuse Dispose291.34 - 291.34 291.34 - 291.34 - (291.34) 0.0%6509099 Contract Services-Security5,905.68 4,100.00 1,805.68 5,905.68 4,100.00 1,805.68 49,200.00 43,294.32 88.0%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 100.0%6509718 Safety Equipment & Training223.86 100.00 123.86 223.86 100.00 123.86 1,200.00 976.14 81.3%Total-CH-OTHER EXPENSES 8,440.88 6,325.00 2,115.88 8,440.88 6,325.00 2,115.88 77,900.00 69,459.12 89.2%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures79.00 200.00 (121.00) 79.00 200.00 (121.00) 2,400.00 2,321.00 96.7%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 Repair135.00 400.00 (265.00) 135.00 400.00 (265.00) 4,800.00 4,665.00 97.2%Total-CH-REPAIRS & MAINTENANCE 214.00 1,000.00 (786.00) 214.00 1,000.00 (786.00) 12,000.00 11,786.00 98.2%Total CLUBHOUSE 10,999.04 9,742.00 1,257.04 10,999.04 9,742.00 1,257.04 118,900.00 23,572.00 19.8%Month to Date Year to DateSilverRock ResortClubhouse Expense StatementJuly 2009Annual Budget July Final 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 286.36 331.00 (44.64) 286.36 331.00 (44.64) 3,972.00 3,685.64 92.8%6601325 Insurance-Workers Comp 137.50 143.00 (5.50) 137.50 143.00 (5.50) 1,713.00 1,575.50 92.0%6601720 Salaries 2,500.00 2,500.00 - 2,500.00 2,500.00 - 30,000.00 27,500.00 91.7%6601800 Taxes-Employer Payroll 311.00 311.00 - 311.00 311.00 - 3,735.00 3,424.00 91.7%Total-MKT-SALARIES & BENEFITS 3,294.86 3,345.00 (50.14) 3,294.86 3,345.00 (50.14) 40,140.00 36,845.14 91.8%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 140.15 100.00 40.15 140.15 100.00 40.15 1,200.00 1,059.85 88.3%6603768 Supplies-Printing & Stationery - - - - - - 4,425.00 4,425.00 100.0%140.15 100.00 40.15 140.15 100.00 40.15 5,625.00 5,484.85 97.5%66-MKT-UTILITIES6607840 Utilities-Telephone 46.00 100.00 (54.00) 46.00 100.00 (54.00) 1,200.00 1,154.00 96.2%Total-MKT-UTILITIES 46.00 100.00 (54.00) 46.00 100.00 (54.00) 1,200.00 1,154.00 96.2%66-MKT-OTHER EXPENSES6609010 Advertising 4,482.73 2,137.00 2,345.73 4,482.73 2,137.00 2,345.73 185,984.00 181,501.27 97.6%6609040 Business Meals - 25.00 (25.00) - 25.00 (25.00) 300.00 300.00 100.0%6609080 Collateral Material 163.11 - 163.11 163.11 - 163.11 9,000.00 8,836.89 98.2%6609102 Contract Services-Web Page 174.00 175.00 (1.00) 174.00 175.00 (1.00) 2,100.00 1,926.00 91.7%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 - - - - - - 700.00 700.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/Vendor - - - - - - 6,500.00 - 0.0%6609150 Dues and Subscriptions 140.00 - 140.00 140.00 - 140.00 735.00 595.00 81.0%6609820 Uniforms - - - - - - 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 4,959.84 2,462.00 2,497.84 4,959.84 2,462.00 2,497.84 209,794.00 198,334.16 94.5%Total-MARKETING 8,440.85 6,007.00 2,433.85 8,440.85 6,007.00 2,433.85 256,759.00 241,818.15 94.2%Month to Date Year to DateSilverRock ResortMarketing Expense StatementJuly 2009Annual Budget July Final 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,175.09 1,458.00 (282.91) 1,175.09 1,458.00 (282.91) 17,496.00 16,320.91 93.3%6701325 Insurance-Workers Comp841.42 981.00 (139.58) 841.42 981.00 (139.58) 11,772.00 10,930.58 92.9%6701720 Salaries 13,503.32 14,534.00 (1,030.68) 13,503.32 14,534.00 (1,030.68) 174,408.00 160,904.68 92.3%6701800 Taxes-Employer Payroll 1,169.87 2,140.00 (970.13) 1,169.87 2,140.00 (970.13) 25,680.00 24,510.13 95.4%6701880 Wages-Hourly1,789.17 2,654.00 (864.83) 1,789.17 2,654.00 (864.83) 31,848.00 30,058.83 94.4%6701882 Wages-Overtime 5.91 - 5.91 5.91 - 5.91 - (5.91) 0.0%Total-G&A-SALARIES & BENEFITS 18,664.78 21,947.00 (3,282.22) 18,664.78 21,947.00 (3,282.22) 263,364.00 244,699.22 92.9%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer350.00 800.00 (450.00) 350.00 800.00 (450.00) 10,800.00 10,450.00 96.8%6703762 Supplies-Office 118.41 125.00 (6.59) 118.41 125.00 (6.59) 1,500.00 1,381.59 92.1%6703768 Supplies-Printing & Stationery- - - - - - 3,200.00 3,200.00 100.0%6703778Supplies-Small Tools/Non-Capital - - - - - - 900.00 900.00 100.0%Total-G&A-SUPPLIES & MATERIALS 468.41 925.00 (456.59) 468.41 925.00 (456.59) 16,400.00 15,931.59 97.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%6709150 Dues & Subscriptions- 50.00 (50.00) - 50.00 (50.00) 1,500.00 1,500.00 100.0%6709180 Employee Recruiting/Relocation56.00 - 56.00 56.00 - 56.00 2,600.00 2,544.00 97.8%6709197 Equipment Rental435.51 350.00 85.51 435.51 350.00 85.51 4,200.00 3,764.49 89.6%6709202 Fees-Bank26.96 90.00 (63.04) 26.96 90.00 (63.04) 1,080.00 1,053.04 97.5%6709208 Fees-Payroll Processing674.92 550.00 124.92 674.92 550.00 124.92 6,600.00 5,925.08 89.8%6709220 Freight/Delivery- 50.00 (50.00) - 50.00 (50.00) 600.00 600.00 100.0%6709490 Miscellaneous 198.26 100.00 98.26 198.26 100.00 98.26 1,200.00 1,001.74 83.5%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services 268.16 75.00 193.16 268.16 75.00 193.16 900.00 631.84 70.2%6709625 Professional Fees475.00 400.00 75.00 475.00 400.00 75.00 4,800.00 4,325.00 90.1%6709636 Promotion/Entertainment- 100.00 (100.00) - 100.00 (100.00) 2,600.00 2,600.00 100.0%6709722 Seminars & Training- 200.00 (200.00) - 200.00 (200.00) 2,400.00 2,400.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 2,534.81 2,440.00 94.81 2,534.81 2,440.00 94.81 35,430.00 32,895.19 92.8%Total-GENERAL & ADMINISTRATIVE21,668.00 25,412.00 (3,744.00) 21,668.00 25,412.00 (3,744.00) 316,394.00 294,726.00 93.2%Month to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementJuly 2009Annual Budget July Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,581.04 11,581.00 0.04 11,581.04 11,581.00 0.04 138,972.00 127,390.96 91.7%6800193 Equipment Leases-Course Maint 16,244.12 16,500.00 (255.88) 16,244.12 16,500.00 (255.88) 189,000.00 172,755.88 91.4%6800194 Equipment Leases-Trailer 549.50 600.00 (50.50) 549.50 600.00 (50.50) 7,200.00 6,650.50 92.4%6800195 Equipment Leases-Software 1,791.93 1,372.00 419.93 1,791.93 1,372.00 419.93 8,232.00 6,440.07 78.2%6800196 Equipment Leases-GPS 7,557.95 7,400.00 157.95 7,557.95 7,400.00 157.95 88,800.00 81,242.05 91.5%6800197 Equipment Leases-Others 2,629.03 - 2,629.03 2,629.03 - 2,629.03 - - 0.0%Total-LEASES 40,353.57 37,453.00 2,900.57 40,353.57 37,453.00 2,900.57 432,204.00 394,479.46 91.3%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 19,586.84 25,987.00 (6,400.16) 19,586.84 25,987.00 (6,400.16) 90,000.00 70,413.16 78.2%6900210 FF&E Reserve 1,891.81 1,728.00 163.81 1,891.81 1,728.00 163.81 59,610.00 57,718.19 96.8%6900800 Personal Property Taxes 5,106.54 20,000.00 (14,893.46) 5,106.54 20,000.00 (14,893.46) 20,000.00 14,893.46 74.5%6900323 Insurance-Commercial 3,110.55 3,500.00 (389.45) 3,110.55 3,500.00 (389.45) 42,000.00 38,889.45 92.6%Total-MISC OTHER EXPENSES29,695.74 51,215.00 (21,519.26) 29,695.74 51,215.00 (21,519.26) 211,610.00 181,914.26 86.0%Silverrock ResortOperating Leases & Miscellaneous Other Expense StatementJuly 2009Annual BudgetMonth to Date Year to Date SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2009-20102009 2009 2009 2009 2009 2009Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMediaSalesPromotionGolf Industry8VIPCelebrityPGA Comp70Charity/Gift Certificate14Rain/Wind ChecksClub Staff69LQ HS Golf161000002010 2010 2010 2010 2010 2010Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf000000