Use Scenario Manager to evaluate the impact of 4 different pricing and discount strategies of the bathing suits on the total revenue in the Markdown Pricing Model:

Data > What-If Analysis > Scenario Manager > Add

Scenario name: Ten/Ten or cell reference = E2

Changing cells: $B$7:$B$8; OK

$B$7: 10 for full price

$B$8: 10% for markdown

Click Add Scenarios to input Twenty/Twenty, Thirty/Thirty and Forty/Forty in the same way as you did for Ten/Ten in the previous slide; Then you can click Show to view individual scenarios and Summary to view the all scenarios.

In the end it should look exactly like this please.

Thank you please show steps of how to do it and ill give a good rating

H Thirty/Thirty 1 Markdown Pricing Model Twenty Twenty Forty/Forty Scenarios Ten/Ten Days at full retail Intermediate markdown 20 30 40 Data 0.1 0.2 0.3 0.4 ovo AWN $70.00 1000 Retail price Inventory Selling Season(days) Days at full retail Intermediate markdown Clearance markdown 40 0.3 0.7 11 Sales Data Price(x) $70 $49 15 Demand function parameters Intercept Slope Average Daily Sales(x) 7.00 32.20 16 -1.2 19 Model $19.600.00 21 Full Retail Sales Retail Price $70.00 Daily Price 7.00 Days at retail price 40 Units sold at retail 280 Retail revenue 27 Discount Sales Discount 30% Discount price $49.00 Daily sales $32.20 Unit sold 322 Discount revenue Clearance Sales Clearance price $21.00 Units sold at clearance 398 Clearance revenue $15.778.00 $8,358.00 Total Revenue $43,736.00 Thirty/Thirty Forty/Fortry 10 50 40 Scenario Summary Current Values: Ten/Ten Twenty/Twenty Changing Cells: $B$6 50 - 0.1 20 $B$8 30% 30% 20% Result Cells: $C$38 $43,736.00 $29.960.14 $52,850.00 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray. 50 30 30% 40 40% $49,322.00 $43,246.00