Skip to content
Item Planning Review app iconItem Planning ReviewReview

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

  1. The planner opens Item Planning Review and sets the period, start date, and end date.
  2. The planner narrows the items with filters, such as item category or location.
  3. The planner chooses Generate, and Item Planning Review calculates average usage for each item.
  4. 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.

Item Planning Review app icon

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.

Ask a product question

Product Questions