scanalytics
scanalytics is a Python implementation of several analyses used in Supply Chain Analytics & Design. I wrote this program to programmatically solve problems encountered in some Supply Chain Analytics and Design class assignments, thus minimizing tedious manual work on spreadsheet.
Table of Content
- Clarke-Wright Savings Algorithm for Vehicle Routing Problem
- Mixed Integer Linear Programming for Master Production Schedule
- One Time Run for Master Production Schedule
- Lot for Lot (Chase) for Master Production Schedule
- Silver Meal for Master Production Schedule
- Fixed Order Quantity (FOQ) for Master Production Schedule
- Periodic Order Quantity (POQ) for Master Production Schedule
Clarke-Wright Savings Algorithm
Example
from scanalytics import *
from IPython.display import display
cwsa = CWSA()
cwsa.add_dist(1,2,16.3)
cwsa.add_dist(1,3,16.5)
cwsa.add_dist(1,4,20)
cwsa.add_dist(1,5,19.6)
cwsa.add_dist(1,6,17.9)
cwsa.add_dist(1,7,9.3)
cwsa.add_dist(1,'DC',12.7)
cwsa.add_dist(2,3,7.2)
cwsa.add_dist(2,4,14.9)
cwsa.add_dist(2,5,16.6)
cwsa.add_dist(2,6,16.6)
cwsa.add_dist(2,7,12.7)
cwsa.add_dist(2,'DC',11.5)
cwsa.add_dist(3,4,8.9)
cwsa.add_dist(3,5,10.1)
cwsa.add_dist(3,6,11)
cwsa.add_dist(3,7,10.8)
cwsa.add_dist(3,'DC',9.8)
cwsa.add_dist(4,5,7.3)
cwsa.add_dist(4,6,13.4)
cwsa.add_dist(4,7,19.1)
cwsa.add_dist(4,'DC',17.5)
cwsa.add_dist(5,6,12.9)
cwsa.add_dist(5,7,16.4)
cwsa.add_dist(5,'DC',16.1)
cwsa.add_dist(6,7,9.4)
cwsa.add_dist(6,'DC',17.4)
cwsa.add_dist(7,'DC',3.6)
CWSA_df, CWSA_savings_df = CWSA_savings(cwsa)
display(CWSA_df)
display(CWSA_savings_df)
Mixed Integer Linear Programming for Master Production Schedule
Example
from scanalytics import *
from IPython.display import display
demand_forecast = [1040,240,480,400,1600,4400,1440,1120,480,400,800,2000]
setup_cost = 1822.5
holding_cost = 0.3375
init_inventory = 0
status,inventory,prod_schedule,total_cost = MPS_MILP(demand_forecast,setup_cost,holding_cost,init_inventory)
One Time Run for Master Production Schedule
Example
from scanalytics import *
from IPython.display import display
demand_forecast = [1040,240,480,400,1600,4400,1440,1120,480,400,800,2000]
setup_cost = 1822.5
holding_cost = 0.3375
init_inventory = 0
inventory,prod_schedule,total_cost = MPS_onetime(demand_forecast,setup_cost,holding_cost,init_inventory)
Lot for Lot (Chase) for Master Production Schedule
Example
from scanalytics import *
from IPython.display import display
demand_forecast = [1040,240,480,400,1600,4400,1440,1120,480,400,800,2000]
setup_cost = 1822.5
holding_cost = 0.3375
init_inventory = 0
inventory,prod_schedule,total_cost = MPS_chase(demand_forecast,setup_cost,holding_cost,init_inventory)
Silver Meal for Master Production Schedule
Example
from scanalytics import *
from IPython.display import display
demand_forecast = [1040,240,480,400,1600,4400,1440,1120,480,400,800,2000]
setup_cost = 1822.5
holding_cost = 0.3375
init_inventory = 0
inventory,prod_schedule,total_cost = MPS_silvermeal(demand_forecast,setup_cost,holding_cost,init_inventory)
Fixed Order Quantity for Master Production Schedule
Example
from scanalytics import *
from IPython.display import display
demand_forecast = [1040,240,480,400,1600,4400,1440,1120,480,400,800,2000]
setup_cost = 1822.5
holding_cost = 0.3375
init_inventory = 0
Q = 3600
inventory,prod_schedule,total_cost = MPS_FOQ(Q, demand_forecast,setup_cost,holding_cost,init_inventory)
Requirement
- Python 3
- NumPy
- Pandas
- PuLP
Alternatively, if you are using Anaconda, activate the environment in command prompt or terminal as follows.
conda env create -f scanalytics.yaml
source activate scanalytics
Installation
Clone this repository as follows.
git clone https://github.com/ragamarkely/scanalytics.git
Notes
This is by no means a complete collection of all analyses. There are other repositories that cover Python implementation other analyses, e.g. Dijkstra's Algorithm.