Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
02 August 2017 SilverRock Resort - Monthly Financial Statement
Monthly Financial Statements July 2017 – August 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 AugustFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue22,270.50 30,929.00 (8,658.50) -28.0% 44,630.75 56,066.00 (11,435.25) 2,964,060.00 2,919,429.25 2%401000 Miscellaneous Golf Revenue3,727.00 2,421.00 1,306.00 53.9%8,142.00 5,281.00 2,861.00 166,766.00 158,624.00 5%410000 Revenue-Golf Shop4,335.72 3,900.00 435.72 11.2%7,360.26 7,323.00 37.26 262,017.00 254,656.74 3%420000 Revenue-F&B Concession500.00 500.00 - 0.0%1,000.00 1,000.00 - 12,000.00 11,000.00 8%890000 Interest Income- - - - - - - - 0%Total Income30,833.22 37,750.00 (6,916.78) -18.3% 61,133.01 69,670.00 (8,536.99) 3,404,843.00 3,343,709.99 2%Cost of Goods Sold510000 COS-Golf Shop2,676.99 2,183.00 493.99 -22.6% 4,521.06 4,099.34 (421.72) 146,651.00 142,129.94 3%Total COS2,676.99 2,183.00 493.99 -22.6% 4,521.06 4,099.34 (421.72) 146,651.00 142,129.94 3%Gross Profit28,156.23 35,567.00 (7,410.77) -20.8% 56,611.95 65,570.66 (8,958.71) 3,258,192.00 3,201,580.05 2%Expenses610000 Golf Pro Shop 13,987.44 12,777.00 1,210.44 -9.5% 27,583.48 25,554.00 2,029.48 199,990.00 172,406.52 14%630000 Course Maintenance114,709.97 115,418.00 (708.03) 0.6% 225,166.31 240,938.00 (15,771.69) 1,735,790.00 1,510,623.69 13%633000 Maintenance Water & Energy23,887.84 22,810.00 1,077.84 -4.7% 40,614.55 46,225.00 (5,610.45) 249,838.00 209,223.45 16%640000 Outside Services16,227.90 19,293.00 (3,065.10) 15.9% 33,396.64 35,841.00 (2,444.36) 331,964.00 298,567.36 10%650000 Clubhouse9,806.76 10,776.00 (969.24) 9.0% 20,211.99 21,552.00 (1,340.01) 136,412.00 116,200.01 15%660000 Marketing11,180.30 7,521.00 3,659.30 -48.7% 22,037.61 15,042.00 6,995.61 230,960.00 208,922.39 10%670000 General & Administrative24,676.63 25,691.00 (1,014.37) 3.9% 46,107.00 50,536.00 (4,429.00) 329,053.00 282,946.00 14%680000 Leases25,189.25 22,550.00 2,639.25 -11.7% 50,959.28 45,100.00 5,859.28 321,050.00 270,090.72 16%690000 Miscellaneous Other Expense13,696.62 12,318.00 1,378.62 -11.2% 26,804.24 29,720.00 (2,915.76) 211,468.00 184,663.76 13%Total Expenses253,362.71 249,154.00 4,208.71 -1.7% 492,881.10 510,508.00 17,626.90 3,746,525.00 3,253,643.90 13%(225,206.48) (213,587.00) (11,619.48) -5.4%(436,269.15) (444,937.34) 8,668.19 (488,333.00) (52,063.85) 0%Rounds of Golf PlayedPaid Rounds Played959 1,007 (48) -4.8%1,907 1,007 900 42,173 40,266 5%Ave $ Per Paid Round Green Fee23.22 30.71 (7.49) -24.4%23.40 55.68 (32.27) 70.28 46.88 33%Ave $ Per Paid Round Merchandise4.52 3.87 0.65 16.7%3.86 7.27 (3.41) 6.21 2.35 62%Ave $ Per Paid Miscellaneous 3.89 2.40 1.48 61.6%4.27 5.24 (0.97) 3.95 (0.32) 108%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateAugust 20171 Income AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees22,270.50 30,929.00 (8,658.50) 44,630.75 56,066.00 (11,435.25) 2,964,060.00 2,919,429.25 98.5%4010000 Rider Fee100.00 124.00 (24.00) 185.00 225.00 (40.00) 7,307.00 7,122.00 97.5%4040000 Club Rental490.00 620.00 (130.00) 780.00 1,124.00 (344.00) 21,087.00 20,307.00 96.3%4050000 Driving Range1,637.00 1,177.00 460.00 3,577.00 1,932.00 1,645.00 94,872.00 91,295.00 96.2%4060000 Handicap Fees- - - - - - 2,500.00 2,500.00 100.0%4090000 Ball Retriever/Subcontract- - - - 1,000.00 (1,000.00) 4,000.00 4,000.00 100.0%4091000 Golf Professional Rental Fee- - - - - - 37,000.00 37,000.00 100.0%4092000 Golf Lessons - - - - - - - - 0.0%4093000 Resident Card Issue1,500.00 500.00 1,000.00 3,600.00 1,000.00 2,600.00 165,300.00 161,700.00 97.8% Total Revenue Fees25,997.50 33,350.00 (7,352.50) 52,772.75 61,347.00 (8,574.25) 3,296,126.00 3,243,353.25 98.4%25,997.50 33,350.00 (7,352.50) 52,772.75 61,347.00 (8,574.25) 3,296,126.00 3,243,353.25 98.4%SilverRock ResortStatement of Fees RevenueAugust 2017Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$22,270.50$30,929.00(8,658.50)Unfavorable: Due to high heat and humidity temperatures. Back 9 closed. ActualBudgetVariance$3,727.00 $2,421.00 1,306.00Favorable: Due to increased Resident Card sales.ActualBudgetVariance$4,335.72 $3,900.00 435.72Unfavorable: Due to rounds being down and temperatures.ExpensesActualBudgetVariance$16,227.90$19,293.00(3,065.10)Favorable: Due to reduced payroll and expenses as a result of reduced play.ActualBudgetVariance$11,180.30$7,521.003,659.30Unfavorable: Due to timing of advertising invoices.ActualBudgetVariance$25,471.92$28,800.00(3,328.08)Unfavorable: Erroneously budgeted previous lease payments amounts for the first 4 months of the new fiscal year.ActualBudgetVariance$13,696.62$12,318.001,378.62Unfavorable: Due to initial payment for commercial insurance higher than anticipated.Variance ExplanationAugust 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 areprovided for those cost of sales percentage that are greater than 5%.Pro Shop Merchandise SalesGolf Green Fee RevenueMiscellaneous Golf RevenueMarketingMiscellaneous Other ExpenseLeasesOutside Services3-20-133 Income AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous378.23 - 378.23 548.89 - 548.89 00 0%4100110 Sales Hard Goods1,680.31 1,365.00 315.31 2,945.63 2,563.00 382.63 91,706.00 88,760.37 96.8%4100112 Sales-Soft Goods3,308.00 2,535.00 773.00 4,896.56 4,760.00 136.56 170,311.00 165,414.44 97.1%5100639 GS-Discounts-Mdse (1,030.82) - (1,030.82) (1,030.82) - (1,030.82) - 1,030.82 0.0% Total Revenue Golf Shop4,335.72 3,900.00 435.72 7,360.26 7,323.00 37.26 262,017.00 255,205.63 97.4%COS 5100150 COS-GS-Hard Goods 1,040.01 791.70 248.31 1,748.51 1,486.54 261.97 53,189.48 51,440.97 96.7%5100151 COS-GS-Soft Goods 1,613.65 1,470.30 143.35 2,403.24 2,760.80 (357.56) 97,137.52 94,734.28 97.5%5100152 COS-GS-Purchase Disc (1.14) (113.00) 111.86 (1.14) (212.00) 210.86 (7,598.00) (7,596.86) 100.0%5100220 COS-GS-Freight Merch 24.47 34.00 (9.53) 370.45 64.00 306.45 2,280.00 1,909.55 83.8%Cost of Sales - Golf Shop2,676.99 2,183.00 493.99 4,521.06 4,099.34 421.72 145,009.00 140,487.94 96.9%Gross Profit 1,658.73 1,717.00 (58.27) 2,839.20 3,223.66 (384.46) 117,008.00 114,717.69 98.0%COS % 61.7% 56.0% -5.8% 61.4% 56.0% -5.4% 53.1% 55.0% 103.7%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group1,693.96 1,740.00 (46.04) 3,098.80 3,480.00 (381.20) 26,796.00 23,697.20 88.4%6101325 Insurance-Workers Comp 880.17 319.00 561.17 1,760.34 638.00 1,122.34 4,957.00 3,196.66 64.5%6101720 Salaries4,000.00 4,001.00 (1.00) 8,000.00 8,002.00 (2.00) 45,000.00 37,000.00 82.2%6101800 Taxes-Employer Payroll 774.69 1,105.00 (330.31) 1,578.31 2,210.00 (631.69) 18,825.00 17,246.69 91.6%6101880 Wages-Hourly5,692.39 4,502.00 1,190.39 11,321.40 9,004.00 2,317.40 87,179.00 75,857.60 87.0%6101882 Wages-Overtime- - - - - - - 952.88 0.0%Total -PS-SALARIES & BENEFITS 13,041.21 11,667.00 1,374.21 25,758.85 23,334.00 2,424.85 182,757.00 157,951.03 86.4%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office- 250.00 (250.00) 83.97 500.00 (416.03) 3,000.00 2,916.03 97.2%6109220 Freight & Delivery- - - 70.61 - 70.61 75.00 4.39 5.9%6109490 Miscellaneous500.00 500.00 - 1,000.00 1,000.00 - 6,000.00 5,000.00 83.3%6109150 Dues and Subscriptions- - - - - - 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short146.29 - 146.29 151.45 - 151.45 - (151.45) 0.0%6109722 Seminars/Training- 150.00 (150.00) - 300.00 (300.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- - - - - - 90.00 90.00 100.0%6109820 Uniforms262.39 100.00 162.39 310.54 200.00 110.54 2,400.00 2,089.46 87.1%6117840 Telephones37.55 110.00 (72.45) 208.06 220.00 (11.94) 1,320.00 1,111.94 84.2%946.23 1,110.00 (163.77) 1,824.63 2,220.00 (395.37) 18,875.00 17,050.37 90.3%13,987.44 12,777.00 1,210.44 27,583.48 25,554.00 2,029.48 201,632.00 175,001.40 86.8%Net Income(12,328.71) (11,060.00) (1,268.71) (24,744.28) (22,330.34) (2,413.94) (84,624.00) (60,283.71) 71.2%SilverRock ResortGolf Shop Income StatementAugust 2017Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group6,547.20 7,425.00 (877.80) 15,086.09 14,850.00 236.09 103,020.00 87,933.91 85.4%6311325 Insurance-Workers Comp3,017.71 2,006.00 1,011.71 6,035.42 4,012.00 2,023.42 26,974.00 20,938.58 77.6%6311720 Salaries11,557.08 12,200.00 (642.92) 23,114.16 24,400.00 (1,285.84) 146,400.00 123,285.84 84.2%6311800 Taxes-Employer Payroll3,003.48 6,953.00 (3,949.52) 6,039.96 13,906.00 (7,866.04) 91,481.00 85,441.04 93.4%6311880 Wages-Hourly43,330.89 41,284.00 2,046.89 83,557.63 82,568.00 989.63 567,262.00 483,704.37 85.3%6311882 Wages-Overtime- - - - - - 12,350.00 12,350.00 100.0%Total-CM-SALARIES & BENEFITS67,456.36 69,868.00 (2,411.64) 133,833.26 139,736.00 (5,902.74) 947,487.00 813,653.74 85.9%63-CM-SUPPLIES & MATERIALS6313734 Chemicals3,003.15 190.00 2,813.15 9,417.09 7,162.00 2,255.09 17,760.00 8,342.91 47.0%6313744 Fertilizer731.92 2,100.00 (1,368.08) 4,532.47 7,970.00 (3,437.53) 105,970.00 101,437.53 95.7%6313745 Herbicides434.88 - 434.88 434.88 - 434.88 25,518.00 25,083.12 98.3%6313746 Flowers/Plants- - - - - - 3,050.00 3,050.00 100.0%6313748 Fuel-Gasoline5,254.05 3,640.00 1,614.05 5,373.37 7,080.00 (1,706.63) 48,950.00 43,576.63 89.0%6313750 Golf Course Accessories- - - 989.40 - 989.40 13,140.00 12,150.60 92.5%6313756 POA Control- - - - - - 9,900.00 9,900.00 100.0%6313758 Miscellaneous Supp122.07 750.00 (627.93) 190.00 1,500.00 (1,310.00) 4,350.00 4,160.00 95.6%6313762 Supplies-Office18.00 - 18.00 36.00 - 36.00 - (36.00) 0.0%6313774 Sand- 390.00 (390.00) - 780.00 (780.00) 13,460.00 13,460.00 100.0%6313776 Seed3,409.31 - 3,409.31 3,409.31 - 3,409.31 117,400.00 113,990.69 97.1%6313778 Small Tools & Non-Capital Equip- 100.00 (100.00) - 200.00 (200.00) 5,000.00 5,000.00 100.0%6313780 Sod973.31 3,500.00 (2,526.69) 973.31 7,800.00 (6,826.69) 13,500.00 12,526.69 92.8%6313782 Topdressing1,499.76 2,200.00 (700.24) 4,975.15 2,200.00 2,775.15 10,000.00 5,024.85 50.2%Total-CM-SUPPLIES & MATERIALS15,446.45 12,870.00 2,576.45 30,330.98 34,692.00 (4,361.02) 387,998.00 357,667.02 92.2%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint5,169.24 2,830.00 2,339.24 6,584.24 5,660.00 924.24 33,960.00 27,375.76 80.6%6315685 CM-R&M-Bldngs & Othr Structures- 750.00 (750.00) 1,731.35 2,000.00 (268.65) 5,550.00 3,818.65 68.8%6315690 CM-R&M-Equipment3,404.96 2,500.00 904.96 5,643.13 4,500.00 1,143.13 38,500.00 32,856.87 85.3%6315692 CM-R&M-Irrigation System3,817.13 3,500.00 317.13 6,693.72 7,900.00 (1,206.28) 19,050.00 12,356.28 64.9%6315696 CM-R&M-Pumps- 1,000.00 (1,000.00) 1,276.48 2,000.00 (723.52) 10,500.00 9,223.52 87.8%6315815 CM-R&M-Trees-Pruning Etc- - - 1,200.00 - 1,200.00 12,050.00 10,850.00 90.0%Total-CM-REPAIRS & MAINTENANCE12,391.33 10,580.00 1,811.33 23,128.92 22,060.00 1,068.92 119,610.00 96,481.08 80.7%6317836 Utilities-Natural Gas/LPG 18.60 15.00 3.60 59.34 30.00 29.34 180.00 120.66 0.0%6317840 Telephones2,003.40 850.00 1,153.40 2,891.61 1,700.00 1,191.61 10,200.00 7,308.39 71.7%Total-CM-UTILITIES2,022.00 865.00 1,157.00 2,950.95 1,730.00 1,220.95 10,380.00 7,429.05 71.6%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 400.00 - 800.00 800.00 - 4,800.00 4,000.00 83.3%6319100 Contract Svcs-Soil/Tissue Test- - - - - - 2,000.00 2,000.00 100.0%6319102 Contract Svcs-Trash Removal- 524.00 (524.00) - 1,048.00 (1,048.00) 6,288.00 6,288.00 100.0%6319150 Dues & Subscriptions- - - - - - 680.00 680.00 100.0%6319170 Employee Education- 50.00 (50.00) - 100.00 (100.00) 3,900.00 3,900.00 100.0%6319197 Equipment Rental- 150.00 (150.00) - 350.00 (350.00) 3,400.00 3,400.00 100.0%6319206 Licenses & Permits- - - - 100.00 (100.00) 4,300.00 4,300.00 100.0%6319490 Miscellaneous- 100.00 (100.00) 12.68 200.00 (187.32) 1,200.00 1,187.32 98.9%6319718 Safety Equipment & Training- 100.00 (100.00) - 300.00 (300.00) 3,850.00 3,850.00 100.0%6319822 Uniforms767.68 920.00 (152.32) 1,202.29 1,840.00 (637.71) 11,040.00 9,837.71 89.1%Total-CM-OTHER EXPENSES1,167.68 2,244.00 (1,076.32) 2,014.97 4,738.00 (2,723.03) 41,458.00 39,443.03 95.1%SilverRock ResortCourse Maintenance Expense StatementAugust 2017Annual BudgetMonth to DateYear to Date5 AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 1,634.05 2,784.00 (1,149.95) 3,995.90 5,568.00 (1,572.10) 33,408.00 29,412.10 88.0%6321325 Insurance-Workers Comp628.69 500.00 128.69 1,257.38 1,000.00 257.38 5,955.00 4,697.62 78.9%6321800 Taxes-Employer Payroll809.79 1,733.00 (923.21) 1,619.44 3,466.00 (1,846.56) 20,793.00 19,173.56 92.2%6321880 Wages-Hourly12,342.53 13,334.00 (991.47) 25,082.97 26,668.00 (1,585.03) 156,528.00 131,445.03 84.0%6321882 Wages-Overtime- - - - - - 3,418.00 3,418.00 100.0%Total-CM-LM-SALARIES & BENEFITS15,415.06 18,351.00 (2,935.94) 31,955.69 36,702.00 (4,746.31) 220,102.00 188,146.31 85.5%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 100.00 (100.00) - 200.00 (200.00) 1,025.00 1,025.00 100.0%6323788 Uniforms268.43 290.00 (21.57) 268.43 580.00 (311.57) 3,480.00 3,211.57 92.3%Total-CM-LM-SUPPLIES & MATERIALS268.43 390.00 (121.57) 268.43 780.00 (511.57) 4,505.00 4,236.57 94.0%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation542.66 250.00 292.66 683.11 500.00 183.11 4,250.00 3,566.89 83.9%Total-CM-LM-REPAIRS & MAINTENANCE542.66 250.00 292.66 683.11 500.00 183.11 4,250.00 3,566.89 83.9%114,709.97 115,418.00 (708.03) 225,166.31 240,938.00 (15,771.69) 1,735,790.00 1,510,623.69 87.0% AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 13,124.04 13,820.00 (695.96) 23,398.22 27,085.00 (3,686.78) 179,791.00 156,392.78 87.0%6337842 Utilities-Water10,763.80 8,990.00 1,773.80 17,216.33 19,140.00 (1,923.67) 70,047.00 52,830.67 75.4%23,887.84 22,810.00 1,077.84 40,614.55 46,225.00 (5,610.45) 249,838.00 209,223.45 83.7%Silverrock ResortCourse Maintenance Water & EnergyAugust 2017Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementAugust 2017Silverrock ResortAnnual BudgetMonth to DateYear to Date6 AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 696.00 (696.00) - 1,392.00 (1,392.00) 8,352.00 8,352.00 100.0%6411325 Insurance-Workers Comp453.33 239.00 214.33 2,213.66 528.00 1,685.66 5,623.00 3,409.34 60.6%6411800 Taxes-Employer Payroll525.65 794.00 (268.35) 1,065.16 1,754.00 (688.84) 18,667.00 17,601.84 94.3%6411880 Wages-Hourly4,716.80 6,375.00 (1,658.20) 11,772.47 14,089.00 (2,316.53) 149,934.00 138,161.53 92.1%6411882 Wages-Overtime 20.44 - 20.44 25.13 - 25.13 - (25.13) 0.0%Total-CBR-SALARIES & BENEFITS5,716.22 8,104.00 (2,387.78) 15,076.42 17,763.00 (2,686.58) 182,576.00 167,499.58 91.7%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- - - - - - 1,850.00 `0.0%6413742 Supplies-Expendable340.39 600.00 (259.61) 905.89 1,200.00 (294.11) 6,750.00 5,844.11 86.6%6413748 Supplies-Fuel for Shuttle- - - - - - 3,000.00 3,000.00 100.0%6413752 Supplies-Range Balls- - - - - - 9,000.00 9,000.00 100.0%6413762 Supplies-Office- 25.00 (25.00) - 50.00 (50.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels 480.00 120.00 360.00 640.00 240.00 400.00 2,182.00 1,542.00 70.7%6413796 Supplies-Bottled Water107.75 4,400.00 (4,292.25) 215.50 4,500.00 (4,284.50) 12,900.00 12,684.50 98.3%Total-CBR-SUPPLIES & MATERIALS928.14 5,145.00 (4,216.86) 1,761.39 5,990.00 (4,228.61) 36,627.00 33,015.61 90.1%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment4,615.65 300.00 4,315.65 6,641.46 600.00 6,041.46 3,600.00 (3,041.46) -84.5%6415695 CBR-R&M-Cart Maintenance & Repair- 500.00 (500.00) 500.00 1,000.00 (500.00) 6,450.00 5,950.00 92.2%Total-CBR-REPAIRS & MAINTENANCE4,615.65 800.00 3,815.65 7,141.46 1,600.00 5,541.46 10,050.00 2,908.54 28.9%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen1,052.18 800.00 252.18 1,356.52 1,600.00 (243.48) 9,600.00 8,243.48 85.9%6419220 Freight/Delivery- 75.00 (75.00) - 150.00 (150.00) 450.00 450.00 100.0%6419490 Miscellaneous194.66 600.00 (405.34) 550.91 1,200.00 (649.09) 7,200.00 6,649.09 92.3%6419820 Uniforms - - - - - - 5,200.00 5,200.00 100.0%Total-CBR-OTHER EXPENSES1,246.84 1,475.00 (228.16) 1,907.43 2,950.00 (1,042.57) 22,450.00 20,542.57 91.5%TOTAL-CARTS,BAGROOM & RANGE12,506.85 15,524.00 (228.16) 25,886.70 28,303.00 (2,416.30) 251,703.00 223,966.30 89.0%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp754.43 115.00 639.43 1,508.86 230.00 1,278.86 2,450.00 941.14 38.4%6431800 Taxes-Employer Payroll228.71 400.00 (171.29) 464.91 800.00 (335.09) 8,494.00 8,029.09 94.5%6431880 Wages-Hourly2,737.91 3,079.00 (341.09) 5,536.17 6,158.00 (621.83) 65,341.00 59,804.83 91.5%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS3,721.05 3,594.00 127.05 7,509.94 7,188.00 321.94 76,285.00 68,775.06 90.2%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 50.00 (50.00) - 100.00 (100.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous- - - - - - 200.00 200.00 100.0%6439718 Safety Equipment & Training- 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0%6439820 Uniforms - 75.00 (75.00) - 150.00 (150.00) 2,125.00 2,125.00 100.0%Total-CS-OTHER EXPENSES- 175.00 (175.00) - 350.00 (350.00) 3,975.00 3,975.00 100.0%Total-COURSE SERVICES3,721.05 3,769.00 (47.95) 7,509.94 7,538.00 (28.06) 80,260.00 72,750.06 90.6%16,227.90 19,293.00 (3,065.10) 33,396.64 35,841.00 (2,444.36) 331,963.00 292,741.36 88.2%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementAugust 2017Annual Budget7 AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 800.00 800.00 - 4,800.00 4,000.00 83.3%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 800.00 800.00 - 4,800.00 4,000.00 83.3%65-CH-UTILITIES6507836 Utilities-Natural Gas342.24 300.00 42.24 554.01 600.00 (45.99) 3,600.00 3,045.99 84.6%6507840 Utilities-Telephone- 1,150.00 (1,150.00) 1,072.46 2,300.00 (1,227.54) 13,800.00 12,727.54 92.2%6507842 Utilities-Water353.74 321.00 32.74 745.73 642.00 103.73 3,852.00 3,106.27 80.6%6507844 Utilities-Cable490.49 380.00 110.49 980.98 760.00 220.98 4,560.00 3,579.02 78.5%Total-CH-UTILITIES1,186.47 2,151.00 (964.53) 3,353.18 4,302.00 (948.82) 25,812.00 22,458.82 87.0%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 2,010.00 1,825.00 185.00 3,760.00 3,650.00 110.00 22,500.00 18,740.00 83.3%6509099 Contract Services-Security5,095.02 5,000.00 95.02 10,381.26 10,000.00 381.26 60,000.00 49,618.74 82.7%6509215 Flowers & Decorations- - - - - - 1,900.00 1,900.00 100.0%6509490 Miscellaneous- 200.00 (200.00) - 400.00 (400.00) 7,000.00 7,000.00 100.0%6509718 Safety Equipment & Training- 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES7,105.02 7,125.00 (19.98) 14,141.26 14,250.00 (108.74) 92,600.00 78,458.74 84.7%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures 1,115.27 300.00 815.27 1,917.55 600.00 1,317.55 3,600.00 1,682.45 46.7%6515686 CH-R&M-Restaurant Repairs- 400.00 (400.00) - 800.00 (800.00) 4,800.00 4,800.00 100.0%6515690 CH-R&M-Equipment Repair- 400.00 (400.00) - 800.00 (800.00) 4,800.00 4,800.00 100.0%Total-CH-REPAIRS & MAINTENANCE1,115.27 1,100.00 15.27 1,917.55 2,200.00 (282.45) 13,200.00 11,282.45 85.5%9,806.76 10,776.00 (969.24) 20,211.99 21,552.00 (1,340.01) 136,412.00 22,564.90 16.5%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementAugust 2017Annual Budget8 AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 348.00 348.00 - 699.02 696.00 3.02 4,176.00 3,476.98 83.3%6601325 Insurance-Workers Comp113.00 94.00 19.00 207.00 188.00 19.00 1,129.00 922.00 81.7%6601720 Salaries1,904.96 2,508.00 (603.04) 3,809.92 5,016.00 (1,206.08) 30,096.00 26,286.08 87.3%6601800 Taxes-Employer Payroll145.20 326.00 (180.80) 290.40 652.00 (361.60) 3,912.00 3,621.60 92.6%Total-MKT-SALARIES & BENEFITS2,511.16 3,276.00 (764.84) 5,006.34 6,552.00 (1,545.66) 39,313.00 34,306.66 87.3%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office 64.17 100.00 (35.83) 128.34 200.00 (71.66) 1,200.00 1,071.66 89.3%6603768 Supplies-Printing & Stationery 388.72 - 388.72 699.14 - 699.14 4,425.00 3,725.86 84.2%452.89 100.00 352.89 827.48 200.00 627.48 5,625.00 4,797.52 85.3%66-MKT-UTILITIES6607840 Utilities-Telephone 43.08 100.00 (56.92) 220.80 200.00 20.80 1,200.00 979.20 81.6%Total-MKT-UTILITIES43.08 100.00 (56.92) 220.80 200.00 20.80 1,200.00 979.20 81.6%66-MKT-OTHER EXPENSES6609010 Advertising6,704.31 3,745.00 2,959.31 13,720.68 7,490.00 6,230.68 169,987.00 156,266.32 91.9%6609040 Business Meals- 25.00 (25.00) - 50.00 (50.00) 300.00 300.00 100.0%6609080 Collateral Material- - - - - - 5,500.00 5,500.00 100.0%6609102 Contract Services-Web Page- 150.00 (150.00) 198.00 300.00 (102.00) 1,800.00 1,602.00 89.0%6609490 Miscellaneous- - - - - - 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0%6609630 Promotion1,468.86 - 1,468.86 2,064.31 - 2,064.31 700.00 (1,364.31) -194.9%6609633 Promotion-Community- 75.00 (75.00) - 150.00 (150.00) 2,250.00 2,250.00 100.0%6609634 Promotion-Media/Vendor- - - - - - 2,000.00 2,000.00 100.0%6609150 Dues and Subscriptions- - - - - - 735.00 735.00 100.0%6609820 Uniforms- - - - - - 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES8,173.17 4,045.00 4,128.17 15,982.99 8,090.00 7,892.99 184,822.00 168,839.01 91.4%11,180.30 7,521.00 3,659.30 22,037.61 15,042.00 6,995.61 230,960.00 208,922.39 90.5%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementAugust 2017Annual Budget9 AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group1,094.94 1,509.00 (414.06) 3,026.18 3,018.00 8.18 18,108.00 15,081.82 83.3%6701325 Insurance-Workers Comp877.17 632.00 245.17 1,254.38 1,242.00 12.38 7,905.00 6,650.62 84.1%6701720 Salaries12,800.00 13,850.00 (1,050.00) 25,600.00 27,100.00 (1,500.00) 177,996.00 152,396.00 85.6%6701800 Taxes-Employer Payroll1,137.22 2,193.00 (1,055.78) 2,306.12 4,308.00 (2,001.88) 32,800.00 30,493.88 93.0%6701880 Wages-Hourly2,065.69 3,012.00 (946.31) 4,545.35 6,028.00 (1,482.65) 27,404.00 22,858.65 83.4%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS17,975.02 21,196.00 (3,220.98) 36,732.03 41,696.00 (4,963.97) 264,213.00 227,480.97 86.1%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer1,878.84 500.00 1,378.84 2,141.78 1,000.00 1,141.78 6,300.00 4,158.22 66.0%6703762 Supplies-Office58.45 105.00 (46.55) 58.45 210.00 (151.55) 1,260.00 1,201.55 95.4%6703768 Supplies-Printing & Stationery- 100.00 (100.00) - 200.00 (200.00) 3,300.00 3,300.00 100.0%Total-G&A-SUPPLIES & MATERIALS1,937.29 705.00 1,232.29 2,200.23 1,410.00 790.23 10,860.00 8,659.77 79.7%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 100.00 (100.00) - 100.00 (100.00) 1,900.00 1,900.00 100.0%Total-G&A-REPAIRS & MAINTENANCE- 100.00 (100.00) - 100.00 (100.00) 1,900.00 1,900.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 1,000.00 1,000.00 - 6,000.00 5,000.00 83.3%6709150 Dues & Subscriptions180.00 - 180.00 420.00 50.00 370.00 1,150.00 730.00 63.5%6709180 Employee Recruiting/Relocation101.95 - 101.95 101.95 - 101.95 1,200.00 1,098.05 91.5%6709197 Equipment Rental464.11 550.00 (85.89) 1,017.39 1,100.00 (82.61) 6,600.00 5,582.61 84.6%6709202 Fees-Bank128.29 90.00 38.29 225.37 180.00 45.37 1,080.00 854.63 79.1%6709208 Fees-Payroll Processing1,577.73 1,000.00 577.73 1,882.73 2,000.00 (117.27) 12,000.00 10,117.27 84.3%6709220 Freight/Delivery- 50.00 (50.00) - 100.00 (100.00) 600.00 600.00 100.0%6709490 Miscellaneous10.86 100.00 (89.14) 82.98 200.00 (117.02) 6,600.00 6,517.02 98.7%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services64.00 75.00 (11.00) 222.99 150.00 72.99 900.00 677.01 75.2%6709625 Professional Fees1,202.20 850.00 352.20 1,686.15 1,700.00 (13.85) 10,200.00 8,513.85 83.5%6709636 Promotion/Entertainment- 100.00 (100.00) - 200.00 (200.00) 1,200.00 1,200.00 100.0%6709722 Seminars & Training250.00 200.00 50.00 250.00 400.00 (150.00) 2,400.00 2,150.00 89.6%6709810 Travel- 100.00 (100.00) - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms285.18 75.00 900.00 285.18 150.00 135.18 1,050.00 764.82 72.8%Total-G&A-OTHER EXPENSES4,764.32 3,690.00 1,764.14 7,174.74 7,330.00 (155.26) 52,080.00 44,905.26 86.2%24,676.63 25,691.00 (1,014.37) 46,107.00 50,536.00 (4,429.00) 329,053.00 282,946.00 86.0%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementAugust 2017Annual Budget10 AugustFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts9,829.27 10,050.00 (220.73) 19,658.54 20,100.00 (441.46) 121,050.00 101,391.46 83.8%6800193 Equipment Leases-Maintenance 9,181.20 6,050.00 3,131.20 18,362.40 12,100.00 6,262.40 116,200.00 97,837.60 84.2%6800194 Equipment Leases-Trailer282.07 600.00 (317.93) 1,084.14 1,200.00 (115.86) 7,200.00 6,115.86 84.9%6800196 Equipment Leases-GPS3,870.00 4,700.00 (830.00) 7,740.00 9,400.00 (1,660.00) 56,400.00 48,660.00 86.3%6800197 Equipment Leases-Others2,026.71 1,150.00 876.71 4,114.20 2,300.00 1,814.20 20,200.00 16,085.80 0.0%25,189.25 22,550.00 2,639.25 50,959.28 45,100.00 5,859.28 321,050.00 270,090.72 84.1%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,652.80 8,999.00 (346.20) 17,305.60 17,998.00 (692.40) 107,987.00 90,681.40 84.0%6900210 FF&E Reserve445.41 619.00 (173.59) 892.62 1,122.00 (229.38) 59,281.00 58,388.38 98.5%6900800 Personal Property Taxes23.65 - 23.65 23.65 5,200.00 (5,176.35) 11,800.00 11,776.35 99.8%6900323 Insurance-Commercial4,574.76 2,700.00 1,874.76 8,582.37 5,400.00 3,182.37 32,400.00 23,817.63 73.5%13,696.62 12,318.00 1,378.62 26,804.24 29,720.00 (2,915.76) 211,468.00 184,663.76 87.3%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementAugust 2017Annual BudgetMonth to DateYear to Date11 SilverRock Resort-Arnold Palmer Classic Course Comp Golf Report-2017-2018 2017 2017 2017 2017 2017 2017 Comp Category July August September October November December Media Sales Promotion Golf Industry VIP Celebrity PGA Comp 20 12 Charity/Gift Certificate 2 2 Rain/Wind Checks Club Staff 53 38 LQ HS Golf 10 6 85 58 0 0 0 0 2018 2018 2018 2018 2018 2018 Comp Category January February March April May June Media Sales Promotion Golf Industry VIP Celebrity PGA Comp Charity/Gift Certificate Rain/Wind Checks Club Staff LQ HS Golf 0 0 0 0 0 0 12