Loading...
12 June 2010 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2009 – June 2010 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 June Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 134,469.63 147,087.00 (12,617.37) -8.6% 3,134,190.27 2,980,503.00 153,687.27 2,980,503.00 (153,687.27) 105%401000 Miscellaneous Golf Revenue 4,871.00 3,548.00 1,323.00 37.3% 153,081.48 109,298.00 43,783.48 109,297.00 (43,784.48) 140%410000 Revenue-Golf Shop 13,471.44 15,051.00 (1,579.56) -10.5% 286,492.73 325,553.00 (39,060.27) 325,551.00 39,058.27 88%420000 Revenue-F&B Concession 500.00 500.00 - 0.0% 12,000.00 12,000.00 - 12,000.00 - 100%890000 Interest Income 7.08 - 7.08 0.0% 66.36 - 66.36 - (66.36) 0%Total Income153,319.15 166,186.00 (12,866.85) -7.7% 3,585,830.84 3,427,354.00 158,476.84 3,427,351.00 (158,479.84) 105%Cost of Goods Sold510000 COS-Golf Shop 6,919.89 7,988.05 (1,068.16) 13.4% 159,457.43 172,786.15 13,328.72 172,786.05 13,328.62 92%Total COS6,919.89 7,988.05 (1,068.16) 13.4% 159,457.43 172,786.15 13,328.72 172,786.05 13,328.62 92%Gross Profit146,399.26 158,197.95 (11,798.69) -7.5% 3,426,373.41 3,254,567.85 171,805.56 3,254,564.95 (171,808.46) 105%Expenses610000 Golf Pro Shop 22,365.80 19,958.00 (2,407.80) -12.1% 215,276.60 243,485.00 28,208.40 243,485.00 28,208.40 88%630000 Course Maintenance 115,596.19 117,316.00 1,719.81 1.5% 1,557,132.49 1,594,571.00 37,438.51 1,594,579.00 37,446.51 98%633000 Maintenance Water & Energy 8,034.00 6,814.00 (1,220.00) -17.9% 68,998.68 86,871.00 17,872.32 86,871.00 17,872.32 79%640000 Outside Services 30,444.03 18,128.00 (12,316.03) -67.9% 318,763.66 276,996.00 (41,767.66) 277,000.00 (41,763.66) 115%650000 Clubhouse 13,575.14 9,742.00 (3,833.14) -39.3% 132,753.74 118,904.00 (13,849.74) 118,900.00 (13,853.74) 112%660000 Marketing 22,516.38 11,322.00 (11,194.38) -98.9% 237,157.02 256,759.00 19,601.98 256,759.00 19,601.98 92%670000 General & Administrative29,477.14 26,012.00 (3,465.14) -13.3% 287,045.06 316,394.00 29,348.94 316,394.00 29,348.94 91%680000 Leases 19,780.69 34,581.00 14,800.31 42.8% 338,345.76 432,204.00 93,858.24 432,204.00 93,858.24 78%690000 Miscellaneous Other Expense 35,424.12 25,741.00 (9,683.12) -37.6% 193,613.82 211,612.00 17,998.18 211,610.00 17,996.18 91%Total Expenses297,213.49 269,614.00 (27,599.49) -10.2% 3,349,086.83 3,537,796.00 188,709.17 3,537,802.00 188,715.17 95%(150,814.23) (111,416.05) (39,398.18) -35.4%77,286.58 (283,228.15) 360,514.73 (283,237.05) (360,523.63) -27%Rounds of Golf PlayedPaid Rounds Played 2,380 2,150 230 10.7% 43,779 39,150 4,629 39,150 (4,629) 112%Ave $ Per Paid Round Green Fee 56.50 68.41 (11.91) -17.4% 71.59 76.13 (4.54) 76.13 4.54 94%Ave $ Per Paid Round Merchandise 5.66 7.00 (1.34) -19.1% 6.54 8.32 (1.77) 8.07 1.53 81%Ave $ Per Paid Miscellaneous 2.05 1.65 0.40 24.0% 3.50 2.79 0.70 2.06 - 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateJune 20101 Income June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 134,469.63 147,087.00 (12,617.37) 3,134,190.27 2,980,503.00 153,687.27 2,980,503.00-153,687.27105%4010000 Rider Fee 400.00 215.00 185.00 9,175.00 5,829.00 3,346.00 5,829.00-3,346.00157%4040000 Club Rental 935.00 1,183.00 (248.00) 21,190.00 26,169.00 (4,979.00) 26,168.004,978.0081%4050000 Driving Range 2,956.00 2,150.00 806.00 71,207.00 44,300.00 26,907.00 44,300.00-26,907.00161%4060000 Handicap Fees 280.00 - 280.00 9,205.00 8,000.00 1,205.00 8,000.00 -1,205.00115%4080000 GPS Advertising 300.00 - 300.00 1,800.00 12,000.00 (10,200.00) 12,000.00 10,200.0015%4090000 Ball Retriever/Subcontract - - - 4,515.98 4,000.00 515.98 4,000.00 -515.98113%4091000 Golf Professional Rental Fee - - - 34,075.00 9,000.00 25,075.00 9,000.00 -25,075.00 379%4092000 Golf Lessons - - - 1,913.50 - 1,913.50 - (1,913.50) 0% Total Revenue Fees 139,340.63 150,635.00 (11,294.37) 3,287,271.75 3,089,801.00 197,470.75 3,089,800.00 (197,471.75) 106%139,340.63 150,635.00 (11,294.37) 3,287,271.75 3,089,801.00 197,470.75 3,089,800.00 (197,471.75) 106%Total IncomeMonth to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueJune 20102 Income June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 213.00 - 213.00 4,136.34 - 4,136.34 0 0 0%4100110 Sales Hard Goods 7,913.43 5,268.00 2,645.43 113,697.25 113,944.00 (246.75) 113,943.00 245.75 100%4100112 Sales-Soft Goods 6,599.50 9,783.00 (3,183.50) 208,677.91 211,609.00 (2,931.09) 211,608.00 2,930.09 99%5100639 GS-Discounts-Mdse (1,628.03) - (1,628.03) (40,392.31) - (40,392.31) - 40,392.31 0% Total Revenue Golf Shop 13,097.90 15,051.00 (1,953.10) 286,119.19 325,553.00 (39,433.81) 325,551.00 43,568.15 87%COS 5100150 COS-GS-Hard Goods 4,497.49 2,897.40 1,600.09 55,109.68 62,669.20 (7,559.52) 62,668.65 7,558.97 88%5100151 COS-GS-Soft Goods 2,255.18 5,380.65 (3,125.47) 100,258.99 116,384.95 (16,125.96) 116,384.40 16,125.41 86%5100152 COS-GS-Purchase Disc (14.40) (414.00) 399.60 (494.99) (8,955.00) 8,460.01 (8,953.00) (8,458.01) -6%5100220 COS-GS-Freight Merch 181.62 124.00 57.62 4,583.75 2,687.00 1,896.75 2,686.00 (1,897.75) 171%Cost of Sales - Golf Shop 6,919.89 7,988.05 (1,068.16) 159,457.43 172,786.15 (13,328.72) 172,786.05 13,328.62 92%Gross Profit 6,178.01 7,062.95 (884.94) 126,661.76 152,766.85 (26,105.09) 152,764.95 30,239.53 80%COS % 52.8% 53.1% 0.2% 55.7% 53.1% -2.7% 53.1% 30.6% 42%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 420.00 420.00 - 5,400.00 5,400.00 - 5,400.00 - 100%6101320 Insurance Group 2,670.92 2,317.00 353.92 26,485.59 26,811.00 (325.41) 26,811.00 325.41 99%6101325 Insurance-Workers Comp 376.80 785.00 (408.20) 5,052.41 9,229.00 (4,176.59) 9,229.00 4,176.59 55%6101720 Salaries 4,239.89 3,582.00 657.89 45,728.86 42,984.00 2,744.86 20,796.00 (24,932.86) 220%6101800 Taxes-Employer Payroll 1,042.79 1,712.00 (669.21) 14,564.30 20,123.00 (5,558.70) 20,123.00 5,558.70 72%6101880 Wages-Hourly 7,093.56 10,172.00 (3,078.44) 91,186.51 118,643.00 (27,456.49) 140,831.00 49,644.49 65%6101882 Wages-Overtime 34.32 - 34.32 1,509.73 - 1,509.73 - 952.88 0%Total -PS-SALARIES & BENEFITS 15,878.28 18,988.00 (3,109.72) 189,927.40 223,190.00 (33,262.60) 223,190.00 35,725.21 84%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - 988.46 - 988.46 - (988.46) 0%6103762 Supplies-Office 128.70 100.00 28.70 2,580.55 2,950.00 (369.45) 2,950.00 369.45 87%6109090 Contract Services 500.00 500.00 - 6,000.00 6,000.00 - 6,000.00 - 100%6109220 Freight & Delivery 108.75 - 108.75 946.57 75.00 871.57 75.00 (871.57) 1262%6109490 Miscellaneous 736.82 50.00 686.82 1,034.57 450.00 584.57 450.00 (584.57) 230%6109150 Dues and Subscriptions - - - 2,267.00 2,000.00 267.00 2,000.00 (267.00) 113%6109500 ProShop-Over/Short 5.00 - 5.00 39.96 - 39.96 - (39.96) 0%6109722 Seminars/Training 4,800.00 35.00 4,765.00 6,378.75 5,490.00 888.75 5,490.00 (888.75) 116%6109810 Travel - Merchandise - 15.00 (15.00) 11.44 90.00 (78.56) 90.00 78.56 13%6109820 Uniforms 28.50 200.00 (171.50) 2,684.74 2,400.00 284.74 2,400.00 (284.74) 112%6117840 Telephones 126.59 70.00 56.59 2,364.00 840.00 1,524.00 840.00 (1,524.00) 0%Total PS-OTHER EXPENSES 6,434.36 970.00 5,464.36 25,296.04 20,295.00 5,001.04 20,295.00 (5,001.04) 125%22,312.64 19,958.00 2,354.64 215,223.44 243,485.00 (28,261.56) 243,485.00 30,724.17 87%Net Income(16,134.63) (12,895.05) (3,239.58) (88,561.68) (90,718.15) 2,156.47 (90,720.05) (484.64) -99%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementJune 20103 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 2,820.00 2,880.00 (60.00) 2,880.00 60.00 2.1%6311320 Insurance-Group 8,740.00 8,740.00 - 105,301.12 104,880.00 421.12 104,880.00 (421.12) -0.4%6311325 Insurance-Workers Comp 1,699.57 3,333.00 (1,633.43) 24,865.60 39,329.00 (14,463.40) 39,329.00 14,463.40 36.8%6311720 Salaries 12,468.48 12,331.00 137.48 140,086.24 147,972.00 (7,885.76) 147,972.00 7,885.76 5.3%6311800 Taxes-Employer Payroll 3,974.99 7,383.00 (3,408.01) 62,931.71 86,421.00 (23,489.29) 86,420.00 23,488.29 27.2%6311880 Wages-Hourly 40,856.83 44,163.00 (3,306.17) 515,886.69 529,920.00 (14,033.31) 529,928.00 14,041.31 2.6%6311882 Wages-Overtime 904.27 2,808.00 (1,903.73) 11,376.54 16,234.00 (4,857.46) 16,234.00 4,857.46 29.9%Total-CM-SALARIES & BENEFITS68,884.14 78,998.00 (10,113.86) 863,267.90 927,636.00 (64,368.10) 927,643.00 64,375.10 6.9%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 3,141.13 2,000.00 1,141.13 34,440.72 29,300.00 5,140.72 29,300.00 (5,140.72) -17.5%6313744 Fertilizer 7,646.24 5,000.00 2,646.24 109,568.73 92,200.00 17,368.73 92,200.00 (17,368.73) -18.8%6313745 Herbicides - - - 6,347.99 10,000.00 (3,652.01) 10,000.00 3,652.01 36.5%6313746 Flowers/Plants - - - 2,376.17 3,500.00 (1,123.83) 3,500.00 1,123.83 32.1%6313748 Fuel-Gasoline 4,226.11 2,860.00 1,366.11 43,667.92 43,100.00 567.92 43,100.00 (567.92) -1.3%6313750 Golf Course Accessories 121.59 100.00 21.59 13,841.88 8,000.00 5,841.88 8,000.00 (5,841.88) -73.0%6313756 POA Control 218.48 - 218.48 8,806.71 7,000.00 1,806.71 7,000.00 (1,806.71) -25.8%6313758 Miscellaneous Supp 518.45 100.00 418.45 7,708.19 4,350.00 3,358.19 4,350.00 (3,358.19) 0.0%6313762 Supplies-Office - - - 562.17 - 562.17 - (562.17) 0.0%6313774 Sand - 100.00 (100.00) 6,839.13 11,460.00 (4,620.87) 11,460.00 4,620.87 40.3%6313775 Sand-Bunkers - - - 3,896.31 - 3,896.31 - (3,896.31) 0.0%6313776 Seed - 350.00 (350.00) 88,921.88 91,810.00 (2,888.12) 91,810.00 2,888.12 3.1%6313778 Small Tools & Non-Capital Equip 284.38 100.00 184.38 8,094.83 5,000.00 3,094.83 5,000.00 (3,094.83) -61.9%6313780 Sod - 1,000.00 (1,000.00) 9,039.15 5,750.00 3,289.15 5,750.00 (3,289.15) -57.2%6313782 Topdressing 2,845.40 1,300.00 1,545.40 6,487.40 7,600.00 (1,112.60) 7,600.00 1,112.60 14.6%Total-CM-SUPPLIES & MATERIALS19,001.78 12,910.00 6,091.78 350,599.18 319,070.00 31,529.18 319,070.00 (31,529.18) -9.9%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,617.87 1,500.00 117.87 20,952.55 17,000.00 3,952.55 17,000.00 (3,952.55) -23.3%6315685 CM-R&M-Bldngs & Othr Structures 727.87 250.00 477.87 3,029.52 1,750.00 1,279.52 1,750.00 (1,279.52) -73.1%6315690 CM-R&M-Equipment 2,738.24 1,500.00 1,238.24 37,508.69 35,700.00 1,808.69 35,700.00 (1,808.69) -5.1%6315692 CM-R&M-Irrigation System 1,502.82 1,000.00 502.82 24,538.72 16,050.00 8,488.72 16,050.00 (8,488.72) -52.9%6315696 CM-R&M-Pumps 973.65 - 973.65 13,704.63 10,500.00 3,204.63 10,500.00 (3,204.63) -30.5%6315815 CM-R&M-Trees-Pruning Etc - - - 8,431.93 10,050.00 (1,618.07) 10,050.00 1,618.07 16.1%Total-CM-REPAIRS & MAINTENANCE 7,560.45 4,250.00 3,310.45 108,166.04 91,050.00 17,116.04 91,050.00 (17,116.04) -18.8%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs - - - 40.50 - 40.50 (40.50) 0.0%6317836 Utilities-Natural Gas/LPG 26.76 50.00 (23.24) 161.86 600.00 (438.14) 600.00 438.14 0.0%6317840 Telephones 1,103.24 850.00 253.24 12,499.94 10,200.00 2,299.94 10,200.00 (2,299.94) -22.5%Total-CM-UTILITIES 1,130.00 900.00 230.00 12,702.30 10,800.00 1,902.30 10,800.00 (1,902.30) -17.6%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 6,000.00 6,000.00 - 6,000.00 - 0.0%6319099 Contract Svcs-Security Bldgs - - - 210.00 - 210.00 (210.00) 0.0%6319100 Contract Svcs-Soil/Tissue Test - - - 3,500.00 4,000.00 (500.00) 4,000.00 500.00 12.5%6319101 Contract Svcs-Trash Removal 1,487.83 524.00 963.83 7,341.79 6,288.00 1,053.79 6,288.00 (1,053.79) 0.0%6319150 Dues & Subscriptions - 100.00 (100.00) 478.00 900.00 (422.00) 900.00 422.00 46.9%6319170 Employee Education - 50.00 (50.00) 1,090.95 1,550.00 (459.05) 1,550.00 459.05 29.6%6319197 Equipment Rental - 100.00 (100.00) 2,966.74 4,200.00 (1,233.26) 4,200.00 1,233.26 29.4%6319206 Licenses & Permits 350.00 - 350.00 2,973.35 680.00 2,293.35 680.00 (2,293.35) -337.3%6319490 Miscellaneous - 100.00 (100.00) 953.92 1,200.00 (246.08) 1,200.00 246.08 20.5%6319718 Safety Equipment & Training 586.37 100.00 486.37 5,100.46 2,600.00 2,500.46 2,600.00 (2,500.46) -96.2%6319822 Uniforms 823.25 820.00 3.25 11,075.59 9,840.00 1,235.59 9,840.00 (1,235.59) -12.6%Total-CM-OTHER EXPENSES 3,747.45 2,294.00 1,453.45 41,690.80 37,258.00 4,432.80 37,258.00 (4,432.80) -11.9%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementJune 2010Annual Budget4 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,317.00 2,317.00 - 25,115.75 27,804.00 (2,688.25) 27,804.00 2,688.25 9.7%6321325 Insurance-Workers Comp 368.97 700.00 (331.03) 4,718.81 8,229.00 (3,510.19) 8,229.00 3,510.19 42.7%6321800 Taxes-Employer Payroll 870.53 1,559.00 (688.47) 12,189.87 18,153.00 (5,963.13) 18,154.00 5,964.13 32.9%6321880 Wages-Hourly 11,425.11 11,712.00 (286.89) 125,096.78 140,544.00 (15,447.22) 140,544.00 15,447.22 11.0%6321882 Wages-Overtime 88.77 811.00 (722.23) 2,319.78 5,272.00 (2,952.22) 5,272.00 2,952.22 56.0%Total-CM-LM-SALARIES & BENEFITS15,070.38 17,099.00 (2,028.62) 169,440.99 200,002.00 (30,561.01) 200,003.00 30,562.01 15.3%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools 63.38 75.00 (11.62) 210.81 1,025.00 (814.19) 1,025.00 814.19 79.4%6323788 Uniforms 138.61 290.00 (151.39) 2,151.17 3,480.00 (1,328.83) 3,480.00 1,328.83 38.2%Total-CM-LM-SUPPLIES & MATERIALS201.99 365.00 (163.01) 2,361.98 4,505.00 (2,143.02) 4,505.00 2,143.02 47.6%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 500.00 (500.00) 8,903.30 4,250.00 4,653.30 4,250.00 (4,653.30) -109.5%Total-CM-LM-REPAIRS & MAINTENANCE - 500.00 (500.00) 8,903.30 4,250.00 4,653.30 4,250.00 (4,653.30) -109.5%115,596.19 117,316.00 (1,719.81) 1,557,132.49 1,594,571.00 (37,438.51) 1,594,579.00 37,446.51 2.3% June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 2,951.30 5,000.00 (2,048.70) 30,861.14 65,000.00 (34,138.86) 65,000.00 34,138.86 52.5%6337842 Utilities-Water5,082.70 1,814.00 3,268.70 38,137.54 21,871.00 16,266.54 21,871.00 (16,266.54) -74.4%8,034.00 6,814.00 1,220.00 68,998.68 86,871.00 (17,872.32) 86,871.00 17,872.32 20.6%Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetSilverrock ResortCourse Maintenance Water & EnergyJune 2010Total-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementJune 2010Annual BudgetMonth to Date Year to Date5 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 480.00 480.00 - 6,960.00 6,960.00 - 6,960.00 - 0.0%6411320 Insurance-Group 662.00 662.00 - 5,952.20 7,944.00 (1,991.80) 7,944.00 1,991.80 25.1%6411325 Insurance-Workers Comp 382.86 1,210.00 (827.14) 4,650.67 16,160.00 (11,509.33) 16,162.00 11,511.33 71.2%6411800 Taxes-Employer Payroll 1,345.25 1,049.00 296.25 16,261.98 14,013.00 2,248.98 14,012.00 (2,249.98) -16.1%6411880 Wages-Hourly 9,529.52 8,425.00 1,104.52 124,740.84 112,549.00 12,191.84 112,549.00 (12,191.84) -10.8%6411882 Wages-Overtime 42.00 - 42.00 1,607.47 - 1,607.47 - (1,607.47) 0.0%Total-CBR-SALARIES & BENEFITS12,441.63 11,826.00 615.63 160,173.16 157,626.00 2,547.16 157,627.00 (2,546.16) -1.6%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 4.88 50.00 (45.12) 5,202.16 2,350.00 2,852.16 2,350.00 (2,852.16) -121.4%6413742 Supplies-Expendable 995.38 500.00 495.38 9,486.15 5,000.00 4,486.15 5,000.00 (4,486.15) -89.7%6413752 Supplies-Range Balls - - - 7,031.57 6,000.00 1,031.57 6,000.00 (1,031.57) -17.2%6413762 Supplies-Office - 50.00 (50.00) - 525.00 (525.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - 70.00 (70.00) 445.29 420.00 25.29 420.00 (25.29) -6.0%6413786 Supplies-Towels - 72.00 (72.00) 1,650.27 892.00 758.27 892.00 (758.27) -85.0%6413796 Supplies-Bottled Water6,722.78 400.00 6,322.78 22,066.92 19,400.00 2,666.92 19,400.00 (2,666.92) -13.7%Total-CBR-SUPPLIES & MATERIALS7,723.04 1,142.00 6,581.04 45,882.36 34,587.00 11,295.36 34,587.00 (11,295.36) -32.7%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts - 720.00 (720.00) 5,383.44 8,640.00 (3,256.56) 8,640.00 3,256.56 37.7%6415690 CBR-R&M-Equipment - 300.00 (300.00) 4,205.69 3,600.00 605.69 3,600.00 (605.69) -16.8%6415695 CBR-R&M-Cart Maintenance & Repair - 250.00 (250.00) 17,096.14 4,000.00 13,096.14 4,000.00 (13,096.14) -327.4%Total-CBR-REPAIRS & MAINTENANCE - 1,270.00 (1,270.00) 26,685.27 16,240.00 10,445.27 16,240.00 (10,445.27) -64.3%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps 300.00 200.00 100.00 6,745.00 5,000.00 1,745.00 5,000.00 (1,745.00) -34.9%6419094 Contract Services-Laundry/Linen 1,700.51 500.00 1,200.51 10,827.50 6,000.00 4,827.50 6,000.00 (4,827.50) -80.5%6419220 Freight/Delivery - 75.00 (75.00) - 900.00 (900.00) 900.00 900.00 100.0%6419490 Miscellaneous - 125.00 (125.00) 850.15 1,150.00 (299.85) 1,150.00 299.85 26.1%6419820 Uniforms 603.55 200.00 403.55 3,420.61 5,625.00 (2,204.39) 5,625.00 2,204.39 39.2%Total-CBR-OTHER EXPENSES 2,604.06 1,100.00 1,504.06 21,843.26 18,675.00 3,168.26 18,675.00 (3,168.26) -17.0%TOTAL-CARTS,BAGROOM & RANGE 22,768.73 15,338.00 7,430.73 254,584.05 227,128.00 27,456.05 227,129.00 (27,455.05) -12.1%643-CS-SALARIES & BENEFITS6431175 Employee Meals 180.00 180.00 - 3,300.00 3,300.00 - 3,300.00 - 0.0%6431325 Insurance-Workers Comp 241.36 116.00 125.36 1,899.36 2,067.00 (167.64) 2,069.00 169.64 8.2%6431800 Taxes-Employer Payroll 878.59 254.00 624.59 6,516.37 4,511.00 2,005.37 4,512.00 (2,004.37) -44.4%6431880 Wages-Hourly 6,013.00 2,040.00 3,973.00 48,131.50 36,240.00 11,891.50 36,240.00 (11,891.50) -32.8%6431882 Wages-Overtime 21.00 - 21.00 372.00 - 372.00 - (372.00) 0.0%Total-CS-SALARIES & BENEFITS7,333.95 2,590.00 4,743.95 60,219.23 46,118.00 14,101.23 46,121.00 (14,098.23) -30.6%643-CS-OTHER EXPENSES6433742 Supplies Expendable 39.38 75.00 (35.62) 1,626.82 1,050.00 576.82 1,050.00 (576.82) -54.9%6439490 Miscellaneous - - - 132.59 200.00 (67.41) 200.00 67.41 33.7%6439718 Safety Equipment & Training - 50.00 (50.00) 524.39 600.00 (75.61) 600.00 75.61 12.6%6439820 Uniforms 301.97 75.00 226.97 1,676.58 1,900.00 (223.42) 1,900.00 223.42 11.8%Total-CS-OTHER EXPENSES 341.35 200.00 141.35 3,960.38 3,750.00 210.38 3,750.00 (210.38) -5.6%Total-COURSE SERVICES 7,675.30 2,790.00 4,885.30 64,179.61 49,868.00 14,311.61 49,871.00 (14,308.61) -28.7%30,444.03 18,128.00 12,316.03 318,763.66 276,996.00 41,767.66 277,000.00 (41,553.28) -15.0%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementJune 2010Annual Budget6 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable957.00 400.00 557.00 1,433.96 4,800.00 (3,366.04) 4,800.00 3,366.04 70.1%Total-CH-SUPPLIES & MATERIALS 957.00 400.00 557.00 1,433.96 4,800.00 (3,366.04) 4,800.00 3,366.04 70.1%65-CH-UTILITIES6507836 Utilities-Natural Gas454.81 300.00 154.81 3,835.85 3,600.00 235.85 3,600.00 (235.85) -6.6%6507838 Utilities-Sewer- 200.00 (200.00) - 2,400.00 (2,400.00) 2,400.00 2,400.00 100.0%6507840 Utilities-Telephone1,062.38 1,000.00 62.38 13,382.28 12,000.00 1,382.28 12,000.00 (1,382.28) -11.5%6507842 Utilities-Water869.37 200.00 669.37 5,792.94 2,400.00 3,392.94 2,400.00 (3,392.94) -141.4%6507844 Utilities-Cable336.47 317.00 19.47 3,955.00 3,804.00 151.00 3,800.00 (155.00) -4.1%Total-CH-UTILITIES 2,723.03 2,017.00 706.03 26,966.07 24,204.00 2,762.07 24,200.00 (2,766.07) -11.4%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,750.00 1,825.00 (75.00) 22,545.00 22,500.00 45.00 22,500.00 (45.00) -0.2%6509098 Contract Services-Refuse Dispose762.59 - 762.59 5,025.64 - 5,025.64 - (5,025.64) 0.0%6509099 Contract Services-Security4,756.56 4,100.00 656.56 60,850.82 49,200.00 11,650.82 49,200.00 (11,650.82) -23.7%6509215 Flowers & Decorations- 100.00 (100.00) - 2,600.00 (2,600.00) 2,600.00 2,600.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 2,116.94 2,400.00 (283.06) 2,400.00 283.06 11.8%6509718 Safety Equipment & Training250.00 100.00 150.00 1,188.15 1,200.00 (11.85) 1,200.00 11.85 1.0%Total-CH-OTHER EXPENSES 7,519.15 6,325.00 1,194.15 91,726.55 77,900.00 13,826.55 77,900.00 (13,826.55) -17.7%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures731.00 200.00 531.00 7,346.04 2,400.00 4,946.04 2,400.00 (4,946.04) -206.1%6515686 CH-R&M-Restaurant Repairs158.00 400.00 (242.00) 3,659.16 4,800.00 (1,140.84) 4,800.00 1,140.84 23.8%6515690 CH-R&M-Equipment Repair1,486.96 400.00 1,086.96 1,621.96 4,800.00 (3,178.04) 4,800.00 3,178.04 66.2%Total-CH-REPAIRS & MAINTENANCE 2,375.96 1,000.00 1,375.96 12,627.16 12,000.00 627.16 12,000.00 (627.16) -5.2%13,575.14 9,742.00 3,833.14 132,753.74 118,904.00 13,849.74 118,900.00 (1,254.32) -1.1%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementJune 2010Annual Budget7 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 720.00 720.00 - 720.00 - 0.0%6601320 Insurance-Group 331.00 331.00 - 3,820.72 3,972.00 (151.28) 3,972.00 151.28 3.8%6601325 Insurance-Workers Comp 100.00 143.00 (43.00) 1,190.80 1,716.00 (525.20) 1,713.00 522.20 30.5%6601720 Salaries 2,500.00 2,500.00 - 31,250.00 30,000.00 1,250.00 30,000.00 (1,250.00) -4.2%6601800 Taxes-Employer Payroll 311.00 311.00 - 3,887.50 3,732.00 155.50 3,735.00 (152.50) -4.1%Total-MKT-SALARIES & BENEFITS 3,302.00 3,345.00 (43.00) 40,869.02 40,140.00 729.02 40,140.00 (729.02) -1.8%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 11.69 100.00 (88.31) 391.37 1,200.00 (808.63) 1,200.00 808.63 67.4%6603768 Supplies-Printing & Stationery 1,010.05 125.00 885.05 4,472.47 4,425.00 47.47 4,425.00 (47.47) -1.1%1,021.74 225.00 796.74 4,863.84 5,625.00 (761.16) 5,625.00 761.16 13.5%66-MKT-UTILITIES6607840 Utilities-Telephone 51.26 100.00 (48.74) 1,009.28 1,200.00 (190.72) 1,200.00 190.72 15.9%Total-MKT-UTILITIES 51.26 100.00 (48.74) 1,009.28 1,200.00 (190.72) 1,200.00 190.72 15.9%66-MKT-OTHER EXPENSES6609010 Advertising 16,752.68 6,777.00 9,975.68 178,626.21 185,984.00 (7,357.79) 185,984.00 7,357.79 4.0%6609040 Business Meals - 25.00 (25.00) 25.00 300.00 (275.00) 300.00 275.00 91.7%6609080 Collateral Material - 500.00 (500.00) 6,034.68 9,000.00 (2,965.32) 9,000.00 2,965.32 32.9%6609102 Contract Services-Web Page 99.00 175.00 (76.00) 1,758.00 2,100.00 (342.00) 2,100.00 342.00 16.3%6609490 Miscellaneous 300.00 - 300.00 332.00 350.00 (18.00) 350.00 18.00 5.1%6609620 Postage 112.02 50.00 62.02 408.61 600.00 (191.39) 600.00 191.39 31.9%6609630 Promotion - 50.00 (50.00) 452.28 700.00 (247.72) 700.00 247.72 0.0%6609633 Promotion-Community - 75.00 (75.00) 1,445.25 2,925.00 (1,479.75) 2,925.00 1,479.75 50.6%6609634 Promotion-Media/Vendor 877.68 - 877.68 1,053.18 6,500.00 (5,446.82) 6,500.00 - 0.0%6609150 Dues and Subscriptions - - - 240.00 735.00 (495.00) 735.00 495.00 67.3%6609820 Uniforms - - - 39.67 600.00 (560.33) 600.00 560.33 93.4%Total-MKT-OTHER EXPENSES 18,141.38 7,652.00 10,489.38 190,414.88 209,794.00 (19,379.12) 209,794.00 13,932.30 6.6%22,516.38 11,322.00 11,194.38 237,157.02 256,759.00 (19,601.98) 256,759.00 14,155.16 5.5%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementJune 2010Annual Budget8 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 2,263.40 2,160.00 103.40 2,160.00 (103.40) -4.8%6701320 Insurance-Group1,458.00 1,458.00 - 16,524.34 17,496.00 (971.66) 17,496.00 971.66 5.6%6701325 Insurance-Workers Comp555.04 981.00 (425.96) 7,141.52 11,772.00 (4,630.48) 11,772.00 4,630.48 39.3%6701720 Salaries 15,205.12 14,534.00 671.12 171,138.42 174,408.00 (3,269.58) 174,408.00 3,269.58 1.9%6701800 Taxes-Employer Payroll 1,405.83 2,140.00 (734.17) 15,800.96 25,680.00 (9,879.04) 25,680.00 9,879.04 38.5%6701880 Wages-Hourly2,105.86 2,654.00 (548.14) 21,391.23 31,848.00 (10,456.77) 31,848.00 10,456.77 32.8%6701882 Wages-Overtime - - - 21.85 - 21.85 - (21.85) 0.0%Total-G&A-SALARIES & BENEFITS 20,909.85 21,947.00 (1,037.15) 234,281.72 263,364.00 (29,082.28) 263,364.00 29,082.28 11.0%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer1,160.90 800.00 360.90 7,800.66 10,800.00 (2,999.34) 10,800.00 2,999.34 27.8%6703762 Supplies-Office - 125.00 (125.00) 1,541.62 1,500.00 41.62 1,500.00 (41.62) -2.8%6703768 Supplies-Printing & Stationery- 400.00 (400.00) 1,944.26 3,200.00 (1,255.74) 3,200.00 1,255.74 39.2%6703778Supplies-Small Tools/Non-Capital - - - - 900.00 (900.00) 900.00 900.00 100.0%Total-G&A-SUPPLIES & MATERIALS 1,160.90 1,325.00 (164.10) 11,286.54 16,400.00 (5,113.46) 16,400.00 5,113.46 31.2%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 340.84 1,200.00 (859.16) 1,200.00 859.16 71.6%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 340.84 1,200.00 (859.16) 1,200.00 859.16 71.6%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 4,800.00 4,800.00 - 4,800.00 - 0.0%6709150 Dues & Subscriptions240.00 50.00 190.00 877.32 1,500.00 (622.68) 1,500.00 622.68 41.5%6709180 Employee Recruiting/Relocation- - - 1,270.49 2,600.00 (1,329.51) 2,600.00 1,329.51 51.1%6709197 Equipment Rental636.84 350.00 286.84 6,532.96 4,200.00 2,332.96 4,200.00 (2,332.96) -55.5%6709202 Fees-Bank152.04 90.00 62.04 773.21 1,080.00 (306.79) 1,080.00 306.79 28.4%6709208 Fees-Payroll Processing802.93 550.00 252.93 9,848.56 6,600.00 3,248.56 6,600.00 (3,248.56) -49.2%6709220 Freight/Delivery- 50.00 (50.00) 195.65 600.00 (404.35) 600.00 404.35 67.4%6709490 Miscellaneous - 100.00 (100.00) 847.56 1,200.00 (352.44) 1,200.00 352.44 29.4%6709620 Postage/Mail Services - 75.00 (75.00) 1,312.63 900.00 412.63 900.00 (412.63) -45.8%6709625 Professional Fees4,642.50 400.00 4,242.50 10,247.43 4,800.00 5,447.43 4,800.00 (5,447.43) -113.5%6709636 Promotion/Entertainment132.08 100.00 32.08 2,534.67 2,600.00 (65.33) 2,600.00 65.33 2.5%6709722 Seminars & Training400.00 200.00 200.00 1,088.51 2,400.00 (1,311.49) 2,400.00 1,311.49 54.6%6709810 Travel - 200.00 (200.00) - 1,100.00 (1,100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms - 75.00 (75.00) 770.60 1,050.00 (279.40) 1,050.00 279.40 26.6%Total-G&A-OTHER EXPENSES 7,406.39 2,640.00 4,766.39 41,135.96 35,430.00 5,705.96 35,430.00 (5,669.59) -16.0%29,477.14 26,012.00 3,465.14 287,045.06 316,394.00 (29,348.94) 316,394.00 29,385.31 9.3%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementJune 2010Annual Budget9 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 8,785.41 11,581.00 (2,795.59) 122,198.70 138,972.00 (16,773.30) 138,972.00 16,773.30 12.1%6800193 Equipment Leases-Course Maint 229.31 15,000.00 (14,770.69) 81,528.04 189,000.00 (107,471.96) 189,000.00 107,471.96 56.9%6800194 Equipment Leases-Trailer 560.00 600.00 (40.00) 6,528.50 7,200.00 (671.50) 7,200.00 671.50 9.3%6800195 Equipment Leases-Software 419.00 - 419.00 12,311.65 8,232.00 4,079.65 8,232.00 (4,079.65) -49.6%6800196 Equipment Leases-GPS 7,942.00 7,400.00 542.00 90,512.51 88,800.00 1,712.51 88,800.00 (1,712.51) -1.9%6800197 Equipment Leases-Others 1,844.97 - 1,844.97 25,266.36 - 25,266.36 - - 0.0%19,780.69 34,581.00 (14,800.31) 338,345.76 432,204.00 (93,858.24) 432,204.00 119,124.60 27.6%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 23,085.38 19,299.00 3,786.38 90,000.00 90,001.00 (1.00) 90,000.00 - 0.0%6900210 FF&E Reserve 2,689.40 2,942.00 (252.60) 62,683.84 59,611.00 3,072.84 59,610.00 (3,073.84) -5.2%6900800 Personal Property Taxes - - - 11,577.70 20,000.00 (8,422.30) 20,000.00 8,422.30 42.1%6900323 Insurance-Commercial 2,551.44 3,500.00 (948.56) 29,352.28 42,000.00 (12,647.72) 42,000.00 12,647.72 30.1%28,326.22 25,741.00 2,585.22 193,613.82 211,612.00 (17,998.18) 211,610.00 17,996.18 8.5%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementJune 201010 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2009-20102009 2009 2009 2009 2009 2009Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia74 4Sales8PromotionGolf Industry81711 715VIPCelebrityPGA Comp70 68 67 9 44 62Charity/Gift Certificate14 10 4 20Rain/Wind Checks3 5 36 15Club Staff69 105 91 6 47 105LQ HS Golf39161 200 227 19 138 2252010 2010 2010 2010 2010 2010Comp CategoryJanuaryFebruaryMarchAprilMayJuneMedia41Sales41Promotion7816Golf Industry26 61218 31 17VIPCelebrityPGA Comp91 536397 75 53Charity/Gift Certificate4165943 27 10Rain/Wind Checks93822 3 3Club Staff63 11394124 150 103LQ HS Golf82 56 7197 191 329 369 309 18711 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2009-2010June 2010 Date Time Description CategoryPlayers6/16/2010 9:07 Michael Dante Media 112