Cost Behavior & Cost Estimation: Types, Analysis & Methods

TAKEAWAYS:

• Costs are classified into fixed, variable, and semi-variable based on their behavior with changes in activity level.
• Cost estimation techniques (e.g., high-low method, scattergraph) help predict future costs accurately for budgeting.
• Contribution margin (per unit or total) reveals how much each sale covers variable costs and contributes to fixed costs/profit.
• Break-even analysis identifies the sales volume where total revenue equals total costs (no profit, no loss).
• Relevant range defines the activity level where cost behavior assumptions hold true.
• Cost-volume-profit (CVP) graphs visually link sales volume, costs, and profit to support strategic decisions.

1. Introduction to Cost Behavior

Cost behavior describes how costs change in response to changes in activity level (e.g., number of guests, room bookings, or meals served). Understanding this is vital for:

• Pricing decisions (e.g., setting room rates in hotels).
• Budgeting (e.g., forecasting labor costs for peak seasons).
• Profit planning (e.g., determining break-even points for events).

Key Types of Cost Behavior

Costs are categorized into three primary types:

FIGURE 1: Cost Behavior Graph Caption: Cost behavior graph for a Kathmandu café (fixed rent, variable ingredients, semi-variable utilities).

2. Cost Estimation Techniques

Estimating costs accurately helps in budgeting, pricing, and profit forecasting. Common methods include:

A. High-Low Method

• Uses two extreme data points (highest and lowest activity levels) to estimate variable and fixed costs.
• Formula:
  • Variable cost per unit = (Highest Cost - Lowest Cost) / (Highest Activity - Lowest Activity)
  • Fixed Cost = Total Cost at Lowest Activity - (Variable Cost × Lowest Activity)

Worked Example: Daraz’s Delivery Costs Daraz tracks delivery costs for 500 orders:

Solution:

1. Variable cost per order = (20,000 - 12,000) / (500 - 200) = Rs 20.
2. Fixed cost = 12,000 - (20 × 200) = Rs 8,000.
3. Cost equation: Total Cost = Rs 8,000 + Rs 20 × x.

Mermaid Diagram: High-Low Method Steps

graph TD
  A["Select highest and lowest activity points (500 rides, Rs 20,000) and (200 rides, Rs 12,000)"] --> B["Variable cost per ride = (20,000 - 12,000) / (500 - 200) = Rs 20"]
  B --> C["Fixed cost = 12,000 - (20 × 200) = Rs 8,000"]
  C --> D["Cost equation: Y = 8,000 + 20x"]
  D --> E["Plot on cost-volume line"]

B. Scattergraph Method

• Plots data points on a graph and fits a trend line to estimate costs.
• Useful for large datasets (e.g., NTC’s monthly call charges).

3. Contribution Margin and Break-Even Analysis

A. Contribution Margin

• Definition: The amount each unit contributes to covering fixed costs after deducting variable costs.
• Formula:
  • Per Unit = Selling Price per Unit - Variable Cost per Unit
  • Total = Total Sales - Total Variable Costs

Worked Example: A Kathmandu Restaurant

• Selling Price per Meal: Rs 300
• Variable Cost per Meal: Rs 120 (ingredients + labor)
• Fixed Costs (monthly): Rs 150,000 (rent, salaries)

Calculations:

1. Contribution Margin per Meal = 300 - 120 = Rs 180.
2. Break-Even Units = Fixed Costs / Contribution Margin per Unit = 150,000 / 180 ≈ 833 meals/month.

FIGURE 2: Contribution Margin Table

B. Break-Even Point

• The sales volume where Total Revenue = Total Costs (no profit, no loss).
• Formula:
  • In Units: Break-Even Units = Fixed Costs / Contribution Margin per Unit
  • In Sales (Rs): Break-Even Sales = Fixed Costs / Contribution Margin Ratio

Worked Example: Pathao’s Ride Pricing Pathao charges:

• Variable Cost per Ride: Rs 80 (fuel, driver wages).
• Fixed Costs (monthly): Rs 500,000 (app maintenance, insurance).
• Contribution Margin per Ride: Rs 120 (Rs 200 fare - Rs 80 variable cost).

Break-Even Calculation:

• Break-Even Rides = 500,000 / 120 ≈ 4,167 rides/month.
• Break-Even Revenue = 4,167 × 200 = Rs 833,400.

