# Additive Manufacturing Job Costing Worksheet (Excel Export)

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

## Short answer

Row-by-row costing of build jobs with machine hours, powder, labor and outside processing, calculating cost per part and totals.

## Category

cost-finance

## Industry

Additive Manufacturing

## Audience

- Cost estimator
- Quoting engineer
- Production controller

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Job / part

**Key:** job

**Type:** text

#### Process

**Key:** process

**Type:** select

**Options:**

- PBF-LB
- PBF-EB
- Binder jet
- DED
- MIM
- PM press and sinter

#### Qty in job

**Key:** qty

**Type:** number

#### Machine hours (job)

**Key:** build_hr

**Type:** number

**Unit:** hr

#### Machine rate

**Key:** rate

**Type:** number

**Format:** currency

**Unit:** $/hr

#### Material consumed (job)

**Key:** mat_kg

**Type:** number

**Unit:** kg

#### Material price

**Key:** mat_price

**Type:** number

**Format:** currency

**Unit:** $/kg

#### Post-process labor (job)

**Key:** post_hr

**Type:** number

**Unit:** hr

#### Labor rate

**Key:** post_rate

**Type:** number

**Format:** currency

**Unit:** $/hr

#### Outside processing (job)

**Key:** outside

**Type:** number

**Format:** currency

**Help:** HIP, heat treat, plating, NDT sent out.

#### Machine cost

**Key:** machine

**Type:** number

**Expr:** build_hr * rate

**Format:** currency

#### Material cost

**Key:** material

**Type:** number

**Expr:** mat_kg * mat_price

**Format:** currency

#### Post-process cost

**Key:** post

**Type:** number

**Expr:** post_hr * post_rate + outside

**Format:** currency

#### Job total

**Key:** total

**Type:** number

**Expr:** build_hr * rate + mat_kg * mat_price + post_hr * post_rate + outside

**Format:** currency

#### Cost per part

**Key:** per_part

**Type:** number

**Expr:** (build_hr * rate + mat_kg * mat_price + post_hr * post_rate + outside) / max(qty, 1)

**Format:** currency

**Rows:**

**Job:** Bracket, 17-4 PH

**Process:** PBF-LB

**Qty:** 24

**Build hr:** 38

**Rate:** 48

**Mat kg:** 6.2

**Mat price:** 60

**Post hr:** 14

**Post rate:** 62

**Outside:** 640

**Job:** Manifold, AlSi10Mg

**Process:** PBF-LB

**Qty:** 6

**Build hr:** 52

**Rate:** 48

**Mat kg:** 4.1

**Mat price:** 45

**Post hr:** 22

**Post rate:** 62

**Outside:** 410

**Job:** Housing, Ti-6Al-4V

**Process:** PBF-LB

**Qty:** 8

**Build hr:** 61

**Rate:** 55

**Mat kg:** 3.4

**Mat price:** 190

**Post hr:** 18

**Post rate:** 62

**Outside:** 1250

**Job:** Gear blank, 4605

**Process:** PM press and sinter

**Qty:** 5000

**Build hr:** 9

**Rate:** 120

**Mat kg:** 410

**Mat price:** 2.1

**Post hr:** 6

**Post rate:** 48

**Outside:** 300

**Job:** Latch, 316L

**Process:** MIM

**Qty:** 20000

**Build hr:** 30

**Rate:** 95

**Mat kg:** 160

**Mat price:** 18

**Post hr:** 40

**Post rate:** 48

**Outside:** 900

**Totals:**

#### Total parts

**Key:** qty

**Agg:** sum

**Format:** integer

#### Total machine cost

**Key:** machine

**Agg:** sum

**Format:** currency

#### Total material cost

**Key:** material

**Agg:** sum

**Format:** currency

#### Total post-process cost

**Key:** post

**Agg:** sum

**Format:** currency

#### Total job cost

**Key:** total

**Agg:** sum

**Format:** currency

**Summary:**

#### Machine share of cost

