Inventory Demand Forecast

Demand forecast: reorder when the numbers say so, not when the shelf is empty

Adon ERP looks at how much of each item you used in past months, projects the next three, and compares that with what is on hand. The items running out first are at the top, with an estimate of what ordering them will cost.

See how cover is worked out

Now onboarding companies in Dhaka.

AdonERP
Nodi Polymer Industries

Inventory / Demand Forecast

Demand forecast

Forecast accuracy

91%

last 6 months

Items to reorder now

2

under 20 days of cover

Forecast horizon

90 days

next three months

Estimated order value

BDT 31,87,600

for items to reorder now

PP granules, monthly use (tonnes)

actual forecast
38Jun
41Jul
44Aug
43Sep
47Oct
48Nov
51Dec
53Jan
50Feb

Past use is solid. The dashed bars are the next three months, projected from the trend.

Days of cover

  • PP granules15 daysorder now
  • White masterbatch35 daysok
  • Black masterbatch15 daysorder now
  • Carton box 5-ply27 dayssoon
  • Flexo ink cyan36 daysok
A partial preview of Demand Forecast in Adon ERP. Company and figures are sample data.

From past use to a reorder list, in three steps

The method is deliberately plain, so a store keeper can check it with a pencil.

  1. 01

    Past use

    What you actually used

    Monthly issues for each item, taken from the stock movements already recorded.

  2. 02

    Forecast

    What you will probably need

    The trend is projected forward for the next three months, so seasonal growth is not missed.

  3. 03

    Cover

    How long the stock lasts

    On-hand stock divided by the forecast use gives days of cover. Under 20 days is order now, under 30 is soon.

What the page shows

Accuracy
How close past forecasts came to real use.
Items to reorder
How many are under 20 days of cover.
The chart
Past use as solid bars, forecast as dashed bars.
Days of cover
A bar for each item, with a marker at 30 days.
Estimated order value
Shortfall times the last rate, for the items to reorder now.

A forecast turns stock history into a buying plan

It reads what was issued, and it ends in a requisition.

Before the forecast

After the forecast

Where it shows up

Forecasting for long lead times

Raw material from abroad takes weeks, and a missed reorder stops a line. Cover in days is the number a plant manager can act on.

  • Cover, not just quantity

    Two thousand kilos is a lot or a little depending on use.

  • Lead time in mind

    Items with short cover and long lead time are the first to see.

  • Seasonal demand

    Eid and export peaks show up in the trend.

  • An order value

    Finance sees what the reorder will cost before it is raised.

One forecast, from trend to requisition

A sample raw material review, the way it usually runs.

  1. PP granules use has risen for five months running.

  2. The forecast for December is 51 tonnes.

  3. On-hand stock covers 15 days, so the item shows order now.

  4. A requisition is raised for the shortfall.

  5. The goods arrive before the stock runs out.

Questions we get about demand forecast

How is demand forecast?

From past monthly use of each item, projected forward as a trend.

What is days of cover?

How many days the stock on hand will last at the forecast rate.

When does an item show order now?

When it has under 20 days of cover.

Does it raise orders by itself?

No. It shows what to reorder, and you raise a requisition.

How far ahead does it look?

Ninety days.

Where is Adon ERP available?

We are currently onboarding companies in Dhaka. Book a demo and we will walk through it with sample data.

How different trades use the demand forecast

Bring your top ten items and last year’s use. We will forecast them in the demo.

A live demo in English or Bangla, using sample books close to your own trade, with time for your accountant’s questions.

Explore Inventory