Hi Gurus,
Hoping someone here has run into this. We're on Standard Costing with an Assembly item and the Production Price Variance / Production Quantity Variance posted at Work Order Close doesn't reconcile with the formulas in NetSuite's own Help Center article ("Assembly Build Production Cost Variances"). Would love a sanity check before we open a formal SuiteAnswers/Support case.
Setup:
- Item: Assembly, Standard Costing, standard unit cost $235.00 (set via Inventory Cost Revaluation)
- Work Order built 2 units
- Work Order Completion capitalized Finished Goods at standard cost: $470.00 (2 × $235.00)
- Work Order Close then posted:
- Debit 590002 Production Price Variance: $143.33
- Credit 590001 Production Qty Variance: $24.99
- Net unfavorable variance = $118.34, which does tie back correctly to Actual cost absorbed into WIP ($588.34) minus Standard cost ($470.00). So the total is right — it's the split between the two accounts that looks off.
Per the documented formulas:
- Production Price Variance = Actual Quantity Used × (Standard Cost − Actual Cost)
- Production Quantity Variance = Standard Cost × (Standard Quantity − Actual Quantity)
Breaking this WO down line by line:
- Raw materials — actual quantity consumed matched the BOM exactly (2 of 2, 4 of 4, zero quantity variance), but actual unit cost was way below standard ($1.00 vs $100.00, $2.00 vs $50.00/Kg). That's a pure rate difference, so per the formula this should be almost entirely Price Variance — roughly −$390 (favorable).
- Routing/labor resources (Labor Run, Machine Setup, Labor Setup) — actual hourly rate matched standard almost exactly ($10/$20/$5 per hour), but actual hours logged were way more than standard assumes for a 2-unit build (34 hrs vs. an implied ~2 hrs for Labor Run alone). That's a pure quantity/usage difference, so this should be almost entirely Quantity Variance — roughly +$508 (unfavorable).
So I'd expect something like −$390 Price / +$508 Quantity (netting to the same +$118.34). Instead the system posted +$143.33 Price / −$24.99 Quantity — almost the opposite weighting.
Questions :
- Does anyone know if routing/operation-based cost categories (Labor Run, Machine Setup, Labor Setup) get bucketed differently than BOM material components in the variance calc? I couldn't find that distinction documented anywhere.
- Has anyone seen NetSuite fold "extra hours consumed" into Price Variance instead of Quantity Variance when Advanced Manufacturing routings are involved?
Thanks