IndiaLaw by assureOffice
Manufacturing Material Cost Variance Analysis

Manufacturing MIS Material Variances: Price, Usage, Mix, Yield and Inventory Reconciliation

Build an output-adjusted material-cost bridge. Separate procurement price from consumption, decompose mix and yield, and control normal loss, units and revised-standard sensitivities.

Reviewed by CA Preeti Agarwal · Chartered Accountant | 15+ years in MIS Reporting

Business charts and performance reports

A cheaper input can still make production more expensive

Compare actual material cost with the standard material cost allowed for actual output, then separate price from usage. A favourable purchase or issue price can be outweighed by extra consumption, poor yield or a different input mix. A monthly MIS that reports only procurement savings can therefore congratulate purchasing while the total material result worsens.

The framework follows the material-cost, price, usage, mix and yield identities in ICAI Board of Studies standard-costing teaching material. The production controls and fictional cases below are an independent MIS application for manufacturing teams. This is management analysis, not a prescription for statutory inventory measurement or a claim that a particular variance must be capitalised. The teaching material is a conceptual source, not a new 2026 law.

Define output, quantity and price on the same basis

For the basic consumption-based model, SQ is standard input quantity allowed for the actual good output, SP the standard input price, AQ the actual quantity consumed and AP its matched actual cost per unit. Use the same period, material specification, measurement unit and cost perimeter on both sides. If standard cost includes landed freight but actual price excludes it, the apparent price result may be a scope difference rather than procurement performance.

Actual output is essential. Comparing actual cost for a lower production volume with a full static production budget can create an apparent saving merely because fewer units were made. Rebuild the allowed input from actual output using the approved consumption/yield standard before measuring usage. Keep normal-loss assumptions explicit so standard quantities are not incorrectly set equal to net good output.

VarianceFormula under this article’s sign conventionInterpretation
Total material costSQ × SP − AQ × APStandard cost allowed for actual output less matched actual material cost
PriceAQ × (SP − AP)Consumption-based price effect using actual quantity
UsageSP × (SQ − AQ)Input quantity effect at standard price
Mix, for comparable input unitsSum of SP × (revised standard-mix quantity − AQ)Actual total input restated in standard proportions versus actual proportions
YieldSum of SP × (SQ − revised standard-mix quantity)Output/input-yield effect after holding the standard mix

Positive amounts are labelled favourable and negative amounts adverse. Under the matched consumption model, total cost variance equals price plus usage. Where mix/yield decomposition is appropriate, usage equals mix plus yield; do not add both usage and its two components again into the total. Preserve the sign in the reconciliation even if the dashboard displays an absolute amount followed by F or A.

Purchases and consumption answer different price questions

A purchase-price variance uses the quantity purchased under its stated model. A consumption-price variance uses the quantity consumed and the cost assigned to that consumption. These populations differ when inventory changes. Do not drop a purchase-based result into a consumption bridge without reconciling the inventory-related difference.

The simplified purchase/consumption example below assumes one clearly identified cohort, one actual price and no other inventory adjustments. A real working may involve opening stock, several receipts, returns, transfers and a cost-flow method. Reconcile those movements before interpreting the difference as either a saving or an error. A variance report is not itself a journal-entry policy for inventory or cost of sales.

Mix and yield require compatible input quantities

For a blend, derive each revised standard-mix quantity by applying the standard proportion to the actual total input. This holds the input total constant while isolating the change in proportions. Then compare the standard quantity allowed for actual output with those revised quantities to identify yield. All quantities being summed must be meaningfully comparable; do not add litres, kilograms and pieces merely because they appear in one BOM.

A favourable mix may mean less of an expensive material was used, but it does not prove the substitution was commercially desirable. Review product specification, quality, rework, customer claims and downstream yield. Likewise, a usage variance can reflect inaccurate output records, unrecorded returns or a stale BOM as well as genuine production efficiency. The arithmetic identifies a question for investigation, not automatic responsibility.

Keep standards visible when circumstances change

Approve a standard’s effective period, input specification, price basis and expected normal loss. If prices or production conditions change materially, show the result against the original approved standard and separately label any revised-standard sensitivity. Retrospectively replacing the standard with a convenient figure can erase an adverse variance without changing one rupee of actual cost.

