Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
07 January 2009 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2008 – January 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 January Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 221,777.26 244,400.00 (22,622.74) -9.3% 1,139,768.76 1,281,858.00 (142,089.24) 3,255,761.00 2,115,992.24 35%401000 Miscellaneous Golf Revenue 13,347.80 8,790.00 4,557.80 51.9% 57,701.53 56,977.00 724.53 113,217.00 55,515.47 51%410000 Revenue-Golf Shop 45,263.23 52,000.00 (6,736.77) -13.0% 143,017.14 173,951.00 (30,933.86) 375,951.00 232,933.86 38%420000 Revenue-F&B Concession 1,500.00 1,500.00 - 0.0% 7,500.00 7,500.00 - 12,000.00 4,500.00 63%890000 Interest Income 3.17 - 3.17 0.0% 54.68 - 54.68 - (54.68) 0%Total Income281,891.46 306,690.00 (24,798.54) -8.1% 1,348,042.11 1,520,286.00 (172,243.89) 3,756,929.00 2,408,886.89 36%Cost of Goods Sold510000 COS-Golf Shop 28,309.29 27,599.00 710.29 -2.6% 82,404.47 92,324.00 9,919.53 199,538.00 117,133.53 41%Total COS28,309.29 27,599.00 710.29 -2.6% 82,404.47 92,324.00 9,919.53 199,538.00 117,133.53 41%Gross Profit253,582.17 279,091.00 (25,508.83) -9.1% 1,265,637.64 1,427,962.00 (162,324.36) 3,557,391.00 2,291,753.36 36%Expenses610000 Golf Pro Shop 21,757.60 27,382.00 5,624.40 20.5% 132,122.42 154,592.00 22,469.58 279,518.00 147,395.58 47%630000 Course Maintenance 126,102.21 135,171.00 9,068.79 6.7% 1,104,929.48 1,141,476.00 36,546.52 1,805,855.00 700,925.52 61%640000 Outside Services 32,079.52 28,641.00 (3,438.52) -12.0% 153,435.08 158,792.00 5,356.92 294,037.00 140,601.92 52%650000 Clubhouse 13,652.38 15,242.00 1,589.62 10.4% 94,368.06 98,894.00 4,525.94 168,104.00 73,735.94 56%660000 Marketing 34,608.22 38,823.00 4,214.78 10.9% 170,492.82 174,766.00 4,273.18 298,081.00 127,588.18 57%670000 General & Administrative 28,832.42 31,382.00 2,549.58 8.1% 169,819.98 196,574.00 26,754.02 333,834.00 164,014.02 51%680000 Leases 39,277.79 41,106.00 1,828.21 4.4% 283,855.73 287,742.00 3,886.27 493,272.00 209,416.27 58%690000 Miscellaneous Other Expense 12,407.52 10,497.00 (1,910.52) -18.2% 144,045.43 152,432.00 8,386.57 227,140.00 83,094.57 63%Total Expenses308,717.66 328,244.00 19,526.34 5.9% 2,253,069.00 2,365,268.00 112,199.00 3,899,841.00 1,646,772.00 58%Net Income (55,135.49) (49,153.00) (5,982.49) -12.2%(987,431.36) (937,306.00) (50,125.36) (342,450.00) 644,981.36 288%Rounds of Golf PlayedPaid Rounds Played 3,476 3,600 (124) -3.4% 15,289 15,950 (661) 40,580 25,291 38%Ave $ Per Paid Round Green Fee 63.80 67.89 (4.09) -6.0% 74.55 80.37 (5.82) 77.90 3.35 96%Ave $ Per Paid Round Merchandise 13.02 14.44 (1.42) -9.9% 9.35 10.91 (1.55) 8.07 (1.28) 116%Ave $ Per Paid Miscellaneous 3.84 2.44 1.40 57.3% 3.77 3.57 0.20 2.06 - 0%Month to Date Year to DateJanuary 2009SilverRock ResortSummary Operating Income Statement1 Income January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 221,777.26 244,400.00 (22,622.74) 1,139,768.76 1,281,858.00 (142,089.24) 3,255,761.002,115,992.2435%4010000 Rider Fee 325.00 260.00 65.00 3,625.00 3,724.00 (99.00) 5,984.002,359.0061%4040000 Club Rental 1,225.00 1,430.00 (205.00) 8,440.00 10,203.00 (1,763.00) 27,583.0019,143.0031%4050000 Driving Range 7,105.00 2,600.00 4,505.00 28,487.00 18,550.00 9,937.00 46,650.0018,163.0061%4060000 Handicap Fees 510.00 1,000.00 (490.00) 6,155.00 7,000.00 (845.00) 8,000.00 1,845.0077%4080000 GPS Advertising 1,500.00 1,000.00 500.00 5,075.00 10,000.00 (4,925.00) 12,000.00 6,925.0042%4090000 Ball Retriever/Subcontract 555.30 1,000.00 (444.70) 1,548.70 3,000.00 (1,451.30) 4,000.00 2,451.3039%4091000 Golf Professional Rental Fee 2,000.00 1,500.00 500.00 3,750.00 4,500.00 (750.00) 9,000.00 5,250.00 42%4092000 Golf Lessons 127.50 - 127.50 620.83 - 620.83 - (620.83) 0% Total Revenue Fees 235,125.06 253,190.00 (18,064.94) 1,197,470.29 1,338,835.00 (141,364.71) 3,368,978.00 2,171,507.71 36%Total Income 235,125.06 253,190.00 (18,064.94) 1,197,470.29 1,338,835.00 (141,364.71) 3,368,978.00 2,171,507.71 36%Month to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueJanuary 20092 Income January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 443.00 - 443.00 4,978.00 - 4,978.00 4100110 Sales Hard Goods 14,561.11 18,200.00 (3,638.89) 62,706.81 60,883.00 1,823.81 131,583.00 68,876.19 48%4100112 Sales-Soft Goods 34,673.67 33,800.00 873.67 98,820.50 113,068.00 (14,247.50) 244,368.00 145,547.50 40%5100639 GS-Discounts-Mdse (4,414.55) - (4,414.55) (23,488.17) - (23,488.17) - 23,488.17 0% Total Revenue Golf Shop 45,263.23 52,000.00 (6,736.77) 143,017.14 173,951.00 (30,933.86) 375,951.00 237,911.86 37%COS 5100150 COS-GS-Hard Goods 11,071.30 10,010.00 1,061.30 34,774.43 33,486.00 1,288.43 72,373.00 37,598.57 48%5100151 COS-GS-Soft Goods 16,245.06 18,590.00 (2,344.94) 45,117.47 62,187.00 (17,069.53) 134,404.00 89,286.53 34%5100152 COS-GS-Purchase Disc (90.26) (1,430.00) 1,339.74 (176.77) (4,784.00) 4,607.23 (10,341.00) (10,164.23) -2%5100220 COS-GS-Freight Merch 1,083.19 429.00 654.19 2,689.34 1,435.00 1,254.34 3,102.00 412.66 87%Cost of Sales - Golf Shop 28,309.29 27,599.00 710.29 82,404.47 92,324.00 (9,919.53) 199,538.00 117,133.53 41%Gross Profit 16,953.94 24,401.00 (7,447.06) 60,612.67 81,627.00 (21,014.33) 176,413.00 120,778.33 32%COS % 62.5% 53.1% -9.5% 57.6% 53.1% -4.5% 53.1% 49.2% 7%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 3,522.37 3,150.00 372.37 18,567.92 20,700.00 (2,132.08) 36,450.00 17,882.08 51%6101325 Insurance-Workers Comp 415.33 1,442.00 (1,026.67) 3,163.21 8,080.00 (4,916.79) 14,771.00 11,607.79 21%6101720 Salaries 6,045.46 6,082.00 (36.54) 41,804.15 41,049.00 755.15 71,459.00 29,654.85 59%6101800 Taxes-Employer Payroll 1,884.04 2,189.00 (304.96) 7,122.05 12,269.00 (5,146.95) 22,431.00 15,308.95 32%6101880 Wages-Hourly 6,615.23 11,504.00 (4,888.77) 43,662.94 57,504.00 (13,841.06) 108,712.00 65,049.06 40%6101882 Wages-Overtime 1,183.60 - 1,183.60 1,541.49 - 1,541.49 - 952.88 0%Total -PS-SALARIES & BENEFITS 20,146.03 24,847.00 (4,700.97) 118,921.76 142,662.00 (23,740.24) 259,223.00 142,795.61 45%61-PS OTHER EXPENSES6103762 Supplies-Office 269.33 150.00 119.33 3,435.52 2,150.00 1,285.52 2,950.00 (485.52) 116%6109090 Contract Services 500.00 500.00 - 3,500.00 3,500.00 - 6,000.00 2,500.00 58%6109220 Freight & Delivery - - - 535.01 75.00 460.01 75.00 (460.01) 713%6109490 Miscellaneous 38.79 50.00 (11.21) 369.68 200.00 169.68 450.00 80.32 82%6109150 Dues and Subscriptions - - - 267.23 - 267.23 2,000.00 1,732.77 13%6109500 ProShop-Over/Short 44.58 - 44.58 134.00 - 134.00 (134.00) 0%6109722 Seminars/Training - 1,250.00 (1,250.00) 2,315.00 4,100.00 (1,785.00) 5,490.00 3,175.00 42%6109810 Travel - Merchandise - 15.00 (15.00) - 15.00 (15.00) 90.00 90.00 0%6109820 Uniforms 326.52 500.00 (173.48) 1,348.00 1,400.00 (52.00) 2,400.00 1,052.00 56%6117840 Telephones 432.35 70.00 362.35 1,296.22 490.00 806.22 840.00 (456.22) 0%Total PS-OTHER EXPENSES 1,611.57 2,535.00 (923.43) 13,200.66 11,930.00 1,270.66 20,295.00 7,094.34 65%Total Expenses21,757.60 27,382.00 (5,624.40) 132,122.42 154,592.00 (22,469.58) 279,518.00 149,889.95 46%Net Income(4,803.66) (2,981.00) (1,822.66) (71,509.75) (72,965.00) 1,455.25 (103,105.00) (29,111.62) -72%Month to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementJanuary 20093 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 9,196.09 12,083.00 (2,886.91) 78,515.98 84,581.00 (6,065.02) 144,996.00 66,480.02 45.8%6311325 Insurance-Workers Comp 2,755.55 4,841.00 (2,085.45) 15,005.15 34,651.00 (19,645.85) 59,020.00 44,014.85 74.6%6311720 Salaries 11,001.60 12,331.00 (1,329.40) 80,121.60 86,317.00 (6,195.40) 147,978.00 67,856.40 45.9%6311800 Taxes-Employer Payroll 8,123.41 7,350.00 773.41 38,922.07 53,189.00 (14,266.93) 90,311.00 51,388.93 56.9%6311880 Wages-Hourly 47,516.47 46,708.00 808.47 323,067.27 326,956.00 (3,888.73) 560,520.00 237,452.73 42.4%6311882 Wages-Overtime - - - 22,939.18 13,966.00 8,973.18 16,894.00 (6,045.18) -35.8%Total-CM-SALARIES & BENEFITS78,833.12 83,553.00 (4,719.88) 560,251.25 601,340.00 (41,088.75) 1,022,599.00 462,347.75 45.2%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 3,317.10 2,000.00 1,317.10 25,216.17 16,800.00 8,416.17 25,200.00 (16.17) -0.1%6313744 Fertilizer 6,617.78 5,500.00 1,117.78 72,800.19 67,200.00 5,600.19 95,200.00 22,399.81 23.5%6313746 Flowers/Plants - 950.00 (950.00) 1,800.52 3,200.00 (1,399.48) 3,500.00 1,699.48 48.6%6313748 Fuel-Gasoline 2,917.19 3,190.00 (272.81) 26,583.27 28,820.00 (2,236.73) 45,540.00 18,956.73 41.6%6313750 Golf Course Accessories 316.33 200.00 116.33 9,159.47 6,500.00 2,659.47 7,000.00 (2,159.47) -30.8%6313756 POA Control 2,957.74 3,000.00 (42.26) 6,965.13 6,000.00 965.13 6,000.00 (965.13) -16.1%6313758 Miscellaneous Supp 535.50 100.00 435.50 3,703.48 700.00 3,003.48 - (3,703.48) 0.0%6313762 Supplies-Office 125.92 - 125.92 432.89 - 432.89 1,200.00 767.11 63.9%6313774 Sand - 380.00 (380.00) 5,696.11 6,160.00 (463.89) 6,660.00 963.89 14.5%6313775 Sand-Bunkers - - - 3,702.67 5,000.00 (1,297.33) 5,000.00 1,297.33 25.9%6313776 Seed - 350.00 (350.00) 109,819.49 100,060.00 9,759.49 101,810.00 (8,009.49) -7.9%6313778 Small Tools & Non-Capital Equip 56.63 100.00 (43.37) 4,638.80 6,500.00 (1,861.20) 7,000.00 2,361.20 33.7%6313780 Sod - 500.00 (500.00) 5,159.85 4,250.00 909.85 5,750.00 590.15 10.3%6313782 Topdressing - - - 5,035.98 5,000.00 35.98 7,600.00 2,564.02 33.7%Total-CM-SUPPLIES & MATERIALS16,844.19 16,270.00 574.19 280,714.02 256,190.00 24,524.02 317,460.00 36,745.98 11.6%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,384.75 500.00 884.75 10,483.35 8,500.00 1,983.35 16,000.00 5,516.65 34.5%6315685 CM-R&M-Bldngs & Othr Structures 87.50 250.00 (162.50) 1,163.50 250.00 913.50 500.00 (663.50) -132.7%6315690 CM-R&M-Equipment 2,468.51 3,500.00 (1,031.49) 34,249.24 36,200.00 (1,950.76) 46,100.00 11,850.76 25.7%6315692 CM-R&M-Irrigation System 1,105.31 1,200.00 (94.69) 11,033.97 10,450.00 583.97 15,450.00 4,416.03 28.6%6315696 CM-R&M-Pumps - 1,000.00 (1,000.00) 5,227.44 7,000.00 (1,772.56) 10,500.00 5,272.56 50.2%6315815 CM-R&M-Trees-Pruning Etc - - - 4,054.64 3,000.00 1,054.64 9,000.00 4,945.36 54.9%Total-CM-REPAIRS & MAINTENANCE 5,046.07 6,450.00 (1,403.93) 66,212.14 65,400.00 812.14 97,550.00 31,337.86 32.1%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs 5.38 - 5.38 37.66 - 37.66 - (37.66) 0.0%6317836 Utilities-Natural Gas/LPG - 150.00 (150.00) - 1,050.00 (1,050.00) 1,800.00 1,800.00 0.0%6317840 Telephones 917.05 800.00 117.05 5,938.60 5,600.00 338.60 9,600.00 3,661.40 38.1%Total-CM-UTILITIES 922.43 950.00 (27.57) 5,976.26 6,650.00 (673.74) 11,400.00 5,423.74 47.6%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 524.05 - 524.05 3,531.21 - 3,531.21 - (3,531.21) 0.0%6319150 Dues & Subscriptions - - - 455.00 400.00 55.00 900.00 445.00 49.4%6319170 Employee Education - 50.00 (50.00) - 350.00 (350.00) 600.00 600.00 100.0%6319197 Equipment Rental - 200.00 (200.00) 2,946.41 3,300.00 (353.59) 4,200.00 1,253.59 29.8%6319206 Licenses & Permits - - - 60.00 200.00 (140.00) 1,600.00 1,540.00 96.3%6319490 Miscellaneous - 100.00 (100.00) 143.02 700.00 (556.98) 1,200.00 1,056.98 88.1%6319718 Safety Equipment & Training 107.13 200.00 (92.87) 2,044.45 2,700.00 (655.55) 3,400.00 1,355.55 39.9%6319822 Uniforms 727.31 820.00 (92.69) 5,042.53 5,740.00 (697.47) 9,840.00 4,797.47 48.8%Total-CM-OTHER EXPENSES 1,858.49 1,870.00 (11.51) 19,222.62 18,890.00 332.62 31,740.00 12,517.38 39.4%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementJanuary 2009Annual Budget4 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,149.50 1,104.00 45.50 8,725.50 7,728.00 997.50 13,248.00 4,522.50 34.1%6321325 Insurance-Workers Comp 380.87 1,078.00 (697.13) 3,076.46 7,818.00 (4,741.54) 13,257.00 10,180.54 76.8%6321800 Taxes-Employer Payroll 2,016.14 1,636.00 380.14 8,158.51 12,075.00 (3,916.49) 20,368.00 12,209.49 59.9%6321880 Wages-Hourly 12,695.53 13,141.00 (445.47) 90,129.42 91,987.00 (1,857.58) 157,692.00 67,562.58 42.8%6321882 Wages-Overtime - - - 5,085.55 5,005.00 80.55 5,915.00 829.45 14.0%Total-CM-LM-SALARIES & BENEFITS16,242.04 16,959.00 (716.96) 115,175.44 124,613.00 (9,437.56) 210,480.00 95,304.56 45.3%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 367.79 650.00 (282.21) 1,025.00 657.21 64.1%6323788 Uniforms 243.93 290.00 (46.07) 2,155.16 2,030.00 125.16 3,480.00 1,324.84 38.1%Total-CM-LM-SUPPLIES & MATERIALS243.93 365.00 (121.07) 2,522.95 2,680.00 (157.05) 4,505.00 1,982.05 44.0%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation 324.39 250.00 74.39 1,826.70 2,750.00 (923.30) 4,250.00 2,423.30 57.0%Total-CM-LM-REPAIRS & MAINTENANCE 324.39 250.00 74.39 1,826.70 2,750.00 (923.30) 4,250.00 2,423.30 57.0%632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 4,163.03 7,000.00 (2,836.97) 31,947.73 49,000.00 (17,052.27) 84,000.00 52,052.27 62.0%6337842 Utilities-Water1,624.52 1,504.00 120.52 21,080.37 13,963.00 7,117.37 21,871.00 790.63 3.6%Total-CM-WATER & ENERGY5,787.55 8,504.00 (2,716.45) 53,028.10 62,963.00 (9,934.90) 105,871.00 52,842.90 49.9%126,102.21 135,171.00 (9,068.79) 1,104,929.48 1,141,476.00 (36,546.52) 1,805,855.00 700,925.52 38.8%Total -COURSE MAINTENANCEMonth to Date Year to DateSilverrock ResortCourse Maintenance Expense StatementJanuary 2009Annual Budget5 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 600.00 600.00 - 3,420.00 3,420.00 - 6,180.00 2,760.00 44.7%6411320 Insurance-Group 63.25 720.00 (656.75) 512.20 5,040.00 (4,527.80) 8,640.00 8,127.80 94.1%6411325 Insurance-Workers Comp 426.77 1,682.00 (1,255.23) 2,124.87 8,651.00 (6,526.13) 16,511.00 14,386.13 87.1%6411800 Taxes-Employer Payroll 1,776.90 1,459.00 317.90 7,320.94 7,503.00 (182.06) 14,318.00 6,997.06 48.9%6411880 Wages-Hourly 13,542.00 11,715.00 1,827.00 62,716.84 60,255.00 2,461.84 114,990.00 52,273.16 45.5%6411882 Wages-Overtime 683.67 - 683.67 830.23 - 830.23 - (830.23) 0.0%Total-CBR-SALARIES & BENEFITS17,092.59 16,176.00 916.59 76,925.08 84,869.00 (7,943.92) 160,639.00 83,713.92 52.1%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 360.00 75.00 285.00 847.62 2,075.00 (1,227.38) 2,350.00 1,502.38 63.9%6413742 Supplies-Expendable 448.93 150.00 298.93 3,729.25 3,550.00 179.25 5,850.00 2,120.75 36.3%6413752 Supplies-Range Balls - - - 5,820.00 6,000.00 (180.00) 6,000.00 180.00 3.0%6413762 Supplies-Office - 50.00 (50.00) - 275.00 (275.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - 70.00 (70.00) - 70.00 (70.00) 420.00 420.00 100.0%6413786 Supplies-Towels 639.39 72.00 567.39 3,974.08 1,932.00 2,042.08 2,292.00 (1,682.08) -73.4%6413796 Supplies-Bottled Water2,172.70 2,600.00 (427.30) 9,982.22 11,250.00 (1,267.78) 23,950.00 13,967.78 58.3%Total-CBR-SUPPLIES & MATERIALS3,621.02 3,017.00 604.02 24,353.17 25,152.00 (798.83) 41,387.00 17,033.83 41.2%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts 720.00 720.00 - 5,115.00 5,040.00 75.00 8,640.00 3,525.00 40.8%6415690 CBR-R&M-Equipment - 125.00 (125.00) 294.03 875.00 (580.97) 1,500.00 1,205.97 80.4%6415695 CBR-R&M-Cart Maintenance & Repair 203.55 250.00 (46.45) 3,344.73 2,750.00 594.73 4,000.00 655.27 16.4%Total-CBR-REPAIRS & MAINTENANCE 923.55 1,095.00 (171.45) 8,753.76 8,665.00 88.76 14,140.00 5,386.24 38.1%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps 2,100.00 1,000.00 1,100.00 3,745.00 3,350.00 395.00 5,000.00 1,255.00 25.1%6419094 Contract Services-Laundry/Linen 165.59 500.00 (334.41) 2,283.53 3,500.00 (1,216.47) 6,000.00 3,716.47 61.9%6419220 Freight/Delivery - 75.00 (75.00) 7.56 525.00 (517.44) 900.00 892.44 99.2%6419490 Miscellaneous - 75.00 (75.00) 506.01 575.00 (68.99) 1,150.00 643.99 56.0%6419820 Uniforms 46.20 - 46.20 1,665.22 3,000.00 (1,334.78) 5,625.00 3,959.78 70.4%Total-CBR-OTHER EXPENSES 2,311.79 1,650.00 661.79 8,207.32 10,950.00 (2,742.68) 18,675.00 10,467.68 56.1%TOTAL-CARTS,BAGROOM & RANGE 23,948.95 21,938.00 2,010.95 118,239.33 129,636.00 (11,396.67) 234,841.00 116,601.67 49.7%643-CS-SALARIES & BENEFITS6431175 Employee Meals 540.00 540.00 - 2,580.00 2,580.00 - 4,860.00 2,280.00 46.9%6431325 Insurance-Workers Comp 164.08 400.00 (235.92) 733.47 1,646.00 (912.53) 3,446.00 2,712.53 78.7%6431800 Taxes-Employer Payroll 731.94 608.00 123.94 2,712.16 2,500.00 212.16 5,220.00 2,507.84 48.0%6431880 Wages-Hourly 5,469.20 4,880.00 589.20 22,758.00 20,080.00 2,678.00 41,920.00 19,162.00 45.7%6431882 Wages-Overtime - - - 48.00 - 48.00 - (48.00) 0.0%Total-CS-SALARIES & BENEFITS6,905.22 6,428.00 477.22 28,831.63 26,806.00 2,025.63 55,446.00 26,614.37 48.0%643-CS-OTHER EXPENSES6433742 Supplies Expendable 1,225.35 100.00 1,125.35 3,705.22 600.00 3,105.22 1,050.00 (2,655.22) -252.9%6439490 Miscellaneous - 50.00 (50.00) 290.55 200.00 90.55 200.00 (90.55) -45.3%6439718 Safety Equipment & Training - 50.00 (50.00) 43.10 350.00 (306.90) 600.00 556.90 92.8%6439820 Uniforms - 75.00 (75.00) 2,325.25 1,200.00 1,125.25 1,900.00 (425.25) -22.4%Total-CS-OTHER EXPENSES 1,225.35 275.00 950.35 6,364.12 2,350.00 4,014.12 3,750.00 (2,614.12) -69.7%Total-COURSE SERVICES 8,130.57 6,703.00 1,427.57 35,195.75 29,156.00 6,039.75 59,196.00 24,000.25 40.5%TOTAL OUTSIDE SERVICES 32,079.52 28,641.00 3,438.52 153,435.08 158,792.00 (5,356.92) 294,037.00 143,216.04 48.7%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementJanuary 2009Annual Budget6 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable27.82 400.00 (372.18) 383.64 2,800.00 (2,416.36) 4,800.00 4,416.36 92.0%Total-CH-SUPPLIES & MATERIALS 27.82 400.00 (372.18) 383.64 2,800.00 (2,416.36) 4,800.00 4,416.36 92.0%65-CH-UTILITIES6507836 Utilities-Natural Gas689.68 300.00 389.68 2,460.43 2,100.00 360.43 3,600.00 1,139.57 31.7%6507838 Utilities-Sewer- 200.00 (200.00) 600.00 1,400.00 (800.00) 2,400.00 1,800.00 75.0%6507840 Utilities-Telephone1,197.39 1,000.00 197.39 7,435.20 7,000.00 435.20 12,000.00 4,564.80 38.0%6507842 Utilities-Water241.29 200.00 41.29 2,359.82 1,400.00 959.82 2,400.00 40.18 1.7%6507844 Utilities-Cable208.09 317.00 (108.91) 2,082.06 2,219.00 (136.94) 3,804.00 1,721.94 45.3%Total-CH-UTILITIES 2,336.45 2,017.00 319.45 14,937.51 14,119.00 818.51 24,204.00 9,266.49 38.3%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 13,180.00 13,375.00 (195.00) 22,500.00 9,320.00 41.4%6509099 Contract Services-Security8,395.44 8,200.00 195.44 58,588.96 57,400.00 1,188.96 98,400.00 39,811.04 40.5%6509215 Flowers & Decorations- 1,500.00 (1,500.00) - 2,100.00 (2,100.00) 2,600.00 2,600.00 100.0%6509490 Miscellaneous193.93 200.00 (6.07) 193.93 1,400.00 (1,206.07) 2,400.00 2,206.07 91.9%6509718 Safety Equipment & Training- 100.00 (100.00) - 700.00 (700.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES 10,726.11 11,825.00 (1,098.89) 74,456.81 74,975.00 (518.19) 127,100.00 52,643.19 41.4%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures272.00 200.00 72.00 2,571.00 1,400.00 1,171.00 2,400.00 (171.00) -7.1%6515686 CH-R&M-Restaurant Repairs290.00 400.00 (110.00) 2,019.10 2,800.00 (780.90) 4,800.00 2,780.90 57.9%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) - 2,800.00 (2,800.00) 4,800.00 4,800.00 100.0%Total-CH-REPAIRS & MAINTENANCE 562.00 1,000.00 (438.00) 4,590.10 7,000.00 (2,409.90) 12,000.00 7,409.90 61.7%Total CLUBHOUSE 13,652.38 15,242.00 (1,589.62) 94,368.06 98,894.00 (4,525.94) 168,104.00 14,819.80 8.8%Month to Date Year to DateSilverRock ResortClubhouse Expense StatementJanuary 2009Annual 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 283.81 450.00 (166.19) 1,657.99 3,150.00 (1,492.01) 5,400.00 3,742.01 69.3%6601325 Insurance-Workers Comp 112.50 205.00 (92.50) 612.78 1,435.00 (822.22) 2,460.00 1,847.22 75.1%6601720 Salaries 3,750.00 2,500.00 1,250.00 18,750.00 17,500.00 1,250.00 30,000.00 11,250.00 37.5%6601800 Taxes-Employer Payroll 466.50 311.00 155.50 2,643.50 2,177.00 466.50 3,732.00 1,088.50 29.2%Total-MKT-SALARIES & BENEFITS 4,672.81 3,526.00 1,146.81 24,084.27 24,682.00 (597.73) 42,312.00 18,227.73 43.1%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 700.00 (700.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery - 200.00 (200.00) 2,755.74 3,800.00 (1,044.26) 4,425.00 1,669.26 37.7%- 300.00 (300.00) 2,755.74 4,500.00 (1,744.26) 5,625.00 2,869.26 51.0%66-MKT-UTILITIES6607840 Utilities-Telephone 48.56 100.00 (51.44) 384.18 700.00 (315.82) 1,200.00 815.82 68.0%Total-MKT-UTILITIES 48.56 100.00 (51.44) 384.18 700.00 (315.82) 1,200.00 815.82 68.0%66-MKT-OTHER EXPENSES6609010 Advertising 28,236.20 31,137.00 (2,900.80) 136,700.03 127,499.00 9,201.03 225,134.00 88,433.97 39.3%6609040 Business Meals - 25.00 (25.00) - 175.00 (175.00) 300.00 300.00 100.0%6609080 Collateral Material 852.50 2,500.00 (1,647.50) 2,704.05 6,000.00 (3,295.95) 9,000.00 6,295.95 70.0%6609102 Contract Services-Web Page 594.00 175.00 419.00 1,089.00 1,225.00 (136.00) 2,100.00 1,011.00 48.1%6609490 Miscellaneous - 50.00 (50.00) - 150.00 (150.00) 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) 1.59 350.00 (348.41) 600.00 598.41 99.7%6609630 Promotion 43.21 500.00 (456.79) 2,166.57 6,000.00 (3,833.43) 6,500.00 4,333.43 0.0%6609633 Promotion-Community 160.94 75.00 85.94 197.27 2,550.00 (2,352.73) 2,925.00 2,727.73 93.3%6609634 Promotion-Media/Vendor - 300.00 (300.00) - 450.00 (450.00) 700.00 - 0.0%6609150 Dues and Subscriptions - 35.00 (35.00) 371.71 35.00 336.71 735.00 363.29 49.4%6609820 Uniforms - 50.00 (50.00) 38.41 450.00 (411.59) 600.00 561.59 93.6%Total-MKT-OTHER EXPENSES 29,886.85 34,897.00 (5,010.15) 143,268.63 144,884.00 (1,615.37) 248,944.00 104,975.37 42.2%Total-MARKETING 34,608.22 38,823.00 (4,214.78) 170,492.82 174,766.00 (4,273.18) 298,081.00 126,888.18 42.6%Month to Date Year to DateSilverRock ResortMarketing Expense StatementJanuary 2009Annual 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,170.84 2,250.00 (1,079.16) 9,739.45 15,750.00 (6,010.55) 27,000.00 17,260.55 63.9%6701325 Insurance-Workers Comp625.34 1,406.00 (780.66) 4,017.24 9,842.00 (5,824.76) 16,872.00 12,854.76 76.2%6701720 Salaries 15,903.89 14,416.00 1,487.89 102,505.28 100,912.00 1,593.28 172,992.00 70,486.72 40.7%6701800 Taxes-Employer Payroll 1,970.88 2,135.00 (164.12) 9,900.28 14,945.00 (5,044.72) 25,620.00 15,719.72 61.4%6701880 Wages-Hourly2,390.13 2,730.00 (339.87) 16,445.98 19,110.00 (2,664.02) 32,760.00 16,314.02 49.8%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 22,241.08 23,117.00 (875.92) 143,868.23 161,819.00 (17,950.77) 277,404.00 133,535.77 48.1%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer190.69 2,000.00 (1,809.31) 2,284.25 6,800.00 (4,515.75) 10,800.00 8,515.75 78.8%6703762 Supplies-Office 599.73 125.00 474.73 1,761.78 875.00 886.78 1,500.00 (261.78) -17.5%6703768 Supplies-Printing & Stationery133.95 400.00 (266.05) 911.61 1,200.00 (288.39) 3,200.00 2,288.39 71.5%6703778Supplies-Small Tools/Non-Capital - 100.00 (100.00) - 500.00 (500.00) 900.00 900.00 100.0%Total-G&A-SUPPLIES & MATERIALS 924.37 2,625.00 (1,700.63) 4,957.64 9,375.00 (4,417.36) 16,400.00 11,442.36 69.8%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 502.21 700.00 (197.79) 1,200.00 697.79 58.1%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 502.21 700.00 (197.79) 1,200.00 697.79 58.1%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%6709090 Contract Services- - - - - - - - 0.0%6709150 Dues & Subscriptions271.71 150.00 121.71 271.71 700.00 (428.29) 1,500.00 1,228.29 81.9%6709180 Employee Recruiting/Relocation- 200.00 (200.00) 557.00 4,200.00 (3,643.00) 4,600.00 4,043.00 87.9%6709197 Equipment Rental1,023.08 350.00 673.08 2,990.78 2,450.00 540.78 4,200.00 1,209.22 28.8%6709202 Fees-Bank159.75 90.00 69.75 269.75 630.00 (360.25) 1,080.00 810.25 75.0%6709208 Fees-Payroll Processing964.38 550.00 414.38 5,741.38 3,850.00 1,891.38 6,600.00 858.62 13.0%6709220 Freight/Delivery- 50.00 (50.00) - 350.00 (350.00) 600.00 600.00 100.0%6709490 Miscellaneous 48.90 100.00 (51.10) 415.00 700.00 (285.00) 1,200.00 785.00 65.4%6709620 Postage/Mail Services 91.85 75.00 16.85 992.29 525.00 467.29 900.00 (92.29) -10.3%6709625 Professional Fees- 400.00 (400.00) 2,605.16 2,800.00 (194.84) 4,800.00 2,194.84 45.7%6709636 Promotion/Entertainment2,502.34 2,900.00 (397.66) 2,705.92 3,500.00 (794.08) 4,000.00 1,294.08 32.4%6709722 Seminars & Training- 200.00 (200.00) 500.00 1,400.00 (900.00) 2,400.00 1,900.00 79.2%6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms - 75.00 (75.00) 437.95 675.00 (237.05) 1,050.00 612.05 58.3%Total-G&A-OTHER EXPENSES 5,666.97 5,540.00 126.97 20,491.90 24,680.00 (4,188.10) 38,830.00 18,543.06 47.8%Total-GENERAL & ADMINISTRATIVE28,832.42 31,382.00 (2,549.58) 169,819.98 196,574.00 (26,754.02) 333,834.00 164,218.98 49.2%Month to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementJanuary 2009Annual Budget9 January Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,581.04 11,581.00 0.04 77,523.19 81,067.00 (3,543.81) 138,972.00 61,448.81 44.2%6800193 Equipment Leases-Course Maint 16,244.12 20,000.00 (3,755.88) 114,303.13 140,000.00 (25,696.87) 240,000.00 125,696.87 52.4%6800194 Equipment Leases-Trailer 540.00 600.00 (60.00) 4,278.94 4,200.00 78.94 7,200.00 2,921.06 40.6%6800195 Equipment Leases-Software 1,791.93 1,525.00 266.93 12,543.51 10,675.00 1,868.51 18,300.00 5,756.49 31.5%6800196 Equipment Leases-GPS 6,840.14 7,400.00 (559.86) 47,880.98 51,800.00 (3,919.02) 88,800.00 40,919.02 46.1%6800197 Equipment Leases-Others 2,280.56 - 2,280.56 27,325.98 - 27,325.98 - - 0.0%Total-LEASES 39,277.79 41,106.00 (1,828.21) 283,855.73 287,742.00 (3,886.27) 493,272.00 236,742.25 48.0%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 4,467.43 863.00 3,604.43 83,041.09 77,525.00 5,516.09 90,000.00 6,958.91 7.7%6900210 FF&E Reserve 4,702.51 6,134.00 (1,431.49) 24,810.80 30,407.00 (5,596.20) 75,140.00 50,329.20 67.0%6900800 Personal Property Taxes - - - 20,812.13 20,000.00 812.13 20,000.00 (812.13) -4.1%6900323 Insurance-Commercial 3,237.58 3,500.00 (262.42) 15,381.41 24,500.00 (9,118.59) 42,000.00 26,618.59 63.4%Total-MISC OTHER EXPENSES12,407.52 10,497.00 1,910.52 144,045.43 152,432.00 (8,386.57) 227,140.00 83,094.57 36.6%Annual BudgetMonth to Date Year to Date Operating Leases & Miscellaneous Other Expense StatementJanuary 200910 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2008-20092008 2008 2008 2008 2008 2008Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia6182177Sales453PromotionGolf Industry11 16 5 5 4 16VIPCelebrityPGA Comp82 48 84 24 38 104Charity/Gift Certificate14 6 3 29 36Rain/Wind Checks66121319Club Staff137 116 113 21 45 69LQ HS Golf256 193 214 58 151 2542009 2009 2009 2009 2009 2009Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf Industry9VIPCelebrityPGA Comp48Charity/Gift Certificate7Rain/Wind Checks10Club Staff53LQ HS Golf1270000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2008-2009December 2008 Date Time Description CategoryPlayers12/6/2008 1:15 Gary Stone Media 212/11/2008 8:45 KMIR - Dean VentMedia 212/29/2008 10:30CBS2 - Debra CarabatSales312