A company has three warehouses that supply four stores with a given product. Each warehouse has 30 units of the product. Stores 1, 2, 3, and 4 require 20, 25, 30, and 35 units of the product, respectively. The per unit shipping costs from each warehouse to each store are:

a. Draw the network representation of this problem. What kind of problem is this? b. Formulate an LP model to determine the least expensive shipping plan to fill the demands at the stores.
c. Solve the problem using Solver.
d. Suppose that shipments are not allowed between warehouse 1 and store 2 or between warehouse 2 and store 3. What is the easiest way to modify the spreadsheet so that you can solve this modified problem? What is the optimal solution to the modifiedproblem?

Transcribed Image Text:

4542 3643 2463 1534 w123