Composites, Fiberglass & Advanced Materials calculator
Advanced Material Price Variance Calculator
Advanced Material Price Variance quantifies how much more or less you paid for prepreg, carbon fiber, resin, or core than the standard cost in your system, expressed in dollars. Cost accountants and supply-chain buyers in composites and advanced-materials shops use it to explain margin swings and to flag when purchase prices have drifted from standards that may need revising. Because advanced materials are volatile and often tariff- or freight-sensitive, isolating price variance from usage variance is essential for clean cost analysis. This calculator separates the per-pound price gap from fixed freight, tariff, and surcharge effects so each driver is visible.
What this calculator does
- Estimate price variance for carbon fiber, aramid, core, resin, prepreg, or specialty advanced materials.
- reviewing material price variance for composite programs
- It computes total material price variance as the per-pound price gap times pounds purchased times scope, plus a fixed freight, tariff, or surcharge amount.
Formula used
- Variable advanced material price variance = advanced material purchase quantity × price variance versus standard × variance scope included
- Total advanced material price variance = variable advanced material price variance + fixed freight, tariff, or surcharge variance
Inputs explained
- Advanced material purchase quantity:
- Actual price variance versus standard:
- Share of variance scope included:
- Fixed freight, tariff, or surcharge variance:
How to use the result
- Use it at period close, during PPV reviews, or whenever a supplier price change or surcharge needs translating into a dollar margin impact.
- It isolates price only; it does not capture usage or yield variance, so a favorable price on a material you over-consume can still hurt total material cost.
Current U.S. benchmarks
- The producer price index for plastic resins and materials stands at 319.371 (BLS, May 2026), up 19.5% from a year earlier. Quotes priced off last quarter's material cost miss this move.
- Steel mill PPI stands at 348.53 (BLS, May 2026), up 6.7% from a year earlier. New factory orders are up 2.3% year over year (Census).
Common questions
- How do you calculate material price variance? Multiply the price gap versus standard by pounds purchased and by scope, then add fixed freight or tariff variance. Here 520 lb x $7.40/lb x 100% = $3,848, plus $0 fixed = $3,848 total.
- Is a positive variance good or bad? It depends on sign convention. Here the $7.40/lb gap is an unfavorable price above standard, producing a $3,848 cost overrun. A negative per-pound figure would represent buying below standard, a favorable variance.
- What is the per-part price variance? When normalized, the variance works out to about $7.40 per unit in this example because the fixed adder is zero and scope is 100%, so the per-pound gap passes straight through.
- Why separate freight and tariffs into a fixed line? Per-pound price drift and lump-sum surcharges behave differently. Tariffs or expedite fees often arrive as fixed dollar hits independent of weight, so isolating them keeps the per-pound price signal clean for sourcing decisions.
- When should I update the standard cost instead of logging variance? If you consistently see a large one-direction variance like this $7.40/lb gap across several buys, the standard is stale. Persistent variance is a signal to re-baseline the standard rather than keep explaining the same gap.
Last reviewed 2026-05-12.