Cost Analysis for Decision-Making

Relevant Costing for Product Rationalization

Relevant costing is a decision‑focused approach that includes only those costs that differ between alternatives. Intuitively, when deciding whether to discontinue a product, a manager asks: Which costs will actually disappear if we drop it? Traditional cost reports may mislead by spreading fixed costs across all products, making low‑volume items look profitable when they are not.

The Decision Context: Product Line Overload

A company with multiple product lines faces tension:

• Marketing prefers variety to boost revenue (top line).
• Production struggles with small batch sizes, frequent changeovers, and low productivity.
• Finance sees stagnant profits despite sales growth → investors concerned.

Managers must rationalize products – identify which to discontinue without harming overall profitability.

Key problem: Traditional product‑wise profitability reports (based on arbitrary cost allocations) can show popular but small‑volume products as profitable, masking the true cost of maintaining them.

The Flaw of Traditional Cost Allocation

Under typical absorption costing, fixed costs (e.g., product‑specific machine setups, dedicated tooling) are allocated using broad drivers like units produced or machine hours. This makes low‑volume products appear to bear only a small share of fixed costs – but in reality, each product may have its own dedicated fixed costs that are incurred regardless of volume.

Exam tip: In product rationalization decisions, avoidable fixed costs (those that disappear if the product is dropped) are relevant; common fixed costs allocated across multiple products are irrelevant.

Relevant Costing: A Decision‑Focused Approach

Relevant costs are future costs that differ between alternatives. For discontinuation:

• Relevant: Product‑specific fixed costs (e.g., a dedicated machine lease, product‑line manager salary) – these are saved if the product is dropped.
• Irrelevant: Sunk costs (past R&D), common overhead (rent, corporate admin), and costs that remain whether or not the product continues.

No standard format – tailor the cost report to the decision. Charging each product its exclusive fixed costs can reveal when older, low-volume products do not cover their own avoidable fixed costs.

Worked example (conceptual):

• Product A: Contribution margin ₹10,000 per month; product‑specific fixed costs ₹12,000 (machine lease).
• Under traditional allocation, product A might show a profit of ₹2,000 (because only a fraction of the lease was allocated to it). Under relevant costing, the true loss is ₹2,000, making it a candidate for discontinuation.

Implementation: A Pilot Test

Rather than a full sweep, the managers decide to:

1. Select two products to discontinue for one month.
2. Observe actual impact on profit, manufacturing, and marketing.
3. Use the evidence to inform broader rationalization.

This iterative, real‑world validation bridges the gap between accounting reports and operational reality.

Key Takeaways

• Relevant costs are future, differ between alternatives, and are always avoidable in the decision context.
• Traditional volume‑based allocation understates the cost of low‑volume products that have dedicated fixed costs.
• For product rationalization, base decisions on product‑specific fixed costs, not common allocated overhead.
• There is no fixed format for relevant costing reports; the structure changes with each decision.
• A pilot test (discontinue a few products temporarily) reduces risk and provides real data.
• Marketing and production objectives must align – a product that boosts top‑line revenue may still destroy bottom‑line profit.

Absorption vs Marginal Costing

Absorption costing (also called full costing) treats all manufacturing costs – both variable and fixed – as product costs. Every unit produced absorbs a share of fixed overhead. In contrast, marginal costing (or variable costing) treats only variable costs as product costs; fixed costs are period costs, expensed in full when incurred.

Why this matters for decision-making: the two methods produce different profit figures and different inventory values, which can flip a “discontinue” decision into a “scale up” one.

The core distinction

Worked example: Cookie launch

Given (April)

• Production: 100,000 packets
• Sales: 90,000 packets (10,000 unsold)
• Revenue: ₹860,000
• Variable cost (total): ₹800,000
• Fixed cost (total): ₹200,000

Under Absorption Costing

Total cost = ₹800,000 (variable) + ₹200,000 (fixed) = ₹1,000,000 Unit cost = ₹1,000,000 / 100,000 units = ₹10/unit Cost of goods sold (COGS) = 90,000 units × ₹10 = ₹900,000 Closing inventory = 10,000 units × ₹10 = ₹100,000 Profit = Revenue – COGS = ₹860,000 – ₹900,000 = –₹40,000 (loss)

Under Marginal Costing

Unit cost = Variable cost only = ₹800,000 / 100,000 units = ₹8/unit Variable cost of goods sold = 90,000 units × ₹8 = ₹720,000 Contribution margin = Revenue – Variable COGS = ₹860,000 – ₹720,000 = ₹140,000 Fixed costs = ₹200,000 (expensed in full) Profit = Contribution margin – Fixed costs = ₹140,000 – ₹200,000 = –₹60,000 (loss)

Both methods show a loss, but the cause differs: absorption costing spreads fixed costs over all units (including inventory), partially hiding the loss. Marginal costing reveals the true contribution after variable costs.

Why the accountant advised discontinuation

Under absorption costing, the product shows a ₹40,000 loss. The accountant concluded the product is unprofitable. However, the marketing team’s proposal to double volume in May changes the picture:

• Fixed costs remain ₹200,000 (unchanged)
• If production doubles to 200,000 packets, fixed cost per unit falls from ₹2 to ₹1
• The contribution margin per unit (₹1.40 = selling price ₹8.60 – variable cost ₹8.00) remains positive
• The decision should be based on contribution margin, not full-cost profit

Exam tip: Under absorption costing, increasing production without increasing sales can boost profit by deferring fixed costs into inventory. Marginal costing avoids this distortion – it is the correct tool for short-term decisions like scale or drop.

Effect on inventory and period charges

• Absorption costing: closing stock contains a share of fixed costs. That fixed cost moves to the next period when the inventory is sold. Value of closing stock = 10,000 units × ₹10 = ₹100,000 (includes ₹2/unit fixed cost).
• Marginal costing: closing stock contains only variable costs. Fixed costs stay in the period they are incurred. Value of closing stock = 10,000 units × ₹8 = ₹80,000.

In May, if production rises and fixed cost remains ₹200,000, absorption costing would show a lower unit cost and thus a lower inventory value per unit – but the key is that profits under absorption costing can be manipulated via production volume, while marginal costing profits respond only to sales.

Key takeaways

• Absorption costing treats fixed costs as product costs (inventoriable); marginal costing treats them as period costs (expensed immediately).
• Unit cost under absorption = variable + fixed per unit; under marginal = variable cost per unit only.
• Contribution margin = Revenue – Variable costs; used for short-run decisions.
• Increasing production without increasing sales inflates absorption-costing profit by deferring fixed costs; marginal costing avoids this.
• For “drop or grow” decisions, rely on contribution margin, not full-cost profit.

Cost Behavior Analysis

Cost behavior describes how a cost changes in relation to changes in volume (production or sales). Understanding this is fundamental to budgeting, pricing, and decision‑making. Every cost item falls into one of three categories based on its response to volume changes.

Fixed, Variable, and Mixed Costs

Intuition:

• Material cost: zero production → zero material cost; double production → double total material cost.
• Rent: paid whether factory runs or not.
• Repairs & maintenance: some routine maintenance is needed even with no production; extra wear and tear adds variable cost when machines run.

Exam tip: Always start a cost analysis by classifying each cost as fixed, variable, or mixed. Misclassification leads to faulty break‑even and profit projections.

---

Methods to Split Mixed Costs into Fixed and Variable

When a cost is mixed, we need to isolate its fixed and variable components. Four common approaches are discussed, each with trade‑offs between simplicity, objectivity, and accuracy.

1. Account Analysis

The manager reviews each cost item and, based on experience and judgment, assigns a percentage to fixed and variable.

