How manufacturers can overcome years of poor data management

Driven by increasing market demand for highly personalised products, the need for manufacturers to leverage the full value of their data is greater than ever. Yet, producing smaller batches of non-standard, unique products is significantly more complex and requires data ‘on-demand’.

With the amount of information already being generated, collected and stored within their organisations, you’d expect industrial businesses to be well versed in unlocking and leveraging the value contained within their data.

However, that’s not the case – at least for large swathes of the manufacturing landscape.

CROP - Data entry digital - image courtesy of Depositphotos.

Traditionally, the data available to manufacturers was limited, manually gathered and stored in bespoke legacy systems or spreadsheets. This made the information time-consuming to access, difficult to consolidate and almost impossible to analyse in any great detail or depth.

The data was largely being used to perform tasks such as demand forecasting and production planning, and that’s not surprising.

Accurate pricing, planning and forecasting are the Holy Trinity for most manufacturing organisations, allowing them to achieve a seamless end-to-end quote, order, engineering and production process.

“There’s no easy fix for years of poor or no data management and cleansing,” explains Jon Lidbury, director of EMEA for Configure One, a world-leader in CPQ software.

“Tools such as a configure, price, quote (CPQ) solution enable a business to view the end-to-end process and implement best practices specifically when product portfolios change from standard to more personalised offerings.”

Manufacturers must bridge legacy systems with new software. Here’s how

Accurate pricing

One of the consequences of not being able to view the end-to-end process is a tendency to misunderstand the true cost of manufacturing a product and subsequently pricing them to ensure the correct margins are achieved.

What many organisations lack is a system which defines costs and prices at a granular level, enabling sales teams and their managers to understand margins from the outset.

In turn, this enables the management team to have a clear view of the product mix and the profit of each individual product or groups of products to determine their continued viability.

Configure One CPQ is such a system.

“Configure One CPQ provides a mechanism for sales information to be quickly and easily transformed into manufacturing data,” explains Jon.

“Bills of materials, routings and production drawings can be generated and real-time visualisation of these unique products enables 2D drawings and 3D models to be automated and immediately available to manufacturing. These outputs are available 24/7 and can even be shared with customers.”

Close-up of the Engineer Holding Laptop with CAD Component digital model - image courtesy of Depositphotos.

Process control

Though the business benefits of CPQ systems have been proven, organisations are being hampered in their adoption by an over-reliance on Excel. Industry’s pervasive use of spreadsheets has been driven by the need for a ‘quick fix’ in the absence of a more controlled process and access to the right ‘tools’ for the job.

“Spreadsheets become the recognised process when used for several months to resolve, what is initially a departmental requirement or issue, but quickly turns into a company-wide process,” Jon notes.

“CPQ is a prime example of where manufacturing organisations initially consider a spreadsheet capable of solving a problem. As requirements become more complex and data needs to be more accessible throughout the organisation, the use of spreadsheets becomes a bottleneck to the process due to the maintenance, shareability and complexity required.”

An over-reliance on spreadsheets is a very difficult habit to break and takes a concerted, top-down approach to overcome. So, what advice does Jon have for how businesses can successfully wean themselves off spreadsheets for the long-term?

Data Management Business Silos Spreadsheets Digital Data Digital Transformation - Stock Image

“Defining the current state process, in terms of identifying people, processes and non-value-added tasks, is a good first step. This information can then be used to create a future state process identifying the importance of one source of the truth, ease of maintenance and the future business requirements.

“Most importantly, manufacturers must endeavour to embed a continuous improvement process and not allow non-validated systems like spreadsheets to come into use without proper consideration and validation.”

A CPQ solution built with manufacturers in mind

Configure One CPQ is a web-based solution that allows one environment to be used by as many end-users as required.

These users may be internal sales teams, order teams, engineers and management, with the added benefit of validated accessibility available to external partners and distributors.

New products and processes can be rolled out to all users simultaneously, data is stored in a centralised database so can be analysed as required by the management team, and no ‘out-of-date’ versions or price lists are being used by employees to create incorrect quotes and manufacturing data.

Click here to learn more, and request your FREE demo


The Manufacturer  has partnered with Configure One to produce a series of pieces exploring how CPQ software (configure, price, quote) has evolved to overcome the challenges modern manufacturing organisations face.

Article: Are 3D configuration tools the key to increased sales and customer delight?

Supporting Video: What exactly is real-time visual configuration?


Article: CPQ software – the aspirin to your customisation headache

Supporting Video: How manufacturers can overcome the challenges of mass customisation


Article: Your sales process is inefficient and error-prone. Here’s how to address that

Supporting Video: A simple way of reducing costs, removing errors and increasing customer satisfaction


Smart Factory Expo 2019 

Configure One will be showcasing their solutions at this year’s SMART FACTORY EXPO | 13-14 NOVEMBER | EXHIBITION CENTRE LIVERPOOL

You can find them at Stand C14 in the ‘Digital Transformation’ Zone 

They will also be speaking in the ‘Digital Transformation’ Solutions Theatre at 13:30 on 13 November 

CLICK THE BANNER BELOW TO REGISTER  👇👇👇

Smart Factory Expo 2019 - Free Pass

*All images courtesy of Depositphotos