Loading...
05 November 2012 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2012 – November 2012 TABLE OF CONTENTS Summary Operating Income Expense 1 Variance Report 2 Statement of Fee Revenue 3 Golf Shop Income Statement 4 Course Maintenance Expense Statement 5 Outside Service Expense Statement 7 Clubhouse Expense Statement 8 Marketing Expense Statement 9 General & Administrative Expense Statement 10 Operating Leases & Miscellaneous Expense Statement 12 Annual BudgetAccount Description November Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue290,314.41 318,591.00 (28,276.59) -8.9% 644,028.23 704,616.00 (60,587.77) 3,350,773.00 2,706,744.77 19%401000 Miscellaneous Golf Revenue 37,697.00 15,275.00 22,422.00 146.8% 54,101.90 37,300.00 16,801.90 159,973.00 105,871.10 34%410000 Revenue-Golf Shop 26,697.94 27,625.00 (927.06) -3.4% 60,809.50 67,487.00 (6,677.50) 311,048.00 250,238.50 20%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0% 4,500.00 4,500.00 - 12,000.00 7,500.00 38%890000 Interest Income0.71 - 0.71 0.0% 3.68 - 3.68 - (3.68) 0%Total Income356,210.06 362,991.00 (6,780.94) -1.9% 763,443.31 813,903.00 (50,459.69) 3,833,794.00 3,070,350.69 20%Cost of Goods Sold510000 COS-Golf Shop 14,064.61 14,661.75 (597.14) 4.1% 31,999.90 35,818.85 3,818.95 165,088.40 133,088.50 19%Total COS14,064.61 14,661.75 (597.14) 4.1% 31,999.90 35,818.85 3,818.95 165,088.40 133,088.50 19%Gross Profit342,145.45 348,329.25 (6,183.80) -1.8% 731,443.41 778,084.15 (46,640.74) 3,668,705.60 2,937,262.19 20%Expenses610000 Golf Pro Shop 17,900.90 18,405.00 504.10 2.7% 81,850.67 81,737.00 (113.67) 212,986.00 131,135.33 38%630000 Course Maintenance138,483.32 155,489.00 17,005.68 10.9% 814,293.26 822,468.00 8,174.74 1,664,207.00 849,913.74 49%633000 Maintenance Water & Energy13,426.91 15,905.00 2,478.09 15.6% 99,984.03 88,935.00 (11,049.03) 221,749.00 121,764.97 45%640000 Outside Services31,031.51 32,543.00 1,511.49 4.6% 105,361.81 110,235.00 4,873.19 292,671.00 187,309.19 36%650000 Clubhouse 10,143.03 10,636.00 492.97 4.6% 52,468.90 54,280.00 1,811.10 132,232.00 79,763.10 40%660000 Marketing 27,568.62 26,057.00 (1,511.62) -5.8% 82,917.39 95,268.00 12,350.61 245,611.00 162,693.61 34%670000 General & Administrative25,341.78 25,636.00 294.22 1.1% 125,604.51 127,655.00 2,050.49 312,385.00 186,780.49 40%680000 Leases 17,489.69 18,890.00 1,400.31 7.4% 89,923.73 94,450.00 4,526.27 226,680.00 136,756.27 40%690000 Miscellaneous Other Expense3,769.77 3,119.00 (650.77) -20.9% 112,148.02 117,206.00 5,057.98 198,215.00 86,066.98 57%Total Expenses285,155.53 306,680.00 21,524.47 7.0% 1,564,552.32 1,592,234.00 27,681.68 3,506,736.00 1,942,183.68 45%56,989.92 41,649.25 15,340.67 36.8%(833,108.91) (814,149.85) (18,959.06) 161,969.60 995,078.51 -514%Rounds of Golf PlayedPaid Rounds Played 4,271 4,250 21 0.5% 13,278 13,500 (222) 45,625 32,347 29%Ave $ Per Paid Round Green Fee67.97 74.96 (6.99) -9.3% 48.50 52.19 (3.69) 73.44 24.94 66%Ave $ Per Paid Round Merchandise6.25 6.50 (0.25) -3.8% 4.58 5.00 (0.42) 6.82 2.24 67%Ave $ Per Paid Miscellaneous 8.83 3.59 5.23 145.6% 4.07 2.76 1.31 3.51 (0.57) 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateNovember 20121 Income November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 290,314.41 318,591.00 (28,276.59) 644,028.23 704,616.00 (60,587.77) 3,350,773.002,706,744.7719%4010000 Rider Fee 950.00 425.00 525.00 3,295.00 1,350.00 1,945.00 7,643.004,348.0043%4040000 Club Rental 1,640.00 2,125.00 (485.00) 5,400.00 6,750.00 (1,350.00) 23,325.0017,925.0023%4050000 Driving Range 8,752.00 7,225.00 1,527.00 16,556.00 21,300.00 (4,744.00) 85,405.0068,849.0019%4060000 Handicap Fees - - - - - - 0.000.000%4080000 GPS Advertising - 500.00 (500.00) - 900.00 (900.00) 2,600.00 2,600.000%4090000 Ball Retriever/Subcontract - - - 2,495.90 2,000.00 495.90 4,000.00 1,504.1062%4091000 Golf Professional Rental Fee 4,800.00 5,000.00 (200.00) 4,800.00 5,000.00 (200.00) 37,000.00 32,200.00 13%4092000 Golf Lessons - - - - - - - - 0%4093000 Resident Card Issue 21,555.00 - 21,555.00 21,555.00 - 21,555.00 - - 0% Total Revenue Fees 328,011.41 333,866.00 (5,854.59) 698,130.13 741,916.00 (43,785.87) 3,510,746.00 2,834,170.87 19%328,011.41 333,866.00 (5,854.59) 698,130.13 741,916.00 (43,785.87) 3,510,746.00 2,834,170.87 19%Total IncomeMonth to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueNovember 20122 Income November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 127.73 - 127.73 472.50 - 472.50 0 0 0%4100110 Sales Hard Goods 8,654.55 9,669.00 (1,014.45) 25,065.72 23,621.00 1,444.72 108,867.00 83,801.28 23%4100112 Sales-Soft Goods 22,708.00 17,956.00 4,752.00 45,185.20 43,866.00 1,319.20 202,181.00 156,995.80 22%5100639 GS-Discounts-Mdse (4,792.34) - (4,792.34) (9,913.92) - (9,913.92) - 9,913.92 0% Total Revenue Golf Shop 26,697.94 27,625.00 (927.06) 60,809.50 67,487.00 (6,677.50) 311,048.00 250,711.00 19%COS 5100150 COS-GS-Hard Goods 3,980.38 5,317.95 (1,337.57) 12,525.78 12,991.55 (465.77) 59,876.85 47,351.07 21%5100151 COS-GS-Soft Goods 9,943.16 9,875.80 67.36 18,868.69 24,126.30 (5,257.61) 111,199.55 92,330.86 17%5100152 COS-GS-Purchase Disc (378.42) (760.00) 381.58 (1,106.47) (1,856.00) 749.53 (8,554.00) (7,447.53) -13%5100220 COS-GS-Freight Merch 519.49 228.00 291.49 1,711.90 557.00 1,154.90 2,566.00 854.10 67%Cost of Sales - Golf Shop 14,064.61 14,661.75 (597.14) 31,999.90 35,818.85 (3,818.95) 165,088.40 133,088.50 19%Gross Profit 12,633.33 12,963.25 (329.92) 28,809.60 31,668.15 (2,858.55) 145,959.60 117,622.50 19%COS % 52.7% 53.1% 0.4% 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 12,011.45 10,592.00 1,419.45 26,811.00 14,799.55 45%6101325 Insurance-Workers Comp 309.05 512.00 (202.95) 2,179.46 2,159.00 20.46 5,663.00 3,483.54 38%6101720 Salaries 3,545.44 3,750.00 (204.56) 19,499.92 18,750.00 749.92 45,000.00 25,500.08 43%6101800 Taxes-Employer Payroll 1,127.73 1,333.00 (205.27) 4,451.02 5,624.00 (1,172.98) 14,758.00 10,306.98 30%6101880 Wages-Hourly 9,170.99 9,008.00 162.99 33,194.47 35,062.00 (1,867.53) 96,229.00 63,034.53 34%6101882 Wages-Overtime 145.31 - 145.31 850.54 - 850.54 - 952.88 0%Total -PS-SALARIES & BENEFITS 16,700.81 16,920.00 (219.19) 72,186.86 72,187.00 (0.14) 188,461.00 118,077.56 37%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - - - - - - 0%6103762 Supplies-Office - 500.00 (500.00) 519.67 2,500.00 (1,980.33) 6,000.00 5,480.33 9%6109090 Contract Services 500.00 500.00 - 2,500.00 2,500.00 - 6,000.00 3,500.00 42%6109220 Freight & Delivery - 25.00 (25.00) 77.35 50.00 27.35 75.00 (2.35) 103%6109490 Miscellaneous - 50.00 (50.00) 1,105.78 100.00 1,005.78 450.00 (655.78) 246%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short (24.24) - (24.24) 35.65 - 35.65 - (35.65) 0%6109722 Seminars/Training - - - 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 616.49 300.00 316.49 2,664.74 700.00 1,964.74 2,400.00 (264.74) 111%6117840 Telephones 107.84 110.00 (2.16) 444.37 550.00 (105.63) 1,320.00 875.63 0%Total PS-OTHER EXPENSES 1,200.09 1,485.00 (284.91) 9,663.81 9,550.00 113.81 24,525.00 14,861.19 39%17,900.90 18,405.00 (504.10) 81,850.67 81,737.00 113.67 212,986.00 132,938.75 38%Net Income(5,267.57) (5,441.75) 174.18 (53,041.07) (50,068.85) (2,972.22) (67,026.40) (15,316.25) -77%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementNovember 20123 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group 9,810.98 8,740.00 1,070.98 47,562.03 43,700.00 3,862.03 104,880.00 57,317.97 54.7%6311325 Insurance-Workers Comp 1,590.20 2,208.00 (617.80) 8,524.73 11,321.00 (2,796.27) 27,280.00 18,755.27 68.8%6311720 Salaries 11,001.60 11,001.60 - 60,508.80 55,008.00 5,500.80 150,996.00 90,487.20 59.9%6311800 Taxes-Employer Payroll 5,697.08 5,753.00 (55.92) 24,088.72 29,865.00 (5,776.28) 71,645.00 47,556.28 66.4%6311880 Wages-Hourly 46,945.10 44,054.40 2,890.70 231,725.01 220,272.00 11,453.01 518,654.00 286,928.99 55.3%6311882 Wages-Overtime 46.99 - 46.99 11,317.20 10,526.00 791.20 15,945.00 4,627.80 29.0%Total-CM-SALARIES & BENEFITS75,091.95 71,757.00 3,334.95 383,726.49 370,692.00 13,034.49 889,400.00 505,673.51 56.9%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 2,700.71 - 2,700.71 12,825.75 - 12,825.75 31,100.00 18,274.25 58.8%6313744 Fertilizer 10,798.75 12,900.00 (2,101.25) 66,535.89 80,000.00 (13,464.11) 114,500.00 47,964.11 41.9%6313745 Herbicides 5,000.00 5,000.00 - 12,281.37 12,000.00 281.37 17,000.00 4,718.63 27.8%6313746 Flowers/Plants - - - 323.25 1,250.00 (926.75) 3,050.00 2,726.75 89.4%6313748 Fuel-Gasoline 3,888.40 5,500.00 (1,611.60) 24,785.51 29,000.00 (4,214.49) 55,020.00 30,234.49 55.0%6313750 Golf Course Accessories 82.32 200.00 (117.68) 13,278.61 11,100.00 2,178.61 13,000.00 (278.61) -2.1%6313756 POA Control 3,900.77 3,500.00 400.77 4,362.74 3,500.00 862.74 7,000.00 2,637.26 37.7%6313758 Miscellaneous Supp 746.25 500.00 246.25 3,680.74 3,250.00 430.74 4,350.00 669.26 0.0%6313762 Supplies-Office - - - 486.72 - 486.72 - (486.72) 0.0%6313774 Sand 4,211.67 7,000.00 (2,788.33) 5,866.07 14,780.00 (8,913.93) 16,460.00 10,593.93 64.4%6313776 Seed - 15,350.00 (15,350.00) 97,122.41 104,360.00 (7,237.59) 106,810.00 9,687.59 9.1%6313778 Small Tools & Non-Capital Equip 116.36 100.00 16.36 4,192.82 4,300.00 (107.18) 5,000.00 807.18 16.1%6313780 Sod - 3,250.00 (3,250.00) 6,767.37 6,500.00 267.37 7,950.00 1,182.63 14.9%6313782 Topdressing 1,862.18 - 1,862.18 7,026.64 5,000.00 2,026.64 7,600.00 573.36 7.5%Total-CM-SUPPLIES & MATERIALS33,307.41 53,300.00 (19,992.59) 259,535.89 275,040.00 (15,504.11) 388,840.00 129,304.11 33.3%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,830.00 2,600.00 230.00 14,150.00 13,000.00 1,150.00 31,200.00 17,050.00 54.6%6315685 CM-R&M-Bldngs & Othr Structures 98.27 500.00 (401.73) 646.40 3,550.00 (2,903.60) 5,550.00 4,903.60 88.4%6315690 CM-R&M-Equipment 3,329.78 2,000.00 1,329.78 24,614.62 16,000.00 8,614.62 31,000.00 6,385.38 20.6%6315692 CM-R&M-Irrigation System 1,046.24 900.00 146.24 8,873.49 15,900.00 (7,026.51) 22,650.00 13,776.51 60.8%6315696 CM-R&M-Pumps 324.81 1,000.00 (675.19) 4,891.81 5,000.00 (108.19) 10,500.00 5,608.19 53.4%6315815 CM-R&M-Trees-Pruning Etc - - - 7,500.00 4,050.00 3,450.00 10,050.00 2,550.00 25.4%Total-CM-REPAIRS & MAINTENANCE 7,629.10 7,000.00 629.10 60,676.32 57,500.00 3,176.32 110,950.00 50,273.68 45.3%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 24.84 15.00 9.84 111.65 75.00 36.65 180.00 68.35 0.0%6317840 Telephones 1,092.81 850.00 242.81 6,120.30 4,250.00 1,870.30 10,200.00 4,079.70 40.0%Total-CM-UTILITIES 1,117.65 865.00 252.65 6,231.95 4,325.00 1,906.95 10,380.00 4,148.05 40.0%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 2,500.00 2,500.00 - 6,000.00 3,500.00 58.3%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,754.96 524.00 1,230.96 4,372.62 2,620.00 1,752.62 6,288.00 1,915.38 0.0%6319150 Dues & Subscriptions - - - 210.00 - 210.00 540.00 330.00 61.1%6319170 Employee Education - 50.00 (50.00) - 250.00 (250.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental - 600.00 (600.00) 579.13 2,900.00 (2,320.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 523.34 100.00 423.34 1,230.56 500.00 730.56 1,200.00 (30.56) -2.5%6319718 Safety Equipment & Training 488.01 500.00 (11.99) 1,840.20 2,350.00 (509.80) 3,850.00 2,009.80 52.2%6319822 Uniforms 2,432.95 920.00 1,512.95 6,309.81 4,600.00 1,709.81 11,040.00 4,730.19 42.8%Total-CM-OTHER EXPENSES 5,699.26 3,194.00 2,505.26 17,042.32 18,000.00 (957.68) 40,098.00 23,055.68 57.5%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementNovember 2012Annual Budget4 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,448.90 2,648.00 (1,199.10) 11,063.18 13,240.00 (2,176.82) 31,776.00 20,712.82 65.2%6321325 Insurance-Workers Comp 502.06 542.00 (39.94) 2,891.54 2,723.00 168.54 6,361.00 3,469.46 54.5%6321800 Taxes-Employer Payroll 1,142.90 1,447.00 (304.10) 6,337.96 7,285.00 (947.04) 16,808.00 10,470.04 62.3%6321880 Wages-Hourly 12,006.58 12,880.00 (873.42) 63,728.84 64,400.00 (671.16) 154,560.00 90,831.16 58.8%6321882 Wages-Overtime 4.03 966.00 (961.97) 1,724.91 5,313.00 (3,588.09) 6,279.00 4,554.09 72.5%Total-CM-LM-SALARIES & BENEFITS15,104.47 18,483.00 (3,378.53) 85,746.43 92,961.00 (7,214.57) 215,784.00 130,037.57 60.3%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 100.00 (100.00) - 500.00 (500.00) 1,025.00 1,025.00 100.0%6323788 Uniforms 533.48 290.00 243.48 1,333.86 1,450.00 (116.14) 3,480.00 2,146.14 61.7%Total-CM-LM-SUPPLIES & MATERIALS533.48 390.00 143.48 1,333.86 1,950.00 (616.14) 4,505.00 3,171.14 70.4%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 500.00 (500.00) - 2,000.00 (2,000.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE - 500.00 (500.00) - 2,000.00 (2,000.00) 4,250.00 4,250.00 100.0%138,483.32 155,489.00 (17,005.68) 814,293.26 822,468.00 (8,174.74) 1,664,207.00 849,913.74 51.1% November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 9,132.68 12,650.00 (3,517.32) 69,774.78 64,400.00 5,374.78 178,691.00 108,916.22 61.0%6337842 Utilities-Water4,294.23 3,255.00 1,039.23 30,209.25 24,535.00 5,674.25 43,058.00 12,848.75 29.8%13,426.91 15,905.00 (2,478.09) 99,984.03 88,935.00 11,049.03 221,749.00 121,764.97 54.9%Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetSilverrock ResortCourse Maintenance Water & EnergyNovember 2012Total-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementNovember 2012Annual BudgetMonth to Date Year to Date5 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group 369.78 662.00 (292.22) 1,848.90 3,310.00 (1,461.10) 7,944.00 6,095.10 76.7%6411325 Insurance-Workers Comp 207.04 410.00 (202.96) 1,702.59 1,645.00 57.59 5,135.00 3,432.41 66.8%6411800 Taxes-Employer Payroll 1,189.52 1,274.00 (84.48) 4,691.29 5,107.00 (415.71) 15,942.00 11,250.71 70.6%6411880 Wages-Hourly 10,813.98 10,230.00 583.98 41,589.74 41,022.00 567.74 128,052.00 86,462.26 67.5%6411882 Wages-Overtime 69.19 - 69.19 543.58 - 543.58 - (543.58) 0.0%Total-CBR-SALARIES & BENEFITS12,649.51 12,576.00 73.51 50,376.10 51,084.00 (707.90) 157,073.00 106,696.90 67.9%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 1,000.00 (1,000.00) 671.83 1,500.00 (828.17) 2,350.00 1,678.17 71.4%6413742 Supplies-Expendable 1,580.55 1,800.00 (219.45) 4,887.99 3,300.00 1,587.99 6,750.00 1,862.01 27.6%6413748 Supplies-Fuel for Shuttle 230.95 300.00 (69.05) 302.81 500.00 (197.19) 3,000.00 2,697.19 89.9%6413752 Supplies-Range Balls 9,177.75 9,000.00 177.75 9,177.75 9,000.00 177.75 9,000.00 (177.75) -2.0%6413762 Supplies-Office - 50.00 (50.00) - 175.00 (175.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels 400.00 185.00 215.00 1,280.00 501.00 779.00 1,005.00 (275.00) -27.4%6413796 Supplies-Bottled Water29.90 50.00 (20.10) 9,787.07 12,200.00 (2,412.93) 24,500.00 14,712.93 60.1%Total-CBR-SUPPLIES & MATERIALS11,419.15 12,385.00 (965.85) 26,107.45 27,176.00 (1,068.55) 47,550.00 21,442.55 45.1%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment 37.66 300.00 (262.34) 58.54 1,500.00 (1,441.46) 3,600.00 3,541.46 98.4%6415695 CBR-R&M-Cart Maintenance & Repair 247.94 750.00 (502.06) 2,321.27 4,500.00 (2,178.73) 9,750.00 7,428.73 76.2%Total-CBR-REPAIRS & MAINTENANCE 285.60 1,050.00 (764.40) 2,379.81 6,000.00 (3,620.19) 13,350.00 10,970.19 82.2%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 1,255.76 800.00 455.76 3,858.85 4,000.00 (141.15) 9,600.00 5,741.15 59.8%6419220 Freight/Delivery - 75.00 (75.00) - 375.00 (375.00) 450.00 450.00 100.0%6419490 Miscellaneous - 75.00 (75.00) 67.24 425.00 (357.76) 1,150.00 1,082.76 94.2%6419820 Uniforms 114.20 500.00 (385.80) 2,317.39 2,500.00 (182.61) 5,200.00 2,882.61 55.4%Total-CBR-OTHER EXPENSES 1,369.96 1,450.00 (80.04) 6,243.48 7,300.00 (1,056.52) 16,400.00 10,156.52 61.9%TOTAL-CARTS,BAGROOM & RANGE 25,724.22 27,461.00 (1,736.78) 85,106.84 91,560.00 (6,453.16) 234,373.00 149,266.16 63.7%643-CS-SALARIES & BENEFITS6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 101.90 168.00 (66.10) 1,439.19 590.00 849.19 1,903.00 463.81 24.4%6431800 Taxes-Employer Payroll 443.58 439.00 4.58 1,708.77 1,535.00 173.77 4,960.00 3,251.23 65.5%6431880 Wages-Hourly 3,856.00 4,200.00 (344.00) 14,654.00 14,700.00 (46.00) 47,460.00 32,806.00 69.1%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS4,401.48 4,807.00 (405.52) 17,801.96 16,825.00 976.96 54,323.00 36,521.04 67.2%643-CS-OTHER EXPENSES6433742 Supplies Expendable 691.76 100.00 591.76 691.76 400.00 291.76 1,050.00 358.24 34.1%6439490 Miscellaneous 214.05 50.00 164.05 647.25 100.00 547.25 200.00 (447.25) -223.6%6439718 Safety Equipment & Training - 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0%6439820 Uniforms - 75.00 (75.00) 1,114.00 1,100.00 14.00 2,125.00 1,011.00 47.6%Total-CS-OTHER EXPENSES 905.81 275.00 630.81 2,453.01 1,850.00 603.01 3,975.00 1,521.99 38.3%Total-COURSE SERVICES 5,307.29 5,082.00 225.29 20,254.97 18,675.00 1,579.97 58,298.00 38,043.03 65.3%31,031.51 32,543.00 (1,511.49) 105,361.81 110,235.00 (4,873.19) 292,671.00 185,787.20 63.5%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementNovember 2012Annual Budget6 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 1,264.00 2,000.00 (736.00) 4,800.00 3,536.00 73.7%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 1,264.00 2,000.00 (736.00) 4,800.00 3,536.00 73.7%65-CH-UTILITIES6507836 Utilities-Natural Gas265.85 300.00 (34.15) 308.60 1,500.00 (1,191.40) 3,600.00 3,291.40 91.4%6507840 Utilities-Telephone1,203.50 1,150.00 53.50 6,076.18 5,750.00 326.18 13,800.00 7,723.82 56.0%6507842 Utilities-Water153.78 321.00 (167.22) 1,727.96 1,605.00 122.96 3,852.00 2,124.04 55.1%6507844 Utilities-Cable336.91 340.00 (3.09) 1,684.55 1,700.00 (15.45) 4,080.00 2,395.45 58.7%Total-CH-UTILITIES 1,960.04 2,111.00 (150.96) 9,797.29 10,555.00 (757.71) 25,332.00 15,534.71 61.3%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,900.00 1,825.00 75.00 9,125.00 9,725.00 (600.00) 22,500.00 13,375.00 59.4%6509099 Contract Services-Security4,565.04 4,900.00 (334.96) 25,923.08 24,500.00 1,423.08 60,400.00 34,476.92 57.1%6509215 Flowers & Decorations98.89 - 98.89 98.89 500.00 (401.11) 2,400.00 2,301.11 95.9%6509490 Miscellaneous- 200.00 (200.00) 206.21 1,000.00 (793.79) 2,400.00 2,193.79 91.4%6509718 Safety Equipment & Training- 100.00 (100.00) 121.12 500.00 (378.88) 1,200.00 1,078.88 89.9%Total-CH-OTHER EXPENSES 6,563.93 7,025.00 (461.07) 35,474.30 36,225.00 (750.70) 88,900.00 53,425.70 60.1%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures216.09 300.00 (83.91) 1,041.34 1,500.00 (458.66) 3,600.00 2,558.66 71.1%6515686 CH-R&M-Restaurant Repairs878.00 400.00 478.00 3,018.00 2,000.00 1,018.00 4,800.00 1,782.00 37.1%6515690 CH-R&M-Equipment Repair524.97 400.00 124.97 1,873.97 2,000.00 (126.03) 4,800.00 2,926.03 61.0%Total-CH-REPAIRS & MAINTENANCE 1,619.06 1,100.00 519.06 5,933.31 5,500.00 433.31 13,200.00 7,266.69 55.1%10,143.03 10,636.00 (492.97) 52,468.90 54,280.00 (1,811.10) 132,232.00 14,533.38 11.0%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementNovember 2012Annual Budget7 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 369.78 331.00 38.78 1,848.90 1,655.00 193.90 3,972.00 2,123.10 53.5%6601325 Insurance-Workers Comp 87.02 101.00 (13.98) 760.14 505.00 255.14 1,207.00 446.86 37.0%6601720 Salaries 2,669.00 2,508.00 161.00 12,252.07 12,540.00 (287.93) 30,096.00 17,843.93 59.3%6601800 Taxes-Employer Payroll 239.70 262.00 (22.30) 1,625.25 1,310.00 315.25 3,145.00 1,519.75 48.3%Total-MKT-SALARIES & BENEFITS 3,365.50 3,202.00 163.50 16,486.36 16,010.00 476.36 38,420.00 21,933.64 57.1%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 500.00 (500.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery 308.40 200.00 108.40 3,407.01 3,400.00 7.01 4,425.00 1,017.99 23.0%308.40 300.00 8.40 3,407.01 3,900.00 (492.99) 5,625.00 2,217.99 39.4%66-MKT-UTILITIES6607840 Utilities-Telephone 105.60 100.00 5.60 527.92 500.00 27.92 1,200.00 672.08 56.0%Total-MKT-UTILITIES 105.60 100.00 5.60 527.92 500.00 27.92 1,200.00 672.08 56.0%66-MKT-OTHER EXPENSES6609010 Advertising 23,428.12 19,680.00 3,748.12 61,335.05 66,433.00 (5,097.95) 179,231.00 117,895.95 65.8%6609040 Business Meals - - - - - - 300.00 300.00 100.0%6609080 Collateral Material 262.00 1,000.00 (738.00) 262.00 3,500.00 (3,238.00) 9,000.00 8,738.00 97.1%6609102 Contract Services-Web Page 99.00 300.00 (201.00) 396.00 1,500.00 (1,104.00) 3,600.00 3,204.00 89.0%6609490 Miscellaneous - 50.00 (50.00) - 50.00 (50.00) 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) 19.82 250.00 (230.18) 600.00 580.18 96.7%6609630 Promotion - 25.00 (25.00) 104.43 125.00 (20.57) 3,000.00 2,895.57 0.0%6609633 Promotion-Community - 800.00 (800.00) 278.80 1,150.00 (871.20) 2,250.00 1,971.20 87.6%6609634 Promotion-Media/Vendor - 500.00 (500.00) - 1,500.00 (1,500.00) 700.00 - 0.0%6609150 Dues and Subscriptions - - - 100.00 - 100.00 735.00 635.00 86.4%6609820 Uniforms - 50.00 (50.00) - 350.00 (350.00) 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 23,789.12 22,455.00 1,334.12 62,496.10 74,858.00 (12,361.90) 200,366.00 137,169.90 68.5%27,568.62 26,057.00 1,511.62 82,917.39 95,268.00 (12,350.61) 245,611.00 161,993.61 66.0%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementNovember 2012Annual Budget8 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,601.11 1,458.00 143.11 8,665.81 7,290.00 1,375.81 17,496.00 8,830.19 50.5%6701325 Insurance-Workers Comp502.40 688.00 (185.60) 2,748.23 3,440.00 (691.77) 8,254.00 5,505.77 66.7%6701720 Salaries 13,116.26 15,003.00 (1,886.74) 73,489.43 75,015.00 (1,525.57) 178,000.00 104,510.57 58.7%6701800 Taxes-Employer Payroll 1,119.56 1,792.00 (672.44) 6,199.86 8,960.00 (2,760.14) 21,510.00 15,310.14 71.2%6701880 Wages-Hourly2,185.91 2,150.00 35.91 8,211.67 10,750.00 (2,538.33) 27,835.00 19,623.33 70.5%6701882 Wages-Overtime 11.81 - 11.81 22.69 - 22.69 - (22.69) 0.0%Total-G&A-SALARIES & BENEFITS 18,537.05 21,091.00 (2,553.95) 99,337.69 105,455.00 (6,117.31) 253,095.00 153,757.31 60.8%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer43.07 400.00 (356.93) 227.07 2,000.00 (1,772.93) 5,200.00 4,972.93 95.6%6703762 Supplies-Office 371.15 100.00 271.15 877.07 500.00 377.07 1,200.00 322.93 26.9%6703768 Supplies-Printing & Stationery57.60 100.00 (42.40) 711.44 500.00 211.44 3,300.00 2,588.56 78.4%Total-G&A-SUPPLIES & MATERIALS 471.82 600.00 (128.18) 1,815.58 3,000.00 (1,184.42) 9,700.00 7,884.42 81.3%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) - 400.00 (400.00) 1,100.00 1,100.00 100.0%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) - 400.00 (400.00) 1,100.00 1,100.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 2,000.00 2,000.00 - 4,800.00 2,800.00 58.3%6709150 Dues & Subscriptions- 50.00 (50.00) 165.00 350.00 (185.00) 1,700.00 1,535.00 90.3%6709180 Employee Recruiting/Relocation180.00 200.00 (20.00) 1,582.60 600.00 982.60 1,400.00 (182.60) -13.0%6709197 Equipment Rental558.93 480.00 78.93 3,558.78 2,400.00 1,158.78 5,760.00 2,201.22 38.2%6709202 Fees-Bank113.75 90.00 23.75 575.79 450.00 125.79 1,080.00 504.21 46.7%6709208 Fees-Payroll Processing1,158.45 1,100.00 58.45 5,948.14 5,500.00 448.14 13,200.00 7,251.86 54.9%6709220 Freight/Delivery- 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0%6709490 Miscellaneous 18.63 100.00 (81.37) 95.96 500.00 (404.04) 1,200.00 1,104.04 92.0%6709620 Postage/Mail Services 257.99 75.00 182.99 757.82 375.00 382.82 900.00 142.18 15.8%6709625 Professional Fees934.25 850.00 84.25 5,129.25 4,250.00 879.25 10,200.00 5,070.75 49.7%6709636 Promotion/Entertainment- 100.00 (100.00) - 500.00 (500.00) 3,100.00 3,100.00 100.0%6709722 Seminars & Training- 200.00 (200.00) 250.00 1,000.00 (750.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 5.86 150.00 (144.14) 290.27 525.00 (234.73) 1,050.00 759.73 72.4%Total-G&A-OTHER EXPENSES 3,627.86 3,845.00 (217.14) 20,353.61 18,800.00 1,553.61 48,490.00 28,136.39 58.0%22,636.73 25,636.00 (2,999.27) 121,506.88 127,655.00 (6,148.12) 312,385.00 190,878.12 61.1%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementNovember 2012Annual Budget9 Income November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4009300Resident Card Issue21,555.00 - 21,555.00 21,555.00 - 21,555.00 - - 0%- - 0% Total Revenue Resident Cards21,555.00 - 21,555.00 21,555.00 - 21,555.00 - - 0%Expense60-RC-SALARIES & BENEFITS6001800 Taxes-Employer Payroll 87.20 - 87.20 87.20 - 87.20 - - 0%6001880 Wages-Hourly460.80 - 460.80 460.80 - 460.80 - - 0%6001882 Wages-Overtime - - - - - - - - 0%Total -RC-SALARIES & BENEFITS 548.00 - 548.00 548.00 - 548.00 - - 0%60-RC- OTHER EXPENSES6003762 Supplies-Office - - - - - - - - 0%6009490 Miscellaneous 2,157.05 - 2,157.05 3,549.63 - 3,549.63 - - 0%6003740 Supplies-Computer- - - - - - - - 0%6009625 Professional Fees- - - - - - - - 0%Total RC-OTHER EXPENSES 2,157.05 - 2,157.05 3,549.63 - 3,549.63 - - 0%2,705.05 - 2,705.05 4,097.63 - 4,097.63 - - 0%Net Income18,849.95 - 18,849.95 17,457.37 - 17,457.37 - - 0%Month to Date Year to Date Annual BudgetTotal-RESIDENT CARDSSilverRock ResortResident Card Income StatementNovember 201210 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,988.25 12,075.00 (86.75) 59,941.25 60,375.00 (433.75) 144,900.00 84,958.75 58.6%6800194 Equipment Leases-Trailer 502.54 600.00 (97.46) 2,270.16 3,000.00 (729.84) 7,200.00 4,929.84 68.5%6800196 Equipment Leases-GPS 4,940.00 5,755.00 (815.00) 24,700.00 28,775.00 (4,075.00) 69,060.00 44,360.00 64.2%6800197 Equipment Leases-Others 58.90 460.00 (401.10) 3,012.32 2,300.00 712.32 5,520.00 2,507.68 0.0%17,489.69 18,890.00 (1,400.31) 89,923.73 94,450.00 (4,526.27) 226,680.00 136,756.27 60.3%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee (4,697.03) (5,453.00) 755.97 72,845.26 77,314.00 (4,468.74) 90,000.00 17,154.74 19.1%6900210 FF&E Reserve 5,806.29 6,372.00 (565.71) 12,880.58 14,092.00 (1,211.42) 67,015.00 54,134.42 80.8%6900800 Personal Property Taxes 382.85 - 382.85 11,524.75 14,800.00 (3,275.25) 14,800.00 3,275.25 22.1%6900323 Insurance-Commercial 2,277.66 2,200.00 77.66 14,897.43 11,000.00 3,897.43 26,400.00 11,502.57 43.6%3,769.77 3,119.00 650.77 112,148.02 117,206.00 (5,057.98) 198,215.00 86,066.98 43.4%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementNovember 201211 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2012-20132012 2012 2012 2012 2012 2012Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia342SalesPromotionGolf IndustryVIPCelebrityPGA Comp62 16 46 15 20Charity/Gift Certificate61511 4Rain/Wind Checks53Club Staff129 60 81 13 78LQ HS Golf81231213 95 152 28 136 02013 2013 2013 2013 2013 2013Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2012-2013November 2012 Date Time Description CategoryPlayers13