I NEED 7-5

This is 7-48

50. Reconsider problem 48 assuming that the maximum amount that can be shipped from either New York or Baltimore through Pittsburgh is 2,000 units due to the size of the plane available for this route. Toyco produces a line of Bonnie dolls and accessories at its plants in New York and Baltimore that must be shipped to distribution centers in Chicago and Los Angeles. The company uses Air Freight, Inc., to make its shipments. Suppose that it can ship directly or through Pittsburgh and Denver. The daily production rates at the plants are respectively 5,000 and 7,000 units daily, and the demands at the distribution centers are respectively 3,500 and 8,500 units daily. The costs of shipping 1,000 units are given in the following table. Find the optimal shipping routes and the associated cost. TO Pittsburgh Denver Chicago Los Angeles F New York $182 $375 $285 $460 R Baltimore 771 290 245 575 O Pittsburgh 275 125 380 M Denver 90 110 Prepare the network diagram for the transshipment problem as shown below: NY PI CH BA DE LA The firm T produces dolls at its plants in NY and B. The firm uses two options. One option is to ship directly to C and LA. Another option is to ship through P and D. The cost of shipping 1,000 units, the demand, and the supply from the plant to the distribution centers are as follows: B E F G 1 2 Route Supply LA 4 Plant NY NY NY-PI 6 NY-P-DE 7 NY-DE Warehouse CH 285 460 =182+125 =1824380 =182+275+90 =182+275+110 =375+90 =375+110 5000 t60 UA 9 Plant BA B B-P B-P-D B-D 245 575 =774125 =77-380 =77+275+90 =77+275+110 =290+90 =290+110 7000 Demand 3500 8500 D Supply B 1 2 Route 3 4. Plant NY NY 5 NY-PI 6 NY-P-DE 7 NY-DE 8 9 Plant BAB 10 B-P 11 B-P-D 12 B-D 13 14 Demand Warehouse CH LA 285 460 307 562 547 567 465 485 5000 245 202 442 380 575 457 462 400 7000 3500 8500 Now, formulate an excel sheet using given values and formulas: www. Val On ing the port 57 Mini City 10 IN NICH . . MODUCHESSESERLER SUMUS SCOUSSSS SCOUT 1 HA H 1 4 SUMPRODUCT(62-2.877) 5 6 7 8 9 10 11 12 13 14 15 5000 2000 3500 8500 Only consider the two routes, either to ship directly or through P and D. Formulated spreadsheet is shown below: 6 H NYO 1 Varaibles Values c O E NY-LABA-CHA-LA 21 35 575 Mint Obj.Function Using transient point 40 567 547 Minimized cost 205 450 42 Constraints 10 11 NY 1 BA 1 CH 14 A . 1 0 . o 1 1 . . 5000 2000 2500 . 1 NY-CH E F G H B NY-CH 0 C NY-LA 5000 D BA-CH 3500 BA-LA 3500 A 1 Varaibles 2 Values 3 4 Obj. Function 5. Using transshipment point P-D 6 7 Minimized cost Minz 4774500 285 547 460 567 245 442 S75 462 285 460 245 462 1 1 0 0 1 OO OO 5000 7000 3500 8500 ### 5000 7000 3500 8500 1 0 1 1 9 Constraints: 10 11 NY 12 BA 13 CH 14 LA 15 The shipping points that reduce the optimal cost using the transshipment points are as given below: Route Number of units NY-CH 0 NY-LA 5,000 BA-CH 3,500 BA-LA 3,500 The optimal cost to transport 12,000 units is $4,774,500