• Advantage: Uses managerial insight – fast and intuitive.
• Disadvantage: Subjective and may miss structural changes in cost patterns; periodic reassessment is required.

2. High‑Low Method

Uses only the highest and lowest activity levels (and their associated costs). Assumes a linear relationship between cost and volume.

Steps:

1. Identify the period with the highest volume and the period with the lowest volume.
2. Compute variable cost per unit (or variable cost as % of sales): $\text{Variable cost per unit} = \frac{\text{Cost}_{\text{high}} - \text{Cost}_{\text{low}}}{\text{Volume}_{\text{high}} - \text{Volume}_{\text{low}}}$
3. Compute fixed cost by plugging into either point: $\text{Fixed cost} = \text{Total cost} - (\text{Variable cost per unit} \times \text{Volume})$

Worked Example: Lowest volume: 100 units, cost ₹50,000 Highest volume: 300 units, cost ₹1,20,000 (note: if cost had tripled to ₹1,50,000, it would be purely variable; here cost increased less than proportionally – economies of scale).

$$\text{Variable cost} = \frac{1,20,000 - 50,000}{300 - 100} = \frac{70,000}{200} = ₹350 \text{ per unit}$$ $$\text{Fixed cost} = 50,000 - (350 \times 100) = ₹15,000$$

Company example – Kansai Nerolac (selling & distribution costs vs. sales):

• High sales: ₹2,731 lakh, cost ₹429 lakh
• Low sales: ₹966 lakh, cost ₹138 lakh

Variable cost as % of sales: $\frac{429 - 138}{2,731 - 966} = \frac{291}{1,765} \approx 0.1428 \quad (14.28\%)$ Fixed cost (using high point): $429 - (0.1428 \times 2,731) = 429 - 390 = \text{Rs. }39 \text{ lakh}$

Drawback: Ignores all intermediate data points and may be unrepresentative.

3. Scatter Graph

Plot all (Volume, Total Cost) pairs on a graph (Y‑axis: cost, X‑axis: volume). Draw a line of best fit through the middle of the points.

• Slope of the line = variable cost per unit.
• Y‑intercept (at zero volume) = fixed cost.
• Done easily in Excel with an XY scatter plot and trendline.

4. Linear Regression (Ordinary Least Squares)

Uses all data points to estimate the line that best fits the data. The regression equation is:

$Y = a + bX$

where

• $Y$ = total cost
• $X$ = volume (or sales)
• $a$ = fixed cost (intercept)
• $b$ = variable cost per unit (or variable cost as a percentage when $X$ is sales)

Excel functions:

• SLOPE(Y_range, X_range) gives $b$.
• INTERCEPT(Y_range, X_range) gives $a$.

Company comparison (regression results):

Why negative fixed cost? Asian Paints’ selling & distribution cost grew faster than sales (sales 5×, cost 6× over ten years). The company was spending heavily on branding; all S&D expenses behaved as variable, and the linear model forced a negative intercept.

Remedy – Force intercept to zero: In Excel, run regression with “Constant is Zero” checked (no intercept). The new model: $\text{S\&D Cost} = 0 + b \times \text{Sales}$ Result for Asian Paints: $b = 19.86\%$, fixed cost = 0. $R^2 \approx 0.99$ – 99% of variation in S&D cost is explained by sales.

Exam tip: A negative fixed cost is a red flag – the cost structure may not follow the simple fixed‑plus‑variable model. Forcing the intercept to zero (i.e., assuming all costs are variable) can provide a workable estimate, but always examine the business context.

Comparison of Methods

Practical advice: For precise estimation, use monthly or quarterly data rather than yearly data to capture current cost behaviour. Historical data may lose relevance over time.

---

Key Takeaways

• Costs behave as fixed, variable, or mixed – classify correctly before analysis.
• Mixed costs can be split using Account Analysis, High‑Low, Scatter Graph, or Regression.
• High‑Low is simple but uses only two data points; regression is more reliable when data are available.
• A negative fixed cost from regression violates the expected cost model; forcing a zero intercept (assuming all variable) often resolves it, but verify the economic logic.
• The variable cost percentage for selling & distribution expenses is often stable and can be used for budgeting (e.g., Asian Paints at 19.86% of sales).

Break-Even Analysis (Single Product)

Break-even analysis determines the sales volume at which total revenue equals total cost – the point of zero profit or loss. Below it, the firm incurs a loss; above it, every additional unit contributes directly to profit.

Core Concepts & Formulas

• Contribution margin (CM) = Selling price – Variable cost per unit. It is the amount each unit contributes toward covering fixed costs and then profit.
• Contribution margin ratio (CMR) = $\frac{\text{CM}}{\text{Selling price}}$.
• Break-even quantity (BEP_Q) = $\displaystyle \frac{\text{Total Fixed Cost}}{\text{CM per unit}}$.
• Break-even sales (BEP_₹) = $\displaystyle \frac{\text{Total Fixed Cost}}{\text{CMR}}$.

Worked Examples

Ice‑cream shop – commission = 20% of sales (i.e., CMR = 20%), fixed cost = ₹10,000/month. $\text{BEP}_\text{Rs. } = \frac{10{,}000}{0.20} = \text{Rs. }50{,}000 \text{ sales value}.$

Chemical company – selling price = ₹100/kg, variable cost = ₹60/kg → CM = ₹40/kg, CMR = 40%. Fixed cost = ₹10,000. $\text{BEP}_Q = \frac{10{,}000}{40} = 250 \text{ kg} \qquad \text{BEP}_\text{Rs. } = \frac{10{,}000}{0.40} = \text{Rs. }25{,}000.$

Break‑Even Capacity

When capacity is known (e.g., maximum output = 1,000 kg): $\text{BEP capacity} = \frac{250}{1{,}000} = 25\%.$ The firm avoids losses if it operates at or above 25% of capacity. Often used to evaluate new project proposals.

Margin of Safety (MOS)

Margin of safety = actual (or budgeted) sales – break‑even sales. Measures the “cushion” before a loss occurs.

Given current sales of 600 kg (vs. BEP 250 kg): $\text{MOS (units)} = 600 - 250 = 350 \text{ kg}.$

• Profit = MOS units × CM per unit. Because the first 250 kg cover fixed costs; all sales beyond BEP flow directly to profit. $\text{Profit at 600 kg} = 350 \times 40 = \text{Rs. }14{,}000.$

Profit Leverage (Operating Leverage)

After BEP, profit grows faster than volume. Compare:

Volume increased 25% (400 → 500), but profit increased 66.7% (₹6,000 → ₹10,000).

Exam tip: This asymmetric response is the hallmark of fixed costs; the higher the fixed costs, the steeper the profit swing.

The “Two Tubs” Metaphor

Visualise fixed costs as the first tub. Each unit’s contribution pours into that tub until it is full (at BEP). Once full, all further contribution fills a second tub – profit. Profit = contribution from units sold beyond BEP.

Key Takeaways

• BEP in units = FC / (SP – VC); in revenue = FC / CMR.
• Contribution margin per unit must first cover fixed costs before any profit.
• Margin of safety = actual sales – BEP; profit = MOS units × CM per unit.
• Above BEP, profit increases faster than sales due to operating leverage.
• Break‑even capacity (percentage of capacity) is used for project feasibility.

---

Multi‑Product Break‑Even Analysis

When a firm sells multiple products with different contribution margins, the break‑even point depends on the sales mix – the proportion of each product in total sales.

Sales‑Mix Bag Approach

