Loading...
09 March 2017 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2016 – March 2017 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 MarchFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue582,514.85 554,175.00 28,339.85 5.1% 2,415,593.83 2,173,186.00 242,407.83 3,199,237.00 783,643.17 76%401000 Miscellaneous Golf Revenue51,228.50 49,125.00 2,103.50 4.3% 271,992.67 266,413.00 5,579.67 349,259.00 77,266.33 78%410000Revenue-Golf Shop35,265.82 42,000.00 (6,734.18) -16.0%178,648.44 183,864.00 (5,215.56) 278,585.00 99,936.56 64%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0% 10,500.00 10,500.00 - 12,000.00 1,500.00 88%890000 Interest Income0.09 - 0.09 0.43 - 0.43 - (0.43) 0%Total Income670,509.26 646,800.00 23,709.26 3.7% 2,876,735.37 2,633,963.00 242,772.37 3,839,081.00 962,345.63 75%Cost of Goods Sold510000 COS-Golf Shop18,813.69 23,507.00 (4,693.31) 20.0% 100,278.66 102,908.12 2,629.46 155,924.00 55,645.34 64%Total COS18,813.69 23,507.00 (4,693.31) 20.0% 100,278.66 102,908.12 2,629.46 155,924.00 55,645.34 64%Gross Profit651,695.57 623,293.00 28,402.57 4.6% 2,776,456.71 2,531,054.88 245,401.83 3,683,157.00 906,700.29 75%Expenses610000 Golf Pro Shop18,271.76 18,519.00 (247.24) 1.3% 141,437.47 143,921.00 (2,483.53) 204,827.00 63,389.53 69%630000 Course Maintenance127,484.44 118,374.00 9,110.44 -7.7% 1,262,354.73 1,332,660.00 (70,305.27) 1,712,795.00 450,440.27 74%633000 Maintenance Water & Energy13,088.96 17,252.00 (4,163.04) 24.1% 152,611.84 171,469.00 (18,857.16) 225,129.00 72,517.16 68%640000 Outside Services36,938.37 33,155.00 3,783.37 -11.4% 244,410.43 238,053.00 6,357.43 309,830.00 65,419.57 79%650000 Clubhouse11,065.01 13,436.00 (2,370.99) 17.6% 103,581.66 104,024.00 (442.34) 136,332.00 32,750.34 76%660000 Marketing23,626.32 23,849.00 (222.68) 0.9% 186,536.60 185,099.00 1,437.60 240,177.00 53,640.40 78%670000 General & Administrative25,600.42 27,461.00 (1,860.58) 6.8% 226,037.77 245,433.00 (19,395.23) 327,511.00 101,473.23 69%680000 Leases26,251.29 28,800.00 (2,548.71) 8.8% 230,238.30 234,650.00 (4,411.70) 271,050.00 40,811.70 85%690000 Miscellaneous Other Expense25,589.40 22,437.00 3,152.40 -14.1% 178,429.38 157,442.00 20,987.38 202,025.00 23,595.62 88%Total Expenses307,915.97 303,283.00 4,632.97 -1.5% 2,725,638.18 2,812,751.00 87,112.82 3,629,676.00 904,037.82 75%343,779.60 320,010.00 23,769.60 7.4%50,818.53 (281,696.12) 332,514.65 53,481.00 2,662.47 0%Rounds of Golf PlayedPaid Rounds Played6,464 6,000 464 7.7%34,652 29,160 5,492 46,475 11,823 75%Ave $ Per Paid Round Green Fee90.12 92.36 (2.25) -2.4%69.71 74.53 (4.82) 68.84 (0.87) 101%Ave $ Per Paid Round Merchandise5.46 7.00 (1.54) -22.1%5.16 6.31 (1.15) 5.99 0.84 86%Ave $ Per Paid Miscellaneous 7.93 8.19 (0.26) -3.2%7.85 9.14 (1.29) 7.51 (0.33) 104%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateMarch 20171 Income MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees582,514.85 554,175.00 28,339.85 2,415,593.83 2,173,186.00 242,407.83 3,199,237.00 783,643.17 24.5%4010000 Rider Fee1,675.00 1,500.00 175.00 7,007.50 6,026.00 981.50 7,738.00 730.50 9.4%4040000 Club Rental5,635.00 3,000.00 2,635.00 20,520.00 14,679.00 5,841.00 23,238.00 2,718.00 11.7%4050000 Driving Range17,020.00 22,500.00 (5,480.00) 76,749.00 92,283.00 (15,534.00) 100,984.00 24,235.00 24.0%4060000 Handicap Fees- 400.00 (400.00) 33.12 2,500.00 (2,466.88) 2,500.00 2,466.88 98.7%4080000 GPS Advertising- 100.00 (100.00) - 2,500.00 (2,500.00) 2,600.00 2,600.00 100.0%4090000 Ball Retriever/Subcontract- - - 1,445.30 3,000.00 (1,554.70) 4,000.00 2,554.70 63.9%4091000 Golf Professional Rental Fee8,523.50 6,000.00 2,523.50 35,602.75 27,000.00 8,602.75 37,000.00 1,397.25 3.8%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue18,375.00 15,625.00 2,750.00 130,635.00 118,425.00 12,210.00 171,200.00 40,565.00 23.7% Total Revenue Fees633,743.35 603,300.00 30,443.35 2,687,586.50 2,439,599.00 247,987.50 3,548,497.00 860,910.50 24.3%633,743.35 603,300.00 30,443.35 2,687,586.50 2,439,599.00 247,987.50 3,548,497.00 860,910.50 24.3%SilverRock ResortStatement of Fees RevenueMarch 2017Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$35,265.82$42,000.00(6,734.18)Unfavorable: Consumer spending on golf merchandise/accessories continue to lag in the industry. Increased promotions and sales will be needed to increase activity. ExpensesActualBudgetVariance$36,938.37$33,155.003,783.37Unfavorable: Due to additional payroll as a result on additional rounds played.ActualBudgetVariance$11,065.01$13,436.00(2,370.99)Favorable: Due to reduced utilization of Miscellaneous expenditures.ActualBudgetVariance$13,088.96$17,252.00(4,163.04)Favorable: Due to reduced watering cycles as a result on continued rain.ActualBudgetVariance$25,589.40$22,437.003,152.40Unfavorable: Due to additional cost of commercial insurance.Variance ExplanationMarch 2017The 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 areClubhouseMiscellaneous Other Expenseprovided for those cost of sales percentage that are greater than 5%.Pro Shop Merchandise SalesMaintenance Water and EnergyOutside Services3-20-133 Income MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous557.00 - 557.00 4,937.29 - 4,937.29 00 0%4100110 Sales Hard Goods 13,323.15 14,700.00 (1,376.85) 61,397.77 64,353.00 (2,955.23) 97,505.00 36,107.23 37.0%4100112 Sales-Soft Goods23,949.00 27,300.00 (3,351.00) 133,036.25 119,511.00 13,525.25 181,080.00 48,043.75 26.5%5100639 GS-Discounts-Mdse (2,563.33) - (2,563.33) (20,722.87) - (20,722.87) - 20,722.87 0.0% Total Revenue Golf Shop35,265.82 42,000.00 (6,734.18) 178,648.44 183,864.00 (5,215.56) 278,585.00 104,873.85 37.6%COS 5100150 COS-GS-Hard Goods 8,078.82 8,526.00 (447.18) 33,809.89 37,324.74 (3,514.85) 56,552.90 22,743.01 40.2%5100151 COS-GS-Soft Goods 10,539.35 15,834.00 (5,294.65) 64,162.20 69,316.38 (5,154.18) 105,026.40 40,864.20 38.9%5100152 COS-GS-Purchase Disc (95.17) (1,218.00) 1,122.83 (626.49) (5,333.00) 4,706.51 (8,079.00) (7,452.51) 92.2%5100220 COS-GS-Freight Merch 290.69 365.00 (74.31) 2,933.06 1,600.00 1,333.06 2,424.00 (509.06) -21.0%Cost of Sales - Golf Shop 18,813.69 23,507.00 (4,693.31) 100,278.66 102,908.12 (2,629.46) 155,924.30 55,645.64 35.7%Gross Profit16,452.13 18,493.00 (2,040.87) 78,369.78 80,955.88 (2,586.10) 122,660.70 49,228.21 40.1%COS %53.3% 56.0% 2.6% 56.1% 56.0% -0.2% 53.1% 53.1% 100.0%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group801.90 2,387.00 (1,585.10) 15,951.78 19,096.00 (3,144.22) 27,621.00 11,669.22 42.2%6101325 Insurance-Workers Comp 880.17 478.00 402.17 5,054.08 3,591.00 1,463.08 5,042.00 (12.08) -0.2%6101720 Salaries4,000.00 4,001.00 (1.00) 36,007.00 36,009.00 (2.00) 45,000.00 8,993.00 20.0%6101800 Taxes-Employer Payroll 1,538.72 1,786.00 (247.28) 11,146.23 13,410.00 (2,263.77) 18,825.00 7,678.77 40.8%6101880 Wages-Hourly8,223.68 8,757.00 (533.32) 61,242.89 59,785.00 1,457.89 89,463.00 28,220.11 31.5%6101882 Wages-Overtime307.13 - 307.13 720.60 - 720.60 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 15,751.60 17,409.00 (1,657.40) 130,122.58 131,891.00 (1,768.42) 185,951.00 57,501.90 30.9%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office83.42 250.00 (166.58) 836.00 2,250.00 (1,414.00) 3,000.00 2,164.00 72.1%6109220 Freight & Delivery23.00 - 23.00 39.80 75.00 (35.20) 75.00 35.20 46.9%6109490 Miscellaneous2,336.27 500.00 1,836.27 6,336.27 4,500.00 1,836.27 6,000.00 (336.27) -5.6%6109150 Dues and Subscriptions- - - 1,103.62 - 1,103.62 2,300.00 1,196.38 52.0%6109500 ProShop-Over/Short(18.42) - (18.42) 3.25 - 3.25 - (3.25) 0.0%6109722 Seminars/Training- 35.00 (35.00) 55.00 2,370.00 (2,315.00) 3,690.00 3,635.00 98.5%6109810 Travel - Merchandise- 15.00 (15.00) - 45.00 (45.00) 90.00 90.00 100.0%6109820 Uniforms- 200.00 (200.00) 2,264.52 1,800.00 464.52 2,400.00 135.48 5.6%6117840 Telephones95.89 110.00 (14.11) 676.43 990.00 (313.57) 1,320.00 643.57 48.8%2,520.16 1,110.00 1,410.16 11,314.89 12,030.00 (715.11) 18,875.00 7,560.11 40.1%18,271.76 18,519.00 (247.24) 141,437.47 143,921.00 (2,483.53) 204,826.00 65,062.01 31.8%Net Income(1,819.63) (26.00) (1,793.63) (63,067.69) (62,965.12) (102.57) (82,165.30) (15,833.80) 19.3%SilverRock ResortGolf Shop Income StatementMarch 2017Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group7,901.71 8,990.00 (1,088.29) 78,775.12 80,910.00 (2,134.88) 107,880.00 29,104.88 27.0%6311325 Insurance-Workers Comp2,727.61 2,065.00 662.61 20,467.04 18,041.00 2,426.04 24,308.00 3,840.96 15.8%6311720 Salaries8,444.70 9,333.33 (888.63) 96,640.30 83,999.97 12,640.33 112,000.00 15,359.70 13.7%6311800 Taxes-Employer Payroll6,797.25 7,709.00 (911.75) 53,721.99 67,953.00 (14,231.01) 91,481.00 37,759.01 41.3%6311880 Wages-Hourly44,820.06 45,727.67 (907.61) 397,755.22 388,310.03 9,445.19 525,494.00 127,738.78 24.3%6311882 Wages-Overtime- - - 12,857.39 13,076.00 (218.61) 15,945.00 3,087.61 19.4%Total-CM-SALARIES & BENEFITS70,691.33 73,825.00 (3,133.67) 660,217.06 652,290.00 7,927.06 877,108.00 216,890.94 24.7%63-CM-SUPPLIES & MATERIALS6313734 Chemicals 7,089.82 1,500.00 5,589.82 23,496.64 29,700.00 (6,203.36) 34,600.00 11,103.36 32.1%6313744 Fertilizer5,833.59 6,000.00 (166.41) 67,610.00 97,500.00 (29,890.00) 112,500.00 44,890.00 39.9%6313745 Herbicides- - - 13,179.43 17,000.00 (3,820.57) 17,000.00 3,820.57 22.5%6313746 Flowers/Plants- 100.00 (100.00) 1,520.65 2,950.00 (1,429.35) 3,050.00 1,529.35 50.1%6313748 Fuel-Gasoline4,143.57 3,850.00 293.57 27,465.63 42,870.00 (15,404.37) 55,020.00 27,554.37 50.1%6313750 Golf Course Accessories1,523.76 100.00 1,423.76 11,846.41 12,700.00 (853.59) 13,000.00 1,153.59 8.9%6313756 POA Control18.58 - 18.58 6,367.86 7,000.00 (632.14) 7,000.00 632.14 9.0%6313758 Miscellaneous Supp694.73 100.00 594.73 5,335.01 4,050.00 1,285.01 4,350.00 (985.01) -22.6%6313762 Supplies-Office18.00 - 18.00 1,639.02 - 1,639.02 - (1,639.02) 0.0%6313774 Sand- 100.00 (100.00) 9,273.61 13,160.00 (3,886.39) 13,460.00 4,186.39 31.1%6313776 Seed- 350.00 (350.00) 117,164.38 124,850.00 (7,685.62) 125,900.00 8,735.62 6.9%6313778 Small Tools & Non-Capital Equip206.07 100.00 106.07 2,274.23 4,700.00 (2,425.77) 5,000.00 2,725.77 54.5%6313780 Sod- - - 11,636.88 9,750.00 1,886.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 & MATERIALS19,528.12 12,200.00 7,328.12 303,392.41 374,230.00 (70,837.59) 411,930.00 108,537.59 26.3%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 1,810.00 2,600.00 (790.00) 24,100.00 23,400.00 700.00 31,200.00 7,100.00 22.8%6315685 CM-R&M-Bldngs & Othr Structures 337.73 250.00 87.73 2,544.76 4,800.00 (2,255.24) 5,550.00 3,005.24 54.1%6315690 CM-R&M-Equipment2,294.71 1,500.00 794.71 29,623.73 30,000.00 (376.27) 40,000.00 10,376.27 25.9%6315692 CM-R&M-Irrigation System2,730.33 1,000.00 1,730.33 19,288.51 16,050.00 3,238.51 19,050.00 (238.51) -1.3%6315696 CM-R&M-Pumps1,138.67 1,000.00 138.67 4,904.22 9,000.00 (4,095.78) 10,500.00 5,595.78 53.3%6315815 CM-R&M-Trees-Pruning Etc- 2,000.00 (2,000.00) 6,071.00 8,050.00 (1,979.00) 12,050.00 5,979.00 49.6%Total-CM-REPAIRS & MAINTENANCE8,311.44 8,350.00 (38.56) 86,532.22 91,300.00 (4,767.78) 118,350.00 31,817.78 26.9%6317836 Utilities-Natural Gas/LPG- 15.00 (15.00) 188.33 135.00 53.33 180.00 (8.33) 0.0%6317840 Telephones607.95 850.00 (242.05) 6,962.10 7,650.00 (687.90) 10,200.00 3,237.90 31.7%Total-CM-UTILITIES 607.95 865.00 (257.05) 7,150.43 7,785.00 (634.57) 10,380.00 3,229.57 31.1%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 400.00 500.00 (100.00) 3,600.00 4,500.00 (900.00) 6,000.00 2,400.00 40.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 Removal712.34 524.00 188.34 6,644.88 4,716.00 1,928.88 6,288.00 (356.88) -5.7%6319150 Dues & Subscriptions365.00 - 365.00 1,305.00 240.00 1,065.00 540.00 (765.00) -141.7%6319170 Employee Education- 50.00 (50.00) - 1,400.00 (1,400.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental37.32 200.00 (162.68) 774.36 2,900.00 (2,125.64) 3,400.00 2,625.64 77.2%6319206 Licenses & Permits- 1,000.00 (1,000.00) 1,429.26 1,280.00 149.26 4,180.00 2,750.74 65.8%6319490 Miscellaneous- 100.00 (100.00) 713.47 900.00 (186.53) 1,200.00 486.53 40.5%6319718 Safety Equipment & Training130.27 200.00 (69.73) 2,416.81 3,550.00 (1,133.19) 3,850.00 1,433.19 37.2%6319822 Uniforms973.90 920.00 53.90 9,767.14 8,280.00 1,487.14 11,040.00 1,272.86 11.5%Total-CM-OTHER EXPENSES2,618.83 3,494.00 (875.17) 27,381.72 29,766.00 (2,384.28) 42,048.00 14,666.28 34.9%SilverRock ResortCourse Maintenance Expense StatementMarch 2017Annual BudgetMonth to Date Year to Date5 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group9,185.09 2,728.00 6,457.09 32,922.76 24,552.00 8,370.76 32,736.00 (186.76) -0.6%6321325 Insurance-Workers Comp628.69 519.00 109.69 4,528.88 4,588.00 (59.12) 6,171.00 1,642.12 26.6%6321800 Taxes-Employer Payroll1,086.58 1,938.00 (851.42) 11,608.48 17,376.00 (5,767.52) 23,334.00 11,725.52 50.3%6321880 Wages-Hourly13,473.45 13,840.00 (366.55) 118,954.62 118,800.00 154.62 160,320.00 41,365.38 25.8%6321882 Wages-Overtime- - - 5,458.15 5,313.00 145.15 6,351.00 892.85 14.1%Total-CM-LM-SALARIES & BENEFITS 24,373.81 19,025.00 5,348.81 173,472.89 170,629.00 2,843.89 228,912.00 55,439.11 24.2%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools - 75.00 (75.00) - 800.00 (800.00) 1,025.00 1,025.00 100.0%6323788 Uniforms948.76 290.00 658.76 3,803.80 2,610.00 1,193.80 3,480.00 (323.80) -9.3%Total-CM-LM-SUPPLIES & MATERIALS 948.76 365.00 583.76 3,803.80 3,410.00 393.80 4,505.00 701.20 15.6%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation 404.20 250.00 154.20 404.20 3,250.00 (2,845.80) 4,250.00 3,845.80 90.5%Total-CM-LM-REPAIRS & MAINTENANCE 404.20 250.00 154.20 404.20 3,250.00 (2,845.80) 4,250.00 3,845.80 90.5%127,484.44 118,374.00 9,110.44 1,262,354.73 1,332,660.00 (70,305.27) 1,697,483.00 435,128.27 25.6% MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping11,344.65 15,005.00 (3,660.35) 103,043.23 117,827.00 (14,783.77) 179,791.00 76,747.77 42.7%6337842 Utilities-Water1,744.31 2,247.00 (502.69) 49,568.61 53,642.00 (4,073.39) 45,338.00 (4,230.61) -9.3%13,088.96 17,252.00 (4,163.04) 152,611.84 171,469.00 (18,857.16) 225,129.00 72,517.16 32.2%Silverrock ResortCourse Maintenance Water & EnergyMarch 2017Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementMarch 2017Silverrock ResortAnnual BudgetMonth to DateYear to Date6 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 682.00 (682.00) - 6,138.00 (6,138.00) 8,184.00 8,184.00 100.0%6411325 Insurance-Workers Comp1,760.33 613.00 1,147.33 7,489.64 3,817.00 3,672.64 5,229.00 (2,260.64) -43.2%6411800 Taxes-Employer Payroll2,621.68 2,036.00 585.68 13,695.31 12,673.00 1,022.31 17,360.00 3,664.69 21.1%6411880 Wages-Hourly17,575.94 16,350.00 1,225.94 108,636.38 101,785.00 6,851.38 139,434.00 30,797.62 22.1%6411882 Wages-Overtime956.88 - 956.88 3,128.04 - 3,128.04 - (3,128.04) 0.0%Total-CBR-SALARIES & BENEFITS22,914.83 19,681.00 3,233.83 132,949.37 124,413.00 8,536.37 170,207.00 37,257.63 21.9%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts804.00 50.00 754.00 804.00 1,700.00 (896.00) 1,850.00 `0.0%6413742 Supplies-Expendable617.41 150.00 467.41 4,797.57 5,600.00 (802.43) 6,750.00 1,952.43 28.9%6413748 Supplies-Fuel for Shuttle214.23 450.00 (235.77) 430.93 2,250.00 (1,819.07) 3,000.00 2,569.07 85.6%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) - 375.00 (375.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- 70.00 (70.00) - 210.00 (210.00) 420.00 420.00 100.0%6413786 Supplies-Towels- 250.00 (250.00) 2,551.34 1,610.00 941.34 2,182.00 (369.34) -16.9%6413796 Supplies-Bottled Water215.50 50.00 165.50 15,633.33 10,850.00 4,783.33 11,000.00 (4,633.33) -42.1%Total-CBR-SUPPLIES & MATERIALS1,851.14 1,070.00 781.14 34,909.17 31,595.00 3,314.17 34,727.00 (1,228.17) -3.5%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment752.19 300.00 452.19 2,545.74 2,700.00 (154.26) 3,600.00 1,054.26 29.3%6415695 CBR-R&M-Cart Maintenance & Repair1,000.00 500.00 500.00 4,456.45 4,950.00 (493.55) 6,450.00 1,993.55 30.9%Total-CBR-REPAIRS & MAINTENANCE1,752.19 800.00 952.19 7,002.19 7,650.00 (647.81) 10,050.00 3,047.81 30.3%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen- 800.00 (800.00) 6,041.66 7,200.00 (1,158.34) 9,600.00 3,558.34 37.1%6419220 Freight/Delivery- - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous612.88 600.00 12.88 2,284.47 5,400.00 (3,115.53) 7,200.00 4,915.53 68.3%6419820 Uniforms- 500.00 (500.00) 2,880.44 3,500.00 (619.56) 5,200.00 2,319.56 44.6%Total-CBR-OTHER EXPENSES612.88 1,900.00 (1,287.12) 11,206.57 16,550.00 (5,343.43) 22,450.00 11,243.43 50.1%TOTAL-CARTS,BAGROOM & RANGE27,131.04 23,451.00 (1,287.12) 186,067.30 180,208.00 5,859.30 237,434.00 50,320.70 21.2%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp754.43 302.00 452.43 3,711.12 1,746.00 1,965.12 2,179.00 (1,532.12) -70.3%6431800 Taxes-Employer Payroll1,124.06 1,127.00 (2.94) 5,818.18 6,517.00 (698.82) 8,135.00 2,316.82 28.5%6431880 Wages-Hourly7,928.84 8,050.00 (121.16) 46,881.46 46,557.00 324.46 58,108.00 11,226.54 19.3%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS9,807.33 9,479.00 328.33 56,410.76 54,820.00 1,590.76 68,422.00 12,011.24 17.6%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 100.00 (100.00) 121.84 800.00 (678.16) 1,050.00 928.16 88.4%6439490 Miscellaneous- - - 429.00 200.00 229.00 200.00 (229.00) -114.5%6439718 Safety Equipment & Training- 50.00 (50.00) - 450.00 (450.00) 600.00 600.00 100.0%6439820 Uniforms- 75.00 (75.00) 1,381.53 1,575.00 (193.47) 2,125.00 743.47 35.0%Total-CS-OTHER EXPENSES- 225.00 (225.00) 1,932.37 3,025.00 (1,092.63) 3,975.00 2,042.63 51.4%Total-COURSE SERVICES9,807.33 9,704.00 103.33 58,343.13 57,845.00 498.13 72,397.00 14,053.87 19.4%36,938.37 33,155.00 3,783.37 244,410.43 238,053.00 6,357.43 309,831.00 62,331.94 20.1%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementMarch 2017Annual Budget7 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable400.00 400.00 - 3,600.00 3,600.00 - 4,800.00 1,200.00 25.0%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 3,600.00 3,600.00 - 4,800.00 1,200.00 25.0%65-CH-UTILITIES6507836 Utilities-Natural Gas744.71 300.00 444.71 4,011.66 2,700.00 1,311.66 3,600.00 (411.66) -11.4%6507840 Utilities-Telephone809.16 1,150.00 (340.84) 10,147.02 10,350.00 (202.98) 13,800.00 3,652.98 26.5%6507842 Utilities-Water478.69 321.00 157.69 3,096.57 2,889.00 207.57 3,852.00 755.43 19.6%6507844 Utilities-Cable490.47 340.00 150.47 4,397.46 3,060.00 1,337.46 4,080.00 (317.46) -7.8%Total-CH-UTILITIES2,523.03 2,111.00 412.03 21,652.71 18,999.00 2,653.71 25,332.00 3,679.29 14.5%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,900.00 1,825.00 75.00 16,530.00 17,025.00 (495.00) 22,500.00 5,970.00 26.5%6509099 Contract Services-Security5,599.72 4,900.00 699.72 49,977.52 45,700.00 4,277.52 60,400.00 10,422.48 17.3%6509215 Flowers & Decorations63.43 500.00 (436.57) 573.12 1,500.00 (926.88) 1,900.00 1,326.88 69.8%6509490 Miscellaneous75.45 2,500.00 (2,424.55) 2,043.12 6,400.00 (4,356.88) 7,000.00 4,956.88 70.8%6509718 Safety Equipment & Training- 100.00 (100.00) 642.24 900.00 (257.76) 1,200.00 557.76 46.5%Total-CH-OTHER EXPENSES7,638.60 9,825.00 (2,186.40) 69,766.00 71,525.00 (1,759.00) 93,000.00 23,234.00 25.0%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures343.38 300.00 43.38 4,027.89 2,700.00 1,327.89 3,600.00 (427.89) -11.9%6515686 CH-R&M-Restaurant Repairs160.00 400.00 (240.00) 3,169.90 3,600.00 (430.10) 4,800.00 1,630.10 34.0%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 1,365.16 3,600.00 (2,234.84) 4,800.00 3,434.84 71.6%Total-CH-REPAIRS & MAINTENANCE503.38 1,100.00 (596.62) 8,562.95 9,900.00 (1,337.05) 13,200.00 4,637.05 35.1%11,065.01 13,436.00 (2,370.99) 103,581.66 104,024.00 (442.34) 136,332.00 9,274.10 6.8%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementMarch 2017Annual Budget8 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group361.00 341.00 20.00 2,792.00 3,069.00 (277.00) 4,092.00 1,300.00 31.8%6601325 Insurance-Workers Comp94.00 94.00 - 828.50 846.00 (17.50) 1,129.00 300.50 26.6%6601720 Salaries2,508.00 2,508.00 - 21,600.87 22,572.00 (971.13) 30,096.00 8,495.13 28.2%6601800 Taxes-Employer Payroll200.00 351.00 (151.00) 2,365.05 3,159.00 (793.95) 4,213.00 1,847.95 43.9%Total-MKT-SALARIES & BENEFITS 3,163.00 3,294.00 (131.00) 27,586.42 29,646.00 (2,059.58) 39,530.00 11,943.58 30.2%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 1,314.03 900.00 414.03 1,200.00 (114.03) -9.5%6603768 Supplies-Printing & Stationery 507.00 125.00 382.00 4,767.43 4,050.00 717.43 4,425.00 (342.43) -7.7%507.00 225.00 282.00 6,081.46 4,950.00 1,131.46 5,625.00 (456.46) -8.1%66-MKT-UTILITIES6607840 Utilities-Telephone 70.08 100.00 (29.92) 899.72 900.00 (0.28) 1,200.00 300.28 25.0%Total-MKT-UTILITIES70.08 100.00 (29.92) 899.72 900.00 (0.28) 1,200.00 300.28 25.0%66-MKT-OTHER EXPENSES6609010 Advertising14,978.11 18,980.00 (4,001.89) 140,305.35 138,468.00 1,837.35 178,987.00 38,681.65 21.6%6609040 Business Meals- 25.00 (25.00) - 225.00 (225.00) 300.00 300.00 100.0%6609080 Collateral Material4,294.71 500.00 3,794.71 7,392.56 3,000.00 4,392.56 5,500.00 (1,892.56) -34.4%6609102 Contract Services-Web Page99.00 150.00 (51.00) 891.00 1,350.00 (459.00) 1,800.00 909.00 50.5%6609490 Miscellaneous52.69 50.00 2.69 817.39 250.00 567.39 350.00 (467.39) -133.5%6609620 Postage30.08 50.00 (19.92) 30.08 450.00 (419.92) 600.00 569.92 95.0%6609630 Promotion- 50.00 (50.00) 97.09 550.00 (452.91) 700.00 602.91 86.1%6609633 Promotion-Community- 75.00 (75.00) 310.27 2,025.00 (1,714.73) 2,250.00 1,939.73 86.2%6609634 Promotion-Media/Vendor- - - 1,308.71 2,000.00 (691.29) 2,000.00 691.29 34.6%6609150 Dues and Subscriptions- 300.00 (300.00) 82.50 735.00 (652.50) 735.00 652.50 88.8%6609820 Uniforms431.65 50.00 381.65 734.05 550.00 184.05 600.00 (134.05) -22.3%Total-MKT-OTHER EXPENSES 19,886.24 20,230.00 (343.76) 151,969.00 149,603.00 2,366.00 193,822.00 41,853.00 21.6%23,626.32 23,849.00 (222.68) 186,536.60 185,099.00 1,437.60 240,177.00 53,640.40 22.3%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementMarch 2017Annual Budget9 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group 1,560.65 1,488.00 72.65 11,771.48 13,392.00 (1,620.52) 17,856.00 6,084.52 34.1%6701325 Insurance-Workers Comp377.21 662.00 (284.79) 4,609.75 5,732.00 (1,122.25) 7,717.00 3,107.25 40.3%6701720 Salaries14,486.40 15,050.00 (563.60) 125,111.00 129,450.00 (4,339.00) 177,996.00 52,885.00 29.7%6701800 Taxes-Employer Payroll1,470.73 2,471.00 (1,000.27) 13,557.83 21,399.00 (7,841.17) 28,812.00 15,254.17 52.9%6701880 Wages-Hourly2,484.00 2,600.00 (116.00) 24,177.70 23,550.00 627.70 27,800.00 3,622.30 13.0%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 20,378.99 22,271.00 (1,892.01) 179,227.76 193,523.00 (14,295.24) 260,181.00 80,953.24 31.1%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 500.00 (500.00) 2,817.77 4,500.00 (1,682.23) 6,300.00 3,482.23 55.3%6703762 Supplies-Office131.95 150.00 (18.05) 515.05 1,350.00 (834.95) 1,800.00 1,284.95 71.4%6703768 Supplies-Printing & Stationery515.88 400.00 115.88 1,904.42 2,100.00 (195.58) 3,300.00 1,395.58 42.3%Total-G&A-SUPPLIES & MATERIALS647.83 1,050.00 (402.17) 5,237.24 7,950.00 (2,712.76) 11,400.00 6,162.76 54.1%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment 1,481.00 100.00 1,381.00 6,724.20 1,600.00 5,124.20 1,900.00 (4,824.20) -253.9%Total-G&A-REPAIRS & MAINTENANCE 1,481.00 100.00 1,381.00 6,724.20 1,600.00 5,124.20 1,900.00 (4,824.20) -253.9%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance 500.00 500.00 - 4,500.00 4,500.00 - 4,800.00 300.00 6.3%6709150 Dues & Subscriptions- 50.00 (50.00) 675.92 1,100.00 (424.08) 1,700.00 1,024.08 60.2%6709180 Employee Recruiting/Relocation30.00 200.00 (170.00) 504.00 1,400.00 (896.00) 1,400.00 896.00 64.0%6709197 Equipment Rental469.09 550.00 (80.91) 5,090.22 4,950.00 140.22 6,600.00 1,509.78 22.9%6709202 Fees-Bank134.94 90.00 44.94 1,123.94 810.00 313.94 1,080.00 (43.94) -4.1%6709208 Fees-Payroll Processing381.03 1,200.00 (818.97) 6,510.01 10,800.00 (4,289.99) 14,400.00 7,889.99 54.8%6709220 Freight/Delivery- 50.00 (50.00) 31.72 450.00 (418.28) 600.00 568.28 94.7%6709490 Miscellaneous- 100.00 (100.00) 3,673.41 6,300.00 (2,626.59) 1,200.00 (2,473.41) -206.1%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services- 75.00 (75.00) 864.94 675.00 189.94 900.00 35.06 3.9%6709625 Professional Fees1,577.54 850.00 727.54 10,138.96 7,650.00 2,488.96 10,200.00 61.04 0.6%6709636 Promotion/Entertainment- 100.00 (100.00) - 900.00 (900.00) 6,600.00 6,600.00 100.0%6709722 Seminars & Training- 200.00 (200.00) 1,155.71 1,800.00 (644.29) 2,400.00 1,244.29 51.8%6709810 Travel- - - - 200.00 (200.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 900.00 579.74 825.00 (245.26) 1,050.00 470.26 44.8%Total-G&A-OTHER EXPENSES 3,092.60 4,040.00 27.60 34,848.57 42,360.00 (7,511.43) 54,030.00 19,181.43 35.5%25,600.42 27,461.00 (1,860.58) 226,037.77 245,433.00 (19,395.23) 327,511.00 101,473.23 31.0%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementMarch 2017Annual Budget10 MarchFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts9,918.27 10,050.00 (131.73) 90,505.06 90,900.00 (394.94) 121,050.00 30,544.94 25.2%6800193 Equipment Leases-Maintenance 10,472.75 11,500.00 (1,027.25) 75,319.81 81,700.00 (6,380.19) 72,600.00 (2,719.81) -3.7%6800194 Equipment Leases-Trailer542.07 600.00 (57.93) 4,856.56 5,400.00 (543.44) 7,200.00 2,343.44 32.5%6800196 Equipment Leases-GPS4,200.00 4,700.00 (500.00) 43,040.00 42,300.00 740.00 56,400.00 13,360.00 23.7%6800197 Equipment Leases-Others1,118.20 1,950.00 (831.80) 16,516.87 14,350.00 2,166.87 13,800.00 (2,716.87) 0.0%26,251.29 28,800.00 (2,548.71) 230,238.30 234,650.00 (4,411.70) 271,050.00 40,811.70 15.1%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,652.80 8,653.00 (0.20) 77,875.20 77,877.00 (1.80) 99,840.00 21,964.80 22.0%6900210 FF&E Reserve11,650.30 11,084.00 566.30 48,311.89 43,465.00 4,846.89 63,985.00 15,673.11 24.5%6900800 Personal Property Taxes711.54 - 711.54 11,582.64 11,800.00 (217.36) 11,800.00 217.36 1.8%6900323 Insurance-Commercial4,574.76 2,700.00 1,874.76 40,659.65 24,300.00 16,359.65 26,400.00 (14,259.65) -54.0%25,589.40 22,437.00 3,152.40 178,429.38 157,442.00 20,987.38 202,025.00 23,595.62 11.7%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementMarch 2017Annual 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 CategoryJanuaryFebruaryMarchAprilMayJuneMedia4 5SalesPromotionGolf IndustryVIPCelebrityPGA Comp27 10 29Charity/Gift Certificate14916Rain/Wind Checks114Club Staff51 22 38LQ HS Golf11 45 116118 95 199 00012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2016-2017March 2017 Date TimeDescriptionCategoryPlayers13