Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
10 April 2006 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2005 – April 2006 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 AprilFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 411,763.50 441,096.00 (29,332.50) -6.6% 2,371,558.80 2,636,373.00 (264,814.20) 3,175,395.00 803,836.20 75%401000 Miscellaneous Golf Revenue 8,469.00 2,927.00 5,542.00 189.3% 51,119.00 29,571.00 21,548.00 34,470.00 (16,649.00) 148%410000 Revenue-Golf Shop 31,971.00 27,511.00 4,460.00 16.2% 224,105.26 197,900.00 26,205.26 245,790.50 21,685.24 91%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 - - - 0.0% 74.44 - 74.44 - (74.44) Total Income 452,703.50 472,034.00 (19,330.50) -4.1% 2,657,857.50 2,874,844.00 (216,986.50) 3,467,655.50 809,798.00 77%Cost of Goods Sold510000 COS-Golf Shop 17,298.13 16,391.35 906.78 -5.5% 129,230.45 120,790.56 (8,439.89) 147,455.77 18,225.32 88%Total COS 17,298.13 16,391.35 906.78 -5.5% 129,230.45 120,790.56 (8,439.89) 147,455.77 18,225.32 88%Gross Profit 435,405.37 455,642.65 (20,237.28) -4.4% 2,528,627.05 2,754,053.44 (225,426.39) 3,320,199.73 791,572.68 76%610000 Golf Pro Shop 14,257.23 17,569.00 3,311.77 18.9% 146,721.22 168,432.00 21,710.78 200,010.00 53,288.78 73%630000 Course Maintenance 139,731.71 128,225.00 (11,506.71) -9.0% 1,585,868.43 1,504,672.00 (81,196.43) 1,746,916.00 161,047.57 91%640000 Outside Services 27,331.98 34,079.00 6,747.02 19.8% 208,562.57 283,784.00 75,221.43 336,789.00 128,226.43 62%650000 Clubhouse 16,620.54 18,076.00 1,455.46 8.1% 130,516.76 170,357.00 39,840.24 206,756.00 76,239.24 63%660000 Marketing 30,045.94 16,742.00 (13,303.94) -79.5% 203,073.83 217,220.00 14,146.17 250,692.00 47,618.17 81%670000 General & Administrative 21,498.55 26,498.00 4,999.45 18.9% 235,942.81 261,780.00 25,837.19 315,272.00 79,329.19 75%680000 Leases 37,066.57 36,255.33 (811.24) -2.2% 331,175.89 332,462.31 1,286.42 397,172.97 65,997.08 83%690000 Miscellaneous Other Expense 2,588.27 20,836.00 18,247.73 87.6% 204,799.07 243,891.00 39,091.93 281,307.00 76,507.93 73%Total Expenses 289,140.79 298,280.33 9,139.54 3.1% 3,046,660.58 3,182,598.31 135,937.73 3,734,914.97 688,254.39 82%Net Income146,264.58 157,362.32 (11,097.74) -7.1%(518,033.53) (428,544.87) (89,488.66) (414,715.24) 103,318.29 125%Rounds of Golf PlayedRounds Played 5,332 4,182 1,150 27.5% 32,613 30,818 1,795 37,814 5,201 86%Ave $ Per Round Green Fee 77.22 105.47 (28.25) -26.8% 72.72 85.55 (12.83) 83.97 11 87%Ave $ Per Round Merchandise 6.00 6.58 (0.58) -8.9% 6.87 6.42 0.45 6.50 (0) 106%Ave $ Per Miscellaneous 1.59 0.70 0.89 126.9% 1.57 0.96 0.61 - - 0%April 2006SilverRock ResortSummary Operating Income Statement1 Income AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 411,763.50 441,096.00 (29,332.50) 2,371,558.80 2,636,373.00 (264,814.20) 3,175,395.00 803,836.20 75%4010000 Rider Fee 1,250.00 - 1,250.00 4,350.00 - 4,350.00 0.00 0.00 0%4040000 Club Rental 2,630.00 627.00 2,003.00 14,855.00 4,621.00 10,234.00 5,672.00 (9,183.00) 262%4050000 Driving Range 4,509.00 2,300.00 2,209.00 29,169.00 16,950.00 12,219.00 20,798.00 -8,371.00 140%4060000 Handicap Fees 80.00 - 80.00 2,745.00 8,000.00 (5,255.00) 8,000.00 5,255.00 34% Total Revenue Fees 420,232.50 444,023.00 (23,790.50) 2,422,677.80 2,665,944.00 (243,266.20) 3,209,865.00 791,537.20 75%Total Income420,232.50 444,023.00 (23,790.50) 2,422,677.80 2,665,944.00 (243,266.20) 3,209,865.00 791,537.20 75%SilverRock ResortStatement of Fees RevenueApril 2006Month to Date Year to Date Annual Budget2 Income AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 1,134.70 - 1,134.70 7,202.97 - 7,202.97 4100110 Sales Hard Goods 14,572.03 10,873.00 3,699.03 75,303.39 80,127.50 (4,824.11) 98,316.50 23,013.11 77%4100112 Sales-Soft Goods 18,038.50 16,310.00 1,728.50 174,660.75 120,188.50 54,472.25 147,474.00 (27,186.75) 118%5100639 GS-Discounts-Mdse (1,774.23) 328.00 (2,102.23) (33,061.85) (2,416.00) (30,645.85) (2,964.00) 30,097.85 -1115% Total Revenue Golf Shop 31,971.00 27,511.00 4,460.00 224,105.26 197,900.00 26,205.26 242,826.50 25,924.21 89%COS 5100150 COS-GS-Hard Goods 8,459.26 6,556.42 1,902.84 44,412.04 48,316.89 (3,904.85) 59,284.85 14,872.81 75%5100151 COS-GS-Soft Goods 8,838.87 9,834.93 (996.06) 84,818.41 72,473.67 12,344.74 88,925.92 4,107.51 95%Cost of Sales - Golf Shop 17,298.13 16,391.35 906.78 129,230.45 120,790.56 8,439.89 148,210.77 18,980.32 87%Gross Profit 14,672.87 11,119.65 3,553.22 94,874.81 77,109.44 17,765.37 94,615.73 6,943.89 93%COS % 56.1% 59.6% 3.5% 57.7% 61.0% 3.4% 61.0% 73.2% -20%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 300.00 300.00 - 2,976.41 2,760.00 216.41 3,240.00 263.59 92%6101320 Insurance Group 2,295.20 2,640.00 (344.80) 17,970.02 22,800.00 (4,829.98) 28,080.00 10,109.98 64%6101325 Insurance-Workers Comp 566.73 1,510.00 (943.27) 6,188.94 14,504.00 (8,315.06) 17,229.00 11,040.06 36%6101720 Salaries 2,615.40 3,333.00 (717.60) 27,175.62 33,330.00 (6,154.38) 39,996.00 12,820.38 68%6101800 Taxes-Employer Payroll 978.65 1,310.00 (331.35) 9,572.40 12,580.00 (3,007.60) 14,940.00 5,367.60 64%6101880 Wages-Hourly 6,165.02 7,185.00 (1,019.98) 59,769.96 67,690.00 (7,920.04) 79,980.00 20,210.04 75%6101882 Wages-Overtime 263.83 - 263.83 4,481.35 - 4,481.35 - 952.88 0%Total -PS-SALARIES & BENEFITS 13,184.83 16,278.00 (3,093.17) 128,134.70 153,664.00 (25,529.30) 183,465.00 60,764.53 67%61-PS-SUPPLIES & MATERIALS6103742 Supplies-Expendable 26.86 200.00 (173.14) 1,418.56 3,400.00 (1,981.44) 3,800.00 2,381.44 37%Total PS-SUPPLIES & MATERIALS 26.86 200.00 (173.14) 1,418.56 3,400.00 (1,981.44) 3,800.00 2,381.44 37%61-PS OTHER EXPENSES6103762 Supplies-Office - 45.00 (45.00) 2,450.72 780.00 1,670.72 870.00 (1,580.72) 282%6109090 Contract Services 500.00 500.00 - 4,500.00 5,000.00 (500.00) 6,000.00 1,500.00 75%6109197 Equipment Rental 50.00 - 50.00 2,303.70 - 2,303.70 - (2,303.70) 0%6109220 Freight & Delivery 263.88 246.00 17.88 617.39 1,888.00 (1,270.61) 2,300.00 1,682.61 27%6109490 Miscellaneous - 50.00 (50.00) 90.40 350.00 (259.60) 450.00 359.60 20%6109150 Dues and Subscriptions - - - 114.18 - 114.18 1,500.00 1,385.82 8%6109500 ProShop-Over/Short 17.80 - 17.80 (78.94) - (78.94) - 78.94 0%6109722 Seminars/Training - 35.00 (35.00) 4,194.84 1,890.00 2,304.84 1,960.00 (2,234.84) 214%6109810 Travel - Merchandise - 15.00 (15.00) 96.00 60.00 36.00 90.00 (6.00) 107%6109820 Uniforms 104.68 200.00 (95.32) 1,837.77 1,400.00 437.77 1,800.00 (37.77) 102%6117840 Telephones 109.18 - 109.18 1,041.90 - 1,041.90 - (1,041.90) 0%6119206 License and Permits - - - - - - - - 0%Total PS-OTHER EXPENSES 1,045.54 1,091.00 (45.46) 17,167.96 11,368.00 5,799.96 14,970.00 (2,197.96) 115%Total Expenses 14,257.23 17,569.00 (3,311.77) 146,721.22 168,432.00 (21,710.78) 202,235.00 58,566.57 71%Net Income415.64 (6,449.35) 6,864.99 (51,846.41) (91,322.56) 39,476.15 (107,619.27) (51,622.68) -52%Month to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementApril 20063 AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 1,729.18 2,400.00 (670.82) 2,880.00 1,150.82 40.0%6311320 Insurance-Group 11,364.60 5,880.00 5,484.60 108,757.81 58,800.00 49,957.81 70,560.00 (38,197.81) -54.1%6311325 Insurance-Workers Comp 4,857.44 8,073.00 (3,215.56) 62,836.87 85,499.00 (22,662.13) 102,328.00 39,491.13 38.6%6311720 Salaries 10,692.32 12,083.00 (1,390.68) 114,063.55 120,814.00 (6,750.45) 144,980.00 30,916.45 21.3%6311800 Taxes-Employer Payroll 6,149.34 6,999.00 (849.66) 63,593.05 74,931.00 (11,337.95) 89,637.00 26,043.95 29.1%6311880 Wages-Hourly 45,635.68 44,136.00 1,499.68 466,104.04 461,662.00 4,442.04 552,841.00 86,736.96 15.7%6311882 Wages-Overtime 742.64 - 742.64 106,818.42 30,384.00 76,434.42 22,153.00 (84,665.42) -382.2%Total-CM-SALARIES & BENEFITS79,682.02 77,411.00 2,271.02 923,902.92 834,490.00 89,412.92 985,379.00 61,476.08 6.2%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 2,341.35 - 2,341.35 9,508.19 - 9,508.19 (9,508.19) 0.0%6313744 Fertilizer 5,431.61 6,000.00 (568.39) 71,749.23 39,500.00 32,249.23 48,000.00 (23,749.23) -49.5%6313746 Flowers/Plants - 100.00 (100.00) 131.60 5,400.00 (5,268.40) 5,500.00 5,368.40 97.6%6313748 Fuel-Gasoline 5,440.06 1,600.00 3,840.06 35,400.78 14,800.00 20,600.78 17,800.00 (17,600.78) -98.9%6313750 Golf Course Accessories 603.17 100.00 503.17 6,491.35 3,450.00 3,041.35 3,650.00 (2,841.35) -77.8%6313756 Supplies-Lubricants & Oils 567.73 - 567.73 3,428.48 - 3,428.48 - (3,428.48) 0.0%6313758 Miscellaneous Supp 81.49 50.00 31.49 5,160.95 500.00 4,660.95 600.00 (4,560.95) -760.2%6313762 Supplies-Office 545.03 - 545.03 3,640.70 - 3,640.70 - (3,640.70) 0.0%6313766 Pesticides 114.16 300.00 (185.84) 16,476.67 11,550.00 4,926.67 13,050.00 (3,426.67) -26.3%6313774 Sand 5,055.79 100.00 4,955.79 12,808.59 6,460.00 6,348.59 6,660.00 (6,148.59) -92.3%6313776 Seed 1,164.00 350.00 814.00 88,832.08 84,050.00 4,782.08 84,750.00 (4,082.08) -4.8%6313778 Small Tools & Non-Capital Equip 496.79 200.00 296.79 7,763.62 6,400.00 1,363.62 6,700.00 (1,063.62) -15.9%6313780 Sod - - - 6,105.25 2,500.00 3,605.25 4,000.00 (2,105.25) -52.6%6313782 Topdressing 1,975.38 - 1,975.38 1,996.93 3,000.00 (1,003.07) 4,000.00 2,003.07 50.1%Total-CM-SUPPLIES & MATERIALS23,816.56 8,800.00 15,016.56 269,494.42 177,610.00 91,884.42 194,710.00 (74,784.42) -38.4%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 705.87 1,500.00 (794.13) 13,820.08 15,000.00 (1,179.92) 12,000.00 (1,820.08) -15.2%6315685 CM-R&M-Bldngs & Othr Structures 143.26 - 143.26 5,485.28 500.00 4,985.28 500.00 (4,985.28) -997.1%6315686 CM-R&M- Drainage - - - 2,706.20 - 2,706.20 - (2,706.20) 0.0%6315690 CM-R&M-Equipment 2,411.72 900.00 1,511.72 29,119.76 13,400.00 15,719.76 15,200.00 (13,919.76) -91.6%6315692 CM-R&M-Irrigation System 4,128.72 650.00 3,478.72 12,483.48 8,350.00 4,133.48 9,650.00 (2,833.48) -29.4%6315696 CM-R&M-Pumps - - - 2,675.89 4,000.00 (1,324.11) 5,000.00 2,324.11 46.5%6315815 CM-R&M-Trees-Pruning Etc1,303.94 - 1,303.94 5,501.79 5,000.00 501.79 5,000.00 (501.79) -10.0%Total-CM-REPAIRS & MAINTENANCE 8,693.51 3,050.00 5,643.51 71,792.48 46,250.00 25,542.48 47,350.00 (24,442.48) -51.6%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs 29.11 1,526.00 (1,496.89) 17,676.16 17,545.00 131.16 22,080.00 4,403.84 19.9%6317836 Utilities-Natural Gas/LPG 112.31 - 112.31 112.31 - 112.31 - (112.31) 0.0%6317840 Telephones 1,130.16 325.00 805.16 10,102.51 3,250.00 6,852.51 3,900.00 (6,202.51) -159.0%Total-CM-UTILITIES 1,271.58 1,851.00 (579.42) 27,890.98 20,795.00 7,095.98 25,980.00 (1,910.98) -7.4%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 - - - - 2,000.00 (2,000.00) 4,000.00 4,000.00 100.0%6319101 Contract Svcs-Trash Removal 1,675.13 900.00 775.13 48,469.09 25,400.00 23,069.09 17,000.00 (31,469.09) -185.1%6319150 Dues & Subscriptions - - - 135.00 750.00 (615.00) 1,000.00 865.00 86.5%6319170 Employee Education - 800.00 (800.00) 500.00 2,480.00 (1,980.00) 2,600.00 2,100.00 80.8%6319197 Equipment Rental 1,371.65 100.00 1,271.65 14,137.83 16,844.00 (2,706.17) 3,900.00 (10,237.83) -262.5%6319206 Licenses & Permits - 250.00 (250.00) 4.00 2,000.00 (1,996.00) 2,000.00 1,996.00 99.8%6319490 Miscellaneous - 50.00 (50.00) 18,035.21 500.00 17,535.21 600.00 (17,435.21) -2905.9%6319500 Propane/Natural Gas - 50.00 (50.00) 1,150.95 500.00 650.95 600.00 (550.95) -91.8%6319718 Safety Equipment & Training 165.65 100.00 65.65 4,603.78 3,200.00 1,403.78 3,400.00 (1,203.78) -35.4%6319822 Uniforms 1,387.99 750.00 637.99 10,484.53 8,250.00 2,234.53 9,750.00 (734.53) -7.5%Total-CM-OTHER EXPENSES 5,100.42 3,500.00 1,600.42 102,520.39 66,924.00 35,596.39 50,850.00 (51,670.39) -101.6%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementApril 2006Annual Budget4 AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,012.63 - 1,012.63 10,389.34 - 10,389.34 - (10,389.34) 0.0%6321325 Insurance-Workers Comp 494.95 2,048.00 (1,553.05) 10,877.59 21,144.00 (10,266.41) 25,335.00 14,457.41 57.1%6321800 Taxes-Employer Payroll 531.40 1,776.00 (1,244.60) 7,467.77 18,621.00 (11,153.23) 22,296.00 14,828.23 66.5%6321880 Wages-Hourly 10,461.63 14,264.00 (3,802.37) 84,537.62 142,640.00 (58,102.38) 171,168.00 86,630.38 50.6%6321882 Wages-Overtime 134.66 - 134.66 22,821.13 6,915.00 15,906.13 7,903.00 (14,918.13) -188.8%Total-CM-LM-SALARIES & BENEFITS12,635.27 18,088.00 (5,452.73) 136,093.45 189,320.00 (53,226.55) 226,702.00 100,997.89 44.6%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 1,743.12 850.00 893.12 1,025.00 (718.12) -70.1%6323788 Uniforms 373.44 375.00 (1.56) 3,362.56 2,400.00 962.56 2,850.00 (512.56) -18.0%Total-CM-LM-SUPPLIES & MATERIALS373.44 450.00 (76.56) 5,105.68 3,250.00 1,855.68 3,875.00 (1,230.68) -31.8%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 250.00 (250.00) 5,091.35 3,000.00 2,091.35 3,750.00 (1,341.35) -35.8%Total-CM-LM-REPAIRS & MAINTENANCE - 250.00 (250.00) 5,091.35 3,000.00 2,091.35 3,750.00 (1,341.35) -35.8%632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 6,290.85 13,275.00 (6,984.15) 27,528.35 147,920.00 (120,391.65) 189,642.00 162,113.65 85.5%6337842 Utilities-Water1,868.06 1,550.00 318.06 16,448.41 15,113.00 1,335.41 18,678.00 2,229.59 11.9%Total-CM-WATER & ENERGY8,158.91 14,825.00 (6,666.09) 43,976.76 163,033.00 (119,056.24) 208,320.00 164,343.24 78.9%Total -COURSE MAINTENANCE139,731.71 128,225.00 11,506.71 1,585,868.43 1,504,672.00 81,196.43 1,746,916.00 171,436.91 9.8%Month to Date Year to DateSilverrock ResortCourse Maintenance Expense StatementApril 2006Annual Budget5 AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 540.00 540.00 - 3,977.27 4,680.00 (702.73) 5,580.00 1,602.73 28.7%6411320 Insurance-Group 706.37 1,080.00 (373.63) 4,175.84 9,360.00 (5,184.16) 11,160.00 6,984.16 62.6%6411325 Insurance-Workers Comp 379.80 1,567.00 (1,187.20) 5,495.92 12,660.00 (7,164.08) 15,346.00 9,850.08 64.2%6411800 Taxes-Employer Payroll 1,131.11 1,359.00 (227.89) 9,451.97 10,978.00 (1,526.03) 13,307.00 3,855.03 29.0%6411880 Wages-Hourly 8,577.39 10,913.00 (2,335.61) 78,009.59 88,169.00 (10,159.41) 106,875.00 28,865.41 27.0%6411882 Wages-Overtime 604.87 - 604.87 2,969.70 - 2,969.70 - (2,969.70) 0.0%Total-CBR-SALARIES & BENEFITS11,939.54 15,459.00 (3,519.46) 104,080.29 125,847.00 (21,766.71) 152,268.00 48,187.71 31.6%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 750.20 75.00 675.20 2,479.91 2,300.00 179.91 2,450.00 (29.91) -1.2%6413742 Supplies-Expendable 1,108.61 4,000.00 (2,891.39) 9,055.44 15,900.00 (6,844.56) 23,900.00 14,844.56 62.1%6413752 Supplies-Range Balls - - - 3,712.50 6,000.00 (2,287.50) 6,000.00 2,287.50 38.1%6413762 Supplies-Office 169.15 50.00 119.15 244.55 600.00 (355.45) 700.00 455.45 65.1%6413768 Supplies-Printing and Stationary - 70.00 (70.00) - 280.00 (280.00) 420.00 420.00 100.0%6413786 Supplies-Towels 1,277.28 72.00 1,205.28 3,071.52 2,648.00 423.52 2,792.00 (279.52) -10.0%6413796 Supplies-Bottled Water2,478.10 2,509.00 (30.90) 19,581.40 18,490.00 1,091.40 22,688.00 3,106.60 13.7%Total-CBR-SUPPLIES & MATERIALS5,783.34 6,776.00 (992.66) 38,145.32 46,218.00 (8,072.68) 58,950.00 20,804.68 35.3%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts 1,080.00 720.00 360.00 6,985.08 7,200.00 (214.92) 8,640.00 1,654.92 19.2%6415690 CBR-R&M-Equipment 202.28 125.00 77.28 2,063.07 1,250.00 813.07 1,500.00 (563.07) -37.5%6415695 CBR-R&M-Cart Maintenance & Repair 293.46 150.00 143.46 1,441.32 1,500.00 (58.68) 1,800.00 358.68 19.9%Total-CBR-REPAIRS & MAINTENANCE 1,575.74 995.00 580.74 10,489.47 9,950.00 539.47 11,940.00 1,450.53 12.1%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps 600.00 250.00 350.00 3,235.00 4,800.00 (1,565.00) 5,000.00 1,765.00 35.3%6419094 Contract Services-Laundry/Linen - 55.00 (55.00) 3,365.87 550.00 2,815.87 660.00 (2,705.87) -410.0%6419220 Freight/Delivery - 25.00 (25.00) - 250.00 (250.00) 300.00 300.00 100.0%6419490 Miscellaneous - 125.00 (125.00) 381.14 1,250.00 (868.86) 1,500.00 1,118.86 74.6%6419820 Uniforms 2,301.34 - 2,301.34 4,571.01 3,425.00 1,146.01 4,625.00 53.99 1.2%Total-CBR-OTHER EXPENSES 2,901.34 455.00 2,446.34 11,553.02 10,275.00 1,278.02 12,085.00 531.98 4.4%TOTAL-CARTS,BAGROOM & RANGE 22,199.96 23,685.00 (1,485.04) 164,268.10 192,290.00 (28,021.90) 235,243.00 70,974.90 30.2%643-CS-SALARIES & BENEFITS6431175 Employee Meals 300.00 300.00 - 2,376.64 2,520.00 (143.36) 2,880.00 503.36 17.5%6431320 Insurance-Group - 720.00 (720.00) 958.00 6,480.00 (5,522.00) 7,920.00 6,962.00 87.9%6431325 Insurance-Workers Comp 161.77 1,011.00 (849.23) 1,434.25 8,954.00 (7,519.75) 9,820.00 8,385.75 85.4%6431800 Taxes-Employer Payroll 599.24 876.00 (276.76) 5,706.22 7,760.00 (2,053.78) 8,510.00 2,803.78 32.9%6431880 Wages-Hourly 3,945.00 7,037.00 (3,092.00) 31,359.70 62,330.00 (30,970.30) 68,362.00 37,002.30 54.1%6431882 Wages-Overtime 42.02 - 42.02 698.40 - 698.40 - (698.40) 0.0%Total-CS-SALARIES & BENEFITS5,048.03 9,944.00 (4,895.97) 42,533.21 88,044.00 (45,510.79) 97,492.00 54,958.79 56.4%643-CS-OTHER EXPENSES6433742 Supplies Expendable 83.99 100.00 (16.01) 832.23 900.00 (67.77) 1,100.00 267.77 24.3%6439490 Miscellaneous - 50.00 (50.00) 79.55 450.00 (370.45) 504.00 424.45 84.2%6439718 Safety Equipment & Training - 100.00 (100.00) - 1,000.00 (1,000.00) 1,200.00 1,200.00 100.0%6439820 Uniforms - 200.00 (200.00) 849.48 1,100.00 (250.52) 1,250.00 400.52 32.0%Total-CS-OTHER EXPENSES 83.99 450.00 (366.01) 1,761.26 3,450.00 (1,688.74) 4,054.00 2,292.74 56.6%Total-COURSE SERVICES 5,132.02 10,394.00 (5,261.98) 44,294.47 91,494.00 (47,199.53) 101,546.00 57,251.53 56.4%TOTAL OUTSIDE SERVICES27,331.98 34,079.00 (6,747.02) 208,562.57 283,784.00 (75,221.43) 336,789.00 125,933.69 37.4%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementApril 2006Annual Budget6 AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable637.57 300.00 337.57 5,289.23 3,000.00 2,289.23 4,300.00 (989.23) -23.0%Total-CH-SUPPLIES & MATERIALS 637.57 300.00 337.57 5,289.23 3,000.00 2,289.23 4,300.00 (989.23) -23.0%65-CH-UTILITIES6507830 Utilities-Electric-Bldgs158.39 4,526.00 (4,367.61) 3,418.40 36,657.00 (33,238.60) 45,256.00 41,837.60 92.4%6507836 Utilities-Natural Gas927.32 200.00 727.32 3,438.84 2,000.00 1,438.84 2,400.00 (1,038.84) -43.3%6507838 Utilities-Sewer- 200.00 (200.00) - 2,000.00 (2,000.00) 2,400.00 2,400.00 100.0%6507840 Utilities-Telephone1,110.52 1,000.00 110.52 10,547.62 10,000.00 547.62 12,000.00 1,452.38 12.1%6507842 Utilities-Water104.24 200.00 (95.76) 1,706.13 2,000.00 (293.87) 2,400.00 693.87 28.9%6507844 Utilities-Cable317.67 - 317.67 2,091.87 - 2,091.87 - (2,091.87) 0.0%Total-CH-UTILITIES 2,618.14 6,126.00 (3,507.86) 21,202.86 52,657.00 (31,454.14) 64,456.00 43,253.14 67.1%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,750.00 1,750.00 - 17,500.00 17,500.00 - 21,000.00 3,500.00 16.7%6509098 Contract Services-Refuse Dispose319.02 300.00 19.02 5,085.57 3,000.00 2,085.57 3,600.00 (1,485.57) -41.3%6509099 Contract Services-Security11,250.12 8,250.00 3,000.12 77,536.39 82,500.00 (4,963.61) 99,000.00 21,463.61 21.7%6509215 Flowers & Decorations- 100.00 (100.00) 296.00 2,400.00 (2,104.00) 2,600.00 2,304.00 88.6%6509490 Miscellaneous- - - 1,235.46 - 1,235.46 - (1,235.46) 0.0%6509718 Safety Equipment & Training- 500.00 (500.00) 250.00 1,800.00 (1,550.00) 2,800.00 2,550.00 91.1%Total-CH-OTHER EXPENSES 13,319.14 10,900.00 2,419.14 101,903.42 107,200.00 (5,296.58) 129,000.00 27,096.58 21.0%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures- 250.00 (250.00) 1,147.56 2,500.00 (1,352.44) 3,000.00 1,852.44 61.7%6515686 CH-R&M-Restaurant Repairs45.69 250.00 (204.31) 45.69 2,500.00 (2,454.31) 3,000.00 2,954.31 98.5%6515690 CH-R&M-Equipment Repair- 250.00 (250.00) 928.00 2,500.00 (1,572.00) 3,000.00 2,072.00 69.1%Total-CH-REPAIRS & MAINTENANCE 45.69 750.00 (704.31) 2,121.25 7,500.00 (5,378.75) 9,000.00 6,878.75 76.4%Total CLUBHOUSE16,620.54 18,076.00 (1,455.46) 130,516.76 170,357.00 (39,840.24) 206,756.00 13,757.50 6.7%Month to Date Year to DateSilverRock ResortClubhouse Expense StatementApril 2006Annual Budget7 AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 667.26 600.00 67.26 720.00 52.74 7.3%6601320 Insurance-Group - 360.00 (360.00) - 3,600.00 (3,600.00) 4,320.00 4,320.00 100.0%6601325 Insurance-Workers Comp 191.15 431.00 (239.85) 2,973.85 4,310.00 (1,336.15) 5,172.00 2,198.15 42.5%6601720 Salaries 2,692.30 3,000.00 (307.70) 29,650.80 30,000.00 (349.20) 36,000.00 6,349.20 17.6%6601800 Taxes-Employer Payroll 205.96 374.00 (168.04) 2,607.55 3,740.00 (1,132.45) 4,488.00 1,880.45 41.9%Total-MKT-SALARIES & BENEFITS 3,149.41 4,225.00 (1,075.59) 35,899.46 42,250.00 (6,350.54) 50,700.00 14,800.54 29.2%66-MKT-SUPPLIES & MATERIALS6603080 Collateral Material - - - 1,878.51 - 1,878.51 - (1,878.51) 0.0%6603762 Supplies-Office 503.98 100.00 403.98 1,166.88 1,400.00 (233.12) 1,600.00 433.12 27.1%6603768 Supplies-Printing & Stationery - 125.00 (125.00) 460.30 6,300.00 (5,839.70) 6,550.00 6,089.70 93.0%503.98 225.00 278.98 3,505.69 7,700.00 (4,194.31) 8,150.00 4,644.31 57.0%66-MKT-UTILITIES6607840 Utilities-Telephone 106.21 100.00 6.21 1,066.05 1,000.00 66.05 1,200.00 133.95 11.2%Total-MKT-UTILITIES 106.21 100.00 6.21 1,066.05 1,000.00 66.05 1,200.00 133.95 11.2%66-MKT-OTHER EXPENSES6609010 Advertising 9,975.30 9,167.00 808.30 136,113.64 115,670.00 20,443.64 134,004.00 (2,109.64) -1.6%6609040 Business Meals - 100.00 (100.00) 109.38 1,000.00 (890.62) 1,200.00 1,090.62 90.9%6609080 Collateral Material 15,041.00 2,000.00 13,041.00 17,720.02 27,500.00 (9,779.98) 31,500.00 13,779.98 43.7%6609102 Contract Services-Web Page 99.00 150.00 (51.00) 1,489.00 1,500.00 (11.00) 1,800.00 311.00 17.3%6609490 Miscellaneous - 50.00 (50.00) - 350.00 (350.00) 450.00 450.00 100.0%6609620 Postage 376.85 100.00 276.85 988.97 1,000.00 (11.03) 1,200.00 211.03 17.6%6609630 Promotion - 500.00 (500.00) 1,700.00 12,500.00 (10,800.00) 13,500.00 11,800.00 87.4%6609633 Promotion-Community 20.00 75.00 (55.00) 1,022.55 5,025.00 (4,002.45) 5,175.00 4,152.45 80.2%6609634 Promotion-Media/Vender 595.00 - 595.00 1,550.82 - 1,550.82 - - 0.0%6609150 Dues and Subscriptions - - - 1,470.00 925.00 545.00 925.00 (545.00) 0.0%6609820 Uniforms 179.19 50.00 129.19 438.25 800.00 (361.75) 900.00 461.75 51.3%Total-MKT-OTHER EXPENSES 26,286.34 12,192.00 14,094.34 162,602.63 166,270.00 (3,667.37) 190,654.00 29,602.19 15.5%Total-MARKETING30,045.94 16,742.00 13,303.94 203,073.83 217,220.00 (14,146.17) 250,704.00 49,180.99 19.6%Month to Date Year to DateSilverRock ResortMarketing Expense StatementApril 2006Annual Budget8 AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 1,904.41 1,800.00 104.41 2,160.00 255.59 11.8%6701320 Insurance-Group1,510.09 3,480.00 (1,969.91) 17,827.39 28,800.00 (10,972.61) 35,760.00 17,932.61 50.1%6701325 Insurance-Workers Comp1,177.42 2,252.00 (1,074.58) 10,110.07 22,520.00 (12,409.93) 27,024.00 16,913.93 62.6%6701720 Salaries 11,827.84 13,083.00 (1,255.16) 132,497.91 130,830.00 1,667.91 156,996.00 24,498.09 15.6%6701800 Taxes-Employer Payroll 1,105.21 1,953.00 (847.79) 13,387.75 19,530.00 (6,142.25) 23,436.00 10,048.25 42.9%6701880 Wages-Hourly2,480.00 2,600.00 (120.00) 23,774.38 26,000.00 (2,225.62) 31,200.00 7,425.62 23.8%6701882 Wages-Overtime 139.50 - 139.50 4,395.29 - 4,395.29 - (4,395.29) 0.0%Total-G&A-SALARIES & BENEFITS 18,420.06 23,548.00 (5,127.94) 203,897.20 229,480.00 (25,582.80) 276,576.00 72,678.80 26.3%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 50.00 (50.00) 377.53 1,400.00 (1,022.47) 1,500.00 1,122.47 74.8%6703762 Supplies-Office 103.20 100.00 3.20 1,938.27 1,000.00 938.27 1,200.00 (738.27) -61.5%6703768 Supplies-Printing & Stationery60.65 500.00 (439.35) 1,383.83 2,900.00 (1,516.17) 3,900.00 2,516.17 64.5%6703778Supplies-Small Tools/Non-Capital - 100.00 (100.00) 685.05 800.00 (114.95) 1,000.00 314.95 31.5%Total-G&A-SUPPLIES & MATERIALS 163.85 750.00 (586.15) 4,384.68 6,100.00 (1,715.32) 7,600.00 3,215.32 42.3%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 1,475.93 1,000.00 475.93 1,200.00 (275.93) -23.0%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 1,475.93 1,000.00 475.93 1,200.00 (275.93) -23.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 4,066.31 4,000.00 66.31 4,800.00 733.69 15.3%6709090 Contract Services- - 495.00 - 495.00 - - 0.0%6709150 Dues & Subscriptions1,341.00 50.00 1,291.00 1,634.92 900.00 734.92 1,000.00 (634.92) -63.5%6709180 Employee Recruiting/Relocation56.00 - 56.00 6,553.23 2,000.00 4,553.23 2,000.00 (4,553.23) -227.7%6709197 Equipment Rental485.83 200.00 285.83 4,946.34 2,000.00 2,946.34 2,400.00 (2,546.34) -106.1%6709202 Fees-Bank46.81 400.00 (353.19) 615.46 3,500.00 (2,884.54) 4,300.00 3,684.54 85.7%6709208 Fees-Payroll Processing- - - 3,349.39 - 3,349.39 - (3,349.39) 0.0%6709220 Freight/Delivery- 50.00 (50.00) 889.32 500.00 389.32 600.00 (289.32) -48.2%6709490 Miscellaneous 75.00 100.00 (25.00) 395.90 1,000.00 (604.10) 1,200.00 804.10 67.0%6709620 Postage/Mail Services - 100.00 (100.00) 343.46 900.00 (556.54) 1,100.00 756.54 68.8%6709625 Professional Fees510.00 500.00 10.00 1,560.00 5,000.00 (3,440.00) 6,000.00 4,440.00 74.0%6709636 Promotion/Entertainment- 100.00 (100.00) 83.58 1,900.00 (1,816.42) 2,100.00 2,016.42 96.0%6709722 Seminars & Training- 100.00 (100.00) 520.00 1,000.00 (480.00) 1,200.00 680.00 56.7%6709810 Travel - - - 342.95 1,500.00 (1,157.05) 2,000.00 1,657.05 82.9%6709820 Uniforms - 100.00 (100.00) 389.14 1,000.00 (610.86) 1,200.00 810.86 67.6%Total-G&A-OTHER EXPENSES 2,914.64 2,100.00 814.64 26,185.00 25,200.00 985.00 29,900.00 4,210.00 14.1%Total-GENERAL & ADMINISTRATIVE21,498.55 26,498.00 (4,999.45) 235,942.81 261,780.00 (25,837.19) 315,276.00 79,828.19 25.3%Month to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementApril 2006Annual Budget9 AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 8,923.52 8,550.00 373.52 87,359.32 82,500.00 4,859.32 96,600.00 9,240.68 9.6%6800193 Equipment Leases-Course Maint 18,218.58 18,050.00 168.58 170,269.70 175,700.00 (5,430.30) 207,000.00 36,730.30 17.7%6800194 Equipment Leases-Trailer 310.41 850.00 (539.59) 2,793.69 8,500.00 (5,706.31) 10,200.00 7,406.31 72.6%6800195 Equipment Leases-Software 2,152.93 1,375.00 777.93 14,879.33 13,750.00 1,129.33 16,500.00 1,620.67 9.8%6800196 Equipment Leases-GPS 7,461.13 7,430.33 30.80 55,873.85 52,012.31 3,861.54 66,872.97 10,999.12 16.4%Total-LEASES37,066.57 36,255.33 811.24 331,175.89 332,462.31 (1,286.42) 397,172.97 65,997.08 16.6%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 7,500.00 6,402.00 1,098.00 75,250.00 112,107.00 (36,857.00) 131,954.00 56,704.00 43.0%6900097 Contract Srvcs-Golf Ops-Management Fee - - - 21,787.50 14,000.00 7,787.50 - (21,787.50) 0.0%6900098 Contract Srvcs-Management Fee-F&B (13,316.38) - (13,316.38) 38,992.54 10,239.00 28,753.54 10,239.00 (28,753.54) 0.0%6900210 FF&E Reserve 8,404.65 9,434.00 (1,029.35) 43,737.81 57,545.00 (13,807.19) 69,353.00 25,615.19 36.9%6900323 Insurance-Commercial - 5,000.00 (5,000.00) 25,031.22 50,000.00 (24,968.78) 80,000.00 54,968.78 68.7%Total-MISC OTHER EXPENSES2,588.27 20,836.00 (18,247.73) 204,799.07 243,891.00 (39,091.93) 291,546.00 86,746.93 29.8% Operating Leases & Miscellaneous Other Expense StatementApril 2006Annual BudgetMonth to Date Year to Date10 SilverRock Resort-Arnold Palmer Classic Course Comp Golf Report‐2005‐2006 2005 2005 2005 2005 2005 2005 Comp Category July August September October November December Media 18 28 13 5 23 18 Sales 8660218 Promotion 0040014 Golf Industry 8 1423131818 VIP 000033 Celebrity 000000 PGA Comp 00198425 City 000000 Charity/Gift Certificate 4000636 Rain/Wind Checks 000028 Club Staff 21 24 12 5 18 28 59 72 77 31 76 168 2006 2006 2006 2006 2006 2006 Comp Category January February March April May June Media 19 8 21 21 Sales 12 26 15 21 Promotion 10 12 1 4 Golf Industry 31 33 29 20 VIP 470 4 Celebrity 000 0 PGA Comp 29 15 27 20 City 000 0 Charity/Gift Certificate 30 29 32 41 Rain/Wind Checks 4621 25 Club Staff 41 12 17 22 LQ HS Golf 0 608848 180 208 251 226 0 0 11