The Complete Guide to Standard Cost Updates in Business Central Manufacturing
Updating standard costs in Business Central is one of the most misunderstood processes across manufacturing, distribution, and supply chain environments. It affects inventory valuation, margins, production variances, and financial reporting. Yet many companies avoid updating their standard costs or perform the process incorrectly, resulting in inaccurate financials and difficult reconciliations.
This guide explains how to correctly manage, calculate, and apply standard costs in Business Central, with a practical, real-world approach.
1. What Is Standard Costing and Why It Matters
Standard costing assigns a fixed, predefined cost to every item, regardless of actual purchase or production cost. It is ideal for:
- Discrete manufacturing
- Repetitive production
- Stable product structures
- Companies needing predictable cost and variance reporting
In Business Central, standard cost affects inventory valuation, COGS, margin calculations, and production variances. Because it drives so much financial activity, updating it must be done carefully and consistently.
2. What Drives the Standard Cost in Business Central
The standard cost roll-up is based on four main elements:
A. BOM Costs (Material Costs)
- Component quantities
- Direct cost on components
- Scrap percentage
- Rounding precision
B. Routing Costs (Labour & Machine Costs)
- Work centre and machine centre cost rates
- Setup time
- Run time
- Overhead applied per operation
- Capacity type (machine vs labour)
C. Overheads
Fixed and variable overheads derived from work centre rates or routing operations.
D. Subcontracting
If routings include subcontracting operations, subcontracting cost is added directly to the cost roll-up.
3. Preparing for a Standard Cost Update
Before calculating costs, ensure the foundations are correct.
✔️ Work Centres Have Correct Cost Rates
Common issues include outdated labour rates, incorrect overhead rates, and wrong capacity units.
✔️ BOMs Are Accurate
- Missing components
- Wrong quantities
- Incorrect scrap settings
✔️ Routings Reflect Real Production
- Missing operations
- Incorrect run or setup times
- Unmapped subcontracting operations
✔️ Costing Versions Are Ready
Create a new costing version (e.g., “2025 Update”) to track all changes and provide audit transparency.
4. How to Calculate Standard Costs (Step-by-Step)
1. Open the Standard Cost Worksheet
Manufacturing → Costing → Standard Cost Worksheet
2. Select or Create a Costing Version
Type = Standard, Status = New.
3. Run “Calculate Standard Cost”
Select your costing version, filter items, and include BOM, routing, and overhead updates.
4. Review the Suggested Costs
Look for:
- Items with zero cost
- Large cost differences
- Missing BOMs or routings
- Subcontracting inconsistencies
5. Implement Standard Cost Changes
This step updates:
- Item Card standard cost
- BOM component cost
- Routing cost
6. Apply the New Standard Costs
Change the costing version status from New to Active. At this moment, the new standard cost becomes effective.
5. What Happens After Applying New Costs
Business Central automatically creates revaluation entries for all on-hand inventory.
| Item | Old Cost | New Cost | Qty | Adjustment |
|---|---|---|---|---|
| FG-100 | £25.00 | £30.00 | 100 | +£500 |
These adjustments impact inventory valuation, COGS, and variance reporting.
6. Common Mistakes to Avoid
- Updating BOM costs manually instead of through the worksheet
- Applying costs before reviewing exceptions
- Updating costs mid-month causing mixed variances
- Forgetting to update work centre cost rates
- Ignoring revaluation journal impacts
7. Best Practices for Standard Cost Updates
- Use a sandbox environment first
- Freeze BOM and routing changes during cost review
- Use costing versions as audit snapshots
- Communicate changes to production and finance teams
- Perform cost updates annually or semi-annually
- Document all changes for audit trails
8. Conclusion
Standard cost updates in Business Central are powerful but require careful preparation, accurate master data, and controlled execution. By following best practices, reviewing calculated costs thoroughly, and coordinating with finance and production, companies can ensure accurate inventory valuation, meaningful variance reporting, and reliable margin analysis.
When done correctly, standard costing becomes a strategic tool for cost control and profitability improvement.
Comments
Post a Comment