Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
06 December 2010 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2010 – December 2010 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 December Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue260,141.50 268,875.00 (8,733.50) -3.2% 930,786.10 998,158.00 (67,371.90) 3,111,458.00 2,180,671.90 30%401000 Miscellaneous Golf Revenue 15,136.00 11,440.00 3,696.00 32.3% 46,710.30 49,056.00 (2,345.70) 117,656.00 70,945.70 40%410000 Revenue-Golf Shop 23,237.76 25,020.00 (1,782.24) -7.1% 85,786.54 93,031.00 (7,244.46) 306,492.00 220,705.46 28%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0% 6,000.00 6,000.00 - 12,000.00 6,000.00 50%890000 Interest Income3.91 - 3.91 0.0% 29.61 - 29.61 - (29.61) 0%Total Income300,019.17 306,835.00 (6,815.83) -2.2% 1,069,312.55 1,146,245.00 (76,932.45) 3,547,606.00 2,478,293.45 30%Cost of Goods Sold510000 COS-Golf Shop 12,350.44 13,279.00 (928.56) 7.0% 46,189.08 49,375.05 3,185.97 162,670.60 116,481.52 28%Total COS12,350.44 13,279.00 (928.56) 7.0% 46,189.08 49,375.05 3,185.97 162,670.60 116,481.52 28%Gross Profit287,668.73 293,556.00 (5,887.27) -2.0% 1,023,123.47 1,096,869.95 (73,746.48) 3,384,935.40 2,361,811.93 30%Expenses610000 Golf Pro Shop 16,917.12 20,326.00 3,408.88 16.8% 88,314.74 106,691.00 18,376.26 230,213.00 141,898.26 38%630000 Course Maintenance106,821.18 108,043.00 1,221.82 1.1% 844,406.43 866,545.00 22,138.57 1,541,961.00 697,554.57 55%633000 Maintenance Water & Energy5,804.71 5,325.00 (479.71) -9.0% 45,760.79 48,160.00 2,399.21 85,358.00 39,597.21 54%640000 Outside Services23,135.29 25,987.00 2,851.71 11.0% 125,297.96 138,661.00 13,363.04 297,478.00 172,180.04 42%650000 Clubhouse 10,478.89 10,636.00 157.11 1.5% 70,326.42 64,916.00 (5,410.42) 132,232.00 61,905.58 53%660000 Marketing 24,515.65 25,866.00 1,350.35 5.2% 122,564.91 131,871.00 9,306.09 262,644.00 140,079.09 47%670000 General & Administrative27,242.19 28,114.00 871.81 3.1% 142,786.50 156,784.00 13,997.50 314,808.00 172,021.50 45%680000 Leases 20,202.10 22,236.00 2,033.90 9.1% 112,684.41 127,740.00 15,055.59 247,740.00 135,055.59 45%690000 Miscellaneous Other Expense16,461.07 15,693.00 (768.07) -4.9% 105,087.93 124,190.00 19,102.07 192,199.00 87,111.07 55%Total Expenses251,578.20 262,226.00 10,647.80 4.1% 1,657,230.09 1,765,558.00 108,327.91 3,304,633.00 1,647,402.91 50%36,090.53 31,330.00 4,760.53 15.2%(634,106.62) (668,688.05) 34,581.43 80,302.40 714,409.02 -790%Rounds of Golf PlayedPaid Rounds Played 3,811 3,600 211 5.9% 17,122 17,027 95 39,150 22,028 44%Ave $ Per Paid Round Green Fee68.26 74.69 (6.43) -8.6% 54.36 58.62 (4.26) 76.13 21.77 71%Ave $ Per Paid Round Merchandise6.10 6.95 (0.85) -12.3% 5.01 5.46 (0.45) 8.07 3.06 62%Ave $ Per Paid Miscellaneous 3.97 3.18 0.79 25.0% 2.73 2.88 (0.15) 2.06 - 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateDecember 2010 Income December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 260,141.50 268,875.00 (8,733.50) 930,786.10 998,158.00 (67,371.90) 3,111,458.002,180,671.9030%4010000 Rider Fee 925.00 360.00 565.00 4,375.00 4,017.00 358.00 6,522.002,147.0067%4040000 Club Rental 2,170.00 1,980.00 190.00 8,335.00 9,364.00 (1,029.00) 28,004.0019,669.0030%4050000 Driving Range 7,316.00 3,600.00 3,716.00 22,949.00 17,675.00 5,274.00 48,130.0025,181.0048%4080000 GPS Advertising - 2,000.00 (2,000.00) - 9,000.00 (9,000.00) 12,000.00 12,000.000%4090000 Ball Retriever/Subcontract - - - 1,826.30 2,000.00 (173.70) 4,000.00 2,173.7046%4091000 Golf Professional Rental Fee 4,725.00 3,500.00 1,225.00 9,225.00 7,000.00 2,225.00 19,000.00 9,775.00 49%4092000 Golf Lessons - - - - - - - - 0% Total Revenue Fees 275,277.50 280,315.00 (5,037.50) 977,496.40 1,047,214.00 (69,717.60) 3,229,114.00 2,251,617.60 30%275,277.50 280,315.00 (5,037.50) 977,496.40 1,047,214.00 (69,717.60) 3,229,114.00 2,251,617.60 30%SilverRock ResortStatement of Fees RevenueDecember 2010Total IncomeMonth to Date Year to Date Annual Budget Income December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 775.52 - 775.52 2,420.54 - 2,420.54 0 0 0%4100110 Sales Hard Goods 7,238.75 8,757.00 (1,518.25) 34,179.58 32,561.00 1,618.58 107,272.00 73,092.42 32%4100112 Sales-Soft Goods 18,500.00 16,263.00 2,237.00 60,387.10 60,470.00 (82.90) 199,220.00 138,832.90 30%5100639 GS-Discounts-Mdse (3,276.51) - (3,276.51) (11,200.68) - (11,200.68) - 11,200.68 0% Total Revenue Golf Shop 23,237.76 25,020.00 (1,782.24) 85,786.54 93,031.00 (7,244.46) 306,492.00 223,126.00 27%COS 5100150 COS-GS-Hard Goods 3,631.58 4,816.35 (1,184.77) 17,762.57 17,908.55 (145.98) 58,999.60 41,237.03 30%5100151 COS-GS-Soft Goods 8,466.85 8,944.65 (477.80) 27,027.38 33,258.50 (6,231.12) 109,571.00 82,543.62 25%5100152 COS-GS-Purchase Disc (255.15) (688.00) 432.85 (1,264.29) (2,558.00) 1,293.71 (8,429.00) (7,164.71) -15%5100220 COS-GS-Freight Merch 507.16 206.00 301.16 2,663.42 766.00 1,897.42 2,529.00 (134.42) 105%Cost of Sales - Golf Shop 12,350.44 13,279.00 (928.56) 46,189.08 49,375.05 (3,185.97) 162,670.60 116,481.52 28%Gross Profit 10,887.32 11,741.00 (853.68) 39,597.46 43,655.95 (4,058.49) 143,821.40 106,644.48 26%COS % 53.1% 53.1% -0.1% 53.8% 53.1% -0.8% 53.1% 52.2% 2%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 480.00 480.00 - 2,580.00 2,580.00 - 5,400.00 2,820.00 48%6101320 Insurance Group 2,317.00 2,317.00 - 13,185.72 12,909.00 276.72 26,811.00 13,625.28 49%6101325 Insurance-Workers Comp 355.07 567.00 (211.93) 2,195.88 2,834.00 (638.12) 6,131.00 3,935.12 36%6101720 Salaries 3,545.46 3,750.00 (204.54) 21,634.88 22,500.00 (865.12) 45,000.00 23,365.12 48%6101800 Taxes-Employer Payroll 960.50 1,714.00 (753.50) 4,342.38 8,563.00 (4,220.62) 18,528.00 14,185.62 23%6101880 Wages-Hourly 8,240.07 10,013.00 (1,772.93) 36,049.94 46,270.00 (10,220.06) 103,818.00 67,768.06 35%6101882 Wages-Overtime 50.25 - 50.25 171.40 - 171.40 - 952.88 0%Total -PS-SALARIES & BENEFITS 15,948.35 18,841.00 (2,892.65) 80,160.20 95,656.00 (15,495.80) 205,688.00 126,652.08 38%61-PS OTHER EXPENSES6103742 Supplies-Expendable - - - 189.74 - 189.74 - (189.74) 0%6103762 Supplies-Office 10.98 500.00 (489.02) 1,834.78 3,000.00 (1,165.22) 6,000.00 4,165.22 31%6109090 Contract Services 500.00 500.00 - 3,000.00 3,000.00 - 6,000.00 3,000.00 50%6109220 Freight & Delivery 10.09 25.00 (14.91) 386.58 75.00 311.58 75.00 (311.58) 515%6109490 Miscellaneous - 50.00 (50.00) 104.37 150.00 (45.63) 450.00 345.63 23%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short 0.72 - 0.72 16.06 - 16.06 - (16.06) 0%6109722 Seminars/Training - 100.00 (100.00) 545.07 3,250.00 (2,704.93) 5,890.00 5,344.93 9%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms 345.06 200.00 145.06 1,191.71 900.00 291.71 2,400.00 1,208.29 50%6117840 Telephones 101.92 110.00 (8.08) 886.23 660.00 226.23 1,320.00 433.77 0%Total PS-OTHER EXPENSES 968.77 1,485.00 (516.23) 8,154.54 11,035.00 (2,880.46) 24,525.00 16,370.46 33%16,917.12 20,326.00 (3,408.88) 88,314.74 106,691.00 (18,376.26) 230,213.00 143,022.54 38%Net Income(6,029.80) (8,585.00) 2,555.20 (48,717.28) (63,035.05) 14,317.77 (86,391.60) (36,378.06) -58%SilverRock ResortGolf Shop Income StatementDecember 2010Total Expenses-Golf ShopMonth to Date Year to Date Annual Budget December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 1,440.00 1,440.00 - 2,880.00 1,440.00 50.0%6311320 Insurance-Group 8,740.00 8,740.00 - 50,827.69 52,440.00 (1,612.31) 104,880.00 54,052.31 51.5%6311325 Insurance-Workers Comp 1,596.24 2,362.00 (765.76) 13,047.45 13,831.00 (783.55) 27,638.00 14,590.55 52.8%6311720 Salaries 12,001.60 12,583.00 (581.40) 69,943.36 75,498.00 (5,554.64) 150,996.00 81,052.64 53.7%6311800 Taxes-Employer Payroll 4,450.16 7,139.00 (2,688.84) 27,383.88 42,227.00 (14,843.12) 84,168.00 56,784.12 67.5%6311880 Wages-Hourly 44,558.83 44,758.00 (199.17) 255,298.30 253,383.00 1,915.30 509,458.00 254,159.70 49.9%6311882 Wages-Overtime 147.48 - 147.48 13,546.59 10,306.00 3,240.59 15,598.00 2,051.41 13.2%Total-CM-SALARIES & BENEFITS71,734.31 75,822.00 (4,087.69) 431,487.27 449,125.00 (17,637.73) 895,618.00 464,130.73 51.8%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 3,543.37 2,200.00 1,343.37 22,502.33 18,900.00 3,602.33 29,300.00 6,797.67 23.2%6313744 Fertilizer 970.87 1,000.00 (29.13) 53,165.88 58,400.00 (5,234.12) 89,400.00 36,234.12 40.5%6313745 Herbicides - - - 12,221.59 12,000.00 221.59 12,000.00 (221.59) -1.8%6313746 Flowers/Plants - 750.00 (750.00) 1,253.89 2,000.00 (746.11) 3,050.00 1,796.11 58.9%6313748 Fuel-Gasoline 3,197.55 3,100.00 97.55 27,032.81 24,730.00 2,302.81 43,100.00 16,067.19 37.3%6313750 Golf Course Accessories 455.04 500.00 (44.96) 11,864.05 11,600.00 264.05 12,300.00 435.95 3.5%6313756 POA Control 3,784.50 - 3,784.50 8,211.11 3,500.00 4,711.11 7,000.00 (1,211.11) -17.3%6313758 Miscellaneous Supp 823.41 500.00 323.41 4,658.60 3,750.00 908.60 4,350.00 (308.60) 0.0%6313762 Supplies-Office - - - 238.13 - 238.13 - (238.13) 0.0%6313774 Sand - 800.00 (800.00) 4,334.57 10,580.00 (6,245.43) 11,460.00 7,125.43 62.2%6313776 Seed 1,609.50 350.00 1,259.50 96,436.13 89,710.00 6,726.13 91,810.00 (4,626.13) -5.0%6313778 Small Tools & Non-Capital Equip - 100.00 (100.00) 4,036.07 4,400.00 (363.93) 5,000.00 963.93 19.3%6313780 Sod - 250.00 (250.00) 3,179.03 2,150.00 1,029.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 & MATERIALS14,384.24 9,550.00 4,834.24 256,851.78 246,720.00 10,131.78 319,720.00 62,868.22 19.7%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,575.00 875.00 700.00 10,801.24 12,278.00 (1,476.76) 24,610.00 13,808.76 56.1%6315685 CM-R&M-Bldngs & Othr Structures 90.50 - 90.50 1,181.15 750.00 431.15 1,750.00 568.85 32.5%6315690 CM-R&M-Equipment 1,453.97 1,000.00 453.97 18,713.96 13,000.00 5,713.96 20,500.00 1,786.04 8.7%6315692 CM-R&M-Irrigation System 400.39 550.00 (149.61) 9,493.35 9,850.00 (356.65) 16,050.00 6,556.65 40.9%6315696 CM-R&M-Pumps 85.78 1,000.00 (914.22) 5,439.15 6,000.00 (560.85) 10,500.00 5,060.85 48.2%6315815 CM-R&M-Trees-Pruning Etc - - - 3,495.00 4,050.00 (555.00) 10,050.00 6,555.00 65.2%Total-CM-REPAIRS & MAINTENANCE 3,605.64 3,425.00 180.64 49,123.85 45,928.00 3,195.85 83,460.00 34,336.15 41.1%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 31.05 15.00 16.05 147.59 90.00 57.59 180.00 32.41 0.0%6317840 Telephones 1,126.70 850.00 276.70 6,597.84 5,100.00 1,497.84 10,200.00 3,602.16 35.3%Total-CM-UTILITIES 1,157.75 865.00 292.75 6,745.43 5,190.00 1,555.43 10,380.00 3,634.57 35.0%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 3,000.00 3,000.00 - 6,000.00 3,000.00 50.0%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 296.29 525.00 (228.71) 2,610.30 3,150.00 (539.70) 6,288.00 3,677.70 0.0%6319150 Dues & Subscriptions 210.00 - 210.00 345.00 - 345.00 540.00 195.00 36.1%6319170 Employee Education - 50.00 (50.00) 70.00 300.00 (230.00) 1,550.00 1,480.00 95.5%6319197 Equipment Rental 263.64 200.00 63.64 2,747.39 3,100.00 (352.61) 4,200.00 1,452.61 34.6%6319206 Licenses & Permits - - - 353.03 280.00 73.03 1,430.00 1,076.97 75.3%6319490 Miscellaneous 16.17 100.00 (83.83) 618.23 600.00 18.23 1,200.00 581.77 48.5%6319718 Safety Equipment & Training 99.89 400.00 (300.11) 1,877.65 2,750.00 (872.35) 3,850.00 1,972.35 51.2%6319822 Uniforms 742.71 820.00 (77.29) 6,327.35 4,920.00 1,407.35 9,840.00 3,512.65 35.7%Total-CM-OTHER EXPENSES 2,128.70 2,595.00 (466.30) 19,448.95 20,100.00 (651.05) 38,898.00 19,449.05 50.0%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementDecember 2010Annual Budget December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,317.00 2,317.00 - 12,993.00 13,902.00 (909.00) 27,804.00 14,811.00 53.3%6321325 Insurance-Workers Comp 252.99 445.00 (192.01) 2,211.64 2,794.00 (582.36) 5,487.00 3,275.36 59.7%6321800 Taxes-Employer Payroll 645.11 1,346.00 (700.89) 4,389.64 8,632.00 (4,242.36) 16,811.00 12,421.36 73.9%6321880 Wages-Hourly 10,429.63 10,813.00 (383.37) 56,869.02 64,878.00 (8,008.98) 129,756.00 72,886.98 56.2%6321882 Wages-Overtime 3.28 - 3.28 2,530.04 4,461.00 (1,930.96) 5,272.00 2,741.96 52.0%Total-CM-LM-SALARIES & BENEFITS13,648.01 14,921.00 (1,272.99) 78,993.34 94,667.00 (15,673.66) 185,130.00 106,136.66 57.3%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) 264.55 575.00 (310.45) 1,025.00 760.45 74.2%6323788 Uniforms 162.53 290.00 (127.47) 1,366.09 1,740.00 (373.91) 3,480.00 2,113.91 60.7%Total-CM-LM-SUPPLIES & MATERIALS162.53 365.00 (202.47) 1,630.64 2,315.00 (684.36) 4,505.00 2,874.36 63.8%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 500.00 (500.00) 125.17 2,500.00 (2,374.83) 4,250.00 4,124.83 97.1%Total-CM-LM-REPAIRS & MAINTENANCE - 500.00 (500.00) 125.17 2,500.00 (2,374.83) 4,250.00 4,124.83 97.1%106,821.18 108,043.00 (1,221.82) 844,406.43 866,545.00 (22,138.57) 1,541,961.00 697,554.57 45.2% December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 2,849.68 3,000.00 (150.32) 15,995.08 21,300.00 (5,304.92) 42,300.00 26,304.92 62.2%6337842 Utilities-Water2,955.03 2,325.00 630.03 29,765.71 26,860.00 2,905.71 43,058.00 13,292.29 30.9%5,804.71 5,325.00 479.71 45,760.79 48,160.00 (2,399.21) 85,358.00 39,597.21 46.4%Silverrock ResortCourse Maintenance Expense StatementDecember 2010Annual BudgetMonth to Date Year to DateSilverrock ResortCourse Maintenance Water & EnergyDecember 2010Total-COURSE MAINTENANCETotal-CM-WATER & ENERGYMonth to Date Year to Date Annual Budget December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 660.00 660.00 - 3,120.00 3,120.00 - 6,960.00 3,840.00 55.2%6411320 Insurance-Group 662.00 662.00 - 3,368.60 3,972.00 (603.40) 7,944.00 4,575.40 57.6%6411325 Insurance-Workers Comp 351.04 485.00 (133.96) 1,899.07 2,082.00 (182.93) 5,096.00 3,196.93 62.7%6411800 Taxes-Employer Payroll 1,260.23 1,466.00 (205.77) 5,603.63 6,293.00 (689.37) 15,399.00 9,795.37 63.6%6411880 Wages-Hourly 11,687.76 11,774.00 (86.24) 50,218.52 50,549.00 (330.48) 123,689.00 73,470.48 59.4%6411882 Wages-Overtime 13.69 - 13.69 183.37 - 183.37 - (183.37) 0.0%Total-CBR-SALARIES & BENEFITS14,634.72 15,047.00 (412.28) 64,393.19 66,016.00 (1,622.81) 159,088.00 94,694.81 59.5%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 284.49 500.00 (215.51) 2,123.29 2,000.00 123.29 2,350.00 226.71 9.6%6413742 Supplies-Expendable 370.78 150.00 220.78 4,613.90 3,450.00 1,163.90 6,750.00 2,136.10 31.6%6413752 Supplies-Range Balls 595.01 - 595.01 7,495.01 6,000.00 1,495.01 6,000.00 (1,495.01) -24.9%6413762 Supplies-Office 16.28 50.00 (33.72) 98.21 225.00 (126.79) 525.00 426.79 81.3%6413768 Supplies-Printing and Stationary - - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels - 72.00 (72.00) - 573.00 (573.00) 1,005.00 1,005.00 100.0%6413796 Supplies-Bottled Water189.82 50.00 139.82 13,975.52 12,250.00 1,725.52 24,500.00 10,524.48 43.0%Total-CBR-SUPPLIES & MATERIALS1,456.38 822.00 634.38 28,305.93 24,498.00 3,807.93 41,550.00 13,244.07 31.9%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts - 720.00 (720.00) - 4,320.00 (4,320.00) 8,640.00 8,640.00 100.0%6415690 CBR-R&M-Equipment 36.00 300.00 (264.00) 1,089.26 1,800.00 (710.74) 3,600.00 2,510.74 69.7%6415695 CBR-R&M-Cart Maintenance & Repair - 250.00 (250.00) 2,900.18 3,500.00 (599.82) 5,000.00 2,099.82 42.0%Total-CBR-REPAIRS & MAINTENANCE 36.00 1,270.00 (1,234.00) 3,989.44 9,620.00 (5,630.56) 17,240.00 13,250.56 76.9%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 663.77 800.00 (136.23) 5,673.40 4,800.00 873.40 9,600.00 3,926.60 40.9%6419220 Freight/Delivery - 75.00 (75.00) 78.96 450.00 (371.04) 450.00 371.04 82.5%6419490 Miscellaneous 8.11 75.00 (66.89) 300.48 500.00 (199.52) 1,150.00 849.52 73.9%6419820 Uniforms 218.19 500.00 (281.81) 2,224.71 3,000.00 (775.29) 5,200.00 2,975.29 57.2%Total-CBR-OTHER EXPENSES 890.07 1,450.00 (559.93) 8,277.55 8,750.00 (472.45) 16,400.00 8,122.45 49.5%TOTAL-CARTS,BAGROOM & RANGE 17,017.17 18,589.00 (1,571.83) 104,966.11 108,884.00 (3,917.89) 234,278.00 129,311.89 55.2%643-CS-SALARIES & BENEFITS6431175 Employee Meals 420.00 420.00 - 1,440.00 1,440.00 - 3,420.00 1,980.00 57.9%6431325 Insurance-Workers Comp 145.41 231.00 (85.59) 557.33 686.00 (128.67) 1,738.00 1,180.67 67.9%6431800 Taxes-Employer Payroll 620.44 697.00 (76.56) 2,000.95 2,072.00 (71.05) 5,251.00 3,250.05 61.9%6431880 Wages-Hourly 4,838.00 5,600.00 (762.00) 15,094.00 23,279.00 (8,185.00) 48,816.00 33,722.00 69.1%6431882 Wages-Overtime 9.00 - 9.00 51.00 - 51.00 - (51.00) 0.0%Total-CS-SALARIES & BENEFITS6,032.85 6,948.00 (915.15) 19,143.28 27,477.00 (8,333.72) 59,225.00 40,081.72 67.7%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) - 500.00 (500.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous 15.08 50.00 (34.92) 26.23 150.00 (123.77) 200.00 173.77 86.9%6439718 Safety Equipment & Training - 50.00 (50.00) 254.05 300.00 (45.95) 600.00 345.95 57.7%6439820 Uniforms 70.19 250.00 (179.81) 908.29 1,350.00 (441.71) 2,125.00 1,216.71 57.3%Total-CS-OTHER EXPENSES 85.27 450.00 (364.73) 1,188.57 2,300.00 (1,111.43) 3,975.00 2,786.43 70.1%Total-COURSE SERVICES 6,118.12 7,398.00 (1,279.88) 20,331.85 29,777.00 (9,445.15) 63,200.00 42,868.15 67.8%23,135.29 25,987.00 (2,851.71) 125,297.96 138,661.00 (13,363.04) 297,478.00 169,393.61 56.9%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementDecember 2010Annual Budget December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable- 400.00 (400.00) 1,654.51 2,400.00 (745.49) 4,800.00 3,145.49 65.5%Total-CH-SUPPLIES & MATERIALS - 400.00 (400.00) 1,654.51 2,400.00 (745.49) 4,800.00 3,145.49 65.5%65-CH-UTILITIES6507836 Utilities-Natural Gas554.90 300.00 254.90 2,042.33 1,800.00 242.33 3,600.00 1,557.67 43.3%6507840 Utilities-Telephone969.79 1,150.00 (180.21) 6,215.59 6,900.00 (684.41) 13,800.00 7,584.41 55.0%6507842 Utilities-Water359.23 321.00 38.23 7,228.83 1,926.00 5,302.83 3,852.00 (3,376.83) -87.7%6507844 Utilities-Cable336.49 340.00 (3.51) 2,018.94 2,040.00 (21.06) 4,080.00 2,061.06 50.5%Total-CH-UTILITIES 2,220.41 2,111.00 109.41 17,505.69 12,666.00 4,839.69 25,332.00 7,826.31 30.9%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,825.00 1,825.00 - 11,025.00 11,550.00 (525.00) 22,500.00 11,475.00 51.0%6509099 Contract Services-Security5,078.88 4,900.00 178.88 30,801.06 29,400.00 1,401.06 60,400.00 29,598.94 49.0%6509215 Flowers & Decorations- - - - 500.00 (500.00) 2,400.00 2,400.00 100.0%6509490 Miscellaneous24.01 200.00 (175.99) 1,253.79 1,200.00 53.79 2,400.00 1,146.21 47.8%6509718 Safety Equipment & Training- 100.00 (100.00) - 600.00 (600.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES 6,927.89 7,025.00 (97.11) 43,079.85 43,250.00 (170.15) 88,900.00 45,820.15 51.5%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures480.50 300.00 180.50 3,126.00 1,800.00 1,326.00 3,600.00 474.00 13.2%6515686 CH-R&M-Restaurant Repairs850.09 400.00 450.09 2,014.86 2,400.00 (385.14) 4,800.00 2,785.14 58.0%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 2,945.51 2,400.00 545.51 4,800.00 1,854.49 38.6%Total-CH-REPAIRS & MAINTENANCE 1,330.59 1,100.00 230.59 8,086.37 6,600.00 1,486.37 13,200.00 5,113.63 38.7%10,478.89 10,636.00 (157.11) 70,326.42 64,916.00 5,410.42 132,232.00 10,227.26 7.7%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementDecember 2010Annual Budget December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 360.00 360.00 - 720.00 360.00 50.0%6601320 Insurance-Group 331.00 331.00 - 1,925.60 1,986.00 (60.40) 3,972.00 2,046.40 51.5%6601325 Insurance-Workers Comp 69.06 103.00 (33.94) 620.16 618.00 2.16 1,240.00 619.84 50.0%6601720 Salaries 2,301.88 2,508.00 (206.12) 16,051.88 15,048.00 1,003.88 30,096.00 14,044.12 46.7%6601800 Taxes-Employer Payroll 232.44 312.00 (79.56) 1,942.94 1,872.00 70.94 3,747.00 1,804.06 48.1%Total-MKT-SALARIES & BENEFITS 2,994.38 3,314.00 (319.62) 20,900.58 19,884.00 1,016.58 39,775.00 18,874.42 47.5%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 52.81 600.00 (547.19) 1,200.00 1,147.19 95.6%6603768 Supplies-Printing & Stationery - 200.00 (200.00) 4,975.26 3,600.00 1,375.26 4,425.00 (550.26) -12.4%- 300.00 (300.00) 5,028.07 4,200.00 828.07 5,625.00 596.93 10.6%66-MKT-UTILITIES6607840 Utilities-Telephone 49.46 100.00 (50.54) 307.62 600.00 (292.38) 1,200.00 892.38 74.4%Total-MKT-UTILITIES 49.46 100.00 (50.54) 307.62 600.00 (292.38) 1,200.00 892.38 74.4%66-MKT-OTHER EXPENSES6609010 Advertising 21,372.81 20,277.00 1,095.81 92,549.92 95,212.00 (2,662.08) 192,534.00 99,984.08 51.9%6609040 Business Meals - 25.00 (25.00) - 150.00 (150.00) 300.00 300.00 100.0%6609080 Collateral Material - - - 630.75 3,500.00 (2,869.25) 9,000.00 8,369.25 93.0%6609102 Contract Services-Web Page 99.00 400.00 (301.00) 1,081.50 2,400.00 (1,318.50) 4,800.00 3,718.50 77.5%6609490 Miscellaneous - 50.00 (50.00) - 100.00 (100.00) 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) 283.62 300.00 (16.38) 600.00 316.38 52.7%6609630 Promotion - 50.00 (50.00) - 150.00 (150.00) 3,500.00 3,500.00 0.0%6609633 Promotion-Community - 750.00 (750.00) - 2,475.00 (2,475.00) 2,925.00 2,925.00 100.0%6609634 Promotion-Media/Vendor - 500.00 (500.00) 1,610.35 2,500.00 (889.65) 700.00 - 0.0%6609150 Dues and Subscriptions - - - 140.00 - 140.00 735.00 595.00 81.0%6609820 Uniforms - 50.00 (50.00) 32.50 400.00 (367.50) 600.00 567.50 94.6%Total-MKT-OTHER EXPENSES 21,471.81 22,152.00 (680.19) 96,328.64 107,187.00 (10,858.36) 216,044.00 120,625.71 55.8%24,515.65 25,866.00 (1,350.35) 122,564.91 131,871.00 (9,306.09) 262,644.00 140,989.44 53.7%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementDecember 2010Annual Budget December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 1,080.00 1,080.00 - 2,160.00 1,080.00 50.0%6701320 Insurance-Group1,458.00 1,458.00 - 8,027.60 8,748.00 (720.40) 17,496.00 9,468.40 54.1%6701325 Insurance-Workers Comp473.94 707.00 (233.06) 3,600.44 4,242.00 (641.56) 8,480.00 4,879.56 57.5%6701720 Salaries 13,416.26 14,833.34 (1,417.08) 84,075.23 89,000.04 (4,924.81) 178,000.00 93,924.77 52.8%6701800 Taxes-Employer Payroll 1,009.46 2,136.00 (1,126.54) 7,069.14 12,816.00 (5,746.86) 25,627.00 18,557.86 72.4%6701880 Wages-Hourly2,381.63 2,319.66 61.97 9,885.40 13,917.96 (4,032.56) 27,835.00 17,949.60 64.5%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 18,919.29 21,634.00 (2,714.71) 113,737.81 129,804.00 (16,066.19) 259,598.00 145,860.19 56.2%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer21.74 400.00 (378.26) 993.95 2,400.00 (1,406.05) 5,200.00 4,206.05 80.9%6703762 Supplies-Office 74.49 100.00 (25.51) 714.22 600.00 114.22 1,200.00 485.78 40.5%6703768 Supplies-Printing & Stationery366.22 400.00 (33.78) 1,157.36 900.00 257.36 3,300.00 2,142.64 64.9%Total-G&A-SUPPLIES & MATERIALS 462.45 900.00 (437.55) 2,865.53 3,900.00 (1,034.47) 9,700.00 6,834.47 70.5%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) - 500.00 (500.00) 1,100.00 1,100.00 100.0%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) - 500.00 (500.00) 1,100.00 1,100.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 2,400.00 2,400.00 - 4,800.00 2,400.00 50.0%6709150 Dues & Subscriptions- 200.00 (200.00) 371.71 550.00 (178.29) 1,700.00 1,328.29 78.1%6709180 Employee Recruiting/Relocation112.00 200.00 (88.00) 420.00 800.00 (380.00) 1,400.00 980.00 70.0%6709197 Equipment Rental634.55 480.00 154.55 3,777.69 2,880.00 897.69 5,760.00 1,982.31 34.4%6709202 Fees-Bank62.06 90.00 (27.94) 427.35 540.00 (112.65) 1,080.00 652.65 60.4%6709208 Fees-Payroll Processing1,140.76 760.00 380.76 7,016.14 4,560.00 2,456.14 9,120.00 2,103.86 23.1%6709220 Freight/Delivery- 50.00 (50.00) - 300.00 (300.00) 600.00 600.00 100.0%6709490 Miscellaneous - 100.00 (100.00) 186.84 600.00 (413.16) 1,200.00 1,013.16 84.4%6709620 Postage/Mail Services 66.83 75.00 (8.17) 629.22 450.00 179.22 900.00 270.78 30.1%6709625 Professional Fees3,249.25 850.00 2,399.25 8,164.25 5,100.00 3,064.25 10,200.00 2,035.75 20.0%6709636 Promotion/Entertainment2,085.00 2,000.00 85.00 2,085.00 2,500.00 (415.00) 3,100.00 1,015.00 32.7%6709722 Seminars & Training110.00 200.00 (90.00) 360.00 1,200.00 (840.00) 2,400.00 2,040.00 85.0%6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms - 75.00 (75.00) 344.96 600.00 (255.04) 1,050.00 705.04 67.1%Total-G&A-OTHER EXPENSES 7,860.45 5,480.00 2,380.45 26,183.16 22,580.00 3,603.16 44,410.00 18,226.84 41.0%27,242.19 28,114.00 (871.81) 142,786.50 156,784.00 (13,997.50) 314,808.00 172,021.50 54.6%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementDecember 2010Annual Budget December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 12,551.27 13,000.00 (448.73) 52,158.74 72,324.00 (20,165.26) 150,324.00 98,165.26 65.3%6800194 Equipment Leases-Trailer 540.00 600.00 (60.00) 3,220.00 3,600.00 (380.00) 7,200.00 3,980.00 55.3%6800196 Equipment Leases-GPS 4,940.00 8,636.00 (3,696.00) 44,650.00 51,816.00 (7,166.00) 90,216.00 45,566.00 50.5%6800197 Equipment Leases-Others 2,170.83 - 2,170.83 12,655.67 - 12,655.67 - - 0.0%20,202.10 22,236.00 (2,033.90) 112,684.41 127,740.00 (15,055.59) 247,740.00 147,711.26 59.6%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,643.14 8,115.00 528.14 61,562.85 77,457.00 (15,894.15) 90,000.00 28,437.15 31.6%6900210 FF&E Reserve 5,202.83 5,378.00 (175.17) 18,615.74 19,963.00 (1,347.26) 62,229.00 43,613.26 70.1%6900800 Personal Property Taxes - - - 11,840.62 13,570.00 (1,729.38) 13,570.00 1,729.38 12.7%6900323 Insurance-Commercial 2,615.10 2,200.00 415.10 13,068.72 13,200.00 (131.28) 26,400.00 13,331.28 50.5%16,461.07 15,693.00 768.07 105,087.93 124,190.00 (19,102.07) 192,199.00 87,111.07 45.3%Silverrock ResortOperating Leases & Miscellaneous Other Expense StatementDecember 2010Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSES 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 CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf000000 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2010-2011December 2010 Date Time Description CategoryPlayers12/23/2010 10:00 Gino LaMont Sales 4