Use Solver Table to analyze the effect of storage capacity increase at the DCs and cotton production increase at the farms. Vary the production capacity at all three farms from 0% to 25% (in increments of 5%) and the storage capacity at all four DCs from 0% to 25% (in increments of 5%) and track the optimal profit. Comment on the change in profit with changes in the storage capacities and production capacity. Note that all changes have to be made simultaneously. You cannot run multiple Solver Table analyses.

Use Solver Table to analyze the effect of storage capacity increase at the DCs and cotton production increase at the farms. Vary the production capacity at all three farms from 0% to 25% (in increments of 5%) and the storage capacity at all four DCs from 0% to 25% (in increments of 5%) and track the optimal profit. Comment on the change in profit with changes in the storage capacities and production capacity. Note that all changes have to be made simultaneously. You cannot run multiple Solver Table analyses.