One of our longest-running projects, still in use 15 years after launch
Volkswagen Group UK | Automates Annual Stock Count with Management Software
Project
Volkswagen Group UK first approached Remote to design and develop a system to automate the annual stock count of all vehicles in the UK throughout all of their retail brands, including Volkswagen, Audi, Seat and Skoda, plus Europcar and Bentley, for commercial, retail and staff vehicles; we have worked with them ever since refining and updating the system year-on-year. The resulting system collects data from various sources using our custom-built, secure online application and collates it into a central database. It then compares it with the data held at the head office in existing SAP and other stock control databases and reports any inconsistencies or anomalies. The count is reconciled, and the resulting files are then exported to form the final stock count in summary reports and submitted to the Inland Revenue.
Challenge
The particular challenge for this project was that each brand had their own method for storing and reporting on stock data, requiring a new system to be designed to accept data in different formats, and collate it into a single database. Every factory, port, retailer and employee was required to submit data to the stock count system, and so we created an intuitive and easy-to-use bespoke submission system. Being a greenfield project, a large number of auditing rules needed to be discovered and created, and so an intuitive system for managing those rules was also created.
Result
Before they commissioned us to create this system, the collection of data for the annual stock count audit was a full-time, year-round task, and the stock count itself happened over several weeks. The first year that we ran our new system, the auditing time was reduced to three months, with a stock count window of one week. Now, thanks to an ongoing process of incremental improvement, the collection of data for the audit takes around a month, with a stock count window of two days. The initial investment in the system was returned many times over thanks to reduced staff time on the audit process, and the large number of vehicles recovered by our software and repatriated into the VW Group system.
01 — START A CONVERSATION
What could better software change for you?
Tell us what you want to achieve and what’s getting in the way. We’ll listen, ask questions and help you work out a sensible next step.
Remote
Shrewsbury, UK / Since 1999