1. Determine the planned sales mix (e.g., in units ratios).
2. Define one sales‑mix bag – a bundle containing units in that exact ratio.
3. Compute contribution per bag = $\sum$ (units of product in bag × CM per unit).
4. Break‑even number of bags = $\displaystyle \frac{\text{Total Fixed Cost}}{\text{Contribution per bag}}$.
5. Convert bags into actual units per product: multiply bags × units per bag.

Worked Example: Five Mobile Phone Models

Fixed cost = ₹1,400 million.

Contribution per bag $= 10 \times 480 + 3 \times 2{,}400 + 5 \times 4{,}000 + 4 \times 3{,}500 + 8 \times 3{,}000$ $= 4{,}800 + 7{,}200 + 20{,}000 + 14{,}000 + 24{,}000 = \text{Rs. }70{,}000.$

Break‑even bags $\frac{1{,}400{,}000{,}000}{70{,}000} = 20{,}000 \text{ bags}.$

Break‑even units per product

• MLaunch: 20,000 × 10 = 200,000
• High‑end: 20,000 × 3 = 60,000
• M‑Professional: 20,000 × 5 = 100,000
• Size: 20,000 × 4 = 80,000
• Mix‑of‑features: 20,000 × 8 = 160,000

Profit at BEP is zero (all contribution covers fixed costs).

Target Profit with Sales Mix

To achieve a target profit of ₹2,100 million:

$\text{Additional bags} = \frac{2{,}100{,}000{,}000}{70{,}000} = 30{,}000 \text{ bags}.$ $\text{Total bags} = 20{,}000 + 30{,}000 = 50{,}000 \text{ bags}.$

Convert to units using the same mix ratios (e.g., MLaunch: 50,000 × 10 = 500,000).

Impact of Changing Sales Mix

• If the actual mix differs (e.g., marketing finds it difficult to sell 250,000 units of the Business model), the contribution per bag changes. All calculations must be redone.
• Introducing a new product alters both the sales mix and fixed costs. The new break‑even point must be recalculated.
• Marketing and R&D often push for more models without considering cost implications; multi‑product BEP analysis highlights the hidden cost effects and ensures profit targets remain realistic.

Key Takeaways

• For multiple products, BEP is computed using a sales‑mix bag: a bundle reflecting the planned sales ratio.
• Contribution per bag = weighted sum of individual contributions.
• BE bags = total fixed cost ÷ contribution per bag; then allocate to products.
• Target profit adds extra bags beyond BE; same allocation method.
• Any change in product mix or introduction of new products requires complete re‑computation and can significantly alter profitability.

Pricing Decision

Pricing decision is shaped by market conditions, customer type, and internal cost structure. While market forces largely determine price, managers set a minimum internal price using cost-plus: variable cost + fixed cost allocation + desired profit. The market price must at least meet this floor. In the short run or for strategic reasons, price can fall below variable cost, but long-run price must cover variable costs and contribute to fixed costs.

Cost-Based Minimum Price

$\text{Internal price} = \text{Variable cost} + \text{Fixed cost per unit} + \text{Target profit per unit}$

• The minimum acceptable price covers variable cost (short-term exception allowed)
• Special orders and export markets often price based on marginal cost (variable cost only)

Worked Example: Tata Nano Variant Launch

Using marginal costing, contribution and profit are computed for different prices. At the lowest price (₹1.70 lakh):

• Contribution per unit = ₹1.70 – ₹1.40 = ₹0.30 lakh
• Total contribution = 50,000 × ₹0.30 = ₹150 lakh? No unit consistency: better in lakhs.

Let's compute in lakhs (1 lakh = 100,000): Variable cost ₹1.40 lakh, fixed cost per unit ₹0.12 lakh, target profit per unit = ₹0.20 lakh (to achieve 20% ROI). Minimum price = 1.40 + 0.12 + 0.20 = ₹1.72 lakh.

Exam tip: The minimum price is derived from cost-plus, not market. If the market price is below that, the firm must decide whether to accept negative profit for strategic reasons (e.g., market entry).

Special Order Pricing

When a one-time order does not affect regular sales and spare capacity exists, relevant cost is only variable cost. Fixed costs are already covered by regular volume. The price floor is variable cost; any price above variable cost adds to profit.

Procedure:

1. Treat the order as a normal order.
2. Remove fixed cost from the price calculation.
3. Apply the same profit mark-up (on variable cost only) as the normal product.

Worked Example: Taxi Service Order

• Regular retail price: ₹1.80 lakh
• Variable cost: ₹1.40 lakh
• Fixed cost per unit (at 50,000 units): ₹12,000
• Profit per unit: ₹28,000
• Mark-up on cost (variable + fixed): 28,000 / 1,52,000 = 18.42%

For special order (5000 units, spare capacity):

• Price = Variable cost + Mark-up on variable cost only
• = ₹1.40 lakh + 18.42% × ₹1.40 lakh = ₹1.65788 lakh ≈ ₹1.66 lakh

The special order customer pays no fixed cost allocation.

Delegation of Authority

Authority to classify an order as "special" should not rest with the marketing department (whose goal is sales volume). An independent authority must decide. Default special order price = variable cost + normal mark-up. Further discounts require higher-level approval and may be justified only for strategic reasons.

Key Takeaways — Pricing Decision

• Internal price = variable cost + fixed cost per unit + target profit
• Special order relevant cost = variable cost only
• Mark-up on special order is based on variable cost alone
• Separate authority for order classification prevents abuse

---

Make or Buy Decision

Firms outsource to achieve cost leadership or focus on core activities. Marginal costing helps identify relevant costs: variable costs plus any fixed costs that can be eliminated if outsourced. Allocated fixed costs (unavoidable) are irrelevant.

Relevant Costs in Make or Buy

$$\text{Relevant cost to make} = \text{Variable cost per unit} + \text{Product-specific fixed cost per unit}$$

• Avoidable fixed costs: e.g., depreciation of dedicated equipment, manager salary
• Unavoidable fixed costs: allocated overheads that will be re‑apportioned

Worked Example: Voltage Stabilizer Division

Current internal cost structure (per unit, at 200,000 units):

External quote from KS Electronics:

• 200,000 units: ₹620/unit
• 300,000 units: ₹600/unit

Decision at 200,000 units:

Internal relevant cost = Variable cost (₹550) + Exclusive fixed cost (₹60) = ₹610 External quote ₹620 → internal is cheaper, so make.

Decision at 300,000 units:

Internal relevant cost = Variable cost ₹550 + Exclusive fixed cost per unit (₹120 lakh ÷ 300,000 = ₹40) = ₹590 External quote ₹600 → internal still cheaper, make.

Incorporating Opportunity Cost

If the division’s plant and equipment can be sold (e.g., for ₹600 lakh) and cost of capital is 15%, the annual opportunity cost of continuing is ₹90 lakh (15% of ₹600). Spread over 200,000 units:

$$\text{Opportunity cost per unit} = \frac{₹90\, \text{lakh}}{2,00\,000} = ₹45$$

Add to internal relevant cost: ₹610 + ₹45 = ₹655 Now external quote ₹620 is cheaper → buy.

Exam tip: Opportunity cost of capital can flip a make decision. Always consider if closure frees assets that could earn returns elsewhere.

Key Takeaways — Make or Buy

• Relevant cost = variable cost + avoidable fixed cost
• Allocated fixed costs are irrelevant
• Include opportunity cost of capital for assets that can be sold
• Re‑evaluate if scale changes (fixed cost per unit changes)

---

Discontinuing a Product or Division

Products with negative contribution (price < variable cost) are prime candidates for discontinuation. Products with positive contribution but loss on full‑cost basis should be continued unless strategic reasons dictate otherwise — fixed costs that are not product‑specific will remain and burden remaining products.

