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 in-class problem. 5. (30 points) Submit your Excel ﬁle on Blackboard. 1...
View Full Document
- Spring '06
- Supply And Demand, Shipping, Ship transport, shipping cost, Company ships coal