FABRICATION • WELDING • JOB SHOP

Quote the job.
See the margin.
Protect the profit.

A practical Excel workflow for calculating shop rates, building quotes, checking target margin, comparing quoted vs actual results, and tracking change orders.

✓ Macro-free✓ No subscription✓ Uses your own rates
QUOTE BUILDERDRAFT
Fabrication Shop Profit & Quote System
CategoryDescriptionQtyRateLine costSell
MaterialMild steel plate8RM 42RM 336RM 386
LabourCut + weld6RM 70RM 420RM 420
ConsumableWire + gas1RM 85RM 85RM 94
Target quoteRM 1,150
Gross profitRM 210
Margin18.3%
StatusCHECKED

Illustrative interface. Buyer enters their own business assumptions.

THE EXPENSIVE PART OF “GOOD ENOUGH”

A quote can look right and still lose money.

Shop rate too low. Labour and machine burden are quietly under-recovered.

Consumables forgotten. Wire, gas, discs, waste and outside services disappear into the margin.

No feedback loop. The quote is sent, the job finishes, and nobody checks what actually happened.

ONE REPEATABLE WORKFLOW

From shop assumptions to post-job learning.

01

Shop Rate

Set labour, machine and overhead assumptions with your own numbers.

02

Quote

Break the job into material, labour, consumable and outside-service lines.

03

Profit Check

See target selling price, expected gross profit and margin before committing.

04

Job Log

Compare quoted sales with actual cost and actual profit after the job.

05

Change Orders

Track added value and added cost so scope changes do not quietly erode margin.

BUILT AROUND THE WORKBOOK

No abstract dashboard. The product is the tool.

Use the spreadsheet directly in the workflow you already know. The system stays intentionally focused instead of pretending to be a full ERP or accounting platform.

Quote BuilderShop Rate CalculatorActual vs EstimateChange Orders
JOB LOGQUOTE vs ACTUAL
RM 1,150
quoted sales
RM 940
actual cost
RM 210
actual profit

WHAT YOU GET

A small-shop toolkit, packaged for immediate use.

01

Macro-free XLSX

Quote, rates, job log and change-order workflow in one workbook.

02

Quick-start guide

A concise setup path so you can replace sample assumptions with your own.

03

Sample data

Example structure to understand how the job-cost loop fits together.

WHO IT IS FOR

Made for small teams that still quote by experience + spreadsheets.

  • Fabrication and welding shops
  • Machine and job shops
  • Engineering workshops pricing custom work
  • Small contractors using material + labour + outside-service costing

WHO IT IS NOT

Know the boundary.

  • Not accounting or tax software
  • Not a full workshop-management platform
  • Not engineering certification or compliance advice
  • Not a promise of guaranteed profit or savings

FAQ

Does it use macros?

No. The workbook is designed to be macro-free.

Can I use my own shop rates?

Yes. Replace the example assumptions with your own verified business inputs.

Does it need an API or internet connection?

No. The core workbook is designed to run locally in Excel-compatible software.

Is this accounting software?

No. It is a quoting and job-costing tool, not accounting, tax or legal advice.

READY TO SEE YOUR NUMBERS?

Stop guessing the quote.

Use the workflow, put in your own rates, and make the margin visible before you commit.

Get the system for US$19