Identifying Relevant Costs for Discontinuation

• Relevant (savable) costs: variable costs + product‑specific fixed costs
• Irrelevant: allocated fixed costs (re‑apportioned)

Worked Example: Steel Products

Product profitability under full costing:

Re‑evaluating with relevant costs:

• Sheets: Contribution = ₹15,840; less product‑specific fixed cost ₹4,600 → segment margin = ₹11,240 (positive). Allocated cost ₹16,800 is irrelevant. Do not discontinue.
• Electro‑steel: A negative contribution means variable cost exceeds price. Discontinuing the product avoids the stated ₹1,000-per-tonne loss, totalling ₹10 crore.

If both are discontinued, total profit impact = save ₹10 cr from Electro‑steel (negative) but lose the positive contribution from Sheets. The decision must be based on each product’s segment margin, not full‑cost profit.

Key Takeaways — Discontinuation

• Negative contribution → discontinue (unless strategic)
• Positive segment margin → continue, ignore allocated fixed costs
• Decision should be transparent, with clear documentation for strategic continuations

---

Optimal Product Mix with Resource Constraints

In an ideal world with unlimited resources, uniform products, and equal margins, all orders can be accepted. Reality imposes resource constraints — limited machine hours, skilled labour, or raw materials. The goal is to choose the optimal product mix that maximises total contribution given these constraints.

The core decision rule: prioritise products with the highest contribution per unit of the scarce resource.

Contribution per Limiting Factor

$\text{Contribution per limiting factor} = \frac{\text{Contribution margin per unit}}{\text{Units of limiting factor per unit}}$

Rank products by this ratio. Allocate the scarce resource first to the highest-ranked product, while respecting minimum and maximum demand constraints.

Worked Example: Machine Hour Constraint

Data:

Total machine hours available: 600 hours.

Step 1: Contribution per machine hour

• Product X: $100 / 2 = \text{Rs. }50$ per hour
• Product Y: $135 / 3 = \text{Rs. }45$ per hour

X is preferred (higher contribution per hour).

Step 2: Hours required for minimum demand

• X: $50 \times 2 = 100$ hours
• Y: $40 \times 3 = 120$ hours
• Total: 220 hours

Remaining hours: $600 - 220 = 380$ hours.

Step 3: Allocate remaining hours to X (up to maximum)

Additional X possible: $200 - 50 = 150$ units, requiring $150 \times 2 = 300$ hours. Hours left after X: $380 - 300 = 80$ hours.

Step 4: Allocate remaining hours to Y

Additional Y possible: $80 / 3 \approx 26.67$ units → 27 units (since units are discrete). Total Y: $40 + 27 = 67$ units.

Optimal Product Mix

The decision logic is straightforward when only one resource is constrained. In multi-constraint cases, linear programming is required.

Generalising to Other Constraints

The same principle applies regardless of the scarce resource:

• Limited skilled labour → use contribution per labour hour.
• Limited raw material → use contribution per unit of raw material.
• Limited machine hours → use contribution per machine hour (as above).

Decision Flowchart

Key takeaways

• Resource constraints force prioritisation — never produce blindly.
• Contribution per limiting factor is the correct ranking metric, not total contribution.
• Minimum demand must always be satisfied first.
• Maximum demand acts as a ceiling; do not produce above it.
• The same logic applies to machine hours, labour hours, or raw materials — always compute contribution per unit of the scarce resource.

Measuring Operating Risk and Leverage

Firms face two broad types of risk: operating risk (from operations) and financial risk (from borrowing). Operating risk arises from the presence of fixed costs such as depreciation, managerial salaries, and rent. High fixed costs mean that a small change in sales volume leads to a large change in profit – a double-edged sword that magnifies gains in good times and losses in downturns.

The marginal costing framework (contribution margin) provides tools to quantify these risks.

Degree of Operating Leverage (DOL)

DOL measures how sensitive profit before interest and taxes (PBIT) is to a percentage change in sales volume from the current level.

$\text{DOL} = \frac{\text{Contribution Margin}}{\text{PBIT}}$

• Low fixed costs → low DOL → profit changes only modestly with sales.
• High fixed costs → high DOL → profit changes sharply with sales.

Degree of Financial Leverage (DFL)

DFL measures how sensitive profit before tax (PBT) is to changes in PBIT, driven by interest payments.

$\text{DFL} = \frac{\text{PBIT}}{\text{PBT}}$

Total Leverage (Degree of Combined Leverage, DCL)

Total leverage combines operating and financial leverage. It measures the overall sensitivity of PBT to a change in sales volume.

$\text{DCL} = \text{DOL} \times \text{DFL} = \frac{\text{Contribution Margin}}{\text{PBT}}$

---

Worked Example: Indian Hotels vs. EI Hotels

Interpretation: For every 1% change in revenue:

• Indian Hotels’ PBIT changes by 1.67%, PBT by 3.33%.
• EI Hotels’ PBIT changes by 2.28%, PBT by 8.15%.

Impact of a 10% revenue decline (economic downturn):

EI Hotels carries higher operating risk (higher fixed cost) and higher financial risk (higher interest). During a downturn its profits collapse much faster; during a boom they would surge equally dramatically. Managers must judge the optimal level of total leverage for their business.

Exam tip: High leverage magnifies both upside and downside. A firm with higher DCL will see larger profit swings for the same revenue change – this is a core risk assessment when comparing firms.

Assumptions of Cost-Volume-Profit (CVP) Analysis

The framework (marginal costing, leverage calculations) rests on several assumptions. These may be violated in practice but provide a useful starting point.

1. Revenue, variable cost, and contribution are constant per unit and linear within the relevant range.
2. Total fixed cost is constant within the relevant range.
3. Mixed costs can be separated into fixed and variable components.
4. Sales = Production (no major inventory fluctuations).
5. No capacity addition during the period.
6. Sales mix remains constant (for multi-product firms).
7. No inflation (or inflation does not affect contribution).
8. Labour productivity, technology, and other factors remain unchanged.

Despite these limitations, managers find CVP analysis relevant and useful for decision-making.

Key Takeaways

• Operating risk stems from fixed costs; measured by DOL = Contribution / PBIT.
• Financial risk stems from interest; measured by DFL = PBIT / PBT.
• Total leverage (DCL) = DOL × DFL = Contribution / PBT.
• High DOL means a % change in sales causes a larger % change in PBIT.
• A worked example comparing two hotels shows that higher fixed costs and interest cause steeper profit swings during a downturn.
• CVP analysis relies on simplifying assumptions (linearity, constant mix, etc.) – be aware of their limits when applying the tools.

Costing Approaches and CVP Analysis – Module Summary

Cost data can be presented under two distinct approaches: full costing and variable (or marginal) costing. The choice depends on the user (external vs. internal) and the purpose of the decision.

• Full costing is the default for external reporting (e.g., cost of goods sold in the income statement).
• Marginal costing focuses on cost behaviour (variable vs. fixed) and is the foundation of Cost‑Volume‑Profit (CVP) analysis.

CVP Analysis – Uses and Foundation

CVP analysis rests on the marginal costing structure and helps answer:

• What is the break‑even point (BEP)?
• What profit results from different sales volumes?
• What if price, cost, or mix changes?

Common managerial decisions that rely on CVP:

• Pricing of special orders
• Make‑or‑buy decisions
• Decision to close down an unprofitable product or business unit

Exam tip: CVP is always built on marginal costing – never mix in allocated fixed overheads when computing contribution per unit for these decisions.

Assumptions of CVP Analysis

CVP analysis is powerful but depends on key assumptions. Violating them leads to misleading conclusions.