**Key:** machine_share

**Expr:** sum_machine / max(sum_total, 1) * 100

**Format:** percent

#### Material share of cost

**Key:** material_share

**Expr:** sum_material / max(sum_total, 1) * 100

**Format:** percent

#### Post-process share of cost

**Key:** post_share

**Expr:** sum_post / max(sum_total, 1) * 100

**Format:** percent

#### Average cost per part across jobs

**Key:** avg_part

**Expr:** sum_total / max(sum_qty, 1)

**Format:** currency

**Primary:** true

**Notes:** Machine hours, material and post-process hours are for the whole job, not per part. Cost per part divides the job total by quantity. Example rows are illustrative, not benchmarks.

## Content

**Intro:** This worksheet costs additive and powder metallurgy jobs the way an estimator builds a quote: machine hours, material, post-process labor and outside processing, rolled into a job total and a cost per part. Edit the example rows, add your own, and export to Excel.

**Sections:**

#### How to use it

**Body:** Add one row per job or part. Enter quantity and the whole-job inputs: machine hours, the burdened machine rate, material consumed in kilograms and its price, post-process labor hours and rate, and any outside processing such as HIP or heat treat. Machine, material, post-process and job-total columns calculate on each row, and cost per part divides by quantity. The summary shows the cost mix across all jobs, so you can see where the money goes.

**Bullets:**

- Use job-level hours and kilograms, then let the sheet divide by quantity.
- Include supports and non-recycled powder in material consumed.
- Put sent-out heat treat, HIP, NDT and plating in outside processing.

#### The costing method

**Body:** Machine cost = machine hours x rate. Material cost = kilograms consumed x price per kilogram. Post-process cost = labor hours x labor rate + outside processing. Job total is the sum of the three, and cost per part is job total divided by quantity. The cost-mix summary divides each category by the grand total. This direct-cost structure maps cleanly onto a standard cost rollup, where machine hours become a routing operation and material becomes a bill of materials line.

#### Using the cost mix

**Body:** A high machine share points to nesting and build-rate improvements. A high material share points to alloy choice, powder reuse and support minimization. A high post-process share, common for thin, small or tight-tolerance parts, points to design for post-processing: fewer supports, machining stock only where needed, and batching heat treat. Compare the mix between processes. Press-and-sinter and MIM jobs carry low per-part post-process but need tooling, which this sheet does not amortize.

#### Common mistakes

**Body:** Entering per-part values in job-level columns inflates or deflates cost by the quantity. Forgetting scrap is another: apply a yield factor by adding hours and material for reprints. Tooling for MIM and PM is a separate one-time cost that should be added to the outside column or quoted as non-recurring engineering. Finally, use rates from the same period; machine rates drift with utilization, so update them quarterly.

**Cta:** If these costs should come from live job data rather than a spreadsheet, we can map machine hours and material lots into your ERP job costing.

**Faq:**

#### How do I handle scrap or failed builds?

**Answer:** Estimate your first-pass yield and add the extra machine hours and material for the failed share to the job, or divide the job total by yield. Track actual failures to refine the assumption over time.

#### Can I use it for MIM and press-and-sinter?

**Answer:** Yes, choose the process and enter furnace or press hours, powder or feedstock kilograms and post-process labor. Add tooling as a one-time cost in outside processing or as a separate line, since it is not recurring per job.

#### What machine rate should I enter?

**Answer:** Divide annual machine cost (depreciation, service, gas, filters, floor space and operator share) by realistic available hours. Use actual utilized hours, not 8,760, or the rate will be too low.

#### How do I export it?

**Answer:** Use the export buttons to download the worksheet as Excel, CSV or PDF. Computed columns export as values, so keep the web version if you want to continue editing with formulas.

## Search terms

additive manufacturing job costing excel, 3d printing quote spreadsheet, am job cost template, metal am quote worksheet, 3d printing cost breakdown template, additive manufacturing costing spreadsheet, build job cost tracking, mim job quote worksheet

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