# Custom Seal Quote Estimator Worksheet

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

## Short answer

Build a line-by-line quote for custom seals with material, machine time, setup amortisation, scrap and margin, and see unit price, extended price and blended margin.

## Category

cost-finance

## Industry

Fluid Power and Sealing

## Audience

- Estimator
- Sales engineer
- Cost accountant

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Seal / part

**Key:** item

**Type:** text

#### Material

**Key:** mat

**Type:** select

**Options:**

- NBR 70
- FKM 75
- EPDM 70
- Silicone 60
- PTFE virgin
- PTFE glass filled
- Polyurethane 90A

#### Quantity

**Key:** qty

**Type:** number

**Format:** integer

#### Material cost / pc

**Key:** mat_cost

**Type:** number

**Format:** currency

**Help:** Raw stock or compound cost per piece, before scrap.

#### Machine/press min / pc

**Key:** mach_min

**Type:** number

**Format:** decimal

#### Rate / hr

**Key:** rate

**Type:** number

**Format:** currency

#### Setup + tooling

**Key:** setup

**Type:** number

**Format:** currency

**Help:** One-time cost spread over the lot quantity.

#### Scrap %

**Key:** scrap

**Type:** number

**Format:** percent

#### Unit cost

**Key:** unit_cost

**Type:** number

**Expr:** (mat_cost + mach_min / 60 * rate) * (1 + scrap / 100) + setup / qty

**Format:** currency

#### Target margin %

**Key:** margin

**Type:** number

**Format:** percent

#### Unit price

**Key:** unit_price

**Type:** number

**Expr:** unit_cost / (1 - margin / 100)

**Format:** currency

#### Extended cost

**Key:** cost_ext

**Type:** number

**Expr:** unit_cost * qty

**Format:** currency

#### Extended price

**Key:** ext

**Type:** number

**Expr:** unit_price * qty

**Format:** currency

**Rows:**

**Item:** O-ring 2-210 FKM 75 (lot)

**Mat:** FKM 75

**Qty:** 2000

**Mat cost:** 0.18

**Mach min:** 0.35

**Rate:** 85

**Setup:** 150

**Scrap:** 3

**Margin:** 35

**Item:** PTFE rod seal, 40 mm, spring energised

**Mat:** PTFE glass filled

**Qty:** 250

**Mat cost:** 2.4

**Mach min:** 6

**Rate:** 95

**Setup:** 220

**Scrap:** 6

**Margin:** 40

**Item:** Custom molded gasket, 6 in

**Mat:** EPDM 70

**Qty:** 1000

**Mat cost:** 0.62

**Mach min:** 0.9

**Rate:** 70

**Setup:** 1800

**Scrap:** 4

**Margin:** 38

**Item:** Turned PTFE backup ring

**Mat:** PTFE virgin

**Qty:** 800

**Mat cost:** 0.55

**Mach min:** 1.8

**Rate:** 95

**Setup:** 120

**Scrap:** 5

**Margin:** 42

**Item:** Polyurethane wiper, 50 mm

**Mat:** Polyurethane 90A

**Qty:** 500

**Mat cost:** 1.15

**Mach min:** 2.2

**Rate:** 90

**Setup:** 300

**Scrap:** 5

**Margin:** 36

**Totals:**

#### Total pieces

**Key:** qty

**Agg:** sum

**Format:** integer

#### Total cost

**Key:** cost_ext

**Agg:** sum

**Format:** currency

#### Total quote value

**Key:** ext

**Agg:** sum

**Format:** currency

**Summary:**

#### Gross margin on quote

**Key:** gm

**Expr:** sum_ext - sum_cost_ext

**Format:** currency

#### Blended gross margin

**Key:** gm_pct

**Expr:** gm / sum_ext * 100

**Format:** percent

#### Average price per piece

**Key:** avg_price

**Expr:** sum_ext / sum_qty

**Format:** currency

**Notes:** Unit cost = (material + machine minutes / 60 x rate) x (1 + scrap) + setup / quantity. Unit price = unit cost / (1 - margin), so margin is on price, not on cost. Replace the example rates and costs with your own burdened rates; these values are illustrative.

## Content

**Intro:** Custom seals are quoted on small lots where tooling and setup swing the unit price. This worksheet rolls material, machine time, scrap, setup and margin into unit and extended price for each line and shows the blended margin for the whole quote.

**Sections:**

#### How to use it

**Body:** Add one row per seal or part. Enter the quantity, material cost per piece, machine or press minutes per piece, the burdened hourly rate, one-time setup or tooling, scrap percentage and the target margin. The worksheet calculates unit cost, unit price and extended totals, and the summary shows blended gross margin and average price per piece. Change quantity on a row to see how setup amortisation moves the price.

**Bullets:**

- Use a fully burdened machine rate that includes labor, overhead and depreciation.
- Enter tooling as one-time cost and let the quantity amortise it.
- Duplicate a row at different quantities to build a price-break table.

#### The costing logic

**Body:** Unit cost = (material + machine minutes / 60 x rate) x (1 + scrap%) + setup / quantity. Scrap is applied to variable cost so yield loss is paid for by the part that survives. Setup and tooling are divided by the lot so small runs carry more. Price is cost divided by (1 minus margin), which gives a true margin on price; adding a percentage markup to cost gives a lower margin than people expect. For example a 35 percent markup on cost is only a 26 percent margin.

#### Reading the output

**Body:** Look at the lines with the lowest margin after setup. Short runs of machined PTFE or lip seals are usually dominated by machine time, while molded elastomer jobs are dominated by tooling and compound cost. Blended margin is weighted by extended price, so one large low-margin line can pull the total down even when the rest look healthy. Use the price per piece at several quantities as the basis for a break table.

#### Common mistakes

**Body:** The usual errors are leaving out setup on repeat orders, ignoring scrap on expensive filled PTFE stock, and using a standard rate that omits inspection and secondary operations such as trimming, post-cure, cleaning and packaging. Add those as extra rows or fold them into the machine minutes. Also check material price validity dates; compound and PTFE resin prices move, and a quote stale by a quarter can erase the margin.

**Cta:** If your estimators rebuild these quotes by hand from ERP item and routing data, we can show how a private quoting assistant fills the same columns from your own history without exposing it outside your network.

**Faq:**

#### How do you calculate unit cost for a custom seal?

**Answer:** Add material cost to machine or press minutes divided by 60 times the hourly rate, apply the scrap percentage, then add one-time setup or tooling divided by the order quantity. That gives unit cost before margin.

#### What is the difference between margin and markup?

**Answer:** Margin is profit as a percentage of price, markup is profit as a percentage of cost. A 35 percent markup gives a 25.9 percent margin. This worksheet takes margin and divides cost by one minus margin, so the entered margin is what you earn on price.

#### How should I handle tooling for molded seals?

**Answer:** Enter mould or tooling cost as one-time setup on the first quote and let it spread over the quantity. For repeat orders where the customer has paid for the tool, set tooling to zero and include only the per-lot setup. Quote tooling separately if policy requires.

#### Can I export the quote?

**Answer:** Yes. The worksheet exports to Excel, CSV and PDF with the calculated unit price, extended price and totals, so you can paste it into a formal quotation or load it into your ERP quote screen.

## Search terms

custom seal quote template, o-ring quote worksheet, seal manufacturing cost estimate, gasket quote estimator excel, rubber molded parts quote calculator, seal unit price calculator, machined seal quote, custom seal pricing spreadsheet

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