1. Costs are linear – variable cost per unit and total fixed costs remain constant within the relevant range.
2. Sales price is constant – no volume discounts or price changes.
3. Single product or constant sales mix – for multi‑product firms, the mix must be fixed.
4. Inventory levels do not change – production = sales (no stock build‑up).
5. Productivity and efficiency are stable.

Key takeaways

• Full costing is required for external reports; marginal costing is for internal decisions.
• CVP analysis (marginal costing based) is used for BEP, profit planning, special orders, make‑or‑buy, and closure decisions.
• CVP assumes linear costs, constant price, fixed mix, zero inventory change, and stable efficiency.
• Violating any assumption reduces the reliability of CVP results – always check the context before applying.

Exercise 1: Cost Behavior Analysis – Employee Cost

Objective: Decompose employee cost into fixed and variable components using high-low method and regression, handling negative fixed cost by re‑running with a zero‑intercept constraint. Compare cost structures across software (Infosys, Wipro) and steel (Tata Steel, SAIL) firms.

Data and High‑Low Method

Select the highest and lowest operating income years. Variable cost % = (Δ employee cost) ÷ (Δ operating income).

Fixed cost = Total employee cost – (Variable cost % × Operating income). Using the high point yields negative fixed costs for all four companies – a meaningless result because fixed cost cannot be negative.

Regression Analysis

Excel’s SLOPE(employee_cost_range, operating_income_range) gives the variable %; INTERCEPT gives fixed cost.

Zero‑Fixed‑Cost Model

Because negative fixed cost is untenable, re‑run regression forcing the intercept to zero using LINEST(employee_cost_range, operating_income_range, FALSE) in Excel. The new slope becomes the variable cost %.

Interpreting Cost Behavior

• Software firms (Infosys, Wipro) have high variable employee cost (≈50% of revenue). Employee cost is the dominant operating expense (≈50% of operating income). Wipro appears slightly more efficient (45.11% vs 52.33%).
• Steel firms have much lower variable employee cost – Tata Steel 9.55%, SAIL 18.31%. Employee cost is a smaller share of revenue (<20%).

Exam tip: When regression yields a negative intercept, the linear model with a positive fixed cost is inappropriate. For cost‑behaviour analysis where fixed costs are expected to be zero (or you want to isolate the purely variable rate), force the intercept to zero. This is a common exam trap.

Key takeaways

• High‑low method uses two extreme data points; regression uses all points.
• Negative fixed cost signals that the cost may be purely variable (or the data range is too narrow).
• Zero‑intercept regression provides a cleaner variable cost % for decision‑making.
• Industry differences: software (labour‑intensive) → high variable employee cost; steel (capital‑intensive) → low variable employee cost.

---

Exercise 2: Breakeven Analysis – Fortune Pharma

Objective: Compute breakeven point (units, revenue, capacity), target profit, and sensitivity of breakeven to changes in price, variable cost, and fixed cost.

Given

• Capacity: 100,000 cases
• Selling price per case: ₹240 (₹10 per bottle × 24 bottles)
• Variable cost per case: ₹200
• Contribution margin per case: ₹40
• Contribution margin ratio: $\frac{40}{240} = 16.67\%$
• Fixed costs: ₹20,00,000 (20 lakh)

Breakeven Calculations

$\text{Breakeven (units)} = \frac{\text{Fixed costs}}{\text{Contribution margin per unit}} = \frac{20,00,000}{40} = 50,000 \text{ cases}$

$\text{Breakeven (\text{Rs. })} = \frac{\text{Fixed costs}}{\text{Contribution margin ratio}} = \frac{20,00,000}{0.1667} = \text{Rs. }1,20,00,000 \text{ (120 lakh)}$

$\text{Breakeven (\% of capacity)} = \frac{50,000}{100,000} = 50\%$

Target Profit

To achieve a profit of ₹10,00,000:

$\text{Required units} = \frac{\text{Fixed costs} + \text{Target profit}}{\text{Contribution margin per unit}} = \frac{20,00,000 + 10,00,000}{40} = 75,000 \text{ cases}$

Alternatively: Breakeven units (50,000) + (Target profit ÷ contribution per unit) = 50,000 + (10,00,000 ÷ 40) = 75,000.

Sensitivity of Breakeven Point

Three independent actions, each a 10% change:

Interpretation: Increasing selling price has the greatest leverage on breakeven (‑37.5%), followed by reducing variable cost (‑33.3%). Cutting fixed cost only reduces breakeven proportionally (‑10%).

Exam tip: Always compare the percentage change in breakeven to the percentage change in the driver. Here a 10% price increase yields a 37.5% drop in breakeven – operating leverage magnifies the effect because contribution margin rises.

Key takeaways

• Breakeven in units = Fixed costs ÷ Contribution margin per unit.
• Profit = (Units sold – Breakeven units) × Contribution margin per unit.
• Among price, variable cost, and fixed cost, price changes have the most powerful impact on breakeven (if volume sensitivity is ignored).

---

Exercise 3: Modernization Decision – RedAir

Objective: Evaluate whether investing in hardware/software upgrade (₹1.3M fixed cost increase) is worthwhile, using contribution margin, margin of safety, and profit. Also compute the minimum revenue increase needed to protect current profit.

Current Situation

RedAir has five verticals earning commissions on gross revenue:

• Total commission = ₹4.95M (all contribution, no variable costs)
• Contribution margin ratio = $\frac{4.95}{30.0} = 16.5\%$
• Fixed costs = ₹3.3M
• Breakeven revenue = $\frac{3.3}{0.165} = \text{Rs. }20.0M$
• Margin of safety = $30.0 - 20.0 = \text{Rs. }10.0M$
• Profit = Margin of safety × Contribution margin ratio = $10.0 \times 0.165 = \text{Rs. }1.65M$

After Upgrade

• Revenue increases 30% → ₹39.0M (gross)
• Commissions increase proportionally → $4.95 \times 1.3 = \text{Rs. }6.435M$
• Contribution margin ratio remains 16.5% (same commission structure)
• Fixed costs increase to $3.3 + 1.3 = \text{Rs. }4.6M$
• Breakeven revenue = $\frac{4.6}{0.165} = \text{Rs. }27.87M$
• Margin of safety = $39.0 - 27.87 = \text{Rs. }11.13M$
• Profit = $11.13 \times 0.165 = \text{Rs. }1.84M$ (increase of ₹0.19M)

Decision

Since the upgrade yields a 30% revenue increase (exceeds the 26.26% threshold to protect current profit of ₹1.65M), the profit rises. The upgrade is desirable.

Minimum Revenue Increase to Protect Existing Profit

To keep profit at ₹1.65M after upgrade:

$\text{Required revenue} = \frac{\text{New fixed costs} + \text{Current profit}}{\text{Contribution margin ratio}} = \frac{4.6 + 1.65}{0.165} = \text{Rs. }37.87M$

$\text{Minimum \% increase} = \frac{37.87 - 30.0}{30.0} = 26.26\%$

Any revenue increase above 26.26% yields higher profit; below that, profit declines. The projected 30% increase clears the hurdle.

Key takeaways

• When variable costs are zero, contribution equals commission revenue.
• Margin of safety = Actual revenue – Breakeven revenue; profit = Margin of safety × Contribution margin ratio.
• To approve a fixed cost increase, verify that the resulting revenue growth exceeds the break‑even revenue growth required to maintain current profit.
• The threshold formula: $\text{Required revenue} = \frac{\text{New FC} + \text{Existing profit}}{\text{CM ratio}}$

Exercise 4: Break-Even Analysis with Volume Changes

