Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
11 May 2011 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2010 – May 2011 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 Revenue318,877.00 271,650.00 47,227.00 17.4% 3,038,908.23 2,957,169.00 81,739.23 3,111,458.00 72,549.77 98%401000 Miscellaneous Golf Revenue 15,603.50 6,600.00 9,003.50 136.4% 161,139.82 113,615.00 47,524.82 117,656.00 (43,483.82) 137%410000 Revenue-Golf Shop 33,299.06 28,000.00 5,299.06 18.9% 312,258.11 290,567.00 21,691.11 306,492.00 (5,766.11) 102%420000 Revenue-F&B Concession500.00 500.00 - 0.0% 11,500.00 11,500.00 - 12,000.00 500.00 96%890000 Interest Income5.37 - 5.37 0.0% 52.11 - 52.11 - (52.11) 0%Total Income368,284.93 306,750.00 61,534.93 20.1% 3,523,858.27 3,372,851.00 151,007.27 3,547,606.00 23,747.73 99%Cost of Goods Sold510000 COS-Golf Shop 19,378.31 14,861.00 4,517.31 -30.4% 173,130.40 154,215.85 (18,914.55) 162,670.60 (10,459.80) 106%Total COS19,378.31 14,861.00 4,517.31 -30.4% 173,130.40 154,215.85 (18,914.55) 162,670.60 (10,459.80) 106%Gross Profit348,906.62 291,889.00 57,017.62 19.5% 3,350,727.87 3,218,635.15 132,092.72 3,384,935.40 34,207.53 99%Expenses610000 Golf Pro Shop 23,015.75 22,623.00 (392.75) -1.7% 195,939.52 211,609.00 15,669.48 230,213.00 34,273.48 85%630000 Course Maintenance111,618.51 107,814.00 (3,804.51) -3.5% 1,422,743.76 1,427,115.00 4,371.24 1,541,961.00 119,217.24 92%633000 Maintenance Water & Energy7,424.17 6,255.00 (1,169.17) -18.7% 73,416.83 75,848.00 2,431.17 85,358.00 11,941.17 86%640000 Outside Services27,298.67 19,333.00 (7,965.67) -41.2% 272,044.02 268,053.00 (3,991.02) 297,478.00 25,433.98 91%650000 Clubhouse 10,536.40 10,636.00 99.60 0.9% 120,776.16 121,196.00 419.84 132,232.00 11,455.84 91%660000 Marketing 11,494.70 12,716.00 1,221.30 9.6% 223,988.82 251,921.00 27,932.18 262,644.00 38,655.18 85%670000 General & Administrative27,624.91 26,814.00 (810.91) -3.0% 277,790.81 288,354.00 10,563.19 314,808.00 37,017.19 88%680000 Leases 28,735.48 20,000.00 (8,735.48) -43.7% 209,053.91 227,740.00 18,686.09 247,740.00 38,686.09 84%690000 Miscellaneous Other Expense4,566.60 13,673.00 9,106.40 66.6% 151,082.36 169,201.00 18,118.64 192,199.00 41,116.64 79%Total Expenses252,315.19 239,864.00 (12,451.19) -5.2% 2,946,836.19 3,041,037.00 94,200.81 3,304,633.00 357,796.81 89%96,591.43 52,025.00 44,566.43 85.7%403,891.68 177,598.15 226,293.53 80,302.40 (323,589.28) 503%Rounds of Golf PlayedPaid Rounds Played 5,428 4,020 1,408 35.0% 42,560 39,653 2,907 39,150 (3,410) 109%Ave $ Per Paid Round Green Fee58.75 67.57 (8.83) -13.1% 71.40 74.58 (3.17) 76.13 4.73 94%Ave $ Per Paid Round Merchandise6.13 6.97 (0.83) -11.9% 7.34 7.33 0.01 8.07 0.73 91%Ave $ Per Paid Miscellaneous 2.87 1.64 1.23 75.1% 3.79 2.87 0.92 2.06 - 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateMay 20111 Income May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 318,877.00 271,650.00 47,227.00 3,038,908.23 2,957,169.00 81,739.23 3,111,458.0072,549.7798%4010000 Rider Fee 1,025.00 400.00 625.00 9,950.00 6,278.00 3,672.00 6,522.00-3,428.00153%4040000 Club Rental 2,430.00 2,200.00 230.00 23,520.00 26,657.00 (3,137.00) 28,004.004,484.0084%4050000 Driving Range 5,786.00 4,000.00 1,786.00 74,947.00 45,680.00 29,267.00 48,130.00-26,817.00156%4060000 Handicap Fees - - - 3,040.00 - 3,040.00 0.000.000%4080000 GPS Advertising - - - - 12,000.00 (12,000.00) 12,000.00 12,000.000%4090000 Ball Retriever/Subcontract - - - 3,633.82 4,000.00 (366.18) 4,000.00 366.1891%4091000 Golf Professional Rental Fee 6,362.50 - 6,362.50 45,272.25 19,000.00 26,272.25 19,000.00 -26,272.25 238%4092000 Golf Lessons - - - 776.75 - 776.75 - (776.75) 0% Total Revenue Fees 334,480.50 278,250.00 56,230.50 3,200,048.05 3,070,784.00 129,264.05 3,229,114.00 32,105.95 99%334,480.50 278,250.00 56,230.50 3,200,048.05 3,070,784.00 129,264.05 3,229,114.00 32,105.95 99%Total IncomeMonth to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueMay 20112 Income May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 515.40 - 515.40 5,495.13 - 5,495.13 0 0 0%4100110 Sales Hard Goods 10,849.31 9,800.00 1,049.31 99,115.10 101,699.00 (2,583.90) 107,272.00 8,156.90 92%4100112 Sales-Soft Goods 27,873.54 18,200.00 9,673.54 252,648.83 188,868.00 63,780.83 199,220.00 (53,428.83) 127%5100639 GS-Discounts-Mdse (5,939.19) - (5,939.19) (45,000.95) - (45,000.95) - 45,000.95 0% Total Revenue Golf Shop 33,299.06 28,000.00 5,299.06 312,258.11 290,567.00 21,691.11 306,492.00 (270.98) 100%COS 5100150 COS-GS-Hard Goods 5,200.87 5,390.00 (189.13) 50,402.07 55,934.45 (5,532.38) 58,999.60 8,597.53 85%5100151 COS-GS-Soft Goods 13,945.49 10,010.00 3,935.49 118,409.68 103,877.40 14,532.28 109,571.00 (8,838.68) 108%5100152 COS-GS-Purchase Disc (134.43) (770.00) 635.57 (2,154.18) (7,991.00) 5,836.82 (8,429.00) (6,274.82) -26%5100220 COS-GS-Freight Merch 366.38 231.00 135.38 6,472.83 2,395.00 4,077.83 2,529.00 (3,943.83) 256%Cost of Sales - Golf Shop 19,378.31 14,861.00 4,517.31 173,130.40 154,215.85 18,914.55 162,670.60 (10,459.80) 106%Gross Profit 13,920.75 13,139.00 781.75 139,127.71 136,351.15 2,776.56 143,821.40 10,188.82 93%COS % 58.2% 53.1% -5.1% 55.4% 53.1% -2.4% 53.1% 3860.0% -7172%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 2,872.44 2,317.00 555.44 26,957.38 24,494.00 2,463.38 26,811.00 (146.38) 101%6101325 Insurance-Workers Comp 402.10 527.00 (124.90) 4,426.25 5,621.00 (1,194.75) 6,131.00 1,704.75 72%6101720 Salaries 4,018.19 3,750.00 268.19 41,607.64 41,250.00 357.64 45,000.00 3,392.36 92%6101800 Taxes-Employer Payroll 1,335.17 1,591.00 (255.83) 13,347.46 16,984.00 (3,636.54) 18,528.00 5,180.54 72%6101880 Wages-Hourly 9,581.01 9,033.00 548.01 85,425.85 95,165.00 (9,739.15) 103,818.00 18,392.15 82%6101882 Wages-Overtime 205.13 - 205.13 1,760.68 - 1,760.68 - 952.88 0%Total -PS-SALARIES & BENEFITS 18,894.04 17,698.00 1,196.04 178,505.26 188,494.00 (9,988.74) 205,688.00 29,896.30 85%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - 189.74 - 189.74 - (189.74) 0%6103762 Supplies-Office 1,078.49 500.00 578.49 4,056.63 5,500.00 (1,443.37) 6,000.00 1,943.37 68%6109090 Contract Services 500.00 500.00 - 5,500.00 5,500.00 - 6,000.00 500.00 92%6109220 Freight & Delivery - - - 689.19 75.00 614.19 75.00 (614.19) 919%6109490 Miscellaneous - 50.00 (50.00) 314.60 400.00 (85.40) 450.00 135.40 70%6109150 Dues and Subscriptions - 2,300.00 (2,300.00) - 2,300.00 (2,300.00) 2,300.00 2,300.00 0%6109500 ProShop-Over/Short (24.56) - (24.56) (23.47) - (23.47) - 23.47 0%6109722 Seminars/Training 2,453.00 1,250.00 1,203.00 2,998.07 5,855.00 (2,856.93) 5,890.00 2,891.93 51%6109810 Travel - Merchandise - 15.00 (15.00) - 75.00 (75.00) 90.00 90.00 0%6109820 Uniforms - 200.00 (200.00) 2,279.23 2,200.00 79.23 2,400.00 120.77 95%6117840 Telephones 114.78 110.00 4.78 1,430.27 1,210.00 220.27 1,320.00 (110.27) 0%Total PS-OTHER EXPENSES 4,121.71 4,925.00 (803.29) 17,434.26 23,115.00 (5,680.74) 24,525.00 7,090.74 71%23,015.75 22,623.00 392.75 195,939.52 211,609.00 (15,669.48) 230,213.00 36,987.04 84%Net Income(9,095.00) (9,484.00) 389.00 (56,811.81) (75,257.85) 18,446.04 (86,391.60) (26,798.22) -69%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementMay 20113 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 2,640.00 2,640.00 - 2,880.00 240.00 8.3%6311320 Insurance-Group 8,740.00 8,740.00 - 94,021.06 96,140.00 (2,118.94) 104,880.00 10,858.94 10.4%6311325 Insurance-Workers Comp 1,521.05 2,238.00 (716.95) 21,638.96 25,323.00 (3,684.04) 27,638.00 5,999.04 21.7%6311720 Salaries 12,468.48 12,583.00 (114.52) 130,919.04 138,413.00 (7,493.96) 150,996.00 20,076.96 13.3%6311800 Taxes-Employer Payroll 4,465.59 6,762.00 (2,296.41) 61,193.09 77,055.00 (15,861.91) 84,168.00 22,974.91 27.3%6311880 Wages-Hourly 40,484.75 41,730.00 (1,245.25) 472,369.95 467,728.00 4,641.95 509,458.00 37,088.05 7.3%6311882 Wages-Overtime 94.87 - 94.87 21,448.95 12,792.00 8,656.95 15,598.00 (5,850.95) -37.5%Total-CM-SALARIES & BENEFITS68,014.74 72,293.00 (4,278.26) 804,231.05 820,091.00 (15,859.95) 895,618.00 91,386.95 10.2%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 1,122.05 900.00 222.05 32,319.49 27,300.00 5,019.49 29,300.00 (3,019.49) -10.3%6313744 Fertilizer 5,246.05 5,000.00 246.05 80,909.56 84,400.00 (3,490.44) 89,400.00 8,490.44 9.5%6313745 Herbicides - - - 12,221.59 12,000.00 221.59 12,000.00 (221.59) -1.8%6313746 Flowers/Plants - - - 1,253.89 3,050.00 (1,796.11) 3,050.00 1,796.11 58.9%6313748 Fuel-Gasoline 6,034.96 2,860.00 3,174.96 48,667.04 40,240.00 8,427.04 43,100.00 (5,567.04) -12.9%6313750 Golf Course Accessories 168.27 100.00 68.27 12,394.61 12,200.00 194.61 12,300.00 (94.61) -0.8%6313756 POA Control - - - 8,905.76 7,000.00 1,905.76 7,000.00 (1,905.76) -27.2%6313758 Miscellaneous Supp 28.28 100.00 (71.72) 9,596.52 4,250.00 5,346.52 4,350.00 (5,246.52) 0.0%6313762 Supplies-Office 180.22 - 180.22 593.04 - 593.04 - (593.04) 0.0%6313774 Sand 1,537.94 100.00 1,437.94 7,090.01 11,360.00 (4,269.99) 11,460.00 4,369.99 38.1%6313776 Seed - 350.00 (350.00) 96,436.13 91,460.00 4,976.13 91,810.00 (4,626.13) -5.0%6313778 Small Tools & Non-Capital Equip - 100.00 (100.00) 4,388.88 4,900.00 (511.12) 5,000.00 611.12 12.2%6313780 Sod - 500.00 (500.00) 3,179.03 3,150.00 29.03 3,350.00 170.97 5.1%6313782 Topdressing 426.72 1,300.00 (873.28) 8,144.31 6,300.00 1,844.31 7,600.00 (544.31) -7.2%Total-CM-SUPPLIES & MATERIALS14,744.49 11,310.00 3,434.49 326,099.86 307,610.00 18,489.86 319,720.00 (6,379.86) -2.0%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,575.00 2,265.00 (690.00) 18,676.24 22,022.00 (3,345.76) 24,610.00 5,933.76 24.1%6315685 CM-R&M-Bldngs & Othr Structures 132.50 250.00 (117.50) 1,840.69 1,500.00 340.69 1,750.00 (90.69) -5.2%6315690 CM-R&M-Equipment 3,235.18 1,500.00 1,735.18 29,335.18 19,000.00 10,335.18 20,500.00 (8,835.18) -43.1%6315692 CM-R&M-Irrigation System 724.06 1,000.00 (275.94) 13,570.87 15,050.00 (1,479.13) 16,050.00 2,479.13 15.4%6315696 CM-R&M-Pumps 5,175.97 500.00 4,675.97 10,994.27 10,500.00 494.27 10,500.00 (494.27) -4.7%6315815 CM-R&M-Trees-Pruning Etc - - - 9,402.16 10,050.00 (647.84) 10,050.00 647.84 6.4%Total-CM-REPAIRS & MAINTENANCE 10,842.71 5,515.00 5,327.71 83,819.41 78,122.00 5,697.41 83,460.00 (359.41) -0.4%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 46.72 15.00 31.72 307.62 165.00 142.62 180.00 (127.62) 0.0%6317840 Telephones 1,037.36 850.00 187.36 12,020.36 9,350.00 2,670.36 10,200.00 (1,820.36) -17.8%Total-CM-UTILITIES 1,084.08 865.00 219.08 12,327.98 9,515.00 2,812.98 10,380.00 (1,947.98) -18.8%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 5,500.00 5,500.00 - 6,000.00 500.00 8.3%6319100 Contract Svcs-Soil/Tissue Test 1,950.00 - 1,950.00 3,450.00 2,000.00 1,450.00 4,000.00 550.00 13.8%6319101 Contract Svcs-Trash Removal 471.25 525.00 (53.75) 5,101.55 5,775.00 (673.45) 6,288.00 1,186.45 0.0%6319150 Dues & Subscriptions 340.00 - 340.00 895.00 440.00 455.00 540.00 (355.00) -65.7%6319170 Employee Education - 50.00 (50.00) 1,355.32 1,500.00 (144.68) 1,550.00 194.68 12.6%6319197 Equipment Rental - 200.00 (200.00) 5,379.36 4,100.00 1,279.36 4,200.00 (1,179.36) -28.1%6319206 Licenses & Permits - - - 2,348.03 1,430.00 918.03 1,430.00 (918.03) -64.2%6319490 Miscellaneous 65.23 100.00 (34.77) 683.46 1,100.00 (416.54) 1,200.00 516.54 43.0%6319718 Safety Equipment & Training 449.66 100.00 349.66 3,612.08 3,750.00 (137.92) 3,850.00 237.92 6.2%6319822 Uniforms 720.63 820.00 (99.37) 11,229.54 9,020.00 2,209.54 9,840.00 (1,389.54) -14.1%Total-CM-OTHER EXPENSES 4,496.77 2,295.00 2,201.77 39,554.34 34,615.00 4,939.34 38,898.00 (656.34) -1.7%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementMay 2011Annual Budget4 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,317.00 2,317.00 - 23,211.06 25,487.00 (2,275.94) 27,804.00 4,592.94 16.5%6321325 Insurance-Workers Comp 221.98 445.00 (223.02) 3,993.88 5,019.00 (1,025.12) 5,487.00 1,493.12 27.2%6321800 Taxes-Employer Payroll 763.08 1,346.00 (582.92) 10,899.90 15,362.00 (4,462.10) 16,811.00 5,911.10 35.2%6321880 Wages-Hourly 8,926.88 10,813.00 (1,886.12) 109,659.88 118,943.00 (9,283.12) 129,756.00 20,096.12 15.5%6321882 Wages-Overtime 9.84 - 9.84 4,087.18 4,461.00 (373.82) 5,272.00 1,184.82 22.5%Total-CM-LM-SALARIES & BENEFITS12,238.78 14,921.00 (2,682.22) 151,851.90 169,272.00 (17,420.10) 185,130.00 33,278.10 18.0%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 527.91 950.00 (422.09) 1,025.00 497.09 48.5%6323788 Uniforms 196.94 290.00 (93.06) 2,443.27 3,190.00 (746.73) 3,480.00 1,036.73 29.8%Total-CM-LM-SUPPLIES & MATERIALS196.94 365.00 (168.06) 2,971.18 4,140.00 (1,168.82) 4,505.00 1,533.82 34.0%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 250.00 (250.00) 1,888.04 3,750.00 (1,861.96) 4,250.00 2,361.96 55.6%Total-CM-LM-REPAIRS & MAINTENANCE - 250.00 (250.00) 1,888.04 3,750.00 (1,861.96) 4,250.00 2,361.96 55.6%111,618.51 107,814.00 3,804.51 1,422,743.76 1,427,115.00 (4,371.24) 1,541,961.00 119,217.24 7.7% May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 2,698.72 3,000.00 (301.28) 29,436.34 39,300.00 (9,863.66) 42,300.00 12,863.66 30.4%6337842 Utilities-Water4,725.45 3,255.00 1,470.45 43,980.49 36,548.00 7,432.49 43,058.00 (922.49) -2.1%7,424.17 6,255.00 1,169.17 73,416.83 75,848.00 (2,431.17) 85,358.00 11,941.17 14.0%Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetSilverrock ResortCourse Maintenance Water & EnergyMay 2011Total-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementMay 2011Annual 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 662.00 662.00 - 6,059.40 7,282.00 (1,222.60) 7,944.00 1,884.60 23.7%6411325 Insurance-Workers Comp 175.04 387.00 (211.96) 3,978.87 4,729.00 (750.13) 5,096.00 1,117.13 21.9%6411800 Taxes-Employer Payroll 1,750.07 1,169.00 581.07 16,061.88 14,290.00 1,771.88 15,399.00 (662.88) -4.3%6411880 Wages-Hourly 11,940.65 9,390.00 2,550.65 120,306.21 114,779.00 5,527.21 123,689.00 3,382.79 2.7%6411882 Wages-Overtime 315.38 - 315.38 1,884.31 - 1,884.31 - (1,884.31) 0.0%Total-CBR-SALARIES & BENEFITS15,323.14 12,088.00 3,235.14 154,770.67 147,560.00 7,210.67 159,088.00 4,317.33 2.7%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 391.77 50.00 341.77 2,584.57 2,300.00 284.57 2,350.00 (234.57) -10.0%6413742 Supplies-Expendable 73.95 500.00 (426.05) 7,732.92 6,250.00 1,482.92 6,750.00 (982.92) -14.6%6413752 Supplies-Range Balls - - - 7,495.01 6,000.00 1,495.01 6,000.00 (1,495.01) -24.9%6413762 Supplies-Office - 50.00 (50.00) 98.21 475.00 (376.79) 525.00 426.79 81.3%6413768 Supplies-Printing and Stationary - 70.00 (70.00) - 350.00 (350.00) 420.00 420.00 100.0%6413786 Supplies-Towels 240.00 72.00 168.00 240.00 933.00 (693.00) 1,005.00 765.00 76.1%6413796 Supplies-Bottled Water189.82 50.00 139.82 14,924.62 12,500.00 2,424.62 24,500.00 9,575.38 39.1%Total-CBR-SUPPLIES & MATERIALS895.54 792.00 103.54 33,075.33 28,808.00 4,267.33 41,550.00 8,474.67 20.4%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts - 720.00 (720.00) 1,488.61 7,920.00 (6,431.39) 8,640.00 7,151.39 82.8%6415690 CBR-R&M-Equipment 509.43 300.00 209.43 1,955.50 3,300.00 (1,344.50) 3,600.00 1,644.50 45.7%6415695 CBR-R&M-Cart Maintenance & Repair 117.02 250.00 (132.98) 4,605.64 4,750.00 (144.36) 5,000.00 394.36 7.9%Total-CBR-REPAIRS & MAINTENANCE 626.45 1,270.00 (643.55) 8,049.75 15,970.00 (7,920.25) 17,240.00 9,190.25 53.3%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 1,197.40 800.00 397.40 10,087.14 8,800.00 1,287.14 9,600.00 (487.14) -5.1%6419220 Freight/Delivery 19.16 - 19.16 285.26 450.00 (164.74) 450.00 164.74 36.6%6419490 Miscellaneous 2,798.29 125.00 2,673.29 6,763.18 1,025.00 5,738.18 1,150.00 (5,613.18) -488.1%6419820 Uniforms 144.86 1,500.00 (1,355.14) 2,402.20 5,000.00 (2,597.80) 5,200.00 2,797.80 53.8%Total-CBR-OTHER EXPENSES 4,159.71 2,425.00 1,734.71 19,537.78 15,275.00 4,262.78 16,400.00 (3,137.78) -19.1%TOTAL-CARTS,BAGROOM & RANGE 21,004.84 16,575.00 4,429.84 215,433.53 207,613.00 7,820.53 234,278.00 18,844.47 8.0%643-CS-SALARIES & BENEFITS6431175 Employee Meals - 180.00 (180.00) 3,060.00 3,240.00 (180.00) 3,420.00 360.00 10.5%6431325 Insurance-Workers Comp - 84.00 (84.00) 1,306.67 1,653.00 (346.33) 1,738.00 431.33 24.8%6431800 Taxes-Employer Payroll 823.83 254.00 569.83 6,212.49 4,997.00 1,215.49 5,251.00 (961.49) -18.3%6431880 Wages-Hourly 5,470.00 2,040.00 3,430.00 43,978.00 46,775.00 (2,797.00) 48,816.00 4,838.00 9.9%6431882 Wages-Overtime - - - 54.00 - 54.00 - (54.00) 0.0%Total-CS-SALARIES & BENEFITS6,293.83 2,558.00 3,735.83 54,611.16 56,665.00 (2,053.84) 59,225.00 4,613.84 7.8%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 75.00 (75.00) 326.63 975.00 (648.37) 1,050.00 723.37 68.9%6439490 Miscellaneous - - - 510.36 200.00 310.36 200.00 (310.36) -155.2%6439718 Safety Equipment & Training - 50.00 (50.00) 254.05 550.00 (295.95) 600.00 345.95 57.7%6439820 Uniforms - 75.00 (75.00) 908.29 2,050.00 (1,141.71) 2,125.00 1,216.71 57.3%Total-CS-OTHER EXPENSES - 200.00 (200.00) 1,999.33 3,775.00 (1,775.67) 3,975.00 1,975.67 49.7%Total-COURSE SERVICES 6,293.83 2,758.00 3,535.83 56,610.49 60,440.00 (3,829.51) 63,200.00 6,589.51 10.4%27,298.67 19,333.00 7,965.67 272,044.02 268,053.00 3,991.02 297,478.00 23,458.31 7.9%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementMay 2011Annual Budget6 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 1,654.51 4,400.00 (2,745.49) 4,800.00 3,145.49 65.5%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 1,654.51 4,400.00 (2,745.49) 4,800.00 3,145.49 65.5%65-CH-UTILITIES6507836 Utilities-Natural Gas- 300.00 (300.00) 4,854.68 3,300.00 1,554.68 3,600.00 (1,254.68) -34.9%6507840 Utilities-Telephone858.08 1,150.00 (291.92) 11,269.81 12,650.00 (1,380.19) 13,800.00 2,530.19 18.3%6507842 Utilities-Water51.39 321.00 (269.61) 9,082.30 3,531.00 5,551.30 3,852.00 (5,230.30) -135.8%6507844 Utilities-Cable336.89 340.00 (3.11) 3,779.04 3,740.00 39.04 4,080.00 300.96 7.4%Total-CH-UTILITIES 1,246.36 2,111.00 (864.64) 28,985.83 23,221.00 5,764.83 25,332.00 (3,653.83) -14.4%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 20,150.00 20,675.00 (525.00) 22,500.00 2,350.00 10.4%6509099 Contract Services-Security7,039.08 4,900.00 2,139.08 57,372.98 55,500.00 1,872.98 60,400.00 3,027.02 5.0%6509215 Flowers & Decorations- - - - 2,000.00 (2,000.00) 2,400.00 2,400.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 1,383.79 2,200.00 (816.21) 2,400.00 1,016.21 42.3%6509718 Safety Equipment & Training- 100.00 (100.00) 359.85 1,100.00 (740.15) 1,200.00 840.15 70.0%Total-CH-OTHER EXPENSES 8,864.08 7,025.00 1,839.08 79,266.62 81,475.00 (2,208.38) 88,900.00 9,633.38 10.8%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures403.34 300.00 103.34 5,195.33 3,300.00 1,895.33 3,600.00 (1,595.33) -44.3%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 2,199.86 4,400.00 (2,200.14) 4,800.00 2,600.14 54.2%6515690 CH-R&M-Equipment Repair22.62 400.00 (377.38) 3,474.01 4,400.00 (925.99) 4,800.00 1,325.99 27.6%Total-CH-REPAIRS & MAINTENANCE 425.96 1,100.00 (674.04) 10,869.20 12,100.00 (1,230.80) 13,200.00 2,330.80 17.7%10,536.40 10,636.00 (99.60) 120,776.16 121,196.00 (419.84) 132,232.00 4,661.60 3.5%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementMay 2011Annual 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 331.00 331.00 - 3,515.24 3,641.00 (125.76) 3,972.00 456.76 11.5%6601325 Insurance-Workers Comp 79.72 103.00 (23.28) 1,012.47 1,133.00 (120.53) 1,240.00 227.53 18.3%6601720 Salaries 2,491.38 2,508.00 (16.62) 28,311.68 27,588.00 723.68 30,096.00 1,784.32 5.9%6601800 Taxes-Employer Payroll 207.57 312.00 (104.43) 3,584.92 3,432.00 152.92 3,747.00 162.08 4.3%Total-MKT-SALARIES & BENEFITS 3,169.67 3,314.00 (144.33) 37,084.31 36,454.00 630.31 39,775.00 2,690.69 6.8%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 441.33 1,100.00 (658.67) 1,200.00 758.67 63.2%6603768 Supplies-Printing & Stationery 128.16 125.00 3.16 5,429.62 4,300.00 1,129.62 4,425.00 (1,004.62) -22.7%128.16 225.00 (96.84) 5,870.95 5,400.00 470.95 5,625.00 (245.95) -4.4%66-MKT-UTILITIES6607840 Utilities-Telephone 50.41 100.00 (49.59) 557.99 1,100.00 (542.01) 1,200.00 642.01 53.5%Total-MKT-UTILITIES 50.41 100.00 (49.59) 557.99 1,100.00 (542.01) 1,200.00 642.01 53.5%66-MKT-OTHER EXPENSES6609010 Advertising 7,766.35 7,427.00 339.35 168,863.29 186,557.00 (17,693.71) 192,534.00 23,670.71 12.3%6609040 Business Meals - 25.00 (25.00) - 275.00 (275.00) 300.00 300.00 100.0%6609080 Collateral Material - 1,000.00 (1,000.00) 7,334.98 8,500.00 (1,165.02) 9,000.00 1,665.02 18.5%6609102 Contract Services-Web Page 99.00 400.00 (301.00) 1,576.50 4,400.00 (2,823.50) 4,800.00 3,223.50 67.2%6609490 Miscellaneous - 50.00 (50.00) - 350.00 (350.00) 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) 283.62 550.00 (266.38) 600.00 316.38 52.7%6609630 Promotion 37.79 50.00 (12.21) 37.79 650.00 (612.21) 3,500.00 3,462.21 0.0%6609633 Promotion-Community - 75.00 (75.00) 175.00 2,850.00 (2,675.00) 2,925.00 2,750.00 94.0%6609634 Promotion-Media/Vendor - - - 1,610.35 3,500.00 (1,889.65) 700.00 - 0.0%6609150 Dues and Subscriptions 243.32 - 243.32 383.32 735.00 (351.68) 735.00 351.68 47.8%6609820 Uniforms - - - 210.72 600.00 (389.28) 600.00 389.28 64.9%Total-MKT-OTHER EXPENSES 8,146.46 9,077.00 (930.54) 180,475.57 208,967.00 (28,491.43) 216,044.00 36,478.78 16.9%11,494.70 12,716.00 (1,221.30) 223,988.82 251,921.00 (27,932.18) 262,644.00 39,565.53 15.1%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementMay 2011Annual Budget8 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 1,980.00 1,980.00 - 2,160.00 180.00 8.3%6701320 Insurance-Group2,850.25 1,458.00 1,392.25 20,834.20 16,038.00 4,796.20 17,496.00 (3,338.20) -19.1%6701325 Insurance-Workers Comp502.98 707.00 (204.02) 6,362.71 7,777.00 (1,414.29) 8,480.00 2,117.29 25.0%6701720 Salaries 15,205.09 14,833.34 371.75 159,653.49 163,166.74 (3,513.25) 178,000.00 18,346.51 10.3%6701800 Taxes-Employer Payroll 1,362.94 2,136.00 (773.06) 15,200.12 23,496.00 (8,295.88) 25,627.00 10,426.88 40.7%6701880 Wages-Hourly2,568.68 2,319.66 249.02 22,683.84 25,516.26 (2,832.42) 27,835.00 5,151.16 18.5%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 22,669.94 21,634.00 1,035.94 226,714.36 237,974.00 (11,259.64) 259,598.00 32,883.64 12.7%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 400.00 (400.00) 1,709.32 4,400.00 (2,690.68) 5,200.00 3,490.68 67.1%6703762 Supplies-Office - 100.00 (100.00) 1,565.50 1,100.00 465.50 1,200.00 (365.50) -30.5%6703768 Supplies-Printing & Stationery65.23 400.00 (334.77) 1,512.16 2,900.00 (1,387.84) 3,300.00 1,787.84 54.2%Total-G&A-SUPPLIES & MATERIALS 65.23 900.00 (834.77) 4,786.98 8,400.00 (3,613.02) 9,700.00 4,913.02 50.6%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 522.50 1,000.00 (477.50) 1,100.00 577.50 52.5%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 522.50 1,000.00 (477.50) 1,100.00 577.50 52.5%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 & Subscriptions- 500.00 (500.00) 761.71 1,650.00 (888.29) 1,700.00 938.29 55.2%6709180 Employee Recruiting/Relocation- - - 813.93 1,400.00 (586.07) 1,400.00 586.07 41.9%6709197 Equipment Rental628.00 480.00 148.00 6,568.23 5,280.00 1,288.23 5,760.00 (808.23) -14.0%6709202 Fees-Bank57.11 90.00 (32.89) 701.82 990.00 (288.18) 1,080.00 378.18 35.0%6709208 Fees-Payroll Processing3,010.68 760.00 2,250.68 15,695.98 8,360.00 7,335.98 9,120.00 (6,575.98) -72.1%6709220 Freight/Delivery26.64 50.00 (23.36) 37.15 550.00 (512.85) 600.00 562.85 93.8%6709490 Miscellaneous - 100.00 (100.00) 194.42 1,100.00 (905.58) 1,200.00 1,005.58 83.8%6709620 Postage/Mail Services 161.02 75.00 86.02 1,271.37 825.00 446.37 900.00 (371.37) -41.3%6709625 Professional Fees534.25 850.00 (315.75) 11,374.20 9,350.00 2,024.20 10,200.00 (1,174.20) -11.5%6709636 Promotion/Entertainment- 100.00 (100.00) 2,085.00 3,000.00 (915.00) 3,100.00 1,015.00 32.7%6709722 Seminars & Training- 200.00 (200.00) 701.00 2,200.00 (1,499.00) 2,400.00 1,699.00 70.8%6709810 Travel - 500.00 (500.00) - 900.00 (900.00) 1,100.00 1,100.00 100.0%6709820 Uniforms 72.04 75.00 (2.96) 1,162.16 975.00 187.16 1,050.00 (112.16) -10.7%Total-G&A-OTHER EXPENSES 4,889.74 4,180.00 709.74 45,766.97 40,980.00 4,786.97 44,410.00 (1,356.97) -3.1%27,624.91 26,814.00 810.91 277,790.81 288,354.00 (10,563.19) 314,808.00 37,017.19 11.8%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementMay 2011Annual Budget9 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,091.63 13,000.00 (1,908.37) 102,326.39 137,324.00 (34,997.61) 150,324.00 47,997.61 31.9%6800194 Equipment Leases-Trailer 540.00 600.00 (60.00) 5,920.00 6,600.00 (680.00) 7,200.00 1,280.00 17.8%6800196 Equipment Leases-GPS 5,290.50 6,400.00 (1,109.50) 71,565.42 83,816.00 (12,250.58) 90,216.00 18,650.58 20.7%6800197 Equipment Leases-Others 11,813.35 - 11,813.35 29,242.10 - 29,242.10 - - 0.0%28,735.48 20,000.00 8,735.48 209,053.91 227,740.00 (18,686.09) 247,740.00 67,928.19 27.4%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee (4,416.04) 6,040.00 (10,456.04) 49,058.19 72,287.00 (23,228.81) 90,000.00 40,941.81 45.5%6900210 FF&E Reserve 6,377.54 5,433.00 944.54 60,410.93 59,144.00 1,266.93 62,229.00 1,818.07 2.9%6900800 Personal Property Taxes - - - 15,519.02 13,570.00 1,949.02 13,570.00 (1,949.02) -14.4%6900323 Insurance-Commercial 2,605.10 2,200.00 405.10 26,094.22 24,200.00 1,894.22 26,400.00 305.78 1.2%4,566.60 13,673.00 (9,106.40) 151,082.36 169,201.00 (18,118.64) 192,199.00 41,116.64 21.4%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementMay 201110 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2010-20112010 2010 2010 2010 2010 2010Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia4Sales4PromotionGolf Industry85 4VIPCelebrityPGA Comp68 72 76 30 58Charity/Gift Certificate12 44 45Rain/Wind Checks34 4Club Staff77 68 96 3 69 119LQ HS Golf20153 148 208 3 155 2262011 2011 2011 2011 2011 2011Comp CategoryJanuaryFebruaryMarchAprilMayJuneMedia4313Sales6Promotion4Golf Industry4204VIPCelebrity1122PGA Comp29 325557 43Charity/Gift Certificate21 182339 13Rain/Wind Checks39221Club Staff51 10810693 72LQ HS Golf61 131 74 3101 231 328 298 161 011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2010-2011May 2011 Date Time Description CategoryPlayers5/19/2011 1:00 Heimark Distributors Industry 45/22/2011 9:30 Golf News Media 35/24/2011 10:07 Michael Dante Celebrity 212