Loading...
05 November 2009 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2009 – November 2009 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 November Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 342,208.86 324,750.00 17,458.86 5.4% 724,059.36 656,465.00 67,594.36 2,980,503.00 2,256,443.64 24%401000 Miscellaneous Golf Revenue 19,283.00 12,100.00 7,183.00 59.4% 37,617.60 34,972.00 2,645.60 109,297.00 71,679.40 34%410000 Revenue-Golf Shop 30,654.13 30,000.00 654.13 2.2% 65,148.12 73,551.00 (8,402.88) 325,551.00 260,402.88 20%420000 Revenue-F&B Concession 1,500.00 1,500.00 - 0.0% 4,500.00 4,500.00 - 12,000.00 7,500.00 38%890000 Interest Income 5.36 - 5.36 0.0% 27.25 - 27.25 - (27.25) 0%Total Income393,651.35 368,350.00 25,301.35 6.9% 831,352.33 769,488.00 61,864.33 3,427,351.00 2,595,998.67 24%Cost of Goods Sold510000 COS-Golf Shop 15,514.90 15,923.00 (408.10) 2.6% 35,595.63 39,037.05 3,441.42 172,786.05 137,190.42 21%Total COS15,514.90 15,923.00 (408.10) 2.6% 35,595.63 39,037.05 3,441.42 172,786.05 137,190.42 21%Gross Profit378,136.45 352,427.00 25,709.45 7.3% 795,756.70 730,450.95 65,305.75 3,254,564.95 2,458,808.25 24%Expenses610000 Golf Pro Shop 17,717.67 21,776.00 4,058.33 18.6% 71,932.46 90,733.00 18,800.54 243,485.00 171,552.54 30%630000 Course Maintenance 119,775.82 129,412.00 9,636.18 7.4% 739,235.15 774,790.00 35,554.85 1,594,579.00 855,343.85 46%633000 Maintenance Water & Energy 3,808.03 7,349.00 3,540.97 48.2% 42,758.52 37,110.00 (5,648.52) 86,871.00 44,112.48 49%640000 Outside Services 27,414.64 28,909.00 1,494.36 5.2% 100,578.33 105,492.00 4,913.67 277,000.00 176,421.67 36%650000 Clubhouse 12,956.87 9,742.00 (3,214.87) -33.0% 57,714.02 49,310.00 (8,404.02) 118,900.00 61,185.98 49%660000 Marketing 24,847.45 29,772.00 4,924.55 16.5% 83,527.86 87,935.00 4,407.14 256,759.00 173,231.14 33%670000 General & Administrative20,299.24 26,187.00 5,887.76 22.5% 107,599.96 129,610.00 22,010.04 316,394.00 208,794.04 34%680000 Leases 39,991.95 37,453.00 (2,538.95) -6.8% 199,244.61 187,265.00 (11,979.61) 432,204.00 232,959.39 46%690000 Miscellaneous Other Expense 7,855.35 8,471.00 615.65 7.3% 94,458.60 123,942.00 29,483.40 211,610.00 117,151.40 45%Total Expenses274,667.02 299,071.00 24,403.98 8.2% 1,497,049.51 1,586,187.00 89,137.49 3,537,802.00 2,040,752.49 42%Net Income 103,469.43 53,356.00 50,113.43 93.9%(701,292.81) (855,736.05) 154,443.24 (283,237.05) 418,055.76 248%Rounds of Golf PlayedPaid Rounds Played 4,494 4,000 494 12.4% 13,678 11,550 2,128 39,150 25,472 35%Ave $ Per Paid Round Green Fee 76.15 81.19 (5.04) -6.2% 52.94 56.84 (3.90) 76.13 23.19 70%Ave $ Per Paid Round Merchandise 6.82 7.50 (0.68) -9.1% 4.76 6.37 (1.61) 8.07 3.31 59%Ave $ Per Paid Miscellaneous 4.29 3.03 1.27 41.8% 2.75 3.03 (0.28) 2.06 - 0%Month to Date Year to DateNovember 2009SilverRock ResortSummary Operating Income Statement1 Income November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 342,208.86 324,750.00 17,458.86 724,059.36 656,465.00 67,594.36 2,980,503.002,256,443.6424%4010000 Rider Fee 775.00 400.00 375.00 3,950.00 3,069.00 881.00 5,829.001,879.0068%4040000 Club Rental 2,830.00 2,200.00 630.00 6,600.00 6,353.00 247.00 26,168.0019,568.0025%4050000 Driving Range 7,023.00 4,000.00 3,023.00 14,223.00 11,550.00 2,673.00 44,300.0030,077.0032%4060000 Handicap Fees 3,655.00 2,000.00 1,655.00 5,745.00 3,500.00 2,245.00 8,000.00 2,255.0072%4080000 GPS Advertising - 2,000.00 (2,000.00) - 7,000.00 (7,000.00) 12,000.00 12,000.000%4090000 Ball Retriever/Subcontract - - - 1,904.60 2,000.00 (95.40) 4,000.00 2,095.4048%4091000 Golf Professional Rental Fee 5,000.00 1,500.00 3,500.00 5,000.00 1,500.00 3,500.00 9,000.00 4,000.00 56%4092000 Golf Lessons - - - 195.00 - 195.00 - (195.00) 0% Total Revenue Fees 361,491.86 336,850.00 24,641.86 761,676.96 691,437.00 70,239.96 3,089,800.00 2,328,123.04 25%Total Income 361,491.86 336,850.00 24,641.86 761,676.96 691,437.00 70,239.96 3,089,800.00 2,328,123.04 25%Month to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueNovember 20092 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 660.00 660.00 - 2,460.00 2,460.00 - 6,960.00 4,500.00 64.7%6411320 Insurance-Group 662.00 662.00 - 1,921.60 3,310.00 (1,388.40) 7,944.00 6,022.40 75.8%6411325 Insurance-Workers Comp 395.82 1,305.00 (909.18) 1,581.05 4,960.00 (3,378.95) 16,162.00 14,580.95 90.2%6411800 Taxes-Employer Payroll 962.03 1,132.00 (169.97) 3,891.63 4,301.00 (409.37) 14,012.00 10,120.37 72.2%6411880 Wages-Hourly 9,821.52 9,090.00 731.52 36,624.33 34,546.00 2,078.33 112,549.00 75,924.67 67.5%6411882 Wages-Overtime 73.88 - 73.88 585.20 - 585.20 - (585.20) 0.0%Total-CBR-SALARIES & BENEFITS12,575.25 12,849.00 (273.75) 47,063.81 49,577.00 (2,513.19) 157,627.00 110,563.19 70.1%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 1,000.00 (1,000.00) 1,327.81 1,500.00 (172.19) 2,350.00 1,022.19 43.5%6413742 Supplies-Expendable 666.06 1,800.00 (1,133.94) 3,018.06 2,400.00 618.06 5,000.00 1,981.94 39.6%6413752 Supplies-Range Balls 5,000.00 6,000.00 (1,000.00) 5,143.75 6,000.00 (856.25) 6,000.00 856.25 14.3%6413762 Supplies-Office - 50.00 (50.00) - 175.00 (175.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary 49.57 - 49.57 180.65 - 180.65 420.00 239.35 57.0%6413786 Supplies-Towels 478.85 72.00 406.85 1,258.46 388.00 870.46 892.00 (366.46) -41.1%6413796 Supplies-Bottled Water219.40 400.00 (180.60) 14,033.51 16,600.00 (2,566.49) 19,400.00 5,366.49 27.7%Total-CBR-SUPPLIES & MATERIALS6,413.88 9,322.00 (2,908.12) 24,962.24 27,063.00 (2,100.76) 34,587.00 9,624.76 27.8%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts 720.00 720.00 - 3,600.00 3,600.00 - 8,640.00 5,040.00 58.3%6415690 CBR-R&M-Equipment 755.48 300.00 455.48 1,316.83 1,500.00 (183.17) 3,600.00 2,283.17 63.4%6415695 CBR-R&M-Cart Maintenance & Repair 1,252.35 250.00 1,002.35 2,900.99 2,250.00 650.99 4,000.00 1,099.01 27.5%Total-CBR-REPAIRS & MAINTENANCE 2,727.83 1,270.00 1,457.83 7,817.82 7,350.00 467.82 16,240.00 8,422.18 51.9%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps - 400.00 (400.00) 895.00 1,100.00 (205.00) 5,000.00 4,105.00 82.1%6419094 Contract Services-Laundry/Linen 297.08 500.00 (202.92) 2,980.72 2,500.00 480.72 6,000.00 3,019.28 50.3%6419220 Freight/Delivery - 75.00 (75.00) - 375.00 (375.00) 900.00 900.00 100.0%6419490 Miscellaneous 130.76 75.00 55.76 640.42 425.00 215.42 1,150.00 509.58 44.3%6419820 Uniforms 307.50 500.00 (192.50) 1,896.42 3,000.00 (1,103.58) 5,625.00 3,728.58 66.3%Total-CBR-OTHER EXPENSES 735.34 1,550.00 (814.66) 6,412.56 7,400.00 (987.44) 18,675.00 12,262.44 65.7%TOTAL-CARTS,BAGROOM & RANGE 22,452.30 24,991.00 (2,538.70) 86,256.43 91,390.00 (5,133.57) 227,129.00 140,872.57 62.0%643-CS-SALARIES & BENEFITS6431175 Employee Meals 240.00 240.00 - 960.00 960.00 - 3,300.00 2,340.00 70.9%6431325 Insurance-Workers Comp 146.72 164.00 (17.28) 440.87 546.00 (105.13) 2,069.00 1,628.13 78.7%6431800 Taxes-Employer Payroll 443.25 359.00 84.25 1,242.46 1,196.00 46.46 4,512.00 3,269.54 72.5%6431880 Wages-Hourly 3,668.00 2,880.00 788.00 10,328.00 9,600.00 728.00 36,240.00 25,912.00 71.5%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS4,497.97 3,643.00 854.97 12,971.33 12,302.00 669.33 46,121.00 33,149.67 71.9%643-CS-OTHER EXPENSES6433742 Supplies Expendable 86.90 100.00 (13.10) 86.90 400.00 (313.10) 1,050.00 963.10 91.7%6439490 Miscellaneous - 50.00 (50.00) - 100.00 (100.00) 200.00 200.00 100.0%6439718 Safety Equipment & Training 377.47 50.00 327.47 464.47 250.00 214.47 600.00 135.53 22.6%6439820 Uniforms - 75.00 (75.00) 799.20 1,050.00 (250.80) 1,900.00 1,100.80 57.9%Total-CS-OTHER EXPENSES 464.37 275.00 189.37 1,350.57 1,800.00 (449.43) 3,750.00 2,399.43 64.0%Total-COURSE SERVICES 4,962.34 3,918.00 1,044.34 14,321.90 14,102.00 219.90 49,871.00 35,549.10 71.3%TOTAL OUTSIDE SERVICES 27,414.64 28,909.00 (1,494.36) 100,578.33 105,492.00 (4,913.67) 277,000.00 174,022.24 62.8%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementNovember 2009Annual Budget3 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 1,140.00 1,200.00 (60.00) 2,880.00 1,740.00 60.4%6311320 Insurance-Group 8,740.00 8,740.00 - 44,708.62 43,700.00 1,008.62 104,880.00 60,171.38 57.4%6311325 Insurance-Workers Comp 2,099.76 3,344.00 (1,244.24) 11,666.74 16,640.00 (4,973.26) 39,329.00 27,662.26 70.3%6311720 Salaries 11,001.60 12,331.00 (1,329.40) 55,008.00 61,655.00 (6,647.00) 147,972.00 92,964.00 62.8%6311800 Taxes-Employer Payroll 4,231.75 7,421.00 (3,189.25) 21,832.13 36,837.00 (15,004.87) 86,420.00 64,587.87 74.7%6311880 Wages-Hourly 41,475.27 44,159.00 (2,683.73) 206,950.51 220,795.00 (13,844.49) 529,928.00 322,977.49 60.9%6311882 Wages-Overtime 17.11 3,114.00 (3,096.89) 9,979.93 13,426.00 (3,446.07) 16,234.00 6,254.07 38.5%Total-CM-SALARIES & BENEFITS67,805.49 79,349.00 (11,543.51) 351,285.93 394,253.00 (42,967.07) 927,643.00 576,357.07 62.1%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 2,742.30 2,700.00 42.30 21,990.58 16,700.00 5,290.58 29,300.00 7,309.42 24.9%6313744 Fertilizer 4,791.52 5,000.00 (208.48) 58,689.78 48,200.00 10,489.78 92,200.00 33,510.22 36.3%6313745 Herbicides 4,257.56 5,000.00 (742.44) 4,257.56 5,000.00 (742.44) 10,000.00 5,742.44 57.4%6313746 Flowers/Plants - - - 1,778.05 1,250.00 528.05 3,500.00 1,721.95 49.2%6313748 Fuel-Gasoline 3,644.43 4,180.00 (535.57) 19,372.54 21,630.00 (2,257.46) 43,100.00 23,727.46 55.1%6313750 Golf Course Accessories 1,432.78 200.00 1,232.78 12,464.58 6,800.00 5,664.58 8,000.00 (4,464.58) -55.8%6313756 POA Control 6,890.40 3,500.00 3,390.40 7,494.19 3,500.00 3,994.19 7,000.00 (494.19) -7.1%6313758 Miscellaneous Supp 865.62 500.00 365.62 2,711.71 3,250.00 (538.29) 4,350.00 1,638.29 0.0%6313762 Supplies-Office - - - 342.66 - 342.66 - (342.66) 0.0%6313774 Sand 1,049.92 2,000.00 (950.08) 5,683.93 9,780.00 (4,096.07) - (5,683.93) 0.0%6313775 Sand-Bunkers - - - 2,300.69 - 2,300.69 11,460.00 9,159.31 79.9%6313776 Seed 822.42 350.00 472.42 88,921.88 89,360.00 (438.12) 91,810.00 2,888.12 3.1%6313778 Small Tools & Non-Capital Equip 149.26 100.00 49.26 3,561.87 4,300.00 (738.13) 5,000.00 1,438.13 28.8%6313780 Sod 711.94 250.00 461.94 7,364.40 3,500.00 3,864.40 5,750.00 (1,614.40) -28.1%6313782 Topdressing - - - 3,089.98 5,000.00 (1,910.02) 7,600.00 4,510.02 59.3%Total-CM-SUPPLIES & MATERIALS27,358.15 23,780.00 3,578.15 240,024.40 218,270.00 21,754.40 319,070.00 79,045.60 24.8%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,561.25 500.00 2,061.25 11,360.20 6,500.00 4,860.20 17,000.00 5,639.80 33.2%6315685 CM-R&M-Bldngs & Othr Structures 90.50 - 90.50 918.48 750.00 168.48 1,750.00 831.52 47.5%6315690 CM-R&M-Equipment 3,299.03 2,000.00 1,299.03 24,652.34 25,200.00 (547.66) 35,700.00 11,047.66 30.9%6315692 CM-R&M-Irrigation System 1,491.99 900.00 591.99 12,200.38 9,300.00 2,900.38 16,050.00 3,849.62 24.0%6315696 CM-R&M-Pumps - 1,000.00 (1,000.00) 6,084.80 5,000.00 1,084.80 10,500.00 4,415.20 42.0%6315815 CM-R&M-Trees-Pruning Etc - - - 3,335.59 4,050.00 (714.41) 10,050.00 6,714.41 66.8%Total-CM-REPAIRS & MAINTENANCE 7,442.77 4,400.00 3,042.77 58,551.79 50,800.00 7,751.79 91,050.00 32,498.21 35.7%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs 5.38 - 5.38 25.63 - 25.63 (25.63) 0.0%6317836 Utilities-Natural Gas/LPG - 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 0.0%6317840 Telephones 625.62 850.00 (224.38) 4,000.97 4,250.00 (249.03) 10,200.00 6,199.03 60.8%Total-CM-UTILITIES 631.00 900.00 (269.00) 4,026.60 4,500.00 (473.40) 10,800.00 6,773.40 62.7%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%6319099 Contract Svcs-Security Bldgs - - - 210.00 - 210.00 (210.00) 0.0%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 487.83 524.00 (36.17) 2,926.98 2,620.00 306.98 6,288.00 3,361.02 0.0%6319150 Dues & Subscriptions - 200.00 (200.00) 18.00 400.00 (382.00) 900.00 882.00 98.0%6319170 Employee Education - 50.00 (50.00) - 250.00 (250.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental 524.24 600.00 (75.76) 2,966.74 2,900.00 66.74 4,200.00 1,233.26 29.4%6319206 Licenses & Permits - - - 228.10 280.00 (51.90) 680.00 451.90 66.5%6319490 Miscellaneous 85.80 100.00 (14.20) 439.92 500.00 (60.08) 1,200.00 760.08 63.3%6319718 Safety Equipment & Training 520.08 200.00 320.08 2,239.67 1,500.00 739.67 2,600.00 360.33 13.9%6319822 Uniforms 982.10 820.00 162.10 4,562.08 4,100.00 462.08 9,840.00 5,277.92 53.6%Total-CM-OTHER EXPENSES 3,100.05 2,994.00 106.05 17,591.49 17,050.00 541.49 37,258.00 19,666.51 52.8%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementNovember 2009Annual Budget4 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,317.00 2,317.00 - 9,805.75 11,585.00 (1,779.25) 27,804.00 17,998.25 64.7%6321325 Insurance-Workers Comp 391.87 700.00 (308.13) 2,177.21 3,515.00 (1,337.79) 8,229.00 6,051.79 73.5%6321800 Taxes-Employer Payroll 749.43 1,559.00 (809.57) 3,899.70 7,846.00 (3,946.30) 18,154.00 14,254.30 78.5%6321880 Wages-Hourly 9,782.94 11,712.00 (1,929.06) 48,791.12 58,560.00 (9,768.88) 140,544.00 91,752.88 65.3%6321882 Wages-Overtime 13.69 811.00 (797.31) 2,185.42 4,461.00 (2,275.58) 5,272.00 3,086.58 58.5%Total-CM-LM-SALARIES & BENEFITS13,254.93 17,099.00 (3,844.07) 66,859.20 85,967.00 (19,107.80) 200,003.00 133,143.80 66.6%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 183.43 290.00 (106.57) 895.74 1,450.00 (554.26) 3,480.00 2,584.26 74.3%Total-CM-LM-SUPPLIES & MATERIALS183.43 390.00 (206.57) 895.74 1,950.00 (1,054.26) 4,505.00 3,609.26 80.1%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%119,775.82 129,412.00 (9,636.18) 739,235.15 774,790.00 (35,554.85) 1,594,579.00 855,343.85 53.6% November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping - 6,000.00 (6,000.00) 11,828.05 26,000.00 (14,171.95) 65,000.00 53,171.95 81.8%6337842 Utilities-Water3,808.03 1,349.00 2,459.03 30,930.47 11,110.00 19,820.47 21,871.00 (9,059.47) -41.4%Total-CM-WATER & ENERGY 3,808.03 7,349.00 (3,540.97) 42,758.52 37,110.00 5,648.52 86,871.00 44,112.48 50.8%Month to Date Year to Date Annual BudgetYear to DateSilverrock ResortCourse Maintenance Water & EnergyNovember 2009Total -COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementNovember 2009Annual BudgetMonth to Date5 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 660.00 660.00 - 2,460.00 2,460.00 - 6,960.00 4,500.00 64.7%6411320 Insurance-Group 662.00 662.00 - 1,921.60 3,310.00 (1,388.40) 7,944.00 6,022.40 75.8%6411325 Insurance-Workers Comp 395.82 1,305.00 (909.18) 1,581.05 4,960.00 (3,378.95) 16,162.00 14,580.95 90.2%6411800 Taxes-Employer Payroll 962.03 1,132.00 (169.97) 3,891.63 4,301.00 (409.37) 14,012.00 10,120.37 72.2%6411880 Wages-Hourly 9,821.52 9,090.00 731.52 36,624.33 34,546.00 2,078.33 112,549.00 75,924.67 67.5%6411882 Wages-Overtime 73.88 - 73.88 585.20 - 585.20 - (585.20) 0.0%Total-CBR-SALARIES & BENEFITS12,575.25 12,849.00 (273.75) 47,063.81 49,577.00 (2,513.19) 157,627.00 110,563.19 70.1%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 1,000.00 (1,000.00) 1,327.81 1,500.00 (172.19) 2,350.00 1,022.19 43.5%6413742 Supplies-Expendable 666.06 1,800.00 (1,133.94) 3,018.06 2,400.00 618.06 5,000.00 1,981.94 39.6%6413752 Supplies-Range Balls 5,000.00 6,000.00 (1,000.00) 5,143.75 6,000.00 (856.25) 6,000.00 856.25 14.3%6413762 Supplies-Office - 50.00 (50.00) - 175.00 (175.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary 49.57 - 49.57 180.65 - 180.65 420.00 239.35 57.0%6413786 Supplies-Towels 478.85 72.00 406.85 1,258.46 388.00 870.46 892.00 (366.46) -41.1%6413796 Supplies-Bottled Water219.40 400.00 (180.60) 14,033.51 16,600.00 (2,566.49) 19,400.00 5,366.49 27.7%Total-CBR-SUPPLIES & MATERIALS6,413.88 9,322.00 (2,908.12) 24,962.24 27,063.00 (2,100.76) 34,587.00 9,624.76 27.8%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts 720.00 720.00 - 3,600.00 3,600.00 - 8,640.00 5,040.00 58.3%6415690 CBR-R&M-Equipment 755.48 300.00 455.48 1,316.83 1,500.00 (183.17) 3,600.00 2,283.17 63.4%6415695 CBR-R&M-Cart Maintenance & Repair 1,252.35 250.00 1,002.35 2,900.99 2,250.00 650.99 4,000.00 1,099.01 27.5%Total-CBR-REPAIRS & MAINTENANCE 2,727.83 1,270.00 1,457.83 7,817.82 7,350.00 467.82 16,240.00 8,422.18 51.9%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps - 400.00 (400.00) 895.00 1,100.00 (205.00) 5,000.00 4,105.00 82.1%6419094 Contract Services-Laundry/Linen 297.08 500.00 (202.92) 2,980.72 2,500.00 480.72 6,000.00 3,019.28 50.3%6419220 Freight/Delivery - 75.00 (75.00) - 375.00 (375.00) 900.00 900.00 100.0%6419490 Miscellaneous 130.76 75.00 55.76 640.42 425.00 215.42 1,150.00 509.58 44.3%6419820 Uniforms 307.50 500.00 (192.50) 1,896.42 3,000.00 (1,103.58) 5,625.00 3,728.58 66.3%Total-CBR-OTHER EXPENSES 735.34 1,550.00 (814.66) 6,412.56 7,400.00 (987.44) 18,675.00 12,262.44 65.7%TOTAL-CARTS,BAGROOM & RANGE 22,452.30 24,991.00 (2,538.70) 86,256.43 91,390.00 (5,133.57) 227,129.00 140,872.57 62.0%643-CS-SALARIES & BENEFITS6431175 Employee Meals 240.00 240.00 - 960.00 960.00 - 3,300.00 2,340.00 70.9%6431325 Insurance-Workers Comp 146.72 164.00 (17.28) 440.87 546.00 (105.13) 2,069.00 1,628.13 78.7%6431800 Taxes-Employer Payroll 443.25 359.00 84.25 1,242.46 1,196.00 46.46 4,512.00 3,269.54 72.5%6431880 Wages-Hourly 3,668.00 2,880.00 788.00 10,328.00 9,600.00 728.00 36,240.00 25,912.00 71.5%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS4,497.97 3,643.00 854.97 12,971.33 12,302.00 669.33 46,121.00 33,149.67 71.9%643-CS-OTHER EXPENSES6433742 Supplies Expendable 86.90 100.00 (13.10) 86.90 400.00 (313.10) 1,050.00 963.10 91.7%6439490 Miscellaneous - 50.00 (50.00) - 100.00 (100.00) 200.00 200.00 100.0%6439718 Safety Equipment & Training 377.47 50.00 327.47 464.47 250.00 214.47 600.00 135.53 22.6%6439820 Uniforms - 75.00 (75.00) 799.20 1,050.00 (250.80) 1,900.00 1,100.80 57.9%Total-CS-OTHER EXPENSES 464.37 275.00 189.37 1,350.57 1,800.00 (449.43) 3,750.00 2,399.43 64.0%Total-COURSE SERVICES 4,962.34 3,918.00 1,044.34 14,321.90 14,102.00 219.90 49,871.00 35,549.10 71.3%TOTAL OUTSIDE SERVICES 27,414.64 28,909.00 (1,494.36) 100,578.33 105,492.00 (4,913.67) 277,000.00 174,022.24 62.8%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementNovember 2009Annual Budget6 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable270.43 400.00 (129.57) 270.43 2,000.00 (1,729.57) 4,800.00 4,529.57 94.4%Total-CH-SUPPLIES & MATERIALS 270.43 400.00 (129.57) 270.43 2,000.00 (1,729.57) 4,800.00 4,529.57 94.4%65-CH-UTILITIES6507836 Utilities-Natural Gas259.24 300.00 (40.76) 1,090.65 1,500.00 (409.35) 3,600.00 2,509.35 69.7%6507838 Utilities-Sewer- 200.00 (200.00) - 1,000.00 (1,000.00) 2,400.00 2,400.00 100.0%6507840 Utilities-Telephone988.43 1,000.00 (11.57) 5,823.42 5,000.00 823.42 12,000.00 6,176.58 51.5%6507842 Utilities-Water255.95 200.00 55.95 2,930.84 1,000.00 1,930.84 2,400.00 (530.84) -22.1%6507844 Utilities-Cable326.47 317.00 9.47 1,827.30 1,585.00 242.30 3,800.00 1,972.70 51.9%Total-CH-UTILITIES 1,830.09 2,017.00 (186.91) 11,672.21 10,085.00 1,587.21 24,200.00 12,527.79 51.8%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning2,025.00 1,825.00 200.00 9,740.00 9,725.00 15.00 22,500.00 12,760.00 56.7%6509098 Contract Services-Refuse Dispose291.34 - 291.34 1,748.04 - 1,748.04 - (1,748.04) 0.0%6509099 Contract Services-Security6,847.56 4,100.00 2,747.56 27,047.20 20,500.00 6,547.20 49,200.00 22,152.80 45.0%6509215 Flowers & Decorations- 100.00 (100.00) - 500.00 (500.00) 2,600.00 2,600.00 100.0%6509490 Miscellaneous190.29 200.00 (9.71) 218.84 1,000.00 (781.16) 2,400.00 2,181.16 90.9%6509718 Safety Equipment & Training85.00 100.00 (15.00) 308.86 500.00 (191.14) 1,200.00 891.14 74.3%Total-CH-OTHER EXPENSES 9,439.19 6,325.00 3,114.19 39,062.94 32,225.00 6,837.94 77,900.00 38,837.06 49.9%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures480.50 200.00 280.50 3,460.28 1,000.00 2,460.28 2,400.00 (1,060.28) -44.2%6515686 CH-R&M-Restaurant Repairs936.66 400.00 536.66 3,113.16 2,000.00 1,113.16 4,800.00 1,686.84 35.1%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 135.00 2,000.00 (1,865.00) 4,800.00 4,665.00 97.2%Total-CH-REPAIRS & MAINTENANCE 1,417.16 1,000.00 417.16 6,708.44 5,000.00 1,708.44 12,000.00 5,291.56 44.1%Total CLUBHOUSE 12,956.87 9,742.00 3,214.87 57,714.02 49,310.00 8,404.02 118,900.00 10,583.12 8.9%Month to Date Year to DateSilverRock ResortClubhouse Expense StatementNovember 2009Annual Budget7 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 300.00 300.00 - 720.00 420.00 58.3%6601320 Insurance-Group 331.00 331.00 - 1,564.12 1,655.00 (90.88) 3,972.00 2,407.88 60.6%6601325 Insurance-Workers Comp 101.00 143.00 (42.00) 540.80 715.00 (174.20) 1,713.00 1,172.20 68.4%6601720 Salaries 2,500.00 2,500.00 - 12,500.00 12,500.00 - 30,000.00 17,500.00 58.3%6601800 Taxes-Employer Payroll 311.00 311.00 - 1,555.00 1,555.00 - 3,735.00 2,180.00 58.4%Total-MKT-SALARIES & BENEFITS 3,303.00 3,345.00 (42.00) 16,459.92 16,725.00 (265.08) 40,140.00 23,680.08 59.0%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 140.15 500.00 (359.85) 1,200.00 1,059.85 88.3%6603768 Supplies-Printing & Stationery 650.38 200.00 450.38 837.81 3,400.00 (2,562.19) 4,425.00 3,587.19 81.1%650.38 300.00 350.38 977.96 3,900.00 (2,922.04) 5,625.00 4,647.04 82.6%66-MKT-UTILITIES6607840 Utilities-Telephone 82.86 100.00 (17.14) 392.31 500.00 (107.69) 1,200.00 807.69 67.3%Total-MKT-UTILITIES 82.86 100.00 (17.14) 392.31 500.00 (107.69) 1,200.00 807.69 67.3%66-MKT-OTHER EXPENSES6609010 Advertising 20,518.71 19,877.00 641.71 64,410.16 54,835.00 9,575.16 185,984.00 121,573.84 65.4%6609040 Business Meals - 25.00 (25.00) 25.00 125.00 (100.00) 300.00 275.00 91.7%6609080 Collateral Material - 1,000.00 (1,000.00) 163.11 3,500.00 (3,336.89) 9,000.00 8,836.89 98.2%6609102 Contract Services-Web Page 99.00 175.00 (76.00) 570.00 875.00 (305.00) 2,100.00 1,530.00 72.9%6609490 Miscellaneous 32.00 50.00 (18.00) 32.00 50.00 (18.00) 350.00 318.00 90.9%6609620 Postage 161.50 50.00 111.50 263.98 250.00 13.98 600.00 336.02 56.0%6609630 Promotion - 50.00 (50.00) - 100.00 (100.00) 700.00 700.00 0.0%6609633 Promotion-Community - 750.00 (750.00) - 1,725.00 (1,725.00) 2,925.00 2,925.00 100.0%6609634 Promotion-Media/Vendor - 4,000.00 (4,000.00) 93.42 5,000.00 (4,906.58) 6,500.00 - 0.0%6609150 Dues and Subscriptions - - - 140.00 - 140.00 735.00 595.00 81.0%6609820 Uniforms - 50.00 (50.00) - 350.00 (350.00) 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 20,811.21 26,027.00 (5,215.79) 65,697.67 66,810.00 (1,112.33) 209,794.00 137,689.75 65.6%Total-MARKETING 24,847.45 29,772.00 (4,924.55) 83,527.86 87,935.00 (4,407.14) 256,759.00 166,824.56 65.0%Month to Date Year to DateSilverRock ResortMarketing Expense StatementNovember 2009Annual Budget8 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 900.00 900.00 - 2,160.00 1,260.00 58.3%6701320 Insurance-Group1,458.00 1,458.00 - 6,681.04 7,290.00 (608.96) 17,496.00 10,814.96 61.8%6701325 Insurance-Workers Comp536.65 981.00 (444.35) 3,213.50 4,905.00 (1,691.50) 11,772.00 8,558.50 72.7%6701720 Salaries 13,416.26 14,534.00 (1,117.74) 67,386.01 72,670.00 (5,283.99) 174,408.00 107,021.99 61.4%6701800 Taxes-Employer Payroll 1,026.34 2,140.00 (1,113.66) 5,706.46 10,700.00 (4,993.54) 25,680.00 19,973.54 77.8%6701880 Wages-Hourly- 2,654.00 (2,654.00) 7,208.30 13,270.00 (6,061.70) 31,848.00 24,639.70 77.4%6701882 Wages-Overtime - - - 5.91 - 5.91 - (5.91) 0.0%Total-G&A-SALARIES & BENEFITS 16,617.25 21,947.00 (5,329.75) 91,101.22 109,735.00 (18,633.78) 263,364.00 172,262.78 65.4%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 800.00 (800.00) 1,199.16 4,000.00 (2,800.84) 10,800.00 9,600.84 88.9%6703762 Supplies-Office 331.76 125.00 206.76 1,041.81 625.00 416.81 1,500.00 458.19 30.5%6703768 Supplies-Printing & Stationery346.97 100.00 246.97 573.66 400.00 173.66 3,200.00 2,626.34 82.1%6703778Supplies-Small Tools/Non-Capital - 100.00 (100.00) - 300.00 (300.00) 900.00 900.00 100.0%Total-G&A-SUPPLIES & MATERIALS 678.73 1,125.00 (446.27) 2,814.63 5,325.00 (2,510.37) 16,400.00 13,585.37 82.8%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 297.97 500.00 (202.03) 1,200.00 902.03 75.2%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 297.97 500.00 (202.03) 1,200.00 902.03 75.2%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) - 350.00 (350.00) 1,500.00 1,500.00 100.0%6709180 Employee Recruiting/Relocation706.49 500.00 206.49 902.49 1,500.00 (597.51) 2,600.00 1,697.51 65.3%6709197 Equipment Rental456.38 350.00 106.38 2,501.66 1,750.00 751.66 4,200.00 1,698.34 40.4%6709202 Fees-Bank58.83 90.00 (31.17) 255.66 450.00 (194.34) 1,080.00 824.34 76.3%6709208 Fees-Payroll Processing791.47 550.00 241.47 3,390.86 2,750.00 640.86 6,600.00 3,209.14 48.6%6709220 Freight/Delivery- 50.00 (50.00) 88.29 250.00 (161.71) 600.00 511.71 85.3%6709490 Miscellaneous 19.40 100.00 (80.60) 297.79 500.00 (202.21) 1,200.00 902.21 75.2%6709620 Postage/Mail Services 31.69 75.00 (43.31) 446.79 375.00 71.79 900.00 453.21 50.4%6709625 Professional Fees475.00 400.00 75.00 2,425.04 2,000.00 425.04 4,800.00 2,374.96 49.5%6709636 Promotion/Entertainment- 100.00 (100.00) 134.78 500.00 (365.22) 2,600.00 2,465.22 94.8%6709722 Seminars & Training64.00 200.00 (136.00) 543.00 1,000.00 (457.00) 2,400.00 1,857.00 77.4%6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms - 150.00 (150.00) 399.78 525.00 (125.22) 1,050.00 650.22 61.9%Total-G&A-OTHER EXPENSES 3,003.26 3,015.00 (11.74) 13,386.14 14,050.00 (663.86) 35,430.00 22,043.86 62.2%Total-GENERAL & ADMINISTRATIVE20,299.24 26,187.00 (5,887.76) 107,599.96 129,610.00 (22,010.04) 316,394.00 208,794.04 66.0%Month to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementNovember 2009Annual Budget9 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,581.04 11,581.00 0.04 57,905.20 57,905.00 0.20 138,972.00 81,066.80 58.3%6800193 Equipment Leases-Course Maint 16,244.12 16,500.00 (255.88) 81,220.60 82,500.00 (1,279.40) 189,000.00 107,779.40 57.0%6800194 Equipment Leases-Trailer 549.50 600.00 (50.50) 2,719.00 3,000.00 (281.00) 7,200.00 4,481.00 62.2%6800195 Equipment Leases-Software 2,210.93 1,372.00 838.93 9,378.65 6,860.00 2,518.65 8,232.00 (1,146.65) -13.9%6800196 Equipment Leases-GPS 6,840.14 7,400.00 (559.86) 34,918.51 37,000.00 (2,081.49) 88,800.00 53,881.49 60.7%6800197 Equipment Leases-Others 2,566.22 - 2,566.22 13,102.65 - 13,102.65 - - 0.0%Total-LEASES 39,991.95 37,453.00 2,538.95 199,244.61 187,265.00 11,979.61 432,204.00 246,062.04 56.9%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee (5,389.83) (1,524.00) (3,865.83) 59,144.61 73,312.00 (14,167.39) 90,000.00 30,855.39 34.3%6900210 FF&E Reserve 6,844.18 6,495.00 349.18 14,481.19 13,130.00 1,351.19 59,610.00 45,128.81 75.7%6900800 Personal Property Taxes - - - 10,777.70 20,000.00 (9,222.30) 20,000.00 9,222.30 46.1%6900323 Insurance-Commercial 6,401.00 3,500.00 2,901.00 10,055.10 17,500.00 (7,444.90) 42,000.00 31,944.90 76.1%Total-MISC OTHER EXPENSES7,855.35 8,471.00 (615.65) 94,458.60 123,942.00 (29,483.40) 211,610.00 117,151.40 55.4%Annual BudgetMonth to Date Year to DateSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementNovember 200910 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2009-20102009 2009 2009 2009 2009 2009Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia74 4SalesPromotionGolf Industry81711 7VIPCelebrityPGA Comp70 68 67 9 44Charity/Gift Certificate14 10 4Rain/Wind Checks35 36Club Staff69 105 91 6 47LQ HS Golf39161 200 227 19 138 02010 2010 2010 2010 2010 2010Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2009-2010November 2009 Date Time Description CategoryPlayers11/10/2009 9:15 Michael Dante Media 211/17/2009 11:15 Michael Dante Media 212