BC Construction extracts minerals from ore mined at two different sites in Pennsylvania.

Each ton of ore type 1 contains 50% copper, 10% zinc, and 15% magnesium.

Each ton of ore type 2 contains 15% copper, 25% zinc, and 10% magnesium.

Ore type 1 costs $90 per ton, while ore type 2 costs $120 per ton.

BC Construction 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.

Create a spreadsheet model for this problem and solve it using Excel Solver. Thanks again!