Inventory Planning Implementation

VIP SOLUTIONS CASE STUDY

Manufacturing

INDUSTRY

100

EMPLOYEES

$25M

ANNUAL REVENUE

BACKGROUND

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.

BACK TO CASE STUDIES
DOWNLOAD PDF