Where management wants a planning-versus-operational decomposition, define and document that additional model and its market/technical evidence. The revised-standard illustration below is only a transparent sensitivity: it does not automatically establish controllability or excuse a purchasing result. Retain the original reconciliation beside it.

A useful monthly report closes to quantities and money

Reconcile output to production records, material issues and returns to the stores movement, and actual material cost to the costing ledger. Explain work in progress, scrap, rework and period cut-offs. Use the same validated population for all component variances, then tie the signed bridge back to the total cost difference.

Keep the action log specific: obtain price evidence for a procurement exception, check meter or weighing data for an unexplained quantity movement, and investigate a formulation change with production and quality teams. Pair variance amounts with relevant quantities and business consequences. A small favourable price result is not a reason to ignore a larger adverse material total.

Worked illustrations

These illustrations use fictional facts and expressly stated assumptions. Amounts are Indian rupees unless a different currency or unit is specified. They are independent examples, not findings about any actual client.

Illustrative example 1: Price savings are outweighed by usage

Actual good output is 100 units; the standard allows 2 kg per unit at ₹50/kg, so SQ = 200 kg and standard cost ₹10,000. Actual consumption is 220 kg at ₹48/kg, costing ₹10,560. Price variance = 220 × (50 − 48) = ₹440 favourable. Usage = (200 − 220) × 50 = ₹1,000 adverse. Net cost variance is ₹560 adverse, because +440 − 1,000 = −560.

Illustrative example 2: Flex the allowed cost to actual output

A static budget assumed 1,000 units, 2 kg per unit and ₹50/kg: ₹1,00,000. Actual output is 800 units, so allowed input is 1,600 kg and allowed cost ₹80,000. Actual consumption of 1,700 kg at ₹50 costs ₹85,000. Comparing with the static budget suggests ₹15,000 favourable, but the output-adjusted material result is ₹5,000 adverse. There is no price effect in this case.

Illustrative example 3: Purchase and consumption price populations

Assume one cohort: 1,000 kg bought at ₹45/kg against SP ₹50, with 600 kg consumed and 400 kg still held, no other movements or valuation adjustments. Purchase-price variance is ₹5,000 favourable. The consumed cohort’s price effect is 600 × ₹5 = ₹3,000 favourable; the remaining cohort’s price difference is 400 × ₹5 = ₹2,000. The ₹5,000 purchase result is not all a consumption-period saving; ₹3,000 + ₹2,000 reconciles it.

Illustrative example 4: A mix change at unchanged total input and yield

For 90 units of actual good output, the standard input is 60 kg A at ₹10 and 40 kg B at ₹20: ₹1,400. Actual input is 70 kg A and 30 kg B at those same prices: ₹1,300. The standard-mix restatement of the actual 100 kg total is still 60/40. Mix variance is (60 − 70) × 10 + (40 − 30) × 20 = ₹100 favourable. Yield and price effects are zero, so usage and total cost variances are also ₹100 favourable. Quality must still be investigated.

Illustrative example 5: Reconcile price, mix and yield together

For the same 90-unit good output and 60/40 standard, actual input is 70 kg A at ₹11 plus 40 kg B at ₹19: total 110 kg and actual cost ₹1,530. Standard-mix quantities for 110 kg are 66 kg A and 44 kg B, costing ₹1,540 at SP. Price variance is −₹70 + ₹40 = ₹30 adverse. Mix variance is −₹40 + ₹80 = ₹40 favourable. Yield variance is −₹60 − ₹80 = ₹140 adverse. Usage is ₹100 adverse and total cost variance ₹130 adverse: −30 + 40 − 140 = −130, equal to ₹1,400 − ₹1,530.

Illustrative example 6: Allow for stated normal loss

Assume an approved 80% normal yield: 1.25 kg input is allowed per kg of good output. For actual good output 800 kg, allowed input is 1,000 kg. At SP ₹40/kg, allowed cost is ₹40,000. Actual input of 1,050 kg at ₹40 costs ₹42,000, giving ₹2,000 adverse usage. Incorrectly using 800 kg as allowed input would show ₹10,000 adverse and overstate the deviation by ₹8,000.

Illustrative example 7: Convert tonnes and kilograms before comparing price

