🔹 Scenarios kya hote hain?

Scenario Excel ka ek What-If Analysis tool hai, jiska use different conditions ke according possible results ko compare karne ke liye kiya jata hai.

Simple words mein:

Scenario ka matlab hai ek hi calculation ke liye different situations create karke dekhna ki result kaise change hota hai.

For example, business mein hum dekh sakte hain:

• Sales kam ho to profit kitna hoga?
• Sales normal ho to profit kitna hoga?
• Sales zyada ho to profit kitna hoga?

In situations ko Scenarios kaha ja sakta hai.

1. Scenario ka Example

Suppose ek business ki monthly sales ₹1,00,000 hai aur profit sales ke according calculate hota hai.

Hum 3 scenarios bana sakte hain:

Ab ek hi worksheet mein different possibilities ko compare kiya ja sakta hai.

2. Scenarios ka main purpose

Scenarios ka main purpose hai:

“Agar situation change ho jaye, to result kya hoga?”

Isliye Scenarios ko What-If Analysis ka part kaha jata hai.

Example:

What if salary increase ho jaye?
What if expenses increase ho jaye?
What if sales decrease ho jaye?

Excel in different conditions ke results ko compare karne mein help karta hai.

3. Scenario Manager

Excel mein scenarios create aur manage karne ke liye Scenario Manager ka use hota hai.

Path:

Data → What-If Analysis → Scenario Manager

Scenario Manager se hum:

• New Scenario create kar sakte hain
• Existing Scenario edit kar sakte hain
• Scenario delete kar sakte hain
• Different scenarios ke results compare kar sakte hain
• Scenario Summary report create kar sakte hain

4. Scenario ke Important Components

Scenario banate waqt mainly 3 cheezein important hoti hain:

1. Scenario Name

Scenario ko ek meaningful name diya jata hai.

Example:

Low Sales
Normal Sales
High Sales

2. Changing Cells

Wo cells jinki values scenario ke according change hongi.

Example:

Sales
Expenses
Interest Rate
Salary

3. Result Cells

Wo cells jahan final result calculate hota hai.

Example:

Profit
Net Income
Total Cost
EMI

5. Practical Example – Business Profit

Suppose:

Sales = ₹1,00,000
Expenses = ₹70,000
Profit = Sales - Expenses

Formula:

=B2-B3

Ab hum 3 scenarios bana sakte hain.

Scenario 1 – Low Sales

Sales = ₹80,000
Expenses = ₹70,000
Profit = ₹10,000

Scenario 2 – Normal Sales

Sales = ₹1,00,000
Expenses = ₹70,000
Profit = ₹30,000

Scenario 3 – High Sales

Sales = ₹1,20,000
Expenses = ₹70,000
Profit = ₹50,000

Is tarah business owner different situations ka effect samajh sakta hai.

6. Scenario Create Karne ke Steps

Step 1

Excel sheet mein required calculations aur formulas prepare karein.

Step 2

Go to:

Data → What-If Analysis → Scenario Manager

Step 3

Add button par click karein.

Step 4

Scenario ka naam enter karein.

Example:

Low Sales

Step 5

Changing Cells select karein.

Example:

Sales Cell

Step 6

Changing cell ki value enter karein.

Step 7

Isi tarah Normal Sales aur High Sales scenarios create karein.

Step 8

Scenario Manager se different scenarios select karke results compare karein.

7. Scenario Summary

Excel different scenarios ko ek summary report mein bhi show kar sakta hai.

Example:

Isse comparison bahut easy ho jata hai.

8. Scenarios ke Practical Uses

💰 Financial Planning

Different income aur expense conditions ka analysis.

📈 Sales Planning

Low, normal aur high sales ka comparison.

👨‍💼 Salary Planning

Salary increase hone par total payroll ka analysis.

🏢 Business Planning

Different business conditions ke possible results dekhna.

🛒 Pricing Analysis

Price change hone par revenue/profit ka effect.

💳 Loan Planning

Interest rate ya payment changes ka effect analyze karna.

🔄 Scenario vs Goal Seek

⭐ Exam Points

• Scenario Excel ka What-If Analysis tool hai.
• Iska use different conditions ke possible results compare karne ke liye hota hai.
• Scenarios ko manage karne ke liye Scenario Manager use hota hai.
• Path: Data → What-If Analysis → Scenario Manager
• Scenario mein Changing Cells aur Result Cells important hote hain.
• Multiple scenarios ka Scenario Summary create kiya ja sakta hai.
• Business, finance, sales aur planning mein iska practical use hota hai.