Gross Profit Variance Analysis Study Notes

Session Outcomes and Fundamental Concepts

• By the conclusion of this study, students will possess the capability to compute, interpret, and defend gross profit variances.

• The objective is to explain the underlying reasons why gross profit changed between two specific periods, moving beyond the simple observation that a change occurred.

• Analysis requires separating gross profit changes into four primary drivers: price, cost, volume, and sales mix.

• Students must be able to apply six-factor, four-factor, and three-factor analysis for a single product, as well as multi-product analysis including sales mix impacts.

• Quantitative results must be translated into operational actions across various departments: pricing, procurement, production, and channel strategy.

• A "Board-exam mindset" is essential: computation represents only half of the required response; the superior answer provides the business narrative behind the variance.

The Big Picture of Gross Profit Variance Analysis

• Gross profit serves as the "first profit checkpoint," indicating whether a company earns sufficient revenue from product sales before accounting for operating expenses.

• Core Mathematical Relationship:

  • $\text{Gross Profit} = \text{Sales} - \text{Cost of Sales}$

• Expanded Mathematical View:

  • $\text{Gross Profit} = \text{Quantity} \times (\text{Selling Price per Unit} - \text{Cost per Unit})$

• Strategic Importance of Analysis:

  • A rise in revenue can effectively conceal damage occurring to margins.

  • An increase in costs might be strategically acceptable if selling price and volume increases compensate for it.

  • A shift in the product mix can either improve or destroy gross profit, even in scenarios where total unit sales are rising.

  • Variance analysis converts the question of "What happened?" into the more critical "Why did it happen?"

Objectives and Factors causing Variation

• Diagnose: Identifying whether margin movement stems from price, cost, volume, or mix.

• Control: Providing signals to operations, purchasing, pricing, or sales teams regarding the need for corrective action.

• Plan: Improving the accuracy of budgets, pricing policies, procurement planning, and overall product strategy.

• Evaluate: Assessing if company growth is genuinely profitable or simply "busy but not earning."

• Relatable Analogy: Imagine your allowance increases, but food prices and Grab fares increase at a higher rate. You have more cash inflow, but your "gross profit" (leftover cash after survival costs) has decreased.

Narrative Factors of Gross Profit

• Price Factor: Influenced by discounting, premium pricing, promotional activities, channel price changes, and exchange rate pass-through.

• Cost Factor: Influenced by supplier price hikes, material quality changes, freight costs, wastage, labor conversion efficiency, and outsourcing.

• Volume Factor: Influenced by market demand, production capacity, stock-outs, seasonality, sales execution, and competitor activity.

• Sales Mix Factor: The impact of shifting from high-margin to low-margin products, or the reverse.

Basic Data and Symbolic Conventions

• Variance analysis requires comparing a base period (or budget) against an actual period.

• Symbols used in formulas:

  • $BQ$: Base or budgeted quantity (used for volume and mix analysis).

  • $AQ$: Actual quantity (used for price, cost, and actual mix analysis).

  • $BP$: Base or budgeted selling price per unit.

  • $AP$: Actual selling price per unit.

  • $BC$: Base or budgeted cost per unit.

  • $AC$: Actual cost per unit.

• Sign Convention: Favorable (F) variances increase gross profit; Unfavorable (U) variances decrease gross profit.

Single Product Analysis Methods

There are three primary methods for single-product analysis, each differing in complexity and how interaction effects are handled.

• Six-factor Method:

  • Isolates pure volume, pure price/cost, and interaction effects.

  • Strength: Mathematically the most precise.

  • Complexity: Highest.

• Four-factor Method:

  • Analyzes volume and uses actual quantity to determine price/cost effects.

  • Strength: Clean and practical for standard management reporting.

  • Complexity: Moderate.

• Three-factor Method:

  • Analyzes the net gross profit impact of volume, price, and cost.

  • Strength: Fastest and most suitable for exam conditions.

  • Complexity: Lowest.

Comparison of Methods

• All methods reconcile to the same total gross profit change (e.g., $-₱1,404,000$ in Case 1).

• The only difference lies in the classification of interaction effects.

• Six-factor separates interactions; Four-factor and Three-factor absorb them into price and cost variances.

Case Study 1: Tala Tumbler Co.

Business Context:

• The company sells insulated stainless bottles.

• In 2026, a "Back-to-Campus" discount campaign was launched to increase volume.

• Demand improved, but stainless steel and freight costs rose due to supplier repricing.

Data Table:

• Selling Units: 24,000 (Base) | 27,600 (Actual)

