Categories
Uncategorized

The purpose of this assignment is to extend the Transportation Model to a more realistic application of linear programming, the Transshipment Model.

Purpose The purpose of this assignment is to extend the Transportation Model to a more realistic application of linear programming, the Transshipment Model.

In this model, intermediate trans-shipment points are added between the sources and destinations. These intermediate points do not hold inventory. Items may be transported from sources through transhipment points onto destinations.

You will use Solver to find the solution. Task Complete problem S11.38 Use the template provided.

Do not alter this template Add in the formulations needed in the excel spreadsheet. Open solver and complete all the necessary fields Run solver Address any questions asked about the problem.

You must submit the excel file with the formulas in the appropriate cells. You must use solver to find the correct answers. I will run the solver to veriiqufy your set up is correct.

Shipping Costs ($):
 Distribution Center   Distribution Center
WarehouseABCSupplyShippedWarehouseABC
1   70 112117
2   80 28614
3   50 391012
Shipped     
Shipping Costs ($):
  Distribution Center   Distribution Center
Distribution CenterABCShippedDistribution CenterABC
A    A83
B    B1 2
C    C72 
   Demand6010040 
 Shipped    
Transshipment flows: 
 A 
 B 
 C 
Cost = 

Leave a Reply

Your email address will not be published. Required fields are marked *