In the Green Grass shipping model, we assumed that certain inputs (see the range B4:B7 in Figure 6.25) are the same for all plants or plant–customer combinations. Change this so that the unit...

In the Green Grass shipping model, we assumed that certain inputs (see the range B4:B7 in Figure 6.25) are the same for all plants or plant–customer combinations. Change this so that the unit production cost, the monthly fixed cost, and the monthly capacity can vary by plant, and the unit shipping cost can vary by plant–customer combination. (You can make up data that vary around the values in the B4:B7 range.) Use Solver to find the new optimal solution.

=B5/B4^B10 3

Sensitivity factor. The model treats both cases, when shirts and ties are ignored and when they are not, by using SolverTable with a “sensitivity factor” as the input cell. When this factor is 0, the complementary products are ignored; when it is positive, they are taken into consideration. Enter 1 in the sensitivity factor cell E9 for now. In general, this factor determines the average number of shirts and ties purchased with the purchase of a suit—this factor is multiplied by the values in the E5:F5 range. When this factor is 1, you get the values in the statement of the problem. When it is 0, no shirts and ties are purchased with a suit. 4 Price, demand. Enter any price in cell B13, and calculate the corresponding demand for suits in cell B14 with the formula

=B7+SUMPRODUCT (Prices, C7:D7)

in cell C19 for the off-peak demand.