Using Sell-Thru for Decision-Making
Thursday, February 2, 2017 at 3:50PM Sell-Thru is a key performance indicator for vendors and retailers alike. It allows you to understand the rate at which inventory is being consumed as it relates to sales. Because sell-thru is a leading indicator, it is also very useful for predictive analysis.
When calculating sell-thru, careful consideration should be given to how the formula is constructed. As with any business metric, there is more than one possible answer, but only one is correct in terms of meeting the business user's needs.
So ask yourself: what is the difference between calculating sell-thru using all available weeks of sales and inventory data as opposed to using the most recent 4 weeks of data? Both methods are valid, although they may produce very different results. The first method will tend to flatten out fluctuations due to promotions. This is useful if the item is on replenishment and operates within established min/max guidelines. The second method of calculating sell-thru, using the most recent 4 weeks of data, tends to provide a rolling snapshot of performance. This is very useful if an item is highly promoted and you want to understand the impact of lift within a given promotional window.
Both methods are correct, but one will be more useful than the other to the decision makers at your organization. Here are three best practices to make sure your team arrives at the most useful method:
1) Have simple design sessions with business users to write out on a whiteboard all calculations.
2) Discuss if the calculation supports the intended business decision.
3) Adjust the formula accordingly.
4) Identify low, middle, and upper performance conditions for each metric so exception dashboards can be created.
5) Document your work in a place all team members can access so there is no confusion on how the calculation is performed, or how the performance conditions are aligned.
Interested to know how your sell-thru percentages compare to our benchmark data? The Accelerated Analytics research team has compiled the average sell-thru percentage for eight retail categories each at 8, 13, 26 and 52 weeks and put it all together in our Sell-Thru Benchmark Data Infographic. To request the infographic simply complete the form below and it will be e-mailed to you right away!