Instructors: Be sure to contact FT Press 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.
The models we mention use IBM’s ILOG LogicNet Plus XE. If you are a professor at a university, you can access this for your class through IBM’s Academic Initiative.
Here are some tips for making sure the software is installed on the student’s machines:
- It is a PC program, so make sure it is installed on a PC or the windows section of a MAC.
- Make sure you unzip the program first (if it comes to you zipped)
- The students should install the program on the c:\ drive or the hard drive of their personal computer. The academic version won’t work if installed on a network drive
- Make the assignments team assignment in case someone has settings that won’t allow the software to be installed.
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.
- Mars and Wrigley merger
- Whirlpool and Maytag merger
- MillerCoors merger
- The Home Depot supply chain transformation
- Pepsi and Multi-site Production Planning
- Johnson Controls closed loop battery supply chain
- Südzucker uses network design to adjust to changing regulations
- 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. If you are an academic user, you can sign up for IBM’s academic initiative and use IBM’s ILOG LogicNet Plus XE.
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 and answer case study question in the end of chapters questions with this material. This material contains an instructions sheet that you should read first.
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 and the Brazil Capacity 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). Click here for this model 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 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. 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
If you want to use the Illinois Quality Parts model from the book, you want to extract the four zip files into the same directory. Click here to see what the directory structure should look like when you are done unzipping. The four files are IQP 1 of 4, IQP 2 of 4, IQP 3 of 4, and IQP 4 of 4.
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 (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.
Chapter 11 Material
The model for this chapter also has a self-guided tour that takes you through multi-objective optimization as well as other interesting topics. To build a model from scratch, you need the German Store Delivery file. It is a great exercise, worth the time. If you want to start with the fully built model, go to file German WH vs 75 km model.
Chapter 12 Material
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
The JPMS case was too big as a single file. We’ve split it into four files. You need to unzip these into the same directory. When you are done, it should look like this picture.