Problem

Our team at RevoU was tasked with analyzing data from Maven Toys (Mexico Toys Sales) to identify potential areas for improvement. We discovered that there were significant losses due to inventory being stuck in stores, and we also identified a lack of forecasting for supply chain management. Our goal was to increase sales by 10-20% within four months.

We knew that we needed to find a solution that would help us forecast supply chain needs and create a live dashboard of stock on hand for each store location. This would allow us to make data-driven decisions and optimize our inventory management strategy.

Click here

Solution

To address the challenges we faced, our team developed a comprehensive solution that leveraged our skills in data analysis and visualization. We used Python to clean and analyze the data from Maven Toys, which allowed us to identify trends and patterns in sales data across different store locations.

Based on this analysis, we developed a forecasting model that helped us predict future demand for each store location. We also created a live dashboard using Tableau that provided real-time visibility into stock levels at each store location, allowing us to make informed decisions about inventory management.

Impact

Increase sales by 10-20% within four months
Improved inventory management through accurate forecasting and real-time visibility into stock levels
"This project had an incredible impact on our ability to make data-driven decisions and optimize our inventory management strategy. We were able to increase sales and reduce losses due to inventory being stuck in stores, which had a significant impact on our bottom line."

Team

Christian Aditya & Fauzan Rahmatan Prayoga - Data Analyst
- Cleaned and analyzed data from Maven Toys using Python
- Developed forecasting model to predict future demand for each store location
Ghea Miftahul Jannah & Chrissanti Vina Dewi - Visualization Specialist
- Created live dashboard using Tableau to provide real-time visibility into stock levels at each store location
- Designed visualizations that helped us identify trends and patterns in sales data across different store locations

Boosting Sales 10-20% with Inventory Optimization