Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
08 February 2009 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2008 – February 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 February Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 444,358.26 507,450.00 (63,091.74) -12.4% 1,584,127.02 1,789,308.00 (205,180.98) 3,255,761.00 1,671,633.98 49%401000 Miscellaneous Golf Revenue 17,121.25 16,260.00 861.25 5.3% 74,822.78 73,237.00 1,585.78 113,217.00 38,394.22 66%410000 Revenue-Golf Shop 33,876.50 51,000.00 (17,123.50) -33.6% 176,893.64 224,951.00 (48,057.36) 375,951.00 199,057.36 47%420000 Revenue-F&B Concession 1,500.00 1,500.00 - 0.0% 9,000.00 9,000.00 - 12,000.00 3,000.00 75%890000 Interest Income 3.42 - 3.42 0.0% 58.10 - 58.10 - (58.10) 0%Total Income496,859.43 576,210.00 (79,350.57) -13.8% 1,844,901.54 2,096,496.00 (251,594.46) 3,756,929.00 1,912,027.46 49%Cost of Goods Sold510000 COS-Golf Shop 21,196.82 27,069.00 (5,872.18) 21.7% 103,601.29 119,393.00 15,791.71 199,538.00 95,936.71 52%Total COS21,196.82 27,069.00 (5,872.18) 21.7% 103,601.29 119,393.00 15,791.71 199,538.00 95,936.71 52%Gross Profit475,662.61 549,141.00 (73,478.39) -13.4% 1,741,300.25 1,977,103.00 (235,802.75) 3,557,391.00 1,816,090.75 49%Expenses610000 Golf Pro Shop 17,455.76 24,952.00 7,496.24 30.0% 149,578.18 179,544.00 29,965.82 279,518.00 129,939.82 54%630000 Course Maintenance 116,483.77 133,864.00 17,380.23 13.0% 1,221,413.25 1,275,340.00 53,926.75 1,805,855.00 584,441.75 68%640000 Outside Services 26,199.24 28,941.00 2,741.76 9.5% 179,634.32 187,733.00 8,098.68 294,037.00 114,402.68 61%650000 Clubhouse 13,020.26 13,842.00 821.74 5.9% 107,388.32 112,736.00 5,347.68 168,104.00 60,715.68 64%660000 Marketing 27,100.93 35,703.00 8,602.07 24.1% 197,593.75 210,469.00 12,875.25 298,081.00 100,487.25 66%670000 General & Administrative 23,570.66 27,482.00 3,911.34 14.2% 193,390.64 224,056.00 30,665.36 333,834.00 140,443.36 58%680000 Leases 39,277.79 41,106.00 1,828.21 4.4% 323,133.52 328,848.00 5,714.48 493,272.00 170,138.48 66%690000 Miscellaneous Other Expense 14,680.03 10,399.00 (4,281.03) -41.2% 158,725.46 162,831.00 4,105.54 227,140.00 68,414.54 70%Total Expenses277,788.44 316,289.00 38,500.56 12.2% 2,530,857.44 2,681,557.00 150,699.56 3,899,841.00 1,368,983.56 65%Net Income 197,874.17 232,852.00 (34,977.83) -15.0%(789,557.19) (704,454.00) (85,103.19) (342,450.00) 447,107.19 231%Rounds of Golf PlayedPaid Rounds Played 4,669 4,922 (253) -5.1% 19,958 15,950 4,008 40,580 20,622 49%Ave $ Per Paid Round Green Fee 95.17 103.10 (7.93) -7.7% 79.37 112.18 (32.81) 77.90 (1.47) 102%Ave $ Per Paid Round Merchandise 7.26 10.36 (3.11) -30.0% 8.86 14.10 (5.24) 8.07 (0.79) 110%Ave $ Per Paid Miscellaneous 3.67 3.30 0.36 11.0% 3.75 4.59 (0.84) 2.06 - 0%Month to Date Year to DateFebruary 2009SilverRock ResortSummary Operating Income Statement1 Income February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 444,358.26 507,450.00 (63,091.74) 1,584,127.02 1,789,308.00 (205,180.98) 3,255,761.001,671,633.9849%4010000 Rider Fee 575.00 510.00 65.00 4,200.00 4,234.00 (34.00) 5,984.001,784.0070%4040000 Club Rental 2,420.00 5,100.00 (2,680.00) 10,860.00 15,303.00 (4,443.00) 27,583.0016,723.0039%4050000 Driving Range 10,905.00 7,650.00 3,255.00 39,392.00 26,200.00 13,192.00 46,650.007,258.0084%4060000 Handicap Fees 645.00 500.00 145.00 6,800.00 7,500.00 (700.00) 8,000.00 1,200.0085%4080000 GPS Advertising - 1,000.00 (1,000.00) 5,075.00 11,000.00 (5,925.00) 12,000.00 6,925.0042%4090000 Ball Retriever/Subcontract - - - 1,548.70 3,000.00 (1,451.30) 4,000.00 2,451.3039%4091000 Golf Professional Rental Fee 2,250.00 1,500.00 750.00 6,000.00 6,000.00 - 9,000.00 3,000.00 67%4092000 Golf Lessons 326.25 - 326.25 947.08 - 947.08 - (947.08) 0% Total Revenue Fees461,479.51 523,710.00 (62,230.49) 1,658,949.80 1,862,545.00 (203,595.20) 3,368,978.00 1,710,028.20 49%Total Income 461,479.51 523,710.00 (62,230.49) 1,658,949.80 1,862,545.00 (203,595.20) 3,368,978.00 1,710,028.20 49% Month to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueFebruary 20092 Income February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 537.84 - 537.84 5,515.84 - 5,515.84 4100110 Sales Hard Goods 10,117.37 17,850.00 (7,732.63) 72,824.18 78,733.00 (5,908.82) 131,583.00 58,758.82 55%4100112 Sales-Soft Goods 28,029.76 33,150.00 (5,120.24) 126,850.26 146,218.00 (19,367.74) 244,368.00 117,517.74 52%5100639 GS-Discounts-Mdse (4,808.47) - (4,808.47) (28,296.64) - (28,296.64) - 28,296.64 0% Total Revenue Golf Shop 33,876.50 51,000.00 (17,123.50) 176,893.64 224,951.00 (48,057.36) 375,951.00 204,573.20 46%COS 5100150 COS-GS-Hard Goods 6,103.46 9,818.00 (3,714.54) 40,877.89 43,304.00 (2,426.11) 72,373.00 31,495.11 56%5100151 COS-GS-Soft Goods 14,724.46 18,233.00 (3,508.54) 59,841.93 80,420.00 (20,578.07) 134,404.00 74,562.07 45%5100152 COS-GS-Purchase Disc (28.80) (1,403.00) 1,374.20 (205.57) (6,187.00) 5,981.43 (10,341.00) (10,135.43) -2%5100220 COS-GS-Freight Merch 397.70 421.00 (23.30) 3,087.04 1,856.00 1,231.04 3,102.00 14.96 100%Cost of Sales - Golf Shop 21,196.82 27,069.00 (5,872.18) 103,601.29 119,393.00 (15,791.71) 199,538.00 95,936.71 52%Gross Profit 12,679.68 23,931.00 (11,251.32) 73,292.35 105,558.00 (32,265.65) 176,413.00 108,636.49 38%COS % 62.6% 53.1% -9.5% 58.6% 53.1% -5.5% 53.1% 46.9% 12%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 480.00 480.00 - 3,540.00 3,540.00 - 5,400.00 1,860.00 66%6101320 Insurance Group 2,511.84 3,150.00 (638.16) 21,079.76 23,850.00 (2,770.24) 36,450.00 15,370.24 58%6101325 Insurance-Workers Comp 347.44 1,376.00 (1,028.56) 3,510.65 9,456.00 (5,945.35) 14,771.00 11,260.35 24%6101720 Salaries 6,045.46 6,082.00 (36.54) 47,849.61 47,131.00 718.61 71,459.00 23,609.39 67%6101800 Taxes-Employer Payroll 1,436.68 2,090.00 (653.32) 8,558.73 14,359.00 (5,800.27) 22,431.00 13,872.27 38%6101880 Wages-Hourly 5,490.22 10,704.00 (5,213.78) 49,153.16 68,208.00 (19,054.84) 108,712.00 59,558.84 45%6101882 Wages-Overtime 45.38 - 45.38 1,586.87 - 1,586.87 - 952.88 0%Total -PS-SALARIES & BENEFITS 16,357.02 23,882.00 (7,524.98) 135,278.78 166,544.00 (31,265.22) 259,223.00 126,483.97 51%61-PS OTHER EXPENSES6103762 Supplies-Office 205.32 200.00 5.32 3,640.84 2,350.00 1,290.84 2,950.00 (690.84) 123%6109090 Contract Services 610.00 500.00 110.00 4,110.00 4,000.00 110.00 6,000.00 1,890.00 69%6109220 Freight & Delivery 58.09 - 58.09 593.10 75.00 518.10 75.00 (518.10) 791%6109490 Miscellaneous - 50.00 (50.00) 369.68 250.00 119.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 17.63 - 17.63 151.63 - 151.63 (151.63) 0%6109722 Seminars/Training 75.00 35.00 40.00 2,390.00 4,135.00 (1,745.00) 5,490.00 3,100.00 44%6109810 Travel - Merchandise - 15.00 (15.00) - 30.00 (30.00) 90.00 90.00 0%6109820 Uniforms - 200.00 (200.00) 1,348.00 1,600.00 (252.00) 2,400.00 1,052.00 56%6117840 Telephones 132.70 70.00 62.70 1,428.92 560.00 868.92 840.00 (588.92) 0%Total PS-OTHER EXPENSES 1,098.74 1,070.00 28.74 14,299.40 13,000.00 1,299.40 20,295.00 5,995.60 70%Total Expenses17,455.76 24,952.00 (7,496.24) 149,578.18 179,544.00 (29,965.82) 279,518.00 132,479.57 53%Net Income(4,776.08) (1,021.00) (3,755.08) (76,285.83) (73,986.00) (2,299.83) (103,105.00) (23,843.08) -77%Month to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementFebruary 20093 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 1,920.00 1,920.00 - 2,880.00 960.00 33.3%6311320 Insurance-Group 9,081.41 12,083.00 (3,001.59) 87,597.39 96,664.00 (9,066.61) 144,996.00 57,398.61 39.6%6311325 Insurance-Workers Comp 1,496.94 4,841.00 (3,344.06) 16,502.09 39,492.00 (22,989.91) 59,020.00 42,517.91 72.0%6311720 Salaries 11,001.60 12,331.00 (1,329.40) 91,123.20 98,648.00 (7,524.80) 147,978.00 56,854.80 38.4%6311800 Taxes-Employer Payroll 5,713.18 7,350.00 (1,636.82) 44,635.25 60,539.00 (15,903.75) 90,311.00 45,675.75 50.6%6311880 Wages-Hourly 38,762.98 46,708.00 (7,945.02) 361,830.25 373,664.00 (11,833.75) 560,520.00 198,689.75 35.4%6311882 Wages-Overtime 133.27 - 133.27 23,072.45 13,966.00 9,106.45 16,894.00 (6,178.45) -36.6%Total-CM-SALARIES & BENEFITS66,429.38 83,553.00 (17,123.62) 626,680.63 684,893.00 (58,212.37) 1,022,599.00 395,918.37 38.7%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 2,220.19 2,000.00 220.19 27,436.36 18,800.00 8,636.36 25,200.00 (2,236.36) -8.9%6313744 Fertilizer 12,457.20 8,000.00 4,457.20 85,257.39 75,200.00 10,057.39 95,200.00 9,942.61 10.4%6313746 Flowers/Plants - 100.00 (100.00) 1,800.52 3,300.00 (1,499.48) 3,500.00 1,699.48 48.6%6313748 Fuel-Gasoline 2,966.52 3,190.00 (223.48) 29,549.79 32,010.00 (2,460.21) 45,540.00 15,990.21 35.1%6313750 Golf Course Accessories 422.13 100.00 322.13 9,581.60 6,600.00 2,981.60 7,000.00 (2,581.60) -36.9%6313756 POA Control - - - 6,965.13 6,000.00 965.13 6,000.00 (965.13) -16.1%6313758 Miscellaneous Supp 469.47 100.00 369.47 4,172.95 800.00 3,372.95 - (4,172.95) 0.0%6313762 Supplies-Office 138.51 - 138.51 571.40 - 571.40 1,200.00 628.60 52.4%6313774 Sand - 100.00 (100.00) 5,696.11 6,260.00 (563.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,410.00 9,409.49 101,810.00 (8,009.49) -7.9%6313778 Small Tools & Non-Capital Equip - 100.00 (100.00) 4,638.80 6,600.00 (1,961.20) 7,000.00 2,361.20 33.7%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 & MATERIALS18,674.02 14,040.00 4,634.02 299,388.04 270,230.00 29,158.04 317,460.00 18,071.96 5.7%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,217.87 1,500.00 717.87 12,701.22 10,000.00 2,701.22 16,000.00 3,298.78 20.6%6315685 CM-R&M-Bldngs & Othr Structures 87.50 250.00 (162.50) 1,251.00 500.00 751.00 500.00 (751.00) -150.2%6315690 CM-R&M-Equipment 3,304.14 2,500.00 804.14 37,553.38 38,700.00 (1,146.62) 46,100.00 8,546.62 18.5%6315692 CM-R&M-Irrigation System 1,717.94 1,000.00 717.94 12,751.91 11,450.00 1,301.91 15,450.00 2,698.09 17.5%6315696 CM-R&M-Pumps 1,135.00 1,000.00 135.00 6,362.44 8,000.00 (1,637.56) 10,500.00 4,137.56 39.4%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 8,462.45 6,250.00 2,212.45 74,674.59 71,650.00 3,024.59 97,550.00 22,875.41 23.4%63-CM-UTILTIES6317830 Utilities-Electricity-Bldngs 5.38 - 5.38 43.04 - 43.04 - (43.04) 0.0%6317836 Utilities-Natural Gas/LPG - 150.00 (150.00) - 1,200.00 (1,200.00) 1,800.00 1,800.00 0.0%6317840 Telephones 878.49 800.00 78.49 6,817.09 6,400.00 417.09 9,600.00 2,782.91 29.0%Total-CM-UTILITIES 883.87 950.00 (66.13) 6,860.13 7,600.00 (739.87) 11,400.00 4,539.87 39.8%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 4,000.00 4,000.00 - 6,000.00 2,000.00 33.3%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 4,055.26 - 4,055.26 - (4,055.26) 0.0%6319150 Dues & Subscriptions - 200.00 (200.00) 455.00 600.00 (145.00) 900.00 445.00 49.4%6319170 Employee Education 560.00 50.00 510.00 560.00 400.00 160.00 600.00 40.00 6.7%6319197 Equipment Rental - 200.00 (200.00) 2,946.41 3,500.00 (553.59) 4,200.00 1,253.59 29.8%6319206 Licenses & Permits - 1,000.00 (1,000.00) 60.00 1,200.00 (1,140.00) 1,600.00 1,540.00 96.3%6319490 Miscellaneous 475.83 100.00 375.83 618.85 800.00 (181.15) 1,200.00 581.15 48.4%6319718 Safety Equipment & Training 121.54 200.00 (78.46) 2,165.99 2,900.00 (734.01) 3,400.00 1,234.01 36.3%6319822 Uniforms 1,087.19 820.00 267.19 6,129.72 6,560.00 (430.28) 9,840.00 3,710.28 37.7%Total-CM-OTHER EXPENSES 3,268.61 3,070.00 198.61 22,491.23 21,960.00 531.23 31,740.00 9,248.77 29.1%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementFebruary 2009Annual Budget4 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,253.00 1,104.00 149.00 9,978.50 8,832.00 1,146.50 13,248.00 3,269.50 24.7%6321325 Insurance-Workers Comp 287.57 1,078.00 (790.43) 3,364.03 8,896.00 (5,531.97) 13,257.00 9,892.97 74.6%6321800 Taxes-Employer Payroll 1,221.45 1,636.00 (414.55) 9,379.96 13,711.00 (4,331.04) 20,368.00 10,988.04 53.9%6321880 Wages-Hourly 9,585.39 13,141.00 (3,555.61) 99,714.81 105,128.00 (5,413.19) 157,692.00 57,977.19 36.8%6321882 Wages-Overtime 7.13 - 7.13 5,092.68 5,005.00 87.68 5,915.00 822.32 13.9%Total-CM-LM-SALARIES & BENEFITS12,354.54 16,959.00 (4,604.46) 127,529.98 141,572.00 (14,042.02) 210,480.00 82,950.02 39.4%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 367.79 725.00 (357.21) 1,025.00 657.21 64.1%6323788 Uniforms 309.27 290.00 19.27 2,464.43 2,320.00 144.43 3,480.00 1,015.57 29.2%Total-CM-LM-SUPPLIES & MATERIALS309.27 365.00 (55.73) 2,832.22 3,045.00 (212.78) 4,505.00 1,672.78 37.1%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 250.00 (250.00) 1,826.70 3,000.00 (1,173.30) 4,250.00 2,423.30 57.0%Total-CM-LM-REPAIRS & MAINTENANCE - 250.00 (250.00) 1,826.70 3,000.00 (1,173.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) 36,110.76 56,000.00 (19,889.24) 84,000.00 47,889.24 57.0%6337842 Utilities-Water1,938.60 1,427.00 511.60 23,018.97 15,390.00 7,628.97 21,871.00 (1,147.97) -5.2%Total-CM-WATER & ENERGY6,101.63 8,427.00 (2,325.37) 59,129.73 71,390.00 (12,260.27) 105,871.00 46,741.27 44.1%116,483.77 133,864.00 (17,380.23) 1,221,413.25 1,275,340.00 (53,926.75) 1,805,855.00 584,441.75 32.4%Total -COURSE MAINTENANCEMonth to Date Year to DateSilverrock ResortCourse Maintenance Expense StatementFebruary 2009Annual Budget5 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 600.00 600.00 - 4,020.00 4,020.00 - 6,180.00 2,160.00 35.0%6411320 Insurance-Group 63.25 720.00 (656.75) 575.45 5,760.00 (5,184.55) 8,640.00 8,064.55 93.3%6411325 Insurance-Workers Comp 361.04 1,682.00 (1,320.96) 2,485.91 10,333.00 (7,847.09) 16,511.00 14,025.09 84.9%6411800 Taxes-Employer Payroll 1,569.79 1,459.00 110.79 8,890.73 8,962.00 (71.27) 14,318.00 5,427.27 37.9%6411880 Wages-Hourly 12,015.64 11,715.00 300.64 74,732.48 71,970.00 2,762.48 114,990.00 40,257.52 35.0%6411882 Wages-Overtime 18.94 - 18.94 849.17 - 849.17 - (849.17) 0.0%Total-CBR-SALARIES & BENEFITS14,628.66 16,176.00 (1,547.34) 91,553.74 101,045.00 (9,491.26) 160,639.00 69,085.26 43.0%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 19.35 75.00 (55.65) 866.97 2,150.00 (1,283.03) 2,350.00 1,483.03 63.1%6413742 Supplies-Expendable 349.80 1,000.00 (650.20) 4,079.05 4,550.00 (470.95) 5,850.00 1,770.95 30.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) - 325.00 (325.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary - 70.00 (70.00) - 140.00 (140.00) 420.00 420.00 100.0%6413786 Supplies-Towels - 72.00 (72.00) 3,974.08 2,004.00 1,970.08 2,292.00 (1,682.08) -73.4%6413796 Supplies-Bottled Water1,179.85 2,600.00 (1,420.15) 11,162.07 13,850.00 (2,687.93) 23,950.00 12,787.93 53.4%Total-CBR-SUPPLIES & MATERIALS1,549.00 3,867.00 (2,318.00) 25,902.17 29,019.00 (3,116.83) 41,387.00 15,484.83 37.4%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts 720.00 720.00 - 5,835.00 5,760.00 75.00 8,640.00 2,805.00 32.5%6415690 CBR-R&M-Equipment 375.64 125.00 250.64 669.67 1,000.00 (330.33) 1,500.00 830.33 55.4%6415695 CBR-R&M-Cart Maintenance & Repair 234.46 250.00 (15.54) 3,579.19 3,000.00 579.19 4,000.00 420.81 10.5%Total-CBR-REPAIRS & MAINTENANCE 1,330.10 1,095.00 235.10 10,083.86 9,760.00 323.86 14,140.00 4,056.14 28.7%641-CBR-OTHER EXPENSES6419093 Contract Services-Handicaps 1,860.00 500.00 1,360.00 5,605.00 3,850.00 1,755.00 5,000.00 (605.00) -12.1%6419094 Contract Services-Laundry/Linen 442.56 500.00 (57.44) 2,726.09 4,000.00 (1,273.91) 6,000.00 3,273.91 54.6%6419220 Freight/Delivery - 75.00 (75.00) 7.56 600.00 (592.44) 900.00 892.44 99.2%6419490 Miscellaneous - 75.00 (75.00) 506.01 650.00 (143.99) 1,150.00 643.99 56.0%6419820 Uniforms - - - 1,665.22 3,000.00 (1,334.78) 5,625.00 3,959.78 70.4%Total-CBR-OTHER EXPENSES 2,302.56 1,150.00 1,152.56 10,509.88 12,100.00 (1,590.12) 18,675.00 8,165.12 43.7%TOTAL-CARTS,BAGROOM & RANGE 19,810.32 22,288.00 (2,477.68) 138,049.65 151,924.00 (13,874.35) 234,841.00 96,791.35 41.2%643-CS-SALARIES & BENEFITS6431175 Employee Meals 540.00 540.00 - 3,120.00 3,120.00 - 4,860.00 1,740.00 35.8%6431325 Insurance-Workers Comp 138.99 400.00 (261.01) 872.46 2,046.00 (1,173.54) 3,446.00 2,573.54 74.7%6431800 Taxes-Employer Payroll 595.35 608.00 (12.65) 3,307.51 3,108.00 199.51 5,220.00 1,912.49 36.6%6431880 Wages-Hourly 4,630.00 4,880.00 (250.00) 27,388.00 24,960.00 2,428.00 41,920.00 14,532.00 34.7%6431882 Wages-Overtime 3.00 - 3.00 51.00 - 51.00 - (51.00) 0.0%Total-CS-SALARIES & BENEFITS5,907.34 6,428.00 (520.66) 34,738.97 33,234.00 1,504.97 55,446.00 20,707.03 37.3%643-CS-OTHER EXPENSES6433742 Supplies Expendable 481.58 100.00 381.58 4,186.80 700.00 3,486.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 400.00 (356.90) 600.00 556.90 92.8%6439820 Uniforms - 75.00 (75.00) 2,325.25 1,275.00 1,050.25 1,900.00 (425.25) -22.4%Total-CS-OTHER EXPENSES 481.58 225.00 256.58 6,845.70 2,575.00 4,270.70 3,750.00 (3,095.70) -82.6%Total-COURSE SERVICES 6,388.92 6,653.00 (264.08) 41,584.67 35,809.00 5,775.67 59,196.00 17,611.33 29.8%TOTAL OUTSIDE SERVICES 26,199.24 28,941.00 (2,741.76) 179,634.32 187,733.00 (8,098.68) 294,037.00 117,498.38 40.0%Month to Date Year to DateSilverRock ResortOutside Services Expense StatementFebruary 2009Annual Budget6 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 383.64 3,200.00 (2,816.36) 4,800.00 4,416.36 92.0%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 383.64 3,200.00 (2,816.36) 4,800.00 4,416.36 92.0%65-CH-UTILITIES6507836 Utilities-Natural Gas584.01 300.00 284.01 3,044.44 2,400.00 644.44 3,600.00 555.56 15.4%6507838 Utilities-Sewer- 200.00 (200.00) 600.00 1,600.00 (1,000.00) 2,400.00 1,800.00 75.0%6507840 Utilities-Telephone1,075.21 1,000.00 75.21 8,510.41 8,000.00 510.41 12,000.00 3,489.59 29.1%6507842 Utilities-Water286.86 200.00 86.86 2,646.68 1,600.00 1,046.68 2,400.00 (246.68) -10.3%6507844 Utilities-Cable333.04 317.00 16.04 2,415.10 2,536.00 (120.90) 3,804.00 1,388.90 36.5%Total-CH-UTILITIES 2,279.12 2,017.00 262.12 17,216.63 16,136.00 1,080.63 24,204.00 6,987.37 28.9%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,908.70 1,825.00 83.70 15,088.70 15,200.00 (111.30) 22,500.00 7,411.30 32.9%6509098 Contract Services-Refuse Dispose311.74 - 311.74 2,805.66 - 2,805.66 - (2,805.66) 0.0%6509099 Contract Services-Security8,140.08 8,200.00 (59.92) 66,729.04 65,600.00 1,129.04 98,400.00 31,670.96 32.2%6509215 Flowers & Decorations- 100.00 (100.00) - 2,200.00 (2,200.00) 2,600.00 2,600.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 193.93 1,600.00 (1,406.07) 2,400.00 2,206.07 91.9%6509718 Safety Equipment & Training108.62 100.00 8.62 108.62 800.00 (691.38) 1,200.00 1,091.38 90.9%Total-CH-OTHER EXPENSES 10,469.14 10,425.00 44.14 84,925.95 85,400.00 (474.05) 127,100.00 42,174.05 33.2%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures272.00 200.00 72.00 2,843.00 1,600.00 1,243.00 2,400.00 (443.00) -18.5%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 2,019.10 3,200.00 (1,180.90) 4,800.00 2,780.90 57.9%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) - 3,200.00 (3,200.00) 4,800.00 4,800.00 100.0%Total-CH-REPAIRS & MAINTENANCE 272.00 1,000.00 (728.00) 4,862.10 8,000.00 (3,137.90) 12,000.00 7,137.90 59.5%Total CLUBHOUSE 13,020.26 13,842.00 (821.74) 107,388.32 112,736.00 (5,347.68) 168,104.00 14,275.80 8.5%Month to Date Year to DateSilverRock ResortClubhouse Expense StatementFebruary 2009Annual Budget7 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 480.00 480.00 - 720.00 240.00 33.3%6601320 Insurance-Group 283.81 450.00 (166.19) 1,941.80 3,600.00 (1,658.20) 5,400.00 3,458.20 64.0%6601325 Insurance-Workers Comp 75.00 205.00 (130.00) 687.78 1,640.00 (952.22) 2,460.00 1,772.22 72.0%6601720 Salaries 2,500.00 2,500.00 - 21,250.00 20,000.00 1,250.00 30,000.00 8,750.00 29.2%6601800 Taxes-Employer Payroll 311.00 311.00 - 2,954.50 2,488.00 466.50 3,732.00 777.50 20.8%Total-MKT-SALARIES & BENEFITS 3,229.81 3,526.00 (296.19) 27,314.08 28,208.00 (893.92) 42,312.00 14,997.92 35.4%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) - 800.00 (800.00) 1,200.00 1,200.00 100.0%6603768 Supplies-Printing & Stationery - 125.00 (125.00) 2,755.74 3,925.00 (1,169.26) 4,425.00 1,669.26 37.7%- 225.00 (225.00) 2,755.74 4,725.00 (1,969.26) 5,625.00 2,869.26 51.0%66-MKT-UTILITIES6607840 Utilities-Telephone 48.30 100.00 (51.70) 432.48 800.00 (367.52) 1,200.00 767.52 64.0%Total-MKT-UTILITIES 48.30 100.00 (51.70) 432.48 800.00 (367.52) 1,200.00 767.52 64.0%66-MKT-OTHER EXPENSES6609010 Advertising 23,723.82 29,977.00 (6,253.18) 160,423.85 157,476.00 2,947.85 225,134.00 64,710.15 28.7%6609040 Business Meals - 25.00 (25.00) - 200.00 (200.00) 300.00 300.00 100.0%6609080 Collateral Material - 500.00 (500.00) 2,704.05 6,500.00 (3,795.95) 9,000.00 6,295.95 70.0%6609102 Contract Services-Web Page 99.00 175.00 (76.00) 1,188.00 1,400.00 (212.00) 2,100.00 912.00 43.4%6609490 Miscellaneous - 50.00 (50.00) - 200.00 (200.00) 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) 1.59 400.00 (398.41) 600.00 598.41 99.7%6609630 Promotion - 500.00 (500.00) 2,166.57 6,500.00 (4,333.43) 6,500.00 4,333.43 0.0%6609633 Promotion-Community - 75.00 (75.00) 197.27 2,625.00 (2,427.73) 2,925.00 2,727.73 93.3%6609634 Promotion-Media/Vendor - 50.00 (50.00) - 500.00 (500.00) 700.00 - 0.0%6609150 Dues and Subscriptions - 400.00 (400.00) 371.71 435.00 (63.29) 735.00 363.29 49.4%6609820 Uniforms - 50.00 (50.00) 38.41 500.00 (461.59) 600.00 561.59 93.6%Total-MKT-OTHER EXPENSES 23,822.82 31,852.00 (8,029.18) 167,091.45 176,736.00 (9,644.55) 248,944.00 81,152.55 32.6%Total-MARKETING 27,100.93 35,703.00 (8,602.07) 197,593.75 210,469.00 (12,875.25) 298,081.00 99,787.25 33.5%Month to Date Year to DateSilverRock ResortMarketing Expense StatementFebruary 2009Annual Budget8 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 1,440.00 1,440.00 - 2,160.00 720.00 33.3%6701320 Insurance-Group1,170.84 2,250.00 (1,079.16) 10,910.29 18,000.00 (7,089.71) 27,000.00 16,089.71 59.6%6701325 Insurance-Workers Comp497.63 1,406.00 (908.37) 4,514.87 11,248.00 (6,733.13) 16,872.00 12,357.13 73.2%6701720 Salaries 14,453.97 14,416.00 37.97 116,959.25 115,328.00 1,631.25 172,992.00 56,032.75 32.4%6701800 Taxes-Employer Payroll 1,311.72 2,135.00 (823.28) 11,212.00 17,080.00 (5,868.00) 25,620.00 14,408.00 56.2%6701880 Wages-Hourly2,133.70 2,730.00 (596.30) 18,579.68 21,840.00 (3,260.32) 32,760.00 14,180.32 43.3%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 19,747.86 23,117.00 (3,369.14) 163,616.09 184,936.00 (21,319.91) 277,404.00 113,787.91 41.0%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 800.00 (800.00) 2,284.25 7,600.00 (5,315.75) 10,800.00 8,515.75 78.8%6703762 Supplies-Office 304.47 125.00 179.47 2,066.25 1,000.00 1,066.25 1,500.00 (566.25) -37.8%6703768 Supplies-Printing & Stationery- 400.00 (400.00) 911.61 1,600.00 (688.39) 3,200.00 2,288.39 71.5%6703778Supplies-Small Tools/Non-Capital 5.39 100.00 (94.61) 5.39 600.00 (594.61) 900.00 894.61 99.4%Total-G&A-SUPPLIES & MATERIALS 309.86 1,425.00 (1,115.14) 5,267.50 10,800.00 (5,532.50) 16,400.00 11,132.50 67.9%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 502.21 800.00 (297.79) 1,200.00 697.79 58.1%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 502.21 800.00 (297.79) 1,200.00 697.79 58.1%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 3,200.00 3,200.00 - 4,800.00 1,600.00 33.3%6709150 Dues & Subscriptions112.50 150.00 (37.50) 384.21 850.00 (465.79) 1,500.00 1,115.79 74.4%6709180 Employee Recruiting/Relocation140.00 200.00 (60.00) 697.00 4,400.00 (3,703.00) 4,600.00 3,903.00 84.8%6709197 Equipment Rental521.80 350.00 171.80 3,512.58 2,800.00 712.58 4,200.00 687.42 16.4%6709202 Fees-Bank20.00 90.00 (70.00) 289.75 720.00 (430.25) 1,080.00 790.25 73.2%6709208 Fees-Payroll Processing681.34 550.00 131.34 6,422.72 4,400.00 2,022.72 6,600.00 177.28 2.7%6709220 Freight/Delivery- 50.00 (50.00) - 400.00 (400.00) 600.00 600.00 100.0%6709490 Miscellaneous 27.45 100.00 (72.55) 442.45 800.00 (357.55) 1,200.00 757.55 63.1%6709491 Loss/Damage- - - 204.96 - 204.96 - 0.0%6709620 Postage/Mail Services - 75.00 (75.00) 992.29 600.00 392.29 900.00 (92.29) -10.3%6709625 Professional Fees745.00 400.00 345.00 3,350.16 3,200.00 150.16 4,800.00 1,449.84 30.2%6709636 Promotion/Entertainment- 100.00 (100.00) 2,705.92 3,600.00 (894.08) 4,000.00 1,294.08 32.4%6709722 Seminars & Training624.45 200.00 424.45 1,124.45 1,600.00 (475.55) 2,400.00 1,275.55 53.1%6709810 Travel 240.40 100.00 140.40 240.40 200.00 40.40 1,100.00 859.60 78.1%6709820 Uniforms - 75.00 (75.00) 437.95 750.00 (312.05) 1,050.00 612.05 58.3%Total-G&A-OTHER EXPENSES 3,512.94 2,840.00 672.94 24,004.84 27,520.00 (3,515.16) 38,830.00 15,030.12 38.7%Total-GENERAL & ADMINISTRATIVE23,570.66 27,482.00 (3,911.34) 193,390.64 224,056.00 (30,665.36) 333,834.00 140,648.32 42.1%Month to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementFebruary 2009Annual Budget9 February Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,581.04 11,581.00 0.04 89,104.23 92,648.00 (3,543.77) 138,972.00 49,867.77 35.9%6800193 Equipment Leases-Course Maint 16,244.12 20,000.00 (3,755.88) 130,547.25 160,000.00 (29,452.75) 240,000.00 109,452.75 45.6%6800194 Equipment Leases-Trailer 540.00 600.00 (60.00) 4,818.94 4,800.00 18.94 7,200.00 2,381.06 33.1%6800195 Equipment Leases-Software 1,791.93 1,525.00 266.93 14,335.44 12,200.00 2,135.44 18,300.00 3,964.56 21.7%6800196 Equipment Leases-GPS 6,840.14 7,400.00 (559.86) 54,721.12 59,200.00 (4,478.88) 88,800.00 34,078.88 38.4%6800197 Equipment Leases-Others 2,280.56 - 2,280.56 29,606.54 - 29,606.54 - - 0.0%Total-LEASES 39,277.79 41,106.00 (1,828.21) 323,133.52 328,848.00 (5,714.48) 493,272.00 199,745.02 40.5%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 2,336.41 (4,625.00) 6,961.41 85,377.50 72,900.00 12,477.50 90,000.00 4,622.50 5.1%6900210 FF&E Reserve 9,223.07 11,524.00 (2,300.93) 34,033.87 41,931.00 (7,897.13) 75,140.00 41,106.13 54.7%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) 18,501.96 28,000.00 (9,498.04) 42,000.00 23,498.04 55.9%Total-MISC OTHER EXPENSES14,680.03 10,399.00 4,281.03 158,725.46 162,831.00 (4,105.54) 227,140.00 68,414.54 30.1%Annual BudgetMonth to Date Year to Date Operating Leases & Miscellaneous Other Expense StatementFebruary 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 CategoryJanuaryFebruaryMarchAprilMayJuneMedia Sales11Promotion8Golf Industry95VIPCelebrityPGA Comp48 63Charity/Gift Certificate715Rain/Wind Checks10 3Club Staff53 70LQ HS Golf127175000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2008-2009February 2009 Date Time Description CategoryPlayers2/1/2009 7:30 Paul Schulte (2guyswhogolf.com)Promotion 42/1/2009 12:45 Paul Schulte (2guyswhogolf.com)Promotion 42/6/2009 8:45 Kris Long (CBS2)Sales 12/6/2009 11:30 Gino Lamont (KMIR)Sales 22/21/2009 11:45John White (KESQ)Sales42/28/2009 12:15Kris Long (CBS2)Sales112