Cost-Volume-Profit (CVP) & Break-Even Analysis: Key Concepts, Formulas & Real-World Applications

---

Core Concepts & Definitions

1. Cost-Volume-Profit (CVP) Analysis

Definition: CVP analysis studies how changes in costs, volume (sales), and prices affect a company’s profit. It assumes:

• Costs are linear (fixed + variable).
• All units produced are sold.
• Sales mix remains constant (for multi-product firms).
• Efficiency and productivity are constant.

Key Terms:

---

A typical CVP graph showing fixed costs (horizontal line), total costs (sloped line), total revenue (sloped line), and the break-even point where they intersect.

---

2. Break-Even Analysis: How It Works

Step-by-Step Calculation

1. Identify Fixed Costs (FC):

   • Rent, salaries, insurance, depreciation, etc.
   • Example: A Kathmandu-based biscuit manufacturing unit has fixed costs of Rs. 500,000/year.

2. Determine Variable Cost per Unit (VC):

   • Raw materials, direct labor, packaging, etc.
   • Example: Variable cost per biscuit = Rs. 10.

3. Set Selling Price (P):

   • Example: Selling price per biscuit = Rs. 20.

4. Calculate Contribution Margin (CM): $CM=P-VC=20-10=\text{Rs. 10 per biscuit}$.

5. Compute Break-Even Point (BEP) in Units: $BEP=\frac{FC}{CM}=\frac{500,000}{10}=50,000\text{ biscuits}$.

6. Compute BEP in Rupees: $BEP\text{ (Rs)}=BEP\text{ (units)}\times P=50,000\times 20=\text{Rs. 1,000,000}$.

---

WORKED EXAMPLE: Daraz’s Break-Even for a New Product Daraz is launching a smartphone accessory kit with:

• Fixed costs (FC): Rs. 2,000,000 (marketing, warehouse setup).
• Variable cost per kit (VC): Rs. 800 (raw materials, packaging, shipping).
• Selling price (P): Rs. 1,500.

Calculations:

1. Contribution Margin (CM): $CM=1,500-800=\text{Rs. 700 per kit}$.

2. Break-Even Point (BEP) in Units: $BEP=\frac{2,000,000}{700}\approx 2,857\text{ kits}$.

3. BEP in Rupees: $2,857\times 1,500=\text{Rs. 4,285,700}$.

Interpretation: Daraz must sell 2,857 kits to cover costs. If they sell 3,000 kits, profit = $(3,000-2,857)\times 700=\text{Rs. 94,900}$.

---

Break-Even Formula Variations

---

---

3. Profit-Volume (PV) Graph & Sensitivity Analysis

PV Graph Components

