Linear Optimization Analysis

Using the Solver add-in in Microsoft Excel, the "Supply Chain Analytics Case Study Template," and "Supply Chain Analytics Case Study Data" file, run a linear optimization analysis to determine the optimal number of shipments from each of the four distribution centers to one or more stores in order to minimize total logistics cost. Assume the following:

1. There are four distribution center locations: Cambridge, Dover, Newark, and Toronto.
2. Use the daily demand information for each store, as provided in the case.
3. Assume each distribution center internally fulfills its own demand. The demand information for the Dover, Newark, and Toronto locations does not need to be reflected in the model.
4. Assume the following maximum supply capacities for each distribution center: Cambridge: 45, Dover: 15, Newark: 15, and Toronto: 15.
5. Use the relevant travel time information (in minutes) as provided in the case. Assume that the logistics cost per minute per unit is $0.85.

\f\f