Cost-Volume-Profit (CVP) Analysis: Break-even, Margins & Decision Making

TAKEAWAYS:

• CVP analysis links sales volume, costs, and profit using the formula: Profit = (Selling Price × Units) – (Variable Cost × Units) – Fixed Costs.
• The break-even point is where total revenue = total costs (no profit, no loss), calculated as Fixed Costs ÷ Contribution Margin per Unit.
• Contribution margin (per unit or ratio) shows how much each sale covers variable costs before fixed costs.
• Margin of safety measures how much sales can drop before losses occur: (Actual Sales – Break-even Sales) ÷ Actual Sales.
• Real-world uses include hotel room pricing, menu costing, and Daraz’s inventory decisions to maximize profitability.
• Assumptions (e.g., linear cost-volume relationships) must hold for CVP to be accurate—violations require alternative methods.

Core Concepts of CVP Analysis

CVP (Cost-Volume-Profit) analysis is a decision-making tool that examines how changes in sales volume, costs, and pricing affect a business’s profitability. It helps managers:

• Set selling prices.
• Determine break-even points.
• Plan production levels for desired profits.
• Compare cost structures (e.g., fixed vs. variable).

Key Terms

1. The CVP Formula: How It Works

The profit equation is the foundation of CVP analysis:

Profit = (Selling Price × Units Sold) – (Variable Cost × Units Sold) – Fixed Costs

Or simplified:

Profit = (Contribution Margin per Unit × Units Sold) – Fixed Costs

Visual: The Profit-Volume Graph

graph TD
    A["Sales Volume (Units)"] --> B["Total Revenue (TR)"]
    A --> C["Total Variable Cost (TVC)"]
    A --> D["Total Fixed Cost (TFC)"]
    B --> E["Profit/Loss"]
    C --> E
    D --> E

• Break-even point (BEP): Where TR = TVC + TFC (Profit = 0).
• Profit area: Above BEP (TR > TC).
• Loss area: Below BEP (TR < TC).

2. Calculating Break-Even Point (BEP)

There are three methods to find BEP:

Method 1: Equation Method

Using the profit equation:

0 = (Selling Price × Units) – (Variable Cost × Units) – Fixed Costs

Rearranged to solve for Units:

Units = Fixed Costs ÷ (Selling Price – Variable Cost per Unit)

Example: A Thamel café sells coffee at Rs 150/cup with:

• Variable cost per cup = Rs 50
• Fixed costs (rent, salaries) = Rs 30,000/month

Calculation:

BEP (units) = Rs 30,000 ÷ (Rs 150 – Rs 50) = 30,000 ÷ Rs 100 = **300 cups/month**

Verification:

• Total Revenue = 300 × Rs 150 = Rs 45,000
• Total Variable Cost = 300 × Rs 50 = Rs 15,000
• Total Fixed Cost = Rs 30,000
• Profit = Rs 45,000 – Rs 15,000 – Rs 30,000 = Rs 0 (Break-even).

Method 2: Contribution Margin Ratio

If you know the contribution margin ratio (CMR):

CMR = (Selling Price – Variable Cost) ÷ Selling Price

Then:

BEP (Sales Revenue) = Fixed Costs ÷ CMR

Example: Same café, but now we want BEP in Rs (revenue).

CMR = (Rs 150 – Rs 50) ÷ Rs 150 = 66.67%
BEP (Revenue) = Rs 30,000 ÷ 0.6667 = **Rs 45,000**

This matches the earlier result (300 cups × Rs 150 = Rs 45,000).

Method 3: Graphical Method

Plot Total Revenue (TR) and Total Cost (TC) lines:

• TR line: Starts at origin (0,0), slope = Selling Price.
• TC line: Starts at Fixed Costs on Y-axis, slope = Variable Cost per Unit.
• Intersection point = BEP.

graph LR
    A["Y-Axis: Cost/Revenue (Rs)"] --> B["Total Revenue (TR)"]
    A --> C["Total Cost (TC)"]
    B --> D["Slope = Selling Price"]
    C --> E["Fixed Costs + Variable Costs"]
    B -- Intersection --> F["Break-Even Point"]

3. Margin of Safety (MOS)

MOS shows how much sales can drop before losses occur.

MOS (Units) = Actual Sales – Break-Even Sales
MOS (%) = (MOS ÷ Actual Sales) × 100

Example: The café sells 500 cups/month (vs. BEP of 300 cups).

MOS (Units) = 500 – 300 = **200 cups**
MOS (%) = (200 ÷ 500) × 100 = **40%**

Interpretation: The café can lose 200 cups (40%) before breaking even.

