Inventory Optimization Project
Excel and Power-BI
Introduction
I crafted actionable insights using advanced data analytics tools for best inventory management practices including;
ABC Inventory Classification,
> XYZ Classification,
> Inventory Turnover Ratio,
> Calculation of Safety Stock/Buffer Stock & Reorder points,
> Stock Status Classification,
> ABC Pareto Chart & Demand Forecasting.
It is beneficial for Warehouse/ In-plant Inventory Managers to effectively control the Inventory levels and maintain the optimal service levels. Increase revenue by effective prioritizing invenory strategies.
Outcomes
ABC & XYZ Classification Analysis and Report
Fast Slow Non-Moving-FSN Analysis and Report
Fast Medium Slow-FMS Analysis and Report
Expiration analysis and reports Ageing Report
Stock optimization and replenishment analysis
Data Analysis
Data cleaning and EDA- Python
Power-BI and Dax functions for data, transformation, EDA, visualisations and creating a dashboard.
A clear summary of the findings- Powerpoint
Documentation of any cleaning or manipulation of data
An Interactive Inventory Management Dashboard- PowerBI
0 likes · 13 views · Feb 15, 2024
Data analytics: ABC & XYZ Inventory Classification, Inventory Turnover Ratio, Calculation of Safety Stock/Buffer Stock & Reorder points
