# Converting Job Quote Cost Build-Up Worksheet

> Source: https://netray.co/tools/converting-job-quote-cost-build-up-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Build a converting quote operation by operation: setup hours, run speed, machine rate and material cost roll up into total cost and cost per thousand.

## Category

cost-finance

## Industry

Packaging & Converting

## Audience

- Estimator
- Sales engineer
- Plant controller

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Operation

**Key:** op

**Type:** select

**Options:**

- Prepress / plates
- Printing
- Lamination
- Die cutting
- Slitting / rewinding
- Folder gluing
- Bag making
- Inspection / packing
- Other

#### Notes

**Key:** desc

**Type:** text

#### Setup hours

**Key:** setup_hr

**Type:** number

**Unit:** hr

#### Run quantity

**Key:** qty

**Type:** number

**Unit:** units

**Help:** Units for this operation, such as sheets, feet or labels.

#### Run speed

**Key:** speed

**Type:** number

**Unit:** units/hr

#### Machine plus labor rate

**Key:** rate

**Type:** number

**Format:** currency

**Unit:** $/hr

#### Material and outside cost

**Key:** material

**Type:** number

**Format:** currency

**Unit:** $

#### Run hours

**Key:** run_hr

**Type:** number

**Expr:** qty / speed

**Format:** decimal

#### Total hours

**Key:** hours

**Type:** number

**Expr:** setup_hr + qty / speed

**Format:** decimal

#### Operation cost

**Key:** cost

**Type:** number

**Expr:** (setup_hr + qty / speed) * rate + material

**Format:** currency

**Rows:**

**Op:** Prepress / plates

**Desc:** Plates and proof

**Setup hr:** 1.5

**Qty:** 0

**Speed:** 1

**Rate:** 85

**Material:** 420

**Op:** Printing

**Desc:** 4 color flexo on 28 in web

**Setup hr:** 2.5

**Qty:** 30000

**Speed:** 6000

**Rate:** 165

**Material:** 3150

**Op:** Lamination

**Desc:** Gloss varnish plus matte film

**Setup hr:** 0.75

**Qty:** 30000

**Speed:** 9000

**Rate:** 95

**Material:** 640

**Op:** Die cutting

**Desc:** Rotary die, 16 up

**Setup hr:** 1.25

**Qty:** 30000

**Speed:** 7500

**Rate:** 110

**Material:** 380

**Op:** Slitting / rewinding

**Desc:** Final rolls

**Setup hr:** 0.5

**Qty:** 30000

**Speed:** 12000

**Rate:** 70

**Material:** 0

**Op:** Inspection / packing

**Desc:** Cartons and pallet wrap

**Setup hr:** 0.25

**Qty:** 30000

**Speed:** 15000

**Rate:** 48

**Material:** 210

**Totals:**

#### Total hours

**Key:** hours

**Agg:** sum

**Format:** decimal

#### Material and outside cost

**Key:** material

**Agg:** sum

**Format:** currency

#### Total cost

**Key:** cost

**Agg:** sum

**Format:** currency

**Summary:**

#### Cost per 1,000 finished units

**Key:** cost_per_m

**Expr:** sum_cost / max_qty * 1000

**Format:** currency

**Primary:** true

**Description:** Divides total cost by the largest run quantity, which should be finished units.

#### Price at 30 percent margin

**Key:** price_30

**Expr:** sum_cost / (1 - 0.3)

**Format:** currency

#### Price per 1,000 at 30 percent margin

**Key:** price_30_m

**Expr:** price_30 / max_qty * 1000

**Format:** currency

#### Average cost per press hour

**Key:** cost_per_hr

**Expr:** sum_cost / max(sum_hours, 0.01)

**Format:** currency

**Notes:** Enter the finished quantity as the largest run quantity so cost per thousand is right. A speed of 1 with quantity 0 gives a pure setup row. Machine rates should come from your own burdened cost per hour. Margin shown is a gross margin on price, not markup.

## Content

**Intro:** A good converting quote is built operation by operation, not from a blended rate. This worksheet lets you list each step, its setup hours, run speed, hourly rate and materials, then rolls it up to total cost, cost per thousand and a price at a chosen margin.

**Sections:**

#### How to use it

**Body:** Start from the routing: prepress, printing, lamination, die cutting, slitting or gluing, inspection and packing. For each, enter setup hours, the run quantity in that operation's units, the run speed in units per hour and your burdened rate per hour. Add materials and outside services in the last input column. Hours and cost compute per row, and the totals update. Add rows for anything else, such as outside finishing or freight, and delete the ones that do not apply.

#### The method behind the numbers

**Body:** Operation cost equals setup hours plus run quantity divided by speed, multiplied by the rate, plus material. Gross margin price equals cost divided by one minus the margin fraction. This differs from markup: a 30 percent markup on cost is only a 23 percent margin. Use the same method for every quote so that pricing differences come from the job and not from the estimator.

#### Worked example

**Body:** The default rows describe a 30,000 unit job. Printing adds 2.5 setup hours plus 5 run hours at 165 dollars per hour, plus 3,150 dollars of film and ink. The rest of the routing adds smaller operations. The summary shows the total cost, cost per thousand and a price per thousand at 30 percent gross margin. Change one speed or setup and watch how much of the price moves.

#### Common mistakes

**Body:** Typical errors include quoting run speed from machine spec sheets rather than achieved speed, leaving out waste in the material line, ignoring that short runs are dominated by setup, and using a single rate for every machine. Review actual speeds from the shop floor regularly, and keep a separate waste line for printing and die cutting.

**Bullets:**

- Use achieved speeds, not nameplate speeds
- Add waste to material quantities before pricing
- Quote price breaks by changing quantity and keeping setup fixed

**Cta:** If your estimators rebuild this routing from memory every time, we can connect routings, rates and achieved speeds in your ERP to a quoting assistant that runs on your own servers.

**Faq:**

#### How do I handle waste in this worksheet?

**Answer:** Increase the run quantity of each operation by the expected waste, or add a material line that includes it. For example, printing 30,000 good units at 5 percent waste means running 31,500 units. Keep waste lines visible so you can improve them.

#### What machine rate should I use?

**Answer:** Use your burdened cost per hour: labor, depreciation, power, maintenance, space and overhead allocated to that machine. Do not use selling price per hour. Your controller or standard cost roll-up usually holds the right figure.

#### Why is the margin different from markup?

**Answer:** Margin is profit divided by price, markup is profit divided by cost. A 30 percent gross margin requires dividing cost by 0.70, a markup of about 43 percent. The worksheet uses margin.

#### Can I quote price breaks?

**Answer:** Yes. Copy the worksheet, change quantities, and keep setup hours fixed. The cost per thousand falls as setup is spread over more units. Compare the results to build a price break table.

## Search terms

converting job quote worksheet, packaging quote excel template, label converting estimate spreadsheet, operation based job costing template, print and converting cost build up, setup and run time estimate worksheet, carton job costing excel, packaging estimating template

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