Demand forecasting and inventory planning features

Demand forecasting by SKU

Varox builds a monthly quantity forecast for every SKU over the horizon you choose, and a revenue forecast from the quantity and the recent average selling price. Automatic model selection picks a base method per SKU from the shape of its history:

• Stable history gets a statistical model with level, trend, outlier handling, and a per-SKU seasonality factor for each month.
• Short history (under about twelve months) borrows its level and seasonal shape from a parent group such as brand, vendor, or category, scaled to the SKU's own recent sales.
• Inactive SKUs stay near zero instead of inventing demand.

Forecasts roll up by category, supplier, brand, or sales channel when those fields exist in your data, so you can review seasonality at business-unit level and then drill into the SKUs behind it. Each forecast shows which model produced it.

Related: why demand planning matters and how much safety stock a forecast error needs.

Replenishment and delivery planning

The Delivery Planner takes the saved forecast and the latest stock on hand and walks each SKU's warehouse balance forward month by month. When projected stock would fall below next month's demand plus the safety buffer, it plans a delivery sized to close the gap and keeps going.

• Safety stock per ABCD class, set as months of average demand, so fast movers and long-tail items get different buffers.
• Lead time in days, which moves each delivery to the month it actually arrives.
• Delivery coverage, the look-ahead window used to size each order.
• Pack-size rounding from item info, applied to the order quantity.
• Months and days of coverage for every SKU, so overstock and stockout risk are visible before you order.

Work out the numbers behind a single SKU with the free reorder point calculator and EOQ calculator.

Working capital and inventory cash flow

Working Capital turns the forecast and the delivery plan into money. It values the stock you will hold at unit cost, applies supplier payment terms to each planned delivery to show when invoices fall due, and nets supplier payables against inventory to show the working capital the plan needs each month. Sell-out and sell-in views show revenue and purchases side by side, so finance and planning look at the same numbers.

Inventory reporting

Reporting covers demand by period and level, inventory position, delivery performance, and inventory turnover by SKU and group. Every report exports to Excel (XLSX) with the same filters and aggregation you see on screen.

AI assistant for planning questions

Ask the assistant which SKUs are at risk of running out, why a forecast moved, or what a delivery plan costs, and it answers from your own forecast, stock, and plan data. It explains numbers; it does not change your plan on its own.

Data in, without an ERP project

Start with an Excel or CSV export of sales history and stock and map its columns once. Or connect a Google Sheet or a SharePoint CSV link and load it without exporting files by hand. SQL Server, Microsoft Fabric, and a custom API are set up with you on request. See all integrations.