I’ve had a couple of conversations in the past few weeks which have ultimately all come back to the importance of optimisation of stock flow through the retail supply chain. It is of course a balancing act – trading off the benefit of reduced logistics and transport overheads of in return for the risk of infrequent replenishment orders of higher quantities vs. high cost of distribution but the benefit of accurate, frequent replenishment. Of course the answer is potentially different for every SKU-store combination in a retail business!
Trade off: Mark down to clear OR rebalance stock, avoiding maldistribution, increase full price sell through and reduce lost sales?
I think it is pretty reasonable to assume that no matter what effort you put into your forecasting and replenishment your customers won’t buy to plan!! This means than towards the end of a season / before a range refresh not all SKUs will have an ideal distribution of stock across all stores ranged. If you’ve already allocated out remaining stock from DC then there are only 2 things you can do, both dependent on first undertaking analysis of the SKU-store stock levels vs. SKU-store forecast sale rates to understand the likely cost implications of either action:
- Mark the item down across the chain to encourage sell through of pockets of stock BUT acknowledging you will be losing margin due to mark down spend and impacting availability in some stores where there are no overstocks.
- Rebalance stock (taking from overstocked stores and replenishing those who would sell out), mindful of the operational overhead of physically moving the stock to locations where it will sell at full price.
Don’t under estimate the value of knowing more about your business… detailed data insights deliver increased profitability
The above actions both depend on someone undertaking analysis of the SKU-store stock levels vs. SKU-store forecast sale rates in order to give you appropriate information upon which to base the decision as to which action is most profitable.
To be honest this is usually an onerous exercise that no one really has time for. Of course then without this information retailers will implement action 1 (the only action you could do without the SKU-store detail) – potentially losing a massive amount of margin unnecessarily.
Supply chain optimisation data analytics, insights and actions that increase availability and improve margin!
If you don’t have the time but want some help with getting into the data and the detail, (and here comes the shameless plug… :-)) my team at Retail Acumen can support you.
Lately we’ve been building client specific data models, reports and analytics to enable clients to not only have 1-off insights for a specific supply chain project but also to allow them to call on us whenever they need to repeat a process e.g. end of season stock rebalancing.
In our experience using a backhaul approach to uplifting of surplus stock from a handful of stores, returning that to DC and redistributing it out again on the next replenishment run adds only a very marginal increase in logistics and supply chain costs compared to a considerable reduction in mark down spend.
If you’d like to find out more, give me a call, I’m proud that the team have been recently called “data junkies” and I know that they’ll really enjoy delving into the detail to find some great benefits for you too!