File Name

Scenario_Manager_Practice.xlsx

Business Model

Input	Value
Quantity	100
Selling Price	₹500
Cost per Unit	₹300
Fixed Cost	₹5,000

Calculations

Revenue

=B2*B3

Variable Cost

=B2*B4

Total Cost

=B6+B5

Profit

=B6-B7

Scenario 1 — Low Sales

Input	Value
Quantity	75
Selling Price	₹450
Cost per Unit	₹300

Scenario 2 — Normal Sales

Input	Value
Quantity	100
Selling Price	₹500
Cost per Unit	₹300

Scenario 3 — High Sales

Input	Value
Quantity	150
Selling Price	₹600
Cost per Unit	₹300

Tasks

1. Create the Profit Model.
2. Identify the changing cells.
3. Create Low Sales scenario.
4. Create Normal Sales scenario.
5. Create High Sales scenario.
6. Use Show to switch between scenarios.
7. Record the Profit for each scenario.
8. Create a Scenario Summary Report.
9. Format the report professionally.
10. Create a chart comparing scenario profits.

Final Challenge

Create a Business Scenario Planning Report containing:

Scenario 1

Low Sales

Scenario 2

Normal Sales

Scenario 3

High Sales

For each scenario show:

• Quantity
• Selling Price
• Cost
• Revenue
• Total Cost
• Profit

Then create a visual comparison chart.