12. (***) (Microsoft Excel problem). Consider the following information:

a. Write out the assignment problem by hand, using Equations 12-4 through 12-7 and Example 12-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. (Hint: The objective function for the optimal solution is $2200.) 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?

Transcribed Image Text:

PLANT CAPACITY STORE DEMAND AB 400 X 200 B 500 Y 250 C 100 Z 300 Total: 1000 Total: 750