Sign Shop: Material Waste Percent

All versions

A 4x8 sheet costs the same whether you get three signs out of it or six. Waste percent is the number that tells you whether your nesting is any good.

Quick formula: Unused area over total area:

=(PRODUCT(B2,C2)-PRODUCT(D2,E2)*F2)/PRODUCT(B2,C2)

Three 24x36 signs out of a 48x96 sheet uses 2,592 of 4,608 square inches — 43.75% waste.

Functions used (tap for the full reference guide):

PRODUCT

The example

Three cut plans, all from a standard 48 x 96 inch sheet.

	A	B	C	D	E	F	G
1	Job	Sheet W	Sheet H	Sign W	Sign H	Qty	Waste %
2	Yard signs	48	96	24	36	3	43.75%
3	Panel set	48	96	24	48	4	0.00%
4	A-frames	48	96	18	24	8	25.00%

The formula

Two areas and one subtraction:

=(PRODUCT(B2,C2)-PRODUCT(D2,E2)*F2)/PRODUCT(B2,C2) // (sheet area - used area) / sheet area

How it works

Work in square inches throughout and the units cancel:

PRODUCT(B2,C2) is the sheet area — 48 x 96 is 4,608 square inches.
PRODUCT(D2,E2)*F2 is the area you used: one sign's area times how many you nested on the sheet.
Subtracting gives the offcut area, and dividing by the sheet area turns it into a percentage.
Format the cell as a percent so 0.4375 reads as 43.75%.

Four 24x48 panels tile a 48x96 sheet perfectly — zero waste. That is the benchmark every other cut plan gets measured against.

Try it: interactive demo

Interactive

Enter the sheet size, the sign size, and how many fit.

Sheet width (in)

Sheet height (in)

Sign width (in)

Sign height (in)

Signs per sheet

Variations

Cost of the waste

Turn the percentage into dollars you can see on the job sheet.

=G2*H2

Yield instead of waste

Some shops prefer to track the good half.

=1-G2

Pitfalls & errors

The formula does not know whether the signs physically fit. Nine 24x36 signs mathematically use less than two sheets, but they will not nest that way — check the layout before trusting the percent.

Leave a margin for the cutter's grip and blade kerf. Reduce the usable sheet dimensions by an inch or so rather than pretending you cut edge to edge.

Practice workbook

📊

Download the free Sign Shop: Material Waste Percent practice workbook

Edit the yellow sheet, sign, and quantity cells; waste % recalculates.

Frequently asked questions

What is an acceptable waste percent?

It depends entirely on the sign size. Sizes that tile the sheet run near zero; odd custom sizes routinely hit 30 to 40%. Track it per job type rather than chasing one target.

Should offcuts count as waste if I keep them?

Add a Reusable column and subtract that area before dividing. Only the pieces genuinely too small to use belong in the waste figure.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Function references: PRODUCT