CVP Analysis: Break-even, Profit Planning & Sensitivity

TAKEAWAYS:

• CVP analysis links sales volume, costs, and profits to predict break-even and target profits using the formula: Profit = (P × Q) – (F + V × Q), where P = price, Q = quantity, F = fixed costs, V = variable cost per unit.
• Break-even point (BEP) is where total revenue equals total costs (profit = 0). It can be calculated in units or sales value.
• Margin of safety (MOS) measures how much sales can drop before losses occur: MOS = Actual Sales – Break-even Sales.
• Profit planning uses CVP to set sales targets, pricing strategies, and cost controls (e.g., Daraz adjusting delivery fees based on demand).
• Sensitivity analysis tests how changes in price, costs, or volume affect profit (critical for NEPSE-listed companies like Nabil Bank).
• Assumptions of CVP (linear cost behavior, constant selling price, single product) must be checked in real-world scenarios.

---

1. Introduction to Cost-Volume-Profit (CVP) Analysis

CVP analysis is a profit-planning tool that examines how changes in costs, volume, and price affect a company’s profitability. It helps managers:

• Determine the break-even point (where revenue covers costs).
• Set sales targets to achieve desired profits.
• Assess the impact of pricing or cost changes on profitability.

Why is CVP important?

• Used by Nepali businesses (e.g., hotels, retail shops) to decide pricing, promotions, and cost cuts.
• Helps e-commerce platforms (like Daraz) optimize delivery fees and discounts.
• Guides government agencies (e.g., NTC) in setting tariffs for electricity/water.

---

2. Key Terms and Formulas

A. Cost Behavior: Fixed vs. Variable Costs

Costs are classified based on their behavior with changes in production/sales volume.

B. Contribution Margin

The contribution margin (CM) is the amount each unit contributes to covering fixed costs and profit after variable costs. Formula: $$\text{Contribution Margin per Unit (CMU)}=\text{Selling Price per Unit (P)}-\text{Variable Cost per Unit (V)}$$ $$\text{Total Contribution Margin}=\text{CMU}\times \text{Quantity (Q)}$$

Example (Nepali Retail Shop): A Kathmandu grocery shop sells 100 kg of rice at Rs 120/kg. Variable costs (packaging, labor) are Rs 80/kg. Fixed costs (rent, utilities) are Rs 5,000/month.

• CMU = Rs 120 – Rs 80 = Rs 40/kg
• Total CM for 100 kg = Rs 40 × 100 = Rs 4,000
• Profit = Total CM – Fixed Costs = Rs 4,000 – Rs 5,000 = –Rs 1,000 (Loss!)

---

3. Break-Even Analysis

The break-even point (BEP) is where Total Revenue (TR) = Total Costs (TC), and profit = 0.

A. Break-Even in Units

$$\text{BEP (units)}=\frac{\text{Fixed Costs (F)}}{\text{Contribution Margin per Unit (CMU)}}$$ Example (Continued): For the Kathmandu shop:

• BEP (units) = Rs 5,000 / Rs 40 = 125 kg
• Break-even revenue = 125 kg × Rs 120 = Rs 15,000

B. Break-Even in Sales Value (Rs)

$$\text{BEP (Rs)}=\frac{\text{Fixed Costs (F)}}{\text{Contribution Margin Ratio (CMR)}}$$ Where: $$\text{CMR}=\frac{\text{CMU}}{\text{Selling Price per Unit (P)}}$$ For the shop:

• CMR = Rs 40 / Rs 120 = 33.33%
• BEP (Rs) = Rs 5,000 / 0.3333 = Rs 15,000 (matches the unit calculation).

---

4. Profit-Volume (PV) Graph

A PV graph visually shows how profit changes with sales volume.

Key Points on the Graph:

• TR line: Starts at origin, slopes upward.
• TVC line: Starts at origin, slopes upward (steeper if variable costs are high).
• TFC line: Horizontal line (constant).
• Break-even point: Where TR and TC (TVC + TFC) intersect.
• Profit area: Above the break-even point.
• Loss area: Below the break-even point.

---

5. Margin of Safety (MOS)

