Loading...
11 May 2016 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2015 – May 2016 TABLE OF CONTENTS Summary Operating Income Expense 1 Statement of Fee Revenue 2 Variance Report 3 Course Maintenance Expense Statement 4 Outside Service Expense Statement 6 Clubhouse Expense Statement 7 Marketing Expense Statement 8 General & Administrative Expense Statement 9 Operating Leases & Miscellaneous Expense Statement 10 Complimentary Report 11 Annual BudgetAccount Description MayFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue231,368.24 285,924.00 (54,555.76) -19.1% 2,973,364.97 3,059,097.00 (85,732.03) 3,199,237.00 225,872.03 93%401000 Miscellaneous Golf Revenue29,018.00 30,020.00 (1,002.00) -3.3% 361,526.89 328,490.00 33,036.89 349,259.00 (12,267.89) 104%410000 Revenue-Golf Shop24,027.32 29,700.00 (5,672.68) -19.1% 233,280.86 263,888.00 (30,607.14) 278,585.00 45,304.14 84%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.08 - 0.08 12.48 - 12.48 - (12.48) 0%Total Income284,913.64 346,144.00 (61,230.36) -17.7% 3,579,685.20 3,662,975.00 (83,289.80) 3,839,081.00 259,395.80 93%Cost of Goods Sold510000 COS-Golf Shop12,066.10 16,623.00 (4,556.90) 27.4% 128,615.31 147,697.04 19,081.73 155,924.00 27,308.69 82%Total COS12,066.10 16,623.00 (4,556.90) 27.4% 128,615.31 147,697.04 19,081.73 155,924.00 27,308.69 82%Gross Profit272,847.54 329,521.00 (56,673.46) -17.2% 3,451,069.89 3,515,277.96 (64,208.07) 3,683,157.00 232,087.11 94%Expenses610000 Golf Pro Shop 21,605.08 21,498.00 107.08 -0.5% 184,322.65 187,286.00 (2,963.35) 204,827.00 20,504.35 90%630000 Course Maintenance138,979.72 117,124.00 21,855.72 -18.7% 1,600,128.25 1,593,070.00 7,058.25 1,712,795.00 112,666.75 93%633000 Maintenance Water & Energy24,136.31 24,272.00 (135.69) 0.6% 210,870.63 197,089.00 13,781.63 225,129.00 14,258.37 94%640000 Outside Services23,100.94 21,479.00 1,621.94 -7.6% 315,946.68 290,628.00 25,318.68 309,830.00 (6,116.68) 102%650000 Clubhouse10,539.51 10,636.00 (96.49) 0.9% 126,748.96 125,296.00 1,452.96 136,332.00 9,583.04 93%660000 Marketing9,933.13 13,031.00 (3,097.87) 23.8% 217,328.18 229,644.00 (12,315.82) 240,177.00 22,848.82 90%670000 General & Administrative22,125.58 28,111.00 (5,985.42) 21.3% 280,128.07 299,853.00 (19,724.93) 327,511.00 47,382.93 86%680000 Leases20,750.70 22,550.00 (1,799.30) 8.0% 245,956.00 248,500.00 (2,544.00) 271,050.00 25,094.00 91%690000 Miscellaneous Other Expense16,285.37 16,238.00 47.37 -0.3% 202,355.98 188,703.00 13,652.98 202,025.00 (330.98) 100%Total Expenses287,456.34 274,939.00 12,517.34 -4.6% 3,383,785.40 3,360,069.00 (23,716.40) 3,629,676.00 245,890.60 93%(14,608.80) 54,582.00 (69,190.80) -126.8%67,284.49 155,208.96 (87,924.47) 53,481.00 (13,803.49) 0%Rounds of Golf PlayedPaid Rounds Played4,189 4,950 (761) -15.4%43,640 44,025 (385) 41,100 (2,540) 106%Ave $ Per Paid Round Green Fee55.23 57.76 (2.53) -4.4%68.13 69.49 (1.35) 77.84 9.71 88%Ave $ Per Paid Round Merchandise5.74 6.00 (0.26) -4.4%5.35 5.99 (0.65) 6.78 1.43 79%Ave $ Per Paid Miscellaneous 6.93 6.06 0.86 14.2%8.28 7.46 0.82 8.50 0.21 97%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateMay 20161 Income MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees231,368.24 285,924.00 (54,555.76) 2,973,364.97 3,059,097.00 (85,732.03) 3,199,237.00 225,872.03 7.1%4010000 Rider Fee1,400.00 495.00 905.00 11,770.00 7,493.00 4,277.00 7,738.00 (4,032.00) -52.1%4040000 Club Rental2,395.00 2,475.00 (80.00) 21,411.00 22,013.00 (602.00) 23,238.00 1,827.00 7.9%4050000 Driving Range5,540.00 7,425.00 (1,885.00) 99,172.00 97,309.00 1,863.00 100,984.00 1,812.00 1.8%4060000 Handicap Fees4,001.00 - 4,001.00 4,001.00 2,500.00 1,501.00 2,500.00 (1,501.00) -60.0%4080000 GPS Advertising- - - - 2,600.00 (2,600.00) 2,600.00 2,600.00 100.0%4090000 Ball Retriever/Subcontract - - - 3,073.80 4,000.00 (926.20) 4,000.00 926.20 23.2%4091000 Golf Professional Rental Fee 8,032.00 4,000.00 4,032.00 46,824.09 37,000.00 9,824.09 37,000.00 (9,824.09) -26.6%4092000 Golf Lessons - - - - - - - - 0.0%4093000 Resident Card Issue7,650.00 15,625.00 (7,975.00) 175,275.00 155,575.00 19,700.00 171,200.00 (4,075.00) -2.4% Total Revenue Fees260,386.24 315,944.00 (55,557.76) 3,334,891.86 3,387,587.00 (52,695.14) 3,548,497.00 213,605.14 6.0%260,386.24 315,944.00 (55,557.76) 3,334,891.86 3,387,587.00 (52,695.14) 3,548,497.00 213,605.14 6.0%SilverRock ResortStatement of Fees RevenueMay 2016Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$231,368.24 $285,924.00 (54,555.76)Unfavorable: Due to projected closure of nine holes effective 5/15/16. We updated our website and media to reflect only providing 9 holes effective May 15, 2016. Rounds weredown by 760 due to projected closure.ActualBudgetVariance$24,027.32$29,700.00(5,672.68)Unfavorable: Due to projected closure with rounds down 15%.ExpensesActualBudgetVariance$138,979.72 $117,124.00 21,855.72Unfavorable: Due to timing of fertilizer and chemical invoices.ActualBudgetVariance$9,933.13 $13,031.00 (3,097.87)Favorable: Due to timing of advertisement invoices, also, we are currently tracking with our year to date budgeted amount.ActualBudgetVariance$22,125.58$28,111.00(5,985.42)Favorable: Due to reduced wages, administrative assistant on disabiltiy.Pro Shop Merchandise SalesGolf Green Fee Revenueprovided for those cost of sales percentage that are greater than 5%.Variance ExplanationMay 2016The explanation of variance from budget shown below provide details of variances by revenue and expensecategories of at least $1,000 that are greater than 10% of the budgeted amounts. Separate explanations areMarketingMaintenanceGeneral and Administrative3-20-133 Income MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous562.00 - 562.00 2,799.77 - 2,799.77 00 0%4100110 Sales Hard Goods6,957.46 10,395.00 (3,437.54) 77,328.22 92,362.00 (15,033.78) 97,505.00 20,176.78 20.7%4100112 Sales-Soft Goods20,818.00 19,305.00 1,513.00 184,043.50 171,526.00 12,517.50 181,080.00 (2,963.50) -1.6%5100639 GS-Discounts-Mdse (4,310.14) - (4,310.14) (30,890.63) - (30,890.63) - 30,890.63 0.0% Total Revenue Golf Shop24,027.32 29,700.00 (5,672.68) 233,280.86 263,888.00 (30,607.14) 278,585.00 48,103.91 17.3%COS 5100150 COS-GS-Hard Goods 3,092.76 6,029.10 (2,936.34) 39,711.98 53,569.96 (13,857.98) 56,552.90 16,840.92 29.8%5100151 COS-GS-Soft Goods 8,891.32 11,196.90 (2,305.58) 85,793.44 99,485.08 (13,691.64) 105,026.40 19,232.96 18.3%5100152 COS-GS-Purchase Disc- (861.00) 861.00 (130.20) (7,654.00) 7,523.80 (8,079.00) (7,948.80) 98.4%5100220 COS-GS-Freight Merch 82.02 258.00 (175.98) 3,240.09 2,296.00 944.09 2,424.00 (816.09) -33.7%Cost of Sales - Golf Shop12,066.10 16,623.00 (4,556.90) 128,615.31 147,697.04 (19,081.73) 155,924.30 27,308.99 17.5%Gross Profit11,961.22 13,077.00 (1,115.78) 104,665.55 116,190.96 (11,525.41) 122,660.70 20,794.92 17.0%COS % 50.2% 56.0% 5.8% 55.1% 56.0% 0.8% 53.1% 56.8% 107.0%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group2,479.03 2,387.00 92.03 21,866.94 25,234.00 (3,367.06) 27,621.00 5,754.06 20.8%6101325 Insurance-Workers Comp 602.04 461.00 141.04 6,321.82 4,594.00 1,727.82 5,042.00 (1,279.82) -25.4%6101720 Salaries5,002.50 3,950.00 1,052.50 45,067.35 43,450.00 1,617.35 45,000.00 (67.35) -0.1%6101800 Taxes-Employer Payroll 1,522.50 1,722.00 (199.50) 15,459.48 17,154.00 (1,694.52) 18,825.00 3,365.52 17.9%6101880 Wages-Hourly9,894.14 8,353.00 1,541.14 81,830.35 79,089.00 2,741.35 89,463.00 7,632.65 8.5%6101882 Wages-Overtime196.13 - 196.13 749.25 - 749.25 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 19,696.34 16,873.00 2,823.34 171,295.19 169,521.00 1,774.19 185,951.00 16,357.94 8.8%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - 273.99 - 273.99 - (273.99) 0.0%6103762 Supplies-Office237.45 250.00 (12.55) 2,118.89 2,750.00 (631.11) 3,000.00 881.11 29.4%6109220 Freight & Delivery69.64 - 69.64 466.38 75.00 391.38 75.00 (391.38) -521.8%6109490 Miscellaneous463.73 500.00 (36.27) 5,045.97 5,500.00 (454.03) 6,000.00 954.03 15.9%6109150 Dues and Subscriptions 1,118.00 2,300.00 (1,182.00) 1,220.30 2,300.00 (1,079.70) 2,300.00 1,079.70 46.9%6109500 ProShop-Over/Short19.92 - 19.92 208.61 - 208.61 - (208.61) 0.0%6109722 Seminars/Training- 1,250.00 (1,250.00) - 3,655.00 (3,655.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- 15.00 (15.00) - 75.00 (75.00) 90.00 90.00 100.0%6109820 Uniforms- 200.00 (200.00) 2,134.92 2,200.00 (65.08) 2,400.00 265.08 11.0%6117840 Telephones- 110.00 (110.00) 1,558.40 1,210.00 348.40 1,320.00 (238.40) -18.1%1,908.74 4,625.00 (2,716.26) 13,027.46 17,765.00 (4,737.54) 18,875.00 5,847.54 31.0%21,605.08 21,498.00 107.08 184,322.65 187,286.00 (2,963.35) 204,826.00 22,205.48 10.8%Net Income(9,643.86) (8,421.00) (1,222.86) (79,657.10) (71,095.04) (8,562.06) (82,165.30) (1,410.56) 1.7%SilverRock ResortGolf Shop Income StatementMay 2016Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group9,028.27 8,990.00 38.27 93,815.20 98,890.00 (5,074.80) 107,880.00 14,064.80 13.0%6311325 Insurance-Workers Comp2,835.73 2,065.00 770.73 28,235.47 22,657.00 5,578.47 24,794.00 (3,441.47) -13.9%6311720 Salaries13,220.80 11,900.00 1,320.80 131,334.10 130,900.00 434.10 142,017.20 10,683.10 7.5%6311800 Taxes-Employer Payroll6,702.23 7,709.00 (1,006.77) 66,611.04 85,192.00 (18,580.96) 93,302.00 26,690.96 28.6%6311880 Wages-Hourly41,513.56 43,161.00 (1,647.44) 479,838.06 464,537.00 15,301.06 508,481.80 28,643.74 5.6%6311882 Wages-Overtime- - - 12,421.76 13,076.00 (654.24) 15,945.00 3,523.24 22.1%Total-CM-SALARIES & BENEFITS73,300.59 73,825.00 (524.41) 812,255.63 815,252.00 (2,996.37) 892,420.00 80,164.37 9.0%63-CM-SUPPLIES & MATERIALS6313734 Chemicals6,963.06 900.00 6,063.06 39,644.09 32,600.00 7,044.09 34,600.00 (5,044.09) -14.6%6313744 Fertilizer11,227.52 5,000.00 6,227.52 126,324.27 107,500.00 18,824.27 112,500.00 (13,824.27) -12.3%6313745 Herbicides1,963.74 - 1,963.74 21,331.26 17,000.00 4,331.26 17,000.00 (4,331.26) -25.5%6313746 Flowers/Plants251.86 - 251.86 1,376.30 3,050.00 (1,673.70) 3,050.00 1,673.70 54.9%6313748 Fuel-Gasoline2,266.09 3,100.00 (833.91) 36,917.54 51,920.00 (15,002.46) 55,020.00 18,102.46 32.9%6313750 Golf Course Accessories- 100.00 (100.00) 11,425.14 12,900.00 (1,474.86) 13,000.00 1,574.86 12.1%6313756 POA Control- - - 6,757.37 7,000.00 (242.63) 7,000.00 242.63 3.5%6313758 Miscellaneous Supp1,035.95 100.00 935.95 8,118.59 4,250.00 3,868.59 4,350.00 (3,768.59) -86.6%6313762 Supplies-Office76.91 - 76.91 76.91 - 76.91 - (76.91) 0.0%6313774 Sand2,692.18 100.00 2,592.18 4,571.63 13,360.00 (8,788.37) 13,460.00 8,888.37 66.0%6313776 Seed- 350.00 (350.00) 132,015.98 125,550.00 6,465.98 125,900.00 (6,115.98) -4.9%6313778 Small Tools & Non-Capital Equip284.48 100.00 184.48 4,328.33 4,900.00 (571.67) 5,000.00 671.67 13.4%6313780 Sod- 500.00 (500.00) 5,597.26 10,250.00 (4,652.74) 10,450.00 4,852.74 46.4%6313782 Topdressing- 1,300.00 (1,300.00) 7,213.94 9,300.00 (2,086.06) 10,600.00 3,386.06 31.9%Total-CM-SUPPLIES & MATERIALS26,761.79 11,550.00 15,211.79 405,698.61 399,580.00 6,118.61 411,930.00 6,231.39 1.5%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint2,830.00 2,600.00 230.00 34,481.50 28,600.00 5,881.50 31,200.00 (3,281.50) -10.5%6315685 CM-R&M-Bldngs & Othr Structures 255.88 250.00 5.88 3,334.34 5,300.00 (1,965.66) 5,550.00 2,215.66 39.9%6315690 CM-R&M-Equipment3,135.97 2,500.00 635.97 41,578.11 38,000.00 3,578.11 40,000.00 (1,578.11) -3.9%6315692 CM-R&M-Irrigation System6,065.56 1,000.00 5,065.56 21,415.14 18,050.00 3,365.14 19,050.00 (2,365.14) -12.4%6315696 CM-R&M-Pumps1,178.73 500.00 678.73 12,303.59 10,500.00 1,803.59 10,500.00 (1,803.59) -17.2%6315815 CM-R&M-Trees-Pruning Etc3,276.12 - 3,276.12 12,832.07 12,050.00 782.07 12,050.00 (782.07) -6.5%Total-CM-REPAIRS & MAINTENANCE16,742.26 6,850.00 9,892.26 125,944.75 112,500.00 13,444.75 118,350.00 (7,594.75) -6.4%6317836 Utilities-Natural Gas/LPG 12.00 15.00 (3.00) 212.56 165.00 47.56 180.00 (32.56) 0.0%6317840 Telephones503.28 850.00 (346.72) 10,447.12 9,350.00 1,097.12 10,200.00 (247.12) -2.4%Total-CM-UTILITIES515.28 865.00 (349.72) 10,659.68 9,515.00 1,144.68 10,380.00 (279.68) -2.7%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 500.00 (100.00) 5,300.00 5,500.00 (200.00) 6,000.00 700.00 11.7%6319100 Contract Svcs-Soil/Tissue Test- 2,000.00 (2,000.00) 2,000.00 4,000.00 (2,000.00) 4,000.00 2,000.00 50.0%6319102 Contract Svcs-Trash Removal1,041.00 524.00 517.00 8,710.07 5,764.00 2,946.07 6,288.00 (2,422.07) -38.5%6319150 Dues & Subscriptions210.00 - 210.00 1,380.00 440.00 940.00 540.00 (840.00) -155.6%6319170 Employee Education- 50.00 (50.00) 1,650.99 1,500.00 150.99 1,550.00 (100.99) -6.5%6319197 Equipment Rental- 200.00 (200.00) 911.44 3,300.00 (2,388.56) 3,400.00 2,488.56 73.2%6319206 Licenses & Permits- - - 2,307.89 4,180.00 (1,872.11) 4,180.00 1,872.11 44.8%6319490 Miscellaneous74.11 100.00 (25.89) 802.64 1,100.00 (297.36) 1,200.00 397.36 33.1%6319718 Safety Equipment & Training196.06 100.00 96.06 4,509.64 3,750.00 759.64 3,850.00 (659.64) -17.1%6319822 Uniforms810.21 920.00 (109.79) 11,348.13 10,120.00 1,228.13 11,040.00 (308.13) -2.8%Total-CM-OTHER EXPENSES2,731.38 4,394.00 (1,662.62) 38,920.80 39,654.00 (733.20) 42,048.00 3,127.20 7.4%SilverRock ResortCourse Maintenance Expense StatementMay 2016Annual BudgetMonth to DateYear to Date5 AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,748.50 2,728.00 20.50 27,016.35 30,008.00 (2,991.65) 32,736.00 5,719.65 17.5%6321325 Insurance-Workers Comp651.02 519.00 132.02 5,024.01 5,626.00 (601.99) 6,171.00 1,146.99 18.6%6321800 Taxes-Employer Payroll940.62 1,938.00 (997.38) 15,132.07 21,252.00 (6,119.93) 23,334.00 8,201.93 35.2%6321880 Wages-Hourly14,295.20 13,840.00 455.20 152,830.33 146,480.00 6,350.33 160,320.00 7,489.67 4.7%6321882 Wages-Overtime- - - 4,181.01 5,313.00 (1,131.99) 6,351.00 2,169.99 34.2%Total-CM-LM-SALARIES & BENEFITS18,635.34 19,025.00 (389.66) 204,183.77 208,679.00 (4,495.23) 228,912.00 24,728.23 10.8%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 75.00 (75.00) - 950.00 (950.00) 1,025.00 1,025.00 100.0%6323788 Uniforms293.08 290.00 3.08 2,465.01 3,190.00 (724.99) 3,480.00 1,014.99 29.2%Total-CM-LM-SUPPLIES & MATERIALS293.08 365.00 (71.92) 2,465.01 4,140.00 (1,674.99) 4,505.00 2,039.99 45.3%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 250.00 (250.00) - 3,750.00 (3,750.00) 4,250.00 4,250.00 100.0%Total-CM-LM-REPAIRS & MAINTENANCE- 250.00 (250.00) - 3,750.00 (3,750.00) 4,250.00 4,250.00 100.0%138,979.72 117,124.00 21,855.72 1,600,128.25 1,593,070.00 7,058.25 1,712,795.00 112,666.75 6.6% AprilFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 20,305.25 21,017.00 (711.75) 168,414.72 158,261.00 10,153.72 179,791.00 11,376.28 6.3%6337842 Utilities-Water3,831.06 3,255.00 576.06 42,455.91 38,828.00 3,627.91 45,338.00 2,882.09 6.4%24,136.31 24,272.00 (135.69) 210,870.63 197,089.00 13,781.63 225,129.00 14,258.37 6.3%Silverrock ResortCourse Maintenance Water & EnergyMay 2016Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementMay 2016Silverrock ResortAnnual BudgetMonth to DateYear to Date6 MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 682.00 (682.00) - 7,502.00 (7,502.00) 8,184.00 8,184.00 100.0%6411325 Insurance-Workers Comp570.08 411.00 159.08 7,494.44 4,841.00 2,653.44 5,229.00 (2,265.44) -43.3%6411800 Taxes-Employer Payroll1,805.64 1,363.00 442.64 19,353.49 16,072.00 3,281.49 17,360.00 (1,993.49) -11.5%6411880 Wages-Hourly11,597.00 10,950.00 647.00 144,102.62 129,085.00 15,017.62 139,434.00 (4,668.62) -3.3%6411882 Wages-Overtime551.25 - 551.25 3,427.79 - 3,427.79 - (3,427.79) 0.0%Total-CBR-SALARIES & BENEFITS14,523.97 13,406.00 1,117.97 174,378.34 157,500.00 16,878.34 170,207.00 (4,171.34) -2.5%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts84.80 50.00 34.80 3,397.88 1,800.00 1,597.88 1,850.00 `0.0%6413742 Supplies-Expendable- 500.00 (500.00) 6,143.76 6,250.00 (106.24) 6,750.00 606.24 9.0%6413748 Supplies-Fuel for Shuttle- 200.00 (200.00) - 2,900.00 (2,900.00) 3,000.00 3,000.00 100.0%6413752 Supplies-Range Balls- - - 9,000.00 9,000.00 - 9,000.00 - 0.0%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) 94.87 350.00 (255.13) 420.00 325.13 77.4%6413786 Supplies-Towels 1,698.29 250.00 1,448.29 4,365.39 2,110.00 2,255.39 2,182.00 (2,183.39) -100.1%6413796 Supplies-Bottled Water- 50.00 (50.00) 12,224.40 10,950.00 1,274.40 11,000.00 (1,224.40) -11.1%Total-CBR-SUPPLIES & MATERIALS1,783.09 1,170.00 613.09 35,226.30 33,835.00 1,391.30 34,727.00 1,048.58 3.0%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment 244.03 300.00 (55.97) 4,230.41 3,300.00 930.41 3,600.00 (630.41) -17.5%6415695 CBR-R&M-Cart Maintenance & Repair- 500.00 (500.00) 10,286.68 5,950.00 4,336.68 6,450.00 (3,836.68) -59.5%Total-CBR-REPAIRS & MAINTENANCE244.03 800.00 (555.97) 14,517.09 9,250.00 5,267.09 10,050.00 (4,467.09) -44.4%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen856.84 800.00 56.84 6,544.62 8,800.00 (2,255.38) 9,600.00 3,055.38 31.8%6419220 Freight/Delivery- - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous- 600.00 (600.00) 4,096.12 6,600.00 (2,503.88) 7,200.00 3,103.88 43.1%6419820 Uniforms 1,379.42 1,500.00 (120.58) 4,296.75 5,000.00 (703.25) 5,200.00 903.25 17.4%Total-CBR-OTHER EXPENSES2,236.26 2,900.00 (663.74) 14,937.49 20,850.00 (5,912.51) 22,450.00 7,512.51 33.5%TOTAL-CARTS,BAGROOM & RANGE18,787.35 18,276.00 (663.74) 239,059.22 221,435.00 17,624.22 237,434.00 (77.34) 0.0%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp302.04 96.00 206.04 3,717.20 2,084.00 1,633.20 2,179.00 (1,538.20) -70.6%6431800 Taxes-Employer Payroll949.41 357.00 592.41 7,949.92 7,777.00 172.92 8,135.00 185.08 2.3%6431880 Wages-Hourly2,192.50 2,550.00 (357.50) 60,660.12 55,557.00 5,103.12 58,108.00 (2,552.12) -4.4%6431882 Wages-Overtime- - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS3,443.95 3,003.00 440.95 72,327.24 65,418.00 6,909.24 68,422.00 (3,905.24) -5.7%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 75.00 (75.00) 906.72 975.00 (68.28) 1,050.00 143.28 13.6%6439490 Miscellaneous- - - 1,031.60 200.00 831.60 200.00 (831.60) -415.8%6439718 Safety Equipment & Training- 50.00 (50.00) 50.00 550.00 (500.00) 600.00 550.00 91.7%6439820 Uniforms 869.64 75.00 794.64 2,571.90 2,050.00 521.90 2,125.00 (446.90) -21.0%Total-CS-OTHER EXPENSES869.64 200.00 669.64 4,560.22 3,775.00 785.22 3,975.00 (585.22) -14.7%Total-COURSE SERVICES4,313.59 3,203.00 1,110.59 76,887.46 69,193.00 7,694.46 72,397.00 (4,490.46) -6.2%23,100.94 21,479.00 1,621.94 315,946.68 290,628.00 25,318.68 309,831.00 (3,982.58) -1.3%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementMay 2016Annual Budget7 MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 4,405.00 4,400.00 5.00 4,800.00 395.00 8.2%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 4,405.00 4,400.00 5.00 4,800.00 395.00 8.2%65-CH-UTILITIES6507836 Utilities-Natural Gas471.61 300.00 171.61 4,670.06 3,300.00 1,370.06 3,600.00 (1,070.06) -29.7%6507840 Utilities-Telephone1,134.57 1,150.00 (15.43) 10,861.87 12,650.00 (1,788.13) 13,800.00 2,938.13 21.3%6507842 Utilities-Water430.05 321.00 109.05 8,463.94 3,531.00 4,932.94 3,852.00 (4,611.94) -119.7%6507844 Utilities-Cable - 340.00 (340.00) 5,300.31 3,740.00 1,560.31 4,080.00 (1,220.31) -29.9%Total-CH-UTILITIES2,036.23 2,111.00 (74.77) 29,296.18 23,221.00 6,075.18 25,332.00 (3,964.18) -15.6%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 1,825.00 1,825.00 - 20,347.00 20,675.00 (328.00) 22,500.00 2,153.00 9.6%6509099 Contract Services-Security5,092.08 4,900.00 192.08 57,776.48 55,500.00 2,276.48 60,400.00 2,623.52 4.3%6509215 Flowers & Decorations- - - 586.16 1,500.00 (913.84) 1,900.00 1,313.84 69.1%6509490 Miscellaneous- 200.00 (200.00) 2,843.62 6,800.00 (3,956.38) 7,000.00 4,156.38 59.4%6509718 Safety Equipment & Training- 100.00 (100.00) 320.32 1,100.00 (779.68) 1,200.00 879.68 73.3%Total-CH-OTHER EXPENSES6,917.08 7,025.00 (107.92) 81,873.58 85,575.00 (3,701.42) 93,000.00 11,126.42 12.0%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures- 300.00 (300.00) 3,708.30 3,300.00 408.30 3,600.00 (108.30) -3.0%6515686 CH-R&M-Restaurant Repairs395.00 400.00 (5.00) 3,939.97 4,400.00 (460.03) 4,800.00 860.03 17.9%6515690 CH-R&M-Equipment Repair791.20 400.00 391.20 3,525.93 4,400.00 (874.07) 4,800.00 1,274.07 26.5%Total-CH-REPAIRS & MAINTENANCE1,186.20 1,100.00 86.20 11,174.20 12,100.00 (925.80) 13,200.00 2,025.80 15.3%10,539.51 10,636.00 (96.49) 126,748.96 125,296.00 1,452.96 136,332.00 4,051.60 3.0%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementMay 2016Annual Budget8 MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group - 341.00 (341.00) 3,075.80 3,751.00 (675.20) 4,092.00 1,016.20 24.8%6601325 Insurance-Workers Comp94.00 94.00 - 857.20 1,034.00 (176.80) 1,129.00 271.80 24.1%6601720 Salaries1,904.96 2,508.00 (603.04) 22,658.48 27,588.00 (4,929.52) 30,096.00 7,437.52 24.7%6601800 Taxes-Employer Payroll145.20 351.00 (205.80) 2,530.52 3,861.00 (1,330.48) 4,213.00 1,682.48 39.9%Total-MKT-SALARIES & BENEFITS2,144.16 3,294.00 (1,149.84) 29,122.00 36,234.00 (7,112.00) 39,530.00 10,408.00 26.3%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 197.97 100.00 97.97 856.98 1,100.00 (243.02) 1,200.00 343.02 28.6%6603768 Supplies-Printing & Stationery- 125.00 (125.00) 4,949.77 4,300.00 649.77 4,425.00 (524.77) -11.9%197.97 225.00 (27.03) 5,806.75 5,400.00 406.75 5,625.00 (181.75) -3.2%66-MKT-UTILITIES6607840 Utilities-Telephone 100.00 100.00 - 690.48 1,100.00 (409.52) 1,200.00 509.52 42.5%Total-MKT-UTILITIES100.00 100.00 - 690.48 1,100.00 (409.52) 1,200.00 509.52 42.5%66-MKT-OTHER EXPENSES6609010 Advertising6,439.67 8,012.00 (1,572.33) 169,835.76 173,425.00 (3,589.24) 178,987.00 9,151.24 5.1%6609040 Business Meals- - - - - - 300.00 300.00 100.0%6609080 Collateral Material- 1,000.00 (1,000.00) 6,596.48 4,500.00 2,096.48 5,500.00 (1,096.48) -19.9%6609102 Contract Services-Web Page- 150.00 (150.00) 1,386.00 1,650.00 (264.00) 1,800.00 414.00 23.0%6609490 Miscellaneous- 50.00 (50.00) - 350.00 (350.00) 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) 158.97 550.00 (391.03) 600.00 441.03 73.5%6609630 Promotion- 25.00 (25.00) - 275.00 (275.00) 700.00 700.00 100.0%6609633 Promotion-Community1,051.33 125.00 926.33 1,774.69 2,825.00 (1,050.31) 2,250.00 475.31 21.1%6609634 Promotion-Media/Vendor- - - 1,346.62 2,000.00 (653.38) 2,000.00 653.38 32.7%6609150 Dues and Subscriptions- - - 110.00 735.00 (625.00) 735.00 625.00 85.0%6609820 Uniforms- - - 500.43 600.00 (99.57) 600.00 99.57 16.6%Total-MKT-OTHER EXPENSES7,491.00 9,412.00 (1,921.00) 181,708.95 186,910.00 (5,201.05) 193,822.00 12,113.05 6.2%9,933.13 13,031.00 (3,097.87) 217,328.18 229,644.00 (12,315.82) 240,177.00 22,848.82 9.5%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementMay 2016Annual Budget9 MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,080.38 1,488.00 (407.62) 13,443.23 16,368.00 (2,924.77) 17,856.00 4,412.77 24.7%6701325 Insurance-Workers Comp987.88 662.00 325.88 6,723.42 7,056.00 (332.58) 7,717.00 993.58 12.9%6701720 Salaries12,284.45 15,050.00 (2,765.55) 155,665.20 159,550.00 (3,884.80) 177,996.00 22,330.80 12.5%6701800 Taxes-Employer Payroll1,084.71 2,471.00 (1,386.29) 19,661.07 26,341.00 (6,679.93) 28,812.00 9,150.93 31.8%6701880 Wages-Hourly1,080.00 2,600.00 (1,520.00) 29,721.10 28,598.00 1,123.10 27,800.00 (1,921.10) -6.9%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS16,517.42 22,271.00 (5,753.58) 225,214.02 237,913.00 (12,698.98) 260,181.00 34,966.98 13.4%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer391.84 500.00 (108.16) 1,756.40 5,500.00 (3,743.60) 6,300.00 4,543.60 72.1%6703762 Supplies-Office- 150.00 (150.00) 1,382.24 1,650.00 (267.76) 1,800.00 417.76 23.2%6703768 Supplies-Printing & Stationery487.13 400.00 87.13 2,535.64 2,900.00 (364.36) 3,300.00 764.36 23.2%Total-G&A-SUPPLIES & MATERIALS878.97 1,050.00 (171.03) 5,674.28 10,050.00 (4,375.72) 11,400.00 5,725.72 50.2%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment 92.50 100.00 (7.50) 1,400.00 1,800.00 (400.00) 1,900.00 500.00 26.3%Total-G&A-REPAIRS & MAINTENANCE92.50 100.00 (7.50) 1,400.00 1,800.00 (400.00) 1,900.00 500.00 26.3%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 400.00 100.00 4,500.00 4,400.00 100.00 4,800.00 300.00 6.3%6709150 Dues & Subscriptions- 500.00 (500.00) 419.00 1,650.00 (1,231.00) 1,700.00 1,281.00 75.4%6709180 Employee Recruiting/Relocation30.00 - 30.00 1,377.78 1,400.00 (22.22) 1,400.00 22.22 1.6%6709197 Equipment Rental1,015.43 550.00 465.43 7,527.60 6,050.00 1,477.60 6,600.00 (927.60) -14.1%6709202 Fees-Bank87.89 90.00 (2.11) 1,355.22 990.00 365.22 1,080.00 (275.22) -25.5%6709208 Fees-Payroll Processing1,083.93 1,200.00 (116.07) 13,749.06 13,200.00 549.06 14,400.00 650.94 4.5%6709220 Freight/Delivery- 50.00 (50.00) 10.68 550.00 (539.32) 600.00 589.32 98.2%6709490 Miscellaneous102.50 100.00 2.50 4,325.70 6,500.00 (2,174.30) 1,200.00 (3,125.70) -260.5%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services- 75.00 (75.00) 1,080.81 825.00 255.81 900.00 (180.81) -20.1%6709625 Professional Fees1,257.94 850.00 407.94 10,540.72 9,350.00 1,190.72 10,200.00 (340.72) -3.3%6709636 Promotion/Entertainment- 100.00 (100.00) - 1,100.00 (1,100.00) 6,600.00 6,600.00 100.0%6709722 Seminars & Training559.00 200.00 359.00 1,393.70 2,200.00 (806.30) 2,400.00 1,006.30 41.9%6709810 Travel- 500.00 (500.00) - 900.00 (900.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 900.00 719.50 975.00 (255.50) 1,050.00 330.50 31.5%Total-G&A-OTHER EXPENSES4,636.69 4,690.00 921.69 47,839.77 50,090.00 (2,250.23) 54,030.00 6,190.23 11.5%22,125.58 28,111.00 (5,985.42) 280,128.07 299,853.00 (19,724.93) 327,511.00 47,382.93 14.5%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementMay 2016Annual Budget10 MayFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts9,534.37 10,050.00 (515.63) 113,168.87 110,550.00 2,618.87 121,050.00 7,881.13 6.5%6800193 Equipment Leases-Maintenance 5,571.50 6,050.00 (478.50) 61,286.50 67,000.00 (5,713.50) 72,600.00 11,313.50 15.6%6800194 Equipment Leases-Trailer521.94 600.00 (78.06) 5,446.70 6,600.00 (1,153.30) 7,200.00 1,753.30 24.4%6800196 Equipment Leases-GPS4,500.00 4,700.00 (200.00) 49,500.00 51,700.00 (2,200.00) 56,400.00 6,900.00 12.2%6800197 Equipment Leases-Others622.89 1,150.00 (527.11) 16,553.93 12,650.00 3,903.93 13,800.00 (2,753.93) 0.0%20,750.70 22,550.00 (1,799.30) 245,956.00 248,500.00 (2,544.00) 271,050.00 25,094.00 9.3%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,320.00 8,320.00 - 91,520.00 91,520.00 - 99,840.00 8,320.00 8.3%6900210 FF&E Reserve4,554.12 5,718.00 (1,163.88) 59,394.06 61,183.00 (1,788.94) 63,985.00 4,590.94 7.2%6900800 Personal Property Taxes- - - 12,117.83 11,800.00 317.83 11,800.00 (317.83) -2.7%6900323 Insurance-Commercial3,411.25 2,200.00 1,211.25 39,324.09 24,200.00 15,124.09 26,400.00 (12,924.09) -49.0%16,285.37 16,238.00 47.37 202,355.98 188,703.00 13,652.98 202,025.00 (330.98) -0.2%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementMay 2016Annual BudgetMonth to DateYear to Date11 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2015‐20162015 2015 2015 2015 2015 2015Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia24414SalesPromotion4Golf IndustryVIPCelebrityPGA Comp383738112366Charity/Gift Certificate72626Rain/Wind Checks12129Club Staff956280652111LQ HS Golf2117182530168 121 14319112 2602016 2016 2016 2016 2016 2016Comp CategoryJanuaryFebruaryMarchAprilMayJuneMedia42249SalesPromotion4Golf IndustryVIPCelebrityPGA Comp4342444658Charity/Gift Certificate4261223Rain/Wind Checks113412Club Staff77668351112LQ HS Golf2624178 11061159 137 316 227 275012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report‐2015‐2016May 2016 Date Time DescriptionCategoryPlayers5/2/2016 11:00:00 AM Al Shore - Golfweek Rater Media 25/8/2016 12:30:00 PM John White - KESQ News Anchor Media 45/21/20165 7:23:00 AM Jason Kosky - Locale Magazine Media 313