The best method starts below the total. Match the old and new work by configuration, manufacturing route, quantity, plant, supplier scope, engineering novelty, test, documentation and delivery pattern. Carry forward hours and physical quantities where possible. Apply current rates and current supplier evidence. Remove rework, customer changes and one-time events that do not belong in the new base scope.
The result should be a cost bridge that a reviewer can challenge: closed-job actual, normalization, scope change, current economics and risk. That bridge gives historical data its credibility without letting yesterday’s accounting decide tomorrow’s price.
Know which historical number you found
A job record can hold several values that answer different questions. Label the value and its status before using it. An “actual cost” from an open order may still exclude late supplier invoices, overhead allocation or cost adjustment.
| Value | What it records | Safe use in a new quote |
|---|---|---|
| Original quote estimate | What the bid team believed before award | Compare assumptions and identify the risks the team saw |
| Released job budget | The cost basis production received after order review | Trace changes between sale and release |
| Standard cost | The fixed accounting basis for inventory and variance | Use as a reference after reconciling it to the job’s physical work |
| Committed cost | Purchase orders and other obligations already placed | Check supplier choice, quantity, currency and open commitments |
| Recorded actual | Posted material, labor, machine, supplier and overhead transactions | Use after checking completeness, classification and close status |
| Final adjusted actual | Cost after invoices, WIP settlement and accounting adjustments | Strongest financial total, provided the work content is clear |
| Cost variance | Difference between a standard, estimate or budget and actual | Find the driver; the sign and total alone explain nothing |
Microsoft’s current Business Central guidance says a finished production order brings together actual material, capacity, subcontracting and overhead, and that final adjustment depends on the order reaching Finished status. NetSuite likewise generates manufacturing variance from differences between fixed and actual cost. The quote team needs the close and transaction rules for its own ERP before it trusts the total.
Close the job before you call it actual
| Close check | Failure mode | Quoting action |
|---|---|---|
| All receipts and invoices posted | A late machining, freight or material invoice appears after the analysis | Wait for close or carry a named accrual |
| Material issues and returns complete | Unused stock remains charged or consumed material never reached the job | Reconcile issue, return and scrap quantities |
| Labor and machine time approved | Missing shifts or corrected time change the conversion cost | Use approved records and note backflush or standard-time postings |
| Subcontract operations received | The job shows a commitment but not the final price or quantity | Use invoice cost or an explicit outstanding commitment |
| WIP settled and order closed | Financial actuals remain provisional | Show the close status beside the cost |
| Change orders classified | Customer-funded work appears as base-product overrun | Separate base scope from approved and unapproved changes |
| Credits and recoveries recorded | Supplier credits, scrap sales or warranty recovery never reduce the job | Include only recoveries that belong to the same work |
IFS exposes standard, estimated and actual cost by shop order, operation, cost bucket and transaction in its Shop Order Costs workflow. That detail matters. A closed total without its transactions cannot tell the estimator whether the overrun came from a permanent route problem, a customer change or a posting error.
Match jobs on the drivers that created cost
Part number and product family help find candidates. They rarely prove comparability. A repeat model can carry a new motor, coating, control standard, test plan or documentation package. A different model can share the same expensive engineering and factory route. Search broadly, then score the drivers.
| Driver | What to compare | Why it moves cost |
|---|---|---|
| Product architecture | Modules, ratings, size, duty and configuration path | Changes material, bought-out content, assembly and test |
| Revision and requirements | Drawing, BOM, specification, code and customer deviations | Changes the work even when the commercial name stays the same |
| Manufacturing route | Plant, work centers, subcontract operations, tooling and sequence | Changes time, burden, yield and freight between operations |
| Quantity and delivery | Lot size, annual volume, release pattern and deadline | Changes setup, purchasing, learning, overtime and logistics |
| Engineering content | Reuse, new design, approvals, calculations and documentation | Moves nonrecurring hours and schedule risk |
| Supplier scope | Make/buy split, suppliers, Incoterms, currency and validity | Changes both price and exposure |
| Quality and test | Inspection, certification, FAT, witness points and records | Adds labor, equipment, scrap risk and lead time |
| Execution conditions | Capacity, expedite, disruption and learning stage | Explains actual cost that may not repeat |
Build a comparable set instead of betting on one job
One historical job can contain an unusual supplier failure, a favorable material buy or a reporting gap. Use several candidates when the record exists. Choose one as the primary analogue and use the others to test individual cost blocks.
| Candidate | What matches | What differs | Use |
|---|---|---|---|
| J-2418 | Same pump architecture, plant, test route and customer documentation | Smaller motor, carbon-steel trim, included winterization | Primary analogue |
| J-2387 | Same hydraulic size and fabrication route | Different controls and a simpler customer document set | Cross-check fabricated base, piping and assembly hours |
| J-2471 | Current motor, VFD and control cabinet | Larger skid and different pump family | Cross-check bought-out equipment and controls integration |
| J-2294 | Same customer and acceptance test | Old design revision and another plant | Cross-check witness-test and documentation effort only |
Record why each job entered the set and which lines it supports. Do not average four totals whose scope differs. A material line may come from the most recent supplier order while engineering hours come from the closest customer and configuration.
Compare physical work before dollars
Dollars mix quantity, rate, accounting and time. Hours, kilograms, operation counts and purchase quantities make the old job easier to understand and update. Carry the physical driver into the new estimate, then apply the rate that fits the new work.
| Cost line | Historical record to retrieve | Current conversion |
|---|---|---|
| Material | Issued quantity, return, scrap and yield by material | Current BOM quantity and current buy rate |
| Direct labor | Setup and run hours by operation or work center | Comparable hours adjusted for scope, quantity and learning times current labor rate |
| Machine | Machine hours and work center | Current route and machine or burden rate |
| Bought-out parts | PO quantity, invoice price, freight and currency | Current supplier quote or valid price at the new quantity |
| Engineering | Hours by task, role and change reason | Reusable base hours plus explicit new and customer-specific work |
| Test | Setup, run, retest, witness and report hours | Current procedure, witness points and planned first-pass yield |
| Freight | Lane, mode, weight, dimensions and expedite | Current shipment plan and carrier evidence |
GAO’s Cost Estimating and Assessment Guide recommends this level of care: validate the data, normalize it, separate recurring and nonrecurring cost, and understand the work that created each value. It also warns that changes in accounting can invalidate an extrapolation even when the product looks similar.
Remove events that should not become standard work
| Historical event | Default treatment | Exception |
|---|---|---|
| Customer change after release | Remove from base and estimate the current requested scope separately | Carry it when the new RFQ includes the changed requirement |
| Internal drawing error and rework | Remove from the expected route and track as a corrective-action issue | Carry residual risk when the fix remains unproven |
| Supplier quality failure | Remove defective-unit cost from standard content | Add current risk when the same supplier and cause remain |
| Premium freight caused by late action | Remove from normal delivery cost | Carry it when the new schedule still requires expedite |
| Prototype or first-article learning | Separate from recurring production | Use a learning plan when the new order remains early in the curve |
| One-time tooling or fixture | Separate cash and amortization from recurring unit cost | Carry remaining recovery only when the commercial agreement requires it |
| Favorable purchase or scrap sale | Normalize to repeatable economics | Use the benefit when a current agreement secures it |
Removing an overrun from the quote does not mean ignoring it. Put the event in the variance record, assign its corrective action and test whether the cause still exists. The quote should carry expected work and named risk, not every mistake the company has ever made.
Separate recurring work, one-time work and learning
A first build often combines production, tooling, documentation setup, engineering release and factory learning. Divide those costs before applying a new quantity. Learning applies to repeated work; it does not automatically reduce material or one-time engineering.
| Cost behavior | Examples | How to carry it forward |
|---|---|---|
| Recurring per unit | Material, run labor, standard test and packaging | Scale with quantity after rate, yield and learning review |
| Recurring per batch | Setup, inspection setup, material handling and shipment prep | Scale with lots or releases, not units |
| Nonrecurring | Design, qualification, tooling, fixtures and customer document setup | Re-estimate the work and show recovery separately |
| Step cost | Extra shift, fixture, test stand or project manager | Add when volume or schedule crosses the capacity threshold |
| Learning-sensitive | Manual assembly, fabrication and repeated engineering tasks | Use observed hours across units or lots when the process stayed stable |
| Volatile market cost | Metals, energy, bought-out electronics and freight | Use current evidence and a stated escalation basis |
The GAO guide limits learning-curve logic to recurring work and asks the estimator to account for breaks in production and rate changes. That is directly relevant to industrial equipment. A line that built ten similar units last quarter may not retain the same efficiency after a two-year gap, a new crew or a design revision.
Explain estimate-to-actual variance before reusing it
A variance report becomes useful when the team assigns a cause that changes a future assumption. “Material unfavorable: $18,400” is an accounting fact. “Customer changed the motor after release: $11,200; original unit price and return charge account for the rest” gives the next estimator a decision.
| Variance class | Example | Next-quote action |
|---|---|---|
| Scope | Customer added a certification package | Add the current requirement and price the change path |
| Quantity or mix | Build quantity fell from eight to three | Recalculate setup, buy breaks and amortization |
| Rate | Labor, material or supplier rate changed | Use the current effective rate and retain the old physical quantity |
| Usage or efficiency | Assembly used 920 hours instead of 760 | Find the operation, cause and corrective action |
| Yield and quality | Fabrication scrapped one base frame | Use expected first-pass yield plus current residual risk |
| Schedule | Overtime and air freight recovered a late release | Build the new schedule and price expedite only when required |
| Accounting | Overhead method or cost center changed | Restate the historical line on a comparable basis |
| Posting quality | Time or material reached the wrong job | Correct or exclude the transaction before analysis |
IFS shows planned and actual machine, labor, material, scrap and overhead at shop-order level. Dynamics 365 can compare estimated and actual component, route and indirect costs. Those tools provide the facts. The business still needs a short, controlled cause list and an owner who can explain each material variance.
Follow a completed pump package into a new quote
Consider a new customer request for a packaged process pump. J-2418 is the closest completed job. It used the same hydraulic architecture, plant, acceptance-test route and document set. Its closed actual cost was $402,000. The new unit has a larger motor and VFD, stainless trim, no winterization and one extra customer document package.
| Bridge step | Adjustment | Running cost |
|---|---|---|
| Closed actual for J-2418 | Starting point | $402,000 |
| Remove customer change after release | -$14,000 | $388,000 |
| Remove internal drawing-error recovery | -$7,000 | $381,000 |
| Remove one-time assembly fixture | -$9,000 | $372,000 |
| Larger motor and VFD | +$18,000 | $390,000 |
| Stainless trim | +$7,000 | $397,000 |
| Remove winterization package | -$6,000 | $391,000 |
| Additional customer documentation | +$4,000 | $395,000 |
| Current supplier and material evidence | +$9,000 | $404,000 |
| Current labor and work-center rates | +$6,000 | $410,000 |
| Batch and repeat-build efficiency | -$4,000 | $406,000 |
| Current freight plan | +$2,000 | $408,000 |
| Unresolved heat-rejection allowance | +$12,000 | $420,000 |
The bridge produces a $420,000 working estimate. A separate bottom-up cost model returns $414,000. Current supplier quotes support $417,000 for the bought-out and subcontract content. The team sets a review range of $410,000 to $432,000 and assigns engineering to close the heat-rejection assumption before price approval.
The three views agree closely enough for a decision, and the $12,000 allowance stays visible. Copying J-2418’s $402,000 actual would have hidden both the new scope and the resolved waste.
Update prices with specific evidence
Use current supplier quotes, agreements and purchase prices before general indexes. An index describes a market series. It does not know the old job’s supplier, quantity, alloy, freight lane or negotiation. Apply it to the cost block that resembles its market basket and record the series, base period and dates.
| Update source | Good use | Limit |
|---|---|---|
| Current supplier quote | Named part, scope, quantity and date | May carry exclusions, minimums or temporary capacity pricing |
| Current purchase agreement | Contracted item and valid volume tier | Check remaining term, escalation and currency |
| Recent purchase order or invoice | Repeat buy under comparable conditions | One transaction may include expedite or a credit |
| Material or commodity evidence | Specific raw-material content | Conversion, yield and supplier economics still need separate treatment |
| Producer Price Index | Broad escalation check for a matching output series | Measures seller prices for a market, not the direct cost of your product |
| Exchange and freight evidence | Named currency and shipping lane | Timing, hedge, Incoterm and fuel terms can change the result |
The Bureau of Labor Statistics PPI price-adjustment guide tells contracting parties to define the exact series, base value, adjustment interval, weights and treatment of revisions or discontinued series. Use that discipline for quote escalation too. “Add 6% for inflation” is not a cost method.
Use several actuals without averaging away the story
Multiple jobs can show a stable relationship or a wide range. Group them by the drivers first. Then use medians, ranges or simple models at the level where the data remain comparable. Show the sample size and spread beside the result.
| Pattern | Useful treatment | Warning |
|---|---|---|
| Stable repeat item | Median recent usage and time, current rates | Check revision, lot and plant changes |
| Configured family | Model cost by size, option and route drivers | Do not let a product-family label replace configuration data |
| Early production | Separate first-unit effort and fit a learning view when the process stayed stable | Few points can create a false trend |
| High-mix engineered work | Use cost blocks and expert adjustment from several analogues | A total-cost regression can hide scope |
| Supplier purchase history | Normalize quantity, currency, freight and terms | Paid price may include negotiation or capacity conditions |
| Noisy actuals | Use the data to identify uncertainty and collection gaps | More records do not repair inconsistent classification |
If the team has enough closed work, the same comparable cohorts can improve quote win-loss analysis. Cost variance, price position and outcome then sit beside product, customer and commercial context instead of becoming separate reports with different populations.
Store the bridge with the quote
Save the reasoning with the quote: historical job IDs, source transactions, matching rationale, exclusions, physical quantities, rates, adjustments, unresolved risks and approvals. Preserve the old actual as evidence while the current quote evolves.
| Record | Owner | Version rule |
|---|---|---|
| Comparable-job set | Estimator or cost engineer | Freeze the set used for each submitted quote revision |
| Historical actual extract | Finance or ERP owner | Record close status and extraction time |
| Scope and configuration comparison | Engineering | Tie every material difference to a customer or product revision |
| Rate and supplier update | Sourcing and finance | Store source, currency, quantity, validity and effective date |
| Variance decisions | Named functional owners | Preserve the original value, adjustment and reason |
| Risk and allowance log | Bid owner | Close, replace or approve each item before handoff |
A system should let a reviewer move from the new cost line to the historical transaction and back without losing context. If the business only stores the final $420,000, the next estimator must rebuild the argument from scratch.
Measure whether historical quoting improves
| Measure | Definition | What it reveals |
|---|---|---|
| Actual-cost completeness | Closed jobs with material, labor, supplier, change and close records complete | Whether the evidence base deserves use |
| Comparable-set coverage | Quotes with at least one documented analogue and driver match | Whether reuse reaches daily work |
| Unexplained bridge value | Adjustment value without an owner and source as a percent of estimated cost | Where judgment still hides |
| Estimate-to-actual variance | Closed-job actual against approved estimate by cost block | Which assumptions need repair |
| Systematic bias | Median signed variance by family, plant and estimator | Persistent optimism or conservatism |
| Estimate cycle time | Receipt of usable scope to approved cost | Whether retrieval and normalization save time |
| Post-award change separation | Change cost classified by customer, internal, supplier and external cause | Whether base-product economics stay clean |
Review the measures by product family and work type. One overall accuracy number can hide a reliable repeat business and a failing engineer-to-order segment. Fix the source and method where the variance begins.
Where Bourne helps
ERP remains the system of record for job transactions, inventory and accounting cost. Bourne can search the closed work, assemble comparable jobs around the current customer request, show the revision and configuration differences, retrieve the underlying actuals and route each adjustment to its owner.
For the pump package, the estimator would see J-2418 beside the new RFQ. Engineering would own the motor, trim, documentation and heat-rejection changes. Sourcing would refresh supplier and freight evidence. Finance would approve the current rates and the treatment of abnormal historical cost. The approved bridge would feed pricing and stay with the order handoff.
This works best when the business already records useful actuals but struggles to find, normalize and explain them during a deadline. See the product costing workflow for the application.
Buğra Gündüz
Buğra Gündüz is the co-founder and CEO of Bourne and co-founder of HockeyStack. He built HockeyStack into an eight-figure AI business. At Bourne, he works with entrepreneurs and established companies to create AI products and services.