Purpose
The Inventory Forecast dashboard provides insights into inventory levels and storage capacity, enabling informed procurement decisions to optimize stock and prevent overstock or stockouts.
This dashboard honors user restrictions based on Product Location.
Details
Filters include Fiscal Year, Fiscal Month, Transaction Selection, Department ID/Name, Product ID/Name, Location ID/Name, Product Classification Name, Product Manufacturer, Active Ingredient, and Region.
Choosing the Fiscal Month range and Fiscal Year will include inventory from the selected months in the current fiscal year and forecast values from the selected Fiscal Year.
- PY Sales – Total sales achieved during the same period last year.
- Quantity Forecasted – Projected number of units expected to be sold in the future as predicted by a forecasting tool.
- Amount on Hand – Represents actual physical inventory or stock currently available in the warehouse or storage ready to be sold.
- Qty Ordered – Number of units a company has already committed to buying from suppliers but has not yet received.
- Qty Committed – Total number of units Customers have committed to purchase but not yet fulfilled.
- Qty Available – Total number of units available to meet future demand after accounting for current stock, incoming orders, and pending commitments.
Amount on Hand + Qty Ordered - Qty Committed - Forecast Remaining – Amount of future demand that still needs to be fulfilled after accounting for sales made in the selected range and quantity committed to sell.
Quantity Forecasted - Sales in selected range - Qty Committed - Forecast Position – Shows whether there is a surplus or deficit of stock to meet the forecasted demand after accounting for current availability and remaining forecasted sales.
Qty Available - Forecast Remaining
