CVP Analysis: Break-Even, Profit Planning & Sensitivity

Core Concepts

1. Definitions & Key Terms

Key Terms:

• Contribution Margin (CM): Revenue remaining after variable costs; used to cover fixed costs and generate profit. $$CM=\text{Sales Revenue}-\text{Variable Cost}$$
• Break-Even Point (BEP): Volume where total revenue equals total cost (profit = 0). $$BEP(\text{units})=\frac{\text{Fixed Cost}}{CM\text{ per unit}}$$
• Margin of Safety (MoS): Excess sales above BEP; measures operational cushion. $$MoS=\text{Actual Sales}-\text{BEP Sales}$$
• Degree of Operating Leverage (DOL): Sensitivity of profit to changes in sales volume. $$DOL=\frac{CM}{Profit}$$

---

2. How CVP Works: The Mathematical Model

Step-by-Step Calculation:

1. Identify Costs:
   • Fixed Cost (FC): Rent, salaries, insurance (do not change with volume).
   • Variable Cost (VC): Direct materials, labor, commissions (change per unit).
2. Calculate Contribution Margin per Unit: $$CM=\text{Selling Price (SP)}-\text{Variable Cost per Unit (VCU)}$$
3. Determine Break-Even Point (Units): $$BEP(\text{units})=\frac{FC}{CM}$$
4. Calculate Target Profit Volume: $$\text{Volume}=\frac{FC+\text{Desired Profit}}{CM}$$

Example (Nepali Business): Kathmandu Retail Shop (KRS) Ltd.

• Selling Price (SP): Rs 500 per unit
• Variable Cost per Unit (VCU): Rs 300
• Fixed Cost (FC): Rs 200,000/month
• Desired Profit: Rs 50,000

Calculations:

Graphical Representation:

---

3. Applications in Real-World Nepali Businesses

Example 1: eSewa (Digital Payment Platform)

• Idea Used: Break-Even Analysis for Transaction Fees
  • eSewa charges a 1.5% transaction fee on digital payments.
  • Fixed Costs: Server maintenance (Rs 500,000/month), customer support (Rs 300,000/month).
  • Variable Cost: Per-transaction processing cost (Rs 2/transaction).
  • Selling Price (Revenue): 1.5% of transaction value.
  • BEP Calculation:
    • Assume average transaction = Rs 5,000.
    • CM per transaction = Revenue − VC = (1.5% of 5,000) − 2 = Rs 75 − Rs 2 = Rs 73.
    • BEP Transactions = FC / CM = (500,000 + 300,000) / 73 ≈ 10,960 transactions/month.
    • Implication: eSewa needs ~11,000 transactions/month to cover costs before profit.

Example 2: Daraz (E-Commerce) – Inventory Management

• Idea Used: Cost-Volume-Profit for Pricing Strategy
  • Daraz sells a product at Rs 2,000/unit.
  • Variable Cost: Rs 1,200 (supplier cost + shipping).
  • Fixed Cost: Rs 500,000 (warehouse rent, marketing).
  • BEP (units) = 500,000 / (2,000 − 1,200) = 1,250 units/month.
  • Profit Planning: If Daraz wants Rs 200,000 profit, it needs: $$\text{Volume}=\frac{500,000+200,000}{800}=937.5\text{ units}$$
  • Real-World Impact: Daraz uses CVP to set minimum order quantities for sellers to ensure profitability.

Example 3: NTC (Telecom) – Pricing Mobile Plans

• Idea Used: Degree of Operating Leverage (DOL) for Risk Assessment
  • NTC offers a Rs 1,500/month plan with:
    • Fixed Cost: Rs 800 (network infrastructure).
    • Variable Cost: Rs 500 (data usage).
    • Contribution Margin: Rs 1,500 − Rs 500 = Rs 1,000.
    • Profit at 50,000 users: Rs 1,000 × 50,000 − (FC × 50,000) = Rs 45,000,000.
  • DOL Calculation: $$DOL=\frac{CM}{Profit}=\frac{1,000\times 50,000}{45,000,000}=1.11$$
  • Interpretation: A 1% increase in sales volume leads to a 1.11% increase in profit. High DOL means higher risk if sales drop.

---

4. Multi-Product CVP Analysis

When a company sells multiple products, CVP requires:

1. Sales Mix Assumption: Ratio of products sold (e.g., 60% Product A, 40% Product B).
2. Weighted Contribution Margin: $$\text{Weighted CM}=(C{M}_A\times {\text{Percentage}}_A)+(C{M}_B\times {\text{Percentage}}_B)$$
3. BEP Calculation: $$BEP(\text{units})=\frac{FC}{\text{Weighted CM}}$$

Example: Kathmandu Bakery (KB) Ltd.

