Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
12 June 2017 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2016 – June 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 JuneFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue24,314.10 140,140.00 (115,825.90) -82.7% 2,878,292.64 2,970,237.00 (91,944.36) 3,199,237.00 320,944.36 90%401000 Miscellaneous Golf Revenue13,119.00 20,770.00 (7,651.00) -36.8% 337,471.67 351,268.00 (13,796.33) 349,259.00 11,787.33 97%410000 Revenue-Golf Shop2,544.00 14,700.00 (12,156.00) -82.7% 217,864.27 262,015.00 (44,150.73) 278,585.00 60,720.73 78%420000 Revenue-F&B Concession500.00 500.00 - 0.0% 12,000.00 12,000.00 - 12,000.00 - 100%890000 Interest Income0.04 - 0.04 0.55 - 0.55 - (0.55) 0%Total Income40,477.14 176,110.00 (135,632.86) -77.0% 3,445,629.13 3,595,520.00 (149,890.87) 3,839,081.00 393,451.87 90%Cost of Goods Sold510000 COS-Golf Shop1,547.13 8,228.00 (6,680.87) 81.2% 123,047.14 146,649.70 23,602.56 155,924.00 32,876.86 79%Total COS1,547.13 8,228.00 (6,680.87) 81.2% 123,047.14 146,649.70 23,602.56 155,924.00 32,876.86 79%Gross Profit38,930.01 167,882.00 (128,951.99) -76.8% 3,322,581.99 3,448,870.30 (126,288.31) 3,683,157.00 360,575.01 90%Expenses610000 Golf Pro Shop 17,941.83 17,536.00 405.83 -2.3% 192,308.72 200,768.00 (8,459.28) 204,827.00 12,518.28 94%630000 Course Maintenance120,658.38 119,725.00 933.38 -0.8% 1,619,004.01 1,691,933.00 (72,928.99) 1,712,795.00 93,790.99 95%633000 Maintenance Water & Energy22,380.30 30,969.00 (8,588.70) 27.7% 206,344.12 249,838.00 (43,493.88) 225,129.00 18,784.88 92%640000 Outside Services24,847.63 19,204.00 5,643.63 -29.4% 334,710.56 309,832.00 24,878.56 309,830.00 (24,880.56) 108%650000 Clubhouse12,166.64 11,036.00 1,130.64 -10.2% 136,200.05 136,332.00 (131.95) 136,332.00 131.95 100%660000 Marketing15,665.44 10,346.00 5,319.44 -51.4% 247,462.74 231,175.00 16,287.74 240,177.00 (7,285.74) 103%670000 General & Administrative25,032.27 27,761.00 (2,728.73) 9.8% 298,122.63 328,866.00 (30,743.37) 327,511.00 29,388.37 91%680000 Leases25,987.36 28,800.00 (2,812.64) 9.8% 304,818.13 321,050.00 (16,231.87) 271,050.00 (33,768.13) 112%690000 Miscellaneous Other Expense13,778.24 14,156.00 (377.76) 2.7% 229,900.44 207,442.00 22,458.44 202,025.00 (27,875.44) 114%Total Expenses278,458.09 279,533.00 (1,074.91) 0.4% 3,568,871.40 3,677,236.00 108,364.60 3,629,676.00 60,804.60 98%(239,528.08) (111,651.00) (127,877.08) -114.5%(246,289.41) (228,365.70) (17,923.71) 53,481.00 299,770.41 0%Rounds of Golf PlayedPaid Rounds Played871 2,450 (1,579) -64.4%43,085 42,150 935 42,150 (935) 102%Ave $ Per Paid Round Green Fee27.82 57.20 (29.38) -51.4%66.80 70.47 (3.66) 75.90 9.10 88%Ave $ Per Paid Round Merchandise2.92 6.00 (3.08) -51.3%5.06 6.22 (1.16) 6.61 1.55 77%Ave $ Per Paid Miscellaneous 15.06 8.48 6.58 77.7%7.83 8.33 (0.50) 8.29 0.45 95%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateJune 20171 Income JuneFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees24,314.10 140,140.00 (115,825.90) 2,878,292.64 2,970,237.00 (91,944.36) 3,199,237.00 320,944.36 10.0%4010000 Rider Fee50.00 245.00 (195.00) 8,532.50 7,306.00 1,226.50 7,738.00 (794.50) -10.3%4040000 Club Rental150.00 1,225.00 (1,075.00) 26,450.00 21,079.00 5,371.00 23,238.00 (3,212.00) -13.8%4050000 Driving Range2,260.00 3,675.00 (1,415.00) 94,374.00 111,483.00 (17,109.00) 100,984.00 6,610.00 6.5%4060000 Handicap Fees2,397.00 - 2,397.00 2,430.12 2,500.00 (69.88) 2,500.00 69.88 2.8%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 Fee 4,632.00 - 4,632.00 50,774.75 37,000.00 13,774.75 37,000.00 (13,774.75) -37.2%4092000 Golf Lessons - - - - - - - - 0.0%4093000 Resident Card Issue3,630.00 15,625.00 (11,995.00) 152,265.00 165,300.00 (13,035.00) 171,200.00 18,935.00 11.1% Total Revenue Fees37,433.10 160,910.00 (123,476.90) 3,215,764.31 3,321,505.00 (105,740.69) 3,548,497.00 332,732.69 9.4%37,433.10 160,910.00 (123,476.90) 3,215,764.31 3,321,505.00 (105,740.69) 3,548,497.00 332,732.69 9.4%SilverRock ResortStatement of Fees RevenueJune 2017Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$24,314.10$140,140.00(115,825.90)Unfavorable: Rounds down 1579 to budget due to closure of the back nine holes.ActualBudgetVariance$13,119.00$20,770.00(14,840.00)Unfavorable: Rounds down 1579 to budget due to closure of the back nine holes.ActualBudgetVariance$2,544.00$14,700.00(12,156.00)Unfavorable: Rounds down 1579 to budget due to closure of the back nine holes.ExpensesActualBudgetVariance$22,380.30$30,969.00(8,588.70)Favorable: Due to reduced runtime of the water features and the closure of the back none for construction.ActualBudgetVariance$24,847.63$19,204.005,643.63Unfavorable: Due to increased cost of bottled water and timing of invoice.ActualBudgetVariance$15,665.44$10,346.005,319.44Unfavorable: Due to timing of advertising invoices.ActualBudgetVariance$12,166.64$11,036.001,130.64Unfavorable: Due to additional expenditures on repairs to clubhouse and restaurant.ClubhouseMarketingMaintenance Water and EnergyOutside Servicesprovided for those cost of sales percentage that are greater than 5%.Pro Shop Merchandise SalesGolf Green Fee RevenueMiscellaneous Golf RevenueVariance ExplanationJune 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 JuneFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous65.14 - 65.14 5,568.97 - 5,568.97 00 0%4100110 Sales Hard Goods1,219.20 5,145.00 (3,925.80) 75,137.16 91,706.00 (16,568.84) 97,505.00 22,367.84 22.9%4100112 Sales-Soft Goods1,775.00 9,555.00 (7,780.00) 165,629.25 170,309.00 (4,679.75) 181,080.00 15,450.75 8.5%5100639 GS-Discounts-Mdse(515.34) - (515.34) (28,471.11) - (28,471.11) - 28,471.11 0.0% Total Revenue Golf Shop2,544.00 14,700.00 (12,156.00) 217,864.27 262,015.00 (44,150.73) 278,585.00 66,289.70 23.8%COS 5100150 COS-GS-Hard Goods 671.12 2,984.10 (2,312.98) 38,885.19 53,189.48 (14,304.29) 56,552.90 17,667.71 31.2%5100151 COS-GS-Soft Goods816.20 5,541.90 (4,725.70) 81,384.93 98,779.22 (17,394.29) 105,026.40 23,641.47 22.5%5100152 COS-GS-Purchase Disc- (426.00) 426.00 (652.71) (7,599.00) 6,946.29 (8,079.00) (7,426.29) 91.9%5100220 COS-GS-Freight Merch 59.81 128.00 (68.19) 3,429.73 2,280.00 1,149.73 2,424.00 (1,005.73) -41.5%Cost of Sales - Golf Shop1,547.13 8,228.00 (6,680.87) 123,047.14 146,649.70 (23,602.56) 155,924.30 32,877.16 21.1%Gross Profit996.87 6,472.00 (5,475.13) 94,817.13 115,365.30 (20,548.17) 122,660.70 33,412.54 27.2%COS % 60.8% 56.0% -4.8% 56.5% 56.0% -0.5% 53.1% 49.6% 93.4%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group1,198.38 2,387.00 (1,188.62) 20,961.46 26,257.00 (5,295.54) 27,621.00 6,659.54 24.1%6101325 Insurance-Workers Comp 880.17 447.00 433.17 7,932.78 4,955.00 2,977.78 5,042.00 (2,890.78) -57.3%6101720 Salaries4,000.00 4,001.00 (1.00) 48,007.00 48,012.00 (5.00) 45,000.00 (3,007.00) -6.7%6101800 Taxes-Employer Payroll 1,069.96 1,669.00 (599.04) 15,266.95 18,503.00 (3,236.05) 18,825.00 3,558.05 18.9%6101880 Wages-Hourly9,385.32 7,922.00 1,463.32 83,864.95 84,166.00 (301.05) 89,463.00 5,598.05 6.3%6101882 Wages-Overtime10.88 - 10.88 1,320.80 - 1,320.80 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 16,544.71 16,426.00 118.71 177,353.94 181,893.00 (4,539.06) 185,951.00 10,870.74 5.8%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office230.61 250.00 (19.39) 1,066.61 3,000.00 (1,933.39) 3,000.00 1,933.39 64.4%6109220 Freight & Delivery- - - 39.80 75.00 (35.20) 75.00 35.20 46.9%6109490 Miscellaneous500.00 500.00 - 7,836.27 6,000.00 1,836.27 6,000.00 (1,836.27) -30.6%6109150 Dues and Subscriptions- - - 1,662.62 2,300.00 (637.38) 2,300.00 637.38 27.7%6109500 ProShop-Over/Short(20.11) - (20.11) 245.18 - 245.18 - (245.18) 0.0%6109722 Seminars/Training- 35.00 (35.00) 55.00 3,690.00 (3,635.00) 3,690.00 3,635.00 98.5%6109810 Travel - Merchandise- 15.00 (15.00) - 90.00 (90.00) 90.00 90.00 100.0%6109820 Uniforms533.85 200.00 333.85 2,972.93 2,400.00 572.93 2,400.00 (572.93) -23.9%6117840 Telephones152.77 110.00 42.77 1,076.37 1,320.00 (243.63) 1,320.00 243.63 18.5%1,397.12 1,110.00 287.12 14,954.78 18,875.00 (3,920.22) 18,875.00 3,920.22 20.8%17,941.83 17,536.00 405.83 192,308.72 200,768.00 (8,459.28) 204,826.00 14,790.96 7.2%Net Income(16,944.96) (11,064.00) (5,880.96) (97,491.59) (85,402.70) (12,088.89) (82,165.30) 18,621.58 -22.7%SilverRock ResortGolf Shop Income StatementJune 2017Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 JuneFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group7,962.46 8,990.00 (1,027.54) 107,149.57 107,880.00 (730.43) 107,880.00 730.43 0.7%6311325 Insurance-Workers Comp3,017.71 2,137.00 880.71 30,336.84 24,308.00 6,028.84 24,308.00 (6,028.84) -24.8%6311720 Salaries9,557.08 9,333.33 223.75 129,311.54 111,999.96 17,311.58 112,000.00 (17,311.54) -15.5%6311800 Taxes-Employer Payroll4,632.72 8,110.00 (3,477.28) 67,777.62 91,481.00 (23,703.38) 91,481.00 23,703.38 25.9%6311880 Wages-Hourly44,783.81 45,727.67 (943.86) 530,308.92 525,493.04 4,815.88 525,494.00 (4,814.92) -0.9%6311882 Wages-Overtime2,556.97 2,869.00 (312.03) 15,434.21 15,945.00 (510.79) 15,945.00 510.79 3.2%Total-CM-SALARIES & BENEFITS72,510.75 77,167.00 (4,656.25) 880,318.70 877,107.00 3,211.70 877,108.00 (3,210.70) -0.4%63-CM-SUPPLIES & MATERIALS6313734 Chemicals3,001.57 2,000.00 1,001.57 32,485.94 34,600.00 (2,114.06) 34,600.00 2,114.06 6.1%6313744 Fertilizer4,444.57 5,000.00 (555.43) 78,832.53 112,500.00 (33,667.47) 112,500.00 33,667.47 29.9%6313745 Herbicides- - - 13,179.43 17,000.00 (3,820.57) 17,000.00 3,820.57 22.5%6313746 Flowers/Plants- - - 1,891.48 3,050.00 (1,158.52) 3,050.00 1,158.52 38.0%6313748 Fuel-Gasoline2,757.95 3,100.00 (342.05) 33,856.78 52,970.00 (19,113.22) 55,020.00 21,163.22 38.5%6313750 Golf Course Accessories198.74 100.00 98.74 13,700.98 13,000.00 700.98 13,000.00 (700.98) -5.4%6313756 POA Control- - - 6,367.86 7,000.00 (632.14) 7,000.00 632.14 9.0%6313758 Miscellaneous Supp100.47 100.00 0.47 7,117.72 4,350.00 2,767.72 4,350.00 (2,767.72) -63.6%6313762 Supplies-Office- - - 2,104.46 - 2,104.46 - (2,104.46) 0.0%6313774 Sand- 100.00 (100.00) 9,273.61 13,460.00 (4,186.39) 13,460.00 4,186.39 31.1%6313776 Seed- 350.00 (350.00) 117,164.38 125,900.00 (8,735.62) 125,900.00 8,735.62 6.9%6313778 Small Tools & Non-Capital Equip- 100.00 (100.00) 3,066.98 5,000.00 (1,933.02) 5,000.00 1,933.02 38.7%6313780 Sod929.88 200.00 729.88 12,566.76 10,450.00 2,116.76 10,450.00 (2,116.76) -20.3%6313782 Topdressing3,031.34 1,300.00 1,731.34 7,614.00 10,600.00 (2,986.00) 10,600.00 2,986.00 28.2%Total-CM-SUPPLIES & MATERIALS14,464.52 12,350.00 2,114.52 339,222.91 409,880.00 (70,657.09) 411,930.00 72,707.09 17.7%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint2,830.00 2,600.00 230.00 32,590.00 31,200.00 1,390.00 31,200.00 (1,390.00) -4.5%6315685 CM-R&M-Bldngs & Othr Structures- 250.00 (250.00) 2,855.84 5,550.00 (2,694.16) 5,550.00 2,694.16 48.5%6315690 CM-R&M-Equipment2,011.10 2,000.00 11.10 36,635.38 36,500.00 135.38 40,000.00 3,364.62 8.4%6315692 CM-R&M-Irrigation System- 1,000.00 (1,000.00) 19,818.61 19,050.00 768.61 19,050.00 (768.61) -4.0%6315696 CM-R&M-Pumps- - - 9,131.23 10,500.00 (1,368.77) 10,500.00 1,368.77 13.0%6315815 CM-R&M-Trees-Pruning Etc3,800.00 - 3,800.00 9,871.00 12,050.00 (2,179.00) 12,050.00 2,179.00 18.1%Total-CM-REPAIRS & MAINTENANCE8,641.10 5,850.00 2,791.10 110,902.06 114,850.00 (3,947.94) 118,350.00 7,447.94 6.3%6317836 Utilities-Natural Gas/LPG- 15.00 (15.00) 233.69 180.00 53.69 180.00 (53.69) 0.0%6317840 Telephones741.69 850.00 (108.31) 8,765.29 10,200.00 (1,434.71) 10,200.00 1,434.71 14.1%Total-CM-UTILITIES741.69 865.00 (123.31) 8,998.98 10,380.00 (1,381.02) 10,380.00 1,381.02 13.3%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 500.00 (100.00) 4,800.00 6,000.00 (1,200.00) 6,000.00 1,200.00 20.0%6319100 Contract Svcs-Soil/Tissue Test- - - 730.80 4,000.00 (3,269.20) 4,000.00 3,269.20 81.7%6319102 Contract Svcs-Trash Removal- 524.00 (524.00) 8,069.56 6,288.00 1,781.56 6,288.00 (1,781.56) -28.3%6319150 Dues & Subscriptions210.00 100.00 110.00 1,515.00 540.00 975.00 540.00 (975.00) -180.6%6319170 Employee Education- 50.00 (50.00) - 1,550.00 (1,550.00) 1,550.00 1,550.00 100.0%6319197 Equipment Rental- 100.00 (100.00) 774.36 3,400.00 (2,625.64) 3,400.00 2,625.64 77.2%6319206 Licenses & Permits1,129.92 - 1,129.92 7,678.18 4,180.00 3,498.18 4,180.00 (3,498.18) -83.7%6319490 Miscellaneous- 100.00 (100.00) 797.35 1,200.00 (402.65) 1,200.00 402.65 33.6%6319718 Safety Equipment & Training364.96 100.00 264.96 3,470.78 3,850.00 (379.22) 3,850.00 379.22 9.8%6319822 Uniforms768.05 920.00 (151.95) 13,242.59 11,040.00 2,202.59 11,040.00 (2,202.59) -20.0%Total-CM-OTHER EXPENSES2,872.93 2,394.00 478.93 41,078.62 42,048.00 (969.38) 42,048.00 969.38 2.3%Month to DateYear to DateSilverRock ResortCourse Maintenance Expense StatementJune 2017Annual Budget5 JuneFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,196.55 2,728.00 (531.45) 40,346.46 32,736.00 7,610.46 32,736.00 (7,610.46) -23.2%6321325 Insurance-Workers Comp628.69 545.00 83.69 6,585.09 6,171.00 414.09 6,171.00 (414.09) -6.7%6321800 Taxes-Employer Payroll714.89 2,083.00 (1,368.11) 15,355.67 23,335.00 (7,979.33) 23,334.00 7,978.33 34.2%6321880 Wages-Hourly16,881.09 13,840.00 3,041.09 162,338.08 160,320.00 2,018.08 160,320.00 (2,018.08) -1.3%6321882 Wages-Overtime854.93 1,038.00 (183.07) 6,313.08 6,351.00 (37.92) 6,351.00 37.92 0.6%Total-CM-LM-SALARIES & BENEFITS21,276.15 20,234.00 1,042.15 230,938.38 228,913.00 2,025.38 228,912.00 (2,026.38) -0.9%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools 151.24 75.00 76.24 565.44 1,025.00 (459.56) 1,025.00 459.56 44.8%6323788 Uniforms- 290.00 (290.00) 4,763.63 3,480.00 1,283.63 3,480.00 (1,283.63) -36.9%Total-CM-LM-SUPPLIES & MATERIALS151.24 365.00 (213.76) 5,329.07 4,505.00 824.07 4,505.00 (824.07) -18.3%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 500.00 (500.00) 2,215.29 4,250.00 (2,034.71) 4,250.00 2,034.71 47.9%Total-CM-LM-REPAIRS & MAINTENANCE- 500.00 (500.00) 2,215.29 4,250.00 (2,034.71) 4,250.00 2,034.71 47.9%120,658.38 119,725.00 933.38 1,619,004.01 1,691,933.00 (72,928.99) 1,697,483.00 78,478.99 4.6% JuneFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 14,966.24 21,530.00 (6,563.76) 145,905.35 179,791.00 (33,885.65) 179,791.00 33,885.65 18.8%6337842 Utilities-Water7,414.06 9,439.00 (2,024.94) 60,438.77 70,047.00 (9,608.23) 45,338.00 (15,100.77) -33.3%22,380.30 30,969.00 (8,588.70) 206,344.12 249,838.00 (43,493.88) 225,129.00 18,784.88 8.3%Total-COURSE MAINTENANCECourse Maintenance Expense StatementJune 2017Silverrock ResortAnnual BudgetMonth to DateYear to DateSilverrock ResortCourse Maintenance Water & EnergyJune 2017Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual Budget6 JuneFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 682.00 (682.00) 800.00 8,184.00 (7,384.00) 8,184.00 7,384.00 90.2%6411325 Insurance-Workers Comp1,760.33 388.00 1,372.33 13,247.02 5,229.00 8,018.02 5,229.00 (8,018.02) -153.3%6411800 Taxes-Employer Payroll926.48 1,289.00 (362.52) 19,071.09 17,361.00 1,710.09 17,360.00 (1,711.09) -9.9%6411880 Wages-Hourly8,974.93 10,350.00 (1,375.07) 148,426.32 139,435.00 8,991.32 139,434.00 (8,992.32) -6.4%6411882 Wages-Overtime19.70 - 19.70 4,199.10 - 4,199.10 - (4,199.10) 0.0%Total-CBR-SALARIES & BENEFITS11,681.44 12,709.00 (1,027.56) 185,743.53 170,209.00 15,534.53 170,207.00 (15,536.53) -9.1%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- 50.00 (50.00) 827.50 1,850.00 (1,022.50) 1,850.00 `0.0%6413742 Supplies-Expendable241.33 500.00 (258.67) 5,945.88 6,750.00 (804.12) 6,750.00 804.12 11.9%6413748 Supplies-Fuel for Shuttle23.65 100.00 (76.35) 975.43 3,000.00 (2,024.57) 3,000.00 2,024.57 67.5%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) - 525.00 (525.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- 70.00 (70.00) 58.02 420.00 (361.98) 420.00 361.98 86.2%6413786 Supplies-Towels 400.00 72.00 328.00 4,242.18 2,182.00 2,060.18 2,182.00 (2,060.18) -94.4%6413796 Supplies-Bottled Water5,486.75 50.00 5,436.75 21,227.83 11,000.00 10,227.83 11,000.00 (10,227.83) -93.0%Total-CBR-SUPPLIES & MATERIALS6,151.73 892.00 5,259.73 43,968.84 34,727.00 9,241.84 34,727.00 (10,264.34) -29.6%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment756.79 300.00 456.79 3,302.53 3,600.00 (297.47) 3,600.00 297.47 8.3%6415695 CBR-R&M-Cart Maintenance & Repair 500.00 500.00 - 5,956.45 6,450.00 (493.55) 6,450.00 493.55 7.7%Total-CBR-REPAIRS & MAINTENANCE1,256.79 800.00 456.79 9,258.98 10,050.00 (791.02) 10,050.00 791.02 7.9%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen966.88 800.00 166.88 10,965.64 9,600.00 1,365.64 9,600.00 (1,365.64) -14.2%6419220 Freight/Delivery- - - - 450.00 (450.00) 450.00 450.00 100.0%6419490 Miscellaneous- 600.00 (600.00) 2,498.37 7,200.00 (4,701.63) 7,200.00 4,701.63 65.3%6419820 Uniforms - 200.00 (200.00) 5,245.59 5,200.00 45.59 5,200.00 (45.59) -0.9%Total-CBR-OTHER EXPENSES966.88 1,600.00 (633.12) 18,709.60 22,450.00 (3,740.40) 22,450.00 3,740.40 16.7%TOTAL-CARTS,BAGROOM & RANGE20,056.84 16,001.00 (633.12) 257,680.95 237,436.00 20,244.95 237,434.00 (21,269.45) -9.0%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp754.43 96.00 658.43 6,178.58 2,180.00 3,998.58 2,179.00 (3,999.58) -183.6%6431800 Taxes-Employer Payroll411.21 357.00 54.21 7,814.62 8,134.00 (319.38) 8,135.00 320.38 3.9%6431880 Wages-Hourly3,625.15 2,550.00 1,075.15 61,104.04 58,107.00 2,997.04 58,108.00 (2,996.04) -5.2%6431882 Wages-Overtime- - - - - #N/A- - 0.0%Total-CS-SALARIES & BENEFITS4,790.79 3,003.00 1,787.79 75,097.24 68,421.00 #N/A68,422.00 (6,675.24) -9.8%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 75.00 (75.00) 121.84 1,050.00 (928.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) - 600.00 (600.00) 600.00 600.00 100.0%6439820 Uniforms - 75.00 (75.00) 1,381.53 2,125.00 (743.47) 2,125.00 743.47 35.0%Total-CS-OTHER EXPENSES- 200.00 (200.00) 1,932.37 3,975.00 (2,042.63) 3,975.00 2,042.63 51.4%Total-COURSE SERVICES4,790.79 3,203.00 1,587.79 77,029.61 72,396.00 #N/A72,397.00 (4,632.61) -6.4%24,847.63 19,204.00 5,643.63 334,710.56 309,832.00 24,878.56 309,831.00 (27,944.69) -9.0%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementJune 2017Annual Budget7 JuneFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 4,800.00 4,800.00 - 4,800.00 - 0.0%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 4,800.00 4,800.00 - 4,800.00 - 0.0%65-CH-UTILITIES6507836 Utilities-Natural Gas379.24 300.00 79.24 4,923.74 3,600.00 1,323.74 3,600.00 (1,323.74) -36.8%6507840 Utilities-Telephone1,062.28 1,150.00 (87.72) 13,884.35 13,800.00 84.35 13,800.00 (84.35) -0.6%6507842 Utilities-Water437.89 321.00 116.89 4,639.95 3,852.00 787.95 3,852.00 (787.95) -20.5%6507844 Utilities-Cable 490.47 340.00 150.47 5,868.87 4,080.00 1,788.87 4,080.00 (1,788.87) -43.8%Total-CH-UTILITIES2,369.88 2,111.00 258.88 29,316.91 25,332.00 #N/A25,332.00 (3,984.91) -15.7%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 1,890.00 1,825.00 65.00 22,070.00 22,500.00 (430.00) 22,500.00 430.00 1.9%6509099 Contract Services-Security5,417.04 4,900.00 517.04 65,575.16 60,400.00 5,175.16 60,400.00 (5,175.16) -8.6%6509215 Flowers & Decorations- 400.00 (400.00) 573.12 1,900.00 (1,326.88) 1,900.00 1,326.88 69.8%6509490 Miscellaneous- 200.00 (200.00) 2,127.00 7,000.00 (4,873.00) 7,000.00 4,873.00 69.6%6509718 Safety Equipment & Training- 100.00 (100.00) 642.24 1,200.00 (557.76) 1,200.00 557.76 46.5%Total-CH-OTHER EXPENSES7,307.04 7,425.00 (117.96) 90,987.52 93,000.00 (2,012.48) 93,000.00 2,012.48 2.2%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures 1,055.72 300.00 755.72 5,526.56 3,600.00 1,926.56 3,600.00 (1,926.56) -53.5%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) 3,169.90 4,800.00 (1,630.10) 4,800.00 1,630.10 34.0%6515690 CH-R&M-Equipment Repair1,034.00 400.00 634.00 2,399.16 4,800.00 (2,400.84) 4,800.00 2,400.84 50.0%Total-CH-REPAIRS & MAINTENANCE2,089.72 1,100.00 989.72 11,095.62 13,200.00 (2,104.38) 13,200.00 2,104.38 15.9%12,166.64 11,036.00 1,130.64 136,200.05 136,332.00 #N/A136,332.00 4,208.76 3.1%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementJune 2017Annual Budget8 JuneFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 351.02 341.00 10.02 3,894.04 4,092.00 (197.96) 4,092.00 197.96 4.8%6601325 Insurance-Workers Comp106.00 94.00 12.00 1,150.50 1,128.00 22.50 1,129.00 (21.50) -1.9%6601720 Salaries2,857.44 2,508.00 349.44 28,268.23 30,096.00 (1,827.77) 30,096.00 1,827.77 6.1%6601800 Taxes-Employer Payroll217.80 351.00 (133.20) 2,873.25 4,212.00 (1,338.75) 4,213.00 1,339.75 31.8%Total-MKT-SALARIES & BENEFITS3,532.26 3,294.00 238.26 36,186.02 39,528.00 (3,341.98) 39,530.00 3,343.98 8.5%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office64.17 100.00 (35.83) 1,505.95 1,200.00 305.95 1,200.00 (305.95) -25.5%6603768 Supplies-Printing & Stationery 265.57 125.00 140.57 7,425.94 4,425.00 3,000.94 4,425.00 (3,000.94) -67.8%329.74 225.00 104.74 8,931.89 5,625.00 3,306.89 5,625.00 (3,306.89) -58.8%66-MKT-UTILITIES6607840 Utilities-Telephone 177.72 100.00 77.72 1,428.24 1,200.00 228.24 1,200.00 (228.24) -19.0%Total-MKT-UTILITIES177.72 100.00 77.72 1,428.24 1,200.00 228.24 1,200.00 (228.24) -19.0%66-MKT-OTHER EXPENSES6609010 Advertising11,193.37 5,377.00 5,816.37 183,729.98 169,987.00 13,742.98 178,987.00 (4,742.98) -2.6%6609040 Business Meals- 25.00 (25.00) - 300.00 (300.00) 300.00 300.00 100.0%6609080 Collateral Material215.33 1,000.00 (784.67) 10,143.55 5,500.00 4,643.55 5,500.00 (4,643.55) -84.4%6609102 Contract Services-Web Page- 150.00 (150.00) 990.00 1,800.00 (810.00) 1,800.00 810.00 45.0%6609490 Miscellaneous- - - 817.39 350.00 467.39 350.00 (467.39) -133.5%6609620 Postage- 50.00 (50.00) 82.11 600.00 (517.89) 600.00 517.89 86.3%6609630 Promotion- 50.00 (50.00) 97.09 700.00 (602.91) 700.00 602.91 86.1%6609633 Promotion-Community217.02 75.00 142.02 2,492.67 2,250.00 242.67 2,250.00 (242.67) -10.8%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 Uniforms- - - 1,172.59 600.00 572.59 600.00 (572.59) -95.4%Total-MKT-OTHER EXPENSES11,625.72 6,727.00 4,898.72 200,916.59 184,822.00 16,094.59 193,822.00 (7,094.59) -3.7%15,665.44 10,346.00 5,319.44 247,462.74 231,175.00 16,287.74 240,177.00 (7,285.74) -3.0%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementJune 2017Annual Budget9 JuneFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,717.55 1,488.00 229.55 16,933.96 17,856.00 (922.04) 17,856.00 922.04 5.2%6701325 Insurance-Workers Comp377.21 662.00 (284.79) 5,843.45 7,718.00 (1,874.55) 7,717.00 1,873.55 24.3%6701720 Salaries14,486.40 15,050.00 (563.60) 168,570.20 174,600.00 (6,029.80) 177,996.00 9,425.80 5.3%6701800 Taxes-Employer Payroll1,303.19 2,471.00 (1,167.81) 17,515.51 28,812.00 (11,296.49) 28,812.00 11,296.49 39.2%6701880 Wages-Hourly2,548.69 2,600.00 (51.31) 31,702.36 31,350.00 352.36 27,800.00 (3,902.36) -14.0%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS20,433.04 22,271.00 (1,837.96) 240,565.48 260,336.00 (19,770.52) 260,181.00 19,615.52 7.5%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 800.00 (800.00) 2,972.21 6,300.00 (3,327.79) 6,300.00 3,327.79 52.8%6703762 Supplies-Office53.23 150.00 (96.77) 618.13 1,800.00 (1,181.87) 1,800.00 1,181.87 65.7%6703768 Supplies-Printing & Stationery93.26 400.00 (306.74) 2,040.68 3,300.00 (1,259.32) 3,300.00 1,259.32 38.2%Total-G&A-SUPPLIES & MATERIALS146.49 1,350.00 (1,203.51) 5,631.02 11,400.00 (5,768.98) 11,400.00 5,768.98 50.6%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) 6,724.20 1,900.00 4,824.20 1,900.00 (4,824.20) -253.9%Total-G&A-REPAIRS & MAINTENANCE- 100.00 (100.00) 6,724.20 1,900.00 4,824.20 1,900.00 (4,824.20) -253.9%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 6,000.00 6,000.00 - 4,800.00 (1,200.00) -25.0%6709150 Dues & Subscriptions- 50.00 (50.00) 675.92 1,700.00 (1,024.08) 1,700.00 1,024.08 60.2%6709180 Employee Recruiting/Relocation133.45 - 133.45 871.01 1,400.00 (528.99) 1,400.00 528.99 37.8%6709197 Equipment Rental464.63 550.00 (85.37) 6,533.05 6,600.00 (66.95) 6,600.00 66.95 1.0%6709202 Fees-Bank104.17 90.00 14.17 1,486.01 1,080.00 406.01 1,080.00 (406.01) -37.6%6709208 Fees-Payroll Processing1,462.52 1,200.00 262.52 8,578.73 14,400.00 (5,821.27) 14,400.00 5,821.27 40.4%6709220 Freight/Delivery- 50.00 (50.00) 31.72 600.00 (568.28) 600.00 568.28 94.7%6709490 Miscellaneous- 100.00 (100.00) 3,708.41 6,600.00 (2,891.59) 1,200.00 (2,508.41) -209.0%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services148.52 75.00 73.52 1,426.45 900.00 526.45 900.00 (526.45) -58.5%6709625 Professional Fees800.50 850.00 (49.50) 12,800.01 10,200.00 2,600.01 10,200.00 (2,600.01) -25.5%6709636 Promotion/Entertainment- 100.00 (100.00) - 1,200.00 (1,200.00) 6,600.00 6,600.00 100.0%6709722 Seminars & Training838.95 200.00 638.95 2,064.61 2,400.00 (335.39) 2,400.00 335.39 14.0%6709810 Travel- 200.00 (200.00) - 1,100.00 (1,100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms- 75.00 900.00 1,026.01 1,050.00 (23.99) 1,050.00 23.99 2.3%Total-G&A-OTHER EXPENSES4,452.74 4,040.00 1,387.74 45,201.93 55,230.00 (10,028.07) 54,030.00 8,828.07 16.3%25,032.27 27,761.00 (2,728.73) 298,122.63 328,866.00 (30,743.37) 327,511.00 29,388.37 9.0%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementJune 2017Annual Budget10 JuneFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts9,829.27 10,050.00 (220.73) 118,792.87 121,050.00 (2,257.13) 121,050.00 2,257.13 1.9%6800193 Equipment Leases-Maintenance 9,181.20 11,500.00 (2,318.80) 101,863.41 116,200.00 (14,336.59) 72,600.00 (29,263.41) -40.3%6800194 Equipment Leases-Trailer282.07 600.00 (317.93) 6,222.77 7,200.00 (977.23) 7,200.00 977.23 13.6%6800196 Equipment Leases-GPS3,870.00 4,700.00 (830.00) 55,320.00 56,400.00 (1,080.00) 56,400.00 1,080.00 1.9%6800197 Equipment Leases-Others2,824.82 1,950.00 874.82 22,619.08 20,200.00 2,419.08 13,800.00 (8,819.08) 0.0%25,987.36 28,800.00 (2,812.64) 304,818.13 321,050.00 (16,231.87) 271,050.00 (33,768.13) -12.5%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,652.80 8,653.00 (0.20) 103,833.60 103,836.00 (2.40) 99,840.00 (3,993.60) -4.0%6900210 FF&E Reserve500.68 2,803.00 (2,302.32) 57,580.27 59,406.00 (1,825.73) 63,985.00 6,404.73 10.0%6900800 Personal Property Taxes- - - 11,582.64 11,800.00 (217.36) 11,800.00 217.36 1.8%6900323 Insurance-Commercial4,624.76 2,700.00 1,924.76 56,903.93 32,400.00 24,503.93 26,400.00 (30,503.93) -115.5%13,778.24 14,156.00 (377.76) 229,900.44 207,442.00 22,458.44 202,025.00 (27,875.44) -13.8%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementJune 2017Annual BudgetMonth to DateYear to Date11 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2016-20172016 2016 2016 2016 2016 2016Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia4828SalesPromotionGolf 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 CategoryJanuaryFebruaryMarchAprilMayJuneMedia454SalesPromotionGolf IndustryVIPCelebrityPGA Comp27 10 29 38 12 10Charity/Gift Certificate14916 20Rain/Wind Checks1142Club Staff51 22 38 78 62 56LQ HS Golf11 45 116 4986118 95 199 189 84 7212