RELEX Solutions experts discuss benefits of better inventory data

A planning solution can be a great asset in helping to optimise inventory levels and availability. But what happens if the data coming into the system is inaccurate and leaks into other areas of operations?

Mike Holmes, Solutions Consulting Manager at RELEX Solutions, and Robert Jenkins, Regional Programmer Director at RELEX Solutions explore more and discuss why identifying where there are problems in the inventory data stream can help maximise a solution’s usefulness and improve inventory management and accuracy as well.

Accurate data is vital to inventory management

As well as preventing a planning solution from performing at its best, incorrect inventory data can negatively impact other areas of operation, including store KPIs, customer availability, spoilage, and sales.

Data discrepancies aren’t restricted to negatively affecting store operations. Minor inaccuracies across a network of multiple stores all add up and can escalate into far more significant losses.

The worst-case scenario for a retailer with inaccurate inventory is financial loss from spoilage, and lost sales. Re-inputting these numbers by hand may help fix the problem but it’s time-consuming and negates the benefits of having an optimised inventory planning solution in the first place.

To avoid this, identifying where initial data collecting can go wrong is the first step.

Here are the four most common causes of inaccurate inventory data for retailers to look out for:

  1. Merchandising considerations

When products of a similar nature and appearance are placed next to each other, it’s easy for in-store staff to scan the wrong labels or count the same item multiple times when taking inventory.

Scanning these item types at the checkouts can also result in items being scanned more than once or rung up as a completely different product.

  1. Product locations

Products situated across multiple locations throughout the store can confuse inventory counts, with staff unsure whether all the products in-store have been counted.

Problems often arise when one assumes that all stock is in its proper location. A consistent unit of measurement across these different products during counting can help remove the complexity that might result in errors.

  1. Delivery timings

The timing of both stock counts and deliveries can impact the data reflected in inventory levels. A store with standard opening and closing times and delivery schedules might not have any issues. However, a 24-hour store or a store with irregular delivery hours is likely to miss inventory numbers in their morning or evening counts.

  1. Unrecorded use of stock

The internal consumption of store stock, such as in-store cafes or bakeries, needs careful documenting.

How to improve data collection and inventory accuracy

What appears as minor discrepancies in stock data can become significant problems in inventory accuracy. Implementing an effective planning solution lets retailers record when stock measurements change and evaluate key performance indicators. This in turn helps them identify scenarios where input data might be incorrect.

Investing in automated methods of maintaining stock record accuracy (such as advance shipping notices or other electronic tracking mechanisms) can help. However, they can be expensive and take a long time to implement. Once installed, retailers can analyse their inventory data to identify patterns that indicate a stock record error.

Proper retail planning can use available data to create views and alerts for users. Retailers should maintain a steady measurement of changes and inconsistencies in inventory levels to avoid the pitfalls of inventory data collection. They also need to ensure their planning system is proactive, not reactive and that their inventory plans are accurate and optimised.

More News
21 hours ago
VIPRE ranks in top five for Real-World Protection Test
VIPRE Security Group has been ranked in the top five vendors in the Real-World Protection Test, conducted by AV-Comparatives.
21 hours ago
Knightsbridge Furniture's Design & Development Manager celebrates milestone
After 13 years of service, Knightsbridge Furniture is celebrating the work of Design & Development Manager, Catherine Hawcroft.
22 hours ago
A single day working from home could save workers up to £300
According to research by Banner, a single day of home working per week could save the average person between £22.92 and £28.65 each month, or around £297.96 per year, when factoring in average commuting costs, a morning coffee, and lunch.
23 hours ago
Data breaches cost UK £4bn per year as identity fraud rises
Credas Technologies, an identity verification checks provider, has revealed that identity theft is the driving factor behind more than 28 million data breaches across the UK since 2013, breaches that cost the nation close to £4 billion each year.
1 day ago
Lexmark named 2022 MPS leader by Quocirca
Lexmark has been named a leader in Managed Print Services (MPS) by global print and market insight research firm Quocirca for the 10th consecutive year.
1 week ago
The role of tech in creating better workplace food experiences
Companies are beginning to realise how important good food is in attracting talent and creating healthy workplaces that look after their employees. A recent study revealed two-thirds of respondents believe an organisation that prioritises their health and wellbeing would make them more likely to stay in their current role, so healthy food and beverage provisions should not be overlooked.
1 week ago
Cohesity appoints new CEO and President
Cohesity, experts in next-gen data management, has announced the appointment of Sanjay Poonen as CEO and President. He will also join the Cohesity Board of Directors.
1 week ago
Dealing with loneliness when working from home
More of us are working from home than ever before. However, despite all the benefits of this new flexible way of working, there are a few downsides with the main one being loneliness with half of the remote workers reporting that they feel isolated working from home.
1 week ago
Print security challenge as pharmaceuticals move to hybrid working
Like other sectors, pharmaceuticals have embraced the benefits of hybrid working. Leaders from the biggest firms like GSK Consumer Healthcare, Pfizer, and Novartis have said the future workplace model will be flexible with more people given the choice to work from home, in the office, or a mix of both. This is according to Colin Bosher, CEO, EKM Global.
2 weeks ago
Knightsbridge invests in future growth with new machinery
Bradford-based contract furniture company, Knightsbridge Furniture, has invested in an L-Series Pathfinder fabric cutting machine, as part of several investments the company has planned for 2022/23.

Login / Sign up