MOS measures how much sales can fall before the company starts incurring losses. $$\text{MOS (units)}=\text{Actual Sales}-\text{Break-even Sales}$$ $$\text{MOS (Rs)}=\text{Actual Revenue}-\text{Break-even Revenue}$$ $$\text{MOS Ratio}=\frac{\text{MOS (units)}}{\text{Actual Sales (units)}}\times 100\%$$

Example (Nepali Hotel): A Kathmandu hotel has:

• Actual sales: 500 rooms/month at Rs 5,000/room.
• BEP: 300 rooms.
• MOS (units) = 500 – 300 = 200 rooms
• MOS (Rs) = 500 × Rs 5,000 – 300 × Rs 5,000 = Rs 1,000,000
• MOS Ratio = (200/500) × 100 = 40%

Interpretation: The hotel can lose 40% of its sales (200 rooms) before breaking even.

---

6. Profit Planning and Target Profit

Managers use CVP to set sales targets to achieve a desired profit.

A. Target Profit in Units

$$\text{Required Sales (units)}=\frac{\text{Fixed Costs (F)}+\text{Target Profit}}{\text{Contribution Margin per Unit (CMU)}}$$

Example (Daraz Delivery Service): Daraz wants a target profit of Rs 500,000/month.

• Fixed costs (warehouse rent, salaries): Rs 2,000,000
• Variable cost per delivery: Rs 150
• Selling price per delivery: Rs 300
• CMU = Rs 300 – Rs 150 = Rs 150
• Required sales = (Rs 2,000,000 + Rs 500,000) / Rs 150 = 16,667 deliveries/month

B. Target Profit in Sales Value

$$\text{Required Sales (Rs)}=\frac{\text{Fixed Costs (F)}+\text{Target Profit}}{\text{Contribution Margin Ratio (CMR)}}$$

---

7. Sensitivity Analysis

Tests how changes in price, costs, or volume affect profit. Used by:

• Nepali banks (e.g., Nabil Bank) to assess loan interest rate risks.
• E-commerce (e.g., Daraz) to adjust discount thresholds.
• Telecom (e.g., Ncell) to optimize call plan pricing.

Example (Khalti Transaction Fees): Khalti charges a 2.5% fee on transactions. If they reduce it to 2%, how does profit change?

• Current profit: Rs 500,000 from 200,000 transactions at Rs 50 avg. value.
• New fee: Rs 50 × 2% = Rs 1 → New profit = 200,000 × Rs 1 = Rs 200,000 (down by Rs 300,000).

---

8. Limitations of CVP Analysis

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

---

In the Real World

1. Daraz (E-commerce)

   • Uses CVP to set delivery fees: If variable costs (fuel, labor) rise, Daraz adjusts fees to maintain profit margins.
   • Break-even analysis helps decide minimum order values for free shipping (e.g., "Free delivery on orders above Rs 1,000").

2. Nepal Telecom (NTC) and Ncell

   • Tariff planning: NTC uses CVP to set call/data rates. If fixed costs (network maintenance) rise, they may increase tariffs.
   • Sensitivity analysis: Tests how a 10% price hike affects subscriber numbers.

3. Nepali Hotels (e.g., Yak & Yeti, Dwarika’s)

   • Room pricing: Hotels use CVP to decide seasonal rates. In monsoon (low demand), they lower prices to hit break-even.
   • Food & Beverage (F&B): Restaurants calculate CM per menu item (e.g., Rs 200 dish with Rs 50 cost → 75% CM).

4. Khalti (Digital Payments)

   • Transaction fees: Khalti’s 2.5% fee is set using CVP. If merchant volume drops, they may reduce fees to boost usage.

5. Nabil Bank (Loan Interest)

   • Loan pricing: Banks use CVP to set interest rates. Fixed costs (branch salaries) + variable costs (default risk) determine profit per loan.

---

9. Worked Example: Kathmandu Retail Shop

Scenario: A Kathmandu grocery shop sells rice with the following data:

• Selling price per kg: Rs 120
• Variable cost per kg: Rs 80 (packaging, labor)
• Fixed costs per month: Rs 5,000 (rent, utilities)
• Current sales: 150 kg/month

Questions:

1. Calculate the break-even point in units and Rs.
2. Determine the margin of safety at current sales.
3. What sales volume is needed to earn a profit of Rs 3,000/month?

