# Should Cost Model Worksheet for Machined Parts

> Source: https://netray.co/tools/should-cost-model-worksheet-for-machined-parts
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Build a bottom-up should cost for a machined part from material, machine time, setup, finish and overhead to test a supplier quote.

## Category

cost-finance

## Industry

Discrete Manufacturing

## Audience

- Buyer
- Cost engineer
- Sourcing manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Cost element

**Key:** element

**Type:** text

#### Group

**Key:** group

**Type:** select

**Options:**

- Material
- Machining
- Setup
- Finishing
- Inspection
- Tooling
- Overhead
- Other

#### Cost driver

**Key:** driver

**Type:** text

#### Quantity per piece

**Key:** quantity

**Type:** number

**Help:** Kg, hours or units consumed per finished piece

#### Rate per unit

**Key:** unit_cost

**Type:** number

**Format:** currency

#### Allowance %

**Key:** allowance

**Type:** number

**Help:** Scrap, yield loss or contingency

#### Cost per piece

**Key:** ext

**Type:** number

**Expr:** quantity * unit_cost * (1 + allowance / 100)

**Format:** currency

**Rows:**

**Element:** 6061-T651 plate

**Group:** Material

**Driver:** Kg of stock per piece

**Quantity:** 1.8

**Unit cost:** 5.2

**Allowance:** 8

**Ext:** 0

**Element:** CNC milling cycle

**Group:** Machining

**Driver:** Machine hours at shop rate

**Quantity:** 0.42

**Unit cost:** 78

**Allowance:** 0

**Ext:** 0

**Element:** Setup amortized

**Group:** Setup

**Driver:** Setup hours / lot size

**Quantity:** 0.04

**Unit cost:** 85

**Allowance:** 0

**Ext:** 0

**Element:** Deburr and clean

**Group:** Finishing

**Driver:** Labor hours

**Quantity:** 0.12

**Unit cost:** 38

**Allowance:** 0

**Ext:** 0

**Element:** Anodize Type II

**Group:** Finishing

**Driver:** Outside process per piece

**Quantity:** 1

**Unit cost:** 4.5

**Allowance:** 3

**Ext:** 0

**Element:** In-process and final inspection

**Group:** Inspection

**Driver:** Inspection hours

**Quantity:** 0.1

**Unit cost:** 52

**Allowance:** 0

**Ext:** 0

**Element:** Cutting tools and inserts

**Group:** Tooling

**Driver:** Tool cost per piece

**Quantity:** 1

**Unit cost:** 1.35

**Allowance:** 0

**Ext:** 0

**Totals:**

#### Should cost per piece (before SG&A and profit)

**Key:** ext

**Agg:** sum

**Format:** currency

**Summary:**

#### SG&A at 10%

**Key:** sga

**Expr:** sum_ext * 0.10

**Format:** currency

#### Profit at 12%

**Key:** profit

**Expr:** (sum_ext + sga) * 0.12

**Format:** currency

#### Should cost price per piece

**Key:** target

**Expr:** sum_ext + sga + profit

**Format:** currency

**Primary:** true

**Description:** Cost plus SG&A and profit. Compare this to the supplier quote at the same quantity.

**Notes:** Divide setup hours by lot size before entering the quantity, for example 2 setup hours on a 50 piece lot is 0.04 hours per piece. Replace the SG&A and profit percentages in the summary logic with your own assumptions by editing the rates in the rows or applying the markup in Excel after export.

## Content

**Intro:** A should cost model builds a part's price from the ground up, so you can negotiate from facts instead of a quote. This worksheet breaks a machined part into material, machine time, setup, finishing, inspection and tooling, adds overhead and profit, and exports to Excel.

**Sections:**

#### How to use the should cost worksheet

**Body:** List each cost element in a row. For material, enter kilograms of stock needed per piece, including the bar or plate you cut it from, and the price per kilogram. For machining, enter the cycle time in hours and the shop rate. For setup, divide total setup hours by the lot size. Add finishing, inspection and tooling. Use the allowance column for scrap and yield loss. The worksheet multiplies quantity by rate and by one plus the allowance, then totals the rows. Edit, add or delete rows to match your part, and export the result to Excel or PDF to share with the team.

#### The method behind a should cost

**Body:** Should cost is a bottom-up estimate. You start from the raw material weight and market price, add the process time on each machine at a realistic rate, add outside processes, then layer on overhead, SG&A and a fair margin. The logic is the same used in cost engineering teams. The aim is not to prove a supplier wrong to the cent. The aim is to find which cost lines are out of proportion so the negotiation focuses on them. Material and cycle time are usually the largest drivers for milled parts, and they are the easiest to verify.

**Bullets:**

- Material: stock weight, not finished weight
- Machine rates: use a market rate for the machine class
- Setup: amortize over the real lot size
- Margin: typical job shop margins are in the low double digits

#### Reading the result

**Body:** Compare the should cost price to the supplier quote at the same quantity. A gap of a few percent is normal noise. A gap of 20 percent or more means either you missed a cost, such as a secondary operation, or the supplier has padding in one line. Ask for a breakdown by group and compare group by group. If the machining line is far above yours, question the cycle time. If material is high, question stock size and scrap. Keep the model, because the same part at a different quantity only needs the setup and tooling lines updated.

#### Common mistakes

**Body:** Using finished part weight for material instead of stock weight understates cost, often by half for plate and bar. Using a machine rate that excludes labor, or one that includes full overhead twice, distorts the total. Ignoring setup on small lots is another common error. Finally, do not treat the model as exact. It is a negotiation tool, and its value comes from showing where the supplier's number is unusual, not from matching it perfectly.

**Cta:** If your part costs, routings and standard rates live in your ERP, Netray can help pull them into a should cost view so the model starts from your own data.

**Faq:**

#### What is a should cost model?

**Answer:** A should cost model is a bottom-up estimate of what a part ought to cost, built from material, labor, machine time, overhead and margin. Buyers use it to challenge quotes, find cost drivers, and negotiate with facts instead of relying only on competing bids.

#### How accurate does a should cost need to be?

**Answer:** It does not need to be exact. Being within roughly 10 percent is useful. The goal is to see which lines in a quote are out of proportion, not to match the supplier cent for cent. Refine the biggest cost lines first.

#### What machine rate should I use?

**Answer:** Use a market rate for the machine class, for example a three-axis mill versus a five-axis center, and confirm whether it includes labor and overhead. If you have no data, ask two or three shops for their hourly rates and use the middle value.

#### How do I handle setup cost?

**Answer:** Estimate total setup hours for a run, multiply by the setup rate, and divide by the lot size to get setup per piece. Because setup is fixed per run, it falls as quantity rises, which is why quantity breaks matter in quotes.

## Search terms

should cost model template, should cost analysis excel, should cost worksheet, cost breakdown machined part, bottom up cost model manufacturing, price teardown template, cnc part cost estimate spreadsheet, should cost vs quote

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