Question

The Distribution Unlimited Co. has two factories producing a product that needs to be shipped to two warehouses • Factory 1 produces 85 units. • Factory 2 produces 65 units. • Warehouse I needs 55 units. • Warehouse 2 needs 95 units. There are rail links directly from Factory 1 to Warehouse 1 and Factory 2 to Warehouse 2. • Independent truckers are available to ship up to so unlts from each factory to the distribution center, and then 50 units from the distribution center to each warehouse The cost varies for different from F1 to W1: $600 from F1 to DC: $300 from DC to W1:52:50 o from DC to W2:5400 from F2 to W2:$500 from F2 to DC: 5700 Question: How many units (truckloads) should be shipped along each shipping lane? Please show the excel model and use solver to solve it.

Answer 1

85 Unite 55 units Produced E W2 need Tounit max) [sounit max] Somn The distribution network WI need DC) 65 units Produced E 95 unite Produced F [5o units max.) DC $100/unit $500/unit need Data for distribution network 85 units $600/unit 55 units WI) need [5ounits $300/unit max. $250 unit $uod unit 65 units produced 95 unit F2 W2

a network model [85] $600 IL F1 WD (55] $300 $259 DC $400 $700 $ 500 F2 [65] 2) (95) The optimal solution (85) FI (35) [-55] W) (50) [20] [0] DC [20] (50] F2) W2) (-95] [65] (45)