Demand Forecasting
Project stock risk and purchase needs from current availability and sold quantities. Filter the forecast by period, supplier, and brand, then recalculate as inventory and order data changes.
Demand Forecasting
What the forecasting module calculates
The forecasting module stores one forecasting record per product. It calculates current available quantity across inventory entries, total sold quantity, sold per day, forecasted sold quantity, forecasted purchase quantity, and forecasted available quantity.
Forecasts can be viewed for 7, 14, 30, 60, or 90 days. The UI also supports supplier and brand filters plus table sorting across the calculated metrics.
Forecasting is not an isolated report. Inventory adjustments and order processing both trigger forecasting updates, so the numbers reflect operational changes instead of requiring a separate manual export/import process.
Tracked metrics
Current available quantity
Total sold quantity
Sold per day
Forecasted sold quantity
Forecasted purchase quantity
Forecasted available quantity
How forecasting behaves in the current code
Calculated from live inventory rows
The service sums available and sold quantities across inventory entries for the product before calculating the forecast values.
Solution:
Forecasting stays connected to the same stock records used operationally.
Simple sold-per-day model
The current implementation derives sold per day from total sold quantity divided by 30. It is intentionally simple and does not yet query period-specific stock history.
Solution:
Treat the current forecast as a practical planning signal rather than an advanced statistical model.
Company-wide recalculation
Users can trigger a recalculation for the selected period from the forecasting screen, which updates forecasting data for all products in the company.
Solution:
This is useful after major purchasing or catalog changes.
Operational update hooks
Inventory adjustments and order processing both update forecasting for affected products, so the screen reacts to stock movement workflows already in the app.
Solution:
Use forecasting as a living inventory planning tool, not a static report.
What users can do in the forecasting screen
Switch forecast horizon
The controller accepts 7, 14, 30, 60, and 90-day periods and rejects unsupported values by falling back to 30 days.
Filter by supplier and brand
Forecast entries can be narrowed by supplier or brand, which is useful when buyers want to plan one vendor or assortment slice at a time.
Sort by forecast metrics
The table supports sorting by product name, SKU, sold per day, forecasted sold, current available, ordered quantity, forecasted purchase quantity, and forecasted available quantity.
Spot shortages visually
Forecasted purchase quantity is emphasized when replenishment is needed, and forecasted available quantity changes color for positive, zero, and negative outcomes.
Need replenishment planning tied to live stock data?
Use Indexed PIM forecasting to identify what will be short, how much to buy, and which supplier or brand group needs attention first.