As an intern in the financial department of scandia kayaks, you assist jay chen, a financial analyst. jay has asked you to work with the company's current revenue and sales data in excel to develop scenarios and what-if analyses that identify ways to increase profits.
switch to the revenue and expenses worksheet. jay wants to know how profits would change if the company sold 5 percent fewer kayaks of each model. make a scenario to provide this information for jay as follows:
a. in the scenario manager, add a new scenario and use unit sales decrease 5% as the scenario name.
b. change the values in the range f12: h12. (hint: two scenarios are already defined for the revenue and expenses worksheet.)
c. use the information shown in table 1 below as the values for the changing cells.
table 1: unit sales decrease 5% scenario values
changing cell
value
dae_units_sold (f12)
20900
swede_units_sold (g12)
20283
finn_units_sold (h12)
19665
d. show the results of the unit sales decrease 5% scenario.