• Selling Price/Unit: $₱750$ (Base) | $₱720$ (Actual)

• Cost/Unit: $₱450$ (Base) | $₱510$ (Actual)

• Sales: $₱18.00M$ (Base) | $₱19.87M$ (Actual)

• Cost of Sales: $₱10.80M$ (Base) | $₱14.08M$ (Actual)

• Gross Profit: $₱7.20M$ (Base) | $₱5.80M$ (Actual)

Calculated Movements:

• Total Sales Change: $+₱1.872M$

• Total COGS Change: $+₱3.276M$

• Total GP Change: $-₱1.404M$

Step 1: Total Movement Calculation

1. Base GP: $24,000 \times (₱750 - ₱450) = ₱7,200,000$

2. Actual GP: $27,600 \times (₱720 - ₱510) = ₱5,796,000$

3. Change: $₱5,796,000 - ₱7,200,000 = -₱1,404,000$ (Unfavorable)

• Interpretation: Volume rose, but per-unit margin dropped from $₱300$ to $₱210$. The company sold more units but earned less per bottle.

Three-Factor Solution

• Volume Factor: $(27,600 - 24,000) \times (750 - 450) = +1.080M$ (F)

• Price Factor: $27,600 \times (720 - 750) = -0.828M$ (U)

• Cost Factor: $27,600 \times (450 - 510) = -1.656M$ (U)

• Net Change: $-1.404M$ (U)

• Narrative: Volume helped by $₱1.08M$, but discounts hurt by $₱0.828M$ and cost inflation hurt by $₱1.656M$.

Four-Factor Solution

• Sales Volume Var: $(27,600 - 24,000) \times 750 = +2.700M$ (F)

• Sales Price Var: $27,600 \times (720 - 750) = -0.828M$ (U)

• COGS Volume Var: $(27,600 - 24,000) \times 450 = +1.620M$ (U impact on GP)

• COGS Cost Var: $27,600 \times (510 - 450) = +1.656M$ (U impact on GP)

• Reconciliation: Sales Change ($+1.872M$) - COGS Change ($+3.276M$) = $-1.404M$ (U)

Six-Factor Solution (Millions of Pesos)

• Sales Volume: $(27,600 - 24,000) \times 750 = +2.700$ (F)

• Sales Price: $24,000 \times (720 - 750) = -0.720$ (U)

• Volume-Price interaction: $3,600 \times (720 - 750) = -0.108$ (U)

• COGS Volume: $(27,600 - 24,000) \times 450 = +1.620$ (U impact)

• COGS Cost: $24,000 \times (510 - 450) = +1.440$ (U impact)

• Volume-Cost interaction: $3,600 \times (510 - 450) = +0.216$ (U impact)

• GP Change: $-1.404M$ (U)

• Business Conclusion: The volume push was insufficient to absorb the price discount and the higher input cost.

Multiple Product Analysis and Sales Mix

• Units sold do not tell the whole story in a multi-product firm because different products have different per-unit gross profits.

• Sales Mix: A portfolio issue. A shift toward low-margin items reduces total GP even if revenue grows. Conversely, shifting toward high-margin items improves GP even if volume is flat.

Multi-Product Formulas

• Base GP/Unit per product: $\text{BP}_i - \text{BC}_i$

• Base Weighted Average GP/Unit: $\text{Base total GP} \div \text{Base total units}$

• Volume Variance: $(\text{Actual total units} - \text{Base total units}) \times \text{Base weighted average GP/unit}$

• Sales Mix Variance: $\sum[\text{AQ}_i \times \text{Base GP/unit}_i] - [\text{Actual total units} \times \text{Base weighted average GP/unit}]$

• Price Variance: $\sum[\text{AQ}_i \times (\text{AP}_i - \text{BP}_i)]$

• Cost Variance: $\sum[\text{AQ}_i \times (\text{BC}_i - \text{AC}_i)]$

Case Study 2: Tala Lifestyle Products

Scenario:

• Three product lines: Pro Flask (highest margin), Daily Tumbler, and Kids Bottle.

• Analysis objective: Determine if the 2026 strategy improved gross profit quality.

Raw Data (Product | BQ | BP | BC | AQ | AP | AC):

• Pro Flask: 10,000 | $₱2,200$ | $₱1,450$ | 12,500 | $₱2,100$ | $₱1,520$

• Daily Tumbler: 15,000 | $₱1,400$ | $₱900$ | 13,000 | $₱1,480$ | $₱970$

