Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
06 December 2015 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2015 – December 2015 TABLE OF CONTENTS Summary Operating Income Expense 1 Statement of Fee Revenue 2 Variance Report 3 Golf Shop Income Statement 4 Course Maintenance Expense Statement 5 Outside Service Expense Statement 7 Clubhouse Expense Statement 8 Marketing Expense Statement 9 General & Administrative Expense Statement 10 Operating Leases & Miscellaneous Expense Statement 12 Complimentary Report 13 Annual BudgetAccount Description December Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue271,180.95 288,794.00 (17,613.05) -6.1% 928,864.26 924,902.00 3,962.26 3,199,237.00 2,270,372.74 29%401000 Miscellaneous Golf Revenue41,076.00 41,625.00 (549.00) -1.3% 134,214.50 116,555.00 17,659.50 349,259.00 215,044.50 38%410000 Revenue-Golf Shop20,484.94 25,625.00 (5,140.06) -20.1% 78,769.19 88,686.00 (9,916.81) 278,585.00 199,815.81 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 Income0.75 - 0.75 10.95 - 10.95 - (10.95) 0%Total Income334,242.64 357,544.00 (23,301.36) -6.5% 1,147,858.90 1,136,143.00 11,715.90 3,839,081.00 2,691,222.10 30%Cost of Goods Sold510000 COS-Golf Shop12,305.18 14,342.50 (2,037.32) 14.2% 45,016.52 49,636.88 4,620.36 155,924.00 110,907.48 29%Total COS12,305.18 14,342.50 (2,037.32) 14.2% 45,016.52 49,636.88 4,620.36 155,924.00 110,907.48 29%Gross Profit321,937.46 343,201.50 (21,264.04) -6.2% 1,102,842.38 1,086,506.12 16,336.26 3,683,157.00 2,580,314.62 30%Expenses610000 Golf Pro Shop 18,182.78 18,594.00 (411.22) 2.2% 86,602.06 90,903.00 (4,300.94) 204,827.00 118,224.94 42%630000 Course Maintenance125,821.66 131,799.00 (5,977.34) 4.5% 957,230.86 971,267.00 (14,036.14) 1,712,795.00 755,564.14 56%633000 Maintenance Water & Energy14,012.41 11,415.00 2,597.41 -22.8% 112,115.21 101,930.00 10,185.21 225,129.00 113,013.79 50%640000 Outside Services36,886.09 31,248.00 5,638.09 -18.0% 134,308.41 130,838.00 3,470.41 309,830.00 175,521.59 43%650000 Clubhouse12,503.88 10,636.00 1,867.88 -17.6% 70,317.57 67,216.00 3,101.57 136,332.00 66,014.43 52%660000 Marketing32,439.54 27,049.00 5,390.54 -19.9% 110,970.48 118,783.00 (7,812.52) 240,177.00 129,206.52 46%670000 General & Administrative29,607.17 30,411.00 (803.83) 2.6% 149,632.86 161,798.00 (12,165.14) 327,511.00 177,878.14 46%680000 Leases22,633.77 22,550.00 83.77 -0.4% 135,563.12 135,750.00 (186.88) 271,050.00 135,486.88 50%690000 Miscellaneous Other Expense17,554.87 16,296.00 1,258.87 -7.7% 99,438.12 93,419.00 6,019.12 202,025.00 102,586.88 49%Total Expenses309,642.17 299,998.00 9,644.17 -3.2% 1,856,178.69 1,871,904.00 15,725.31 3,629,676.00 1,773,497.31 51%12,295.29 43,203.50 (30,908.21) -71.5%(753,336.31) (785,397.88) 32,061.57 53,481.00 806,817.31 0%Rounds of Golf PlayedPaid Rounds Played3,972 4,100 (128) -3.1%16,963 17,175 (212) 41,100 24,137 41%Ave $ Per Paid Round Green Fee68.27 70.44 (2.16) -3.1%54.76 53.85 0.91 77.84 23.08 70%Ave $ Per Paid Round Merchandise5.16 6.25 (1.09) -17.5%4.64 5.16 (0.52) 6.78 2.13 69%Ave $ Per Paid Miscellaneous 10.34 10.15 0.19 1.9%7.91 6.79 1.13 8.50 0.59 93%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateDecember 20151 Income December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees271,180.95 288,794.00 (17,613.05) 928,864.26 924,902.00 3,962.26 3,199,237.00 2,270,372.74 71.0%4010000 Rider Fee925.00 1,025.00 (100.00) 4,232.50 2,333.00 1,899.50 7,738.00 3,505.50 45.3%4040000 Club Rental2,045.00 2,050.00 (5.00) 7,970.00 8,588.00 (618.00) 23,238.00 15,268.00 65.7%4050000 Driving Range9,580.00 10,250.00 (670.00) 32,157.00 29,534.00 2,623.00 100,984.00 68,827.00 68.2%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 - - - 894.00 2,000.00 (1,106.00) 4,000.00 3,106.00 77.7%4091000 Golf Professional Rental Fee 6,581.00 5,000.00 1,581.00 12,581.00 10,000.00 2,581.00 37,000.00 24,419.00 66.0%4092000 Golf Lessons - - - - - - - - 0.0%4093000 Resident Card Issue21,945.00 22,800.00 (855.00) 76,380.00 62,700.00 13,680.00 171,200.00 94,820.00 55.4% Total Revenue Fees312,256.95 330,419.00 (18,162.05) 1,063,078.76 1,041,457.00 21,621.76 3,548,497.00 2,485,418.24 70.0%312,256.95 330,419.00 (18,162.05) 1,063,078.76 1,041,457.00 21,621.76 3,548,497.00 2,485,418.24 70.0%SilverRock ResortStatement of Fees RevenueDecember 2015Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$20,484.94 $25,625.00 (5,140.06)Unfavorable: Merchandise sales were down 20% compared to budget as a result of consumer spending being reduced. The majority of this can be attributed to the weak CanadianDollar that has become very weak against the U.S. Dollar. Nearly 1/3 of SilverRock's golfers are Canadian during the winter & spring.ExpensesActualBudgetVariance$14,012.41 $11,415.00 2,597.41Unfavorable: Pumping and Water Costs are over budget by 9% versus budget year to date. Run times on water features will be reduced to reduce pumping costs. ActualBudgetVariance$36,886.09$31,248.005,638.09Unfavorable: Due to cost of custom labels for bottled water and unexpected cart repairs of $2,700.ActualBudgetVariance$12,503.88 $10,636.00 1,867.88Unfavorable: Due to repairs of refrigeration units in the Grill Room and holiday rates paid to Drum Security.ActualBudgetVariance$32,439.54 $27,049.00 5,390.54Unfavorable: Due to timing of advertisement invoices. In addition we completed orders for tees, ballmarkers and pencils for the golfers. We receive lower pricing by buying in bulk.Cartbarn-Outside ServicesClubhouseMarketingVariance ExplanationDecember 2015The 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 areprovided for those cost of sales percentage that are greater than 5%.Pro Shop Merchandise SalesWater & Energy3 Income December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous84.08 - 84.08 962.69 - 962.69 00 0%4100110 Sales Hard Goods6,983.94 8,969.00 (1,985.06) 31,109.56 31,041.00 68.56 97,505.00 66,395.44 68.1%4100112 Sales-Soft Goods16,518.50 16,656.00 (137.50) 56,682.00 57,645.00 (963.00) 181,080.00 124,398.00 68.7%5100639 GS-Discounts-Mdse (3,101.58) - (3,101.58) (9,985.06) - (9,985.06) - 9,985.06 0.0% Total Revenue Golf Shop20,484.94 25,625.00 (5,140.06) 78,769.19 88,686.00 (9,916.81) 278,585.00 200,778.50 72.1%COS 5100150 COS-GS-Hard Goods 4,716.11 5,202.02 (485.91) 18,199.70 18,003.78 195.92 56,552.90 38,353.20 67.8%5100151 COS-GS-Soft Goods 7,420.24 9,660.48 (2,240.24) 25,105.04 33,434.10 (8,329.06) 105,026.40 79,921.36 76.1%5100152 COS-GS-Purchase Disc- (743.00) 743.00 (38.64) (2,573.00) 2,534.36 (8,079.00) (8,040.36) 99.5%5100220 COS-GS-Freight Merch 168.83 223.00 (54.17) 1,750.42 772.00 978.42 2,424.00 673.58 27.8%Cost of Sales - Golf Shop12,305.18 14,342.50 (2,037.32) 45,016.52 49,636.88 (4,620.36) 155,924.30 110,907.78 71.1%Gross Profit 8,179.76 11,282.50 (3,102.74) 33,752.67 39,049.12 (5,296.45) 122,660.70 89,870.72 73.3%COS % 60.1% 56.0% -4.1% 57.1% 56.0% -1.2% 53.1% 55.2% 104.1%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group2,125.69 2,387.00 (261.31) 10,555.81 13,299.00 (2,743.19) 27,621.00 17,065.19 61.8%6101325 Insurance-Workers Comp 724.69 478.00 246.69 3,115.70 2,243.00 872.70 5,042.00 1,926.30 38.2%6101720 Salaries3,956.60 3,950.00 6.60 23,206.15 23,700.00 (493.85) 45,000.00 21,793.85 48.4%6101800 Taxes-Employer Payroll 1,685.10 1,786.00 (100.90) 6,077.28 8,372.00 (2,294.72) 18,825.00 12,747.72 67.7%6101880 Wages-Hourly8,320.92 8,808.00 (487.08) 37,516.96 36,104.00 1,412.96 89,463.00 51,946.04 58.1%6101882 Wages-Overtime52.13 - 52.13 157.51 - 157.51 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 16,865.13 17,409.00 (543.87) 80,629.41 83,718.00 (3,088.59) 185,951.00 106,431.98 57.2%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office117.36 250.00 (132.64) 858.88 1,500.00 (641.12) 3,000.00 2,141.12 71.4%6109220 Freight & Delivery- 25.00 (25.00) 140.00 75.00 65.00 75.00 (65.00) -86.7%6109490 Miscellaneous500.00 500.00 - 2,582.24 3,000.00 (417.76) 6,000.00 3,417.76 57.0%6109150 Dues and Subscriptions- - - 102.30 - 102.30 2,300.00 2,197.70 95.6%6109500 ProShop-Over/Short44.49 - 44.49 42.79 - 42.79 - (42.79) 0.0%6109722 Seminars/Training- 100.00 (100.00) - 1,050.00 (1,050.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- - - - - - 90.00 90.00 100.0%6109820 Uniforms134.21 200.00 (65.79) 1,461.38 900.00 561.38 2,400.00 938.62 39.1%6117840 Telephones521.59 110.00 411.59 785.06 660.00 125.06 1,320.00 534.94 40.5%1,317.65 1,185.00 132.65 5,972.65 7,185.00 (1,212.35) 18,875.00 12,902.35 68.4%18,182.78 18,594.00 (411.22) 86,602.06 90,903.00 (4,300.94) 204,826.00 119,334.33 58.3%Net Income(10,003.02) (7,311.50) (2,691.52) (52,849.39) (51,853.88) (995.51) (82,165.30) (29,463.61) 35.9%SilverRock ResortGolf Shop Income StatementDecember 2015Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group8,538.33 8,990.00 (451.67) 49,929.95 53,940.00 (4,010.05) 107,880.00 57,950.05 53.7%6311325 Insurance-Workers Comp3,261.09 2,181.00 1,080.09 14,775.34 12,049.00 2,726.34 24,794.00 10,018.66 40.4%6311720 Salaries11,671.20 11,900.00 (228.80) 69,035.20 71,400.00 (2,364.80) 142,017.20 72,982.00 51.4%6311800 Taxes-Employer Payroll3,274.98 8,143.00 (4,868.02) 33,608.20 45,474.00 (11,865.80) 93,302.00 59,693.80 64.0%6311880 Wages-Hourly46,004.61 46,267.00 (262.39) 248,203.21 242,895.00 5,308.21 508,481.80 260,278.59 51.2%6311882 Wages-Overtime- - - 9,947.12 10,526.00 (578.88) 15,945.00 5,997.88 37.6%Total-CM-SALARIES & BENEFITS72,750.21 77,481.00 (4,730.79) 425,499.02 436,284.00 (10,784.98) 892,420.00 466,920.98 52.3%63-CM-SUPPLIES & MATERIALS6313734 Chemicals100.65 2,200.00 (2,099.35) 27,886.21 22,700.00 5,186.21 34,600.00 6,713.79 19.4%6313744 Fertilizer9,960.26 9,000.00 960.26 75,747.10 70,000.00 5,747.10 112,500.00 36,752.90 32.7%6313745 Herbicides5,521.68 5,000.00 521.68 19,367.52 17,000.00 2,367.52 17,000.00 (2,367.52) -13.9%6313746 Flowers/Plants- 750.00 (750.00) 87.64 2,000.00 (1,912.36) 3,050.00 2,962.36 97.1%6313748 Fuel-Gasoline2,165.14 4,200.00 (2,034.86) 25,445.35 33,200.00 (7,754.65) 55,020.00 29,574.65 53.8%6313750 Golf Course Accessories395.75 1,200.00 (804.25) 10,948.34 12,300.00 (1,351.66) 13,000.00 2,051.66 15.8%6313756 POA Control- - - 4,554.17 3,500.00 1,054.17 7,000.00 2,445.83 34.9%6313758 Miscellaneous Supp865.96 500.00 365.96 3,449.29 3,750.00 (300.71) 4,350.00 900.71 20.7%6313762 Supplies-Office- - - - - - - - 0.0%6313774 Sand- 800.00 (800.00) 1,879.45 12,580.00 (10,700.55) 13,460.00 11,580.55 86.0%6313776 Seed- 350.00 (350.00) 132,015.98 123,800.00 8,215.98 125,900.00 (6,115.98) -4.9%6313778 Small Tools & Non-Capital Equip80.89 100.00 (19.11) 2,972.22 4,400.00 (1,427.78) 5,000.00 2,027.78 40.6%6313780 Sod- 250.00 (250.00) 5,597.26 9,250.00 (3,652.74) 10,450.00 4,852.74 46.4%6313782 Topdressing771.12 - 771.12 5,722.06 8,000.00 (2,277.94) 10,600.00 4,877.94 46.0%Total-CM-SUPPLIES & MATERIALS19,861.45 24,350.00 (4,488.55) 315,672.59 322,480.00 (6,807.41) 411,930.00 96,257.41 23.4%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint4,695.00 2,600.00 2,095.00 20,331.50 15,600.00 4,731.50 31,200.00 10,868.50 34.8%6315685 CM-R&M-Bldngs & Othr Structures 103.00 500.00 (397.00) 2,224.65 4,050.00 (1,825.35) 5,550.00 3,325.35 59.9%6315690 CM-R&M-Equipment2,787.35 3,000.00 (212.65) 29,275.49 24,500.00 4,775.49 40,000.00 10,724.51 26.8%6315692 CM-R&M-Irrigation System514.73 550.00 (35.27) 12,566.00 12,850.00 (284.00) 19,050.00 6,484.00 34.0%6315696 CM-R&M-Pumps2,219.04 1,000.00 1,219.04 8,098.81 6,000.00 2,098.81 10,500.00 2,401.19 22.9%6315815 CM-R&M-Trees-Pruning Etc- - - 8,555.95 6,050.00 2,505.95 12,050.00 3,494.05 29.0%Total-CM-REPAIRS & MAINTENANCE10,319.12 7,650.00 2,669.12 81,052.40 69,050.00 12,002.40 118,350.00 37,297.60 31.5%6317836 Utilities-Natural Gas/LPG 21.21 15.00 6.21 120.58 90.00 30.58 180.00 59.42 0.0%6317840 Telephones1,975.18 850.00 1,125.18 7,422.09 5,100.00 2,322.09 10,200.00 2,777.91 27.2%Total-CM-UTILITIES1,996.39 865.00 1,131.39 7,542.67 5,190.00 2,352.67 10,380.00 2,837.33 27.3%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 Removal752.46 524.00 228.46 4,514.76 3,144.00 1,370.76 6,288.00 1,773.24 28.2%6319150 Dues & Subscriptions210.00 - 210.00 785.00 - 785.00 540.00 (245.00) -45.4%6319170 Employee Education- 50.00 (50.00) 69.00 300.00 (231.00) 1,550.00 1,481.00 95.5%6319197 Equipment Rental- 200.00 (200.00) 911.44 2,300.00 (1,388.56) 3,400.00 2,488.56 73.2%6319206 Licenses & Permits- - - 223.89 280.00 (56.11) 4,180.00 3,956.11 94.6%6319490 Miscellaneous- 100.00 (100.00) 439.43 600.00 (160.57) 1,200.00 760.57 63.4%6319718 Safety Equipment & Training536.15 400.00 136.15 2,203.32 2,750.00 (546.68) 3,850.00 1,646.68 42.8%6319822 Uniforms537.96 920.00 (382.04) 5,332.87 5,520.00 (187.13) 11,040.00 5,707.13 51.7%Total-CM-OTHER EXPENSES2,536.57 2,694.00 (157.43) 19,479.71 19,894.00 (414.29) 42,048.00 22,568.29 53.7%SilverRock ResortCourse Maintenance Expense StatementDecember 2015Annual BudgetMonth to DateYear to Date5 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,998.50 2,728.00 (729.50) 11,738.70 16,368.00 (4,629.30) 32,736.00 20,997.30 64.1%6321325 Insurance-Workers Comp362.34 483.00 (120.66) 3,094.96 3,031.00 63.96 6,171.00 3,076.04 49.8%6321800 Taxes-Employer Payroll1,492.92 1,803.00 (310.08) 8,688.80 11,562.00 (2,873.20) 23,334.00 14,645.20 62.8%6321880 Wages-Hourly14,395.91 12,880.00 1,515.91 79,019.07 77,280.00 1,739.07 160,320.00 81,300.93 50.7%6321882 Wages-Overtime- - - 4,172.57 5,313.00 (1,140.43) 6,351.00 2,178.43 34.3%Total-CM-LM-SALARIES & BENEFITS18,249.67 17,894.00 355.67 106,714.10 113,554.00 (6,839.90) 228,912.00 122,197.90 53.4%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 75.00 (75.00) - 575.00 (575.00) 1,025.00 1,025.00 100.0%6323788 Uniforms108.25 290.00 (181.75) 1,270.37 1,740.00 (469.63) 3,480.00 2,209.63 63.5%Total-CM-LM-SUPPLIES & MATERIALS108.25 365.00 (256.75) 1,270.37 2,315.00 (1,044.63) 4,505.00 3,234.63 71.8%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 500.00 (500.00) - 2,500.00 (2,500.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE- 500.00 (500.00) - 2,500.00 (2,500.00) 4,250.00 4,250.00 100.0%125,821.66 131,799.00 (5,977.34) 957,230.86 971,267.00 (14,036.14) 1,712,795.00 755,564.14 44.1% December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 10,409.39 9,090.00 1,319.39 79,864.09 72,790.00 7,074.09 179,791.00 99,926.91 55.6%6337842 Utilities-Water3,603.02 2,325.00 1,278.02 32,251.12 29,140.00 3,111.12 45,338.00 13,086.88 28.9%14,012.41 11,415.00 2,597.41 112,115.21 101,930.00 10,185.21 225,129.00 113,013.79 50.2%Silverrock ResortCourse Maintenance Water & EnergyDecember 2015Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementDecember 2015Silverrock ResortAnnual BudgetMonth to DateYear to Date6 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 Comp1,207.81 564.00 643.81 2,884.20 1,978.00 906.20 5,229.00 2,344.80 44.8%6411800 Taxes-Employer Payroll1,253.03 1,871.00 (617.97) 5,304.69 6,565.00 (1,260.31) 17,360.00 12,055.31 69.4%6411880 Wages-Hourly15,814.89 15,030.00 784.89 57,097.26 52,735.00 4,362.26 139,434.00 82,336.74 59.1%6411882 Wages-Overtime 114.22 - 114.22 347.15 - 347.15 - (347.15) 0.0%Total-CBR-SALARIES & BENEFITS18,389.95 18,147.00 242.95 65,633.30 65,370.00 263.30 170,207.00 104,573.70 61.4%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- 500.00 (500.00) 3,106.88 1,500.00 1,606.88 1,850.00 `0.0%6413742 Supplies-Expendable1,011.96 150.00 861.96 4,105.60 3,450.00 655.60 6,750.00 2,644.40 39.2%6413748 Supplies-Fuel for Shuttle- 400.00 (400.00) - 900.00 (900.00) 3,000.00 3,000.00 100.0%6413752 Supplies-Range Balls- - - 9,000.00 9,000.00 - 9,000.00 - 0.0%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 320.00 195.00 125.00 1,680.00 860.00 820.00 2,182.00 502.00 23.0%6413796 Supplies-Bottled Water3,955.20 50.00 3,905.20 4,495.20 3,750.00 745.20 11,000.00 6,504.80 59.1%Total-CBR-SUPPLIES & MATERIALS5,287.16 1,345.00 3,942.16 22,387.68 19,685.00 2,702.68 34,727.00 13,596.20 39.2%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment- 300.00 (300.00) 935.29 1,800.00 (864.71) 3,600.00 2,664.71 74.0%6415695 CBR-R&M-Cart Maintenance & Repair 3,264.62 500.00 2,764.62 6,302.86 3,450.00 2,852.86 6,450.00 147.14 2.3%Total-CBR-REPAIRS & MAINTENANCE3,264.62 800.00 2,464.62 7,238.15 5,250.00 1,988.15 10,050.00 2,811.85 28.0%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen790.99 800.00 (9.01) 2,977.19 4,800.00 (1,822.81) 9,600.00 6,622.81 69.0%6419220 Freight/Delivery- 75.00 (75.00) - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous740.29 600.00 140.29 2,697.20 3,600.00 (902.80) 7,200.00 4,502.80 62.5%6419820 Uniforms - 500.00 (500.00) 2,396.52 3,000.00 (603.48) 5,200.00 2,803.48 53.9%Total-CBR-OTHER EXPENSES1,531.28 1,975.00 (443.72) 8,070.91 11,850.00 (3,779.09) 22,450.00 14,379.09 64.0%TOTAL-CARTS,BAGROOM & RANGE28,473.01 22,267.00 (443.72) 103,330.04 102,155.00 1,175.04 237,434.00 135,360.84 57.0%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp343.33 272.00 71.33 1,111.08 840.00 271.08 2,179.00 1,067.92 49.0%6431800 Taxes-Employer Payroll897.13 1,014.00 (116.87) 2,815.22 3,136.00 (320.78) 8,135.00 5,319.78 65.4%6431880 Wages-Hourly7,077.75 7,245.00 (167.25) 24,467.37 22,407.00 2,060.37 58,108.00 33,640.63 57.9%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS8,318.21 8,531.00 (212.79) 28,393.67 26,383.00 2,010.67 68,422.00 40,028.33 58.5%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 100.00 (100.00) 200.20 500.00 (299.80) 1,050.00 849.80 80.9%6439490 Miscellaneous94.87 50.00 44.87 794.62 150.00 644.62 200.00 (594.62) -297.3%6439718 Safety Equipment & Training- 50.00 (50.00) - 300.00 (300.00) 600.00 600.00 100.0%6439820 Uniforms - 250.00 (250.00) 1,589.88 1,350.00 239.88 2,125.00 535.12 25.2%Total-CS-OTHER EXPENSES94.87 450.00 (355.13) 2,584.70 2,300.00 284.70 3,975.00 1,390.30 35.0%Total-COURSE SERVICES8,413.08 8,981.00 (567.92) 30,978.37 28,683.00 2,295.37 72,397.00 41,418.63 57.2%36,886.09 31,248.00 5,638.09 134,308.41 130,838.00 3,470.41 309,831.00 175,389.17 56.6%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementDecember 2015Annual Budget7 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 2,405.00 2,400.00 5.00 4,800.00 2,395.00 49.9%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 2,405.00 2,400.00 5.00 4,800.00 2,395.00 49.9%65-CH-UTILITIES6507836 Utilities-Natural Gas392.85 300.00 92.85 1,792.55 1,800.00 (7.45) 3,600.00 1,807.45 50.2%6507840 Utilities-Telephone1,056.79 1,150.00 (93.21) 5,339.90 6,900.00 (1,560.10) 13,800.00 8,460.10 61.3%6507842 Utilities-Water1,053.27 321.00 732.27 4,643.57 1,926.00 2,717.57 3,852.00 (791.57) -20.5%6507844 Utilities-Cable 482.21 340.00 142.21 2,889.26 2,040.00 849.26 4,080.00 1,190.74 29.2%Total-CH-UTILITIES2,985.12 2,111.00 874.12 14,665.28 12,666.00 1,999.28 25,332.00 10,666.72 42.1%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 1,825.00 1,825.00 - 11,222.00 11,550.00 (328.00) 22,500.00 11,278.00 50.1%6509099 Contract Services-Security5,668.56 4,900.00 768.56 31,720.52 29,400.00 2,320.52 60,400.00 28,679.48 47.5%6509215 Flowers & Decorations63.73 - 63.73 376.21 500.00 (123.79) 1,900.00 1,523.79 80.2%6509490 Miscellaneous- 200.00 (200.00) 2,411.16 3,500.00 (1,088.84) 7,000.00 4,588.84 65.6%6509718 Safety Equipment & Training- 100.00 (100.00) - 600.00 (600.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES7,557.29 7,025.00 532.29 45,729.89 45,550.00 179.89 93,000.00 47,270.11 50.8%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures92.50 300.00 (207.50) 2,440.36 1,800.00 640.36 3,600.00 1,159.64 32.2%6515686 CH-R&M-Restaurant Repairs 1,400.00 400.00 1,000.00 3,315.00 2,400.00 915.00 4,800.00 1,485.00 30.9%6515690 CH-R&M-Equipment Repair68.97 400.00 (331.03) 1,762.04 2,400.00 (637.96) 4,800.00 3,037.96 63.3%Total-CH-REPAIRS & MAINTENANCE1,561.47 1,100.00 461.47 7,517.40 6,600.00 917.40 13,200.00 5,682.60 43.1%12,503.88 10,636.00 1,867.88 70,317.57 67,216.00 3,101.57 136,332.00 11,365.20 8.3%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementDecember 2015Annual Budget8 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 300.00 341.00 (41.00) 2,000.00 2,046.00 (46.00) 4,092.00 2,092.00 51.1%6601325 Insurance-Workers Comp65.00 94.00 (29.00) 728.20 564.00 164.20 1,129.00 400.80 35.5%6601720 Salaries2,857.44 2,508.00 349.44 12,181.20 15,048.00 (2,866.80) 30,096.00 17,914.80 59.5%6601800 Taxes-Employer Payroll233.32 351.00 (117.68) 1,466.92 2,106.00 (639.08) 4,213.00 2,746.08 65.2%Total-MKT-SALARIES & BENEFITS3,455.76 3,294.00 161.76 16,376.32 19,764.00 (3,387.68) 39,530.00 23,153.68 58.6%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 197.97 100.00 97.97 621.44 600.00 21.44 1,200.00 578.56 48.2%6603768 Supplies-Printing & Stationery 559.43 200.00 359.43 1,973.04 3,600.00 (1,626.96) 4,425.00 2,451.96 55.4%757.40 300.00 457.40 2,594.48 4,200.00 (1,605.52) 5,625.00 3,030.52 53.9%66-MKT-UTILITIES6607840 Utilities-Telephone - 100.00 (100.00) 305.40 600.00 (294.60) 1,200.00 894.60 74.6%Total-MKT-UTILITIES- 100.00 (100.00) 305.40 600.00 (294.60) 1,200.00 894.60 74.6%66-MKT-OTHER EXPENSES6609010 Advertising24,250.01 21,730.00 2,520.01 87,262.89 87,919.00 (656.11) 178,987.00 91,724.11 51.2%6609040 Business Meals- - - - - - 300.00 300.00 100.0%6609080 Collateral Material3,767.37 - 3,767.37 3,767.37 1,500.00 2,267.37 5,500.00 1,732.63 31.5%6609102 Contract Services-Web Page99.00 150.00 (51.00) 396.00 900.00 (504.00) 1,800.00 1,404.00 78.0%6609490 Miscellaneous- 50.00 (50.00) - 100.00 (100.00) 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 300.00 (300.00) 600.00 600.00 100.0%6609630 Promotion- 25.00 (25.00) - 150.00 (150.00) 700.00 700.00 100.0%6609633 Promotion-Community- 800.00 (800.00) 76.50 1,950.00 (1,873.50) 2,250.00 2,173.50 96.6%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 110.00 - 110.00 735.00 625.00 85.0%6609820 Uniforms- 50.00 (50.00) 81.52 400.00 (318.48) 600.00 518.48 86.4%Total-MKT-OTHER EXPENSES28,226.38 23,355.00 4,871.38 91,694.28 94,219.00 (2,524.72) 193,822.00 102,127.72 52.7%32,439.54 27,049.00 5,390.54 110,970.48 118,783.00 (7,812.52) 240,177.00 129,206.52 53.8%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementDecember 2015Annual Budget9 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,042.88 1,488.00 (445.12) 6,776.36 8,928.00 (2,151.64) 17,856.00 11,079.64 62.0%6701325 Insurance-Workers Comp1,449.37 662.00 787.37 4,758.95 3,746.00 1,012.95 7,717.00 2,958.05 38.3%6701720 Salaries14,681.50 15,050.00 (368.50) 83,991.50 84,300.00 (308.50) 177,996.00 94,004.50 52.8%6701800 Taxes-Employer Payroll2,407.86 2,471.00 (63.14) 10,757.85 13,986.00 (3,228.15) 28,812.00 18,054.15 62.7%6701880 Wages-Hourly1,246.50 2,600.00 (1,353.50) 14,420.60 15,598.00 (1,177.40) 27,800.00 13,379.40 48.1%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS20,828.11 22,271.00 (1,442.89) 120,705.26 126,558.00 (5,852.74) 260,181.00 139,475.74 53.6%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer100.13 500.00 (399.87) 1,071.59 3,000.00 (1,928.41) 6,300.00 5,228.41 83.0%6703762 Supplies-Office63.42 150.00 (86.58) 830.47 900.00 (69.53) 1,800.00 969.53 53.9%6703768 Supplies-Printing & Stationery51.09 400.00 (348.91) 431.96 900.00 (468.04) 3,300.00 2,868.04 86.9%Total-G&A-SUPPLIES & MATERIALS214.64 1,050.00 (835.36) 2,334.02 4,800.00 (2,465.98) 11,400.00 9,065.98 79.5%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment 99.60 100.00 (0.40) 941.00 1,300.00 (359.00) 1,900.00 959.00 50.5%Total-G&A-REPAIRS & MAINTENANCE99.60 100.00 (0.40) 941.00 1,300.00 (359.00) 1,900.00 959.00 50.5%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) - 550.00 (550.00) 1,700.00 1,700.00 100.0%6709180 Employee Recruiting/Relocation360.00 200.00 160.00 540.00 800.00 (260.00) 1,400.00 860.00 61.4%6709197 Equipment Rental1,682.27 550.00 1,132.27 4,240.37 3,300.00 940.37 6,600.00 2,359.63 35.8%6709202 Fees-Bank126.59 90.00 36.59 782.49 540.00 242.49 1,080.00 297.51 27.5%6709208 Fees-Payroll Processing1,509.98 1,200.00 309.98 7,095.91 7,200.00 (104.09) 14,400.00 7,304.09 50.7%6709220 Freight/Delivery10.68 50.00 (39.32) 10.68 300.00 (289.32) 600.00 589.32 98.2%6709490 Miscellaneous4,077.50 3,000.00 1,077.50 4,116.28 6,000.00 (1,883.72) 1,200.00 (2,916.28) -243.0%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services98.00 75.00 23.00 673.84 450.00 223.84 900.00 226.16 25.1%6709625 Professional Fees199.80 850.00 (650.20) 5,092.50 5,100.00 (7.50) 10,200.00 5,107.50 50.1%6709636 Promotion/Entertainment- 100.00 (100.00) - 600.00 (600.00) 6,600.00 6,600.00 100.0%6709722 Seminars & Training- 200.00 (200.00) 250.00 1,200.00 (950.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- 75.00 900.00 450.51 600.00 (149.49) 1,050.00 599.49 57.1%Total-G&A-OTHER EXPENSES8,464.82 6,990.00 2,449.82 25,652.58 29,140.00 (3,487.42) 54,030.00 28,377.42 52.5%29,607.17 30,411.00 (803.83) 149,632.86 161,798.00 (12,165.14) 327,511.00 177,878.14 54.3%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementDecember 2015Annual Budget10 December Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts10,363.45 10,050.00 313.45 62,180.70 60,300.00 1,880.70 121,050.00 58,869.30 48.6%6800193 Equipment Leases-Maintenance 5,571.50 6,050.00 (478.50) 33,429.00 36,750.00 (3,321.00) 72,600.00 39,171.00 54.0%6800194 Equipment Leases-Trailer512.61 600.00 (87.39) 2,823.05 3,600.00 (776.95) 7,200.00 4,376.95 60.8%6800196 Equipment Leases-GPS4,500.00 4,700.00 (200.00) 27,000.00 28,200.00 (1,200.00) 56,400.00 29,400.00 52.1%6800197 Equipment Leases-Others1,686.21 1,150.00 536.21 10,130.37 6,900.00 3,230.37 13,800.00 3,669.63 0.0%22,633.77 22,550.00 83.77 135,563.12 135,750.00 (186.88) 271,050.00 135,486.88 50.0%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,320.00 8,320.00 - 49,920.00 49,920.00 - 99,840.00 49,920.00 50.0%6900210 FF&E Reserve5,423.62 5,776.00 (352.38) 18,577.29 18,499.00 78.29 63,985.00 45,407.71 71.0%6900800 Personal Property Taxes- - - 12,117.83 11,800.00 317.83 11,800.00 (317.83) -2.7%6900323 Insurance-Commercial3,811.25 2,200.00 1,611.25 18,823.00 13,200.00 5,623.00 26,400.00 7,577.00 28.7%17,554.87 16,296.00 1,258.87 99,438.12 93,419.00 6,019.12 202,025.00 102,586.88 50.8%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementDecember 2015Annual BudgetMonth to Date Year to Date11 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2015‐20162015 2015 2015 2015 2015 2015Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia24414SalesPromotion4Golf IndustryVIPCelebrityPGA Comp383738112366Charity/Gift Certificate72626Rain/Wind Checks12129Club Staff956280652111LQ HS Golf2117182530168 121 14319112 2602016 2016 2016 2016 2016 2016Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2015‐2016December 2015 Date Time DescriptionCategoryPlayers12/8/2015 10:45:00 AM Walt Nelson - Cascade Golfer Media 212/11/2015 8:00:00 AM Lee MacKay - New England Publishing Media 412/19/2015 10:00:00 AM CVB FAM Trip Promo 412/19/2015 11:30:00 AM Kris Long - CBS2 Media 413