Inventory Forecasting

Benchmark, forecast, and optimise your inventory with precision.

The Inventory Forecasting helps you monitor sales trends, plan future stock levels, and ensure product availability aligns with your revenue goals. This tool is designed to give inventory teams and planners a full view of both historical sales and forward-looking stock needs.

Sales & Target Overview 

At the top of the dashboard, you’ll see a bar chart comparing your Sales History (blue) against your Sales Target (grey). This high-level visual shows how you're performing month-over-month and helps track progress toward revenue goals.

Click Target Settings (top right) to adjust your sales goal assumptions.

You can:

• Set a Target Growth % to project future sales based on historical patterns
• Define a Minimum Target Sales threshold per month
• Adjust monthly targets individually for more granular control

Once saved, these targets feed directly into the forecast model and visualisation chart.

Forecast Table (Product-Level Detail)

The lower half of the dashboard shows inventory forecast data at the product level. Here, you can monitor stock status and recommended actions across all SKUs.

Tabs include:

• Stock Out – Items with no stock in the inventory
• Risk – Products at risk of going out of stock
• Healthy – Balanced stock with sufficient coverage
• Excess – Items with more stock than needed based on forecast

Each product row includes:

Click Forecast Settings (above the table) to adjust the logic used in forecasting.

You can define:

• Forecast Horizon – How far ahead to project (e.g. 90 days)
• Average Lead Days – Time between placing an order and receiving stock
• Excess Threshold – Number of days of cover at which stock is considered excessive
• Minimum Units to Buy – Suggested order floor for stockouts
• Product Inclusion – Optionally exclude Gift Cards or inactive products

This allows you to refine your forecast and tailor inventory recommendations to your operational workflow.

Grouped Inventory View

Monitor inventory by product style or collection—not just by individual SKUs or variants.

The Grouped tab in the Inventory Forecast Dashboard allows you to view inventory and forecast data at the product group level, making it easier for teams managing multi-variant products (e.g. fashion or jewellery) to see the bigger picture.

When you click on a product from the Grouped view — the table expands to show all individual variants (SKUs) under that group. This helps you analyse variant-level performance within a larger product family.

When you click in a product you are able to view both the performance and future demand requirements across multiple locations. 

You can analyse: 

• Sell Through Rate: Indicates how much of your available stock has been sold within the period, helping to measure product performance.

• Out of Stock Date: The estimated date when this product is projected to run out based on current sales velocity.

• Weeks of Cover: Shows how many weeks of stock you have left at the current rate of sales.

• Days of Cover: Reflects how many days the current inventory will last before depleting.

• Overstocked Rate: Highlights the proportion of stock that is exceeding demand, signalling potential overbuying.

• Stock to Sales Ratio: Represents the balance between inventory levels and sales volume to assess stock efficiency.

• True Rate of Sales: Measures the average rate at which units are selling, adjusted for stockouts and availability.

• Unit Cost: Displays the cost to the business for each unit of the product, used to calculate margins and profitability.

• Gross Profit: Reflects the total profit earned from sales after deducting the cost of goods sold.

• Gross Margin: Shows the percentage of revenue that remains after covering the product cost, indicating pricing efficiency.

• Trend (Quantity): Tracks whether the number of units sold is increasing, stable, or declining over time.

• Trend (Gross Sales): Monitors the direction of gross revenue from the product over time.

• Avg Quantity per Month: Represents the average number of units sold monthly, useful for forecasting and planning.

• Revenue Concentration: Shows how dependent your total revenue is on this single SKU.

• Class (Gross Profit): Categorises the product based on its total gross profit contribution, helping prioritise investment.

• Class (Gross Sales): Categorises the product by its total sales value, indicating its role in overall revenue.

You can action: 

• Reorder strong sellers or mark down slow movers based on predicted demand.

• Time reorders or pause ads to avoid going out of stock.

• Promote overstocked items to clear inventory and unlock cash.

• Align ad spend with how long inventory is projected to last.

• Identify and act on products where stock exceeds demand.

• Flag inefficient inventory holding and adjust future buys accordingly.

• Forecast demand more accurately by correcting for stockouts.

• Evaluate pricing and margin strategy based on unit costs.

• Prioritise high-profit products in marketing and reordering.

• Promote products with healthy margins to improve profitability.

• Increase stock or ad investment in SKUs showing sales growth.

• Double down on products with rising revenue momentum.

• Base future orders on stable monthly sales performance.

• Reduce over-reliance on any single product for revenue.

• Focus on top-performing SKUs and review underperformers.

• Balance volume drivers with margin to ensure overall profitability.