Intuition. A firm’s break-even point is the sales level at which total revenue equals total cost. When volume changes, fixed costs stay constant — every extra rupee of revenue above variable cost flows to profit. This operating leverage causes profit to grow faster than revenue.

Initial Data – Spider Technology (four services)

Operating costs: ₹28 million total.

• 40% variable → ₹11.2 million = 112 lakh
• 60% fixed → ₹16.8 million = 168 lakh

Contribution Margin Ratio (CMR): $CMR = \frac{630 - 112}{630} = \frac{518}{630} \approx 0.8222 \ (82.22\%)$

Break‑even sales: $BE_{sales} = \frac{Fixed\ Cost}{CMR} = \frac{168}{0.8222} \approx 204.32 \text{ lakh}$

Margin of safety: $\text{Margin of Safety} = 630 - 204.32 = 425.68 \text{ lakh}$

Current net income: $630 - 112 - 168 = 350 \text{ lakh}$

Revised Volumes (30% increase for first two services, 50% for last two)

Assumption: Variable costs remain proportional to revenue (i.e., same CMR). Revised contribution = $905 \times 0.8222 \approx 744.1$ lakh. Revised net income: $744.1 - 168 = 576.11$ lakh.

Profit increase: $\frac{576.11 - 350}{350} = 64\%$ vs. revenue increase of $\frac{905-630}{630}=43.65\%$.

Exam tip: The profit boost is larger because fixed costs do not increase. This is the essence of operating leverage. Always check whether variable costs are assumed to scale with revenue.

Key takeaways

• Break‑even sales = fixed cost / CMR.
• Margin of safety = actual sales – break‑even sales.
• When volume rises, profit rises by a higher percentage than revenue (fixed costs drag less).
• Use the contribution margin ratio to project profit at different revenue levels.

---

Exercise 5: Multi‑Product Break‑Even with Sales Mix Change

Intuition. In a multi‑product firm, the break‑even point depends on the sales mix — the proportion of each product sold. Selling more high‑contribution products lowers break‑even; selling more low‑contribution products raises it.

Revised Sales Mix (per “bag” of 6+5+7+8+10 = 36 units)

(The final per-bag contribution is ₹1,00,880.)

Fixed cost: ₹1,400 million = 1,40,000 lakh.

Break‑even number of bags: $BE_{bags} = \frac{1,40,000\ \text{lakh}}{1,00,880\ \text{\text{Rs. }/bag}} \approx 13,878 \text{ bags}$

Convert bags to units per product:

Why the break‑even changed: The new mix contains more units of high‑contribution products (M‑Ultima, M‑Professional, M‑Sleek, M‑Optima) and fewer of the low‑contribution M‑Launch. This increases the weighted‑average contribution per unit, so fewer total units are needed to cover the same fixed cost.

Exam tip: Always compute per‑bag contribution when given a sales mix. A favorable mix shift (more high‑margin products) lowers break‑even; an unfavorable shift raises it.

Key takeaways

• In multi‑product CVP, the sales mix determines the composite contribution.
• Break‑even (in units) = fixed cost ÷ weighted‑average contribution per unit.
• Changing the mix without changing prices or variable costs can alter break‑even.
• High‑contribution products reduce break‑even volume.

---

Exercise 6: Special Order Pricing

Intuition. A special order is a one‑time order that does not affect regular business. The minimum acceptable price is the total incremental cost (variable + any extra fixed costs). Above that, any positive contribution improves profit. The “desirable” price can be set by applying the firm’s normal margin — either the contribution margin or the profit margin — to incremental costs.

Current Operations (Southern Surgical)

Contribution margin ratio: $CMR = \frac{150}{500} = 30\%$

Profit margin: $\text{Profit margin} = \frac{80}{500} = 16\%$

Special Order from Sri Lanka Hospital

Minimum price (no gain/no loss) = ₹24 crore.

Desirable price using contribution margin markup: Markup on variable cost: $\text{Contribution markup} = \frac{CMR}{1-CMR} = \frac{30\%}{70\%} \approx 42.86\%$ Price = ₹24 crore × (1 + 0.4286) = ₹34.29 crore.

Desirable price using profit margin markup: Profit markup on cost: $\text{Profit markup} = \frac{\text{Profit margin}}{1-\text{Profit margin}} = \frac{16\%}{84\%} \approx 19.05\%$ Price = ₹24 crore × (1 + 0.1905) = ₹28.57 crore.

Exam tip: The minimum price is never below total incremental cost. The two markup methods give different “desirable” prices — the contribution margin method includes a share of fixed costs, the profit margin method includes only the profit rate on total cost. The choice depends on market competition and capacity utilisation.

Key takeaways

• Minimum price = variable cost of order + any incremental fixed cost.
• Additional fixed costs (e.g., setup) must be covered.
• Desirable price can be set using the existing contribution markup or profit markup.
• The contribution markup is higher than the profit markup when fixed costs exist.
• Special orders should not absorb existing fixed costs already covered by regular sales.

Exercise 7: Multi-Product Break-Even and Target Profit

Intuition. When a firm sells multiple products with different contributions, break-even can’t be computed per product in isolation. Instead, use a sales-mix bundle (a “bag”) that reflects the fixed ratio in which products are sold. Compute the contribution per bundle, then find how many bundles are needed to cover fixed costs and hit profit targets.

Data – ExecutiveMentor.com

Fixed costs (per year, in lakh ₹):

• Depreciation: 5 cr × 20 % = 100 lakh
• Salary and other expenses: per month 25 lakh (salary) + 10 lakh (other) = 35 lakh → combined with depreciation gives 135 lakh.

Note: Treat monthly fixed expenses as a single 35 lakh lump sum; adding depreciation gives 135 lakh.

Contribution per bundle (1 Gold + 3 Silver)

$$\text{Contribution per bag} = 1 \times 1{,}300 + 3 \times 900 = 1{,}300 + 2{,}700 = 4{,}000 \text{ ₹/bag}$$

(A) Break‑even point (BEP)

$$\text{BEP (bags)} = \frac{\text{Fixed cost}}{\text{Contribution per bag}} = \frac{135 \text{ lakh}}{4{,}000} = 3{,}375 \text{ bags}$$

Membership breakdown:

• Gold: $3{,}375 \times 1 = 3{,}375$
• Silver: $3{,}375 \times 3 = 10{,}125$

Break‑even operating revenue:

$$3{,}375 \times 1{,}500 + 10{,}125 \times 1{,}000 = 50{,}62{,}500 + 1{,}01{,}25{,}000 = \text{₹ } 1{,}51{,}87{,}500 \;(151.875 \text{ lakh})$$

(B) Target profit = ₹10 lakh

$$\text{Bags required} = \frac{135 \text{ lakh} + 10 \text{ lakh}}{4{,}000} = \frac{145 \text{ lakh}}{4{,}000} = 3{,}625 \text{ bags}$$

• Gold: 3,625
• Silver: 10,875

(C) Return on investment = 30 % of ₹5 cr (500 lakh)

$$\text{Target profit} = 30\% \times 500 \text{ lakh} = 150 \text{ lakh}$$ $$\text{Bags} = \frac{135 + 150}{4{,}000} = \frac{285}{4{,}000} = 7{,}125 \text{ bags}$$

• Gold: 7,125
• Silver: 21,375

(D) Profit margin = 10 % of membership revenue

Profit is taken as a percentage of price before contribution is earned. For each card, the “new” contribution after setting aside the required profit margin:

• Gold: $1{,}300 - (10\% \times 1{,}500) = 1{,}300 - 150 = 1{,}150$
• Silver: $900 - (10\% \times 1{,}000) = 900 - 100 = 800$

