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 |
|||||