Understanding Break-Even Point Calculation

The question asks us to determine the break-even point in terms of sales value for AB Ltd., a company manufacturing filing cabinets. The break-even point is the level of sales where total revenue equals total costs, resulting in neither profit nor loss.

Key Concepts for Break-Even Analysis

• Fixed Costs (FC): Costs that remain constant regardless of the production or sales volume (e.g., rent, salaries). For AB Ltd., fixed costs are Rs. 10,00,000.
• Variable Costs (VC): Costs that change directly in proportion to the production or sales volume (e.g., raw materials, direct labor). For AB Ltd., fully variable costs are 60 percent of the sales value.
• Contribution Margin: The difference between sales revenue and variable costs. This amount contributes towards covering fixed costs and generating profit.
• Profit-Volume (P/V) Ratio: The ratio of contribution margin to sales, usually expressed as a percentage. It indicates the contribution earned per rupee of sales.
• Break-Even Point (BEP): The sales level (in units or value) at which contribution margin equals total fixed costs.

Given Information for AB Ltd.

• Units sold in current year: 4,000 cabinets
• Loss incurred in current year: Rs. 2,00,000
• Fixed Costs (FC): Rs. 10,00,000
• Fully Variable Costs (VC): 60% of sales value

The information about capacity utilization (40%) and the number of units sold (4,000) is useful for understanding the context but not directly needed for the BEP in sales value calculation, provided we can determine the P/V ratio from the given financial data.

Formula for Break-Even Point in Sales Value

The formula to calculate the break-even point in sales value is:

$$ \text{BEP (Sales Value)} = \frac{\text{Fixed Costs}}{\text{P/V Ratio}} $$

First, we need to calculate the P/V Ratio.

Calculating the P/V Ratio

The P/V Ratio can be calculated as:

$$ \text{P/V Ratio} = \frac{\text{Contribution Margin}}{\text{Sales Value}} \times 100 $$

or, more simply, if Variable Costs are given as a percentage of Sales Value:

$$ \text{P/V Ratio} = 1 - \left( \frac{\text{Variable Costs}}{\text{Sales Value}} \right) $$

Since the variable costs are given as 60% of the sales value, the P/V ratio is:

$$ \text{P/V Ratio} = 1 - 0.60 = 0.40 \text{ or } 40\% $$

Calculating Current Sales Value (Optional but useful for verification)

We can also determine the current sales value using the given loss information. We know that:

$$ \text{Sales} - \text{Variable Costs} - \text{Fixed Costs} = \text{Profit (or -Loss)} $$

Let S be the current sales value.

Variable Costs (VC) = 60% of S = 0.60S

Fixed Costs (FC) = 10,00,000

Loss = 2,00,000

So, the equation is:

$$ S - 0.60S - 10,00,000 = -2,00,000 $$

$$ 0.40S - 10,00,000 = -2,00,000 $$

$$ 0.40S = 10,00,000 - 2,00,000 $$

$$ 0.40S = 8,00,000 $$

$$ S = \frac{8,00,000}{0.40} $$

$$ S = 8,00,000 \times \frac{10}{4} $$

$$ S = 20,00,000 $$

The current sales value is Rs. 20,00,000. At this sales level:

• Sales: Rs. 20,00,000
• Variable Costs: 60% of Rs. 20,00,000 = Rs. 12,00,000
• Contribution Margin: Rs. 20,00,000 - Rs. 12,00,000 = Rs. 8,00,000
• Fixed Costs: Rs. 10,00,000
• Profit/Loss: Rs. 8,00,000 - Rs. 10,00,000 = -Rs. 2,00,000 (Loss)

This calculation confirms the current situation described in the question and validates our P/V ratio of 40% (Rs. 8,00,000 CM / Rs. 20,00,000 Sales).

Calculating Break-Even Point in Sales Value

Now, we can use the BEP formula:

Fixed Costs = Rs. 10,00,000

P/V Ratio = 40% or 0.40

$$ \text{BEP (Sales Value)} = \frac{\text{Fixed Costs}}{\text{P/V Ratio}} $$

$$ \text{BEP (Sales Value)} = \frac{10,00,000}{0.40} $$

$$ \text{BEP (Sales Value)} = \frac{10,00,000}{40/100} $$

$$ \text{BEP (Sales Value)} = 10,00,000 \times \frac{100}{40} $$

$$ \text{BEP (Sales Value)} = 10,00,000 \times 2.5 $$

$$ \text{BEP (Sales Value)} = 25,00,000 $$

The break-even point in terms of sales value for AB Ltd. is Rs. 25,00,000.

Summary of Calculations

Revision Table: Break-Even Point Analysis

Additional Information: Cost-Volume-Profit (CVP) Analysis

Break-Even Point analysis is a core component of Cost-Volume-Profit (CVP) analysis. CVP analysis studies the relationship between costs, sales volume, and profit. It helps management make important decisions regarding pricing, production levels, and cost control. Key assumptions of CVP analysis include:

• Costs can be clearly separated into fixed and variable components.
• Fixed costs remain constant within the relevant range of activity.
• Variable costs per unit remain constant.
• Selling price per unit remains constant.
• Production volume equals sales volume.
• The sales mix remains constant (for multi-product companies).

Understanding CVP analysis and BEP calculation is crucial for financial planning and decision-making in businesses.