Question: please help me asap Consider the table below, representing the cost of shipping one unit of a good from each source (New Jersey, Chicago, and

Consider the table below, representing the cost of shipping one unit of a good from each source (New Jersey, Chicago, and Denver) to each destination (Atlanta, Houston, Los Angeles, and Seattle). Assume no fixed costs and that all three sources are available for operation. Demand and capacity are also as given in the table. FOLLOWING THE TRANSPORTATION LP we did in class, and using Excel Solver, determine how many units should be shipped from each source to each destination so as to minimize cost of transshipment. From these results we know: Seattle will receive all 20 units demanded from Chicago Los Angeles will receive all 40 units demanded from Denver all of the available options are correct Atlanta will receive all 30 units demanded from New Jersey Reconsider your results from the previous question. We also know that We have excess capacity in all of our plants. We are using all of our capacity in our Chicago and Denver plants. We are using all of our capacity in our New Jersey and Denver plants. We are using all of our capacity in our Chicago and New Jersey plants
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
