Black ridge refining extracts minerals from ore mined at two different sites in utah. each ton of ore type 1 contains 15% copper, 20% zinc and 15% magnesium. each ton of ore type 2 contains 25% copper, 25% zinc and 10% magnesium. ore type 1 costs $90 per ton and ore type 2 costs $120 per ton. black ridge would like to buy enough ore to extract at least 8 tons of copper, 6 tons of zinc, and 5 tons of magnesium in the least costly manner.
a) use the graphical approach to solve this lp problem.
b) formulate a spreadsheet model and use solver to solve this lp problem.
c) based on the sensitivity report, how much would it cost the company to get one more ton of copper? explain.