Table 1: Unit Sales Decrease 3% Scenario Values

Changing Cell Value

Basel_Units_Sold (F12) 8245

Geneva_Units_Sold (G12) 7988

Lucerne_Units_Sold (H12) 8119

2. Akio asks you to compare the results of the three scenarios.

Compare the scenarios as follows:

a. Design a Scenario Summary Report for result cells B8:B10, F13:H13.

b. On the Scenario Summary worksheet, delete column D to avoid repeating the data

shown in column G.

c. Delete the contents of the range B16:B18 to remove the notes.

3. Akio also wants to compare the scenario results.

Design

T Tech Togs Expense Report Revenue and Expenses Per Unit Profit Detailed Costs Revenue % of Total Basel Geneva Lucerne Marketing Basel 1,351,500 32% Price $ 159.00 $ 169.00 $ 179.00 Basel 250,500 Geneva 1,391,715 33% Mktg. cost 29.47 30.57 30.1 1 Geneva 251,760 Lucerne 1,498,230 35% Mfg. cost 89.00 94.00 104.00 Lucerne 252,055 Total sales 4,241,445 R&D cost 32.35 34.97 35.24 Manufacturing Units sold 8,500 8,235 8,370 Basel $ 756,500 Cost of Goods Sold Gross profit / unit $ 8.18 $ 9.46 $ 9.64 Geneva 774,090 Basel 1,282,000 32% Lucerne $ 870,480 Geneva 1,313,850 33% R&D Lucerne 1,417,535 35% Basel 275,000 Total COGS 54 4,013,385 Geneva 288,000 Lucerne 295,000 Gross profit $ 228,060 Total cost of goods sold $ 4,013,385