2. Warehouses A, B, and C and D have 25, 25, 15 and 18 units of a certain commodity, respectively. Customers V, W, X, and Y have respective demands of 18, 26, 28, and 11 units of this commodity. The costs per unit to ship this commodity from each warehouse to each customer are given in the table below: A B C D Deman d V 4 5 1 5 W 2 6 4 8 X 5 1 4 5 Y Supply 1 5 2 4 Fill the table and find how can all of these demands be met from these warehouses at minimum total cost? (Use transportation problem methods)

Weighted factor methodUse the table to calculate the most ideal X coordinate for supermarket  Point Quantity offered/requested Transportation costs Coordinate X Coordinate Y Supermarket 1 3,000 0.04 4 8 Supermarket 2 3,500 0.04 7 2 Supermarket 3 2,000 0.07 3 5 Supermarket 4 1,500 0.07 7 4 Supermarket 5 1,200 0.07 6 8

1

Answer using the excel screenshot format to do the question. Secondly, please use the Net flow, sign and the RHS to work on Solver.