Question

The Bright Company wants to figure out the best way to ship their new product, Flying Widgets, from their factories through their warehouses to their retail outlets. They would like to set up a Transhipment table so they can use POM to find the least cost shipping routes. They have hired you to set up the Transhipment table based on the information below. You will be paid handsomely if you can come up with the correct table. Shipping Costs Shipping Costs 01 02 03 04 W1 W2 W3 W1 3 4 2 3 F1 2 3 4 W2 4 3 2 2 F2 3 4 2 W3 2 4 3 4 Also, Flying Widgets can be shipped from Factory 1 to Factory 2 for $3 per unit. Factory 1 can produce 300 units and factory 2 can produce 100 units. Outlet 1 demand is 50 units, Outlet 2 is 150 units, Outlet 3 is 100 units, and Outlet 4 is 100 units.

Answer 1

fax =SUMPRODUCT(C3:C21,D3:D21) Set Objective: SG$14 ES To: O Max O Min O Value of: 0 E F 1 K By Changing Variable Cells: SD$3:$D$21 3 = Subject to the Constraints: $1$3:$I$11 = $K$3:$K$11 Add Node F1 F2 wi W2 W3 01 02 03 04 G H Units Shipped In Outt Shipments 300 300 100 100 100' 100 0 50" 50 0 250 250 0 100 100 150 150 100 100 50 50 A B C D 1 Route Units 2 Start Node End Node Cost Shipped 3 F1 F2 ol 4 F1 wi 21 501 5 F1 W2 이 6 F1 W3 250 7 F2 W1 501 8 F2 W2 4 501 9 F2 W3 이 10 W1 01 100 11 W1 02 0 12 W1 03 0 13 W1 04 3 0 14 W2 01 4 0 15 W2 02 3 0 16 W2 03 2. 0 17 W2 04 501 18 W3 01 0 19 W3 02 150 20 W3 03 3 100 21 W3 04 0 Supply 300 100 0 0 0 100 150 100 100 Change = Delete Reset Al Load/Save Cost 2750 Make Unconstrained variables Non-Negative Select a Solving Method: Simplex LP Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth Help Solve Close

A С E F G J K 1 D Units Shipped Start Node Cost In Supply 3 2 B Route End Node F2 W1 W2 W3 W1 W2 W3 3 4 Node F1 F2 W1 W2 W3 01 02 03 04 10 50 10 250 50 50 10 100 10 H Units Shipped Out et Shipmen =SUM(D3-D6) =H3 =SUM(D7-09) =H4 =SUM(D10-D13) =H5-G5 'ESUM(D14:D17) -H6-G6 =SUM(D18:D21) =H7-G7 =G8 =G9 =G10 =G11 3 =D4+D7 =D5+DS =D6+D9 =D10+D14+D18 =D11+D15+D19 =D12+D16+D20 =D13+D17+D21 300 100 0 0 0 100 150 100 100 4 = 2 3 4 2 3 F1 4 F1 5 F1 6 F1 7 F2 8 F2 9 F2 10 W1 11 W1 12 W1 13 W1 14 W2 15 W2 16 W2 17 W2 18 W3 19 W3 20 W3 21 W3 2 10 02 03 04 01 02 3 0 4 0 Cost =SUMPRODUCT C3:C21,D3:D21) 3 0 2 0 03 04 2 50 2 0 01 02 03 4 150 100 3 14 0

These are the required tabel.

Thank you so much sir.