```figure
{"type":"curves","lines":[{"label":"Total Revenue (TR)","from":[0,0],"to":[10,100],"fns":[{"expr":"x*10","label":"TR = P*Q"}]},{"label":"Total Cost (TC)","from":[0,40],"to":[10,140],"fns":[{"expr":"40 + (x*10)","label":"TC = FC + (VC*Q)"}]},{"label":"Fixed Cost (FC)","from":[0,40],"to":[10,40],"style":"dashed"},{"label":"Variable Cost (VC)","from":[0,0],"to":[10,100],"fns":[{"expr":"x*10","label":"VC = VC*Q"}]}],"points":[{"x":4,"y":40,"label":"BEP","xmark":"Q*","ymark":"TR=TC"}],"xlabel":"Quantity (Units)","ylabel":"Amount (NPR)","caption":"PV Graph showing components: Fixed Cost (FC = 40), Variable Cost (VC = 60), and Break-Even Point (BEP = 4 units)"}

• X-axis: Sales volume (units).
• Y-axis: Rupees (costs/revenue).
• Fixed Cost (FC): Horizontal line (constant).
• Total Cost (TC): Sloped line starting at FC.
• Total Revenue (TR): Sloped line starting at origin.
• BEP: Intersection of TC and TR.

---

A graph showing FC (horizontal), TC (sloped), TR (sloped), and BEP intersection.

---

Sensitivity Analysis: "What-If" Scenarios

---

REAL WORLD: How Ncell Uses CVP Analysis Ncell plans to launch a new prepaid plan with:

• Fixed costs (FC): Rs. 100 million (network upgrades, marketing).
• Variable cost per MB (VC): Rs. 0.10.
• Revenue per MB (P): Rs. 0.50.
• Target profit: Rs. 20 million.

Calculations:

1. CM per MB: ( 0.50 - 0.10 = \text{Rs. 0.40} ).
2. BEP for Target Profit: ( BEP = \frac{100,000,000 + 20,000,000}{0.40} = 300,000,000 \text{ MB} ).
3. Margin of Safety (MoS): If Ncell expects 400 million MB sales, MoS = ( 400 - 300 = 100 \text{ million MB} ).

Why It Matters: Ncell can now:

• Set minimum sales targets to avoid losses.
• Adjust marketing spend if BEP is too high.
• Compare with NTC’s plans to price competitively.

---

4. Margin of Safety (MoS) & Operating Leverage

Margin of Safety (MoS)

Definition: Measures how much sales can drop before the company incurs a loss. [ MoS = \text{Actual Sales} - BEP \text{ (units)} ] [ MoS \text{ (%)} = \frac{MoS}{Actual Sales} \times 100 ]

Example: Kathmandu Traffic Routes (Analogy)

• Actual traffic volume (sales): 100,000 vehicles/day.
• BEP (minimum for no congestion): 70,000 vehicles.
• MoS: ( 100,000 - 70,000 = 30,000 ) vehicles.
• MoS (%): ( \frac{30,000}{100,000} \times 100 = 30% ).

Interpretation: If traffic drops by 30%, roads reach BEP (congestion = cost).

---

Operating Leverage

Definition: Measures how fixed costs amplify changes in sales into profit changes. [ \text{Operating Leverage} = \frac{Contribution Margin}{Net Profit} ]

Example:

• Company A: High fixed costs (e.g., Daraz’s warehouse rent).
• Company B: Low fixed costs (e.g., a local tea stall).
• Impact: A 10% sales increase for Company A may boost profit by 30%, while Company B sees only a 10% profit increase.

Why It Matters:

• High operating leverage = higher risk but higher reward.
• Low operating leverage = stable but lower profit growth.

---

---

5. Multi-Product Break-Even Analysis

Weighted Average Contribution Margin

When a company sells multiple products, BEP is calculated using a weighted average CM based on sales mix.

Formula: [ \text{Weighted CM} = \sum (\text{Product CM} \times \text{Sales Mix %}) ] [ BEP = \frac{FC}{\text{Weighted CM}} ]

---

WORKED EXAMPLE: Sony Manufacturing (Past Exam Question) Sony produces Product X and Y with the following data:

Calculations:

1. Weighted CM: ( (200 \times 0.50) + (300 \times 0.50) = 100 + 150 = \text{Rs. 250 per unit} ).

2. BEP in Units: ( \frac{8,000,000}{250} = 32,000 \text{ units} ).

Interpretation: Sony must sell 32,000 units total (not per product) to break even.

---

```figure
{"type":"pie","labels":["Product X (50%)","Product Y (50%)"],"values":[50,50],"caption":"Sales mix for Sony products (50% each) with weighted average contribution margin calculation"}

---

6. Limitations of CVP Analysis

While powerful, CVP has assumptions that may not hold in reality:

---

REAL WORLD: How Khalti Handles CVP Limitations Khalti’s transaction fees are mostly variable (Rs. 10-20 per transaction), but:

• Fixed costs include server maintenance and customer support.
• Sales mix changes during Dashain/Tihar (high-volume periods).
• Discounts are offered to merchants (e.g., lower fees for bulk payments).

Solution: Khalti uses segmented CVP analysis to adjust for:

1. Peak vs. off-peak transaction volumes.
2. Different fee structures for individuals vs. businesses.

---

7. Practical Applications in Nepali Businesses

Case 1: Daraz’s Pricing Strategy

Daraz sells electronics with:

• FC: Rs. 50 million (warehouse, logistics).
• VC per product: Rs. 2,000.
• Selling price: Rs. 5,000.
• CM: Rs. 3,000.
• BEP: $\frac{50,000,000}{3,000}\approx 16,667\text{ units}$.

Decision:

• If Daraz expects 20,000 sales, profit = $(20,000-16,667)\times 3,000=\text{Rs. 10 million}$.
• Action: Offer discounts to increase sales beyond BEP.

---

Case 2: NTC’s Break-Even for New Towers

NTC installs a new 5G tower with:

