Modis brews up custom application for leading U.S. beer manufacturer

Client Overview: Leading international beer brewer

Based in the Midwest, this major beer brewer dominates the U.S. beer market. The company produces some of the world’s largest-selling beers and continues to rank high both in FORTUNE magazine’s “America’s Most Admired Companies” and FORTUNE’s “Global Most Admired Companies” list. The company also is one of the largest theme park operators in the United States, is a major manufacturer of aluminum cans and is the world’s largest recycler of aluminum beverage containers.

The Modis Solution: Custom application keeps staff current on operating procedures

A subsidiary of this major brewer requires various standard operating procedure documents be read at various times to ensure their personnel stay current on procedures.

Developed by Modis consultants, the SOP Express application allows plant personnel to log into the system and track when various standard operating procedure documents are read. This application uses an Outlook-style interface that allows documents to be viewed in such grouping methods as title, department, equipment, and subassembly. The application allows several reports to be printed by administrators to show read history information. The reports were written using a tool called Data Dynamics Active Reports.

Enhancements to the application allow administrator- and maintainer-level personnel to log into the system and maintain or add new SOP documents. Once created, a document can be attached to a group of users that must approve the document. The SOP Express system allows email to be sent out as a reminder to approvers to check the document out, edit it, and check it back into the system. The act of checking in the document is equivalent to approving it. Notices are subsequently emailed to the remaining approvers. Phase 2 uses an enhanced rich text editor built right into the SOP Express application.

The application is housed on the brewer’s Packaging Group&rsquos wide area network (WAN). The application originally was created in Visual Basic 5.0 using Microsoft Access 97 as its database. During Phase Two the application was converted to Visual Basic 6.0.

To see what Modis can do for you, contact your local Modis office today or read more Manufacturing case studies .