# Print Job Estimate Worksheet

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

## Short answer

Itemise a print job from prepress to delivery, add markup per line, and see total cost, selling price and gross margin.

## Category

cost-finance

## Industry

Packaging and Printing

## Audience

- Estimator
- Print shop owner
- Sales manager
- Plant manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Cost item

**Key:** item

**Type:** text

#### Category

**Key:** category

**Type:** select

**Options:**

- Prepress
- Plates
- Paper
- Ink
- Press time
- Finishing
- Packing
- Freight
- Outside service

#### Quantity

**Key:** qty

**Type:** number

#### Rate

**Key:** rate

**Type:** number

**Format:** currency

**Help:** Cost per unit: per sheet, kg, plate or hour.

#### Markup %

**Key:** markup

**Type:** number

**Unit:** %

#### Cost

**Key:** cost

**Type:** number

**Expr:** qty * rate

**Format:** currency

#### Selling price

**Key:** price

**Type:** number

**Expr:** qty * rate * (1 + markup / 100)

**Format:** currency

**Rows:**

**Item:** Artwork and file prep

**Category:** Prepress

**Qty:** 1

**Rate:** 85

**Markup:** 25

**Item:** CTP plates, 4 colour

**Category:** Plates

**Qty:** 4

**Rate:** 22

**Markup:** 25

**Item:** 150 gsm silk, 5,500 sheets

**Category:** Paper

**Qty:** 5500

**Rate:** 0.06

**Markup:** 20

**Item:** Process ink

**Category:** Ink

**Qty:** 4

**Rate:** 14

**Markup:** 25

**Item:** Press time incl. makeready

**Category:** Press time

**Qty:** 2.5

**Rate:** 140

**Markup:** 25

**Item:** Fold and trim

**Category:** Finishing

**Qty:** 2

**Rate:** 60

**Markup:** 30

**Item:** Carton and delivery

**Category:** Freight

**Qty:** 1

**Rate:** 90

**Markup:** 10

**Totals:**

#### Total cost

**Key:** cost

**Agg:** sum

**Format:** currency

#### Total selling price

**Key:** price

**Agg:** sum

**Format:** currency

**Summary:**

#### Gross profit

**Key:** profit

**Expr:** sum_price - sum_cost

**Format:** currency

**Primary:** true

#### Gross margin

**Key:** margin

**Expr:** if(gt(sum_price, 0), (sum_price - sum_cost) / sum_price * 100, 0)

**Format:** percent

**Primary:** true

**Notes:** Set the markup per line to reflect risk and your pricing policy. Divide the total price by run quantity to get a price per piece, and add spoilage to paper quantity before you quote.

## Content

**Intro:** A good print estimate lists every cost between artwork and delivery, then adds markup so the quote protects margin. This worksheet gives estimators a repeatable layout for sheetfed, web or flexo jobs that exports straight to Excel.

**Sections:**

#### How to use the worksheet

**Body:** Add a row for each cost item and pick its category. Enter quantity and rate in the unit that applies, such as plates, sheets, kilograms or hours, and set a markup percentage. Cost is quantity times rate. Selling price adds the markup. Totals and gross margin appear underneath. Replace the example rows with your own and keep the template as a starting point for every quote. Add spoilage to paper quantity before you enter it.

**Bullets:**

- Paper: add makeready and running spoilage sheets
- Press time: include makeready, not only running time
- Plates: one per colour per side unless reused
- Finishing: fold, die cut, laminate, bind

#### What a print estimate normally includes

**Body:** Most print jobs break into prepress, plates or cylinders, substrate, ink, press time, finishing, packing and delivery. Outside services such as foil or embossing add another line. Estimators calculate press time from impressions, speed and makeready, and paper from sheets including spoilage. Ink follows coverage. Some shops price per thousand with run-length breaks, which you can reproduce by copying the sheet for each quantity. This sheet does not replace a print MIS but is the check most estimators build in Excel.

#### Reading margin and markup

**Body:** Markup is added to cost, margin is measured against price. A 25 percent markup on cost is a 20 percent margin on price. The sheet shows the real gross margin so you can compare it to your target. A high markup on press time with a low markup on bought-in paper is common because paper has pass-through risk. If gross margin is below your floor, look at spoilage, makeready and outside services first, because they are the lines estimators often undercount.

#### Common mistakes and ERP notes

**Body:** The usual errors are ignoring makeready, not adding spoilage, missing finishing speeds, forgetting freight, and quoting without a cost-per-piece check. In an ERP, a print job maps to a routing with operations for prepress, press and finishing, and a bill of materials for paper and ink. Compare your actual job cost to the estimate after each job, and feed the variance back into the rates in this sheet.

**Bullets:**

- Include makeready and spoilage
- Record actual versus estimate per job
- Keep hourly rates current by press
- Add outside services and freight

**Cta:** If estimate versus actual job cost is hard to compare in your ERP, we can build an agent that reads job costing data and summarises variances. Ask for a short review.

**Faq:**

#### How do I estimate the cost of a print job?

**Answer:** List every cost: prepress, plates, paper with spoilage, ink, press time including makeready, finishing, packing and delivery. Add the lines for total cost, then apply markup or a target margin to reach the selling price.

#### What is the difference between markup and margin?

**Answer:** Markup is the percentage added to cost. Margin is profit as a percentage of price. A 25 percent markup gives a 20 percent margin. Quoting on margin target needs price equal to cost divided by one minus margin.

#### How much paper spoilage should I add?

**Answer:** Spoilage depends on press, colour count and finishing. Offset jobs commonly need a few percent plus makeready sheets per colour, and finishing operations add more. Use your press log history rather than a flat guess.

#### Can I get a price per thousand?

**Answer:** Yes. Divide total selling price by the run quantity and multiply by 1,000. Repeat the sheet for different run lengths because makeready is fixed, which makes longer runs cheaper per piece.

## Search terms

print job estimate template, printing estimate worksheet excel, print quote calculator, printing job costing sheet, print estimating spreadsheet, how to estimate a print job, print job cost breakdown, commercial printing estimate form

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