• FC: Rs. 200 million (tower, licenses).
• VC per minute: Rs. 0.05.
• Revenue per minute: Rs. 0.20.
• CM per minute: Rs. 0.15.
• BEP: $\frac{200,000,000}{0.15}\approx 1.33\text{ billion minutes}$.

Interpretation: NTC must ensure 1.33 billion minutes of usage to cover costs. If actual usage is 1.5 billion, profit = $(1.5-1.33)\times 0.15=\text{Rs. 24.5 million}$.

---

Case 3: Local Biscuit Manufacturer (Kathmandu)

A small factory produces biscuits with:

• FC: Rs. 300,000 (rent, salaries).
• VC per kg: Rs. 150.
• Selling price per kg: Rs. 300.
• CM per kg: Rs. 150.
• BEP: $\frac{300,000}{150}=2,000\text{ kg}$.

MoS Calculation:

• Actual sales: 3,000 kg.
• MoS: $3,000-2,000=1,000\text{ kg}$.
• MoS (%): $\frac{1,000}{3,000}\times 100=33.3\%$.

Decision:

• The factory can afford a 33% sales drop before breaking even.
• Action: Invest in marketing to increase sales beyond 3,000 kg.

---

Exam Tip: How to Score Full Marks

1. Always Show Workings

• Never just write the final answer. Show step-by-step calculations (e.g., CM → BEP).
• Example: ❌ Wrong: "BEP = 50,000 units." ✅ Correct:

  CM = Rs. 10
  BEP = FC / CM = 500,000 / 10 = 50,000 units.
  

2. Use Tables for Clarity

• Present data in well-formatted tables (like the Sony example above).
• Label columns clearly (e.g., "Dr.", "Cr.", "Total").

3. Explain Assumptions

• Exams often ask: "What are the limitations of CVP?"
• Answer:

  "CVP assumes linear costs, constant sales mix, and no inventory changes. In reality, costs may be semi-variable (e.g., overtime labor), and product demand fluctuates (e.g., seasonal sales)."

4. Link to Real-World Scenarios

• Example Question:

  "A company has FC = Rs. 200,000, VC = Rs. 50 per unit, P = Rs. 100. Calculate BEP and explain its relevance to a Nepali business like Daraz."

• Answer:

  "BEP = 200,000 / (100 - 50) = 4,000 units. For Daraz, this means they must sell 4,000 units of a product to cover costs. If actual sales are higher, they earn profit; if lower, they incur losses. Daraz can use this to set minimum sales targets for new products."

5. Graphs Are Worth Marks

• If asked to "draw a PV graph", sketch it neatly with:
  • X-axis: Sales volume.
  • Y-axis: Costs/revenue.
  • Label BEP, FC, and TR/TC lines.

6. Common Mistakes to Avoid

• Mixing up fixed and variable costs.
• Forgetting to convert BEP from units to rupees when asked.
• Ignoring the sales mix in multi-product questions.
• Not calculating MoS when asked about "safety" or "risk."

---

Sample Exam Question & Model Answer

Question: A manufacturing company has fixed costs of Rs. 1,000,000 and variable costs of Rs. 60 per unit. The selling price is Rs. 100 per unit. Calculate:

1. Break-even point in units and rupees.
2. Margin of safety if actual sales are 20,000 units.
3. Operating leverage if net profit is Rs. 200,000.

Model Answer:

1. Break-Even Point:

   • Contribution Margin (CM): $100-60=\text{Rs. 40 per unit}$.
   • BEP in Units: $\frac{1,000,000}{40}=25,000\text{ units}$.
   • BEP in Rupees: $25,000\times 100=\text{Rs. 2,500,000}$.

2. Margin of Safety:

   • Actual Sales: 20,000 units.
   • MoS (units): $20,000-25,000=-5,000\text{ units}$. (Negative MoS means the company is already at a loss.)
   • MoS (%): $\frac{-5,000}{20,000}\times 100=-25\%$. (Interpretation: The company is operating 25% below break-even.)

3. Operating Leverage:

   • Total CM: $20,000\times 40=\text{Rs. 800,000}$.
   • Operating Leverage: $\frac{800,000}{200,000}=4$. (Interpretation: A 1% increase in sales leads to a 4% increase in profit.)

---

Final Checklist Before Submitting

✅ All formulas applied correctly. ✅ Units and rupees clearly labeled. ✅ Assumptions stated (if any). ✅ Real-world link provided (if applicable). ✅ Graphs/tables neat and professional. ✅ No calculation errors (double-check!).