=E*5.3. Consider the Big M Co. problem presented in Section 3.5, including the spreadsheet in Figure 3.10 showing its formulation and optimal solution.

There is some uncertainty about what the unit costs will be for shipping through the various shipping lanes. Therefore, before adopting the optimal solution in Figure 3.10, management wants additional information about the effect of inaccuracies in estimating these unit costs.

Use the Excel Solver to generate the sensitivity report preparatory to addressing the following questions.