Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
11 May 2010 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2009 – May 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 May Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 306,099.17 271,650.00 34,449.17 12.7% 2,999,720.64 2,833,416.00 166,304.64 2,980,503.00 (19,217.64) 101%401000 Miscellaneous Golf Revenue 12,699.00 6,600.00 6,099.00 92.4% 148,210.48 105,750.00 42,460.48 109,297.00 (38,913.48) 136%410000 Revenue-Golf Shop 21,637.94 28,000.00 (6,362.06) -22.7% 273,021.29 310,502.00 (37,480.71) 325,551.00 52,529.71 84%420000 Revenue-F&B Concession 500.00 500.00 - 0.0% 11,500.00 11,500.00 - 12,000.00 500.00 96%890000 Interest Income 7.79 - 7.79 0.0% 59.28 - 59.28 - (59.28) 0%Total Income340,943.90 306,750.00 34,193.90 11.1% 3,432,511.69 3,261,168.00 171,343.69 3,427,351.00 (5,160.69) 100%Cost of Goods Sold510000 COS-Golf Shop 10,413.79 14,861.00 (4,447.21) 29.9% 152,537.54 164,798.10 12,260.56 172,786.05 20,248.51 88%Total COS10,413.79 14,861.00 (4,447.21) 29.9% 152,537.54 164,798.10 12,260.56 172,786.05 20,248.51 88%Gross Profit330,530.11 291,889.00 38,641.11 13.2% 3,279,974.15 3,096,369.90 183,604.25 3,254,564.95 (25,409.20) 101%Expenses610000 Golf Pro Shop 20,730.19 23,683.00 2,952.81 12.5% 192,910.80 223,527.00 30,616.20 243,485.00 50,574.20 79%630000 Course Maintenance 130,041.19 113,759.00 (16,282.19) -14.3% 1,441,536.30 1,477,255.00 35,718.70 1,594,579.00 153,042.70 90%633000 Maintenance Water & Energy 6,708.49 6,659.00 (49.49) -0.7% 60,964.68 80,057.00 19,092.32 86,871.00 25,906.32 70%640000 Outside Services 23,256.31 19,428.00 (3,828.31) -19.7% 288,319.63 258,868.00 (29,451.63) 277,000.00 (11,319.63) 104%650000 Clubhouse 10,978.06 9,742.00 (1,236.06) -12.7% 119,178.60 109,162.00 (10,016.60) 118,900.00 (278.60) 100%660000 Marketing 15,698.12 13,572.00 (2,126.12) -15.7% 214,640.64 245,437.00 30,796.36 256,759.00 42,118.36 84%670000 General & Administrative26,728.41 26,862.00 133.59 0.5% 257,512.71 290,382.00 32,869.29 316,394.00 58,881.29 81%680000 Leases 19,446.94 34,581.00 15,134.06 43.8% 318,565.07 397,623.00 79,057.93 432,204.00 113,638.93 74%690000 Miscellaneous Other Expense 5,689.09 14,292.00 8,602.91 60.2% 158,189.70 185,871.00 27,681.30 211,610.00 53,420.30 75%Total Expenses259,276.80 262,578.00 3,301.20 1.3% 3,051,818.13 3,268,182.00 216,363.87 3,537,802.00 485,983.87 86%71,253.31 29,311.00 41,942.31 143.1%228,156.02 (171,812.10) 399,968.12 (283,237.05) (511,393.07) -81%Rounds of Golf PlayedPaid Rounds Played 5,204 4,000 1,204 30.1% 41,399 37,000 4,399 39,150 (2,249) 106%Ave $ Per Paid Round Green Fee 58.82 67.91 (9.09) -13.4% 72.46 76.58 (4.12) 76.13 3.67 95%Ave $ Per Paid Round Merchandise 4.16 7.00 (2.84) -40.6% 6.59 8.39 (1.80) 8.07 1.48 82%Ave $ Per Paid Miscellaneous 2.44 1.65 0.79 47.9% 3.58 2.86 0.72 2.06 - 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateMay 20101 Income May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 306,099.17 271,650.00 34,449.17 2,999,720.64 2,833,416.00 166,304.64 2,980,503.00-19,217.64101%4010000 Rider Fee 900.00 400.00 500.00 8,775.00 5,614.00 3,161.00 5,829.00-2,946.00151%4040000 Club Rental 1,830.00 2,200.00 (370.00) 20,255.00 24,986.00 (4,731.00) 26,168.005,913.0077%4050000 Driving Range 5,534.00 4,000.00 1,534.00 68,251.00 42,150.00 26,101.00 44,300.00-23,951.00154%4060000 Handicap Fees 435.00 - 435.00 8,925.00 8,000.00 925.00 8,000.00 -925.00112%4080000 GPS Advertising - - - 1,500.00 12,000.00 (10,500.00) 12,000.00 10,500.0013%4090000 Ball Retriever/Subcontract - - - 4,515.98 4,000.00 515.98 4,000.00 -515.98113%4091000 Golf Professional Rental Fee 4,000.00 - 4,000.00 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 318,798.17 278,250.00 40,548.17 3,147,931.12 2,939,166.00 208,765.12 3,089,800.00 (58,131.12) 102%318,798.17 278,250.00 40,548.17 3,147,931.12 2,939,166.00 208,765.12 3,089,800.00 (58,131.12) 102%Total IncomeMonth to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueMay 20102 Income May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 334.00 - 334.00 3,923.34 - 3,923.34 0 0 0%4100110 Sales Hard Goods 10,173.96 9,800.00 373.96 105,783.82 108,676.00 (2,892.18) 113,943.00 8,159.18 93%4100112 Sales-Soft Goods 13,413.50 18,200.00 (4,786.50) 202,078.41 201,826.00 252.41 211,608.00 9,529.59 95%5100639 GS-Discounts-Mdse (2,283.52) - (2,283.52) (38,764.28) - (38,764.28) - 38,764.28 0% Total Revenue Golf Shop 21,637.94 28,000.00 (6,362.06) 273,021.29 310,502.00 (37,480.71) 325,551.00 56,453.05 83%COS 5100150 COS-GS-Hard Goods 3,612.97 5,390.00 (1,777.03) 50,612.19 59,771.80 (9,159.61) 62,668.65 12,056.46 81%5100151 COS-GS-Soft Goods 6,642.36 10,010.00 (3,367.64) 98,003.81 111,004.30 (13,000.49) 116,384.40 18,380.59 84%5100152 COS-GS-Purchase Disc - (770.00) 770.00 (480.59) (8,541.00) 8,060.41 (8,953.00) (8,472.41) -5%5100220 COS-GS-Freight Merch 158.46 231.00 (72.54) 4,402.13 2,563.00 1,839.13 2,686.00 (1,716.13) 164%Cost of Sales - Golf Shop 10,413.79 14,861.00 (4,447.21) 152,537.54 164,798.10 (12,260.56) 172,786.05 20,248.51 88%Gross Profit 11,224.15 13,139.00 (1,914.85) 120,483.75 145,703.90 (25,220.15) 152,764.95 36,204.54 76%COS % 48.1% 53.1% 4.9% 55.9% 53.1% -2.8% 53.1% 35.9% 32%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 480.00 480.00 - 4,980.00 4,980.00 - 5,400.00 420.00 92%6101320 Insurance Group 1,859.30 2,317.00 (457.70) 23,814.67 24,494.00 (679.33) 26,811.00 2,996.33 89%6101325 Insurance-Workers Comp 363.96 807.00 (443.04) 4,675.61 8,444.00 (3,768.39) 9,229.00 4,553.39 51%6101720 Salaries 4,261.64 3,582.00 679.64 41,488.97 39,402.00 2,086.97 20,796.00 (20,692.97) 200%6101800 Taxes-Employer Payroll 1,196.44 1,760.00 (563.56) 13,521.51 18,411.00 (4,889.49) 20,123.00 6,601.49 67%6101880 Wages-Hourly 9,239.18 10,552.00 (1,312.82) 84,092.95 108,471.00 (24,378.05) 140,831.00 56,738.05 60%6101882 Wages-Overtime 188.08 - 188.08 1,475.41 - 1,475.41 - 952.88 0%Total -PS-SALARIES & BENEFITS 17,588.60 19,498.00 (1,909.40) 174,049.12 204,202.00 (30,152.88) 223,190.00 51,569.17 77%61-PS OTHER EXPENSES6103762 Supplies-Office 49.19 100.00 (50.81) 2,451.85 2,850.00 (398.15) 2,950.00 498.15 83%6109090 Contract Services 500.00 500.00 - 5,500.00 5,500.00 - 6,000.00 500.00 92%6109220 Freight & Delivery 128.16 - 128.16 837.82 75.00 762.82 75.00 (762.82) 1117%6109490 Miscellaneous - 50.00 (50.00) 297.75 400.00 (102.25) 450.00 152.25 66%6109150 Dues and Subscriptions 2,267.00 2,000.00 267.00 2,267.00 2,000.00 267.00 2,000.00 (267.00) 113%6109500 ProShop-Over/Short 17.75 - 17.75 34.96 - 34.96 - (34.96) 0%6109722 Seminars/Training - 1,250.00 (1,250.00) 1,578.75 5,455.00 (3,876.25) 5,490.00 3,911.25 29%6109810 Travel - Merchandise 11.44 15.00 (3.56) 11.44 75.00 (63.56) 90.00 78.56 13%6109820 Uniforms 56.75 200.00 (143.25) 2,656.24 2,200.00 456.24 2,400.00 (256.24) 111%6117840 Telephones 111.30 70.00 41.30 2,237.41 770.00 1,467.41 840.00 (1,397.41) 0%Total PS-OTHER EXPENSES 3,141.59 4,185.00 (1,043.41) 18,861.68 19,325.00 (463.32) 20,295.00 1,433.32 93%20,730.19 23,683.00 (2,952.81) 192,910.80 223,527.00 (30,616.20) 243,485.00 53,002.49 78%Net Income(9,506.04) (10,544.00) 1,037.96 (72,427.05) (77,823.10) 5,396.05 (90,720.05) (16,797.95) -81%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementMay 20103 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 2,580.00 2,640.00 (60.00) 2,880.00 300.00 10.4%6311320 Insurance-Group 8,152.50 8,740.00 (587.50) 96,561.12 96,140.00 421.12 104,880.00 8,318.88 7.9%6311325 Insurance-Workers Comp 1,477.36 3,226.00 (1,748.64) 23,166.03 35,996.00 (12,829.97) 39,329.00 16,162.97 41.1%6311720 Salaries 12,100.96 12,331.00 (230.04) 127,617.76 135,641.00 (8,023.24) 147,972.00 20,354.24 13.8%6311800 Taxes-Employer Payroll 4,090.14 7,034.00 (2,943.86) 58,956.72 79,038.00 (20,081.28) 86,420.00 27,463.28 31.8%6311880 Wages-Hourly 41,764.14 44,163.00 (2,398.86) 475,029.86 485,757.00 (10,727.14) 529,928.00 54,898.14 10.4%6311882 Wages-Overtime 22.32 - 22.32 10,472.27 13,426.00 (2,953.73) 16,234.00 5,761.73 35.5%Total-CM-SALARIES & BENEFITS67,847.42 75,734.00 (7,886.58) 794,383.76 848,638.00 (54,254.24) 927,643.00 133,259.24 14.4%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 2,527.90 900.00 1,627.90 31,299.59 27,300.00 3,999.59 29,300.00 (1,999.59) -6.8%6313744 Fertilizer 5,606.10 5,000.00 606.10 101,922.49 87,200.00 14,722.49 92,200.00 (9,722.49) -10.5%6313745 Herbicides - - - 6,347.99 10,000.00 (3,652.01) 10,000.00 3,652.01 36.5%6313746 Flowers/Plants 598.12 - 598.12 2,376.17 3,500.00 (1,123.83) 3,500.00 1,123.83 32.1%6313748 Fuel-Gasoline 3,598.81 2,860.00 738.81 39,441.81 40,240.00 (798.19) 43,100.00 3,658.19 8.5%6313750 Golf Course Accessories 193.61 100.00 93.61 13,720.29 7,900.00 5,820.29 8,000.00 (5,720.29) -71.5%6313756 POA Control 229.36 - 229.36 8,588.23 7,000.00 1,588.23 7,000.00 (1,588.23) -22.7%6313758 Miscellaneous Supp 1,143.57 100.00 1,043.57 7,189.74 4,250.00 2,939.74 4,350.00 (2,839.74) 0.0%6313762 Supplies-Office - - - 562.17 - 562.17 - (562.17) 0.0%6313774 Sand 774.32 100.00 674.32 6,839.13 11,360.00 (4,520.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,460.00 (2,538.12) 91,810.00 2,888.12 3.1%6313778 Small Tools & Non-Capital Equip 4,042.23 100.00 3,942.23 7,810.45 4,900.00 2,910.45 5,000.00 (2,810.45) -56.2%6313780 Sod - 500.00 (500.00) 9,039.15 4,750.00 4,289.15 5,750.00 (3,289.15) -57.2%6313782 Topdressing - 1,300.00 (1,300.00) 3,642.00 6,300.00 (2,658.00) 7,600.00 3,958.00 52.1%Total-CM-SUPPLIES & MATERIALS18,714.02 11,310.00 7,404.02 331,597.40 306,160.00 25,437.40 319,070.00 (12,527.40) -3.9%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,092.87 1,500.00 (407.13) 19,334.68 15,500.00 3,834.68 17,000.00 (2,334.68) -13.7%6315685 CM-R&M-Bldngs & Othr Structures 125.50 250.00 (124.50) 2,301.65 1,500.00 801.65 1,750.00 (551.65) -31.5%6315690 CM-R&M-Equipment 3,421.59 1,500.00 1,921.59 34,770.45 34,200.00 570.45 35,700.00 929.55 2.6%6315692 CM-R&M-Irrigation System 6,025.07 1,000.00 5,025.07 23,035.90 15,050.00 7,985.90 16,050.00 (6,985.90) -43.5%6315696 CM-R&M-Pumps 5,298.40 500.00 4,798.40 12,730.98 10,500.00 2,230.98 10,500.00 (2,230.98) -21.2%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 15,963.43 4,750.00 11,213.43 100,605.59 86,800.00 13,805.59 91,050.00 (9,555.59) -10.5%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs - - - 40.50 - 40.50 (40.50) 0.0%6317836 Utilities-Natural Gas/LPG 23.40 50.00 (26.60) 135.10 550.00 (414.90) 600.00 464.90 0.0%6317840 Telephones 1,171.43 850.00 321.43 11,396.70 9,350.00 2,046.70 10,200.00 (1,196.70) -11.7%Total-CM-UTILITIES 1,194.83 900.00 294.83 11,572.30 9,900.00 1,672.30 10,800.00 (772.30) -7.2%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 5,500.00 5,500.00 - 6,000.00 500.00 8.3%6319099 Contract Svcs-Security Bldgs - - - 210.00 - 210.00 (210.00) 0.0%6319100 Contract Svcs-Soil/Tissue Test 2,000.00 2,000.00 - 3,500.00 4,000.00 (500.00) 4,000.00 500.00 12.5%6319101 Contract Svcs-Trash Removal 487.83 524.00 (36.17) 5,853.96 5,764.00 89.96 6,288.00 434.04 0.0%6319150 Dues & Subscriptions 320.00 - 320.00 478.00 800.00 (322.00) 900.00 422.00 46.9%6319170 Employee Education - 50.00 (50.00) 1,090.95 1,500.00 (409.05) 1,550.00 459.05 29.6%6319197 Equipment Rental - 200.00 (200.00) 2,966.74 4,100.00 (1,133.26) 4,200.00 1,233.26 29.4%6319206 Licenses & Permits - - - 2,623.35 680.00 1,943.35 680.00 (1,943.35) -285.8%6319490 Miscellaneous 289.00 100.00 189.00 953.92 1,100.00 (146.08) 1,200.00 246.08 20.5%6319718 Safety Equipment & Training 177.86 100.00 77.86 4,514.09 2,500.00 2,014.09 2,600.00 (1,914.09) -73.6%6319822 Uniforms 739.78 820.00 (80.22) 10,252.34 9,020.00 1,232.34 9,840.00 (412.34) -4.2%Total-CM-OTHER EXPENSES 4,514.47 4,294.00 220.47 37,943.35 34,964.00 2,979.35 37,258.00 (685.35) -1.8%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementMay 2010Annual Budget4 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,408.00 2,317.00 (909.00) 22,798.75 25,487.00 (2,688.25) 27,804.00 5,005.25 18.0%6321325 Insurance-Workers Comp 295.17 669.00 (373.83) 4,349.84 7,529.00 (3,179.16) 8,229.00 3,879.16 47.1%6321800 Taxes-Employer Payroll 888.56 1,458.00 (569.44) 11,319.34 16,594.00 (5,274.66) 18,154.00 6,834.66 37.6%6321880 Wages-Hourly 10,660.45 11,712.00 (1,051.55) 113,671.67 128,832.00 (15,160.33) 140,544.00 26,872.33 19.1%6321882 Wages-Overtime 9.35 - 9.35 2,231.01 4,461.00 (2,229.99) 5,272.00 3,040.99 57.7%Total-CM-LM-SALARIES & BENEFITS13,261.53 16,156.00 (2,894.47) 154,370.61 182,903.00 (28,532.39) 200,003.00 45,632.39 22.8%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools 58.32 75.00 (16.68) 147.43 950.00 (802.57) 1,025.00 877.57 85.6%6323788 Uniforms 188.02 290.00 (101.98) 2,012.56 3,190.00 (1,177.44) 3,480.00 1,467.44 42.2%Total-CM-LM-SUPPLIES & MATERIALS246.34 365.00 (118.66) 2,159.99 4,140.00 (1,980.01) 4,505.00 2,345.01 52.1%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation 8,299.15 250.00 8,049.15 8,903.30 3,750.00 5,153.30 4,250.00 (4,653.30) -109.5%Total-CM-LM-REPAIRS & MAINTENANCE 8,299.15 250.00 8,049.15 8,903.30 3,750.00 5,153.30 4,250.00 (4,653.30) -109.5%130,041.19 113,759.00 16,282.19 1,441,536.30 1,477,255.00 (35,718.70) 1,594,579.00 153,042.70 9.6% May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 2,544.80 5,000.00 (2,455.20) 27,909.84 60,000.00 (32,090.16) 65,000.00 37,090.16 57.1%6337842 Utilities-Water4,163.69 1,659.00 2,504.69 33,054.84 20,057.00 12,997.84 21,871.00 (11,183.84) -51.1%6,708.49 6,659.00 49.49 60,964.68 80,057.00 (19,092.32) 86,871.00 25,906.32 29.8%Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetSilverrock ResortCourse Maintenance Water & EnergyMay 2010Total-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementMay 2010Annual BudgetMonth to Date Year to Date5 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 480.00 480.00 - 6,480.00 6,480.00 - 6,960.00 480.00 6.9%6411320 Insurance-Group 58.60 662.00 (603.40) 5,290.20 7,282.00 (1,991.80) 7,944.00 2,653.80 33.4%6411325 Insurance-Workers Comp 335.57 1,210.00 (874.43) 4,267.81 14,950.00 (10,682.19) 16,162.00 11,894.19 73.6%6411800 Taxes-Employer Payroll 1,573.97 1,049.00 524.97 14,916.73 12,964.00 1,952.73 14,012.00 (904.73) -6.5%6411880 Wages-Hourly 11,131.14 8,425.00 2,706.14 115,211.32 104,124.00 11,087.32 112,549.00 (2,662.32) -2.4%6411882 Wages-Overtime 54.56 - 54.56 1,565.47 - 1,565.47 - (1,565.47) 0.0%Total-CBR-SALARIES & BENEFITS13,633.84 11,826.00 1,807.84 147,731.53 145,800.00 1,931.53 157,627.00 9,895.47 6.3%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 50.00 (50.00) 5,197.28 2,300.00 2,897.28 2,350.00 (2,847.28) -121.2%6413742 Supplies-Expendable 995.35 500.00 495.35 8,490.77 4,500.00 3,990.77 5,000.00 (3,490.77) -69.8%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) - 475.00 (475.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - 70.00 (70.00) 445.29 350.00 95.29 420.00 (25.29) -6.0%6413786 Supplies-Towels - 72.00 (72.00) 1,650.27 820.00 830.27 892.00 (758.27) -85.0%6413796 Supplies-Bottled Water189.82 400.00 (210.18) 15,344.14 19,000.00 (3,655.86) 19,400.00 4,055.86 20.9%Total-CBR-SUPPLIES & MATERIALS1,185.17 1,142.00 43.17 38,159.32 33,445.00 4,714.32 34,587.00 (3,572.32) -10.3%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts - 720.00 (720.00) 5,383.44 7,920.00 (2,536.56) 8,640.00 3,256.56 37.7%6415690 CBR-R&M-Equipment 12.17 300.00 (287.83) 4,205.69 3,300.00 905.69 3,600.00 (605.69) -16.8%6415695 CBR-R&M-Cart Maintenance & Repair 642.03 250.00 392.03 17,096.14 3,750.00 13,346.14 4,000.00 (13,096.14) -327.4%Total-CBR-REPAIRS & MAINTENANCE 654.20 1,270.00 (615.80) 26,685.27 14,970.00 11,715.27 16,240.00 (10,445.27) -64.3%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps 330.00 200.00 130.00 6,445.00 4,800.00 1,645.00 5,000.00 (1,445.00) -28.9%6419094 Contract Services-Laundry/Linen 1,268.47 500.00 768.47 9,126.99 5,500.00 3,626.99 6,000.00 (3,126.99) -52.1%6419220 Freight/Delivery - 75.00 (75.00) - 825.00 (825.00) 900.00 900.00 100.0%6419490 Miscellaneous 209.73 125.00 84.73 850.15 1,025.00 (174.85) 1,150.00 299.85 26.1%6419820 Uniforms - 1,500.00 (1,500.00) 2,817.06 5,425.00 (2,607.94) 5,625.00 2,807.94 49.9%Total-CBR-OTHER EXPENSES 1,808.20 2,400.00 (591.80) 19,239.20 17,575.00 1,664.20 18,675.00 (564.20) -3.0%TOTAL-CARTS,BAGROOM & RANGE 17,281.41 16,638.00 643.41 231,815.32 211,790.00 20,025.32 227,129.00 (4,686.32) -2.1%643-CS-SALARIES & BENEFITS6431175 Employee Meals 180.00 180.00 - 3,120.00 3,120.00 - 3,300.00 180.00 5.5%6431325 Insurance-Workers Comp 214.19 116.00 98.19 1,658.00 1,951.00 (293.00) 2,069.00 411.00 19.9%6431800 Taxes-Employer Payroll 401.72 254.00 147.72 5,637.78 4,257.00 1,380.78 4,512.00 (1,125.78) -25.0%6431880 Wages-Hourly 4,947.70 2,040.00 2,907.70 42,118.50 34,200.00 7,918.50 36,240.00 (5,878.50) -16.2%6431882 Wages-Overtime 48.00 - 48.00 351.00 - 351.00 - (351.00) 0.0%Total-CS-SALARIES & BENEFITS5,791.61 2,590.00 3,201.61 52,885.28 43,528.00 9,357.28 46,121.00 (6,764.28) -14.7%643-CS-OTHER EXPENSES6433742 Supplies Expendable 28.44 75.00 (46.56) 1,587.44 975.00 612.44 1,050.00 (537.44) -51.2%6439490 Miscellaneous 18.47 - 18.47 132.59 200.00 (67.41) 200.00 67.41 33.7%6439718 Safety Equipment & Training - 50.00 (50.00) 524.39 550.00 (25.61) 600.00 75.61 12.6%6439820 Uniforms 136.38 75.00 61.38 1,374.61 1,825.00 (450.39) 1,900.00 525.39 27.7%Total-CS-OTHER EXPENSES 183.29 200.00 (16.71) 3,619.03 3,550.00 69.03 3,750.00 130.97 3.5%Total-COURSE SERVICES 5,974.90 2,790.00 3,184.90 56,504.31 47,078.00 9,426.31 49,871.00 (6,633.31) -13.3%23,256.31 19,428.00 3,828.31 288,319.63 258,868.00 29,451.63 277,000.00 (11,450.60) -4.1%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementMay 2010Annual Budget6 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 476.96 4,400.00 (3,923.04) 4,800.00 4,323.04 90.1%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 476.96 4,400.00 (3,923.04) 4,800.00 4,323.04 90.1%65-CH-UTILITIES6507836 Utilities-Natural Gas471.81 300.00 171.81 3,381.04 3,300.00 81.04 3,600.00 218.96 6.1%6507838 Utilities-Sewer- 200.00 (200.00) - 2,200.00 (2,200.00) 2,400.00 2,400.00 100.0%6507840 Utilities-Telephone1,085.15 1,000.00 85.15 12,319.90 11,000.00 1,319.90 12,000.00 (319.90) -2.7%6507842 Utilities-Water604.61 200.00 404.61 4,923.57 2,200.00 2,723.57 2,400.00 (2,523.57) -105.1%6507844 Utilities-Cable336.47 317.00 19.47 3,618.53 3,487.00 131.53 3,800.00 181.47 4.8%Total-CH-UTILITIES 2,498.04 2,017.00 481.04 24,243.04 22,187.00 2,056.04 24,200.00 (43.04) -0.2%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 20,795.00 20,675.00 120.00 22,500.00 1,705.00 7.6%6509098 Contract Services-Refuse Dispose424.47 - 424.47 4,263.05 - 4,263.05 - (4,263.05) 0.0%6509099 Contract Services-Security4,565.04 4,100.00 465.04 56,094.26 45,100.00 10,994.26 49,200.00 (6,894.26) -14.0%6509215 Flowers & Decorations- 100.00 (100.00) - 2,500.00 (2,500.00) 2,600.00 2,600.00 100.0%6509490 Miscellaneous1,194.25 200.00 994.25 2,116.94 2,200.00 (83.06) 2,400.00 283.06 11.8%6509718 Safety Equipment & Training- 100.00 (100.00) 938.15 1,100.00 (161.85) 1,200.00 261.85 21.8%Total-CH-OTHER EXPENSES 8,008.76 6,325.00 1,683.76 84,207.40 71,575.00 12,632.40 77,900.00 (6,307.40) -8.1%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures471.26 200.00 271.26 6,615.04 2,200.00 4,415.04 2,400.00 (4,215.04) -175.6%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 3,501.16 4,400.00 (898.84) 4,800.00 1,298.84 27.1%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 135.00 4,400.00 (4,265.00) 4,800.00 4,665.00 97.2%Total-CH-REPAIRS & MAINTENANCE 471.26 1,000.00 (528.74) 10,251.20 11,000.00 (748.80) 12,000.00 1,748.80 14.6%10,978.06 9,742.00 1,236.06 119,178.60 109,162.00 10,016.60 118,900.00 3,497.60 2.9%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementMay 2010Annual Budget7 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 660.00 660.00 - 720.00 60.00 8.3%6601320 Insurance-Group 270.60 331.00 (60.40) 3,489.72 3,641.00 (151.28) 3,972.00 482.28 12.1%6601325 Insurance-Workers Comp 75.00 143.00 (68.00) 1,090.80 1,573.00 (482.20) 1,713.00 622.20 36.3%6601720 Salaries 2,500.00 2,500.00 - 28,750.00 27,500.00 1,250.00 30,000.00 1,250.00 4.2%6601800 Taxes-Employer Payroll 311.00 311.00 - 3,576.50 3,421.00 155.50 3,735.00 158.50 4.2%Total-MKT-SALARIES & BENEFITS 3,216.60 3,345.00 (128.40) 37,567.02 36,795.00 772.02 40,140.00 2,572.98 6.4%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 379.68 1,100.00 (720.32) 1,200.00 820.32 68.4%6603768 Supplies-Printing & Stationery - 125.00 (125.00) 3,462.42 4,300.00 (837.58) 4,425.00 962.58 21.8%- 225.00 (225.00) 3,842.10 5,400.00 (1,557.90) 5,625.00 1,782.90 31.7%66-MKT-UTILITIES6607840 Utilities-Telephone 83.63 100.00 (16.37) 958.02 1,100.00 (141.98) 1,200.00 241.98 20.2%Total-MKT-UTILITIES 83.63 100.00 (16.37) 958.02 1,100.00 (141.98) 1,200.00 241.98 20.2%66-MKT-OTHER EXPENSES6609010 Advertising 10,201.84 8,477.00 1,724.84 161,873.53 179,207.00 (17,333.47) 185,984.00 24,110.47 13.0%6609040 Business Meals - 25.00 (25.00) 25.00 275.00 (250.00) 300.00 275.00 91.7%6609080 Collateral Material 1,799.09 1,000.00 799.09 6,034.68 8,500.00 (2,465.32) 9,000.00 2,965.32 32.9%6609102 Contract Services-Web Page 99.00 175.00 (76.00) 1,659.00 1,925.00 (266.00) 2,100.00 441.00 21.0%6609490 Miscellaneous - 50.00 (50.00) 32.00 350.00 (318.00) 350.00 318.00 90.9%6609620 Postage - 50.00 (50.00) 296.59 550.00 (253.41) 600.00 303.41 50.6%6609630 Promotion - 50.00 (50.00) 452.28 650.00 (197.72) 700.00 247.72 0.0%6609633 Promotion-Community 271.00 75.00 196.00 1,445.25 2,850.00 (1,404.75) 2,925.00 1,479.75 50.6%6609634 Promotion-Media/Vendor - - - 175.50 6,500.00 (6,324.50) 6,500.00 - 0.0%6609150 Dues and Subscriptions - - - 240.00 735.00 (495.00) 735.00 495.00 67.3%6609820 Uniforms 26.96 - 26.96 39.67 600.00 (560.33) 600.00 560.33 93.4%Total-MKT-OTHER EXPENSES 12,397.89 9,902.00 2,495.89 172,273.50 202,142.00 (29,868.50) 209,794.00 31,196.00 14.9%15,698.12 13,572.00 2,126.12 214,640.64 245,437.00 (30,796.36) 256,759.00 35,793.86 13.9%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementMay 2010Annual Budget8 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 2,083.40 1,980.00 103.40 2,160.00 76.60 3.5%6701320 Insurance-Group1,095.30 1,458.00 (362.70) 15,066.34 16,038.00 (971.66) 17,496.00 2,429.66 13.9%6701325 Insurance-Workers Comp498.93 981.00 (482.07) 6,586.48 10,791.00 (4,204.52) 11,772.00 5,185.52 44.0%6701720 Salaries 14,757.86 14,534.00 223.86 155,933.30 159,874.00 (3,940.70) 174,408.00 18,474.70 10.6%6701800 Taxes-Employer Payroll 1,156.17 2,140.00 (983.83) 14,395.13 23,540.00 (9,144.87) 25,680.00 11,284.87 43.9%6701880 Wages-Hourly2,465.28 2,654.00 (188.72) 19,285.37 29,194.00 (9,908.63) 31,848.00 12,562.63 39.4%6701882 Wages-Overtime 5.44 - 5.44 21.85 - 21.85 - (21.85) 0.0%Total-G&A-SALARIES & BENEFITS 20,158.98 21,947.00 (1,788.02) 213,371.87 241,417.00 (28,045.13) 263,364.00 49,992.13 19.0%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer4,083.88 800.00 3,283.88 6,639.76 10,000.00 (3,360.24) 10,800.00 4,160.24 38.5%6703762 Supplies-Office - 125.00 (125.00) 1,541.62 1,375.00 166.62 1,500.00 (41.62) -2.8%6703768 Supplies-Printing & Stationery144.13 400.00 (255.87) 1,944.26 2,800.00 (855.74) 3,200.00 1,255.74 39.2%6703778Supplies-Small Tools/Non-Capital - 100.00 (100.00) - 900.00 (900.00) 900.00 900.00 100.0%Total-G&A-SUPPLIES & MATERIALS 4,228.01 1,425.00 2,803.01 10,125.64 15,075.00 (4,949.36) 16,400.00 6,274.36 38.3%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 340.84 1,100.00 (759.16) 1,200.00 859.16 71.6%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 340.84 1,100.00 (759.16) 1,200.00 859.16 71.6%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 4,400.00 4,400.00 - 4,800.00 400.00 8.3%6709150 Dues & Subscriptions243.32 500.00 (256.68) 637.32 1,450.00 (812.68) 1,500.00 862.68 57.5%6709180 Employee Recruiting/Relocation- - - 1,270.49 2,600.00 (1,329.51) 2,600.00 1,329.51 51.1%6709197 Equipment Rental540.58 350.00 190.58 5,896.12 3,850.00 2,046.12 4,200.00 (1,696.12) -40.4%6709202 Fees-Bank76.66 90.00 (13.34) 621.17 990.00 (368.83) 1,080.00 458.83 42.5%6709208 Fees-Payroll Processing917.50 550.00 367.50 9,045.63 6,050.00 2,995.63 6,600.00 (2,445.63) -37.1%6709220 Freight/Delivery- 50.00 (50.00) 195.65 550.00 (354.35) 600.00 404.35 67.4%6709490 Miscellaneous - 100.00 (100.00) 847.56 1,100.00 (252.44) 1,200.00 352.44 29.4%6709620 Postage/Mail Services 126.99 75.00 51.99 1,312.63 825.00 487.63 900.00 (412.63) -45.8%6709625 Professional Fees- 400.00 (400.00) 5,604.93 4,400.00 1,204.93 4,800.00 (804.93) -16.8%6709636 Promotion/Entertainment- 100.00 (100.00) 2,402.59 2,500.00 (97.41) 2,600.00 197.41 7.6%6709722 Seminars & Training- 200.00 (200.00) 688.51 2,200.00 (1,511.49) 2,400.00 1,711.49 71.3%6709810 Travel - 500.00 (500.00) - 900.00 (900.00) 1,100.00 1,100.00 100.0%6709820 Uniforms - 75.00 (75.00) 715.39 975.00 (259.61) 1,050.00 334.61 31.9%Total-G&A-OTHER EXPENSES 2,341.42 3,390.00 (1,048.58) 33,674.36 32,790.00 884.36 35,430.00 1,792.01 5.1%26,728.41 26,862.00 (133.59) 257,512.71 290,382.00 (32,869.29) 316,394.00 58,917.66 18.6%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementMay 2010Annual Budget9 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 8,785.41 11,581.00 (2,795.59) 113,413.29 127,391.00 (13,977.71) 138,972.00 25,558.71 18.4%6800193 Equipment Leases-Course Maint 229.31 15,000.00 (14,770.69) 81,298.73 174,000.00 (92,701.27) 189,000.00 107,701.27 57.0%6800194 Equipment Leases-Trailer 540.00 600.00 (60.00) 5,968.50 6,600.00 (631.50) 7,200.00 1,231.50 17.1%6800195 Equipment Leases-Software 419.00 - 419.00 11,892.65 8,232.00 3,660.65 8,232.00 (3,660.65) -44.5%6800196 Equipment Leases-GPS 7,942.00 7,400.00 542.00 82,570.51 81,400.00 1,170.51 88,800.00 6,229.49 7.0%6800197 Equipment Leases-Others 1,531.22 - 1,531.22 23,421.39 - 23,421.39 - - 0.0%19,446.94 34,581.00 (15,134.06) 318,565.07 397,623.00 (79,057.93) 432,204.00 137,060.32 31.7%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee (2,984.34) 5,359.00 (8,343.34) 59,816.72 70,702.00 (10,885.28) 90,000.00 30,183.28 33.5%6900210 FF&E Reserve 6,121.99 5,433.00 688.99 59,994.44 56,669.00 3,325.44 59,610.00 (384.44) -0.6%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) 26,800.84 38,500.00 (11,699.16) 42,000.00 15,199.16 36.2%5,689.09 14,292.00 (8,602.91) 158,189.70 185,871.00 (27,681.30) 211,610.00 53,420.30 25.2%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementMay 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 CategoryJanuaryFebruaryMarchAprilMayJuneMedia4Sales41Promotion7816Golf Industry26 61218 31VIPCelebrityPGA Comp91 536397 75Charity/Gift Certificate4165943 27Rain/Wind Checks93822 3Club Staff63 11394124 150LQ HS Golf82 56 7197 191 329 369 309 011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2009-2010May 2010 Date Time Description CategoryPlayers5/18/2010 12:15 Granite Hills High School Promotion 1612