# Stamping Quote Breakdown Worksheet (Excel)

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

## Short answer

An editable worksheet that builds unit cost and price for several stamped parts at once, with annual revenue totals.

## Category

cost-finance

## Industry

Metal Stamping

## Audience

- Estimator
- Sales engineer
- Controller

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Part number

**Key:** part

**Type:** text

#### Process

**Key:** op

**Type:** select

**Options:**

- Progressive die
- Transfer die
- Single-hit blanking
- Deep draw

#### Annual volume

**Key:** vol

**Type:** number

**Format:** integer

#### Gross lb per part

**Key:** gross_lb

**Type:** number

**Format:** decimal

**Help:** From strip layout, including scrap.

#### Coil $/lb

**Key:** price_lb

**Type:** number

**Format:** decimal

#### Good parts/hr

**Key:** pph

**Type:** number

**Format:** integer

#### Press rate $/hr

**Key:** rate

**Type:** number

**Format:** decimal

#### Secondary $/pc

**Key:** second

**Type:** number

**Format:** decimal

#### Margin %

**Key:** margin

**Type:** number

**Format:** number

#### Material $/pc

**Key:** mat_cost

**Type:** number

**Expr:** gross_lb * price_lb

**Format:** decimal

#### Press $/pc

**Key:** press_cost

**Type:** number

**Expr:** rate / pph

**Format:** decimal

#### Unit cost $/pc

**Key:** unit_cost

**Type:** number

**Expr:** gross_lb * price_lb + rate / pph + second

**Format:** decimal

#### Unit price $/pc

**Key:** unit_price

**Type:** number

**Expr:** (gross_lb * price_lb + rate / pph + second) / (1 - margin / 100)

**Format:** decimal

#### Annual revenue

**Key:** rev

**Type:** number

**Expr:** vol * (gross_lb * price_lb + rate / pph + second) / (1 - margin / 100)

**Format:** currency

#### Annual gross profit

**Key:** gp

**Type:** number

**Expr:** vol * ((gross_lb * price_lb + rate / pph + second) / (1 - margin / 100) - (gross_lb * price_lb + rate / pph + second))

**Format:** currency

**Rows:**

**Part:** BRK-2041

**Op:** Progressive die

**Vol:** 120000

**Gross lb:** 0.074

**Price lb:** 0.55

**Pph:** 2880

**Rate:** 95

**Second:** 0.04

**Margin:** 18

**Part:** CLP-1187

**Op:** Progressive die

**Vol:** 250000

**Gross lb:** 0.021

**Price lb:** 0.62

**Pph:** 6000

**Rate:** 110

**Second:** 0.015

**Margin:** 16

**Part:** HSG-3302

**Op:** Deep draw

**Vol:** 40000

**Gross lb:** 0.31

**Price lb:** 0.78

**Pph:** 900

**Rate:** 120

**Second:** 0.22

**Margin:** 22

**Part:** PLT-0915

**Op:** Single-hit blanking

**Vol:** 60000

**Gross lb:** 0.18

**Price lb:** 0.55

**Pph:** 1500

**Rate:** 75

**Second:** 0.03

**Margin:** 20

**Part:** TRM-7720

**Op:** Transfer die

**Vol:** 90000

**Gross lb:** 0.13

**Price lb:** 1.9

**Pph:** 1800

**Rate:** 130

**Second:** 0.09

**Margin:** 19

**Totals:**

#### Total annual revenue

**Key:** rev

**Agg:** sum

**Format:** currency

#### Total annual gross profit

**Key:** gp

**Agg:** sum

**Format:** currency

#### Total pieces per year

**Key:** vol

**Agg:** sum

**Format:** integer

**Summary:**

#### Blended gross margin

**Key:** blended_margin

**Expr:** sum_gp / sum_rev * 100

**Format:** percent

**Primary:** true

**Description:** Gross profit divided by revenue across all parts.

#### Average selling price per piece

**Key:** avg_price

**Expr:** sum_rev / sum_vol

**Format:** currency

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

## Content

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

**Sections:**

#### How to use it

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

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

**Bullets:**

- 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

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

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

**Faq:**

#### How is the unit price calculated?

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

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

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

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

## Search terms

stamping quote template excel, stamping cost breakdown, metal stamping quote worksheet, stamping estimating spreadsheet, piece price breakdown, quote cost roll up stamping, stamping price per part excel, estimator worksheet metal stamping

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