Madison Precision Products, Inc. Improves Efficiency with Base2 EDI
Founded in 1987, Indiana-based Madison Precision Products, Inc. manufactures high quality aluminum die cast parts for the automotive industry.
Madison Precision Products' EDI system lacked the functionality that the company needed to efficiently fulfill customer orders and effectively scale with new business. Their biggest challenges involved inbound orders and imports into their ERP system.
Changes Create Complications
Madison Precision Products' biggest customer, Honda, implemented a substantial change in the format of their sales orders. The sales orders that the automotive buyer sent to Madison Precision Products displayed multiple PO #s for each part. The company's previous EDI software could not accommodate the change, resulting in some internal PO #s not appearing on the ASN sent to Honda. When Madison Precision Products contacted the software company to request support in resolving the EDI issue, no answers were provided-leaving Madison Precision Products to find a solution on their own.
Madison Precision Products' EDI system also lacked integration with their ERP system, Exact Macola. The accounting department was forced to manually enter shipping data into Macola. From the bills of lading to Macola, the manual data feed amounted to hundreds of lines per day and consumed approximately 20 dedicated work-hours each week. Hours spent on manual data entry became costly, and the possibility of human error hung over the operation. In order to successfully fulfill orders and meet growing needs, the company needed an EDI system that could efficiently manage the orders from receipt to import into the ERP.
Their search for a more efficient solution ended with Base2. Madison Precision Products implemented the Base2 automotive solution and immediately began reaping the benefits of an integrated system.
"We spoke with several existing users of Base2 and were pleased with our findings," stated Joel Applegate, shipping coordinator and EDI tech for Madison Precision Products.
Difficulty is a Thing of the Past
After implementing the Base2 EDI solution, Madison Precision Products was able to efficiently adapt to Honda's sales order changes. Base2's solution stores inbound data exactly as it is received. The unique nature of each inbound order is preserved for ASN creation. For Madison Precision Products, the ASNs sent to Honda now display the correct (multiple) PO #s. Base2 is Honda certified which provides extra reassurance to the user.
Ad hoc and formatted reporting is provided by Base2 for any number of situations, including shipping summaries, pick lists, forecast and order summaries. "Processing the orders became a breeze," commented Mr. Applegate. "From the sales orders, I create spreadsheets by exporting this data to Microsoft Excel. The data includes part names and quantity of all items shipped and is separated by truck."
MacLink Eases the Burden
Base2's solution provides fast, efficient integration to Exact Macola. With Base2's Macola interface-MacLink-the order data is automatically imported into Madison Precision Products' ERP system. Instead of hundreds of hours spent annually on manual order data entry, now it only takes two minutes per shipment to complete the task. For Madison Precision Products, order fulfillment has been greatly simplified, and the chance of error is almost nonexistent.
"It just works," stated Mr. Applegate.
Base2 MacLink directly populates the Macola order entry files with the user's sales orders. ASNs are subsequently created, using the pre-loaded data. The solution also uses a simple algorithm to locate and update orders and forecasts in the Macola database thus, keeping the MRP current with the frequent changes sent by the OEMs. The result of these strengths is an efficient and accurate EDI management system that facilitates growth by allowing staff to do more and accommodate additional customers.
"Business is growing," stated Mr. Applegate. "Base2 has enabled us to get back to fulfilling orders quickly and accurately."
Extra, Extra, Read All About It
Madison Precision Products further simplifies their operation with Base2's labeling system. With Lineside Labeling, hundreds of labels are printed daily, and parts are labeled as they come off the manufacturing line. The labels are prepopulated and are produced in the correct format and quantity for the shipment. No data re-entry is needed, thus greatly reducing chance of error.
"We now have a better system," commented Mr. Applegate.
Going the Extra Mile
"Base2's support is amazing," said Mr. Applegate. "If we ever have problems, we know we can call the support team and they will guide us to a solution."
In addition to 24/7 assistance, Base2 practices a hands-on approach. Base2 visited Madison Precision Products early in the relationship to examine the operation and to assist with implementation. "Communication with our customers is of utmost importance," commented Russ White, director of business development for Base2. "We are here to assist with setup, daily maintenance, and any issues in between."
For more information on this case study or how Base2 EDI can improve your operation, please contact Russ White at 281-480-1121 ext. 764 or
1199 NASA Parkway
Houston, TX 77058
Phone: +1 281-480-1121
Fax: +1 281-480-1181
5215 N. Ironwood Rd.
Glendale, WI 53217
Phone: +1 262-387-1140
Fax: +1 262-387-1150
4220 de Rouen
Phone: +1 514-899-0003
Toll Free: +1 877-700-7223
5500 Explorer Dr. - 3rd Floor Mississauga, ON L4W 5C7 Canada
Phone: +1 416-679-1917
Toll Free: +1 866-679-1917
Hong Kong Office
Room 907 Silvercord Tower 2
30 Canton Road, Kowloon
Telephone: + 85 2 2961-4426
Fax: + 85 2 3007-5249
66 Chunfang Road, Louhu
Room F, 11/F., Block B, Lushan Building
Telephone: + 86 755 8232 2386
Fax: + 85 2 3007-5249
139 Pasteur St., Ward 6, Dist. 3,
Ho Chi Minh City, 70000, Vietnam
Telephone:+84 3547 3000
Fax: + 84 3827 3600
Da Nang Office, Vietnam
Da Nang Software Park, Block 9, 9th Floor, 2 Quang Trung St., Hai Chau Dist., Da Nang City.
Tel: +84 511 388 8001
Level 7, Toranomon 40 MT Building
Minato-ku, Tokyo, Japan
SCO-91, First floor