Questions from Business Analytics

Q: Dion must now purchase at least 5 units of Product A,

Dion must now purchase at least 5 units of Product A, 15 units of Product B, and 10 units of Product C to fulfill his demand. Use Solver to find an optimal solution and compare the Solver solution wit...

Q: Bangs Leisure Chairs. The Solver Sensitivity Report for the optimal solution

Bangs Leisure Chairs. The Solver Sensitivity Report for the optimal solution is shown in Figure 15.38. Clearly explain the information it provides.

Q: Model and solve an optimization model for the Morton Supply Company.

Model and solve an optimization model for the Morton Supply Company. Obtain the Solver Sensitivity Report for your solution, and clearly explain all the key information in language that the production...

Q: Model and solve an optimization model for planting corns and carrots.

Model and solve an optimization model for planting corns and carrots. Using the Solver Sensitivity Report, answer the following questions, explaining what information you used in Sensitive Report. a....

Q: For Susan’s cake recipe scenario, obtain the Solver Sensitivity Report and

For Susan’s cake recipe scenario, obtain the Solver Sensitivity Report and write a short memo to Susan explaining the sensitive information in language that she can understand.

Q: For Dara’s investment situation, obtain the Solver Sensitivity Report and interpret

For Dara’s investment situation, obtain the Solver Sensitivity Report and interpret the information, making recommendations that Dara might consider for her portfolio.

Q: StraitCarrier and SunShipping, obtain the Solver Sensitivity Report and write a

StraitCarrier and SunShipping, obtain the Solver Sensitivity Report and write a short memo to the directors of both the companies explaining your results.

Q: For Problem (Shafer Office Supplies), obtain the Solver Sensitivity Report

For Problem (Shafer Office Supplies), obtain the Solver Sensitivity Report and answer the following questions: a. Suppose that 500 units of extra supply are available (and that the cost of this extra...

Q: For the ColPal Products scenario, use the spreadsheet model to answer

For the ColPal Products scenario, use the spreadsheet model to answer the following question by changing the parameters and re-solving the model. Answer each question independently relative to the o...

Q: Apply the Advanced Filter to the Credit Risk Data (Base Data

Apply the Advanced Filter to the Credit Risk Data (Base Data worksheet) to find the following: a. All new car loans obtained for single females. b. All furniture loans obtained for single individuals...