Job Close-Out Variance Worksheet
You find out whether a quote was right only after the job ships. This worksheet puts quoted and actual hours and cost side by side for each closed job, so you can find the parts you consistently underprice and fix the estimate next time.
| Job number | Part | Quoted hours (hours) | Actual hours (hours) | Shop rate (per hour) | Quoted material and outside | Actual material and outside | Invoiced revenue | Hours variance | Actual cost | Profit | Margin | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
-4 | $4,990 | $2,210 | 30.7% | |||||||||
18 | $9,280 | $520 | 5.3% | |||||||||
-1 | $2,940 | $1,160 | 28.3% | |||||||||
15 | $11,375 | $1,225 | 9.7% |
Use actual hours from your ERP labor transactions. Include outside processing in material and outside. Review jobs where hours variance is positive and repeat parts first.
Automatic quote vs actual reports
Optional: ask about weekly variance reports built from your ERP data.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
After a job is invoiced, add a row with the quoted hours, actual hours, shop rate, quoted and actual material and outside processing, and invoiced revenue. The sheet calculates hours variance, actual cost, profit and margin. Review the biggest positive hours variances first. Export to Excel monthly and keep the file as a record of estimating accuracy.
The calculations
Hours variance equals actual hours minus quoted hours. Actual cost equals actual hours times shop rate plus actual material and outside cost. Profit equals revenue minus actual cost, and margin is profit divided by revenue. Because the rate is a blended number, treat margin as a comparison across jobs rather than as accounting profit.
- Positive hours variance means the job ran long
- Compare repeat parts across multiple runs
- Separate setup variance from run variance when you can
- Look at material variance for scrap or price changes
Reading the result
One bad job is noise. A pattern is information: if the same operation type runs long on every quote, the standard times are wrong. If material cost runs over on every job, review how you price bar stock and scrap allowance. Update the routing standards in your ERP when the pattern is clear.
ERP notes
JobBOSS, E2 Shop System, Global Shop Solutions and ProShop all report estimated versus actual per job. The value of this sheet is the discipline of a short review meeting, plus the freedom to add your own notes. If your ERP numbers disagree, check whether labor entries were captured and whether outside costs were posted to the job.
Frequently Asked Questions
Where do I get actual hours?
From labor or shop floor data collection in your ERP, or from timecards if you do not have one. Make sure setup, run and rework time are all attached to the correct job number.
Should rework hours be included?
Yes, include them in actual hours, but consider tracking them separately as well so you can see how much margin is lost to rework rather than estimating error.
Is the margin an accounting profit?
No. It uses one blended shop rate, so it is a management comparison. Your accountant's job cost reports may differ because of overhead allocation methods.
How often should I review it?
Weekly or monthly for jobs closed in the period. Review immediately for any job that lost money, while the details are still fresh.
If you want estimated-versus-actual reviews generated automatically from your ERP every week, Netray can help build the report.
Related Tools
Job Shop Machine Hour Rate Worksheet
Editable worksheet that converts machine price, life, hours, power draw and maintenance into a cost per run hour for each machine.
Costing & FinanceJob Shop Setup Cost Per Piece Calculator
See how setup hours, run time, material and margin combine into a per-piece cost and price, and how it falls as the lot size grows.
MES & Shop FloorJob Shop On-Time Delivery Tracker Worksheet
An editable tracker that computes days late per job and the shop on-time delivery rate from promised and actual ship days.
Discrete ManufacturingJob Shop RFQ Intake Form Template
A one-page request for quote intake form so every RFQ reaches the estimator with the same information before anyone opens JobBOSS, E2 Shop System or Global Shop Solutions.
More Costing & Finance tools
See all- CNC Machining Cost Calculator
- SAP QM Inspection Effort and Cost Calculator
- SAP Standard Cost Estimate BOM Rollup Calculator
- Legacy ERP Retirement Cost and Payback Calculator
- JD Edwards World Month-End Close Procedure Template
- Distributor Customer Credit Application Template
- Distributor Customer Profitability Worksheet
- Distributor GMROI and Inventory Turns Calculator
- Vendor Early Pay Discount Worksheet