How to Pick Merchandise Planning Attributes

May 10, 2021

Picking the right attributes for top down planning is as much an art as it is a science. Here is a quick guide on how to approach it.

Overview

For top down planning, your organization needs to determine the attributes to use. Given the high number of attributes that you will already be using for slicing and dicing reports, figuring out which attributes to use for top down planning can be a challenge.

Getting the list of top down planning attributes right is critical and will impact both the guidance top-down planning can provide and the level of effort it will require. Planning attributes should be granular enough that each combination of attributes yields distinct forecasting and reporting behaviors, but not too granular that the combination becomes unwieldy. At the end of the day, there is a reason why top-down planning is separate from bottom-up planning which is the most granular level of planning possible.

Below are some quick guidelines on how to figure out which planning attributes to pick for your business.

Number of planning attributes to pick

The ideal number of planning attributes will depend on the size and complexity of your business, and the size of your planning team. At Toolio, we recommend to maximum 7-8 planning attributes, as too many attributes will make top-down planning unwieldy. For smaller teams, with 1 or 2 planners, we recommend limiting the number of planning attributes to 4 or 5.

After selecting planning attributes, you should look at the number of choices (i.e. style / color combinations) and the size of the topline sales that fall into each combination.

To warrant the time you will spend with top-down planning, the choices falling into each combination should rarely be less than 25 and / or $500K in terms of the topline business. Of course, these are high level guidelines and there could be exceptions. Below is a set of criteria to use while deciding whether or not your selection of planning attributes is sound.

Criteria to use while selecting planning attributes

There are many criteria to use while selecting the planning attributes. Here are the characteristics of well designed planning attributes:

Orthogonal

When planning attributes are selected well, the combination of attributes yields a different set of characteristics such as:

  • Sales Seasonality
  • Margin
  • Inventory Productivity targets

Specifically, if the planning attributes are selected wisely, planning each one of them will feel like planning for a different type of business with different characteristics.

For example, let’s say that our planning attributes are Department, Class, Channel and Sales Type. Planning for Mens / Outerwear / Retail / Full Price will feel very different than planning Womens / Tops / Wholesale / Full Price, since seasonality, margin and turn targets will be very different between the two plans.

Consistency

Values of good planning attributes should not change over time. Consistency will make it easier for you to refer to your historical plans while planning the current seasons and improve your ability to forecast and understand trends.

Retail is a dynamic business, and how you look at the business will naturally over time; however, if you have selected your planning attributes well, these will not be changing much over time.

For example, style name or fabric type rarely make good candidates for top down planning attributes, since these will change a lot over time. However, channel or seasonality would be great candidates, since these will likely be consistent over time.

Granularity

Select the planning attributes such that roughly 25 choices will fall into each combination of planning attributes. This way top-down planning will be a good guide to drive your assortment planning and item planning processes, without being too loose or restrictive.

Naturally, there will always be some product categories, e.g. gift cards or a new line of business that you might be getting into, that will not neatly fall into the 25 choices per combination approach.

Suggested planning attributes

A typical approach to planning attribute selection is to use a few attributes to capture merchandise hierarchy (e.g. division, department, class), seasonality (e.g. Core vs. Seasonal), channel (e.g. Retail vs. Wholesale) and sale type (full price vs. markdown).

Here is what this selection would look like in action:

  • Division: Mens, Womens, Kids
  • Department: Clothing, Footwear, Accessories
  • Class: Outerwear, Tops, Sneakers, Sandals, Bags, Watches
  • Seasonality: Core, Seasonal
  • Channel: Ecomm, Retail, Wholesale
  • Sales Type: Full Price, Markdown
Eytan Daniyalzade
CEO & Co Founder
Kristen Henry
Head of Customer Success