Loading...
09 March 2007 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2006 – March 2007 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 Account Description MarchFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 587,533.25 471,983.00 115,550.25 24.5% 2,288,825.43 2,142,013.00 146,812.43 2,985,870.00 697,044.57 77%401000 Miscellaneous Golf Revenue 17,733.00 6,198.00 11,535.00 186.1% 80,640.87 49,026.00 31,614.87 62,181.00 (18,459.87) 130%410000 Revenue-Golf Shop 51,983.03 42,075.00 9,908.03 23.5% 219,607.46 231,999.00 (12,391.54) 311,248.00 91,640.54 71%420000 Revenue-F&B Concession 1,500.00 1,500.00 - 0.0% 10,500.00 10,500.00 - 12,000.00 1,500.00 88%890000 Interest Income 27.22 - 27.22 0.0% 201.76 - 201.76 - (201.76) Total Income 658,776.50 521,756.00 137,020.50 26.3% 2,599,775.52 2,433,538.00 166,237.52 3,371,299.00 771,523.48 77%Cost of Goods Sold510000 COS-Golf Shop 27,166.79 24,403.50 2,763.29 -11.3% 110,334.63 134,559.42 24,224.79 180,513.00 70,178.37 61%Total COS 27,166.79 24,403.50 2,763.29 -11.3% 110,334.63 134,559.42 24,224.79 180,513.00 70,178.37 61%Gross Profit 631,609.71 497,352.50 134,257.21 27.0% 2,489,440.89 2,298,978.58 190,462.31 3,190,786.00 701,345.11 78%610000 Golf Pro Shop 19,552.38 19,264.00 (288.38) -1.5% 154,246.90 154,013.00 (233.90) 211,697.00 57,450.10 73%630000 Course Maintenance 130,739.42 118,939.00 (11,800.42) -9.9% 1,345,055.54 1,336,766.00 (8,289.54) 1,739,809.00 394,753.46 77%640000 Outside Services 30,725.56 28,555.00 (2,170.56) -7.6% 184,417.97 214,926.00 30,508.03 291,576.00 107,158.03 63%650000 Clubhouse 14,331.01 16,815.00 2,483.99 14.8% 135,829.91 146,395.00 10,565.09 197,095.00 61,265.09 69%660000 Marketing 33,373.81 33,756.00 382.19 1.1% 256,010.69 258,010.00 1,999.31 248,481.00 (7,529.69) 103%670000 General & Administrative 23,786.75 25,702.00 1,915.25 7.5% 215,317.57 232,818.00 17,500.43 311,576.00 96,258.43 69%680000 Leases 39,504.60 39,325.00 (179.60) -0.5% 348,825.69 353,925.00 5,099.31 471,900.00 123,074.31 74%690000 Miscellaneous Other Expense 4,409.26 14,504.00 10,094.74 69.6% 154,366.28 199,672.00 45,305.72 263,021.00 108,654.72 59%Total Expenses 296,422.79 296,860.00 437.21 0.1% 2,794,070.55 2,896,525.00 102,454.45 3,735,155.00 941,084.45 75%Net Income335,186.92 200,492.50 134,694.42 67.2%(304,629.66) (597,546.42) 292,916.76 (544,369.00) (239,739.34) 56%Rounds of Golf PlayedPaid Rounds Played 5,816 4,651 1,165 25.0% 29,304 28,595 709 39,220 9,916 75%Ave $ Per Paid Round Green Fee 101.02 101.48 (0.46) -0.5% 78.11 74.91 3.20 76.13 (1.98) 103%Ave $ Per Paid Round Merchandise 8.94 9.05 (0.11) -1.2% 7.49 8.11 (0.62) 7.94 0.45 94%Ave $ Per Paid Miscellaneous 3.05 1.33 1.72 128.8% 2.75 1.71 1.04 1.59 - 0%March 2007SilverRock ResortSummary Operating Income Statement1 Income MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 587,533.25 471,983.00 115,550.25 2,288,825.43 2,142,013.00 146,812.43 2,985,870.00697,044.5777%4010000 Rider Fee 525.00 - 525.00 4,668.92 - 4,668.92 0.000.000%4040000 Club Rental 4,975.00 1,485.00 3,490.00 15,445.00 8,579.00 6,866.00 11,766.00-3,679.00131%4050000 Driving Range 7,783.00 3,713.00 4,070.00 35,145.00 21,447.00 13,698.00 29,415.00-5,730.00119%4060000 Handicap Fees 200.00 500.00 (300.00) 5,030.00 8,000.00 (2,970.00) 8,000.00 2,970.0063%4080000 GPS Advertising 1,250.00 500.00 750.00 13,400.00 8,000.00 5,400.00 9,000.00 -4,400.00149%4090000 Ball Retriever/Subcontract - - - 1,301.95 3,000.00 (1,698.05) 4,000.00 4,000.00 0%4091000 Golf Professional Rental Fee 3,000.00 - 3,000.00 5,650.00 - 5,650.00 - - 0% Total Revenue Fees 605,266.25 478,181.00 127,085.25 2,369,466.30 2,191,039.00 178,427.30 3,048,051.00 690,205.57 77%Total Income605,266.25 478,181.00 127,085.25 2,369,466.30 2,191,039.00 178,427.30 3,048,051.00 690,205.57 77%SilverRock ResortStatement of Fees RevenueMarch 2007Month to Date Year to Date Annual Budget2 Income MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 3,616.56 - 3,616.56 14,303.73 - 14,303.73 4100110 Sales Hard Goods 15,170.84 14,726.00 444.84 69,453.41 81,200.00 (11,746.59) 108,937.00 39,483.59 64%4100112 Sales-Soft Goods 36,236.64 27,349.00 8,887.64 151,413.85 150,799.00 614.85 202,311.00 50,897.15 75%5100639 GS-Discounts-Mdse (3,041.01) - (3,041.01) (15,563.53) - (15,563.53) (9,353.00) 6,210.53 -166% Total Revenue Golf Shop 51,983.03 42,075.00 9,908.03 219,607.46 231,999.00 (12,391.54) 301,895.00 96,591.27 68%COS 5100150 COS-GS-Hard Goods 9,265.80 8,541.08 724.72 40,876.98 47,096.00 (6,219.02) 63,183.46 22,306.48 65%5100151 COS-GS-Soft Goods 17,900.99 15,862.42 2,038.57 69,457.65 87,463.42 (18,005.77) 107,977.38 38,519.73 64%Cost of Sales - Golf Shop 27,166.79 24,403.50 2,763.29 110,334.63 134,559.42 (24,224.79) 171,160.84 60,826.21 64%Gross Profit 24,816.24 17,671.50 7,144.74 109,272.83 97,439.58 11,833.25 130,734.16 35,765.06 73%COS % 52.3% 58.0% 5.7% 50.2% 58.0% 7.8% 61.0% 63.0% -3%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 359.57 360.00 (0.43) 2,911.44 2,940.00 (28.56) 3,960.00 1,048.56 74%6101320 Insurance Group 3,843.75 3,000.00 843.75 24,014.16 22,320.00 1,694.16 31,320.00 7,305.84 77%6101325 Insurance-Workers Comp 1,028.63 1,230.00 (201.37) 5,792.90 9,742.00 (3,949.10) 13,313.00 7,520.10 44%6101720 Salaries 2,586.00 3,333.00 (747.00) 35,381.88 29,997.00 5,384.88 39,992.00 4,610.12 88%6101800 Taxes-Employer Payroll 1,884.15 1,531.00 353.15 10,486.02 12,128.00 (1,641.98) 16,575.00 6,088.98 63%6101880 Wages-Hourly 7,421.10 8,965.00 (1,543.90) 57,413.94 67,421.00 (10,007.06) 93,138.00 35,724.06 62%6101882 Wages-Overtime 279.20 - 279.20 1,252.26 - 1,252.26 - 952.88 0%Total -PS-SALARIES & BENEFITS 17,402.40 18,419.00 (1,016.60) 137,252.60 144,548.00 (7,295.40) 198,298.00 63,250.54 68%61-PS-SUPPLIES & MATERIALS6103742 Supplies-Expendable 267.11 - 267.11 1,029.90 - 1,029.90 - (1,029.90) 0%Total PS-SUPPLIES & MATERIALS 267.11 - 267.11 1,029.90 - 1,029.90 - (1,029.90) 0%61-PS OTHER EXPENSES6103762 Supplies-Office 1,151.30 45.00 1,106.30 2,018.28 1,390.00 628.28 1,525.00 (493.28) 132%6109090 Contract Services 500.00 500.00 - 3,500.00 4,500.00 (1,000.00) 6,000.00 2,500.00 58%6109197 Equipment Rental - - - 1,593.00 - 1,593.00 - (1,593.00) 0%6109220 Freight & Delivery 53.29 - 53.29 1,076.50 75.00 1,001.50 75.00 (1,001.50) 1435%6109490 Miscellaneous - 50.00 (50.00) 1,171.59 300.00 871.59 450.00 (721.59) 260%6109150 Dues and Subscriptions - - - 156.93 - 156.93 1,500.00 1,343.07 10%6109500 ProShop-Over/Short 2.42 - 2.42 89.65 - 89.65 - (89.65) 0%6109722 Seminars/Training - 35.00 (35.00) 3,510.00 1,855.00 1,655.00 1,960.00 (1,550.00) 179%6109810 Travel - Merchandise - 15.00 (15.00) 44.62 45.00 (0.38) 90.00 45.38 50%6109820 Uniforms 78.42 200.00 (121.58) 1,968.71 1,300.00 668.71 1,800.00 (168.71) 109%6117840 Telephones 97.44 - 97.44 835.12 - 835.12 - (835.12) 0%6119206 License and Permits - - - - - - - - 0%Total PS-OTHER EXPENSES 1,882.87 845.00 1,037.87 15,964.40 9,465.00 6,499.40 13,400.00 (2,564.40) 119%Total Expenses 19,552.38 19,264.00 288.38 154,246.90 154,013.00 233.90 211,698.00 60,686.14 71%Net Income5,263.86 (1,592.50) 6,856.36 (44,974.07) (56,573.42) 11,599.35 (80,963.84) (24,921.08) -69%Month to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementMarch 20073 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 2,160.00 2,160.00 - 2,880.00 720.00 25.0%6311320 Insurance-Group 13,473.45 5,880.00 7,593.45 101,879.59 52,920.00 48,959.59 70,560.00 (31,319.59) -44.4%6311325 Insurance-Workers Comp 4,816.13 5,691.00 (874.87) 39,371.41 53,415.00 (14,043.59) 70,971.00 31,599.59 44.5%6311720 Salaries 9,958.07 11,750.00 (1,791.93) 101,577.04 105,734.00 (4,156.96) 141,000.00 39,422.96 28.0%6311800 Taxes-Employer Payroll 6,292.07 7,085.00 (792.93) 52,159.74 67,036.00 (14,876.26) 89,006.00 36,846.26 41.4%6311880 Wages-Hourly 37,507.86 45,156.00 (7,648.14) 421,981.83 419,820.00 2,161.83 558,230.00 136,248.17 24.4%6311882 Wages-Overtime 695.37 - 695.37 28,972.61 12,859.00 16,113.61 15,679.00 (13,293.61) -84.8%Total-CM-SALARIES & BENEFITS72,982.95 75,802.00 (2,819.05) 748,102.22 713,944.00 34,158.22 948,326.00 200,223.78 21.1%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 3,193.24 - 3,193.24 21,066.54 - 21,066.54 (21,066.54) 0.0%6313744 Fertilizer 7,603.78 3,850.00 3,753.78 69,382.95 42,100.00 27,282.95 54,650.00 (14,732.95) -27.0%6313746 Flowers/Plants - 100.00 (100.00) - 3,400.00 (3,400.00) 3,500.00 3,500.00 100.0%6313748 Fuel-Gasoline 5,321.80 3,000.00 2,321.80 32,907.78 32,100.00 807.78 40,900.00 7,992.22 19.5%6313750 Golf Course Accessories 905.59 100.00 805.59 9,065.49 3,900.00 5,165.49 4,200.00 (4,865.49) -115.8%6313756 POA Control 182.00 - 182.00 1,093.36 6,000.00 (4,906.64) 6,000.00 4,906.64 81.8%6313758 Miscellaneous Supp - 100.00 (100.00) 1,858.74 900.00 958.74 1,200.00 (658.74) -54.9%6313766 Pesticides 16.00 200.00 (184.00) 12,961.87 13,400.00 (438.13) 14,900.00 1,938.13 13.0%6313762 Supplies-Office 623.70 - 623.70 1,434.48 - 1,434.48 - (1,434.48) 0.0%6313774 Sand 1,134.65 100.00 1,034.65 4,594.83 6,360.00 (1,765.17) 16,660.00 12,065.17 72.4%6313775 Sand-Bunkers - - - 3,552.24 10,000.00 (6,447.76) 10,000.00 6,447.76 64.5%6313776 Seed 789.25 350.00 439.25 104,076.29 83,700.00 20,376.29 84,750.00 (19,326.29) -22.8%6313778 Small Tools & Non-Capital Equip 826.44 100.00 726.44 2,904.51 6,200.00 (3,295.49) 6,500.00 3,595.49 55.3%6313780 Sod - - - 3,874.82 4,250.00 (375.18) 5,750.00 1,875.18 32.6%6313782 Topdressing - - - 2,776.92 1,300.00 1,476.92 3,900.00 1,123.08 28.8%Total-CM-SUPPLIES & MATERIALS20,596.45 7,900.00 12,696.45 271,550.82 213,610.00 57,940.82 252,910.00 (18,640.82) -7.4%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 529.75 1,500.00 (970.25) 6,806.22 9,500.00 (2,693.78) 14,000.00 7,193.78 51.4%6315685 CM-R&M-Bldngs & Othr Structures 138.87 - 138.87 997.93 500.00 497.93 500.00 (497.93) -99.6%6315686 CM-R&M- Drainage - - - 5,083.39 - 5,083.39 - (5,083.39) 0.0%6315690 CM-R&M-Equipment 4,928.65 700.00 4,228.65 34,059.73 12,300.00 21,759.73 14,400.00 (19,659.73) -136.5%6315692 CM-R&M-Irrigation System 2,505.56 550.00 1,955.56 13,647.76 6,800.00 6,847.76 8,450.00 (5,197.76) -61.5%6315696 CM-R&M-Pumps - - - 5,004.99 4,000.00 1,004.99 5,000.00 (4.99) -0.1%6315815 CM-R&M-Trees-Pruning Etc 330.80 - 330.80 3,826.20 4,000.00 (173.80) 4,000.00 173.80 4.3%Total-CM-REPAIRS & MAINTENANCE 8,433.63 2,750.00 5,683.63 69,426.22 37,100.00 32,326.22 46,350.00 (23,076.22) -49.8%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs - 1,021.00 (1,021.00) 17,885.16 16,019.00 1,866.16 22,080.00 4,194.84 19.0%6317836 Utilities-Natural Gas/LPG 84.80 - 84.80 257.02 - 257.02 - (257.02) 0.0%6317840 Telephones 820.63 350.00 470.63 7,409.53 3,150.00 4,259.53 4,200.00 (3,209.53) -76.4%Total-CM-UTILITIES 905.43 1,371.00 (465.57) 25,551.71 19,169.00 6,382.71 26,280.00 728.29 2.8%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 4,500.00 4,500.00 - 6,000.00 1,500.00 25.0%6319099 Contract Svcs-Security 210.00 - 210.00 280.00 - 280.00 - (280.00) 0.0%6319100 Contract Svcs-Soil/Tissue Test - - - 38.76 2,000.00 (1,961.24) 4,000.00 3,961.24 99.0%6319101 Contract Svcs-Trash Removal 3,884.20 400.00 3,484.20 12,321.64 3,600.00 8,721.64 18,800.00 6,478.36 34.5%6319102 Greens-Waste Removal - 300.00 (300.00) 10,358.82 13,100.00 (2,741.18) 14,000.00 3,641.18 26.0%6319150 Dues & Subscriptions - - - - 600.00 (600.00) 900.00 900.00 100.0%6319170 Employee Education 250.00 50.00 200.00 250.00 450.00 (200.00) 600.00 350.00 58.3%6319197 Equipment Rental - 200.00 (200.00) 1,364.15 3,700.00 (2,335.85) 4,200.00 2,835.85 67.5%6319206 Licenses & Permits - 250.00 (250.00) 966.01 1,650.00 (683.99) 1,800.00 833.99 46.3%6319490 Miscellaneous 171.56 100.00 71.56 1,755.11 900.00 855.11 1,200.00 (555.11) -46.3%6319500 Propane/Natural Gas - 150.00 (150.00) - 1,350.00 (1,350.00) 1,800.00 1,800.00 100.0%6319718 Safety Equipment & Training 608.85 200.00 408.85 2,625.42 3,100.00 (474.58) 3,400.00 774.58 22.8%6319822 Uniforms 745.74 720.00 25.74 6,087.53 7,230.00 (1,142.47) 9,390.00 3,302.47 35.2%Total-CM-OTHER EXPENSES 6,370.35 2,870.00 3,500.35 40,547.44 42,180.00 (1,632.56) 66,090.00 25,542.56 38.6%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementMarch 2007Annual Budget4 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,104.00 1,104.00 - 10,888.63 9,936.00 952.63 13,248.00 2,359.37 0.0%6321325 Insurance-Workers Comp 942.96 1,314.00 (371.04) 6,028.94 12,191.00 (6,162.06) 16,194.00 10,165.06 62.8%6321800 Taxes-Employer Payroll 1,188.56 1,636.00 (447.44) 8,609.09 15,403.00 (6,793.91) 20,426.00 11,816.91 57.9%6321880 Wages-Hourly 9,430.00 13,141.00 (3,711.00) 85,430.84 118,269.00 (32,838.16) 157,692.00 72,261.16 45.8%6321882 Wages-Overtime 132.12 - 132.12 5,033.13 5,460.00 (426.87) 6,370.00 1,336.87 21.0%Total-CM-LM-SALARIES & BENEFITS12,797.64 17,195.00 (4,397.36) 115,990.63 161,259.00 (45,268.37) 213,930.00 95,580.00 44.7%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools 94.60 75.00 19.60 5,258.12 800.00 4,458.12 1,025.00 (4,233.12) -413.0%6323788 Uniforms 249.11 240.00 9.11 2,497.43 2,160.00 337.43 2,880.00 382.57 13.3%Total-CM-LM-SUPPLIES & MATERIALS343.71 315.00 28.71 7,755.55 2,960.00 4,795.55 3,905.00 (3,850.55) -98.6%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation 255.48 250.00 5.48 3,646.62 3,250.00 396.62 4,250.00 603.38 14.2%Total-CM-LM-REPAIRS & MAINTENANCE 255.48 250.00 5.48 3,646.62 3,250.00 396.62 4,250.00 603.38 14.2%632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 7,520.47 8,982.00 (1,461.53) 51,707.73 130,145.00 (78,437.27) 183,642.00 131,934.27 71.8%6337842 Utilities-Water533.31 1,504.00 (970.69) 10,776.60 13,149.00 (2,372.40) 18,126.00 7,349.40 40.5%Total-CM-WATER & ENERGY8,053.78 10,486.00 (2,432.22) 62,484.33 143,294.00 (80,809.67) 201,768.00 139,283.67 69.0%130,739.42 118,939.00 11,800.42 1,345,055.54 1,336,766.00 8,289.54 1,763,809.00 416,394.09 23.6%Total -COURSE MAINTENANCEMonth to Date Year to DateSilverrock ResortCourse Maintenance Expense StatementMarch 2007Annual Budget5 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 600.00 600.00 - 4,500.00 4,620.00 (120.00) 6,240.00 1,740.00 27.9%6411320 Insurance-Group 35.25 720.00 (684.75) 5,172.80 6,480.00 (1,307.20) 8,640.00 3,467.20 40.1%6411325 Insurance-Workers Comp 988.54 1,741.00 (752.46) 4,637.91 12,165.00 (7,527.09) 16,944.00 12,306.09 72.6%6411800 Taxes-Employer Payroll 1,458.98 1,510.00 (51.02) 8,697.88 10,549.00 (1,851.12) 14,690.00 5,992.12 40.8%6411880 Wages-Hourly 9,812.13 12,127.00 (2,314.87) 71,082.56 84,731.00 (13,648.44) 117,992.00 46,909.44 39.8%6411882 Wages-Overtime 73.19 - 73.19 1,295.32 - 1,295.32 - (1,295.32) 0.0%Total-CBR-SALARIES & BENEFITS12,968.09 16,698.00 (3,729.91) 95,386.47 118,545.00 (23,158.53) 164,506.00 69,119.53 42.0%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 222.36 50.00 172.36 1,051.31 2,200.00 (1,148.69) 2,350.00 1,298.69 55.3%6413742 Supplies-Expendable 2,712.09 150.00 2,562.09 5,075.67 6,400.00 (1,324.33) 7,550.00 2,474.33 32.8%6413752 Supplies-Range Balls - - - 5,250.00 6,000.00 (750.00) 6,000.00 750.00 12.5%6413762 Supplies-Office 590.74 50.00 540.74 1,017.37 375.00 642.37 525.00 (492.37) -93.8%6413768 Supplies-Printing and Stationary - 70.00 (70.00) 95.60 210.00 (114.40) 420.00 324.40 77.2%6413786 Supplies-Towels 1,399.02 72.00 1,327.02 5,815.46 2,076.00 3,739.46 2,292.00 (3,523.46) -153.7%6413796 Supplies-Bottled Water4,054.19 2,684.00 1,370.19 17,938.33 15,584.00 2,354.33 22,631.00 4,692.67 20.7%Total-CBR-SUPPLIES & MATERIALS8,978.40 3,076.00 5,902.40 36,243.74 32,845.00 3,398.74 41,768.00 5,524.26 13.2%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts 720.00 720.00 - 5,760.00 6,480.00 (720.00) 8,640.00 2,880.00 33.3%6415690 CBR-R&M-Equipment 475.78 125.00 350.78 5,348.45 1,125.00 4,223.45 1,500.00 (3,848.45) -256.6%6415695 CBR-R&M-Cart Maintenance & Repair 1,105.57 250.00 855.57 2,845.82 2,250.00 595.82 3,000.00 154.18 5.1%Total-CBR-REPAIRS & MAINTENANCE 2,301.35 1,095.00 1,206.35 13,954.27 9,855.00 4,099.27 13,140.00 (814.27) -6.2%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps 83.00 500.00 (417.00) 2,523.00 4,350.00 (1,827.00) 5,000.00 2,477.00 49.5%6419094 Contract Services-Laundry/Linen - 150.00 (150.00) 166.75 1,390.00 (1,223.25) 1,690.00 1,523.25 90.1%6419220 Freight/Delivery - 75.00 (75.00) 122.17 675.00 (552.83) 900.00 777.83 86.4%6419490 Miscellaneous - 125.00 (125.00) - 775.00 (775.00) 1,150.00 1,150.00 100.0%6419820 Uniforms 140.24 925.00 (784.76) 2,876.36 3,425.00 (548.64) 4,625.00 1,748.64 37.8%Total-CBR-OTHER EXPENSES 223.24 1,775.00 (1,551.76) 5,688.28 10,615.00 (4,926.72) 13,365.00 7,676.72 57.4%TOTAL-CARTS,BAGROOM & RANGE 24,471.08 22,644.00 1,827.08 151,272.76 171,860.00 (20,587.24) 232,779.00 81,506.24 35.0%643-CS-SALARIES & BENEFITS6431175 Employee Meals 300.00 300.00 - 2,280.00 2,340.00 (60.00) 3,120.00 840.00 26.9%6431320 Insurance-Group - - - - - - - - 0.0%6431325 Insurance-Workers Comp 433.31 440.00 (6.69) 1,970.45 3,119.00 (1,148.55) 4,261.00 2,290.55 53.8%6431800 Taxes-Employer Payroll 587.57 548.00 39.57 2,710.46 3,883.00 (1,172.54) 5,305.00 2,594.54 48.9%6431880 Wages-Hourly 4,296.41 4,398.00 (101.59) 22,198.03 31,174.00 (8,975.97) 42,611.00 20,412.97 47.9%6431882 Wages-Overtime 36.60 - 36.60 243.76 - 243.76 - (243.76) 0.0%Total-CS-SALARIES & BENEFITS5,653.89 5,686.00 (32.11) 29,402.70 40,516.00 (11,113.30) 55,297.00 25,894.30 46.8%643-CS-OTHER EXPENSES6433742 Supplies Expendable 496.91 100.00 396.91 2,399.29 800.00 1,599.29 1,050.00 (1,349.29) -128.5%6439490 Miscellaneous - - - - 200.00 (200.00) 200.00 200.00 100.0%6439718 Safety Equipment & Training - 50.00 (50.00) - 450.00 (450.00) 600.00 600.00 100.0%6439820 Uniforms 103.68 75.00 28.68 1,343.22 1,100.00 243.22 1,650.00 306.78 18.6%Total-CS-OTHER EXPENSES 600.59 225.00 375.59 3,742.51 2,550.00 1,192.51 3,500.00 (242.51) -6.9%Total-COURSE SERVICES 6,254.48 5,911.00 343.48 33,145.21 43,066.00 (9,920.79) 58,797.00 25,651.79 43.6%TOTAL OUTSIDE SERVICES30,725.56 28,555.00 2,170.56 184,417.97 214,926.00 (30,508.03) 291,576.00 107,400.54 36.8%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementMarch 2007Annual Budget6 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable507.64 400.00 107.64 4,467.94 3,600.00 867.94 4,800.00 332.06 6.9%Total-CH-SUPPLIES & MATERIALS 507.64 400.00 107.64 4,467.94 3,600.00 867.94 4,800.00 332.06 6.9%65-CH-UTILITIES6507830 Utilities-Electric-Bldgs- 4,073.00 (4,073.00) 7,375.00 30,317.00 (22,942.00) 42,795.00 35,420.00 82.8%6507836 Utilities-Natural Gas423.39 200.00 223.39 3,296.40 1,800.00 1,496.40 2,400.00 (896.40) -37.4%6507838 Utilities-Sewer- 200.00 (200.00) - 1,800.00 (1,800.00) 2,400.00 2,400.00 100.0%6507840 Utilities-Telephone1,692.96 675.00 1,017.96 10,556.92 6,075.00 4,481.92 8,100.00 (2,456.92) -30.3%6507842 Utilities-Water106.02 200.00 (93.98) 1,365.86 1,800.00 (434.14) 2,400.00 1,034.14 43.1%6507844 Utilities-Cable545.86 317.00 228.86 2,796.94 2,853.00 (56.06) 3,800.00 1,003.06 0.0%Total-CH-UTILITIES 2,768.23 5,665.00 (2,896.77) 25,391.12 44,645.00 (19,253.88) 61,895.00 36,503.88 59.0%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning2,467.50 1,750.00 717.50 17,067.50 15,750.00 1,317.50 21,000.00 3,932.50 18.7%6509098 Contract Services-Refuse Dispose301.40 400.00 (98.60) 4,707.47 3,600.00 1,107.47 4,800.00 92.53 1.9%6509099 Contract Services-Security8,190.08 7,800.00 390.08 74,749.88 70,200.00 4,549.88 93,600.00 18,850.12 20.1%6509215 Flowers & Decorations- 100.00 (100.00) 516.87 2,300.00 (1,783.13) 2,600.00 2,083.13 80.1%6509490 Miscellaneous- - - 538.67 - 538.67 - (538.67) 0.0%6509718 Safety Equipment & Training- 100.00 (100.00) - 900.00 (900.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES 10,958.98 10,150.00 808.98 97,580.39 92,750.00 4,830.39 123,200.00 25,619.61 20.8%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures96.16 200.00 (103.84) 2,845.00 1,800.00 1,045.00 2,400.00 (445.00) -18.5%6515686 CH-R&M-Restaurant Repairs- 200.00 (200.00) 280.18 1,800.00 (1,519.82) 2,400.00 2,119.82 88.3%6515690 CH-R&M-Equipment Repair- 200.00 (200.00) 5,265.28 1,800.00 3,465.28 2,400.00 (2,865.28) -119.4%Total-CH-REPAIRS & MAINTENANCE 96.16 600.00 (503.84) 8,390.46 5,400.00 2,990.46 7,200.00 (1,190.46) -16.5%Total CLUBHOUSE14,331.01 16,815.00 (2,483.99) 135,829.91 146,395.00 (10,565.09) 197,095.00 (2,380.92) -1.2%Month to Date Year to DateSilverRock ResortClubhouse Expense StatementMarch 2007Annual Budget7 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals - 60.00 (60.00) 240.00 540.00 (300.00) 720.00 480.00 66.7%6601320 Insurance-Group - 150.00 (150.00) 306.21 1,350.00 (1,043.79) 1,800.00 1,493.79 83.0%6601325 Insurance-Workers Comp 216.17 317.00 (100.83) 1,534.20 2,853.00 (1,318.80) 3,800.00 2,265.80 59.6%6601720 Salaries 2,161.64 3,167.00 (1,005.36) 18,955.81 28,503.00 (9,547.19) 38,004.00 19,048.19 50.1%6601800 Taxes-Employer Payroll - 394.00 (394.00) 1,471.97 3,546.00 (2,074.03) 4,731.00 3,259.03 68.9%Total-MKT-SALARIES & BENEFITS 2,377.81 4,088.00 (1,710.19) 22,508.19 36,792.00 (14,283.81) 49,055.00 26,546.81 54.1%66-MKT-SUPPLIES & MATERIALS6603080 Collateral Material - 500.00 (500.00) 3,496.15 7,000.00 (3,503.85) - (3,496.15) 0.0%6603762 Supplies-Office 96.51 100.00 (3.49) 477.95 900.00 (422.05) 1,200.00 722.05 60.2%6603768 Supplies-Printing & Stationery - 125.00 (125.00) 264.49 4,050.00 (3,785.51) 4,425.00 4,160.51 94.0%96.51 725.00 (628.49) 4,238.59 11,950.00 (7,711.41) 5,625.00 1,386.41 24.6%66-MKT-UTILITIES6607840 Utilities-Telephone 65.43 100.00 (34.57) 738.98 900.00 (161.02) 1,200.00 461.02 38.4%Total-MKT-UTILITIES 65.43 100.00 (34.57) 738.98 900.00 (161.02) 1,200.00 461.02 38.4%66-MKT-OTHER EXPENSES6609010 Advertising 29,434.16 28,068.00 1,366.16 222,314.28 201,333.00 20,981.28 175,290.00 (47,024.28) -26.8%6609040 Business Meals 83.28 25.00 58.28 174.25 225.00 (50.75) 300.00 125.75 41.9%6609080 Collateral Material - - - 2,922.21 - 2,922.21 9,000.00 6,077.79 67.5%6609102 Contract Services-Web Page 99.00 175.00 (76.00) 792.00 1,575.00 (783.00) 2,100.00 1,308.00 62.3%6609490 Miscellaneous - 50.00 (50.00) 303.28 250.00 53.28 350.00 46.72 13.3%6609620 Postage 187.94 50.00 137.94 362.22 450.00 (87.78) 600.00 237.78 39.6%6609630 Promotion 263.02 50.00 213.02 503.44 550.00 (46.56) - (503.44) 0.0%6609633 Promotion-Community - 75.00 (75.00) 128.31 2,700.00 (2,571.69) 2,925.00 2,796.69 95.6%6609634 Promotion-Media/Vender - - - - - - 700.00 - 0.0%6609150 Dues and Subscriptions 695.00 300.00 395.00 695.00 735.00 (40.00) 735.00 40.00 0.0%6609820 Uniforms 71.66 50.00 21.66 329.94 550.00 (220.06) 600.00 270.06 45.0%Total-MKT-OTHER EXPENSES 30,834.06 28,843.00 1,991.06 228,524.93 208,368.00 20,156.93 192,600.00 (36,624.93) -19.0%Total-MARKETING33,373.81 33,756.00 (382.19) 256,010.69 258,010.00 (1,999.31) 248,480.00 (8,230.69) -3.3%Month to Date Year to DateSilverRock ResortMarketing Expense StatementMarch 2007Annual Budget8 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 1,620.00 1,620.00 - 2,160.00 540.00 25.0%6701320 Insurance-Group2,026.06 2,280.00 (253.94) 14,778.91 20,520.00 (5,741.09) 27,360.00 12,581.09 46.0%6701325 Insurance-Workers Comp1,479.46 1,598.00 (118.54) 10,787.82 14,382.00 (3,594.18) 19,176.00 8,388.18 43.7%6701720 Salaries 12,434.00 13,250.00 (816.00) 119,400.50 119,250.00 150.50 159,000.00 39,599.50 24.9%6701800 Taxes-Employer Payroll 1,248.95 1,989.00 (740.05) 11,553.26 17,901.00 (6,347.74) 23,874.00 12,320.74 51.6%6701880 Wages-Hourly2,371.68 2,730.00 (358.32) 25,556.46 24,570.00 986.46 32,756.00 7,199.54 22.0%6701882 Wages-Overtime - - - 418.50 - 418.50 - (418.50) 0.0%Total-G&A-SALARIES & BENEFITS 19,740.15 22,027.00 (2,286.85) 184,115.45 198,243.00 (14,127.55) 264,326.00 80,210.55 30.3%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer1,046.96 500.00 546.96 2,097.28 4,500.00 (2,402.72) 6,000.00 3,902.72 65.0%6703762 Supplies-Office 495.07 125.00 370.07 1,414.49 1,125.00 289.49 1,500.00 85.51 5.7%6703768 Supplies-Printing & Stationery104.10 400.00 (295.90) 1,377.27 2,000.00 (622.73) 3,200.00 1,822.73 57.0%6703778Supplies-Small Tools/Non-Capital - 100.00 (100.00) - 700.00 (700.00) 900.00 900.00 100.0%Total-G&A-SUPPLIES & MATERIALS 1,646.13 1,125.00 521.13 4,889.04 8,325.00 (3,435.96) 11,600.00 6,710.96 57.9%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 1,742.50 900.00 842.50 1,200.00 (542.50) -45.2%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 1,742.50 900.00 842.50 1,200.00 (542.50) -45.2%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 3,600.00 3,600.00 - 4,800.00 1,200.00 25.0%6709090 Contract Services- - - 75.00 - 75.00 - - 0.0%6709150 Dues & Subscriptions- 50.00 (50.00) - 900.00 (900.00) 1,500.00 1,500.00 100.0%6709180 Employee Recruiting/Relocation652.39 - 652.39 4,815.00 2,000.00 2,815.00 2,000.00 (2,815.00) -140.8%6709197 Equipment Rental357.78 350.00 7.78 2,958.39 3,150.00 (191.61) 4,200.00 1,241.61 29.6%6709202 Fees-Bank162.13 300.00 (137.87) 1,082.29 2,700.00 (1,617.71) 3,600.00 2,517.71 69.9%6709208 Fees-Payroll Processing545.67 550.00 (4.33) 5,477.27 4,950.00 527.27 6,600.00 1,122.73 0.0%6709220 Freight/Delivery156.32 50.00 106.32 734.42 450.00 284.42 600.00 (134.42) -22.4%6709490 Miscellaneous 80.28 100.00 (19.72) 519.11 900.00 (380.89) 1,200.00 680.89 56.7%6709620 Postage/Mail Services 4.64 75.00 (70.36) 623.54 675.00 (51.46) 900.00 276.46 30.7%6709625 Professional Fees- 400.00 (400.00) 3,305.00 3,600.00 (295.00) 4,800.00 1,495.00 31.1%6709636 Promotion/Entertainment- 100.00 (100.00) - 900.00 (900.00) 1,200.00 1,200.00 100.0%6709722 Seminars & Training- - - 925.00 500.00 425.00 900.00 (25.00) -2.8%6709810 Travel - - - 120.99 200.00 (79.01) 1,100.00 979.01 89.0%6709820 Uniforms 41.26 75.00 (33.74) 334.57 825.00 (490.43) 1,050.00 715.43 68.1%Total-G&A-OTHER EXPENSES 2,400.47 2,450.00 (49.53) 24,570.58 25,350.00 (779.42) 34,450.00 9,954.42 28.9%Total-GENERAL & ADMINISTRATIVE23,786.75 25,702.00 (1,915.25) 215,317.57 232,818.00 (17,500.43) 311,576.00 96,333.43 30.9%Month to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementMarch 2007Annual Budget9 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 2,094.08 9,800.00 (7,705.92) 75,509.58 88,200.00 (12,690.42) 117,600.00 42,090.42 35.8%6800193 Equipment Leases-Course Maint 7,164.16 20,000.00 (12,835.84) 172,586.05 180,000.00 (7,413.95) 240,000.00 67,413.95 28.1%6800194 Equipment Leases-Trailer 920.13 600.00 320.13 6,722.09 5,400.00 1,322.09 7,200.00 477.91 6.6%6800195 Equipment Leases-Software 1,900.22 1,525.00 375.22 12,680.73 13,725.00 (1,044.27) 18,300.00 5,619.27 30.7%6800196 Equipment Leases-GPS 7,370.25 7,400.00 (29.75) 61,271.48 66,600.00 (5,328.52) 88,800.00 27,528.52 31.0%6800198 Equipment Leases-Others 20,055.76 - 20,055.76 20,055.76 - 20,055.76 - - 0.0%Total-LEASES39,504.60 39,325.00 179.60 348,825.69 353,925.00 (5,099.31) 471,900.00 143,130.07 30.3%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee (10,699.09) (141.00) (10,558.09) 60,116.09 93,182.00 (33,065.91) 125,196.00 65,079.91 52.0%6900210 FF&E Reserve 12,105.33 10,445.00 1,660.33 46,723.77 48,690.00 (1,966.23) 67,426.00 20,702.23 30.7%6900211 Personal Property Taxes 3,003.02 - 3,003.02 3,003.02 20,000.00 (16,996.98) 20,000.00 16,996.98 85.0%6900323 Insurance-Commercial - 4,200.00 (4,200.00) 44,523.40 37,800.00 6,723.40 50,400.00 5,876.60 11.7%Total-MISC OTHER EXPENSES4,409.26 14,504.00 (10,094.74) 154,366.28 199,672.00 (45,305.72) 263,022.00 108,655.72 41.3% Operating Leases & Miscellaneous Other Expense StatementMarch 2007Annual BudgetMonth to Date Year to Date10 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2006‐20072006 2006 2006 2006 2006 2006Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia6158 01815Sales727842Promotion423000Golf Industry20 21 15 9 17 26VIP600004Celebrity000000PGA Comp27 28 60 2 16 18Charity/Gift Certificate624370 029Rain/Wind Checks0000287Club Staff20 17 44 2 22 50LQ HS Golf00030096 109 174 24 105 1512007 2007 2007 2007 2007 2007Comp CategoryJanuaryFebruaryMarchAprilMayJuneMedia31 128Sales000Promotion300Golf Industry8424VIP000Celebrity002PGA Comp43 1636Charity/Gift Certificate688Rain/Wind Checks9836Club Staff89 4028LQ HS Golf0 36 108189 124 250 0 0 011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2006‐2007March 20073/8/2007 7:45 John White KESQ Media 43/8/2007 12:52 Gary Sinese / Mykelti Williamson Celebrity 23/12/2007 7:22 Jim Houston CBS Media 23/12/2007 9:15 Susan Reed + 1 Golf for Women Media 212