Loading...
06 December 2009 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2009 – December 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 December Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 268,660.80 257,672.00 10,988.80 4.3% 992,720.16 914,137.00 78,583.16 2,980,503.00 1,987,782.84 33%401000 Miscellaneous Golf Revenue 15,201.25 11,693.00 3,508.25 30.0% 52,818.85 46,665.00 6,153.85 109,297.00 56,478.15 48%410000 Revenue-Golf Shop 23,974.93 24,151.00 (176.07) -0.7% 88,594.55 97,702.00 (9,107.45) 325,551.00 236,956.45 27%420000 Revenue-F&B Concession 1,500.00 1,500.00 - 0.0% 6,000.00 6,000.00 - 12,000.00 6,000.00 50%890000 Interest Income 4.75 - 4.75 0.0% 32.00 - 32.00 - (32.00) 0%Total Income309,341.73 295,016.00 14,325.73 4.9% 1,140,165.56 1,064,504.00 75,661.56 3,427,351.00 2,287,185.44 33%Cost of Goods Sold510000 COS-Golf Shop 14,348.04 12,818.05 1,529.99 -11.9% 49,943.67 51,855.10 1,911.43 172,786.05 122,842.38 29%Total COS14,348.04 12,818.05 1,529.99 -11.9% 49,943.67 51,855.10 1,911.43 172,786.05 122,842.38 29%Gross Profit294,993.69 282,197.95 12,795.74 4.5% 1,090,221.89 1,012,648.90 77,572.99 3,254,564.95 2,164,343.06 33%Expenses610000 Golf Pro Shop 17,253.08 21,676.00 4,422.92 20.4% 89,185.54 112,409.00 23,223.46 243,485.00 154,299.46 37%630000 Course Maintenance 113,954.63 125,894.00 11,939.37 9.5% 853,189.78 900,684.00 47,494.22 1,594,579.00 741,389.22 54%633000 Maintenance Water & Energy 1,841.68 7,349.00 5,507.32 74.9% 44,600.20 44,459.00 (141.20) 86,871.00 42,270.80 51%640000 Outside Services 24,422.43 26,057.00 1,634.57 6.3% 125,000.76 131,549.00 6,548.24 277,000.00 151,999.24 45%650000 Clubhouse 9,354.08 9,742.00 387.92 4.0% 67,068.10 59,052.00 (8,016.10) 118,900.00 51,831.90 56%660000 Marketing 22,276.56 26,972.00 4,695.44 17.4% 105,804.42 114,907.00 9,102.58 256,759.00 150,954.58 41%670000 General & Administrative20,854.79 26,562.00 5,707.21 21.5% 128,692.59 156,172.00 27,479.41 316,394.00 187,701.41 41%680000 Leases 33,627.12 37,453.00 3,825.88 10.2% 232,871.73 224,718.00 (8,153.73) 432,204.00 199,332.27 54%690000 Miscellaneous Other Expense 24,307.51 20,098.00 (4,209.51) -20.9% 118,766.11 144,040.00 25,273.89 211,610.00 92,843.89 56%Total Expenses267,891.88 301,803.00 33,911.12 11.2% 1,765,179.23 1,887,990.00 122,810.77 3,537,802.00 1,772,622.77 50%Net Income 27,101.81 (19,605.05) 46,706.86 238.2%(674,957.34) (875,341.10) 200,383.76 (283,237.05) 391,720.29 238%Rounds of Golf PlayedPaid Rounds Played 3,670 3,450 220 6.4% 17,348 15,000 2,348 39,150 21,802 44%Ave $ Per Paid Round Green Fee 73.20 74.69 (1.48) -2.0% 57.22 60.94 (3.72) 76.13 18.91 75%Ave $ Per Paid Round Merchandise 6.53 7.00 (0.47) -6.7% 5.11 6.51 (1.41) 8.07 2.96 63%Ave $ Per Paid Miscellaneous 4.14 3.39 0.75 22.2% 3.04 3.11 (0.07) 2.06 - 0%Month to Date Year to DateDecember 2009SilverRock ResortSummary Operating Income Statement1 Income December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 268,660.80 257,672.00 10,988.80 992,720.16 914,137.00 78,583.16 2,980,503.001,987,782.8433%4010000 Rider Fee 850.00 345.00 505.00 4,800.00 3,414.00 1,386.00 5,829.001,029.0082%4040000 Club Rental 1,685.00 1,898.00 (213.00) 8,285.00 8,251.00 34.00 26,168.0017,883.0032%4050000 Driving Range 6,193.00 3,450.00 2,743.00 20,416.00 15,000.00 5,416.00 44,300.0023,884.0046%4060000 Handicap Fees 805.00 2,500.00 (1,695.00) 6,550.00 6,000.00 550.00 8,000.00 1,450.0082%4080000 GPS Advertising - 2,000.00 (2,000.00) - 9,000.00 (9,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 10,000.00 3,000.00 7,000.00 9,000.00 -1,000.00 111%4092000 Golf Lessons 668.25 - 668.25 863.25 - 863.25 - (863.25) 0% Total Revenue Fees 283,862.05 269,365.00 14,497.05 1,045,539.01 960,802.00 84,737.01 3,089,800.00 2,044,260.99 34%Total Income 283,862.05 269,365.00 14,497.05 1,045,539.01 960,802.00 84,737.01 3,089,800.00 2,044,260.99 34%SilverRock ResortStatement of Fees RevenueDecember 2009Month to Date Year to Date Annual Budget2 Income December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 343.00 - 343.00 2,143.21 - 2,143.21 4100110 Sales Hard Goods 6,337.16 8,453.00 (2,115.84) 35,294.74 34,196.00 1,098.74 113,943.00 78,648.26 31%4100112 Sales-Soft Goods 21,877.14 15,698.00 6,179.14 65,436.60 63,506.00 1,930.60 211,608.00 146,171.40 31%5100639 GS-Discounts-Mdse (4,582.37) - (4,582.37) (14,280.00) - (14,280.00) - 14,280.00 0% Total Revenue Golf Shop 23,974.93 24,151.00 (176.07) 88,594.55 97,702.00 (9,107.45) 325,551.00 239,099.66 27%COS 5100150 COS-GS-Hard Goods 2,891.18 4,649.15 (1,757.97) 17,513.20 18,807.80 (1,294.60) 62,668.65 45,155.45 28%5100151 COS-GS-Soft Goods 11,191.13 8,633.90 2,557.23 31,062.19 34,928.30 (3,866.11) 116,384.40 85,322.21 27%5100152 COS-GS-Purchase Disc (30.24) (664.00) 633.76 (450.28) (2,688.00) 2,237.72 (8,953.00) (8,502.72) -5%5100220 COS-GS-Freight Merch 295.97 199.00 96.97 1,818.56 807.00 1,011.56 2,686.00 867.44 68%Cost of Sales - Golf Shop 14,348.04 12,818.05 1,529.99 49,943.67 51,855.10 (1,911.43) 172,786.05 122,842.38 29%Gross Profit 9,626.89 11,332.95 (1,706.06) 38,650.88 45,846.90 (7,196.02) 152,764.95 116,257.28 24%COS % 59.8% 53.1% -6.8% 56.4% 53.1% -3.3% 53.1% 51.4% 3%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 480.00 480.00 - 2,580.00 2,580.00 - 5,400.00 2,820.00 48%6101320 Insurance Group 2,317.00 2,317.00 - 12,687.37 12,909.00 (221.63) 26,811.00 14,123.63 47%6101325 Insurance-Workers Comp 460.90 852.00 (391.10) 2,478.62 4,230.00 (1,751.38) 9,229.00 6,750.38 27%6101720 Salaries 3,722.73 3,582.00 140.73 21,450.03 21,492.00 (41.97) 20,796.00 (654.03) 103%6101800 Taxes-Employer Payroll 1,101.56 1,858.00 (756.44) 4,951.27 9,222.00 (4,270.73) 20,123.00 15,171.73 25%6101880 Wages-Hourly 8,319.87 11,342.00 (3,022.13) 36,984.54 52,581.00 (15,596.46) 140,831.00 103,846.46 26%6101882 Wages-Overtime 29.63 - 29.63 515.44 - 515.44 - 952.88 0%Total -PS-SALARIES & BENEFITS 16,431.69 20,431.00 (3,999.31) 81,647.27 103,014.00 (21,366.73) 223,190.00 143,011.05 36%61-PS OTHER EXPENSES6103762 Supplies-Office - 300.00 (300.00) 1,036.87 2,000.00 (963.13) 2,950.00 1,913.13 35%6109090 Contract Services 500.00 500.00 - 3,000.00 3,000.00 - 6,000.00 3,000.00 50%6109220 Freight & Delivery - 25.00 (25.00) 251.97 75.00 176.97 75.00 (176.97) 336%6109490 Miscellaneous 30.99 50.00 (19.01) 178.45 150.00 28.45 450.00 271.55 40%6109150 Dues and Subscriptions - - - - - - 2,000.00 2,000.00 0%6109500 ProShop-Over/Short (1.24) - (1.24) 32.07 - 32.07 - (32.07) 0%6109722 Seminars/Training - 100.00 (100.00) 206.00 2,850.00 (2,644.00) 5,490.00 5,284.00 4%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms 87.00 200.00 (113.00) 898.44 900.00 (1.56) 2,400.00 1,501.56 37%6117840 Telephones 204.64 70.00 134.64 1,503.68 420.00 1,083.68 840.00 (663.68) 0%Total PS-OTHER EXPENSES 821.39 1,245.00 (423.61) 7,538.27 9,395.00 (1,856.73) 20,295.00 12,756.73 37%Total Expenses17,253.08 21,676.00 (4,422.92) 89,185.54 112,409.00 (23,223.46) 243,485.00 155,767.78 36%Net Income(7,626.19) (10,343.05) 2,716.86 (50,534.66) (66,562.10) 16,027.44 (90,720.05) (39,510.50) -56%Month to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementDecember 20093 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 1,380.00 1,440.00 (60.00) 2,880.00 1,500.00 52.1%6311320 Insurance-Group 8,740.00 8,740.00 - 53,448.62 52,440.00 1,008.62 104,880.00 51,431.38 49.0%6311325 Insurance-Workers Comp 2,080.24 3,226.00 (1,145.76) 13,746.98 19,866.00 (6,119.02) 39,329.00 25,582.02 65.0%6311720 Salaries 11,551.68 12,331.00 (779.32) 66,559.68 73,986.00 (7,426.32) 147,972.00 81,412.32 55.0%6311800 Taxes-Employer Payroll 4,421.08 7,033.00 (2,611.92) 26,253.21 43,870.00 (17,616.79) 86,420.00 60,166.79 69.6%6311880 Wages-Hourly 42,694.93 44,159.00 (1,464.07) 249,645.44 264,954.00 (15,308.56) 529,928.00 280,282.56 52.9%6311882 Wages-Overtime 51.84 - 51.84 10,031.77 13,426.00 (3,394.23) 16,234.00 6,202.23 38.2%Total-CM-SALARIES & BENEFITS69,779.77 75,729.00 (5,949.23) 421,065.70 469,982.00 (48,916.30) 927,643.00 506,577.30 54.6%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 500.00 2,200.00 (1,700.00) 22,490.58 18,900.00 3,590.58 29,300.00 6,809.42 23.2%6313744 Fertilizer 16,263.82 10,500.00 5,763.82 74,953.60 58,700.00 16,253.60 92,200.00 17,246.40 18.7%6313745 Herbicides 1,976.38 5,000.00 (3,023.62) 6,233.94 10,000.00 (3,766.06) 10,000.00 3,766.06 37.7%6313746 Flowers/Plants - 1,000.00 (1,000.00) 1,778.05 2,250.00 (471.95) 3,500.00 1,721.95 49.2%6313748 Fuel-Gasoline 1,922.29 3,100.00 (1,177.71) 21,294.83 24,730.00 (3,435.17) 43,100.00 21,805.17 50.6%6313750 Golf Course Accessories 478.04 500.00 (21.96) 12,942.62 7,300.00 5,642.62 8,000.00 (4,942.62) -61.8%6313756 POA Control 205.00 - 205.00 7,699.19 3,500.00 4,199.19 7,000.00 (699.19) -10.0%6313758 Miscellaneous Supp 392.84 500.00 (107.16) 3,104.55 3,750.00 (645.45) 4,350.00 1,245.45 0.0%6313762 Supplies-Office 43.46 - 43.46 386.12 - 386.12 - (386.12) 0.0%6313774 Sand - 800.00 (800.00) 5,683.93 10,580.00 (4,896.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 - 350.00 (350.00) 88,921.88 89,710.00 (788.12) 91,810.00 2,888.12 3.1%6313778 Small Tools & Non-Capital Equip 28.58 100.00 (71.42) 3,590.45 4,400.00 (809.55) 5,000.00 1,409.55 28.2%6313780 Sod 1,674.75 250.00 1,424.75 9,039.15 3,750.00 5,289.15 5,750.00 (3,289.15) -57.2%6313782 Topdressing 552.02 - 552.02 3,642.00 5,000.00 (1,358.00) 7,600.00 3,958.00 52.1%Total-CM-SUPPLIES & MATERIALS24,037.18 24,300.00 (262.82) 264,061.58 242,570.00 21,491.58 319,070.00 55,008.42 17.2%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 311.00 2,500.00 (2,189.00) 11,671.20 9,000.00 2,671.20 17,000.00 5,328.80 31.3%6315685 CM-R&M-Bldngs & Othr Structures 300.50 - 300.50 1,218.98 750.00 468.98 1,750.00 531.02 30.3%6315690 CM-R&M-Equipment 1,107.85 1,500.00 (392.15) 25,760.19 26,700.00 (939.81) 35,700.00 9,939.81 27.8%6315692 CM-R&M-Irrigation System - 550.00 (550.00) 12,200.38 9,850.00 2,350.38 16,050.00 3,849.62 24.0%6315696 CM-R&M-Pumps 213.85 1,000.00 (786.15) 6,298.65 6,000.00 298.65 10,500.00 4,201.35 40.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 1,933.20 5,550.00 (3,616.80) 60,484.99 56,350.00 4,134.99 91,050.00 30,565.01 33.6%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs 5.38 - 5.38 31.01 - 31.01 (31.01) 0.0%6317836 Utilities-Natural Gas/LPG - 50.00 (50.00) - 300.00 (300.00) 600.00 600.00 0.0%6317840 Telephones 817.40 850.00 (32.60) 4,818.37 5,100.00 (281.63) 10,200.00 5,381.63 52.8%Total-CM-UTILITIES 822.78 900.00 (77.22) 4,849.38 5,400.00 (550.62) 10,800.00 5,950.62 55.1%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 3,000.00 3,000.00 - 6,000.00 3,000.00 50.0%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) 3,414.81 3,144.00 270.81 6,288.00 2,873.19 0.0%6319150 Dues & Subscriptions - - - 18.00 400.00 (382.00) 900.00 882.00 98.0%6319170 Employee Education - 50.00 (50.00) - 300.00 (300.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental - 200.00 (200.00) 2,966.74 3,100.00 (133.26) 4,200.00 1,233.26 29.4%6319206 Licenses & Permits 228.10 - 228.10 456.20 280.00 176.20 680.00 223.80 32.9%6319490 Miscellaneous - 100.00 (100.00) 439.92 600.00 (160.08) 1,200.00 760.08 63.3%6319718 Safety Equipment & Training 436.80 200.00 236.80 2,676.47 1,700.00 976.47 2,600.00 (76.47) -2.9%6319822 Uniforms 1,418.81 820.00 598.81 5,980.89 4,920.00 1,060.89 9,840.00 3,859.11 39.2%Total-CM-OTHER EXPENSES 3,071.54 2,394.00 677.54 20,663.03 19,444.00 1,219.03 37,258.00 16,594.97 44.5%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementDecember 2009Annual Budget4 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,317.00 2,317.00 - 12,122.75 13,902.00 (1,779.25) 27,804.00 15,681.25 56.4%6321325 Insurance-Workers Comp 402.27 669.00 (266.73) 2,579.48 4,184.00 (1,604.52) 8,229.00 5,649.52 68.7%6321800 Taxes-Employer Payroll 837.94 1,458.00 (620.06) 4,737.64 9,304.00 (4,566.36) 18,154.00 13,416.36 73.9%6321880 Wages-Hourly 10,454.59 11,712.00 (1,257.41) 59,245.71 70,272.00 (11,026.29) 140,544.00 81,298.29 57.8%6321882 Wages-Overtime 13.97 - 13.97 2,199.39 4,461.00 (2,261.61) 5,272.00 3,072.61 58.3%Total-CM-LM-SALARIES & BENEFITS14,025.77 16,156.00 (2,130.23) 80,884.97 102,123.00 (21,238.03) 200,003.00 119,118.03 59.6%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools 89.11 75.00 14.11 89.11 575.00 (485.89) 1,025.00 935.89 91.3%6323788 Uniforms 195.28 290.00 (94.72) 1,091.02 1,740.00 (648.98) 3,480.00 2,388.98 68.6%Total-CM-LM-SUPPLIES & MATERIALS284.39 365.00 (80.61) 1,180.13 2,315.00 (1,134.87) 4,505.00 3,324.87 73.8%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 500.00 (500.00) - 2,500.00 (2,500.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE - 500.00 (500.00) - 2,500.00 (2,500.00) 4,250.00 4,250.00 100.0%113,954.63 125,894.00 (11,939.37) 853,189.78 900,684.00 (47,494.22) 1,594,579.00 741,389.22 46.5% December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 2,392.36 6,000.00 (3,607.64) 14,220.41 32,000.00 (17,779.59) 65,000.00 50,779.59 78.1%6337842 Utilities-Water(550.68) 1,349.00 (1,899.68) 30,379.79 12,459.00 17,920.79 21,871.00 (8,508.79) -38.9%Total-CM-WATER & ENERGY 1,841.68 7,349.00 (5,507.32) 44,600.20 44,459.00 141.20 86,871.00 42,270.80 48.7%Month to Date Year to Date Annual BudgetYear to DateSilverrock ResortCourse Maintenance Water & EnergyDecember 2009Total -COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementDecember 2009Annual BudgetMonth to Date5 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 660.00 660.00 - 3,120.00 3,120.00 - 6,960.00 3,840.00 55.2%6411320 Insurance-Group 662.00 662.00 - 2,583.60 3,972.00 (1,388.40) 7,944.00 5,360.40 67.5%6411325 Insurance-Workers Comp 430.85 1,659.00 (1,228.15) 2,011.90 6,619.00 (4,607.10) 16,162.00 14,150.10 87.6%6411800 Taxes-Employer Payroll 1,116.16 1,439.00 (322.84) 5,007.79 5,740.00 (732.21) 14,012.00 9,004.21 64.3%6411880 Wages-Hourly 11,246.23 11,555.00 (308.77) 47,870.56 46,101.00 1,769.56 112,549.00 64,678.44 57.5%6411882 Wages-Overtime 39.19 - 39.19 624.39 - 624.39 - (624.39) 0.0%Total-CBR-SALARIES & BENEFITS14,154.43 15,975.00 (1,820.57) 61,218.24 65,552.00 (4,333.76) 157,627.00 96,408.76 61.2%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 500.00 (500.00) 1,327.81 2,000.00 (672.19) 2,350.00 1,022.19 43.5%6413742 Supplies-Expendable 468.22 150.00 318.22 3,486.28 2,550.00 936.28 5,000.00 1,513.72 30.3%6413752 Supplies-Range Balls - - - 5,143.75 6,000.00 (856.25) 6,000.00 856.25 14.3%6413762 Supplies-Office - 50.00 (50.00) - 225.00 (225.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - - - 180.65 - 180.65 420.00 239.35 57.0%6413786 Supplies-Towels 391.81 72.00 319.81 1,650.27 460.00 1,190.27 892.00 (758.27) -85.0%6413796 Supplies-Bottled Water304.65 400.00 (95.35) 14,338.16 17,000.00 (2,661.84) 19,400.00 5,061.84 26.1%Total-CBR-SUPPLIES & MATERIALS1,164.68 1,172.00 (7.32) 26,126.92 28,235.00 (2,108.08) 34,587.00 8,460.08 24.5%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts 720.00 720.00 - 4,320.00 4,320.00 - 8,640.00 4,320.00 50.0%6415690 CBR-R&M-Equipment - 300.00 (300.00) 1,316.83 1,800.00 (483.17) 3,600.00 2,283.17 63.4%6415695 CBR-R&M-Cart Maintenance & Repair 54.50 250.00 (195.50) 2,955.49 2,500.00 455.49 4,000.00 1,044.51 26.1%Total-CBR-REPAIRS & MAINTENANCE 774.50 1,270.00 (495.50) 8,592.32 8,620.00 (27.68) 16,240.00 7,647.68 47.1%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps - 1,250.00 (1,250.00) 895.00 2,350.00 (1,455.00) 5,000.00 4,105.00 82.1%6419094 Contract Services-Laundry/Linen 906.75 500.00 406.75 3,887.47 3,000.00 887.47 6,000.00 2,112.53 35.2%6419220 Freight/Delivery - 75.00 (75.00) - 450.00 (450.00) 900.00 900.00 100.0%6419490 Miscellaneous - 75.00 (75.00) 640.42 500.00 140.42 1,150.00 509.58 44.3%6419820 Uniforms 920.64 - 920.64 2,817.06 3,000.00 (182.94) 5,625.00 2,807.94 49.9%Total-CBR-OTHER EXPENSES 1,827.39 1,900.00 (72.61) 8,239.95 9,300.00 (1,060.05) 18,675.00 10,435.05 55.9%TOTAL-CARTS,BAGROOM & RANGE 17,921.00 20,317.00 (2,396.00) 104,177.43 111,707.00 (7,529.57) 227,129.00 122,951.57 54.1%643-CS-SALARIES & BENEFITS6431175 Employee Meals 360.00 360.00 - 1,320.00 1,320.00 - 3,300.00 1,980.00 60.0%6431325 Insurance-Workers Comp 192.96 247.00 (54.04) 633.83 793.00 (159.17) 2,069.00 1,435.17 69.4%6431800 Taxes-Employer Payroll 613.22 538.00 75.22 1,855.68 1,734.00 121.68 4,512.00 2,656.32 58.9%6431880 Wages-Hourly 5,067.25 4,320.00 747.25 15,395.25 13,920.00 1,475.25 36,240.00 20,844.75 57.5%6431882 Wages-Overtime 18.00 - 18.00 18.00 - 18.00 - (18.00) 0.0%Total-CS-SALARIES & BENEFITS6,251.43 5,465.00 786.43 19,222.76 17,767.00 1,455.76 46,121.00 26,898.24 58.3%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) 86.90 500.00 (413.10) 1,050.00 963.10 91.7%6439490 Miscellaneous - 50.00 (50.00) - 150.00 (150.00) 200.00 200.00 100.0%6439718 Safety Equipment & Training - 50.00 (50.00) 464.47 300.00 164.47 600.00 135.53 22.6%6439820 Uniforms 250.00 75.00 175.00 1,049.20 1,125.00 (75.80) 1,900.00 850.80 44.8%Total-CS-OTHER EXPENSES 250.00 275.00 (25.00) 1,600.57 2,075.00 (474.43) 3,750.00 2,149.43 57.3%Total-COURSE SERVICES 6,501.43 5,740.00 761.43 20,823.33 19,842.00 981.33 49,871.00 29,047.67 58.2%TOTAL OUTSIDE SERVICES 24,422.43 26,057.00 (1,634.57) 125,000.76 131,549.00 (6,548.24) 277,000.00 149,849.81 54.1%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementDecember 2009Annual Budget6 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 270.43 2,400.00 (2,129.57) 4,800.00 4,529.57 94.4%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 270.43 2,400.00 (2,129.57) 4,800.00 4,529.57 94.4%65-CH-UTILITIES6507836 Utilities-Natural Gas- 300.00 (300.00) 1,090.65 1,800.00 (709.35) 3,600.00 2,509.35 69.7%6507838 Utilities-Sewer- 200.00 (200.00) - 1,200.00 (1,200.00) 2,400.00 2,400.00 100.0%6507840 Utilities-Telephone1,004.63 1,000.00 4.63 6,828.05 6,000.00 828.05 12,000.00 5,171.95 43.1%6507842 Utilities-Water337.65 200.00 137.65 3,268.49 1,200.00 2,068.49 2,400.00 (868.49) -36.2%6507844 Utilities-Cable124.95 317.00 (192.05) 1,952.25 1,902.00 50.25 3,800.00 1,847.75 48.6%Total-CH-UTILITIES 1,467.23 2,017.00 (549.77) 13,139.44 12,102.00 1,037.44 24,200.00 11,060.56 45.7%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 11,565.00 11,550.00 15.00 22,500.00 10,935.00 48.6%6509098 Contract Services-Refuse Dispose376.34 - 376.34 2,124.38 - 2,124.38 - (2,124.38) 0.0%6509099 Contract Services-Security4,756.56 4,100.00 656.56 31,803.76 24,600.00 7,203.76 49,200.00 17,396.24 35.4%6509215 Flowers & Decorations- 100.00 (100.00) - 600.00 (600.00) 2,600.00 2,600.00 100.0%6509490 Miscellaneous32.95 200.00 (167.05) 251.79 1,200.00 (948.21) 2,400.00 2,148.21 89.5%6509718 Safety Equipment & Training165.00 100.00 65.00 473.86 600.00 (126.14) 1,200.00 726.14 60.5%Total-CH-OTHER EXPENSES 7,155.85 6,325.00 830.85 46,218.79 38,550.00 7,668.79 77,900.00 31,681.21 40.7%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures731.00 200.00 531.00 4,191.28 1,200.00 2,991.28 2,400.00 (1,791.28) -74.6%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 3,113.16 2,400.00 713.16 4,800.00 1,686.84 35.1%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 135.00 2,400.00 (2,265.00) 4,800.00 4,665.00 97.2%Total-CH-REPAIRS & MAINTENANCE 731.00 1,000.00 (269.00) 7,439.44 6,000.00 1,439.44 12,000.00 4,560.56 38.0%Total CLUBHOUSE 9,354.08 9,742.00 (387.92) 67,068.10 59,052.00 8,016.10 118,900.00 9,121.12 7.7%Month to Date Year to DateSilverRock ResortClubhouse Expense StatementDecember 2009Annual Budget7 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 360.00 360.00 - 720.00 360.00 50.0%6601320 Insurance-Group 331.00 331.00 - 1,895.12 1,986.00 (90.88) 3,972.00 2,076.88 52.3%6601325 Insurance-Workers Comp 100.00 143.00 (43.00) 640.80 858.00 (217.20) 1,713.00 1,072.20 62.6%6601720 Salaries 2,500.00 2,500.00 - 15,000.00 15,000.00 - 30,000.00 15,000.00 50.0%6601800 Taxes-Employer Payroll 311.00 311.00 - 1,866.00 1,866.00 - 3,735.00 1,869.00 50.0%Total-MKT-SALARIES & BENEFITS 3,302.00 3,345.00 (43.00) 19,761.92 20,070.00 (308.08) 40,140.00 20,378.08 50.8%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 140.15 600.00 (459.85) 1,200.00 1,059.85 88.3%6603768 Supplies-Printing & Stationery - 200.00 (200.00) 837.81 3,600.00 (2,762.19) 4,425.00 3,587.19 81.1%- 300.00 (300.00) 977.96 4,200.00 (3,222.04) 5,625.00 4,647.04 82.6%66-MKT-UTILITIES6607840 Utilities-Telephone 187.85 100.00 87.85 580.16 600.00 (19.84) 1,200.00 619.84 51.7%Total-MKT-UTILITIES 187.85 100.00 87.85 580.16 600.00 (19.84) 1,200.00 619.84 51.7%66-MKT-OTHER EXPENSES6609010 Advertising 18,687.71 21,577.00 (2,889.29) 83,097.87 76,412.00 6,685.87 185,984.00 102,886.13 55.3%6609040 Business Meals - 25.00 (25.00) 25.00 150.00 (125.00) 300.00 275.00 91.7%6609080 Collateral Material - - - 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) 669.00 1,050.00 (381.00) 2,100.00 1,431.00 68.1%6609490 Miscellaneous - 50.00 (50.00) 32.00 100.00 (68.00) 350.00 318.00 90.9%6609620 Postage - 50.00 (50.00) 263.98 300.00 (36.02) 600.00 336.02 56.0%6609630 Promotion - 50.00 (50.00) - 150.00 (150.00) 700.00 700.00 0.0%6609633 Promotion-Community - 750.00 (750.00) - 2,475.00 (2,475.00) 2,925.00 2,925.00 100.0%6609634 Promotion-Media/Vendor - 500.00 (500.00) 93.42 5,500.00 (5,406.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) - 400.00 (400.00) 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES 18,786.71 23,227.00 (4,440.29) 84,484.38 90,037.00 (5,552.62) 209,794.00 118,903.04 56.7%Total-MARKETING 22,276.56 26,972.00 (4,695.44) 105,804.42 114,907.00 (9,102.58) 256,759.00 144,548.00 56.3%Month to Date Year to DateSilverRock ResortMarketing Expense StatementDecember 2009Annual Budget8 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 1,080.00 1,080.00 - 2,160.00 1,080.00 50.0%6701320 Insurance-Group1,458.00 1,458.00 - 8,139.04 8,748.00 (608.96) 17,496.00 9,356.96 53.5%6701325 Insurance-Workers Comp572.97 981.00 (408.03) 3,786.47 5,886.00 (2,099.53) 11,772.00 7,985.53 67.8%6701720 Salaries 14,087.07 14,534.00 (446.93) 81,473.08 87,204.00 (5,730.92) 174,408.00 92,934.92 53.3%6701800 Taxes-Employer Payroll 1,043.58 2,140.00 (1,096.42) 6,750.04 12,840.00 (6,089.96) 25,680.00 18,929.96 73.7%6701880 Wages-Hourly961.88 2,654.00 (1,692.12) 8,170.18 15,924.00 (7,753.82) 31,848.00 23,677.82 74.3%6701882 Wages-Overtime - - - 5.91 - 5.91 - (5.91) 0.0%Total-G&A-SALARIES & BENEFITS 18,303.50 21,947.00 (3,643.50) 109,404.72 131,682.00 (22,277.28) 263,364.00 153,959.28 58.5%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 800.00 (800.00) 1,199.16 4,800.00 (3,600.84) 10,800.00 9,600.84 88.9%6703762 Supplies-Office - 125.00 (125.00) 1,041.81 750.00 291.81 1,500.00 458.19 30.5%6703768 Supplies-Printing & Stationery- 400.00 (400.00) 573.66 800.00 (226.34) 3,200.00 2,626.34 82.1%6703778Supplies-Small Tools/Non-Capital - 100.00 (100.00) - 400.00 (400.00) 900.00 900.00 100.0%Total-G&A-SUPPLIES & MATERIALS - 1,425.00 (1,425.00) 2,814.63 6,750.00 (3,935.37) 16,400.00 13,585.37 82.8%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 297.97 600.00 (302.03) 1,200.00 902.03 75.2%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 297.97 600.00 (302.03) 1,200.00 902.03 75.2%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 2,400.00 2,400.00 - 4,800.00 2,400.00 50.0%6709150 Dues & Subscriptions110.00 200.00 (90.00) 110.00 550.00 (440.00) 1,500.00 1,390.00 92.7%6709180 Employee Recruiting/Relocation84.00 500.00 (416.00) 986.49 2,000.00 (1,013.51) 2,600.00 1,613.51 62.1%6709197 Equipment Rental558.10 350.00 208.10 3,059.76 2,100.00 959.76 4,200.00 1,140.24 27.1%6709202 Fees-Bank32.58 90.00 (57.42) 288.24 540.00 (251.76) 1,080.00 791.76 73.3%6709208 Fees-Payroll Processing770.90 550.00 220.90 4,161.76 3,300.00 861.76 6,600.00 2,438.24 36.9%6709220 Freight/Delivery21.39 50.00 (28.61) 109.68 300.00 (190.32) 600.00 490.32 81.7%6709490 Miscellaneous 407.30 100.00 307.30 705.09 600.00 105.09 1,200.00 494.91 41.2%6709620 Postage/Mail Services 167.02 75.00 92.02 613.81 450.00 163.81 900.00 286.19 31.8%6709625 Professional Fees- 400.00 (400.00) 2,425.04 2,400.00 25.04 4,800.00 2,374.96 49.5%6709636 Promotion/Entertainment- 100.00 (100.00) 134.78 600.00 (465.22) 2,600.00 2,465.22 94.8%6709722 Seminars & Training- 200.00 (200.00) 543.00 1,200.00 (657.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 - 75.00 (75.00) 637.62 600.00 37.62 1,050.00 412.38 39.3%Total-G&A-OTHER EXPENSES 2,551.29 3,090.00 (538.71) 16,175.27 17,140.00 (964.73) 35,430.00 19,254.73 54.3%Total-GENERAL & ADMINISTRATIVE20,854.79 26,562.00 (5,707.21) 128,692.59 156,172.00 (27,479.41) 316,394.00 187,701.41 59.3%Month to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementDecember 2009Annual Budget9 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,581.04 11,581.00 0.04 69,486.24 69,486.00 0.24 138,972.00 69,485.76 50.0%6800193 Equipment Leases-Course Maint 10,472.94 16,500.00 (6,027.06) 91,693.54 99,000.00 (7,306.46) 189,000.00 97,306.46 51.5%6800194 Equipment Leases-Trailer 549.50 600.00 (50.50) 3,268.50 3,600.00 (331.50) 7,200.00 3,931.50 54.6%6800195 Equipment Leases-Software 419.00 1,372.00 (953.00) 9,797.65 8,232.00 1,565.65 8,232.00 (1,565.65) -19.0%6800196 Equipment Leases-GPS 7,942.00 7,400.00 542.00 42,860.51 44,400.00 (1,539.49) 88,800.00 45,939.49 51.7%6800197 Equipment Leases-Others 2,662.64 - 2,662.64 15,765.29 - 15,765.29 - - 0.0%Total-LEASES 33,627.12 37,453.00 (3,825.88) 232,871.73 224,718.00 8,153.73 432,204.00 215,097.56 49.8%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 11,233.75 11,445.00 (211.25) 70,378.36 84,757.00 (14,378.64) 90,000.00 19,621.64 21.8%6900210 FF&E Reserve 5,373.22 5,153.00 220.22 19,854.41 18,283.00 1,571.41 59,610.00 39,755.59 66.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 7,700.54 3,500.00 4,200.54 17,755.64 21,000.00 (3,244.36) 42,000.00 24,244.36 57.7%Total-MISC OTHER EXPENSES24,307.51 20,098.00 4,209.51 118,766.11 144,040.00 (25,273.89) 211,610.00 92,843.89 43.9%Silverrock ResortOperating Leases & Miscellaneous Other Expense StatementDecember 2009Annual BudgetMonth to Date Year to Date10 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2009-20102009 2009 2009 2009 2009 2009Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia74 4Sales8PromotionGolf Industry81711 715VIPCelebrityPGA Comp70 68 67 9 44 62Charity/Gift Certificate14 10 4 20Rain/Wind Checks3 5 36 15Club Staff69 105 91 6 47 105LQ HS Golf39161 200 227 19 138 2252010 2010 2010 2010 2010 2010Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011