a) mathematical model

b) supply, demand, and transshipment nodes in this problem

c) Spreadsheet model and solver solution.

Problem Exercise A furniture manufacturer has warehouses in cities represented by nodes 1, 2, and 3 in figure below. The values on the arcs indicate the per-unit shipping costs required to transport living room suites between the various cities. The supply of living room suites at each warehouse is indicated by the negative number next to nodes 1, 2, and 3. The demand for living room suites is indicated by the positive number next to the remaining nodes. a. Formulate the transshipment problem. b. Identify the supply, demand, and transshipment nodes in this problem. c. Use Solver to determine the least costly shipping plan for this problem. -20 $20 $40 -30 1 $20 $30 +10 $30 4 6 +40 $10 -40 2 $50 $30 $20 5 +30