Gross Profit Variance: Separate Price, Input Costs and Waste
Explain a gross profit shortfall by changing one input at a time: selling price, the amount of material used and its price. Keep output volume fixed for this first check. Split extra usage into recorded waste and other usage differences, then reconcile the movements to actual gross profit without counting the same loss twice.
What you’ll get from this guide: Build a gross profit bridge with a record supporting each movement.
- Hold sales volume constant when comparing unit economics.
- Value usage differences at the planned input price, then calculate the input-price effect on actual usage.
- Waste is part of material usage; do not deduct both in full.
Use this worksheet when a recipe or manufactured item earns less than planned. It starts with one product so you can find the operational cause before widening the review to the whole range.
Gather output, material and sales records
For the same batch or period, collect units sold, net sales, material issued into production, returned material, measured waste and supplier prices. Purchases alone are not material consumption if unused stock remains on hand. Separate sales discounts from returns and make sure units are consistent: kilograms throughout, not kilograms in one column and packets in another.
ACCA's material variance explanation separates input price from usage. It also warns against counting a total usage difference and its component mix or yield differences together. The worksheet below uses one material and splits usage into recorded waste and other excess consumption.
Reconcile a $426 shortfall
The fictional business makes and sells 1,000 items. Planned selling price is $10, material consumption 200 kg at $4/kg, and other direct costs $3,000. Actual selling price averages $9.80. It uses 230 kg at $4.20/kg; the other direct costs are unchanged. There is no unsold output or work in progress.
Assumptions: Fictional Australian-dollar management example. Revenue and costs exclude any recoverable GST; non-recoverable tax is included in costs. No GST entitlement or income-tax deduction is assumed for your business. Contribution is before unallocated overhead and income tax.
| Movement | Calculation | Change | Running gross profit |
|---|---|---|---|
| Planned result | $10,000 − $800 − $3,000 | Starting point | $6,200 |
| Selling price | 1,000 × ($9.80 − $10) | −$200 | $6,000 |
| Recorded extra waste | 20 kg × $4 | −$80 | $5,920 |
| Other extra usage | 10 kg × $4 | −$40 | $5,880 |
| Input price | 230 kg × ($4.20 − $4) | −$46 | $5,834 |
Original ASBG worked example. All businesses, amounts and scenarios are fictional. The table contains the same figures as the visual.
The direct check is $9,800 sales − $966 materials − $3,000 other costs = $5,834. That matches the bridge. Total extra usage is 30 kg, worth $120 at the planned price. The 20 kg waste line is already inside that $120; deducting another $120 would count it twice.
The example assumes the standard 200 kg already allows normal losses. Only waste above that allowance enters the bridge. If the standard is unrealistic, revise it transparently for future reviews rather than rewriting last month's target to remove the difference.
Match each movement to a record
Check the $200 price reduction against discounts, refunds and invoice lines. Match the $46 material-price movement to the actual cost of material consumed, not an unrelated recent quote. Compare waste logs with production output, and investigate the remaining 10 kg: oversized portions, rework, measurement errors or incorrect stock issues are different problems requiring different fixes.
Don't conclude that cheaper ingredients are better until you measure usable output. Our recipe yield worksheet costs the portions you can actually sell.
Add volume and mix only after this check agrees
If sales volume changed, first recalculate the planned contribution at actual volume. If several products changed their share of sales, use the sales-mix comparison separately. Label each bridge's starting point so their totals are not added together incorrectly.
Where to get help
Take the reconciled worksheet and source records to your accountant or production manager. Use the profit and loss guide for report classifications and the pricing and profit hub for the next costing task.
Where to go from here
Sales Rose but Gross Margin Fell? Check Your Sales Mix
Check whether product mix explains the overall margin.
3 min readProduct Returns: Calculate Their Effect on Real Margin
Include refunds, return costs and recovered stock.
3 min readRecurring Revenue Profit: Model Cancellations and Service Costs
Continue the “diagnose falling profit” reading sequence.
4 min read
General information only. This guide doesn't take your personal or business circumstances into account and isn't financial, legal or tax advice. Rates and thresholds change — check the official sources linked in this guide and get qualified advice where your circumstances require it.