Use SolverTable to run a sensitivity analysis on the cost per ounce of metal in the product mix model. Let this unit cost vary from $0.30 to $1.30 in increments of $0.20, and keep track of the values in the changing cells and the target cell. Discuss what happens to the optimal product mix. Also, does each 20-cent increase in the cost of metal result in the same decrease in profit?
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here