Question: (please try answer as soon as possible, I have more question to post after this if you can, I can not post all question at

(please try answer as soon as possible, I have more question to post after this if you can, I can not post all question at once because that's the question system one by one in my assignment )
Use the information below to answer the following question(s). Below is a spreadsheet for a hotel overbooking model. B 5 16 7 18 A B D | Hotel Overbooking Model Demand Probability 290 0.03 Data 1295 10.05 300 0.08 Rooms available 350 305 0.12 Price $ 120 310 0.15 Overbooking cost $ 100 315 0.20 320 0.15 9 Model 325 10.10 10 330 0.05 11 Reservation limit 350 335 0.04 12 Customer demand 320 340 0.03 13 Reservations made 14 Cancellations 15 15 Customer arrivals 16 17 Overbooked customers 18 INet revenue Assume that each reservation has a constant probability p = 0.04 of being cancelled. With respect to B12 (Expected Demand), what is the range of weights (probabilities) given in Discrete function formulation? O$E$2:$E$8 O$E$2:$E$13 O $D$2:$D$13 O$E$2:$E$12Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