Contribution per bag (revised):

$$1{,}150 + 3 \times 800 = 1{,}150 + 2{,}400 = 3{,}550$$

Bags required (fixed cost unchanged):

$$\frac{135 \text{ lakh}}{3{,}550} \approx 3{,}803 \text{ bags}$$

• Gold: 3,803
• Silver: $3{,}803 \times 3 = 11{,}408$

Exam tip – profit margin vs. target profit: When the profit is stated as a percentage of revenue, it changes the contribution per unit because the required profit is effectively a “cost” that must be netted out of the original contribution. This is different from a fixed rupee target profit added to fixed costs.

---

Key takeaways – Multi‑product break‑even

• Use a sales‑mix bundle (bag) to handle multiple products with a fixed ratio.
• Contribution per bundle = $\sum (\text{mix weight} \times \text{contribution per unit})$.
• BEP (bundles) = $\frac{\text{Fixed cost}}{\text{Contribution per bundle}}$.
• Target profit (flat amount) → add to fixed cost in numerator.
• Target profit as % of revenue → deduct the profit margin from contribution per unit, then compute bundles.
• Always convert bundles back to individual product volumes using the mix ratio.

---

Exercise 8: Resource Constraint and Surplus Capacity

Intuition. When capacity (e.g., consultant hours) is fixed and multiple jobs compete for it, the objective is to maximise total contribution from the limited hours. Ranking by contribution per hour (contribution ÷ hours) is the correct approach, but final selection may need to consider indivisible job sizes – the best ranking does not always yield the best combination if a high‑rank job uses up hours that block a better overall mix.

Data – Q‑Team Consulting

Job details and full‑cost profit

Full‑cost profit is not the decision criterion for capacity allocation because fixed overhead is allocated arbitrarily. Use contribution analysis.

Relevant analysis – Contribution per hour

For surplus capacity, the consultants’ existing salaries and fixed overhead are already committed. The acceptance decision therefore uses incremental job-specific cost: travel and other direct costs. Contribution is income less those incremental costs.

Ranking by contribution per hour: 1 → 2 → 3 → 4.

With 16,000 hours: Job 1 (10,000) + Job 2 (6,000) = 16,000 ⇒ total contribution = 28 + 16 = 44 lakh.

Alternative combination: Job 2 (6,000 hrs) + Job 3 (8,000 hrs) uses 14,000 hours and contributes ₹34 lakh. Job 1 + Job 2 uses all 16,000 hours and contributes ₹44 lakh, so it is preferred.

Exam tip – indivisibility trap: A job with a high contribution per hour may be too large to combine with other jobs. Always check feasible combinations, not just the ranking.

If management could stretch capacity by 2,000 hours (to 18,000), Job1+Job3 (18,000 hrs) would yield 48 lakh, which is better.

---

Key takeaways – Resource constraint decision

• Ignore fixed costs; use contribution (incremental revenue minus incremental costs).
• Rank jobs by contribution per unit of constrained resource (here, consultant hours).
• Because jobs are indivisible, the best ranking does not guarantee the best combination – evaluate feasible bundles.
• The goal is to maximise total contribution from the limited capacity.

---

Exercise 9: Operating, Financial, and Total Leverage

Intuition. Leverage magnifies the effect of changes in sales on profits. Operating leverage arises from fixed operating costs – the higher the fixed costs, the more a given sales change affects EBIT. Financial leverage arises from fixed interest payments – it amplifies the effect of EBIT changes on net profit. Total leverage is the combined impact from sales to net profit.

Formulas

$$\text{Operating leverage (OL)} = \frac{\text{Contribution}}{\text{EBIT}}$$ $$\text{Financial leverage (FL)} = \frac{\text{EBIT}}{\text{EBT}}$$ $$\text{Total leverage (TL)} = \text{OL} \times \text{FL} = \frac{\text{Contribution}}{\text{EBT}}$$

• OL > 1 indicates presence of fixed operating costs; higher OL → higher operating risk.
• FL = 1 means no interest (no financial risk); FL > 1 indicates financial risk.
• TL expresses the overall risk – the percentage change in net profit for a 1 % change in sales.

Illustration – Sonata Software (year March 2014)

$$\text{OL} = \frac{54.58}{34.33} = 1.59$$ $$\text{FL} = \frac{34.33}{34.25} = 1.002$$ $$\text{TL} = 1.59 \times 1.002 \approx 1.59$$

Comparative analysis – Sonata vs. Vishal Software (over 3 years)

The comparison provides selected values and trend directions rather than a complete three-year series for both firms:

Key observations:

• Both firms have almost no financial leverage (FL ≈ 1), so total risk is driven by operating leverage.
• Sonata’s operating leverage rose over three years, indicating increased operating risk (higher fixed costs relative to contribution).
• Vishal’s operating leverage fell. Its 2014 figure of 0.65 accompanies a negative fixed-cost estimate, an unusual result that requires investigation for reclassification or expense reversals. For a cleaner comparison, use 2013: Vishal’s operating leverage was lower than Sonata’s, so Vishal had lower operating risk.

Exam tip – negative fixed costs: An operating leverage below 1 or a negative fixed cost is unusual. In real data, it signals accounting anomalies (e.g., reversals, reclassifications). Always question such results before concluding about risk.

---

Key takeaways – Leverage

• Operating leverage = Contribution ÷ EBIT – measures sensitivity of EBIT to sales changes.
• Financial leverage = EBIT ÷ EBT – measures sensitivity of net profit to EBIT changes.
• Total leverage = OL × FL – overall risk from sales to net profit.
• Higher fixed costs (operating or financial) increase leverage and thus risk.
• Use leverage ratios to compare risk across firms or over time.

CVP Index – Britannia Industries Example

The CVP Index (CVP = Cost-Volume-Profit) integrates profitability (contribution margin ratio) and risk (how far sales exceed break‑even). A higher index means a safer, more profitable business.

$\text{CVP Index} = \frac{\text{Contribution Margin}}{\text{Sales}} \times \frac{\text{Current Sales}}{\text{Break-even Sales}}$

The first term measures profitability; the second term measures margin of safety (sales cushion above BEP). Their product captures the overall health of the firm.

---

Worked Example: Britannia Industries

Data (10‑year summary, figures in same currency unit):

Step 1: Separate fixed & variable costs

• Raw material: 100% variable → cost ratio $61.24\%$
• Other expenses: split via regression (intercept = fixed, slope = variable)
  • Variable portion: $28.54\%$ of sales
  • Fixed portion: $1,296$

Total variable cost ratio = $61.24\% + 28.54\% = 89.78\%$

Contribution margin ratio = $1 - 0.8978 = 0.1022 = 10.22\%$

Total fixed cost = $1,296$

Step 2: Break‑even sales

$\text{BEP Sales} = \frac{\text{Fixed Cost}}{\text{Contribution Margin Ratio}} = \frac{1296}{0.1022} \approx 12{,}680$

Step 3: Margin of safety (risk measure)

$\text{Sales / BEP Sales} = \frac{79{,}479}{12{,}680} \approx 6.27$ (The higher this ratio, the lower the risk.)

Step 4: CVP Index

$\text{CVP Index} = 0.1022 \times 6.27 \approx 0.64$

---

Comparison with HUL and ITC (from textbook)

Britannia has the lowest contribution margin (weak profitability) and the smallest sales‑cushion (higher risk). Its CVP Index is far below the other two FMCG giants.

---

Interpreting the CVP Index

