Unformatted text preview: shipping cost is minimized. 1. (20 points) Formulate a linear program to determine the optimal shipping schedule. Solve it with Excel. To check your work: in a correct solution Mine 1 ships ONLY to Plant 1. 2. (20 points) Interpret the solution. In other words, state the optimal shipping plan, and how much it will cost. 3. (20 points) The mining company wants to know if there are any mines where they could decrease supply while still meeting all the demand. If there are some mines, list them and explain mathematically why this is the case; otherwise, show mathematically that there are none. 4. (10 points) Explain how this LP formulation is reminiscent of the formulation of the JetGreen inclass problem. 5. (30 points) Submit your Excel ﬁle on Blackboard. 1...
View
Full Document
 Spring '06
 RUBIN,David
 Supply And Demand, Shipping, Ship transport, shipping cost, Company ships coal

Click to edit the document details