Skip to content
Production Order Analysis app iconProduction Order AnalysisFeature

Actual Versus Expected Production Cost for Microsoft Dynamics 365 Business Central

A production order can run over budget without anyone noticing until someone builds a variance report by hand, because actual cost builds up across many posted entries. Production Order Analysis compares actual against expected cost on production orders in Business Central and calculates the variance, broken down by material, labor, and subcontracting.

The figures come from posted entries, so the comparison is as current as your last posting.

How Actual versus expected production cost works in Production Order Analysis

  1. Production posts consumption, output, and capacity against the production order.
  2. A cost accountant or production manager opens Production Order Analysis and selects the production order.
  3. Production Order Analysis shows expected cost, actual cost, and the variance, in total and by cost type.
  4. They review the lines with the largest variances.
  5. Once the order is finished and cost adjustment has run, the variance is final.

Key capabilities

Expected beside actual

For the selected production order, Production Order Analysis shows total expected cost, total actual cost, and the variance between them.

Variance by cost type

Totals are split into material, capacity, subcontracted, and capacity overhead cost, so an overrun points at a type of cost rather than a single number.

Down to the line

Each component and work center line carries its own expected cost, actual cost, and variance. See Cost at Each Stage.

Overruns in red

Negative variances show in red, so the lines that cost more than expected stand out.

Calculated for you

Production Order Analysis works out the variance from Business Central's posted entries, so nobody has to rebuild it in a spreadsheet.

See Actual versus expected production cost on screen

Real screens from Production Order Analysis, shown with demo data.

Details that matter on the floor

As current as your posting

Actual cost exists once consumption, output, and capacity are posted. A shop that posts as work happens sees a current picture; one that posts weekly sees last week's.

Final after cost adjustment

Variance settles when the order is finished and Business Central's cost adjustment has run, so treat figures on an open order as a running view.

Who uses Actual versus expected production cost

Production managers

Monitor cost against expectation and adjust when a variance appears.

Cost accountants

Use the variance and its breakdown for accurate cost allocation and margin analysis.

Operations managers

Read cost across orders to guide resource and process decisions.

Questions about Actual versus expected production cost

Can Business Central compare actual and expected cost on a production order?

Yes. Production Order Analysis shows actual against expected cost on production orders, with the variance calculated for you and split into material, capacity, subcontracted, and capacity overhead cost.

Where do the actual costs come from?

From consumption, output, and capacity entries posted in Business Central.

When is the variance final?

When the production order is finished and cost adjustment has run in Business Central.

Can I buy Production Order Analysis on its own?

Not at this time. Production Order Analysis is currently available only as part of the Enhanced Planning Pack. Users who work with production orders need a full user license on the Business Central Premium tier, and people who only view results can use a Team Member license. For more detail, see the licensing FAQ or contact your Microsoft Partner.

Production Order Analysis app icon

Part of Production Order Analysis

Monitor actual vs. expected production costs to optimize budgets and enhance profitability.

Have a question about Actual versus expected production cost?

Send us a note and the Production Order Analysis team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.

Ask a product question

Product Questions