Explanation
You can create multiple scenarios using the same model.
Example
Low Sales
Quantity = 80
Price = ₹450
Cost = ₹300
Normal Sales
Quantity = 100
Price = ₹500
Cost = ₹300
High Sales
Quantity = 150
Price = ₹600
Cost = ₹300
Profit Formula
=(Quantity*Price)-(Quantity*Cost)-FixedCost
Scenario Comparison
|
Scenario |
Quantity |
Price |
Cost |
|
Low Sales |
80 |
₹450 |
₹300 |
|
Normal Sales |
100 |
₹500 |
₹300 |
|
High Sales |
150 |
₹600 |
₹300 |
Practice
Create all three scenarios and switch between them.