Loading...
06 December 2014 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2014 – December 2014 TABLE OF CONTENTS Summary Operating Income Expense 1 Statement of Fee Revenue 2 Variance Report 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 Revenue295,458.96 288,794.00 6,664.96 2.3% 733,448.24 696,761.00 36,687.24 3,043,760.00 2,310,311.76 24%401000 Miscellaneous Golf Revenue44,453.50 38,600.00 5,853.50 15.2% 126,360.40 106,635.00 19,725.40 430,315.00 303,954.60 29%410000 Revenue-Golf Shop22,417.85 25,625.00 (3,207.15) -12.5% 63,322.31 66,056.00 (2,733.69) 258,680.00 195,357.69 24%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 Income1.53 - 1.53 0.0%9.07 - 9.07 - (9.07) 0%Total Income363,831.84 354,519.00 9,312.84 2.6% 929,140.02 875,452.00 53,688.02 3,744,755.00 2,815,614.98 25%Cost of Goods Sold510000 COS-Golf Shop12,869.66 14,342.50 (1,472.84) 10.3% 36,214.46 36,970.48 756.02 144,783.40 108,568.94 25%Total COS12,869.66 14,342.50 (1,472.84) 10.3% 36,214.46 36,970.48 756.02 144,783.40 108,568.94 25%Gross Profit350,962.18 340,176.50 10,785.68 3.2% 892,925.56 838,481.52 54,444.04 3,599,971.60 2,707,046.04 25%Expenses610000 Golf Pro Shop 17,675.94 18,467.00 791.06 4.3% 83,557.79 91,015.00 7,457.21 204,190.00 120,632.21 41%630000 Course Maintenance120,940.83 131,089.00 10,148.17 7.7% 912,381.92 967,193.00 (54,811.08) 1,697,652.00 785,270.08 54%633000 Maintenance Water & Energy13,640.50 11,415.00 (2,225.50) -19.5% 95,670.73 107,230.00 (11,559.27) 223,629.00 127,958.27 43%640000 Outside Services30,200.03 29,547.00 (653.03) -2.2% 110,674.43 122,435.00 (11,760.57) 285,234.00 174,559.57 39%650000 Clubhouse11,305.51 10,636.00 (669.51) -6.3% 62,209.12 64,916.00 (2,706.88) 131,732.00 69,522.88 47%660000 Marketing26,695.43 27,024.00 328.57 1.2% 117,118.87 118,633.00 (1,514.13) 239,875.00 122,756.13 49%670000 General & Administrative29,222.13 27,334.00 (1,888.13) -6.9% 151,748.00 155,398.00 (3,650.00) 320,052.00 168,304.00 47%680000 Leases22,577.89 22,550.00 (27.89) -0.1% 112,763.38 111,550.00 1,213.38 246,850.00 134,086.62 46%690000 Miscellaneous Other Expense17,055.89 15,976.00 1,079.89 -6.8% 95,197.19 89,934.00 5,263.19 198,074.00 102,876.81 48%Total Expenses289,314.15 294,038.00 (4,723.85) 1.6% 1,741,321.43 1,828,304.00 86,982.57 3,547,288.00 1,805,966.57 49%61,648.03 46,138.50 15,509.53 33.6%(848,395.87) (989,822.48) 141,426.61 52,683.60 901,079.47 0%Rounds of Golf PlayedPaid Rounds Played4,199 4,100 99 2.4%13,015 11,400 1,615 41,100 28,085 32%Ave $ Per Paid Round Green Fee70.36 70.44 (0.07) -0.1%56.35 61.12 (4.77) 74.06 17.70 76%Ave $ Per Paid Round Merchandise5.34 6.25 (0.91) -14.6%4.87 5.79 (0.93) 6.29 1.43 77%Ave $ Per Paid Miscellaneous 10.59 9.41 1.17 12.4%9.71 9.35 0.35 10.47 0.76 0%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateDecember 20141 Sales and Cost of SalesActualBudgetVariance$44,453.50 $38,600.00 5,853.50Favorable: Due to additional lessons for Professional Fees from Golf Made Simple. Resident Card revenue was up as a result of increased sales/renewals of Resident Cards. *ActualBudgetVariance$22,417.85$25,625.00(3,207.15)Unfavorable: Retail sales continue to be down as a result of consumer behavior in the golf industry. ExpensesActualBudgetVariance$13,640.50 11,415.00 2,225.50Unfavorable: Due to water feature drainage and restart for new season.Pro Shop Merchandise SalesWater & Energyprovided for those cost of sales percentage that are greater than 5%.Misc Golf RevenueVariance ExplanationDecember 2014The explanation of variance from budget shown below provide details of variances by revenue and expensecategories of at least $1,000 that are greater than 10% of the budgeted amounts. Separate explanations are3-20-132 Income December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees295,458.96 288,794.00 6,664.96 733,448.24 696,761.00 36,687.24 3,043,760.00 2,310,311.76 75.9%4010000 Rider Fee1,110.00 1,025.00 85.00 2,675.00 1,755.00 920.00 7,230.00 4,555.00 63.0%4040000 Club Rental2,990.00 2,050.00 940.00 6,810.00 5,700.00 1,110.00 20,550.00 13,740.00 66.9%4050000 Driving Range9,780.00 8,200.00 1,580.00 30,305.00 19,285.00 11,020.00 86,435.00 56,130.00 64.9%4060000 Handicap Fees- - - - - - 2,500.00 2,500.00 100.0%4080000 GPS Advertising- 500.00 (500.00) - 1,400.00 (1,400.00) 2,600.00 2,600.00 100.0%4090000 Ball Retriever/Subcontract 712.50 - 712.50 1,504.40 2,000.00 (495.60) 4,000.00 2,495.60 62.4%4091000 Golf Professional Rental Fee 7,031.00 5,000.00 2,031.00 12,781.00 10,000.00 2,781.00 37,000.00 24,219.00 65.5%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue22,830.00 21,825.00 1,005.00 72,285.00 66,495.00 5,790.00 135,000.00 62,715.00 46.5% Total Revenue Fees339,912.46 327,394.00 12,518.46 859,808.64 803,396.00 56,412.64 3,339,075.00 2,479,266.36 74.3%339,912.46 327,394.00 12,518.46 859,808.64 803,396.00 56,412.64 3,339,075.00 2,479,266.36 74.3%SilverRock ResortStatement of Fees RevenueDecember 2014Total IncomeMonth to DateYear to DateAnnual Budget3 Income December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous 524.00 - 524.00 2,151.51 - 2,151.51 00 0%4100110 Sales Hard Goods6,380.67 8,969.00 (2,588.33) 21,012.24 23,120.00 (2,107.76) 90,538.00 69,525.76 76.8%4100112 Sales-Soft Goods 18,884.00 16,656.00 2,228.00 50,157.00 42,936.00 7,221.00 168,142.00 117,985.00 70.2%5100639 GS-Discounts-Mdse (3,370.82) - (3,370.82) (9,998.44) - (9,998.44) - 9,998.44 0.0% Total Revenue Golf Shop22,417.85 25,625.00 (3,207.15) 63,322.31 66,056.00 (2,733.69) 258,680.00 197,509.20 76.4%COS 5100150 COS-GS-Hard Goods 4,042.56 5,202.02 (1,159.46) 14,390.78 13,409.60 981.18 52,512.04 38,121.26 72.6%5100151 COS-GS-Soft Goods 8,198.50 9,660.48 (1,461.98) 20,451.02 24,902.88 (4,451.86) 97,522.36 77,071.34 79.0%5100152 COS-GS-Purchase Disc (3.24) (743.00) 739.76 (163.65) (1,917.00) 1,753.35 (7,502.00) (7,338.35) 97.8%5100220 COS-GS-Freight Merch 631.84 223.00 408.84 1,536.31 575.00 961.31 2,251.00 714.69 31.7%Cost of Sales - Golf Shop12,869.66 14,342.50 (1,472.84) 36,214.46 36,970.48 (756.02) 144,783.40 108,568.94 75.0%Gross Profit9,548.19 11,282.50 (1,734.31) 27,107.85 29,085.52 (1,977.67) 113,896.60 88,940.26 78.1%COS % 57.4% 56.0% -1.4% 57.2% 56.0% -1.2% 53.1% 55.0% 103.6%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group2,115.00 2,387.00 (272.00) 11,398.10 13,299.00 (1,900.90) 27,621.00 16,222.90 58.7%6101325 Insurance-Workers Comp 427.61 478.00 (50.39) 2,002.56 2,264.00 (261.44) 5,062.00 3,059.44 60.4%6101720 Salaries3,702.40 3,750.00 (47.60) 24,212.32 22,500.00 1,712.32 45,000.00 20,787.68 46.2%6101800 Taxes-Employer Payroll 1,428.81 1,659.00 (230.19) 5,280.40 7,855.00 (2,574.60) 17,562.00 12,281.60 69.9%6101880 Wages-Hourly8,984.42 9,008.00 (23.58) 33,439.36 37,912.00 (4,472.64) 90,070.00 56,630.64 62.9%6101882 Wages-Overtime- - - 86.37 - 86.37 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 16,658.24 17,282.00 (623.76) 76,419.11 83,830.00 (7,410.89) 185,315.00 109,935.14 59.3%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office80.00 250.00 (170.00) 564.01 1,500.00 (935.99) 3,000.00 2,435.99 81.2%6109220 Freight & Delivery- 25.00 (25.00) 610.00 75.00 535.00 75.00 (535.00) -713.3%6109490 Miscellaneous501.51 500.00 1.51 2,951.51 3,000.00 (48.49) 6,000.00 3,048.49 50.8%6109150 Dues and Subscriptions- - - - - - 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short(4.89) - (4.89) 21.23 - 21.23 - (21.23) 0.0%6109722 Seminars/Training- 100.00 (100.00) 407.20 1,050.00 (642.80) 3,690.00 3,282.80 89.0%6109810 Travel - Merchandise- - - - - - 90.00 90.00 100.0%6109820 Uniforms232.10 200.00 32.10 2,051.94 900.00 1,151.94 2,400.00 348.06 14.5%6117840 Telephones208.98 110.00 98.98 532.79 660.00 (127.21) 1,320.00 787.21 59.6%training expenses for the month and miscel 1,017.70 1,185.00 (167.30) 7,138.68 7,185.00 (46.32) 18,875.00 11,736.32 62.2%17,675.94 18,467.00 (791.06) 83,557.79 91,015.00 (7,457.21) 204,190.00 121,671.46 59.6%Net Income(8,127.75) (7,184.50) (943.25) (56,449.94) (61,929.48) 5,479.54 (90,293.40) (32,731.20) 36.2%SilverRock ResortGolf Shop Income StatementDecember 2014Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group8,000.00 8,990.00 (990.00) 51,116.62 53,940.00 (2,823.38) 107,880.00 56,763.38 52.6%6311325 Insurance-Workers Comp2,855.27 2,181.00 674.27 16,568.52 12,049.00 4,519.52 24,794.00 8,225.48 33.2%6311720 Salaries10,620.80 11,001.60 (380.80) 65,035.20 66,009.60 (974.40) 132,019.20 66,984.00 50.7%6311800 Taxes-Employer Payroll3,763.00 7,562.00 (3,799.00) 25,623.76 42,226.00 (16,602.24) 86,638.00 61,014.24 70.4%6311880 Wages-Hourly45,520.48 47,165.40 (1,644.92) 243,042.55 248,285.40 (5,242.85) 518,478.80 275,436.25 53.1%6311882 Wages-Overtime28.66 - 28.66 6,198.39 10,526.00 (4,327.61) 15,945.00 9,746.61 61.1%Total-CM-SALARIES & BENEFITS70,788.21 76,900.00 (6,111.79) 407,585.04 433,036.00 (25,450.96) 885,755.00 478,169.96 54.0%63-CM-SUPPLIES & MATERIALS6313734 Chemicals2,937.93 2,200.00 737.93 23,709.58 22,700.00 1,009.58 34,600.00 10,890.42 31.5%6313744 Fertilizer8,711.17 9,000.00 (288.83) 65,364.34 70,000.00 (4,635.66) 112,500.00 47,135.66 41.9%6313745 Herbicides5,022.00 5,000.00 22.00 23,416.62 17,000.00 6,416.62 17,000.00 (6,416.62) -37.7%6313746 Flowers/Plants436.32 750.00 (313.68) 481.38 2,000.00 (1,518.62) 3,050.00 2,568.62 84.2%6313748 Fuel-Gasoline1,912.21 4,200.00 (2,287.79) 25,993.62 33,200.00 (7,206.38) 55,020.00 29,026.38 52.8%6313750 Golf Course Accessories1,227.80 1,200.00 27.80 13,207.57 12,300.00 907.57 13,000.00 (207.57) -1.6%6313756 POA Control240.96 - 240.96 2,987.93 3,500.00 (512.07) 7,000.00 4,012.07 57.3%6313758 Miscellaneous Supp694.65 500.00 194.65 6,611.16 3,750.00 2,861.16 4,350.00 (2,261.16) -52.0%6313762 Supplies-Office- - - - - - - - 0.0%6313774 Sand348.30 800.00 (451.70) 5,348.30 12,580.00 (7,231.70) 13,460.00 8,111.70 60.3%6313776 Seed- 350.00 (350.00) 132,291.96 123,800.00 8,491.96 125,900.00 (6,391.96) -5.1%6313778 Small Tools & Non-Capital Equip 13.05 100.00 (86.95) 4,300.70 4,400.00 (99.30) 5,000.00 699.30 14.0%6313780 Sod- 250.00 (250.00) 4,473.08 9,250.00 (4,776.92) 10,450.00 5,976.92 57.2%6313782 Topdressing- - - 768.75 8,000.00 (7,231.25) 10,600.00 9,831.25 92.7%Total-CM-SUPPLIES & MATERIALS21,544.39 24,350.00 (2,805.61) 308,954.99 322,480.00 (13,525.01) 411,930.00 102,975.01 25.0%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 3,260.00 2,600.00 660.00 16,980.00 15,600.00 1,380.00 31,200.00 14,220.00 45.6%6315685 CM-R&M-Bldngs & Othr Structures 98.27 500.00 (401.73) 2,169.85 4,050.00 (1,880.15) 5,550.00 3,380.15 60.9%6315690 CM-R&M-Equipment2,258.44 3,000.00 (741.56) 26,529.95 24,500.00 2,029.95 40,000.00 13,470.05 33.7%6315692 CM-R&M-Irrigation System1,126.28 550.00 576.28 9,199.67 12,850.00 (3,650.33) 19,050.00 9,850.33 51.7%6315696 CM-R&M-Pumps- 1,000.00 (1,000.00) 4,934.42 6,000.00 (1,065.58) 10,500.00 5,565.58 53.0%6315815 CM-R&M-Trees-Pruning Etc- - - 5,770.00 6,050.00 (280.00) 12,050.00 6,280.00 52.1%Total-CM-REPAIRS & MAINTENANCE6,742.99 7,650.00 (907.01) 65,583.89 69,050.00 (3,466.11) 118,350.00 52,766.11 44.6%6317836 Utilities-Natural Gas/LPG30.51 15.00 15.51 134.38 90.00 44.38 180.00 45.62 0.0%6317840 Telephones1,436.89 850.00 586.89 6,117.22 5,100.00 1,017.22 10,200.00 4,082.78 40.0%Total-CM-UTILITIES1,467.40 865.00 602.40 6,251.60 5,190.00 1,061.60 10,380.00 4,128.40 39.8%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance500.00 500.00 - 3,000.00 3,000.00 - 6,000.00 3,000.00 50.0%6319100 Contract Svcs-Soil/Tissue Test- - - 2,000.00 2,000.00 - 4,000.00 2,000.00 50.0%6319102 Contract Svcs-Trash Removal 752.46 524.00 228.46 4,514.76 3,144.00 1,370.76 6,288.00 1,773.24 28.2%6319150 Dues & Subscriptions344.00 - 344.00 986.20 - 986.20 540.00 (446.20) -82.6%6319170 Employee Education- 50.00 (50.00) 69.00 300.00 (231.00) 1,550.00 1,481.00 95.5%6319197 Equipment Rental183.00 200.00 (17.00) 915.57 2,300.00 (1,384.43) 3,400.00 2,484.43 73.1%6319206 Licenses & Permits- - - 487.86 280.00 207.86 4,180.00 3,692.14 88.3%6319490 Miscellaneous- 100.00 (100.00) 325.61 600.00 (274.39) 1,200.00 874.39 72.9%6319718 Safety Equipment & Training392.24 400.00 (7.76) 2,526.32 2,750.00 (223.68) 3,850.00 1,323.68 34.4%6319822 Uniforms850.17 920.00 (69.83) 5,021.51 5,520.00 (498.49) 11,040.00 6,018.49 54.5%Total-CM-OTHER EXPENSES3,021.87 2,694.00 327.87 19,846.83 19,894.00 (47.17) 42,048.00 22,201.17 52.8%Month to DateYear to DatefCourse Maintenance Expense StatementDecember 2014Annual Budget5 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,205.00 2,728.00 (523.00) 13,435.55 16,368.00 (2,932.45) 32,736.00 19,300.45 59.0%6321325 Insurance-Workers Comp616.52 483.00 133.52 2,730.06 3,031.00 (300.94) 5,953.00 3,222.94 54.1%6321800 Taxes-Employer Payroll1,181.46 1,674.00 (492.54) 8,417.21 10,736.00 (2,318.79) 20,906.00 12,488.79 59.7%6321880 Wages-Hourly13,184.61 12,880.00 304.61 75,370.22 77,280.00 (1,909.78) 154,560.00 79,189.78 51.2%6321882 Wages-Overtime- - - 2,609.09 5,313.00 (2,703.91) 6,279.00 3,669.91 58.4%Total-CM-LM-SALARIES & BENEFITS17,187.59 17,765.00 (577.41) 102,562.13 112,728.00 (10,165.87) 220,434.00 117,871.87 53.5%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 75.00 (75.00) - 575.00 (575.00) 1,025.00 1,025.00 100.0%6323788 Uniforms188.38 290.00 (101.62) 1,181.14 1,740.00 (558.86) 3,480.00 2,298.86 66.1%Total-CM-LM-SUPPLIES & MATERIALS188.38 365.00 (176.62) 1,181.14 2,315.00 (1,133.86) 4,505.00 3,323.86 73.8%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 500.00 (500.00) 416.30 2,500.00 (2,083.70) 4,250.00 3,833.70 90.2%Total-CM-LM-REPAIRS & MAINTENANCE- 500.00 (500.00) 416.30 2,500.00 (2,083.70) 4,250.00 3,833.70 90.2%120,940.83 131,089.00 (10,148.17) 912,381.92 967,193.00 (54,811.08) 1,697,652.00 785,270.08 46.3% December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 10,481.89 9,090.00 1,391.89 70,341.70 78,090.00 (7,748.30) 178,291.00 107,949.30 60.5%6337842 Utilities-Water3,158.61 2,325.00 833.61 25,329.03 29,140.00 (3,810.97) 45,338.00 20,008.97 44.1%13,640.50 11,415.00 2,225.50 95,670.73 107,230.00 (11,559.27) 223,629.00 127,958.27 57.2%Total-COURSE MAINTENANCECourse Maintenance Expense StatementDecember 2014Silverrock ResortAnnual BudgetMonth to DateYear to DateSilverrock ResortCourse Maintenance Water & EnergyDecember 2014Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual Budget6 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 682.00 (682.00) - 4,092.00 (4,092.00) 8,184.00 8,184.00 100.0%6411325 Insurance-Workers Comp399.47 564.00 (164.53) 1,833.72 1,978.00 (144.28) 4,976.00 3,142.28 63.1%6411800 Taxes-Employer Payroll2,021.87 1,871.00 150.87 5,805.35 6,565.00 (759.65) 16,514.00 10,708.65 64.8%6411880 Wages-Hourly15,015.62 15,030.00 (14.38) 49,799.35 52,735.00 (2,935.65) 132,655.00 82,855.65 62.5%6411882 Wages-Overtime 346.54 - 346.54 691.57 - 691.57 - (691.57) 0.0%Total-CBR-SALARIES & BENEFITS17,783.50 18,147.00 (363.50) 58,129.99 65,370.00 (7,240.01) 162,329.00 104,199.01 64.2%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- 500.00 (500.00) - 1,500.00 (1,500.00) 1,850.00 `0.0%6413742 Supplies-Expendable1,322.70 150.00 1,172.70 3,496.26 3,450.00 46.26 6,750.00 3,253.74 48.2%6413748 Supplies-Fuel for Shuttle108.81 400.00 (291.19) 108.81 900.00 (791.19) 3,000.00 2,891.19 96.4%6413752 Supplies-Range Balls- - - 10,200.00 9,000.00 1,200.00 9,000.00 (1,200.00) -13.3%6413762 Supplies-Office- 50.00 (50.00) - 225.00 (225.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels 400.00 195.00 205.00 1,520.00 860.00 660.00 2,182.00 662.00 30.3%6413796 Supplies-Bottled Water- 50.00 (50.00) 742.50 300.00 442.50 8,550.00 7,807.50 91.3%Total-CBR-SUPPLIES & MATERIALS1,831.51 1,345.00 486.51 16,067.57 16,235.00 (167.43) 32,277.00 14,359.43 44.5%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment87.42 300.00 (212.58) 1,114.01 1,800.00 (685.99) 3,600.00 2,485.99 69.1%6415695 CBR-R&M-Cart Maintenance & Repair 882.14 500.00 382.14 6,833.34 3,450.00 3,383.34 6,450.00 (383.34) -5.9%Total-CBR-REPAIRS & MAINTENANCE969.56 800.00 169.56 7,947.35 5,250.00 2,697.35 10,050.00 2,102.65 20.9%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen 1,338.44 800.00 538.44 2,660.01 4,800.00 (2,139.99) 9,600.00 6,939.99 72.3%6419220 Freight/Delivery- 75.00 (75.00) - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous- 75.00 (75.00) 116.31 500.00 (383.69) 1,150.00 1,033.69 89.9%6419820 Uniforms - 500.00 (500.00) 2,589.41 3,000.00 (410.59) 5,200.00 2,610.59 50.2%Total-CBR-OTHER EXPENSES1,338.44 1,450.00 (111.56) 5,365.73 8,750.00 (3,384.27) 16,400.00 11,034.27 67.3%TOTAL-CARTS,BAGROOM & RANGE21,923.01 21,742.00 (111.56) 87,510.64 95,605.00 (8,094.36) 221,056.00 131,695.36 59.6%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%training expe Insurance-Workers Comp246.37 236.00 10.37 915.12 787.00 128.12 1,933.00 1,017.88 52.7%6431800 Taxes-Employer Payroll690.69 819.00 (128.31) 2,096.99 2,731.00 (634.01) 6,703.00 4,606.01 68.7%6431880 Wages-Hourly6,488.40 6,300.00 188.40 18,514.90 21,012.00 (2,497.10) 51,567.00 33,052.10 64.1%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS7,425.46 7,355.00 70.46 21,527.01 24,530.00 (3,002.99) 60,203.00 38,675.99 64.2%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 100.00 (100.00) - 500.00 (500.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous107.26 50.00 57.26 127.00 150.00 (23.00) 200.00 73.00 36.5%6439718 Safety Equipment & Training386.66 50.00 336.66 386.66 300.00 86.66 600.00 213.34 35.6%6439820 Uniforms 357.64 250.00 107.64 1,123.12 1,350.00 (226.88) 2,125.00 1,001.88 47.1%Total-CS-OTHER EXPENSES851.56 450.00 401.56 1,636.78 2,300.00 (663.22) 3,975.00 2,338.22 58.8%Total-COURSE SERVICES8,277.02 7,805.00 472.02 23,163.79 26,830.00 (3,666.21) 64,178.00 41,014.21 63.9%30,200.03 29,547.00 653.03 110,674.43 122,435.00 (11,760.57) 285,234.00 170,371.35 59.7%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementDecember 2014Annual Budget7 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 397.00 400.00 (3.00) 2,793.50 2,400.00 393.50 4,800.00 2,006.50 41.8%Total-CH-SUPPLIES & MATERIALS397.00 400.00 (3.00) 2,793.50 2,400.00 393.50 4,800.00 2,006.50 41.8%65-CH-UTILITIES6507836 Utilities-Natural Gas289.27 300.00 (10.73) 1,671.79 1,800.00 (128.21) 3,600.00 1,928.21 53.6%6507840 Utilities-Telephone1,194.37 1,150.00 44.37 6,063.35 6,900.00 (836.65) 13,800.00 7,736.65 56.1%6507842 Utilities-Water887.68 321.00 566.68 3,110.83 1,926.00 1,184.83 3,852.00 741.17 19.2%6507844 Utilities-Cable 462.06 340.00 122.06 2,748.61 2,040.00 708.61 4,080.00 1,331.39 32.6%Total-CH-UTILITIES2,833.38 2,111.00 722.38 13,594.58 12,666.00 928.58 25,332.00 11,737.42 46.3%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 2,117.00 1,825.00 292.00 11,973.50 11,550.00 423.50 22,500.00 10,526.50 46.8%6509099 Contract Services-Security5,653.55 4,900.00 753.55 31,373.51 29,400.00 1,973.51 60,400.00 29,026.49 48.1%6509215 Flowers & Decorations- - - - 500.00 (500.00) 1,900.00 1,900.00 100.0%6509490 Miscellaneous- 200.00 (200.00) 300.78 1,200.00 (899.22) 2,400.00 2,099.22 87.5%6509718 Safety Equipment & Training - 100.00 (100.00) - 600.00 (600.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES7,770.55 7,025.00 745.55 43,647.79 43,250.00 397.79 88,400.00 44,752.21 50.6%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures304.58 300.00 4.58 1,771.02 1,800.00 (28.98) 3,600.00 1,828.98 50.8%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 252.23 2,400.00 (2,147.77) 4,800.00 4,547.77 94.7%6515690 CH-R&M-Equipment Repair - 400.00 (400.00) 150.00 2,400.00 (2,250.00) 4,800.00 4,650.00 96.9%Total-CH-REPAIRS & MAINTENANCE304.58 1,100.00 (795.42) 2,173.25 6,600.00 (4,426.75) 13,200.00 11,026.75 83.5%11,305.51 10,636.00 669.51 62,209.12 64,916.00 (2,706.88) 131,732.00 22,053.50 16.7%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementDecember 2014Annual Budget8 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 305.00 341.00 (36.00) 1,799.44 2,046.00 (246.56) 4,092.00 2,292.56 56.0%6601325 Insurance-Workers Comp87.00 94.00 (7.00) 492.96 564.00 (71.04) 1,128.00 635.04 56.3%6601720 Salaries1,158.66 2,508.00 (1,349.34) 12,955.69 15,048.00 (2,092.31) 30,096.00 17,140.31 57.0%6601800 Taxes-Employer Payroll165.10 326.00 (160.90) 987.49 1,956.00 (968.51) 3,912.00 2,924.51 74.8%Total-MKT-SALARIES & BENEFITS1,715.76 3,269.00 (1,553.24) 16,235.58 19,614.00 (3,378.42) 39,228.00 22,992.42 58.6%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 276.27 100.00 176.27 588.90 600.00 (11.10) 1,200.00 611.10 50.9%6603768 Supplies-Printing & Stationery 2,245.49 200.00 2,045.49 7,667.58 3,600.00 4,067.58 4,425.00 (3,242.58) -73.3%2,521.76 300.00 2,221.76 8,256.48 4,200.00 4,056.48 5,625.00 (2,631.48) -46.8%66-MKT-UTILITIES6607840 Utilities-Telephone 63.08 100.00 (36.92) 511.86 600.00 (88.14) 1,200.00 688.14 57.3%Total-MKT-UTILITIES63.08 100.00 (36.92) 511.86 600.00 (88.14) 1,200.00 688.14 57.3%66-MKT-OTHER EXPENSES6609010 Advertising20,343.50 21,730.00 (1,386.50) 86,565.67 87,919.00 (1,353.33) 178,987.00 92,421.33 51.6%6609040 Business Meals- 25.00 (25.00) - 150.00 (150.00) 300.00 300.00 100.0%6609080 Collateral Material1,525.51 - 1,525.51 4,293.68 1,500.00 2,793.68 5,500.00 1,206.32 21.9%6609102 Contract Services-Web Page99.00 150.00 (51.00) 495.00 900.00 (405.00) 1,800.00 1,305.00 72.5%6609490 Miscellaneous35.63 50.00 (14.37) 35.63 100.00 (64.37) 350.00 314.37 89.8%6609620 Postage- 50.00 (50.00) - 300.00 (300.00) 600.00 600.00 100.0%6609630 Promotion- 50.00 (50.00) - 150.00 (150.00) 700.00 700.00 100.0%6609633 Promotion-Community- 750.00 (750.00) - 1,800.00 (1,800.00) 2,250.00 2,250.00 100.0%6609634 Promotion-Media/Vendor- 500.00 (500.00) - 1,000.00 (1,000.00) 2,000.00 2,000.00 100.0%6609150 Dues and Subscriptions110.00 - 110.00 306.55 - 306.55 735.00 428.45 58.3%6609820 Uniforms281.19 50.00 231.19 418.42 400.00 18.42 600.00 181.58 30.3%Total-MKT-OTHER EXPENSES22,394.83 23,355.00 (960.17) 92,114.95 94,219.00 (2,104.05) 193,822.00 101,707.05 52.5%26,695.43 27,024.00 (328.57) 117,118.87 118,633.00 (1,514.13) 239,875.00 122,756.13 51.2%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementDecember 2014Annual Budget9 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,500.00 1,488.00 12.00 8,229.81 8,928.00 (698.19) 17,856.00 9,626.19 53.9%6701325 Insurance-Workers Comp 819.75 662.00 157.75 4,355.40 3,746.00 609.40 7,718.00 3,362.60 43.6%6701720 Salaries14,129.44 14,833.34 (703.90) 84,688.43 89,000.04 (4,311.61) 178,000.00 93,311.57 52.4%6701800 Taxes-Employer Payroll 1,217.92 2,294.00 (1,076.08) 7,855.82 12,984.00 (5,128.18) 26,748.00 18,892.18 70.6%6701880 Wages-Hourly2,642.70 2,816.66 (173.96) 12,009.10 10,899.96 1,109.14 27,800.00 15,790.90 56.8%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 20,309.81 22,094.00 (1,784.19) 117,138.56 125,558.00 (8,419.44) 258,122.00 140,983.44 54.6%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer82.60 500.00 (417.40) 5,184.21 3,000.00 2,184.21 6,300.00 1,115.79 17.7%6703762 Supplies-Office177.99 150.00 27.99 713.24 900.00 (186.76) 1,800.00 1,086.76 60.4%6703768 Supplies-Printing & Stationery 85.08 400.00 (314.92) 388.88 900.00 (511.12) 3,300.00 2,911.12 88.2%Total-G&A-SUPPLIES & MATERIALS345.67 1,050.00 (704.33) 6,286.33 4,800.00 1,486.33 11,400.00 5,113.67 44.9%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipm243.42 100.00 143.42 243.42 1,300.00 (1,056.58) 1,900.00 1,656.58 87.2%Total-G&A-REPAIRS & MAINTENANCE 243.42 100.00 143.42 243.42 1,300.00 (1,056.58) 1,900.00 1,656.58 87.2%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance 400.00 400.00 - 2,400.00 2,400.00 - 4,800.00 2,400.00 50.0%6709150 Dues & Subscriptions- 200.00 (200.00) - 550.00 (550.00) 1,700.00 1,700.00 100.0%6709180 Employee Recruiting/Relocatio102.00 200.00 (98.00) 948.57 800.00 148.57 1,400.00 451.43 32.2%6709197 Equipment Rental1,365.94 550.00 815.94 4,349.21 3,300.00 1,049.21 6,600.00 2,250.79 34.1%6709202 Fees-Bank156.89 90.00 66.89 1,108.05 540.00 568.05 1,080.00 (28.05) -2.6%6709208 Fees-Payroll Processing 1,335.08 1,200.00 135.08 6,987.30 7,200.00 (212.70) 14,400.00 7,412.70 51.5%6709220 Freight/Delivery- 50.00 (50.00) - 300.00 (300.00) 600.00 600.00 100.0%6709490 Miscellaneous193.75 100.00 93.75 388.83 600.00 (211.17) 1,200.00 811.17 67.6%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services147.00 75.00 72.00 712.50 450.00 262.50 900.00 187.50 20.8%6709625 Professional Fees1,460.12 850.00 610.12 6,956.54 5,100.00 1,856.54 10,200.00 3,243.46 31.8%6709636 Promotion/Entertainment 2,500.00 100.00 2,400.00 2,500.00 600.00 1,900.00 1,200.00 (1,300.00) -108.3%6709722 Seminars & Training250.00 200.00 50.00 947.20 1,200.00 (252.80) 2,400.00 1,452.80 60.5%6709810 Travel- - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%training expe Uniforms412.45 75.00 900.00 781.49 600.00 181.49 1,050.00 268.51 25.6%Total-G&A-OTHER EXPENSES8,323.23 4,090.00 4,795.78 28,079.69 23,740.00 4,339.69 48,630.00 20,550.31 42.3%29,222.13 27,334.00 1,888.13 151,748.00 155,398.00 (3,650.00) 320,052.00 168,304.00 52.6%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementDecember 2014Annual Budget10 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts10,363.45 10,050.00 313.45 58,180.70 60,750.00 (2,569.30) 121,050.00 62,869.30 51.9%6800193 Equipment Leases-Maintenance 5,125.77 6,050.00 (924.23) 16,678.85 12,100.00 4,578.85 48,400.00 31,721.15 65.5%6800194 Equipment Leases-Trailer496.73 600.00 (103.27) 3,488.48 3,600.00 (111.52) 7,200.00 3,711.52 51.5%6800196 Equipment Leases-GPS4,460.00 4,700.00 (240.00) 26,080.00 28,200.00 (2,120.00) 56,400.00 30,320.00 53.8%6800197 Equipment Leases-Others2,131.94 1,150.00 981.94 8,335.35 6,900.00 1,435.35 13,800.00 5,464.65 0.0%22,577.89 22,550.00 27.89 112,763.38 111,550.00 1,213.38 246,850.00 134,086.62 54.3%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,000.00 8,000.00 - 48,000.00 48,000.00 - 96,000.00 48,000.00 50.0%6900210 FF&E Reserve5,909.18 5,776.00 133.18 14,668.98 13,934.00 734.98 60,874.00 46,205.02 75.9%6900800 Personal Property Taxes- - - 9,584.24 14,800.00 (5,215.76) 14,800.00 5,215.76 35.2%6900323 Insurance-Commercial3,146.71 2,200.00 946.71 22,943.97 13,200.00 9,743.97 26,400.00 3,456.03 13.1%17,055.89 15,976.00 1,079.89 95,197.19 89,934.00 5,263.19 198,074.00 102,876.81 51.9%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementDecember 2014Annual BudgetMonth to DateYear to Date11 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2014‐20152014 2014 2014 2014 2014 2014Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia4SalesPromotionGolf IndustryVIPCelebrityPGA Comp9893726Charity/Gift Certificate422Rain/Wind Checks12247Club Staff728360854102LQ HS Golf21010611841058113711722015 2015 2015 2015 2015 2015Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2012‐2013December 2014 Date Time DescriptionCategoryPlayers12/8/2014 12:45 Judd Spicer / Golf WriterMedia212/26/2014 11:00 John White / TV AnchorMedia213