Project: Highstreet Retailer

Automating Inventory Levels

Understanding the size of potential inventory benefits is key to making informed decisions

Unlocking staff bandwidth for making higher value decisions

We worked with a UK-wide retailer to help them understand what could be achieved through automating the setting of stock levels, and how this new way of working could be implemented across their business.

Opportunity to reduce excess stock

With products held in stock across circa 200 shopfronts, there was significant opportunity to both reduce the amount of cash tied up in stock where there was excess stock, whilst also increasing stock holding for lines where insufficient stock was being held.

However, if set-up wrong, the impact on the business could be huge. Therefore, identifying a suitable forecasting algorithm that met the specific requirements of the business before making widespread and systematic changes was important.

Trym built a tool to test stock level recommendations based on a number of inputs and calculations. This allowed our client to also carry out an initial trial across a selection of shopfronts to monitor the impact of the calculated inventory levels. This meant that the algorithm could be further improved to capture specific product nuances.

With the inventory levels calculation scoped out, a decision on the best software solution could then be made… In the short term, the Trym model was developed and automated, to support business requirements. In parallel, the specification of the model was used to produce a system specification for the existing ERP.

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

Decision Analytics

Using historic, current, and predictive data to inform and provide businesses with confidence in their decisions.

Check out this service if:

You want to clarify decisions with data.

You want to better understand how to define success.

You are interested in analysing new KPIs.

You want fresh insights into difficult challenges.

Inventory Optimisation

Using your latest operating data and simulation, we can refresh inventory levels to better suit your business needs.

Check out this service if:

You want to outsource your inventory strategy.

Know that your 'min-max' levels are not optimal.

Have gone through a period of change or growth.

You want to free up cash tied up in stock.

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