Average Usage Calculation for Microsoft Dynamics 365 Business Central
Reorder points and safety stock are only as good as the usage they are based on. In many companies they were set years ago, and nobody can easily see whether they still match how fast items actually move.
Item Planning Review calculates average inventory usage for each item over a period and date range you choose in Microsoft Dynamics 365 Business Central, and shows it next to the item's planning parameters.
How Average Usage Calculation works in Item Planning Review
- The planner opens Item Planning Review and sets the period, start date, and end date.
- The planner narrows the items with filters, such as item category or location.
- The planner chooses Generate, and Item Planning Review calculates average usage for each item.
- The planner compares average usage with the current planning parameters and adjusts them on the same page.
Key capabilities
Period and date range
Choose a period, such as weekly, and a start and end date. A period summary shows how many periods the range covers, for example 14 weeks.
Usage, not only sales
By default, usage counts assembly consumption, assembly output, consumption, output, negative adjustments, and sales, so an item consumed in production shows its real demand.
Generate for many items
The Generate action calculates average usage for every item that matches the filter settings, one row per item.
Based on posted history
Average usage comes from posted item ledger entries, so the result reflects what actually happened in the chosen range.
Feeds the calculated values
Average usage is a variable in the calculation expressions that suggest safety stock, reorder point, reorder quantity, and maximum inventory.
See Average Usage Calculation on screen
Real screens from Item Planning Review, shown with demo data.
Details that matter on the floor
Looks back, by design
Item Planning Review shows what usage actually was and leaves the decision to the planner. It is a tool for teams that want better planning parameters without running a forecast.
History length matters
A short date range or a new item gives an average that should not be trusted. Choose a range with enough posted history for the item.
Who uses Average Usage Calculation
Inventory managers
Check whether reorder points still match how fast items move.
Production planners
See usage that includes consumption and output for manufactured and component items.
Purchasing managers
Use real usage to judge order quantities.
Questions about Average Usage Calculation
How do I calculate average item usage in Business Central?
With Item Planning Review, choose a period and a start and end date, set any filters, and choose Generate. Item Planning Review calculates average usage for each item from posted item ledger entries and shows it beside the item's planning parameters.
Is usage the same as sales?
No. By default, usage includes assembly consumption, assembly output, consumption, output, and negative adjustments as well as sales. You can change which entry types count on the setup page.
Does Item Planning Review forecast demand?
No. Item Planning Review looks at actual past usage. For a forecast from Microsoft's Azure AI forecasting model, see Enhanced Forecasting Worksheet, another app in Enhanced Planning Pack.
How much history do I need?
Enough posted history in the chosen period to give a reliable average. A short period or a new item gives an average that should be treated with care.
Related Item Planning Review features
All Item Planning Review features →Part of Item Planning Review
Optimize inventory management by streamlining reorder planning, minimizing costs, and enhancing accuracy.
Have a question about Average Usage Calculation?
Send us a note and the Item Planning Review team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
