How do you calculate sheet utilization?

Divide the finished part area shipped by the sheet area purchased for the job. 360 sq ft of parts from 480 sq ft is 75%, 10 points under an 85% target; with 60 sq ft of usable remnant, 60 sq ft is left outside parts and remnants, the Sheet Utilization calculator's own example.

Do remnants count towards utilization?

No. A remnant keeps its material value in stock but has not become a shipped part, so it is shown separately. Count it towards utilization only when it is cut into parts on a later job.

What is the area outside parts and remnants?

Sheet area minus part area minus remnant area: the skeleton, kerf, rejected parts and any stock not recorded. A large share on one job points to the nest, the run size or a remnant that was not measured.

What utilization target should I set?

One by material and thickness from your own completed jobs; nests of small parts in thin sheet reach higher than heavy plate. The example targets are invented for a fictional shop.

Is this a nesting efficiency estimate?

No. It uses recorded areas from completed jobs. A proposed nest needs cutting clearances, lead-ins and handling checked in your nesting software.

Does the workbook use macros?

No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test jobs and shows Self-check: PASS.

Manufacturing Cost and Quoting

Sheet Utilization Log Excel Template

Sheet utilization = finished part area shipped ÷ sheet area purchased for the job. Log every job and see its utilization against the material's target, and the rest of the sheet split into usable remnants back in stock and the area outside parts and remnants (skeleton, kerf, rejects), valued at the sheet cost.

Free, and a plain .xlsx with no macros to enable. A CSV with live formulas and a printed how-to guide come with it.

Overview

This sheet utilization template is a working Excel workbook for laser, plasma, waterjet and punch shop managers, nesting programmers, estimators and cost accountants. Each job is one row with its material, the purchased sheet area allocated to it, the finished part area shipped and the measured reusable remnant area returned to stock; each material's cost per square foot and target utilization come from Setup. The workbook gives the utilization against target with a status in words, the unshipped area, the area outside parts and remnants, and the cost of that area and the book value of the remnants at the sheet cost. It totals every material over its jobs. It ships with ten jobs in four materials at a fictional cutting shop, so every tile and chart is filled in when you open it.

In the example a 10 gauge mild steel job shipped 360 sq ft of parts from 480 purchased: 75%, 10 points under its 85% target. 60 sq ft came back as a remnant and 60 sq ft left as skeleton and kerf, 252.00 at 4.20 a square foot. A short stainless run with no fill parts reached only 73.8%, while a common-line nest on the same mild steel made 86.4%. Across the ten jobs the shop shipped 82.6% of what it bought and 505 sq ft left as skeleton, kerf and rejects, worth 3,611.10.

Utilization counts only shipped part area; remnants keep their value but are not parts. The download is a plain .xlsx with no macros. A CSV with live formulas is also included for other tools; the dashboard, charts, dropdowns and self-check are in the .xlsx.

What this template includes

Setup sheet with your shop, currency and near band, and the materials with their cost per square foot and target utilization
Jobs table, one row per job: date, material, sheet area purchased, part area shipped and usable remnant area, with a Check column
Per job: utilization, gap to target in points, a status in words, unshipped area, area outside parts and remnants, its cost, and the remnant at sheet cost
Dashboard with four tiles (sheet utilization, area outside parts and remnants, its cost, jobs below target), utilization by material against target, where each job's sheet went, and the job and material tables
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference and the Sheet Utilization calculator (Self-check: PASS)
CSV with live formulas for the Jobs table; the dashboard, charts, dropdowns and self-check are in the .xlsx

Suggested use case

Use it for a weekly nesting review, to set utilization standards for quoting by material, or to check that remnants are being measured and put back in stock.

How to use it

On Setup, type your shop, currency and near band, and list your materials with their cost per square foot and target utilization.
On Jobs, give each job a row: date, material, sheet area purchased, part area shipped and usable remnant area.
Fix anything the Check column names.
Open the Dashboard: utilization against target by material, and where every job's sheet went.

Frequently Asked Questions

How do you calculate sheet utilization?: Divide the finished part area shipped by the sheet area purchased for the job. 360 sq ft of parts from 480 sq ft is 75%, 10 points under an 85% target; with 60 sq ft of usable remnant, 60 sq ft is left outside parts and remnants, the Sheet Utilization calculator's own example.
Do remnants count towards utilization?: No. A remnant keeps its material value in stock but has not become a shipped part, so it is shown separately. Count it towards utilization only when it is cut into parts on a later job.
What is the area outside parts and remnants?: Sheet area minus part area minus remnant area: the skeleton, kerf, rejected parts and any stock not recorded. A large share on one job points to the nest, the run size or a remnant that was not measured.
What utilization target should I set?: One by material and thickness from your own completed jobs; nests of small parts in thin sheet reach higher than heavy plate. The example targets are invented for a fictional shop.
Is this a nesting efficiency estimate?: No. It uses recorded areas from completed jobs. A proposed nest needs cutting clearances, lead-ins and handling checked in your nesting software.
Does the workbook use macros?: No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test jobs and shows Self-check: PASS.