Loading...
11 May 2017 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2016 – May 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 MayFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue69,757.94 285,924.00 (216,166.06) -75.6% 2,853,978.54 2,830,097.00 23,881.54 3,199,237.00 345,258.46 89%401000 Miscellaneous Golf Revenue15,180.00 30,020.00 (14,840.00) -49.4% 324,352.67 330,498.00 (6,145.33) 349,259.00 24,906.33 93%410000Revenue-Golf Shop8,548.90 29,700.00 (21,151.10) -71.2%215,320.27 247,315.00 (31,994.73) 278,585.00 63,264.73 77%420000 Revenue-F&B Concession500.00 500.00 - 0.0% 11,500.00 11,500.00 - 12,000.00 500.00 96%890000 Interest Income0.04 - 0.04 0.51 - 0.51 - (0.51) 0%Total Income93,986.88 346,144.00 (252,157.12) -72.8% 3,405,151.99 3,419,410.00 (14,258.01) 3,839,081.00 433,929.01 89%Cost of Goods Sold510000 COS-Golf Shop4,743.46 16,623.00 (11,879.54) 71.5% 121,500.01 138,421.70 16,921.69 155,924.00 34,423.99 78%Total COS4,743.46 16,623.00 (11,879.54) 71.5% 121,500.01 138,421.70 16,921.69 155,924.00 34,423.99 78%Gross Profit89,243.42 329,521.00 (240,277.58) -72.9% 3,283,651.98 3,280,988.30 2,663.68 3,683,157.00 399,505.02 89%Expenses610000 Golf Pro Shop15,826.02 21,498.00 (5,671.98) 26.4% 174,366.89 183,232.00 (8,865.11) 204,827.00 30,460.11 85%630000 Course Maintenance108,946.57 117,124.00 (8,177.43) 7.0% 1,498,345.63 1,572,208.00 (73,862.37) 1,712,795.00 214,449.37 87%633000 Maintenance Water & Energy17,247.46 25,736.00 (8,488.54) 33.0% 183,963.82 218,869.00 (34,905.18) 225,129.00 41,165.18 82%640000 Outside Services29,297.95 21,479.00 7,818.95 -36.4% 309,862.93 290,628.00 19,234.93 309,830.00 (32.93) 100%650000 Clubhouse10,247.03 10,636.00 (388.97) 3.7% 124,033.41 125,296.00 (1,262.59) 136,332.00 12,298.59 91%660000 Marketing15,442.53 12,931.00 2,511.53 -19.4% 231,797.30 220,829.00 10,968.30 240,177.00 8,379.70 97%670000 General & Administrative23,550.99 28,211.00 (4,660.01) 16.5% 273,090.36 301,105.00 (28,014.64) 327,511.00 54,420.64 83%680000 Leases25,471.92 28,800.00 (3,328.08) 11.6% 278,830.77 292,250.00 (13,419.23) 271,050.00 (7,780.77) 103%690000 Miscellaneous Other Expense14,622.72 17,071.00 (2,448.28) 14.3% 216,122.20 193,286.00 22,836.20 202,025.00 (14,097.20) 107%Total Expenses260,653.19 283,486.00 (22,832.81) 8.1% 3,290,413.31 3,397,703.00 107,289.69 3,629,676.00 339,262.69 91%(171,409.77) 46,035.00 (217,444.77) -472.3%(6,761.33) (116,714.70) 109,953.37 53,481.00 60,242.33 0%Rounds of Golf PlayedPaid Rounds Played2,128 4,950 (2,822) -57.0%42,228 39,600 2,628 46,475 4,247 91%Ave $ Per Paid Round Green Fee32.78 57.76 (24.98) -43.2%67.58 71.47 (3.88) 68.84 1.25 98%Ave $ Per Paid Round Merchandise4.02 6.00 (1.98) -33.0%5.10 6.25 (1.15) 5.99 0.90 85%Ave $ Per Paid Miscellaneous 7.13 6.06 1.07 17.6%7.68 8.35 (0.66) 7.51 (0.17) 102%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateMay 20171 Income MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees69,757.94 285,924.00 (216,166.06) 2,853,978.54 2,830,097.00 23,881.54 3,199,237.00 345,258.46 10.8%4010000 Rider Fee375.00 495.00 (120.00) 8,482.50 7,061.00 1,421.50 7,738.00 (744.50) -9.6%4040000 Club Rental2,115.00 2,475.00 (360.00) 26,300.00 19,854.00 6,446.00 23,238.00 (3,062.00) -13.2%4050000 Driving Range5,650.00 7,425.00 (1,775.00) 92,114.00 107,808.00 (15,694.00) 100,984.00 8,870.00 8.8%4060000 Handicap Fees- - - 33.12 2,500.00 (2,466.88) 2,500.00 2,466.88 98.7%4080000 GPS Advertising- - - - 2,600.00 (2,600.00) 2,600.00 2,600.00 100.0%4090000 Ball Retriever/Subcontract- - - 2,645.30 4,000.00 (1,354.70) 4,000.00 1,354.70 33.9%4091000 Golf Professional Rental Fee890.00 4,000.00 (3,110.00) 46,142.75 37,000.00 9,142.75 37,000.00 (9,142.75) -24.7%4092000 Golf Lessons- - - - - - - - 0.0%4093000 Resident Card Issue6,150.00 15,625.00 (9,475.00) 148,635.00 149,675.00 (1,040.00) 171,200.00 22,565.00 13.2% Total Revenue Fees84,937.94 315,944.00 (231,006.06) 3,178,331.21 3,160,595.00 17,736.21 3,548,497.00 370,165.79 10.4%84,937.94 315,944.00 (231,006.06) 3,178,331.21 3,160,595.00 17,736.21 3,548,497.00 370,165.79 10.4%SilverRock ResortStatement of Fees RevenueMay 2017Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$69,757.94$285,924.00(216,166.06)Unfavorable: Rounds down 2822 to budget due to closure of the back nine holes.ActualBudgetVariance$15,180.00$30,020.00(14,840.00)Unfavorable: Rounds down 2822 to budget due to closure of the back nine holes.ActualBudgetVariance$8,548.90$29,700.00(21,151.10)Unfavorable: Rounds down 2822 to budget due to closure of the back nine holes.ExpensesActualBudgetVariance$15,826.02$21,498.00(5,671.98)Favorable: Due to reduced labor cost with the closure of the back nine.ActualBudgetVariance$17,247.46$25,736.00(8,488.54)Favorable: Due to reduced watering cycles and cooler temperatures. Also, reduced runtime on the waterfalls at the entry.ActualBudgetVariance$29,297.95$21,479.007,818.95Unfavorable: Due to increased payroll to facilitate the cleaning of driving range and cartbarn.ActualBudgetVariance$15,442.53$12,931.002,511.53Unfavorable: Due to timing of advertising invoices.ActualBudgetVariance$23,550.99$28,211.00(4,660.01)Favorable: Due to reduced line items for Computer supplies and print and stationary.ActualBudgetVariance$25,471.92$28,800.00(3,328.08)Favorable: Due to adjustment of taxes on maintenance equipment.ActualBudgetVariance$14,622.72$17,071.00(2,448.28)Favorable: Due to reduction of reserve money as a result of the closure of the back nine.Golf ShopGeneral & AdministrativeMarketingMiscellaneous Other ExpenseLeasesMaintenance Water and EnergyOutside Servicesprovided for those cost of sales percentage that are greater than 5%.Pro Shop Merchandise SalesGolf Green Fee RevenueMiscellaneous Golf RevenueVariance ExplanationMay 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 are3-20-133 Income MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous6.54 - 6.54 5,503.83 - 5,503.83 00 0%4100110 Sales Hard Goods3,260.33 10,395.00 (7,134.67) 73,917.96 86,561.00 (12,643.04) 97,505.00 23,587.04 24.2%4100112 Sales-Soft Goods7,110.50 19,305.00 (12,194.50) 163,854.25 160,754.00 3,100.25 181,080.00 17,225.75 9.5%5100639 GS-Discounts-Mdse (1,828.47) - (1,828.47) (27,955.77) - (27,955.77) - 27,955.77 0.0% Total Revenue Golf Shop8,548.90 29,700.00 (21,151.10) 215,320.27 247,315.00 (31,994.73) 278,585.00 68,768.56 24.7%COS 5100150 COS-GS-Hard Goods 421.76 6,029.10 (5,607.34) 38,214.07 50,205.38 (11,991.31) 56,552.90 18,338.83 32.4%5100151 COS-GS-Soft Goods 4,277.18 11,196.90 (6,919.72) 80,568.73 93,237.32 (12,668.59) 105,026.40 24,457.67 23.3%5100152 COS-GS-Purchase Disc- (861.00) 861.00 (652.71) (7,173.00) 6,520.29 (8,079.00) (7,426.29) 91.9%5100220 COS-GS-Freight Merch 44.52 258.00 (213.48) 3,369.92 2,152.00 1,217.92 2,424.00 (945.92) -39.0%Cost of Sales - Golf Shop 4,743.46 16,623.00 (11,879.54) 121,500.01 138,421.70 (16,921.69) 155,924.30 34,424.29 22.1%Gross Profit3,805.44 13,077.00 (9,271.56) 93,820.26 108,893.30 (15,073.04) 122,660.70 34,344.27 28.0%COS %55.5% 56.0% 0.5% 56.4% 56.0% -0.5% 53.1% 50.1% 94.3%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group1,404.84 2,387.00 (982.16) 19,763.08 23,870.00 (4,106.92) 27,621.00 7,857.92 28.4%6101325 Insurance-Workers Comp 1,118.36 461.00 657.36 7,052.61 4,508.00 2,544.61 5,042.00 (2,010.61) -39.9%6101720 Salaries4,000.00 4,001.00 (1.00) 44,007.00 44,011.00 (4.00) 45,000.00 993.00 2.2%6101800 Taxes-Employer Payroll 1,245.95 1,722.00 (476.05) 14,196.99 16,834.00 (2,637.01) 18,825.00 4,628.01 24.6%6101880 Wages-Hourly6,048.46 8,302.00 (2,253.54) 74,479.63 76,244.00 (1,764.37) 89,463.00 14,983.37 16.7%6101882 Wages-Overtime345.75 - 345.75 1,309.92 - 1,309.92 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 14,163.36 16,873.00 (2,709.64) 160,809.23 165,467.00 (4,657.77) 185,951.00 27,404.57 14.7%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office- 250.00 (250.00) 836.00 2,750.00 (1,914.00) 3,000.00 2,164.00 72.1%6109220 Freight & Delivery- - - 39.80 75.00 (35.20) 75.00 35.20 46.9%6109490 Miscellaneous500.00 500.00 - 7,336.27 5,500.00 1,836.27 6,000.00 (1,336.27) -22.3%6109150 Dues and Subscriptions 559.00 2,300.00 (1,741.00) 1,662.62 2,300.00 (637.38) 2,300.00 637.38 27.7%6109500 ProShop-Over/Short276.33 - 276.33 265.29 - 265.29 - (265.29) 0.0%6109722 Seminars/Training- 1,250.00 (1,250.00) 55.00 3,655.00 (3,600.00) 3,690.00 3,635.00 98.5%6109810 Travel - Merchandise- 15.00 (15.00) - 75.00 (75.00) 90.00 90.00 100.0%6109820 Uniforms174.56 200.00 (25.44) 2,439.08 2,200.00 239.08 2,400.00 (39.08) -1.6%6117840 Telephones152.77 110.00 42.77 923.60 1,210.00 (286.40) 1,320.00 396.40 30.0%1,662.66 4,625.00 (2,962.34) 13,557.66 17,765.00 (4,207.34) 18,875.00 5,317.34 28.2%15,826.02 21,498.00 (5,671.98) 174,366.89 183,232.00 (8,865.11) 204,826.00 32,721.91 16.0%Net Income(12,020.58) (8,421.00) (3,599.58) (80,546.63) (74,338.70) (6,207.93) (82,165.30) 1,622.36 -2.0%SilverRock ResortGolf Shop Income StatementMay 2017Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group10,588.90 8,990.00 1,598.90 99,187.11 98,890.00 297.11 107,880.00 8,692.89 8.1%6311325 Insurance-Workers Comp3,834.38 2,065.00 1,769.38 27,319.13 22,171.00 5,148.13 24,308.00 (3,011.13) -12.4%6311720 Salaries11,557.08 9,333.33 2,223.75 119,754.46 102,666.63 17,087.83 112,000.00 (7,754.46) -6.9%6311800 Taxes-Employer Payroll2,946.12 7,709.00 (4,762.88) 63,144.90 83,371.00 (20,226.10) 91,481.00 28,336.10 31.0%6311880 Wages-Hourly42,022.92 45,727.67 (3,704.75) 485,525.11 479,765.37 5,759.74 525,494.00 39,968.89 7.6%6311882 Wages-Overtime19.85 - 19.85 12,877.24 13,076.00 (198.76) 15,945.00 3,067.76 19.2%Total-CM-SALARIES & BENEFITS70,969.25 73,825.00 (2,855.75) 807,807.95 799,940.00 7,867.95 877,108.00 69,300.05 7.9%63-CM-SUPPLIES & MATERIALS6313734 Chemicals1,310.37 900.00 410.37 29,484.37 32,600.00 (3,115.63) 34,600.00 5,115.63 14.8%6313744 Fertilizer4,161.96 5,000.00 (838.04) 74,387.96 107,500.00 (33,112.04) 112,500.00 38,112.04 33.9%6313745 Herbicides- - - 13,179.43 17,000.00 (3,820.57) 17,000.00 3,820.57 22.5%6313746 Flowers/Plants370.83 - 370.83 1,891.48 3,050.00 (1,158.52) 3,050.00 1,158.52 38.0%6313748 Fuel-Gasoline1,516.65 3,100.00 (1,583.35) 31,098.83 49,870.00 (18,771.17) 55,020.00 23,921.17 43.5%6313750 Golf Course Accessories951.93 100.00 851.93 13,502.24 12,900.00 602.24 13,000.00 (502.24) -3.9%6313756 POA Control- - - 6,367.86 7,000.00 (632.14) 7,000.00 632.14 9.0%6313758 Miscellaneous Supp704.15 100.00 604.15 7,017.25 4,250.00 2,767.25 4,350.00 (2,667.25) -61.3%6313762 Supplies-Office336.51 - 336.51 2,104.46 - 2,104.46 - (2,104.46) 0.0%6313774 Sand- 100.00 (100.00) 9,273.61 13,360.00 (4,086.39) 13,460.00 4,186.39 31.1%6313776 Seed- 350.00 (350.00) 117,164.38 125,550.00 (8,385.62) 125,900.00 8,735.62 6.9%6313778 Small Tools & Non-Capital Equip- 100.00 (100.00) 3,066.98 4,900.00 (1,833.02) 5,000.00 1,933.02 38.7%6313780 Sod- 500.00 (500.00) 11,636.88 10,250.00 1,386.88 10,450.00 (1,186.88) -11.4%6313782 Topdressing- 1,300.00 (1,300.00) 4,582.66 9,300.00 (4,717.34) 10,600.00 6,017.34 56.8%Total-CM-SUPPLIES & MATERIALS9,352.40 11,550.00 (2,197.60) 324,758.39 397,530.00 (72,771.61) 411,930.00 87,171.61 21.2%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint 2,830.00 2,600.00 230.00 29,760.00 28,600.00 1,160.00 31,200.00 1,440.00 4.6%6315685 CM-R&M-Bldngs & Othr Structures 155.54 250.00 (94.46) 2,855.84 5,300.00 (2,444.16) 5,550.00 2,694.16 48.5%6315690 CM-R&M-Equipment3,691.28 2,500.00 1,191.28 34,624.28 34,500.00 124.28 40,000.00 5,375.72 13.4%6315692 CM-R&M-Irrigation System- 1,000.00 (1,000.00) 19,818.61 18,050.00 1,768.61 19,050.00 (768.61) -4.0%6315696 CM-R&M-Pumps- 500.00 (500.00) 9,131.23 10,500.00 (1,368.77) 10,500.00 1,368.77 13.0%6315815 CM-R&M-Trees-Pruning Etc- - - 6,071.00 12,050.00 (5,979.00) 12,050.00 5,979.00 49.6%Total-CM-REPAIRS & MAINTENANCE6,676.82 6,850.00 (173.18) 102,260.96 109,000.00 (6,739.04) 118,350.00 16,089.04 13.6%6317836 Utilities-Natural Gas/LPG20.87 15.00 5.87 233.69 165.00 68.69 180.00 (53.69) 0.0%6317840 Telephones895.17 850.00 45.17 8,023.60 9,350.00 (1,326.40) 10,200.00 2,176.40 21.3%Total-CM-UTILITIES 916.04 865.00 51.04 8,257.29 9,515.00 (1,257.71) 10,380.00 2,122.71 20.5%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance 400.00 500.00 (100.00) 4,400.00 5,500.00 (1,100.00) 6,000.00 1,600.00 26.7%6319100 Contract Svcs-Soil/Tissue Test- 2,000.00 (2,000.00) 730.80 4,000.00 (3,269.20) 4,000.00 3,269.20 81.7%6319102 Contract Svcs-Trash Removal712.34 524.00 188.34 8,069.56 5,764.00 2,305.56 6,288.00 (1,781.56) -28.3%6319150 Dues & Subscriptions- - - 1,305.00 440.00 865.00 540.00 (765.00) -141.7%6319170 Employee Education- 50.00 (50.00) - 1,500.00 (1,500.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental- 200.00 (200.00) 774.36 3,300.00 (2,525.64) 3,400.00 2,625.64 77.2%6319206 Licenses & Permits- - - 6,548.26 4,180.00 2,368.26 4,180.00 (2,368.26) -56.7%6319490 Miscellaneous- 100.00 (100.00) 797.35 1,100.00 (302.65) 1,200.00 402.65 33.6%6319718 Safety Equipment & Training140.06 100.00 40.06 3,105.82 3,750.00 (644.18) 3,850.00 744.18 19.3%6319822 Uniforms678.46 920.00 (241.54) 12,474.54 10,120.00 2,354.54 11,040.00 (1,434.54) -13.0%Total-CM-OTHER EXPENSES1,930.86 4,394.00 (2,463.14) 38,205.69 39,654.00 (1,448.31) 42,048.00 3,842.31 9.1%SilverRock ResortCourse Maintenance Expense StatementMay 2017Annual BudgetMonth to Date Year to Date5 MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group2,361.85 2,728.00 (366.15) 38,149.91 30,008.00 8,141.91 32,736.00 (5,413.91) -16.5%6321325 Insurance-Workers Comp798.83 519.00 279.83 5,956.40 5,626.00 330.40 6,171.00 214.60 3.5%6321800 Taxes-Employer Payroll1,086.07 1,938.00 (851.93) 14,640.78 21,252.00 (6,611.22) 23,334.00 8,693.22 37.3%6321880 Wages-Hourly12,515.81 13,840.00 (1,324.19) 145,456.99 146,480.00 (1,023.01) 160,320.00 14,863.01 9.3%6321882 Wages-Overtime- - - 5,458.15 5,313.00 145.15 6,351.00 892.85 14.1%Total-CM-LM-SALARIES & BENEFITS 16,762.56 19,025.00 (2,262.44) 209,662.23 208,679.00 983.23 228,912.00 19,249.77 8.4%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools265.20 75.00 190.20 414.20 950.00 (535.80) 1,025.00 610.80 59.6%6323788 Uniforms262.35 290.00 (27.65) 4,763.63 3,190.00 1,573.63 3,480.00 (1,283.63) -36.9%Total-CM-LM-SUPPLIES & MATERIALS527.55 365.00 162.55 5,177.83 4,140.00 1,037.83 4,505.00 (672.83) -14.9%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation1,811.09 250.00 1,561.09 2,215.29 3,750.00 (1,534.71) 4,250.00 2,034.71 47.9%Total-CM-LM-REPAIRS & MAINTENANCE 1,811.09 250.00 1,561.09 2,215.29 3,750.00 (1,534.71) 4,250.00 2,034.71 47.9%108,946.57 117,124.00 (8,177.43) 1,498,345.63 1,572,208.00 (73,862.37) 1,697,483.00 199,137.37 11.7% MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping15,109.37 21,017.00 (5,907.63) 130,939.11 158,261.00 (27,321.89) 179,791.00 48,851.89 27.2%6337842 Utilities-Water2,138.09 4,719.00 (2,580.91) 53,024.71 60,608.00 (7,583.29) 45,338.00 (7,686.71) -17.0%17,247.46 25,736.00 (8,488.54) 183,963.82 218,869.00 (34,905.18) 225,129.00 41,165.18 18.3%Silverrock ResortCourse Maintenance Water & EnergyMay 2017Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementMay 2017Silverrock ResortAnnual BudgetMonth to Date Year to Date6 MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 682.00 (682.00) 800.00 7,502.00 (6,702.00) 8,184.00 7,384.00 90.2%6411325 Insurance-Workers Comp2,236.72 411.00 1,825.72 11,486.69 4,841.00 6,645.69 5,229.00 (6,257.69) -119.7%6411800 Taxes-Employer Payroll1,811.03 1,363.00 448.03 18,144.61 16,072.00 2,072.61 17,360.00 (784.61) -4.5%6411880 Wages-Hourly13,665.80 10,950.00 2,715.80 139,451.39 129,085.00 10,366.39 139,434.00 (17.39) 0.0%6411882 Wages-Overtime381.97 - 381.97 4,179.40 - 4,179.40 - (4,179.40) 0.0%Total-CBR-SALARIES & BENEFITS18,095.52 13,406.00 4,689.52 174,062.09 157,500.00 16,562.09 170,207.00 (3,855.09) -2.3%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- 50.00 (50.00) 827.50 1,800.00 (972.50) 1,850.00 `0.0%6413742 Supplies-Expendable453.49 500.00 (46.51) 5,704.55 6,250.00 (545.45) 6,750.00 1,045.45 15.5%6413748 Supplies-Fuel for Shuttle189.20 200.00 (10.80) 951.78 2,900.00 (1,948.22) 3,000.00 2,048.22 68.3%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) - 475.00 (475.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- 70.00 (70.00) 58.02 350.00 (291.98) 420.00 361.98 86.2%6413786 Supplies-Towels650.84 250.00 400.84 3,842.18 2,110.00 1,732.18 2,182.00 (1,660.18) -76.1%6413796 Supplies-Bottled Water107.75 50.00 57.75 15,741.08 10,950.00 4,791.08 11,000.00 (4,741.08) -43.1%Total-CBR-SUPPLIES & MATERIALS1,401.28 1,170.00 231.28 37,817.11 33,835.00 3,982.11 34,727.00 (4,112.61) -11.8%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment- 300.00 (300.00) 2,545.74 3,300.00 (754.26) 3,600.00 1,054.26 29.3%6415695 CBR-R&M-Cart Maintenance & Repair500.00 500.00 - 5,456.45 5,950.00 (493.55) 6,450.00 993.55 15.4%Total-CBR-REPAIRS & MAINTENANCE500.00 800.00 (300.00) 8,002.19 9,250.00 (1,247.81) 10,050.00 2,047.81 20.4%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen1,601.18 800.00 801.18 9,998.76 8,800.00 1,198.76 9,600.00 (398.76) -4.2%6419220 Freight/Delivery- - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous213.90 600.00 (386.10) 2,498.37 6,600.00 (4,101.63) 7,200.00 4,701.63 65.3%6419820 Uniforms2,365.15 1,500.00 865.15 5,245.59 5,000.00 245.59 5,200.00 (45.59) -0.9%Total-CBR-OTHER EXPENSES4,180.23 2,900.00 1,280.23 17,742.72 20,850.00 (3,107.28) 22,450.00 4,707.28 21.0%TOTAL-CARTS,BAGROOM & RANGE24,177.03 18,276.00 1,280.23 237,624.11 221,435.00 16,189.11 237,434.00 (1,212.61) -0.5%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp958.60 96.00 862.60 5,424.15 2,084.00 3,340.15 2,179.00 (3,245.15) -148.9%6431800 Taxes-Employer Payroll504.80 357.00 147.80 7,403.41 7,777.00 (373.59) 8,135.00 731.59 9.0%6431880 Wages-Hourly3,657.52 2,550.00 1,107.52 57,478.89 55,557.00 1,921.89 58,108.00 629.11 1.1%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS5,120.92 3,003.00 2,117.92 70,306.45 65,418.00 4,888.45 68,422.00 (1,884.45) -2.8%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 75.00 (75.00) 121.84 975.00 (853.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) - 550.00 (550.00) 600.00 600.00 100.0%6439820 Uniforms- 75.00 (75.00) 1,381.53 2,050.00 (668.47) 2,125.00 743.47 35.0%Total-CS-OTHER EXPENSES- 200.00 (200.00) 1,932.37 3,775.00 (1,842.63) 3,975.00 2,042.63 51.4%Total-COURSE SERVICES5,120.92 3,203.00 1,917.92 72,238.82 69,193.00 3,045.82 72,397.00 158.18 0.2%29,297.95 21,479.00 7,818.95 309,862.93 290,628.00 19,234.93 309,831.00 (3,097.06) -1.0%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementMay 2017Annual Budget7 MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable400.00 400.00 - 4,400.00 4,400.00 - 4,800.00 400.00 8.3%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 4,400.00 4,400.00 - 4,800.00 400.00 8.3%65-CH-UTILITIES6507836 Utilities-Natural Gas224.38 300.00 (75.62) 4,544.50 3,300.00 1,244.50 3,600.00 (944.50) -26.2%6507840 Utilities-Telephone1,078.21 1,150.00 (71.79) 12,822.07 12,650.00 172.07 13,800.00 977.93 7.1%6507842 Utilities-Water568.15 321.00 247.15 4,202.06 3,531.00 671.06 3,852.00 (350.06) -9.1%6507844 Utilities-Cable490.47 340.00 150.47 5,378.40 3,740.00 1,638.40 4,080.00 (1,298.40) -31.8%Total-CH-UTILITIES2,361.21 2,111.00 250.21 26,947.03 23,221.00 3,726.03 25,332.00 (1,615.03) -6.4%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning1,900.00 1,825.00 75.00 20,180.00 20,675.00 (495.00) 22,500.00 2,320.00 10.3%6509099 Contract Services-Security5,158.56 4,900.00 258.56 60,158.12 55,500.00 4,658.12 60,400.00 241.88 0.4%6509215 Flowers & Decorations- - - 573.12 1,500.00 (926.88) 1,900.00 1,326.88 69.8%6509490 Miscellaneous83.88 200.00 (116.12) 2,127.00 6,800.00 (4,673.00) 7,000.00 4,873.00 69.6%6509718 Safety Equipment & Training- 100.00 (100.00) 642.24 1,100.00 (457.76) 1,200.00 557.76 46.5%Total-CH-OTHER EXPENSES7,142.44 7,025.00 117.44 83,680.48 85,575.00 (1,894.52) 93,000.00 9,319.52 10.0%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures343.38 300.00 43.38 4,470.84 3,300.00 1,170.84 3,600.00 (870.84) -24.2%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 3,169.90 4,400.00 (1,230.10) 4,800.00 1,630.10 34.0%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) 1,365.16 4,400.00 (3,034.84) 4,800.00 3,434.84 71.6%Total-CH-REPAIRS & MAINTENANCE343.38 1,100.00 (756.62) 9,005.90 12,100.00 (3,094.10) 13,200.00 4,194.10 31.8%10,247.03 10,636.00 (388.97) 124,033.41 125,296.00 (1,262.59) 136,332.00 8,388.20 6.2%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementMay 2017Annual Budget8 MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group351.02 341.00 10.02 3,543.02 3,751.00 (207.98) 4,092.00 548.98 13.4%6601325 Insurance-Workers Comp115.00 94.00 21.00 1,044.50 1,034.00 10.50 1,129.00 84.50 7.5%6601720 Salaries1,904.96 2,508.00 (603.04) 25,410.79 27,588.00 (2,177.21) 30,096.00 4,685.21 15.6%6601800 Taxes-Employer Payroll145.20 351.00 (205.80) 2,655.45 3,861.00 (1,205.55) 4,213.00 1,557.55 37.0%Total-MKT-SALARIES & BENEFITS 2,516.18 3,294.00 (777.82) 32,653.76 36,234.00 (3,580.24) 39,530.00 6,876.24 17.4%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 64.17 100.00 (35.83) 1,441.78 1,100.00 341.78 1,200.00 (241.78) -20.1%6603768 Supplies-Printing & Stationery 1,941.43 125.00 1,816.43 7,160.37 4,300.00 2,860.37 4,425.00 (2,735.37) -61.8%2,005.60 225.00 1,780.60 8,602.15 5,400.00 3,202.15 5,625.00 (2,977.15) -52.9%66-MKT-UTILITIES6607840 Utilities-Telephone177.72 100.00 77.72 1,250.52 1,100.00 150.52 1,200.00 (50.52) -4.2%Total-MKT-UTILITIES 177.72 100.00 77.72 1,250.52 1,100.00 150.52 1,200.00 (50.52) -4.2%66-MKT-OTHER EXPENSES6609010 Advertising 10,175.65 7,912.00 2,263.65 172,536.61 164,610.00 7,926.61 178,987.00 6,450.39 3.6%6609040 Business Meals- 25.00 (25.00) - 275.00 (275.00) 300.00 300.00 100.0%6609080 Collateral Material- 1,000.00 (1,000.00) 9,928.22 4,500.00 5,428.22 5,500.00 (4,428.22) -80.5%6609102 Contract Services-Web Page99.00 150.00 (51.00) 990.00 1,650.00 (660.00) 1,800.00 810.00 45.0%6609490 Miscellaneous- 50.00 (50.00) 817.39 350.00 467.39 350.00 (467.39) -133.5%6609620 Postage52.03 50.00 2.03 82.11 550.00 (467.89) 600.00 517.89 86.3%6609630 Promotion- 50.00 (50.00) 97.09 650.00 (552.91) 700.00 602.91 86.1%6609633 Promotion-Community- 75.00 (75.00) 2,275.65 2,175.00 100.65 2,250.00 (25.65) -1.1%6609634 Promotion-Media/Vendor- - - 1,308.71 2,000.00 (691.29) 2,000.00 691.29 34.6%6609150 Dues and Subscriptions- - - 82.50 735.00 (652.50) 735.00 652.50 88.8%6609820 Uniforms416.35 - 416.35 1,172.59 600.00 572.59 600.00 (572.59) -95.4%Total-MKT-OTHER EXPENSES 10,743.03 9,312.00 1,431.03 189,290.87 178,095.00 11,195.87 193,822.00 4,531.13 2.3%15,442.53 12,931.00 2,511.53 231,797.30 220,829.00 10,968.30 240,177.00 8,379.70 3.5%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementMay 2017Annual Budget9 MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group 1,931.24 1,488.00 443.24 15,216.41 16,368.00 (1,151.59) 17,856.00 2,639.59 14.8%6701325 Insurance-Workers Comp479.28 662.00 (182.72) 5,466.24 7,056.00 (1,589.76) 7,717.00 2,250.76 29.2%6701720 Salaries14,486.40 15,050.00 (563.60) 154,083.80 159,550.00 (5,466.20) 177,996.00 23,912.20 13.4%6701800 Taxes-Employer Payroll1,332.19 2,471.00 (1,138.81) 16,212.32 26,341.00 (10,128.68) 28,812.00 12,599.68 43.7%6701880 Wages-Hourly2,447.97 2,600.00 (152.03) 29,153.67 28,750.00 403.67 27,800.00 (1,353.67) -4.9%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS 20,677.08 22,271.00 (1,593.92) 220,132.44 238,065.00 (17,932.56) 260,181.00 40,048.56 15.4%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 500.00 (500.00) 2,972.21 5,500.00 (2,527.79) 6,300.00 3,327.79 52.8%6703762 Supplies-Office43.08 150.00 (106.92) 564.90 1,650.00 (1,085.10) 1,800.00 1,235.10 68.6%6703768 Supplies-Printing & Stationery43.00 400.00 (357.00) 1,947.42 2,900.00 (952.58) 3,300.00 1,352.58 41.0%Total-G&A-SUPPLIES & MATERIALS86.08 1,050.00 (963.92) 5,484.53 10,050.00 (4,565.47) 11,400.00 5,915.47 51.9%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 6,724.20 1,800.00 4,924.20 1,900.00 (4,824.20) -253.9%Total-G&A-REPAIRS & MAINTENANCE - 100.00 (100.00) 6,724.20 1,800.00 4,924.20 1,900.00 (4,824.20) -253.9%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance 500.00 500.00 - 5,500.00 5,500.00 - 4,800.00 (700.00) -14.6%6709150 Dues & Subscriptions- 500.00 (500.00) 675.92 1,650.00 (974.08) 1,700.00 1,024.08 60.2%6709180 Employee Recruiting/Relocation- - - 737.56 1,400.00 (662.44) 1,400.00 662.44 47.3%6709197 Equipment Rental562.78 550.00 12.78 6,068.42 6,050.00 18.42 6,600.00 531.58 8.1%6709202 Fees-Bank116.75 90.00 26.75 1,381.84 990.00 391.84 1,080.00 (301.84) -27.9%6709208 Fees-Payroll Processing324.44 1,200.00 (875.56) 7,116.21 13,200.00 (6,083.79) 14,400.00 7,283.79 50.6%6709220 Freight/Delivery- 50.00 (50.00) 31.72 550.00 (518.28) 600.00 568.28 94.7%6709490 Miscellaneous35.00 100.00 (65.00) 3,708.41 6,500.00 (2,791.59) 1,200.00 (2,508.41) -209.0%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services218.60 75.00 143.60 1,277.93 825.00 452.93 900.00 (377.93) -42.0%6709625 Professional Fees751.00 850.00 (99.00) 11,999.51 9,350.00 2,649.51 10,200.00 (1,799.51) -17.6%6709636 Promotion/Entertainment- 100.00 (100.00) - 1,100.00 (1,100.00) 6,600.00 6,600.00 100.0%6709722 Seminars & Training29.95 200.00 (170.05) 1,225.66 2,200.00 (974.34) 2,400.00 1,174.34 48.9%6709810 Travel- 500.00 (500.00) - 900.00 (900.00) 1,100.00 1,100.00 100.0%6709820 Uniforms249.31 75.00 900.00 1,026.01 975.00 51.01 1,050.00 23.99 2.3%Total-G&A-OTHER EXPENSES 2,787.83 4,790.00 (1,276.48) 40,749.19 51,190.00 (10,440.81) 54,030.00 13,280.81 24.6%23,550.99 28,211.00 (4,660.01) 273,090.36 301,105.00 (28,014.64) 327,511.00 54,420.64 16.6%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementMay 2017Annual Budget10 MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts9,429.27 10,050.00 (620.73) 108,963.60 111,000.00 (2,036.40) 121,050.00 12,086.40 10.0%6800193 Equipment Leases-Maintenance 9,181.20 11,500.00 (2,318.80) 92,682.21 104,700.00 (12,017.79) 72,600.00 (20,082.21) -27.7%6800194 Equipment Leases-Trailer802.07 600.00 202.07 5,940.70 6,600.00 (659.30) 7,200.00 1,259.30 17.5%6800196 Equipment Leases-GPS4,770.00 4,700.00 70.00 51,450.00 51,700.00 (250.00) 56,400.00 4,950.00 8.8%6800197 Equipment Leases-Others1,289.38 1,950.00 (660.62) 19,794.26 18,250.00 1,544.26 13,800.00 (5,994.26) 0.0%25,471.92 28,800.00 (3,328.08) 278,830.77 292,250.00 (13,419.23) 271,050.00 (7,780.77) -2.9%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,652.80 8,653.00 (0.20) 95,180.80 95,183.00 (2.20) 99,840.00 4,659.20 4.7%6900210 FF&E Reserve1,395.16 5,718.00 (4,322.84) 57,079.59 56,603.00 476.59 63,985.00 6,905.41 10.8%6900800 Personal Property Taxes- - - 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 52,279.17 29,700.00 22,579.17 26,400.00 (25,879.17) -98.0%14,622.72 17,071.00 (2,448.28) 216,122.20 193,286.00 22,836.20 202,025.00 (14,097.20) -7.0%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementMay 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 5 4SalesPromotionGolf IndustryVIPCelebrityPGA Comp27 10 29 38 12Charity/Gift Certificate14916 20Rain/Wind Checks1142Club Staff51 22 38 78 62LQ HS Golf11 45 116 498118 95 199 189 84012