Implemented supply chain management scripting to optimize inventory classification and supplier management processes through the use of ABC segmentation and Kraljic Matrix.
Scripts and Notebooks used for the tutorial
The original dataset is a year's worth of electronics sales transactions. It has around 185K records and 11 attributes. Business Objective: Identify the products which generated 80% of profit.
Start with this folder to follow the tutorial: https://youtu.be/oJzNnHIusZs
University project provided by Alkemy. Market analysis and strategic consultancy for a possible client in the retail sector.
🏢 End-to-end Inventory Data Analysis project covering Demand Forecasting, ABC Analysis, EOQ, Inventory Turnover, Lead Time, and Carrying Cost Optimization.
🚚 Optimize inventory transfers between Canada and the US with advanced forecasting, intelligent recommendations, and professional reporting tools.
Unlock smarter inventory decisions by combining Generative AI and MongoDB Atlas Vector Search.
Цей проєкт демонструє комплексний аналіз продажів міжнародної компанії, яка працює на глобальному ринку через онлайн та офлайн канали. Основна мета — отримати практичні інсайти, визначити ключові фактори прибутковості та підтримати прийняття бізнес-рішень на основі даних.
Combined ABC-XYZ product segmentation
Real-Time Pharmacy Inventory Management System using MySQL and Excel | Data Analytics Project
Аналіз продажів компанії, виконаний у Google Sheets. Містить зведені таблиці, АВС-аналіз та фінальний звіт.
Аналіз продажів компанії, виконаний у Excel. Містить зведені таблиці, АВС-аналіз та фінальний звіт.
End-to-end sales analysis of a retail superstore dataset using Excel, covering data cleaning, EDA, business insights, customer segmentation (RFM), and dashboard visualization.
Анализ продаж Amazon India | EDA + RFM + Demand Forecasting
Activity-Based Costing for manufacturing — Kaplan & Cooper
This project demonstrates Excel-based inventory optimization for 50 SKUs using ABC Classification, Safety Stock, Reorder Point (ROP), and Economic Order Quantity (EOQ). The analysis highlights demand variability, holding cost distribution, and replenishment efficiency—providing insights for e-commerce supply chain management.
End-to-end inventory optimization using demand forecasting, ABC classification, EOQ, and reorder point analysis in Python.
[WORK PROJECT] Data-driven hospital logistics: ABC inventory categorization & SARIMAX demand forecasting via Flask + MongoDB. Synthetic, domain-informed (Type II PH).
Add a description, image, and links to the abc-analysis topic page so that developers can more easily learn about it.
To associate your repository with the abc-analysis topic, visit your repo's landing page and select "manage topics."