• Product A (Cakes): SP = Rs 300, VC = Rs 150 → CM = Rs 150
• Product B (Pastries): SP = Rs 200, VC = Rs 100 → CM = Rs 100
• Sales Mix: 70% Cakes, 30% Pastries
• Fixed Cost: Rs 100,000/month

Calculations:

BEP (units): $$\frac{100,000}{135}\approx 741\text{ units (total)}$$

• Breakdown:
  • Cakes: 70% of 741 ≈ 519 units
  • Pastries: 30% of 741 ≈ 222 units

---

5. Sensitivity Analysis & Profit Planning

CVP helps businesses plan for uncertainties using:

• What-if Scenarios: How changes in price, costs, or volume affect profit.
• Margin of Safety (MoS): Shows how much sales can drop before losses occur. $$MoS(\%)=\frac{\text{Actual Sales}-BEP\text{ Sales}}{Actual\text{ Sales}}\times 100$$
• Operating Leverage: High DOL means higher profit sensitivity to sales changes.

Example: Pathao (Ride-Hailing) – Driver Pricing

• Fixed Cost (FC): Rs 200,000 (app development, customer support).
• Variable Cost (VC): Rs 100 per ride (driver commission, fuel).
• Price per Ride: Rs 250
• Current Sales: 10,000 rides/month
• BEP Rides: 200,000 / (250 − 100) = 2,000 rides/month
• MoS: (10,000 − 2,000) / 10,000 × 100 = 80%
  • Interpretation: Pathao can lose 20% of rides before breaking even.

---

6. Limitations of CVP Analysis

---

7. Practical Steps for Profit Planning

1. Estimate Sales Volume: Use past data or market research.
2. Calculate Costs: Separate fixed and variable costs accurately.
3. Determine BEP: Find the minimum sales needed to cover costs.
4. Set Profit Targets: Decide on desired profit margins.
5. Adjust Pricing/Mix: Use CVP to optimize pricing or product mix.
6. Monitor & Adjust: Track actual vs. planned performance.

Example: NEPSE (Stock Exchange) – IPO Pricing

• Company: New Nepali Tech Startup (NTS)
• Fixed Costs: Rs 50,000,000 (R&D, legal fees).
• Variable Costs: Rs 500 per share (marketing, underwriting).
• Desired Profit: Rs 20,000,000
• Target Shares to Sell: $$\text{Shares}=\frac{FC+Profit}{SP-VC}=\frac{50,000,000+20,000,000}{SP-500}$$
• If SP = Rs 2,000: $$\text{Shares}=\frac{70,000,000}{1,500}\approx 46,667\text{ shares}$$
• Implication: NTS must sell ~46,667 shares at Rs 2,000 to break even + profit.

---

Exam Tip: How to Score Full Marks

1. Always Show Calculations:

   • Examiners reward step-by-step working (e.g., BEP, CM, MoS).
   • Example: For a question on break-even, write:

     Step 1: CM = SP − VC = Rs X − Rs Y = Rs Z
     Step 2: BEP (units) = FC / CM = Rs A / Rs Z = B units
     

2. Use Real-World Examples:

   • Relate answers to Nepali businesses (eSewa, Daraz, NTC, banks).
   • Example: "Like eSewa, which charges a transaction fee, the break-even point helps determine the minimum number of transactions needed to cover server and customer support costs."

3. Graphs & Tables:

   • Draw a break-even chart (even if rough) to visualize profit/loss zones.
   • Use tables for multi-product CVP (show weighted CM clearly).

4. Highlight Assumptions:

   • CVP relies on linearity, constant costs, and single product. State these explicitly.

5. Common Pitfalls to Avoid:

   • Mixing fixed and variable costs in calculations.
   • Ignoring sales mix in multi-product questions.
   • Forgetting units (e.g., BEP in units vs. revenue).

Past Exam Question Analysis: Question: "A company has a BEP of 5,000 units. If fixed costs increase by 20% and variable cost per unit increases by 10%, what is the new BEP?" Solution Steps:

1. Let original FC = Rs X, VC = Rs Y, SP = Rs Z.
2. Original BEP: $X/(Z-Y)=5,000$ → $X=5,000(Z-Y)$.
3. New FC = 1.2X, New VC = 1.1Y.
4. New BEP = $1.2X/(Z-1.1Y)$.
5. Substitute $X=5,000(Z-Y)$: $$\text{New BEP}=\frac{1.2\times 5,000(Z-Y)}{Z-1.1Y}=\frac{6,000(Z-Y)}{Z-1.1Y}$$
6. Numerical Example: If Z = Rs 10, Y = Rs 6: $$\text{New BEP}=\frac{6,000(10-6)}{10-6.6}=\frac{24,000}{3.4}\approx 7,059\text{ units}$$

---

Final Note: CVP is not just math—it’s a strategic tool used by every business to make pricing, production, and investment decisions. Master the formulas, graphs, and real-world links, and you’ll ace this unit!