Begin by reviewing ?HOSP 4040 Benchmark Development Case Study (docx) HOSP 4040 Benchmark Development Case Study (docx) – Alternative
Begin by reviewing HOSP 4040 Benchmark Development Case Study (docx) HOSP 4040 Benchmark Development Case Study (docx) – Alternative Formats and Benchmark Development Data file (xlsx) . One of the more important functions of an Asset Manager is the development of benchmarks to drive performance across your portfolio.
Using the assignment documents, develop benchmarks for your properties.
HOSP 4040
DEVELOPING BENCHMARKS CASE STUDY
BACKGROUND:
The development of benchmarks is a critical part of an overall continual improvement strategy.
The basic process is straight forward.
1. Identify those metrics that are most important to the success of the business units (in this case individual hotels).
2. Identify those hotels in the portfolio (owned, managed, branded) that are performing the best on each of these metrics.
3. Calculate a benchmark based on this data.
4. Publish the benchmarks and hold all of the hotels in the portfolio accountable for achieving them.
5. Repeat.
The devil is in the detail of course. Here are some common considerations when developing benchmarks.
1. Benchmarks should always be based on “like hotels”. Meaning hotels that are like each other. It would be nonsensical to attempt to hold luxury hotels and select service hotels to the same benchmarks. The hotels do not need to be the same size, because using units of production as a benchmark eliminates the differences between hotels of different sizes. For example, if a benchmark for housekeeping labor is 30 minutes per room occupied, that benchmark is the same whether the hotel is 150 or 500 rooms.
2. Benchmarks should always be based on the units of production. In the case of hotels, this is rooms occupied or covers served in F&B. Because pricing is varied across the country and changes constantly, benchmarking off of revenue would be unwise.
3. Labor benchmarks should always be based on productivity – not labor cost. Labor costs vary widely by market and are not controllable by local management. So, using labor cost for benchmarking is also counterproductive. You should always use man hours per unit sold.
4. Cost benchmarks should always be on units of production, and only for those expenses where the cost of the products have been negotiated for the entire portfolio – so each hotel is paying the same cost for the items.
5. Achievement of the benchmarks should be incorporated into both performance reviews and into incentive compensation plans for management.
6. The number of benchmarks should be limited. Focus on what is most important.
7. Benchmarks should be developed using the average of the highest performing group of hotels – not on an individual hotel. Most benchmarking programs use either the highest decile (best 10%) or quartile (best 25%) averages.
The Case
You are an asset manager working for an owned portfolio of 20 “like hotels”. Your company has established several benchmarks, and these have been used and measured for years. Each year, prior to the budgeting process the benchmarks are updated, based on the most current data for the portfolio.
Your analyst has prepared the attached excel file detailing the most recent data. Each tab on the file is a separate benchmark.
Your assignment
Using the attached excel file, create a benchmark using the average performance of the upper quartile on each of the benchmark tabs. Insert your benchmark into the assigned cell.
Steps:
1. Sort the data from best to worst.
2. Take the average of the best quartile (in this case, the top 5 hotels).
3. Enter this average of the best quartile performance into the given cell on each tab.
4. Summarize the benchmark on the first tab for all of the benchmarks.
5. Save the excel file using the name “yourname.xlsx” and submit using the assignment link.
,
Cover
Triangle Partners | |
Portfolio Benchmarks | |
Budget Benchmark | |
Housekeeper Man Hours per occupied room | |
Linen expense per occupied room | |
Cleaning supplies cost per occupied room | |
Front Desk Man Hours per occupied room | |
F&B Culinary man hours per cover | |
F&B Service man hours per cover | |
F&B Food cost per cover | |
F&B China, glass, silver and linen cost per cover |
Housekeeping MHPOR
Triangle Partners | ||||
Benchmark Development | ||||
Benchmark: | Houskeeper Man Hours per Occupied Room | |||
Current Year Data (YTD) | ||||
Hotel | Metric | |||
Hotel A | 0.53 | Enter the calculated benchmark | ||
Hotel B | 0.48 | |||
Hotel C | 0.47 | |||
Hotel D | 0.54 | |||
Hotel E | 0.52 | |||
Hotel F | 0.50 | |||
Hotel G | 0.49 | |||
Hotel H | 0.45 | |||
Hotel I | 0.53 | |||
Hotel J | 0.48 | |||
Hotel K | 0.47 | |||
Hotel L | 0.54 | |||
Hotel M | 0.52 | |||
Hotel N | 0.50 | |||
Hotel O | 0.49 | |||
Hotel P | 0.45 | |||
Hotel Q | 0.53 | |||
Hotel R | 0.48 | |||
Hotel S | 0.47 | |||
Hotel T | 0.54 |
Linen Expense POR
Triangle Partners | ||||
Benchmark Development | ||||
Benchmark: | Linen Expense Per Occupied Room | |||
Current Year Data (YTD) | ||||
Hotel | Metric | |||
Hotel A | $ 1.85 | Enter the calculated benchmark | ||
Hotel B | $ 1.75 | |||
Hotel C | $ 1.55 | |||
Hotel D | $ 1.95 | |||
Hotel E | $ 2.05 | |||
Hotel F | $ 1.65 | |||
Hotel G | $ 1.72 | |||
Hotel H | $ 1.85 | |||
Hotel I | $ 1.75 | |||
Hotel J | $ 1.55 | |||
Hotel K | $ 1.95 | |||
Hotel L | $ 2.05 | |||
Hotel M | $ 1.65 | |||
Hotel N | $ 1.72 | |||
Hotel O | $ 1.85 | |||
Hotel P | $ 1.75 | |||
Hotel Q | $ 1.55 | |||
Hotel R | $ 1.95 | |||
Hotel S | $ 2.05 | |||
Hotel T | $ 1.65 | |||
Cleaning Supplies POR
Triangle Partners | ||||
Benchmark Development | ||||
Benchmark: | Cleaning Supplies Expense Per Occupied Room | |||
Current Year Data (YTD) | ||||
Hotel | Metric | |||
Hotel A | $ 1.85 | Enter the calculated benchmark | ||
Hotel B | $ 1.75 | |||
Hotel C | $ 1.55 | |||
Hotel D | $ 1.95 | |||
Hotel E | $ 2.05 | |||
Hotel F | $ 1.65 | |||
Hotel G | $ 1.72 | |||
Hotel H | $ 1.85 | |||
Hotel I | $ 1.75 | |||
Hotel J | $ 1.55 | |||
Hotel K | $ 1.95 | |||
Hotel L | $ 2.05 | |||
Hotel M | $ 1.65 | |||
Hotel N | $ 1.72 | |||
Hotel O | $ 1.85 | |||
Hotel P | $ 1.75 | |||
Hotel Q | $ 1.55 | |||
Hotel R | $ 1.95 | |||
Hotel S | $ 2.05 | |||
Hotel T | $ 1.65 | |||
Front Desk MHPOR
Triangle Partners | ||||
Benchmark Development | ||||
Benchmark: | Front Desk Man Hours Per Occupied Room | |||
Current Year Data (YTD) | ||||
Hotel | Metric | |||
Hotel A | 0.10 | Enter the calculated benchmark | ||
Hotel B | 0.11 | |||
Hotel C | 0.09 | |||
Hotel D | 0.08 | |||
Hotel E | 0.12 | |||
Hotel F | 0.13 | |||
Hotel G | 0.10 | |||
Hotel H | 0.11 | |||
Hotel I | 0.09 | |||
Hotel J | 0.08 | |||
Hotel K | 0.12 | |||
Hotel L | 0.13 | |||
Hotel M | 0.10 | |||
Hotel N | 0.11 | |||
Hotel O | 0.09 | |||
Hotel P | 0.08 | |||
Hotel Q | 0.12 | |||
Hotel R | 0.13 | |||
Hotel S | 0.10 | |||
Hotel T | 0.11 | |||
F&B Culinary per Cover
Triangle Partners | ||||
Benchmark Development | ||||
Benchmark: | F&B Culinary Man Hours Per Cover | |||
Current Year Data (YTD) | ||||
Hotel | Metric | |||
Hotel A | 0.18 | Enter the calculated benchmark | ||
Hotel B | 0.21 | |||
Hotel C | 0.19 | |||
Hotel D | 0.17 | |||
Hotel E | 0.16 | |||
Hotel F | 0.22 | |||
Hotel G | 0.18 | |||
Hotel H | 0.21 | |||
Hotel I | 0.19 | |||
Hotel J | 0.17 | |||
Hotel K | 0.16 | |||
Hotel L | 0.22 | |||
Hotel M | 0.18 | |||
Hotel N | 0.21 | |||
Hotel O | 0.19 | |||
Hotel P | 0.17 | |||
Hotel Q | 0.16 | |||
Hotel R | 0.22 | |||
Hotel S | 0.18 | |||
Hotel T | 0.21 | |||
F&B Service per Cover
Triangle Partners | ||||
Benchmark Development | ||||
Benchmark: | F&B Service Man Hours Per Cover | |||
Current Year Data (YTD) | ||||
Hotel | Metric | |||
Hotel A | 0.14 | Enter the calculated benchmark | ||
Hotel B | 0.15 | |||
Hotel C | 0.12 | |||
Hotel D | 0.13 | |||
Hotel E | 0.18 | |||
Hotel F | 0.20 | |||
Hotel G | 0.14 | |||
Hotel H | 0.15 | |||
Hotel I | 0.12 | |||
Hotel J | 0.13 | |||
Hotel K | 0.18 | |||
Hotel L | 0.20 | |||
Hotel M | 0.14 | |||
Hotel N | 0.15 | |||
Hotel O | 0.12 | |||
Hotel P | 0.13 | |||
Hotel Q | 0.18 | |||
Hotel R | 0.20 | |||
Hotel S | 0.14 | |||
Hotel T | 0.15 | |||
F&B Food Cost Per Cover
Triangle Partners | ||||
Benchmark Development | ||||
Benchmark: | F&B Food Cost Per Cover | |||
Current Year Data (YTD) | ||||
Hotel | Metric | |||
Hotel A | $ 4.85 | Enter the calculated benchmark | ||
Hotel B | $ 4.95 | |||
Hotel C | $ 5.10 | |||
Hotel D | $ 5.05 | |||
Hotel E | $ 4.84 | |||
Hotel F | $ 4.72 | |||
Hotel G | $ 4.85 | |||
Hotel H | $ 4.95 | |||
Hotel I | $ 5.10 | |||
Hotel J | $ 5.05 | |||
Hotel K | $ 4.84 | |||
Hotel L | $ 4.72 | |||
Hotel M | $ 4.85 | |||
Hotel N | $ 4.95 | |||
Hotel O | $ 5.10 | |||
Hotel P | $ 5.05 | |||
Hotel Q | $ 4.84 | |||
Hotel R | $ 4.72 | |||
Hotel S | $ 4.85 | |||
Hotel T | $ 4.95 | |||
F&B China Glass Sliver Per Cove
Triangle Partners | ||||
Benchmark Development | ||||
Benchmark: | F&B China Glass Silver Linen per cover | |||
Current Year Data (YTD) | ||||
Hotel | Metric | |||
Hotel A | $ 1.85 | Enter the calculated benchmark | ||
Hotel B | $ 1.95 | |||
Hotel C | $ 2.10 | |||
Hotel D | $ 2.05 | |||
Hotel E | $ 1.84 | |||
Hotel F | $ 1.72 | |||
Hotel G | $ 1.85 | |||
Hotel H | $ 1.95 | |||
Hotel I | $ 2.10 | |||
Hotel J | $ 2.05 | |||
Hotel K | $ 1.84 | |||
Hotel L | $ 1.72 | |||
Hotel M | $ 1.85 | |||
Hotel N | $ 1.95 | |||
Hotel O | $ 2.10 | |||
Hotel P | $ 2.05 | |||
Hotel Q | $ 1.84 | |||
Hotel R | $ 1.72 | |||
Hotel S | $ 1.85 | |||
Hotel T | $ 1.95 | |||
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.