Loading...
12 June 2011 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2010 – June 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 June Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue161,830.25 154,289.00 7,541.25 4.9% 3,200,738.48 3,111,458.00 89,280.48 3,111,458.00 (89,280.48) 103%401000 Miscellaneous Golf Revenue 5,495.50 4,043.00 1,452.50 35.9% 166,635.32 117,658.00 48,977.32 117,656.00 (48,979.32) 142%410000 Revenue-Golf Shop 13,436.07 15,925.00 (2,488.93) -15.6% 325,694.18 306,492.00 19,202.18 306,492.00 (19,202.18) 106%420000 Revenue-F&B Concession500.00 500.00 - 0.0% 12,000.00 12,000.00 - 12,000.00 - 100%890000 Interest Income5.44 - 5.44 0.0% 57.55 - 57.55 - (57.55) 0%Total Income181,267.26 174,757.00 6,510.26 3.7% 3,705,125.53 3,547,608.00 157,517.53 3,547,606.00 (157,519.53) 104%Cost of Goods Sold510000 COS-Golf Shop 8,862.09 8,451.75 410.34 -4.9% 181,992.49 162,667.60 (19,324.89) 162,670.60 (19,321.89) 112%Total COS8,862.09 8,451.75 410.34 -4.9% 181,992.49 162,667.60 (19,324.89) 162,670.60 (19,321.89) 112%Gross Profit172,405.17 166,305.25 6,099.92 3.7% 3,523,133.04 3,384,940.40 138,192.64 3,384,935.40 (138,197.64) 104%Expenses610000 Golf Pro Shop 15,523.40 18,605.00 3,081.60 16.6% 211,462.92 230,214.00 18,751.08 230,213.00 18,750.08 92%630000 Course Maintenance125,705.91 114,856.00 (10,849.91) -9.4% 1,548,449.67 1,541,971.00 (6,478.67) 1,541,961.00 (6,488.67) 100%633000 Maintenance Water & Energy8,393.77 9,510.00 1,116.23 11.7% 81,810.60 85,358.00 3,547.40 85,358.00 3,547.40 96%640000 Outside Services32,640.33 29,423.00 (3,217.33) -10.9% 304,684.35 297,476.00 (7,208.35) 297,478.00 (7,206.35) 102%650000 Clubhouse 11,199.19 11,036.00 (163.19) -1.5% 131,975.35 132,232.00 256.65 132,232.00 256.65 100%660000 Marketing 24,014.01 10,716.00 (13,298.01) -124.1% 248,002.83 262,637.00 14,634.17 262,644.00 14,641.17 94%670000 General & Administrative27,048.06 26,464.00 (584.06) -2.2% 304,838.87 314,818.00 9,979.13 314,808.00 9,969.13 97%680000 Leases 21,493.27 20,000.00 (1,493.27) -7.5% 230,547.18 247,740.00 17,192.82 247,740.00 17,192.82 93%690000 Miscellaneous Other Expense24,991.59 22,999.00 (1,992.59) -8.7% 198,328.80 192,200.00 (6,128.80) 192,199.00 (6,129.80) 103%Total Expenses291,009.53 263,609.00 (27,400.53) -10.4% 3,260,100.57 3,304,646.00 44,545.43 3,304,633.00 44,532.43 99%(118,604.36) (97,303.75) (21,300.61) -21.9%263,032.47 80,294.40 182,738.07 80,302.40 (182,730.07) 328%Rounds of Golf PlayedPaid Rounds Played 2,709 2,450 259 10.6% 45,269 42,104 3,165 39,150 (6,119) 116%Ave $ Per Paid Round Green Fee59.74 62.98 (3.24) -5.1% 70.70 73.90 (3.19) 76.13 5.43 93%Ave $ Per Paid Round Merchandise4.96 6.50 (1.54) -23.7% 7.19 7.28 (0.08) 8.07 0.88 89%Ave $ Per Paid Miscellaneous 2.03 1.65 0.38 22.9% 3.68 2.79 0.89 2.06 - 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateJune 20111 Income June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 161,830.25 154,289.00 7,541.25 3,200,738.48 3,111,458.00 89,280.48 3,111,458.00-89,280.48103%4010000 Rider Fee 425.00 245.00 180.00 10,375.00 6,523.00 3,852.00 6,522.00-3,853.00159%4040000 Club Rental 1,220.00 1,348.00 (128.00) 24,740.00 28,005.00 (3,265.00) 28,004.003,264.0088%4050000 Driving Range 3,379.00 2,450.00 929.00 78,326.00 48,130.00 30,196.00 48,130.00-30,196.00163%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 - - - 45,272.25 19,000.00 26,272.25 19,000.00 -26,272.25 238%4092000 Golf Lessons 471.50 - 471.50 1,248.25 - 1,248.25 - (1,248.25) 0% Total Revenue Fees 167,325.75 158,332.00 8,993.75 3,367,373.80 3,229,116.00 138,257.80 3,229,114.00 (135,219.80) 104%167,325.75 158,332.00 8,993.75 3,367,373.80 3,229,116.00 138,257.80 3,229,114.00 (135,219.80) 104%SilverRock ResortStatement of Fees RevenueJune 2011Total IncomeMonth to Date Year to Date Annual Budget2 Income June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 336.00 - 336.00 5,831.13 - 5,831.13 0 0 0%4100110 Sales Hard Goods 5,368.81 5,574.00 (205.19) 104,483.91 107,273.00 (2,789.09) 107,272.00 2,788.09 97%4100112 Sales-Soft Goods 9,395.94 10,351.00 (955.06) 262,044.77 199,219.00 62,825.77 199,220.00 (62,824.77) 132%5100639 GS-Discounts-Mdse (1,664.68) - (1,664.68) (46,665.63) - (46,665.63) - 46,665.63 0% Total Revenue Golf Shop 13,436.07 15,925.00 (2,488.93) 325,694.18 306,492.00 19,202.18 306,492.00 (13,371.05) 104%COS 5100150 COS-GS-Hard Goods 3,244.94 3,065.70 179.24 53,647.01 59,000.15 (5,353.14) 58,999.60 5,352.59 91%5100151 COS-GS-Soft Goods 5,503.66 5,693.05 (189.39) 123,913.34 109,570.45 14,342.89 109,571.00 (14,342.34) 113%5100152 COS-GS-Purchase Disc (54.56) (438.00) 383.44 (2,208.74) (8,429.00) 6,220.26 (8,429.00) (6,220.26) -26%5100220 COS-GS-Freight Merch 168.05 131.00 37.05 6,640.88 2,526.00 4,114.88 2,529.00 (4,111.88) 263%Cost of Sales - Golf Shop 8,862.09 8,451.75 410.34 181,992.49 162,667.60 19,324.89 162,670.60 (19,321.89) 112%Gross Profit 4,573.98 7,473.25 (2,899.27) 143,701.69 143,824.40 (122.71) 143,821.40 5,950.84 96%COS % 66.0% 53.1% -12.9% 55.9% 53.1% -2.8% 53.1% 144.5% -172%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 420.00 420.00 - 5,400.00 5,400.00 - 5,400.00 - 100%6101320 Insurance Group 2,607.66 2,317.00 290.66 29,565.04 26,811.00 2,754.04 26,811.00 (2,754.04) 110%6101325 Insurance-Workers Comp 322.65 511.00 (188.35) 4,748.90 6,132.00 (1,383.10) 6,131.00 1,382.10 77%6101720 Salaries 3,900.00 3,750.00 150.00 45,507.64 45,000.00 507.64 45,000.00 (507.64) 101%6101800 Taxes-Employer Payroll 917.43 1,544.00 (626.57) 14,264.89 18,528.00 (4,263.11) 18,528.00 4,263.11 77%6101880 Wages-Hourly 6,164.37 8,653.00 (2,488.63) 91,590.22 103,818.00 (12,227.78) 103,818.00 12,227.78 88%6101882 Wages-Overtime 18.33 - 18.33 1,779.01 - 1,779.01 - 952.88 0%Total -PS-SALARIES & BENEFITS 14,350.44 17,195.00 (2,844.56) 192,855.70 205,689.00 (12,833.30) 205,688.00 15,564.19 92%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - 189.74 - 189.74 - (189.74) 0%6103762 Supplies-Office - 500.00 (500.00) 4,056.63 6,000.00 (1,943.37) 6,000.00 1,943.37 68%6109090 Contract Services 500.00 500.00 - 6,000.00 6,000.00 - 6,000.00 - 100%6109220 Freight & Delivery - - - 689.19 75.00 614.19 75.00 (614.19) 919%6109490 Miscellaneous 96.90 50.00 46.90 411.50 450.00 (38.50) 450.00 38.50 91%6109150 Dues and Subscriptions - - - - 2,300.00 (2,300.00) 2,300.00 2,300.00 0%6109500 ProShop-Over/Short (2.89) - (2.89) (26.36) - (26.36) - 26.36 0%6109722 Seminars/Training - 35.00 (35.00) 2,998.07 5,890.00 (2,891.93) 5,890.00 2,891.93 51%6109810 Travel - Merchandise - 15.00 (15.00) - 90.00 (90.00) 90.00 90.00 0%6109820 Uniforms 464.17 200.00 264.17 2,743.40 2,400.00 343.40 2,400.00 (343.40) 114%6117840 Telephones 114.78 110.00 4.78 1,545.05 1,320.00 225.05 1,320.00 (225.05) 0%Total PS-OTHER EXPENSES 1,172.96 1,410.00 (237.04) 18,607.22 24,525.00 (5,917.78) 24,525.00 5,917.78 76%15,523.40 18,605.00 (3,081.60) 211,462.92 230,214.00 (18,751.08) 230,213.00 21,481.97 91%Net Income(10,949.42) (11,131.75) 182.33 (67,761.23) (86,389.60) 18,628.37 (86,391.60) (15,531.13) -82%SilverRock ResortGolf Shop Income StatementJune 2011Total Expenses-Golf ShopMonth to Date Year to Date Annual Budget3 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 2,880.00 2,880.00 - 2,880.00 - 0.0%6311320 Insurance-Group 8,434.28 8,740.00 (305.72) 102,455.34 104,880.00 (2,424.66) 104,880.00 2,424.66 2.3%6311325 Insurance-Workers Comp 1,728.47 2,315.00 (586.53) 23,367.43 27,638.00 (4,270.57) 27,638.00 4,270.57 15.5%6311720 Salaries 12,101.76 12,583.00 (481.24) 143,020.80 150,996.00 (7,975.20) 150,996.00 7,975.20 5.3%6311800 Taxes-Employer Payroll 4,319.83 7,111.00 (2,791.17) 65,512.92 84,166.00 (18,653.08) 84,168.00 18,655.08 22.2%6311880 Wages-Hourly 41,306.43 41,730.00 (423.57) 513,676.38 509,458.00 4,218.38 509,458.00 (4,218.38) -0.8%6311882 Wages-Overtime 606.53 2,806.00 (2,199.47) 22,055.48 15,598.00 6,457.48 15,598.00 (6,457.48) -41.4%Total-CM-SALARIES & BENEFITS68,737.30 75,525.00 (6,787.70) 872,968.35 895,616.00 (22,647.65) 895,618.00 22,649.65 2.5%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 4,562.08 2,000.00 2,562.08 36,881.57 29,300.00 7,581.57 29,300.00 (7,581.57) -25.9%6313744 Fertilizer 8,715.97 5,000.00 3,715.97 89,625.53 89,400.00 225.53 89,400.00 (225.53) -0.3%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 3,673.26 2,860.00 813.26 52,340.30 43,100.00 9,240.30 43,100.00 (9,240.30) -21.4%6313750 Golf Course Accessories 961.04 100.00 861.04 13,355.65 12,300.00 1,055.65 12,300.00 (1,055.65) -8.6%6313756 POA Control 244.54 - 244.54 9,150.30 7,000.00 2,150.30 7,000.00 (2,150.30) -30.7%6313758 Miscellaneous Supp 329.48 100.00 229.48 9,926.00 4,350.00 5,576.00 4,350.00 (5,576.00) 0.0%6313762 Supplies-Office 187.62 - 187.62 780.66 - 780.66 - (780.66) 0.0%6313774 Sand 7,621.11 100.00 7,521.11 14,711.12 11,460.00 3,251.12 11,460.00 (3,251.12) -28.4%6313776 Seed - 350.00 (350.00) 96,436.13 91,810.00 4,626.13 91,810.00 (4,626.13) -5.0%6313778 Small Tools & Non-Capital Equip 146.27 100.00 46.27 4,535.15 5,000.00 (464.85) 5,000.00 464.85 9.3%6313780 Sod - 200.00 (200.00) 3,179.03 3,350.00 (170.97) 3,350.00 170.97 5.1%6313782 Topdressing 2,326.55 1,300.00 1,026.55 10,470.86 7,600.00 2,870.86 7,600.00 (2,870.86) -37.8%Total-CM-SUPPLIES & MATERIALS28,767.92 12,110.00 16,657.92 354,867.78 319,720.00 35,147.78 319,720.00 (35,147.78) -11.0%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,575.00 2,590.00 (1,015.00) 20,251.24 24,612.00 (4,360.76) 24,610.00 4,358.76 17.7%6315685 CM-R&M-Bldngs & Othr Structures 2,299.50 250.00 2,049.50 4,140.19 1,750.00 2,390.19 1,750.00 (2,390.19) -136.6%6315690 CM-R&M-Equipment 1,680.58 1,500.00 180.58 31,015.76 20,500.00 10,515.76 20,500.00 (10,515.76) -51.3%6315692 CM-R&M-Irrigation System 1,103.04 1,000.00 103.04 14,673.91 16,050.00 (1,376.09) 16,050.00 1,376.09 8.6%6315696 CM-R&M-Pumps - - - 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 6,658.12 5,340.00 1,318.12 90,477.53 83,462.00 7,015.53 83,460.00 (7,017.53) -8.4%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 22.19 15.00 7.19 329.81 180.00 149.81 180.00 (149.81) 0.0%6317840 Telephones 1,031.51 850.00 181.51 13,051.87 10,200.00 2,851.87 10,200.00 (2,851.87) -28.0%Total-CM-UTILITIES 1,053.70 865.00 188.70 13,381.68 10,380.00 3,001.68 10,380.00 (3,001.68) -28.9%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 6,000.00 6,000.00 - 6,000.00 - 0.0%6319100 Contract Svcs-Soil/Tissue Test - 2,000.00 (2,000.00) 3,450.00 4,000.00 (550.00) 4,000.00 550.00 13.8%6319101 Contract Svcs-Trash Removal 942.50 525.00 417.50 6,044.05 6,300.00 (255.95) 6,288.00 243.95 0.0%6319150 Dues & Subscriptions 245.00 100.00 145.00 1,140.00 540.00 600.00 540.00 (600.00) -111.1%6319170 Employee Education - 50.00 (50.00) 1,355.32 1,550.00 (194.68) 1,550.00 194.68 12.6%6319197 Equipment Rental 2,631.95 100.00 2,531.95 8,011.31 4,200.00 3,811.31 4,200.00 (3,811.31) -90.7%6319206 Licenses & Permits - - - 2,348.03 1,430.00 918.03 1,430.00 (918.03) -64.2%6319490 Miscellaneous - 100.00 (100.00) 683.46 1,200.00 (516.54) 1,200.00 516.54 43.0%6319718 Safety Equipment & Training 315.87 100.00 215.87 3,927.95 3,850.00 77.95 3,850.00 (77.95) -2.0%6319822 Uniforms 902.04 820.00 82.04 12,131.58 9,840.00 2,291.58 9,840.00 (2,291.58) -23.3%Total-CM-OTHER EXPENSES 5,537.36 4,295.00 1,242.36 45,091.70 38,910.00 6,181.70 38,898.00 (6,193.70) -15.9%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementJune 2011Annual Budget4 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,615.33 2,317.00 (701.67) 24,826.39 27,804.00 (2,977.61) 27,804.00 2,977.61 10.7%6321325 Insurance-Workers Comp 366.32 468.00 (101.68) 4,360.20 5,487.00 (1,126.80) 5,487.00 1,126.80 20.5%6321800 Taxes-Employer Payroll 883.35 1,447.00 (563.65) 11,783.25 16,809.00 (5,025.75) 16,811.00 5,027.75 29.9%6321880 Wages-Hourly 11,447.57 10,813.00 634.57 121,107.45 129,756.00 (8,648.55) 129,756.00 8,648.55 6.7%6321882 Wages-Overtime - 811.00 (811.00) 4,087.18 5,272.00 (1,184.82) 5,272.00 1,184.82 22.5%Total-CM-LM-SALARIES & BENEFITS14,312.57 15,856.00 (1,543.43) 166,164.47 185,128.00 (18,963.53) 185,130.00 18,965.53 10.2%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 527.91 1,025.00 (497.09) 1,025.00 497.09 48.5%6323788 Uniforms 198.83 290.00 (91.17) 2,642.10 3,480.00 (837.90) 3,480.00 837.90 24.1%Total-CM-LM-SUPPLIES & MATERIALS198.83 365.00 (166.17) 3,170.01 4,505.00 (1,334.99) 4,505.00 1,334.99 29.6%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation 440.11 500.00 (59.89) 2,328.15 4,250.00 (1,921.85) 4,250.00 1,921.85 45.2%Total-CM-LM-REPAIRS & MAINTENANCE 440.11 500.00 (59.89) 2,328.15 4,250.00 (1,921.85) 4,250.00 1,921.85 45.2%125,705.91 114,856.00 10,849.91 1,548,449.67 1,541,971.00 6,478.67 1,541,961.00 (6,488.67) -0.4% June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 2,902.08 3,000.00 (97.92) 32,338.42 42,300.00 (9,961.58) 42,300.00 9,961.58 23.5%6337842 Utilities-Water5,491.69 6,510.00 (1,018.31) 49,472.18 43,058.00 6,414.18 43,058.00 (6,414.18) -14.9%8,393.77 9,510.00 (1,116.23) 81,810.60 85,358.00 (3,547.40) 85,358.00 3,547.40 4.2%Silverrock ResortCourse Maintenance Expense StatementJune 2011Annual BudgetMonth to Date Year to DateSilverrock ResortCourse Maintenance Water & EnergyJune 2011Total-COURSE MAINTENANCETotal-CM-WATER & ENERGYMonth to Date Year to Date Annual Budget5 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 498.55 662.00 (163.45) 6,557.95 7,944.00 (1,386.05) 7,944.00 1,386.05 17.4%6411325 Insurance-Workers Comp 364.61 367.00 (2.39) 4,343.48 5,096.00 (752.52) 5,096.00 752.52 14.8%6411800 Taxes-Employer Payroll 1,564.29 1,109.00 455.29 17,626.17 15,399.00 2,227.17 15,399.00 (2,227.17) -14.5%6411880 Wages-Hourly 11,221.81 8,910.00 2,311.81 131,528.02 123,689.00 7,839.02 123,689.00 (7,839.02) -6.3%6411882 Wages-Overtime 172.31 - 172.31 2,056.62 - 2,056.62 - (2,056.62) 0.0%Total-CBR-SALARIES & BENEFITS14,301.57 11,528.00 2,773.57 169,072.24 159,088.00 9,984.24 159,088.00 (9,984.24) -6.3%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 50.00 (50.00) 2,584.57 2,350.00 234.57 2,350.00 (234.57) -10.0%6413742 Supplies-Expendable 462.41 500.00 (37.59) 8,195.33 6,750.00 1,445.33 6,750.00 (1,445.33) -21.4%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 525.00 (426.79) 525.00 426.79 81.3%6413768 Supplies-Printing and Stationary - 70.00 (70.00) - 420.00 (420.00) 420.00 420.00 100.0%6413786 Supplies-Towels 480.00 72.00 408.00 720.00 1,005.00 (285.00) 1,005.00 285.00 28.4%6413796 Supplies-Bottled Water6,523.07 12,000.00 (5,476.93) 21,447.69 24,500.00 (3,052.31) 24,500.00 3,052.31 12.5%Total-CBR-SUPPLIES & MATERIALS7,465.48 12,742.00 (5,276.52) 40,540.81 41,550.00 (1,009.19) 41,550.00 1,009.19 2.4%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts - 720.00 (720.00) 1,488.61 8,640.00 (7,151.39) 8,640.00 7,151.39 82.8%6415690 CBR-R&M-Equipment 783.34 300.00 483.34 2,738.84 3,600.00 (861.16) 3,600.00 861.16 23.9%6415695 CBR-R&M-Cart Maintenance & Repair 131.81 250.00 (118.19) 4,737.45 5,000.00 (262.55) 5,000.00 262.55 5.3%Total-CBR-REPAIRS & MAINTENANCE 915.15 1,270.00 (354.85) 8,964.90 17,240.00 (8,275.10) 17,240.00 8,275.10 48.0%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 1,216.59 800.00 416.59 11,303.73 9,600.00 1,703.73 9,600.00 (1,703.73) -17.7%6419220 Freight/Delivery - - - 285.26 450.00 (164.74) 450.00 164.74 36.6%6419490 Miscellaneous 405.64 125.00 280.64 7,168.82 1,150.00 6,018.82 1,150.00 (6,018.82) -523.4%6419820 Uniforms 1,485.32 200.00 1,285.32 3,887.52 5,200.00 (1,312.48) 5,200.00 1,312.48 25.2%Total-CBR-OTHER EXPENSES 3,107.55 1,125.00 1,982.55 22,645.33 16,400.00 6,245.33 16,400.00 (6,245.33) -38.1%TOTAL-CARTS,BAGROOM & RANGE 25,789.75 26,665.00 (875.25) 241,223.28 234,278.00 6,945.28 234,278.00 (6,945.28) -3.0%643-CS-SALARIES & BENEFITS6431175 Employee Meals 180.00 180.00 - 3,240.00 3,420.00 (180.00) 3,420.00 180.00 5.3%6431325 Insurance-Workers Comp 143.87 84.00 59.87 1,450.54 1,737.00 (286.46) 1,738.00 287.46 16.5%6431800 Taxes-Employer Payroll 665.22 254.00 411.22 6,877.71 5,251.00 1,626.71 5,251.00 (1,626.71) -31.0%6431880 Wages-Hourly 4,484.00 2,040.00 2,444.00 48,462.00 48,815.00 (353.00) 48,816.00 354.00 0.7%6431882 Wages-Overtime 12.00 - 12.00 66.00 - 66.00 - (66.00) 0.0%Total-CS-SALARIES & BENEFITS5,485.09 2,558.00 2,927.09 60,096.25 59,223.00 873.25 59,225.00 (871.25) -1.5%643-CS-OTHER EXPENSES6433742 Supplies Expendable 1,205.02 75.00 1,130.02 1,531.65 1,050.00 481.65 1,050.00 (481.65) -45.9%6439490 Miscellaneous - - - 510.36 200.00 310.36 200.00 (310.36) -155.2%6439718 Safety Equipment & Training 97.66 50.00 47.66 351.71 600.00 (248.29) 600.00 248.29 41.4%6439820 Uniforms 62.81 75.00 (12.19) 971.10 2,125.00 (1,153.90) 2,125.00 1,153.90 54.3%Total-CS-OTHER EXPENSES 1,365.49 200.00 1,165.49 3,364.82 3,975.00 (610.18) 3,975.00 610.18 15.4%Total-COURSE SERVICES 6,850.58 2,758.00 4,092.58 63,461.07 63,198.00 263.07 63,200.00 (261.07) -0.4%32,640.33 29,423.00 3,217.33 304,684.35 297,476.00 7,208.35 297,478.00 (7,816.53) -2.6%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementJune 2011Annual Budget6 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable1,012.86 400.00 612.86 2,667.37 4,800.00 (2,132.63) 4,800.00 2,132.63 44.4%Total-CH-SUPPLIES & MATERIALS 1,012.86 400.00 612.86 2,667.37 4,800.00 (2,132.63) 4,800.00 2,132.63 44.4%65-CH-UTILITIES6507836 Utilities-Natural Gas406.17 300.00 106.17 5,260.85 3,600.00 1,660.85 3,600.00 (1,660.85) -46.1%6507840 Utilities-Telephone1,216.72 1,150.00 66.72 12,486.53 13,800.00 (1,313.47) 13,800.00 1,313.47 9.5%6507842 Utilities-Water510.93 321.00 189.93 9,593.23 3,852.00 5,741.23 3,852.00 (5,741.23) -149.0%6507844 Utilities-Cable336.89 340.00 (3.11) 4,115.93 4,080.00 35.93 4,080.00 (35.93) -0.9%Total-CH-UTILITIES 2,470.71 2,111.00 359.71 31,456.54 25,332.00 6,124.54 25,332.00 (6,124.54) -24.2%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 21,975.00 22,500.00 (525.00) 22,500.00 525.00 2.3%6509099 Contract Services-Security5,050.04 4,900.00 150.04 62,423.02 60,400.00 2,023.02 60,400.00 (2,023.02) -3.3%6509215 Flowers & Decorations- 400.00 (400.00) - 2,400.00 (2,400.00) 2,400.00 2,400.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 1,383.79 2,400.00 (1,016.21) 2,400.00 1,016.21 42.3%6509718 Safety Equipment & Training- 100.00 (100.00) 359.85 1,200.00 (840.15) 1,200.00 840.15 70.0%Total-CH-OTHER EXPENSES 6,875.04 7,425.00 (549.96) 86,141.66 88,900.00 (2,758.34) 88,900.00 2,758.34 3.1%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures390.80 300.00 90.80 5,586.13 3,600.00 1,986.13 3,600.00 (1,986.13) -55.2%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 2,199.86 4,800.00 (2,600.14) 4,800.00 2,600.14 54.2%6515690 CH-R&M-Equipment Repair449.78 400.00 49.78 3,923.79 4,800.00 (876.21) 4,800.00 876.21 18.3%Total-CH-REPAIRS & MAINTENANCE 840.58 1,100.00 (259.42) 11,709.78 13,200.00 (1,490.22) 13,200.00 1,490.22 11.3%11,199.19 11,036.00 163.19 131,975.35 132,232.00 (256.65) 132,232.00 2,980.44 2.3%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementJune 2011Annual 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 264.78 331.00 (66.22) 3,780.02 3,972.00 (191.98) 3,972.00 191.98 4.8%6601325 Insurance-Workers Comp 79.89 103.00 (23.11) 1,092.36 1,236.00 (143.64) 1,240.00 147.64 11.9%6601720 Salaries 2,496.50 2,508.00 (11.50) 30,808.18 30,096.00 712.18 30,096.00 (712.18) -2.4%6601800 Taxes-Employer Payroll 248.25 312.00 (63.75) 3,833.17 3,744.00 89.17 3,747.00 (86.17) -2.3%Total-MKT-SALARIES & BENEFITS 3,149.42 3,314.00 (164.58) 40,233.73 39,768.00 465.73 39,775.00 (458.73) -1.2%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 441.33 1,200.00 (758.67) 1,200.00 758.67 63.2%6603768 Supplies-Printing & Stationery 84.80 125.00 (40.20) 5,514.42 4,425.00 1,089.42 4,425.00 (1,089.42) -24.6%84.80 225.00 (140.20) 5,955.75 5,625.00 330.75 5,625.00 (330.75) -5.9%66-MKT-UTILITIES6607840 Utilities-Telephone 47.82 100.00 (52.18) 605.81 1,200.00 (594.19) 1,200.00 594.19 49.5%Total-MKT-UTILITIES 47.82 100.00 (52.18) 605.81 1,200.00 (594.19) 1,200.00 594.19 49.5%66-MKT-OTHER EXPENSES6609010 Advertising 15,580.61 5,977.00 9,603.61 184,443.90 192,534.00 (8,090.10) 192,534.00 8,090.10 4.2%6609040 Business Meals - 25.00 (25.00) - 300.00 (300.00) 300.00 300.00 100.0%6609080 Collateral Material 4,340.83 500.00 3,840.83 11,675.81 9,000.00 2,675.81 9,000.00 (2,675.81) -29.7%6609102 Contract Services-Web Page 99.00 400.00 (301.00) 1,675.50 4,800.00 (3,124.50) 4,800.00 3,124.50 65.1%6609490 Miscellaneous - - - - 350.00 (350.00) 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) 283.62 600.00 (316.38) 600.00 316.38 52.7%6609630 Promotion 13.95 50.00 (36.05) 51.74 700.00 (648.26) 3,500.00 3,448.26 0.0%6609633 Promotion-Community - 75.00 (75.00) 175.00 2,925.00 (2,750.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 381.71 - 381.71 765.03 735.00 30.03 735.00 (30.03) -4.1%6609820 Uniforms 315.87 - 315.87 526.59 600.00 (73.41) 600.00 73.41 12.2%Total-MKT-OTHER EXPENSES 20,731.97 7,077.00 13,654.97 201,207.54 216,044.00 (14,836.46) 216,044.00 15,746.81 7.3%24,014.01 10,716.00 13,298.01 248,002.83 262,637.00 (14,634.17) 262,644.00 15,551.52 5.9%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementJune 2011Annual Budget8 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 2,160.00 2,160.00 - 2,160.00 - 0.0%6701320 Insurance-Group2,850.25 1,458.00 1,392.25 23,684.45 17,496.00 6,188.45 17,496.00 (6,188.45) -35.4%6701325 Insurance-Workers Comp552.48 707.00 (154.52) 6,915.19 8,484.00 (1,568.81) 8,480.00 1,564.81 18.5%6701720 Salaries 14,757.89 14,833.34 (75.45) 174,411.38 178,000.08 (3,588.70) 178,000.00 3,588.62 2.0%6701800 Taxes-Employer Payroll 1,321.67 2,136.00 (814.33) 16,521.79 25,632.00 (9,110.21) 25,627.00 9,105.21 35.5%6701880 Wages-Hourly2,507.19 2,319.66 187.53 25,191.03 27,835.92 (2,644.89) 27,835.00 2,643.97 9.5%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 22,169.48 21,634.00 535.48 248,883.84 259,608.00 (10,724.16) 259,598.00 10,714.16 4.1%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer82.20 800.00 (717.80) 1,791.52 5,200.00 (3,408.48) 5,200.00 3,408.48 65.5%6703762 Supplies-Office 102.44 100.00 2.44 1,667.94 1,200.00 467.94 1,200.00 (467.94) -39.0%6703768 Supplies-Printing & Stationery330.03 400.00 (69.97) 1,842.19 3,300.00 (1,457.81) 3,300.00 1,457.81 44.2%Total-G&A-SUPPLIES & MATERIALS 514.67 1,300.00 (785.33) 5,301.65 9,700.00 (4,398.35) 9,700.00 4,398.35 45.3%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 522.50 1,100.00 (577.50) 1,100.00 577.50 52.5%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 522.50 1,100.00 (577.50) 1,100.00 577.50 52.5%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 4,800.00 4,800.00 - 4,800.00 - 0.0%6709150 Dues & Subscriptions355.00 50.00 305.00 1,116.71 1,700.00 (583.29) 1,700.00 583.29 34.3%6709180 Employee Recruiting/Relocation112.00 - 112.00 925.93 1,400.00 (474.07) 1,400.00 474.07 33.9%6709197 Equipment Rental509.13 480.00 29.13 7,077.36 5,760.00 1,317.36 5,760.00 (1,317.36) -22.9%6709202 Fees-Bank51.70 90.00 (38.30) 753.52 1,080.00 (326.48) 1,080.00 326.48 30.2%6709208 Fees-Payroll Processing1,252.77 760.00 492.77 16,948.75 9,120.00 7,828.75 9,120.00 (7,828.75) -85.8%6709220 Freight/Delivery- 50.00 (50.00) 37.15 600.00 (562.85) 600.00 562.85 93.8%6709490 Miscellaneous 10.78 100.00 (89.22) 205.20 1,200.00 (994.80) 1,200.00 994.80 82.9%6709620 Postage/Mail Services 112.89 75.00 37.89 1,384.26 900.00 484.26 900.00 (484.26) -53.8%6709625 Professional Fees1,104.25 850.00 254.25 12,478.45 10,200.00 2,278.45 10,200.00 (2,278.45) -22.3%6709636 Promotion/Entertainment- 100.00 (100.00) 2,085.00 3,100.00 (1,015.00) 3,100.00 1,015.00 32.7%6709722 Seminars & Training250.00 200.00 50.00 951.00 2,400.00 (1,449.00) 2,400.00 1,449.00 60.4%6709810 Travel - 200.00 (200.00) - 1,100.00 (1,100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms 205.39 75.00 130.39 1,367.55 1,050.00 317.55 1,050.00 (317.55) -30.2%Total-G&A-OTHER EXPENSES 4,363.91 3,430.00 933.91 50,130.88 44,410.00 5,720.88 44,410.00 (5,720.88) -12.9%27,048.06 26,464.00 584.06 304,838.87 314,818.00 (9,979.13) 314,808.00 9,969.13 3.2%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementJune 2011Annual Budget9 June Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,091.63 13,000.00 (1,908.37) 113,418.02 150,324.00 (36,905.98) 150,324.00 36,905.98 24.6%6800194 Equipment Leases-Trailer 540.00 600.00 (60.00) 6,460.00 7,200.00 (740.00) 7,200.00 740.00 10.3%6800196 Equipment Leases-GPS 5,290.50 6,400.00 (1,109.50) 76,855.92 90,216.00 (13,360.08) 90,216.00 13,360.08 14.8%6800197 Equipment Leases-Others 4,571.14 - 4,571.14 33,813.24 - 33,813.24 - - 0.0%21,493.27 20,000.00 1,493.27 230,547.18 247,740.00 (17,192.82) 247,740.00 51,006.06 20.6%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 18,686.96 17,713.00 973.96 90,000.00 90,000.00 - 90,000.00 - 0.0%6900210 FF&E Reserve 3,236.61 3,086.00 150.61 63,647.54 62,230.00 1,417.54 62,229.00 (1,418.54) -2.3%6900800 Personal Property Taxes 462.92 - 462.92 15,981.94 13,570.00 2,411.94 13,570.00 (2,411.94) -17.8%6900323 Insurance-Commercial 2,605.10 2,200.00 405.10 28,699.32 26,400.00 2,299.32 26,400.00 (2,299.32) -8.7%24,991.59 22,999.00 1,992.59 198,328.80 192,200.00 6,128.80 192,199.00 (6,129.80) -3.2%Silverrock ResortOperating Leases & Miscellaneous Other Expense StatementJune 2011Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSES10 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 CategoryJanuaryFebruaryMarchAprilMayJuneMedia43138Sales6Promotion4Golf Industry4204VIPCelebrity11222PGA Comp29 325557 43 75Charity/Gift Certificate21 182339 13 9Rain/Wind Checks392217Club Staff51 10810693 72 75LQ HS Golf61 131 74 3101 231 328 298 161 17611 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2010-2011June 2011 Date Time Description CategoryPlayers6/5/2011 12:30 Kris Long Media 16/11/2011 12:45 Kris Long Media 16/17/2011 8:15 Kris Long Media 26/18/2011 9:45 John White Media 46/20/2011 8:22 Mike Dante Celeb 212