# Plating Job Quote and Pricing Worksheet

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

## Short answer

Quote multiple plating or anodize line items with computed metal cost, labor, setup, margin and unit price, then export to Excel.

## Category

cost-finance

## Industry

Metal Finishing

## Audience

- Estimator
- Plating shop owner
- Sales engineer

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Part number

**Key:** part

**Type:** text

#### Process

**Key:** process

**Type:** select

**Options:**

- Zinc clear
- Zinc yellow
- Electroless nickel
- Bright nickel
- Acid copper
- Tin matte
- Type II anodize
- Type III hard coat

#### Quantity

**Key:** qty

**Type:** number

#### Area per part (dm2)

**Key:** area

**Type:** number

#### Thickness (um)

**Key:** thk

**Type:** number

#### Deposit density (g/cm3)

**Key:** dens

**Type:** number

#### Metal price ($/kg)

**Key:** price

**Type:** number

**Format:** currency

#### Handling and process labor (min/part)

**Key:** hmin

**Type:** number

#### Loaded rate ($/h)

**Key:** rate

**Type:** number

**Format:** currency

#### Setup and masking ($)

**Key:** setup

**Type:** number

**Format:** currency

#### Metal cost

**Key:** metal

**Type:** number

**Expr:** qty * area * thk * dens / 100 / 1000 * price

**Format:** currency

#### Labor and line cost

**Key:** labor

**Type:** number

**Expr:** qty * hmin / 60 * rate

**Format:** currency

#### Total cost

**Key:** cost

**Type:** number

**Expr:** setup + metal + labor

**Format:** currency

#### Margin (%)

**Key:** margin

**Type:** number

#### Quoted price

**Key:** quote

**Type:** number

**Expr:** cost * (1 + margin / 100)

**Format:** currency

#### Price each

**Key:** each

**Type:** number

**Expr:** quote / qty

**Format:** currency

**Rows:**

**Part:** BRK-1001

**Process:** Zinc yellow

**Qty:** 5000

**Area:** 0.18

**Thk:** 8

**Dens:** 7.14

**Price:** 3.5

**Hmin:** 0.05

**Rate:** 85

**Setup:** 120

**Margin:** 30

**Part:** FIT-2210

**Process:** Bright nickel

**Qty:** 1200

**Area:** 0.35

**Thk:** 15

**Dens:** 8.9

**Price:** 18

**Hmin:** 0.12

**Rate:** 85

**Setup:** 150

**Margin:** 35

**Part:** CNT-3305

**Process:** Acid copper

**Qty:** 800

**Area:** 0.22

**Thk:** 10

**Dens:** 8.96

**Price:** 9.5

**Hmin:** 0.1

**Rate:** 85

**Setup:** 100

**Margin:** 30

**Part:** HSG-4412

**Process:** Type II anodize

**Qty:** 300

**Area:** 2.4

**Thk:** 18

**Dens:** 3.2

**Price:** 0

**Hmin:** 0.6

**Rate:** 95

**Setup:** 200

**Margin:** 40

**Part:** SHF-5120

**Process:** Electroless nickel

**Qty:** 150

**Area:** 1.1

**Thk:** 25

**Dens:** 8

**Price:** 22

**Hmin:** 0.9

**Rate:** 95

**Setup:** 250

**Margin:** 40

**Totals:**

#### Total pieces

**Key:** qty

**Agg:** sum

**Format:** integer

#### Total metal cost

**Key:** metal

**Agg:** sum

**Format:** currency

#### Total labor and line cost

**Key:** labor

**Agg:** sum

**Format:** currency

#### Total quoted price

**Key:** quote

**Agg:** sum

**Format:** currency

**Summary:**

#### Blended price per piece

**Key:** blend

**Expr:** sum_quote / sum_qty

**Format:** currency

**Primary:** true

#### Gross profit on quote

**Key:** gp

**Expr:** sum_quote - sum_cost

**Format:** currency

#### Gross margin on price

**Key:** gpm

**Expr:** (sum_quote - sum_cost) / sum_quote * 100

**Format:** percent

**Notes:** Metal cost is deposited mass only: add dragout, anode and chemistry utilization by raising the metal price or the margin. For anodize set metal price to zero and put chemical and energy costs into the loaded rate. Minimum lot charges and rack tooling are not modeled, so add them to Setup. Use the area estimator and Faraday calculator to fill area and thickness.

## Content

**Intro:** Plating shops lose money when quotes are built from per-piece guesses. This worksheet builds each line from metal weight, labor minutes and setup, adds margin and gives a price each, plus totals and blended margin across the quote.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per part and process. Enter quantity, area in square decimeters, thickness in micrometers, deposit density and metal price. Add handling and line minutes per part, a loaded hourly rate, any setup or masking charge and your target margin. The sheet computes metal cost, labor, total cost, quoted price and price each. The summary shows blended price per piece and gross margin on the whole quote. Export it to Excel to send or iterate.

**Bullets:**

- Start from the part surface area estimator for area
- Use the Faraday calculator for time and thickness checks
- Put minimum lot charges into setup
- Raise metal price to include dragout losses

#### How the cost columns work

**Body:** Metal cost is quantity x area x thickness x density / 100 grams, converted to kilograms and priced. Labor and line cost is quantity x minutes per part / 60 x loaded rate. Total cost is setup plus metal plus labor. Quoted price is cost x (1 + margin / 100), and the price each is that divided by quantity. This is markup on cost; the summary also reports gross margin on price, which is always lower than the markup.

#### Pricing context

**Body:** Precious metals such as gold and silver make metal the dominant cost, so price changes should flow through quickly, ideally with a metal surcharge clause. For zinc and nickel work labor and line time dominate. Anodize has no deposited metal, so rate and time drive cost. Check that small lots recover setup and that minimum charges apply, since many plating quotes lose money on short runs.

#### Common mistakes

**Body:** The usual errors are pricing by area alone, ignoring minimum thickness that forces longer plating, and not loading rework into margin. Another is quoting markup as if it were margin; a 30 percent markup yields only about a 23 percent margin. Review actual job cost against the quote regularly to recalibrate minutes per part.

**Cta:** If you want quotes generated from drawings, routings and past job costs held in your ERP, we can help set up a private quoting assistant that stays on your own servers.

**Faq:**

#### How do I price plating per piece?

**Answer:** Add metal cost, labor and line time per piece, divide setup by lot size, then apply your margin. This worksheet does that for each line and reports price each along with total and blended price.

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

**Answer:** Markup is added to cost. Margin is the share of the price that is profit. A 30 percent markup on cost gives a gross margin of about 23 percent of price. The summary shows margin on price.

#### How do I include precious metal losses?

**Answer:** Raise the metal price to reflect drag-out and anode utilization, or add a separate line for metal recovery. Many shops also use a metal surcharge tied to market price.

#### Can I export this to Excel?

**Answer:** Yes. Every worksheet exports to Excel, PDF or CSV with the computed columns and totals preserved, so you can send the quote or continue editing in a spreadsheet.

## Search terms

plating quote template, plating job pricing worksheet, metal finishing quote excel, plating estimate template, anodizing quote template, plating price per piece calculation, job shop plating quoting

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