EXCEL

Part 2: Create Scenarios using Scenario Manager (15 Marks) a. Create the following scenarios using scenario manager using Part 1 data: Pessimistic Scenario Best Case Scenario Most likely Scenario Number of toolsets sold: 20 Number of toolsets sold: 120 Number of toolsets sold: 100 Price per toolset: $20.00 Price per toolset: $50.00 Price per toolset:$40.00 Variable cost per toolset: $25.00 Variable cost per toolset: $35.00 Variable cost per toolset: $30.00 b. Create a summary of all the scenarios based on the above data and name the sheet as Scenario Summary. Your summary scenario must show the profits for each scenario along with details of each scenario