Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
04 October 2018 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2018 – October 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 October Final Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue55,660.90 27,482.00 28,178.90 102.5% 363,201.32 291,307.25 71,894.07 3,401,303.00 3,038,101.68 11%401000 Miscellaneous Golf Revenue11,445.00 9,228.00 2,217.00 24.0% 34,862.85 17,283.10 17,579.75 302,066.00 267,203.15 12%410000 Revenue-Golf Shop4,219.36 2,275.00 1,944.36 85.5% 35,605.15 31,725.00 3,880.15 277,150.00 241,544.85 13%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0%3,000.00 3,000.00 - 12,000.00 9,000.00 25%890000 Interest Income0.05 - 0.05 0.0%0.18 - 0.18 - (0.18) 0%Total Income72,825.31 40,485.00 32,340.31 79.9% 436,669.50 343,315.35 93,354.15 3,992,519.00 3,555,849.50 11%Cost of Goods Sold510000 COS-Golf Shop2,590.51 1,699.14 891.37 -52.5% 20,357.80 8,234.22 (12,123.58) 155,121.00 134,763.20 13%Total COS2,590.51 1,699.14 891.37 -52.5% 20,357.80 8,234.22 (12,123.58) 155,121.00 134,763.20 13%Gross Profit70,234.80 38,785.86 31,448.94 81.1% 416,311.70 335,081.13 81,230.57 3,837,398.00 3,421,086.30 11%Expenses610000 Golf Pro Shop 16,096.41 12,851.85 3,244.56 -25.2% 64,816.71 55,300.28 9,516.43 221,115.00 156,298.29 29%630000 Course Maintenance278,597.51 308,833.00 (30,235.49) 9.8% 650,626.16 691,834.00 (41,207.84) 1,740,490.00 1,089,863.84 37%633000 Maintenance Water & Energy15,652.25 18,240.00 (2,587.75) 14.2% 80,003.07 87,212.00 (7,208.93) 249,838.00 169,834.93 32%640000 Outside Services15,198.39 17,881.41 (2,683.02) 15.0% 80,733.13 73,517.53 7,215.60 354,598.00 273,864.87 23%650000 Clubhouse13,153.88 11,876.00 1,277.88 -10.8% 43,791.53 44,204.00 (412.47) 136,412.00 92,620.47 32%660000 Marketing16,855.54 20,948.00 (4,092.46) 19.5% 55,100.35 50,663.00 4,437.35 229,960.00 174,859.65 24%670000 General & Administrative21,756.56 25,870.00 (4,113.44) 15.9% 84,975.40 101,656.00 (16,680.60) 329,053.00 244,077.60 26%680000 Leases25,599.23 25,650.00 (50.77) 0.2% 102,550.37 101,250.00 1,300.37 309,250.00 206,699.63 33%690000 Miscellaneous Other Expense16,915.63 16,649.64 265.99 -1.6% 75,862.59 71,626.15 4,236.44 241,826.00 165,963.41 31%Total Expenses419,825.40 458,799.90 (38,974.50) 8.5% 1,238,459.31 1,277,262.96 38,803.65 3,812,542.00 2,574,082.69 32%(349,590.60) (420,014.04) 70,423.44 16.8%(822,147.61) (942,181.83) 120,034.22 24,856.00 847,003.61 0%Rounds of Golf PlayedPaid Rounds Played962 455 507 111.4%8,823 8,155 668 42,173 33,350 21%Ave $ Per Paid Round Green Fee57.86 60.40 (2.54) -4.2%41.17 35.72 5.44 80.65 39.49 51%Ave $ Per Paid Round Merchandise4.39 5.00 (0.61) -12.3%4.04 3.89 0.15 6.57 2.54 61%Ave $ Per Paid Miscellaneous 11.90 20.28 (8.38) -41.3%3.95 2.12 1.83 7.16 3.21 55%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateOctober 20181 Income October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees55,660.90 27,482.00 28,178.90 363,201.32 291,307.25 71,894.07 3,401,303.00 3,038,101.68 89.3%4010000 Rider Fee365.00 45.50 319.50 2,492.85 412.30 2,080.55 7,307.00 4,814.15 65.9%4040000 Club Rental530.00 227.50 302.50 2,855.00 2,061.50 793.50 21,087.00 18,232.00 86.5%4050000 Driving Range1,215.00 455.00 760.00 8,180.00 3,809.30 4,370.70 94,872.00 86,692.00 91.4%4060000 Handicap Fees- - - - - - 2,500.00 2,500.00 100.0%4090000 Ball Retriever/Subcontract75.00 1,000.00 (925.00) 75.00 2,000.00 (1,925.00) 4,000.00 3,925.00 98.1%4091000 Golf Professional Rental Fee 500.00 - 500.00 500.00 - 500.00 7,000.00 6,500.00 92.9%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue8,760.00 7,500.00 1,260.00 20,760.00 9,000.00 11,760.00 165,300.00 144,540.00 87.4% Total Revenue Fees67,105.90 36,710.00 30,395.90 398,064.17 308,590.35 89,473.82 3,703,369.00 3,305,304.83 89.3%67,105.90 36,710.00 30,395.90 398,064.17 308,590.35 89,473.82 3,703,369.00 3,305,304.83 89.3%SilverRock ResortStatement of Fees RevenueTotal IncomeMonth to DateYear to DateAnnual BudgetOctober 20182 RevenuesActual BudgetVariance$55,660.90$27,482.0028,178.90Favorable: Due to utilizing UnderPar Promotion to lure in additional golfers, and exception weather for the final days prior to closure.Actual BudgetVariance$11,445.00 $9,228.002,217.00Favorable: Due to an increase in Resident Card sales, and independent professionals started early along with an increase in driving range use dueto the weather.Actual BudgetVariance$9,064.37 $7,150.001,944.36Favorable: Due to close-out inventory from Summer stock in preparation for new fall line.ExpensesActual BudgetVariance$15,652.25 $18,240.00(2,587.75)Favorable: Due to less runtime on the Water feature for the front entrance and lakes. Drained due to cleaning.Actual BudgetVariance$15,198.39 $17,881.41(2,683.02)Favorable: Due to timing of invoices for employee uniforms for the new season.Actual BudgetVariance$13,153.88 $11,876.001,277.88Unfavorable: Due to replacement of the 3 wall warmer/steamer for the restaurant.Actual BudgetVariance$16,855.54 $20,948.00(4,092.46)Favorable: Due to stationary and supplies timing of invoices for score cards, etc.Actual BudgetVariance$21,756.56 $25,870.00(4,113.44)Favorable: Due to reallocation of accounting payroll.Maintenance - Water & EnergyVariance ExplanationOctober 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 SalesGolf Green Fee RevenueMiscellaneous Golf RevenueGeneral and AdministrativeMarketingOutside ServicesClubhouse3-20-133 Income October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous370.23 - 370.23 2,368.61 - 2,368.61 00 0%4100110 Sales Hard Goods1,988.57 568.75 1,419.82 17,835.30 7,931.25 9,904.05 69,288.00 51,452.70 74.3%4100112 Sales-Soft Goods2,488.00 1,706.25 781.75 19,853.00 23,793.75 (3,940.75) 207,863.00 188,010.00 90.4%5100639 GS-Discounts-Mdse(627.44) - (627.44) (4,451.76) - (4,451.76) - 4,451.76 0.0% Total Revenue Golf Shop4,219.36 2,275.00 1,944.36 35,605.15 31,725.00 3,880.15 277,151.00 243,914.46 88.0%COS 5100150 COS-GS-Hard Goods 782.15 318.33 463.82 9,482.68 4,439.12 5,043.56 40,187.04 30,704.36 76.4%5100151 COS-GS-Soft Goods783.37 1,427.00 (643.63) 9,424.61 13,961.00 (4,536.39) 120,560.54 111,135.93 92.2%5100152 COS-GS-Purchase Disc- (65.98) 65.98 (84.50) (920.03) 835.53 (8,037.00) (7,952.50) 98.9%5100220 COS-GS-Freight Merch 1,024.99 19.79 1,005.20 1,535.01 276.01 1,259.00 2,411.00 875.99 36.3%Cost of Sales - Golf Shop2,590.51 1,699.14 891.37 20,357.80 17,756.10 2,601.70 155,121.58 134,763.78 86.9%Gross Profit 1,628.85 575.86 1,052.99 15,247.35 13,968.90 1,278.45 122,029.42 109,150.68 89.4%COS %61.4% 74.7% 13.3% 57.2% 56.0% -1.2% 53.1% 55.3% 104.1%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group401.66 2,088.00 (1,686.34) 5,180.96 7,308.00 (2,127.04) 26,796.00 21,615.04 80.7%6101325 Insurance-Workers Comp 693.49 298.04 395.45 2,439.84 1,386.86 1,052.98 5,635.00 3,195.16 56.7%6101720 Salaries4,861.54 4,400.00 461.54 18,984.62 17,600.00 1,384.62 51,000.00 32,015.38 62.8%6101800 Taxes-Employer Payroll 887.83 1,033.19 (145.36) 3,783.96 4,807.75 (1,023.79) 19,935.00 16,151.04 81.0%6101880 Wages-Hourly6,301.50 3,547.62 2,753.88 29,605.00 19,382.67 10,222.33 98,874.00 69,269.00 70.1%6101882 Wages-Overtime52.13 - 52.13 88.51 - 88.51 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 13,198.15 11,366.85 1,831.30 60,082.89 50,485.28 9,597.61 202,240.00 143,198.50 70.8%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office- 250.00 (250.00) 194.41 1,000.00 (805.59) 3,000.00 2,805.59 93.5%6109220 Freight & Delivery- 25.00 (25.00) - 25.00 (25.00) 75.00 75.00 100.0%6109490 Miscellaneous- 500.00 (500.00) 419.14 2,000.00 (1,580.86) 6,000.00 5,580.86 93.0%6109150 Dues and Subscriptions- - - - - - 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short0.95 - 0.95 52.25 - 52.25 - (52.25) 0.0%6109722 Seminars/Training- 500.00 (500.00) - 950.00 (950.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise 2,145.00 - 2,145.00 2,145.00 - 2,145.00 90.00 (2,055.00) -2283.3%6109820 Uniforms714.85 100.00 614.85 1,747.62 400.00 1,347.62 2,400.00 652.38 27.2%6117840 Telephones37.46 110.00 (72.54) 175.40 440.00 (264.60) 1,320.00 1,144.60 86.7%2,898.26 1,485.00 1,413.26 4,733.82 4,815.00 (81.18) 18,875.00 14,141.18 74.9%16,096.41 12,851.85 3,244.56 64,816.71 55,300.28 9,516.43 221,115.00 157,339.68 71.2%Net Income(14,467.56) (12,275.99) (2,191.57) (49,569.36) (41,331.38) (8,237.98) (99,085.58) (48,189.00) 48.6%SilverRock ResortGolf Shop Income StatementTotal Expenses-Golf ShopMonth to DateYear to DateAnnual BudgetOctober 20184 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group8,266.75 7,425.00 841.75 33,946.67 29,700.00 4,246.67 103,020.00 69,073.33 67.0%6311325 Insurance-Workers Comp2,179.54 2,661.00 (481.46) 8,840.20 8,614.00 226.20 26,974.00 18,133.80 67.2%6311720 Salaries12,476.92 12,476.92 - 49,907.68 49,907.68 - 146,400.00 96,492.32 65.9%6311800 Taxes-Employer Payroll5,825.42 9,759.00 (3,933.58) 18,415.05 30,394.00 (11,978.95) 94,048.00 75,632.95 80.4%6311880 Wages-Hourly46,487.69 50,246.08 (3,758.39) 170,521.44 171,542.32 (1,020.88) 564,695.00 394,173.56 69.8%6311882 Wages-Overtime16,319.05 12,350.00 3,969.05 25,498.99 12,350.00 13,148.99 12,350.00 (13,148.99) -106.5%Total-CM-SALARIES & BENEFITS91,555.37 94,918.00 (3,362.63) 307,130.03 302,508.00 4,622.03 947,487.00 640,356.97 67.6%63-CM-SUPPLIES & MATERIALS6313734 Chemicals12,990.79 1,700.00 11,290.79 16,697.78 6,280.00 10,417.78 17,760.00 1,062.22 6.0%6313744 Fertilizer12,095.28 29,560.00 (17,464.72) 34,229.29 47,410.00 (13,180.71) 100,520.00 66,290.71 65.9%6313745 Herbicides- 7,659.00 (7,659.00) 1,854.50 18,061.00 (16,206.50) 25,518.00 23,663.50 92.7%6313746 Flowers/Plants1,346.31 250.00 1,096.31 1,346.31 1,250.00 96.31 3,050.00 1,703.69 55.9%6313748 Fuel-Gasoline5,387.12 4,750.00 637.12 15,050.97 15,250.00 (199.03) 46,860.00 31,809.03 67.9%6313750 Golf Course Accessories9,884.76 12,300.00 (2,415.24) 9,884.76 12,300.00 (2,415.24) 13,140.00 3,255.24 24.8%6313756 POA Control- - - - 2,400.00 (2,400.00) 9,900.00 9,900.00 100.0%6313758 Miscellaneous Supp230.00 500.00 (270.00) 1,010.16 2,750.00 (1,739.84) 4,350.00 3,339.84 76.8%6313762 Supplies-Office1,244.91 - 1,244.91 1,699.21 - 1,699.21 - (1,699.21) 0.0%6313774 Sand- 2,000.00 (2,000.00) 1,142.15 7,780.00 (6,637.85) 13,460.00 12,317.85 91.5%6313776 Seed103,424.93 105,500.00 (2,075.07) 103,424.93 105,500.00 (2,075.07) 117,400.00 13,975.07 11.9%6313778 Small Tools & Non-Capital Equip580.44 2,000.00 (1,419.56) 1,416.67 4,200.00 (2,783.33) 5,000.00 3,583.33 71.7%6313780 Sod793.31 - 793.31 5,163.51 8,800.00 (3,636.49) 13,500.00 8,336.49 61.8%6313782 Topdressing1,266.66 2,200.00 (933.34) 4,849.65 4,400.00 449.65 10,000.00 5,150.35 51.5%Total-CM-SUPPLIES & MATERIALS149,244.51 168,419.00 (19,174.49) 197,769.89 236,381.00 (38,611.11) 380,458.00 182,688.11 48.0%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint- 3,850.00 (3,850.00) 11,530.00 15,400.00 (3,870.00) 46,200.00 34,670.00 75.0%6315685 CM-R&M-Bldngs & Othr Structures 2,578.48 500.00 2,078.48 3,581.35 3,050.00 531.35 5,550.00 1,968.65 35.5%6315690 CM-R&M-Equipment10,861.62 10,000.00 861.62 25,906.72 17,500.00 8,406.72 38,500.00 12,593.28 32.7%6315692 CM-R&M-Irrigation System2,098.68 2,000.00 98.68 10,087.27 11,400.00 (1,312.73) 19,050.00 8,962.73 47.0%6315696 CM-R&M-Pumps886.84 1,000.00 (113.16) 4,592.81 4,000.00 592.81 10,500.00 5,907.19 56.3%6315815 CM-R&M-Trees-Pruning Etc- 550.00 (550.00) 5,190.00 6,050.00 (860.00) 12,050.00 6,860.00 56.9%Total-CM-REPAIRS & MAINTENANCE16,425.62 17,900.00 (1,474.38) 60,888.15 57,400.00 3,488.15 131,850.00 70,961.85 53.8%6317836 Utilities-Natural Gas/LPG 18.52 15.00 3.52 76.40 60.00 16.40 180.00 103.60 0.0%6317840 Telephones813.68 850.00 (36.32) 2,716.65 3,400.00 (683.35) 10,200.00 7,483.35 73.4%Total-CM-UTILITIES832.20 865.00 (32.80) 2,793.05 3,460.00 (666.95) 10,380.00 7,586.95 73.1%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7%6319100 Contract Svcs-Soil/Tissue Test691.38 - 691.38 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) 312.06 2,096.00 (1,783.94) 6,288.00 5,975.94 95.0%6319150 Dues & Subscriptions55.00 - 55.00 475.00 - 475.00 680.00 205.00 30.1%6319170 Employee Education- 50.00 (50.00) - 200.00 (200.00) 3,900.00 3,900.00 100.0%6319197 Equipment Rental- 1,000.00 (1,000.00) - 1,500.00 (1,500.00) 3,400.00 3,400.00 100.0%6319206 Licenses & Permits- 250.00 (250.00) 827.05 350.00 477.05 4,300.00 3,472.95 80.8%6319490 Miscellaneous115.27 100.00 15.27 115.27 400.00 (284.73) 1,200.00 1,084.73 90.4%6319718 Safety Equipment & Training108.65 800.00 (691.35) 1,308.91 1,850.00 (541.09) 3,850.00 2,541.09 66.0%6319822 Uniforms- 920.00 (920.00) 2,729.80 3,680.00 (950.20) 11,040.00 8,310.20 75.3%Total-CM-OTHER EXPENSES1,474.32 4,044.00 (2,569.68) 8,059.47 12,676.00 (4,616.53) 41,458.00 33,398.53 80.6%Month to DateYear to DateSilverRock ResortCourse Maintenance Expense StatementAnnual BudgetOctober 20185 October 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) 12,327.33 11,136.00 1,191.33 33,408.00 21,080.67 63.1%6321325 Insurance-Workers Comp495.35 569.00 (73.65) 2,356.24 2,053.00 303.24 5,955.00 3,598.76 60.4%6321800 Taxes-Employer Payroll877.82 2,122.00 (1,244.18) 3,447.18 7,266.00 (3,818.82) 20,793.00 17,345.82 83.4%6321880 Wages-Hourly12,631.63 12,904.00 (272.37) 51,458.86 52,476.00 (1,017.14) 156,528.00 105,069.14 67.1%6321882 Wages-Overtime1,400.00 3,418.00 (2,018.00) 2,629.69 3,418.00 (788.31) 3,418.00 788.31 23.1%Total-CM-LM-SALARIES & BENEFITS18,011.20 21,797.00 (3,785.80) 72,219.30 76,349.00 (4,129.70) 220,102.00 147,882.70 67.2%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 100.00 (100.00) - 400.00 (400.00) 1,025.00 1,025.00 100.0%6323788 Uniforms1,054.29 290.00 764.29 1,766.27 1,160.00 606.27 3,480.00 1,713.73 49.2%Total-CM-LM-SUPPLIES & MATERIALS1,054.29 390.00 664.29 1,766.27 1,560.00 206.27 4,505.00 2,738.73 60.8%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 500.00 (500.00) - 1,500.00 (1,500.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE- 500.00 (500.00) - 1,500.00 (1,500.00) 4,250.00 4,250.00 100.0%278,597.51 308,833.00 (30,235.49) 650,626.16 691,834.00 (41,207.84) 1,740,490.00 1,089,863.84 62.6% October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 8,514.95 8,390.00 124.95 50,127.74 44,262.00 5,865.74 179,791.00 129,663.26 72.1%6337842 Utilities-Water7,137.30 9,850.00 (2,712.70) 29,875.33 42,950.00 (13,074.67) 70,047.00 40,171.67 57.3%15,652.25 18,240.00 (2,587.75) 80,003.07 87,212.00 (7,208.93) 249,838.00 169,834.93 68.0%Total-COURSE MAINTENANCECourse Maintenance Expense StatementOctober 2018Silverrock ResortAnnual BudgetMonth to DateYear to DateSilverrock ResortCourse Maintenance Water & EnergyOctober 2018Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual Budget6 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group668.53 696.00 (27.47) 1,337.06 2,784.00 (1,446.94) 8,352.00 7,014.94 84.0%6411325 Insurance-Workers Comp1,188.84 266.48 922.36 2,710.65 1,160.58 1,550.07 6,172.00 3,461.35 56.1%6411800 Taxes-Employer Payroll762.03 884.70 (122.67) 3,516.18 3,853.09 (336.91) 20,493.00 16,976.82 82.8%6411880 Wages-Hourly8,308.63 7,106.00 1,202.63 37,280.65 30,948.50 6,332.15 164,599.00 127,318.35 77.4%6411882 Wages-Overtime57.76 - 57.76 187.67 - 187.67 - (187.67) 0.0%Total-CBR-SALARIES & BENEFITS10,985.798,953.18 2,032.61 45,032.21 38,746.17 6,286.04 199,616.00 154,583.79 77.4%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- 500.00 (500.00) - 500.00 (500.00) 1,850.00 `0.0%6413742 Supplies-Expendable- 150.00 (150.00) 113.10 1,500.00 (1,386.90) 6,750.00 6,636.90 98.3%6413748 Supplies-Fuel for Shuttle- 100.00 (100.00) - 200.00 (200.00) 3,000.00 3,000.00 100.0%6413752 Supplies-Range Balls- - - - - - 9,000.00 9,000.00 100.0%6413762 Supplies-Office- 50.00 (50.00) 14.67 125.00 (110.33) 525.00 510.33 97.2%6413768 Supplies-Printing and Stationary- - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels727.65 120.00 607.65 3,462.48 480.00 2,982.48 2,182.00 (1,280.48) -58.7%6413796 Supplies-Bottled Water395.00 100.00 295.00 6,480.06 4,700.00 1,780.06 12,900.00 6,419.94 49.8%Total-CBR-SUPPLIES & MATERIALS1,122.65 1,020.00 102.65 10,070.31 7,505.00 2,565.31 36,627.00 24,706.69 67.5%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment31.50 300.00 (268.50) 31.50 1,200.00 (1,168.50) 3,600.00 3,568.50 99.1%6415695 CBR-R&M-Cart Maintenance & Repair- 950.00 (950.00) 8,236.16 2,450.00 5,786.16 6,450.00 (1,786.16) -27.7%Total-CBR-REPAIRS & MAINTENANCE31.50 1,250.00 (1,218.50) 8,267.66 3,650.00 4,617.66 10,050.00 1,782.34 17.7%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen240.00 800.00 (560.00) 2,181.42 3,200.00 (1,018.58) 9,600.00 7,418.58 77.3%6419220 Freight/Delivery- 75.00 (75.00) - 300.00 (300.00) 450.00 450.00 100.0%6419490 Miscellaneous77.88 600.00 (522.12) 250.53 2,400.00 (2,149.47) 7,200.00 6,949.47 96.5%6419820 Uniforms- 2,000.00 (2,000.00) - 2,000.00 (2,000.00) 5,200.00 5,200.00 100.0%Total-CBR-OTHER EXPENSES317.88 3,475.00 (3,157.12) 2,431.95 7,900.00 (5,468.05) 22,450.00 20,018.05 89.2%TOTAL-CARTS,BAGROOM & RANGE12,457.8214,698.18(3,157.12) 65,802.13 57,801.17 8,000.96 268,743.00 201,090.87 74.8%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp495.35 70.13 425.22 1,428.36 454.23 974.13 2,630.00 1,201.64 45.7%6431800 Taxes-Employer Payroll155.59 243.10 (87.51) 1,004.80 1,574.63 (569.83) 9,117.00 8,112.20 89.0%6431880 Wages-Hourly1,988.25 1,870.00 118.25 12,259.50 12,112.50 147.00 70,133.00 57,873.50 82.5%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS2,639.19 2,183.23 455.96 14,692.66 14,141.36 551.30 81,880.00 67,187.34 82.1%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 100.00 (100.00) 82.64 300.00 (217.36) 1,050.00 967.36 92.1%6439490 Miscellaneous101.38 50.00 51.38 155.70 50.00 105.70 200.00 44.30 22.2%6439718 Safety Equipment & Training- 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6439820 Uniforms- 800.00 (800.00) - 1,025.00 (1,025.00) 2,125.00 2,125.00 100.0%Total-CS-OTHER EXPENSES101.38 1,000.00 (898.62) 238.34 1,575.00 (1,336.66) 3,975.00 3,736.66 94.0%Total-COURSE SERVICES2,740.57 3,183.23 (442.66) 14,931.00 15,716.36 (785.36) 85,855.00 70,924.00 82.6%15,198.3917,881.41(2,683.02) 80,733.13 73,517.53 7,215.60 354,598.00 268,278.21 75.7%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementAnnual BudgetOctober 20187 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 1,600.00 1,600.00 - 4,800.00 3,200.00 66.7%65-CH-UTILITIES6507836 Utilities-Natural Gas361.31 300.00 61.31 1,561.37 1,200.00 361.37 3,600.00 2,038.63 56.6%6507840 Utilities-Telephone1,191.11 1,150.00 41.11 3,570.21 4,600.00 (1,029.79) 13,800.00 10,229.79 74.1%6507842 Utilities-Water948.20 321.00 627.20 3,487.71 1,284.00 2,203.71 3,852.00 364.29 9.5%6507844 Utilities-Cable 495.80 380.00 115.80 1,983.28 1,520.00 463.28 4,560.00 2,576.72 56.5%Total-CH-UTILITIES2,996.42 2,151.00 845.42 10,602.57 8,604.00 1,998.57 25,812.00 15,209.43 58.9%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning824.00 2,425.00 (1,601.00) 2,124.00 7,900.00 (5,776.00) 22,500.00 20,376.00 90.6%6509099 Contract Services-Security5,094.72 5,000.00 94.72 21,344.21 20,000.00 1,344.21 60,000.00 38,655.79 64.4%6509215 Flowers & Decorations- 500.00 (500.00) - 500.00 (500.00) 1,900.00 1,900.00 100.0%6509490 Miscellaneous19.99 200.00 (180.01) 276.58 800.00 (523.42) 7,000.00 6,723.42 96.0%6509718 Safety Equipment & Training- 100.00 (100.00) 251.47 400.00 (148.53) 1,200.00 948.53 79.0%Total-CH-OTHER EXPENSES5,938.71 8,225.00 (2,286.29)23,996.26 29,600.00 (5,603.74) 92,600.00 68,603.74 74.1%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures868.75 300.00 568.75 4,642.70 1,200.00 3,442.70 3,600.00 (1,042.70) -29.0%6515686 CH-R&M-Restaurant Repairs 2,950.00 400.00 2,550.00 2,950.00 1,600.00 1,350.00 4,800.00 1,850.00 38.5%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) - 1,600.00 (1,600.00) 4,800.00 4,800.00 100.0%Total-CH-REPAIRS & MAINTENANCE3,818.75 1,100.00 2,718.75 7,592.70 4,400.00 3,192.70 13,200.00 5,607.30 42.5%13,153.88 11,876.001,277.88 43,791.53 44,204.00 (412.47) 136,412.00 11,214.60 8.2%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementAnnual BudgetOctober 20188 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 355.89 348.00 7.89 1,423.56 1,392.00 31.56 4,176.00 2,752.44 65.9%6601325 Insurance-Workers Comp95.40 94.00 1.40 387.57 376.00 11.57 1,129.00 741.43 65.7%6601720 Salaries1,905.20 2,508.00 (602.80) 7,620.80 10,032.00 (2,411.20) 30,096.00 22,475.20 74.7%6601800 Taxes-Employer Payroll145.20 326.00 (180.80) 580.80 1,304.00 (723.20) 3,912.00 3,331.20 85.2%Total-MKT-SALARIES & BENEFITS2,501.69 3,276.00 (774.31) 10,012.73 13,104.00 (3,091.27) 39,313.00 29,300.27 74.5%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 64.17 100.00 (35.83) 551.76 400.00 151.76 1,200.00 648.24 54.0%6603768 Supplies-Printing & Stationery 802.65 3,000.00 (2,197.35) 1,730.81 3,200.00 (1,469.19) 4,425.00 2,694.19 60.9%866.82 3,100.00 (2,233.18) 2,282.57 3,600.00 (1,317.43) 5,625.00 3,342.43 59.4%66-MKT-UTILITIES6607840 Utilities-Telephone 148.49 100.00 48.49 1,822.87 400.00 1,422.87 1,200.00 (622.87) -51.9%Total-MKT-UTILITIES148.49 100.00 48.49 1,822.87 400.00 1,422.87 1,200.00 (622.87) -51.9%66-MKT-OTHER EXPENSES6609010 Advertising12,940.47 13,322.00 (381.53) 34,291.76 31,509.00 2,782.76 169,987.00 135,695.24 79.8%6609040 Business Meals- 25.00 (25.00) - 100.00 (100.00) 300.00 300.00 100.0%6609080 Collateral Material- 500.00 (500.00) 4,579.50 500.00 4,079.50 5,500.00 920.50 16.7%6609102 Contract Services-Web Page99.00 150.00 (51.00) 198.00 600.00 (402.00) 1,800.00 1,602.00 89.0%6609490 Miscellaneous- - - - - - 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6609630 Promotion- 50.00 (50.00) 700.00 50.00 650.00 700.00 - 0.0%6609633 Promotion-Community- 75.00 (75.00) 913.85 300.00 613.85 2,250.00 1,336.15 59.4%6609634 Promotion-Media/Vendor- - - - - - 1,000.00 1,000.00 100.0%6609150 Dues and Subscriptions- - - - - - 735.00 735.00 100.0%6609820 Uniforms299.07 300.00 (0.93) 299.07 300.00 (0.93) 600.00 300.93 50.2%Total-MKT-OTHER EXPENSES13,338.54 14,472.00 (1,133.46) 40,982.18 33,559.00 7,423.18 183,822.00 142,839.82 77.7%16,855.54 20,948.00 (4,092.46) 55,100.35 50,663.00 4,437.35 229,960.00 174,859.65 76.0%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementAnnual BudgetOctober 20189 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group2,376.47 1,509.00 867.47 8,987.06 6,036.00 2,951.06 18,108.00 9,120.94 50.4%6701325 Insurance-Workers Comp647.26 632.00 15.26 2,256.36 2,484.00 (227.64) 7,905.00 5,648.64 71.5%6701720 Salaries11,494.80 14,456.00 (2,961.20) 45,979.20 54,804.00 (8,824.80) 177,996.00 132,016.80 74.2%6701800 Taxes-Employer Payroll1,069.67 2,193.00 (1,123.33) 4,316.35 8,616.00 (4,299.65) 32,800.00 28,483.65 86.8%6701880 Wages-Hourly2,498.32 2,410.00 88.32 10,485.82 11,461.00 (975.18) 27,404.00 16,918.18 61.7%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS18,086.52 21,200.00 (3,113.48) 72,024.79 83,401.00 (11,376.21) 264,213.00 192,188.21 72.7%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer145.48 500.00 (354.52) 468.49 2,000.00 (1,531.51) 6,300.00 5,831.51 92.6%6703762 Supplies-Office- 105.00 (105.00) 187.47 420.00 (232.53) 1,260.00 1,072.53 85.1%6703768 Supplies-Printing & Stationery- 100.00 (100.00) 713.37 400.00 313.37 3,300.00 2,586.63 78.4%Total-G&A-SUPPLIES & MATERIALS145.48 705.00 (559.52) 1,369.33 2,820.00 (1,450.67) 10,860.00 9,490.67 87.4%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment 53.14 100.00 (46.86) 683.14 300.00 383.14 1,900.00 1,216.86 64.0%Total-G&A-REPAIRS & MAINTENANCE53.14 100.00 (46.86) 683.14 300.00 383.14 1,900.00 1,216.86 64.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 2,000.00 2,000.00 - 6,000.00 4,000.00 66.7%6709150 Dues & Subscriptions- 50.00 (50.00) 180.00 300.00 (120.00) 1,150.00 970.00 84.3%6709180 Employee Recruiting/Relocation192.00 150.00 42.00 342.00 300.00 42.00 1,200.00 858.00 71.5%6709197 Equipment Rental702.57 550.00 152.57 1,919.42 2,200.00 (280.58) 6,600.00 4,680.58 70.9%6709202 Fees-Bank41.64 90.00 (48.36) 244.53 360.00 (115.47) 1,080.00 835.47 77.4%6709208 Fees-Payroll Processing358.90 1,000.00 (641.10) 1,415.25 4,000.00 (2,584.75) 12,000.00 10,584.75 88.2%6709220 Freight/Delivery- 50.00 (50.00) - 200.00 (200.00) 600.00 600.00 100.0%6709490 Miscellaneous- 100.00 (100.00) 189.53 400.00 (210.47) 6,600.00 6,410.47 97.1%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services- 75.00 (75.00) 276.60 300.00 (23.40) 900.00 623.40 69.3%6709625 Professional Fees1,629.00 850.00 779.00 3,789.00 3,400.00 389.00 10,200.00 6,411.00 62.9%6709636 Promotion/Entertainment- 100.00 (100.00) - 400.00 (400.00) 1,200.00 1,200.00 100.0%6709722 Seminars & Training- 200.00 (200.00) 250.00 800.00 (550.00) 2,400.00 2,150.00 89.6%6709810 Travel- - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms47.31 150.00 900.00 291.81 375.00 (83.19) 1,050.00 758.19 72.2%Total-G&A-OTHER EXPENSES3,471.42 3,865.00 609.11 10,898.14 15,135.00 (4,236.86) 52,080.00 41,181.86 79.1%21,756.56 25,870.00 (4,113.44) 84,975.40 101,656.00 (16,680.60) 329,053.00 244,077.60 74.2%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementAnnual BudgetOctober 201810 October Final Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts9,829.27 10,500.00 (670.73) 39,317.09 40,650.00 (1,332.91) 121,050.00 81,732.91 67.5%6800193 Equipment Leases-Maintenance 9,181.20 9,500.00 (318.80) 36,724.80 38,000.00 (1,275.20) 114,000.00 77,275.20 67.8%6800194 Equipment Leases-Trailer658.07 600.00 58.07 2,817.28 2,400.00 417.28 7,200.00 4,382.72 60.9%6800196 Equipment Leases-GPS3,870.00 3,900.00 (30.00) 15,480.00 15,600.00 (120.00) 46,800.00 31,320.00 66.9%6800197 Equipment Leases-Others2,060.69 1,150.00 910.69 8,211.20 4,600.00 3,611.20 20,200.00 11,988.80 0.0%25,599.23 25,650.00(50.77) 102,550.37101,250.00 1,300.37 309,250.00 206,699.6366.8%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 9,500.00 9,500.00 - 38,000.00 38,000.00 - 114,000.00 76,000.00 66.7%6900210 FF&E Reserve1,113.22 549.64 563.58 7,264.04 5,826.15 1,437.89 68,026.00 60,761.96 89.3%6900800 Personal Property Taxes- 2,600.00 (2,600.00) 14,738.21 11,800.00 2,938.21 11,800.00 (2,938.21) -24.9%6900323 Insurance-Commercial6,302.41 4,000.00 2,302.41 15,860.34 16,000.00 (139.66) 48,000.00 32,139.66 67.0%16,915.63 16,649.64265.99 75,862.59 71,626.15 4,236.44 241,826.00 165,963.4168.6%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementAnnual BudgetMonth to Date Year to DateOctober 201811 SilverRock Resort-Arnold Palmer Classic Course 12 13