"Steelco has received an order for exactly 125 tons of steel. The order must contain at least 5.5 tons of nickel, at most 3.2 tons of carbon, and...

"Steelco has received an order for exactly 125 tons of steel. The order must contain at least 5.5 tons of nickel, at most 3.2 tons of carbon, and exactly 4 tons of manganese. To fill the order Steelco can combine four alloys whose chemical composition is given in Table below. Steelco wishes to minimize the cost for filling the order. How many tons from each Alloy should be in the order. Alloy 1 Alloy 2 Alloy 3 Alloy 4Nickel 8% 5% 3% 4% Carbon 3% 4% 5% 6% Manganese 5% 6% 3% 2% Cost/ton $15 $12 $10 $5 solve it by using the excel solver" ""