Go to the Product Mix worksheet, which calculates the profit from each model of portable speaker. Benicio

$\frac{0}{5}$

wants to compare three scenarios: one with the current prices and costs, another with the prices raised $$10\mathrm{.}00,$ and a third that reduces the variable costs per unit by $$5\mathrm{.}00.$ He has already created the first two scenarios and defined names for cells and ranges.

Create a third scenario as follows:

a$.$ In the Scenario Manager, add a scenario using Reduced Costs as the name.

b$.$ Accept the same changing cells $($nonadjacent ranges B$6$:F$6$ and B$11$:F$12)$ as the other two scenarios.

c$.$ Reduce each variable cost per unit value $($Minil$\_$Variable$\_$Cost, Mini$2\_$Variable$\_$Cost, VoiceXP$\_$Variable$\_$Cost, VoiceXP$10\_$Variable$\_$Cost, and Waterproof$\_$Variable$\_$Cost$)$ by $$5\mathrm{.}00.$

d$.$ Create a Scenario Summary report that summarizes the effect of the three scenarios. Use the profit per unit sold $($range B$17$:F$17)$ as the result cells.

Set the input cell values for a scenario.

In the Product Mix worksheet, the parameters for the "Reduced Costs" scenario have not been correctly set.

Create a Scenario Summary report.

The Scenario Summary worksheet should contain a scenario using the range B$17$:F$17$ in the Product Mix worksheet as the result cells.