Loading...
06 December 2016 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2016 – December 2016 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 DecemberFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue302,629.50 288,794.00 13,835.50 4.8% 929,599.23 733,830.00 195,769.23 3,199,237.00 2,269,637.77 29%401000 Miscellaneous Golf Revenue38,938.50 41,625.00 (2,686.50) -6.5% 120,221.42 107,688.00 12,533.42 349,259.00 229,037.58 34%410000Revenue-Golf Shop22,100.61 25,625.00 (3,524.39) -13.8%81,159.39 72,113.00 9,046.39 278,585.00 197,425.61 29%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 Income- - - 0.26 - 0.26 - (0.26) 0%Total Income365,168.61 357,544.00 7,624.61 2.1% 1,136,980.30 919,631.00 217,349.30 3,839,081.00 2,702,100.70 30%Cost of Goods Sold510000 COS-Golf Shop14,480.30 14,342.50 137.80 -1.0% 47,533.66 40,361.54 (7,172.12) 155,924.00 108,390.34 30%Total COS14,480.30 14,342.50 137.80 -1.0% 47,533.66 40,361.54 (7,172.12) 155,924.00 108,390.34 30%Gross Profit350,688.31 343,201.50 7,486.81 2.2% 1,089,446.64 879,269.46 210,177.18 3,683,157.00 2,593,710.36 30%Expenses610000 Golf Pro Shop18,191.15 18,594.00 (402.85) 2.2% 88,429.75 86,849.00 1,580.75 204,827.00 116,397.25 43%630000 Course Maintenance118,856.09 130,599.00 (11,742.91) 9.0% 894,235.35 953,355.00 (59,119.65) 1,712,795.00 818,559.65 52%633000 Maintenance Water & Energy14,980.49 16,775.00 (1,794.51) 10.7% 110,316.09 119,356.00 (9,039.91) 225,129.00 114,812.91 49%640000 Outside Services28,176.38 31,248.00 (3,071.62) 9.8% 132,357.29 130,838.00 1,519.29 309,830.00 177,472.71 43%650000 Clubhouse10,830.80 10,636.00 194.80 -1.8% 65,498.89 67,216.00 (1,717.11) 136,332.00 70,833.11 48%660000 Marketing28,149.32 27,049.00 1,100.32 -4.1% 116,661.12 110,278.00 6,383.12 240,177.00 123,515.88 49%670000 General & Administrative24,650.33 30,511.00 (5,860.67) 19.2% 149,314.80 162,550.00 (13,235.20) 327,511.00 178,196.20 46%680000 Leases26,080.45 28,800.00 (2,719.55) 9.4% 151,213.74 148,250.00 2,963.74 271,050.00 119,836.26 56%690000 Miscellaneous Other Expense18,713.20 17,129.00 1,584.20 -9.2% 107,748.31 94,595.00 13,153.31 202,025.00 94,276.69 53%Total Expenses288,628.21 311,341.00 (22,712.79) 7.3% 1,815,775.34 1,873,287.00 57,511.66 3,629,676.00 1,813,900.66 50%62,060.10 31,860.50 30,199.60 94.8%(726,328.70) (994,017.54) 267,688.84 53,481.00 779,809.70 0%Rounds of Golf PlayedPaid Rounds Played4,307 4,100 207 5.0%17,496 12,850 4,646 46,475 28,979 38%Ave $ Per Paid Round Green Fee70.26 70.44 (0.17) -0.2%53.13 57.11 (3.98) 68.84 15.71 77%Ave $ Per Paid Round Merchandise5.13 6.25 (1.12) -17.9%4.64 5.61 (0.97) 5.99 1.36 77%Ave $ Per Paid Miscellaneous 9.04 10.15 (1.11) -10.9%6.87 8.38 (1.51) 7.51 0.64 91%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateDecember 20161 Income DecemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees302,629.50 288,794.00 13,835.50 929,599.23 733,830.00 195,769.23 3,199,237.00 2,269,637.77 70.9%4010000 Rider Fee840.00 1,025.00 (185.00) 3,382.50 1,901.00 1,481.50 7,738.00 4,355.50 56.3%4040000 Club Rental2,165.00 2,050.00 115.00 9,355.00 6,429.00 2,926.00 23,238.00 13,883.00 59.7%4050000 Driving Range8,847.00 10,250.00 (1,403.00) 26,629.00 29,158.00 (2,529.00) 100,984.00 74,355.00 73.6%4060000 Handicap Fees- - - 33.12 - 33.12 2,500.00 2,466.88 98.7%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- - - 995.30 2,000.00 (1,004.70) 4,000.00 3,004.70 75.1%4091000 Golf Professional Rental Fee6,611.50 5,000.00 1,611.50 12,611.50 10,000.00 2,611.50 37,000.00 24,388.50 65.9%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue20,475.00 22,800.00 (2,325.00) 67,215.00 56,800.00 10,415.00 171,200.00 103,985.00 60.7% Total Revenue Fees341,568.00 330,419.00 11,149.00 1,049,820.65 841,518.00 208,302.65 3,548,497.00 2,498,676.35 70.4%341,568.00 330,419.00 11,149.00 1,049,820.65 841,518.00 208,302.65 3,548,497.00 2,498,676.35 70.4%SilverRock ResortStatement of Fees RevenueDecember 2016Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$22,100.61$25,625.00(3,524.39)Unfavorable: Consumer spending on golf merchandise/accessories continue to lag in the industry. Increased promotions and sales will be needed to increase activity. ExpensesActualBudgetVariance$14,480.30$14,342.50137.80Unfavorable: COS high due to discounting inventory in an effort to keep the shop current with more cooler weather apparel.ActualBudgetVariance$118,856.09$130,599.00(11,742.91)Favorable: Due to reduction in usage of seed. We reduced the amount applied per square acre in an effort to reduce costs.ActualBudgetVariance$14,980.49$16,775.00(1,794.51)Favorable: Due to an increase in the amount of rain for the month of December. Less pump run time and less water.ActualBudgetVariance$24,650.33$30,511.00(5,860.67)Favorable: Due to miscellaneous expenses down for the month.Pro Shop Cost of SalesGeneral and Administrativeprovided for those cost of sales percentage that are greater than 5%.Variance ExplanationDecember 2016The 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 arePro Shop Merchandise SalesMaintenance Water and EnergyMaintenance3-20-133 Income DecemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous222.00 - 222.00 3,875.29 - 3,875.29 00 0%4100110 Sales Hard Goods6,828.57 8,969.00 (2,140.43) 30,295.92 25,240.00 5,055.92 97,505.00 67,209.08 68.9%4100112 Sales-Soft Goods18,883.75 16,656.00 2,227.75 59,529.25 46,873.00 12,656.25 181,080.00 121,550.75 67.1%5100639 GS-Discounts-Mdse (3,833.71) - (3,833.71) (12,541.07) - (12,541.07) - 12,541.07 0.0% Total Revenue Golf Shop22,100.61 25,625.00 (3,524.39) 81,159.39 72,113.00 9,046.39 278,585.00 201,300.90 72.3%COS 5100150 COS-GS-Hard Goods 4,290.52 5,202.02 (911.50) 15,557.73 14,639.20 918.53 56,552.90 40,995.17 72.5%5100151 COS-GS-Soft Goods 9,990.06 9,660.48 329.58 30,383.41 27,186.34 3,197.07 105,026.40 74,642.99 71.1%5100152 COS-GS-Purchase Disc (188.72) (743.00) 554.28 (248.21) (2,092.00) 1,843.79 (8,079.00) (7,830.79) 96.9%5100220 COS-GS-Freight Merch 388.44 223.00 165.44 1,840.73 628.00 1,212.73 2,424.00 583.27 24.1%Cost of Sales - Golf Shop14,480.30 14,342.50 137.80 47,533.66 40,361.54 7,172.12 155,924.30 108,390.64 69.5%Gross Profit7,620.31 11,282.50 (3,662.19) 33,625.73 31,751.46 1,874.27 122,660.70 92,910.26 75.7%COS %65.5% 56.0% -9.5% 58.6% 56.0% -2.6% 53.1% 53.8% 101.4%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group2,333.12 2,387.00 (53.88) 11,850.43 11,935.00 (84.57) 27,621.00 15,770.57 57.1%6101325 Insurance-Workers Comp 450.50 478.00 (27.50) 2,413.57 2,157.00 256.57 5,042.00 2,628.43 52.1%6101720 Salaries4,000.00 4,001.00 (1.00) 24,007.00 24,006.00 1.00 45,000.00 20,993.00 46.7%6101800 Taxes-Employer Payroll 1,702.57 1,786.00 (83.43) 6,263.39 8,052.00 (1,788.61) 18,825.00 12,561.61 66.7%6101880 Wages-Hourly8,922.29 8,757.00 165.29 36,635.32 33,514.00 3,121.32 89,463.00 52,827.68 59.0%6101882 Wages-Overtime41.26 - 41.26 117.39 - 117.39 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 17,449.74 17,409.00 40.74 81,287.10 79,664.00 1,623.10 185,951.00 105,734.17 56.9%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office21.48 250.00 (228.52) 533.33 1,500.00 (966.67) 3,000.00 2,466.67 82.2%6109220 Freight & Delivery- 25.00 (25.00) 16.80 75.00 (58.20) 75.00 58.20 77.6%6109490 Miscellaneous500.00 500.00 - 3,000.00 3,000.00 - 6,000.00 3,000.00 50.0%6109150 Dues and Subscriptions- - - 1,103.62 - 1,103.62 2,300.00 1,196.38 52.0%6109500 ProShop-Over/Short(13.37) - (13.37) 48.13 - 48.13 - (48.13) 0.0%6109722 Seminars/Training55.00 100.00 (45.00) 55.00 1,050.00 (995.00) 3,690.00 3,635.00 98.5%6109810 Travel - Merchandise- - - - - - 90.00 90.00 100.0%6109820 Uniforms121.23 200.00 (78.77) 2,042.87 900.00 1,142.87 2,400.00 357.13 14.9%6117840 Telephones57.07 110.00 (52.93) 342.90 660.00 (317.10) 1,320.00 977.10 74.0%741.41 1,185.00 (443.59) 7,142.65 7,185.00 (42.35) 18,875.00 11,732.35 62.2%18,191.15 18,594.00 (402.85) 88,429.75 86,849.00 1,580.75 204,826.00 117,466.52 57.3%Net Income(10,570.84) (7,311.50) (3,259.34) (54,804.02) (55,097.54) 293.52 (82,165.30) (24,556.26) 29.9%SilverRock ResortGolf Shop Income StatementDecember 2016Total Expenses-Golf ShopMonth to Date Year to Date Annual Budget4 DecemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group8,562.29 8,990.00 (427.71) 47,115.58 53,940.00 (6,824.42) 107,880.00 60,764.42 56.3%6311325 Insurance-Workers Comp1,988.50 2,181.00 (192.50) 11,704.01 11,563.00 141.01 24,794.00 13,089.99 52.8%6311720 Salaries9,337.17 9,333.33 3.84 63,517.57 55,999.98 7,517.59 142,017.20 78,499.63 55.3%6311800 Taxes-Employer Payroll7,245.34 8,143.00 (897.66) 34,847.94 43,653.00 (8,805.06) 93,302.00 58,454.06 62.7%6311880 Wages-Hourly48,826.75 48,833.67 (6.92) 257,823.97 245,290.02 12,533.95 508,481.80 250,657.83 49.3%6311882 Wages-Overtime715.65 - 715.65 12,291.95 10,526.00 1,765.95 15,945.00 3,653.05 22.9%Total-CM-SALARIES & BENEFITS76,675.70 77,481.00 (805.30) 427,301.02 420,972.00 6,329.02 892,420.00 465,118.98 52.1%63-CM-SUPPLIES & MATERIALS6313734 Chemicals - 2,200.00 (2,200.00) 13,017.29 22,700.00 (9,682.71) 34,600.00 21,582.71 62.4%6313744 Fertilizer4,802.34 9,000.00 (4,197.66) 57,579.54 70,000.00 (12,420.46) 112,500.00 54,920.46 48.8%6313745 Herbicides5,000.00 5,000.00 - 12,882.04 17,000.00 (4,117.96) 17,000.00 4,117.96 24.2%6313746 Flowers/Plants280.65 750.00 (469.35) 1,520.65 2,000.00 (479.35) 3,050.00 1,529.35 50.1%6313748 Fuel-Gasoline819.81 4,000.00 (3,180.19) 15,625.31 31,600.00 (15,974.69) 55,020.00 39,394.69 71.6%6313750 Golf Course Accessories2,313.94 1,200.00 1,113.94 8,593.43 12,300.00 (3,706.57) 13,000.00 4,406.57 33.9%6313756 POA Control- - - 6,349.28 3,500.00 2,849.28 7,000.00 650.72 9.3%6313758 Miscellaneous Supp295.06 500.00 (204.94) 3,645.35 3,750.00 (104.65) 4,350.00 704.65 16.2%6313762 Supplies-Office45.13 - 45.13 1,370.73 - 1,370.73 - (1,370.73) 0.0%6313774 Sand- 800.00 (800.00) 8,806.17 12,580.00 (3,773.83) 13,460.00 4,653.83 34.6%6313776 Seed- 350.00 (350.00) 117,164.38 123,800.00 (6,635.62) 125,900.00 8,735.62 6.9%6313778 Small Tools & Non-Capital Equip44.03 100.00 (55.97) 1,921.81 4,400.00 (2,478.19) 5,000.00 3,078.19 61.6%6313780 Sod- 250.00 (250.00) 11,636.88 9,250.00 2,386.88 10,450.00 (1,186.88) -11.4%6313782 Topdressing- - - 4,582.66 8,000.00 (3,417.34) 10,600.00 6,017.34 56.8%Total-CM-SUPPLIES & MATERIALS13,600.96 24,150.00 (10,549.04) 264,695.52 320,880.00 (56,184.48) 411,930.00 147,234.48 35.7%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,600.00 2,600.00 - 16,750.00 15,600.00 1,150.00 31,200.00 14,450.00 46.3%6315685 CM-R&M-Bldngs & Othr Structures 107.12 500.00 (392.88) 1,650.72 4,050.00 (2,399.28) 5,550.00 3,899.28 70.3%6315690 CM-R&M-Equipment2,548.21 2,000.00 548.21 22,826.71 23,500.00 (673.29) 40,000.00 17,173.29 42.9%6315692 CM-R&M-Irrigation System804.47 550.00 254.47 14,790.29 12,850.00 1,940.29 19,050.00 4,259.71 22.4%6315696 CM-R&M-Pumps- 1,000.00 (1,000.00) 3,465.55 6,000.00 (2,534.45) 10,500.00 7,034.45 67.0%6315815 CM-R&M-Trees-Pruning Etc- - - 6,071.00 6,050.00 21.00 12,050.00 5,979.00 49.6%Total-CM-REPAIRS & MAINTENANCE6,059.80 6,650.00 (590.20) 65,554.27 68,050.00 (2,495.73) 118,350.00 52,795.73 44.6%6317836 Utilities-Natural Gas/LPG21.14 15.00 6.14 138.75 90.00 48.75 180.00 41.25 0.0%6317840 Telephones666.54 850.00 (183.46) 5,057.79 5,100.00 (42.21) 10,200.00 5,142.21 50.4%Total-CM-UTILITIES 687.68 865.00 (177.32) 5,196.54 5,190.00 6.54 10,380.00 5,183.46 49.9%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 400.00 500.00 (100.00) 2,400.00 3,000.00 (600.00) 6,000.00 3,600.00 60.0%6319100 Contract Svcs-Soil/Tissue Test- - - 730.80 2,000.00 (1,269.20) 4,000.00 3,269.20 81.7%6319102 Contract Svcs-Trash Removal694.00 524.00 170.00 4,507.86 3,144.00 1,363.86 6,288.00 1,780.14 28.3%6319150 Dues & Subscriptions300.00 - 300.00 565.00 - 565.00 540.00 (25.00) -4.6%6319170 Employee Education- 50.00 (50.00) - 300.00 (300.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental- 200.00 (200.00) 737.04 2,300.00 (1,562.96) 3,400.00 2,662.96 78.3%6319206 Licenses & Permits- - - 1,429.26 280.00 1,149.26 4,180.00 2,750.74 65.8%6319490 Miscellaneous67.00 100.00 (33.00) 636.55 600.00 36.55 1,200.00 563.45 47.0%6319718 Safety Equipment & Training204.66 400.00 (195.34) 1,987.69 2,750.00 (762.31) 3,850.00 1,862.31 48.4%6319822 Uniforms2,192.08 920.00 1,272.08 6,181.35 5,520.00 661.35 11,040.00 4,858.65 44.0%Total-CM-OTHER EXPENSES3,857.74 2,694.00 1,163.74 19,175.55 19,894.00 (718.45) 42,048.00 22,872.45 54.4%Month to Date Year to DateSilverRock ResortCourse Maintenance Expense StatementDecember 2016Annual Budget5 DecemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group2,867.62 2,728.00 139.62 17,204.87 16,368.00 836.87 32,736.00 15,531.13 47.4%6321325 Insurance-Workers Comp480.10 483.00 (2.90) 2,642.81 3,031.00 (388.19) 6,171.00 3,528.19 57.2%6321800 Taxes-Employer Payroll1,255.81 1,803.00 (547.19) 6,180.48 11,562.00 (5,381.52) 23,334.00 17,153.52 73.5%6321880 Wages-Hourly12,824.96 12,880.00 (55.04) 79,372.02 77,280.00 2,092.02 160,320.00 80,947.98 50.5%6321882 Wages-Overtime- - - 5,458.15 5,313.00 145.15 6,351.00 892.85 14.1%Total-CM-LM-SALARIES & BENEFITS 17,428.49 17,894.00 (465.51) 110,858.33 113,554.00 (2,695.67) 228,912.00 118,053.67 51.6%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) - 575.00 (575.00) 1,025.00 1,025.00 100.0%6323788 Uniforms545.72 290.00 255.72 1,454.12 1,740.00 (285.88) 3,480.00 2,025.88 58.2%Total-CM-LM-SUPPLIES & MATERIALS 545.72 365.00 180.72 1,454.12 2,315.00 (860.88) 4,505.00 3,050.88 67.7%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%118,856.09 130,599.00 (11,742.91) 894,235.35 953,355.00 (59,119.65) 1,712,795.00 818,559.65 47.8% DecemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping7,737.30 9,090.00 (1,352.70) 65,929.22 72,790.00 (6,860.78) 179,791.00 113,861.78 63.3%6337842 Utilities-Water7,243.19 7,685.00 (441.81) 44,386.87 46,566.00 (2,179.13) 45,338.00 951.13 2.1%14,980.49 16,775.00 (1,794.51) 110,316.09 119,356.00 (9,039.91) 225,129.00 114,812.91 51.0%Total-COURSE MAINTENANCECourse Maintenance Expense StatementDecember 2016Silverrock ResortAnnual BudgetMonth to DateYear to DateSilverrock ResortCourse Maintenance Water & EnergyDecember 2016Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual Budget6 DecemberFinal 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 Comp505.50 564.00 (58.50) 2,208.65 1,978.00 230.65 5,229.00 3,020.35 57.8%6411800 Taxes-Employer Payroll2,069.59 1,871.00 198.59 5,449.22 6,565.00 (1,115.78) 17,360.00 11,910.78 68.6%6411880 Wages-Hourly15,874.50 15,030.00 844.50 58,250.31 52,735.00 5,515.31 139,434.00 81,183.69 58.2%6411882 Wages-Overtime249.75 - 249.75 1,179.75 - 1,179.75 - (1,179.75) 0.0%Total-CBR-SALARIES & BENEFITS18,699.34 18,147.00 552.34 67,087.93 65,370.00 1,717.93 170,207.00 103,119.07 60.6%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- 500.00 (500.00) - 1,500.00 (1,500.00) 1,850.00 `0.0%6413742 Supplies-Expendable629.62 150.00 479.62 2,754.80 3,450.00 (695.20) 6,750.00 3,995.20 59.2%6413748 Supplies-Fuel for Shuttle108.90 400.00 (291.10) 108.90 900.00 (791.10) 3,000.00 2,891.10 96.4%6413752 Supplies-Range Balls- - - 10,692.00 9,000.00 1,692.00 9,000.00 (1,692.00) -18.8%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-Towels471.34 195.00 276.34 1,991.34 860.00 1,131.34 2,182.00 190.66 8.7%6413796 Supplies-Bottled Water- 50.00 (50.00) 8,117.54 3,750.00 4,367.54 11,000.00 2,882.46 26.2%Total-CBR-SUPPLIES & MATERIALS1,209.86 1,345.00 (135.14) 23,664.58 19,685.00 3,979.58 34,727.00 9,212.42 26.5%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment- 300.00 (300.00) 1,648.55 1,800.00 (151.45) 3,600.00 1,951.45 54.2%6415695 CBR-R&M-Cart Maintenance & Repair- 500.00 (500.00) 2,956.45 3,450.00 (493.55) 6,450.00 3,493.55 54.2%Total-CBR-REPAIRS & MAINTENANCE- 800.00 (800.00) 4,605.00 5,250.00 (645.00) 10,050.00 5,445.00 54.2%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen570.14 800.00 (229.86) 4,019.81 4,800.00 (780.19) 9,600.00 5,580.19 58.1%6419220 Freight/Delivery- 75.00 (75.00) - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous94.87 600.00 (505.13) 351.97 3,600.00 (3,248.03) 7,200.00 6,848.03 95.1%6419820 Uniforms- 500.00 (500.00) 2,880.44 3,000.00 (119.56) 5,200.00 2,319.56 44.6%Total-CBR-OTHER EXPENSES665.01 1,975.00 (1,309.99) 7,252.22 11,850.00 (4,597.78) 22,450.00 15,197.78 67.7%TOTAL-CARTS,BAGROOM & RANGE20,574.21 22,267.00 (1,309.99) 102,609.73 102,155.00 454.73 237,434.00 132,974.27 56.0%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp510.80 272.00 238.80 1,447.83 840.00 607.83 2,179.00 731.17 33.6%6431800 Taxes-Employer Payroll787.37 1,014.00 (226.63) 2,122.13 3,136.00 (1,013.87) 8,135.00 6,012.87 73.9%6431880 Wages-Hourly5,875.00 7,245.00 (1,370.00) 24,245.23 22,407.00 1,838.23 58,108.00 33,862.77 58.3%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS7,173.17 8,531.00 (1,357.83) 27,815.19 26,383.00 1,432.19 68,422.00 40,606.81 59.3%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 100.00 (100.00) 121.84 500.00 (378.16) 1,050.00 928.16 88.4%6439490 Miscellaneous429.00 50.00 379.00 429.00 150.00 279.00 200.00 (229.00) -114.5%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,381.53 1,350.00 31.53 2,125.00 743.47 35.0%Total-CS-OTHER EXPENSES429.00 450.00 (21.00) 1,932.37 2,300.00 (367.63) 3,975.00 2,042.63 51.4%Total-COURSE SERVICES7,602.17 8,981.00 (1,378.83) 29,747.56 28,683.00 1,064.56 72,397.00 42,649.44 58.9%28,176.38 31,248.00 (3,071.62) 132,357.29 130,838.00 1,519.29 309,831.00 173,581.08 56.0%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementDecember 2016Annual Budget7 DecemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable400.00 400.00 - 2,400.00 2,400.00 - 4,800.00 2,400.00 50.0%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 2,400.00 2,400.00 - 4,800.00 2,400.00 50.0%65-CH-UTILITIES6507836 Utilities-Natural Gas295.92 300.00 (4.08) 1,926.74 1,800.00 126.74 3,600.00 1,673.26 46.5%6507840 Utilities-Telephone1,153.25 1,150.00 3.25 6,833.03 6,900.00 (66.97) 13,800.00 6,966.97 50.5%6507842 Utilities-Water692.47 321.00 371.47 1,456.50 1,926.00 (469.50) 3,852.00 2,395.50 62.2%6507844 Utilities-Cable490.47 340.00 150.47 2,926.05 2,040.00 886.05 4,080.00 1,153.95 28.3%Total-CH-UTILITIES2,632.11 2,111.00 521.11 13,142.32 12,666.00 476.32 25,332.00 12,189.68 48.1%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,750.00 1,825.00 (75.00) 10,980.00 11,550.00 (570.00) 22,500.00 11,520.00 51.2%6509099 Contract Services-Security5,653.56 4,900.00 753.56 31,704.84 29,400.00 2,304.84 60,400.00 28,695.16 47.5%6509215 Flowers & Decorations63.73 - 63.73 382.38 500.00 (117.62) 1,900.00 1,517.62 79.9%6509490 Miscellaneous139.00 200.00 (61.00) 1,766.98 3,500.00 (1,733.02) 7,000.00 5,233.02 74.8%6509718 Safety Equipment & Training- 100.00 (100.00) 258.26 600.00 (341.74) 1,200.00 941.74 78.5%Total-CH-OTHER EXPENSES7,606.29 7,025.00 581.29 45,092.46 45,550.00 (457.54) 93,000.00 47,907.54 51.5%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures192.40 300.00 (107.60) 2,251.11 1,800.00 451.11 3,600.00 1,348.89 37.5%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 1,695.00 2,400.00 (705.00) 4,800.00 3,105.00 64.7%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 918.00 2,400.00 (1,482.00) 4,800.00 3,882.00 80.9%Total-CH-REPAIRS & MAINTENANCE192.40 1,100.00 (907.60) 4,864.11 6,600.00 (1,735.89) 13,200.00 8,335.89 63.2%10,830.80 10,636.00 194.80 65,498.89 67,216.00 (1,717.11) 136,332.00 16,671.78 12.2%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementDecember 2016Annual Budget8 DecemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group340.00 341.00 (1.00) 1,732.00 2,046.00 (314.00) 4,092.00 2,360.00 57.7%6601325 Insurance-Workers Comp87.10 94.00 (6.90) 538.40 564.00 (25.60) 1,129.00 590.60 52.3%6601720 Salaries2,504.96 2,508.00 (3.04) 14,029.76 15,048.00 (1,018.24) 30,096.00 16,066.24 53.4%6601800 Taxes-Employer Payroll295.20 351.00 (55.80) 1,020.80 2,106.00 (1,085.20) 4,213.00 3,192.20 75.8%Total-MKT-SALARIES & BENEFITS 3,227.26 3,294.00 (66.74) 17,320.96 19,764.00 (2,443.04) 39,530.00 22,209.04 56.2%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 210.56 100.00 110.56 1,214.03 600.00 614.03 1,200.00 (14.03) -1.2%6603768 Supplies-Printing & Stationery 2,207.27 200.00 2,007.27 3,640.35 3,600.00 40.35 4,425.00 784.65 17.7%2,417.83 300.00 2,117.83 4,854.38 4,200.00 654.38 5,625.00 770.62 13.7%66-MKT-UTILITIES6607840 Utilities-Telephone 85.08 100.00 (14.92) 413.48 600.00 (186.52) 1,200.00 786.52 65.5%Total-MKT-UTILITIES85.08 100.00 (14.92) 413.48 600.00 (186.52) 1,200.00 786.52 65.5%66-MKT-OTHER EXPENSES6609010 Advertising20,952.39 21,730.00 (777.61) 87,864.80 79,414.00 8,450.80 178,987.00 91,122.20 50.9%6609040 Business Meals- 25.00 (25.00) - 150.00 (150.00) 300.00 300.00 100.0%6609080 Collateral Material9.61 - 9.61 3,046.03 1,500.00 1,546.03 5,500.00 2,453.97 44.6%6609102 Contract Services-Web Page99.00 150.00 (51.00) 594.00 900.00 (306.00) 1,800.00 1,206.00 67.0%6609490 Miscellaneous- 50.00 (50.00) 533.70 100.00 433.70 350.00 (183.70) -52.5%6609620 Postage- 50.00 (50.00) - 300.00 (300.00) 600.00 600.00 100.0%6609630 Promotion- 50.00 (50.00) 97.09 150.00 (52.91) 700.00 602.91 86.1%6609633 Promotion-Community- 750.00 (750.00) 310.27 1,800.00 (1,489.73) 2,250.00 1,939.73 86.2%6609634 Promotion-Media/Vendor1,308.71 500.00 808.71 1,308.71 1,000.00 308.71 2,000.00 691.29 34.6%6609150 Dues and Subscriptions- - - 82.50 - 82.50 735.00 652.50 88.8%6609820 Uniforms49.44 50.00 (0.56) 235.20 400.00 (164.80) 600.00 364.80 60.8%Total-MKT-OTHER EXPENSES22,419.15 23,355.00 (935.85) 94,072.30 85,714.00 8,358.30 193,822.00 99,749.70 51.5%28,149.32 27,049.00 1,100.32 116,661.12 110,278.00 6,383.12 240,177.00 123,515.88 51.4%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementDecember 2016Annual Budget9 DecemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group 1,212.50 1,488.00 (275.50) 6,600.45 8,928.00 (2,327.55) 17,856.00 11,255.55 63.0%6701325 Insurance-Workers Comp609.20 662.00 (52.80) 3,478.12 3,746.00 (267.88) 7,717.00 4,238.88 54.9%6701720 Salaries14,179.20 15,050.00 (870.80) 80,721.50 84,300.00 (3,578.50) 177,996.00 97,274.50 54.6%6701800 Taxes-Employer Payroll1,313.51 2,471.00 (1,157.49) 7,538.93 13,986.00 (6,447.07) 28,812.00 21,273.07 73.8%6701880 Wages-Hourly2,516.00 2,600.00 (84.00) 16,693.70 15,750.00 943.70 27,800.00 11,106.30 40.0%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 19,830.41 22,271.00 (2,440.59) 115,032.70 126,710.00 (11,677.30) 260,181.00 145,148.30 55.8%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer471.41 500.00 (28.59) 2,163.27 3,000.00 (836.73) 6,300.00 4,136.73 65.7%6703762 Supplies-Office41.90 150.00 (108.10) 307.83 900.00 (592.17) 1,800.00 1,492.17 82.9%6703768 Supplies-Printing & Stationery759.77 400.00 359.77 1,236.64 900.00 336.64 3,300.00 2,063.36 62.5%Total-G&A-SUPPLIES & MATERIALS1,273.08 1,050.00 223.08 3,707.74 4,800.00 (1,092.26) 11,400.00 7,692.26 67.5%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 5,055.93 1,300.00 3,755.93 1,900.00 (3,155.93) -166.1%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 5,055.93 1,300.00 3,755.93 1,900.00 (3,155.93) -166.1%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance 500.00 500.00 - 3,000.00 3,000.00 - 4,800.00 1,800.00 37.5%6709150 Dues & Subscriptions- 200.00 (200.00) - 550.00 (550.00) 1,700.00 1,700.00 100.0%6709180 Employee Recruiting/Relocation234.00 200.00 34.00 384.00 800.00 (416.00) 1,400.00 1,016.00 72.6%6709197 Equipment Rental505.01 550.00 (44.99) 3,371.39 3,300.00 71.39 6,600.00 3,228.61 48.9%6709202 Fees-Bank123.36 90.00 33.36 693.61 540.00 153.61 1,080.00 386.39 35.8%6709208 Fees-Payroll Processing400.43 1,200.00 (799.57) 4,859.99 7,200.00 (2,340.01) 14,400.00 9,540.01 66.3%6709220 Freight/Delivery- 50.00 (50.00) 31.72 300.00 (268.28) 600.00 568.28 94.7%6709490 Miscellaneous724.55 3,000.00 (2,275.45) 3,596.92 6,000.00 (2,403.08) 1,200.00 (2,396.92) -199.7%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services107.99 75.00 32.99 615.76 450.00 165.76 900.00 284.24 31.6%6709625 Professional Fees701.50 850.00 (148.50) 7,593.92 5,100.00 2,493.92 10,200.00 2,606.08 25.5%6709636 Promotion/Entertainment- 100.00 (100.00) - 600.00 (600.00) 6,600.00 6,600.00 100.0%6709722 Seminars & Training250.00 200.00 50.00 1,050.00 1,200.00 (150.00) 2,400.00 1,350.00 56.3%6709810 Travel- - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 900.00 321.12 600.00 (278.88) 1,050.00 728.88 69.4%Total-G&A-OTHER EXPENSES 3,546.84 7,090.00 (2,568.16) 25,518.43 29,740.00 (4,221.57) 54,030.00 28,511.57 52.8%24,650.33 30,511.00 (5,860.67) 149,314.80 162,550.00 (13,235.20) 327,511.00 178,196.20 54.4%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementDecember 2016Annual Budget10 DecemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts9,463.45 10,050.00 (586.55) 60,817.25 60,750.00 67.25 121,050.00 60,232.75 49.8%6800193 Equipment Leases-Maintenance 10,683.20 11,500.00 (816.80) 44,297.70 47,200.00 (2,902.30) 72,600.00 28,302.30 39.0%6800194 Equipment Leases-Trailer542.07 600.00 (57.93) 3,512.42 3,600.00 (87.58) 7,200.00 3,687.58 51.2%6800196 Equipment Leases-GPS3,870.00 4,700.00 (830.00) 30,600.00 28,200.00 2,400.00 56,400.00 25,800.00 45.7%6800197 Equipment Leases-Others1,521.73 1,950.00 (428.27) 11,986.37 8,500.00 3,486.37 13,800.00 1,813.63 0.0%26,080.45 28,800.00 (2,719.55) 151,213.74 148,250.00 2,963.74 271,050.00 119,836.26 44.2%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,653.00 8,653.00 - 51,917.00 51,918.00 (1.00) 99,840.00 47,923.00 48.0%6900210 FF&E Reserve6,052.59 5,776.00 276.59 18,591.99 14,677.00 3,914.99 63,985.00 45,393.01 70.9%6900800 Personal Property Taxes- - - 10,871.10 11,800.00 (928.90) 11,800.00 928.90 7.9%6900323 Insurance-Commercial4,007.61 2,700.00 1,307.61 26,368.22 16,200.00 10,168.22 26,400.00 31.78 0.1%18,713.20 17,129.00 1,584.20 107,748.31 94,595.00 13,153.31 202,025.00 94,276.69 46.7%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementDecember 2016Annual BudgetMonth to Date Year to Date11 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2016-20172016 2016 2016 2016 2016 2016Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia4 828SalesPromotionGolf IndustryVIPCelebrityPGA Comp34 45 47 20 13 33Charity/Gift Certificate1847Rain/Wind Checks113Club Staff47 61 63 19 25 82LQ HS Golf58844892 122 130 43 43 1612017 2017 2017 2017 2017 2017Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2016-2017December 2016 Date TimeDescriptionCategoryPlayers12/3/2017 10:38 a.m. John WhiteMedia412/4/20174 11:00-12:00 PS Media Classic (all writers and golf journalists)Media 2413