Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
11 May 2012 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2011 – May 2012 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 Revenue278,853.09 309,290.00 (30,436.91) -9.8% 3,175,973.96 3,172,693.00 3,280.96 3,326,982.00 151,008.04 95%401000 Miscellaneous Golf Revenue 19,834.25 11,025.00 8,809.25 79.9% 188,231.66 141,396.00 46,835.66 146,537.00 (41,694.66) 128%410000 Revenue-Golf Shop 26,898.85 31,500.00 (4,601.15) -14.6% 270,717.83 296,221.00 (25,503.17) 310,919.00 40,201.17 87%420000 Revenue-F&B Concession500.00 500.00 - 0.0% 11,500.00 11,500.00 - 12,000.00 500.00 96%890000 Interest Income1.02 - 1.02 0.0% 24.99 - 24.99 - (24.99) 0%Total Income326,087.21 352,315.00 (26,227.79) -7.4% 3,646,448.44 3,621,810.00 24,638.44 3,796,438.00 149,989.56 96%Cost of Goods Sold510000 COS-Golf Shop 16,074.67 16,719.00 (644.33) 3.9% 156,559.23 157,221.55 662.32 165,020.45 8,461.22 95%Total COS16,074.67 16,719.00 (644.33) 3.9% 156,559.23 157,221.55 662.32 165,020.45 8,461.22 95%Gross Profit310,012.54 335,596.00 (25,583.46) -7.6% 3,489,889.21 3,464,588.45 25,300.76 3,631,417.55 141,528.34 96%Expenses610000 Golf Pro Shop 18,128.79 22,016.00 3,887.21 17.7% 182,528.53 205,264.00 22,735.47 223,325.00 40,796.47 82%630000 Course Maintenance122,153.63 113,182.00 (8,971.63) -7.9% 1,559,561.52 1,522,768.00 (36,793.52) 1,638,879.00 79,317.48 95%633000 Maintenance Water & Energy14,449.33 24,272.00 9,822.67 40.5% 188,486.66 242,409.00 53,922.34 270,449.00 81,962.34 70%640000 Outside Services25,274.89 18,433.00 (6,841.89) -37.1% 262,803.34 252,500.00 (10,303.34) 281,023.00 18,219.66 94%650000 Clubhouse 9,274.54 10,636.00 1,361.46 12.8% 115,141.67 121,196.00 6,054.33 132,232.00 17,090.33 87%660000 Marketing 21,895.37 13,216.00 (8,679.37) -65.7% 214,995.92 244,598.00 29,602.08 254,820.00 39,824.08 84%670000 General & Administrative23,285.65 26,802.00 3,516.35 13.1% 273,157.87 288,222.00 15,064.13 314,669.00 41,511.13 87%680000 Leases 18,633.59 19,590.00 956.41 4.9% 214,029.81 215,490.00 1,460.19 235,080.00 21,050.19 91%690000 Miscellaneous Other Expense8,800.73 12,965.00 4,164.27 32.1% 165,602.66 173,636.00 8,033.34 197,740.00 32,137.34 84%Total Expenses261,896.52 261,112.00 (784.52) -0.3% 3,176,307.98 3,266,083.00 89,775.02 3,548,217.00 371,909.02 90%48,116.02 74,484.00 (26,367.98) -35.4%313,581.23 198,505.45 115,075.78 83,200.55 (230,380.68) 377%Rounds of Golf PlayedPaid Rounds Played 4,788 5,250 (462) -8.8% 44,507 43,175 1,332 45,625 1,118 98%Ave $ Per Paid Round Green Fee58.24 58.91 (0.67) -1.1% 71.36 73.48 (2.13) 72.92 1.56 98%Ave $ Per Paid Round Merchandise5.62 6.00 (0.38) -6.4% 6.08 6.86 (0.78) 6.81 0.73 89%Ave $ Per Paid Miscellaneous 4.14 2.10 2.04 97.3% 4.23 3.27 0.95 3.21 (1.02) 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateMay 20121 Income May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 278,853.09 309,290.00 (30,436.91) 3,175,973.96 3,172,693.00 3,280.96 3,326,982.00151,008.0495%4010000 Rider Fee 1,125.00 525.00 600.00 12,300.00 7,203.00 5,097.00 7,446.00-4,854.00165%4040000 Club Rental 3,365.00 2,625.00 740.00 25,579.00 21,589.00 3,990.00 22,813.00-2,766.00112%4050000 Driving Range 6,098.00 7,875.00 (1,777.00) 84,564.00 69,604.00 14,960.00 73,278.00-11,286.00115%4060000 Handicap Fees 2,035.00 - 2,035.00 3,635.00 - 3,635.00 0.000.000%4080000 GPS Advertising - - - 2,554.48 12,000.00 (9,445.52) 12,000.00 9,445.5221%4090000 Ball Retriever/Subcontract - - - 3,269.30 4,000.00 (730.70) 4,000.00 730.7082%4091000 Golf Professional Rental Fee 6,500.00 - 6,500.00 54,059.25 27,000.00 27,059.25 27,000.00 -27,059.25 200%4092000 Golf Lessons 711.25 - 711.25 2,270.63 - 2,270.63 - (2,270.63) 0% Total Revenue Fees 298,687.34 320,315.00 (21,627.66) 3,364,205.62 3,314,089.00 50,116.62 3,473,519.00 112,948.38 97%298,687.34 320,315.00 (21,627.66) 3,364,205.62 3,314,089.00 50,116.62 3,473,519.00 112,948.38 97%SilverRock ResortStatement of Fees RevenueMay 2012Total IncomeMonth to Date Year to Date Annual Budget2 Income May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 216.00 - 216.00 3,648.42 - 3,648.42 0 0 0%4100110 Sales Hard Goods 10,860.63 11,025.00 (164.37) 104,721.24 103,678.00 1,043.24 108,822.00 4,100.76 96%4100112 Sales-Soft Goods 18,984.14 20,475.00 (1,490.86) 205,839.40 192,543.00 13,296.40 202,097.00 (3,742.40) 102%5100639 GS-Discounts-Mdse (3,161.92) - (3,161.92) (43,491.23) - (43,491.23) - 43,491.23 0% Total Revenue Golf Shop 26,898.85 31,500.00 (4,601.15) 270,717.83 296,221.00 (25,503.17) 310,919.00 43,849.59 86%COS 5100150 COS-GS-Hard Goods 6,906.58 6,063.75 842.83 58,725.67 57,022.90 1,702.77 59,852.10 1,126.43 98%5100151 COS-GS-Soft Goods 8,971.01 11,261.25 (2,290.24) 94,846.78 105,898.65 (11,051.87) 111,153.35 16,306.57 85%5100152 COS-GS-Purchase Disc (96.20) (866.00) 769.80 (1,237.50) (8,148.00) 6,910.50 (8,550.00) (7,312.50) -14%5100220 COS-GS-Freight Merch 293.28 260.00 33.28 4,224.28 2,448.00 1,776.28 2,565.00 (1,659.28) 165%Cost of Sales - Golf Shop 16,074.67 16,719.00 (644.33) 156,559.23 157,221.55 (662.32) 165,020.45 8,461.22 95%Gross Profit 10,824.18 14,781.00 (3,956.82) 114,158.60 138,999.45 (24,840.85) 145,898.55 35,388.37 76%COS % 59.8% 53.1% -6.7% 57.8% 53.1% -4.8% 53.1% 19.3% 64%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 2,402.29 2,317.00 85.29 27,271.65 24,494.00 2,777.65 26,811.00 (460.65) 102%6101325 Insurance-Workers Comp 501.70 527.00 (25.30) 4,832.35 5,621.00 (788.65) 6,131.00 1,298.65 79%6101720 Salaries 3,545.44 3,750.00 (204.56) 41,718.06 41,250.00 468.06 45,000.00 3,281.94 93%6101800 Taxes-Employer Payroll 1,157.23 1,464.00 (306.77) 13,239.62 15,619.00 (2,379.38) 17,040.00 3,800.38 78%6101880 Wages-Hourly 7,769.64 9,033.00 (1,263.36) 78,266.01 95,165.00 (16,898.99) 103,818.00 25,551.99 75%6101882 Wages-Overtime 144.10 - 144.10 1,498.89 - 1,498.89 - 952.88 0%Total -PS-SALARIES & BENEFITS 15,520.40 17,091.00 (1,570.60) 166,826.58 182,149.00 (15,322.42) 198,800.00 34,425.19 83%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 104.20 500.00 (395.80) 3,541.33 5,500.00 (1,958.67) 6,000.00 2,458.67 59%6109090 Contract Services 500.00 500.00 - 5,500.00 5,500.00 - 6,000.00 500.00 92%6109220 Freight & Delivery - - - 620.42 75.00 545.42 75.00 (545.42) 827%6109490 Miscellaneous - 50.00 (50.00) 531.18 400.00 131.18 450.00 (81.18) 118%6109150 Dues and Subscriptions 1,326.00 2,300.00 (974.00) 1,326.00 2,300.00 (974.00) 2,300.00 974.00 58%6109500 ProShop-Over/Short (7.75) - (7.75) 177.60 - 177.60 - (177.60) 0%6109722 Seminars/Training - 1,250.00 (1,250.00) 302.96 5,855.00 (5,552.04) 5,890.00 5,587.04 5%6109810 Travel - Merchandise - 15.00 (15.00) - 75.00 (75.00) 90.00 90.00 0%6109820 Uniforms 577.26 200.00 377.26 2,343.54 2,200.00 143.54 2,400.00 56.46 98%6117840 Telephones 108.68 110.00 (1.32) 1,358.92 1,210.00 148.92 1,320.00 (38.92) 0%Total PS-OTHER EXPENSES 2,608.39 4,925.00 (2,316.61) 15,701.95 23,115.00 (7,413.05) 24,525.00 8,823.05 64%18,128.79 22,016.00 (3,887.21) 182,528.53 205,264.00 (22,735.47) 223,325.00 43,248.24 81%Net Income(7,304.61) (7,235.00) (69.61) (68,369.93) (66,264.55) (2,105.38) (77,426.45) (7,859.87) -90%SilverRock ResortGolf Shop Income StatementMay 2012Total Expenses-Golf ShopMonth to Date Year to Date Annual Budget3 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 9,955.16 8,740.00 1,215.16 98,427.84 96,140.00 2,287.84 104,880.00 6,452.16 6.2%6311325 Insurance-Workers Comp 1,937.02 2,269.00 (331.98) 20,807.02 25,679.00 (4,871.98) 28,026.00 7,218.98 25.8%6311720 Salaries 11,001.60 12,583.00 (1,581.40) 129,452.16 138,413.00 (8,960.84) 150,996.00 21,543.84 14.3%6311800 Taxes-Employer Payroll 4,835.82 6,304.00 (1,468.18) 62,342.81 71,866.00 (9,523.19) 78,501.00 16,158.19 20.6%6311880 Wages-Hourly 46,095.25 42,478.00 3,617.25 490,448.93 476,176.00 14,272.93 518,654.00 28,205.07 5.4%6311882 Wages-Overtime 46.50 - 46.50 11,263.80 13,076.00 (1,812.20) 15,945.00 4,681.20 29.4%Total-CM-SALARIES & BENEFITS73,871.35 72,374.00 1,497.35 812,742.56 821,350.00 (8,607.44) 897,002.00 84,259.44 9.4%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 1,958.16 900.00 1,058.16 33,689.36 27,300.00 6,389.36 29,300.00 (4,389.36) -15.0%6313744 Fertilizer 1,689.38 5,000.00 (3,310.62) 113,054.21 99,400.00 13,654.21 104,400.00 (8,654.21) -8.3%6313745 Herbicides - - - 17,751.38 17,000.00 751.38 17,000.00 (751.38) -4.4%6313746 Flowers/Plants - - - 3,129.73 3,050.00 79.73 3,050.00 (79.73) -2.6%6313748 Fuel-Gasoline 4,492.24 3,100.00 1,392.24 51,816.91 45,700.00 6,116.91 48,800.00 (3,016.91) -6.2%6313750 Golf Course Accessories 123.91 100.00 23.91 14,886.62 12,200.00 2,686.62 12,300.00 (2,586.62) -21.0%6313756 POA Control 242.66 - 242.66 8,685.92 7,000.00 1,685.92 7,000.00 (1,685.92) -24.1%6313758 Miscellaneous Supp 1,093.46 100.00 993.46 10,380.49 4,250.00 6,130.49 4,350.00 (6,030.49) 0.0%6313762 Supplies-Office - - - 435.40 - 435.40 - (435.40) 0.0%6313774 Sand 5,055.95 100.00 4,955.95 16,864.95 16,360.00 504.95 16,460.00 (404.95) -2.5%6313776 Seed - 350.00 (350.00) 106,201.53 106,460.00 (258.47) 106,810.00 608.47 0.6%6313778 Small Tools & Non-Capital Equip - 100.00 (100.00) 4,512.09 4,900.00 (387.91) 5,000.00 487.91 9.8%6313780 Sod 2,347.80 500.00 1,847.80 9,393.61 6,150.00 3,243.61 6,350.00 (3,043.61) -47.9%6313782 Topdressing - 1,300.00 (1,300.00) 3,842.05 6,300.00 (2,457.95) 7,600.00 3,757.95 49.4%Total-CM-SUPPLIES & MATERIALS17,003.56 11,550.00 5,453.56 394,644.25 356,070.00 38,574.25 368,420.00 (26,224.25) -7.1%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,830.00 2,600.00 230.00 31,040.00 28,600.00 2,440.00 31,200.00 160.00 0.5%6315685 CM-R&M-Bldngs & Othr Structures 350.60 250.00 100.60 7,093.12 1,500.00 5,593.12 1,750.00 (5,343.12) -305.3%6315690 CM-R&M-Equipment 2,708.78 1,500.00 1,208.78 30,273.47 19,000.00 11,273.47 20,500.00 (9,773.47) -47.7%6315692 CM-R&M-Irrigation System 951.80 1,000.00 (48.20) 17,683.82 21,650.00 (3,966.18) 22,650.00 4,966.18 21.9%6315696 CM-R&M-Pumps - 500.00 (500.00) 10,742.01 10,500.00 242.01 10,500.00 (242.01) -2.3%6315815 CM-R&M-Trees-Pruning Etc - - - 8,295.00 10,050.00 (1,755.00) 10,050.00 1,755.00 17.5%Total-CM-REPAIRS & MAINTENANCE 6,841.18 5,850.00 991.18 105,127.42 91,300.00 13,827.42 96,650.00 (8,477.42) -8.8%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 20.79 15.00 5.79 198.32 165.00 33.32 180.00 (18.32) 0.0%6317840 Telephones 1,078.80 850.00 228.80 12,961.01 9,350.00 3,611.01 10,200.00 (2,761.01) -27.1%Total-CM-UTILITIES 1,099.59 865.00 234.59 13,159.33 9,515.00 3,644.33 10,380.00 (2,779.33) -26.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 2,000.00 2,000.00 - 4,000.00 4,000.00 - 4,000.00 - 0.0%6319102 Contract Svcs-Trash Removal 659.04 524.00 135.04 8,715.64 5,764.00 2,951.64 6,288.00 (2,427.64) 0.0%6319150 Dues & Subscriptions - - - 1,265.00 440.00 825.00 540.00 (725.00) -134.3%6319170 Employee Education - 50.00 (50.00) 59.00 1,500.00 (1,441.00) 1,550.00 1,491.00 96.2%6319197 Equipment Rental - 200.00 (200.00) 2,695.38 4,100.00 (1,404.62) 4,200.00 1,504.62 35.8%6319206 Licenses & Permits 550.00 - 550.00 2,275.00 1,430.00 845.00 1,430.00 (845.00) -59.1%6319490 Miscellaneous 121.68 100.00 21.68 2,075.86 1,100.00 975.86 1,200.00 (875.86) -73.0%6319718 Safety Equipment & Training 99.40 100.00 (0.60) 3,119.28 3,750.00 (630.72) 3,850.00 730.72 19.0%6319822 Uniforms 992.88 920.00 72.88 11,311.83 10,120.00 1,191.83 11,040.00 (271.83) -2.5%Total-CM-OTHER EXPENSES 4,923.00 4,394.00 529.00 41,016.99 37,704.00 3,312.99 40,098.00 (918.99) -2.3%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementMay 2012Annual Budget4 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,958.24 2,648.00 310.24 26,555.09 29,128.00 (2,572.91) 31,776.00 5,220.91 16.4%6321325 Insurance-Workers Comp 640.93 531.00 109.93 5,379.39 5,986.00 (606.61) 6,543.00 1,163.61 17.8%6321800 Taxes-Employer Payroll 770.86 1,475.00 (704.14) 14,418.52 16,832.00 (2,413.48) 18,416.00 3,997.48 21.7%6321880 Wages-Hourly 13,620.44 12,880.00 740.44 139,588.37 141,680.00 (2,091.63) 154,560.00 14,971.63 9.7%6321882 Wages-Overtime 118.87 - 118.87 2,490.01 5,313.00 (2,822.99) 6,279.00 3,788.99 60.3%Total-CM-LM-SALARIES & BENEFITS18,109.34 17,534.00 575.34 188,431.38 198,939.00 (10,507.62) 217,574.00 29,142.62 13.4%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 224.72 950.00 (725.28) 1,025.00 800.28 78.1%6323788 Uniforms 305.61 290.00 15.61 2,616.37 3,190.00 (573.63) 3,480.00 863.63 24.8%Total-CM-LM-SUPPLIES & MATERIALS305.61 365.00 (59.39) 2,841.09 4,140.00 (1,298.91) 4,505.00 1,663.91 36.9%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 250.00 (250.00) 1,598.50 3,750.00 (2,151.50) 4,250.00 2,651.50 62.4%Total-CM-LM-REPAIRS & MAINTENANCE - 250.00 (250.00) 1,598.50 3,750.00 (2,151.50) 4,250.00 2,651.50 62.4%122,153.63 113,182.00 8,971.63 1,559,561.52 1,522,768.00 36,793.52 1,638,879.00 79,317.48 4.8% May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 9,642.78 21,017.00 (11,374.22) 142,163.63 205,861.00 (63,697.37) 227,391.00 85,227.37 37.5%6337842 Utilities-Water4,806.55 3,255.00 1,551.55 46,323.03 36,548.00 9,775.03 43,058.00 (3,265.03) -7.6%14,449.33 24,272.00 (9,822.67) 188,486.66 242,409.00 (53,922.34) 270,449.00 81,962.34 30.3%Silverrock ResortCourse Maintenance Expense StatementMay 2012Annual BudgetMonth to Date Year to DateSilverrock ResortCourse Maintenance Water & EnergyMay 2012Total-COURSE MAINTENANCETotal-CM-WATER & ENERGYMonth to Date Year to Date Annual Budget5 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group 420.59 662.00 (241.41) 4,734.30 7,282.00 (2,547.70) 7,944.00 3,209.70 40.4%6411325 Insurance-Workers Comp 401.15 387.00 14.15 4,119.35 4,729.00 (609.65) 5,096.00 976.65 19.2%6411800 Taxes-Employer Payroll 1,592.57 1,169.00 423.57 16,109.72 14,290.00 1,819.72 15,399.00 (710.72) -4.6%6411880 Wages-Hourly 11,246.76 9,390.00 1,856.76 119,460.92 114,779.00 4,681.92 123,689.00 4,228.08 3.4%6411882 Wages-Overtime 276.56 - 276.56 1,692.20 - 1,692.20 - (1,692.20) 0.0%Total-CBR-SALARIES & BENEFITS13,937.63 11,608.00 2,329.63 146,116.49 141,080.00 5,036.49 152,128.00 6,011.51 4.0%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 50.00 (50.00) 1,209.92 2,300.00 (1,090.08) 2,350.00 1,140.08 48.5%6413742 Supplies-Expendable 785.11 500.00 285.11 9,383.59 6,250.00 3,133.59 6,750.00 (2,633.59) -39.0%6413752 Supplies-Range Balls - - - 7,745.85 9,000.00 (1,254.15) 9,000.00 1,254.15 13.9%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) 70.40 350.00 (279.60) 420.00 349.60 83.2%6413786 Supplies-Towels 560.00 72.00 488.00 3,520.00 933.00 2,587.00 1,005.00 (2,515.00) -250.2%6413796 Supplies-Bottled Water199.23 50.00 149.23 12,143.03 12,500.00 (356.97) 24,500.00 12,356.97 50.4%Total-CBR-SUPPLIES & MATERIALS1,544.34 792.00 752.34 34,072.79 31,808.00 2,264.79 44,550.00 10,477.21 23.5%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment 427.30 300.00 127.30 3,903.64 3,300.00 603.64 3,600.00 (303.64) -8.4%6415695 CBR-R&M-Cart Maintenance & Repair - 750.00 (750.00) 5,155.48 9,000.00 (3,844.52) 9,750.00 4,594.52 47.1%Total-CBR-REPAIRS & MAINTENANCE 427.30 1,050.00 (622.70) 9,059.12 12,300.00 (3,240.88) 13,350.00 4,290.88 32.1%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 1,522.50 800.00 722.50 8,517.77 8,800.00 (282.23) 9,600.00 1,082.23 11.3%6419220 Freight/Delivery - - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous - 125.00 (125.00) 637.11 1,025.00 (387.89) 1,150.00 512.89 44.6%6419820 Uniforms 1,012.13 1,500.00 (487.87) 3,609.50 5,000.00 (1,390.50) 5,200.00 1,590.50 30.6%Total-CBR-OTHER EXPENSES 2,534.63 2,425.00 109.63 12,764.38 15,275.00 (2,510.62) 16,400.00 3,635.62 22.2%TOTAL-CARTS,BAGROOM & RANGE 18,443.90 15,875.00 2,568.90 202,012.78 200,463.00 1,549.78 226,428.00 24,415.22 10.8%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 358.70 84.00 274.70 3,168.14 1,721.00 1,447.14 1,805.00 (1,363.14) -75.5%6431800 Taxes-Employer Payroll 737.91 234.00 503.91 6,422.41 4,781.00 1,641.41 5,015.00 (1,407.41) -28.1%6431880 Wages-Hourly 4,930.00 2,040.00 2,890.00 46,206.00 41,760.00 4,446.00 43,800.00 (2,406.00) -5.5%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS6,026.61 2,358.00 3,668.61 55,796.55 48,262.00 7,534.55 50,620.00 (5,176.55) -10.2%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 75.00 (75.00) 1,078.29 975.00 103.29 1,050.00 (28.29) -2.7%6439490 Miscellaneous 417.78 - 417.78 2,153.72 200.00 1,953.72 200.00 (1,953.72) -976.9%6439718 Safety Equipment & Training - 50.00 (50.00) 91.59 550.00 (458.41) 600.00 508.41 84.7%6439820 Uniforms 386.60 75.00 311.60 1,670.41 2,050.00 (379.59) 2,125.00 454.59 21.4%Total-CS-OTHER EXPENSES 804.38 200.00 604.38 4,994.01 3,775.00 1,219.01 3,975.00 (1,019.01) -25.6%Total-COURSE SERVICES 6,830.99 2,558.00 4,272.99 60,790.56 52,037.00 8,753.56 54,595.00 (6,195.56) -11.3%25,274.89 18,433.00 6,841.89 262,803.34 252,500.00 10,303.34 281,023.00 19,238.67 6.8%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementMay 2012Annual Budget6 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 1,867.79 4,400.00 (2,532.21) 4,800.00 2,932.21 61.1%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 1,867.79 4,400.00 (2,532.21) 4,800.00 2,932.21 61.1%65-CH-UTILITIES6507836 Utilities-Natural Gas- 300.00 (300.00) 4,030.13 3,300.00 730.13 3,600.00 (430.13) -11.9%6507840 Utilities-Telephone1,146.76 1,150.00 (3.24) 12,379.10 12,650.00 (270.90) 13,800.00 1,420.90 10.3%6507842 Utilities-Water528.06 321.00 207.06 4,305.18 3,531.00 774.18 3,852.00 (453.18) -11.8%6507844 Utilities-Cable336.91 340.00 (3.09) 3,705.89 3,740.00 (34.11) 4,080.00 374.11 9.2%Total-CH-UTILITIES 2,011.73 2,111.00 (99.27) 24,420.30 23,221.00 1,199.30 25,332.00 911.70 3.6%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning150.00 1,825.00 (1,675.00) 16,575.00 20,675.00 (4,100.00) 22,500.00 5,925.00 26.3%6509099 Contract Services-Security6,315.04 4,900.00 1,415.04 60,676.16 55,500.00 5,176.16 60,400.00 (276.16) -0.5%6509215 Flowers & Decorations- - - - 2,000.00 (2,000.00) 2,400.00 2,400.00 100.0%6509490 Miscellaneous130.00 200.00 (70.00) 746.89 2,200.00 (1,453.11) 2,400.00 1,653.11 68.9%6509718 Safety Equipment & Training- 100.00 (100.00) 127.19 1,100.00 (972.81) 1,200.00 1,072.81 89.4%Total-CH-OTHER EXPENSES 6,595.04 7,025.00 (429.96) 78,125.24 81,475.00 (3,349.76) 88,900.00 10,774.76 12.1%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures642.21 300.00 342.21 6,494.40 3,300.00 3,194.40 3,600.00 (2,894.40) -80.4%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 1,346.01 4,400.00 (3,053.99) 4,800.00 3,453.99 72.0%6515690 CH-R&M-Equipment Repair25.56 400.00 (374.44) 2,887.93 4,400.00 (1,512.07) 4,800.00 1,912.07 39.8%Total-CH-REPAIRS & MAINTENANCE 667.77 1,100.00 (432.23) 10,728.34 12,100.00 (1,371.66) 13,200.00 2,471.66 18.7%9,274.54 10,636.00 (1,361.46) 115,141.67 121,196.00 (6,054.33) 132,232.00 4,943.32 3.7%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementMay 2012Annual Budget7 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 369.78 331.00 38.78 3,537.60 3,641.00 (103.40) 3,972.00 434.40 10.9%6601325 Insurance-Workers Comp 180.55 103.00 77.55 1,772.03 1,133.00 639.03 1,240.00 (532.03) -42.9%6601720 Salaries 2,252.51 2,508.00 (255.49) 24,703.54 27,588.00 (2,884.46) 30,096.00 5,392.46 17.9%6601800 Taxes-Employer Payroll 225.14 287.00 (61.86) 2,936.51 3,157.00 (220.49) 3,446.00 509.49 14.8%Total-MKT-SALARIES & BENEFITS 3,027.98 3,229.00 (201.02) 32,949.68 35,519.00 (2,569.32) 38,754.00 5,804.32 15.0%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 506.03 1,100.00 (593.97) 1,200.00 693.97 57.8%6603768 Supplies-Printing & Stationery 1,685.58 125.00 1,560.58 8,213.38 4,300.00 3,913.38 4,425.00 (3,788.38) -85.6%1,685.58 225.00 1,460.58 8,719.41 5,400.00 3,319.41 5,625.00 (3,094.41) -55.0%66-MKT-UTILITIES6607840 Utilities-Telephone 105.46 100.00 5.46 971.56 1,100.00 (128.44) 1,200.00 228.44 19.0%Total-MKT-UTILITIES 105.46 100.00 5.46 971.56 1,100.00 (128.44) 1,200.00 228.44 19.0%66-MKT-OTHER EXPENSES6609010 Advertising 15,114.37 8,012.00 7,102.37 159,556.07 180,169.00 (20,612.93) 185,731.00 26,174.93 14.1%6609040 Business Meals - 25.00 (25.00) - 275.00 (275.00) 300.00 300.00 100.0%6609080 Collateral Material 654.72 1,000.00 (345.28) 7,697.99 8,500.00 (802.01) 9,000.00 1,302.01 14.5%6609102 Contract Services-Web Page 99.00 400.00 (301.00) 1,089.00 4,400.00 (3,311.00) 4,800.00 3,711.00 77.3%6609490 Miscellaneous - 50.00 (50.00) 143.29 350.00 (206.71) 350.00 206.71 59.1%6609620 Postage - 50.00 (50.00) 430.86 550.00 (119.14) 600.00 169.14 28.2%6609630 Promotion 359.68 50.00 309.68 392.01 650.00 (257.99) 3,500.00 3,107.99 0.0%6609633 Promotion-Community 345.23 75.00 270.23 787.28 2,850.00 (2,062.72) 2,925.00 2,137.72 73.1%6609634 Promotion-Media/Vendor 503.35 - 503.35 968.35 3,500.00 (2,531.65) 700.00 - 0.0%6609150 Dues and Subscriptions - - - 368.08 735.00 (366.92) 735.00 366.92 49.9%6609820 Uniforms - - - 922.34 600.00 322.34 600.00 (322.34) -53.7%Total-MKT-OTHER EXPENSES 17,076.35 9,662.00 7,414.35 172,355.27 202,579.00 (30,223.73) 209,241.00 37,154.08 17.8%21,895.37 13,216.00 8,679.37 214,995.92 244,598.00 (29,602.08) 254,820.00 40,092.43 15.7%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementMay 2012Annual Budget8 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,802.11 1,458.00 344.11 24,055.09 16,038.00 8,017.09 17,496.00 (6,559.09) -37.5%6701325 Insurance-Workers Comp602.40 707.00 (104.60) 6,157.52 7,777.00 (1,619.48) 8,480.00 2,322.48 27.4%6701720 Salaries 13,416.26 14,833.34 (1,417.08) 157,864.83 163,166.74 (5,301.91) 178,000.00 20,135.17 11.3%6701800 Taxes-Employer Payroll 1,188.30 1,964.00 (775.70) 14,993.21 21,604.00 (6,610.79) 23,568.00 8,574.79 36.4%6701880 Wages-Hourly2,117.00 2,319.66 (202.66) 22,105.23 25,516.26 (3,411.03) 27,835.00 5,729.77 20.6%6701882 Wages-Overtime - - - 10.88 - 10.88 - (10.88) 0.0%Total-G&A-SALARIES & BENEFITS 19,126.07 21,282.00 (2,155.93) 225,186.76 234,102.00 (8,915.24) 255,379.00 30,192.24 11.8%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 400.00 (400.00) 2,921.99 4,400.00 (1,478.01) 5,200.00 2,278.01 43.8%6703762 Supplies-Office 155.91 100.00 55.91 1,055.62 1,100.00 (44.38) 1,200.00 144.38 12.0%6703768 Supplies-Printing & Stationery- 400.00 (400.00) 765.62 2,900.00 (2,134.38) 3,300.00 2,534.38 76.8%Total-G&A-SUPPLIES & MATERIALS 155.91 900.00 (744.09) 4,743.23 8,400.00 (3,656.77) 9,700.00 4,956.77 51.1%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 228.47 1,000.00 (771.53) 1,100.00 871.53 79.2%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 228.47 1,000.00 (771.53) 1,100.00 871.53 79.2%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) 491.17 1,650.00 (1,158.83) 1,700.00 1,208.83 71.1%6709180 Employee Recruiting/Relocation60.00 - 60.00 913.35 1,400.00 (486.65) 1,400.00 486.65 34.8%6709197 Equipment Rental669.06 480.00 189.06 6,699.81 5,280.00 1,419.81 5,760.00 (939.81) -16.3%6709202 Fees-Bank60.82 90.00 (29.18) 864.89 990.00 (125.11) 1,080.00 215.11 19.9%6709208 Fees-Payroll Processing1,147.23 1,100.00 47.23 12,309.39 12,100.00 209.39 13,200.00 890.61 6.7%6709220 Freight/Delivery- 50.00 (50.00) - 550.00 (550.00) 600.00 600.00 100.0%6709490 Miscellaneous - 100.00 (100.00) 576.48 1,100.00 (523.52) 1,200.00 623.52 52.0%6709620 Postage/Mail Services 208.99 75.00 133.99 1,009.21 825.00 184.21 900.00 (109.21) -12.1%6709625 Professional Fees1,231.25 850.00 381.25 10,036.48 9,350.00 686.48 10,200.00 163.52 1.6%6709636 Promotion/Entertainment- 100.00 (100.00) 3,000.00 3,000.00 - 3,100.00 100.00 3.2%6709722 Seminars & Training- 200.00 (200.00) 1,348.61 2,200.00 (851.39) 2,400.00 1,051.39 43.8%6709810 Travel - 500.00 (500.00) 224.38 900.00 (675.62) 1,100.00 875.62 79.6%6709820 Uniforms 226.32 75.00 151.32 1,125.64 975.00 150.64 1,050.00 (75.64) -7.2%Total-G&A-OTHER EXPENSES 4,003.67 4,520.00 (516.33) 42,999.41 44,720.00 (1,720.59) 48,490.00 5,490.59 11.3%23,285.65 26,802.00 (3,516.35) 273,157.87 288,222.00 (15,064.13) 314,669.00 41,511.13 13.2%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementMay 2012Annual Budget9 May Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,988.05 12,075.00 (86.95) 127,387.45 132,825.00 (5,437.55) 144,900.00 17,512.55 12.1%6800194 Equipment Leases-Trailer 502.54 600.00 (97.46) 5,556.40 6,600.00 (1,043.60) 7,200.00 1,643.60 22.8%6800196 Equipment Leases-GPS 4,940.00 5,755.00 (815.00) 61,092.02 63,305.00 (2,212.98) 69,060.00 7,967.98 11.5%6800197 Equipment Leases-Others 1,203.00 1,160.00 43.00 19,993.94 12,760.00 7,233.94 13,920.00 (6,073.94) 0.0%18,633.59 19,590.00 (956.41) 214,029.81 215,490.00 (1,460.19) 235,080.00 21,050.19 9.0%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 365.74 4,579.00 (4,213.26) 60,783.12 71,181.00 (10,397.88) 90,000.00 29,216.88 32.5%6900210 FF&E Reserve 5,577.07 6,186.00 (608.93) 63,519.46 63,455.00 64.46 66,540.00 3,020.54 4.5%6900800 Personal Property Taxes 382.85 - 382.85 14,651.02 14,800.00 (148.98) 14,800.00 148.98 1.0%6900323 Insurance-Commercial 2,475.07 2,200.00 275.07 26,649.06 24,200.00 2,449.06 26,400.00 (249.06) -0.9%8,800.73 12,965.00 (4,164.27) 165,602.66 173,636.00 (8,033.34) 197,740.00 32,137.34 16.3%Silverrock ResortOperating Leases & Miscellaneous Other Expense StatementMay 2012Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSES10 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2011-20122011 2011 2011 2011 2011 2011Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia51 145Sales4Promotion36Golf Industry6VIPCelebrityPGA Comp64 60 50 5 38 29Charity/Gift Certificate214 430Rain/Wind Checks321 13Club Staff65 62 91 8 66 71LQ HS Golf2 4 12 11 34141 136 162 14 136 2052012 2012 2012 2012 2012 2012Comp CategoryJanuaryFebruaryMarchAprilMayJuneMedia56623SalesPromotion11341Golf Industry4VIPCelebrity2PGA Comp37 1055337 74Charity/Gift Certificate823420 10Rain/Wind Checks413713Club Staff150 926659 81LQ HS Golf48 177 199 197 29255 420 345 322 211 011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2011-2012May 2012 Date Time Description CategoryPlayers5/9/2012 8:52 Kris Long Media 35/19/2012 8:30 Gary Riddle / Golf Digest Rater Promo 112