The optimal solution to the Dorian production model appears to be sensitive to the model inputs. For each of the following inputs, create a one-way SolverTable that captures all changing cells and the...

The optimal solution to the Dorian production model appears to be sensitive to the model inputs. For each of the following inputs, create a one-way SolverTable that captures all changing cells and the target cell as outputs. You can choose the ranges of these inputs to make the results “interesting.” Comment on your results.

a. The steel available

b. The labor hours available

c. The unit profit contribution of large minivans

d. The minimum production level (currently 200) of large minivans

e. The minimum production level (currently 1000) of compact cars