Use the data from various tabs of the Trend Report to fill in answers on the following table. For full marks, you must include numbers to support your evaluations.
Hotel Industry Performance Reports Module 4 Exercise – Assessment 7 Due: Sunday, July 12 by midnight Hotel Industry Performance Reports Module 4 Exercise – Assessment 7 Total marks: ___ / 27 Application 5 continued Use the data from various tabs of the Trend Report to fill in answers on the following table. For full marks, you must include numbers to support your evaluations. What was the 12MMA Occupancy, ADR, and RevPAR for the last full year shown in the report? – 3pt What was the percent change in Supply, Demand and Revenue from the first full year (total year) shown in the report to the last full year (total year) shown? – 3pt Was the YTD (year-to-date) Occupancy higher or lower in 2015 than in 2017? – 2pt In September 2017, which day of the week had the highest ADR? – 1pt What was the Occupancy, ADR and RevPAR on January 1, 2017? Did each increase or decrease from the prior year? – 6pts © 2019 STR. All Rights Reserved. Application 6 continued Use the data from various pages of the Pipeline Report to fill in answers on the following table. For full marks, you must include numbers to support your evaluations. Which scale had the most growth in the last 5 years? – 2pt Which scale has the most rooms In Construction? – 2pt Which scale has the largest number of existing rooms? – 2pt Which scale will have the largest number of existing rooms? – 2pt Which brand has the most rooms Recently Opened? – 2pt Which brand(s) had the largest net change in the last 5 years? – 2pt © 2019 STR. All Rights Reserved. Table of Contents HOST Job #: 121513 / Date Created: Oct 30, 2017 Custom HOST Report Nashville - Select Full Service Hotels Data for End of 2016 & 2015 Table of Contents1 Summary2 Revenue3 Departmental Expenses4 Undistrib Operating Expenses5 Selected Fixed Charges6 Participation Report7 Definitions8 Help9 735 East Main Street, Hendersonville, TN 37075 USABlue Fin Building, 110 Southwark Street, London SE1 0TA T : +1 615 824 8664T : +44 (0)20 7922 1930
[email protected] [email protected] www.str.com The STR Custom HOST Report is a publication of STR, Inc. and STR Global, Ltd., and is intended solely for use by paid subscribers. Reproduction or distribution of the STR Complimentary HOST Participant Report, in whole or part, without written permission is prohibited and subject to legal action. If you have received this report and are NOT a subscriber to the STR Complimentary HOST Participant Report, please contact us immediately. Source: 2017 STR, Inc. / STR Global, Ltd. trading as "STR". Summary 2016Props:112015Props:11 Rooms:4,069Rooms:4,069 Occupancy:80.8%Occupancy:78.9% ADR:$195.71ADR:$195.69 RevPAR:$158.19RevPAR:$154.48 TrevPAR:$240.00TrevPAR:$237.83 2017 Custom HOST ReportGOPPAR:$110.95GOPPAR:$104.63 Summary Currency:USD20162015Variance % Ratio to Sales 1Amount Per Available RoomAmount Per Occupied Room NightRatio to Sales 1Amount Per Available RoomAmount Per Occupied Room NightAmount Per Available RoomAmount Per Occupied Room Night REVENUE%$$%$$%% Rooms65.9%$ 56,029$ 195.7165.0%$ 56,328$ 195.69(0.5)%0.0% Food18.115,40553.8118.916,41757.04(6.2)(5.7) Beverage4.63,93813.764.74,07514.16(3.4)(2.8) Other Food & Beverage5.94,98117.405.85,05517.56(1.5)(0.9) Other Operated Departments1.71,4184.952.11,8226.33(22.1)(21.8) Miscellaneous Income3.83,23711.303.53,02610.506.97.6 TOTAL REVENUE100.0%$ 85,007$ 296.93100.0%$ 86,723$ 301.29(2.0)%(1.4)% DEPARTMENTAL EXPENSES Rooms18.9%$ 10,579$ 36.9520.2%$ 11,376$ 39.52(7.0)%(6.5)% Food & Beverage58.714,27749.8760.915,55154.03(8.2)(7.7) Other Operated Departments102.01,4475.0685.71,5605.42(7.2)(6.6) TOTAL DEPARTMENTAL EXPENSES30.9%$ 26,304$ 91.8832.8%$ 28,487$ 98.97(7.7)%(7.2)% DEPARTMENTAL PROFITS Rooms81.1%$ 45,449$ 158.7579.8%$ 44,952$ 156.171.1%1.7% Food & Beverage41.310,04635.0939.19,99634.730.51.0 Other Operated Departments(2.0)(29)(0.10)14.32610.91(111.1)(111.0) TOTAL DEPARTMENTAL PROFITS69.1%$ 58,703$ 205.0567.2%$ 58,235$ 202.320.8%1.3% UNDISTRIBUTED OPERATING EXPENSES Administrative & General6.7%5,69519.897.1%6,15821.39(7.5)%(7.0)% Information & Telecommunications Systems1.29853.440.54621.60113.3115.0 Marketing (excluding Franchise Fees)7.76,51522.767.76,63923.06(1.9)(1.3) Franchise Fees (royalty and marketing)1.08462.961.09103.16(7.0)(6.3) Utility Costs3.32,7739.693.53,04210.57(8.8)(8.3) Property Operation & Maintenance3.02,5929.063.32,8719.98(9.7)(9.2) TOTAL UNDISTRIBUTED OPERATING EXPENSES22.8$ 19,407$ 67.7923.2%$ 20,082$ 69.77(3.4)%(2.8)% GROSS OPERATING PROFIT46.2%$ 39,296$ 137.2644.0%$ 38,153$ 132.553.0%3.6% Base Management Fees2.9$ 2,505$ 8.752.9$ 2,510$ 8.72(0.2)0.3 Incentive Management Fees0.86732.350.54301.4956.657.7 INCOME BEFORE FIXED CHARGES42.5%$ 36,118$ 126.1640.6%$ 35,214$ 122.342.6%3.1% SELECTED FIXED CHARGES Non-Operating Income2.9%$ 6,556$ 22.002.8%$ 7,485$ 25.63(12.4)%(14.2)% Rent3.1$ 2,656$ 9.285.3$ 4,619$ 16.05(42.5)(42.2) Property Taxes1.81,5465.401.61,4174.929.19.8 Insurance0.43201.120.43161.101.31.8 EBITDA34.3%$ 29,120$ 101.7230.5%$ 26,410$ 91.7610.3%10.9% Reserve For Capital Replacement1.81,5595.441.71,4465.027.88.4 SUPPLEMENTAL PAYROLL ANALYSIS 3 Rooms10.5%$ 5,866$ 20.4911.4%$ 6,414$ 22.28(8.5)%(8.0)% Food and Beverage31.97,76327.1133.38,50229.54(8.7)(8.2) Other Operated Departments80.31,6455.8076.11,5265.307.89.4 Administrative & General3.12,6569.283.32,8379.85(6.4)(5.8) Information & Telecommunications0.32630.920.32390.8210.312.2 Marketing2.11,8266.382.31,9666.83(7.1)(6.6) Property Operations & Maintenance1.41,2014.201.51,2924.49(7.0)(6.5) TOTAL LABOR COSTS24.1%$ 20,462$ 71.4725.4%$ 22,055$ 76.62(7.2)%(6.7)% SUPPLEMENTAL FOOD & BEVERAGE INFORMATION 3 Cost of Food Sales25.0%$ 3,848$ 13.4425.4%$ 4,168$ 14.48(7.7)%(7.2)% Cost of Beverage Sales20.68102.8321.88883.08(8.7)(8.1) Total Cost of F&B Sales19.1%$ 4,658$ 16.2719.8%$ 5,056$ 17.57(7.9)%(7.4)% Food & Beverage Labor31.9%$ 7,763$ 27.1133.3%$ 8,502$ 29.54(8.7)%(8.2)% Food & Beverage Other Expenses7.6%$ 1,857$ 6.497.8%$ 1,993$ 6.93(6.8)%(6.3)% 1 Ratio to Sales for departmental expenses and profits are based on their respective departmental revenues. All other expense ratios are based on total revenue. 2 EBITDA does not include Depreciation and Amortization, Interest, nor Income Taxes 3 Labor and Costs of Sales are included in expenses. Amounts shown here are for additional detail only. Not all participants provide detailed data on payroll and F&B costs; therefore, the following supplemental analyses provide the ratios for only these hotels in the samples that reported detailed information. Consequently, the amounts may not tie to the departmental figures provided. Please note for summary tab: Totals may not add due to rounding Ratio to sales based on Total Revenue, except Departmental Expenses Per Available Room based on total total number of hotel rooms Per Occupied Room Night based on total number of occupied rooms The information contained in this report is based upon independent surveys and research from sources considered reliable. However, no representation is made as to its completeness or accuracy. THE INFORMATION IS PROVIDED AS-IS. This information shall not be construed as either a recommendation by STR of any industry standard or as legal, investment, or tax advice. The STR Custom HOST Report is a publication of STR, Inc. and STR Global, Ltd., and is intended solely for use by paid subscribers. Reproduction or distribution of the STR Complimentary HOST Participant Report, in whole or part, without written permission is prohibited and subject to legal action. If you have received this report and are NOT a subscriber to the STR Complimentary HOST Participant Report, please contact us immediately. Source: 2017 STR, Inc. / STR Global, Ltd. trading as "STR". Revenue Please note for detailed tabs: Ratio to sales based on Total Revenue of only those hotels that reported each line item, respectively Totals may not add up due to each line item being based on different totals Blank cells indicate insufficient data to report 2017 Custom HOST Report Revenue Detail Currency:USD20162015Variance % Ratio to Sales 1Amount Per Available RoomAmount Per Occupied Room NightRatio to Sales 1Amount Per Available RoomAmount Per Occupied Room NightAmount Per Available RoomAmount Per Occupied Room Night REVENUE%$$%$$%% Rooms Transient Revenue36.0%$ 30,981$ 108.2135.9%$ 31,565$ 109.52(1.9)%(1.2)% Group Revenue29.525,37488.6229.125,64989.00(1.1)(0.4) Rooms Other2.01,6955.921.51,3214.5828.329.3 Service Charges Food Venues5.64,74116.565.85,04417.52(6.0)(5.5) In-Room Dining0.87272.540.98122.81(10.5)(9.6) Banquet/Catering11.89,99734.9212.210,59536.81(5.6)(5.1) Mini Bar Other(0.1)(71)(0.26)- 0(37)(0.13)94.1100.0 Beverage Venues3.52,97910.413.63,09310.75(3.7)(3.2) In-Room Dining0.21460.510.21540.53(5.0)(3.8) Banquet/Catering1.08282.891.08973.12(7.7)(7.4) Mini Bar Other- 0(5)(0.02)(0.5)(362)(1.27)(98.5)(98.4) Other F&B Revenue Meeting Room Rental0.97752.710.97672.661.11.9 Audiovisual2.11,8086.312.11,8566.42(2.6)(1.7) Service Charges2.52,1197.402.62,2977.98(7.7)(7.3) Other0.44201.410.54121.412.0- 0 Other Operated Departments Golf Green Fees Cart Rental Income Retail Membership Fees Other Golf Revenue Spa Spa Treatment Revenue Salon Revenue Retail Other Spa Revenue Other Transportation/Garage/Parking1.58683.652.31,9887.41(56.4)(50.7) Telecommunications0.21870.650.32300.80(18.5)(18.5) Other Operated Departments1.08062.851.08322.89(3.1)(1.4) Miscellaneous Income3.83,23711.303.53,02610.506.97.6 TOTAL REVENUE100.0%$ 85,007$ 296.93100.0%$ 86,723$ 301.29(2.0)%(1.4)% The information contained in this report is based upon independent surveys and research from sources considered reliable. However, no representation is made as to its completeness or accuracy. THE INFORMATION IS PROVIDED AS-IS. This information shall not be construed as either a recommendation by STR of any industry standard or as legal, investment, or tax advice. The STR Custom HOST Report is a publication of STR, Inc. and STR Global, Ltd., and is intended