How to do this in excel

(d) Consider the following scenarios. Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5 Variable Cost/Book 56 58 $12 $10 511 Access Price 546 $50 $40 $50 560 Demand 2,000 2,500 6,000 5,000 1,000 For each of these scenarios, the fixed cost rerrains 5161,000. Use Scenario Manager to generate a surtimary report that gives the profit for each of these scenarios. Which scenario yields the highest profit? Scenario 1 Scenario 2 Scenaria 3 Scenario 4 Scenario 5 which scenario yields the lowest profit? Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5