File Name
What_If_Analysis_Practice.xlsx
Sales Model
|
Input |
Value |
|
Quantity |
100 |
|
Selling Price |
500 |
|
Cost per Unit |
300 |
|
Fixed Cost |
5000 |
Calculations
Revenue
=B2*B3
Variable Cost
=B2*B4
Total Cost
=B6+B5
Profit
=B7-B8
Task 1 — Goal Seek
Find the Selling Price required to achieve:
₹30,000 Profit
Task 2 — One-Variable Data Table
Test these selling prices:
|
Selling Price |
|
₹400 |
|
₹450 |
|
₹500 |
|
₹550 |
|
₹600 |
|
₹650 |
|
₹700 |
Calculate the resulting profit.
Task 3 — Two-Variable Data Table
Use:
Quantity: 50, 100, 150, 200
Selling Price: ₹400, ₹500, ₹600, ₹700
Analyze the resulting profit.
Task 4 — Scenario Manager
Create:
Low Sales
Quantity = 75
Selling Price = ₹450
Normal Sales
Quantity = 100
Selling Price = ₹500
High Sales
Quantity = 150
Selling Price = ₹600
Compare the resulting profit.
Final Challenge
Create a Business Profit Analysis Report containing:
- Current Profit
- Goal Seek result
- One-variable Data Table
- Two-variable Data Table
- Low Sales Scenario
- Normal Sales Scenario
- High Sales Scenario
- Final comparison chart