Production Specification System – Wrigley

Wrigley logo

The William Wrigley Jr. Company based in Chicago, Illinois is ranked #482 among Fortune 500 companies. Wrigley 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 – Wrigley’s Spearmint®, Juicy Fruit®, and Altoids® – have heritages stretching back more than a  century. Other brands include Doublemint®, Life Savers®, Big Red®, Boomer®, Pim Pom®, Winterfresh®,  Extra®, Freedent®, Hubba Bubba®, Orbit®, Excel®, Creme Savers®, Eclipse®, Airwaves®, Alpine®,  Solano®, Sugus®, Cool Air®, and P.K.®.

Challenge Challenge - Mountain without Flag

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 ease-of-use.

Solution Solution - Mountain with Flag

The Wrigley Company selected alligatortek to develop a new customized solution that would help with the  transition from its current Microsoft Excel application to an interdepartment 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 and finalized by the author. Production personnel can then query the system based on a series of design parameters.

    Wrigley - product specification system UI

This Microsoft Access database application allows engineers worldwide to input and query on engineering  specifications. The parameters are stored in a centralized SQL Server database hosted at a data center at Corporate Headquarters.

alligatortek has been supporting and updating the system for over 7 years.As technology and systems have  evolved, the system has been continuously updated to use recent technology and satisfy new requirements  from Production Engineers at Wrigley.

latest news

01

Start With a Plan: 3 Reasons To Begin Any Development Project With a Discovery Session

Ninety percent of alligatortek clients that begin development with a discovery session will continue to the second part of the process. Want to know why? Here are three reasons why a planning stage will produce better results for you

02

File-Snapshot Backups to Microsoft Azure Blob Storage

Azure’s SQL Server data files allow us to create a database in an on-premises SQL Server or an available server in the Azure Virtual Machine. This database is tied to our application using a specific location in Azure blob storage. The File-Snapshot backup, introduced in SQL Server 2016, is capable of quickly performing a backup and restore.

03

How to create an Azure subscription

Anyone can harness the power of Microsoft Azure with a free trial account. The trial comes with a $200 credit, valid for 30 days.

Copyright© 2018 alligatortek. All rights reserved.