Loading...
03 September 2012 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2012 – September 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 September Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue131,168.69 156,113.00 (24,944.31) -16.0% 295,661.64 328,875.00 (33,213.36) 3,350,773.00 3,055,111.36 9%401000 Miscellaneous Golf Revenue 4,972.00 7,345.00 (2,373.00) -32.3% 12,815.90 18,625.00 (5,809.10) 159,973.00 147,157.10 8%410000 Revenue-Golf Shop 14,148.88 15,871.00 (1,722.12) -10.9% 29,880.79 31,862.00 (1,981.21) 311,048.00 281,167.21 10%420000 Revenue-F&B Concession500.00 500.00 - 0.0% 1,500.00 1,500.00 - 12,000.00 10,500.00 13%890000 Interest Income0.76 - 0.76 0.0% 1.81 - 1.81 - (1.81) 0%Total Income150,790.33 179,829.00 (29,038.67) -16.1% 339,860.14 380,862.00 (41,001.86) 3,833,794.00 3,493,933.86 9%Cost of Goods Sold510000 COS-Golf Shop 7,380.60 8,424.05 (1,043.45) 12.4% 15,723.97 16,911.10 1,187.13 165,088.40 149,364.43 10%Total COS7,380.60 8,424.05 (1,043.45) 12.4% 15,723.97 16,911.10 1,187.13 165,088.40 149,364.43 10%Gross Profit143,409.73 171,404.95 (27,995.22) -16.3% 324,136.17 363,950.90 (39,814.73) 3,668,705.60 3,344,569.43 9%Expenses610000 Golf Pro Shop 16,611.63 16,834.00 222.37 1.3% 48,671.73 49,504.00 832.27 212,986.00 164,314.27 23%630000 Course Maintenance142,848.48 146,019.00 3,170.52 2.2% 404,597.51 404,341.00 (256.51) 1,664,207.00 1,259,609.49 24%633000 Maintenance Water & Energy19,583.85 19,975.00 391.15 2.0% 67,999.30 57,620.00 (10,379.30) 221,749.00 153,749.70 31%640000 Outside Services17,582.95 17,539.00 (43.95) -0.3% 51,560.01 48,774.00 (2,786.01) 292,671.00 241,110.99 18%650000 Clubhouse 11,376.60 10,636.00 (740.60) -7.0% 33,789.16 31,908.00 (1,881.16) 132,232.00 98,442.84 26%660000 Marketing 20,408.62 24,749.00 4,340.38 17.5% 44,743.30 50,187.00 5,443.70 245,611.00 200,867.70 18%670000 General & Administrative25,395.12 25,711.00 315.88 1.2% 70,053.39 76,383.00 6,329.61 312,385.00 242,331.61 22%680000 Leases 17,737.17 18,890.00 1,152.83 6.1% 53,981.13 56,670.00 2,688.87 226,680.00 172,698.87 24%690000 Miscellaneous Other Expense22,635.38 20,260.00 (2,375.38) -11.7% 79,749.63 78,079.00 (1,670.63) 198,215.00 118,465.37 40%Total Expenses294,179.80 300,613.00 6,433.20 2.1% 855,145.16 853,466.00 (1,679.16) 3,506,736.00 2,651,590.84 24%(150,770.07) (129,208.05) (21,562.02) -16.7%(531,008.99) (489,515.10) (41,493.89) 161,969.60 692,978.59 -328%Rounds of Golf PlayedPaid Rounds Played 3,176 3,450 (274) -7.9% 8,027 8,250 (223) 45,625 37,598 18%Ave $ Per Paid Round Green Fee41.30 45.25 (3.95) -8.7% 36.83 39.86 (3.03) 73.44 36.61 50%Ave $ Per Paid Round Merchandise4.45 4.60 (0.15) -3.2% 3.72 3.86 (0.14) 6.82 3.09 55%Ave $ Per Paid Miscellaneous 1.57 2.13 (0.56) -26.5% 1.60 2.26 (0.66) 3.51 1.91 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateSeptember 20121 Income September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 131,168.69 156,113.00 (24,944.31) 295,661.64 328,875.00 (33,213.36) 3,350,773.003,055,111.369%4010000 Rider Fee 580.00 345.00 235.00 1,630.00 825.00 805.00 7,643.006,013.0021%4040000 Club Rental 1,420.00 1,725.00 (305.00) 3,200.00 4,125.00 (925.00) 23,325.0020,125.0014%4050000 Driving Range 2,972.00 5,175.00 (2,203.00) 6,816.00 12,375.00 (5,559.00) 85,405.0078,589.008%4060000 Handicap Fees - - - - - - 0.000.000%4080000 GPS Advertising - 100.00 (100.00) - 300.00 (300.00) 2,600.00 2,600.000%4090000 Ball Retriever/Subcontract - - - 1,169.90 1,000.00 169.90 4,000.00 2,830.1029%4091000 Golf Professional Rental Fee - - - - - - 37,000.00 37,000.00 0%4092000 Golf Lessons - - - - - - - - 0% Total Revenue Fees 136,140.69 163,458.00 (27,317.31) 308,477.54 347,500.00 (39,022.46) 3,510,746.00 3,202,268.46 9%136,140.69 163,458.00 (27,317.31) 308,477.54 347,500.00 (39,022.46) 3,510,746.00 3,202,268.46 9%SilverRock ResortStatement of Fees RevenueSeptember 2012Total IncomeMonth to Date Year to Date Annual Budget2 Income September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 94.00 - 94.00 344.77 - 344.77 0 0 0%4100110 Sales Hard Goods 5,749.38 5,555.00 194.38 14,260.82 11,152.00 3,108.82 108,867.00 94,606.18 13%4100112 Sales-Soft Goods 10,245.70 10,316.00 (70.30) 19,902.20 20,710.00 (807.80) 202,181.00 182,278.80 10%5100639 GS-Discounts-Mdse (1,940.20) - (1,940.20) (4,627.00) - (4,627.00) - 4,627.00 0% Total Revenue Golf Shop 14,148.88 15,871.00 (1,722.12) 29,880.79 31,862.00 (1,981.21) 311,048.00 281,511.98 9%COS 5100150 COS-GS-Hard Goods 3,016.55 3,055.25 (38.70) 7,603.73 6,133.60 1,470.13 59,876.85 52,273.12 13%5100151 COS-GS-Soft Goods 4,443.99 5,673.80 (1,229.81) 7,938.92 11,390.50 (3,451.58) 111,199.55 103,260.63 7%5100152 COS-GS-Purchase Disc (183.75) (436.00) 252.25 (201.65) (876.00) 674.35 (8,554.00) (8,352.35) -2%5100220 COS-GS-Freight Merch 103.81 131.00 (27.19) 382.97 263.00 119.97 2,566.00 2,183.03 15%Cost of Sales - Golf Shop 7,380.60 8,424.05 (1,043.45) 15,723.97 16,911.10 (1,187.13) 165,088.40 149,364.43 10%Gross Profit 6,768.28 7,446.95 (678.67) 14,156.82 14,950.90 (794.08) 145,959.60 132,147.55 9%COS % 52.2% 53.1% 0.9% 52.6% 53.1% 0.5% 53.1% 53.1% 0%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 2,402.29 1,986.00 416.29 7,206.87 5,958.00 1,248.87 26,811.00 19,604.13 27%6101325 Insurance-Workers Comp 501.70 434.00 67.70 1,368.71 1,306.00 62.71 5,663.00 4,294.29 24%6101720 Salaries 4,609.07 3,750.00 859.07 12,409.04 11,250.00 1,159.04 45,000.00 32,590.96 28%6101800 Taxes-Employer Payroll 896.13 1,131.00 (234.87) 2,611.84 3,403.00 (791.16) 14,758.00 12,146.16 18%6101880 Wages-Hourly 6,045.45 7,073.00 (1,027.55) 18,916.58 21,307.00 (2,390.42) 96,229.00 77,312.42 20%6101882 Wages-Overtime 241.42 - 241.42 631.35 - 631.35 - 952.88 0%Total -PS-SALARIES & BENEFITS 14,696.06 14,374.00 322.06 43,144.39 43,224.00 (79.61) 188,461.00 146,900.84 22%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 154.68 500.00 (345.32) 291.74 1,500.00 (1,208.26) 6,000.00 5,708.26 5%6109090 Contract Services 500.00 500.00 - 1,500.00 1,500.00 - 6,000.00 4,500.00 25%6109220 Freight & Delivery - - - 77.35 - 77.35 75.00 (2.35) 103%6109490 Miscellaneous - - - 777.78 - 777.78 450.00 (327.78) 173%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short 27.53 - 27.53 25.88 - 25.88 - (25.88) 0%6109722 Seminars/Training - 1,250.00 (1,250.00) 1,250.00 2,650.00 (1,400.00) 5,890.00 4,640.00 21%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms 1,114.13 100.00 1,014.13 1,268.06 300.00 968.06 2,400.00 1,131.94 53%6117840 Telephones 119.23 110.00 9.23 336.53 330.00 6.53 1,320.00 983.47 0%Total PS-OTHER EXPENSES 1,915.57 2,460.00 (544.43) 5,527.34 6,280.00 (752.66) 24,525.00 18,997.66 23%16,611.63 16,834.00 (222.37) 48,671.73 49,504.00 (832.27) 212,986.00 165,898.50 22%Net Income(9,843.35) (9,387.05) (456.30) (34,514.91) (34,553.10) 38.19 (67,026.40) (33,750.95) -50%SilverRock ResortGolf Shop Income StatementSeptember 2012Total Expenses-Golf ShopMonth to Date Year to Date Annual Budget3 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 8,717.11 8,740.00 (22.89) 26,940.07 26,220.00 720.07 104,880.00 77,939.93 74.3%6311325 Insurance-Workers Comp 1,793.54 2,208.00 (414.46) 5,140.99 6,624.00 (1,483.01) 27,280.00 22,139.01 81.2%6311720 Salaries 11,302.08 11,001.60 300.48 35,505.60 33,004.80 2,500.80 150,996.00 115,490.40 76.5%6311800 Taxes-Employer Payroll 4,406.31 5,753.00 (1,346.69) 12,831.39 17,259.00 (4,427.61) 71,645.00 58,813.61 82.1%6311880 Wages-Hourly 47,944.53 44,054.40 3,890.13 137,944.57 132,163.20 5,781.37 518,654.00 380,709.43 73.4%6311882 Wages-Overtime 419.26 - 419.26 673.75 - 673.75 15,945.00 15,271.25 95.8%Total-CM-SALARIES & BENEFITS74,582.83 71,757.00 2,825.83 219,036.37 215,271.00 3,765.37 889,400.00 670,363.63 75.4%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 5,372.33 - 5,372.33 6,290.00 - 6,290.00 31,100.00 24,810.00 79.8%6313744 Fertilizer 9,588.49 14,500.00 (4,911.51) 40,248.92 45,000.00 (4,751.08) 114,500.00 74,251.08 64.8%6313745 Herbicides 6,659.35 7,000.00 (340.65) 7,281.37 7,000.00 281.37 17,000.00 9,718.63 57.2%6313746 Flowers/Plants - 1,000.00 (1,000.00) - 1,000.00 (1,000.00) 3,050.00 3,050.00 100.0%6313748 Fuel-Gasoline 4,280.70 5,100.00 (819.30) 14,069.98 15,500.00 (1,430.02) 55,020.00 40,950.02 74.4%6313750 Golf Course Accessories 499.59 500.00 (0.41) 578.77 900.00 (321.23) 13,000.00 12,421.23 95.5%6313756 POA Control 231.52 - 231.52 461.97 - 461.97 7,000.00 6,538.03 93.4%6313758 Miscellaneous Supp 371.90 750.00 (378.10) 2,473.81 2,250.00 223.81 4,350.00 1,876.19 0.0%6313762 Supplies-Office - - - 101.31 - 101.31 - (101.31) 0.0%6313774 Sand - 5,000.00 (5,000.00) - 5,780.00 (5,780.00) 16,460.00 16,460.00 100.0%6313776 Seed - 250.00 (250.00) 1,224.91 950.00 274.91 106,810.00 105,585.09 98.9%6313778 Small Tools & Non-Capital Equip 1,956.96 2,000.00 (43.04) 1,956.96 2,200.00 (243.04) 5,000.00 3,043.04 60.9%6313780 Sod 2,091.89 1,000.00 1,091.89 6,767.37 3,000.00 3,767.37 7,950.00 1,182.63 14.9%6313782 Topdressing - - - 1,536.29 2,500.00 (963.71) 7,600.00 6,063.71 79.8%Total-CM-SUPPLIES & MATERIALS31,052.73 37,100.00 (6,047.27) 82,991.66 86,080.00 (3,088.34) 388,840.00 305,848.34 78.7%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,830.00 2,600.00 230.00 8,490.00 7,800.00 690.00 31,200.00 22,710.00 72.8%6315685 CM-R&M-Bldngs & Othr Structures 136.34 550.00 (413.66) 449.86 2,550.00 (2,100.14) 5,550.00 5,100.14 91.9%6315690 CM-R&M-Equipment 6,248.80 2,000.00 4,248.80 12,182.99 5,000.00 7,182.99 31,000.00 18,817.01 60.7%6315692 CM-R&M-Irrigation System 690.02 2,200.00 (1,509.98) 6,910.18 13,000.00 (6,089.82) 22,650.00 15,739.82 69.5%6315696 CM-R&M-Pumps 780.00 1,000.00 (220.00) 4,567.00 3,000.00 1,567.00 10,500.00 5,933.00 56.5%6315815 CM-R&M-Trees-Pruning Etc 2,700.00 3,500.00 (800.00) 2,700.00 3,500.00 (800.00) 10,050.00 7,350.00 73.1%Total-CM-REPAIRS & MAINTENANCE 13,385.16 11,850.00 1,535.16 35,300.03 34,850.00 450.03 110,950.00 75,649.97 68.2%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 21.27 15.00 6.27 65.54 45.00 20.54 180.00 114.46 0.0%6317840 Telephones 1,303.88 850.00 453.88 3,716.86 2,550.00 1,166.86 10,200.00 6,483.14 63.6%Total-CM-UTILITIES 1,325.15 865.00 460.15 3,782.40 2,595.00 1,187.40 10,380.00 6,597.60 63.6%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 1,500.00 1,500.00 - 6,000.00 4,500.00 75.0%6319100 Contract Svcs-Soil/Tissue Test - 2,000.00 (2,000.00) - 2,000.00 (2,000.00) 4,000.00 4,000.00 100.0%6319102 Contract Svcs-Trash Removal 627.48 524.00 103.48 1,540.18 1,572.00 (31.82) 6,288.00 4,747.82 0.0%6319150 Dues & Subscriptions 210.00 - 210.00 210.00 - 210.00 540.00 330.00 61.1%6319170 Employee Education - 50.00 (50.00) - 150.00 (150.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental - 150.00 (150.00) - 500.00 (500.00) 4,200.00 4,200.00 100.0%6319206 Licenses & Permits - 80.00 (80.00) - 280.00 (280.00) 1,430.00 1,430.00 100.0%6319490 Miscellaneous - 100.00 (100.00) 519.55 300.00 219.55 1,200.00 680.45 56.7%6319718 Safety Equipment & Training 324.72 750.00 (425.28) 963.44 1,050.00 (86.56) 3,850.00 2,886.56 75.0%6319822 Uniforms 603.95 920.00 (316.05) 2,866.37 2,760.00 106.37 11,040.00 8,173.63 74.0%Total-CM-OTHER EXPENSES 2,266.15 5,074.00 (2,807.85) 7,599.54 10,112.00 (2,512.46) 40,098.00 32,498.46 81.0%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementSeptember 2012Annual Budget4 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,848.90 2,648.00 (799.10) 7,765.38 7,944.00 (178.62) 31,776.00 24,010.62 75.6%6321325 Insurance-Workers Comp 640.93 542.00 98.93 1,748.55 1,574.00 174.55 6,361.00 4,612.45 72.5%6321800 Taxes-Employer Payroll 1,894.80 1,447.00 447.80 4,331.63 4,139.00 192.63 16,808.00 12,476.37 74.2%6321880 Wages-Hourly 15,710.55 12,880.00 2,830.55 41,453.25 38,640.00 2,813.25 154,560.00 113,106.75 73.2%6321882 Wages-Overtime - 966.00 (966.00) 10.50 966.00 (955.50) 6,279.00 6,268.50 99.8%Total-CM-LM-SALARIES & BENEFITS20,095.18 18,483.00 1,612.18 55,309.31 53,263.00 2,046.31 215,784.00 160,474.69 74.4%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 100.00 (100.00) - 300.00 (300.00) 1,025.00 1,025.00 100.0%6323788 Uniforms 141.28 290.00 (148.72) 578.20 870.00 (291.80) 3,480.00 2,901.80 83.4%Total-CM-LM-SUPPLIES & MATERIALS141.28 390.00 (248.72) 578.20 1,170.00 (591.80) 4,505.00 3,926.80 87.2%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 500.00 (500.00) - 1,000.00 (1,000.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE - 500.00 (500.00) - 1,000.00 (1,000.00) 4,250.00 4,250.00 100.0%142,848.48 146,019.00 (3,170.52) 404,597.51 404,341.00 256.51 1,664,207.00 1,259,609.49 75.7% September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 13,180.24 13,815.00 (634.76) 47,247.57 40,300.00 6,947.57 178,691.00 131,443.43 73.6%6337842 Utilities-Water6,403.61 6,160.00 243.61 20,751.73 17,320.00 3,431.73 43,058.00 22,306.27 51.8%19,583.85 19,975.00 (391.15) 67,999.30 57,620.00 10,379.30 221,749.00 153,749.70 69.3%Silverrock ResortCourse Maintenance Expense StatementSeptember 2012Annual BudgetMonth to Date Year to DateSilverrock ResortCourse Maintenance Water & EnergySeptember 2012Total-COURSE MAINTENANCETotal-CM-WATER & ENERGYMonth to Date Year to Date Annual Budget5 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group 369.78 662.00 (292.22) 1,109.34 1,986.00 (876.66) 7,944.00 6,834.66 86.0%6411325 Insurance-Workers Comp 401.15 358.00 43.15 1,094.40 967.00 127.40 5,135.00 4,040.60 78.7%6411800 Taxes-Employer Payroll 1,041.53 1,110.00 (68.47) 2,969.07 3,002.00 (32.93) 15,942.00 12,972.93 81.4%6411880 Wages-Hourly 9,634.06 8,918.00 716.06 25,955.01 24,116.00 1,839.01 128,052.00 102,096.99 79.7%6411882 Wages-Overtime 73.88 - 73.88 123.20 - 123.20 - (123.20) 0.0%Total-CBR-SALARIES & BENEFITS11,520.40 11,048.00 472.40 31,251.02 30,071.00 1,180.02 157,073.00 125,821.98 80.1%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 201.50 - 201.50 336.19 - 336.19 2,350.00 2,013.81 85.7%6413742 Supplies-Expendable 300.63 150.00 150.63 2,903.37 1,350.00 1,553.37 6,750.00 3,846.63 57.0%6413748 Supplies-Fuel for Shuttle - 100.00 (100.00) - 100.00 (100.00) 3,000.00 3,000.00 100.0%6413752 Supplies-Range Balls - - - - - - 9,000.00 9,000.00 100.0%6413762 Supplies-Office - 25.00 (25.00) - 75.00 (75.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels 80.00 72.00 8.00 800.00 216.00 584.00 1,005.00 205.00 20.4%6413796 Supplies-Bottled Water89.50 50.00 39.50 567.87 150.00 417.87 24,500.00 23,932.13 97.7%Total-CBR-SUPPLIES & MATERIALS671.63 397.00 274.63 4,607.43 1,891.00 2,716.43 47,550.00 42,942.57 90.3%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment 20.88 300.00 (279.12) 20.88 900.00 (879.12) 3,600.00 3,579.12 99.4%6415695 CBR-R&M-Cart Maintenance & Repair 7.52 750.00 (742.48) 1,501.54 2,250.00 (748.46) 9,750.00 8,248.46 84.6%Total-CBR-REPAIRS & MAINTENANCE 28.40 1,050.00 (1,021.60) 1,522.42 3,150.00 (1,627.58) 13,350.00 11,827.58 88.6%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 276.67 800.00 (523.33) 2,350.21 2,400.00 (49.79) 9,600.00 7,249.79 75.5%6419220 Freight/Delivery - 75.00 (75.00) - 225.00 (225.00) 450.00 450.00 100.0%6419490 Miscellaneous 67.24 75.00 (7.76) 67.24 275.00 (207.76) 1,150.00 1,082.76 94.2%6419820 Uniforms - - - 287.81 - 287.81 5,200.00 4,912.19 94.5%Total-CBR-OTHER EXPENSES 343.91 950.00 (606.09) 2,705.26 2,900.00 (194.74) 16,400.00 13,694.74 83.5%TOTAL-CARTS,BAGROOM & RANGE 12,564.34 13,445.00 (880.66) 40,086.13 38,012.00 2,074.13 234,373.00 194,286.87 82.9%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 358.70 136.00 222.70 978.59 358.00 620.59 1,903.00 924.41 48.6%6431800 Taxes-Employer Payroll 450.62 353.00 97.62 1,058.09 929.00 129.09 4,960.00 3,901.91 78.7%6431880 Wages-Hourly 3,968.80 3,380.00 588.80 9,004.00 8,900.00 104.00 47,460.00 38,456.00 81.0%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS4,778.12 3,869.00 909.12 11,040.68 10,187.00 853.68 54,323.00 43,282.32 79.7%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) - 200.00 (200.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous 240.49 - 240.49 433.20 - 433.20 200.00 (233.20) -116.6%6439718 Safety Equipment & Training - 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6439820 Uniforms - 75.00 (75.00) - 225.00 (225.00) 2,125.00 2,125.00 100.0%Total-CS-OTHER EXPENSES 240.49 225.00 15.49 433.20 575.00 (141.80) 3,975.00 3,541.80 89.1%Total-COURSE SERVICES 5,018.61 4,094.00 924.61 11,473.88 10,762.00 711.88 58,298.00 46,824.12 80.3%17,582.95 17,539.00 43.95 51,560.01 48,774.00 2,786.01 292,671.00 237,569.19 81.2%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementSeptember 2012Annual Budget6 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable400.00 400.00 - 1,264.00 1,200.00 64.00 4,800.00 3,536.00 73.7%Total-CH-SUPPLIES & MATERIALS 400.00 400.00 - 1,264.00 1,200.00 64.00 4,800.00 3,536.00 73.7%65-CH-UTILITIES6507836 Utilities-Natural Gas- 300.00 (300.00) - 900.00 (900.00) 3,600.00 3,600.00 100.0%6507840 Utilities-Telephone1,195.32 1,150.00 45.32 3,646.69 3,450.00 196.69 13,800.00 10,153.31 73.6%6507842 Utilities-Water425.17 321.00 104.17 1,257.94 963.00 294.94 3,852.00 2,594.06 67.3%6507844 Utilities-Cable336.91 340.00 (3.09) 1,010.73 1,020.00 (9.27) 4,080.00 3,069.27 75.2%Total-CH-UTILITIES 1,957.40 2,111.00 (153.60) 5,915.36 6,333.00 (417.64) 25,332.00 19,416.64 76.6%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 5,475.00 5,475.00 - 22,500.00 17,025.00 75.7%6509099 Contract Services-Security5,398.08 4,900.00 498.08 16,984.52 14,700.00 2,284.52 60,400.00 43,415.48 71.9%6509215 Flowers & Decorations- - - - - - 2,400.00 2,400.00 100.0%6509490 Miscellaneous- 200.00 (200.00) - 600.00 (600.00) 2,400.00 2,400.00 100.0%6509718 Safety Equipment & Training121.12 100.00 21.12 121.12 300.00 (178.88) 1,200.00 1,078.88 89.9%Total-CH-OTHER EXPENSES 7,344.20 7,025.00 319.20 22,580.64 21,075.00 1,505.64 88,900.00 66,319.36 74.6%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures- 300.00 (300.00) 609.16 900.00 (290.84) 3,600.00 2,990.84 83.1%6515686 CH-R&M-Restaurant Repairs395.00 400.00 (5.00) 2,140.00 1,200.00 940.00 4,800.00 2,660.00 55.4%6515690 CH-R&M-Equipment Repair1,280.00 400.00 880.00 1,280.00 1,200.00 80.00 4,800.00 3,520.00 73.3%Total-CH-REPAIRS & MAINTENANCE 1,675.00 1,100.00 575.00 4,029.16 3,300.00 729.16 13,200.00 9,170.84 69.5%11,376.60 10,636.00 740.60 33,789.16 31,908.00 1,881.16 132,232.00 18,341.68 13.9%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementSeptember 2012Annual Budget7 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 369.78 331.00 38.78 1,109.34 993.00 116.34 3,972.00 2,862.66 72.1%6601325 Insurance-Workers Comp 180.55 101.00 79.55 492.57 303.00 189.57 1,207.00 714.43 59.2%6601720 Salaries 3,062.08 2,508.00 554.08 7,471.35 7,524.00 (52.65) 30,096.00 22,624.65 75.2%6601800 Taxes-Employer Payroll 270.86 262.00 8.86 708.82 786.00 (77.18) 3,145.00 2,436.18 77.5%Total-MKT-SALARIES & BENEFITS 3,883.27 3,202.00 681.27 9,782.08 9,606.00 176.08 38,420.00 28,637.92 74.5%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 300.00 (300.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery 263.09 200.00 63.09 933.37 200.00 733.37 4,425.00 3,491.63 78.9%263.09 300.00 (36.91) 933.37 500.00 433.37 5,625.00 4,691.63 83.4%66-MKT-UTILITIES6607840 Utilities-Telephone 105.45 100.00 5.45 316.49 300.00 16.49 1,200.00 883.51 73.6%Total-MKT-UTILITIES 105.45 100.00 5.45 316.49 300.00 16.49 1,200.00 883.51 73.6%66-MKT-OTHER EXPENSES6609010 Advertising 15,949.80 20,197.00 (4,247.20) 33,121.12 37,931.00 (4,809.88) 179,231.00 146,109.88 81.5%6609040 Business Meals - - - - - - 300.00 300.00 100.0%6609080 Collateral Material - - - - - - 9,000.00 9,000.00 100.0%6609102 Contract Services-Web Page 99.00 300.00 (201.00) 99.00 900.00 (801.00) 3,600.00 3,501.00 97.3%6609490 Miscellaneous - - - - - - 350.00 350.00 100.0%6609620 Postage 8.01 50.00 (41.99) 8.01 150.00 (141.99) 600.00 591.99 98.7%6609630 Promotion - 25.00 (25.00) 104.43 75.00 29.43 3,000.00 2,895.57 0.0%6609633 Promotion-Community - 75.00 (75.00) 278.80 225.00 53.80 2,250.00 1,971.20 87.6%6609634 Promotion-Media/Vendor - 500.00 (500.00) - 500.00 (500.00) 700.00 - 0.0%6609150 Dues and Subscriptions 100.00 - 100.00 100.00 - 100.00 735.00 635.00 86.4%6609820 Uniforms - - - - - - 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 16,156.81 21,147.00 (4,990.19) 33,711.36 39,781.00 (6,069.64) 200,366.00 165,954.64 82.8%20,408.62 24,749.00 (4,340.38) 44,743.30 50,187.00 (5,443.70) 245,611.00 200,167.70 81.5%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementSeptember 2012Annual Budget8 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,748.99 1,458.00 290.99 5,262.59 4,374.00 888.59 17,496.00 12,233.41 69.9%6701325 Insurance-Workers Comp602.40 688.00 (85.60) 1,643.43 2,064.00 (420.57) 8,254.00 6,610.57 80.1%6701720 Salaries 15,624.39 15,003.00 621.39 43,956.91 45,009.00 (1,052.09) 178,000.00 134,043.09 75.3%6701800 Taxes-Employer Payroll 1,446.22 1,792.00 (345.78) 3,894.03 5,376.00 (1,481.97) 21,510.00 17,615.97 81.9%6701880 Wages-Hourly1,458.51 2,150.00 (691.49) 3,935.12 6,450.00 (2,514.88) 27,835.00 23,899.88 85.9%6701882 Wages-Overtime 5.44 - 5.44 10.88 - 10.88 - (10.88) 0.0%Total-G&A-SALARIES & BENEFITS 20,885.95 21,091.00 (205.05) 58,702.96 63,273.00 (4,570.04) 253,095.00 194,392.04 76.8%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer184.00 400.00 (216.00) 184.00 1,200.00 (1,016.00) 5,200.00 5,016.00 96.5%6703762 Supplies-Office - 100.00 (100.00) 384.25 300.00 84.25 1,200.00 815.75 68.0%6703768 Supplies-Printing & Stationery- 100.00 (100.00) - 300.00 (300.00) 3,300.00 3,300.00 100.0%Total-G&A-SUPPLIES & MATERIALS 184.00 600.00 (416.00) 568.25 1,800.00 (1,231.75) 9,700.00 9,131.75 94.1%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) - 200.00 (200.00) 1,100.00 1,100.00 100.0%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) - 200.00 (200.00) 1,100.00 1,100.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 1,200.00 1,200.00 - 4,800.00 3,600.00 75.0%6709150 Dues & Subscriptions- 200.00 (200.00) 165.00 250.00 (85.00) 1,700.00 1,535.00 90.3%6709180 Employee Recruiting/Relocation30.00 200.00 (170.00) 90.00 200.00 (110.00) 1,400.00 1,310.00 93.6%6709197 Equipment Rental657.26 480.00 177.26 1,793.94 1,440.00 353.94 5,760.00 3,966.06 68.9%6709202 Fees-Bank114.60 90.00 24.60 338.18 270.00 68.18 1,080.00 741.82 68.7%6709208 Fees-Payroll Processing1,410.66 1,100.00 310.66 3,685.13 3,300.00 385.13 13,200.00 9,514.87 72.1%6709220 Freight/Delivery- 50.00 (50.00) - 150.00 (150.00) 600.00 600.00 100.0%6709490 Miscellaneous - 100.00 (100.00) 77.33 300.00 (222.67) 1,200.00 1,122.67 93.6%6709620 Postage/Mail Services 118.00 75.00 43.00 410.65 225.00 185.65 900.00 489.35 54.4%6709625 Professional Fees1,217.25 850.00 367.25 2,626.25 2,550.00 76.25 10,200.00 7,573.75 74.3%6709636 Promotion/Entertainment- 100.00 (100.00) - 300.00 (300.00) 3,100.00 3,100.00 100.0%6709722 Seminars & Training250.00 200.00 50.00 250.00 600.00 (350.00) 2,400.00 2,150.00 89.6%6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms 127.40 75.00 52.40 145.70 225.00 (79.30) 1,050.00 904.30 86.1%Total-G&A-OTHER EXPENSES 4,325.17 3,920.00 405.17 10,782.18 11,110.00 (327.82) 48,490.00 37,707.82 77.8%25,395.12 25,711.00 (315.88) 70,053.39 76,383.00 (6,329.61) 312,385.00 242,331.61 77.6%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementSeptember 2012Annual Budget9 September Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,091.63 12,075.00 (983.37) 35,068.13 36,225.00 (1,156.87) 144,900.00 109,831.87 75.8%6800194 Equipment Leases-Trailer 502.54 600.00 (97.46) 1,507.62 1,800.00 (292.38) 7,200.00 5,692.38 79.1%6800196 Equipment Leases-GPS 4,940.00 5,755.00 (815.00) 14,820.00 17,265.00 (2,445.00) 69,060.00 54,240.00 78.5%6800197 Equipment Leases-Others 1,203.00 460.00 743.00 2,585.38 1,380.00 1,205.38 5,520.00 2,934.62 0.0%17,737.17 18,890.00 (1,152.83) 53,981.13 56,670.00 (2,688.87) 226,680.00 172,698.87 76.2%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 15,429.78 14,938.00 491.78 60,602.27 59,702.00 900.27 90,000.00 29,397.73 32.7%6900210 FF&E Reserve 2,623.38 3,122.00 (498.62) 5,913.24 6,577.00 (663.76) 67,015.00 61,101.76 91.2%6900800 Personal Property Taxes 4,582.22 - 4,582.22 10,759.05 5,200.00 5,559.05 14,800.00 4,040.95 27.3%6900323 Insurance-Commercial - 2,200.00 (2,200.00) 2,475.07 6,600.00 (4,124.93) 26,400.00 23,924.93 90.6%22,635.38 20,260.00 2,375.38 79,749.63 78,079.00 1,670.63 198,215.00 118,465.37 59.8%Silverrock ResortOperating Leases & Miscellaneous Other Expense StatementSeptember 2012Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSES10 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2012-20132012 2012 2012 2012 2012 2012Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia342SalesPromotionGolf IndustryVIPCelebrityPGA Comp62 16 46Charity/Gift Certificate61511Rain/Wind Checks5Club Staff129 60 81LQ HS Golf812213 95 152 0 0 02013 2013 2013 2013 2013 2013Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2012-2013September 2012 Date Time Description CategoryPlayers9/1/2012 11:07 John White Media 212