Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
10 April 2009 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2008 – April 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 April Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 401,364.50 457,245.00 (55,880.50) -12.2% 2,521,359.27 2,833,603.00 (312,243.73) 3,255,761.00 734,401.73 77%401000 Miscellaneous Golf Revenue 15,917.25 11,410.00 4,507.25 39.5% 110,154.53 102,987.00 7,167.53 113,217.00 3,062.47 97%410000 Revenue-Golf Shop 34,464.18 48,600.00 (14,135.82) -29.1% 249,943.48 332,551.00 (82,607.52) 375,951.00 126,007.52 66%420000 Revenue-F&B Concession 500.00 500.00 - 0.0% 11,000.00 11,000.00 - 12,000.00 1,000.00 92%890000 Interest Income 7.70 - 7.70 0.0% 70.75 - 70.75 - (70.75) 0%Total Income452,253.63 517,755.00 (65,501.37) -12.7% 2,892,528.03 3,280,141.00 (387,612.97) 3,756,929.00 864,400.97 77%Cost of Goods Sold510000 COS-Golf Shop 17,964.28 25,795.00 (7,830.72) 30.4% 142,818.80 176,503.00 33,684.20 199,538.00 56,719.20 72%Total COS17,964.28 25,795.00 (7,830.72) 30.4% 142,818.80 176,503.00 33,684.20 199,538.00 56,719.20 72%Gross Profit434,289.35 491,960.00 (57,670.65) -11.7% 2,749,709.23 3,103,638.00 (353,928.77) 3,557,391.00 807,681.77 77%Expenses610000 Golf Pro Shop 19,907.40 24,952.00 5,044.60 20.2% 186,094.36 229,448.00 43,353.64 279,518.00 93,423.64 67%630000 Course Maintenance 118,930.45 125,850.00 6,919.55 5.5% 1,384,979.46 1,452,370.00 67,390.54 1,699,984.00 315,004.54 81%633000 Maintenance Water & Energy 7,004.07 8,504.00 1,499.93 17.6% 71,421.16 88,398.00 16,976.84 105,871.00 34,449.84 67%640000 Outside Services 28,749.34 28,191.00 (558.34) -2.0% 236,051.27 245,065.00 9,013.73 294,037.00 57,985.73 80%650000 Clubhouse 15,937.04 13,842.00 (2,095.04) -15.1% 139,012.75 140,420.00 1,407.25 168,104.00 29,091.25 83%660000 Marketing 25,930.52 26,503.00 572.48 2.2% 246,130.01 266,425.00 20,294.99 298,081.00 51,950.99 83%670000 General & Administrative23,290.93 27,282.00 3,991.07 14.6% 239,432.76 278,620.00 39,187.24 333,834.00 94,401.24 72%680000 Leases 39,860.99 41,106.00 1,245.01 3.0% 402,272.30 411,060.00 8,787.70 493,272.00 90,999.70 82%690000 Miscellaneous Other Expense 2,930.16 9,968.00 7,037.84 70.6% 167,920.50 180,569.00 12,648.50 227,140.00 59,219.50 74%Total Expenses282,540.90 306,198.00 23,657.10 7.7% 3,073,314.57 3,292,375.00 219,060.43 3,899,841.00 826,526.43 79%Net Income 151,748.45 185,762.00 (34,013.55) -18.3%(323,605.34) (188,737.00) (134,868.34) (342,450.00) (18,844.66) 94%Rounds of Golf PlayedPaid Rounds Played 5,140 5,400 (260) -4.8% 33,125 34,950 (1,825) 40,580 7,455 82%Ave $ Per Paid Round Green Fee 78.09 84.68 (6.59) -7.8% 76.12 81.08 (4.96) 77.90 1.78 98%Ave $ Per Paid Round Merchandise 6.71 9.00 (2.29) -25.5% 7.55 9.52 (1.97) 8.07 0.52 94%Ave $ Per Paid Miscellaneous 3.10 2.11 0.98 46.6% 3.33 2.95 0.38 2.06 - 0%Month to Date Year to DateApril 2009SilverRock ResortSummary Operating Income Statement1 Income April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 401,364.50 457,245.00 (55,880.50) 2,521,359.27 2,833,603.00 (312,243.73) 3,255,761.00734,401.7377%4010000 Rider Fee 1,175.00 540.00 635.00 6,250.00 5,364.00 886.00 5,984.00-266.00104%4040000 Club Rental 2,190.00 2,970.00 (780.00) 17,020.00 24,173.00 (7,153.00) 27,583.0010,563.0062%4050000 Driving Range 8,870.00 5,400.00 3,470.00 60,208.00 40,450.00 19,758.00 46,650.00-13,558.00129%4060000 Handicap Fees 600.00 - 600.00 7,710.00 8,000.00 (290.00) 8,000.00 290.0096%4080000 GPS Advertising - - - 5,075.00 12,000.00 (6,925.00) 12,000.00 6,925.0042%4090000 Ball Retriever/Subcontract 1,226.00 1,000.00 226.00 2,774.70 4,000.00 (1,225.30) 4,000.00 1,225.3069%4091000 Golf Professional Rental Fee 1,500.00 1,500.00 - 9,500.00 9,000.00 500.00 9,000.00 -500.00 106%4092000 Golf Lessons 356.25 - 356.25 1,616.83 - 1,616.83 - (1,616.83) 0% Total Revenue Fees 417,281.75 468,655.00 (51,373.25) 2,631,513.80 2,936,590.00 (305,076.20) 3,368,978.00 737,464.20 78%Total Income 417,281.75 468,655.00 (51,373.25) 2,631,513.80 2,936,590.00 (305,076.20) 3,368,978.00 737,464.20 78%SilverRock ResortStatement of Fees RevenueApril 2009Month to Date Year to Date Annual Budget2 Income April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 545.86 - 545.86 6,350.70 - 6,350.70 4100110 Sales Hard Goods 17,031.67 17,010.00 21.67 102,450.23 116,393.00 (13,942.77) 131,583.00 29,132.77 78%4100112 Sales-Soft Goods 21,810.56 31,590.00 (9,779.44) 180,786.57 216,158.00 (35,371.43) 244,368.00 63,581.43 74%5100639 GS-Discounts-Mdse (4,923.91) - (4,923.91) (39,644.02) - (39,644.02) - 39,644.02 0% Total Revenue Golf Shop 34,464.18 48,600.00 (14,135.82) 249,943.48 332,551.00 (82,607.52) 375,951.00 132,358.22 65%COS 5100150 COS-GS-Hard Goods 8,685.66 9,356.00 (670.34) 56,254.70 64,018.00 (7,763.30) 72,373.00 16,118.30 78%5100151 COS-GS-Soft Goods 9,203.75 17,375.00 (8,171.25) 83,463.36 118,888.00 (35,424.64) 134,404.00 50,940.64 62%5100152 COS-GS-Purchase Disc - (1,337.00) 1,337.00 (205.57) (9,147.00) 8,941.43 (10,341.00) (10,135.43) -2%5100220 COS-GS-Freight Merch 74.87 401.00 (326.13) 3,306.31 2,744.00 562.31 3,102.00 (204.31) 107%Cost of Sales - Golf Shop 17,964.28 25,795.00 (7,830.72) 142,818.80 176,503.00 (33,684.20) 199,538.00 56,719.20 72%Gross Profit 16,499.90 22,805.00 (6,305.10) 107,124.68 156,048.00 (48,923.32) 176,413.00 75,639.02 57%COS % 52.1% 53.1% 1.0% 57.1% 53.1% -4.1% 53.1% 42.9% 19%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 480.00 480.00 - 4,500.00 4,500.00 - 5,400.00 900.00 83%6101320 Insurance Group 3,051.08 3,150.00 (98.92) 27,440.84 30,150.00 (2,709.16) 36,450.00 9,009.16 75%6101325 Insurance-Workers Comp 239.65 1,376.00 (1,136.35) 4,062.04 12,208.00 (8,145.96) 14,771.00 10,708.96 28%6101720 Salaries 6,045.46 6,082.00 (36.54) 59,940.53 59,295.00 645.53 71,459.00 11,518.47 84%6101800 Taxes-Employer Payroll 1,244.94 2,090.00 (845.06) 11,062.32 18,539.00 (7,476.68) 22,431.00 11,368.68 49%6101880 Wages-Hourly 5,784.80 10,704.00 (4,919.20) 59,205.25 89,616.00 (30,410.75) 108,712.00 49,506.75 54%6101882 Wages-Overtime 151.69 - 151.69 1,816.85 - 1,816.85 - 952.88 0%Total -PS-SALARIES & BENEFITS 16,997.62 23,882.00 (6,884.38) 168,027.83 214,308.00 (46,280.17) 259,223.00 93,964.90 64%61-PS OTHER EXPENSES6103762 Supplies-Office 203.45 200.00 3.45 3,980.04 2,750.00 1,230.04 2,950.00 (1,030.04) 135%6109090 Contract Services 500.00 500.00 - 5,110.00 5,000.00 110.00 6,000.00 890.00 85%6109220 Freight & Delivery 128.20 - 128.20 795.96 75.00 720.96 75.00 (720.96) 1061%6109490 Miscellaneous - 50.00 (50.00) 369.68 350.00 19.68 450.00 80.32 82%6109150 Dues and Subscriptions 1,897.00 - 1,897.00 2,164.23 - 2,164.23 2,000.00 (164.23) 108%6109500 ProShop-Over/Short (7.10) - (7.10) 129.63 - 129.63 (129.63) 0%6109722 Seminars/Training - 35.00 (35.00) 2,390.00 4,205.00 (1,815.00) 5,490.00 3,100.00 44%6109810 Travel - Merchandise - 15.00 (15.00) - 60.00 (60.00) 90.00 90.00 0%6109820 Uniforms 136.77 200.00 (63.23) 1,484.77 2,000.00 (515.23) 2,400.00 915.23 62%6117840 Telephones 51.46 70.00 (18.54) 1,642.22 700.00 942.22 840.00 (802.22) 0%Total PS-OTHER EXPENSES 2,909.78 1,070.00 1,839.78 18,066.53 15,140.00 2,926.53 20,295.00 2,228.47 89%Total Expenses19,907.40 24,952.00 (5,044.60) 186,094.36 229,448.00 (43,353.64) 279,518.00 96,193.37 66%Net Income(3,407.50) (2,147.00) (1,260.50) (78,969.68) (73,400.00) (5,569.68) (103,105.00) (20,554.35) -80%Month to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementApril 20093 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 2,400.00 2,400.00 - 2,880.00 480.00 16.7%6311320 Insurance-Group 11,314.28 12,083.00 (768.72) 110,379.61 120,830.00 (10,450.39) 144,996.00 34,616.39 23.9%6311325 Insurance-Workers Comp 1,176.27 4,842.00 (3,665.73) 19,230.27 49,176.00 (29,945.73) 59,020.00 39,789.73 67.4%6311720 Salaries 12,235.20 12,333.00 (97.80) 114,360.00 123,312.00 (8,952.00) 147,978.00 33,618.00 22.7%6311800 Taxes-Employer Payroll 5,756.03 7,352.00 (1,595.97) 56,019.31 75,243.00 (19,223.69) 90,311.00 34,291.69 38.0%6311880 Wages-Hourly 46,479.23 46,716.00 (236.77) 448,985.40 467,088.00 (18,102.60) 560,520.00 111,534.60 19.9%6311882 Wages-Overtime 118.41 - 118.41 23,243.69 13,966.00 9,277.69 16,894.00 (6,349.69) -37.6%Total-CM-SALARIES & BENEFITS77,319.42 83,566.00 (6,246.58) 774,618.28 852,015.00 (77,396.72) 1,022,599.00 247,980.72 24.3%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 5,544.91 2,000.00 3,544.91 39,468.79 22,300.00 17,168.79 25,200.00 (14,268.79) -56.6%6313744 Fertilizer 3,699.86 5,000.00 (1,300.14) 89,619.76 85,200.00 4,419.76 95,200.00 5,580.24 5.9%6313746 Flowers/Plants - 100.00 (100.00) 1,800.52 3,500.00 (1,699.48) 3,500.00 1,699.48 48.6%6313748 Fuel-Gasoline 3,336.99 4,290.00 (953.01) 36,770.43 39,820.00 (3,049.57) 45,540.00 8,769.57 19.3%6313750 Golf Course Accessories 143.55 100.00 43.55 9,725.15 6,800.00 2,925.15 7,000.00 (2,725.15) -38.9%6313756 POA Control 198.38 - 198.38 7,360.84 6,000.00 1,360.84 6,000.00 (1,360.84) -22.7%6313758 Miscellaneous Supp 728.30 100.00 628.30 5,328.23 1,000.00 4,328.23 - (5,328.23) 0.0%6313762 Supplies-Office 25.01 - 25.01 596.41 - 596.41 1,200.00 603.59 50.3%6313774 Sand - 100.00 (100.00) 6,036.72 6,460.00 (423.28) 6,660.00 623.28 9.4%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 101,110.00 8,709.49 101,810.00 (8,009.49) -7.9%6313778 Small Tools & Non-Capital Equip 538.31 100.00 438.31 5,334.96 6,800.00 (1,465.04) 7,000.00 1,665.04 23.8%6313780 Sod - - - 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 & MATERIALS14,215.31 12,140.00 2,075.31 325,759.80 293,240.00 32,519.80 317,460.00 (8,299.80) -2.6%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,214.62 1,500.00 714.62 16,473.33 13,000.00 3,473.33 16,000.00 (473.33) -3.0%6315685 CM-R&M-Bldngs & Othr Structures - - - 1,338.50 500.00 838.50 500.00 (838.50) -167.7%6315690 CM-R&M-Equipment 3,681.74 2,000.00 1,681.74 44,047.93 42,700.00 1,347.93 46,100.00 2,052.07 4.5%6315692 CM-R&M-Irrigation System 5.76 1,000.00 (994.24) 13,526.38 13,450.00 76.38 15,450.00 1,923.62 12.5%6315696 CM-R&M-Pumps - 1,000.00 (1,000.00) 6,862.44 10,000.00 (3,137.56) 10,500.00 3,637.56 34.6%6315815 CM-R&M-Trees-Pruning Etc 2,800.00 4,000.00 (1,200.00) 6,854.64 9,000.00 (2,145.36) 9,000.00 2,145.36 23.8%Total-CM-REPAIRS & MAINTENANCE 8,702.12 9,500.00 (797.88) 89,103.22 88,650.00 453.22 97,550.00 8,446.78 8.7%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs 5.38 - 5.38 53.80 - 53.80 - (53.80) 0.0%6317836 Utilities-Natural Gas/LPG - 150.00 (150.00) - 1,500.00 (1,500.00) 1,800.00 1,800.00 0.0%6317840 Telephones 936.28 800.00 136.28 8,710.01 8,000.00 710.01 9,600.00 889.99 9.3%Total-CM-UTILITIES 941.66 950.00 (8.34) 8,763.81 9,500.00 (736.19) 11,400.00 2,636.19 23.1%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 5,000.00 5,000.00 - 6,000.00 1,000.00 16.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 487.83 - 487.83 5,045.72 - 5,045.72 - (5,045.72) 0.0%6319150 Dues & Subscriptions - 200.00 (200.00) 455.00 800.00 (345.00) 900.00 445.00 49.4%6319170 Employee Education - 50.00 (50.00) 560.00 500.00 60.00 600.00 40.00 6.7%6319197 Equipment Rental - 200.00 (200.00) 2,946.41 3,900.00 (953.59) 4,200.00 1,253.59 29.8%6319206 Licenses & Permits 1,700.00 150.00 1,550.00 1,760.00 1,600.00 160.00 1,600.00 (160.00) -10.0%6319490 Miscellaneous - 100.00 (100.00) 618.85 1,000.00 (381.15) 1,200.00 581.15 48.4%6319718 Safety Equipment & Training - 100.00 (100.00) 2,350.56 3,200.00 (849.44) 3,400.00 1,049.44 30.9%6319822 Uniforms 769.18 820.00 (50.82) 7,439.35 8,200.00 (760.65) 9,840.00 2,400.65 24.4%Total-CM-OTHER EXPENSES 3,457.01 2,120.00 1,337.01 27,675.89 26,200.00 1,475.89 31,740.00 4,064.11 12.8%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementApril 2009Annual Budget4 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,191.80 1,104.00 87.80 12,310.70 11,040.00 1,270.70 13,248.00 937.30 7.1%6321325 Insurance-Workers Comp 227.68 1,078.00 (850.32) 3,885.62 11,052.00 (7,166.38) 13,257.00 9,371.38 70.7%6321800 Taxes-Employer Payroll 1,269.02 1,636.00 (366.98) 11,808.65 16,983.00 (5,174.35) 20,368.00 8,559.35 42.0%6321880 Wages-Hourly 11,383.84 13,141.00 (1,757.16) 120,895.65 131,410.00 (10,514.35) 157,692.00 36,796.35 23.3%6321882 Wages-Overtime - - - 5,092.68 5,005.00 87.68 5,915.00 822.32 13.9%Total-CM-LM-SALARIES & BENEFITS14,072.34 16,959.00 (2,886.66) 153,993.30 175,490.00 (21,496.70) 210,480.00 56,486.70 26.8%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 367.79 875.00 (507.21) 1,025.00 657.21 64.1%6323788 Uniforms 222.59 290.00 (67.41) 2,870.67 2,900.00 (29.33) 3,480.00 609.33 17.5%Total-CM-LM-SUPPLIES & MATERIALS222.59 365.00 (142.41) 3,238.46 3,775.00 (536.54) 4,505.00 1,266.54 28.1%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 250.00 (250.00) 1,826.70 3,500.00 (1,673.30) 4,250.00 2,423.30 57.0%Total-CM-LM-REPAIRS & MAINTENANCE - 250.00 (250.00) 1,826.70 3,500.00 (1,673.30) 4,250.00 2,423.30 57.0%118,930.45 125,850.00 (6,919.55) 1,384,979.46 1,452,370.00 (67,390.54) 1,699,984.00 315,004.54 18.5% April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 4,057.13 7,000.00 (2,942.87) 43,907.30 70,000.00 (26,092.70) 84,000.00 40,092.70 47.7%6337842 Utilities-Water2,946.94 1,504.00 1,442.94 27,513.86 18,398.00 9,115.86 21,871.00 (5,642.86) -25.8%Total-CM-WATER & ENERGY 7,004.07 8,504.00 (1,499.93) 71,421.16 88,398.00 (16,976.84) 105,871.00 34,449.84 32.5%Month to Date Year to Date Annual BudgetYear to DateSilverrock ResortCourse Maintenance Water & EnergyApril 2009Total -COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementApril 2009Annual BudgetMonth to Date5 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 600.00 600.00 - 5,220.00 5,220.00 - 6,180.00 960.00 15.5%6411320 Insurance-Group 463.25 720.00 (256.75) 1,291.68 7,200.00 (5,908.32) 8,640.00 7,348.32 85.1%6411325 Insurance-Workers Comp 231.45 1,682.00 (1,450.55) 3,078.42 13,697.00 (10,618.58) 16,511.00 13,432.58 81.4%6411800 Taxes-Employer Payroll 1,548.37 1,459.00 89.37 12,118.44 11,880.00 238.44 14,318.00 2,199.56 15.4%6411880 Wages-Hourly 11,572.26 11,715.00 (142.74) 98,336.99 95,400.00 2,936.99 114,990.00 16,653.01 14.5%6411882 Wages-Overtime - - - 852.17 - 852.17 - (852.17) 0.0%Total-CBR-SALARIES & BENEFITS14,415.33 16,176.00 (1,760.67) 120,897.70 133,397.00 (12,499.30) 160,639.00 39,741.30 24.7%641-CBR-SUPPLIES & MATERIALS Supplies-Carts 1,880.90 50.00 1,830.90 3,368.15 2,250.00 1,118.15 2,350.00 (1,018.15) -43.3%6413742 Supplies-Expendable 1,574.99 150.00 1,424.99 6,995.57 4,850.00 2,145.57 5,850.00 (1,145.57) -19.6%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) - 425.00 (425.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - 70.00 (70.00) - 280.00 (280.00) 420.00 420.00 100.0%6413786 Supplies-Towels - 72.00 (72.00) 3,974.08 2,148.00 1,826.08 2,292.00 (1,682.08) -73.4%6413796 Supplies-Bottled Water1,721.57 2,600.00 (878.43) 14,552.19 19,150.00 (4,597.81) 23,950.00 9,397.81 39.2%Total-CBR-SUPPLIES & MATERIALS5,177.46 2,992.00 2,185.46 34,709.99 35,103.00 (393.01) 41,387.00 6,677.01 16.1%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts 720.00 720.00 - 7,275.00 7,200.00 75.00 8,640.00 1,365.00 15.8%6415690 CBR-R&M-Equipment 469.00 125.00 344.00 1,138.67 1,250.00 (111.33) 1,500.00 361.33 24.1%6415695 CBR-R&M-Cart Maintenance & Repair 210.00 250.00 (40.00) 4,677.36 3,500.00 1,177.36 4,000.00 (677.36) -16.9%Total-CBR-REPAIRS & MAINTENANCE 1,399.00 1,095.00 304.00 13,091.03 11,950.00 1,141.03 14,140.00 1,048.97 7.4%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps 605.00 250.00 355.00 6,210.00 4,600.00 1,610.00 5,000.00 (1,210.00) -24.2%6419094 Contract Services-Laundry/Linen 897.41 500.00 397.41 4,732.05 5,000.00 (267.95) 6,000.00 1,267.95 21.1%6419220 Freight/Delivery 40.34 75.00 (34.66) 47.90 750.00 (702.10) 900.00 852.10 94.7%6419490 Miscellaneous - 125.00 (125.00) 506.01 900.00 (393.99) 1,150.00 643.99 56.0%6419820 Uniforms - - - 1,665.22 3,925.00 (2,259.78) 5,625.00 3,959.78 70.4%Total-CBR-OTHER EXPENSES 1,542.75 950.00 592.75 13,161.18 15,175.00 (2,013.82) 18,675.00 5,513.82 29.5%TOTAL-CARTS,BAGROOM & RANGE 22,534.54 21,213.00 1,321.54 181,859.90 195,625.00 (13,765.10) 234,841.00 52,981.10 22.6%643-CS-SALARIES & BENEFITS6431175 Employee Meals 540.00 540.00 - 4,200.00 4,200.00 - 4,860.00 660.00 13.6%6431325 Insurance-Workers Comp 98.48 400.00 (301.52) 1,121.96 2,846.00 (1,724.04) 3,446.00 2,324.04 67.4%6431800 Taxes-Employer Payroll 652.32 608.00 44.32 4,626.71 4,324.00 302.71 5,220.00 593.29 11.4%6431880 Wages-Hourly 4,918.00 4,880.00 38.00 37,316.00 34,720.00 2,596.00 41,920.00 4,604.00 11.0%6431882 Wages-Overtime 6.00 - 6.00 81.00 - 81.00 - (81.00) 0.0%Total-CS-SALARIES & BENEFITS6,214.80 6,428.00 (213.20) 47,345.67 46,090.00 1,255.67 55,446.00 8,100.33 14.6%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) 4,186.80 900.00 3,286.80 1,050.00 (3,136.80) -298.7%6439490 Miscellaneous - - - 290.55 200.00 90.55 200.00 (90.55) -45.3%6439718 Safety Equipment & Training - 50.00 (50.00) 43.10 500.00 (456.90) 600.00 556.90 92.8%6439820 Uniforms - 400.00 (400.00) 2,325.25 1,750.00 575.25 1,900.00 (425.25) -22.4%Total-CS-OTHER EXPENSES - 550.00 (550.00) 6,845.70 3,350.00 3,495.70 3,750.00 (3,095.70) -82.6%Total-COURSE SERVICES 6,214.80 6,978.00 (763.20) 54,191.37 49,440.00 4,751.37 59,196.00 5,004.63 8.5%TOTAL OUTSIDE SERVICES 28,749.34 28,191.00 558.34 236,051.27 245,065.00 (9,013.73) 294,037.00 61,081.43 20.8%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementApril 2009Annual Budget6 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable32.52 400.00 (367.48) 416.16 4,000.00 (3,583.84) 4,800.00 4,383.84 91.3%Total-CH-SUPPLIES & MATERIALS 32.52 400.00 (367.48) 416.16 4,000.00 (3,583.84) 4,800.00 4,383.84 91.3%65-CH-UTILITIES6507836 Utilities-Natural Gas377.53 300.00 77.53 3,867.06 3,000.00 867.06 3,600.00 (267.06) -7.4%6507838 Utilities-Sewer- 200.00 (200.00) 600.00 2,000.00 (1,400.00) 2,400.00 1,800.00 75.0%6507840 Utilities-Telephone1,033.86 1,000.00 33.86 10,619.02 10,000.00 619.02 12,000.00 1,380.98 11.5%6507842 Utilities-Water333.19 200.00 133.19 3,164.57 2,000.00 1,164.57 2,400.00 (764.57) -31.9%6507844 Utilities-Cable529.23 317.00 212.23 3,479.51 3,170.00 309.51 3,804.00 324.49 8.5%Total-CH-UTILITIES 2,273.81 2,017.00 256.81 21,730.16 20,170.00 1,560.16 24,204.00 2,473.84 10.2%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,750.00 1,825.00 (75.00) 18,738.70 18,850.00 (111.30) 22,500.00 3,761.30 16.7%6509099 Contract Services-Security10,853.42 8,200.00 2,653.42 87,529.24 82,000.00 5,529.24 98,400.00 10,870.76 11.0%6509215 Flowers & Decorations- 100.00 (100.00) - 2,400.00 (2,400.00) 2,600.00 2,600.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 193.93 2,000.00 (1,806.07) 2,400.00 2,206.07 91.9%6509718 Safety Equipment & Training- 100.00 (100.00) 108.62 1,000.00 (891.38) 1,200.00 1,091.38 90.9%Total-CH-OTHER EXPENSES 12,894.76 10,425.00 2,469.76 109,958.58 106,250.00 3,708.58 127,100.00 17,141.42 13.5%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures272.00 200.00 72.00 3,622.00 2,000.00 1,622.00 2,400.00 (1,222.00) -50.9%6515686 CH-R&M-Restaurant Repairs463.95 400.00 63.95 2,483.05 4,000.00 (1,516.95) 4,800.00 2,316.95 48.3%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 802.80 4,000.00 (3,197.20) 4,800.00 3,997.20 83.3%Total-CH-REPAIRS & MAINTENANCE 735.95 1,000.00 (264.05) 6,907.85 10,000.00 (3,092.15) 12,000.00 5,092.15 42.4%Total CLUBHOUSE 15,937.04 13,842.00 2,095.04 139,012.75 140,420.00 (1,407.25) 168,104.00 10,184.30 6.1%Month to Date Year to DateSilverRock ResortClubhouse Expense StatementApril 2009Annual Budget7 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 600.00 600.00 - 720.00 120.00 16.7%6601320 Insurance-Group 383.81 450.00 (66.19) 2,699.15 4,500.00 (1,800.85) 5,400.00 2,700.85 50.0%6601325 Insurance-Workers Comp 51.09 205.00 (153.91) 813.87 2,050.00 (1,236.13) 2,460.00 1,646.13 66.9%6601720 Salaries 2,500.00 2,500.00 - 26,250.00 25,000.00 1,250.00 30,000.00 3,750.00 12.5%6601800 Taxes-Employer Payroll 311.00 311.00 - 3,576.50 3,110.00 466.50 3,732.00 155.50 4.2%Total-MKT-SALARIES & BENEFITS 3,305.90 3,526.00 (220.10) 33,939.52 35,260.00 (1,320.48) 42,312.00 8,372.48 19.8%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 100.00 100.00 - 100.00 1,000.00 (900.00) 1,200.00 1,100.00 91.7%6603768 Supplies-Printing & Stationery 2,154.42 125.00 2,029.42 4,910.16 4,175.00 735.16 4,425.00 (485.16) -11.0%2,254.42 225.00 2,029.42 5,010.16 5,175.00 (164.84) 5,625.00 614.84 10.9%66-MKT-UTILITIES6607840 Utilities-Telephone 56.62 100.00 (43.38) 545.92 1,000.00 (454.08) 1,200.00 654.08 54.5%Total-MKT-UTILITIES 56.62 100.00 (43.38) 545.92 1,000.00 (454.08) 1,200.00 654.08 54.5%66-MKT-OTHER EXPENSES6609010 Advertising 19,469.15 21,677.00 (2,207.85) 198,328.38 203,480.00 (5,151.62) 225,134.00 26,805.62 11.9%6609040 Business Meals - 25.00 (25.00) - 250.00 (250.00) 300.00 300.00 100.0%6609080 Collateral Material - 500.00 (500.00) 2,704.05 7,500.00 (4,795.95) 9,000.00 6,295.95 70.0%6609102 Contract Services-Web Page 99.00 175.00 (76.00) 1,386.00 1,750.00 (364.00) 2,100.00 714.00 34.0%6609490 Miscellaneous - 50.00 (50.00) - 300.00 (300.00) 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) 1.59 500.00 (498.41) 600.00 598.41 99.7%6609630 Promotion - - - 2,166.57 6,500.00 (4,333.43) 6,500.00 4,333.43 0.0%6609633 Promotion-Community 370.43 75.00 295.43 567.70 2,775.00 (2,207.30) 2,925.00 2,357.30 80.6%6609634 Promotion-Media/Vendor - 50.00 (50.00) - 600.00 (600.00) 700.00 - 0.0%6609150 Dues and Subscriptions 375.00 - 375.00 1,441.71 735.00 706.71 735.00 (706.71) -96.2%6609820 Uniforms - 50.00 (50.00) 38.41 600.00 (561.59) 600.00 561.59 93.6%Total-MKT-OTHER EXPENSES 20,313.58 22,652.00 (2,338.42) 206,634.41 224,990.00 (18,355.59) 248,944.00 41,609.59 16.7%Total-MARKETING 25,930.52 26,503.00 (572.48) 246,130.01 266,425.00 (20,294.99) 298,081.00 51,250.99 17.2%Month to Date Year to DateSilverRock ResortMarketing Expense StatementApril 2009Annual Budget8 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 1,800.00 1,800.00 - 2,160.00 360.00 16.7%6701320 Insurance-Group2,149.09 2,250.00 (100.91) 14,728.93 22,500.00 (7,771.07) 27,000.00 12,271.07 45.4%6701325 Insurance-Workers Comp337.40 1,406.00 (1,068.60) 5,323.75 14,060.00 (8,736.25) 16,872.00 11,548.25 68.4%6701720 Salaries 14,419.32 14,416.00 3.32 144,881.89 144,160.00 721.89 172,992.00 28,110.11 16.2%6701800 Taxes-Employer Payroll 1,377.34 2,135.00 (757.66) 13,867.94 21,350.00 (7,482.06) 25,620.00 11,752.06 45.9%6701880 Wages-Hourly2,450.43 2,730.00 (279.57) 23,242.55 27,300.00 (4,057.45) 32,760.00 9,517.45 29.1%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 20,913.58 23,117.00 (2,203.42) 203,845.06 231,170.00 (27,324.94) 277,404.00 73,558.94 26.5%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 800.00 (800.00) 2,494.36 9,200.00 (6,705.64) 10,800.00 8,305.64 76.9%6703762 Supplies-Office 169.59 125.00 44.59 2,336.75 1,250.00 1,086.75 1,500.00 (836.75) -55.8%6703768 Supplies-Printing & Stationery- 400.00 (400.00) 994.61 2,400.00 (1,405.39) 3,200.00 2,205.39 68.9%6703778Supplies-Small Tools/Non-Capital - 100.00 (100.00) 5.39 800.00 (794.61) 900.00 894.61 99.4%Total-G&A-SUPPLIES & MATERIALS 169.59 1,425.00 (1,255.41) 5,831.11 13,650.00 (7,818.89) 16,400.00 10,568.89 64.4%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 790.74 1,000.00 (209.26) 1,200.00 409.26 34.1%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 790.74 1,000.00 (209.26) 1,200.00 409.26 34.1%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 4,000.00 4,000.00 - 4,800.00 800.00 16.7%6709150 Dues & Subscriptions- 50.00 (50.00) 384.21 950.00 (565.79) 1,500.00 1,115.79 74.4%6709180 Employee Recruiting/Relocation56.00 - 56.00 781.00 4,600.00 (3,819.00) 4,600.00 3,819.00 83.0%6709197 Equipment Rental396.67 350.00 46.67 4,541.00 3,500.00 1,041.00 4,200.00 (341.00) -8.1%6709202 Fees-Bank46.69 90.00 (43.31) 356.44 900.00 (543.56) 1,080.00 723.56 67.0%6709208 Fees-Payroll Processing683.75 550.00 133.75 7,812.35 5,500.00 2,312.35 6,600.00 (1,212.35) -18.4%6709220 Freight/Delivery- 50.00 (50.00) 46.65 500.00 (453.35) 600.00 553.35 92.2%6709490 Miscellaneous 39.50 100.00 (60.50) 581.91 1,000.00 (418.09) 1,200.00 618.09 51.5%6709491 Loss/Damage- - - 204.96 - 204.96 - 0.0%6709620 Postage/Mail Services 110.15 75.00 35.15 1,259.43 750.00 509.43 900.00 (359.43) -39.9%6709625 Professional Fees475.00 400.00 75.00 4,015.16 4,000.00 15.16 4,800.00 784.84 16.4%6709636 Promotion/Entertainment- 100.00 (100.00) 2,793.74 3,800.00 (1,006.26) 4,000.00 1,206.26 30.2%6709722 Seminars & Training- 200.00 (200.00) 1,374.45 2,000.00 (625.55) 2,400.00 1,025.55 42.7%6709810 Travel - 200.00 (200.00) 240.40 400.00 (159.60) 1,100.00 859.60 78.1%6709820 Uniforms - 75.00 (75.00) 574.15 900.00 (325.85) 1,050.00 475.85 45.3%Total-G&A-OTHER EXPENSES 2,207.76 2,640.00 (432.24) 28,965.85 32,800.00 (3,834.15) 38,830.00 10,069.11 25.9%Total-GENERAL & ADMINISTRATIVE23,290.93 27,282.00 (3,991.07) 239,432.76 278,620.00 (39,187.24) 333,834.00 94,606.20 28.3%Month to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementApril 2009Annual Budget9 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,581.04 11,581.00 0.04 112,266.31 115,810.00 (3,543.69) 138,972.00 26,705.69 19.2%6800193 Equipment Leases-Course Maint 16,244.12 20,000.00 (3,755.88) 163,035.49 200,000.00 (36,964.51) 240,000.00 76,964.51 32.1%6800194 Equipment Leases-Trailer 540.00 600.00 (60.00) 5,898.94 6,000.00 (101.06) 7,200.00 1,301.06 18.1%6800195 Equipment Leases-Software 1,791.93 1,525.00 266.93 17,919.30 15,250.00 2,669.30 18,300.00 380.70 2.1%6800196 Equipment Leases-GPS 6,840.14 7,400.00 (559.86) 68,401.40 74,000.00 (5,598.60) 88,800.00 20,398.60 23.0%6800197 Equipment Leases-Others 2,863.76 - 2,863.76 34,750.86 - 34,750.86 - - 0.0%Total-LEASES 39,860.99 41,106.00 (1,245.01) 402,272.30 411,060.00 (8,787.70) 493,272.00 125,750.56 25.5%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee (8,536.03) (3,887.00) (4,649.03) 68,880.15 59,965.00 8,915.15 90,000.00 21,119.85 23.5%6900210 FF&E Reserve 8,345.64 10,355.00 (2,009.36) 53,485.16 65,604.00 (12,118.84) 75,140.00 21,654.84 28.8%6900800 Personal Property Taxes - - - 20,812.13 20,000.00 812.13 20,000.00 (812.13) -4.1%6900323 Insurance-Commercial 3,120.55 3,500.00 (379.45) 24,743.06 35,000.00 (10,256.94) 42,000.00 17,256.94 41.1%Total-MISC OTHER EXPENSES2,930.16 9,968.00 (7,037.84) 167,920.50 180,569.00 (12,648.50) 227,140.00 59,219.50 26.1% Operating Leases & Miscellaneous Other Expense StatementApril 2009Annual BudgetMonth to Date Year to Date10 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 CategoryJanuaryFebruaryMarchAprilMayJuneMedia 813Sales11Promotion84Golf Industry953439VIPCelebrity2PGA Comp48 633491Charity/Gift Certificate7153437Rain/Wind Checks10 31414Club Staff53 70103121LQ HS Golf68 52127 175 301 367 0 011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2008-2009April 2009 Date Time Description CategoryPlayers4/1/2009 10:45 Michael Dante Media 24/2/2009 8:15 Kris Lond - CBS2 Media 24/3/2009 12:07 Gino Lamont - KMIR Media 24/6/2009 10:30 Michael Dante Media 14/17/2009 11:30 Gino Lamont - KMIR Media 24/18/2009 10:30 Michael Dante Media 24/23/2009 11:00 Gino Lamont - KMIR Media 212