Loading...
07 January 2011 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2010 – January 2011 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 January Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue252,490.47 236,925.00 15,565.47 6.6% 1,183,276.57 1,235,083.00 (51,806.43) 3,111,458.00 1,928,181.43 38%401000 Miscellaneous Golf Revenue 16,744.08 9,955.00 6,789.08 68.2% 63,454.38 59,011.00 4,443.38 117,656.00 54,201.62 54%410000 Revenue-Golf Shop 49,646.43 37,800.00 11,846.43 31.3% 135,432.97 130,831.00 4,601.97 306,492.00 171,059.03 44%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0% 7,500.00 7,500.00 - 12,000.00 4,500.00 63%890000 Interest Income4.45 - 4.45 0.0% 34.06 - 34.06 - (34.06) 0%Total Income320,385.43 286,180.00 34,205.43 12.0% 1,389,697.98 1,432,425.00 (42,727.02) 3,547,606.00 2,157,908.02 39%Cost of Goods Sold510000 COS-Golf Shop 27,091.60 20,062.00 7,029.60 -35.0% 73,280.68 69,437.05 (3,843.63) 162,670.60 89,389.92 45%Total COS27,091.60 20,062.00 7,029.60 -35.0% 73,280.68 69,437.05 (3,843.63) 162,670.60 89,389.92 45%Gross Profit293,293.83 266,118.00 27,175.83 10.2% 1,316,417.30 1,362,987.95 (46,570.65) 3,384,935.40 2,068,518.10 39%Expenses610000 Golf Pro Shop 21,969.02 21,766.00 (203.02) -0.9% 110,283.76 128,457.00 18,173.24 230,213.00 119,929.24 48%630000 Course Maintenance121,454.29 118,145.00 (3,309.29) -2.8% 965,860.72 984,690.00 18,829.28 1,541,961.00 576,100.28 63%633000 Maintenance Water & Energy4,687.25 4,860.00 172.75 3.6% 50,448.04 53,020.00 2,571.96 85,358.00 34,909.96 59%640000 Outside Services26,668.91 28,179.00 1,510.09 5.4% 151,966.87 166,840.00 14,873.13 297,478.00 145,511.13 51%650000 Clubhouse 9,843.00 13,236.00 3,393.00 25.6% 80,169.42 78,152.00 (2,017.42) 132,232.00 52,062.58 61%660000 Marketing 28,703.30 32,236.00 3,532.70 11.0% 151,268.21 164,107.00 12,838.79 262,644.00 111,375.79 58%670000 General & Administrative25,246.67 26,114.00 867.33 3.3% 168,298.69 182,898.00 14,599.31 314,808.00 146,509.31 53%680000 Leases 19,166.86 20,000.00 833.14 4.2% 131,851.27 147,740.00 15,888.73 247,740.00 115,888.73 53%690000 Miscellaneous Other Expense21,511.20 13,086.00 (8,425.20) -64.4% 126,599.13 137,276.00 10,676.87 192,199.00 65,599.87 66%Total Expenses279,250.50 277,622.00 (1,628.50) -0.6% 1,936,746.11 2,043,180.00 106,433.89 3,304,633.00 1,367,886.89 59%14,043.33 (11,504.00) 25,547.33 222.1%(620,328.81) (680,192.05) 59,863.24 80,302.40 700,631.21 -772%Rounds of Golf PlayedPaid Rounds Played 2,941 2,700 241 8.9% 20,063 19,727 336 39,150 19,087 51%Ave $ Per Paid Round Green Fee85.85 87.75 (1.90) -2.2% 58.98 62.61 (3.63) 76.13 17.15 77%Ave $ Per Paid Round Merchandise16.88 14.00 2.88 20.6% 6.75 6.63 0.12 8.07 1.32 84%Ave $ Per Paid Miscellaneous 5.69 3.69 2.01 54.4% 3.16 2.99 0.17 2.06 - 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateJanuary 20111 Income January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 252,490.47 236,925.00 15,565.47 1,183,276.57 1,235,083.00 (51,806.43) 3,111,458.001,928,181.4338%4010000 Rider Fee 750.00 270.00 480.00 5,125.00 4,287.00 838.00 6,522.001,397.0079%4040000 Club Rental 1,975.00 1,485.00 490.00 10,310.00 10,849.00 (539.00) 28,004.0017,694.0037%4050000 Driving Range 7,711.00 2,700.00 5,011.00 30,660.00 20,375.00 10,285.00 48,130.0017,470.0064%4080000 GPS Advertising - 1,000.00 (1,000.00) - 10,000.00 (10,000.00) 12,000.00 12,000.000%4090000 Ball Retriever/Subcontract 249.08 1,000.00 (750.92) 2,075.38 3,000.00 (924.62) 4,000.00 1,924.6252%4091000 Golf Professional Rental Fee 5,900.00 3,500.00 2,400.00 15,125.00 10,500.00 4,625.00 19,000.00 3,875.00 80%4092000 Golf Lessons 159.00 - 159.00 159.00 - 159.00 - (159.00) 0% Total Revenue Fees 269,234.55 246,880.00 22,354.55 1,246,730.95 1,294,094.00 (47,363.05) 3,229,114.00 1,982,383.05 39%269,234.55 246,880.00 22,354.55 1,246,730.95 1,294,094.00 (47,363.05) 3,229,114.00 1,982,383.05 39%SilverRock ResortStatement of Fees RevenueJanuary 2011Total IncomeMonth to Date Year to Date Annual Budget2 Income January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 181.84 - 181.84 2,602.38 - 2,602.38 0 0 0%4100110 Sales Hard Goods 13,532.51 13,230.00 302.51 47,712.09 45,791.00 1,921.09 107,272.00 59,559.91 44%4100112 Sales-Soft Goods 41,101.91 24,570.00 16,531.91 101,489.01 85,040.00 16,449.01 199,220.00 97,730.99 51%5100639 GS-Discounts-Mdse (5,169.83) - (5,169.83) (16,370.51) - (16,370.51) - 16,370.51 0% Total Revenue Golf Shop 49,646.43 37,800.00 11,846.43 135,432.97 130,831.00 4,601.97 306,492.00 173,661.41 43%COS 5100150 COS-GS-Hard Goods 6,057.02 7,276.50 (1,219.48) 23,819.59 25,185.05 (1,365.46) 58,999.60 35,180.01 40%5100151 COS-GS-Soft Goods 19,109.94 13,513.50 5,596.44 46,137.32 46,772.00 (634.68) 109,571.00 63,433.68 42%5100152 COS-GS-Purchase Disc (136.86) (1,040.00) 903.14 (1,401.15) (3,598.00) 2,196.85 (8,429.00) (7,027.85) -17%5100220 COS-GS-Freight Merch 2,061.50 312.00 1,749.50 4,724.92 1,078.00 3,646.92 2,529.00 (2,195.92) 187%Cost of Sales - Golf Shop 27,091.60 20,062.00 7,029.60 73,280.68 69,437.05 3,843.63 162,670.60 89,389.92 45%Gross Profit 22,554.83 17,738.00 4,816.83 62,152.29 61,393.95 758.34 143,821.40 84,271.49 41%COS % 54.6% 53.1% -1.5% 54.1% 53.1% -1.0% 53.1% 51.5% 3%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 480.00 480.00 - 3,060.00 3,060.00 - 5,400.00 2,340.00 57%6101320 Insurance Group 2,317.00 2,317.00 - 15,502.72 15,226.00 276.72 26,811.00 11,308.28 58%6101325 Insurance-Workers Comp 481.35 567.00 (85.65) 2,677.23 3,401.00 (723.77) 6,131.00 3,453.77 44%6101720 Salaries 3,545.46 3,750.00 (204.54) 25,180.34 26,250.00 (1,069.66) 45,000.00 19,819.66 56%6101800 Taxes-Employer Payroll 2,226.88 1,714.00 512.88 6,569.26 10,277.00 (3,707.74) 18,528.00 11,958.74 35%6101880 Wages-Hourly 10,420.00 10,013.00 407.00 46,469.94 56,283.00 (9,813.06) 103,818.00 57,348.06 45%6101882 Wages-Overtime 1,076.83 - 1,076.83 1,248.23 - 1,248.23 - 952.88 0%Total -PS-SALARIES & BENEFITS 20,547.52 18,841.00 1,706.52 100,707.72 114,497.00 (13,789.28) 205,688.00 107,181.39 48%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - 189.74 - 189.74 - (189.74) 0%6103762 Supplies-Office 97.84 500.00 (402.16) 1,932.62 3,500.00 (1,567.38) 6,000.00 4,067.38 32%6109090 Contract Services 500.00 500.00 - 3,500.00 3,500.00 - 6,000.00 2,500.00 58%6109220 Freight & Delivery 52.59 - 52.59 439.17 75.00 364.17 75.00 (364.17) 586%6109490 Miscellaneous 85.00 50.00 35.00 189.37 200.00 (10.63) 450.00 260.63 42%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short 4.54 - 4.54 20.60 - 20.60 - (20.60) 0%6109722 Seminars/Training - 1,250.00 (1,250.00) 545.07 4,500.00 (3,954.93) 5,890.00 5,344.93 9%6109810 Travel - Merchandise - 15.00 (15.00) - 15.00 (15.00) 90.00 90.00 0%6109820 Uniforms 579.61 500.00 79.61 1,771.32 1,400.00 371.32 2,400.00 628.68 74%6117840 Telephones 101.92 110.00 (8.08) 988.15 770.00 218.15 1,320.00 331.85 0%Total PS-OTHER EXPENSES 1,421.50 2,925.00 (1,503.50) 9,576.04 13,960.00 (4,383.96) 24,525.00 14,948.96 39%21,969.02 21,766.00 203.02 110,283.76 128,457.00 (18,173.24) 230,213.00 122,130.35 47%Net Income585.81 (4,028.00) 4,613.81 (48,131.47) (67,063.05) 18,931.58 (86,391.60) (37,858.86) -56%SilverRock ResortGolf Shop Income StatementJanuary 2011Total Expenses-Golf ShopMonth to Date Year to Date Annual Budget3 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 1,680.00 1,680.00 - 2,880.00 1,200.00 41.7%6311320 Insurance-Group 8,740.00 8,740.00 - 59,567.69 61,180.00 (1,612.31) 104,880.00 45,312.31 43.2%6311325 Insurance-Workers Comp 2,091.23 2,541.00 (449.77) 15,138.68 16,372.00 (1,233.32) 27,638.00 12,499.32 45.2%6311720 Salaries 11,468.28 12,583.00 (1,114.72) 81,411.64 88,081.00 (6,669.36) 150,996.00 69,584.36 46.1%6311800 Taxes-Employer Payroll 8,814.18 7,781.00 1,033.18 36,198.06 50,008.00 (13,809.94) 84,168.00 47,969.94 57.0%6311880 Wages-Hourly 47,716.03 47,430.00 286.03 303,014.33 300,813.00 2,201.33 509,458.00 206,443.67 40.5%6311882 Wages-Overtime 7,633.38 2,486.00 5,147.38 21,179.97 12,792.00 8,387.97 15,598.00 (5,581.97) -35.8%Total-CM-SALARIES & BENEFITS86,703.10 81,801.00 4,902.10 518,190.37 530,926.00 (12,735.63) 895,618.00 377,427.63 42.1%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 3,154.65 2,000.00 1,154.65 25,656.98 20,900.00 4,756.98 29,300.00 3,643.02 12.4%6313744 Fertilizer 1,301.96 1,000.00 301.96 54,467.84 59,400.00 (4,932.16) 89,400.00 34,932.16 39.1%6313745 Herbicides - - - 12,221.59 12,000.00 221.59 12,000.00 (221.59) -1.8%6313746 Flowers/Plants - 750.00 (750.00) 1,253.89 2,750.00 (1,496.11) 3,050.00 1,796.11 58.9%6313748 Fuel-Gasoline 3,305.78 2,950.00 355.78 30,338.59 27,680.00 2,658.59 43,100.00 12,761.41 29.6%6313750 Golf Course Accessories 185.10 200.00 (14.90) 12,049.15 11,800.00 249.15 12,300.00 250.85 2.0%6313756 POA Control 239.62 3,500.00 (3,260.38) 8,450.73 7,000.00 1,450.73 7,000.00 (1,450.73) -20.7%6313758 Miscellaneous Supp 1,885.86 100.00 1,785.86 6,544.46 3,850.00 2,694.46 4,350.00 (2,194.46) 0.0%6313762 Supplies-Office - - - 238.13 - 238.13 - (238.13) 0.0%6313774 Sand 533.61 380.00 153.61 4,868.18 10,960.00 (6,091.82) 11,460.00 6,591.82 57.5%6313776 Seed - 350.00 (350.00) 96,436.13 90,060.00 6,376.13 91,810.00 (4,626.13) -5.0%6313778 Small Tools & Non-Capital Equip 91.54 100.00 (8.46) 4,127.61 4,500.00 (372.39) 5,000.00 872.39 17.4%6313780 Sod - 500.00 (500.00) 3,179.03 2,650.00 529.03 3,350.00 170.97 5.1%6313782 Topdressing - - - 7,717.59 5,000.00 2,717.59 7,600.00 (117.59) -1.5%Total-CM-SUPPLIES & MATERIALS10,698.12 11,830.00 (1,131.88) 267,549.90 258,550.00 8,999.90 319,720.00 52,170.10 16.3%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,575.00 2,068.00 (493.00) 12,376.24 14,346.00 (1,969.76) 24,610.00 12,233.76 49.7%6315685 CM-R&M-Bldngs & Othr Structures 90.50 250.00 (159.50) 1,271.65 1,000.00 271.65 1,750.00 478.35 27.3%6315690 CM-R&M-Equipment 2,195.66 1,000.00 1,195.66 20,909.62 14,000.00 6,909.62 20,500.00 (409.62) -2.0%6315692 CM-R&M-Irrigation System 440.75 1,200.00 (759.25) 9,934.10 11,050.00 (1,115.90) 16,050.00 6,115.90 38.1%6315696 CM-R&M-Pumps - 1,000.00 (1,000.00) 5,439.15 7,000.00 (1,560.85) 10,500.00 5,060.85 48.2%6315815 CM-R&M-Trees-Pruning Etc - - - 3,495.00 4,050.00 (555.00) 10,050.00 6,555.00 65.2%Total-CM-REPAIRS & MAINTENANCE 4,301.91 5,518.00 (1,216.09) 53,425.76 51,446.00 1,979.76 83,460.00 30,034.24 36.0%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 20.81 15.00 5.81 168.40 105.00 63.40 180.00 11.60 0.0%6317840 Telephones 1,120.22 850.00 270.22 7,718.06 5,950.00 1,768.06 10,200.00 2,481.94 24.3%Total-CM-UTILITIES 1,141.03 865.00 276.03 7,886.46 6,055.00 1,831.46 10,380.00 2,493.54 24.0%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 3,500.00 3,500.00 - 6,000.00 2,500.00 41.7%6319100 Contract Svcs-Soil/Tissue Test - - - 1,500.00 2,000.00 (500.00) 4,000.00 2,500.00 62.5%6319101 Contract Svcs-Trash Removal 471.25 525.00 (53.75) 3,081.55 3,675.00 (593.45) 6,288.00 3,206.45 0.0%6319150 Dues & Subscriptions - - - 345.00 - 345.00 540.00 195.00 36.1%6319170 Employee Education - 50.00 (50.00) 70.00 350.00 (280.00) 1,550.00 1,480.00 95.5%6319197 Equipment Rental - 200.00 (200.00) 2,747.39 3,300.00 (552.61) 4,200.00 1,452.61 34.6%6319206 Licenses & Permits - - - 353.03 280.00 73.03 1,430.00 1,076.97 75.3%6319490 Miscellaneous - 100.00 (100.00) 618.23 700.00 (81.77) 1,200.00 581.77 48.5%6319718 Safety Equipment & Training 356.33 400.00 (43.67) 2,233.98 3,150.00 (916.02) 3,850.00 1,616.02 42.0%6319822 Uniforms 1,016.31 820.00 196.31 7,343.66 5,740.00 1,603.66 9,840.00 2,496.34 25.4%Total-CM-OTHER EXPENSES 2,343.89 2,595.00 (251.11) 21,792.84 22,695.00 (902.16) 38,898.00 17,105.16 44.0%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementJanuary 2011Annual Budget4 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,317.00 2,317.00 - 15,310.00 16,219.00 (909.00) 27,804.00 12,494.00 44.9%6321325 Insurance-Workers Comp 254.00 445.00 (191.00) 2,465.64 3,239.00 (773.36) 5,487.00 3,021.36 55.1%6321800 Taxes-Employer Payroll 1,562.81 1,346.00 216.81 5,952.45 9,978.00 (4,025.55) 16,811.00 10,858.55 64.6%6321880 Wages-Hourly 10,408.85 10,813.00 (404.15) 67,277.87 75,691.00 (8,413.13) 129,756.00 62,478.13 48.2%6321882 Wages-Overtime 1,528.57 - 1,528.57 4,058.61 4,461.00 (402.39) 5,272.00 1,213.39 23.0%Total-CM-LM-SALARIES & BENEFITS16,071.23 14,921.00 1,150.23 95,064.57 109,588.00 (14,523.43) 185,130.00 90,065.43 48.6%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 264.55 650.00 (385.45) 1,025.00 760.45 74.2%6323788 Uniforms 195.01 290.00 (94.99) 1,561.10 2,030.00 (468.90) 3,480.00 1,918.90 55.1%Total-CM-LM-SUPPLIES & MATERIALS195.01 365.00 (169.99) 1,825.65 2,680.00 (854.35) 4,505.00 2,679.35 59.5%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 250.00 (250.00) 125.17 2,750.00 (2,624.83) 4,250.00 4,124.83 97.1%Total-CM-LM-REPAIRS & MAINTENANCE - 250.00 (250.00) 125.17 2,750.00 (2,624.83) 4,250.00 4,124.83 97.1%121,454.29 118,145.00 3,309.29 965,860.72 984,690.00 (18,829.28) 1,541,961.00 576,100.28 37.4% January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 2,748.05 3,000.00 (251.95) 18,743.13 24,300.00 (5,556.87) 42,300.00 23,556.87 55.7%6337842 Utilities-Water1,939.20 1,860.00 79.20 31,704.91 28,720.00 2,984.91 43,058.00 11,353.09 26.4%4,687.25 4,860.00 (172.75) 50,448.04 53,020.00 (2,571.96) 85,358.00 34,909.96 40.9%Silverrock ResortCourse Maintenance Expense StatementJanuary 2011Annual BudgetMonth to Date Year to DateSilverrock ResortCourse Maintenance Water & EnergyJanuary 2011Total-COURSE MAINTENANCETotal-CM-WATER & ENERGYMonth to Date Year to Date Annual Budget5 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 720.00 720.00 - 3,840.00 3,840.00 - 6,960.00 3,120.00 44.8%6411320 Insurance-Group 662.00 662.00 - 4,030.60 4,634.00 (603.40) 7,944.00 3,913.40 49.3%6411325 Insurance-Workers Comp 445.07 565.00 (119.93) 2,344.14 2,647.00 (302.86) 5,096.00 2,751.86 54.0%6411800 Taxes-Employer Payroll 1,943.09 1,707.00 236.09 7,546.72 8,000.00 (453.28) 15,399.00 7,852.28 51.0%6411880 Wages-Hourly 13,358.94 13,710.00 (351.06) 63,577.46 64,259.00 (681.54) 123,689.00 60,111.54 48.6%6411882 Wages-Overtime 558.48 - 558.48 741.85 - 741.85 - (741.85) 0.0%Total-CBR-SALARIES & BENEFITS17,687.58 17,364.00 323.58 82,080.77 83,380.00 (1,299.23) 159,088.00 77,007.23 48.4%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 54.32 75.00 (20.68) 2,177.61 2,075.00 102.61 2,350.00 172.39 7.3%6413742 Supplies-Expendable 667.73 1,000.00 (332.27) 5,281.63 4,450.00 831.63 6,750.00 1,468.37 21.8%6413752 Supplies-Range Balls - - - 7,495.01 6,000.00 1,495.01 6,000.00 (1,495.01) -24.9%6413762 Supplies-Office - 50.00 (50.00) 98.21 275.00 (176.79) 525.00 426.79 81.3%6413768 Supplies-Printing and Stationary - 70.00 (70.00) - 70.00 (70.00) 420.00 420.00 100.0%6413786 Supplies-Towels - 72.00 (72.00) - 645.00 (645.00) 1,005.00 1,005.00 100.0%6413796 Supplies-Bottled Water219.77 50.00 169.77 14,195.29 12,300.00 1,895.29 24,500.00 10,304.71 42.1%Total-CBR-SUPPLIES & MATERIALS941.82 1,317.00 (375.18) 29,247.75 25,815.00 3,432.75 41,550.00 12,302.25 29.6%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts - 720.00 (720.00) - 5,040.00 (5,040.00) 8,640.00 8,640.00 100.0%6415690 CBR-R&M-Equipment - 300.00 (300.00) 1,089.26 2,100.00 (1,010.74) 3,600.00 2,510.74 69.7%6415695 CBR-R&M-Cart Maintenance & Repair - 250.00 (250.00) 2,900.18 3,750.00 (849.82) 5,000.00 2,099.82 42.0%Total-CBR-REPAIRS & MAINTENANCE - 1,270.00 (1,270.00) 3,989.44 10,890.00 (6,900.56) 17,240.00 13,250.56 76.9%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 254.94 800.00 (545.06) 5,928.34 5,600.00 328.34 9,600.00 3,671.66 38.2%6419220 Freight/Delivery - - - 78.96 450.00 (371.04) 450.00 371.04 82.5%6419490 Miscellaneous 649.24 75.00 574.24 949.72 575.00 374.72 1,150.00 200.28 17.4%6419820 Uniforms 32.63 - 32.63 2,257.34 3,000.00 (742.66) 5,200.00 2,942.66 56.6%Total-CBR-OTHER EXPENSES 936.81 875.00 61.81 9,214.36 9,625.00 (410.64) 16,400.00 7,185.64 43.8%TOTAL-CARTS,BAGROOM & RANGE 19,566.21 20,826.00 (1,259.79) 124,532.32 129,710.00 (5,177.68) 234,278.00 109,745.68 46.8%643-CS-SALARIES & BENEFITS6431175 Employee Meals 420.00 420.00 - 1,860.00 1,860.00 - 3,420.00 1,560.00 45.6%6431325 Insurance-Workers Comp 173.32 235.00 (61.68) 730.65 921.00 (190.35) 1,738.00 1,007.35 58.0%6431800 Taxes-Employer Payroll 766.55 711.00 55.55 2,767.50 2,783.00 (15.50) 5,251.00 2,483.50 47.3%6431880 Wages-Hourly 5,413.20 5,712.00 (298.80) 20,507.20 28,991.00 (8,483.80) 48,816.00 28,308.80 58.0%6431882 Wages-Overtime 3.00 - 3.00 54.00 - 54.00 - (54.00) 0.0%Total-CS-SALARIES & BENEFITS6,776.07 7,078.00 (301.93) 25,919.35 34,555.00 (8,635.65) 59,225.00 33,305.65 56.2%643-CS-OTHER EXPENSES6433742 Supplies Expendable 326.63 100.00 226.63 326.63 600.00 (273.37) 1,050.00 723.37 68.9%6439490 Miscellaneous - 50.00 (50.00) 26.23 200.00 (173.77) 200.00 173.77 86.9%6439718 Safety Equipment & Training - 50.00 (50.00) 254.05 350.00 (95.95) 600.00 345.95 57.7%6439820 Uniforms - 75.00 (75.00) 908.29 1,425.00 (516.71) 2,125.00 1,216.71 57.3%Total-CS-OTHER EXPENSES 326.63 275.00 51.63 1,515.20 2,575.00 (1,059.80) 3,975.00 2,459.80 61.9%Total-COURSE SERVICES 7,102.70 7,353.00 (250.30) 27,434.55 37,130.00 (9,695.45) 63,200.00 35,765.45 56.6%26,668.91 28,179.00 (1,510.09) 151,966.87 166,840.00 (14,873.13) 297,478.00 143,051.33 48.1%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementJanuary 2011Annual Budget6 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 1,654.51 2,800.00 (1,145.49) 4,800.00 3,145.49 65.5%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 1,654.51 2,800.00 (1,145.49) 4,800.00 3,145.49 65.5%65-CH-UTILITIES6507836 Utilities-Natural Gas650.70 300.00 350.70 2,693.03 2,100.00 593.03 3,600.00 906.97 25.2%6507840 Utilities-Telephone969.59 1,150.00 (180.41) 7,185.18 8,050.00 (864.82) 13,800.00 6,614.82 47.9%6507842 Utilities-Water330.68 321.00 9.68 7,559.51 2,247.00 5,312.51 3,852.00 (3,707.51) -96.2%6507844 Utilities-Cable336.47 340.00 (3.53) 2,355.41 2,380.00 (24.59) 4,080.00 1,724.59 42.3%Total-CH-UTILITIES 2,287.44 2,111.00 176.44 19,793.13 14,777.00 5,016.13 25,332.00 5,538.87 21.9%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 12,850.00 13,375.00 (525.00) 22,500.00 9,650.00 42.9%6509099 Contract Services-Security4,692.72 6,500.00 (1,807.28) 35,493.78 35,900.00 (406.22) 60,400.00 24,906.22 41.2%6509215 Flowers & Decorations- 1,000.00 (1,000.00) - 1,500.00 (1,500.00) 2,400.00 2,400.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 1,253.79 1,400.00 (146.21) 2,400.00 1,146.21 47.8%6509718 Safety Equipment & Training359.85 100.00 259.85 359.85 700.00 (340.15) 1,200.00 840.15 70.0%Total-CH-OTHER EXPENSES 6,877.57 9,625.00 (2,747.43) 49,957.42 52,875.00 (2,917.58) 88,900.00 38,942.58 43.8%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures557.99 300.00 257.99 3,683.99 2,100.00 1,583.99 3,600.00 (83.99) -2.3%6515686 CH-R&M-Restaurant Repairs120.00 400.00 (280.00) 2,134.86 2,800.00 (665.14) 4,800.00 2,665.14 55.5%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 2,945.51 2,800.00 145.51 4,800.00 1,854.49 38.6%Total-CH-REPAIRS & MAINTENANCE 677.99 1,100.00 (422.01) 8,764.36 7,700.00 1,064.36 13,200.00 4,435.64 33.6%9,843.00 13,236.00 (3,393.00) 80,169.42 78,152.00 2,017.42 132,232.00 8,871.28 6.7%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementJanuary 2011Annual Budget7 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 420.00 420.00 - 720.00 300.00 41.7%6601320 Insurance-Group 331.00 331.00 - 2,256.60 2,317.00 (60.40) 3,972.00 1,715.40 43.2%6601325 Insurance-Workers Comp 78.04 103.00 (24.96) 698.20 721.00 (22.80) 1,240.00 541.80 43.7%6601720 Salaries 2,438.67 2,508.00 (69.33) 18,490.55 17,556.00 934.55 30,096.00 11,605.45 38.6%6601800 Taxes-Employer Payroll 453.44 312.00 141.44 2,396.38 2,184.00 212.38 3,747.00 1,350.62 36.0%Total-MKT-SALARIES & BENEFITS 3,361.15 3,314.00 47.15 24,261.73 23,198.00 1,063.73 39,775.00 15,513.27 39.0%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 52.81 700.00 (647.19) 1,200.00 1,147.19 95.6%6603768 Supplies-Printing & Stationery 169.60 200.00 (30.40) 5,144.86 3,800.00 1,344.86 4,425.00 (719.86) -16.3%169.60 300.00 (130.40) 5,197.67 4,500.00 697.67 5,625.00 427.33 7.6%66-MKT-UTILITIES6607840 Utilities-Telephone 49.46 100.00 (50.54) 357.08 700.00 (342.92) 1,200.00 842.92 70.2%Total-MKT-UTILITIES 49.46 100.00 (50.54) 357.08 700.00 (342.92) 1,200.00 842.92 70.2%66-MKT-OTHER EXPENSES6609010 Advertising 24,650.12 24,537.00 113.12 117,200.04 119,749.00 (2,548.96) 192,534.00 75,333.96 39.1%6609040 Business Meals - 25.00 (25.00) - 175.00 (175.00) 300.00 300.00 100.0%6609080 Collateral Material 195.75 2,500.00 (2,304.25) 826.50 6,000.00 (5,173.50) 9,000.00 8,173.50 90.8%6609102 Contract Services-Web Page 99.00 400.00 (301.00) 1,180.50 2,800.00 (1,619.50) 4,800.00 3,619.50 75.4%6609490 Miscellaneous - 50.00 (50.00) - 150.00 (150.00) 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) 283.62 350.00 (66.38) 600.00 316.38 52.7%6609630 Promotion - 300.00 (300.00) - 450.00 (450.00) 3,500.00 3,500.00 0.0%6609633 Promotion-Community - 75.00 (75.00) - 2,550.00 (2,550.00) 2,925.00 2,925.00 100.0%6609634 Promotion-Media/Vendor - 500.00 (500.00) 1,610.35 3,000.00 (1,389.65) 700.00 - 0.0%6609150 Dues and Subscriptions - 35.00 (35.00) 140.00 35.00 105.00 735.00 595.00 81.0%6609820 Uniforms 178.22 50.00 128.22 210.72 450.00 (239.28) 600.00 389.28 64.9%Total-MKT-OTHER EXPENSES 25,123.09 28,522.00 (3,398.91) 121,451.73 135,709.00 (14,257.27) 216,044.00 95,502.62 44.2%28,703.30 32,236.00 (3,532.70) 151,268.21 164,107.00 (12,838.79) 262,644.00 112,286.14 42.8%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementJanuary 2011Annual Budget8 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 1,260.00 1,260.00 - 2,160.00 900.00 41.7%6701320 Insurance-Group1,458.00 1,458.00 - 9,485.60 10,206.00 (720.40) 17,496.00 8,010.40 45.8%6701325 Insurance-Workers Comp510.91 707.00 (196.09) 4,111.35 4,949.00 (837.65) 8,480.00 4,368.65 51.5%6701720 Salaries 13,416.26 14,833.34 (1,417.08) 97,491.49 103,833.38 (6,341.89) 178,000.00 80,508.51 45.2%6701800 Taxes-Employer Payroll 2,336.85 2,136.00 200.85 9,405.99 14,952.00 (5,546.01) 25,627.00 16,221.01 63.3%6701880 Wages-Hourly2,549.58 2,319.66 229.92 12,434.98 16,237.62 (3,802.64) 27,835.00 15,400.02 55.3%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 20,451.60 21,634.00 (1,182.40) 134,189.41 151,438.00 (17,248.59) 259,598.00 125,408.59 48.3%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 400.00 (400.00) 993.95 2,800.00 (1,806.05) 5,200.00 4,206.05 80.9%6703762 Supplies-Office 519.40 100.00 419.40 1,233.62 700.00 533.62 1,200.00 (33.62) -2.8%6703768 Supplies-Printing & Stationery84.79 400.00 (315.21) 1,242.15 1,300.00 (57.85) 3,300.00 2,057.85 62.4%Total-G&A-SUPPLIES & MATERIALS 604.19 900.00 (295.81) 3,469.72 4,800.00 (1,330.28) 9,700.00 6,230.28 64.2%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment522.50 100.00 422.50 522.50 600.00 (77.50) 1,100.00 577.50 52.5%Total-G&A-REPAIRS & MAINTENANCE 522.50 100.00 422.50 522.50 600.00 (77.50) 1,100.00 577.50 52.5%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 2,800.00 2,800.00 - 4,800.00 2,000.00 41.7%6709150 Dues & Subscriptions- 100.00 (100.00) 371.71 650.00 (278.29) 1,700.00 1,328.29 78.1%6709180 Employee Recruiting/Relocation- 200.00 (200.00) 420.00 1,000.00 (580.00) 1,400.00 980.00 70.0%6709197 Equipment Rental522.23 480.00 42.23 4,299.92 3,360.00 939.92 5,760.00 1,460.08 25.3%6709202 Fees-Bank58.46 90.00 (31.54) 485.81 630.00 (144.19) 1,080.00 594.19 55.0%6709208 Fees-Payroll Processing1,721.44 760.00 961.44 8,737.58 5,320.00 3,417.58 9,120.00 382.42 4.2%6709220 Freight/Delivery- 50.00 (50.00) - 350.00 (350.00) 600.00 600.00 100.0%6709490 Miscellaneous - 100.00 (100.00) 186.84 700.00 (513.16) 1,200.00 1,013.16 84.4%6709620 Postage/Mail Services 147.00 75.00 72.00 776.22 525.00 251.22 900.00 123.78 13.8%6709625 Professional Fees819.25 850.00 (30.75) 8,983.50 5,950.00 3,033.50 10,200.00 1,216.50 11.9%6709636 Promotion/Entertainment- 100.00 (100.00) 2,085.00 2,600.00 (515.00) 3,100.00 1,015.00 32.7%6709722 Seminars & Training- 200.00 (200.00) 360.00 1,400.00 (1,040.00) 2,400.00 2,040.00 85.0%6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms - 75.00 (75.00) 610.48 675.00 (64.52) 1,050.00 439.52 41.9%Total-G&A-OTHER EXPENSES 3,668.38 3,480.00 188.38 30,117.06 26,060.00 4,057.06 44,410.00 14,292.94 32.2%25,246.67 26,114.00 (867.33) 168,298.69 182,898.00 (14,599.31) 314,808.00 146,509.31 46.5%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementJanuary 2011Annual Budget9 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,091.63 13,000.00 (1,908.37) 63,250.37 85,324.00 (22,073.63) 150,324.00 87,073.63 57.9%6800194 Equipment Leases-Trailer 540.00 600.00 (60.00) 3,760.00 4,200.00 (440.00) 7,200.00 3,440.00 47.8%6800196 Equipment Leases-GPS 5,290.50 6,400.00 (1,109.50) 49,940.50 58,216.00 (8,275.50) 90,216.00 40,275.50 44.6%6800197 Equipment Leases-Others 2,244.73 - 2,244.73 14,900.40 - 14,900.40 - - 0.0%19,166.86 20,000.00 (833.14) 131,851.27 147,740.00 (15,888.73) 247,740.00 130,789.13 52.8%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 10,177.89 6,147.00 4,030.89 71,740.74 83,604.00 (11,863.26) 90,000.00 18,259.26 20.3%6900210 FF&E Reserve 5,049.81 4,739.00 310.81 23,665.55 24,702.00 (1,036.45) 62,229.00 38,563.45 62.0%6900800 Personal Property Taxes 3,678.40 - 3,678.40 15,519.02 13,570.00 1,949.02 13,570.00 (1,949.02) -14.4%6900323 Insurance-Commercial 2,605.10 2,200.00 405.10 15,673.82 15,400.00 273.82 26,400.00 10,726.18 40.6%21,511.20 13,086.00 8,425.20 126,599.13 137,276.00 (10,676.87) 192,199.00 65,599.87 34.1%Silverrock ResortOperating Leases & Miscellaneous Other Expense StatementJanuary 2011Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSES10 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2010-20112010 2010 2010 2010 2010 2010Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia4Sales4PromotionGolf Industry85 4VIPCelebrityPGA Comp68 72 76 30 58Charity/Gift Certificate12 44 45Rain/Wind Checks34 4Club Staff77 68 96 3 69 119LQ HS Golf20153 148 208 3 155 2262011 2011 2011 2011 2011 2011Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA Comp29Charity/Gift Certificate21Rain/Wind ChecksClub Staff51LQ HS Golf1010000011