Solutions:

1. Break-Even Point

• CMU = Rs 120 – Rs 80 = Rs 40/kg
• BEP (units) = Fixed Costs / CMU = Rs 5,000 / Rs 40 = 125 kg
• BEP (Rs) = 125 kg × Rs 120 = Rs 15,000

2. Margin of Safety

• Actual sales = 150 kg
• MOS (units) = 150 – 125 = 25 kg
• MOS (Rs) = 150 × Rs 120 – 125 × Rs 120 = Rs 3,000
• MOS Ratio = (25/150) × 100 = 16.67%

3. Target Profit of Rs 3,000

$$\text{Required Sales}=\frac{\text{Fixed Costs}+\text{Target Profit}}{\text{CMU}}=\frac{\text{Rs 5,000}+\text{Rs 3,000}}{\text{Rs 40}}=175\text{ kg}$$

Interpretation:

• The shop is already at break-even (150 kg) but needs to sell 175 kg to earn Rs 3,000 profit.
• Current MOS (25 kg) means it can afford a 16.67% drop in sales before losing money.

---

10. Exam Tip: How to Score Full Marks

Based on past TU/PU/NEB exam patterns, here’s how to ace this unit:

A. Common Exam Question Types

B. Step-by-Step Answering Strategy

1. Understand the question: Identify what’s asked (BEP, MOS, target profit, etc.).
2. Write the formula: Always start with the correct equation.
3. Plug in numbers: Use given data and units (e.g., Rs, kg, units).
4. Interpret results: Explain what the answer means (e.g., "The shop must sell 175 kg to earn Rs 3,000 profit").
5. Check assumptions: If the question asks for limitations, link to real-world scenarios.

C. Model Answer for a 7-Mark Question

Question: A manufacturing company has fixed costs of Rs 200,000 and a contribution margin of Rs 50 per unit. Calculate:

1. Break-even point in units.
2. Required sales to earn a profit of Rs 50,000.
3. Margin of safety if actual sales are 6,000 units.

Answer:

1. Break-even point (units): $$\text{BEP}=\frac{\text{Fixed Costs}}{\text{CMU}}=\frac{\text{Rs 200,000}}{\text{Rs 50}}=4,000\text{ units}$$

2. Required sales for Rs 50,000 profit: $$\text{Required Sales}=\frac{\text{Fixed Costs}+\text{Target Profit}}{\text{CMU}}=\frac{\text{Rs 200,000}+\text{Rs 50,000}}{\text{Rs 50}}=5,000\text{ units}$$

3. Margin of safety (MOS): $$\text{MOS (units)}=\text{Actual Sales}-\text{BEP}=6,000-4,000=2,000\text{ units}$$ $$\text{MOS Ratio}=\left(\frac{2,000}{6,000}\right)\times 100=33.33\%$$ Interpretation: The company can afford a 33.33% drop in sales (2,000 units) before breaking even.

---

11. Quick Revision Table

---

12. Common Mistakes to Avoid

1. Ignoring units: Always label answers in units, Rs, or %.
2. Mixing fixed and variable costs: Double-check which costs are fixed/variable.
3. Forgetting to interpret: Exams reward explanations (e.g., "This means the shop must sell X more to break even").
4. Assuming linear costs: In multi-product firms, use weighted average CM.
5. Calculation errors: Recheck arithmetic (e.g., BEP = F/CMU, not F/V).

---

13. Practice Questions (Exam Style)

1. A Nepali biscuit factory has:

   • Fixed costs: Rs 100,000/month
   • Variable cost per biscuit: Rs 5
   • Selling price: Rs 10 Calculate: a) Break-even in units and Rs. b) Sales needed for Rs 20,000 profit. c) MOS if actual sales are 25,000 units.

2. Ncell wants to test a new call plan:

   • Fixed cost (network): Rs 500,000/month
   • Variable cost per call: Rs 2
   • Selling price per call: Rs 5 If they want a profit of Rs 100,000, how many calls must they sell?

3. Differentiate between contribution margin and gross profit, with examples from Daraz and a Kathmandu tailor shop.

---

14. Final Summary Flowchart