Problems:
Integer Programming Problem: Transportation and Transshipment
Part 1 Transportation
Part 2 (Transshipment):
By including intermediary distribution centers X and Y as shown below and using the given network, will the company save money in its transportation costs compared to the results obtained in part 1? Need assistance solving the problem by using Excel, and find the optimal cost.
Instructions:
Need assistance solving parts 1 and 2 in the same Excel workbook and in two different sheets (Sheet 1 and sheet 2).
For each part, need assistance defining the decision variables (for example in part 1, XAP represents the number of units to be transported from source A to destination P), the objective function, and the constraints. Please write all the above in the corresponding Excel spreadsheet.