New and Improved Inventory Database for Auto Parts Distributor
Hermanos Copher are one of the largest new and used vehicle parts company in Central America. The company distribute new and used body parts, suspension, engines, mechanical and automatic gearboxes, tyres and electrical parts for vehicles.
REQUIREMENTS
Hermanos Copher required a solution to create a new reliable parts database, with updated information on both used and new spare parts, so required RGIS to provide the following:
- Complete a physical inventory count of all 18 stores and one distribution centre
- Update stock on hand levels for both new and used spare parts
- Provide a new and accurate inventory database
SOLUTION
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 centre
- 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
RESULTS
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 centre
- 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
- The customer received a new, complete and accurate parts database
- The customer was very happy with the performance and will be working with RGIS again in the future