New and Improved Inventory Database for Auto Parts Distributor

Hermanos Copher required a solution to create a new reliable parts database, with updated information on both used and new spare parts.

Hermanos Copher partnered with RGIS to complete the spare parts inventory database project, and provided the following:

• Scheduled a team of 30 experienced RGIS auditors

• RGIS teams completed a physical inventory of all spare parts in stores and in the distribution center

• The project was carried out in two stages; new spare parts, and used spare parts. Processes were set up during the first stage, and applied to the second stage with improvements

• Information was captured for each part, including a generic product category code plus the part’s specific identification code creating a unique composite code for item identification

• Any spare parts with no information available had a new product category and identification code created, and was then added to the database

Hermanos Copher found by outsourcing the spare parts inventory database project to RGIS, the following results were achieved:

• Accurately counted all spare parts across 18 stores and one distribution center

• By working as a team with the customer, it was possible to identify damaged or incomplete parts from the parts that were in good condition. It also made identifying parts without labels a great deal easier

• Unique composite codes that were created for each spare part provided the customer with complete information for item identification