Founded in 1886, Johnson and Johnson is an American multinational pharmaceutical, medical material and consumer goods manufacturer, headquartered in New Brunswick, New Jersey. Their consumer goods division is in Skillman, New Jersey and they have around 250 subsidiary companies operating in over 57 countries with their products selling in more than 175 countries.
The client had different types of functions like Packaging Material Change (PMC), Raw Material Change (RMC), PMC – material governance, RMC – material governance etc. and handled each of their events and projects using spreadsheet software. They began facing the obvious hurdles of using spreadsheet as they scaled up, and had difficulty managing their projects and materials across multiple locations.