Course Materials

Instructors:  Be sure to contact us ( to get a copy of the Instructors Manual and Slides.  We have a lot of material to help you with your class.  We have a 33-page instructors manual, we have 310 slides that cover the 15 chapters, we have 15 answer keys with answers and additional discussion points for class, this site has 16 models (with their own slides), and 11 different pre-built spreadsheets. (Note that in late 2017, we converted some material to a new format, and that will be a work-in-progress for awhile.)

Screenshot from OPC for Chpt4 Problem

We are creating the models using a Jupyter notebook so they can run in Python with an open source solver and open source simple mapping.  We are making the notebooks as simple as possible so that your students should be able to easily run the exercises.  As of Oct 2018, these are still in development (but, one of the authors of the book will be using them in his class at Northwestern in this month).  Please contact for more information on these models.

If you develop or improve the material, we would love to hear about it, share with the group, and give you credit.

Chapter 1 Material

Here are some good cases and links to more material on the cases.  We would be happy to post additional cases to help with your class.

  1. Mars and Wrigley merger
  2. Whirlpool and Maytag merger
  3. MillerCoors merger
  4. The Home Depot supply chain transformation
  5. Pepsi and Multi-site Production Planning
  6. Johnson Controls closed loop battery supply chain
  7. Südzucker uses network design to adjust to changing regulations
  8. Toshiba uses network design to evaluate options

Chapter 2 Material

The Logistica Spreadsheet shows you the calculations from the book.  It is also a good starting point if you want to test other ideas.

The side bar in Chapter 2 provides an example of locating the best point between Eugene, OR and Portland, OR.  This spreadsheet shows you this calculation.

Chapter 3 Material

If you are going to use commercial network design software, this is a good chapter to start.  Contact Opalytics (see above) for the academic version.

The Excel Exercise, MIP for 9-City Example, is a good companion to use when going over the Mixed Integer Programming (MIP) formulation.  The MIP formulation is important for building intuition and if you cover it slowly and with the help of Excel, students should get a lot out of the section.

You can re-create the Al’s Athletics model in OCP and answer case study question in the end of chapters questions with this spreadsheet and this training document.

Chapter 4 Material

In Chapter 4, you can extend the MIP 9-City Example from Chapter 3 with service level constraints.

Click here for the the Chen’s case study and guide for the end of chapter questions.  You can also extend this model

Chapter 5 Material

In this chapter we add capacity constraints to our models.  Capacity seems relatively straight-forward to add to a model.  However, as the chapter points it, it can be hard to measure, it can cause strange results, and it can increase the complexity of the models.  We have two cases that help explain capacity, the LP Transportation Problem (contact us for this case) and the Brazil Capacity (contact us) case (from the case in the book).  Both cases help explain capacity and both allow you to explore more advanced optimization ideas.

Chapter 6 Material

In the text we mention a UPS model and there is an exercise using this model (but with a different demand and package weight).  We have the UPS case in OPC (contact us) .  This includes the data and guides on how to use it.   You can easily extend this model to create other case studies.

To practice using regression for determining transportation rates, we have a file of 296 actual shipments with their distance and cost.  This was taken from a project that used regression to build the rate matrix.  The file is called, Raw Truckload Rates for Regression.  Use this to build a regression to determine the cost based on the distance.

In the book, we have a section on determining factors for multi-stop routes.  Click here for a copy of this spreadsheet so you can see the examples.  We have also included other examples.  There are a lot of different assumptions you can make here.  If you have new ideas you would like to share, let us know.

Question # 2 (in Chapter 6)’s TL and LTL Model for Construction file (contact us) gives you a working model that has a model with TL and LTL rates.  This model can easily be expanded and modified.

Here is the raw data for the price of oil vs the price of diesel fuel.  This the mini-case at the end of chapter.  For a more detailed discussion of the impact of the price of oil on the supply chain see this post.

Here is the Raw Transportation Rate file from the end of chapter questions.  This shows 300 shipments from Atlanta to Chicago with different modes.

Chapter 7 Material

In the text of the chapter, we mention modifying the UPS model with variable costs.  You can do this exercise with the UPS model from Chapter 6.

Question #3 references the file Warehouse Costs by Throughput.  This is another example of regression analysis.  This time it is applied to the fixed and variable costs of the warehouse.

Question #5 references a file called Investment Decisions (contact us).   This is a full model for a fast-growing beverage company in the UK.

Question #7 references a file called Accounting Allocations.  This file is an exercise in allocating the accounting costs to fixed and variable costs.

Chapter 8 Material

Here is the  Illinois Quality Parts (IQP) (contact us) model from the book.

Question #2 references the MIP for 9 City Excel found in the materials for Chapter 3.

Chapter 9 Material

The JADE case is also a self-guided tutorial.  You can use this case to learn how to work through the software so you can work through the exercises.  Here is the JADE Intro Case Model and the JADE Intro Case PowerPoint (which is also the self-guided training).

Chapter 10 Material

The text walks through the Value Grocers example.  Question #3 also references the file Value Grocers Expanded Product Line Exercise (contact us) (which include the Excel file as well).  If you remove the new products from this file, you can recreate the model from the text.

Question #4 references the file Australia Gold Mining Product Sourcing Study (contact us).

Chapter 11 Material

This is a great model to learn and think about multi-objective optimization.  Click here for the files and instructions (contact us).

Chapter 12 Material

The end of chapter questions reference Debugging Example I, Debugging Example II, and Debugging Example III. (contact us)  All three are full models and worth a try.

Chapter 13 Material

Question #2 references a file called Aggregating Customers.  This gives you practice grouping customers.

Question #3 references a file called Aggregating Products.  This gives you practice aggregating products.

Chapter 15 Material

Here is JPMS (contact us) if you want to take a look.