Questions from Business Analytics

Q: For the Hansel Corporation, obtain the Solver Sensitivity Report and use

For the Hansel Corporation, obtain the Solver Sensitivity Report and use it to answer the following: a. A labor strike in India leads to a shortage of 20,000 units of additive C. What should the produ...

Q: For the nonlinear pricing decision model, suppose that the company wants

For the nonlinear pricing decision model, suppose that the company wants to keep the price at a maximum $300. Note that the solution in Figure 14.19 will no longer be feasible. Modify the spreadsheet...

Q: Figure 15.39 shows the Solver Sensitivity Report for the Markowitz

Figure 15.39 shows the Solver Sensitivity Report for the Markowitz portfolio model. a. Explain how to interpret the Lagrange multiplier value for the target portfolio return. b. Suppose the target ret...

Q: Obtain the Solver Sensitivity Report for the Hal Chase portfolio optimization model

Obtain the Solver Sensitivity Report for the Hal Chase portfolio optimization model. Explain how to interpret the Lagrange multipliers for the constraints.

Q: Marketing agents have various media alternatives in which to advertise and must

Marketing agents have various media alternatives in which to advertise and must determine which to use, the number of insertions in each, and the timing of insertions to maximize advertising effective...

Q: Box Tile Company, use the auxiliary variable technique to handle the

Box Tile Company, use the auxiliary variable technique to handle the bound constraints on grade I and grade III tiles and obtain the Solver Sensitivity Report. Answer the following: a. Explain the sen...

Q: For Starbucks coffee company, formulate and solve a linear optimization model

For Starbucks coffee company, formulate and solve a linear optimization model using the auxiliary variable cells method and write a short memo to the outlet manager explaining the sensitivity informat...

Q: For the Fruity Juices scenario, formulate and solve a linear optimization

For the Fruity Juices scenario, formulate and solve a linear optimization model using the auxiliary variable cells method and write a short memo explaining the sensitivity information.

Q: For WoodFurni, solve the model using auxiliary variables. Obtain the

For WoodFurni, solve the model using auxiliary variables. Obtain the Solver Sensitivity Report, and answer the following: a. Explain the sensitivity information for the objective coefficients. What ha...

Q: Hahn Engineering would like to increase its return, but the project

Hahn Engineering would like to increase its return, but the project manager knows that this will require more cash and/or personnel. Conduct a what-if analysis of the optimal solution as the cash limi...