Automate Budget Planning using Linear Programming 💰
Select the projects that maximise the return on investment, follow the management guidelines while respecting budget constraints
Objective
Automate the decision-making process for the yearly budget allocation of an International Logistics Company.
Article
In this Article, we will design a simple Linear Programming Model in Python to automate the decision-making process, considering budget constraints, projects, ROI, and management guidelines.
📘 Your complete guide for Supply Chain Analytics
60+ case studies with source code, dummy data and mathematical concepts here 👉 Analytics Cheat Sheet
Youtube Video
Click on the image below to access a full tutorial video to understand the concept behind this solution
Scenario
As a Regional Director at an international logistics company, you are responsible for logistics operations across four countries.
Objective
Your role is to find the right budget allocation that maximises your profits (ROI) and respects the guidelines of the top management.
Code
In this repository, you will find all the code used to explain the concepts presented in the article.
Files
Budget Planning Problem.ipynb- Jupyter notebook with step-by-step analysisbudget_planning.py- Standalone Python script
Getting Started
pip install -r requirements.txt
python budget_planning.pyDependencies
- pandas
- pulp
- numpy
- matplotlib
- seaborn
- openpyxl
About me 🤓
Senior Supply Chain and Data Science consultant with international experience working on Logistics and Transportation operations.\ For consulting or advising on analytics and sustainable supply chain transformation, feel free to contact me via Logigreen Consulting.\ For more case studies, check my Personal Website.