Questions from Business Analytics

Q: Figure 15.32 shows the Solver Sensitivity Report after solving the

Figure 15.32 shows the Solver Sensitivity Report after solving the Crebo Manufacturing. Using only the information in the Sensitivity Report, answer the following questions. a. Explain the value of th...

Q: For the Bicycle Inventory database, use database functions to find the

For the Bicycle Inventory database, use database functions to find the following: a. The total number of leisure bicycles on hand. b. The average purchase cost and selling price of road bicycles.

Q: Figure 15.33 shows the Solver Sensitivity Report for Valencia Products

Figure 15.33 shows the Solver Sensitivity Report for Valencia Products. Using only the information in the Sensitivity Report, answer the following questions, explaining what information you used in th...

Q: Figure 15.34 shows the Solver Sensitivity Report for the ColPal

Figure 15.34 shows the Solver Sensitivity Report for the ColPal Products scenario. Using only the information in the Sensitivity Report, answer the following questions, explaining what information you...

Q: Figure 15.35 shows the Solver Sensitivity Report for the Burger

Figure 15.35 shows the Solver Sensitivity Report for the Burger Office Equipment scenario. Using only the information in the Sensitivity Report, answer the following questions, explaining what informa...

Q: Use the Outsourcing Decision Model Excel file to compute the cost of

Use the Outsourcing Decision Model Excel file to compute the cost of in-house manufacturing and outsourcing for the following levels of demand: 200, 600, 1,000, and 1,400. Use this information to set...

Q: For the DoorCo Corporation decision, suppose that the probabilities of the

For the DoorCo Corporation decision, suppose that the probabilities of the three scenarios are estimated to be 0.15, 0.40, and 0.45, respectively. Find the best expected value decision.

Q: For Peter Cartman’s investment decision, suppose that the probabilities of the

For Peter Cartman’s investment decision, suppose that the probabilities of the scenarios are estimated to be 0.35, 0.25, and 0.40, respectively. Find the best expected value decision.

Q: For the DoorCo Corporation decision, construct a decision tree and compute

For the DoorCo Corporation decision, construct a decision tree and compute the rollback values to find the best expected value decision.

Q: For Peter Cartman’s investment decision, construct a decision tree and compute

For Peter Cartman’s investment decision, construct a decision tree and compute the rollback values to find the best expected value decision.