In: Operations Management
Transportation Homework | ||||||||
Cost Table | NY | Boston | LA | Fl | ||||
Japan | 20 | 22 | 10 | 16 | ||||
China | 25 | 26 | 12 | 14 | ||||
Malysia | 18 | 20 | 14 | 13 | ||||
Philipines | 22 | 19 | 8 | 14 | ||||
India | 24 | 11 | 20 | 16 | ||||
Part(a) | Submit an excel sheet (with solver) showing the min cost to send the 2500 units | |||||||
Supply | Demand | |||||||
Japan | 300 | NY | 520 | |||||
China | 500 | Boston | 630 | |||||
Malysia | 700 | LA | 740 | TD | ||||
Philipines | 600 | TS | Fl | 850 | 2740 | |||
India | 400 | 2500 | ||||||
Part(b) | Submit an excel sheet (with solver) showing the min cost to send the 2500 units | |||||||
Supply | Demand | |||||||
Japan | 300 | NY | 370 | |||||
China | 500 | Boston | 530 | |||||
Malysia | 700 | LA | 440 | TD | ||||
Philipines | 600 | TS | Fl | 850 | 2190 | |||
India | 400 | 2500 |
Transportation HW Given the COST TABLE in the excel file – solve the transportation problem TWO times. Once with TS > TD and again with TS < TD TS > TD should be in ONE worksheet TS < TD should be in another worksheet |