Auto parts maker standardizes data collection on the shop floor: an auto-parts maker uses screen mapping to take its MAPICS system mobile

Frontline Solutions, June, 2004 by Brian Albright

Acquisitions can bring corporate headaches, not the least of which is integrating disparate information technology across multiple facilities. In the wake of several acquisitions, Dearborn, Mich.-based automotive supplier Meridian Automotive Systems Inc. found itself with multiple bar code scanning technologies in its 22 North American plants. The company used them mostly for shipping and receiving; reporting was largely paper based. Unfortunately, the scanning solutions were incompatible.

"We had four different bar code scanning technologies, and they were not doing a good job," says Bruce Knoll, director of information systems for Meridian, a leading supplier of front- and rear-end modules, consoles, instrument panels, and other automotive components. A more comprehensive technology was needed, not only to increase operational efficiency but to support and complement the Meridian management systems that were being initiated on the shop floor.

In addition, Meridian was implementing the MAPICS enterprise resource planning system across its manufacturing facilities. The company needed a software solution that could overlay the MAPICS system, the company's BPCS software, and Agilisys Inc.'s AC Manager electronic data interchange solution.

Using a new screen mapping system, Meridian has standardized its data collection system and extended MAPICS to the shop floor, all without creating custom code. The wireless bar code system has eliminated much of the manual key entry associated with the paper-based system. It provides real-time inventory data and label generation and improved inventory and work-in-process tracking for the company.

Not an IT Project

In addition to standardizing its data collection efforts, Meridian needed to meet established Materials Management Operations Guidelines (MMOG), a best practices methodology for the shop floor established by Ford. In December 2001, Meridian formed an eight-member steering committee to address MMOG compliance and comprehensive traceability goals and requirements.

Along with Knoll, the committee included the materials manager, two division managers, and representatives from purchasing and finance.

"One key point is that this was not an IT project," Knoll says. "We had a sponsor in management and a very company-focused drive to the project."

Three of the eight members were dedicated to selecting a new bar code scanning technology that would work with MAPICS and the Agilisys EDI package. After a six-month review and planning process that included visiting company sites to determine specific needs, the scanning group presented its requirements.

"Our goal with the scanning was to not have software 'off to the side' of MAPICS," says Knoll. "MAPICS does the transactions we needed, and we wanted those screens on the handheld [devices]. We didn't want to have to rewrite what we were already doing."

Unfortunately, finding the right solution wasn't as easy as Knoll's group had hoped. "When we went looking for scanning packages, we knew the main players," says Knoll. "None of them did what we needed."

Looking for more options, Meridian asked MAPICS for help. The ERP vendor recommended the QuikTrac screen mapping and data collection software from Integrated Barcoding Systems (IBS).

Knoll contacted IBS, and the company provided a demo and the name of a local QuikTrac customer. Finally, IBS provided Meridian with a trial version to test with the company's own operations.

The project committee presented the business case and unanimous recommendation for the new system to management, which approved the solution.

Employees Guide System

Meridian followed a modeling process for each of its 22 facilities. They set up a small-scale working model of each plant floor using Symbol Technologies PDT6846 two-dimensional (2D) bar code scanners. "We used Lego bricks and Play-Doh to make the models," says Knoll. "We simulated receipt, storage, shipping--everything. The workers could really see how it worked."

After the three-month modeling process, Knoll moved to the shop floor, setting up pilots one department at a time. When the pilot began, system planners had included only 10 MAPICS transaction screens for presentation on the bar code scanners. But employees came up with some other functions.

"We started scanning out on the floor, and it was a huge success," says Knoll. "The plant people came to us asking if they could have more." Workers now have access to more than 50 screens in MAPICS, the EDI system, and some custom programs. Most of the screens are transaction-based, but some are used for inquiries, such as quantity on hand. IBS provided help in developing the additional functionality and assisted with further training for Meridian support personnel.

The first plantwide conversion was completed in April 2003.

End-to-End Tracking

When parts arrive at Meridian, workers use handheld scanners to read carton labels and receive inventory into the system (15-20 scanners are deployed at each location). If an order arrives without a bar code or with one that is unreadable, workers create Code 39 bar-coded labels for the shipment by using wireless Zebra Technologies Zebra 105 printers. Previously, labels were printed in batch, on printers located in supervisors' offices, and then distributed later.