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 Solver Table that captures all changing cells and...

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 Solver Table 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