Project: Retail & E-commerce

Strategy to deliver expanding product range

Using analytics to deliver an increased range and volume through the existing footprint

UK

8-weeks

Developing a tool to dynamically manage storage solutions

Our client had operated a General Merchandise warehouse for the whole of its grocery estate for a number of years. As both sales volumes and product range grew, the facility became under ever greater pressure.

A challenge of two halves

The initial requirement was to break the challenge into two halves:  Storage and Pick Locations. 

In the case of storage, given a stock target (and likely breach of this stock holding target!), we had to answer how much storage space was required for the increased range, and therefore what combination of storage locations were required. In this particular case, finding specific storage space was not a significant challenge.

However, the other half of the challenge, Pick Locations, was far more challenging. The initial calculation of number and size of locations was easy, based on forecast volumes, sku dimensions and the range of storage locations we had or could create. What made the answer harder to deliver was the requirement to manage these locations as sales volumes changed, and also combine this with the picking routes that the operational team wished to follow, to minimise the distance travelled.

Creating a toolkit

Through a combination of modelling, heat maps showing where the pickers would be walking, and simulating the overall storage requirements week by week, a modelling toolkit was built that allowed the site to manage their storage locations on an on-going basis.

As independent consultants, we bring a fresh perspective to your warehouse and supply chain challenges.

Contact us

Enhance your supply chain with data-driven strategies tailored to your business. Reach out today to explore how we can help you reduce costs, improve efficiency, and achieve measurable results.

Ashleigh Monks

Ashleigh Monks

Supply Chain & Data Consultant

Related Services

Capacity Modelling

Building models from existing data makes it possible to prepare your supply chain for future scenarios.

Check out this service if:

You want to prepare your supply chain for the future.

You want to understand the impact of sustained growth or an acquisition on your supply chain.

Your warehouse is reaching its capacity.

You want to improve delivery performance.

Demand Planning

Demand forecasting is a critical business requirement to support a range of business functions.

Check out this service if:

You want to free up cash held in excess stock.

You want to improve product availability.

Your business has a seasonal demand.

Your procurement team wants to stop 'fire fighting'.

We are independent supply chain and warehouse consultants who specialise in data analysis, leading strategy, and bringing a fresh perspective to your supply chain challenges.

© Trym Consulting