Our client was struggling to accurately predict inventory stocks and make sound and timely judgments on which products to focus plant production. Existing trackers were limited to siloed functional needs and did not serve the company strategy.
OBJECTIVES
Inform raw materials procurement
Determine which products and in what quantities should the plant produce to meet sales goals
Gain visibility to existing bottlenecks
Maintain inventory stocks
SOLUTIONS
Built, delivered, and trained the team on a complex, interdependent sales, production, and inventory model
Developed a dashboard to publish weekly projections in PowerBI
Leveraged Visio to map all business process to educate leadership and sponsors
IMPLEMENTED INVENTORY PLANNING company has embraced the new model and now uses it weekly to plan production. A critical raw material shortfall was predicted in future months and is being mitigated due to visibility that was not possible before.