Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
10 April 2010 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2009 – April 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 April Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 435,183.64 440,310.00 (5,126.36) -1.2% 2,693,621.47 2,561,766.00 131,855.47 2,980,503.00 286,881.53 90%401000 Miscellaneous Golf Revenue 21,058.20 11,080.00 9,978.20 90.1% 135,511.48 99,150.00 36,361.48 109,297.00 (26,214.48) 124%410000 Revenue-Golf Shop 33,994.06 46,800.00 (12,805.94) -27.4% 251,383.35 282,502.00 (31,118.65) 325,551.00 74,167.65 77%420000 Revenue-F&B Concession 500.00 500.00 - 0.0% 11,000.00 11,000.00 - 12,000.00 1,000.00 92%890000 Interest Income 6.56 - 6.56 0.0% 51.49 - 51.49 - (51.49) 0%Total Income490,742.46 498,690.00 (7,947.54) -1.6% 3,091,567.79 2,954,418.00 137,149.79 3,427,351.00 335,783.21 90%Cost of Goods Sold510000 COS-Golf Shop 19,734.83 24,839.00 (5,104.17) 20.5% 142,123.75 149,937.10 7,813.35 172,786.05 30,662.30 82%Total COS19,734.83 24,839.00 (5,104.17) 20.5% 142,123.75 149,937.10 7,813.35 172,786.05 30,662.30 82%Gross Profit471,007.63 473,851.00 (2,843.37) -0.6% 2,949,444.04 2,804,480.90 144,963.14 3,254,564.95 305,120.91 91%Expenses610000 Golf Pro Shop 20,805.09 20,792.00 (13.09) -0.1% 172,180.61 199,844.00 27,663.39 243,485.00 71,304.39 71%630000 Course Maintenance 120,908.04 116,499.00 (4,409.04) -3.8% 1,311,495.11 1,363,496.00 52,000.89 1,594,579.00 283,083.89 82%633000 Maintenance Water & Energy 5,894.46 6,504.00 609.54 9.4% 54,256.19 73,398.00 19,141.81 86,871.00 32,614.81 62%640000 Outside Services 38,385.20 24,218.00 (14,167.20) -58.5% 265,063.32 239,440.00 (25,623.32) 277,000.00 11,936.68 96%650000 Clubhouse 9,664.49 9,742.00 77.51 0.8% 108,200.54 99,420.00 (8,780.54) 118,900.00 10,699.46 91%660000 Marketing 16,485.39 23,122.00 6,636.61 28.7% 198,942.52 231,865.00 32,922.48 256,759.00 57,816.48 77%670000 General & Administrative25,847.42 26,112.00 264.58 1.0% 230,737.25 263,520.00 32,782.75 316,394.00 85,656.75 73%680000 Leases 19,446.94 34,581.00 15,134.06 43.8% 299,118.13 363,042.00 63,923.87 432,204.00 133,085.87 69%690000 Miscellaneous Other Expense 8,545.10 5,705.00 (2,840.10) -49.8% 152,500.61 171,579.00 19,078.39 211,610.00 59,109.39 72%Total Expenses265,982.13 267,275.00 1,292.87 0.5% 2,792,494.28 3,005,604.00 213,109.72 3,537,802.00 745,307.72 79%205,025.50 206,576.00 (1,550.50) -0.8%156,949.76 (201,123.10) 358,072.86 (283,237.05) (440,186.81) -55%Rounds of Golf PlayedPaid Rounds Played 5,254 5,200 54 1.0% 36,195 33,000 3,195 39,150 2,955 92%Ave $ Per Paid Round Green Fee 82.83 84.68 (1.85) -2.2% 74.42 77.63 (3.21) 76.13 1.71 98%Ave $ Per Paid Round Merchandise 6.47 9.00 (2.53) -28.1% 6.95 8.56 (1.62) 8.07 1.12 86%Ave $ Per Paid Miscellaneous 4.01 2.13 1.88 88.1% 3.74 3.00 0.74 2.06 - 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateApril 20101 Income April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 435,183.64 440,310.00 (5,126.36) 2,693,621.47 2,561,766.00 131,855.47 2,980,503.00286,881.5390%4010000 Rider Fee 875.00 520.00 355.00 7,875.00 5,214.00 2,661.00 5,829.00-2,046.00135%4040000 Club Rental 3,650.00 2,860.00 790.00 18,425.00 22,786.00 (4,361.00) 26,168.007,743.0070%4050000 Driving Range 9,978.00 5,200.00 4,778.00 62,717.00 38,150.00 24,567.00 44,300.00-18,417.00142%4060000 Handicap Fees 235.00 - 235.00 8,490.00 8,000.00 490.00 8,000.00 -490.00106%4080000 GPS Advertising - - - 1,500.00 12,000.00 (10,500.00) 12,000.00 10,500.0013%4090000 Ball Retriever/Subcontract 928.70 1,000.00 (71.30) 4,515.98 4,000.00 515.98 4,000.00 -515.98113%4091000 Golf Professional Rental Fee 5,300.00 1,500.00 3,800.00 30,075.00 9,000.00 21,075.00 9,000.00 -21,075.00 334%4092000 Golf Lessons 91.50 - 91.50 1,913.50 - 1,913.50 - (1,913.50) 0% Total Revenue Fees 456,241.84 451,390.00 4,851.84 2,829,132.95 2,660,916.00 168,216.95 3,089,800.00 260,667.05 92%456,241.84 451,390.00 4,851.84 2,829,132.95 2,660,916.00 168,216.95 3,089,800.00 260,667.05 92%SilverRock ResortStatement of Fees RevenueApril 2010Total IncomeMonth to Date Year to Date Annual Budget2 Income April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 139.00 - 139.00 3,589.34 - 3,589.34 0 0 0%4100110 Sales Hard Goods 13,186.54 16,380.00 (3,193.46) 95,609.86 98,876.00 (3,266.14) 113,943.00 18,333.14 84%4100112 Sales-Soft Goods 26,205.00 30,420.00 (4,215.00) 188,664.91 183,626.00 5,038.91 211,608.00 22,943.09 89%5100639 GS-Discounts-Mdse (5,536.48) - (5,536.48) (36,480.76) - (36,480.76) - 36,480.76 0% Total Revenue Golf Shop 33,994.06 46,800.00 (12,805.94) 251,383.35 282,502.00 (31,118.65) 325,551.00 77,756.99 76%COS 5100150 COS-GS-Hard Goods 8,681.42 9,009.00 (327.58) 46,999.22 54,381.80 (7,382.58) 62,668.65 15,669.43 75%5100151 COS-GS-Soft Goods 10,772.33 16,731.00 (5,958.67) 91,361.45 100,994.30 (9,632.85) 116,384.40 25,022.95 78%5100152 COS-GS-Purchase Disc - (1,287.00) 1,287.00 (480.59) (7,771.00) 7,290.41 (8,953.00) (8,472.41) -5%5100220 COS-GS-Freight Merch 281.08 386.00 (104.92) 4,243.67 2,332.00 1,911.67 2,686.00 (1,557.67) 158%Cost of Sales - Golf Shop 19,734.83 24,839.00 (5,104.17) 142,123.75 149,937.10 (7,813.35) 172,786.05 30,662.30 82%Gross Profit 14,259.23 21,961.00 (7,701.77) 109,259.60 132,564.90 (23,305.30) 152,764.95 47,094.69 69%COS % 58.1% 53.1% -5.0% 56.5% 53.1% -3.5% 53.1% 39.4% 26%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 480.00 480.00 - 4,500.00 4,500.00 - 5,400.00 900.00 83%6101320 Insurance Group 2,317.00 2,317.00 - 21,955.37 22,177.00 (221.63) 26,811.00 4,855.63 82%6101325 Insurance-Workers Comp 429.72 818.00 (388.28) 4,311.65 7,637.00 (3,325.35) 9,229.00 4,917.35 47%6101720 Salaries 4,136.37 3,582.00 554.37 37,227.33 35,820.00 1,407.33 20,796.00 (16,431.33) 179%6101800 Taxes-Employer Payroll 1,477.68 1,783.00 (305.32) 12,325.07 16,651.00 (4,325.93) 20,123.00 7,797.93 61%6101880 Wages-Hourly 9,916.10 10,742.00 (825.90) 74,853.77 97,919.00 (23,065.23) 140,831.00 65,977.23 53%6101882 Wages-Overtime 271.52 - 271.52 1,287.33 - 1,287.33 - 952.88 0%Total -PS-SALARIES & BENEFITS 19,028.39 19,722.00 (693.61) 156,460.52 184,704.00 (28,243.48) 223,190.00 68,969.69 69%61-PS OTHER EXPENSES6103762 Supplies-Office 359.72 200.00 159.72 2,402.66 2,750.00 (347.34) 2,950.00 547.34 81%6109090 Contract Services 500.00 500.00 - 5,000.00 5,000.00 - 6,000.00 1,000.00 83%6109220 Freight & Delivery 20.56 - 20.56 709.66 75.00 634.66 75.00 (634.66) 946%6109490 Miscellaneous 99.88 50.00 49.88 297.75 350.00 (52.25) 450.00 152.25 66%6109150 Dues and Subscriptions - - - - - - 2,000.00 2,000.00 0%6109500 ProShop-Over/Short 10.78 - 10.78 17.21 - 17.21 - (17.21) 0%6109722 Seminars/Training 372.75 35.00 337.75 1,578.75 4,205.00 (2,626.25) 5,490.00 3,911.25 29%6109810 Travel - Merchandise - 15.00 (15.00) - 60.00 (60.00) 90.00 90.00 0%6109820 Uniforms 290.68 200.00 90.68 2,599.49 2,000.00 599.49 2,400.00 (199.49) 108%6117840 Telephones 122.33 70.00 52.33 2,126.11 700.00 1,426.11 840.00 (1,286.11) 0%Total PS-OTHER EXPENSES 1,776.70 1,070.00 706.70 15,720.09 15,140.00 580.09 20,295.00 4,574.91 77%20,805.09 20,792.00 13.09 172,180.61 199,844.00 (27,663.39) 243,485.00 73,544.60 70%Net Income(6,545.86) 1,169.00 (7,714.86) (62,921.01) (67,279.10) 4,358.09 (90,720.05) (26,449.91) -71%SilverRock ResortGolf Shop Income StatementApril 2010Total Expenses-Golf ShopMonth to Date Year to Date Annual Budget3 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 2,340.00 2,400.00 (60.00) 2,880.00 540.00 18.8%6311320 Insurance-Group 8,740.00 8,740.00 - 88,408.62 87,400.00 1,008.62 104,880.00 16,471.38 15.7%6311325 Insurance-Workers Comp 1,782.90 3,226.00 (1,443.10) 21,688.67 32,770.00 (11,081.33) 39,329.00 17,640.33 44.9%6311720 Salaries 12,835.20 12,331.00 504.20 115,516.80 123,310.00 (7,793.20) 147,972.00 32,455.20 21.9%6311800 Taxes-Employer Payroll 6,158.07 7,034.00 (875.93) 54,866.58 72,004.00 (17,137.42) 86,420.00 31,553.42 36.5%6311880 Wages-Hourly 44,109.72 44,163.00 (53.28) 433,265.72 441,594.00 (8,328.28) 529,928.00 96,662.28 18.2%6311882 Wages-Overtime 85.05 - 85.05 10,449.95 13,426.00 (2,976.05) 16,234.00 5,784.05 35.6%Total-CM-SALARIES & BENEFITS73,950.94 75,734.00 (1,783.06) 726,536.34 772,904.00 (46,367.66) 927,643.00 201,106.66 21.7%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 3,110.94 2,000.00 1,110.94 28,771.69 26,400.00 2,371.69 29,300.00 528.31 1.8%6313744 Fertilizer 6,106.90 5,000.00 1,106.90 96,316.39 82,200.00 14,116.39 92,200.00 (4,116.39) -4.5%6313745 Herbicides - - - 6,347.99 10,000.00 (3,652.01) 10,000.00 3,652.01 36.5%6313746 Flowers/Plants - 100.00 (100.00) 1,778.05 3,500.00 (1,721.95) 3,500.00 1,721.95 49.2%6313748 Fuel-Gasoline 2,978.02 3,600.00 (621.98) 35,843.00 37,380.00 (1,537.00) 43,100.00 7,257.00 16.8%6313750 Golf Course Accessories - 100.00 (100.00) 13,526.68 7,800.00 5,726.68 8,000.00 (5,526.68) -69.1%6313756 POA Control 245.00 - 245.00 8,358.87 7,000.00 1,358.87 7,000.00 (1,358.87) -19.4%6313758 Miscellaneous Supp 1,539.00 100.00 1,439.00 6,046.17 4,150.00 1,896.17 4,350.00 (1,696.17) 0.0%6313762 Supplies-Office 26.57 - 26.57 562.17 - 562.17 - (562.17) 0.0%6313774 Sand 380.88 100.00 280.88 6,064.81 11,260.00 (5,195.19) 11,460.00 5,395.19 47.1%6313775 Sand-Bunkers - - - 3,896.31 - 3,896.31 - (3,896.31) 0.0%6313776 Seed - 350.00 (350.00) 88,921.88 91,110.00 (2,188.12) 91,810.00 2,888.12 3.1%6313778 Small Tools & Non-Capital Equip - 100.00 (100.00) 3,768.22 4,800.00 (1,031.78) 5,000.00 1,231.78 24.6%6313780 Sod - - - 9,039.15 4,250.00 4,789.15 5,750.00 (3,289.15) -57.2%6313782 Topdressing - - - 3,642.00 5,000.00 (1,358.00) 7,600.00 3,958.00 52.1%Total-CM-SUPPLIES & MATERIALS14,387.31 11,450.00 2,937.31 312,883.38 294,850.00 18,033.38 319,070.00 6,186.62 1.9%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,985.37 1,500.00 1,485.37 18,241.81 14,000.00 4,241.81 17,000.00 (1,241.81) -7.3%6315685 CM-R&M-Bldngs & Othr Structures 125.50 - 125.50 2,176.15 1,250.00 926.15 1,750.00 (426.15) -24.4%6315690 CM-R&M-Equipment 1,834.17 1,500.00 334.17 31,348.86 32,700.00 (1,351.14) 35,700.00 4,351.14 12.2%6315692 CM-R&M-Irrigation System 827.00 1,000.00 (173.00) 17,010.83 14,050.00 2,960.83 16,050.00 (960.83) -6.0%6315696 CM-R&M-Pumps 528.04 1,000.00 (471.96) 7,432.58 10,000.00 (2,567.42) 10,500.00 3,067.42 29.2%6315815 CM-R&M-Trees-Pruning Etc 5,000.00 4,000.00 1,000.00 8,431.93 10,050.00 (1,618.07) 10,050.00 1,618.07 16.1%Total-CM-REPAIRS & MAINTENANCE 11,300.08 9,000.00 2,300.08 84,642.16 82,050.00 2,592.16 91,050.00 6,407.84 7.0%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs - - - 40.50 - 40.50 (40.50) 0.0%6317836 Utilities-Natural Gas/LPG 25.51 50.00 (24.49) 111.70 500.00 (388.30) 600.00 488.30 0.0%6317840 Telephones 1,112.53 850.00 262.53 10,225.27 8,500.00 1,725.27 10,200.00 (25.27) -0.2%Total-CM-UTILITIES 1,138.04 900.00 238.04 10,377.47 9,000.00 1,377.47 10,800.00 422.53 3.9%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 5,000.00 5,000.00 - 6,000.00 1,000.00 16.7%6319099 Contract Svcs-Security Bldgs - - - 210.00 - 210.00 (210.00) 0.0%6319100 Contract Svcs-Soil/Tissue Test - - - 1,500.00 2,000.00 (500.00) 4,000.00 2,500.00 62.5%6319101 Contract Svcs-Trash Removal 487.83 524.00 (36.17) 5,366.13 5,240.00 126.13 6,288.00 921.87 0.0%6319150 Dues & Subscriptions - 200.00 (200.00) 158.00 800.00 (642.00) 900.00 742.00 82.4%6319170 Employee Education - 50.00 (50.00) 1,090.95 1,450.00 (359.05) 1,550.00 459.05 29.6%6319197 Equipment Rental - 200.00 (200.00) 2,966.74 3,900.00 (933.26) 4,200.00 1,233.26 29.4%6319206 Licenses & Permits 1,939.05 150.00 1,789.05 2,623.35 680.00 1,943.35 680.00 (1,943.35) -285.8%6319490 Miscellaneous 225.00 100.00 125.00 664.92 1,000.00 (335.08) 1,200.00 535.08 44.6%6319718 Safety Equipment & Training 446.33 100.00 346.33 4,336.23 2,400.00 1,936.23 2,600.00 (1,736.23) -66.8%6319822 Uniforms 869.73 820.00 49.73 9,512.56 8,200.00 1,312.56 9,840.00 327.44 3.3%Total-CM-OTHER EXPENSES 4,467.94 2,644.00 1,823.94 33,428.88 30,670.00 2,758.88 37,258.00 3,829.12 10.3%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementApril 2010Annual Budget4 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,317.00 2,317.00 - 21,390.75 23,170.00 (1,779.25) 27,804.00 6,413.25 23.1%6321325 Insurance-Workers Comp 344.28 669.00 (324.72) 4,054.67 6,860.00 (2,805.33) 8,229.00 4,174.33 50.7%6321800 Taxes-Employer Payroll 1,352.66 1,458.00 (105.34) 10,430.78 15,136.00 (4,705.22) 18,154.00 7,723.22 42.5%6321880 Wages-Hourly 11,468.94 11,712.00 (243.06) 103,011.22 117,120.00 (14,108.78) 140,544.00 37,532.78 26.7%6321882 Wages-Overtime 7.13 - 7.13 2,221.66 4,461.00 (2,239.34) 5,272.00 3,050.34 57.9%Total-CM-LM-SALARIES & BENEFITS15,490.01 16,156.00 (665.99) 141,109.08 166,747.00 (25,637.92) 200,003.00 58,893.92 29.4%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 89.11 875.00 (785.89) 1,025.00 935.89 91.3%6323788 Uniforms 173.72 290.00 (116.28) 1,824.54 2,900.00 (1,075.46) 3,480.00 1,655.46 47.6%Total-CM-LM-SUPPLIES & MATERIALS173.72 365.00 (191.28) 1,913.65 3,775.00 (1,861.35) 4,505.00 2,591.35 57.5%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 250.00 (250.00) 604.15 3,500.00 (2,895.85) 4,250.00 3,645.85 85.8%Total-CM-LM-REPAIRS & MAINTENANCE - 250.00 (250.00) 604.15 3,500.00 (2,895.85) 4,250.00 3,645.85 85.8%120,908.04 116,499.00 4,409.04 1,311,495.11 1,363,496.00 (52,000.89) 1,594,579.00 283,083.89 17.8% April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 2,595.61 5,000.00 (2,404.39) 25,365.04 55,000.00 (29,634.96) 65,000.00 39,634.96 61.0%6337842 Utilities-Water3,298.85 1,504.00 1,794.85 28,891.15 18,398.00 10,493.15 21,871.00 (7,020.15) -32.1%5,894.46 6,504.00 (609.54) 54,256.19 73,398.00 (19,141.81) 86,871.00 32,614.81 37.5%Silverrock ResortCourse Maintenance Expense StatementApril 2010Annual BudgetMonth to Date Year to DateSilverrock ResortCourse Maintenance Water & EnergyApril 2010Total-COURSE MAINTENANCETotal-CM-WATER & ENERGYMonth to Date Year to Date Annual Budget5 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 720.00 720.00 - 6,000.00 6,000.00 - 6,960.00 960.00 13.8%6411320 Insurance-Group 662.00 662.00 - 5,231.60 6,620.00 (1,388.40) 7,944.00 2,712.40 34.1%6411325 Insurance-Workers Comp 468.12 1,724.00 (1,255.88) 3,932.24 13,740.00 (9,807.76) 16,162.00 12,229.76 75.7%6411800 Taxes-Employer Payroll 2,275.34 1,495.00 780.34 13,342.76 11,915.00 1,427.76 14,012.00 669.24 4.8%6411880 Wages-Hourly 15,346.22 12,009.00 3,337.22 104,080.18 95,699.00 8,381.18 112,549.00 8,468.82 7.5%6411882 Wages-Overtime 257.82 - 257.82 1,510.91 - 1,510.91 - (1,510.91) 0.0%Total-CBR-SALARIES & BENEFITS19,729.50 16,610.00 3,119.50 134,097.69 133,974.00 123.69 157,627.00 23,529.31 14.9%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 87.50 50.00 37.50 5,197.28 2,250.00 2,947.28 2,350.00 (2,847.28) -121.2%6413742 Supplies-Expendable 1,489.73 150.00 1,339.73 7,495.42 4,000.00 3,495.42 5,000.00 (2,495.42) -49.9%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) - 425.00 (425.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary 72.87 70.00 2.87 445.29 280.00 165.29 420.00 (25.29) -6.0%6413786 Supplies-Towels - 72.00 (72.00) 1,650.27 748.00 902.27 892.00 (758.27) -85.0%6413796 Supplies-Bottled Water189.82 400.00 (210.18) 15,154.32 18,600.00 (3,445.68) 19,400.00 4,245.68 21.9%Total-CBR-SUPPLIES & MATERIALS1,839.92 792.00 1,047.92 36,974.15 32,303.00 4,671.15 34,587.00 (2,387.15) -6.9%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts - 720.00 (720.00) 5,383.44 7,200.00 (1,816.56) 8,640.00 3,256.56 37.7%6415690 CBR-R&M-Equipment 828.06 300.00 528.06 4,193.52 3,000.00 1,193.52 3,600.00 (593.52) -16.5%6415695 CBR-R&M-Cart Maintenance & Repair 8,738.18 250.00 8,488.18 16,454.11 3,500.00 12,954.11 4,000.00 (12,454.11) -311.4%Total-CBR-REPAIRS & MAINTENANCE 9,566.24 1,270.00 8,296.24 26,031.07 13,700.00 12,331.07 16,240.00 (9,791.07) -60.3%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps 270.00 250.00 20.00 6,115.00 4,600.00 1,515.00 5,000.00 (1,115.00) -22.3%6419094 Contract Services-Laundry/Linen 705.56 500.00 205.56 7,858.52 5,000.00 2,858.52 6,000.00 (1,858.52) -31.0%6419220 Freight/Delivery - 75.00 (75.00) - 750.00 (750.00) 900.00 900.00 100.0%6419490 Miscellaneous - 125.00 (125.00) 640.42 900.00 (259.58) 1,150.00 509.58 44.3%6419820 Uniforms - - - 2,817.06 3,925.00 (1,107.94) 5,625.00 2,807.94 49.9%Total-CBR-OTHER EXPENSES 975.56 950.00 25.56 17,431.00 15,175.00 2,256.00 18,675.00 1,244.00 6.7%TOTAL-CARTS,BAGROOM & RANGE 32,111.22 19,622.00 12,489.22 214,533.91 195,152.00 19,381.91 227,129.00 12,595.09 5.5%643-CS-SALARIES & BENEFITS6431175 Employee Meals 360.00 360.00 - 2,940.00 2,940.00 - 3,300.00 360.00 10.9%6431325 Insurance-Workers Comp 188.81 178.00 10.81 1,443.81 1,835.00 (391.19) 2,069.00 625.19 30.2%6431800 Taxes-Employer Payroll 885.12 388.00 497.12 5,236.06 4,003.00 1,233.06 4,512.00 (724.06) -16.0%6431880 Wages-Hourly 4,198.47 3,120.00 1,078.47 37,170.80 32,160.00 5,010.80 36,240.00 (930.80) -2.6%6431882 Wages-Overtime 114.00 - 114.00 303.00 - 303.00 - (303.00) 0.0%Total-CS-SALARIES & BENEFITS5,746.40 4,046.00 1,700.40 47,093.67 40,938.00 6,155.67 46,121.00 (972.67) -2.1%643-CS-OTHER EXPENSES6433742 Supplies Expendable 467.66 100.00 367.66 1,559.00 900.00 659.00 1,050.00 (509.00) -48.5%6439490 Miscellaneous - - - 114.12 200.00 (85.88) 200.00 85.88 42.9%6439718 Safety Equipment & Training 59.92 50.00 9.92 524.39 500.00 24.39 600.00 75.61 12.6%6439820 Uniforms - 400.00 (400.00) 1,238.23 1,750.00 (511.77) 1,900.00 661.77 34.8%Total-CS-OTHER EXPENSES 527.58 550.00 (22.42) 3,435.74 3,350.00 85.74 3,750.00 314.26 8.4%Total-COURSE SERVICES 6,273.98 4,596.00 1,677.98 50,529.41 44,288.00 6,241.41 49,871.00 (658.41) -1.3%38,385.20 24,218.00 14,167.20 265,063.32 239,440.00 25,623.32 277,000.00 11,622.42 4.2%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementApril 2010Annual Budget6 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable206.53 400.00 (193.47) 476.96 4,000.00 (3,523.04) 4,800.00 4,323.04 90.1%Total-CH-SUPPLIES & MATERIALS 206.53 400.00 (193.47) 476.96 4,000.00 (3,523.04) 4,800.00 4,323.04 90.1%65-CH-UTILITIES6507836 Utilities-Natural Gas489.94 300.00 189.94 2,909.23 3,000.00 (90.77) 3,600.00 690.77 19.2%6507838 Utilities-Sewer- 200.00 (200.00) - 2,000.00 (2,000.00) 2,400.00 2,400.00 100.0%6507840 Utilities-Telephone1,102.12 1,000.00 102.12 11,234.75 10,000.00 1,234.75 12,000.00 765.25 6.4%6507842 Utilities-Water286.05 200.00 86.05 4,318.96 2,000.00 2,318.96 2,400.00 (1,918.96) -80.0%6507844 Utilities-Cable336.47 317.00 19.47 3,282.06 3,170.00 112.06 3,800.00 517.94 13.6%Total-CH-UTILITIES 2,214.58 2,017.00 197.58 21,745.00 20,170.00 1,575.00 24,200.00 2,455.00 10.1%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 18,970.00 18,850.00 120.00 22,500.00 3,530.00 15.7%6509098 Contract Services-Refuse Dispose291.34 - 291.34 3,838.58 - 3,838.58 - (3,838.58) 0.0%6509099 Contract Services-Security4,565.04 4,100.00 465.04 51,529.22 41,000.00 10,529.22 49,200.00 (2,329.22) -4.7%6509215 Flowers & Decorations- 100.00 (100.00) - 2,400.00 (2,400.00) 2,600.00 2,600.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 922.69 2,000.00 (1,077.31) 2,400.00 1,477.31 61.6%6509718 Safety Equipment & Training- 100.00 (100.00) 938.15 1,000.00 (61.85) 1,200.00 261.85 21.8%Total-CH-OTHER EXPENSES 6,681.38 6,325.00 356.38 76,198.64 65,250.00 10,948.64 77,900.00 1,701.36 2.2%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures562.00 200.00 362.00 6,143.78 2,000.00 4,143.78 2,400.00 (3,743.78) -156.0%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 3,501.16 4,000.00 (498.84) 4,800.00 1,298.84 27.1%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 135.00 4,000.00 (3,865.00) 4,800.00 4,665.00 97.2%Total-CH-REPAIRS & MAINTENANCE 562.00 1,000.00 (438.00) 9,779.94 10,000.00 (220.06) 12,000.00 2,220.06 18.5%9,664.49 9,742.00 (77.51) 108,200.54 99,420.00 8,780.54 118,900.00 4,440.12 3.7%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementApril 2010Annual Budget7 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 600.00 600.00 - 720.00 120.00 16.7%6601320 Insurance-Group 331.00 331.00 - 3,219.12 3,310.00 (90.88) 3,972.00 752.88 19.0%6601325 Insurance-Workers Comp 112.50 143.00 (30.50) 1,015.80 1,430.00 (414.20) 1,713.00 697.20 40.7%6601720 Salaries 3,750.00 2,500.00 1,250.00 26,250.00 25,000.00 1,250.00 30,000.00 3,750.00 12.5%6601800 Taxes-Employer Payroll 466.50 311.00 155.50 3,265.50 3,110.00 155.50 3,735.00 469.50 12.6%Total-MKT-SALARIES & BENEFITS 4,720.00 3,345.00 1,375.00 34,350.42 33,450.00 900.42 40,140.00 5,789.58 14.4%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 379.68 1,000.00 (620.32) 1,200.00 820.32 68.4%6603768 Supplies-Printing & Stationery 626.23 125.00 501.23 3,462.42 4,175.00 (712.58) 4,425.00 962.58 21.8%626.23 225.00 401.23 3,842.10 5,175.00 (1,332.90) 5,625.00 1,782.90 31.7%66-MKT-UTILITIES6607840 Utilities-Telephone 56.93 100.00 (43.07) 874.39 1,000.00 (125.61) 1,200.00 325.61 27.1%Total-MKT-UTILITIES 56.93 100.00 (43.07) 874.39 1,000.00 (125.61) 1,200.00 325.61 27.1%66-MKT-OTHER EXPENSES6609010 Advertising 10,196.33 18,477.00 (8,280.67) 151,671.69 170,730.00 (19,058.31) 185,984.00 34,312.31 18.4%6609040 Business Meals - 25.00 (25.00) 25.00 250.00 (225.00) 300.00 275.00 91.7%6609080 Collateral Material - 500.00 (500.00) 4,235.59 7,500.00 (3,264.41) 9,000.00 4,764.41 52.9%6609102 Contract Services-Web Page 99.00 175.00 (76.00) 1,560.00 1,750.00 (190.00) 2,100.00 540.00 25.7%6609490 Miscellaneous - 50.00 (50.00) 32.00 300.00 (268.00) 350.00 318.00 90.9%6609620 Postage - 50.00 (50.00) 296.59 500.00 (203.41) 600.00 303.41 50.6%6609630 Promotion 152.90 50.00 102.90 452.28 600.00 (147.72) 700.00 247.72 0.0%6609633 Promotion-Community 534.00 75.00 459.00 1,174.25 2,775.00 (1,600.75) 2,925.00 1,750.75 59.9%6609634 Promotion-Media/Vendor - - - 175.50 6,500.00 (6,324.50) 6,500.00 - 0.0%6609150 Dues and Subscriptions 100.00 - 100.00 240.00 735.00 (495.00) 735.00 495.00 67.3%6609820 Uniforms - 50.00 (50.00) 12.71 600.00 (587.29) 600.00 587.29 97.9%Total-MKT-OTHER EXPENSES 11,082.23 19,452.00 (8,369.77) 159,875.61 192,240.00 (32,364.39) 209,794.00 43,593.89 20.8%16,485.39 23,122.00 (6,636.61) 198,942.52 231,865.00 (32,922.48) 256,759.00 51,491.98 20.1%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementApril 2010Annual Budget8 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 283.40 180.00 103.40 1,903.40 1,800.00 103.40 2,160.00 256.60 11.9%6701320 Insurance-Group1,458.00 1,458.00 - 13,971.04 14,580.00 (608.96) 17,496.00 3,524.96 20.1%6701325 Insurance-Workers Comp549.74 981.00 (431.26) 6,087.55 9,810.00 (3,722.45) 11,772.00 5,684.45 48.3%6701720 Salaries 15,652.30 14,534.00 1,118.30 141,175.44 145,340.00 (4,164.56) 174,408.00 33,232.56 19.1%6701800 Taxes-Employer Payroll 1,463.57 2,140.00 (676.43) 13,238.96 21,400.00 (8,161.04) 25,680.00 12,441.04 48.4%6701880 Wages-Hourly2,666.79 2,654.00 12.79 16,820.09 26,540.00 (9,719.91) 31,848.00 15,027.91 47.2%6701882 Wages-Overtime 5.44 - 5.44 16.41 - 16.41 - (16.41) 0.0%Total-G&A-SALARIES & BENEFITS 22,079.24 21,947.00 132.24 193,212.89 219,470.00 (26,257.11) 263,364.00 70,151.11 26.6%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer798.41 800.00 (1.59) 2,555.88 9,200.00 (6,644.12) 10,800.00 8,244.12 76.3%6703762 Supplies-Office 32.60 125.00 (92.40) 1,541.62 1,250.00 291.62 1,500.00 (41.62) -2.8%6703768 Supplies-Printing & Stationery81.12 400.00 (318.88) 1,800.13 2,400.00 (599.87) 3,200.00 1,399.87 43.7%6703778Supplies-Small Tools/Non-Capital - 100.00 (100.00) - 800.00 (800.00) 900.00 900.00 100.0%Total-G&A-SUPPLIES & MATERIALS 912.13 1,425.00 (512.87) 5,897.63 13,650.00 (7,752.37) 16,400.00 10,502.37 64.0%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment42.87 100.00 (57.13) 340.84 1,000.00 (659.16) 1,200.00 859.16 71.6%Total-G&A-REPAIRS & MAINTENANCE 42.87 100.00 (57.13) 340.84 1,000.00 (659.16) 1,200.00 859.16 71.6%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 4,000.00 4,000.00 - 4,800.00 800.00 16.7%6709150 Dues & Subscriptions- 50.00 (50.00) 394.00 950.00 (556.00) 1,500.00 1,106.00 73.7%6709180 Employee Recruiting/Relocation- - - 1,270.49 2,600.00 (1,329.51) 2,600.00 1,329.51 51.1%6709197 Equipment Rental598.60 350.00 248.60 5,355.54 3,500.00 1,855.54 4,200.00 (1,155.54) -27.5%6709202 Fees-Bank52.95 90.00 (37.05) 544.51 900.00 (355.49) 1,080.00 535.49 49.6%6709208 Fees-Payroll Processing1,094.05 550.00 544.05 8,128.13 5,500.00 2,628.13 6,600.00 (1,528.13) -23.2%6709220 Freight/Delivery- 50.00 (50.00) 195.65 500.00 (304.35) 600.00 404.35 67.4%6709490 Miscellaneous - 100.00 (100.00) 847.56 1,000.00 (152.44) 1,200.00 352.44 29.4%6709620 Postage/Mail Services 209.77 75.00 134.77 1,185.64 750.00 435.64 900.00 (285.64) -31.7%6709625 Professional Fees190.00 400.00 (210.00) 5,604.93 4,000.00 1,604.93 4,800.00 (804.93) -16.8%6709636 Promotion/Entertainment267.81 100.00 167.81 2,402.59 2,400.00 2.59 2,600.00 197.41 7.6%6709722 Seminars & Training- 200.00 (200.00) 688.51 2,000.00 (1,311.49) 2,400.00 1,711.49 71.3%6709810 Travel - 200.00 (200.00) - 400.00 (400.00) 1,100.00 1,100.00 100.0%6709820 Uniforms - 75.00 (75.00) 668.34 900.00 (231.66) 1,050.00 381.66 36.3%Total-G&A-OTHER EXPENSES 2,813.18 2,640.00 173.18 31,285.89 29,400.00 1,885.89 35,430.00 4,144.11 11.7%25,847.42 26,112.00 (264.58) 230,737.25 263,520.00 (32,782.75) 316,394.00 85,656.75 27.1%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementApril 2010Annual Budget9 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 8,785.41 11,581.00 (2,795.59) 104,627.88 115,810.00 (11,182.12) 138,972.00 34,344.12 24.7%6800193 Equipment Leases-Course Maint 229.31 15,000.00 (14,770.69) 81,069.42 159,000.00 (77,930.58) 189,000.00 107,930.58 57.1%6800194 Equipment Leases-Trailer 540.00 600.00 (60.00) 5,428.50 6,000.00 (571.50) 7,200.00 1,771.50 24.6%6800195 Equipment Leases-Software 419.00 - 419.00 11,473.65 8,232.00 3,241.65 8,232.00 (3,241.65) -39.4%6800196 Equipment Leases-GPS 7,942.00 7,400.00 542.00 74,628.51 74,000.00 628.51 88,800.00 14,171.49 16.0%6800197 Equipment Leases-Others 1,531.22 - 1,531.22 21,890.17 - 21,890.17 - - 0.0%19,446.94 34,581.00 (15,134.06) 299,118.13 363,042.00 (63,923.87) 432,204.00 154,976.04 35.9%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee (2,710.02) (6,601.00) 3,890.98 62,801.06 65,343.00 (2,541.94) 90,000.00 27,198.94 30.2%6900210 FF&E Reserve 8,703.68 8,806.00 (102.32) 53,872.45 51,236.00 2,636.45 59,610.00 5,737.55 9.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) 24,249.40 35,000.00 (10,750.60) 42,000.00 17,750.60 42.3%8,545.10 5,705.00 2,840.10 152,500.61 171,579.00 (19,078.39) 211,610.00 59,109.39 27.9%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementApril 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 CategoryJanuaryFebruaryMarchAprilMayJuneMedia4Sales41Promotion78Golf Industry26 61218VIPCelebrityPGA Comp91 536397Charity/Gift Certificate4165943Rain/Wind Checks93822Club Staff63 11394124LQ HS Golf82 56197 191 329 369 0 011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2009-2010April 2010 Date Time Description CategoryPlayers4/9/2010 4:00 Palm Desert High School Promotion 812