How many SKUs should a firm offer?
Alejandro Serrano – . Apr 2012 | Spain
Herbert Hainer, CEO of Adidas AG, announced last Saturday* that the company has plans to cut 25% of its 46,897 SKUs. An argument used by Mr. Hainer to justify their decision is that 20% of the current assortment generates 80% of sales.
If this roughly is the case–which should not be surprising, according to Pareto’s law, it means that 80% of the assortment accounts for 20% of sales. And most likely, within the remaining 80% SKUs, Pareto’s law still holds, i.e., 80% of that 80% account for 20% of the remaining 20% of sales, and so on and so for. Working in this fashion we can prepare the following table for how much the SKUs with the least sales sell.
How much SKUs with the least seales sell according to Pareto's Law
As the last row shows, cutting SKUs by 25% means removing those items that contribute to 0.006% of sales, or $1.2m, since Adidas sells roughly $18b. Remarkably, those 12,294 items only sell $83 (roughly 1 unit) on average worldwide! Therefore, it makes a lot of sense to remove them from the assortment.
The natural question to ask at this point is why pruning 25% of the items and not more. Should Adidas also remove the second-to-last row items (15,367 SKUs!), which sell $400 on average worldwide? What about the third-to-last row?
These question nicely illustrates the usual trade-off between Marketing and Supply Chain departments in the retailing industry. A marketing-driven organization, like Adidas, argues that adding an SKU to the assortment increases sales. The more variety offered, the higher the chances that the customer likes whatever is on the shelf thus the probability of making one additional sale. The penalty to pay is in the form of, mainly, inventory holding cost and ordering cost. In good times (Adidas increased sales by 10% last year) this penalty tends to be underestimated.
Source: http://www.adidas.de
Indeed there is no clear answer to the question posed above, but we can have a look at other industries to shed some light on the issue. For instance, in the telecommunication telephone manufacturing industry, Apple sells only 2 SKUs (i-phone 4, either black or white), whilst Nokia sells at least one model for each market segment (for instance, it sells 37 different models only in Germany). Other successful companies have followed the same trend of reducing the number of SKUs to focus on reducing supply chain costs. Good examples include Lidl in Germany or Mercadona in Spain.
A holistic view of the company is necessary to make sound decisions when answering the question of ow many SKUs in the assortment are needed. Supply chain costs should be carefully pondered before blindly following the advice of marketing experts.
(*) Frankfurter Allgemeine Zeitung. The link to the piece of news is here (in German)
To know more about Supply Chain www.zlc.edu.es
Blog de Alejandro Serrano 