Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
04 November 2010 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2010 – November 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 November Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue 346,152.60 350,831.00 (4,678.40) -1.3% 670,644.60 729,283.00 (58,638.40) 3,111,458.00 2,440,813.40 22%401000 Miscellaneous Golf Revenue 17,018.00 12,925.00 4,093.00 31.7% 31,574.30 37,616.00 (6,041.70) 117,656.00 86,081.70 27%410000 Revenue-Golf Shop 29,958.15 30,825.00 (866.85) -2.8% 62,548.78 68,011.00 (5,462.22) 306,492.00 243,943.22 20%420000 Revenue-F&B Concession 1,500.00 1,500.00 - 0.0% 4,500.00 4,500.00 - 12,000.00 7,500.00 38%890000 Interest Income 4.80 - 4.80 0.0% 25.70 - 25.70 - (25.70) 0%Total Income394,633.55 396,081.00 (1,447.45) -0.4% 769,293.38 839,410.00 (70,116.62) 3,547,606.00 2,778,312.62 22%Cost of Goods Sold510000 COS-Golf Shop 16,108.32 16,359.75 (251.43) 1.5% 33,838.64 36,096.05 2,257.41 162,670.60 128,831.96 21%Total COS16,108.32 16,359.75 (251.43) 1.5% 33,838.64 36,096.05 2,257.41 162,670.60 128,831.96 21%Gross Profit378,525.23 379,721.25 (1,196.02) -0.3% 735,454.74 803,313.95 (67,859.21) 3,384,935.40 2,649,480.66 22%Expenses610000 Golf Pro Shop 16,177.84 20,326.00 4,148.16 20.4% 71,397.62 86,365.00 14,967.38 230,213.00 158,815.38 31%630000 Course Maintenance 115,036.02 120,427.00 5,390.98 4.5% 737,585.25 758,502.00 20,916.75 1,541,961.00 804,375.75 48%633000 Maintenance Water & Energy 5,255.81 6,255.00 999.19 16.0% 39,956.08 42,835.00 2,878.92 85,358.00 45,401.92 47%640000 Outside Services 31,432.49 31,690.00 257.51 0.8% 102,162.67 112,674.00 10,511.33 297,478.00 195,315.33 34%650000 Clubhouse 11,887.36 10,636.00 (1,251.36) -11.8% 59,847.53 54,280.00 (5,567.53) 132,232.00 72,384.47 45%660000 Marketing 25,156.52 26,316.00 1,159.48 4.4% 98,049.26 106,005.00 7,955.74 262,644.00 164,594.74 37%670000 General & Administrative22,822.79 25,839.00 3,016.21 11.7% 115,294.05 128,670.00 13,375.95 314,808.00 199,513.95 37%680000 Leases 17,790.86 22,236.00 4,445.14 20.0% 92,482.31 105,504.00 13,021.69 247,740.00 155,257.69 37%690000 Miscellaneous Other Expense (4,830.83) 6,519.00 11,349.83 174.1% 88,626.86 108,497.00 19,870.14 192,199.00 103,572.14 46%Total Expenses240,728.86 270,244.00 29,515.14 10.9% 1,405,401.63 1,503,332.00 97,930.37 3,304,633.00 1,899,231.37 43%137,796.37 109,477.25 28,319.12 25.9%(669,946.89) (700,018.05) 30,071.16 80,302.40 750,249.29 -834%Rounds of Golf PlayedPaid Rounds Played 4,757 4,500 257 5.7% 13,311 13,427 (116) 39,150 25,839 34%Ave $ Per Paid Round Green Fee 72.77 77.96 (5.20) -6.7% 50.38 54.31 (3.93) 76.13 25.75 66%Ave $ Per Paid Round Merchandise 6.30 6.85 (0.55) -8.1% 4.70 5.07 (0.37) 8.07 3.37 58%Ave $ Per Paid Miscellaneous 3.58 2.87 0.71 24.6% 2.37 2.80 (0.43) 2.06 - 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to Date Year to DateNovember 20101 Income November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees 346,152.60 350,831.00 (4,678.40) 670,644.60 729,283.00 (58,638.40) 3,111,458.002,440,813.4022%4010000 Rider Fee 775.00 450.00 325.00 3,450.00 3,657.00 (207.00) 6,522.003,072.0053%4040000 Club Rental 2,775.00 2,475.00 300.00 6,165.00 7,384.00 (1,219.00) 28,004.0021,839.0022%4050000 Driving Range 8,968.00 4,500.00 4,468.00 15,633.00 14,075.00 1,558.00 48,130.0032,497.0032%4080000 GPS Advertising - 2,000.00 (2,000.00) - 7,000.00 (7,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,500.00 3,500.00 1,000.00 4,500.00 3,500.00 1,000.00 19,000.00 14,500.00 24%4092000 Golf Lessons - - - - - - - - 0% Total Revenue Fees 363,170.60 363,756.00 (585.40) 702,218.90 766,899.00 (64,680.10) 3,229,114.00 2,526,895.10 22%363,170.60 363,756.00 (585.40) 702,218.90 766,899.00 (64,680.10) 3,229,114.00 2,526,895.10 22%Total IncomeMonth to Date Year to Date Annual BudgetSilverRock ResortStatement of Fees RevenueNovember 20102 Income November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 912.50 - 912.50 1,645.02 - 1,645.02 0 0 0%4100110 Sales Hard Goods 11,259.20 10,789.00 470.20 26,940.83 23,804.00 3,136.83 107,272.00 80,331.17 25%4100112 Sales-Soft Goods 20,281.68 20,036.00 245.68 41,887.10 44,207.00 (2,319.90) 199,220.00 157,332.90 21%5100639 GS-Discounts-Mdse (2,495.23) - (2,495.23) (7,924.17) - (7,924.17) - 7,924.17 0% Total Revenue Golf Shop 29,958.15 30,825.00 (866.85) 62,548.78 68,011.00 (5,462.22) 306,492.00 245,588.24 20%COS 5100150 COS-GS-Hard Goods 5,827.32 5,933.95 (106.63) 14,130.99 13,092.20 1,038.79 58,999.60 44,868.61 24%5100151 COS-GS-Soft Goods 8,689.06 11,019.80 (2,330.74) 18,560.53 24,313.85 (5,753.32) 109,571.00 91,010.47 17%5100152 COS-GS-Purchase Disc (261.76) (848.00) 586.24 (1,009.14) (1,870.00) 860.86 (8,429.00) (7,419.86) -12%5100220 COS-GS-Freight Merch 1,853.70 254.00 1,599.70 2,156.26 560.00 1,596.26 2,529.00 372.74 85%Cost of Sales - Golf Shop 16,108.32 16,359.75 (251.43) 33,838.64 36,096.05 (2,257.41) 162,670.60 128,831.96 21%Gross Profit 13,849.83 14,465.25 (615.42) 28,710.14 31,914.95 (3,204.81) 143,821.40 116,756.28 19%COS % 53.8% 53.1% -0.7% 54.1% 53.1% -1.0% 53.1% 52.5% 1%Expense61-PS-SALARIES & BENEFITS6101175 Employee Meals 480.00 480.00 - 2,100.00 2,100.00 - 5,400.00 3,300.00 39%6101320 Insurance Group 2,317.00 2,317.00 - 10,868.72 10,592.00 276.72 26,811.00 15,942.28 41%6101325 Insurance-Workers Comp 423.61 567.00 (143.39) 1,840.81 2,267.00 (426.19) 6,131.00 4,290.19 30%6101720 Salaries 3,545.46 3,750.00 (204.54) 18,089.42 18,750.00 (660.58) 45,000.00 26,910.58 40%6101800 Taxes-Employer Payroll 773.58 1,714.00 (940.42) 3,381.88 6,849.00 (3,467.12) 18,528.00 15,146.12 18%6101880 Wages-Hourly 7,031.21 10,013.00 (2,981.79) 27,809.87 36,257.00 (8,447.13) 103,818.00 76,008.13 27%6101882 Wages-Overtime 13.50 - 13.50 121.15 - 121.15 - 952.88 0%Total -PS-SALARIES & BENEFITS 14,584.36 18,841.00 (4,256.64) 64,211.85 76,815.00 (12,603.15) 205,688.00 142,550.18 31%61-PS OTHER EXPENSES6103742 Supplies-Expendable 189.74 - 189.74 189.74 - 189.74 - (189.74) 0%6103762 Supplies-Office 98.54 500.00 (401.46) 1,823.80 2,500.00 (676.20) 6,000.00 4,176.20 30%6109090 Contract Services 500.00 500.00 - 2,500.00 2,500.00 - 6,000.00 3,500.00 42%6109220 Freight & Delivery 266.38 25.00 241.38 376.49 50.00 326.49 75.00 (301.49) 502%6109490 Miscellaneous - 50.00 (50.00) 104.37 100.00 4.37 450.00 345.63 23%6109150 Dues and Subscriptions - - - - - - 2,300.00 2,300.00 0%6109500 ProShop-Over/Short 5.98 - 5.98 15.34 - 15.34 - (15.34) 0%6109722 Seminars/Training - - - 545.07 3,150.00 (2,604.93) 5,890.00 5,344.93 9%6109810 Travel - Merchandise - - - - - - 90.00 90.00 0%6109820 Uniforms 248.38 300.00 (51.62) 846.65 700.00 146.65 2,400.00 1,553.35 35%6117840 Telephones 284.46 110.00 174.46 784.31 550.00 234.31 1,320.00 535.69 0%Total PS-OTHER EXPENSES 1,593.48 1,485.00 108.48 7,185.77 9,550.00 (2,364.23) 24,525.00 17,339.23 29%16,177.84 20,326.00 (4,148.16) 71,397.62 86,365.00 (14,967.38) 230,213.00 159,889.41 31%Net Income(2,328.01) (5,860.75) 3,532.74 (42,687.48) (54,450.05) 11,762.57 (86,391.60) (43,133.13) -50%Total Expenses-Golf ShopMonth to Date Year to Date Annual BudgetSilverRock ResortGolf Shop Income StatementNovember 20103 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311175 Employee Meals 240.00 240.00 - 1,200.00 1,200.00 - 2,880.00 1,680.00 58.3%6311320 Insurance-Group 8,740.00 8,740.00 - 42,087.69 43,700.00 (1,612.31) 104,880.00 62,792.31 59.9%6311325 Insurance-Workers Comp 2,102.72 2,237.00 (134.28) 11,451.21 11,469.00 (17.79) 27,638.00 16,186.79 58.6%6311720 Salaries 11,001.60 12,583.00 (1,581.40) 57,941.76 62,915.00 (4,973.24) 150,996.00 93,054.24 61.6%6311800 Taxes-Employer Payroll 4,460.69 6,761.00 (2,300.31) 22,933.72 35,088.00 (12,154.28) 84,168.00 61,234.28 72.8%6311880 Wages-Hourly 41,417.26 41,725.00 (307.74) 210,739.47 208,625.00 2,114.47 509,458.00 298,718.53 58.6%6311882 Wages-Overtime 149.08 - 149.08 13,399.11 10,306.00 3,093.11 15,598.00 2,198.89 14.1%Total-CM-SALARIES & BENEFITS68,111.35 72,286.00 (4,174.65) 359,752.96 373,303.00 (13,550.04) 895,618.00 535,865.04 59.8%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 2,459.86 2,700.00 (240.14) 18,958.96 16,700.00 2,258.96 29,300.00 10,341.04 35.3%6313744 Fertilizer 4,179.40 4,500.00 (320.60) 52,195.01 57,400.00 (5,204.99) 89,400.00 37,204.99 41.6%6313745 Herbicides 5,136.30 5,000.00 136.30 12,221.59 12,000.00 221.59 12,000.00 (221.59) -1.8%6313746 Flowers/Plants - - - 1,253.89 1,250.00 3.89 3,050.00 1,796.11 58.9%6313748 Fuel-Gasoline 4,155.19 4,180.00 (24.81) 23,835.26 21,630.00 2,205.26 43,100.00 19,264.74 44.7%6313750 Golf Course Accessories 521.26 200.00 321.26 11,409.01 11,100.00 309.01 12,300.00 890.99 7.2%6313756 POA Control 4,002.98 3,500.00 502.98 4,426.61 3,500.00 926.61 7,000.00 2,573.39 36.8%6313758 Miscellaneous Supp 1,599.83 500.00 1,099.83 3,835.19 3,250.00 585.19 4,350.00 514.81 0.0%6313762 Supplies-Office - - - 238.13 - 238.13 - (238.13) 0.0%6313774 Sand 1,944.33 2,000.00 (55.67) 4,334.57 9,780.00 (5,445.43) 11,460.00 7,125.43 62.2%6313776 Seed 239.25 350.00 (110.75) 94,826.63 89,360.00 5,466.63 91,810.00 (3,016.63) -3.3%6313778 Small Tools & Non-Capital Equip 97.89 100.00 (2.11) 4,036.07 4,300.00 (263.93) 5,000.00 963.93 19.3%6313780 Sod - 250.00 (250.00) 3,179.03 1,900.00 1,279.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 & MATERIALS24,336.29 23,280.00 1,056.29 242,467.54 237,170.00 5,297.54 319,720.00 77,252.46 24.2%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,575.00 1,255.00 320.00 9,226.24 11,403.00 (2,176.76) 24,610.00 15,383.76 62.5%6315685 CM-R&M-Bldngs & Othr Structures 413.65 - 413.65 1,090.65 750.00 340.65 1,750.00 659.35 37.7%6315690 CM-R&M-Equipment 1,247.78 1,000.00 247.78 17,259.99 12,000.00 5,259.99 20,500.00 3,240.01 15.8%6315692 CM-R&M-Irrigation System 2,468.62 900.00 1,568.62 9,092.96 9,300.00 (207.04) 16,050.00 6,957.04 43.3%6315696 CM-R&M-Pumps 739.67 1,000.00 (260.33) 5,353.37 5,000.00 353.37 10,500.00 5,146.63 49.0%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 6,444.72 4,155.00 2,289.72 45,518.21 42,503.00 3,015.21 83,460.00 37,941.79 45.5%63-CM-UTILTIES6317836 Utilities-Natural Gas/LPG 22.76 15.00 7.76 116.54 75.00 41.54 180.00 63.46 0.0%6317840 Telephones 1,236.47 850.00 386.47 5,471.14 4,250.00 1,221.14 10,200.00 4,728.86 46.4%Total-CM-UTILITIES 1,259.23 865.00 394.23 5,587.68 4,325.00 1,262.68 10,380.00 4,792.32 46.2%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 500.00 500.00 - 2,500.00 2,500.00 - 6,000.00 3,500.00 58.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 137.88 525.00 (387.12) 2,314.01 2,625.00 (310.99) 6,288.00 3,973.99 0.0%6319150 Dues & Subscriptions 135.00 - 135.00 135.00 - 135.00 540.00 405.00 75.0%6319170 Employee Education - 50.00 (50.00) 70.00 250.00 (180.00) 1,550.00 1,480.00 95.5%6319197 Equipment Rental - 600.00 (600.00) 2,483.75 2,900.00 (416.25) 4,200.00 1,716.25 40.9%6319206 Licenses & Permits 60.00 - 60.00 353.03 280.00 73.03 1,430.00 1,076.97 75.3%6319490 Miscellaneous 158.00 100.00 58.00 602.06 500.00 102.06 1,200.00 597.94 49.8%6319718 Safety Equipment & Training 591.78 500.00 91.78 1,777.76 2,350.00 (572.24) 3,850.00 2,072.24 53.8%6319822 Uniforms 1,398.07 820.00 578.07 5,584.64 4,100.00 1,484.64 9,840.00 4,255.36 43.2%Total-CM-OTHER EXPENSES 2,980.73 3,095.00 (114.27) 17,320.25 17,505.00 (184.75) 38,898.00 21,577.75 55.5%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementNovember 2010Annual Budget4 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,317.00 2,317.00 - 10,676.00 11,585.00 (909.00) 27,804.00 17,128.00 61.6%6321325 Insurance-Workers Comp 328.60 468.00 (139.40) 1,958.65 2,349.00 (390.35) 5,487.00 3,528.35 64.3%6321800 Taxes-Employer Payroll 628.44 1,447.00 (818.56) 3,744.53 7,286.00 (3,541.47) 16,811.00 13,066.47 77.7%6321880 Wages-Hourly 8,204.81 10,813.00 (2,608.19) 46,439.39 54,065.00 (7,625.61) 129,756.00 83,316.61 64.2%6321882 Wages-Overtime 10.12 811.00 (800.88) 2,526.76 4,461.00 (1,934.24) 5,272.00 2,745.24 52.1%Total-CM-LM-SALARIES & BENEFITS11,488.97 15,856.00 (4,367.03) 65,345.33 79,746.00 (14,400.67) 185,130.00 119,784.67 64.7%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools 118.27 100.00 18.27 264.55 500.00 (235.45) 1,025.00 760.45 74.2%6323788 Uniforms 296.46 290.00 6.46 1,203.56 1,450.00 (246.44) 3,480.00 2,276.44 65.4%Total-CM-LM-SUPPLIES & MATERIALS414.73 390.00 24.73 1,468.11 1,950.00 (481.89) 4,505.00 3,036.89 67.4%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 500.00 (500.00) 125.17 2,000.00 (1,874.83) 4,250.00 4,124.83 97.1%Total-CM-LM-REPAIRS & MAINTENANCE - 500.00 (500.00) 125.17 2,000.00 (1,874.83) 4,250.00 4,124.83 97.1%115,036.02 120,427.00 (5,390.98) 737,585.25 758,502.00 (20,916.75) 1,541,961.00 804,375.75 52.2% November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 1,680.96 3,000.00 (1,319.04) 13,145.40 18,300.00 (5,154.60) 42,300.00 29,154.60 68.9%6337842 Utilities-Water3,574.85 3,255.00 319.85 26,810.68 24,535.00 2,275.68 43,058.00 16,247.32 37.7%5,255.81 6,255.00 (999.19) 39,956.08 42,835.00 (2,878.92) 85,358.00 45,401.92 53.2%Total-CM-WATER & ENERGYMonth to Date Year to Date Annual BudgetSilverrock ResortCourse Maintenance Water & EnergyNovember 2010Total-COURSE MAINTENANCESilverrock ResortCourse Maintenance Expense StatementNovember 2010Annual BudgetMonth to Date Year to Date5 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411175 Employee Meals 660.00 660.00 - 2,460.00 2,460.00 - 6,960.00 4,500.00 64.7%6411320 Insurance-Group 662.00 662.00 - 2,706.60 3,310.00 (603.40) 7,944.00 5,237.40 65.9%6411325 Insurance-Workers Comp 422.82 445.00 (22.18) 1,548.03 1,597.00 (48.97) 5,096.00 3,547.97 69.6%6411800 Taxes-Employer Payroll 1,169.60 1,345.00 (175.40) 4,343.40 4,827.00 (483.60) 15,399.00 11,055.60 71.8%6411880 Wages-Hourly 10,515.64 10,802.00 (286.36) 38,530.76 38,775.00 (244.24) 123,689.00 85,158.24 68.8%6411882 Wages-Overtime 54.74 - 54.74 169.68 - 169.68 - (169.68) 0.0%Total-CBR-SALARIES & BENEFITS13,484.80 13,914.00 (429.20) 49,758.47 50,969.00 (1,210.53) 159,088.00 109,329.53 68.7%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 601.77 1,000.00 (398.23) 1,838.80 1,500.00 338.80 2,350.00 511.20 21.8%6413742 Supplies-Expendable 1,898.15 1,800.00 98.15 4,243.12 3,300.00 943.12 6,750.00 2,506.88 37.1%6413752 Supplies-Range Balls 6,900.00 6,000.00 900.00 6,900.00 6,000.00 900.00 6,000.00 (900.00) -15.0%6413762 Supplies-Office 81.93 50.00 31.93 81.93 175.00 (93.07) 525.00 443.07 84.4%6413768 Supplies-Printing and Stationary - - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels - 185.00 (185.00) - 501.00 (501.00) 1,005.00 1,005.00 100.0%6413796 Supplies-Bottled Water1,722.78 50.00 1,672.78 13,785.70 12,200.00 1,585.70 24,500.00 10,714.30 43.7%Total-CBR-SUPPLIES & MATERIALS11,204.63 9,085.00 2,119.63 26,849.55 23,676.00 3,173.55 41,550.00 14,700.45 35.4%641-CBR-REPAIRS & MAINTENANCE6415096 CBR-R&M-Contract Services-Carts - 720.00 (720.00) - 3,600.00 (3,600.00) 8,640.00 8,640.00 100.0%6415690 CBR-R&M-Equipment 90.64 300.00 (209.36) 1,053.26 1,500.00 (446.74) 3,600.00 2,546.74 70.7%6415695 CBR-R&M-Cart Maintenance & Repair - 750.00 (750.00) 2,900.18 3,250.00 (349.82) 5,000.00 2,099.82 42.0%Total-CBR-REPAIRS & MAINTENANCE 90.64 1,770.00 (1,679.36) 3,953.44 8,350.00 (4,396.56) 17,240.00 13,286.56 77.1%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 1,067.51 800.00 267.51 5,009.63 4,000.00 1,009.63 9,600.00 4,590.37 47.8%6419220 Freight/Delivery - 75.00 (75.00) 78.96 375.00 (296.04) 450.00 371.04 82.5%6419490 Miscellaneous 251.10 75.00 176.10 292.37 425.00 (132.63) 1,150.00 857.63 74.6%6419820 Uniforms 259.14 500.00 (240.86) 2,006.52 2,500.00 (493.48) 5,200.00 3,193.48 61.4%Total-CBR-OTHER EXPENSES 1,577.75 1,450.00 127.75 7,387.48 7,300.00 87.48 16,400.00 9,012.52 55.0%TOTAL-CARTS,BAGROOM & RANGE 26,357.82 26,219.00 138.82 87,948.94 90,295.00 (2,346.06) 234,278.00 146,329.06 62.5%643-CS-SALARIES & BENEFITS6431175 Employee Meals 300.00 300.00 - 1,020.00 1,020.00 - 3,420.00 2,400.00 70.2%6431325 Insurance-Workers Comp 154.12 173.00 (18.88) 411.92 455.00 (43.08) 1,738.00 1,326.08 76.3%6431800 Taxes-Employer Payroll 502.35 523.00 (20.65) 1,380.51 1,375.00 5.51 5,251.00 3,870.49 73.7%6431880 Wages-Hourly 3,820.00 4,200.00 (380.00) 10,256.00 17,679.00 (7,423.00) 48,816.00 38,560.00 79.0%6431882 Wages-Overtime 33.00 - 33.00 42.00 - 42.00 - (42.00) 0.0%Total-CS-SALARIES & BENEFITS4,809.47 5,196.00 (386.53) 13,110.43 20,529.00 (7,418.57) 59,225.00 46,114.57 77.9%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) - 400.00 (400.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous 11.15 50.00 (38.85) 11.15 100.00 (88.85) 200.00 188.85 94.4%6439718 Safety Equipment & Training 254.05 50.00 204.05 254.05 250.00 4.05 600.00 345.95 57.7%6439820 Uniforms - 75.00 (75.00) 838.10 1,100.00 (261.90) 2,125.00 1,286.90 60.6%Total-CS-OTHER EXPENSES 265.20 275.00 (9.80) 1,103.30 1,850.00 (746.70) 3,975.00 2,871.70 72.2%Total-COURSE SERVICES 5,074.67 5,471.00 (396.33) 14,213.73 22,379.00 (8,165.27) 63,200.00 48,986.27 77.5%31,432.49 31,690.00 (257.51) 102,162.67 112,674.00 (10,511.33) 297,478.00 192,443.63 64.7%TOTAL OUTSIDE SERVICESMonth to Date Year to DateSilverRock ResortOutside Services Expense StatementNovember 2010Annual Budget6 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable942.01 400.00 542.01 1,654.51 2,000.00 (345.49) 4,800.00 3,145.49 65.5%Total-CH-SUPPLIES & MATERIALS 942.01 400.00 542.01 1,654.51 2,000.00 (345.49) 4,800.00 3,145.49 65.5%65-CH-UTILITIES6507836 Utilities-Natural Gas349.14 300.00 49.14 1,487.43 1,500.00 (12.57) 3,600.00 2,112.57 58.7%6507840 Utilities-Telephone1,038.98 1,150.00 (111.02) 5,245.80 5,750.00 (504.20) 13,800.00 8,554.20 62.0%6507842 Utilities-Water179.75 321.00 (141.25) 6,869.60 1,605.00 5,264.60 3,852.00 (3,017.60) -78.3%6507844 Utilities-Cable336.49 340.00 (3.51) 1,682.45 1,700.00 (17.55) 4,080.00 2,397.55 58.8%Total-CH-UTILITIES 1,904.36 2,111.00 (206.64) 15,285.28 10,555.00 4,730.28 25,332.00 10,046.72 39.7%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,900.00 1,825.00 75.00 9,200.00 9,725.00 (525.00) 22,500.00 13,300.00 59.1%6509099 Contract Services-Security4,604.94 4,900.00 (295.06) 25,722.18 24,500.00 1,222.18 60,400.00 34,677.82 57.4%6509215 Flowers & Decorations- - - - 500.00 (500.00) 2,400.00 2,400.00 100.0%6509490 Miscellaneous338.07 200.00 138.07 1,229.78 1,000.00 229.78 2,400.00 1,170.22 48.8%6509718 Safety Equipment & Training- 100.00 (100.00) - 500.00 (500.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES 6,843.01 7,025.00 (181.99) 36,151.96 36,225.00 (73.04) 88,900.00 52,748.04 59.3%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures396.50 300.00 96.50 2,645.50 1,500.00 1,145.50 3,600.00 954.50 26.5%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 1,164.77 2,000.00 (835.23) 4,800.00 3,635.23 75.7%6515690 CH-R&M-Equipment Repair1,801.48 400.00 1,401.48 2,945.51 2,000.00 945.51 4,800.00 1,854.49 38.6%Total-CH-REPAIRS & MAINTENANCE 2,197.98 1,100.00 1,097.98 6,755.78 5,500.00 1,255.78 13,200.00 6,444.22 48.8%11,887.36 10,636.00 1,251.36 59,847.53 54,280.00 5,567.53 132,232.00 12,888.44 9.7%Total CLUBHOUSEMonth to Date Year to DateSilverRock ResortClubhouse Expense StatementNovember 2010Annual Budget7 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601175 Employee Meals 60.00 60.00 - 300.00 300.00 - 720.00 420.00 58.3%6601320 Insurance-Group 331.00 331.00 - 1,594.60 1,655.00 (60.40) 3,972.00 2,377.40 59.9%6601325 Insurance-Workers Comp 101.10 103.00 (1.90) 551.10 515.00 36.10 1,240.00 688.90 55.6%6601720 Salaries 2,500.00 2,508.00 (8.00) 13,750.00 12,540.00 1,210.00 30,096.00 16,346.00 54.3%6601800 Taxes-Employer Payroll 311.00 312.00 (1.00) 1,710.50 1,560.00 150.50 3,747.00 2,036.50 54.4%Total-MKT-SALARIES & BENEFITS 3,303.10 3,314.00 (10.90) 17,906.20 16,570.00 1,336.20 39,775.00 21,868.80 55.0%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 52.81 500.00 (447.19) 1,200.00 1,147.19 95.6%6603768 Supplies-Printing & Stationery 111.69 200.00 (88.31) 4,975.26 3,400.00 1,575.26 4,425.00 (550.26) -12.4%111.69 300.00 (188.31) 5,028.07 3,900.00 1,128.07 5,625.00 596.93 10.6%66-MKT-UTILITIES6607840 Utilities-Telephone 49.49 100.00 (50.51) 258.16 500.00 (241.84) 1,200.00 941.84 78.5%Total-MKT-UTILITIES 49.49 100.00 (50.51) 258.16 500.00 (241.84) 1,200.00 941.84 78.5%66-MKT-OTHER EXPENSES6609010 Advertising 19,641.94 19,227.00 414.94 71,177.11 74,935.00 (3,757.89) 192,534.00 121,356.89 63.0%6609040 Business Meals - 25.00 (25.00) - 125.00 (125.00) 300.00 300.00 100.0%6609080 Collateral Material 308.45 1,000.00 (691.55) 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) 982.50 2,000.00 (1,017.50) 4,800.00 3,817.50 79.5%6609490 Miscellaneous - 50.00 (50.00) - 50.00 (50.00) 350.00 350.00 100.0%6609620 Postage - 50.00 (50.00) 283.62 250.00 33.62 600.00 316.38 52.7%6609630 Promotion - 50.00 (50.00) - 100.00 (100.00) 3,500.00 3,500.00 0.0%6609633 Promotion-Community - 750.00 (750.00) - 1,725.00 (1,725.00) 2,925.00 2,925.00 100.0%6609634 Promotion-Media/Vendor 1,610.35 1,000.00 610.35 1,610.35 2,000.00 (389.65) 700.00 - 0.0%6609150 Dues and Subscriptions - - - 140.00 - 140.00 735.00 595.00 81.0%6609820 Uniforms 32.50 50.00 (17.50) 32.50 350.00 (317.50) 600.00 567.50 94.6%Total-MKT-OTHER EXPENSES 21,692.24 22,602.00 (909.76) 74,856.83 85,035.00 (10,178.17) 216,044.00 142,097.52 65.8%25,156.52 26,316.00 (1,159.48) 98,049.26 106,005.00 (7,955.74) 262,644.00 165,505.09 63.0%Total-MARKETINGMonth to Date Year to DateSilverRock ResortMarketing Expense StatementNovember 2010Annual Budget8 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701175 Employee Meals 180.00 180.00 - 900.00 900.00 - 2,160.00 1,260.00 58.3%6701320 Insurance-Group1,458.00 1,458.00 - 6,569.60 7,290.00 (720.40) 17,496.00 10,926.40 62.5%6701325 Insurance-Workers Comp619.88 707.00 (87.12) 3,126.50 3,535.00 (408.50) 8,480.00 5,353.50 63.1%6701720 Salaries 13,416.26 14,833.34 (1,417.08) 70,658.97 74,166.70 (3,507.73) 178,000.00 107,341.03 60.3%6701800 Taxes-Employer Payroll 1,185.52 2,136.00 (950.48) 6,059.68 10,680.00 (4,620.32) 25,627.00 19,567.32 76.4%6701880 Wages-Hourly2,080.75 2,319.66 (238.91) 7,503.77 11,598.30 (4,094.53) 27,835.00 20,331.23 73.0%6701882 Wages-Overtime - - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 18,940.41 21,634.00 (2,693.59) 94,818.52 108,170.00 (13,351.48) 259,598.00 164,779.48 63.5%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer108.73 400.00 (291.27) 972.21 2,000.00 (1,027.79) 5,200.00 4,227.79 81.3%6703762 Supplies-Office 198.92 100.00 98.92 639.73 500.00 139.73 1,200.00 560.27 46.7%6703768 Supplies-Printing & Stationery- 100.00 (100.00) 791.14 500.00 291.14 3,300.00 2,508.86 76.0%Total-G&A-SUPPLIES & MATERIALS 307.65 600.00 (292.35) 2,403.08 3,000.00 (596.92) 9,700.00 7,296.92 75.2%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) - 400.00 (400.00) 1,100.00 1,100.00 100.0%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) - 400.00 (400.00) 1,100.00 1,100.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance400.00 400.00 - 2,000.00 2,000.00 - 4,800.00 2,800.00 58.3%6709150 Dues & Subscriptions- 50.00 (50.00) 371.71 350.00 21.71 1,700.00 1,328.29 78.1%6709180 Employee Recruiting/Relocation28.00 200.00 (172.00) 308.00 600.00 (292.00) 1,400.00 1,092.00 78.0%6709197 Equipment Rental508.81 480.00 28.81 3,143.14 2,400.00 743.14 5,760.00 2,616.86 45.4%6709202 Fees-Bank135.25 90.00 45.25 365.29 450.00 (84.71) 1,080.00 714.71 66.2%6709208 Fees-Payroll Processing1,066.33 760.00 306.33 5,875.38 3,800.00 2,075.38 9,120.00 3,244.62 35.6%6709220 Freight/Delivery- 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0%6709490 Miscellaneous - 100.00 (100.00) 186.84 500.00 (313.16) 1,200.00 1,013.16 84.4%6709620 Postage/Mail Services 244.84 75.00 169.84 562.39 375.00 187.39 900.00 337.61 37.5%6709625 Professional Fees941.50 850.00 91.50 4,915.00 4,250.00 665.00 10,200.00 5,285.00 51.8%6709636 Promotion/Entertainment- 100.00 (100.00) - 500.00 (500.00) 3,100.00 3,100.00 100.0%6709722 Seminars & Training250.00 200.00 50.00 250.00 1,000.00 (750.00) 2,400.00 2,150.00 89.6%6709810 Travel - - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms - 150.00 (150.00) 94.70 525.00 (430.30) 1,050.00 955.30 91.0%Total-G&A-OTHER EXPENSES 3,574.73 3,505.00 69.73 18,072.45 17,100.00 972.45 44,410.00 26,337.55 59.3%22,822.79 25,839.00 (3,016.21) 115,294.05 128,670.00 (13,375.95) 314,808.00 199,513.95 63.4%Total-GENERAL & ADMINISTRATIVEMonth to Date Year to DateSilverRock ResortGeneral & Administrative Expense StatementNovember 2010Annual Budget9 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 7,260.77 13,000.00 (5,739.23) 39,607.47 59,324.00 (19,716.53) 150,324.00 110,716.53 73.7%6800194 Equipment Leases-Trailer 540.00 600.00 (60.00) 2,680.00 3,000.00 (320.00) 7,200.00 4,520.00 62.8%6800196 Equipment Leases-GPS 7,942.00 8,636.00 (694.00) 39,710.00 43,180.00 (3,470.00) 90,216.00 50,506.00 56.0%6800197 Equipment Leases-Others 2,048.09 - 2,048.09 10,484.84 - 10,484.84 - - 0.0%17,790.86 22,236.00 (4,445.14) 92,482.31 105,504.00 (13,021.69) 247,740.00 165,742.53 66.9%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee (12,765.19) (2,698.00) (10,067.19) 52,919.71 69,342.00 (16,422.29) 90,000.00 37,080.29 41.2%6900210 FF&E Reserve 6,923.06 7,017.00 (93.94) 13,412.91 14,585.00 (1,172.09) 62,229.00 48,816.09 78.4%6900800 Personal Property Taxes - - - 11,840.62 13,570.00 (1,729.38) 13,570.00 1,729.38 12.7%6900323 Insurance-Commercial 1,011.30 2,200.00 (1,188.70) 10,453.62 11,000.00 (546.38) 26,400.00 15,946.38 60.4%(4,830.83) 6,519.00 (11,349.83) 88,626.86 108,497.00 (19,870.14) 192,199.00 103,572.14 53.9%Annual BudgetMonth to Date Year to DateTotal-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementNovember 201010 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2010-20112010 2010 2010 2010 2010 2010Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMediaSales4PromotionGolf Industry85 4VIPCelebrityPGA Comp68 72 76 30Charity/Gift Certificate12 44Rain/Wind Checks34 4Club Staff77 68 96 3 69LQ HS Golf20153 148 208 3 155 02011 2011 2011 2011 2011 2011Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000011 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2010-2011November 2010 Date Time Description CategoryPlayers11/26/2010 12:15 Tee it up Radio Sales 412