Solution for Supply Chain Network Design: Applying Optimization and Analytics to the Global Supply Chain 1st Edition Chapter 13, Problem 2

by Michael Watson Sara Lewis Peter Cacioppi Jay Jayaraman
106 Solutions 14 Chapters 19693 Studied ISBN: 9780133017373 Supply Chain Management 5 (1)

Chapter 13, Problem 2 : 2. Open the file Aggregating Customers.xls found on...

2. Open the file Aggregating Customers.xls found on the book web site. This file contains a list of 10,000 raw ship-to points and some characteristics about these data points. How would you go about aggregating the customers? Go ahead and follow your strategy. How many customers do you end up with?

Step-By-Step Solution

2. This question is a bit open ended. There is no single correct answer. However, the general idea is to get the total customers groups down to around 100–400.

Some strategies that could work would be to aggregate by the leading three digits of the zip codes (496 of these) or by the leading two digits of the zip codes (94 of these).

From there, the ambitious students might realize that there are some customers with more than 50 deliveries a year that might be split out separately.

The idea here is that the students spend time thinking about how to group these shipments to create both an accurate model as well as one with a manageable number of customers to work with.

Of course, you can expand this to introduce errors into the data, include more shipments with different modes, or have them actually build a model with this data.

This could be a good introduction to Microsoft Access for dealing with large data sets (or Pivot tables).

Unlimited Access Free
Signup & Access More than 10 Million+
  • Textbook Solutions
  • Flashcards
  • Homework Answers
  • Documents
All Chapters Solved


Is this a textbook?

We do not endorse or sell any Textbooks in this service. This is only a solution guide for the textbook shown. So, you will find all the answers to questions in the textbook, indexed for your ease of use. ExploreNow!

I am unable to find the book I need.

You can request for your textbook to be answered. While you may get the book resolved within 15-20 days’ subject to expert availability and can access it at no cost if you are premium member, We encourage you to use our Study Help service for the specific question or even a full chapter you currently, need within a 24-48-hour window.

My book is similar but not the same!

This may be due to different versions or editions of the same book. You can check the table of contents and match the questions in each chapter (As you can see, the questions are free to view for the entire book). You can subscribe if you decide the step-by-step solutions will be useful albeit the differences.

Not all questions are answered!

We try not to post guidebooks that are under progress. However, some guides are so high in demand that we have to post them as we work on them. If you find the notification stating, "An expert is currently solving this for you" in the answer section, you can contact customer support to know the status or even get an instant answer if you are a premium member.

The ISBN's are not matching!

Check if there are other ISBN's mentioned on the book cover page. If it still does not match, check the samples available to ensure you are on the right guide. 

Can I see some samples?

Every chapter in the book has the first three solutions displayed in full for free. Browse the chapters and questions to view the same. 

Is it possible to see a specific answer before I subscribe?

Contact customer support via Live Chat to request the same. They will assist you with the full answer if it is a simple question or a partial answer to assure you of the availability if it is a large solution.