Cost-Volume-Profit Analysis: Break-even, Margin & Decision Tools

Core Concepts & Definitions

1. Cost-Volume-Profit (CVP) Relationship

The CVP analysis examines how changes in costs, volume (sales units), and pricing affect a company’s profit. It helps managers:

• Set selling prices
• Determine production levels
• Assess profitability under different scenarios

Key Terms

2. The CVP Equation & Break-even Analysis

The CVP equation is the foundation of this analysis: $$\text{Profit}=(\text{Selling Price}\times \text{Quantity})-\text{Fixed Costs}-(\text{Variable Cost per Unit}\times \text{Quantity})$$ At break-even, profit = 0: $$0=(SP\times Q)-FC-(VC\times Q)$$ Rearranged to find BEP in units: $$Q_{BEP}=\frac{FC}{SP-VC}=\frac{FC}{CM}$$

Worked Example: Kathmandu Tea Shop

Scenario: A small tea shop in Thamel sells masala chai at ₹50 per cup.

• Fixed Costs (FC): ₹15,000/month (rent, salaries)
• Variable Cost per Cup (VC): ₹10 (milk, tea leaves, sugar)
• Current Sales: 500 cups/month

Step 1: Calculate Contribution Margin (CM)

$$CM=SP-VC=₹50-₹10=₹40\text{ per cup}$$

Step 2: Find Break-even Point (BEP) in Units

$$Q_{BEP}=\frac{FC}{CM}=\frac{₹15,000}{₹40}=375\text{ cups}$$ Interpretation: The shop must sell 375 cups to cover all costs.

Step 3: Calculate Current Profit

$$\text{Profit}=(SP\times Q)-FC-(VC\times Q)=(₹50\times 500)-₹15,000-(₹10\times 500)=₹5,000$$

Step 4: Margin of Safety (MoS)

$$MoS=\text{Actual Sales}-BEP=500-375=125\text{ cups}$$ Interpretation: The shop can sell 125 fewer cups before breaking even.

3. Graphical Representation of CVP

graph TD
    A["Total Revenue (TR)"] -->|"Linear, upward slope"| B["Sales Volume (Q)"]
    C["Total Cost (TC)"] -->|"Fixed Costs + Variable Costs"| D["Sales Volume (Q)"]
    E["Break-even Point"] -->|"Where TR = TC"| F["Profit Zone"]
    G["Loss Zone"] -->|"Where TR < TC"| H["Below BEP"]
    I["Profit Zone"] -->|"Where TR > TC"| J["Above BEP"]

Key Observations:

• TR (Total Revenue) is a straight line starting from the origin.
• TC (Total Cost) is a straight line starting at FC (y-intercept).
• The intersection point = Break-even Point.
• Above BEP = Profit.
• Below BEP = Loss.

In the Real World

1. Daraz (Nepal’s Amazon)

   • Uses CVP analysis to decide minimum order quantities for sellers.
   • Example: If Daraz’s fixed costs for a product category are ₹500,000 and the contribution margin per item is ₹200, the break-even sales volume is 2,500 units. Sellers must meet this to avoid losses.

2. Ncell (Telecom Operator)

   • Applies CVP to set prepaid vs. postpaid pricing.
   • Example: If Ncell’s fixed costs for a data plan are ₹10 million and the variable cost per GB is ₹5, the break-even data sales (at ₹20/GB) is 500,000 GB. This helps them decide discount strategies.

3. Khalti (Digital Payment App)

   • Uses CVP to determine transaction fees.
   • Example: If Khalti’s fixed costs for processing payments are ₹2 million/month and the variable cost per transaction is ₹2, the break-even transactions (at ₹10/transaction fee) is 200,000 transactions. This guides their merchant fee structure.

4. Assumptions of CVP Analysis

CVP analysis relies on simplifying assumptions. While useful, these must be considered:

5. Applications of CVP Analysis

A. Pricing Decisions

• Helps set minimum prices to cover costs.
• Example: A Kathmandu furniture shop selling chairs at ₹2,000 with ₹1,200 variable cost and ₹50,000 fixed costs must sell 50 chairs to break even.

B. Production Decisions

• Determines optimal production levels.
• Example: A biscuit factory with ₹100,000 fixed costs and ₹5 CM per biscuit needs to sell 20,000 biscuits to break even.

C. Profit Planning

• Estimates profit at different sales volumes.
• Example: If a Thamel restaurant sells 1,000 meals/month at ₹500 each with ₹200 variable cost and ₹100,000 fixed costs, its profit is: $$(₹500-₹200)\times 1,000-₹100,000=₹300,000-₹100,000=₹200,000$$

