Production Order Analysis for Microsoft Dynamics 365 Business Central
See where each production order's cost went
Monitor actual vs. expected production costs to optimize budgets and enhance profitability.
Production Order Analysis compares actual against expected cost on production orders in Microsoft Dynamics 365 Business Central, broken down by material, labor, and subcontracting. Where a production order is linked to a sales order, Production Order Analysis also shows the sales margin beside the cost. It is currently available only as part of the Enhanced Planning Pack, Insight Works' bundle of six planning, forecasting, and production analysis apps for manufacturers.
Production Order Analysis is included in Enhanced Planning Pack.
- Cloud and on-premises
- Available in Enhanced Planning Pack
How Production Order Analysis helps
Cost variance
Find which cost ran over on a production order
When a finished production order costs more than expected, the total alone does not say whether material, machine and labor time, or subcontracting caused it. Working that out by hand means pulling entries from several places.
Production Order Analysis shows expected cost, actual cost, and the variance for each component and work center on the order, with totals for material, capacity, subcontracting, and capacity overhead. Overruns are shown in red, so the lines that need attention stand out.
See all Production Order Analysis features ↓Sales margin
See cost and margin side by side
Production cost tells you what an order cost, not whether it made money. On make-to-order work, the margin is the number that shapes the next quote.
Where a production order is linked to a sales order, Production Order Analysis calculates the sales margin next to the actual cost. The worksheet carries sales amount, gross margin amount, and gross margin percent alongside the cost columns.
See all Production Order Analysis features ↓One worksheet
Keep production cost review in one place
Cost reviews built from manual calculations take time and drift from what was actually posted. By the time the spreadsheet is finished, the next orders are already done.
Production Order Analysis brings the cost detail into a single worksheet in Business Central, built from the entries Business Central has already posted. The Production Order Analysis report lets you choose which summaries to print: units, actual costs, expected costs, cost variances, and sales and margin amounts.
See all Production Order Analysis features ↓Production Order Analysis screenshots
Real screens from Production Order Analysis in Business Central, shown with demo data.
Production Order Analysis features
- Actual and expected cost comparisonSee actual against expected cost on production orders, with the variance calculated for you.
- Consumption and capacity cost detailBreak costs down into material, labor, and subcontracting to see what drove a variance.
- Sales margin calculationCalculate the sales margin automatically when the production order is linked to a sales order.
- Single worksheetReview the cost detail for production orders in one worksheet instead of several reports.
- Cost at each stageSee expected and actual cost for each component and work center on the order.
- Budget controlLine up expected and actual cost to catch overruns and keep production within budget.
- Analysis across production ordersReview and compare costs across multiple production orders.
- Configurable summariesChoose which summaries to show: units, actual costs, expected costs, cost variances, and sales margins.
Requirements and licensing
Comes with the Enhanced Planning Pack
Production Order Analysis is currently available only as part of the Enhanced Planning Pack, a subscription licensed per company.
Business Central license
Users who work with production orders need a full user license on the Business Central Premium tier, the tier that includes production orders. People who only view the results can use a Team Member license.
Cloud or on-premises
Production Order Analysis runs on Business Central online and on-premises.
Posted entries
Figures come from posted consumption, output, and capacity entries, so the analysis is as current as your last posting. Variance is final once the order is finished and cost adjustment has run. Costs are reported in your local (default) currency.
Sales order link for margin
The sales margin appears only when the production order is linked to a sales order, as in make-to-order production. There is no margin for make-to-stock orders with no sales link, or for assembly orders.
GET A QUOTE
Your Microsoft Partner prepares a quote for your setup.
App details and prerequisites
- Business Central
- Cloud and on-premises
- Insight Works license
- Per company, subscription, as part of the Enhanced Planning Pack
- Business Central license
- Full user license (Premium tier); Team Member to view results
- Languages
- English
- Availability
- All countries where Business Central is available
Questions about Production Order Analysis?
Ready to plan a rollout? Contact your Microsoft Partner. For product questions, send us a note and the Production Order Analysis team will reply by email. Scoping Production Order Analysis for a project? Book a Q&A session with the product manager.





