Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
10 April 2011 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2010 – April 2011 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 Revenue491,246.50 432,266.00 58,980.50 13.6% 2,720,031.23 2,685,519.00 34,512.23 3,111,458.00 391,426.77 87%401000 Miscellaneous Golf Revenue 29,979.19 10,924.00 19,055.19 174.4% 145,536.32 107,015.00 38,521.32 117,656.00 (27,880.32) 124%410000 Revenue-Golf Shop 49,054.05 37,011.00 12,043.05 32.5% 278,959.05 262,567.00 16,392.05 306,492.00 27,532.95 91%420000 Revenue-F&B Concession500.00 500.00 - 0.0% 11,000.00 11,000.00 - 12,000.00 1,000.00 92%890000 Interest Income4.34 - 4.34 0.0% 46.74 - 46.74 - (46.74) 0%Total Income570,784.08 480,701.00 90,083.08 18.7% 3,155,573.34 3,066,101.00 89,472.34 3,547,606.00 392,032.66 89%Cost of Goods Sold510000 COS-Golf Shop 27,329.38 19,643.05 7,686.33 -39.1% 153,752.09 139,354.85 (14,397.24) 162,670.60 8,918.51 95%Total COS27,329.38 19,643.05 7,686.33 -39.1% 153,752.09 139,354.85 (14,397.24) 162,670.60 8,918.51 95%Gross Profit543,454.70 461,057.95 82,396.75 17.9% 3,001,821.25 2,926,746.15 75,075.10 3,384,935.40 383,114.15 89%Expenses610000 Golf Pro Shop 20,595.30 19,469.00 (1,126.30) -5.8% 172,923.77 188,986.00 16,062.23 230,213.00 57,289.23 75%630000 Course Maintenance123,478.06 113,229.00 (10,249.06) -9.1% 1,311,125.25 1,319,301.00 8,175.75 1,541,961.00 230,835.75 85%633000 Maintenance Water & Energy5,956.35 5,550.00 (406.35) -7.3% 65,992.66 69,593.00 3,600.34 85,358.00 19,365.34 77%640000 Outside Services33,569.07 25,947.00 (7,622.07) -29.4% 244,745.35 248,720.00 3,974.65 297,478.00 52,732.65 82%650000 Clubhouse 9,214.42 10,636.00 1,421.58 13.4% 110,239.76 110,560.00 320.24 132,232.00 21,992.24 83%660000 Marketing 19,604.64 21,016.00 1,411.36 6.7% 212,494.12 239,205.00 26,710.88 262,644.00 50,149.88 81%670000 General & Administrative28,174.16 26,064.00 (2,110.16) -8.1% 250,165.90 261,540.00 11,374.10 314,808.00 64,642.10 79%680000 Leases 17,526.86 20,000.00 2,473.14 12.4% 180,318.43 207,740.00 27,421.57 247,740.00 67,421.57 73%690000 Miscellaneous Other Expense6,541.43 8,211.00 1,669.57 20.3% 146,515.76 155,528.00 9,012.24 192,199.00 45,683.24 76%Total Expenses264,660.29 250,122.00 (14,538.29) -5.8% 2,694,521.00 2,801,173.00 106,652.00 3,304,633.00 610,112.00 82%278,794.41 210,935.95 67,858.46 32.2%307,300.25 125,573.15 181,727.10 80,302.40 (226,997.85) 383%Rounds of Golf PlayedPaid Rounds Played 5,801 5,100 701 13.7% 37,132 35,630 1,502 39,150 2,018 95%Ave $ Per Paid Round Green Fee84.68 84.76 (0.07) -0.1% 73.25 75.37 (2.12) 76.13 2.88 96%Ave $ Per Paid Round Merchandise8.46 7.26 1.20 16.5% 7.51 7.37 0.14 8.07 0.56 93%Ave $ Per Paid Miscellaneous 5.17 2.14 3.03 141.3% 3.92 3.00 0.92 2.06 - 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateApril 20111 Income April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 491,246.50 432,266.00 58,980.50 2,720,031.23 2,685,519.00 34,512.23 3,111,458.00391,426.7787%4010000 Rider Fee 1,300.00 511.00 789.00 8,925.00 5,878.00 3,047.00 6,522.00-2,403.00137%4040000 Club Rental 4,050.00 2,808.00 1,242.00 21,090.00 24,457.00 (3,367.00) 28,004.006,914.0075%4050000 Driving Range 10,507.00 5,105.00 5,402.00 69,161.00 41,680.00 27,481.00 48,130.00-21,031.00144%4060000 Handicap Fees 3,040.00 - 3,040.00 3,040.00 - 3,040.00 0.000.000%4080000 GPS Advertising - - - - 12,000.00 (12,000.00) 12,000.00 12,000.000%4090000 Ball Retriever/Subcontract 1,558.44 1,000.00 558.44 3,633.82 4,000.00 (366.18) 4,000.00 366.1891%4091000 Golf Professional Rental Fee 9,324.75 1,500.00 7,824.75 38,909.75 19,000.00 19,909.75 19,000.00 -19,909.75 205%4092000 Golf Lessons 199.00 - 199.00 776.75 - 776.75 - (776.75) 0% Total Revenue Fees 521,225.69 443,190.00 78,035.69 2,865,567.55 2,792,534.00 73,033.55 3,229,114.00 366,586.45 89%521,225.69 443,190.00 78,035.69 2,865,567.55 2,792,534.00 73,033.55 3,229,114.00 366,586.45 89%SilverRock ResortStatement of Fees RevenueApril 2011Total IncomeMonth to Date Year to Date Annual Budget2 Income April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 1,259.18 - 1,259.18 4,979.73 - 4,979.73 0 0 0%4100110 Sales Hard Goods 15,694.82 12,954.00 2,740.82 88,265.79 91,899.00 (3,633.21) 107,272.00 19,006.21 82%4100112 Sales-Soft Goods 39,482.97 24,057.00 15,425.97 224,775.29 170,668.00 54,107.29 199,220.00 (25,555.29) 113%5100639 GS-Discounts-Mdse (7,382.92) - (7,382.92) (39,061.76) - (39,061.76) - 39,061.76 0% Total Revenue Golf Shop 49,054.05 37,011.00 12,043.05 278,959.05 262,567.00 16,392.05 306,492.00 32,512.68 89%COS 5100150 COS-GS-Hard Goods 9,195.89 7,124.70 2,071.19 45,201.20 50,544.45 (5,343.25) 58,999.60 13,798.40 77%5100151 COS-GS-Soft Goods 17,822.65 13,231.35 4,591.30 104,464.19 93,867.40 10,596.79 109,571.00 5,106.81 95%5100152 COS-GS-Purchase Disc (141.98) (1,018.00) 876.02 (2,019.75) (7,221.00) 5,201.25 (8,429.00) (6,409.25) -24%5100220 COS-GS-Freight Merch 452.82 305.00 147.82 6,106.45 2,164.00 3,942.45 2,529.00 (3,577.45) 241%Cost of Sales - Golf Shop 27,329.38 19,643.05 7,686.33 153,752.09 139,354.85 14,397.24 162,670.60 8,918.51 95%Gross Profit 21,724.67 17,367.95 4,356.72 125,206.96 123,212.15 1,994.81 143,821.40 23,594.17 84%COS % 55.7% 53.1% -2.6% 55.1% 53.1% -2.0% 53.1% 27.4% 48%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 2,872.44 2,317.00 555.44 24,084.94 22,177.00 1,907.94 26,811.00 2,726.06 90%6101325 Insurance-Workers Comp 445.78 539.00 (93.22) 4,024.15 5,094.00 (1,069.85) 6,131.00 2,106.85 66%6101720 Salaries 3,900.01 3,750.00 150.01 37,589.45 37,500.00 89.45 45,000.00 7,410.55 84%6101800 Taxes-Employer Payroll 1,491.97 1,630.00 (138.03) 12,012.29 15,393.00 (3,380.71) 18,528.00 6,515.71 65%6101880 Wages-Hourly 9,906.79 9,343.00 563.79 75,844.84 86,132.00 (10,287.16) 103,818.00 27,973.16 73%6101882 Wages-Overtime 123.94 - 123.94 1,555.55 - 1,555.55 - 952.88 0%Total -PS-SALARIES & BENEFITS 19,220.93 18,059.00 1,161.93 159,611.22 170,796.00 (11,184.78) 205,688.00 48,585.21 76%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - 189.74 - 189.74 - (189.74) 0%6103762 Supplies-Office 475.52 500.00 (24.48) 2,978.14 5,000.00 (2,021.86) 6,000.00 3,021.86 50%6109090 Contract Services 500.00 500.00 - 5,000.00 5,000.00 - 6,000.00 1,000.00 83%6109220 Freight & Delivery - - - 689.19 75.00 614.19 75.00 (614.19) 919%6109490 Miscellaneous 47.48 50.00 (2.52) 314.60 350.00 (35.40) 450.00 135.40 70%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short 9.53 - 9.53 1.09 - 1.09 - (1.09) 0%6109722 Seminars/Training - 35.00 (35.00) 545.07 4,605.00 (4,059.93) 5,890.00 5,344.93 9%6109810 Travel - Merchandise - 15.00 (15.00) - 60.00 (60.00) 90.00 90.00 0%6109820 Uniforms 124.38 200.00 (75.62) 2,279.23 2,000.00 279.23 2,400.00 120.77 95%6117840 Telephones 217.46 110.00 107.46 1,315.49 1,100.00 215.49 1,320.00 4.51 0%Total PS-OTHER EXPENSES 1,374.37 1,410.00 (35.63) 13,312.55 18,190.00 (4,877.45) 24,525.00 11,212.45 54%20,595.30 19,469.00 1,126.30 172,923.77 188,986.00 (16,062.23) 230,213.00 59,797.66 74%Net Income1,129.37 (2,101.05) 3,230.42 (47,716.81) (65,773.85) 18,057.04 (86,391.60) (36,203.49) -58%SilverRock ResortGolf Shop Income StatementApril 2011Total Expenses-Golf ShopMonth to Date Year to Date Annual Budget3 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 9,169.74 8,740.00 429.74 85,281.06 87,400.00 (2,118.94) 104,880.00 19,598.94 18.7%6311325 Insurance-Workers Comp 1,449.50 2,238.00 (788.50) 20,117.91 23,085.00 (2,967.09) 27,638.00 7,520.09 27.2%6311720 Salaries 12,101.76 12,583.00 (481.24) 118,450.56 125,830.00 (7,379.44) 150,996.00 32,545.44 21.6%6311800 Taxes-Employer Payroll 5,832.08 6,762.00 (929.92) 56,727.50 70,293.00 (13,565.50) 84,168.00 27,440.50 32.6%6311880 Wages-Hourly 43,657.00 41,730.00 1,927.00 431,885.20 425,998.00 5,887.20 509,458.00 77,572.80 15.2%6311882 Wages-Overtime 21.19 - 21.19 21,354.08 12,792.00 8,562.08 15,598.00 (5,756.08) -36.9%Total-CM-SALARIES & BENEFITS72,471.27 72,293.00 178.27 736,216.31 747,798.00 (11,581.69) 895,618.00 159,401.69 17.8%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 1,940.42 2,000.00 (59.58) 31,197.44 26,400.00 4,797.44 29,300.00 (1,897.44) -6.5%6313744 Fertilizer 6,055.12 5,000.00 1,055.12 75,663.51 79,400.00 (3,736.49) 89,400.00 13,736.49 15.4%6313745 Herbicides - - - 12,221.59 12,000.00 221.59 12,000.00 (221.59) -1.8%6313746 Flowers/Plants - 100.00 (100.00) 1,253.89 3,050.00 (1,796.11) 3,050.00 1,796.11 58.9%6313748 Fuel-Gasoline 6,887.95 3,600.00 3,287.95 42,632.08 37,380.00 5,252.08 43,100.00 467.92 1.1%6313750 Golf Course Accessories 59.46 100.00 (40.54) 12,226.34 12,100.00 126.34 12,300.00 73.66 0.6%6313756 POA Control 239.62 - 239.62 8,905.76 7,000.00 1,905.76 7,000.00 (1,905.76) -27.2%6313758 Miscellaneous Supp 961.59 100.00 861.59 9,568.24 4,150.00 5,418.24 4,350.00 (5,218.24) 0.0%6313762 Supplies-Office 24.90 - 24.90 412.82 - 412.82 - (412.82) 0.0%6313774 Sand 289.06 100.00 189.06 5,552.07 11,260.00 (5,707.93) 11,460.00 5,907.93 51.6%6313776 Seed - 350.00 (350.00) 96,436.13 91,110.00 5,326.13 91,810.00 (4,626.13) -5.0%6313778 Small Tools & Non-Capital Equip - 100.00 (100.00) 4,388.88 4,800.00 (411.12) 5,000.00 611.12 12.2%6313780 Sod - - - 3,179.03 2,650.00 529.03 3,350.00 170.97 5.1%6313782 Topdressing - - - 7,717.59 5,000.00 2,717.59 7,600.00 (117.59) -1.5%Total-CM-SUPPLIES & MATERIALS16,458.12 11,450.00 5,008.12 311,355.37 296,300.00 15,055.37 319,720.00 8,364.63 2.6%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,575.00 2,940.00 (1,365.00) 17,101.24 19,757.00 (2,655.76) 24,610.00 7,508.76 30.5%6315685 CM-R&M-Bldngs & Othr Structures 132.50 - 132.50 1,708.19 1,250.00 458.19 1,750.00 41.81 2.4%6315690 CM-R&M-Equipment 2,057.02 1,500.00 557.02 26,100.00 17,500.00 8,600.00 20,500.00 (5,600.00) -27.3%6315692 CM-R&M-Irrigation System 1,144.23 1,000.00 144.23 12,846.81 14,050.00 (1,203.19) 16,050.00 3,203.19 20.0%6315696 CM-R&M-Pumps - 1,000.00 (1,000.00) 5,818.30 10,000.00 (4,181.70) 10,500.00 4,681.70 44.6%6315815 CM-R&M-Trees-Pruning Etc 3,952.75 4,000.00 (47.25) 9,402.16 10,050.00 (647.84) 10,050.00 647.84 6.4%Total-CM-REPAIRS & MAINTENANCE 8,861.50 10,440.00 (1,578.50) 72,976.70 72,607.00 369.70 83,460.00 10,483.30 12.6%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 65.76 15.00 50.76 260.90 150.00 110.90 180.00 (80.90) 0.0%6317840 Telephones 1,545.32 850.00 695.32 10,983.00 8,500.00 2,483.00 10,200.00 (783.00) -7.7%Total-CM-UTILITIES 1,611.08 865.00 746.08 11,243.90 8,650.00 2,593.90 10,380.00 (863.90) -8.3%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 606.25 525.00 81.25 4,630.30 5,250.00 (619.70) 6,288.00 1,657.70 0.0%6319150 Dues & Subscriptions - 200.00 (200.00) 555.00 440.00 115.00 540.00 (15.00) -2.8%6319170 Employee Education - 50.00 (50.00) 1,355.32 1,450.00 (94.68) 1,550.00 194.68 12.6%6319197 Equipment Rental 2,631.97 200.00 2,431.97 5,379.36 3,900.00 1,479.36 4,200.00 (1,179.36) -28.1%6319206 Licenses & Permits 1,995.00 150.00 1,845.00 2,348.03 1,430.00 918.03 1,430.00 (918.03) -64.2%6319490 Miscellaneous - 100.00 (100.00) 618.23 1,000.00 (381.77) 1,200.00 581.77 48.5%6319718 Safety Equipment & Training 283.67 100.00 183.67 3,162.42 3,650.00 (487.58) 3,850.00 687.58 17.9%6319822 Uniforms 777.70 820.00 (42.30) 10,508.91 8,200.00 2,308.91 9,840.00 (668.91) -6.8%Total-CM-OTHER EXPENSES 6,794.59 2,645.00 4,149.59 35,057.57 32,320.00 2,737.57 38,898.00 3,840.43 9.9%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementApril 2011Annual Budget4 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,317.00 2,317.00 - 20,894.06 23,170.00 (2,275.94) 27,804.00 6,909.94 24.9%6321325 Insurance-Workers Comp 566.87 445.00 121.87 3,771.90 4,574.00 (802.10) 5,487.00 1,715.10 31.3%6321800 Taxes-Employer Payroll 2,087.42 1,346.00 741.42 10,136.82 14,016.00 (3,879.18) 16,811.00 6,674.18 39.7%6321880 Wages-Hourly 10,367.92 10,813.00 (445.08) 100,733.00 108,130.00 (7,397.00) 129,756.00 29,023.00 22.4%6321882 Wages-Overtime - - - 4,077.34 4,461.00 (383.66) 5,272.00 1,194.66 22.7%Total-CM-LM-SALARIES & BENEFITS15,339.21 14,921.00 418.21 139,613.12 154,351.00 (14,737.88) 185,130.00 45,516.88 24.6%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 527.91 875.00 (347.09) 1,025.00 497.09 48.5%6323788 Uniforms 179.42 290.00 (110.58) 2,246.33 2,900.00 (653.67) 3,480.00 1,233.67 35.5%Total-CM-LM-SUPPLIES & MATERIALS179.42 365.00 (185.58) 2,774.24 3,775.00 (1,000.76) 4,505.00 1,730.76 38.4%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation 1,762.87 250.00 1,512.87 1,888.04 3,500.00 (1,611.96) 4,250.00 2,361.96 55.6%Total-CM-LM-REPAIRS & MAINTENANCE 1,762.87 250.00 1,512.87 1,888.04 3,500.00 (1,611.96) 4,250.00 2,361.96 55.6%123,478.06 113,229.00 10,249.06 1,311,125.25 1,319,301.00 (8,175.75) 1,541,961.00 230,835.75 15.0% April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 2,546.20 4,000.00 (1,453.80) 26,737.62 36,300.00 (9,562.38) 42,300.00 15,562.38 36.8%6337842 Utilities-Water3,410.15 1,550.00 1,860.15 39,255.04 33,293.00 5,962.04 43,058.00 3,802.96 8.8%5,956.35 5,550.00 406.35 65,992.66 69,593.00 (3,600.34) 85,358.00 19,365.34 22.7%Silverrock ResortCourse Maintenance Expense StatementApril 2011Annual BudgetMonth to Date Year to DateSilverrock ResortCourse Maintenance Water & EnergyApril 2011Total-COURSE MAINTENANCETotal-CM-WATER & ENERGYMonth to Date Year to Date Annual Budget5 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 720.00 720.00 - 6,000.00 6,000.00 - 6,960.00 960.00 13.8%6411320 Insurance-Group 662.00 662.00 - 5,397.40 6,620.00 (1,222.60) 7,944.00 2,546.60 32.1%6411325 Insurance-Workers Comp 521.32 565.00 (43.68) 3,803.83 4,342.00 (538.17) 5,096.00 1,292.17 25.4%6411800 Taxes-Employer Payroll 2,223.07 1,707.00 516.07 14,311.81 13,121.00 1,190.81 15,399.00 1,087.19 7.1%6411880 Wages-Hourly 15,723.33 13,710.00 2,013.33 108,365.56 105,389.00 2,976.56 123,689.00 15,323.44 12.4%6411882 Wages-Overtime 567.94 - 567.94 1,568.93 - 1,568.93 - (1,568.93) 0.0%Total-CBR-SALARIES & BENEFITS20,417.66 17,364.00 3,053.66 139,447.53 135,472.00 3,975.53 159,088.00 19,640.47 12.3%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts - 50.00 (50.00) 2,192.80 2,250.00 (57.20) 2,350.00 157.20 6.7%6413742 Supplies-Expendable 1,012.53 150.00 862.53 7,658.97 5,750.00 1,908.97 6,750.00 (908.97) -13.5%6413752 Supplies-Range Balls - - - 7,495.01 6,000.00 1,495.01 6,000.00 (1,495.01) -24.9%6413762 Supplies-Office - 50.00 (50.00) 98.21 425.00 (326.79) 525.00 426.79 81.3%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) - 861.00 (861.00) 1,005.00 1,005.00 100.0%6413796 Supplies-Bottled Water189.82 50.00 139.82 14,734.80 12,450.00 2,284.80 24,500.00 9,765.20 39.9%Total-CBR-SUPPLIES & MATERIALS1,202.35 442.00 760.35 32,179.79 28,016.00 4,163.79 41,550.00 9,370.21 22.6%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts - 720.00 (720.00) 1,488.61 7,200.00 (5,711.39) 8,640.00 7,151.39 82.8%6415690 CBR-R&M-Equipment 117.69 300.00 (182.31) 1,446.07 3,000.00 (1,553.93) 3,600.00 2,153.93 59.8%6415695 CBR-R&M-Cart Maintenance & Repair - 250.00 (250.00) 4,488.62 4,500.00 (11.38) 5,000.00 511.38 10.2%Total-CBR-REPAIRS & MAINTENANCE 117.69 1,270.00 (1,152.31) 7,423.30 14,700.00 (7,276.70) 17,240.00 9,816.70 56.9%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 1,059.26 800.00 259.26 8,889.74 8,000.00 889.74 9,600.00 710.26 7.4%6419220 Freight/Delivery - - - 266.10 450.00 (183.90) 450.00 183.90 40.9%6419490 Miscellaneous 2,701.50 125.00 2,576.50 3,964.89 900.00 3,064.89 1,150.00 (2,814.89) -244.8%6419820 Uniforms - - - 2,257.34 3,500.00 (1,242.66) 5,200.00 2,942.66 56.6%Total-CBR-OTHER EXPENSES 3,760.76 925.00 2,835.76 15,378.07 12,850.00 2,528.07 16,400.00 1,021.93 6.2%TOTAL-CARTS,BAGROOM & RANGE 25,498.46 20,001.00 5,497.46 194,428.69 191,038.00 3,390.69 234,278.00 39,849.31 17.0%643-CS-SALARIES & BENEFITS6431175 Employee Meals 360.00 360.00 - 3,060.00 3,060.00 - 3,420.00 360.00 10.5%6431325 Insurance-Workers Comp 195.75 178.00 17.75 1,306.67 1,569.00 (262.33) 1,738.00 431.33 24.8%6431800 Taxes-Employer Payroll 913.53 538.00 375.53 5,388.66 4,743.00 645.66 5,251.00 (137.66) -2.6%6431880 Wages-Hourly 6,117.20 4,320.00 1,797.20 38,508.00 44,735.00 (6,227.00) 48,816.00 10,308.00 21.1%6431882 Wages-Overtime - - - 54.00 - 54.00 - (54.00) 0.0%Total-CS-SALARIES & BENEFITS7,586.48 5,396.00 2,190.48 48,317.33 54,107.00 (5,789.67) 59,225.00 10,907.67 18.4%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) 326.63 900.00 (573.37) 1,050.00 723.37 68.9%6439490 Miscellaneous 484.13 - 484.13 510.36 200.00 310.36 200.00 (310.36) -155.2%6439718 Safety Equipment & Training - 50.00 (50.00) 254.05 500.00 (245.95) 600.00 345.95 57.7%6439820 Uniforms - 400.00 (400.00) 908.29 1,975.00 (1,066.71) 2,125.00 1,216.71 57.3%Total-CS-OTHER EXPENSES 484.13 550.00 (65.87) 1,999.33 3,575.00 (1,575.67) 3,975.00 1,975.67 49.7%Total-COURSE SERVICES 8,070.61 5,946.00 2,124.61 50,316.66 57,682.00 (7,365.34) 63,200.00 12,883.34 20.4%33,569.07 25,947.00 7,622.07 244,745.35 248,720.00 (3,974.65) 297,478.00 50,756.98 17.1%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementApril 2011Annual Budget6 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 1,654.51 4,000.00 (2,345.49) 4,800.00 3,145.49 65.5%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 1,654.51 4,000.00 (2,345.49) 4,800.00 3,145.49 65.5%65-CH-UTILITIES6507836 Utilities-Natural Gas1,578.44 300.00 1,278.44 4,854.68 3,000.00 1,854.68 3,600.00 (1,254.68) -34.9%6507840 Utilities-Telephone- 1,150.00 (1,150.00) 10,411.73 11,500.00 (1,088.27) 13,800.00 3,388.27 24.6%6507842 Utilities-Water393.60 321.00 72.60 9,030.91 3,210.00 5,820.91 3,852.00 (5,178.91) -134.4%6507844 Utilities-Cable481.34 340.00 141.34 3,442.15 3,400.00 42.15 4,080.00 637.85 15.6%Total-CH-UTILITIES 2,453.38 2,111.00 342.38 27,739.47 21,110.00 6,629.47 25,332.00 (2,407.47) -9.5%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,900.00 1,825.00 75.00 18,325.00 18,850.00 (525.00) 22,500.00 4,175.00 18.6%6509099 Contract Services-Security4,565.04 4,900.00 (334.96) 50,333.90 50,600.00 (266.10) 60,400.00 10,066.10 16.7%6509215 Flowers & Decorations- - - - 2,000.00 (2,000.00) 2,400.00 2,400.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 1,383.79 2,000.00 (616.21) 2,400.00 1,016.21 42.3%6509718 Safety Equipment & Training- 100.00 (100.00) 359.85 1,000.00 (640.15) 1,200.00 840.15 70.0%Total-CH-OTHER EXPENSES 6,465.04 7,025.00 (559.96) 70,402.54 74,450.00 (4,047.46) 88,900.00 18,497.46 20.8%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures296.00 300.00 (4.00) 4,791.99 3,000.00 1,791.99 3,600.00 (1,191.99) -33.1%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 2,199.86 4,000.00 (1,800.14) 4,800.00 2,600.14 54.2%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 3,451.39 4,000.00 (548.61) 4,800.00 1,348.61 28.1%Total-CH-REPAIRS & MAINTENANCE 296.00 1,100.00 (804.00) 10,443.24 11,000.00 (556.76) 13,200.00 2,756.76 20.9%9,214.42 10,636.00 (1,421.58) 110,239.76 110,560.00 (320.24) 132,232.00 5,513.52 4.2%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementApril 2011Annual 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 331.00 331.00 - 3,184.24 3,310.00 (125.76) 3,972.00 787.76 19.8%6601325 Insurance-Workers Comp 77.22 103.00 (25.78) 932.75 1,030.00 (97.25) 1,240.00 307.25 24.8%6601720 Salaries 2,412.97 2,508.00 (95.03) 25,820.30 25,080.00 740.30 30,096.00 4,275.70 14.2%6601800 Taxes-Employer Payroll 232.08 312.00 (79.92) 3,377.35 3,120.00 257.35 3,747.00 369.65 9.9%Total-MKT-SALARIES & BENEFITS 3,113.27 3,314.00 (200.73) 33,914.64 33,140.00 774.64 39,775.00 5,860.36 14.7%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 388.52 100.00 288.52 441.33 1,000.00 (558.67) 1,200.00 758.67 63.2%6603768 Supplies-Printing & Stationery 156.60 125.00 31.60 5,301.46 4,175.00 1,126.46 4,425.00 (876.46) -19.8%545.12 225.00 320.12 5,742.79 5,175.00 567.79 5,625.00 (117.79) -2.1%66-MKT-UTILITIES6607840 Utilities-Telephone 101.58 100.00 1.58 507.58 1,000.00 (492.42) 1,200.00 692.42 57.7%Total-MKT-UTILITIES 101.58 100.00 1.58 507.58 1,000.00 (492.42) 1,200.00 692.42 57.7%66-MKT-OTHER EXPENSES6609010 Advertising 13,098.79 16,177.00 (3,078.21) 161,096.94 179,130.00 (18,033.06) 192,534.00 31,437.06 16.3%6609040 Business Meals - 25.00 (25.00) - 250.00 (250.00) 300.00 300.00 100.0%6609080 Collateral Material 2,646.88 500.00 2,146.88 7,334.98 7,500.00 (165.02) 9,000.00 1,665.02 18.5%6609102 Contract Services-Web Page 99.00 400.00 (301.00) 1,477.50 4,000.00 (2,522.50) 4,800.00 3,322.50 69.2%6609490 Miscellaneous - 50.00 (50.00) - 300.00 (300.00) 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) 283.62 500.00 (216.38) 600.00 316.38 52.7%6609630 Promotion - 50.00 (50.00) - 600.00 (600.00) 3,500.00 3,500.00 0.0%6609633 Promotion-Community - 75.00 (75.00) 175.00 2,775.00 (2,600.00) 2,925.00 2,750.00 94.0%6609634 Promotion-Media/Vendor - - - 1,610.35 3,500.00 (1,889.65) 700.00 - 0.0%6609150 Dues and Subscriptions - - - 140.00 735.00 (595.00) 735.00 595.00 81.0%6609820 Uniforms - 50.00 (50.00) 210.72 600.00 (389.28) 600.00 389.28 64.9%Total-MKT-OTHER EXPENSES 15,844.67 17,377.00 (1,532.33) 172,329.11 199,890.00 (27,560.89) 216,044.00 44,625.24 20.7%19,604.64 21,016.00 (1,411.36) 212,494.12 239,205.00 (26,710.88) 262,644.00 51,060.23 19.4%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementApril 2011Annual 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,850.25 1,458.00 1,392.25 17,983.95 14,580.00 3,403.95 17,496.00 (487.95) -2.8%6701325 Insurance-Workers Comp588.72 707.00 (118.28) 5,859.73 7,070.00 (1,210.27) 8,480.00 2,620.27 30.9%6701720 Salaries 15,757.89 14,833.34 924.55 144,448.40 148,333.40 (3,885.00) 178,000.00 33,551.60 18.8%6701800 Taxes-Employer Payroll 1,326.81 2,136.00 (809.19) 13,837.18 21,360.00 (7,522.82) 25,627.00 11,789.82 46.0%6701880 Wages-Hourly2,639.73 2,319.66 320.07 20,115.16 23,196.60 (3,081.44) 27,835.00 7,719.84 27.7%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 23,343.40 21,634.00 1,709.40 204,044.42 216,340.00 (12,295.58) 259,598.00 55,553.58 21.4%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer715.37 400.00 315.37 1,709.32 4,000.00 (2,290.68) 5,200.00 3,490.68 67.1%6703762 Supplies-Office 16.62 100.00 (83.38) 1,565.50 1,000.00 565.50 1,200.00 (365.50) -30.5%6703768 Supplies-Printing & Stationery- 400.00 (400.00) 1,446.93 2,500.00 (1,053.07) 3,300.00 1,853.07 56.2%Total-G&A-SUPPLIES & MATERIALS 731.99 900.00 (168.01) 4,721.75 7,500.00 (2,778.25) 9,700.00 4,978.25 51.3%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 522.50 900.00 (377.50) 1,100.00 577.50 52.5%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 522.50 900.00 (377.50) 1,100.00 577.50 52.5%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 & Subscriptions110.00 50.00 60.00 761.71 1,150.00 (388.29) 1,700.00 938.29 55.2%6709180 Employee Recruiting/Relocation225.93 - 225.93 813.93 1,400.00 (586.07) 1,400.00 586.07 41.9%6709197 Equipment Rental680.85 480.00 200.85 5,940.23 4,800.00 1,140.23 5,760.00 (180.23) -3.1%6709202 Fees-Bank51.91 90.00 (38.09) 644.71 900.00 (255.29) 1,080.00 435.29 40.3%6709208 Fees-Payroll Processing1,571.31 760.00 811.31 12,685.30 7,600.00 5,085.30 9,120.00 (3,565.30) -39.1%6709220 Freight/Delivery- 50.00 (50.00) 10.51 500.00 (489.49) 600.00 589.49 98.2%6709490 Miscellaneous - 100.00 (100.00) 194.42 1,000.00 (805.58) 1,200.00 1,005.58 83.8%6709620 Postage/Mail Services 26.11 75.00 (48.89) 1,110.35 750.00 360.35 900.00 (210.35) -23.4%6709625 Professional Fees534.25 850.00 (315.75) 10,839.95 8,500.00 2,339.95 10,200.00 (639.95) -6.3%6709636 Promotion/Entertainment- 100.00 (100.00) 2,085.00 2,900.00 (815.00) 3,100.00 1,015.00 32.7%6709722 Seminars & Training91.00 200.00 (109.00) 701.00 2,000.00 (1,299.00) 2,400.00 1,699.00 70.8%6709810 Travel - 200.00 (200.00) - 400.00 (400.00) 1,100.00 1,100.00 100.0%6709820 Uniforms 407.41 75.00 332.41 1,090.12 900.00 190.12 1,050.00 (40.12) -3.8%Total-G&A-OTHER EXPENSES 4,098.77 3,430.00 668.77 40,877.23 36,800.00 4,077.23 44,410.00 3,532.77 8.0%28,174.16 26,064.00 2,110.16 250,165.90 261,540.00 (11,374.10) 314,808.00 64,642.10 20.5%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementApril 2011Annual Budget9 April Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 11,091.63 13,000.00 (1,908.37) 91,234.76 124,324.00 (33,089.24) 150,324.00 59,089.24 39.3%6800194 Equipment Leases-Trailer 540.00 600.00 (60.00) 5,380.00 6,000.00 (620.00) 7,200.00 1,820.00 25.3%6800196 Equipment Leases-GPS 5,290.50 6,400.00 (1,109.50) 66,274.92 77,416.00 (11,141.08) 90,216.00 23,941.08 26.5%6800197 Equipment Leases-Others 604.73 - 604.73 17,428.75 - 17,428.75 - - 0.0%17,526.86 20,000.00 (2,473.14) 180,318.43 207,740.00 (27,421.57) 247,740.00 84,850.32 34.2%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee (5,888.60) (2,634.00) (3,254.60) 53,474.23 66,247.00 (12,772.77) 90,000.00 36,525.77 40.6%6900210 FF&E Reserve 9,824.93 8,645.00 1,179.93 54,033.39 53,711.00 322.39 62,229.00 8,195.61 13.2%6900800 Personal Property Taxes - - - 15,519.02 13,570.00 1,949.02 13,570.00 (1,949.02) -14.4%6900323 Insurance-Commercial 2,605.10 2,200.00 405.10 23,489.12 22,000.00 1,489.12 26,400.00 2,910.88 11.0%6,541.43 8,211.00 (1,669.57) 146,515.76 155,528.00 (9,012.24) 192,199.00 45,683.24 23.8%Silverrock ResortOperating Leases & Miscellaneous Other Expense StatementApril 2011Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSES10 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2010-20112010 2010 2010 2010 2010 2010Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia4Sales4PromotionGolf Industry85 4VIPCelebrityPGA Comp68 72 76 30 58Charity/Gift Certificate12 44 45Rain/Wind Checks34 4Club Staff77 68 96 3 69 119LQ HS Golf20153 148 208 3 155 2262011 2011 2011 2011 2011 2011Comp CategoryJanuaryFebruaryMarchAprilMayJuneMedia431Sales6Promotion4Golf Industry420VIPCelebrity112PGA Comp29 325557Charity/Gift Certificate21 182339Rain/Wind Checks392Club Staff51 10810693LQ HS Golf61 131 74101 231 328 298 0 011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2010-2011April 2011 Date Time Description CategoryPlayers4/1/2011 11:15 Scott White GM CVA Sales 44/1/2011 12:00 Ken Murphy - Golfweek Magazine Promo 14/4/2011 11:07 Jason Brown - Photographer Promo 14/10/2011 7:37 Vater - Golfweek Magazine Promo 24/13/2011 12:00 Michael Dante Celebrity 24/17/2011 1:22 Kris Long Media 14/23/2011 12:45 RJ Milici -GPSI Promo 212