Exam 17: Optimization Models with Uncertainty

Use the table below to answer the following question(s). Below is a spreadsheet for a hotel overbooking model. Answer the following question(s)using multiple parameterized simulations.The range of the historical data is 400-430. -What is the number of reservations that will generate the least revenue?

Use the table below to answer the following question(s). Below is the spreadsheet for an economic order quantity model. Assume that the distribution of demand is normal with a mean of 20,000 and standard deviation of 2,000. -What is the value of mean obtained from the simulation results?

Use the table below to answer the following question(s). Below is a spreadsheet for Stone Age Surfboards. Assume that the finishing time for a pair of Rockwell surfboards is triangular with a minimum value of 1.4, a most likely value of 1.5, and a maximum value of 1.8 and that finishing time for a pair of Limestone surfboards is also triangular with a minimum value of 1.8, a most likely value of 2.0, and a maximum value of 2.4.The number of trials per simulation is equal to 5000. -Which of the following cells is defined with a triangular distribution?

Use the table below to answer the following question(s). Below is a spreadsheet for a hotel overbooking model. Answer the following question(s)using multiple parameterized simulations.The range of the historical data is 400-430. -If there are 425 reservations and 5 overbooked customers, what is the net revenue generated?

What is a value at risk constraint?

Use the table below to answer the following question(s). Below is a spreadsheet for Stone Age Surfboards. Assume that the finishing time for a pair of Rockwell surfboards is triangular with a minimum value of 1.4, a most likely value of 1.5, and a maximum value of 1.8 and that finishing time for a pair of Limestone surfboards is also triangular with a minimum value of 1.8, a most likely value of 2.0, and a maximum value of 2.4.The number of trials per simulation is equal to 5000. -What is the value of standard deviation obtained from the simulation results?

Use the table below to answer the following question(s). The Atlas Movies Theater has repriced their ticket rates to maximize revenues.They have three classes of tickets: Classic, Silver, and Gold.The table below provides information on the average ticket sales, revenue and price elasticity on demand.They have a total seating capacity of 300.The table also provides the new price for the three classes obtained using Solver. Assume the distributions of elasticities for three classes of tickets are uniform with minimum and maximum values equal to 75% and 125% of their estimated values, respectively.Under this assumption, use Monte Carlo simulation to answer the following questions.The model is simulated for 10,000 trials. -Which of the following cells are defined to be uniformly distributed?

Use the table below to answer the following question(s). The Atlas Movies Theater has repriced their ticket rates to maximize revenues.They have three classes of tickets: Classic, Silver, and Gold.The table below provides information on the average ticket sales, revenue and price elasticity on demand.They have a total seating capacity of 300.The table also provides the new price for the three classes obtained using Solver. Assume the distributions of elasticities for three classes of tickets are uniform with minimum and maximum values equal to 75% and 125% of their estimated values, respectively.Under this assumption, use Monte Carlo simulation to answer the following questions.The model is simulated for 10,000 trials. -What is the probability that more than 300 tickets will be sold?

Use the table below to answer the following question(s). Below is the spreadsheet for a newsvendor model. Answer the following question(s)using multiple parameterized simulations.The range of the historical data is 40 to 51. -Which of the following values of purchase quantity shows the least mean profit?

Use the table below to answer the following question(s). Below is a spreadsheet for a hotel overbooking model. Answer the following question(s)using multiple parameterized simulations.The range of the historical data is 400-430. -What is the number of reservations that will generate a net revenue of $59,000?

Use the table below to answer the following question(s). Below is the spreadsheet for a project selection model. -What is the value of standard deviation obtained from the simulation results? [Hint: Choose the approximate value.]

Use the table below to answer the following question(s). Below is the spreadsheet for an economic order quantity model. Assume that the distribution of demand is normal with a mean of 20,000 and standard deviation of 2,000. -Which of the following cells is defined to be normally distributed using the function = PsiNormal(20000,2000)?

Use the table below to answer the following question(s). The Atlas Movies Theater has repriced their ticket rates to maximize revenues.They have three classes of tickets: Classic, Silver, and Gold.The table below provides information on the average ticket sales, revenue and price elasticity on demand.They have a total seating capacity of 300.The table also provides the new price for the three classes obtained using Solver. Assume the distributions of elasticities for three classes of tickets are uniform with minimum and maximum values equal to 75% and 125% of their estimated values, respectively.Under this assumption, use Monte Carlo simulation to answer the following questions.The model is simulated for 10,000 trials. -What is the mean absolute deviation obtained from the simulation results?

Use the table below to answer the following question(s). Below is a spreadsheet for a hotel overbooking model. Answer the following question(s)using multiple parameterized simulations.The range of the historical data is 400-430. -Which of the following is the best number of reservations to accept?

Use the table below to answer the following question(s). Below is a spreadsheet for Stone Age Surfboards. Assume that the finishing time for a pair of Rockwell surfboards is triangular with a minimum value of 1.4, a most likely value of 1.5, and a maximum value of 1.8 and that finishing time for a pair of Limestone surfboards is also triangular with a minimum value of 1.8, a most likely value of 2.0, and a maximum value of 2.4.The number of trials per simulation is equal to 5000. -How often will overtime be needed if 4.5 Rockwell and 9.0 Limestone surfboards, the optimal solution, are scheduled each day?

Below is the spreadsheet for an economic order quantity model. Assume that the distribution of demand is normal with a mean of 20,000 and standard deviation of 2,000.The increase in total cost is calculated by adding the holding cost and the ordering cost.

Use the table below to answer the following question(s). Below is the spreadsheet for a project selection model. -What is the coefficient of variation obtained from the simulation results? [Hint: Choose the approximate value.]

Use the table below to answer the following question(s). Below is the spreadsheet for an economic order quantity model. Assume that the distribution of demand is normal with a mean of 20,000 and standard deviation of 2,000. -Which of the following cells is defined as the uncertain output cell?

Use the table below to answer the following question(s). Below is the spreadsheet for an economic order quantity model. Assume that the distribution of demand is normal with a mean of 20,000 and standard deviation of 2,000. -What is the coefficient of variation obtained from the simulation results?

What is a conditional value at risk constraint?