Project Costing for Special Machine Builders: Quoted vs Actual, Before Shipment

Set the Budget in the Same Buckets as the Quote

Costing only works if the budget lines match the quote lines. Break the project into mechanical engineering, electrical engineering, controls programming, project management, fabrication, assembly and wiring, purchased components, outside services, test and FAT, and installation and commissioning. Load the quote hours and dollars into each bucket as the baseline.

If the quote was one lump, split it afterward with the estimator before the project starts, because reconstructing a budget after problems appear never works. In Infor SyteLine, Epicor Kinetic, or NetSuite these map to project tasks or cost codes.

• One budget line per quote line
• Hours and dollars both, so rate variance is visible
• Separate baseline from approved change order budget
• Include warranty reserve and commissioning travel

Committed Cost Is More Useful Than Actual

Actual cost lags. By the time a purchased part is invoiced the decision was made weeks ago. Committed cost, open purchase orders plus received and invoiced, shows where the project is heading.

A PO for a robot that came in 15 percent over budget is visible the day it is placed. Make sure your ERP or reporting shows commitments by project line. If it only shows receipts, add a simple weekly extract of open POs to the project cost view.

Labor Capture, Especially Engineering

Shop labor is normally booked by job. Engineering often is not, which leaves the largest and least predictable cost invisible. Require weekly time entry by project and discipline.

It does not need to be heavy: a timesheet with project, task, and hours is enough. Without it, you cannot compute actual-to-estimate ratios, and you cannot tell whether controls programming or mechanical design is the one that runs over. Treat unbooked time as a data quality problem that you track and report by person.

Estimate to Complete and Margin Forecast

Each month, the project manager should enter an estimate to complete per line based on remaining work, not simply budget minus actual. Actual plus estimate to complete gives a forecast at completion, and subtracting that from contract value gives forecast margin. A drop of more than a few points is the trigger for a review: is it a change order, a rework issue, or a missed assumption?

This forecast also feeds percent-complete revenue recognition when you recognize revenue over time, which your accountant will want to be accurate.

Post-Project Review and When Simple Is Enough

When a project closes, compare final cost to the quote by line and record the reasons for variance in a short note. Over a dozen projects, the pattern, for example that controls always runs 40 percent over, becomes a correction factor in the next estimate. If you ship only a few machines a year, a spreadsheet pulling ERP actuals each month does the job.

Invest in an ERP or AI reporting layer when project count makes manual reconciliation the bottleneck.