🚚 Transshipment Model and Risk Minimization

MAIN TOOL

Excel Workbook

Secondary tool

Excel Solver

INDUSTRY

Finance

📚 About the Project

This project explores a transshipment model aimed at optimizing the distribution of goods among warehouses and minimizing associated risks. The focus is on balancing supply and demand across multiple warehouses while minimizing costs. Key techniques such as linear programming and sensitivity analysis are used to develop a robust decision-making framework.


📊 Key Results

 

  • Optimized Transshipment Plan:
    • Reduced total shipping costs by 25% compared to initial estimates.
    • Balanced supply and demand effectively across all warehouses.
  • Risk Analysis:
    • Identified cost-effective risk minimization strategies with detailed sensitivity analysis.

📂 Project Structure

 

.
├── Data/
│   ├── Transshipment_Data.xlsx
├── Analysis/
│   ├── Linear_Programming_Model.xlsx
├── Reports/
│   ├── Transshipment_and_Risk_Minimization.pdf
├── README.md

 

📜 Full Report

 

For detailed analysis, including methodology, optimization results, and insights, refer to the complete report:
📄 Transshipment and Risk Minimization Report


🤝 Connect with Me

 

Feel free to reach out for feedback, questions, or collaboration opportunities:
LinkedInDr. Syed Faizan

Author: Syed Faizan
Master’s Student in Data Analytics and Machine Learning

Excel Workbook and the Report of the Analysis