Mermaid Diagram: Break-Even Analysis Flow

graph TD
    A["Identify Fixed Costs"] --> B["Determine Variable Cost per Unit"]
    B --> C["Calculate Contribution Margin per Unit"]
    C --> D["Use formula: Break-Even = Fixed Costs / Contribution Margin"]
    D --> E["Plot on CVP Graph"]

4. Cost-Volume-Profit (CVP) Analysis

CVP analysis links sales volume, costs, and profit to answer:

• What sales volume is needed to break even?
• How does profit change with sales volume?
• What is the margin of safety (difference between actual sales and break-even sales)?

A. CVP Graph

A visual tool showing:

1. Total Revenue Line (sloping upward).
2. Total Cost Line (fixed + variable costs).
3. Break-Even Point (intersection of revenue and cost lines).

FIGURE 3: CVP Graph for a Hotel Caption: CVP graph for a 50-room hotel (fixed costs = Rs 50,000, variable cost = Rs 50/room, selling price = Rs 100/room).

B. Margin of Safety

• Definition: The difference between actual sales and break-even sales.
• Formula:
  • In Units = Actual Sales - Break-Even Sales
  • In % = (Actual Sales - Break-Even Sales) / Actual Sales × 100

Worked Example: Ncell’s Data Sales

• Actual Sales: 10,000 units
• Break-Even Sales: 5,000 units
• Margin of Safety = 10,000 - 5,000 = 5,000 units (or 50%).

5. Relevant Range

• Definition: The activity level where cost behavior assumptions (fixed/variable) remain valid.
• Example: A hotel’s fixed costs (rent) may stay constant until 100% occupancy. Beyond that, they may need to hire extra staff (costs become semi-variable).

Mermaid Diagram: Relevant Range

graph TD
  A["Cost Behavior Assumptions (Fixed/Variable)"] --> B["Valid within Relevant Range (e.g., 0-100% occupancy)"]
  B --> C["Beyond Range: Costs Change (e.g., semi-variable)"]
  C --> D["Example: Hotel Staff Hiring at 100% Occupancy"]
  D --> E["Graph: Flat line → Sloped line"]

6. Applications in Real-World Businesses

## In the real world

1. eSewa’s Transaction Fees

   • Idea Used: Semi-variable costs (fixed app maintenance + variable transaction fees).
   • How: eSewa charges merchants a fixed monthly fee (Rs 500) + variable percentage (1.5% per transaction). Cost estimation helps them set competitive fees while covering costs.

2. Daraz’s Inventory Management

   • Idea Used: Break-even analysis for stock levels.
   • How: Daraz uses CVP analysis to determine how many units of a product must sell to cover storage costs (fixed) and variable costs (shipping, handling). If a product’s break-even point is too high, Daraz may discontinue it.

3. Ncell’s Call Charges

   • Idea Used: Cost estimation (high-low method) for pricing.
   • How: Ncell estimates variable costs (network usage, customer service) and fixed costs (towers, salaries) to set call rates. If variable costs rise (e.g., due to demand), Ncell adjusts pricing dynamically.

7. Advantages and Limitations

8. Exam Tips

1. Memorize Formulas:

   • Contribution Margin = SP - VC
   • Break-Even = Fixed Costs / Contribution Margin
   • Margin of Safety = Actual Sales - Break-Even Sales

2. Graphs Are Key:

   • Always plot CVP graphs for break-even analysis.
   • Label axes clearly (e.g., "Sales Volume" vs. "Profit/Loss").

3. Real-World Linkages:

   • Connect cost behavior to hotel pricing (e.g., dynamic pricing during festivals).
   • Use Daraz/Ncell examples to explain semi-variable costs.

4. Watch for Units:

   • Exams often ask for break-even in units or sales (Rs). Calculate both if needed.

5. Common Pitfalls:

   • Miscounting fixed vs. variable costs. Always verify with the question.
   • Ignoring relevant range. State assumptions clearly (e.g., "within normal operating capacity").

Final Note: This unit is highly numerical. Practice worked examples (like the Kathmandu restaurant) and CVP graphs to score full marks. Focus on cost estimation techniques (high-low, scattergraph) and break-even calculations—these appear frequently in exams.