# Casting Scrap by Defect Pareto Worksheet

> Source: https://netray.co/tools/casting-scrap-by-defect-pareto-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Record scrap by defect type with quantity and unit cost, and see the cost and average value per scrapped casting.

## Category

quality

## Industry

Foundry

## Audience

- Foundry quality manager
- Process engineer
- Plant manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Defect

**Key:** defect

**Type:** select

**Options:**

- Gas porosity
- Shrinkage
- Sand inclusion
- Cold shut
- Misrun
- Crack
- Core shift
- Mold break
- Dimensional
- Surface finish

#### Where found

**Key:** area

**Type:** select

**Options:**

- Shakeout
- Cleaning room
- Machining
- Pressure test
- Customer

#### Pieces scrapped

**Key:** qty

**Type:** number

#### Cost per piece

**Key:** unit_cost

**Type:** number

**Format:** currency

**Help:** Cost incurred up to the point of scrap

#### Scrap cost

**Key:** cost

**Type:** number

**Expr:** qty * unit_cost

**Format:** currency

#### Week ending

**Key:** week

**Type:** date

**Rows:**

**Defect:** Shrinkage

**Area:** Machining

**Qty:** 14

**Unit cost:** 38.5

**Week:** 2026-10-09

**Defect:** Gas porosity

**Area:** Cleaning room

**Qty:** 22

**Unit cost:** 12.75

**Week:** 2026-10-09

**Defect:** Sand inclusion

**Area:** Shakeout

**Qty:** 31

**Unit cost:** 6.2

**Week:** 2026-10-09

**Defect:** Core shift

**Area:** Machining

**Qty:** 6

**Unit cost:** 41

**Week:** 2026-10-16

**Defect:** Misrun

**Area:** Shakeout

**Qty:** 17

**Unit cost:** 5.9

**Week:** 2026-10-16

**Totals:**

#### Total pieces scrapped

**Key:** qty

**Agg:** sum

**Format:** integer

#### Total scrap cost

**Key:** cost

**Agg:** sum

**Format:** currency

**Summary:**

#### Average cost per scrapped piece

**Key:** avg_cost

**Expr:** sum_cost / sum_qty

**Format:** currency

**Notes:** Sort the exported sheet by scrap cost, highest first. Count alone misleads: a few late machining rejects can cost more than many early shakeout rejects.

## Content

**Intro:** Foundries rarely lack scrap data, they lack scrap data in cost terms. This worksheet turns defect counts into dollars so that the Pareto reflects money, not just piece counts.

**Sections:**

#### How to use this worksheet

**Body:** Add a row per defect, per place found and per week. Enter pieces scrapped and the cost carried by one piece at that point in the route. Scrap cost calculates automatically and totals update. Export to Excel and sort by cost, then chart the top three or four causes. The vital few typically carry most of the loss.

#### Why cost, not just count

**Body:** A casting scrapped at shakeout has only melt and mold cost in it. The same casting scrapped after machining carries labor, tooling and overhead. Two defects with equal counts can differ in cost several times over. Using cost per piece at the point of discovery ranks defects by what they cost you, and it shows the value of finding defects earlier, for example with radiography or pressure checks before machining.

#### Reading the results

**Body:** Average cost per scrapped piece rises when late stage defects dominate, even when total scrap count is flat. Use that figure with the share by defect to choose projects. Shrinkage and gas porosity usually point to gating, risering, venting or moisture. Sand inclusions and core shift point to molding and core setting. Track results week by week to verify that an action worked.

#### Common mistakes

**Body:** Mixing rework with scrap, using standard cost for every stage, and lumping unlike defects under 'other' all weaken the analysis. Keep defect names consistent between shifts and with your ERP scrap reason codes so data from the floor and from the system match.

**Cta:** If your scrap reason codes sit in an ERP, Netray can help pull them into a defect cost view on your own servers.

**Faq:**

#### What cost should I use per piece?

**Answer:** Use the accumulated cost at the stage where the piece was scrapped, such as melt and molding at shakeout, or including machining after the cut. A consistent rule matters more than perfect precision.

#### Is this a true Pareto chart?

**Answer:** It gives you the data. Export to Excel, sort by cost descending and add a cumulative percent column and chart if you want the classic bar and line view.

#### Should rework be included?

**Answer:** Track rework separately or in its own rows with a clear label, so scrap totals are not inflated. Rework cost can be significant and deserves its own analysis.

#### How often should I update it?

**Answer:** Weekly works for most foundries, daily for high volume lines. The point is catching a trend before a full lot is affected.

## Search terms

foundry scrap log excel, casting scrap tracking sheet, casting defect pareto, foundry scrap analysis template, casting rejection log, scrap cost by defect, foundry quality report excel, casting yield loss worksheet

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