Loading...
05 November 2017 SilverRock Resort - Monthly Financial Statement Monthly Financial Statements July 2017 – November 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 NovemberFinal Budget Variance Percentages Unfavorable (-) Favorable (+) Final Budget Variance Annual Budget Unemcumb. % Bdgt Income400000 Golf Green Fee Revenue301,935.88 334,335.00 (32,399.12) -9.7% 400,719.18 438,879.00 (38,159.82) 2,964,060.00 2,563,340.82 14%401000 Miscellaneous Golf Revenue39,855.00 47,903.00 (8,048.00) -16.8% 61,214.00 65,188.00 (3,974.00) 166,766.00 105,552.00 37%410000 Revenue-Golf Shop24,999.50 30,225.00 (5,225.50) -17.3% 41,376.54 46,488.00 (5,111.46) 262,017.00 220,640.46 16%420000 Revenue-F&B Concession1,500.00 1,500.00 - 0.0%4,500.00 4,500.00 - 12,000.00 7,500.00 38%890000 Interest Income0.17 - 0.17 0.17 - 0.17 - (0.17) 0%Total Income368,290.55 413,963.00 (45,672.45) -11.0% 507,809.89 555,055.00 (47,245.11) 3,404,843.00 2,897,033.11 15%Cost of Goods Sold510000 COS-Golf Shop17,375.37 16,916.50 458.87 -2.7% 27,527.98 26,019.04 (1,508.94) 146,651.00 119,123.02 19%Total COS17,375.37 16,916.50 458.87 -2.7% 27,527.98 26,019.04 (1,508.94) 146,651.00 119,123.02 19%Gross Profit350,915.18 397,046.50 (46,131.32) -11.6% 480,281.91 529,035.96 (48,754.05) 3,258,192.00 2,777,910.09 15%Expenses610000 Golf Pro Shop 15,274.51 18,516.00 (3,241.49) 17.5% 68,660.60 68,004.00 656.60 199,990.00 131,329.40 34%630000 Course Maintenance141,564.26 149,881.00 (8,316.74) 5.5% 761,997.60 838,755.00 (76,757.40) 1,735,790.00 973,792.40 44%633000 Maintenance Water & Energy16,244.27 15,369.00 875.27 -5.7% 99,773.31 102,581.00 (2,807.69) 249,838.00 150,064.69 40%640000 Outside Services32,164.42 37,279.00 (5,114.58) 13.7% 116,063.64 109,083.00 6,980.64 331,964.00 215,900.36 35%650000 Clubhouse13,174.98 13,076.00 98.98 -0.8% 56,420.79 57,280.00 (859.21) 136,412.00 79,991.21 41%660000 Marketing24,732.27 32,476.00 (7,743.73) 23.8% 76,014.03 83,139.00 (7,124.97) 230,960.00 154,945.97 33%670000 General & Administrative24,123.58 30,571.00 (6,447.42) 21.1% 115,141.91 132,222.00 (17,080.09) 329,053.00 213,911.09 35%680000 Leases24,726.12 28,800.00 (4,073.88) 14.1% 126,705.59 119,450.00 7,255.59 321,050.00 194,344.41 39%690000 Miscellaneous Other Expense28,616.71 18,386.00 10,230.71 -55.6% 91,650.80 79,073.00 12,577.80 211,468.00 119,817.20 43%Total Expenses320,621.12 344,354.00 (23,732.88) 6.9% 1,512,428.27 1,589,587.00 77,158.73 3,746,525.00 2,234,096.73 40%30,294.06 52,692.50 (22,398.44) -42.5%(1,032,146.36) (1,060,551.04) 28,404.68 (488,333.00) 543,813.36 0%Rounds of Golf PlayedPaid Rounds Played4,331 4,650 (319) -6.9%8,246 8,773 (527) 42,173 33,927 20%Ave $ Per Paid Round Green Fee69.72 71.90 (2.18) -3.0%48.60 50.03 (1.43) 70.28 21.69 69%Ave $ Per Paid Round Merchandise5.77 6.50 (0.73) -11.2%5.02 5.30 (0.28) 6.21 1.20 81%Ave $ Per Paid Miscellaneous 9.20 10.30 (1.10) -10.7%7.42 7.43 (0.01) 3.95 (3.47) 188%SilverRock ResortSummary Operating Income StatementNet IncomeMonth to DateYear to DateNovember 20171 Income NovemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4000000 Revenue-Fees301,935.88 334,335.00 (32,399.12) 400,719.18 438,879.00 (38,159.82) 2,964,060.00 2,563,340.82 86.5%4010000 Rider Fee865.00 465.00 400.00 1,340.00 878.00 462.00 7,307.00 5,967.00 81.7%4040000 Club Rental2,230.00 2,325.00 (95.00) 4,210.00 4,388.00 (178.00) 21,087.00 16,877.00 80.0%4050000 Driving Range9,000.00 15,113.00 (6,113.00) 17,239.00 18,922.00 (1,683.00) 94,872.00 77,633.00 81.8%4060000 Handicap Fees- - - - - - 2,500.00 2,500.00 100.0%4090000 Ball Retriever/Subcontract- - - - 2,000.00 (2,000.00) 4,000.00 4,000.00 100.0%4091000 Golf Professional Rental Fee 1,210.00 5,000.00 (3,790.00) 1,210.00 5,000.00 (3,790.00) 37,000.00 35,790.00 96.7%4092000 Golf Lessons - - - - - - - - 0.0%4093000 Resident Card Issue26,550.00 25,000.00 1,550.00 37,215.00 34,000.00 3,215.00 165,300.00 128,085.00 77.5% Total Revenue Fees341,790.88 382,238.00 (40,447.12) 461,933.18 504,067.00 (42,133.82) 3,296,126.00 2,834,192.82 86.0%341,790.88 382,238.00 (40,447.12) 461,933.18 504,067.00 (42,133.82) 3,296,126.00 2,834,192.82 86.0%SilverRock ResortStatement of Fees RevenueNovember 2017Total IncomeMonth to DateYear to DateAnnual Budget2 RevenuesActualBudgetVariance$39,855.00 $47,903.00 (8,048.00)Unfavorable: Due to reduced income from Golf Schools; Golf Made Simple is not teaching this year due to clubhouse relocation plans and uncertain circumstances of facilities. ActualBudgetVariance$24,999.50 $30,225.00 (5,225.50)Unfavorable: Due to reduced cost of green fees, and reduction of inventory to prepare for new season.ExpensesActualBudgetVariance$15,274.51 $18,516.00 (3,241.49)Favorable: Due to reduced payroll cost as a result of staffing levels. Additional staff will be added in the next months. ActualBudgetVariance$32,164.42 $37,279.00 (5,114.58)Unfavorable: Due to timing of range balls expense. Expense was realized in October 17'.ActualBudgetVariance$24,732.27 $32,476.00 (7,743.73)Favorable: Due to timing of invoices. We are currently in line with year to date budget.ActualBudgetVariance$24,123.58 $30,571.00 (6,447.42)Favorable: Due to less expenditures on line items to assist with reduced income of course.ActualBudgetVariance$25,471.92 $28,800.00 (3,328.08)Favorable: Due to non-receipt of property tax and our leased equipment.ActualBudgetVariance$28,616.71 $18,386.00 10,230.71Unfavorable: Due to down payment for umbrella insurance policy required down payment.Golf ShopGeneral and AdministrativeMarketingMiscellaneous Other ExpenseLeasesOutside Servicesprovided for those cost of sales percentage that are greater than 5%.Pro Shop Merchandise SalesMiscellaneous Golf RevenueVariance ExplanationNovember 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 NovemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% Budget4100000 Sales Miscellaneous495.56 - 495.56 1,515.35 - 1,515.35 00 0%4100110 Sales Hard Goods9,356.15 10,579.00 (1,222.85) 15,661.00 16,271.00 (610.00) 91,706.00 76,045.00 82.9%4100112 Sales-Soft Goods19,435.38 19,646.00 (210.62) 31,744.67 30,217.00 1,527.67 170,311.00 138,566.33 81.4%5100639 GS-Discounts-Mdse (4,287.59) - (4,287.59) (7,544.48) - (7,544.48) - 7,544.48 0.0% Total Revenue Golf Shop24,999.50 30,225.00 (5,225.50) 41,376.54 46,488.00 (5,111.46) 262,017.00 222,155.81 84.8%COS 5100150 COS-GS-Hard Goods 5,529.10 6,135.82 (606.72) 9,072.88 9,437.18 (364.30) 53,189.48 44,116.60 82.9%5100151 COS-GS-Soft Goods 11,253.43 11,394.68 (141.25) 16,808.45 17,525.86 (717.41) 97,137.52 80,329.07 82.7%5100152 COS-GS-Purchase Disc- (877.00) 877.00 (7.62) (1,349.00) 1,341.38 (7,598.00) (7,590.38) 99.9%5100220 COS-GS-Freight Merch 592.84 263.00 329.84 1,654.27 405.00 1,249.27 2,280.00 625.73 27.4%Cost of Sales - Golf Shop17,375.37 16,916.50 458.87 27,527.98 26,019.04 1,508.94 145,009.00 117,481.02 81.0%Gross Profit 7,624.13 13,308.50 (5,684.37) 13,848.56 20,468.96 (6,620.40) 117,008.00 104,674.79 89.5%COS % 69.5% 56.0% -13.5% 66.5% 56.0% -10.6% 53.1% 52.9% 99.6%Expense61-PS-SALARIES & BENEFITS6101320 Insurance Group1,514.52 2,436.00 (921.48) 9,036.04 9,744.00 (707.96) 26,796.00 17,759.96 66.3%6101325 Insurance-Workers Comp 408.40 478.00 (69.60) 2,714.74 1,679.00 1,035.74 4,957.00 2,242.26 45.2%6101720 Salaries4,000.00 4,001.00 (1.00) 20,000.00 20,005.00 (5.00) 45,000.00 25,000.00 55.6%6101800 Taxes-Employer Payroll 1,065.89 1,659.00 (593.11) 4,046.32 5,819.00 (1,772.68) 18,825.00 14,778.68 78.5%6101880 Wages-Hourly7,250.14 8,757.00 (1,506.86) 28,718.93 24,757.00 3,961.93 87,179.00 58,460.07 67.1%6101882 Wages-Overtime282.37 - 282.37 373.31 - 373.31 - 952.88 0.0%Total -PS-SALARIES & BENEFITS 14,521.32 17,331.00 (2,809.68) 64,889.34 62,004.00 2,885.34 182,757.00 119,193.85 65.2%61-PS OTHER EXPENSES6103742 Supplies-Expendable- - - - - - - - 0.0%6103762 Supplies-Office86.01 250.00 (163.99) 202.58 1,250.00 (1,047.42) 3,000.00 2,797.42 93.2%6109220 Freight & Delivery- 25.00 (25.00) 89.16 50.00 39.16 75.00 (14.16) -18.9%6109490 Miscellaneous315.27 500.00 (184.73) 1,315.27 2,500.00 (1,184.73) 6,000.00 4,684.73 78.1%6109150 Dues and Subscriptions- - - - - - 2,300.00 2,300.00 100.0%6109500 ProShop-Over/Short12.24 - 12.24 165.44 - 165.44 - (165.44) 0.0%6109722 Seminars/Training- - - - 950.00 (950.00) 3,690.00 3,690.00 100.0%6109810 Travel - Merchandise- - - - - - 90.00 90.00 100.0%6109820 Uniforms287.56 300.00 (12.44) 1,356.13 700.00 656.13 2,400.00 1,043.87 43.5%6117840 Telephones52.11 110.00 (57.89) 642.68 550.00 92.68 1,320.00 677.32 51.3%753.19 1,185.00 (431.81) 3,771.26 6,000.00 (2,228.74) 18,875.00 15,103.74 80.0%15,274.51 18,516.00 (3,241.49) 68,660.60 68,004.00 656.60 201,632.00 134,297.59 66.6%Net Income(7,650.38) (5,207.50) (2,442.88) (54,812.04) (47,535.04) (7,277.00) (84,624.00) (29,622.80) 35.0%SilverRock ResortGolf Shop Income StatementNovember 2017Total Expenses-Golf ShopMonth to DateYear to DateAnnual Budget4 NovemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense63-CM-SALARIES & BENEFITS6311320 Insurance-Group7,574.62 9,165.00 (1,590.38) 37,542.78 38,865.00 (1,322.22) 103,020.00 65,477.22 63.6%6311325 Insurance-Workers Comp1,980.70 2,276.00 (295.30) 12,338.62 10,890.00 1,448.62 26,974.00 14,635.38 54.3%6311720 Salaries11,748.74 12,200.00 (451.26) 57,977.06 61,000.00 (3,022.94) 146,400.00 88,422.94 60.4%6311800 Taxes-Employer Payroll6,497.54 7,891.00 (1,393.46) 23,631.58 38,285.00 (14,653.42) 91,481.00 67,849.42 74.2%6311880 Wages-Hourly44,667.83 48,500.00 (3,832.17) 209,875.97 221,120.00 (11,244.03) 567,262.00 357,386.03 63.0%6311882 Wages-Overtime12,391.32 - 12,391.32 42,739.60 12,350.00 30,389.60 12,350.00 (30,389.60) -246.1%Total-CM-SALARIES & BENEFITS84,860.75 80,032.00 4,828.75 384,105.61 382,510.00 1,595.61 947,487.00 563,381.39 59.5%63-CM-SUPPLIES & MATERIALS6313734 Chemicals- 2,100.00 (2,100.00) 14,206.49 26,441.00 (12,234.51) 17,760.00 3,553.51 20.0%6313744 Fertilizer20,015.10 10,650.00 9,365.10 34,005.87 58,060.00 (24,054.13) 105,970.00 71,964.13 67.9%6313745 Herbicides351.25 - 351.25 5,089.82 - 5,089.82 25,518.00 20,428.18 80.1%6313746 Flowers/Plants- - - 1,650.42 1,250.00 400.42 3,050.00 1,399.58 45.9%6313748 Fuel-Gasoline2,390.30 5,070.00 (2,679.70) 14,378.25 21,470.00 (7,091.75) 48,950.00 34,571.75 70.6%6313750 Golf Course Accessories2,747.26 - 2,747.26 11,366.01 12,300.00 (933.99) 13,140.00 1,773.99 13.5%6313756 POA Control- - - - 2,400.00 (2,400.00) 9,900.00 9,900.00 100.0%6313758 Miscellaneous Supp2,162.82 500.00 1,662.82 3,844.81 3,250.00 594.81 4,350.00 505.19 11.6%6313762 Supplies-Office- - - 54.00 - 54.00 - (54.00) 0.0%6313774 Sand1,561.97 4,000.00 (2,438.03) 3,811.98 11,780.00 (7,968.02) 13,460.00 9,648.02 71.7%6313776 Seed- 11,900.00 (11,900.00) 104,427.63 117,400.00 (12,972.37) 117,400.00 12,972.37 11.0%6313778 Small Tools & Non-Capital Equip97.54 100.00 (2.46) 241.53 4,300.00 (4,058.47) 5,000.00 4,758.47 95.2%6313780 Sod1,309.35 - 1,309.35 7,479.11 8,800.00 (1,320.89) 13,500.00 6,020.89 44.6%6313782 Topdressing- 2,600.00 (2,600.00) 6,473.47 7,000.00 (526.53) 10,000.00 3,526.53 35.3%Total-CM-SUPPLIES & MATERIALS30,635.59 36,920.00 (6,284.41) 207,029.39 274,451.00 (67,421.61) 387,998.00 180,968.61 46.6%63-CM-REPAIRS & MAINTENANCE6315095 CM-R&M-Contract Lake Maint3,840.00 2,830.00 1,010.00 18,104.24 14,150.00 3,954.24 33,960.00 15,855.76 46.7%6315685 CM-R&M-Bldngs & Othr Structures 268.07 500.00 (231.93) 2,304.73 3,550.00 (1,245.27) 5,550.00 3,245.27 58.5%6315690 CM-R&M-Equipment1,814.86 5,000.00 (3,185.14) 19,161.71 22,500.00 (3,338.29) 38,500.00 19,338.29 50.2%6315692 CM-R&M-Irrigation System593.54 900.00 (306.46) 11,748.79 12,300.00 (551.21) 19,050.00 7,301.21 38.3%6315696 CM-R&M-Pumps164.19 1,000.00 (835.81) 1,640.67 5,000.00 (3,359.33) 10,500.00 8,859.33 84.4%6315815 CM-R&M-Trees-Pruning Etc- - - 6,680.00 6,050.00 630.00 12,050.00 5,370.00 44.6%Total-CM-REPAIRS & MAINTENANCE6,680.66 10,230.00 (3,549.34) 59,640.14 63,550.00 (3,909.86) 119,610.00 59,969.86 50.1%6317836 Utilities-Natural Gas/LPG 38.49 15.00 23.49 115.88 75.00 40.88 180.00 64.12 0.0%6317840 Telephones802.85 850.00 (47.15) 5,142.62 4,250.00 892.62 10,200.00 5,057.38 49.6%Total-CM-UTILITIES841.34 865.00 (23.66) 5,258.50 4,325.00 933.50 10,380.00 5,121.50 49.3%63-CM-OTHER EXPENSES6319020 Auto Mileage/Allowance400.00 400.00 - 2,000.00 2,000.00 - 4,800.00 2,800.00 58.3%6319100 Contract Svcs-Soil/Tissue Test- - - - 1,000.00 (1,000.00) 2,000.00 2,000.00 100.0%6319102 Contract Svcs-Trash Removal- 524.00 (524.00) - 2,620.00 (2,620.00) 6,288.00 6,288.00 100.0%6319150 Dues & Subscriptions- - - 210.00 - 210.00 680.00 470.00 69.1%6319170 Employee Education- 50.00 (50.00) - 250.00 (250.00) 3,900.00 3,900.00 100.0%6319197 Equipment Rental- 600.00 (600.00) 1,785.29 2,100.00 (314.71) 3,400.00 1,614.71 47.5%6319206 Licenses & Permits- - - 239.29 350.00 (110.71) 4,300.00 4,060.71 94.4%6319490 Miscellaneous- 100.00 (100.00) 53.37 500.00 (446.63) 1,200.00 1,146.63 95.6%6319718 Safety Equipment & Training412.56 500.00 (87.44) 1,130.86 2,350.00 (1,219.14) 3,850.00 2,719.14 70.6%6319822 Uniforms705.92 920.00 (214.08) 3,272.11 4,600.00 (1,327.89) 11,040.00 7,767.89 70.4%Total-CM-OTHER EXPENSES1,518.48 3,094.00 (1,575.52) 8,690.92 15,770.00 (7,079.08) 41,458.00 32,767.08 79.0%SilverRock ResortCourse Maintenance Expense StatementNovember 2017Annual BudgetMonth to DateYear to Date5 SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget632-CM-LANDSCAPE MAINTENANCE632-CM-LM-SALARIES & BENEFITS6321320 Insurance-Group 2,630.27 2,784.00 (153.73) 21,103.48 13,920.00 7,183.48 33,408.00 12,304.52 36.8%6321325 Insurance-Workers Comp407.20 484.00 (76.80) 2,686.08 2,537.00 149.08 5,955.00 3,268.92 54.9%6321800 Taxes-Employer Payroll1,376.44 1,678.00 (301.56) 5,759.91 8,944.00 (3,184.09) 20,793.00 15,033.09 72.3%6321880 Wages-Hourly11,673.60 12,904.00 (1,230.40) 62,220.74 65,380.00 (3,159.26) 156,528.00 94,307.26 60.2%6321882 Wages-Overtime939.93 - 939.93 1,541.49 3,418.00 (1,876.51) 3,418.00 1,876.51 54.9%Total-CM-LM-SALARIES & BENEFITS17,027.44 17,850.00 (822.56) 93,311.70 94,199.00 (887.30) 220,102.00 126,790.30 57.6%632-CM-LM-SUPPLIES & MATERIALS6323778 Small Tools- 100.00 (100.00) 386.77 500.00 (113.23) 1,025.00 638.23 62.3%6323788 Uniforms- 290.00 (290.00) 360.87 1,450.00 (1,089.13) 3,480.00 3,119.13 89.6%Total-CM-LM-SUPPLIES & MATERIALS- 390.00 (390.00) 747.64 1,950.00 (1,202.36) 4,505.00 3,757.36 83.4%632-CM-LM-REPAIRS & MAINTENANCE6325687 CM-LM-R&M-Drip Irrigation- 500.00 (500.00) 3,213.70 2,000.00 1,213.70 4,250.00 1,036.30 24.4%Total-CM-LM-REPAIRS & MAINTENANCE- 500.00 (500.00) 3,213.70 2,000.00 1,213.70 4,250.00 1,036.30 24.4%141,564.26 149,881.00 (8,316.74) 761,997.60 838,755.00 (76,757.40) 1,735,790.00 973,792.40 56.1% SeptemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%Budget633-CM-WATER & ENERGY6337834 Utilities-Electricity-Pumping 9,925.12 10,650.00 (724.88) 56,604.83 63,700.00 (7,095.17) 179,791.00 123,186.17 68.5%6337842 Utilities-Water6,319.15 4,719.00 1,600.15 43,168.48 38,881.00 4,287.48 70,047.00 26,878.52 38.4%16,244.27 15,369.00 875.27 99,773.31 102,581.00 (2,807.69) 249,838.00 150,064.69 60.1%Silverrock ResortCourse Maintenance Water & EnergySeptember 2017Total-CM-WATER & ENERGYMonth to DateYear to DateAnnual BudgetTotal-COURSE MAINTENANCECourse Maintenance Expense StatementSeptember 2017Silverrock ResortAnnual BudgetMonth to DateYear to Date6 NovemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense641-CBR-SALARIES & BENEFITS6411320 Insurance-Group- 696.00 (696.00) - 3,480.00 (3,480.00) 8,352.00 8,352.00 100.0%6411325 Insurance-Workers Comp409.01 466.00 (56.99) 3,205.17 1,591.00 1,614.17 5,623.00 2,417.83 43.0%6411800 Taxes-Employer Payroll1,395.94 1,548.00 (152.06) 3,692.44 5,284.00 (1,591.56) 18,667.00 14,974.56 80.2%6411880 Wages-Hourly10,687.79 12,435.00 (1,747.21) 37,686.70 42,445.00 (4,758.30) 149,934.00 112,247.30 74.9%6411882 Wages-Overtime 117.96 - 117.96 190.35 - 190.35 - (190.35) 0.0%Total-CBR-SALARIES & BENEFITS12,610.70 15,145.00 (2,534.30) 44,774.66 52,800.00 (8,025.34) 182,576.00 137,801.34 75.5%641-CBR-SUPPLIES & MATERIALS6413732 Supplies-Carts- 500.00 (500.00) - 1,000.00 (1,000.00) 1,850.00 `0.0%6413742 Supplies-Expendable114.19 1,800.00 (1,685.81) 1,530.36 3,300.00 (1,769.64) 6,750.00 5,219.64 77.3%6413748 Supplies-Fuel for Shuttle- 300.00 (300.00) - 500.00 (500.00) 3,000.00 3,000.00 100.0%6413752 Supplies-Range Balls- 9,000.00 (9,000.00) 10,766.25 9,000.00 1,766.25 9,000.00 (1,766.25) -19.6%6413762 Supplies-Office- 50.00 (50.00) - 175.00 (175.00) 525.00 525.00 100.0%6413768 Supplies-Printing and Stationary- - - - - - 420.00 420.00 100.0%6413786 Supplies-Towels 498.35 185.00 313.35 1,378.35 665.00 713.35 2,182.00 803.65 36.8%6413796 Supplies-Bottled Water5,386.75 200.00 5,186.75 5,817.75 4,900.00 917.75 12,900.00 7,082.25 54.9%Total-CBR-SUPPLIES & MATERIALS5,999.29 12,035.00 (6,035.71) 19,492.71 19,540.00 (47.29) 36,627.00 15,284.29 41.7%641-CBR-REPAIRS & MAINTENANCE6415690 CBR-R&M-Equipment4,406.21 300.00 4,106.21 22,280.89 1,500.00 20,780.89 3,600.00 (18,680.89) -518.9%6415695 CBR-R&M-Cart Maintenance & Repair- 500.00 (500.00) 500.00 2,950.00 (2,450.00) 6,450.00 5,950.00 92.2%Total-CBR-REPAIRS & MAINTENANCE4,406.21 800.00 3,606.21 22,780.89 4,450.00 18,330.89 10,050.00 (12,730.89) -126.7%641-CBR-OTHER EXPENSES6419094 Contract Services-Laundry/Linen1,316.56 800.00 516.56 3,200.43 4,000.00 (799.57) 9,600.00 6,399.57 66.7%6419220 Freight/Delivery- 75.00 (75.00) - 375.00 (375.00) 450.00 450.00 100.0%6419490 Miscellaneous943.53 600.00 343.53 1,494.44 3,000.00 (1,505.56) 7,200.00 5,705.56 79.2%6419820 Uniforms - 500.00 (500.00) - 2,500.00 (2,500.00) 5,200.00 5,200.00 100.0%Total-CBR-OTHER EXPENSES2,260.09 1,975.00 285.09 4,694.87 9,875.00 (5,180.13) 22,450.00 17,755.13 79.1%TOTAL-CARTS,BAGROOM & RANGE25,276.29 29,955.00 285.09 91,743.13 86,665.00 5,078.13 251,703.00 158,109.87 62.8%643-CS-SALARIES & BENEFITS6431320 Insurance-Group- - - - - - - - 0.0%6431325 Insurance-Workers Comp207.20 226.00 (18.80) 1,890.06 659.00 1,231.06 2,450.00 559.94 22.9%6431800 Taxes-Employer Payroll751.16 785.00 (33.84) 1,698.81 2,290.00 (591.19) 8,494.00 6,795.19 80.0%6431880 Wages-Hourly5,538.27 6,038.00 (499.73) 16,752.36 17,619.00 (866.64) 65,341.00 48,588.64 74.4%6431882 Wages-Overtime - - - - - - - - 0.0%Total-CS-SALARIES & BENEFITS6,496.63 7,049.00 (552.37) 20,341.23 20,568.00 (226.77) 76,285.00 55,943.77 73.3%643-CS-OTHER EXPENSES6433742 Supplies Expendable- 100.00 (100.00) - 400.00 (400.00) 1,050.00 1,050.00 100.0%6439490 Miscellaneous- 50.00 (50.00) - 100.00 (100.00) 200.00 200.00 100.0%6439718 Safety Equipment & Training- 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0%6439820 Uniforms 391.50 75.00 316.50 3,979.28 1,100.00 2,879.28 2,125.00 (1,854.28) -87.3%Total-CS-OTHER EXPENSES391.50 275.00 116.50 3,979.28 1,850.00 2,129.28 3,975.00 (4.28) -0.1%Total-COURSE SERVICES 6,888.13 7,324.00 (435.87) 24,320.51 22,418.00 1,902.51 80,260.00 55,939.49 69.7%32,164.42 37,279.00 (5,114.58) 116,063.64 109,083.00 6,980.64 331,963.00 214,053.64 64.5%TOTAL OUTSIDE SERVICESMonth to DateYear to DateSilverRock ResortOutside Services Expense StatementNovember 2017Annual Budget7 NovemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.%BudgetExpense65-CH-SUPPLIES & MATERIALS6503742 Supplies-Expendable 400.00 400.00 - 2,000.00 2,000.00 - 4,800.00 2,800.00 58.3%Total-CH-SUPPLIES & MATERIALS400.00 400.00 - 2,000.00 2,000.00 - 4,800.00 2,800.00 58.3%65-CH-UTILITIES6507836 Utilities-Natural Gas315.73 300.00 15.73 1,600.06 1,500.00 100.06 3,600.00 1,999.94 55.6%6507840 Utilities-Telephone1,092.36 1,150.00 (57.64) 4,342.01 5,750.00 (1,407.99) 13,800.00 9,457.99 68.5%6507842 Utilities-Water- 321.00 (321.00) 1,616.41 1,605.00 11.41 3,852.00 2,235.59 58.0%6507844 Utilities-Cable494.41 380.00 114.41 2,464.23 1,900.00 564.23 4,560.00 2,095.77 46.0%Total-CH-UTILITIES1,902.50 2,151.00 (248.50) 10,022.71 10,755.00 (732.29) 25,812.00 15,789.29 61.2%65-CH-OTHER EXPENSES6509091 Contract Services-Cleaning 1,825.00 1,825.00 - 9,235.00 9,725.00 (490.00) 22,500.00 13,265.00 59.0%6509099 Contract Services-Security4,967.04 5,000.00 (32.96) 26,181.58 25,000.00 1,181.58 60,000.00 33,818.42 56.4%6509215 Flowers & Decorations- - - - 500.00 (500.00) 1,900.00 1,900.00 100.0%6509490 Miscellaneous777.90 2,500.00 (1,722.10) 777.90 3,300.00 (2,522.10) 7,000.00 6,222.10 88.9%6509718 Safety Equipment & Training- 100.00 (100.00) - 500.00 (500.00) 1,200.00 1,200.00 100.0%Total-CH-OTHER EXPENSES7,569.94 9,425.00 (1,855.06) 36,194.48 39,025.00 (2,830.52) 92,600.00 56,405.52 60.9%65-CH-REPAIRS & MAINTENANCE6515685 CH-R&M-Building Structures868.60 300.00 568.60 4,637.06 1,500.00 3,137.06 3,600.00 (1,037.06) -28.8%6515686 CH-R&M-Restaurant Repairs 1,256.84 400.00 856.84 1,256.84 2,000.00 (743.16) 4,800.00 3,543.16 73.8%6515690 CH-R&M-Equipment Repair1,177.10 400.00 777.10 2,309.70 2,000.00 309.70 4,800.00 2,490.30 51.9%Total-CH-REPAIRS & MAINTENANCE3,302.54 1,100.00 2,202.54 8,203.60 5,500.00 2,703.60 13,200.00 4,996.40 37.9%13,174.98 13,076.00 98.98 56,420.79 57,280.00 (859.21) 136,412.00 9,992.80 7.3%Total CLUBHOUSEMonth to DateYear to DateSilverRock ResortClubhouse Expense StatementNovember 2017Annual Budget8 NovemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense66-MKT-SALARIES & BENEFITS6601320 Insurance-Group 351.02 348.00 3.02 2,103.10 1,740.00 363.10 4,176.00 2,072.90 49.6%6601325 Insurance-Workers Comp92.80 94.00 (1.20) 478.00 470.00 8.00 1,129.00 651.00 57.7%6601720 Salaries1,904.96 2,508.00 (603.04) 9,524.80 12,540.00 (3,015.20) 30,096.00 20,571.20 68.4%6601800 Taxes-Employer Payroll145.20 326.00 (180.80) 726.00 1,630.00 (904.00) 3,912.00 3,186.00 81.4%Total-MKT-SALARIES & BENEFITS2,493.98 3,276.00 (782.02) 12,831.90 16,380.00 (3,548.10) 39,313.00 26,481.10 67.4%66-MKT-SUPPLIES & MATERIALS6603762 Supplies-Office - 100.00 (100.00) 460.51 500.00 (39.49) 1,200.00 739.49 61.6%6603768 Supplies-Printing & Stationery 371.99 200.00 171.99 1,800.47 3,400.00 (1,599.53) 4,425.00 2,624.53 59.3%371.99 300.00 71.99 2,260.98 3,900.00 (1,639.02) 5,625.00 3,364.02 59.8%66-MKT-UTILITIES6607840 Utilities-Telephone 164.69 100.00 64.69 699.07 500.00 199.07 1,200.00 500.93 41.7%Total-MKT-UTILITIES164.69 100.00 64.69 699.07 500.00 199.07 1,200.00 500.93 41.7%66-MKT-OTHER EXPENSES6609010 Advertising21,319.07 26,175.00 (4,855.93) 56,992.36 57,684.00 (691.64) 169,987.00 112,994.64 66.5%6609040 Business Meals- 25.00 (25.00) - 125.00 (125.00) 300.00 300.00 100.0%6609080 Collateral Material283.54 1,000.00 (716.46) 283.54 1,500.00 (1,216.46) 5,500.00 5,216.46 94.8%6609102 Contract Services-Web Page99.00 150.00 (51.00) 396.00 750.00 (354.00) 1,800.00 1,404.00 78.0%6609490 Miscellaneous- 50.00 (50.00) - 50.00 (50.00) 350.00 350.00 100.0%6609620 Postage- 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0%6609630 Promotion- 50.00 (50.00) 2,064.31 100.00 1,964.31 700.00 (1,364.31) -194.9%6609633 Promotion-Community- 750.00 (750.00) 485.87 1,050.00 (564.13) 2,250.00 1,764.13 78.4%6609634 Promotion-Media/Vendor- 500.00 (500.00) - 500.00 (500.00) 2,000.00 2,000.00 100.0%6609150 Dues and Subscriptions- - - - - - 735.00 735.00 100.0%6609820 Uniforms- 50.00 (50.00) - 350.00 (350.00) 600.00 600.00 100.0%Total-MKT-OTHER EXPENSES21,701.61 28,800.00 (7,098.39) 60,222.08 62,359.00 (2,136.92) 184,822.00 124,599.92 67.4%24,732.27 32,476.00 (7,743.73) 76,014.03 83,139.00 (7,124.97) 230,960.00 154,945.97 67.1%Total-MARKETINGMonth to DateYear to DateSilverRock ResortMarketing Expense StatementNovember 2017Annual Budget9 NovemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense67-G&A-SALARIES & BENEFITS6701320 Insurance-Group2,041.33 1,509.00 532.33 8,873.62 7,545.00 1,328.62 18,108.00 9,234.38 51.0%6701325 Insurance-Workers Comp780.00 677.00 103.00 3,263.88 3,161.00 102.88 7,905.00 4,641.12 58.7%6701720 Salaries12,800.00 15,050.00 (2,250.00) 64,000.00 70,450.00 (6,450.00) 177,996.00 113,996.00 64.0%6701800 Taxes-Employer Payroll1,844.49 2,349.00 (504.51) 6,439.57 10,965.00 (4,525.43) 32,800.00 26,360.43 80.4%6701880 Wages-Hourly2,846.42 3,016.00 (169.58) 11,712.90 13,876.00 (2,163.10) 27,404.00 15,691.10 57.3%6701882 Wages-Overtime- - - - - - - - 0.0%Total-G&A-SALARIES & BENEFITS20,312.24 22,601.00 (2,288.76) 94,289.97 105,997.00 (11,707.03) 264,213.00 169,923.03 64.3%67-G&A-SUPPLIES & MATERIALS6703740 Supplies-Computer- 500.00 (500.00) 2,419.07 2,500.00 (80.93) 6,300.00 3,880.93 61.6%6703762 Supplies-Office113.22 105.00 8.22 208.35 525.00 (316.65) 1,260.00 1,051.65 83.5%6703768 Supplies-Printing & Stationery180.38 100.00 80.38 939.73 500.00 439.73 3,300.00 2,360.27 71.5%Total-G&A-SUPPLIES & MATERIALS293.60 705.00 (411.40) 3,567.15 3,525.00 42.15 10,860.00 7,292.85 67.2%67-G&A-REPAIRS & MAINTENANCE6705690 Repairs & Maintenance-Equipment- 900.00 (900.00) - 1,200.00 (1,200.00) 1,900.00 1,900.00 100.0%Total-G&A-REPAIRS & MAINTENANCE- 900.00 (900.00) - 1,200.00 (1,200.00) 1,900.00 1,900.00 100.0%67-G&A-OTHER EXPENSES6709020 Auto/Mileage Allowance500.00 500.00 - 2,500.00 2,500.00 - 6,000.00 3,500.00 58.3%6709150 Dues & Subscriptions- 50.00 (50.00) 420.00 350.00 70.00 1,150.00 730.00 63.5%6709180 Employee Recruiting/Relocation- 150.00 (150.00) 251.95 450.00 (198.05) 1,200.00 948.05 79.0%6709197 Equipment Rental485.37 550.00 (64.63) 2,718.16 2,750.00 (31.84) 6,600.00 3,881.84 58.8%6709202 Fees-Bank818.56 90.00 728.56 1,367.04 450.00 917.04 1,080.00 (287.04) -26.6%6709208 Fees-Payroll Processing312.15 1,000.00 (687.85) 2,821.53 5,000.00 (2,178.47) 12,000.00 9,178.47 76.5%6709220 Freight/Delivery- 50.00 (50.00) - 250.00 (250.00) 600.00 600.00 100.0%6709490 Miscellaneous- 2,600.00 (2,600.00) 157.32 3,000.00 (2,842.68) 6,600.00 6,442.68 97.6%6709491 Loss/Damage- - - - - - - 0.0%6709620 Postage/Mail Services251.37 75.00 176.37 782.96 375.00 407.96 900.00 117.04 13.0%6709625 Professional Fees849.60 850.00 (0.40) 4,521.70 4,250.00 271.70 10,200.00 5,678.30 55.7%6709636 Promotion/Entertainment- 100.00 (100.00) 138.18 500.00 (361.82) 1,200.00 1,061.82 88.5%6709722 Seminars & Training- 200.00 (200.00) 1,020.08 1,000.00 20.08 2,400.00 1,379.92 57.5%6709810 Travel- - - - 100.00 (100.00) 1,100.00 1,100.00 100.0%6709820 Uniforms300.69 150.00 900.00 585.87 525.00 60.87 1,050.00 464.13 44.2%Total-G&A-OTHER EXPENSES3,517.74 6,365.00 (2,097.95) 17,284.79 21,500.00 (4,215.21) 52,080.00 34,795.21 66.8%24,123.58 30,571.00 (6,447.42) 115,141.91 132,222.00 (17,080.09) 329,053.00 213,911.09 65.0%Total-GENERAL & ADMINISTRATIVEMonth to DateYear to DateSilverRock ResortGeneral & Administrative Expense StatementNovember 2017Annual Budget10 NovemberFinal Budget Variance Final Budget Variance Annual BudgetUnemcumb.% BudgetExpense68-LEASES6800192 Equipment Leases-Carts9,829.27 10,050.00 (220.73) 49,146.35 50,700.00 (1,553.65) 121,050.00 71,903.65 59.4%6800193 Equipment Leases-Maintenance 9,181.20 11,500.00 (2,318.80) 45,906.00 35,700.00 10,206.00 116,200.00 70,294.00 60.5%6800194 Equipment Leases-Trailer583.07 600.00 (16.93) 2,808.67 3,000.00 (191.33) 7,200.00 4,391.33 61.0%6800196 Equipment Leases-GPS3,870.00 4,700.00 (830.00) 19,350.00 23,500.00 (4,150.00) 56,400.00 37,050.00 65.7%6800197 Equipment Leases-Others1,262.58 1,950.00 (687.42) 9,494.57 6,550.00 2,944.57 20,200.00 10,705.43 0.0%24,726.12 28,800.00 (4,073.88) 126,705.59 119,450.00 7,255.59 321,050.00 194,344.41 60.5%69-MISC OTHER EXPENSES6900096 Contract Srvcs-Management Fee 8,652.80 8,999.00 (346.20) 43,764.00 44,995.00 (1,231.00) 107,987.00 64,223.00 59.5%6900210 FF&E Reserve6,038.72 6,687.00 (648.28) 8,014.40 8,778.00 (763.60) 59,281.00 51,266.60 86.5%6900800 Personal Property Taxes- - - 15,095.97 11,800.00 3,295.97 11,800.00 (3,295.97) -27.9%6900323 Insurance-Commercial13,925.19 2,700.00 11,225.19 24,776.43 13,500.00 11,276.43 32,400.00 7,623.57 23.5%28,616.71 18,386.00 10,230.71 91,650.80 79,073.00 12,577.80 211,468.00 119,817.20 56.7%Total-LEASESTotal-MISC OTHER EXPENSESSilverrock ResortOperating Leases & Miscellaneous Other Expense StatementNovember 2017Annual BudgetMonth to Date Year to Date11 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2017-20182017 2017 2017 2017 2017 2017Comp CategoryJulyAugustSeptemberOctoberNovemberDecemberMedia13SalesPromotionGolf IndustryVIPCelebrityPGA Comp20 12 275Charity/Gift Certificate2213Rain/Wind ChecksClub Staff53 38 65 16 32LQ HS Golf10663885 58 98 19 7102018 2018 2018 2018 2018 2018Comp CategoryJanuaryFebruaryMarchAprilMayJuneMediaSalesPromotionGolf IndustryVIPCelebrityPGA CompCharity/Gift CertificateRain/Wind ChecksClub StaffLQ HS Golf00000012 SilverRock Resort-Arnold Palmer Classic CourseComp Golf Report-2017-2018November 2017 Date TimeDescriptionCategoryPlayers11/11/2017 7:45:00 AM Jason Kosky-Locale MagazineMedia411/18/2017 8:08:00 AM John Young, Golf Digest RaterPromo111/26/2017 11:23:00 AM Blake Arthor, KESQ Sports Director and News Anchors Media411/28/2017 11:38:00 AM Judd Spicer, Golf WriterPromo413