D. Special Order Decisions

• Evaluates one-time orders below normal selling price.
• Example: A Daraz seller gets an offer for 1,000 units at ₹500 (normal price: ₹800, variable cost: ₹300).
  • CM per unit: ₹500 - ₹300 = ₹200
  • Total CM: ₹200,000
  • Decision: Accept if additional fixed costs (e.g., shipping) < ₹200,000.

6. Limitations & Criticisms

While powerful, CVP analysis has real-world constraints:

7. Advanced: Multi-Product CVP Analysis

When a company sells multiple products, the weighted average contribution margin is used.

Example: A Kathmandu Café Selling Tea & Coffee

Step 1: Calculate Weighted Average CM

$$\text{Weighted CM}=(₹40\times 0.6)+(₹60\times 0.4)=₹24+₹24=₹48\text{ per "unit"}$$ (Here, 1 "unit" = 60% tea + 40% coffee.)

Step 2: Find Break-even in "Units"

$$Q_{BEP}=\frac{FC}{WeightedCM}=\frac{₹15,000}{₹48}=312.5\text{ units}$$ Interpretation: The café must sell 312.5 "units" (≈ 187.5 tea + 125 coffee) to break even.

8. Exam Tip: How to Score Full Marks

Common Exam Questions & How to Answer

1. Calculate Break-even Point (BEP)

   • What examiners want: Correct formula, clear steps, and units (not just money).
   • How to answer:
     • Write the CVP equation.
     • Calculate CM per unit.
     • Use $Q_{BEP}=\frac{FC}{CM}$.
     • Always state the answer in units (e.g., "375 cups").

2. Determine Profit at a Given Sales Volume

   • What examiners want: Correct profit calculation using SP × Q – (FC + VC × Q).
   • How to answer:
     • Calculate total revenue (SP × Q).
     • Calculate total variable cost (VC × Q).
     • Subtract FC and TVC from TR.

3. Margin of Safety (MoS) Questions

   • What examiners want: Difference between actual sales and BEP.
   • How to answer:
     • First, find BEP in units.
     • Subtract from actual sales.
     • Express as a percentage if asked (e.g., "MoS is 25% of sales").

4. Special Order Decisions

   • What examiners want: Whether to accept/reject based on additional CM.
   • How to answer:
     • Calculate CM per unit for the special order.
     • Check if additional FC (if any) is covered.
     • Decision rule: Accept if CM > additional costs.

5. Graphical CVP Questions

   • What examiners want: A correctly labeled graph with TR, TC, and BEP.
   • How to answer:
     • Draw TR as a straight line from origin.
     • Draw TC as a straight line starting at FC.
     • Mark BEP where lines intersect.
     • Shade profit and loss zones.

Final Checklist Before Submission

✅ Units: Always specify whether BEP is in units, rupees, or percentage. ✅ Formulas: Write the CVP equation clearly. ✅ Assumptions: Mention if the question involves single vs. multi-product. ✅ Real-world tie: Relate answers to Nepali businesses (e.g., Daraz, Khalti, local shops). ✅ Graphs: If asked for a graph, label axes, lines, and BEP.

Practice Question (Solve Before Exam)

Scenario: A Pokhara electronics shop sells smartphones at ₹30,000 each.

• Fixed Costs: ₹5,000,000/year (rent, salaries)
• Variable Cost per Phone: ₹15,000
• Current Sales: 300 phones/year

Questions:

1. Calculate the break-even point in units.
2. Determine the profit at current sales.
3. If the shop wants a ₹2,000,000 profit, how many phones must it sell?
4. What is the margin of safety in units and percentage?

Answer Structure:

1. BEP in units: $$CM=₹30,000-₹15,000=₹15,000$$ $$Q_{BEP}=\frac{₹5,000,000}{₹15,000}=333.33\text{ phones}$$
2. Current Profit: $$\text{Profit}=(₹30,000\times 300)-₹5,000,000-(₹15,000\times 300)=₹4,000,000-₹5,000,000-₹4,500,000=-₹500,000\text{ (Loss)}$$
3. Phones for ₹2M Profit: $$\text{Required Sales}=\frac{FC+\text{Desired Profit}}{CM}=\frac{₹5,000,000+₹2,000,000}{₹15,000}=533.33\text{ phones}$$
4. Margin of Safety: $$MoS(units)=300-333.33=-33.33\text{ (Currently in loss zone)}$$ (If sales were 400 phones: MoS = 400 - 333.33 = 66.67 units)

A labeled CVP graph showing TR, TC, and BEP for a Nepali business. (Image: Slade74, CC0, via Wikimedia Commons)