Embedded Files
Introduction to Exercise 2: The Logarithmic Method
Introduction to Exercise 2: The Logarithmic Method
Recapping Exercise 1: What We Achieved
In Exercise 1, you applied the Chain Substitution Method to break down total revenue growth into two core drivers: Volume Impact (ΔP_Q) and Price Impact (ΔP_C).
Chain Substitution is a deterministic, step-by-step technique widely used in corporate accounting because it accounts for 100% of the total variance and assigns clear departmental ownership. However, as helpful as it is, it carries a fundamental structural weakness.The Hidden Flaw: Path Dependency & Sequence Bias
When both quantity (Q) and price (C) change at the same time, they create a joint "interaction effect" (more units sold at a higher price).
Under the Chain Substitution rule:
Volume is evaluated first, freezing price at its baseline (C0).
Price is evaluated second, applied to the new actual volume (Q1).
Because price is placed second in the chain, 100% of the joint interaction effect is automatically bundled into the Price Impact. If you reversed the order and analyzed price first, the resulting numbers would change! This path dependency creates a managerial dilemma: sales managers and pricing directors might argue over which sequence is "fairer."
Why Use the Logarithmic Method? (Refinement & Evolution)
Is the Logarithmic Method an extension, a supplement, or a replacement?
Think of the Logarithmic Method as an advanced methodological refinement. It does not contradict two-factor analysis; rather, it fixes the path-dependency flaw of the chain substitution rule.
By taking the natural logarithm (ln) of revenue, volume, and price ratios, we convert multiplicative growth into an additive continuous scale.
Core Advantages over Chain Substitution:
Zero Sequence Bias: There is no priority order. Neither volume nor price has to go "first."
Fair Interaction Allocation: The joint interaction term is not dumped onto the last factor. Instead, it is distributed perfectly proportionally based on each factor's relative contribution to logarithmic growth.
Flawless Managerial Equity: Neither department is penalized or privileged by an arbitrary choice of substitution order.
Example Case Study: Logarithmic Method – Office Chairs
Example Case Study: Logarithmic Method – Office Chairs
Scenario Description:
An office chair manufacturer budgeted to sell 500 chairs at $200 per unit, aiming for $100,000 in baseline revenue. Due to strong market demand, actual sales reached 600 chairs at $250 per unit, resulting in total actual revenue of $150,000.
The total revenue growth (deviation) is $50,000 ($150,000 - $100,000).
Case Goal:
Analyze the step-by-step calculation below to see how the Logarithmic Method (ln) fairly distributes the total $50,000 deviation between Volume Impact (ΔP_Q) and Price Impact (ΔP_C) without sequence bias.
Example Case Study: Logarithmic Method – Calculation
Example Case Study: Logarithmic Method – Calculation
Step 1: Understand the Inputs
Budget / Baseline (Period 0)
Quantity (Q0) = 500 units
Price (C0) = $200
Baseline Revenue (P0) = 500 x $200 = $100,000
Actual Performance (Period 1):
Quantity (Q1) = 600 units
Price (C1) = $250
Actual Revenue (P1) = 600 x $250 = $150,000
Total Revenue Deviation (ΔP):
ΔP = P1 - P0 = $150,000 - $100,000 = $50,000
Step 2: Calculate the Base for the Denominator
Rule: Use the natural log (ln) of the total revenue index (P1 / P0).
P1 / P0 = 150,000 / 100,000 = 1.5
Denominator = ln(1.5) = approx. 0.405465
Step 3: Calculate Volume Impact
Formula: Total Deviation x [ln(Q1 / Q0) / ln(P1 / P0)]
Volume Index = 600 / 500 = 1.2
Calculation: 50,000 x [ln(1.2) / ln(1.5)]
Calculation: 50,000 x [0.182321 / 0.405465] = 22,482.7
Rounded Volume Impact = 22,483
Step 4: Calculate Price Impact
Formula: Total Deviation x [ln(C1 / C0) / ln(P1 / P0)]
Price Index = 250 / 200 = 1.25
Calculation: 50,000 x [ln(1.25) / ln(1.5)]
Calculation: 50,000 x [0.223143 / 0.405465] = 27,517.3
Rounded Price Impact = 27,517
Step 5: Final Check
22,483 + 27,517 = 50,000
The impacts add up exactly to the total deviation of $50,000.
This exercise challenges students to recalculate the revenue deviation using the Logarithmic Method. By utilizing natural logarithms, students will see how the mathematical residual (the joint effect) is distributed perfectly proportionally. This method eliminates the sequence bias found in chain substitution, ensuring a flawlessly objective and fair performance evaluation for department managers.
Roadmap to Solution:
Step 1: Calculate the Total Revenue Index (P₁ / P₀) and take its natural logarithm: ln(P₁ / P₀). This will be your denominator.
Step 2: Calculate the Volume Index (Q₁ / Q₀) and the Price Index (C₁ / C₀), and take the natural logarithm of both.
Step 3 (Volume Impact): Multiply the Total Deviation (ΔP, from Exercise 1) by the fraction: ln(Volume Index) / ln(Total Revenue Index).
Step 4 (Price Impact): Multiply the Total Deviation by the fraction: ln(Price Index) / ln(Total Revenue Index).
Page updated
Report abuse