Loading...
05 November 2018 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2018 – November 2018 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 November Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue321,668.48 353,093.75 (31,425.27) -8.9% 684,869.80 644,401.00 40,468.80 3,401,303.00 2,716,433.20 20%401000 Miscellaneous Golf Revenue38,030.00 42,902.50 (4,872.50) -11.4% 72,892.85 61,185.60 11,707.25 302,066.00 229,173.15 24%410000 Revenue-Golf Shop26,214.85 29,900.00 (3,685.15) -12.3% 61,820.00 61,625.00 195.00 277,150.00 215,330.00 22%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0%4,500.00 4,500.00 - 12,000.00 7,500.00 38%890000 Interest Income- - - 0.0%0.18 - 0.18 - (0.18) 0%Total Income387,413.33 427,396.25 (39,982.92) -9.4% 824,082.83 771,711.60 52,371.23 3,992,519.00 3,168,436.17 21%Cost of Goods Sold510000 COS-Golf Shop14,980.59 16,737.79 (1,757.20) 10.5% 35,338.39 34,492.89 (845.50) 155,121.00 119,782.61 23%Total COS14,980.59 16,737.79 (1,757.20) 10.5% 35,338.39 34,492.89 (845.50) 155,121.00 119,782.61 23%Gross Profit372,432.74 410,658.46 (38,225.72) -9.3% 788,744.44 737,218.71 51,525.73 3,837,398.00 3,048,653.56 21%Expenses610000 Golf Pro Shop 19,302.03 20,452.03 (1,150.00) 5.6% 81,973.74 75,752.31 6,221.43 221,115.00 139,141.26 37%630000 Course Maintenance157,706.36 150,681.00 7,025.36 -4.7% 808,210.54 842,515.00 (34,304.46) 1,740,490.00 932,279.46 46%633000 Maintenance Water & Energy12,035.26 15,369.00 (3,333.74) 21.7% 92,038.33 102,581.00 (10,542.67) 249,838.00 157,799.67 37%640000 Outside Services50,712.85 38,120.39 12,592.46 -33.0% 131,445.98 111,637.92 19,808.06 354,598.00 223,152.02 37%650000 Clubhouse12,322.89 13,076.00 (753.11) 5.8% 53,164.42 57,280.00 (4,115.58) 136,412.00 83,247.58 39%660000 Marketing27,864.71 31,981.00 (4,116.29) 12.9% 82,965.06 82,644.00 321.06 229,960.00 146,994.94 36%670000 General & Administrative26,752.46 30,567.00 (3,814.54) 12.5% 111,727.86 132,223.00 (20,495.14) 329,053.00 217,325.14 34%680000 Leases25,610.60 26,000.00 (389.40) 1.5% 128,160.97 127,250.00 910.97 309,250.00 181,089.03 41%690000 Miscellaneous Other Expense15,933.37 20,561.88 (4,628.51) 22.5% 91,795.96 92,188.03 (392.07) 241,826.00 150,030.04 38%Total Expenses348,240.53 346,808.30 1,432.23 -0.4% 1,581,482.86 1,624,071.26 42,588.40 3,812,542.00 2,231,059.14 41%24,192.21 63,850.16 (39,657.95) -62.1%(792,738.42) (886,852.55) 94,114.13 24,856.00 817,594.42 0%Rounds of Golf PlayedPaid Rounds Played4,210 4,600 (390) -8.5%13,033 12,755 278 42,173 29,140 31%Ave $ Per Paid Round Green Fee76.41 76.76 (0.35) -0.5%52.55 50.52 2.03 80.65 28.10 65%Ave $ Per Paid Round Merchandise6.23 6.50 (0.27) -4.2%4.74 4.83 (0.09) 6.57 1.83 72%Ave $ Per Paid Miscellaneous 9.03 9.33 (0.29) -3.1%5.59 4.80 0.80 7.16 1.57 78%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateNovember 20181 Income November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees321,668.48 353,093.75 (31,425.27) 684,869.80 644,401.00 40,468.80 3,401,303.00 2,716,433.20 79.9%4010000 Rider Fee1,125.00 465.00 660.00 3,617.85 877.30 2,740.55 7,307.00 3,689.15 50.5%4040000 Club Rental2,925.00 2,325.00 600.00 5,780.00 4,386.50 1,393.50 21,087.00 15,307.00 72.6%4050000 Driving Range9,430.00 15,112.50 (5,682.50) 17,610.00 18,921.80 (1,311.80) 94,872.00 77,262.00 81.4%4060000 Handicap Fees- - - - - - 2,500.00 2,500.00 100.0%4090000 Ball Retriever/Subcontract- - - 75.00 2,000.00 (1,925.00) 4,000.00 3,925.00 98.1%4091000 Golf Professional Rental Fee 1,000.00 1,000.00 - 1,500.00 1,000.00 500.00 7,000.00 5,500.00 78.6%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue23,550.00 25,000.00 (1,450.00) 44,310.00 34,000.00 10,310.00 165,300.00 120,990.00 73.2% Total Revenue Fees359,698.48 396,996.25(37,297.77) 757,762.65 705,586.60 52,176.05 3,703,369.00 2,945,606.35 79.5%359,698.48 396,996.25(37,297.77) 757,762.65 705,586.60 52,176.05 3,703,369.00 2,945,606.35 79.5%SilverRock ResortStatement of Fees RevenueTotal IncomeMonth to DateYear to DateAnnual BudgetNovember 20182 RevenuesActual BudgetVariance$38,030.00 $42,902.50(4,872.50)Unfavorable: Despite average green fee up $6 from previous year, rounds of golf were down due to changing to 10 minute tee time intervals. In addition, driving range revenue was down compared to projection. Actual BudgetVariance$26,214.85 $29,900.00(3,685.15)Unfavorable: Due to reduced rounds of golf compared to budget amount. Also, do to less walk-ins.ExpensesActual BudgetVariance$12,035.26 $15,369.00(3,333.74)Unfavorable: Due to decrease of running of water feature for the start up.Actual BudgetVariance$50,712.85 $38,120.3912,592.46Unfavorable: Due to timing of the shipment of water for the golf cart amenities.Actual BudgetVariance$27,864.71 $31,981.00(4,116.29)Favorable: Due to stationary and supplies timing of invoices for score cards, etc.Actual BudgetVariance$26,752.46 $30,567.00(3,814.54)Favorable: Due to reallocation of accounting payroll.Actual BudgetVariance$15,933.37 $20,561.88(4,628.51)Favorable: Due to timing of invoices for property tax and commercial insurance.Maintenance - Water & EnergyVariance ExplanationNovember 2018The 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 SalesMiscellaneous Golf RevenueMarketingMiscellaneous Other ExpenseOutside ServicesGeneral and Administrative3-20-133 Income November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous101.20 - 101.20 2,469.81 - 2,469.81 00 0%4100110 Sales Hard Goods7,041.30 7,475.00 (433.70) 24,876.60 15,406.25 9,470.35 69,288.00 44,411.40 64.1%4100112 Sales-Soft Goods24,464.00 22,425.00 2,039.00 44,317.00 46,218.75 (1,901.75) 207,863.00 163,546.00 78.7%5100639 GS-Discounts-Mdse (5,391.65) - (5,391.65) (9,843.41) - (9,843.41) - 9,843.41 0.0% Total Revenue Golf Shop26,214.85 29,900.00 (3,685.15) 61,820.00 61,625.00 195.00 277,151.00 217,800.81 78.6%COS 5100150 COS-GS-Hard Goods 3,929.52 4,183.76 (254.24) 13,412.20 8,622.88 4,789.32 40,187.04 26,774.84 66.6%5100151 COS-GS-Soft Goods 10,332.30 13,161.00 (2,828.70) 19,756.91 27,121.00 (7,364.09) 120,560.54 100,803.63 83.6%5100152 COS-GS-Purchase Disc (23.54) (867.10) 843.56 (108.04) (1,787.13) 1,679.09 (8,037.00) (7,928.96) 98.7%5100220 COS-GS-Freight Merch 742.31 260.13 482.18 2,277.32 536.14 1,741.18 2,411.00 133.68 5.5%Cost of Sales - Golf Shop14,980.59 16,737.79 (1,757.20) 35,338.39 34,492.89 845.50 155,121.58 119,783.19 77.2%Gross Profit11,234.26 13,162.21 (1,927.95) 26,481.61 27,132.11 (650.50) 122,029.42 98,017.62 80.3%COS % 57.1% 56.0% -1.2% 57.2% 56.0% -1.2% 53.1% 55.0% 103.6%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group451.94 2,436.00 (1,984.06) 5,632.90 9,744.00 (4,111.10) 26,796.00 21,163.10 79.0%6101325 Insurance-Workers Comp 501.20 540.61 (39.41) 2,941.04 1,927.47 1,013.57 5,635.00 2,693.96 47.8%6101720 Salaries4,861.54 4,400.00 461.54 23,846.16 22,000.00 1,846.16 51,000.00 27,153.84 53.2%6101800 Taxes-Employer Payroll 1,559.95 1,874.12 (314.17) 5,343.91 6,681.87 (1,337.96) 19,935.00 14,591.09 73.2%6101880 Wages-Hourly10,343.50 10,016.30 327.20 39,948.50 29,398.97 10,549.53 98,874.00 58,925.50 59.6%6101882 Wages-Overtime50.25 - 50.25 138.76 - 138.76 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 17,768.38 19,267.03 (1,498.65) 77,851.27 69,752.31 8,098.96 202,240.00 125,480.37 62.0%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office268.96 250.00 18.96 463.37 1,250.00 (786.63) 3,000.00 2,536.63 84.6%6109220 Freight & Delivery- 25.00 (25.00) - 50.00 (50.00) 75.00 75.00 100.0%6109490 Miscellaneous- 500.00 (500.00) 419.14 2,500.00 (2,080.86) 6,000.00 5,580.86 93.0%6109150 Dues and Subscriptions- - - - - - 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short(14.30) - (14.30) 37.95 - 37.95 - (37.95) 0.0%6109722 Seminars/Training- - - - 950.00 (950.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise 1,072.50 - 1,072.50 1,072.50 - 1,072.50 90.00 (982.50) -1091.7%6109820 Uniforms169.03 300.00 (130.97) 1,916.65 700.00 1,216.65 2,400.00 483.35 20.1%6117840 Telephones37.46 110.00 (72.54) 212.86 550.00 (337.14) 1,320.00 1,107.14 83.9%1,533.65 1,185.00 348.65 4,122.47 6,000.00 (1,877.53) 18,875.00 14,752.53 78.2%19,302.03 20,452.03 (1,150.00) 81,973.74 75,752.31 6,221.43 221,115.00 140,232.90 63.4%Net Income(8,067.77) (7,289.82) (777.95) (55,492.13) (48,620.20) (6,871.93) (99,085.58) (42,215.28) 42.6%SilverRock ResortGolf Shop Income StatementTotal Expenses-Golf ShopMonth to DateYear to DateAnnual BudgetNovember 20184 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group8,251.73 9,165.00 (913.27) 42,198.40 38,865.00 3,333.40 103,020.00 60,821.60 59.0%6311325 Insurance-Workers Comp2,140.00 2,276.00 (136.00) 10,980.20 10,890.00 90.20 26,974.00 15,993.80 59.3%6311720 Salaries12,476.92 12,476.92 - 62,384.60 62,384.60 - 146,400.00 84,015.40 57.4%6311800 Taxes-Employer Payroll7,375.66 7,891.00 (515.34) 25,790.71 38,285.00 (12,494.29) 94,048.00 68,257.29 72.6%6311880 Wages-Hourly47,876.03 48,223.08 (347.05) 218,397.47 219,765.40 (1,367.93) 564,695.00 346,297.53 61.3%6311882 Wages-Overtime8,549.50 - 8,549.50 34,048.49 12,350.00 21,698.49 12,350.00 (21,698.49) -175.7%Total-CM-SALARIES & BENEFITS86,669.84 80,032.00 6,637.84 393,799.87 382,540.00 11,259.87 947,487.00 553,687.13 58.4%63-CM-SUPPLIES & MATERIALS6313734 Chemicals7,471.36 2,100.00 5,371.36 24,169.14 8,380.00 15,789.14 17,760.00 (6,409.14) -36.1%6313744 Fertilizer16,908.83 10,650.00 6,258.83 51,138.12 58,060.00 (6,921.88) 100,520.00 49,381.88 49.1%6313745 Herbicides- - - 1,854.50 18,061.00 (16,206.50) 25,518.00 23,663.50 92.7%6313746 Flowers/Plants1,625.54 - 1,625.54 2,971.85 1,250.00 1,721.85 3,050.00 78.15 2.6%6313748 Fuel-Gasoline3,469.54 4,850.00 (1,380.46) 18,398.53 20,100.00 (1,701.47) 46,860.00 28,461.47 60.7%6313750 Golf Course Accessories3,101.79 - 3,101.79 12,986.55 12,300.00 686.55 13,140.00 153.45 1.2%6313756 POA Control141.06 - 141.06 141.06 2,400.00 (2,258.94) 9,900.00 9,758.94 98.6%6313758 Miscellaneous Supp693.45 500.00 193.45 1,703.61 3,250.00 (1,546.39) 4,350.00 2,646.39 60.8%6313762 Supplies-Office624.32 - 624.32 2,323.53 - 2,323.53 - (2,323.53) 0.0%6313774 Sand2,919.86 4,000.00 (1,080.14) 4,062.01 11,780.00 (7,717.99) 13,460.00 9,397.99 69.8%6313776 Seed- 11,900.00 (11,900.00) 103,424.93 117,400.00 (13,975.07) 117,400.00 13,975.07 11.9%6313778 Small Tools & Non-Capital Equip224.30 100.00 124.30 1,640.97 4,300.00 (2,659.03) 5,000.00 3,359.03 67.2%6313780 Sod- - - 5,163.51 8,800.00 (3,636.49) 13,500.00 8,336.49 61.8%6313782 Topdressing- 2,600.00 (2,600.00) 4,849.65 7,000.00 (2,150.35) 10,000.00 5,150.35 51.5%Total-CM-SUPPLIES & MATERIALS37,180.05 36,700.00 480.05 234,827.96 273,081.00 (38,253.04) 380,458.00 145,630.04 38.3%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint1,895.00 3,850.00 (1,955.00) 13,425.00 19,250.00 (5,825.00) 46,200.00 32,775.00 70.9%6315685 CM-R&M-Bldngs & Othr Structures 993.39 500.00 493.39 4,574.74 3,550.00 1,024.74 5,550.00 975.26 17.6%6315690 CM-R&M-Equipment5,458.99 5,000.00 458.99 31,365.71 22,500.00 8,865.71 38,500.00 7,134.29 18.5%6315692 CM-R&M-Irrigation System1,345.66 900.00 445.66 11,432.93 12,300.00 (867.07) 19,050.00 7,617.07 40.0%6315696 CM-R&M-Pumps2,920.49 1,000.00 1,920.49 7,513.30 5,000.00 2,513.30 10,500.00 2,986.70 28.4%6315815 CM-R&M-Trees-Pruning Etc- - - 5,190.00 6,050.00 (860.00) 12,050.00 6,860.00 56.9%Total-CM-REPAIRS & MAINTENANCE12,613.53 11,250.00 1,363.53 73,501.68 68,650.00 4,851.68 131,850.00 58,348.32 44.3%6317836 Utilities-Natural Gas/LPG19.91 15.00 4.91 96.31 75.00 21.31 180.00 83.69 0.0%6317840 Telephones1,343.84 850.00 493.84 4,060.49 4,250.00 (189.51) 10,200.00 6,139.51 60.2%Total-CM-UTILITIES1,363.75 865.00 498.75 4,156.80 4,325.00 (168.20) 10,380.00 6,223.20 60.0%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 400.00 - 2,000.00 2,000.00 - 4,800.00 2,800.00 58.3%6319100 Contract Svcs-Soil/Tissue Test- - - 691.38 1,000.00 (308.62) 2,000.00 1,308.62 65.4%6319102 Contract Svcs-Trash Removal104.02 524.00 (419.98) 416.08 2,620.00 (2,203.92) 6,288.00 5,871.92 93.4%6319150 Dues & Subscriptions- - - 475.00 - 475.00 680.00 205.00 30.1%6319170 Employee Education- 50.00 (50.00) - 250.00 (250.00) 3,900.00 3,900.00 100.0%6319197 Equipment Rental- 600.00 (600.00) - 2,100.00 (2,100.00) 3,400.00 3,400.00 100.0%6319206 Licenses & Permits- - - 827.05 350.00 477.05 4,300.00 3,472.95 80.8%6319490 Miscellaneous- 100.00 (100.00) 115.27 500.00 (384.73) 1,200.00 1,084.73 90.4%6319718 Safety Equipment & Training247.30 500.00 (252.70) 1,556.21 2,350.00 (793.79) 3,850.00 2,293.79 59.6%6319822 Uniforms1,814.80 920.00 894.80 4,544.60 4,600.00 (55.40) 11,040.00 6,495.40 58.8%Total-CM-OTHER EXPENSES2,566.12 3,094.00 (527.88) 10,625.59 15,770.00 (5,144.41) 41,458.00 30,832.41 74.4%SilverRock ResortCourse Maintenance Expense StatementAnnual BudgetNovember 2018Month to DateYear to Date5 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,606.40 2,784.00 (177.60) 14,933.73 13,920.00 1,013.73 33,408.00 18,474.27 55.3%6321325 Insurance-Workers Comp 401.71 484.00 (82.29) 2,757.95 2,537.00 220.95 5,955.00 3,197.05 53.7%6321800 Taxes-Employer Payroll1,582.21 1,678.00 (95.79) 5,029.39 8,944.00 (3,914.61) 20,793.00 15,763.61 75.8%6321880 Wages-Hourly12,489.00 12,904.00 (415.00) 63,947.86 65,380.00 (1,432.14) 156,528.00 92,580.14 59.1%6321882 Wages-Overtime- - - 2,629.69 3,418.00 (788.31) 3,418.00 788.31 23.1%Total-CM-LM-SALARIES & BENEFITS17,079.32 17,850.00 (770.68) 89,298.62 94,199.00 (4,900.38) 220,102.00 130,803.38 59.4%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools 233.75 100.00 133.75 233.75 500.00 (266.25) 1,025.00 791.25 77.2%6323788 Uniforms- 290.00 (290.00) 1,766.27 1,450.00 316.27 3,480.00 1,713.73 49.2%Total-CM-LM-SUPPLIES & MATERIALS233.75 390.00 (156.25) 2,000.02 1,950.00 50.02 4,505.00 2,504.98 55.6%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation - 500.00 (500.00) - 2,000.00 (2,000.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE- 500.00 (500.00) - 2,000.00 (2,000.00) 4,250.00 4,250.00 100.0%157,706.36 150,681.00 7,025.36 808,210.54 842,515.00 (34,304.46) 1,740,490.00 932,279.46 53.6% November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping10,547.42 7,219.00 3,328.42 60,675.16 51,481.00 9,194.16 179,791.00 119,115.84 66.3%6337842 Utilities-Water1,487.84 8,150.00 (6,662.16) 31,363.17 51,100.00 (19,736.83) 70,047.00 38,683.83 55.2%12,035.26 15,369.00 (3,333.74) 92,038.33 102,581.00 (10,542.67) 249,838.00 157,799.67 63.2%Silverrock ResortCourse Maintenance Water & EnergyNovember 2018Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementNovember 2018Silverrock ResortAnnual BudgetMonth to DateYear to Date6 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group668.53 696.00 (27.47) 2,005.59 3,480.00 (1,474.41) 8,352.00 6,346.41 76.0%6411325 Insurance-Workers Comp403.07 482.63 (79.56) 3,113.72 1,643.21 1,470.51 6,172.00 3,058.28 49.6%6411800 Taxes-Employer Payroll1,033.65 1,602.32 (568.67) 4,549.83 5,455.41 (905.58) 20,493.00 15,943.17 77.8%6411880 Wages-Hourly12,888.57 12,870.00 18.57 50,169.22 43,818.50 6,350.72 164,599.00 114,429.78 69.5%6411882 Wages-Overtime260.26 - 260.26 447.93 - 447.93 - (447.93) 0.0%Total-CBR-SALARIES & BENEFITS15,254.0815,650.95(396.87) 60,286.29 54,397.12 5,889.17 199,616.00 139,329.71 69.8%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts 549.59 500.00 49.59 549.59 1,000.00 (450.41) 1,850.00 `0.0%6413742 Supplies-Expendable- 1,800.00 (1,800.00) 113.10 3,300.00 (3,186.90) 6,750.00 6,636.90 98.3%6413748 Supplies-Fuel for Shuttle- 300.00 (300.00) - 500.00 (500.00) 3,000.00 3,000.00 100.0%6413752 Supplies-Range Balls10,568.25 9,000.00 1,568.25 10,568.25 9,000.00 1,568.25 9,000.00 (1,568.25) -17.4%6413762 Supplies-Office- 50.00 (50.00) 14.67 175.00 (160.33) 525.00 510.33 97.2%6413768 Supplies-Printing and Stationary61.55 - 61.55 61.55 - 61.55 420.00 358.45 85.3%6413786 Supplies-Towels1,227.49 185.00 1,042.49 4,689.97 665.00 4,024.97 2,182.00 (2,507.97) -114.9%6413796 Supplies-Bottled Water12,752.35200.00 12,552.35 19,232.41 4,900.00 14,332.41 12,900.00 (6,332.41) -49.1%Total-CBR-SUPPLIES & MATERIALS25,159.2312,035.0013,124.23 35,229.54 19,540.00 15,689.54 36,627.00 97.05 0.3%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment - 300.00 (300.00) 31.50 1,500.00 (1,468.50) 3,600.00 3,568.50 99.1%6415695 CBR-R&M-Cart Maintenance & Repair940.08 500.00 440.08 9,176.24 2,950.00 6,226.24 6,450.00 (2,726.24) -42.3%Total-CBR-REPAIRS & MAINTENANCE940.08 800.00 140.08 9,207.74 4,450.00 4,757.74 10,050.00 842.26 8.4%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen787.90 800.00 (12.10) 2,969.32 4,000.00 (1,030.68) 9,600.00 6,630.68 69.1%6419220 Freight/Delivery- 75.00 (75.00) - 375.00 (375.00) 450.00 450.00 100.0%6419490 Miscellaneous387.52 600.00 (212.48) 638.05 3,000.00 (2,361.95) 7,200.00 6,561.95 91.1%6419820 Uniforms895.92 500.00 395.92 895.92 2,500.00 (1,604.08) 5,200.00 4,304.08 82.8%Total-CBR-OTHER EXPENSES2,071.34 1,975.00 96.34 4,503.29 9,875.00 (5,371.71) 22,450.00 17,946.71 79.9%TOTAL-CARTS,BAGROOM & RANGE 43,424.7330,460.9596.34 109,226.8688,262.12 20,964.74 268,743.00 158,215.73 58.9%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp191.07 237.19 (46.12) 1,619.43 691.42 928.01 2,630.00 1,010.57 38.4%6431800 Taxes-Employer Payroll687.80 822.25 (134.45) 1,692.60 2,396.88 (704.28) 9,117.00 7,424.40 81.4%6431880 Wages-Hourly6,409.25 6,325.00 84.25 18,668.75 18,437.50 231.25 70,133.00 51,464.25 73.4%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS7,288.12 7,384.44 (96.32) 21,980.78 21,525.80 454.98 81,880.00 59,899.22 73.2%643-CS-OTHER EXPENSES6433742 Supplies Expendable - 100.00 (100.00) 82.64 400.00 (317.36) 1,050.00 967.36 92.1%6439490 Miscellaneous- 50.00 (50.00) 155.70 100.00 55.70 200.00 44.30 22.2%6439718 Safety Equipment & Training- 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0%6439820 Uniforms- 75.00 (75.00) - 1,100.00 (1,100.00) 2,125.00 2,125.00 100.0%Total-CS-OTHER EXPENSES- 275.00 (275.00) 238.34 1,850.00 (1,611.66) 3,975.00 3,736.66 94.0%Total-COURSE SERVICES 7,288.12 7,659.44 (371.32) 22,219.12 23,375.80 (1,156.68) 85,855.00 63,635.88 74.1%50,712.8538,120.3912,592.46 131,445.98111,637.9219,808.06 354,598.00 218,114.95 61.5%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementAnnual BudgetNovember 20187 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable400.00 400.00 - 2,000.00 2,000.00 - 4,800.00 2,800.00 58.3%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 2,000.00 2,000.00 - 4,800.00 2,800.00 58.3%65-CH-UTILITIES6507836 Utilities-Natural Gas282.14 300.00 (17.86) 1,843.51 1,500.00 343.51 3,600.00 1,756.49 48.8%6507840 Utilities-Telephone1,185.03 1,150.00 35.03 4,755.24 5,750.00 (994.76) 13,800.00 9,044.76 65.5%6507842 Utilities-Water727.76 321.00 406.76 4,215.47 1,605.00 2,610.47 3,852.00 (363.47) -9.4%6507844 Utilities-Cable495.80 380.00 115.80 2,479.08 1,900.00 579.08 4,560.00 2,080.92 45.6%Total-CH-UTILITIES2,690.73 2,151.00 539.73 13,293.30 10,755.00 2,538.30 25,812.00 12,518.70 48.5%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning475.00 1,825.00 (1,350.00) 2,599.00 9,725.00 (7,126.00) 22,500.00 19,901.00 88.4%6509099 Contract Services-Security5,158.56 5,000.00 158.56 26,502.77 25,000.00 1,502.77 60,000.00 33,497.23 55.8%6509215 Flowers & Decorations- - - - 500.00 (500.00) 1,900.00 1,900.00 100.0%6509490 Miscellaneous2,401.00 2,500.00 (99.00) 2,677.58 3,300.00 (622.42) 7,000.00 4,322.42 61.7%6509718 Safety Equipment & Training- 100.00 (100.00) 251.47 500.00 (248.53) 1,200.00 948.53 79.0%Total-CH-OTHER EXPENSES8,034.56 9,425.00 (1,390.44)32,030.82 39,025.00 (6,994.18) 92,600.00 60,569.18 65.4%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures822.60 300.00 522.60 5,465.30 1,500.00 3,965.30 3,600.00 (1,865.30) -51.8%6515686 CH-R&M-Restaurant Repairs375.00 400.00 (25.00) 375.00 2,000.00 (1,625.00) 4,800.00 4,425.00 92.2%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) - 2,000.00 (2,000.00) 4,800.00 4,800.00 100.0%Total-CH-REPAIRS & MAINTENANCE1,197.60 1,100.00 97.60 5,840.30 5,500.00 340.30 13,200.00 7,359.70 55.8%12,322.89 13,076.00(753.11) 53,164.42 57,280.00 (4,115.58) 136,412.00 14,719.40 10.8%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementAnnual BudgetNovember 20188 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 355.89 348.00 7.89 1,779.45 1,740.00 39.45 4,176.00 2,396.55 57.4%6601325 Insurance-Workers Comp89.01 94.00 (4.99) 476.58 470.00 6.58 1,129.00 652.42 57.8%6601720 Salaries1,905.20 2,508.00 (602.80) 9,526.00 12,540.00 (3,014.00) 30,096.00 20,570.00 68.3%6601800 Taxes-Employer Payroll145.20 326.00 (180.80) 726.00 1,630.00 (904.00) 3,912.00 3,186.00 81.4%Total-MKT-SALARIES & BENEFITS2,495.30 3,276.00 (780.70) 12,508.03 16,380.00 (3,871.97) 39,313.00 26,804.97 68.2%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office134.74 100.00 34.74 686.50 500.00 186.50 1,200.00 513.50 42.8%6603768 Supplies-Printing & Stationery454.17 200.00 254.17 2,184.98 3,400.00 (1,215.02) 4,425.00 2,240.02 50.6%588.91 300.00 288.91 2,871.48 3,900.00 (1,028.52) 5,625.00 2,753.52 49.0%66-MKT-UTILITIES6607840 Utilities-Telephone148.49 100.00 48.49 1,971.36 500.00 1,471.36 1,200.00 (771.36) -64.3%Total-MKT-UTILITIES148.49 100.00 48.49 1,971.36 500.00 1,471.36 1,200.00 (771.36) -64.3%66-MKT-OTHER EXPENSES6609010 Advertising24,533.01 25,680.00 (1,146.99) 58,824.77 57,189.00 1,635.77 169,987.00 111,162.23 65.4%6609040 Business Meals- 25.00 (25.00) - 125.00 (125.00) 300.00 300.00 100.0%6609080 Collateral Material- 1,000.00 (1,000.00) 4,579.50 1,500.00 3,079.50 5,500.00 920.50 16.7%6609102 Contract Services-Web Page99.00 150.00 (51.00) 297.00 750.00 (453.00) 1,800.00 1,503.00 83.5%6609490 Miscellaneous- 50.00 (50.00) - 50.00 (50.00) 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0%6609630 Promotion- 50.00 (50.00) 700.00 100.00 600.00 700.00 - 0.0%6609633 Promotion-Community- 750.00 (750.00) 913.85 1,050.00 (136.15) 2,250.00 1,336.15 59.4%6609634 Promotion-Media/Vendor- 500.00 (500.00) - 500.00 (500.00) 1,000.00 1,000.00 100.0%6609150 Dues and Subscriptions- - - - - - 735.00 735.00 100.0%6609820 Uniforms- 50.00 (50.00) 299.07 350.00 (50.93) 600.00 300.93 50.2%Total-MKT-OTHER EXPENSES24,632.01 28,305.00 (3,672.99) 65,614.19 61,864.00 3,750.19 183,822.00 118,207.81 64.3%27,864.71 31,981.00 (4,116.29) 82,965.06 82,644.00 321.06 229,960.00 146,994.94 63.9%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementAnnual BudgetNovember 20189 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group2,111.39 1,509.00 602.39 11,098.45 7,545.00 3,553.45 18,108.00 7,009.55 38.7%6701325 Insurance-Workers Comp601.01 677.00 (75.99) 2,857.37 3,161.00 (303.63) 7,905.00 5,047.63 63.9%6701720 Salaries13,494.80 13,851.00 (356.20) 59,474.00 68,655.00 (9,181.00) 177,996.00 118,522.00 66.6%6701800 Taxes-Employer Payroll1,076.10 2,349.00 (1,272.90) 5,392.45 10,965.00 (5,572.55) 32,800.00 27,407.55 83.6%6701880 Wages-Hourly3,282.63 4,211.00 (928.37) 13,768.45 15,672.00 (1,903.55) 27,404.00 13,635.55 49.8%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS20,565.93 22,597.00 (2,031.07) 92,590.72 105,998.00 (13,407.28) 264,213.00 171,622.28 65.0%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer123.05 500.00 (376.95) 591.54 2,500.00 (1,908.46) 6,300.00 5,708.46 90.6%6703762 Supplies-Office77.84 105.00 (27.16) 265.31 525.00 (259.69) 1,260.00 994.69 78.9%6703768 Supplies-Printing & Stationery- 100.00 (100.00) 713.37 500.00 213.37 3,300.00 2,586.63 78.4%Total-G&A-SUPPLIES & MATERIALS200.89 705.00 (504.11) 1,570.22 3,525.00 (1,954.78) 10,860.00 9,289.78 85.5%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 900.00 (900.00) 683.14 1,200.00 (516.86) 1,900.00 1,216.86 64.0%Total-G&A-REPAIRS & MAINTENANCE- 900.00 (900.00) 683.14 1,200.00 (516.86) 1,900.00 1,216.86 64.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 2,500.00 2,500.00 - 6,000.00 3,500.00 58.3%6709150 Dues & Subscriptions- 50.00 (50.00) 180.00 350.00 (170.00) 1,150.00 970.00 84.3%6709180 Employee Recruiting/Relocation144.26 150.00 (5.74) 486.26 450.00 36.26 1,200.00 713.74 59.5%6709197 Equipment Rental502.20 550.00 (47.80) 2,421.62 2,750.00 (328.38) 6,600.00 4,178.38 63.3%6709202 Fees-Bank79.16 90.00 (10.84) 323.69 450.00 (126.31) 1,080.00 756.31 70.0%6709208 Fees-Payroll Processing1,377.45 1,000.00 377.45 2,792.70 5,000.00 (2,207.30) 12,000.00 9,207.30 76.7%6709220 Freight/Delivery- 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0%6709490 Miscellaneous2,524.53 2,600.00 (75.47) 2,714.06 3,000.00 (285.94) 6,600.00 3,885.94 58.9%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services276.60 75.00 201.60 553.20 375.00 178.20 900.00 346.80 38.5%6709625 Professional Fees184.50 850.00 (665.50) 3,973.50 4,250.00 (276.50) 10,200.00 6,226.50 61.0%6709636 Promotion/Entertainment- 100.00 (100.00) - 500.00 (500.00) 1,200.00 1,200.00 100.0%6709722 Seminars & Training- 200.00 (200.00) 250.00 1,000.00 (750.00) 2,400.00 2,150.00 89.6%6709810 Travel- - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms396.94 150.00 900.00 688.75 525.00 163.75 1,050.00 361.25 34.4%Total-G&A-OTHER EXPENSES5,985.64 6,365.00 273.70 16,883.78 21,500.00 (4,616.22) 52,080.00 35,196.22 67.6%26,752.46 30,567.00 (3,814.54) 111,727.86 132,223.00 (20,495.14) 329,053.00 217,325.14 66.0%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementAnnual BudgetNovember 201810 November Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts 9,829.27 10,050.00 (220.73) 49,146.36 50,700.00 (1,553.64) 121,050.00 71,903.64 59.4%6800193 Equipment Leases-Maintenance 9,181.20 9,500.00 (318.80) 45,906.00 47,500.00 (1,594.00) 114,000.00 68,094.00 59.7%6800194 Equipment Leases-Trailer658.07 600.00 58.07 3,475.35 3,000.00 475.35 7,200.00 3,724.65 51.7%6800196 Equipment Leases-GPS3,870.00 3,900.00 (30.00) 19,350.00 19,500.00 (150.00) 46,800.00 27,450.00 58.7%6800197 Equipment Leases-Others2,072.06 1,950.00 122.06 10,283.26 6,550.00 3,733.26 20,200.00 9,916.74 0.0%25,610.60 26,000.00(389.40) 128,160.97127,250.00 910.97 309,250.00 181,089.0358.6%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 9,500.00 9,500.00 - 47,500.00 47,500.00 - 114,000.00 66,500.00 58.3%6900210 FF&E Reserve6,433.37 7,061.88 (628.51) 13,697.41 12,888.03 809.38 68,026.00 54,328.59 79.9%6900800 Personal Property Taxes- - - 14,738.21 11,800.00 2,938.21 11,800.00 (2,938.21) -24.9%6900323 Insurance-Commercial- 4,000.00 (4,000.00) 15,860.34 20,000.00 (4,139.66) 48,000.00 32,139.66 67.0%15,933.37 20,561.88(4,628.51) 91,795.96 92,188.03 (392.07) 241,826.00 150,030.0462.0%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementAnnual BudgetMonth to DateYear to DateNovember 201811