Material Price Surcharge Pass-Through Calculator
When steel, aluminum, copper or resin moves, fixed-price quotes lose margin fast. A surcharge clause moves part of that risk to the customer. This calculator shows the surcharge per piece and the margin you keep with and without it.
Your numbers
Index or supplier price used in the quote.
No surcharge unless the move exceeds this percent.
Your results
Illustrative. Real clauses define the index, the lag, the averaging period and the cap. Follow the wording in your contract.
Surcharge and unrecovered cost versus material price
Sweeps Current material price from 1.5 to 3.5, holding your other inputs fixed.
Index-linked surcharges in your ERP
Optional: a conversation about posting surcharge lines automatically from an index table.
Optional. The tool and every export work without this. No spam.
How to use it
Enter the quoted price and margin, the material weight per piece including scrap, the material price used at quote time and today's price. Set a threshold band, because most clauses ignore small moves, and a pass-through share if the customer only absorbs part of the increase. The tool shows the cost impact, the surcharge, whatever remains unrecovered and the resulting margin both ways. The chart sweeps current price so you can propose a table of surcharge values to the customer.
Designing the clause
A workable clause names a published index, the reference date, the averaging window and the lag between index and invoice. It states whether the surcharge applies to price rises only or to falls as well. Symmetry is easier to sell and keeps the relationship fair. Cap and floor values protect both sides. Use material weight that includes scrap and cutting allowance, otherwise you pass through less than you actually pay. Review how the clause interacts with price breaks and blanket orders in your ERP so the surcharge posts as its own line.
- Tie the clause to a public index, not your own invoice
- Include scrap allowance in the weight
- Make it symmetric where the customer insists
- Show it as a separate invoice line
Common mistakes
The usual error is basing the surcharge on net part weight when the process buys bar or plate with large offcut losses. Another is ignoring inventory: if you hold three months of stock bought at the old price, the increase reaches your cost with a delay, and charging the surcharge immediately may breach the agreed lag. Finally, remember that a percentage band behaves differently at low and high price levels, so test the band at both ends before you sign.
Frequently Asked Questions
How is a material surcharge calculated?
Multiply the material weight per piece by the change in price per unit weight, then apply the threshold and pass-through share defined in the contract. The result is added to the piece price as a separate line.
Should scrap be included in the weight?
Yes. You pay for the material you buy, not only what ends up in the part. Using gross weight, including expected scrap and offcuts, recovers the true cost impact, unless the contract explicitly states net weight.
What threshold band is typical?
Bands of a few percent are common so that routine noise does not trigger paperwork, but they vary by industry and customer. Some contracts use a fixed currency amount per kilogram instead of a percentage.
Does the surcharge change my margin percent?
It restores margin dollars but the percentage differs slightly because the price base grows. The calculator shows margin with and without the clause so you can see both effects.
If your ERP can post a surcharge line from an index table, we can help wire it into quoting and invoicing without manual spreadsheets.
Related Tools
Target Costing Allowable Cost Gap Calculator
Compute allowable cost from selling price and target margin, then see the gap and annual value of closing it.
Costing & FinanceTooling and NRE Amortization Per Piece Calculator
Amortize tooling and NRE over lifetime volume, add financing, and see the effect on piece price at different volumes.
Costing & FinanceCost Reduction Savings Tracker Worksheet
An editable list of cost-down projects with unit saving, annual saving, implementation cost and payback.
Costing & FinanceQuote Assumptions and Exclusions Template
A fill-in page that states what a manufacturing quote includes, what it assumes and what it leaves out, ready to attach to the price.
More Costing & Finance tools
See all- SAP QM Inspection Effort and Cost Calculator
- SAP Standard Cost Estimate BOM Rollup Calculator
- Legacy ERP Retirement Cost and Payback Calculator
- JD Edwards World Month-End Close Procedure Template
- Distributor Customer Credit Application Template
- Distributor Customer Profitability Worksheet
- Distributor GMROI and Inventory Turns Calculator
- Vendor Early Pay Discount Worksheet
- SyteLine Cost Rollup Variance Calculator