# Rubber Part Quote Worksheet (Excel)

> Source: https://netray.co/tools/rubber-part-quote-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

A line-by-line costing sheet for molded rubber parts that builds unit cost, selling price and extended value from compound, press time, labor, secondary operations, scrap and margin.

## Category

cost-finance

## Industry

Rubber & Elastomer Products

## Audience

- Estimator
- Sales engineer
- Controller

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Part number

**Key:** part

**Type:** text

#### Compound

**Key:** compound

**Type:** select

**Options:**

- NBR 70
- EPDM 70
- FKM 75
- VMQ 60
- CR 60
- HNBR 75
- NR 50

#### Order qty

**Key:** qty

**Type:** number

**Unit:** pcs

#### Part weight

**Key:** part_g

**Type:** number

**Unit:** g

#### Flash %

**Key:** flash

**Type:** number

**Unit:** %

#### Compound $/kg

**Key:** cost_kg

**Type:** number

**Format:** currency

#### Press cycle

**Key:** cycle_s

**Type:** number

**Unit:** sec

#### Cavities

**Key:** cav

**Type:** number

#### Press $/hr

**Key:** rate

**Type:** number

**Format:** currency

#### Labor $/part

**Key:** lab

**Type:** number

**Format:** currency

#### Secondary $/part

**Key:** sec

**Type:** number

**Format:** currency

**Help:** Deflash, post-cure, inspection, packing, bonding primer.

#### Scrap %

**Key:** scrap

**Type:** number

**Unit:** %

#### Margin %

**Key:** margin

**Type:** number

**Unit:** %

**Help:** Margin on selling price, not markup on cost.

#### Unit cost

**Key:** unit_cost

**Type:** number

**Format:** currency

**Expr:** (part_g * (1 + flash / 100) / 1000 * cost_kg + rate * cycle_s / 3600 / cav + lab + sec) / (1 - scrap / 100)

#### Unit price

**Key:** price

**Type:** number

**Format:** currency

**Expr:** (part_g * (1 + flash / 100) / 1000 * cost_kg + rate * cycle_s / 3600 / cav + lab + sec) / (1 - scrap / 100) / (1 - margin / 100)

#### Extended price

**Key:** ext

**Type:** number

**Format:** currency

**Expr:** qty * (part_g * (1 + flash / 100) / 1000 * cost_kg + rate * cycle_s / 3600 / cav + lab + sec) / (1 - scrap / 100) / (1 - margin / 100)

**Rows:**

**Part:** GSK-2210

**Compound:** NBR 70

**Qty:** 25000

**Part g:** 12

**Flash:** 10

**Cost kg:** 4.8

**Cycle s:** 210

**Cav:** 16

**Rate:** 55

**Lab:** 0.012

**Sec:** 0.02

**Scrap:** 3

**Margin:** 25

**Part:** SEAL-5532

**Compound:** FKM 75

**Qty:** 5000

**Part g:** 4.5

**Flash:** 15

**Cost kg:** 38

**Cycle s:** 260

**Cav:** 24

**Rate:** 55

**Lab:** 0.02

**Sec:** 0.06

**Scrap:** 5

**Margin:** 30

**Part:** GRM-0417

**Compound:** EPDM 70

**Qty:** 40000

**Part g:** 18

**Flash:** 8

**Cost kg:** 4.1

**Cycle s:** 190

**Cav:** 12

**Rate:** 50

**Lab:** 0.015

**Sec:** 0.015

**Scrap:** 2.5

**Margin:** 22

**Part:** DIAPH-7781

**Compound:** VMQ 60

**Qty:** 8000

**Part g:** 31

**Flash:** 12

**Cost kg:** 14.5

**Cycle s:** 300

**Cav:** 8

**Rate:** 60

**Lab:** 0.05

**Sec:** 0.18

**Scrap:** 6

**Margin:** 28

**Part:** BUSH-3306

**Compound:** NR 50

**Qty:** 12000

**Part g:** 85

**Flash:** 7

**Cost kg:** 3.6

**Cycle s:** 420

**Cav:** 4

**Rate:** 50

**Lab:** 0.09

**Sec:** 0.12

**Scrap:** 4

**Margin:** 24

**Totals:**

#### Total pieces

**Key:** qty

**Agg:** sum

**Format:** integer

#### Total quoted value

**Key:** ext

**Agg:** sum

**Format:** currency

**Summary:**

#### Average selling price per piece

**Key:** avg_price

**Expr:** sum_ext / sum_qty

**Format:** currency

**Primary:** true

#### Quote lines

**Key:** lines

**Expr:** count

**Format:** integer

**Notes:** 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.

## Content

**Intro:** 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.

**Sections:**

#### How to use it

**Body:** 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.

**Bullets:**

- 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

**Body:** 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

**Body:** 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

**Body:** 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.

**Cta:** 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.

**Faq:**

#### Is margin the same as markup?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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.

## Search terms

rubber part quote worksheet, rubber molding quote template excel, rubber part cost estimate spreadsheet, molded rubber quote calculator, rubber product pricing sheet, rubber part costing excel, compression molding quote worksheet, rubber seal quotation spreadsheet

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json