MIS775 Decision Models for Business Analytics

Published : 27-Sep,2021 | Views : 10

Question:

Develop a spreadsheet-based decision model that can be used to investigate and explore decisions and risks relating to hotel booking (and reservation limits). The model is for the selling horizon (high season), designed for the revenue manger and,
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)

A brief description of the model bubble diagram or similar capturing the conceptual model used and assumptions behind the decision model.

Answer:

Occupancy Rate	Single unit	Occupancy Rate	Double unit	Occupancy Rate	Family unit
0%	-$50,800.00	0%	-$18,800.00	0%	-$71,800.00
4%	-$21,199.96	4%	$24,296.30	4%	-$31,562.40
8%	$5,880.06	8%	$61,752.60	8%	$6,072.64
12%	$26,600.08	12%	$99,208.90	12%	$34,238.96
16%	$47,320.11	16%	$1,36,665.20	16%	$62,405.28
20%	$68,040.14	20%	$1,74,121.50	20%	$90,571.60
24%	$88,760.17	24%	$2,11,577.80	24%	$1,18,737.92
28%	$1,09,480.20	28%	$2,49,034.10	28%	$1,46,904.24
32%	$1,30,200.22	32%	$2,86,490.40	32%	$1,75,070.56
36%	$1,50,920.25	36%	$3,23,946.70	36%	$2,03,236.88
40%	$1,71,640.28	40%	$3,61,403.00	40%	$2,31,403.20
44%	$1,92,360.31	44%	$3,98,859.30	44%	$2,59,569.52
48%	$2,13,080.34	48%	$4,36,315.60	48%	$2,87,735.84
52%	$2,33,800.36	52%	$4,73,771.90	52%	$3,15,902.16
56%	$2,54,520.39	56%	$5,11,228.20	56%	$3,44,068.48
60%	$2,75,240.42	60%	$5,48,684.50	60%	$3,72,234.80
64%	$2,95,960.45	64%	$5,86,140.80	64%	$4,00,401.12
68%	$3,16,680.48	68%	$6,23,597.10	68%	$4,28,567.44
72%	$3,37,400.50	72%	$6,61,053.40	72%	$4,56,733.76
76%	$3,58,120.53	76%	$6,98,509.70	76%	$4,84,900.08
80%	$3,78,840.56	80%	$7,35,966.00	80%	$5,13,066.40
84%	$3,99,560.59	84%	$7,73,422.30	84%	$5,41,232.72
88%	$4,20,280.62	88%	$8,10,878.60	88%	$5,69,399.04
92%	$4,41,000.64	92%	$8,48,334.90	92%	$5,97,565.36
96%	$4,61,720.67	96%	$8,85,791.20	96%	$6,25,731.68
100%	$4,82,440.70	100%	$9,23,247.50	100%	$6,53,898.00