In the Quality Sweaters model, the range E9:E11 does not have a range name. Open your completed Excel file and name this range Costs. Then look at the formula in cell E12. It does not automatically...

In the Quality Sweaters model, the range E9:E11 does not have a range name. Open your completed Excel file and name this range Costs. Then look at the formula in cell E12. It does not automatically use the new range name. Modify the formula so that it does. Then click on cell G4 and paste the new list of range names over the previous list.

Then sum them to get the total profit in cell B17. Note that the sensitivity factor in cell E9 scales the extra profit, depending on how many ties and shirts per suit are sold. If the value in cell E9 is 0, no shirts and ties are sold; if this value is 1, the numbers of shirts and ties stated in the problem are sold.

=D11/(1 $B$5)^(A11–0.5) in cell E11 and copying it down. Note how the exponent of the denominator accounts for the cash flow in the middle of the year.

in cells E4 through E7, and enter similar formulas using all of the data in columns F to H in cells F4 through F7.