# Converting Line Roll Waste Reconciliation Worksheet

> Source: https://netray.co/tools/converting-line-roll-waste-reconciliation-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Reconcile input footage against good output, makeready, trim and rejects per job, and see unaccounted loss, yield percent and the dollar cost of waste.

## Category

mes-shop-floor

## Industry

Packaging & Converting

## Audience

- Production supervisor
- Plant controller
- Continuous improvement lead

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Job number

**Key:** job

**Type:** text

#### Line

**Key:** line

**Type:** select

**Options:**

- Press 1
- Press 2
- Laminator
- Die cutter
- Slitter
- Bag machine

#### Input footage

**Key:** input_lf

**Type:** number

**Unit:** ft

#### Good output footage

**Key:** good_lf

**Type:** number

**Unit:** ft

#### Makeready waste

**Key:** makeready_lf

**Type:** number

**Unit:** ft

#### Trim and matrix equivalent

**Key:** trim_lf

**Type:** number

**Unit:** ft

**Help:** Convert matrix and edge trim into equivalent full-width footage.

#### Rejected in-process

**Key:** reject_lf

**Type:** number

**Unit:** ft

#### Material cost per foot

**Key:** cost_lf

**Type:** number

**Format:** currency

**Unit:** $/ft

#### Unaccounted loss

**Key:** unaccounted

**Type:** number

**Expr:** input_lf - good_lf - makeready_lf - trim_lf - reject_lf

**Format:** number

**Unit:** ft

#### Yield

**Key:** yield_pct

**Type:** number

**Expr:** good_lf / input_lf * 100

**Format:** percent

#### Waste cost

**Key:** waste_cost

**Type:** number

**Expr:** (input_lf - good_lf) * cost_lf

**Format:** currency

**Rows:**

**Job:** J-24101

**Line:** Press 1

**Input lf:** 9200

**Good lf:** 8450

**Makeready lf:** 420

**Trim lf:** 180

**Reject lf:** 95

**Cost lf:** 0.62

**Job:** J-24102

**Line:** Press 2

**Input lf:** 15400

**Good lf:** 14100

**Makeready lf:** 650

**Trim lf:** 380

**Reject lf:** 210

**Cost lf:** 0.48

**Job:** J-24103

**Line:** Laminator

**Input lf:** 6800

**Good lf:** 6490

**Makeready lf:** 150

**Trim lf:** 90

**Reject lf:** 40

**Cost lf:** 0.71

**Job:** J-24104

**Line:** Die cutter

**Input lf:** 11800

**Good lf:** 10750

**Makeready lf:** 380

**Trim lf:** 520

**Reject lf:** 110

**Cost lf:** 0.55

**Job:** J-24105

**Line:** Slitter

**Input lf:** 20000

**Good lf:** 19350

**Makeready lf:** 120

**Trim lf:** 450

**Reject lf:** 30

**Cost lf:** 0.34

**Totals:**

#### Total input footage

**Key:** input_lf

**Agg:** sum

**Format:** number

#### Total good footage

**Key:** good_lf

**Agg:** sum

**Format:** number

#### Total unaccounted loss

**Key:** unaccounted

**Agg:** sum

**Format:** number

#### Total waste cost

**Key:** waste_cost

**Agg:** sum

**Format:** currency

**Summary:**

#### Overall yield

**Key:** overall_yield

**Expr:** sum_good_lf / sum_input_lf * 100

**Format:** percent

**Primary:** true

#### Unaccounted loss as percent of input

**Key:** unacc_pct

**Expr:** sum_unaccounted / sum_input_lf * 100

**Format:** percent

#### Average waste cost per job

**Key:** avg_cost

**Expr:** sum_waste_cost / max(count, 1)

**Format:** currency

**Notes:** Count footage consistently, either full-width footage or area equivalents, across all lines. A growing unaccounted figure usually means unrecorded rejects, rewind losses or counter errors, not magic. Review it weekly by line and by job type.

## Content

**Intro:** Waste is the largest controllable cost in converting, but most plants only see it as a single yield number. This worksheet reconciles each job's input footage against good output and the known waste buckets, and shows what is left unaccounted.

**Sections:**

#### How to use it

**Body:** Log one row per job per line. Enter the footage issued to the job, the good footage produced, and the footage lost to makeready, trim or matrix, and in-process rejects. Add the material cost per foot, using full-width material cost. The unaccounted loss, yield percent and waste cost compute per row, and the totals and overall yield summarize the period. Use the same unit across lines so rows can be compared.

#### The reconciliation logic

**Body:** Input footage must equal good output plus every named loss. Whatever remains is unaccounted loss, and it is the number to chase: it points to unrecorded reject, counter error, rewind scrap, sampling or inventory transfer. Yield equals good over input. Waste cost multiplies total waste footage by material cost per foot, so a wide expensive web shows more cost for the same footage as a narrow cheap one.

#### Reading the example

**Body:** In the sample data, makeready dominates the waste on presses, trim dominates on the die cutter and slitter, and the laminator shows the least. The overall yield is the weighted average, not the average of row yields. A job with a good yield but a high unaccounted number is a data-quality problem, not a success. Sort by waste cost to find the jobs worth a root-cause review.

#### Common mistakes

**Body:** Plants often log waste in different units across presses, hide rejects in good output until final inspection, or reconcile only at month end when nobody remembers what happened. Count at the end of each job, record rejects when they are found, and do not subtract unaccounted loss into makeready.

**Bullets:**

- Use one unit across all lines
- Record rejects at the time of discovery
- Review unaccounted loss weekly, not monthly

**Cta:** If this reconciliation lives in spreadsheets because job transactions in your ERP or MES do not carry footage, we can help design a read-only extract and an on-prem assistant to answer waste questions.

**Faq:**

#### What counts as makeready waste?

**Answer:** Material consumed from the start of setup until the first sellable output: web threading, color matching, registration and die-cut adjustment. Some plants also include wash-up and plate change. Pick a definition and keep it consistent.

#### What is a healthy unaccounted loss?

**Answer:** Close to zero. Small positive values are normal from counter and measurement differences. A large or growing value means that waste is not being recorded or that counters are off, and it deserves investigation.

#### Should yield be measured in area or footage?

**Answer:** Area is best when widths differ. Footage works when you compare jobs on the same line and web width. If you mix widths, convert everything to area equivalents before logging.

#### How do I treat matrix waste?

**Answer:** Convert it to an equivalent full-width footage, or log it as a separate trim number in feet. The matrix percent from a layout calculator times the good footage gives a quick estimate.

## Search terms

converting waste reconciliation, makeready waste tracking, roll yield tracking worksheet, press waste log excel, converting yield variance, material reconciliation worksheet, label press waste log, waste cost per job

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