Steelco manufactures two types of steel at three different steel mills. During a given month, each s
Question: Steelco manufactures two types of steel at three different steel mills. During a given month, each steel mill has 200 hours of blast furnace time available. Because of differences in the furnaces at each mill, the tiMeand cost to produce a ton of steel differ for each mill, as listed in the file P04_62.xls. Each month Steelco must manufacture at least 500 tons of steel 1 and 600 tons of steel 2. Determine how Steelco can minimize the cost of manufacturing the desired steel using Excel's solver.
Price: $2.99
Answer: The answer consists of 2 pages
Deliverable: Word Document![](/images/msword.png)
Deliverable: Word Document
![](/images/msword.png)