Specification Management System
Customer Profile
Sector: Consumer Goods
Industry: Confectioners
Revenue: $4.0 Billion
Our client is a recognized leader in the confectionery field and the world's largest manufacturer and marketer of chewing gum. The company markets its world-famous brands in more than 180 countries. Three of these brands have heritages stretching back more than a century.
Business Situation
The company has several divisions operating from its Global Innovation Center in Chicago on Goose Island including Quality, Research & Development, Packaging Innovation, and Global Engineering. These departments needed a solution to maintain a database of specifications. Packaging engineers routinely develop new specifications. It was important that these documents be stored for retrieval by production personnel and third-party vendors. Several departments were using an Excel-based solution that was lacking in functionality, versatility, and in ease-of-use.
Solution
Specification Management System
Our client selected Access Programmers to develop a new customized solution that would help with the transition from its current Microsoft Excel application to an inter-department application to manage specifications. The customized Microsoft Access-based product enables engineers to build new specification documents based on a series of thirteen pre-defined templates. Each document begins in an experimental state and is then published once and finalized by the author. Production personnel can query the system based on a series of design parameters.