Excel

22
Nov
Planner reviewing SKU-level inventory target ranges instead of one blanket stock target

How to Set Inventory Targets by SKU (Not One Number for Everything)

One inventory target for every product guarantees you hold too much of some and run out of others. Here is how to set targets by SKU in Excel.
4 min read
16
Oct
How to Build a Seasonal Forecast in Excel, Step by Step

How to Build a Seasonal Forecast in Excel, Step by Step

A moving average will always be late to a seasonal peak. A seasonal index fixes that with one extra column and an AVERAGEIFS. Here is the method, tested on two years of data.
6 min read