all three questions please

Use the information below to answer the following question(s). Below is a spreadsheet for a hotel overbooking model. 11 b B D Hotel Overbooking Model Demand Probability D 290 0.03 B Data 295 0.05 300 0.08 Rooms available 350 305 0.12 Price $ 120 310 0.15 17 Overbooking cost $ 100 315 0.20 B 320 0.15 19 Model 325 0.10 10 330 0.05 Reservation limit 350 335 0.04 112 Customer demand 320 340 0.02 Reservations made 345 0.01 Cancellations 15 15 Customer arrivals 16 17 Overbooked customers 18 Net revenue Assume that each reservation has a constant probability p = 0.04 of being cancelled. The number of cancellation in cell B14, is based on: reservations made customer demand customer arrivals reservation limit Use the information below to answer the following question(s). Below is a spreadsheet for a hotel overbooking model. 11 A Hotel Overbooking Model Pemand Probability 290 0.03 B Data 295 9.05 44 300 0.08 b Rooms available 350 305 0.12 Price $ 120 310 0.15 17 Overbooking cost $ 100 315 0.20 B 320 0.15 P Model 325 0.10 110 330 0.05 111 Reservation limit 350 335 0.04 112 Customer demand 320 340 0.02 13 Reservations made 345 0.01 14 Cancellations 15 15 Customer arrivals 16 17 Overbooked customers 18 Net 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? $D$2:$D$8 $E$2:$E$13 $D$2:$D$13 SE$2:$E$8 Use the information below to answer the following question(s). Below is a spreadsheet for a hotel overbooking model. A D 11 Hotel Overbooking Model Demand Probability 2 290 0.03 B Data 295 0.05 4 300 0.08 Rooms available 350 305 0.12 5 Price $ 120 310 9.15 7 Overbooking cost $ 100 315 0.20 8 320 0.15 Model 325 0.10 110 330 0.05 111 Reservation limit 350 335 0.04 112 Customer demand 320 340 0.02 113 Reservations made 345 0.01 Cancellations 15 15 Customer arrivals 116 Overbooked customers 118 Net revenue Assume that each reservation has a constant probability p = 0.04 of being cancelled. Which of the following cells is defined as an output cell? B14 B13 B18 B15 Use the information below to answer the following question(s). Below is a spreadsheet for a hotel overbooking model. 11 b B D Hotel Overbooking Model Demand Probability D 290 0.03 B Data 295 0.05 300 0.08 Rooms available 350 305 0.12 Price $ 120 310 0.15 17 Overbooking cost $ 100 315 0.20 B 320 0.15 19 Model 325 0.10 10 330 0.05 Reservation limit 350 335 0.04 112 Customer demand 320 340 0.02 Reservations made 345 0.01 Cancellations 15 15 Customer arrivals 16 17 Overbooked customers 18 Net revenue Assume that each reservation has a constant probability p = 0.04 of being cancelled. The number of cancellation in cell B14, is based on: reservations made customer demand customer arrivals reservation limit Use the information below to answer the following question(s). Below is a spreadsheet for a hotel overbooking model. 11 A Hotel Overbooking Model Pemand Probability 290 0.03 B Data 295 9.05 44 300 0.08 b Rooms available 350 305 0.12 Price $ 120 310 0.15 17 Overbooking cost $ 100 315 0.20 B 320 0.15 P Model 325 0.10 110 330 0.05 111 Reservation limit 350 335 0.04 112 Customer demand 320 340 0.02 13 Reservations made 345 0.01 14 Cancellations 15 15 Customer arrivals 16 17 Overbooked customers 18 Net 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? $D$2:$D$8 $E$2:$E$13 $D$2:$D$13 SE$2:$E$8 Use the information below to answer the following question(s). Below is a spreadsheet for a hotel overbooking model. A D 11 Hotel Overbooking Model Demand Probability 2 290 0.03 B Data 295 0.05 4 300 0.08 Rooms available 350 305 0.12 5 Price $ 120 310 9.15 7 Overbooking cost $ 100 315 0.20 8 320 0.15 Model 325 0.10 110 330 0.05 111 Reservation limit 350 335 0.04 112 Customer demand 320 340 0.02 113 Reservations made 345 0.01 Cancellations 15 15 Customer arrivals 116 Overbooked customers 118 Net revenue Assume that each reservation has a constant probability p = 0.04 of being cancelled. Which of the following cells is defined as an output cell? B14 B13 B18 B15