Pepsi Co – data gathering tool
With hundreds of manufacturing plants spread across Europe, purchasing supplies independently, Pepsico’s European HQ in Geneva needed a data gathering tool to check the efficiency of their purchasing.
The data gathering tool we developed helped Pepsico save over 4,000 man hours each year.
The client
A multi-billion dollar food and drinks company with thousands of production facilities around the world. It owns household brands that include Pepsi, Walkers, 7Up, Doritos, Gatorade, Lays, Cheetos, Smiths, Snack-a-Jacks, Quaker, Tropicana, Lipton and Mountain Dew.
The problem
As a result of a large and growing portfolio of household brands, the European division of Pepsi Co owns hundreds of manufacturing plants dotted around Europe. In turn each of these plants are supplied by hundreds of different companies, each supplying price lists and specification documents in different formats.
Pepsi Co’s European HQ needed this data in a common format to analyse buying patterns, how effective buying was and to include in monthly directors reports. Co-ordinating the thousands of suppliers was proving impossible.
The solution
We developed an Excel application that allowed Pepsi Co to record the format and layout of each suppliers price lists and specification document. The application would then automatically open each of these documents, extract the required information and process it in to the required format for analysis.
The result
Up until the application was developed two members of staff were dedicated to cutting and pasting the information in to a common document. The application reduced this full time process to simply dumping the files in to a folder and clicking a button, saving Pepsi over 4,000 man hours a year.
Find Out More
If you want your own data gathering tool or you need any sort of Excel spreadsheet work completing, call us now. If you are in the UK the telephone number is 029 2125 1450 and if you are in the USA the number is (646) 257 4006.