Stamping Quote Breakdown Worksheet (Excel)
This worksheet puts several stamping parts on one quote page and calculates unit cost, unit price and annual revenue from material, press time and secondary cost. Edit the rows, add parts and export to Excel.
| Part number | Process | Annual volume | Gross lb per part | Coil $/lb | Good parts/hr | Press rate $/hr | Secondary $/pc | Margin % | Material $/pc | Press $/pc | Unit cost $/pc | Unit price $/pc | Annual revenue | Annual gross profit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.0407 | 0.033 | 0.1137 | 0.1386 | $16,637 | $2,995 | ||||||||||
0.013 | 0.0183 | 0.0464 | 0.0552 | $13,796 | $2,207 | ||||||||||
0.2418 | 0.1333 | 0.5951 | 0.763 | $30,520 | $6,714 | ||||||||||
0.099 | 0.05 | 0.179 | 0.2238 | $13,425 | $2,685 | ||||||||||
0.247 | 0.0722 | 0.4092 | 0.5052 | $45,469 | $8,639 |
Material is gross weight times coil price, with no scrap credit. Add die amortization as a secondary cost per piece, or quote tooling separately. Use the Piece Price at Volume calculator to derive pph, rate and setup assumptions.
Move estimating out of spreadsheets
Optional: an outline of how quote data could flow into your ERP routing and standard cost records.
Optional. The tool and every export work without this. No spam.
How to use it
For each part, enter the process, annual volume, gross pounds per part from your strip layout, coil price, good parts per hour and press rate. Add any secondary cost per piece such as plating, tumbling or packaging, and the margin you want. The worksheet calculates material and press cost per piece, unit cost, unit price at target margin and annual revenue and gross profit. The summary shows blended margin and average price per piece, which is useful when a customer asks you to bundle a family of parts.
How the columns are calculated
Material cost per piece equals gross pounds times price per pound. Press cost equals press rate divided by good parts per hour. Unit cost adds the secondary cost. Unit price equals unit cost divided by one minus the margin fraction, so the margin is a share of price. Annual revenue equals volume times unit price. Because the model has no tooling, setup or freight term, add those as secondary cost per piece or quote them separately.
- Use gross weight, not net, for material.
- Good parts per hour should already include press efficiency.
- Volumes are annual; match them to the committed volume in the RFQ.
Common mistakes
Estimators often apply the same press rate to every process even though a deep draw or transfer press carries a higher burden. Another mistake is to quote price breaks without re-computing material, which hides that a bigger coil lot can lower the price per pound. Keep a copy of the filled worksheet with the RFQ number as the audit trail for later price review requests.
Frequently Asked Questions
How is the unit price calculated?
Unit price equals unit cost divided by one minus margin. With a unit cost of 0.40 and a margin of 20 percent, the price is 0.50. Multiplying cost by 1.20 would give only 0.48 and a lower real margin.
Can I add tooling cost?
Compute die amortization per piece with the Piece Price at Volume calculator and enter it in the secondary cost column, or quote tooling as a separate line item. Keep one method per quote to avoid double counting.
How many parts can I enter?
Add as many rows as you need. The totals and blended margin update as rows are edited, and the whole table exports to Excel or CSV.
Should material use gross or net weight?
Gross. The coil you buy includes the scrap the die creates. If you receive scrap credit, subtract it in the secondary cost column as a negative value or use the strip layout calculator to get the net cost.
If your quotes are built in spreadsheets and re-keyed into the ERP, we can help connect estimating to item, routing and standard cost data.
Related Tools
Stamping Piece Price at Volume Calculator
Build up the piece price of a stamped part from die amortization, die maintenance, setup, press time, material and secondary operations, and see how price falls with volume.
Engineering & PLMStamping Strip Layout Material Utilization Calculator
Turn blank size, bridge and edge scrap into strip width, pitch, utilization percent and material cost per part, with a sweep of utilization against bridge width.
Supply Chain & InventoryStamping RFQ Package Template
A fill-in RFQ for stamped or progressive die parts that captures the data a stamper needs to quote accurately and compare bids.
Industry TemplatesStamping Material Density and Shear Strength Reference
Look up density and typical shear strength for the alloys most often stamped, to feed weight, tonnage and cost estimates.
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
Keep exploring
Free tools
- Stamping Piece Price at Volume CalculatorBuild up the piece price of a stamped part from die amortization, die maintenance, setup, press time, material and secondary operations, and see how price falls with volume.
- Stamping RFQ Package TemplateA fill-in RFQ for stamped or progressive die parts that captures the data a stamper needs to quote accurately and compare bids.
- Automotive Part Quote Cost Breakdown WorksheetLine-by-line piece price build-up for an automotive RFQ, with extended costs per line and a price at your target margin.
Guides
- Stamping Quote Estimating: Faster Quotes Without Guessing the Press RateHow metal stamping shops estimate quotes: press rate, die amortization, coil yield, secondary ops and where software or AI shortens the cycle without losing margin.
- How to Calculate Coil and Scrap Cost in Metal StampingCalculate coil cost per part in stamping: blank weight, yield, carrier loss, scrap credit, steel surcharges and how to track real utilization from the floor.
- AI RFQ Review for Metal Stamping Suppliers: Read the Package, Flag the RiskHow AI can read stamping RFQ packages, extract print, volume, PPAP level and terms, flag risks and draft a quote for estimator review without exposing customer data.
Manufacturing hubs
- PMA and the metal stamping ecosystem: plants, standards and ERP realitiesThe Precision Metalforming Association serves stampers, die makers and metalformers. See the ecosystem, standards, ERP and private AI issues for plants.
- Metal forming, polymers and fasteners in Northeast OhioNortheast Ohio manufacturing in Cleveland and Akron: metal forming, polymers, fasteners, MAGNET, PMA, standards and where private AI on ERP data helps.