develop a spreadsheet-based decision model that can be used to investigate and explore decisions and risks relating to hotel booking management

You are required to develop a spreadsheet-based decision model that can be used to investigate and explore
decisions and risks relating to hotel booking management (and reservation limits). The model should be
designed to be used by the hotel sales manager for accommodation reservation bookings made by
customers for the coming high season. You can assume the following:
• The number of available rooms is limited
• Cancellations are expected
• The hotel’s policy for overbooking is to give customers a free room at another hotel
• Some limits on the number of possible reservations are expected (to handle overbooking).
The decision model must be realistic and easy to use. The level of complexity modelled, for example the
choice of deterministic vs. stochastic inputs, input distributions, etc., is left to your discretion. However, the
model must enable the user to input the business costs such as maintenance cost, overbooking cost, etc.
No data are provided for this assignment. You are required to create a fictitious client and demonstrate the
utility of the decision model using real data where available and create data where it is not.
The minimum requirements of the decision model are:
1. The ability to enter revenue and costs, so that decision options can be explored and to enable
outputs, such as profit, to be calculated.
2. Stochastic treatment of some of the inputs, so that the resulting simulated output can be explored.
3. It must also enable the decision maker to explore and understand the risks associated with decision.

We are the Best!

course-preview

275 words per page

You essay will be 275 words per page. Tell your writer how many words you need, or the pages.


12 pt Times New Roman

Unless otherwise stated, we use 12pt Arial/Times New Roman as the font for your paper.


Double line spacing

Your essay will have double spaced text. View our sample essays.


Any citation style

APA, MLA, Chicago/Turabian, Harvard, our writers are experts at formatting.


We Accept

Secure Payment
Image 3