Your ownership has asked you to increase revenues and profit by at least $5$ percent for the following year. Based on pricing principles in this chapter and price sensitivity for different market segments, you will have the opportunity to make strategic changes to rates or increase production to key market segments. Find the best combination of strategic changes to achieve the best possible profitable outcome.button$\_$download$-$here.pngExercise: On the next tab, you will see different market segments. The green cells will allow you to make strategic changes for specific market segments. Corporate Accounts & Social Meetings will allow changing production through the sales efforts, positive or negative. For RACK, Opaque, and Corporate Meetings, you will be able to change rates up or down. As you make strategic changes, you will notice it will have an effect on either the production or the rate for each segment. YOU CANNOT GO OVER $4907$ total rooms for May $2016.$ Notes: The changes also take into consideration fixed versus dynamic rates based on real$-$life practice. There are some market segments that have a relationship to each other, such as the BAR rate will also impact Brand.com, OTA, and packages. Other market segments might have a relationship on production, whereby increasing one, they would also decrease the other based on available inventory.Goal: Your goal is to find the optimal combination of rate changes $($positive or negative$)$ as well as production between the market segments. Once you find the optimal revenue and profit growth, make a summary of your decisions and the rationale behind your decisions Explain the relationships between the market segments, such as BAR$/$Online Travel Agents & Brand.com$9$:$37$C

HRM CH $2-$ Spreadsheet Exercise $2....$

$$

Dashboard

Dashboard

Calendar

Calendar

To Do

$2$

Notifications

Inbox