# Corrugated Board Sheet Usage and Trim Waste Worksheet

> Source: https://netray.co/tools/corrugated-board-sheet-usage-and-trim-waste-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable order list that computes how many blanks fit on each board sheet, trim waste percent and board cost per box.

## Category

supply-chain

## Industry

Packaging and Printing

## Audience

- Corrugated planner
- Estimator
- Purchasing manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Order / item

**Key:** order

**Type:** text

#### Board grade

**Key:** grade

**Type:** select

**Options:**

- B flute 32 ECT
- C flute 32 ECT
- C flute 44 ECT
- BC double wall

#### Blank length (mm)

**Key:** blank_l

**Type:** number

**Format:** integer

#### Blank width (mm)

**Key:** blank_w

**Type:** number

**Format:** integer

#### Sheet length (mm)

**Key:** sheet_l

**Type:** number

**Format:** integer

#### Sheet width (mm)

**Key:** sheet_w

**Type:** number

**Format:** integer

#### Board price per m2

**Key:** price_m2

**Type:** number

**Format:** currency

#### Boxes required

**Key:** qty

**Type:** number

**Format:** integer

#### Blanks per sheet

**Key:** ups

**Type:** number

**Expr:** floor(sheet_l / blank_l) * floor(sheet_w / blank_w)

**Format:** integer

#### Trim waste %

**Key:** waste

**Type:** number

**Expr:** (1 - (floor(sheet_l / blank_l) * floor(sheet_w / blank_w) * blank_l * blank_w) / (sheet_l * sheet_w)) * 100

**Format:** percent

#### Board cost per box

**Key:** box_cost

**Type:** number

**Expr:** sheet_l * sheet_w / 1000000 * price_m2 / (floor(sheet_l / blank_l) * floor(sheet_w / blank_w))

**Format:** currency

#### Sheets needed

**Key:** sheets

**Type:** number

**Expr:** ceil(qty / (floor(sheet_l / blank_l) * floor(sheet_w / blank_w)))

**Format:** integer

**Rows:**

**Order:** RSC 400x300x250

**Grade:** C flute 32 ECT

**Blank l:** 1470

**Blank w:** 560

**Sheet l:** 2500

**Sheet w:** 1700

**Price m2:** 0.62

**Qty:** 5000

**Order:** RSC 300x200x200

**Grade:** B flute 32 ECT

**Blank l:** 1050

**Blank w:** 410

**Sheet l:** 2100

**Sheet w:** 1650

**Price m2:** 0.58

**Qty:** 12000

**Order:** Heavy duty 500x400x400

**Grade:** BC double wall

**Blank l:** 1850

**Blank w:** 840

**Sheet l:** 2500

**Sheet w:** 1700

**Price m2:** 1.05

**Qty:** 1500

**Order:** Shipper 350x250x150

**Grade:** C flute 44 ECT

**Blank l:** 1250

**Blank w:** 410

**Sheet l:** 2500

**Sheet w:** 1650

**Price m2:** 0.7

**Qty:** 8000

**Totals:**

#### Total sheets

**Key:** sheets

**Agg:** sum

**Format:** integer

#### Average trim waste

**Key:** waste

**Agg:** avg

**Format:** percent

#### Average board cost per box

**Key:** box_cost

**Agg:** avg

**Format:** currency

**Summary:**

#### Total sheets across orders

**Key:** sheet_total

**Expr:** sum_sheets

**Format:** integer

**Notes:** Layout is a simple grid with no rotation, so it understates yield when rotating the blank would fit more. Slotting and scoring losses between blanks are ignored. Prices are examples; use your board supplier's price list.

## Content

**Intro:** On corrugated work, board is usually the largest cost in the box, and trim waste silently raises it. This worksheet shows how many blanks fit on each sheet, the waste left over and the board cost per box for each order.

**Sections:**

#### How to use the worksheet

**Body:** Enter the blank size from your design, the sheet size you can buy or run, the board price per square metre and the quantity required. The sheet computes blanks per sheet, trim waste, board cost per box and sheets needed. Try changing the sheet width in a row and watch the waste change; that is how planners pick the best trim.

#### The method

**Body:** Blanks per sheet equals the number that fit along the length times the number that fit across the width, each rounded down. Trim waste equals one minus blanks times blank area divided by sheet area. Board cost per box is sheet area times price per m2 divided by blanks per sheet. Sheets needed is quantity divided by blanks per sheet, rounded up.

**Bullets:**

- Rotate the blank by swapping length and width to test a better fit
- Add a spoilage allowance to the quantity for setup and rejects
- Cost uses board only, not printing, die cutting or freight

#### Common mistakes

**Body:** The most common errors are mixing flute direction with sheet direction, which matters for box compression because flutes should run vertically, and forgetting that a sheet wider than the corrugator's trim width cannot run. Also remember that small differences in blank size, even 10 mm, can drop one up and double the waste.

**Cta:** If your estimators rebuild this layout in Excel for every quote, we can help connect board grades, prices and sizes to your ERP costing.

**Faq:**

#### What is a typical trim waste for corrugated boxes?

**Answer:** It varies with box size and available sheet widths. Many plants aim for single digit percent on the corrugator by selecting deckle widths well. Small or odd blanks can exceed that, so compare options per order.

#### Does this account for flute direction?

**Answer:** No. You must decide which blank dimension runs with the flutes and enter it accordingly. For most boxes the flutes run along the box height, so check that your length and width assignment honours that.

#### Why does the cost per box differ from my quote?

**Answer:** This is board material cost only. Quotes usually add conversion, printing, tooling, waste allowances, freight and margin. Use this value as the material line in your own quote.

#### Can I use it for folding cartons?

**Answer:** Yes for simple grid layouts. For folding cartons, nesting and tuck-in layouts can fit more than a grid, so treat the result as a conservative estimate.

## Search terms

corrugated trim waste worksheet, board usage calculator excel, corrugated sheet ups, box blank layout waste, corrugated board cost per box, trim loss corrugated, carton blank per sheet, corrugator trim planning

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