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.
Now onboarding companies in Dhaka.
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 forecastPast 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
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.
01
Past useWhat you actually used
Monthly issues for each item, taken from the stock movements already recorded.
02
ForecastWhat you will probably need
The trend is projected forward for the next three months, so seasonal growth is not missed.
03
CoverHow 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
- Items / Products
Reorder points and units.
- Stock Movements
The history the forecast is built on.
After the forecast
- Purchase Requisitions
Raise a requisition for what is short.
- Purchase Orders
Order directly if the need is clear.
Where it shows up
- Inventory Summary
Stock value and turnover.
- Supply Chain Overview
Open requisitions at a glance.
- Financial Reports
Purchasing in your statements.
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.
PP granules use has risen for five months running.
The forecast for December is 51 tonnes.
On-hand stock covers 15 days, so the item shows order now.
A requisition is raised for the shortfall.
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
- Retail
Stock by season and sales trend.
- Food & Hospitality
Ingredients and supplies by weekly use.
- Real Estate
Materials by project phase.
- Consulting
Consumables by headcount.
- Manufacturing
Raw material and packing by production plan.
- Health & Fitness
Consumables and retail items by usage.
- Trades
Parts by job volume.
- Others
Supplies by programme calendar.
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.