Assume allowed and actual consumption are both three tonnes. SP is ₹30/kg, while AP is quoted as ₹31,000 per tonne. Three tonnes are 3,000 kg; standard cost is ₹90,000 and actual cost ₹93,000. AP equals ₹31/kg, so the price effect is ₹3,000 adverse and usage is zero. Comparing the unconverted price numbers 30 and 31,000 would be meaningless.

Illustrative example 8: A standard reset does not reduce actual cost

Assume SQ = AQ = 200 kg, original SP ₹50/kg and AP ₹56/kg. Original allowed cost is ₹10,000 and actual cost ₹11,200: ₹1,200 adverse. A separately labelled revised-price sensitivity at ₹55/kg gives allowed cost ₹11,000 and ₹200 adverse. The apparent ₹1,000 improvement arises solely from changing the comparison standard; actual cost remains ₹11,200 and no physical efficiency improvement is proved.

Ten-step verification table

StepVerificationEvidence to retain
1Define the production and cost populationPeriod, product/BOM, output status and cost perimeter
2Retain the approved standard versionEffective date, normal loss, quantity and price assumptions
3Validate actual good outputProduction completion, rejection and WIP records
4Reconcile actual input consumptionIssues, returns, transfers and unit conversions
5Match actual cost to the quantity populationConsumption costing or separately labelled purchase model
6Calculate allowed input for actual outputOutput-adjusted SQ and normal-yield working
7Compute signed price and usage variancesConsistent F/A convention and component formulas
8Decompose mix/yield only where appropriateComparable units, standard proportions and actual input total
9Tie the bridge and investigate causesPrice + usage = total; mix + yield = usage; evidence-based actions
10Approve reported adjustments and sensitivitiesOriginal-standard result, labelled alternatives and ledger reconciliation

Sixteen practitioner FAQs

1. Why can a favourable price variance coexist with adverse total cost?

Extra usage or poor yield can exceed the price saving. Reconcile the components to the total material cost for actual output.

2. Should SQ follow budgeted output?

For this performance bridge, it is the standard input allowed for actual good output. A static budget answers a different question.

3. What sign convention is used here?

Standard less actual produces a positive favourable amount and a negative adverse amount. Maintain that convention throughout the bridge.

4. What makes price plus usage equal total cost variance?

They must use the same actual consumption quantity, matched actual cost and standard quantity/price basis. Population changes break the identity.

5. Can purchase quantity replace consumed quantity in one component?

Not without a separate purchase model and inventory reconciliation. Otherwise the component no longer matches the consumption-cost bridge.

6. Does the purchase-price variance all belong to current consumption?

Not necessarily. Inventory may retain part of the purchased cohort. Reconcile opening stock, receipts, consumption and closing stock.

7. Can a variance formula decide the statutory inventory entry?

No. Statutory measurement and journal treatment require their own accounting framework and facts; this article addresses management analysis.

8. How is the revised standard mix calculated?

Apply the standard input proportions to actual total input, using compatible quantity units.

9. Can litres and kilograms be summed in a mix total?

Not without a valid common measurement basis. A numerical sum of incompatible units has no useful mix meaning.

10. Should mix, yield and usage all be added to total cost?

No. Mix plus yield decomposes usage. Adding usage again double counts that effect.

11. Does favourable mix prove a successful substitution?

No. Review specification, quality, rework and downstream effects before treating the lower cost as a business improvement.

12. How does normal loss affect the allowed input?

Use the approved normal-yield relationship. Good output and standard gross input need not be equal.

13. Does an adverse usage result automatically blame production?

No. Validate output, issues, returns, measurement and standard accuracy before assigning a cause or responsibility.

14. Can a revised standard replace the original result without explanation?

Do not conceal the change. Retain the original approved-standard result and label the revised comparison with its basis.

15. Does a revised-price sensitivity establish controllability?

No. A planning/operational model needs defined assumptions and supporting market or technical evidence. The sensitivity alone does not allocate responsibility.

16. What should the final MIS action log contain?

The variance, underlying quantity/cost evidence, investigated cause, accountable follow-up and reconciliation to the costing ledger—not only an F/A colour.

Conclusion

Start with validated actual output and consumption, then reconcile the signed components to the full material-cost difference. Investigate operational and data causes before turning a favourable price result into a performance conclusion.

Official references