Merchant Sheets logo showing text and grid document
graphic representation of the Merchant Sheets Inventory Forecasting template
screenshot of the inventory forecasting template from Merchant Sheets.
screenshot of the inventory forecasting template from Merchant Sheets.
screenshot of the inventory forecasting template from Merchant Sheets.
graphic representation of the Merchant Sheets Inventory Forecasting template
screenshot of the inventory forecasting template from Merchant Sheets.
screenshot of the inventory forecasting template from Merchant Sheets.
screenshot of the inventory forecasting template from Merchant Sheets.

Inventory Forecasting

$99

Inventory Forecasting projects 12 months of unit demand per SKU from your trailing 12-month history and a seasonality index. It assigns ABC tier and service level by tier, then calculates safety stock, reorder point, expected stockout date, and recommended PO date and quantity. Formula-only, so it runs identically in Excel and Google Sheets.

✓

Works in Excel & Google Sheets

Template includes both versions. One price, no add-ons.

Save 67%

Skip to the Full Library

All 20 templates in one purchase, with lifetime updates and every new release included.

See bundles

How it works

The forecast builds in stages: history feeds seasonality, seasonality feeds the forward forecast, and the forecast drives every reorder recommendation.

  1. Items: Confirm or replace the SKU master: cost, price, lead time, MOQ, reorder quantity
  2. History: Paste 12 months of unit sales per SKU. Operator entry
  3. Seasonality: Per-SKU monthly indices, with a category-level fallback for SKUs with sparse history
  4. Forecast: The catalog table. ABC tier, baseline demand, seasonality-adjusted forecast, safety stock, reorder point, and PO date and quantity per SKU
  5. SKU Dashboard: Pick any SKU from the dropdown for a single-product deep dive
  6. Dashboard: Catalog-wide KPIs and the next 30/60/90 day reorder queue

Steps to use it

  1. Confirm your SKU master on Items
  2. Paste 12 months of unit sales per SKU into History
  3. Review Seasonality for auto-computed indices and low-confidence flags
  4. Open Forecast for ABC tier, safety stock, reorder point, and PO recommendations per SKU
  5. Use SKU Dashboard to drill into any single product
  6. Check Dashboard for catalog-wide KPIs and the upcoming reorder queue

ABC tiers are revenue-based: A is the top 20% of SKUs, B the next 30%, C the bottom 50%, each carrying a different service level (A 98%, B 95%, C 90%) that drives how much safety stock it holds.