This project focuses on creating a prescriptive decision model to assist a manufacturing company in optimizing inventory management for a key engine component. The objective is to minimize total inventory costs by balancing holding costs, ordering costs, and economic order quantity (EOQ). The analysis is conducted using Excel and R, providing a comprehensive solution to inventory optimization challenges.
Develop Mathematical Models:
Determine Economic Order Quantity (EOQ):
Implement Sensitivity Analysis:
Verify Results with Solver:
. ├── Data/ │ ├── Inventory_Modelling.xlsx ├── Analysis/ │ ├── EOQ_Model.xlsx │ ├── Sensitivity_Analysis.xlsx ├── Visualizations/ │ ├── EOQ_Plot.png ├── Reports/ │ ├── Inventory_Modelling_Report.pdf ├── README.md
For a detailed analysis, including methods, formulas, and results, refer to the full report:
📄 Inventory Modelling Report
Feel free to reach out for feedback, questions, or collaboration opportunities:
LinkedIn: Dr. Syed Faizan
Author: Syed Faizan
Master’s Student in Data Analytics and Machine Learning
© 2025 Syed Faizan. All Rights Reserved.