Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
08 February 2010 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2009 – February 2010 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 February Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 469,451.35 450,025.00 19,426.35 4.3% 1,702,821.91 1,585,256.00 117,565.91 2,980,503.00 1,277,681.09 57%401000 Miscellaneous Golf Revenue 23,187.00 15,220.00 7,967.00 52.3% 91,455.53 70,510.00 20,945.53 109,297.00 17,841.47 84%410000 Revenue-Golf Shop 45,899.58 47,000.00 (1,100.42) -2.3% 171,437.94 179,702.00 (8,264.06) 325,551.00 154,113.06 53%420000 Revenue-F&B Concession 1,500.00 1,500.00 - 0.0% 9,000.00 9,000.00 - 12,000.00 3,000.00 75%890000 Interest Income 4.55 - 4.55 0.0% 40.81 - 40.81 - (40.81) 0%Total Income540,042.48 513,745.00 26,297.48 5.1% 1,974,756.19 1,844,468.00 130,288.19 3,427,351.00 1,452,594.81 58%Cost of Goods Sold510000 COS-Golf Shop 26,330.10 24,945.00 1,385.10 -5.6% 96,744.54 95,376.10 (1,368.44) 172,786.05 76,041.51 56%Total COS26,330.10 24,945.00 1,385.10 -5.6% 96,744.54 95,376.10 (1,368.44) 172,786.05 76,041.51 56%Gross Profit513,712.38 488,800.00 24,912.38 5.1% 1,878,011.65 1,749,091.90 128,919.75 3,254,564.95 1,376,553.30 58%Expenses610000 Golf Pro Shop 20,182.48 21,726.00 1,543.52 7.1% 130,256.03 157,326.00 27,069.97 243,485.00 113,228.97 53%630000 Course Maintenance 114,586.73 116,044.00 1,457.27 1.3% 1,076,499.84 1,133,502.00 57,002.16 1,594,579.00 518,079.16 68%633000 Maintenance Water & Energy 5,246.61 7,427.00 2,180.39 29.4% 44,078.84 59,390.00 15,311.16 86,871.00 42,792.16 51%640000 Outside Services 34,491.22 27,216.00 (7,275.22) -26.7% 191,817.06 187,825.00 (3,992.06) 277,000.00 85,182.94 69%650000 Clubhouse 12,283.21 9,742.00 (2,541.21) -26.1% 88,865.66 79,936.00 (8,929.66) 118,900.00 30,034.34 75%660000 Marketing 23,589.38 32,322.00 8,732.62 27.0% 157,585.55 182,671.00 25,085.45 256,759.00 99,173.45 61%670000 General & Administrative24,106.70 26,312.00 2,205.30 8.4% 180,479.27 211,296.00 30,816.73 316,394.00 135,914.73 57%680000 Leases 19,446.94 34,581.00 15,134.06 43.8% 260,224.25 293,880.00 33,655.75 432,204.00 171,979.75 60%690000 Miscellaneous Other Expense 7,853.84 10,161.00 2,307.16 22.7% 142,473.79 161,740.00 19,266.21 211,610.00 69,136.21 67%Total Expenses261,787.11 285,531.00 23,743.89 8.3% 2,272,280.29 2,467,566.00 195,285.71 3,537,802.00 1,265,521.71 64%251,925.27 203,269.00 48,656.27 23.9%(394,268.64) (718,474.10) 324,205.46 (283,237.05) 111,031.59 139%Rounds of Golf PlayedPaid Rounds Played 4,930 4,700 230 4.9% 25,004 22,200 2,804 39,150 14,146 64%Ave $ Per Paid Round Green Fee 95.22 95.75 (0.53) -0.5% 68.10 71.41 (3.31) 76.13 8.03 89%Ave $ Per Paid Round Merchandise 9.31 10.00 (0.69) -6.9% 6.86 8.09 (1.24) 8.07 1.21 85%Ave $ Per Paid Miscellaneous 4.70 3.24 1.46 45.2% 3.66 3.18 0.48 2.06 - 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateFebruary 20101 Income February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 469,451.35 450,025.00 19,426.35 1,702,821.91 1,585,256.00 117,565.91 2,980,503.001,277,681.0957%4010000 Rider Fee 900.00 470.00 430.00 6,325.00 4,134.00 2,191.00 5,829.00-496.00109%4040000 Club Rental 2,695.00 4,700.00 (2,005.00) 12,350.00 14,326.00 (1,976.00) 26,168.0013,818.0047%4050000 Driving Range 12,517.00 7,050.00 5,467.00 39,700.00 24,550.00 15,150.00 44,300.004,600.0090%4060000 Handicap Fees 575.00 500.00 75.00 7,855.00 7,500.00 355.00 8,000.00 145.0098%4080000 GPS Advertising 1,500.00 1,000.00 500.00 1,500.00 11,000.00 (9,500.00) 12,000.00 10,500.0013%4090000 Ball Retriever/Subcontract - - - 3,587.28 3,000.00 587.28 4,000.00 412.7290%4091000 Golf Professional Rental Fee 5,000.00 1,500.00 3,500.00 19,275.00 6,000.00 13,275.00 9,000.00 -10,275.00 214%4092000 Golf Lessons - - - 863.25 - 863.25 - (863.25) 0% Total Revenue Fees 492,638.35 465,245.00 27,393.35 1,794,277.44 1,655,766.00 138,511.44 3,089,800.00 1,295,522.56 58%492,638.35 465,245.00 27,393.35 1,794,277.44 1,655,766.00 138,511.44 3,089,800.00 1,295,522.56 58%Total IncomeMonth to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueFebruary 20102 Income February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 532.10 - 532.10 3,110.51 - 3,110.51 0 04100110 Sales Hard Goods 19,827.29 16,450.00 3,377.29 65,904.67 62,896.00 3,008.67 113,943.00 48,038.33 58%4100112 Sales-Soft Goods 31,984.89 30,550.00 1,434.89 126,871.91 116,806.00 10,065.91 211,608.00 84,736.09 60%5100639 GS-Discounts-Mdse (6,444.70) - (6,444.70) (24,449.15) - (24,449.15) - 24,449.15 0% Total Revenue Golf Shop 45,899.58 47,000.00 (1,100.42) 171,437.94 179,702.00 (8,264.06) 325,551.00 157,223.57 52%COS 5100150 COS-GS-Hard Goods 8,515.01 9,047.50 (532.49) 30,549.06 34,592.80 (4,043.74) 62,668.65 32,119.59 49%5100151 COS-GS-Soft Goods 17,549.62 16,802.50 747.12 62,984.22 64,243.30 (1,259.08) 116,384.40 53,400.18 54%5100152 COS-GS-Purchase Disc (1.95) (1,293.00) 1,291.05 (477.23) (4,944.00) 4,466.77 (8,953.00) (8,475.77) -5%5100220 COS-GS-Freight Merch 267.42 388.00 (120.58) 3,688.49 1,484.00 2,204.49 2,686.00 (1,002.49) 137%Cost of Sales - Golf Shop 26,330.10 24,945.00 1,385.10 96,744.54 95,376.10 1,368.44 172,786.05 76,041.51 56%Gross Profit 19,569.48 22,055.00 (2,485.52) 74,693.40 84,325.90 (9,632.50) 152,764.95 81,182.06 47%COS % 57.4% 53.1% -4.3% 56.4% 53.1% -3.4% 53.1% 48.4% 9%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 480.00 480.00 - 3,540.00 3,540.00 - 5,400.00 1,860.00 66%6101320 Insurance Group 2,317.00 2,317.00 - 17,321.37 17,543.00 (221.63) 26,811.00 9,489.63 65%6101325 Insurance-Workers Comp 442.36 863.00 (420.64) 3,403.77 5,956.00 (2,552.23) 9,229.00 5,825.23 37%6101720 Salaries 3,663.64 3,582.00 81.64 29,072.77 28,656.00 416.77 20,796.00 (8,276.77) 140%6101800 Taxes-Employer Payroll 1,972.64 1,882.00 90.64 9,059.98 12,986.00 (3,926.02) 20,123.00 11,063.02 45%6101880 Wages-Hourly 8,817.10 11,532.00 (2,714.90) 55,370.04 75,645.00 (20,274.96) 140,831.00 85,460.96 39%6101882 Wages-Overtime 158.16 - 158.16 940.05 - 940.05 - 952.88 0%Total -PS-SALARIES & BENEFITS 17,850.90 20,656.00 (2,805.10) 118,707.98 144,326.00 (25,618.02) 223,190.00 106,374.95 52%61-PS OTHER EXPENSES6103762 Supplies-Office 162.63 200.00 (37.37) 1,811.33 2,350.00 (538.67) 2,950.00 1,138.67 61%6109090 Contract Services 500.00 500.00 - 4,000.00 4,000.00 - 6,000.00 2,000.00 67%6109220 Freight & Delivery 45.51 - 45.51 518.87 75.00 443.87 75.00 (443.87) 692%6109490 Miscellaneous 10.76 50.00 (39.24) 197.87 250.00 (52.13) 450.00 252.13 44%6109150 Dues and Subscriptions - - - - - - 2,000.00 2,000.00 0%6109500 ProShop-Over/Short (15.97) - (15.97) 21.04 - 21.04 - (21.04) 0%6109722 Seminars/Training - 35.00 (35.00) 206.00 4,135.00 (3,929.00) 5,490.00 5,284.00 4%6109810 Travel - Merchandise - 15.00 (15.00) - 30.00 (30.00) 90.00 90.00 0%6109820 Uniforms 1,323.37 200.00 1,123.37 2,308.81 1,600.00 708.81 2,400.00 91.19 96%6117840 Telephones 121.87 70.00 51.87 1,869.93 560.00 1,309.93 840.00 (1,029.93) 0%Total PS-OTHER EXPENSES 2,331.58 1,070.00 1,261.58 11,548.05 13,000.00 (1,451.95) 20,295.00 8,746.95 57%20,182.48 21,726.00 (1,543.52) 130,256.03 157,326.00 (27,069.97) 243,485.00 115,121.90 53%Net Income(613.00) 329.00 (942.00) (55,562.63) (73,000.10) 17,437.47 (90,720.05) (33,939.84) -63%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementFebruary 20103 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 1,860.00 1,920.00 (60.00) 2,880.00 1,020.00 35.4%6311320 Insurance-Group 8,740.00 8,740.00 - 70,928.62 69,920.00 1,008.62 104,880.00 33,951.38 32.4%6311325 Insurance-Workers Comp 1,936.75 3,226.00 (1,289.25) 17,802.07 26,318.00 (8,515.93) 39,329.00 21,526.93 54.7%6311720 Salaries 11,368.32 12,331.00 (962.68) 90,213.12 98,648.00 (8,434.88) 147,972.00 57,758.88 39.0%6311800 Taxes-Employer Payroll 8,421.66 7,033.00 1,388.66 41,676.95 57,936.00 (16,259.05) 86,420.00 44,743.05 51.8%6311880 Wages-Hourly 43,877.26 44,159.00 (281.74) 341,635.63 353,272.00 (11,636.37) 529,928.00 188,292.37 35.5%6311882 Wages-Overtime 90.12 - 90.12 10,247.96 13,426.00 (3,178.04) 16,234.00 5,986.04 36.9%Total-CM-SALARIES & BENEFITS74,674.11 75,729.00 (1,054.89) 574,364.35 621,440.00 (47,075.65) 927,643.00 353,278.65 38.1%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 1,811.50 2,000.00 (188.50) 24,906.75 22,900.00 2,006.75 29,300.00 4,393.25 15.0%6313744 Fertilizer 10,211.71 8,000.00 2,211.71 85,665.31 72,200.00 13,465.31 92,200.00 6,534.69 7.1%6313745 Herbicides 114.05 - 114.05 6,347.99 10,000.00 (3,652.01) 10,000.00 3,652.01 36.5%6313746 Flowers/Plants - 100.00 (100.00) 1,778.05 3,300.00 (1,521.95) 3,500.00 1,721.95 49.2%6313748 Fuel-Gasoline 4,652.20 3,000.00 1,652.20 29,922.75 30,680.00 (757.25) 43,100.00 13,177.25 30.6%6313750 Golf Course Accessories - 100.00 (100.00) 12,987.65 7,600.00 5,387.65 8,000.00 (4,987.65) -62.3%6313756 POA Control 196.32 - 196.32 7,895.51 7,000.00 895.51 7,000.00 (895.51) -12.8%6313758 Miscellaneous Supp - 100.00 (100.00) 3,817.41 3,950.00 (132.59) 4,350.00 532.59 0.0%6313762 Supplies-Office - - - 450.78 - 450.78 - (450.78) 0.0%6313774 Sand - 100.00 (100.00) 5,683.93 11,060.00 (5,376.07) 11,460.00 5,776.07 50.4%6313775 Sand-Bunkers - - - 2,300.69 - 2,300.69 - (2,300.69) 0.0%6313776 Seed - 350.00 (350.00) 88,921.88 90,410.00 (1,488.12) 91,810.00 2,888.12 3.1%6313778 Small Tools & Non-Capital Equip 25.74 100.00 (74.26) 3,768.22 4,600.00 (831.78) 5,000.00 1,231.78 24.6%6313780 Sod - - - 9,039.15 4,250.00 4,789.15 5,750.00 (3,289.15) -57.2%6313782 Topdressing - - - 3,642.00 5,000.00 (1,358.00) 7,600.00 3,958.00 52.1%Total-CM-SUPPLIES & MATERIALS17,011.52 13,850.00 3,161.52 287,128.07 272,950.00 14,178.07 319,070.00 31,941.93 10.0%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 849.75 1,500.00 (650.25) 13,767.94 11,000.00 2,767.94 17,000.00 3,232.06 19.0%6315685 CM-R&M-Bldngs & Othr Structures 90.50 250.00 (159.50) 1,481.48 1,250.00 231.48 1,750.00 268.52 15.3%6315690 CM-R&M-Equipment 1,499.96 1,500.00 (0.04) 28,102.38 29,700.00 (1,597.62) 35,700.00 7,597.62 21.3%6315692 CM-R&M-Irrigation System 854.14 1,000.00 (145.86) 14,323.00 12,050.00 2,273.00 16,050.00 1,727.00 10.8%6315696 CM-R&M-Pumps - 1,000.00 (1,000.00) 6,904.54 8,000.00 (1,095.46) 10,500.00 3,595.46 34.2%6315815 CM-R&M-Trees-Pruning Etc - - - 3,431.93 4,050.00 (618.07) 10,050.00 6,618.07 65.9%Total-CM-REPAIRS & MAINTENANCE 3,294.35 5,250.00 (1,955.65) 68,011.27 66,050.00 1,961.27 91,050.00 23,038.73 25.3%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs 4.11 - 4.11 40.50 - 40.50 (40.50) 0.0%6317836 Utilities-Natural Gas/LPG 31.93 50.00 (18.07) 60.53 400.00 (339.47) 600.00 539.47 0.0%6317840 Telephones 1,205.86 850.00 355.86 7,656.25 6,800.00 856.25 10,200.00 2,543.75 24.9%Total-CM-UTILITIES 1,241.90 900.00 341.90 7,757.28 7,200.00 557.28 10,800.00 3,042.72 28.2%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 4,000.00 4,000.00 - 6,000.00 2,000.00 33.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) 4,390.47 4,192.00 198.47 6,288.00 1,897.53 0.0%6319150 Dues & Subscriptions 140.00 200.00 (60.00) 158.00 600.00 (442.00) 900.00 742.00 82.4%6319170 Employee Education 1,005.95 1,000.00 5.95 1,005.95 1,350.00 (344.05) 1,550.00 544.05 35.1%6319197 Equipment Rental - 200.00 (200.00) 2,966.74 3,500.00 (533.26) 4,200.00 1,233.26 29.4%6319206 Licenses & Permits - - - 570.25 280.00 290.25 680.00 109.75 16.1%6319490 Miscellaneous - 100.00 (100.00) 439.92 800.00 (360.08) 1,200.00 760.08 63.3%6319718 Safety Equipment & Training 85.81 200.00 (114.19) 3,215.01 2,100.00 1,115.01 2,600.00 (615.01) -23.7%6319822 Uniforms 1,175.23 820.00 355.23 8,066.25 6,560.00 1,506.25 9,840.00 1,773.75 18.0%Total-CM-OTHER EXPENSES 3,394.82 3,544.00 (149.18) 26,522.59 25,382.00 1,140.59 37,258.00 10,735.41 28.8%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementFebruary 2010Annual Budget4 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,317.00 2,317.00 - 16,756.75 18,536.00 (1,779.25) 27,804.00 11,047.25 39.7%6321325 Insurance-Workers Comp 352.18 669.00 (316.82) 3,325.42 5,522.00 (2,196.58) 8,229.00 4,903.58 59.6%6321800 Taxes-Employer Payroll 1,408.27 1,458.00 (49.73) 7,667.34 12,220.00 (4,552.66) 18,154.00 10,486.66 57.8%6321880 Wages-Hourly 10,062.25 11,712.00 (1,649.75) 80,558.18 93,696.00 (13,137.82) 140,544.00 59,985.82 42.7%6321882 Wages-Overtime - - - 2,199.39 4,461.00 (2,261.61) 5,272.00 3,072.61 58.3%Total-CM-LM-SALARIES & BENEFITS14,139.70 16,156.00 (2,016.30) 110,507.08 134,435.00 (23,927.92) 200,003.00 89,495.92 44.7%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 89.11 725.00 (635.89) 1,025.00 935.89 91.3%6323788 Uniforms 226.18 290.00 (63.82) 1,515.94 2,320.00 (804.06) 3,480.00 1,964.06 56.4%Total-CM-LM-SUPPLIES & MATERIALS226.18 365.00 (138.82) 1,605.05 3,045.00 (1,439.95) 4,505.00 2,899.95 64.4%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation 604.15 250.00 354.15 604.15 3,000.00 (2,395.85) 4,250.00 3,645.85 85.8%Total-CM-LM-REPAIRS & MAINTENANCE 604.15 250.00 354.15 604.15 3,000.00 (2,395.85) 4,250.00 3,645.85 85.8%114,586.73 116,044.00 (1,457.27) 1,076,499.84 1,133,502.00 (57,002.16) 1,594,579.00 518,079.16 32.5% February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 3,967.57 6,000.00 (2,032.43) 20,326.27 44,000.00 (23,673.73) 65,000.00 44,673.73 68.7%6337842 Utilities-Water1,279.04 1,427.00 (147.96) 23,752.57 15,390.00 8,362.57 21,871.00 (1,881.57) -8.6%5,246.61 7,427.00 (2,180.39) 44,078.84 59,390.00 (15,311.16) 86,871.00 42,792.16 49.3%Silverrock ResortCourse Maintenance Expense StatementFebruary 2010Annual BudgetMonth to Date Year to DateSilverrock ResortCourse Maintenance Water & EnergyFebruary 2010Total-COURSE MAINTENANCETotal-CM-WATER & ENERGYMonth to Date Year to Date Annual Budget5 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 720.00 720.00 - 4,560.00 4,560.00 - 6,960.00 2,400.00 34.5%6411320 Insurance-Group 662.00 662.00 - 3,907.60 5,296.00 (1,388.40) 7,944.00 4,036.40 50.8%6411325 Insurance-Workers Comp 500.20 1,715.00 (1,214.80) 2,956.82 10,292.00 (7,335.18) 16,162.00 13,205.18 81.7%6411800 Taxes-Employer Payroll 2,239.93 1,487.00 752.93 8,879.06 8,925.00 (45.94) 14,012.00 5,132.94 36.6%6411880 Wages-Hourly 13,780.17 11,945.00 1,835.17 74,348.48 71,681.00 2,667.48 112,549.00 38,200.52 33.9%6411882 Wages-Overtime 511.13 - 511.13 1,144.15 - 1,144.15 - (1,144.15) 0.0%Total-CBR-SALARIES & BENEFITS18,413.43 16,529.00 1,884.43 95,796.11 100,754.00 (4,957.89) 157,627.00 61,830.89 39.2%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 671.53 75.00 596.53 2,109.78 2,150.00 (40.22) 2,350.00 240.22 10.2%6413742 Supplies-Expendable 1,043.47 1,000.00 43.47 5,543.69 3,700.00 1,843.69 5,000.00 (543.69) -10.9%6413752 Supplies-Range Balls 1,887.82 - 1,887.82 7,031.57 6,000.00 1,031.57 6,000.00 (1,031.57) -17.2%6413762 Supplies-Office - 50.00 (50.00) - 325.00 (325.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary 153.06 70.00 83.06 333.71 140.00 193.71 420.00 86.29 20.5%6413786 Supplies-Towels - 72.00 (72.00) 1,650.27 604.00 1,046.27 892.00 (758.27) -85.0%6413796 Supplies-Bottled Water175.80 400.00 (224.20) 14,719.06 17,800.00 (3,080.94) 19,400.00 4,680.94 24.1%Total-CBR-SUPPLIES & MATERIALS3,931.68 1,667.00 2,264.68 31,388.08 30,719.00 669.08 34,587.00 3,198.92 9.2%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts - 720.00 (720.00) 5,383.44 5,760.00 (376.56) 8,640.00 3,256.56 37.7%6415690 CBR-R&M-Equipment 28.61 300.00 (271.39) 1,808.44 2,400.00 (591.56) 3,600.00 1,791.56 49.8%6415695 CBR-R&M-Cart Maintenance & Repair 2,332.55 250.00 2,082.55 5,761.59 3,000.00 2,761.59 4,000.00 (1,761.59) -44.0%Total-CBR-REPAIRS & MAINTENANCE 2,361.16 1,270.00 1,091.16 12,953.47 11,160.00 1,793.47 16,240.00 3,286.53 20.2%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps 570.00 500.00 70.00 5,515.00 3,850.00 1,665.00 5,000.00 (515.00) -10.3%6419094 Contract Services-Laundry/Linen 613.73 500.00 113.73 6,032.13 4,000.00 2,032.13 6,000.00 (32.13) -0.5%6419220 Freight/Delivery - 75.00 (75.00) - 600.00 (600.00) 900.00 900.00 100.0%6419490 Miscellaneous - 75.00 (75.00) 640.42 650.00 (9.58) 1,150.00 509.58 44.3%6419820 Uniforms - - - 2,817.06 3,000.00 (182.94) 5,625.00 2,807.94 49.9%Total-CBR-OTHER EXPENSES 1,183.73 1,150.00 33.73 15,004.61 12,100.00 2,904.61 18,675.00 3,670.39 19.7%TOTAL-CARTS,BAGROOM & RANGE 25,890.00 20,616.00 5,274.00 155,142.27 154,733.00 409.27 227,129.00 71,986.73 31.7%643-CS-SALARIES & BENEFITS6431175 Employee Meals 420.00 420.00 - 2,160.00 2,160.00 - 3,300.00 1,140.00 34.5%6431325 Insurance-Workers Comp 208.10 288.00 (79.90) 1,042.14 1,369.00 (326.86) 2,069.00 1,026.86 49.6%6431800 Taxes-Employer Payroll 833.82 627.00 206.82 3,484.99 2,988.00 496.99 4,512.00 1,027.01 22.8%6431880 Wages-Hourly 5,786.83 5,040.00 746.83 26,896.50 24,000.00 2,896.50 36,240.00 9,343.50 25.8%6431882 Wages-Overtime 159.00 - 159.00 183.00 - 183.00 - (183.00) 0.0%Total-CS-SALARIES & BENEFITS7,407.75 6,375.00 1,032.75 33,766.63 30,517.00 3,249.63 46,121.00 12,354.37 26.8%643-CS-OTHER EXPENSES6433742 Supplies Expendable 1,004.44 100.00 904.44 1,091.34 700.00 391.34 1,050.00 (41.34) -3.9%6439490 Miscellaneous - - - 114.12 200.00 (85.88) 200.00 85.88 42.9%6439718 Safety Equipment & Training - 50.00 (50.00) 464.47 400.00 64.47 600.00 135.53 22.6%6439820 Uniforms 189.03 75.00 114.03 1,238.23 1,275.00 (36.77) 1,900.00 661.77 34.8%Total-CS-OTHER EXPENSES 1,193.47 225.00 968.47 2,908.16 2,575.00 333.16 3,750.00 841.84 22.4%Total-COURSE SERVICES 8,601.22 6,600.00 2,001.22 36,674.79 33,092.00 3,582.79 49,871.00 13,196.21 26.5%34,491.22 27,216.00 7,275.22 191,817.06 187,825.00 3,992.06 277,000.00 84,341.10 30.4%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementFebruary 2010Annual Budget6 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 270.43 3,200.00 (2,929.57) 4,800.00 4,529.57 94.4%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 270.43 3,200.00 (2,929.57) 4,800.00 4,529.57 94.4%65-CH-UTILITIES6507836 Utilities-Natural Gas699.19 300.00 399.19 2,419.29 2,400.00 19.29 3,600.00 1,180.71 32.8%6507838 Utilities-Sewer- 200.00 (200.00) - 1,600.00 (1,600.00) 2,400.00 2,400.00 100.0%6507840 Utilities-Telephone1,132.25 1,000.00 132.25 9,050.83 8,000.00 1,050.83 12,000.00 2,949.17 24.6%6507842 Utilities-Water254.67 200.00 54.67 3,727.51 1,600.00 2,127.51 2,400.00 (1,327.51) -55.3%6507844 Utilities-Cable326.47 317.00 9.47 2,605.19 2,536.00 69.19 3,800.00 1,194.81 31.4%Total-CH-UTILITIES 2,412.58 2,017.00 395.58 17,802.82 16,136.00 1,666.82 24,200.00 6,397.18 26.4%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 15,320.00 15,200.00 120.00 22,500.00 7,180.00 31.9%6509098 Contract Services-Refuse Dispose291.34 - 291.34 2,707.06 - 2,707.06 - (2,707.06) 0.0%6509099 Contract Services-Security6,982.56 4,100.00 2,882.56 42,399.14 32,800.00 9,599.14 49,200.00 6,800.86 13.8%6509215 Flowers & Decorations- 100.00 (100.00) - 2,200.00 (2,200.00) 2,600.00 2,600.00 100.0%6509490 Miscellaneous315.73 200.00 115.73 910.12 1,600.00 (689.88) 2,400.00 1,489.88 62.1%6509718 Safety Equipment & Training- 100.00 (100.00) 688.15 800.00 (111.85) 1,200.00 511.85 42.7%Total-CH-OTHER EXPENSES 9,414.63 6,325.00 3,089.63 62,024.47 52,600.00 9,424.47 77,900.00 15,875.53 20.4%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures456.00 200.00 256.00 5,131.78 1,600.00 3,531.78 2,400.00 (2,731.78) -113.8%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 3,501.16 3,200.00 301.16 4,800.00 1,298.84 27.1%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 135.00 3,200.00 (3,065.00) 4,800.00 4,665.00 97.2%Total-CH-REPAIRS & MAINTENANCE 456.00 1,000.00 (544.00) 8,767.94 8,000.00 767.94 12,000.00 3,232.06 26.9%12,283.21 9,742.00 2,541.21 88,865.66 79,936.00 8,929.66 118,900.00 6,464.12 5.4%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementFebruary 2010Annual Budget7 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 480.00 480.00 - 720.00 240.00 33.3%6601320 Insurance-Group 331.00 331.00 - 2,557.12 2,648.00 (90.88) 3,972.00 1,414.88 35.6%6601325 Insurance-Workers Comp 87.50 143.00 (55.50) 815.80 1,144.00 (328.20) 1,713.00 897.20 52.4%6601720 Salaries 2,500.00 2,500.00 - 20,000.00 20,000.00 - 30,000.00 10,000.00 33.3%6601800 Taxes-Employer Payroll 311.00 311.00 - 2,488.00 2,488.00 - 3,735.00 1,247.00 33.4%Total-MKT-SALARIES & BENEFITS 3,289.50 3,345.00 (55.50) 26,340.92 26,760.00 (419.08) 40,140.00 13,799.08 34.4%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 239.53 100.00 139.53 379.68 800.00 (420.32) 1,200.00 820.32 68.4%6603768 Supplies-Printing & Stationery 65.42 125.00 (59.58) 1,516.25 3,925.00 (2,408.75) 4,425.00 2,908.75 65.7%304.95 225.00 79.95 1,895.93 4,725.00 (2,829.07) 5,625.00 3,729.07 66.3%66-MKT-UTILITIES6607840 Utilities-Telephone 63.66 100.00 (36.34) 750.19 800.00 (49.81) 1,200.00 449.81 37.5%Total-MKT-UTILITIES 63.66 100.00 (36.34) 750.19 800.00 (49.81) 1,200.00 449.81 37.5%66-MKT-OTHER EXPENSES6609010 Advertising 18,964.32 26,777.00 (7,812.68) 124,134.55 131,126.00 (6,991.45) 185,984.00 61,849.45 33.3%6609040 Business Meals - 25.00 (25.00) 25.00 200.00 (175.00) 300.00 275.00 91.7%6609080 Collateral Material - 500.00 (500.00) 2,174.61 6,500.00 (4,325.39) 9,000.00 6,825.39 75.8%6609102 Contract Services-Web Page 594.00 175.00 419.00 1,362.00 1,400.00 (38.00) 2,100.00 738.00 35.1%6609490 Miscellaneous - 50.00 (50.00) 32.00 200.00 (168.00) 350.00 318.00 90.9%6609620 Postage 32.61 50.00 (17.39) 296.59 400.00 (103.41) 600.00 303.41 50.6%6609630 Promotion 299.38 50.00 249.38 299.38 500.00 (200.62) 700.00 400.62 0.0%6609633 Promotion-Community 28.25 75.00 (46.75) 28.25 2,625.00 (2,596.75) 2,925.00 2,896.75 99.0%6609634 Promotion-Media/Vendor - 500.00 (500.00) 93.42 6,500.00 (6,406.58) 6,500.00 - 0.0%6609150 Dues and Subscriptions - 400.00 (400.00) 140.00 435.00 (295.00) 735.00 595.00 81.0%6609820 Uniforms 12.71 50.00 (37.29) 12.71 500.00 (487.29) 600.00 587.29 97.9%Total-MKT-OTHER EXPENSES 19,931.27 28,652.00 (8,720.73) 128,598.51 150,386.00 (21,787.49) 209,794.00 74,788.91 35.6%23,589.38 32,322.00 (8,732.62) 157,585.55 182,671.00 (25,085.45) 256,759.00 92,766.87 36.1%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementFebruary 2010Annual Budget8 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 1,440.00 1,440.00 - 2,160.00 720.00 33.3%6701320 Insurance-Group1,458.00 1,458.00 - 11,055.04 11,664.00 (608.96) 17,496.00 6,440.96 36.8%6701325 Insurance-Workers Comp550.02 981.00 (430.98) 4,921.46 7,848.00 (2,926.54) 11,772.00 6,850.54 58.2%6701720 Salaries 13,863.47 14,534.00 (670.53) 110,318.04 116,272.00 (5,953.96) 174,408.00 64,089.96 36.7%6701800 Taxes-Employer Payroll 1,668.43 2,140.00 (471.57) 10,271.40 17,120.00 (6,848.60) 25,680.00 15,408.60 60.0%6701880 Wages-Hourly1,851.30 2,654.00 (802.70) 11,748.36 21,232.00 (9,483.64) 31,848.00 20,099.64 63.1%6701882 Wages-Overtime - - - 10.97 - 10.97 - (10.97) 0.0%Total-G&A-SALARIES & BENEFITS 19,571.22 21,947.00 (2,375.78) 149,765.27 175,576.00 (25,810.73) 263,364.00 113,598.73 43.1%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 800.00 (800.00) 1,636.57 7,600.00 (5,963.43) 10,800.00 9,163.43 84.8%6703762 Supplies-Office 32.16 125.00 (92.84) 1,404.94 1,000.00 404.94 1,500.00 95.06 6.3%6703768 Supplies-Printing & Stationery298.09 400.00 (101.91) 1,271.35 1,600.00 (328.65) 3,200.00 1,928.65 60.3%6703778Supplies-Small Tools/Non-Capital - 100.00 (100.00) - 600.00 (600.00) 900.00 900.00 100.0%Total-G&A-SUPPLIES & MATERIALS 330.25 1,425.00 (1,094.75) 4,312.86 10,800.00 (6,487.14) 16,400.00 12,087.14 73.7%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 297.97 800.00 (502.03) 1,200.00 902.03 75.2%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 297.97 800.00 (502.03) 1,200.00 902.03 75.2%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 3,200.00 3,200.00 - 4,800.00 1,600.00 33.3%6709150 Dues & Subscriptions284.00 150.00 134.00 394.00 850.00 (456.00) 1,500.00 1,106.00 73.7%6709180 Employee Recruiting/Relocation116.00 200.00 (84.00) 1,158.49 2,400.00 (1,241.51) 2,600.00 1,441.51 55.4%6709197 Equipment Rental455.90 350.00 105.90 4,181.79 2,800.00 1,381.79 4,200.00 18.21 0.4%6709202 Fees-Bank94.34 90.00 4.34 431.59 720.00 (288.41) 1,080.00 648.41 60.0%6709208 Fees-Payroll Processing744.03 550.00 194.03 6,215.21 4,400.00 1,815.21 6,600.00 384.79 5.8%6709220 Freight/Delivery- 50.00 (50.00) 195.65 400.00 (204.35) 600.00 404.35 67.4%6709490 Miscellaneous 3.44 100.00 (96.56) 815.71 800.00 15.71 1,200.00 384.29 32.0%6709620 Postage/Mail Services 133.26 75.00 58.26 975.87 600.00 375.87 900.00 (75.87) -8.4%6709625 Professional Fees1,828.75 400.00 1,428.75 5,073.95 3,200.00 1,873.95 4,800.00 (273.95) -5.7%6709636 Promotion/Entertainment- 100.00 (100.00) 2,134.78 2,200.00 (65.22) 2,600.00 465.22 17.9%6709722 Seminars & Training145.51 200.00 (54.49) 688.51 1,600.00 (911.49) 2,400.00 1,711.49 71.3%6709810 Travel - 100.00 (100.00) - 200.00 (200.00) 1,100.00 1,100.00 100.0%6709820 Uniforms - 75.00 (75.00) 637.62 750.00 (112.38) 1,050.00 412.38 39.3%Total-G&A-OTHER EXPENSES 4,205.23 2,840.00 1,365.23 26,103.17 24,120.00 1,983.17 35,430.00 9,326.83 26.3%24,106.70 26,312.00 (2,205.30) 180,479.27 211,296.00 (30,816.73) 316,394.00 135,914.73 43.0%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementFebruary 2010Annual Budget9 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 8,785.41 11,581.00 (2,795.59) 87,057.06 92,648.00 (5,590.94) 138,972.00 51,914.94 37.4%6800193 Equipment Leases-Course Maint 229.31 15,000.00 (14,770.69) 80,610.80 129,000.00 (48,389.20) 189,000.00 108,389.20 57.3%6800194 Equipment Leases-Trailer 540.00 600.00 (60.00) 4,348.50 4,800.00 (451.50) 7,200.00 2,851.50 39.6%6800195 Equipment Leases-Software 419.00 - 419.00 10,635.65 8,232.00 2,403.65 8,232.00 (2,403.65) -29.2%6800196 Equipment Leases-GPS 7,942.00 7,400.00 542.00 58,744.51 59,200.00 (455.49) 88,800.00 30,055.49 33.8%6800197 Equipment Leases-Others 1,531.22 - 1,531.22 18,827.73 - 18,827.73 - - 0.0%19,446.94 34,581.00 (15,134.06) 260,224.25 293,880.00 (33,655.75) 432,204.00 190,807.48 44.1%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee (3,292.63) (2,340.00) (952.63) 77,693.12 82,034.00 (4,340.88) 90,000.00 12,306.88 13.7%6900210 FF&E Reserve 9,389.03 9,001.00 388.03 34,056.45 31,706.00 2,350.45 59,610.00 25,553.55 42.9%6900800 Personal Property Taxes 800.00 - 800.00 11,577.70 20,000.00 (8,422.30) 20,000.00 8,422.30 42.1%6900323 Insurance-Commercial 957.44 3,500.00 (2,542.56) 19,146.52 28,000.00 (8,853.48) 42,000.00 22,853.48 54.4%7,853.84 10,161.00 (2,307.16) 142,473.79 161,740.00 (19,266.21) 211,610.00 69,136.21 32.7%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementFebruary 201010 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 CategoryJanuaryFebruaryMarchAprilMayJuneMediaSales4PromotionGolf Industry26 6VIPCelebrityPGA Comp91 53Charity/Gift Certificate416Rain/Wind Checks93Club Staff63 113LQ HS Golf197191000011