Consider the following information:

Cost to shop from plant to store (per unit of demand)

a. Write out the assignment problem by hand, using Equations (8.4) through (8.7) and Example 8.7 as a guide.
b. Develop an Excel spreadsheet that uses the Solver function to find the optimal shipping patterns between the plants and the stores. Interpret your answer. Is there any plant that is underutilized? If so, why do you think this is the case? How might you use this information in any future decision to expand plant capacities?

  • CreatedApril 10, 2015
  • Files Included
Post your question