Case Study
Implemented Inventory Planning
- Michael Mazzanti
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.
Objective
- 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.
Solution
- Built, delivered, and trained the team on a complex, interdependent sales, production, and inventory model
- Developed a dashboard to publish weekly projections in Power BI
- Leveraged Visio to map all business process to educate leadership and sponsors
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.
Share this post
Article Tag 1
Article Tag 2
Article Tag 3
Article Tag 4
Knowledge Hub
Forensic Accounting
Streamlining Year-End Closures and Reconciliations
Acquisition Enhancement
Valuation for Internal Equity Transfer
Interim Controller
