Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
04 October 2012 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2012 – October 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 October Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue58,052.18 57,150.00 902.18 1.6% 353,713.82 386,025.00 (32,311.18) 3,350,773.00 2,997,059.18 11%401000 Miscellaneous Golf Revenue 3,589.00 3,400.00 189.00 5.6% 16,404.90 22,025.00 (5,620.10) 159,973.00 143,568.10 10%410000 Revenue-Golf Shop 4,230.77 8,000.00 (3,769.23) -47.1% 34,111.56 39,862.00 (5,750.44) 311,048.00 276,936.44 11%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0% 3,000.00 3,000.00 - 12,000.00 9,000.00 25%890000 Interest Income1.16 - 1.16 0.0% 2.97 - 2.97 - (2.97) 0%Total Income67,373.11 70,050.00 (2,676.89) -3.8% 407,233.25 450,912.00 (43,678.75) 3,833,794.00 3,426,560.75 11%Cost of Goods Sold510000 COS-Golf Shop 2,211.32 4,246.00 (2,034.68) 47.9% 17,935.29 21,157.10 3,221.81 165,088.40 147,153.11 11%Total COS2,211.32 4,246.00 (2,034.68) 47.9% 17,935.29 21,157.10 3,221.81 165,088.40 147,153.11 11%Gross Profit65,161.79 65,804.00 (642.21) -1.0% 389,297.96 429,754.90 (40,456.94) 3,668,705.60 3,279,407.64 11%Expenses610000 Golf Pro Shop 15,278.04 13,753.00 (1,525.04) -11.1% 63,949.77 63,257.00 (692.77) 212,986.00 149,036.23 30%630000 Course Maintenance271,212.43 262,638.00 (8,574.43) -3.3% 675,809.94 666,979.00 (8,830.94) 1,664,207.00 988,397.06 41%633000 Maintenance Water & Energy18,557.82 15,410.00 (3,147.82) -20.4% 86,557.12 73,030.00 (13,527.12) 221,749.00 135,191.88 39%640000 Outside Services22,770.29 28,168.00 5,397.71 19.2% 74,330.30 76,942.00 2,611.70 292,671.00 218,340.70 25%650000 Clubhouse 8,611.71 11,736.00 3,124.29 26.6% 42,400.87 43,644.00 1,243.13 132,232.00 89,831.13 32%660000 Marketing 10,605.47 19,024.00 8,418.53 44.3% 55,348.77 69,211.00 13,862.23 245,611.00 190,262.23 23%670000 General & Administrative28,816.76 25,636.00 (3,180.76) -12.4% 98,870.15 102,019.00 3,148.85 312,385.00 213,514.85 32%680000 Leases 18,452.91 18,890.00 437.09 2.3% 72,434.04 75,560.00 3,125.96 226,680.00 154,245.96 32%690000 Miscellaneous Other Expense28,628.62 36,008.00 7,379.38 20.5% 108,378.25 114,087.00 5,708.75 198,215.00 89,836.75 55%Total Expenses422,934.05 431,263.00 8,328.95 1.9% 1,278,079.21 1,284,729.00 6,649.79 3,506,736.00 2,228,656.79 36%(357,772.26) (365,459.00) 7,686.74 2.1%(888,781.25) (854,974.10) (33,807.15) 161,969.60 1,050,750.85 -549%Rounds of Golf PlayedPaid Rounds Played 980 1,000 (20) -2.0% 9,007 9,250 (243) 45,625 36,618 20%Ave $ Per Paid Round Green Fee59.24 57.15 2.09 3.7% 39.27 41.73 (2.46) 73.44 34.17 53%Ave $ Per Paid Round Merchandise4.32 8.00 (3.68) -46.0% 3.79 4.31 (0.52) 6.82 3.03 56%Ave $ Per Paid Miscellaneous 3.66 3.40 0.26 7.7% 1.82 2.38 (0.56) 3.51 1.68 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateOctober 20121 Income October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 58,052.18 57,150.00 902.18 353,713.82 386,025.00 (32,311.18) 3,350,773.002,997,059.1811%4010000 Rider Fee 715.00 100.00 615.00 2,345.00 925.00 1,420.00 7,643.005,298.0031%4040000 Club Rental 560.00 500.00 60.00 3,760.00 4,625.00 (865.00) 23,325.0019,565.0016%4050000 Driving Range 988.00 1,700.00 (712.00) 7,804.00 14,075.00 (6,271.00) 85,405.0077,601.009%4060000 Handicap Fees - - - - - - 0.000.000%4080000 GPS Advertising - 100.00 (100.00) - 400.00 (400.00) 2,600.00 2,600.000%4090000 Ball Retriever/Subcontract 1,326.00 1,000.00 326.00 2,495.90 2,000.00 495.90 4,000.00 1,504.1062%4091000 Golf Professional Rental Fee - - - - - - 37,000.00 37,000.00 0%4092000 Golf Lessons - - - - - - - - 0% Total Revenue Fees 61,641.18 60,550.00 1,091.18 370,118.72 408,050.00 (37,931.28) 3,510,746.00 3,140,627.28 11%61,641.18 60,550.00 1,091.18 370,118.72 408,050.00 (37,931.28) 3,510,746.00 3,140,627.28 11%Total IncomeMonth to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueOctober 20122 Income October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous - - - 344.77 - 344.77 0 0 0%4100110 Sales Hard Goods 2,150.35 2,800.00 (649.65) 16,411.17 13,952.00 2,459.17 108,867.00 92,455.83 15%4100112 Sales-Soft Goods 2,575.00 5,200.00 (2,625.00) 22,477.20 25,910.00 (3,432.80) 202,181.00 179,703.80 11%5100639 GS-Discounts-Mdse (494.58) - (494.58) (5,121.58) - (5,121.58) - 5,121.58 0% Total Revenue Golf Shop 4,230.77 8,000.00 (3,769.23) 34,111.56 39,862.00 (5,750.44) 311,048.00 277,281.21 11%COS 5100150 COS-GS-Hard Goods 941.67 1,540.00 (598.33) 8,545.40 7,673.60 871.80 59,876.85 51,331.45 14%5100151 COS-GS-Soft Goods 986.61 2,860.00 (1,873.39) 8,925.53 14,250.50 (5,324.97) 111,199.55 102,274.02 8%5100152 COS-GS-Purchase Disc (526.40) (220.00) (306.40) (728.05) (1,096.00) 367.95 (8,554.00) (7,825.95) -9%5100220 COS-GS-Freight Merch 809.44 66.00 743.44 1,192.41 329.00 863.41 2,566.00 1,373.59 46%Cost of Sales - Golf Shop 2,211.32 4,246.00 (2,034.68) 17,935.29 21,157.10 (3,221.81) 165,088.40 147,153.11 11%Gross Profit 2,019.45 3,754.00 (1,734.55) 16,176.27 18,704.90 (2,528.63) 145,959.60 130,128.10 11%COS % 52.3% 53.1% 0.8% 52.6% 53.1% 0.5% 53.1% 53.1% 0%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group 2,402.29 2,317.00 85.29 9,609.16 8,275.00 1,334.16 26,811.00 17,201.84 36%6101325 Insurance-Workers Comp 501.70 341.00 160.70 1,870.41 1,647.00 223.41 5,663.00 3,792.59 33%6101720 Salaries 3,545.44 3,750.00 (204.56) 15,954.48 15,000.00 954.48 45,000.00 29,045.52 35%6101800 Taxes-Employer Payroll 711.45 888.00 (176.55) 3,323.29 4,291.00 (967.71) 14,758.00 11,434.71 23%6101880 Wages-Hourly 5,106.90 4,747.00 359.90 24,023.48 26,054.00 (2,030.52) 96,229.00 72,205.52 25%6101882 Wages-Overtime 73.88 - 73.88 705.23 - 705.23 - 952.88 0%Total -PS-SALARIES & BENEFITS 12,341.66 12,043.00 298.66 55,486.05 55,267.00 219.05 188,461.00 134,633.06 29%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office 227.93 500.00 (272.07) 519.67 2,000.00 (1,480.33) 6,000.00 5,480.33 9%6109090 Contract Services 500.00 500.00 - 2,000.00 2,000.00 - 6,000.00 4,000.00 33%6109220 Freight & Delivery - - - 77.35 - 77.35 75.00 (2.35) 103%6109490 Miscellaneous 328.00 - 328.00 1,105.78 - 1,105.78 450.00 (655.78) 246%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short 34.01 - 34.01 59.89 - 59.89 - (59.89) 0%6109722 Seminars/Training 1,066.25 500.00 566.25 2,316.25 3,150.00 (833.75) 5,890.00 3,573.75 39%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms 780.19 100.00 680.19 2,048.25 400.00 1,648.25 2,400.00 351.75 85%6117840 Telephones - 110.00 (110.00) 336.53 440.00 (103.47) 1,320.00 983.47 0%Total PS-OTHER EXPENSES 2,936.38 1,710.00 1,226.38 8,463.72 7,990.00 473.72 24,525.00 16,061.28 35%15,278.04 13,753.00 1,525.04 63,949.77 63,257.00 692.77 212,986.00 150,694.34 29%Net Income(13,258.59) (9,999.00) (3,259.59) (47,773.50) (44,552.10) (3,221.40) (67,026.40) (20,566.24) -69%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementOctober 20123 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 10,810.98 8,740.00 2,070.98 37,751.05 34,960.00 2,791.05 104,880.00 67,128.95 64.0%6311325 Insurance-Workers Comp 1,793.54 2,489.00 (695.46) 6,934.53 9,113.00 (2,178.47) 27,280.00 20,345.47 74.6%6311720 Salaries 14,001.60 11,001.60 3,000.00 49,507.20 44,006.40 5,500.80 150,996.00 101,488.80 67.2%6311800 Taxes-Employer Payroll 5,560.25 6,853.00 (1,292.75) 18,391.64 24,112.00 (5,720.36) 71,645.00 53,253.36 74.3%6311880 Wages-Hourly 46,835.34 44,054.40 2,780.94 184,779.91 176,217.60 8,562.31 518,654.00 333,874.09 64.4%6311882 Wages-Overtime 10,596.46 10,526.00 70.46 11,270.21 10,526.00 744.21 15,945.00 4,674.79 29.3%Total-CM-SALARIES & BENEFITS89,598.17 83,664.00 5,934.17 308,634.54 298,935.00 9,699.54 889,400.00 580,765.46 65.3%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 3,835.04 - 3,835.04 10,125.04 - 10,125.04 31,100.00 20,974.96 67.4%6313744 Fertilizer 15,488.22 22,100.00 (6,611.78) 55,737.14 67,100.00 (11,362.86) 114,500.00 58,762.86 51.3%6313745 Herbicides - - - 7,281.37 7,000.00 281.37 17,000.00 9,718.63 57.2%6313746 Flowers/Plants 323.25 250.00 73.25 323.25 1,250.00 (926.75) 3,050.00 2,726.75 89.4%6313748 Fuel-Gasoline 6,827.13 8,000.00 (1,172.87) 20,897.11 23,500.00 (2,602.89) 55,020.00 34,122.89 62.0%6313750 Golf Course Accessories 12,617.52 10,000.00 2,617.52 13,196.29 10,900.00 2,296.29 13,000.00 (196.29) -1.5%6313756 POA Control - - - 461.97 - 461.97 7,000.00 6,538.03 93.4%6313758 Miscellaneous Supp 460.68 500.00 (39.32) 2,934.49 2,750.00 184.49 4,350.00 1,415.51 0.0%6313762 Supplies-Office 385.41 - 385.41 486.72 - 486.72 - (486.72) 0.0%6313774 Sand 1,654.40 2,000.00 (345.60) 1,654.40 7,780.00 (6,125.60) 16,460.00 14,805.60 89.9%6313776 Seed 95,897.50 88,060.00 7,837.50 97,122.41 89,010.00 8,112.41 106,810.00 9,687.59 9.1%6313778 Small Tools & Non-Capital Equip 2,119.50 2,000.00 119.50 4,076.46 4,200.00 (123.54) 5,000.00 923.54 18.5%6313780 Sod - 250.00 (250.00) 6,767.37 3,250.00 3,517.37 7,950.00 1,182.63 14.9%6313782 Topdressing 3,628.17 2,500.00 1,128.17 5,164.46 5,000.00 164.46 7,600.00 2,435.54 32.0%Total-CM-SUPPLIES & MATERIALS143,236.82 135,660.00 7,576.82 226,228.48 221,740.00 4,488.48 388,840.00 162,611.52 41.8%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,830.00 2,600.00 230.00 11,320.00 10,400.00 920.00 31,200.00 19,880.00 63.7%6315685 CM-R&M-Bldngs & Othr Structures 98.27 500.00 (401.73) 548.13 3,050.00 (2,501.87) 5,550.00 5,001.87 90.1%6315690 CM-R&M-Equipment 9,101.85 9,000.00 101.85 21,284.84 14,000.00 7,284.84 31,000.00 9,715.16 31.3%6315692 CM-R&M-Irrigation System 917.07 2,000.00 (1,082.93) 7,827.25 15,000.00 (7,172.75) 22,650.00 14,822.75 65.4%6315696 CM-R&M-Pumps - 1,000.00 (1,000.00) 4,567.00 4,000.00 567.00 10,500.00 5,933.00 56.5%6315815 CM-R&M-Trees-Pruning Etc 4,800.00 550.00 4,250.00 7,500.00 4,050.00 3,450.00 10,050.00 2,550.00 25.4%Total-CM-REPAIRS & MAINTENANCE 17,747.19 15,650.00 2,097.19 53,047.22 50,500.00 2,547.22 110,950.00 57,902.78 52.2%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 21.27 15.00 6.27 86.81 60.00 26.81 180.00 93.19 0.0%6317840 Telephones 1,310.63 850.00 460.63 5,027.49 3,400.00 1,627.49 10,200.00 5,172.51 50.7%Total-CM-UTILITIES 1,331.90 865.00 466.90 5,114.30 3,460.00 1,654.30 10,380.00 5,265.70 50.7%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 2,000.00 2,000.00 - 6,000.00 4,000.00 66.7%6319100 Contract Svcs-Soil/Tissue Test - - - - 2,000.00 (2,000.00) 4,000.00 4,000.00 100.0%6319102 Contract Svcs-Trash Removal 1,077.48 524.00 553.48 2,617.66 2,096.00 521.66 6,288.00 3,670.34 0.0%6319150 Dues & Subscriptions - - - 210.00 - 210.00 540.00 330.00 61.1%6319170 Employee Education - 50.00 (50.00) - 200.00 (200.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental 579.13 1,800.00 (1,220.87) 579.13 2,300.00 (1,720.87) 4,200.00 3,620.87 86.2%6319206 Licenses & Permits - - - - 280.00 (280.00) 1,430.00 1,430.00 100.0%6319490 Miscellaneous 187.67 100.00 87.67 707.22 400.00 307.22 1,200.00 492.78 41.1%6319718 Safety Equipment & Training 388.75 800.00 (411.25) 1,352.19 1,850.00 (497.81) 3,850.00 2,497.81 64.9%6319822 Uniforms 1,010.49 920.00 90.49 3,876.86 3,680.00 196.86 11,040.00 7,163.14 64.9%Total-CM-OTHER EXPENSES 3,743.52 4,694.00 (950.48) 11,343.06 14,806.00 (3,462.94) 40,098.00 28,754.94 71.7%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementOctober 2012Annual Budget4 October 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) 9,614.28 10,592.00 (977.72) 31,776.00 22,161.72 69.7%6321325 Insurance-Workers Comp 640.93 607.00 33.93 2,389.48 2,181.00 208.48 6,361.00 3,971.52 62.4%6321800 Taxes-Employer Payroll 863.43 1,699.00 (835.57) 5,195.06 5,838.00 (642.94) 16,808.00 11,612.94 69.1%6321880 Wages-Hourly 10,269.01 12,880.00 (2,610.99) 51,722.26 51,520.00 202.26 154,560.00 102,837.74 66.5%6321882 Wages-Overtime 1,710.38 3,381.00 (1,670.62) 1,720.88 4,347.00 (2,626.12) 6,279.00 4,558.12 72.6%Total-CM-LM-SALARIES & BENEFITS15,332.65 21,215.00 (5,882.35) 70,641.96 74,478.00 (3,836.04) 215,784.00 145,142.04 67.3%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 100.00 (100.00) - 400.00 (400.00) 1,025.00 1,025.00 100.0%6323788 Uniforms 222.18 290.00 (67.82) 800.38 1,160.00 (359.62) 3,480.00 2,679.62 77.0%Total-CM-LM-SUPPLIES & MATERIALS222.18 390.00 (167.82) 800.38 1,560.00 (759.62) 4,505.00 3,704.62 82.2%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 500.00 (500.00) - 1,500.00 (1,500.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE - 500.00 (500.00) - 1,500.00 (1,500.00) 4,250.00 4,250.00 100.0%271,212.43 262,638.00 8,574.43 675,809.94 666,979.00 8,830.94 1,664,207.00 988,397.06 59.4% October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 13,394.53 11,450.00 1,944.53 60,642.10 51,750.00 8,892.10 178,691.00 118,048.90 66.1%6337842 Utilities-Water5,163.29 3,960.00 1,203.29 25,915.02 21,280.00 4,635.02 43,058.00 17,142.98 39.8%18,557.82 15,410.00 3,147.82 86,557.12 73,030.00 13,527.12 221,749.00 135,191.88 61.0%Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetSilverrock ResortCourse Maintenance Water & EnergyOctober 2012Total-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementOctober 2012Annual BudgetMonth to Date Year to Date5 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group 369.78 662.00 (292.22) 1,479.12 2,648.00 (1,168.88) 7,944.00 6,464.88 81.4%6411325 Insurance-Workers Comp 401.15 268.00 133.15 1,495.55 1,235.00 260.55 5,135.00 3,639.45 70.9%6411800 Taxes-Employer Payroll 532.70 831.00 (298.30) 3,501.77 3,833.00 (331.23) 15,942.00 12,440.23 78.0%6411880 Wages-Hourly 4,820.75 6,676.00 (1,855.25) 30,775.76 30,792.00 (16.24) 128,052.00 97,276.24 76.0%6411882 Wages-Overtime 351.19 - 351.19 474.39 - 474.39 - (474.39) 0.0%Total-CBR-SALARIES & BENEFITS6,475.57 8,437.00 (1,961.43) 37,726.59 38,508.00 (781.41) 157,073.00 119,346.41 76.0%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 335.64 500.00 (164.36) 671.83 500.00 171.83 2,350.00 1,678.17 71.4%6413742 Supplies-Expendable 404.07 150.00 254.07 3,307.44 1,500.00 1,807.44 6,750.00 3,442.56 51.0%6413748 Supplies-Fuel for Shuttle 71.86 100.00 (28.14) 71.86 200.00 (128.14) 3,000.00 2,928.14 97.6%6413752 Supplies-Range Balls - - - - - - 9,000.00 9,000.00 100.0%6413762 Supplies-Office - 50.00 (50.00) - 125.00 (125.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels 80.00 100.00 (20.00) 880.00 316.00 564.00 1,005.00 125.00 12.4%6413796 Supplies-Bottled Water9,189.30 12,000.00 (2,810.70) 9,757.17 12,150.00 (2,392.83) 24,500.00 14,742.83 60.2%Total-CBR-SUPPLIES & MATERIALS10,080.87 12,900.00 (2,819.13) 14,688.30 14,791.00 (102.70) 47,550.00 32,861.70 69.1%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment - 300.00 (300.00) 20.88 1,200.00 (1,179.12) 3,600.00 3,579.12 99.4%6415695 CBR-R&M-Cart Maintenance & Repair 571.79 750.00 (178.21) 2,073.33 3,000.00 (926.67) 9,750.00 7,676.67 78.7%Total-CBR-REPAIRS & MAINTENANCE 571.79 1,050.00 (478.21) 2,094.21 4,200.00 (2,105.79) 13,350.00 11,255.79 84.3%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 252.88 800.00 (547.12) 2,603.09 3,200.00 (596.91) 9,600.00 6,996.91 72.9%6419220 Freight/Delivery - 75.00 (75.00) - 300.00 (300.00) 450.00 450.00 100.0%6419490 Miscellaneous - 75.00 (75.00) 67.24 350.00 (282.76) 1,150.00 1,082.76 94.2%6419820 Uniforms 1,915.38 2,000.00 (84.62) 2,203.19 2,000.00 203.19 5,200.00 2,996.81 57.6%Total-CBR-OTHER EXPENSES 2,168.26 2,950.00 (781.74) 4,873.52 5,850.00 (976.48) 16,400.00 11,526.48 70.3%TOTAL-CARTS,BAGROOM & RANGE 19,296.49 25,337.00 (6,040.51) 59,382.62 63,349.00 (3,966.38) 234,373.00 174,990.38 74.7%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 358.70 64.00 294.70 1,337.29 422.00 915.29 1,903.00 565.71 29.7%6431800 Taxes-Employer Payroll 207.10 167.00 40.10 1,265.19 1,096.00 169.19 4,960.00 3,694.81 74.5%6431880 Wages-Hourly 1,794.00 1,600.00 194.00 10,798.00 10,500.00 298.00 47,460.00 36,662.00 77.2%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS2,359.80 1,831.00 528.80 13,400.48 12,018.00 1,382.48 54,323.00 40,922.52 75.3%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) - 300.00 (300.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous - 50.00 (50.00) 433.20 50.00 383.20 200.00 (233.20) -116.6%6439718 Safety Equipment & Training - 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6439820 Uniforms 1,114.00 800.00 314.00 1,114.00 1,025.00 89.00 2,125.00 1,011.00 47.6%Total-CS-OTHER EXPENSES 1,114.00 1,000.00 114.00 1,547.20 1,575.00 (27.80) 3,975.00 2,427.80 61.1%Total-COURSE SERVICES 3,473.80 2,831.00 642.80 14,947.68 13,593.00 1,354.68 58,298.00 43,350.32 74.4%22,770.29 28,168.00 (5,397.71) 74,330.30 76,942.00 (2,611.70) 292,671.00 215,912.90 73.8%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementOctober 2012Annual Budget6 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 1,264.00 1,600.00 (336.00) 4,800.00 3,536.00 73.7%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 1,264.00 1,600.00 (336.00) 4,800.00 3,536.00 73.7%65-CH-UTILITIES6507836 Utilities-Natural Gas42.75 300.00 (257.25) 42.75 1,200.00 (1,157.25) 3,600.00 3,557.25 98.8%6507840 Utilities-Telephone1,225.99 1,150.00 75.99 4,872.68 4,600.00 272.68 13,800.00 8,927.32 64.7%6507842 Utilities-Water316.24 321.00 (4.76) 1,574.18 1,284.00 290.18 3,852.00 2,277.82 59.1%6507844 Utilities-Cable336.91 340.00 (3.09) 1,347.64 1,360.00 (12.36) 4,080.00 2,732.36 67.0%Total-CH-UTILITIES 1,921.89 2,111.00 (189.11) 7,837.25 8,444.00 (606.75) 25,332.00 17,494.75 69.1%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 2,425.00 (600.00) 7,300.00 7,900.00 (600.00) 22,500.00 15,200.00 67.6%6509099 Contract Services-Security4,373.52 4,900.00 (526.48) 21,358.04 19,600.00 1,758.04 60,400.00 39,041.96 64.6%6509215 Flowers & Decorations- 500.00 (500.00) - 500.00 (500.00) 2,400.00 2,400.00 100.0%6509490 Miscellaneous206.21 200.00 6.21 206.21 800.00 (593.79) 2,400.00 2,193.79 91.4%6509718 Safety Equipment & Training- 100.00 (100.00) 121.12 400.00 (278.88) 1,200.00 1,078.88 89.9%Total-CH-OTHER EXPENSES 6,404.73 8,125.00 (1,720.27) 28,985.37 29,200.00 (214.63) 88,900.00 59,914.63 67.4%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures216.09 300.00 (83.91) 825.25 1,200.00 (374.75) 3,600.00 2,774.75 77.1%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 2,140.00 1,600.00 540.00 4,800.00 2,660.00 55.4%6515690 CH-R&M-Equipment Repair69.00 400.00 (331.00) 1,349.00 1,600.00 (251.00) 4,800.00 3,451.00 71.9%Total-CH-REPAIRS & MAINTENANCE 285.09 1,100.00 (814.91) 4,314.25 4,400.00 (85.75) 13,200.00 8,885.75 67.3%8,611.71 11,736.00 (3,124.29) 42,400.87 43,644.00 (1,243.13) 132,232.00 17,771.50 13.4%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementOctober 2012Annual Budget7 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 369.78 331.00 38.78 1,479.12 1,324.00 155.12 3,972.00 2,492.88 62.8%6601325 Insurance-Workers Comp 180.55 101.00 79.55 673.12 404.00 269.12 1,207.00 533.88 44.2%6601720 Salaries 2,111.72 2,508.00 (396.28) 9,583.07 10,032.00 (448.93) 30,096.00 20,512.93 68.2%6601800 Taxes-Employer Payroll 676.73 262.00 414.73 1,385.55 1,048.00 337.55 3,145.00 1,759.45 55.9%Total-MKT-SALARIES & BENEFITS 3,338.78 3,202.00 136.78 13,120.86 12,808.00 312.86 38,420.00 25,299.14 65.8%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 400.00 (400.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery 2,165.24 3,000.00 (834.76) 3,098.61 3,200.00 (101.39) 4,425.00 1,326.39 30.0%2,165.24 3,100.00 (934.76) 3,098.61 3,600.00 (501.39) 5,625.00 2,526.39 44.9%66-MKT-UTILITIES6607840 Utilities-Telephone 105.83 100.00 5.83 422.32 400.00 22.32 1,200.00 777.68 64.8%Total-MKT-UTILITIES 105.83 100.00 5.83 422.32 400.00 22.32 1,200.00 777.68 64.8%66-MKT-OTHER EXPENSES6609010 Advertising 4,785.81 8,822.00 (4,036.19) 37,906.93 46,753.00 (8,846.07) 179,231.00 141,324.07 78.9%6609040 Business Meals - - - - - - 300.00 300.00 100.0%6609080 Collateral Material - 2,500.00 (2,500.00) - 2,500.00 (2,500.00) 9,000.00 9,000.00 100.0%6609102 Contract Services-Web Page 198.00 300.00 (102.00) 297.00 1,200.00 (903.00) 3,600.00 3,303.00 91.8%6609490 Miscellaneous - - - - - - 350.00 350.00 100.0%6609620 Postage 11.81 50.00 (38.19) 19.82 200.00 (180.18) 600.00 580.18 96.7%6609630 Promotion - 25.00 (25.00) 104.43 100.00 4.43 3,000.00 2,895.57 0.0%6609633 Promotion-Community - 125.00 (125.00) 278.80 350.00 (71.20) 2,250.00 1,971.20 87.6%6609634 Promotion-Media/Vendor - 500.00 (500.00) - 1,000.00 (1,000.00) 700.00 - 0.0%6609150 Dues and Subscriptions - - - 100.00 - 100.00 735.00 635.00 86.4%6609820 Uniforms - 300.00 (300.00) - 300.00 (300.00) 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 4,995.62 12,622.00 (7,626.38) 38,706.98 52,403.00 (13,696.02) 200,366.00 160,959.02 80.3%10,605.47 19,024.00 (8,418.53) 55,348.77 69,211.00 (13,862.23) 245,611.00 189,562.23 77.2%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementOctober 2012Annual Budget8 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,802.11 1,458.00 344.11 7,064.70 5,832.00 1,232.70 17,496.00 10,431.30 59.6%6701325 Insurance-Workers Comp602.40 688.00 (85.60) 2,245.83 2,752.00 (506.17) 8,254.00 6,008.17 72.8%6701720 Salaries 16,416.26 15,003.00 1,413.26 60,373.17 60,012.00 361.17 178,000.00 117,626.83 66.1%6701800 Taxes-Employer Payroll 1,186.27 1,792.00 (605.73) 5,080.30 7,168.00 (2,087.70) 21,510.00 16,429.70 76.4%6701880 Wages-Hourly2,090.64 2,150.00 (59.36) 6,025.76 8,600.00 (2,574.24) 27,835.00 21,809.24 78.4%6701882 Wages-Overtime - - - 10.88 - 10.88 - (10.88) 0.0%Total-G&A-SALARIES & BENEFITS 22,097.68 21,091.00 1,006.68 80,800.64 84,364.00 (3,563.36) 253,095.00 172,294.36 68.1%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 400.00 (400.00) 184.00 1,600.00 (1,416.00) 5,200.00 5,016.00 96.5%6703762 Supplies-Office 121.67 100.00 21.67 505.92 400.00 105.92 1,200.00 694.08 57.8%6703768 Supplies-Printing & Stationery653.84 100.00 553.84 653.84 400.00 253.84 3,300.00 2,646.16 80.2%Total-G&A-SUPPLIES & MATERIALS 775.51 600.00 175.51 1,343.76 2,400.00 (1,056.24) 9,700.00 8,356.24 86.1%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) - 300.00 (300.00) 1,100.00 1,100.00 100.0%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) - 300.00 (300.00) 1,100.00 1,100.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7%6709150 Dues & Subscriptions- 50.00 (50.00) 165.00 300.00 (135.00) 1,700.00 1,535.00 90.3%6709180 Employee Recruiting/Relocation1,312.60 200.00 1,112.60 1,402.60 400.00 1,002.60 1,400.00 (2.60) -0.2%6709197 Equipment Rental1,205.91 480.00 725.91 2,999.85 1,920.00 1,079.85 5,760.00 2,760.15 47.9%6709202 Fees-Bank123.86 90.00 33.86 462.04 360.00 102.04 1,080.00 617.96 57.2%6709208 Fees-Payroll Processing1,104.56 1,100.00 4.56 4,789.69 4,400.00 389.69 13,200.00 8,410.31 63.7%6709220 Freight/Delivery- 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6709490 Miscellaneous - 100.00 (100.00) 77.33 400.00 (322.67) 1,200.00 1,122.67 93.6%6709620 Postage/Mail Services 89.18 75.00 14.18 499.83 300.00 199.83 900.00 400.17 44.5%6709625 Professional Fees1,568.75 850.00 718.75 4,195.00 3,400.00 795.00 10,200.00 6,005.00 58.9%6709636 Promotion/Entertainment- 100.00 (100.00) - 400.00 (400.00) 3,100.00 3,100.00 100.0%6709722 Seminars & Training- 200.00 (200.00) 250.00 800.00 (550.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 138.71 150.00 (11.29) 284.41 375.00 (90.59) 1,050.00 765.59 72.9%Total-G&A-OTHER EXPENSES 5,943.57 3,845.00 2,098.57 16,725.75 14,955.00 1,770.75 48,490.00 31,764.25 65.5%28,816.76 25,636.00 3,180.76 98,870.15 102,019.00 (3,148.85) 312,385.00 213,514.85 68.3%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementOctober 2012Annual Budget9 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 12,884.87 12,075.00 809.87 47,953.00 48,300.00 (347.00) 144,900.00 96,947.00 66.9%6800194 Equipment Leases-Trailer 260.00 600.00 (340.00) 1,767.62 2,400.00 (632.38) 7,200.00 5,432.38 75.4%6800196 Equipment Leases-GPS 4,940.00 5,755.00 (815.00) 19,760.00 23,020.00 (3,260.00) 69,060.00 49,300.00 71.4%6800197 Equipment Leases-Others 368.04 460.00 (91.96) 2,953.42 1,840.00 1,113.42 5,520.00 2,566.58 0.0%18,452.91 18,890.00 (437.09) 72,434.04 75,560.00 (3,125.96) 226,680.00 154,245.96 68.0%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 16,940.02 23,065.00 (6,124.98) 77,542.29 82,767.00 (5,224.71) 90,000.00 12,457.71 13.8%6900210 FF&E Reserve 1,161.05 1,143.00 18.05 7,074.29 7,720.00 (645.71) 67,015.00 59,940.71 89.4%6900800 Personal Property Taxes 382.85 9,600.00 (9,217.15) 11,141.90 14,800.00 (3,658.10) 14,800.00 3,658.10 24.7%6900323 Insurance-Commercial 10,144.70 2,200.00 7,944.70 12,619.77 8,800.00 3,819.77 26,400.00 13,780.23 52.2%28,628.62 36,008.00 (7,379.38) 108,378.25 114,087.00 (5,708.75) 198,215.00 89,836.75 45.3%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementOctober 201210 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2012-20132012 2012 2012 2012 2012 2012Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia342SalesPromotionGolf IndustryVIPCelebrityPGA Comp62 16 46 15Charity/Gift Certificate61511Rain/Wind Checks5Club Staff129 60 81 13LQ HS Golf812213 95 152 28 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-2013October 2012 Date Time Description CategoryPlayers12