The standard cost worksheet in Business Central

For manufacturers and distributors using standard cost as their inventory costing method, the standard cost worksheet is the tool that maintains and revalues item standards. It supports the annual cost roll, mid-year revaluations, and what-if scenarios — with the GL posting that reconciles inventory value to the new standards.

Why standard cost. Standard cost stabilises inventory valuation independent of fluctuating actual purchase prices. Variances (between standard and actual purchase price, or between standard and actual production cost) post to dedicated variance accounts, making operational deviations visible. Common in manufacturing where production costs should be predictable for pricing and margin analysis, and in distribution for high-volume items where average-cost noise distorts margin.

The annual cost roll. Once a year (typically before the new fiscal year), companies update the standard costs to reflect current input prices, current routing rates, and current overhead allocations. The standard cost worksheet is where this happens:

1. Suggest Item Standard Cost — populate the worksheet with current standards for selected items.
2. Adjust — calculate new proposed standards based on:
   • Current vendor purchase prices for raw materials.
   • Current production BOM and routing costs.
   • Overhead rate applied to direct costs.
3. Review — the worksheet shows old standard, proposed new standard, % change, and the cost components that drove the change.
4. Approve and post — apply the new standards. The system updates the item card and posts revaluation journal entries.

Components of standard cost. For a manufactured item, the standard breaks into:

• Material cost — sum of BOM components at their standard.
• Capacity cost — sum of routing operations' setup and run time at work-centre rates.
• Subcontracting cost — for subcontracted operations.
• Capacity overhead — applied as a rate on capacity time.
• Manufacturing overhead — applied as a percentage or fixed amount.

The worksheet rolls these components for each item, giving full transparency into where cost is changing.

Revaluation journals. When the standard changes, the inventory value at the old standard differs from the inventory value at the new standard. The system calculates the difference per location, per item, per variant, and posts a revaluation journal:

• Debit / Credit Inventory (depending on direction of change).
• Offset to Revaluation Variance GL account.

This brings inventory to the new standard cleanly, with audit-trail journal entries for finance reconciliation.

What-if analysis. The worksheet can be run without posting — calculate proposed standards, review the impact, adjust assumptions (e.g. test what a 5% raw material increase does to finished goods), and discard. Useful for budgeting and pricing simulations.

Mid-year revaluation. For items where the annual roll isn't enough — a major commodity price move, a contract renegotiation, a new supplier — the worksheet supports mid-year revaluation of selected items. Same mechanism, smaller scope.

The full inventory implication. Standard cost only works if all transactions post at standard. Sales orders, production orders, transfers, and consumption all use the standard. Variances between standard and actual flow to variance accounts on receipt and on production-order completion. Run Adjust Cost — Item Entries before period-end to capture all variances.

Operational discipline. Document the standard cost roll process as an annual procedure — owner, timing, sign-offs, exception handling. Standard-cost discipline is finance and operations together; the worksheet is the bridge.