Rubber Part Quote Worksheet (Excel)
Rubber quoting fails when the sheet hides assumptions. This worksheet puts every cost driver in a column, so a salesperson or estimator can see compound, press time, labor, secondary operations, scrap and margin for each part and export the whole quote to Excel.
| Part number | Compound | Order qty (pcs) | Part weight (g) | Flash % (%) | Compound $/kg | Press cycle (sec) | Cavities | Press $/hr | Labor $/part | Secondary $/part | Scrap % (%) | Margin % (%) | Unit cost | Unit price | Extended price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
$0 | $0 | $10,168 | ||||||||||||||
$0 | $1 | $3,325 | ||||||||||||||
$0 | $0 | $17,337 | ||||||||||||||
$1 | $2 | $16,057 | ||||||||||||||
$2 | $3 | $32,825 |
Unit cost = (compound + press time + labor + secondary) divided by (1 - scrap). Compound = part weight x (1 + flash) / 1000 x $/kg. Press time = $/hr x cycle seconds / 3600 / cavities. Price = unit cost divided by (1 - margin), so margin is a share of the selling price. Tooling, setup, freight and packaging are not included; add them as separate lines or in Labor and Secondary $/part. Example figures are illustrative.
Automate quoting from your ERP data
Optional: we can review how rates, weights and compound prices could feed this kind of sheet automatically, read-only.
Optional. The tool and every export work without this. No spam.
How to use it
Add one row per part number and order quantity. Fill part weight, flash, compound cost, press cycle, cavities and press rate, then labor and secondary cost per part, scrap percent and target margin. Unit cost, unit price and extended price compute automatically, and totals show the quote value. Change a cavity count or cycle time and watch the price respond, then export to Excel for the customer pack.
- Take part weight and flash from the calculator or from weighed samples.
- Use press cycle including cure and handling, not cure alone.
- Put one-time tooling and setup on a separate line.
Costing method
Four direct cost elements are summed per part: compound by weight, press time shared across cavities, direct labor, and secondary operations such as deflash, post-cure, inspection and packing. Scrap is applied by dividing by one minus the scrap rate, which correctly grosses up for parts that must be molded to yield one good part. The selling price divides by one minus margin, so a 25 percent margin means 25 percent of the price is profit.
Reading the example
In the sample rows, the FKM seal carries compound cost far above the NBR gasket despite a lower part weight, because FKM is priced many times higher per kilogram. The silicone diaphragm is dominated by cycle time and post-cure labor instead. Looking across rows shows which parts are material-driven and which are time-driven, so you know whether to negotiate compound price or push cavitation and cycle.
Common mistakes
Mixing margin and markup is the most common error: 25 percent markup on cost is only 20 percent margin. Others are using full press capacity instead of efficiency, leaving out post-cure and inspection, and forgetting to reprice when compound costs move. Also remember that volume breaks change setup absorption, so quote each quantity break as its own row.
Frequently Asked Questions
Is margin the same as markup?
No. Margin is profit as a share of selling price; markup is profit as a share of cost. A 25 percent margin requires a 33.3 percent markup. This worksheet divides cost by one minus margin, so the margin figure is a true margin.
How should I treat tooling cost?
Quote tooling as a separate one-time line, or amortize it over an agreed quantity and state that clearly. Folding it silently into piece price makes re-orders and volume changes hard to manage.
How is press cost per part calculated?
Press hourly rate times cycle seconds, divided by 3600, divided by cavities. That is machine cost per molded part before scrap. Using real efficiency in the hourly rate or cycle keeps it honest.
Can I export this to Excel?
Yes. The page exports the worksheet to Excel, CSV and PDF. Computed columns export as values, so keep the browser copy if you want to keep editing the formulas.
Netray can link a sheet like this to your ERP item master, routings and compound prices so rates and weights fill themselves. Ask for a short review of your quoting workflow.
Related Tools
Rubber Part Weight and Compound Charge Calculator
Turns ring, washer or bushing geometry into part volume, weight, mold charge weight with flash allowance, and compound cost per part and per shot.
MES & Shop FloorRubber Cure Time and Press Cost Calculator
Scales a known cure time to a new thickness and mold temperature, builds the full press cycle, and returns parts per hour and machine plus labor cost per part.
Costing & FinanceRubber Flash and Scrap Allowance Calculator
Stacks flash, molding rejects, trim rejects and start-up compound to show real yield, kilograms required and material cost per good part.
Industry TemplatesRubber Molding Job Quotation Template
A fill-in quotation document for custom molded rubber parts covering compound spec, tolerances, price breaks, tooling, lead time, assumptions and terms.
More Costing & Finance tools
See all- O-Ring Compound Volume and Cost Calculator
- 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
Keep exploring
Free tools
- Rubber Part RFQ Review and Quotation ChecklistThirty-plus checks to run on a molded rubber RFQ so compound, tolerance, tooling, process and commercial risks are caught before the quote goes out.
- Rubber Cure Time and Press Cost CalculatorScales a known cure time to a new thickness and mold temperature, builds the full press cycle, and returns parts per hour and machine plus labor cost per part.
- Rubber Molding Job Quotation TemplateA fill-in quotation document for custom molded rubber parts covering compound spec, tolerances, price breaks, tooling, lead time, assumptions and terms.
Guides
- How to Quote Custom Rubber Molded PartsHow to quote custom rubber molded parts: compound weight, cavity count, cure time, press rate, flash, scrap and tooling amortization, built up in the right order.
- AI RFQ Quoting for Rubber and Elastomer ManufacturersHow AI helps rubber and elastomer manufacturers quote faster: reading RFQs and prints, matching past jobs, drafting cost builds for estimator approval, on-prem.
- ERP for Rubber Molding and Extrusion Manufacturers: What to RequireERP for rubber molding and extrusion manufacturers: what to require for compound lots, cure data, mold tracking, scrap and costing, and how common systems compare.