Question 5: The Fagersta Steelworks currently is working two mines to obtain its iron ore. This iron ore is shipped to either of two storage facilities. When needed, it then is shipped on to the company's steel plant. The diagram below depicts this distribution network, where M1 and M2 are the two mines, S1 and S2 are the two storage facilities, and P is the steel plant. The diagram also shows the monthly amounts produced at the mines and needed at the plant, as well as the shipping cost and the maximum amount that can be shipped per month through each shipping lane. $2,000/ton 40 tons produced M1 S1 30 tons max. $400/ton $1,700/ton 70 tons max. 100 tons needed 30 tons max. P $1,600/ton $800/ton 50 tons max. 70 tons max. $1,100/ton 60 tons produced M2 S2 50 tons max. Management now wants to determine the most economical plan for shipping the iron ore from the mines through the distribution network to the steel plant. a. Express this model in algebraic form. b. Formulate and solve a linear programming model for this problem on a Excel spreadsheet