4. Target Profit Analysis

To find the sales volume needed for a desired profit:

Required Sales (Units) = (Fixed Costs + Desired Profit) ÷ Contribution Margin per Unit

Example: The café wants Rs 10,000 profit/month.

Required Sales = (Rs 30,000 + Rs 10,000) ÷ Rs 100 = **400 cups**

Verification:

• Revenue = 400 × Rs 150 = Rs 60,000
• Variable Cost = 400 × Rs 50 = Rs 20,000
• Fixed Cost = Rs 30,000
• Profit = Rs 60,000 – Rs 20,000 – Rs 30,000 = Rs 10,000 ✅

In the Real World

CVP analysis is used everywhere in Nepal’s hospitality and business sectors:

1. Hotels (e.g., Radisson, Dwarika’s Hotel)

   • Problem: How many rooms to sell at what price to cover costs?
   • Solution: Use CVP to set dynamic pricing (e.g., Rs 5,000/night in peak season vs. Rs 3,000 in off-season).
   • Example: A 100-room hotel with:
     • Fixed costs = Rs 20M/year
     • Variable cost per room = Rs 1,500
     • Desired profit = Rs 5M
     • Calculation:

       Required Sales = (Rs 20M + Rs 5M) ÷ (Rs 5,000 – Rs 1,500) = **6,250 room-nights/year**
       

     • Decision: Offer discounts to fill unsold nights.

2. Daraz (Nepal’s Amazon)

   • Problem: How many orders can Daraz handle before losses?
   • Solution: CVP helps set minimum order thresholds for free shipping.
   • Example: Daraz charges Rs 100 shipping for orders < Rs 2,000.
     • Variable cost per order = Rs 50
     • Fixed costs (warehouses) = Rs 50M/year
     • BEP Orders = Rs 50M ÷ (Rs 2,000 – Rs 50) = 25,126 orders/year
     • MOS: If Daraz processes 50,000 orders, it can afford a 50% drop before breaking even.

3. Khalti & eSewa (Digital Payments)

   • Problem: How many transactions are needed to cover platform costs?
   • Solution: CVP ensures transaction fees (e.g., 2% per payment) cover fixed costs.
   • Example: eSewa has:
     • Fixed costs = Rs 100M/year
     • Variable cost per transaction = Rs 5
     • Fee = 2% of Rs 5,000 avg. transaction = Rs 100
     • Contribution per transaction = Rs 100 – Rs 5 = Rs 95
     • BEP Transactions = Rs 100M ÷ Rs 95 ≈ 1.05M transactions/year
     • Real Data: eSewa processes ~5M transactions/year → MOS = 79% (can handle big drops).

4. Nepal Airlines (Route Pricing)

   • Problem: Should they add a Kathmandu–Pokhara route?
   • Solution: CVP compares fixed costs (plane lease) vs. variable costs (fuel, crew) per flight.
   • Example:
     • Fixed cost per route = Rs 20M/year
     • Variable cost per flight = Rs 500,000
     • Ticket price = Rs 10,000
     • BEP Flights = Rs 20M ÷ (Rs 10,000 – Rs 500,000) → Not viable (negative contribution).
     • Decision: Only operate if subsidized or with higher ticket prices.

5. Assumptions of CVP Analysis

CVP relies on five key assumptions:

1. Linear cost-volume relationship: Costs and revenue change proportionally with volume.
2. Constant selling price: No discounts or price changes.
3. Constant variable and fixed costs: No economies of scale or cost increases.
4. Single product or constant mix: For multi-product firms, use weighted contribution margin.
5. No inventory changes: Relevant only for manufacturing if inventory levels are stable.

Violations? Use non-linear models or activity-based costing (ABC).

6. CVP for Decision Making

CVP helps answer critical "what-if" questions:

Example: A Pokhara restaurant sells:

• Momo: Rs 200 (variable cost = Rs 50) → Contribution = Rs 150
• Thukpa: Rs 300 (variable cost = Rs 100) → Contribution = Rs 200 Decision: Focus on thukpa (higher contribution) to maximize profit.

7. Limitations of CVP Analysis

While powerful, CVP has limitations:

• Ignores inventory: Assumes no opening/closing stock (problem for manufacturers).
• Fixed costs aren’t truly fixed: Rent may increase; salaries may rise.
• No quality considerations: Focuses only on cost, not customer satisfaction.
• Multi-product firms need adjustments: Use weighted contribution margin.
• Short-term focus: Ignores long-term strategic costs (e.g., R&D).

Workaround: Combine CVP with ABC (Activity-Based Costing) for deeper insights.

