Production Fixed Horizon Planning with Python

Implement the Wagner-Whitin algorithm to minimize the total costs of production given a set of constraints.

Production Fixed Horizon Planning with Python

Implement the Wagner-Whitin algorithm to minimize the total costs of production given a set of constraints

Article originally published on: Medium.

Objective
Use python to design an optimal production plan to meet customer demand and minimize the total production costs.

Introduction
The master production schedule is the main communication tool between the commercial team and production.

Your customers send purchase orders with specific quantities to be delivered at a certain time.

Production Demand Forecasts in Units — (http://samirsaci.com)
Example of a customer order — (Image by Author)

Production planning is used to minimize the total cost of production by finding a balance between minimizing inventory and maximizing the quantity produced per setup.

In this article, we will implement optimal production planning using the Wagner-Whitin method with python.

💌 New articles straight in your inbox for free: Newsletter

If you prefer to watch, have a look at the video version of this article

Problem Statement

Scenario

You are a production planning manager in a small factory producing radio equipment that serves local and international markets.

Customers send Purchase Orders (PO) to your commercial team with quantities and expected delivery dates.

Production Planning Methodology — (http://samirsaci.com)
Production Planning — (Image by Author)

Your role is to schedule production to deliver on time with a minimum total cost of production that includes

  • Setup Costs: fixed costs you have each time you set up a production line
  • Production Costs: variable costs per unit produced
  • Holding Costs: cost of storage per unit per time

In our example, the customer ordered products for the next 12 months

Production Demand Forecasts in Units — (http://samirsaci.com)
Customer Order — (Image by Author)

Setup vs. Inventory Costs

The main challenges for you are

  • Reducing the average inventory on hand to minimize the storage costs
  • Minimize the number of production setups
Production Scheduling Challenges — (http://samirsaci.com)
Production Scheduling Challenges — (Image by Author)

However, these two constraints are antagonistic. Therefore, it is difficult for you to find an intuitive way to build an optimal plan.

Example 1: Minimize Inventory

Minimal Inventory Production Planning Strategy — (http://samirsaci.com)
Minimize Inventory Solution — (Image by Author)

In this example, you produce the exact demand quantity each month

  • Pros: no excess inventory
  • Cons: you get production set up for each month with a positive demand

Example 2: Minimize the number of production setups

Minimal Setup Costs Production Planning Strategy — (http://samirsaci.com)
Minimize Setup Costs — (Image by Author)

In this example, you build stock to minimize the number of setups

  • Pros: only two production setups for the whole period
  • Cons: a large stock on hands that increase the inventory costs

Conclusion

You need an optimization algorithm to balance the two constraints.

Solution

You can find the source code with dummy data here: Github

Assumptions

Let us suppose that you receive a purchase order for the next 12 months with the quantities presented in the chart above.

  • Set up cost: 500 $
  • Holding cost: 1 $/unit/month
  • Production cost per unit: 50 $/unit
  • Units produced month m can be shipped the same month
  • Inventory costs are charged from the month m+1

Wagner-Whitin Algorithm

This problem can be seen as a generalization of the economic order quantity model that takes into account that demand for the product varies over time.

Wagner and Whitin developed an algorithm for finding the optimal solution by dynamic programming.

The idea is to understand each month if adding the current month's demand quantity to past months' orders can be more economical than setting up a new cycle of production.

Forward Calculation

Start at period 1:

  • Calculate the total cost to satisfy the demand of month 1, D(1)

Period N:

  • Calculate the total cost to satisfy the demand of month t, D(t)
  • Look at all past orders (t=1 .. N) and find the cost for ordering for D(t) by adding the quantity to past orders D(t-1)
  • Take the most economic option and go to t = N+1
Wagner Whitin Algorithm for Production Planning — (http://samirsaci.com)
Wagner-Whitin Algorithm — (Image by Author)

Backward Calculation

Start from period t = N and work backwards to find the lowest options to satisfy the demand of each D(t).

Results & Conclusion

Forward Calculation

You should export the results of the forward calculation using a table like the one below:

Wagner Whitin Forward Calculation — (http://samirsaci.com)
Forward Calculation — (Image by Author)

Let me take a few examples:

Period 1, if you produce for the

  • First month demand only (D(1) = 200 units): 500$
  • Two first months (D(1) + D(2) = 350 units): 650$

Backward Calculation

We can use the table above to conduct a visual resolution of the algorithm using the rules explained before.

Wagner Whithin Backward Calculation — (http://samirsaci.com)
Backward Calculation — (Image by Author)
  • Start with t = 12
    The cheapest solution is to produce the month 11 for D(11) + D(12)
  • Continue with t = 10
    The cheapest solution is to produce the month 9 for D(9) + D(10)
  • Continue with t = 8
    The cheapest solution is to produce the month 6 for D(6) + D(7) + D(8)
  • Continue with t = 6
    The cheapest solution is to produce the month 1 for D(1) + D(2) + D(3) + D(4) + D(5) + D(6)

Final Solution

  • Month 1: produce 550 units to meet the demand of the first 5 months
  • Month 6: produce 450 units for months 6, 7 and 8
  • Month 9: produce 450 units for months 9 and 10
  • Month 11: produce 550 for months 11 and 12

Inventory Optimization

In the chart below, you can see that the inventory on hand (IOH) is very close to the demand forecast

Wagner Whitin Results in Units — (http://samirsaci.com)
Inventory On Hand — (Image by Author)

A great balance between inventory and set-up costs

In the chart below, you can follow the cumulative holding and set-up costs along the 12 months:

Wagner Whitin Cumulative Costs Results — (http://samirsaci.com)
Holding Costs vs. Set-Up Costs

We can clearly see here how the algorithm is making the balance between inventory optimization and reducing the number of setups.

Implementation with Python

In the GitHub repository, you can find an implementation of this method from scratch using python.

Using pandas functions to manipulate data frames, this method is easy to implement and works well for small datasets.

Implementation

I have implemented this solution on a web application that I deployed using the VIKTOR platform.

You can have a look and try it with your own dataset,

Production Planning Optimization App [Link]

Have a look here: Production Planning Optimization App


About Me

Let’s connect on Linkedin and Twitter, I am a Supply Chain Engineer that is using data analytics to improve logistics operations and reduce costs.