• A low CVP Index (like 0.64) signals that the firm’s profitability is thin and it operates close to its break‑even point — a double vulnerability.
• Britannia, despite being a market leader in biscuits and dairy, scores poorer than HUL and ITC on this combined metric.

Exam tip: The CVP Index is not a standard ratio in textbooks; it’s a constructed index for this module. Remember its two components: contribution margin ratio (profitability) × (sales ÷ BEP sales) (safety). A value < 1 is weak; above 2 is strong.

---

Key takeaways

• CVP Index = contribution margin ratio × (current sales / BEP sales).
• Uses cost‑behaviour analysis: separate fixed and variable costs (regression for mixed costs).
• Britannia: low profitability (10.22% CM ratio) and moderate safety (6.27× BEP) → CVP Index only 0.64.
• Compared to HUL (1.76) and ITC (3.38), Britannia is the worst performer on this integrated measure.
• A high CVP Index requires both high margins and a wide sales cushion above break‑even.

Case Study: Power Pack Batteries

This case applies cost–volume–profit (CVP) analysis to a real firm. Power Pack Batteries manufactures dry cells. Sales have been stable over ten years, yet profits are highly volatile and recently turned negative. The objectives: diagnose the cause, compute current break‑even and risk metrics, infer the competitor’s cost structure from limited data, and recommend a long‑term strategy.

1. Why Profits Are Volatile Despite Stable Sales

Sales are stable but profits swing wildly. The coefficient of variation (CV = standard deviation / mean) quantifies this:

Profit volatility (0.51) is seven times greater than sales volatility (0.07). The root cause is found by examining the stability of each cost element as a percentage of sales.

• Raw material cost as a % of sales is itself highly volatile (CV ≈ 0.12). It fluctuated from 71% down to 63% and up to 79% over the ten years.
• Other costs (employee, selling, administrative) are relatively stable, though they have crept up recently.

Why does raw material cost vary so much? The company has been unable to pass raw-material price increases on to customers, indicating limited pricing power. If selling prices had matched cost increases, raw material cost as a percentage of sales would have remained stable.

Key takeaways

• Volatile profit with stable sales implies one or more cost elements fluctuate in percentage terms.
• Raw material cost is the primary driver: its CV is 0.12, while sales CV is only 0.07.
• The inability to pass on cost increases to customers (due to competition) causes the fluctuation.

---

2. Break‑Even and Risk Analysis (Based on 2005–2014 Data)

The cost structure is separated into fixed and variable components using regression (or Excel’s SLOPE / INTERCEPT). For each cost item:

• If a regression through the origin is justified (e.g., raw material has zero fixed cost), use LINEST with zero intercept.
• If the intercept from a standard regression is negative (impossible for cost), force the intercept to zero.

Cost Structure Breakdown

Thus:

• Variable cost ratio ($V$) = 94.78%
• Contribution margin ratio ($CM$) = $1 - V = 5.22\% = 0.0522$
• Fixed cost ($F$) = 8.33 (same currency unit as sales)

Key Metrics (using current sales $S = 510$)

• Break‑even sales (BEP)

  $$\text{BEP} = \frac{F}{CM} = \frac{8.33}{0.0522} \approx 159.64$$

• Margin of safety

  $$\text{MoS} = S - \text{BEP} = 510 - 159.64 = 350.36$$

  The firm operates 3.2 times above break‑even ($S / \text{BEP} = 510 / 159.64 \approx 3.2$).

• CVP index (a combined measure of profitability and risk)

  $$\text{CVP index} = CM \times \frac{S}{\text{BEP}} = 0.0522 \times 3.2 \approx 0.167$$

Why Did the Company Still Report a Loss in Dec 2015?

The analysis above uses data up to 2014. In the December 2015 quarter:

• Sales collapsed to 42 (quarterly). Annualised ≈ $42 \times 4 = 168$, very close to the break‑even point of ~160.
• The company posted a loss of 21.8 for that quarter.

The seemingly safe 3× margin evaporated when sales volume dropped sharply. This demonstrates operating leverage risk: with very low contribution margin (5.2%), a small drop in sales can eliminate profit.

Key takeaways

• Cost structure: 94.78% variable, 8.33 fixed → contribution margin only 5.22%.
• Break‑even sales = 159.64; current sales (2014) = 510 → large safety margin in normal years.
• However, low $CM$ means high operating leverage: small sales declines cause outsized profit swings.
• The 2015 sales drop to ~168 (annualised) pushed the firm below break‑even.

---

3. Inferring a Competitor’s Cost Structure

Only limited competitor data are available (sales and profit for three years). The insight: above break‑even, the change in profit equals the change in contribution margin.

Deriving Contribution Margin

Use years 1 and 2 (both profitable, above break‑even):

$$CM = \frac{\Delta \text{Profit}}{\Delta \text{Sales}} = \frac{50 - 30}{500 - 400} = \frac{20}{100} = 0.20 \ (20\%)$$

Variable and Fixed Cost

• Variable cost ratio = $1 - CM = 0.80$ (80%).
• Apply to year 2 to find fixed cost $F$: $$\text{Contribution} = 500 \times 0.20 = 100$$ $$100 - F = \text{Profit} = 50 \implies F = 50$$
• Check year 1: $400 \times 0.20 = 80$, $80 - 50 = 30$ ✓.

What Happened in Year 3?

With the same cost structure, year 3 would give:

• Expected contribution: $800 \times 0.20 = 160$
• Expected profit: $160 - 50 = 110$

Actual profit was only 32 – a shortfall of 78. This implies the competitor either:

• Reduced selling price (discounting) to gain volume, or
• Experienced a cost increase not captured.

Working backwards:

$$\text{Actual contribution} = \text{Profit} + F = 32 + 50 = 82$$ $$\text{Implied variable cost} = 800 - 82 = 718 \ (\text{vs. expected } 640)$$

Equivalently, if costs are unchanged, the effective selling price was discounted by about 78/800 ≈ 10%.

Key takeaways

• With only two data points (both above break‑even), $CM = \Delta \text{Profit} / \Delta \text{Sales}$.
• Competitor’s cost structure: $V = 80\%$, $F = 50$, $CM = 20\%$.
• In year 3, the observed profit and sales figures are consistent with an effective selling-price discount of approximately 10%.

---

4. Comparing Cost Structures and Long‑Term Strategy

The competitor’s lower variable cost (80% vs. 94.78%) comes from automation, which raises fixed cost but improves productivity. With a 20% contribution margin, the competitor can:

• Absorb price cuts (e.g., 10% discount) without falling into loss.
• Scale up volume profitably (sales grew 60% from year 2 to 3).

Power Pack’s extremely low contribution margin (5.22%) leaves no room for price competition. Any price reduction or cost increase immediately hits the bottom line.

Recommended Long‑Term Strategy for Power Pack

1. Invest in automation to reduce variable cost – especially raw material and labour content.
2. Accept higher fixed cost (depreciation, maintenance) but aim for a contribution margin of at least 15–20%.
3. Use the improved cost structure to either lower prices (to compete) or maintain prices and earn higher margins.
4. Monitor the break‑even point: automation shifts it upward, but with higher volumes the risk can be managed.

Key takeaways

• Power Pack’s variable cost (95%) is far higher than the competitor’s (80%).
• The competitor’s automation gives it pricing power and scalability.
• Power Pack must automate to increase contribution margin – even at the cost of higher fixed expenses.
• The case shows how limited data (sales and profit) can be used to infer a competitor’s cost structure.

Exam tip: When only sales and profit data are available, the contribution margin can be derived from two periods above break‑even using $\Delta \text{Profit} / \Delta \text{Sales}$. Then fixed cost is found by plugging into one period. This technique is a common exam problem.