Top-down forecasting? Bottom-up forecasting? How is someone with an eCommerce site supposed to know which one to use?

There are specific instances when one is better than the other. Let’s examine which situations call for bottom-up forecasting, and which ones require top-down.

Bottom-up forecasting

Bottom-up forecasting determines the trends and forecasts for each individual variant and then adds up the demand for each of those variants. It takes the very bottom layer and the most granular look at the information and then adds up all the trends.

Here the forecast for SKU-1 is calculated, then the forecast is calculated for SKU-2, and so on. After all of these are forecast, the aggregate demand is your total bottom-up forecast.  This is appropriate when SKU-1 and SKU-2 have different forecasts due to seasonality or other attributes.

Top-down forecasting

By contrast, top-down looks at the same category (or vendor, product, or other grouping). Say your site sells clothing. One particular dress contributed 2% of the revenue in the dress category in the past. A top-down forecast means that because it has been contributing 2% to the category, you will forecast it as continuing to contribute 2% to all dresses sold.

Past performance indicates future performance; however, it does not mean, for example, if you sold 500 dresses in the past that you are going to continue to sell 500 units. Top-down forecasting follows the trends of the categories (in this case, dresses). You normally don’t sell as many dresses in the winter, so if you are looking at that 2% of category revenue, it is 2% of a smaller number.

Top-down is good for products that are seasonal but that do not have a long of sales history. This is especially applicable to the fashion industry where new styles roll out all the time, but you didn’t have those items in stock a year ago. To forecast demand for a seasonal item like a dress, you know how the dress’s category performs, so with a little bit of sales data for that particular dress, you can continue to look at replenishment needs moving forward.

For Inventory Planner Users:

Account-wide top-down forecasting

Just a few clicks in Inventory Planner will allow you to use top-down forecasting for your eCommerce site. To enable top-down forecasting store-wide, go to Account > Settings

Forecasting and enable Use top-down forecasting setting.

Top-down by category, vendor, or total

To override the bottom-up forecast (forecasting for each SKU, then summing those forecasts to the product, category, vendor or total), go to Edit Forecast.

Then select Top-Down by Product, Vendor, Category, or Total.

If you will have higher demand (for example due to promotions or new sales efforts such as trade shows), enter an override in number of units as seen here for May 2019.

Then Save Changes to implement this override.

The increase (or decrease) indicated in the override will scale proportionally to all associated variants. For example, if the original forecast is 500 units, then the override is 750 units, all associated, replenishable variants will see a 150% increase to the forecasted demand for that month.

Ann
June 10, 2019