Skip to content

samirsaci/budget-planning

Repository files navigation

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

Explainer Video Link

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 analysis
  • budget_planning.py - Standalone Python script

Getting Started

pip install -r requirements.txt
python budget_planning.py

Dependencies

  • 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.

Releases

No releases published

Packages

 
 
 

Contributors