A US manufacturing company needed help obtaining a consolidated and reliable view of its inventory. They 1) were unable to generate consistent, aggregated, repeatable, and automated reports on inventory value; 2) had gaps between systems data regarding inventory values: ordering system, ERP, and the production system; 3) were uncertain about data extraction exhaustivity from systems.
These difficulties were costly for the business because it impacted invoicing and inventory optimization objectives. The business difficulties they needed to solve were the following:
- Lack of visibility and reliability on the real inventory value and status
- Inability to make decisions to optimize the inventory without taking risks on customer commitments
- Wasted of time on manual Excel work to compile the required visibility for finance and management
Penon Partners performed a complete inventory & reporting process diagnosis to identify the root cause and provide recommendations to improve this process.
- Interviewing teams & running Workshops
- Data gathering and analysis
- Process mapping (flows, systems, documents…) and analysis
- Writing and presenting the final report
In 5 weeks, the diagnosis solved the inventory issues (data and naming issues between ERP/inventory systems) and identified other initiatives to strengthen the overall process for long-lasting results.