# Forging Job Quote Cost Breakdown Worksheet

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

## Short answer

Fill in each operation of a forging job with setup hours, run minutes, rates and outside cost, and get total cost, cost per piece and price at several margins.

## Category

cost-finance

## Industry

Forging

## Audience

- Estimator
- Forging sales engineer
- Cost accountant

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Operation

**Key:** op

**Type:** text

#### Lot qty

**Key:** lot

**Type:** number

**Unit:** pcs

#### Setup hours

**Key:** setup_hr

**Type:** number

**Unit:** hr

#### Run minutes per piece

**Key:** run_min

**Type:** number

**Unit:** min

#### Rate

**Key:** rate

**Type:** number

**Format:** currency

**Unit:** $/hr

#### Material or outside cost per piece

**Key:** other_pc

**Type:** number

**Format:** currency

**Unit:** $/pc

#### Total operation cost

**Key:** total

**Type:** number

**Expr:** setup_hr * rate + lot * run_min / 60 * rate + lot * other_pc

**Format:** currency

#### Cost per piece

**Key:** per_pc

**Type:** number

**Expr:** (setup_hr * rate + lot * run_min / 60 * rate + lot * other_pc) / lot

**Format:** decimal

**Rows:**

**Op:** Bar stock 4140, billet weight incl. flash and scale

**Lot:** 2500

**Setup hr:** 0

**Run min:** 0

**Rate:** 0

**Other pc:** 5.8

**Op:** Saw to billet length

**Lot:** 2500

**Setup hr:** 0.5

**Run min:** 0.4

**Rate:** 55

**Op:** Induction heat to forging temperature

**Lot:** 2500

**Setup hr:** 0.5

**Run min:** 0.3

**Rate:** 70

**Op:** Forge on 2500 ton press with crew

**Lot:** 2500

**Setup hr:** 3

**Run min:** 0.5

**Rate:** 480

**Op:** Trim flash and punch

**Lot:** 2500

**Setup hr:** 1

**Run min:** 0.3

**Rate:** 150

**Op:** Shot blast and inspect

**Lot:** 2500

**Setup hr:** 0.25

**Run min:** 0.2

**Rate:** 60

**Op:** Normalize and temper, outside

**Lot:** 2500

**Setup hr:** 0

**Run min:** 0

**Rate:** 0

**Other pc:** 0.45

**Totals:**

#### Total job cost

**Key:** total

**Agg:** sum

**Format:** currency

#### Total cost per piece

**Key:** per_pc

**Agg:** sum

**Format:** decimal

**Summary:**

#### Price at 15 percent gross margin

**Key:** price15

**Expr:** sum_total / (1 - 0.15)

**Format:** currency

#### Price at 20 percent gross margin

**Key:** price20

**Expr:** sum_total / (1 - 0.2)

**Format:** currency

**Primary:** true

#### Price at 25 percent gross margin

**Key:** price25

**Expr:** sum_total / (1 - 0.25)

**Format:** currency

#### Number of operations

**Key:** ops

**Expr:** count

**Format:** integer

**Notes:** Cost per piece is only meaningful when every row uses the same lot quantity. Press and hammer rates should include crew, energy, maintenance and depreciation. Add dies as a separate row using the die cost per piece calculator, and keep lot sizes consistent when comparing quotes.

## Content

**Intro:** This worksheet organizes a forging quote the way a job actually flows, from bar stock through saw, heat, forge, trim and finishing. Each row computes setup and run cost from your hours and rates, so you can see where the money is before you pick a margin.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per operation. Enter the lot quantity, setup hours, run minutes per piece and the loaded hourly rate for that work center. Put material or outside process cost per piece, such as bar stock or heat treat, in the last input column. The totals update as you type. Add rows for die cost per piece, packaging, testing, and freight if they apply. Then read the price at the margin you target. Export to Excel to keep a version for each revision of the quote or to compare lot sizes.

#### The method

**Body:** Each operation cost equals setup hours times rate plus lot quantity times run minutes divided by 60 times rate plus lot quantity times material or outside cost per piece. Cost per piece is that total divided by the lot. Summing across rows gives the job cost. Price at a gross margin equals cost divided by one minus margin, which is different from adding a percentage markup to cost. Rates should be built up from labor, energy, maintenance, depreciation and overhead, not from vendor price lists alone.

**Bullets:**

- Operation cost = setup x rate + lot x run / 60 x rate + lot x other
- Price = total cost / (1 - gross margin)
- Keep the lot quantity identical on every row

#### Reading it and common mistakes

**Body:** Check the biggest rows first. In most closed die jobs it is material and the press, not finishing. If setup dominates, the price per piece falls sharply with lot size, so quote several lots. Common mistakes include using direct labor rate for a press line that needs a crew, leaving out billet scale and flash in the material weight, forgetting the heat treat and test charges, and ignoring scrap during setup. Compare your result with the actual job cost after shipping and update the rates.

**Cta:** If you want quotes built from your routings, work center rates and actual job costs, we can connect that to your ERP on your own servers.

**Faq:**

#### What rate should I use for a forging press?

**Answer:** Use a loaded hourly rate that includes crew, energy, maintenance, depreciation, floor space and overhead. A press line with heating, handling and a crew costs far more per hour than a single operator machine, so do not use the plain labor rate.

#### How do I price different lot sizes?

**Answer:** Copy the worksheet for each lot size and change the lot quantity on every row. Setup hours stay fixed per lot while run cost scales, so the cost per piece falls with larger lots. Present the breaks to the customer as separate prices.

#### Where does die cost go?

**Answer:** Add a row with the die cost per piece in the material or outside column, or quote the tooling as a separate one-time charge. Use the die cost per piece calculator to build that figure from die life and resink history.

#### Is price the same as markup?

**Answer:** No. A 20 percent gross margin on price means price equals cost divided by 0.8, while a 20 percent markup on cost means cost times 1.2. The two give different prices, so state which one your policy uses.

## Search terms

forging quote template excel, forging cost estimate worksheet, forging job costing, forging estimating spreadsheet, forging quote breakdown, forging operation cost per piece, hammer press forging quote, forging price calculator excel

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