Exam Tip: How to Score Full Marks

This unit is highly numerical—expect calculations in exams. Here’s how to ace it:

1. Understand the Formula Triangle

Memorize this relationship:

Profit = (Selling Price – Variable Cost) × Units – Fixed Costs

Or rearrange for:

• Break-even units = Fixed Costs ÷ (Selling Price – Variable Cost)
• Target profit units = (Fixed Costs + Profit) ÷ (Selling Price – Variable Cost)

2. Always Show Workings

Examiners deduct marks for missing steps. Example: Question: A hotel has fixed costs of Rs 500,000, variable cost Rs 200/room, and sells at Rs 1,000/room. Calculate BEP in rooms and revenue. Answer:

1. Contribution Margin per Unit = Rs 1,000 – Rs 200 = Rs 800
2. BEP (Rooms) = Rs 500,000 ÷ Rs 800 = **625 rooms**
3. BEP (Revenue) = 625 × Rs 1,000 = **Rs 625,000**

3. Watch for Tricks

• Units vs. Revenue: Some questions ask for units, others for Rs. Always check!
• Semi-variable costs: Split into fixed + variable parts before calculating.
• Multi-product: Use weighted contribution margin (e.g., if a menu has 60% momo and 40% thukpa).

4. Common Mistakes to Avoid

❌ Ignoring units: Forgetting to divide by contribution margin per unit. ❌ Mixing fixed/variable costs: Adding fixed costs to variable costs in the wrong formula. ❌ Assuming all costs are variable: Rent, salaries, and depreciation are fixed! ❌ Not verifying: Always plug your answer back into the profit equation.

5. Past Exam Patterns

• Short answers: Define contribution margin, break-even, margin of safety (2–3 marks).
• Numerical problems: Always show all steps (5–10 marks).
• Scenario-based: Read carefully—some questions give production vs. sales data (e.g., "produced 12,000 but sold 9,000").

6. Quick Revision Checklist

Before exams, ask: ✅ Can I calculate BEP in units and revenue? ✅ Do I know how to find target profit sales? ✅ Can I explain contribution margin and MOS? ✅ Do I recognize fixed vs. variable costs in real examples (e.g., hotel vs. café)? ✅ Can I adjust for semi-variable costs?

Final Worked Example: Kathmandu Hotel

Scenario: Hotel Himalaya in Kathmandu has:

• Fixed costs (rent, salaries, utilities): Rs 12,000,000/year
• Variable cost per room-night: Rs 1,500
• Selling price per room-night: Rs 5,000
• Current occupancy: 60% (300 nights/month × 12 months = 3,600 room-nights/year)

Questions:

1. Calculate break-even room-nights/year.
2. Find the margin of safety if the hotel sells 4,000 room-nights/year.
3. What selling price is needed to break even at 3,000 room-nights/year?

Solutions:

1. Break-Even Room-Nights

Contribution Margin per Unit = Rs 5,000 – Rs 1,500 = Rs 3,500
BEP (Units) = Fixed Costs ÷ Contribution Margin = Rs 12,000,000 ÷ Rs 3,500 ≈ **3,429 room-nights/year**

2. Margin of Safety (MOS)

Actual Sales = 4,000 room-nights
MOS (Units) = 4,000 – 3,429 = **571 room-nights**
MOS (%) = (571 ÷ 4,000) × 100 ≈ **14.28%**

Interpretation: The hotel can lose 14.28% of sales before breaking even.

3. Required Selling Price for 3,000 Room-Nights

Desired Profit = Rs 0 (break-even)
Fixed Costs = Rs 12,000,000
Required Contribution = Fixed Costs ÷ Units = Rs 12,000,000 ÷ 3,000 = Rs 4,000 per room-night
Selling Price = Variable Cost + Required Contribution = Rs 1,500 + Rs 4,000 = **Rs 5,500/room-night**

Decision: Increase price from Rs 5,000 → Rs 5,500 to break even at lower occupancy.

Summary Table: CVP Key Formulas

Final Thought

CVP is not just math—it’s a decision-making tool. Whether you’re pricing a hotel room, deciding Daraz’s shipping thresholds, or setting Khalti’s transaction fees, CVP helps turn costs into profits.

Pro Tip: Always link theory to real examples in exams. If asked about break-even, mention:

"Like a Kathmandu hotel, if fixed costs (rent) are high but variable costs (cleaning per room) are low, the break-even point is lower, meaning fewer rooms need to be sold to cover costs."

Now practice with past papers! Focus on numerical problems and scenario-based questions. 🚀