ElyxAI

Excel for demand planners: units by SKU, not revenue

The demand planner workbook on this page is the list you open when you need units, not money. One row is one SKU for the period you are planning. You type three history periods in units, a seasonality factor, and the stock on hand. The forecast is either a unit figure you already trust, or the average of those three periods times the factor. The gap is stock minus that forecast. This file is not a sales revenue forecast. A sales rep forecast and a financial analyst forecast answer how much revenue might land. They can sit next to prices. This sheet has no price column that the formulas read. A seasonality factor of 1.2 means 20 percent more units than the average, not 20 percent more revenue. The guide below builds that unit list. Elyx writes the forecast, the gap, and the short flag in the workbook you already keep. You still type the history and the stock. The trial lasts 7 days, with no card.

1 workflows

Frequently asked questions

What is on a demand planner sheet?

One row per SKU: three history periods in units, an optional statistical unit forecast, a seasonality factor, stock on hand, and a short flag.

Is this a sales forecast?

No. Sales rep and financial analyst forecasting pages are about revenue. This sheet never multiplies units by a price.

Who types the seasonality?

You do. A factor of 1 leaves the average unchanged. The sheet does not invent a season.

Essential
Popular