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.