• Kids Bottle: 8,000 | $₱1,800$ | $₱1,100$ | 11,000 | $₱1,750$ | $₱1,180$

• Totals: Base units 33,000 | Actual units 36,500 | Base GP $₱20.60M$ | Actual GP $₱20.15M$ | GP Change $-₱0.45M$.

Analysis Steps:

1. Base GP/Unit Determination: Pro Flask ($₱750$), Daily Tumbler ($₱500$), Kids Bottle ($₱700$).

2. Weighted Average Base GP/Unit: $₱20.60M \div 33,000 = ₱624.24$

3. Volume Variance: $(36,500 - 33,000) \times ₱624.24 = +₱2.185M$ (F). If mix were stable, more units would have added $₱2.185M$.

4. Sales Mix Variance:

   • $\sum[\text{AQ} \times \text{Base GP/unit}] = (12,500 \times 750) + (13,000 \times 500) + (11,000 \times 700) = ₱23.575M$

   • Mix Variance: $₱23.575M - (36,500 \times 624.24) = +₱0.790M$ (F). The actual mix leaned slightly toward higher base-margin products.

5. Price Variance:

   • Pro Flask: $12,500 \times (-100) = -1.250M$

   • Daily Tumbler: $13,000 \times 80 = +1.040M$

   • Kids Bottle: $11,000 \times (-50) = -0.550M$

   • Total Price Variance: $-₱0.760M$ (U).

6. Cost Variance:

   • Pro Flask: $12,500 \times (-70) = -0.875M$

   • Daily Tumbler: $13,000 \times (-70) = -0.910M$

   • Kids Bottle: $11,000 \times (-80) = -0.880M$

   • Total Cost Variance: $-₱2.665M$ (U). This was the largest unfavorable driver due to cross-line cost inflation.

Classroom Application: Cebu Roast Café

Data Set:

• Classic Latte: BQ 8,000, BP 160, BC 75 | AQ 9,500, AP 150, AC 82

• Spanish Latte: BQ 6,000, BP 185, BC 92 | AQ 7,800, AP 178, AC 104

• Cold Brew: BQ 5,000, BP 145, BC 63 | AQ 4,200, AP 152, AC 66

Analysis Solution:

• Base GP: $₱1,648.0K$ | Actual GP: $₱1,584.4K$

• Total GP Change: $-₱63.6K$ (U)

• Volume Factor: $+₱216.8K$ (F)

• Sales Mix Factor: $+₱12.5K$ (F)

• Price Factor: $-₱120.2K$ (U)

• Cost Factor: $-₱172.7K$ (U)

• Discussion Theme: Is the heavy discounting on Classic Latte smart when milk and coffee ingredient costs are rising? Determining a minimum price floor is necessary.

Common Mistakes in Gross Profit Analysis

• Confusing "cost variance" from standard COGS analysis with the specific "cost factor" used as part of GP analysis.

• Utilizing base quantity instead of actual quantity when calculating price variance in four-factor or three-factor models.

• Overlooking that an increase in the absolute cost of sales is unfavorable to gross profit.

• Erroneously treating sales mix and sales volume as the same metric.

• Ending the work at the numerical result without explaining the operational cause.

• Exam Tip: Always label variances as F or U and ensure the table reconciles to the total GP change; failure to reconcile indicates a mathematical error.

Managerial Decision Guide

Questions & Discussion

• Question: Why can gross profit decrease even if sales revenue increases?

• Answer: Revenue growth can be driven by volume, but if the cost per unit rises faster than the price or if units are sold at a significant discount, the margin per unit shrinks, potentially overwhelming the volume gains.

• Question: In three-factor analysis, why is the cost factor computed as $AQ \times (BC - AC)$?

• Answer: This formula isolates the impact of cost changes on the units actually sold. If $BC - AC$ is negative (Actual Cost > Base Cost), it correctly results in an unfavorable reduction to Gross Profit.

• Question: What is the difference between volume variance and sales mix variance?

• Answer: Volume variance measures the change in profit resulting from the change in the total number of units sold, assuming the relative proportions of products stay the same. Sales mix variance measures the impact of the change in those relative proportions (the portfolio blend).

• Question: Which method explicitly shows volume-price and volume-cost interaction effects?

• Answer: The Six-factor analysis method.

• Question: How would you explain a favorable mix variance but unfavorable total GP movement?

• Answer: This occurs when the company is successfully selling a larger proportion of its high-margin products (favorable mix), but this success is being overshadowed by severe input cost inflation or drastic price cuts across all products (unfavorable cost/price).