# Secondary Operations Cost Worksheet for Turned Parts

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

## Short answer

Add each secondary operation with setup, per-piece price and vendor minimum charge to get the extended cost, cost per part and total lead time.

## Category

cost-finance

## Industry

Precision Machining

## Audience

- Estimator
- Buyer
- Production planner

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Operation

**Key:** op

**Type:** text

#### Source

**Key:** source

**Type:** select

**Options:**

- In-house
- Outside vendor

#### Specification or note

**Key:** spec

**Type:** text

#### Lot qty

**Key:** lot_qty

**Type:** number

#### Setup or tooling charge

**Key:** setup

**Type:** number

**Format:** currency

#### Price per piece

**Key:** per_pc

**Type:** number

**Format:** currency

#### Minimum lot charge

**Key:** min_chg

**Type:** number

**Format:** currency

#### Lead time (days)

**Key:** lead

**Type:** number

**Format:** integer

#### Extended cost

**Key:** ext

**Type:** number

**Expr:** max(min_chg, setup + per_pc * lot_qty)

**Format:** currency

#### Cost per part

**Key:** pp

**Type:** number

**Expr:** ext / lot_qty

**Format:** currency

**Rows:**

**Op:** Tumble deburr

**Source:** In-house

**Spec:** Ceramic media, 45 min

**Lot qty:** 2500

**Setup:** 25

**Per pc:** 0.015

**Min chg:** 0

**Lead:** 1

**Op:** Passivation

**Source:** Outside vendor

**Spec:** ASTM A967 citric, 303 stainless

**Lot qty:** 2500

**Setup:** 0

**Per pc:** 0.045

**Min chg:** 125

**Lead:** 5

**Op:** Heat treat

**Source:** Outside vendor

**Spec:** Harden and temper, 4140

**Lot qty:** 2500

**Setup:** 0

**Per pc:** 0.11

**Min chg:** 150

**Lead:** 7

**Op:** Zinc plating clear

**Source:** Outside vendor

**Spec:** ASTM B633 Fe/Zn 8

**Lot qty:** 2500

**Setup:** 40

**Per pc:** 0.06

**Min chg:** 175

**Lead:** 6

**Op:** Laser mark

**Source:** In-house

**Spec:** Part number and lot code

**Lot qty:** 2500

**Setup:** 60

**Per pc:** 0.03

**Min chg:** 0

**Lead:** 1

**Op:** Final inspect and pack

**Source:** In-house

**Spec:** Sample plus visual, bagged

**Lot qty:** 2500

**Setup:** 30

**Per pc:** 0.02

**Min chg:** 0

**Lead:** 1

**Totals:**

#### Total secondary cost for the lot

**Key:** ext

**Agg:** sum

**Format:** currency

#### Total cost per part

**Key:** pp

**Agg:** sum

**Format:** currency

#### Longest single lead time

**Key:** lead

**Agg:** max

**Format:** integer

**Summary:**

#### Average cost per operation

**Key:** avg_op

**Expr:** sum_ext / count

**Format:** currency

#### Lead time if run in series (days)

**Key:** serial_days

**Expr:** sum_lead

**Format:** integer

**Description:** Worst case, when each step waits for the one before.

**Notes:** Extended cost is the larger of the minimum lot charge and setup plus price per piece times lot quantity. Example prices are illustrative only, replace them with real vendor quotes. Check the process specification, class and grade required on the drawing before quoting.

## Content

**Intro:** Secondary operations often decide whether a turned part makes money. Deburring, passivation, plating, heat treat and marking each add a setup, a per-piece price and a vendor minimum. This worksheet adds them up row by row.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per operation in routing order. Mark each as in-house or outside vendor and note the specification, for example the plating standard or passivation method. Enter the lot quantity, any setup or fixture charge, the per-piece price and the vendor minimum charge. Extended cost and cost per part calculate automatically, and the totals give the full secondary cost for the lot, per part, and the lead time. Export to Excel to attach it to the quote file.

**Bullets:**

- Keep rows in the order the part will travel.
- Enter the vendor minimum even when it does not apply at today's quantity.
- Include shipping to and from outside vendors in the price per piece.

#### The cost logic

**Body:** Each row computes the larger of the minimum lot charge and setup plus price per piece times quantity. The minimum matters on small lots: a 100-piece plating run billed at a 175 dollar minimum costs 1.75 per piece even when the vendor's piece price is pennies. Cost per part is the extended cost divided by the lot size. The total per part is a simple sum, since secondary operations run one after another on the same lot.

#### Lead time

**Body:** The worksheet shows both the longest single lead time and the serial sum. Outside processing is usually the long pole, and each trip adds transit, queue and process time. If operations must run in sequence, such as heat treat before plating, the serial figure is the realistic one. Consider asking a vendor to consolidate steps, for example passivation after the final wash, to shorten the chain.

#### Common mistakes

**Body:** Quoting piece price without the vendor minimum is the usual source of loss on short runs. Another is ignoring scrap and rework from the secondary step, such as plating rejects or heat treat distortion that needs regrinding. In an ERP, outside processing should be a routing operation with a purchased service item so cost, lead time and receipts flow into the job. If not, the cost shows up as unexplained variance.

**Cta:** If secondary operations are costed here but run in your ERP another way, Netray can help compare estimated and actual outside processing cost by job.

**Faq:**

#### Why does the minimum charge matter?

**Answer:** Platers, heat treaters and finishers bill a minimum per lot because their process has fixed handling and bath or furnace costs. On small lots the minimum, not the piece price, sets your cost, so a quote that ignores it loses money.

#### Should in-house operations use the same columns?

**Answer:** Yes. Treat setup as the setup time costed at the work center rate, price per piece as run time costed at the rate, and leave the minimum at zero. This keeps all operations comparable on one sheet.

#### How do I handle different lot quantities per operation?

**Answer:** Each row has its own lot quantity, so an operation can run on a different quantity. For example, a sample inspection step may use a smaller quantity. Cost per part still divides by that row's quantity.

#### Are the example prices real?

**Answer:** No. They are illustrative placeholders to show how the sheet works. Replace them with current quotes from your vendors and your internal rates.

## Search terms

secondary operations cost turned parts, outside processing cost worksheet, deburring passivation plating cost per part, machining quote worksheet excel, vendor minimum charge per lot, heat treat plating cost estimate, secondary ops routing cost, outside processing lead time

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