Loading...
09 March 2012 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2011 – March 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 March Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue544,239.50 583,188.00 (38,948.50) -6.7% 2,464,214.61 2,400,003.00 64,211.61 3,326,982.00 862,767.39 74%401000 Miscellaneous Golf Revenue 31,817.75 21,190.00 10,627.75 50.2% 143,015.51 112,611.00 30,404.51 146,537.00 3,521.49 98%410000 Revenue-Golf Shop 39,841.49 57,351.00 (17,509.51) -30.5% 211,781.17 222,721.00 (10,939.83) 310,919.00 99,137.83 68%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0% 10,500.00 10,500.00 - 12,000.00 1,500.00 88%890000 Interest Income0.72 - 0.72 0.0% 22.99 - 22.99 - (22.99) 0%Total Income617,399.46 663,229.00 (45,829.54) -6.9% 2,829,534.28 2,745,835.00 83,699.28 3,796,438.00 966,903.72 75%Cost of Goods Sold510000 COS-Golf Shop 22,778.87 30,442.05 (7,663.18) 25.2% 121,901.54 118,210.55 (3,690.99) 165,020.45 43,118.91 74%Total COS22,778.87 30,442.05 (7,663.18) 25.2% 121,901.54 118,210.55 (3,690.99) 165,020.45 43,118.91 74%Gross Profit594,620.59 632,786.95 (38,166.36) -6.0% 2,707,632.74 2,627,624.45 80,008.29 3,631,417.55 923,784.81 75%Expenses610000 Golf Pro Shop 19,040.09 19,910.00 869.91 4.4% 145,704.34 164,390.00 18,685.66 223,325.00 77,620.66 65%630000 Course Maintenance126,167.86 113,332.00 (12,835.86) -11.3% 1,304,446.32 1,293,404.00 (11,042.32) 1,638,879.00 334,432.68 80%633000 Maintenance Water & Energy18,477.00 19,555.00 1,078.00 5.5% 156,927.36 197,170.00 40,242.64 270,449.00 113,521.64 58%640000 Outside Services28,798.95 26,905.00 (1,893.95) -7.0% 212,770.39 208,492.00 (4,278.39) 281,023.00 68,252.61 76%650000 Clubhouse 11,674.20 11,136.00 (538.20) -4.8% 95,646.60 99,924.00 4,277.40 132,232.00 36,585.40 72%660000 Marketing 16,678.59 24,734.00 8,055.41 32.6% 166,763.74 208,398.00 41,634.26 254,820.00 88,056.26 65%670000 General & Administrative23,871.42 26,052.00 2,180.58 8.4% 225,503.93 235,368.00 9,864.07 314,669.00 89,165.07 72%680000 Leases 23,179.79 19,590.00 (3,589.79) -18.3% 176,762.43 176,310.00 (452.43) 235,080.00 58,317.57 75%690000 Miscellaneous Other Expense2,395.97 1,954.00 (441.97) -22.6% 145,349.81 154,263.00 8,913.19 197,740.00 52,390.19 74%Total Expenses270,283.87 263,168.00 (7,115.87) -2.7% 2,629,874.92 2,737,719.00 107,844.08 3,548,217.00 918,342.08 74%324,336.72 369,618.95 (45,282.23) -12.3%77,757.82 (110,094.55) 187,852.37 83,200.55 5,442.73 93%Rounds of Golf PlayedPaid Rounds Played 6,350 6,200 150 2.4% 34,150 32,325 1,825 45,625 11,475 75%Ave $ Per Paid Round Green Fee85.71 94.06 (8.36) -8.9% 72.16 74.25 (2.09) 72.92 0.76 99%Ave $ Per Paid Round Merchandise6.27 9.25 (2.98) -32.2% 6.20 6.89 (0.69) 6.81 0.61 91%Ave $ Per Paid Miscellaneous 5.01 3.42 1.59 46.6% 4.19 3.48 0.70 3.21 (0.98) 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateMarch 20121 Income March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 544,239.50 583,188.00 (38,948.50) 2,464,214.61 2,400,003.00 64,211.61 3,326,982.00862,767.3974%4010000 Rider Fee 1,750.00 1,550.00 200.00 9,875.00 6,118.00 3,757.00 7,446.00-2,429.00133%4040000 Club Rental 4,745.00 3,100.00 1,645.00 18,869.00 16,164.00 2,705.00 22,813.003,944.0083%4050000 Driving Range 16,629.00 10,540.00 6,089.00 67,708.00 53,329.00 14,379.00 73,278.005,570.0092%4060000 Handicap Fees - - - 1,600.00 - 1,600.00 0.000.000%4080000 GPS Advertising - 1,000.00 (1,000.00) 2,554.48 12,000.00 (9,445.52) 12,000.00 9,445.5221%4090000 Ball Retriever/Subcontract - - - 1,840.40 3,000.00 (1,159.60) 4,000.00 2,159.6046%4091000 Golf Professional Rental Fee 8,512.50 5,000.00 3,512.50 39,009.25 22,000.00 17,009.25 27,000.00 -12,009.25 144%4092000 Golf Lessons 181.25 - 181.25 1,559.38 - 1,559.38 - (1,559.38) 0% Total Revenue Fees 576,057.25 604,378.00 (28,320.75) 2,607,230.12 2,512,614.00 94,616.12 3,473,519.00 867,888.88 75%576,057.25 604,378.00 (28,320.75) 2,607,230.12 2,512,614.00 94,616.12 3,473,519.00 867,888.88 75%Total IncomeMonth to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueMarch 20122 Income March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 194.00 - 194.00 2,654.42 - 2,654.42 0 0 0%4100110 Sales Hard Goods 14,064.31 20,073.00 (6,008.69) 82,323.37 77,953.00 4,370.37 108,822.00 26,498.63 76%4100112 Sales-Soft Goods 31,328.56 37,278.00 (5,949.44) 162,240.15 144,768.00 17,472.15 202,097.00 39,856.85 80%5100639 GS-Discounts-Mdse (5,745.38) - (5,745.38) (35,436.77) - (35,436.77) - 35,436.77 0% Total Revenue Golf Shop 39,841.49 57,351.00 (17,509.51) 211,781.17 222,721.00 (10,939.83) 310,919.00 101,792.25 67%COS 5100150 COS-GS-Hard Goods 6,866.80 11,040.15 (4,173.35) 44,288.11 42,874.15 1,413.96 59,852.10 15,563.99 74%5100151 COS-GS-Soft Goods 15,358.45 20,502.90 (5,144.45) 74,970.86 79,622.40 (4,651.54) 111,153.35 36,182.49 67%5100152 COS-GS-Purchase Disc (129.06) (1,577.00) 1,447.94 (923.91) (6,127.00) 5,203.09 (8,550.00) (7,626.09) -11%5100220 COS-GS-Freight Merch 682.68 476.00 206.68 3,566.48 1,841.00 1,725.48 2,565.00 (1,001.48) 139%Cost of Sales - Golf Shop 22,778.87 30,442.05 (7,663.18) 121,901.54 118,210.55 3,690.99 165,020.45 43,118.91 74%Gross Profit 17,062.62 26,908.95 (9,846.33) 89,879.63 104,510.45 (14,630.82) 145,898.55 58,673.34 60%COS % 57.2% 53.1% -4.1% 57.6% 53.1% -4.5% 53.1% 42.4% 20%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 2,402.29 2,317.00 85.29 22,467.07 19,860.00 2,607.07 26,811.00 4,343.93 84%6101325 Insurance-Workers Comp 501.70 577.00 (75.30) 3,828.95 4,555.00 (726.05) 6,131.00 2,302.05 62%6101720 Salaries 3,781.80 3,750.00 31.80 34,627.18 33,750.00 877.18 45,000.00 10,372.82 77%6101800 Taxes-Employer Payroll 1,737.67 1,603.00 134.67 10,652.94 12,656.00 (2,003.06) 17,040.00 6,387.06 63%6101880 Wages-Hourly 9,057.68 10,253.00 (1,195.32) 62,355.73 76,789.00 (14,433.27) 103,818.00 41,462.27 60%6101882 Wages-Overtime 383.75 - 383.75 1,034.25 - 1,034.25 - 952.88 0%Total -PS-SALARIES & BENEFITS 17,864.89 18,500.00 (635.11) 134,966.12 147,610.00 (12,643.88) 198,800.00 65,821.01 67%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 238.10 500.00 (261.90) 2,293.03 4,500.00 (2,206.97) 6,000.00 3,706.97 38%6109090 Contract Services 500.00 500.00 - 4,500.00 4,500.00 - 6,000.00 1,500.00 75%6109220 Freight & Delivery 44.35 - 44.35 620.42 75.00 545.42 75.00 (545.42) 827%6109490 Miscellaneous - 50.00 (50.00) 506.23 300.00 206.23 450.00 (56.23) 112%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short 7.00 - 7.00 105.31 - 105.31 - (105.31) 0%6109722 Seminars/Training 266.25 35.00 231.25 302.96 4,570.00 (4,267.04) 5,890.00 5,587.04 5%6109810 Travel - Merchandise - 15.00 (15.00) - 45.00 (45.00) 90.00 90.00 0%6109820 Uniforms - 200.00 (200.00) 1,275.13 1,800.00 (524.87) 2,400.00 1,124.87 53%6117840 Telephones 119.50 110.00 9.50 1,135.14 990.00 145.14 1,320.00 184.86 0%Total PS-OTHER EXPENSES 1,175.20 1,410.00 (234.80) 10,738.22 16,780.00 (6,041.78) 24,525.00 13,786.78 44%19,040.09 19,910.00 (869.91) 145,704.34 164,390.00 (18,685.66) 223,325.00 79,607.79 64%Net Income(1,977.47) 6,998.95 (8,976.42) (55,824.71) (59,879.55) 4,054.84 (77,426.45) (20,934.45) -73%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementMarch 20123 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 9,532.13 8,740.00 792.13 78,617.94 78,660.00 (42.06) 104,880.00 26,262.06 25.0%6311325 Insurance-Workers Comp 1,937.02 2,269.00 (331.98) 16,932.98 21,141.00 (4,208.02) 28,026.00 11,093.02 39.6%6311720 Salaries 11,735.04 12,583.00 (847.96) 107,448.96 113,247.00 (5,798.04) 150,996.00 43,547.04 28.8%6311800 Taxes-Employer Payroll 6,417.76 6,304.00 113.76 51,400.64 59,258.00 (7,857.36) 78,501.00 27,100.36 34.5%6311880 Wages-Hourly 44,657.69 42,478.00 2,179.69 399,536.86 391,220.00 8,316.86 518,654.00 119,117.14 23.0%6311882 Wages-Overtime 3.66 - 3.66 11,210.08 13,076.00 (1,865.92) 15,945.00 4,734.92 29.7%Total-CM-SALARIES & BENEFITS74,283.30 72,374.00 1,909.30 665,147.46 676,602.00 (11,454.54) 897,002.00 231,854.54 25.8%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 2,118.18 1,500.00 618.18 27,989.11 24,400.00 3,589.11 29,300.00 1,310.89 4.5%6313744 Fertilizer 7,226.11 5,000.00 2,226.11 100,195.83 89,400.00 10,795.83 104,400.00 4,204.17 4.0%6313745 Herbicides - - - 17,751.38 17,000.00 751.38 17,000.00 (751.38) -4.4%6313746 Flowers/Plants - 100.00 (100.00) 3,031.69 2,950.00 81.69 3,050.00 18.31 0.6%6313748 Fuel-Gasoline 4,586.61 3,500.00 1,086.61 42,120.24 38,500.00 3,620.24 48,800.00 6,679.76 13.7%6313750 Golf Course Accessories - 100.00 (100.00) 14,638.80 12,000.00 2,638.80 12,300.00 (2,338.80) -19.0%6313756 POA Control 231.16 - 231.16 8,443.26 7,000.00 1,443.26 7,000.00 (1,443.26) -20.6%6313758 Miscellaneous Supp 1,374.72 100.00 1,274.72 8,300.77 4,050.00 4,250.77 4,350.00 (3,950.77) 0.0%6313762 Supplies-Office 140.06 - 140.06 411.17 - 411.17 - (411.17) 0.0%6313774 Sand - 100.00 (100.00) 11,809.00 16,160.00 (4,351.00) 16,460.00 4,651.00 28.3%6313776 Seed - 350.00 (350.00) 106,201.53 105,760.00 441.53 106,810.00 608.47 0.6%6313778 Small Tools & Non-Capital Equip 75.87 100.00 (24.13) 4,426.31 4,700.00 (273.69) 5,000.00 573.69 11.5%6313780 Sod - - - 7,045.81 5,650.00 1,395.81 6,350.00 (695.81) -11.0%6313782 Topdressing - - - 3,842.05 5,000.00 (1,157.95) 7,600.00 3,757.95 49.4%Total-CM-SUPPLIES & MATERIALS15,752.71 10,850.00 4,902.71 356,206.95 332,570.00 23,636.95 368,420.00 12,213.05 3.3%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 5,660.00 2,600.00 3,060.00 25,380.00 23,400.00 1,980.00 31,200.00 5,820.00 18.7%6315685 CM-R&M-Bldngs & Othr Structures 95.50 - 95.50 4,081.76 1,250.00 2,831.76 1,750.00 (2,331.76) -133.2%6315690 CM-R&M-Equipment 1,714.64 1,000.00 714.64 25,276.13 16,000.00 9,276.13 20,500.00 (4,776.13) -23.3%6315692 CM-R&M-Irrigation System 1,289.24 1,000.00 289.24 15,629.55 19,650.00 (4,020.45) 22,650.00 7,020.45 31.0%6315696 CM-R&M-Pumps 2,480.38 1,000.00 1,480.38 9,280.58 9,000.00 280.58 10,500.00 1,219.42 11.6%6315815 CM-R&M-Trees-Pruning Etc 2,000.00 2,000.00 - 4,295.00 6,050.00 (1,755.00) 10,050.00 5,755.00 57.3%Total-CM-REPAIRS & MAINTENANCE 13,239.76 7,600.00 5,639.76 83,943.02 75,350.00 8,593.02 96,650.00 12,706.98 13.1%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG - 15.00 (15.00) 152.64 135.00 17.64 180.00 27.36 0.0%6317840 Telephones 1,144.52 850.00 294.52 10,735.47 7,650.00 3,085.47 10,200.00 (535.47) -5.2%Total-CM-UTILITIES 1,144.52 865.00 279.52 10,888.11 7,785.00 3,103.11 10,380.00 (508.11) -4.9%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 4,500.00 4,500.00 - 6,000.00 1,500.00 25.0%6319100 Contract Svcs-Soil/Tissue Test - - - 2,000.00 2,000.00 - 4,000.00 2,000.00 50.0%6319102 Contract Svcs-Trash Removal 590.65 524.00 66.65 7,397.56 4,716.00 2,681.56 6,288.00 (1,109.56) 0.0%6319150 Dues & Subscriptions 210.00 - 210.00 770.00 240.00 530.00 540.00 (230.00) -42.6%6319170 Employee Education - 50.00 (50.00) 59.00 1,400.00 (1,341.00) 1,550.00 1,491.00 96.2%6319197 Equipment Rental - 200.00 (200.00) 2,695.38 3,700.00 (1,004.62) 4,200.00 1,504.62 35.8%6319206 Licenses & Permits - 1,000.00 (1,000.00) - 1,280.00 (1,280.00) 1,430.00 1,430.00 100.0%6319490 Miscellaneous - 100.00 (100.00) 1,954.18 900.00 1,054.18 1,200.00 (754.18) -62.8%6319718 Safety Equipment & Training 399.00 200.00 199.00 3,019.88 3,550.00 (530.12) 3,850.00 830.12 21.6%6319822 Uniforms 1,102.43 920.00 182.43 9,409.24 8,280.00 1,129.24 11,040.00 1,630.76 14.8%Total-CM-OTHER EXPENSES 2,802.08 3,494.00 (691.92) 31,805.24 30,566.00 1,239.24 40,098.00 8,292.76 20.7%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementMarch 2012Annual Budget4 March 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 20,638.61 23,832.00 (3,193.39) 31,776.00 11,137.39 35.0%6321325 Insurance-Workers Comp 640.93 531.00 109.93 4,097.53 4,924.00 (826.47) 6,543.00 2,445.47 37.4%6321800 Taxes-Employer Payroll 2,220.25 1,475.00 745.25 12,622.67 13,882.00 (1,259.33) 18,416.00 5,793.33 31.5%6321880 Wages-Hourly 12,796.23 12,880.00 (83.77) 113,126.30 115,920.00 (2,793.70) 154,560.00 41,433.70 26.8%6321882 Wages-Overtime - - - 2,349.10 5,313.00 (2,963.90) 6,279.00 3,929.90 62.6%Total-CM-LM-SALARIES & BENEFITS18,615.65 17,534.00 1,081.65 152,834.21 163,871.00 (11,036.79) 217,574.00 64,739.79 29.8%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools 49.52 75.00 (25.48) 224.72 800.00 (575.28) 1,025.00 800.28 78.1%6323788 Uniforms 280.32 290.00 (9.68) 2,098.71 2,610.00 (511.29) 3,480.00 1,381.29 39.7%Total-CM-LM-SUPPLIES & MATERIALS329.84 365.00 (35.16) 2,323.43 3,410.00 (1,086.57) 4,505.00 2,181.57 48.4%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 250.00 (250.00) 1,297.90 3,250.00 (1,952.10) 4,250.00 2,952.10 69.5%Total-CM-LM-REPAIRS & MAINTENANCE - 250.00 (250.00) 1,297.90 3,250.00 (1,952.10) 4,250.00 2,952.10 69.5%126,167.86 113,332.00 12,835.86 1,304,446.32 1,293,404.00 11,042.32 1,638,879.00 334,432.68 20.4% March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 16,004.30 18,005.00 (2,000.70) 119,093.40 165,427.00 (46,333.60) 227,391.00 108,297.60 47.6%6337842 Utilities-Water2,472.70 1,550.00 922.70 37,833.96 31,743.00 6,090.96 43,058.00 5,224.04 12.1%18,477.00 19,555.00 (1,078.00) 156,927.36 197,170.00 (40,242.64) 270,449.00 113,521.64 42.0%Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetSilverrock ResortCourse Maintenance Water & EnergyMarch 2012Total-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementMarch 2012Annual BudgetMonth to Date Year to Date5 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group 420.59 662.00 (241.41) 3,893.12 5,958.00 (2,064.88) 7,944.00 4,050.88 51.0%6411325 Insurance-Workers Comp 401.15 565.00 (163.85) 3,317.05 3,777.00 (459.95) 5,096.00 1,778.95 34.9%6411800 Taxes-Employer Payroll 2,197.39 1,707.00 490.39 12,517.01 11,414.00 1,103.01 15,399.00 2,881.99 18.7%6411880 Wages-Hourly 14,178.86 13,710.00 468.86 95,082.52 91,679.00 3,403.52 123,689.00 28,606.48 23.1%6411882 Wages-Overtime 409.69 - 409.69 1,204.14 - 1,204.14 - (1,204.14) 0.0%Total-CBR-SALARIES & BENEFITS17,607.68 16,644.00 963.68 116,013.84 112,828.00 3,185.84 152,128.00 36,114.16 23.7%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 151.38 50.00 101.38 1,209.92 2,200.00 (990.08) 2,350.00 1,140.08 48.5%6413742 Supplies-Expendable 385.75 150.00 235.75 8,161.01 5,600.00 2,561.01 6,750.00 (1,411.01) -20.9%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) - 375.00 (375.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - 70.00 (70.00) 70.40 210.00 (139.60) 420.00 349.60 83.2%6413786 Supplies-Towels 480.00 72.00 408.00 2,800.00 789.00 2,011.00 1,005.00 (1,795.00) -178.6%6413796 Supplies-Bottled Water31.84 50.00 (18.16) 11,913.81 12,400.00 (486.19) 24,500.00 12,586.19 51.4%Total-CBR-SUPPLIES & MATERIALS1,048.97 442.00 606.97 31,900.99 30,574.00 1,326.99 44,550.00 12,649.01 28.4%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment - 300.00 (300.00) 3,476.34 2,700.00 776.34 3,600.00 123.66 3.4%6415695 CBR-R&M-Cart Maintenance & Repair 1,472.68 750.00 722.68 4,845.78 7,500.00 (2,654.22) 9,750.00 4,904.22 50.3%Total-CBR-REPAIRS & MAINTENANCE 1,472.68 1,050.00 422.68 8,322.12 10,200.00 (1,877.88) 13,350.00 5,027.88 37.7%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 978.54 800.00 178.54 6,496.42 7,200.00 (703.58) 9,600.00 3,103.58 32.3%6419220 Freight/Delivery - - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous - 125.00 (125.00) 451.78 775.00 (323.22) 1,150.00 698.22 60.7%6419820 Uniforms - 500.00 (500.00) 2,597.37 3,500.00 (902.63) 5,200.00 2,602.63 50.1%Total-CBR-OTHER EXPENSES 978.54 1,425.00 (446.46) 9,545.57 11,925.00 (2,379.43) 16,400.00 6,854.43 41.8%TOTAL-CARTS,BAGROOM & RANGE 21,107.87 19,561.00 1,546.87 165,782.52 165,527.00 255.52 226,428.00 60,645.48 26.8%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 358.70 254.00 104.70 2,450.74 1,424.00 1,026.74 1,805.00 (645.74) -35.8%6431800 Taxes-Employer Payroll 806.88 705.00 101.88 4,926.90 3,956.00 970.90 5,015.00 88.10 1.8%6431880 Wages-Hourly 5,527.07 6,160.00 (632.93) 36,114.00 34,560.00 1,554.00 43,800.00 7,686.00 17.5%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS6,692.65 7,119.00 (426.35) 43,491.64 39,940.00 3,551.64 50,620.00 7,128.36 14.1%643-CS-OTHER EXPENSES6433742 Supplies Expendable 382.61 100.00 282.61 1,011.75 800.00 211.75 1,050.00 38.25 3.6%6439490 Miscellaneous 615.82 - 615.82 1,109.08 200.00 909.08 200.00 (909.08) -454.5%6439718 Safety Equipment & Training - 50.00 (50.00) 91.59 450.00 (358.41) 600.00 508.41 84.7%6439820 Uniforms - 75.00 (75.00) 1,283.81 1,575.00 (291.19) 2,125.00 841.19 39.6%Total-CS-OTHER EXPENSES 998.43 225.00 773.43 3,496.23 3,025.00 471.23 3,975.00 478.77 12.0%Total-COURSE SERVICES 7,691.08 7,344.00 347.08 46,987.87 42,965.00 4,022.87 54,595.00 7,607.13 13.9%28,798.95 26,905.00 1,893.95 212,770.39 208,492.00 4,278.39 281,023.00 67,773.84 24.1%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementMarch 2012Annual Budget6 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 901.04 3,600.00 (2,698.96) 4,800.00 3,898.96 81.2%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 901.04 3,600.00 (2,698.96) 4,800.00 3,898.96 81.2%65-CH-UTILITIES6507836 Utilities-Natural Gas458.13 300.00 158.13 3,603.64 2,700.00 903.64 3,600.00 (3.64) -0.1%6507840 Utilities-Telephone1,182.62 1,150.00 32.62 10,052.79 10,350.00 (297.21) 13,800.00 3,747.21 27.2%6507842 Utilities-Water487.98 321.00 166.98 3,420.91 2,889.00 531.91 3,852.00 431.09 11.2%6507844 Utilities-Cable336.91 340.00 (3.09) 3,032.07 3,060.00 (27.93) 4,080.00 1,047.93 25.7%Total-CH-UTILITIES 2,465.64 2,111.00 354.64 20,109.41 18,999.00 1,110.41 25,332.00 5,222.59 20.6%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 14,600.00 17,025.00 (2,425.00) 22,500.00 7,900.00 35.1%6509099 Contract Services-Security7,297.56 4,900.00 2,397.56 49,796.08 45,700.00 4,096.08 60,400.00 10,603.92 17.6%6509215 Flowers & Decorations- 500.00 (500.00) - 2,000.00 (2,000.00) 2,400.00 2,400.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 616.89 1,800.00 (1,183.11) 2,400.00 1,783.11 74.3%6509718 Safety Equipment & Training- 100.00 (100.00) 127.19 900.00 (772.81) 1,200.00 1,072.81 89.4%Total-CH-OTHER EXPENSES 9,122.56 7,525.00 1,597.56 65,140.16 67,425.00 (2,284.84) 88,900.00 23,759.84 26.7%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures86.00 300.00 (214.00) 5,547.61 2,700.00 2,847.61 3,600.00 (1,947.61) -54.1%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 1,086.01 3,600.00 (2,513.99) 4,800.00 3,713.99 77.4%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 2,862.37 3,600.00 (737.63) 4,800.00 1,937.63 40.4%Total-CH-REPAIRS & MAINTENANCE 86.00 1,100.00 (1,014.00) 9,495.99 9,900.00 (404.01) 13,200.00 3,704.01 28.1%11,674.20 11,136.00 538.20 95,646.60 99,924.00 (4,277.40) 132,232.00 7,408.02 5.6%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementMarch 2012Annual Budget7 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 369.78 331.00 38.78 2,798.04 2,979.00 (180.96) 3,972.00 1,173.96 29.6%6601325 Insurance-Workers Comp 180.55 103.00 77.55 1,410.93 927.00 483.93 1,240.00 (170.93) -13.8%6601720 Salaries 2,236.27 2,508.00 (271.73) 20,339.31 22,572.00 (2,232.69) 30,096.00 9,756.69 32.4%6601800 Taxes-Employer Payroll 236.36 287.00 (50.64) 2,487.48 2,583.00 (95.52) 3,446.00 958.52 27.8%Total-MKT-SALARIES & BENEFITS 3,022.96 3,229.00 (206.04) 27,035.76 29,061.00 (2,025.24) 38,754.00 11,718.24 30.2%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 425.07 100.00 325.07 506.03 900.00 (393.97) 1,200.00 693.97 57.8%6603768 Supplies-Printing & Stationery 306.57 125.00 181.57 4,273.00 4,050.00 223.00 4,425.00 152.00 3.4%731.64 225.00 506.64 4,779.03 4,950.00 (170.97) 5,625.00 845.97 15.0%66-MKT-UTILITIES6607840 Utilities-Telephone 105.50 100.00 5.50 760.44 900.00 (139.56) 1,200.00 439.56 36.6%Total-MKT-UTILITIES 105.50 100.00 5.50 760.44 900.00 (139.56) 1,200.00 439.56 36.6%66-MKT-OTHER EXPENSES6609010 Advertising 11,440.03 19,680.00 (8,239.97) 124,648.39 153,927.00 (29,278.61) 185,731.00 61,082.61 32.9%6609040 Business Meals - 25.00 (25.00) - 225.00 (225.00) 300.00 300.00 100.0%6609080 Collateral Material 1,036.14 500.00 536.14 6,311.79 7,000.00 (688.21) 9,000.00 2,688.21 29.9%6609102 Contract Services-Web Page 99.00 400.00 (301.00) 891.00 3,600.00 (2,709.00) 4,800.00 3,909.00 81.4%6609490 Miscellaneous - 50.00 (50.00) 143.29 250.00 (106.71) 350.00 206.71 59.1%6609620 Postage - 50.00 (50.00) 430.86 450.00 (19.14) 600.00 169.14 28.2%6609630 Promotion - 50.00 (50.00) 32.33 550.00 (517.67) 3,500.00 3,467.67 0.0%6609633 Promotion-Community - 75.00 (75.00) 84.05 2,700.00 (2,615.95) 2,925.00 2,840.95 97.1%6609634 Promotion-Media/Vendor - - - 465.00 3,500.00 (3,035.00) 700.00 - 0.0%6609150 Dues and Subscriptions 243.32 300.00 (56.68) 368.08 735.00 (366.92) 735.00 366.92 49.9%6609820 Uniforms - 50.00 (50.00) 813.72 550.00 263.72 600.00 (213.72) -35.6%Total-MKT-OTHER EXPENSES 12,818.49 21,180.00 (8,361.51) 134,188.51 173,487.00 (39,298.49) 209,241.00 74,817.49 35.8%16,678.59 24,734.00 (8,055.41) 166,763.74 208,398.00 (41,634.26) 254,820.00 87,821.26 34.5%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementMarch 2012Annual Budget8 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,802.11 1,458.00 344.11 20,450.87 13,122.00 7,328.87 17,496.00 (2,954.87) -16.9%6701325 Insurance-Workers Comp602.40 707.00 (104.60) 4,952.72 6,363.00 (1,410.28) 8,480.00 3,527.28 41.6%6701720 Salaries 14,310.85 14,833.34 (522.49) 131,032.31 133,500.06 (2,467.75) 178,000.00 46,967.69 26.4%6701800 Taxes-Employer Payroll 1,382.98 1,964.00 (581.02) 12,605.25 17,676.00 (5,070.75) 23,568.00 10,962.75 46.5%6701880 Wages-Hourly2,277.71 2,319.66 (41.95) 17,722.60 20,876.94 (3,154.34) 27,835.00 10,112.40 36.3%6701882 Wages-Overtime - - - 10.88 - 10.88 - (10.88) 0.0%Total-G&A-SALARIES & BENEFITS 20,376.05 21,282.00 (905.95) 186,774.63 191,538.00 (4,763.37) 255,379.00 68,604.37 26.9%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer198.00 400.00 (202.00) 1,891.47 3,600.00 (1,708.53) 5,200.00 3,308.53 63.6%6703762 Supplies-Office - 100.00 (100.00) 899.71 900.00 (0.29) 1,200.00 300.29 25.0%6703768 Supplies-Printing & Stationery223.42 400.00 (176.58) 516.89 2,100.00 (1,583.11) 3,300.00 2,783.11 84.3%Total-G&A-SUPPLIES & MATERIALS 421.42 900.00 (478.58) 3,308.07 6,600.00 (3,291.93) 9,700.00 6,391.93 65.9%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 228.47 800.00 (571.53) 1,100.00 871.53 79.2%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 228.47 800.00 (571.53) 1,100.00 871.53 79.2%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 3,600.00 3,600.00 - 4,800.00 1,200.00 25.0%6709150 Dues & Subscriptions- 50.00 (50.00) 491.17 1,100.00 (608.83) 1,700.00 1,208.83 71.1%6709180 Employee Recruiting/Relocation- 200.00 (200.00) 793.35 1,400.00 (606.65) 1,400.00 606.65 43.3%6709197 Equipment Rental673.02 480.00 193.02 5,468.30 4,320.00 1,148.30 5,760.00 291.70 5.1%6709202 Fees-Bank170.11 90.00 80.11 758.61 810.00 (51.39) 1,080.00 321.39 29.8%6709208 Fees-Payroll Processing1,434.91 1,100.00 334.91 10,041.38 9,900.00 141.38 13,200.00 3,158.62 23.9%6709220 Freight/Delivery- 50.00 (50.00) - 450.00 (450.00) 600.00 600.00 100.0%6709490 Miscellaneous - 100.00 (100.00) 476.48 900.00 (423.52) 1,200.00 723.52 60.3%6709620 Postage/Mail Services 111.38 75.00 36.38 800.22 675.00 125.22 900.00 99.78 11.1%6709625 Professional Fees248.53 850.00 (601.47) 7,424.80 7,650.00 (225.20) 10,200.00 2,775.20 27.2%6709636 Promotion/Entertainment- 100.00 (100.00) 3,000.00 2,800.00 200.00 3,100.00 100.00 3.2%6709722 Seminars & Training- 200.00 (200.00) 1,348.61 1,800.00 (451.39) 2,400.00 1,051.39 43.8%6709810 Travel - - - 224.38 200.00 24.38 1,100.00 875.62 79.6%6709820 Uniforms 36.00 75.00 (39.00) 765.46 825.00 (59.54) 1,050.00 284.54 27.1%Total-G&A-OTHER EXPENSES 3,073.95 3,770.00 (696.05) 35,192.76 36,430.00 (1,237.24) 48,490.00 13,297.24 27.4%23,871.42 26,052.00 (2,180.58) 225,503.93 235,368.00 (9,864.07) 314,669.00 89,165.07 28.3%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementMarch 2012Annual Budget9 March Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,988.25 12,075.00 (86.75) 103,411.15 108,675.00 (5,263.85) 144,900.00 41,488.85 28.6%6800194 Equipment Leases-Trailer 502.54 600.00 (97.46) 4,551.32 5,400.00 (848.68) 7,200.00 2,648.68 36.8%6800196 Equipment Leases-GPS 9,486.00 5,755.00 3,731.00 51,212.02 51,795.00 (582.98) 69,060.00 17,847.98 25.8%6800197 Equipment Leases-Others 1,203.00 1,160.00 43.00 17,587.94 10,440.00 7,147.94 13,920.00 (3,667.94) 0.0%23,179.79 19,590.00 3,589.79 176,762.43 176,310.00 452.43 235,080.00 58,317.57 24.8%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee (11,346.74) (11,910.00) 563.26 60,481.31 71,662.00 (11,180.69) 90,000.00 29,518.69 32.8%6900210 FF&E Reserve 10,884.79 11,664.00 (779.21) 49,284.26 48,001.00 1,283.26 66,540.00 17,255.74 25.9%6900800 Personal Property Taxes 382.85 - 382.85 13,885.32 14,800.00 (914.68) 14,800.00 914.68 6.2%6900323 Insurance-Commercial 2,475.07 2,200.00 275.07 21,698.92 19,800.00 1,898.92 26,400.00 4,701.08 17.8%2,395.97 1,954.00 441.97 145,349.81 154,263.00 (8,913.19) 197,740.00 52,390.19 26.5%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementMarch 201210 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 CategoryJanuaryFebruaryMarchAprilMayJuneMedia566SalesPromotion1134Golf Industry4VIPCelebrity2PGA Comp37 10553Charity/Gift Certificate8234Rain/Wind Checks413Club Staff150 9266LQ HS Golf48 177 199255 420 345 0 0 011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2011-2012March 2012 Date Time Description CategoryPlayers3/9/2012 12:37 Sandy Carlson / Mary Bono Office Promo 43/16/2012 8:30 John White Media 43/16/2012 12:30 Kris Long Media 212