Contents
A customer needs 100 brackets similar to the ones your shop made last year. The estimator finds three quotes in SharePoint and several production orders in Business Central. The quoted prices differ. One order included rework, and another was for twice as many parts. Those details matter before anyone picks a unit cost.
A costing pilot can bring the records together and let the estimator trace the calculation back to the evidence. Start with a single part family. That gives the team a manageable way to decide which jobs are comparable and where an experienced person still needs to make a call.
Keep the three kinds of cost apart
The quoted price reflects the commercial decisions made at the time. Standard cost is based on manufacturing assumptions. Actual cost draws on recorded consumption, capacity and other charges. In a standard-cost environment, Microsoft documents expected cost at certain posting stages and variance calculations for finished orders. Before using a historical figure, check the order status, the available entries and the costing method for the item.
An unsuccessful quote can show what the estimator assumed about an operation. It provides no observed manufacturing cost. Keep its outcome with the record so that anyone reviewing the estimate can tell where a figure came from.
Match the records with someone who knows the shop
Collect the part revision, material, output quantity and routing operations for each order. From SharePoint, keep the quote version, requested quantity and line-level cost assumptions. Check the routing even when the part numbers match. It may have changed while the number stayed the same.
Have a shop or costing lead review an initial sample of proposed matches. They may recognize one-off rework, an outsourced operation or a setup charge booked in the wrong place. Record the reason for each exclusion. That gives the next estimator a way to explain why apparently similar jobs produce different numbers.
Work through a 100-part estimate
In this fictional example, both lot sizes use the same material, setup and machining time per unit. The size of the lot changes the share of setup assigned to each part.
TableFictional unit cost by production lot size (CAD) · shareable block
| 100-part lot | 50-part lot | |
|---|---|---|
| Material | $8.00 per part | $8.00 per part |
| Setup | $180 ÷ 100 = $1.80 per part | $180 ÷ 50 = $3.60 per part |
| Machining | 6 min × $90/h = $9.00 per part | 6 min × $90/h = $9.00 per part |
| Subtotal | $18.80 per part | $20.60 per part |
Show any costs awaiting confirmation, such as subcontracting, scrap and overhead. Check what the machine rate already includes before adding charges. The estimator should be able to change an assumption, see the effect and open the records behind it.
Test the pilot on jobs with known outcomes
Hold back some historical jobs while building the pilot. Then ask estimators to quote them with the proposed tool. Compare their estimates with the available actual costs and time how long it takes to find and check the data. A usable estimate is one the team can reconstruct and correct before the quote goes out.
If the pilot requires an application, use our guide to compare custom software quotes on the same scope and expected outcome.
To get started, choose a repeat part family and prepare an anonymized production order and quote. Daillac can help map the sources, agree on matching rules and scope the first assisted estimating workflow.
Frequently asked questions
Can we use costs from an open production order?+
Use them to examine the job. If costs are still unposted or final output is unknown, keep that order out of the actual-cost benchmark or label it as provisional.
What if one part has several item numbers?+
Have the shop confirm a cross-reference between item numbers and revisions. Retain the original reference so each amount stays traceable.
Why keep unsuccessful quotes?+
They document the routing and price assumptions made at the time. Preserve their outcome so those values are never mistaken for observed costs.
How many parts should the first pilot cover?+
Choose one repeat family with enough reliable jobs to cover common quantities and operations. Hold back a few records for the final evaluation.
Discuss a manufacturing costing pilot
D
Written by
Daillac

