Question

1. Glitter Glow Machine Company is a Nigerian company that manufactures washing machines located in Lagos and Enugu, in Nigeria. These are shipped to regional distribution centers in Kaduna, and Benin, where they are delivered to the supply houses in Sokoto Sapele and Sagamu, as shown in the Figure below. Destination Transshipment Point Source Supply Sokoto Node 5 450 Lagos Node 1 800 Kaduna Node 3 Node 6 350 Enugu Node 2 Benin 700 Node 4 Shagamu Node 7 300 The available supplies at the factories, the demands at the final destination, and shipping costs are shown in the table below: out view Sec 1 Pages: 1 of 3 Words: 72 of 342 L9 The available supplies at the factories, the demands at the final destination, and shipping costs are shown in the table below: To From Kaduna Benin Sokoto Sapele Shagamu Supply Lagos Enugu Kaduna Benin Demand. 800 $7 $4 $5 SA $6 300 450 350 Glitter Glow would like to minimize the transportation costs associated with shipping enough washing machines to meet the demands at the three destinations while not exceeding the supply at each factory. Formulate this problem as a Transshipment Problem and solve using MS Excel Solver.

Answer 1

Page No. 1 50 di

Page No. Datel 13 70 13