Only answer B please.

Only answer B please.

Fisher & MacInroy Mining and Metalwork Company produces metal alloys from six different ores it mines. The ore which the company mines at the Adams Mine in Northern Ontario we will be calling ore A for convenience. Also, ore B the company gets at the Bell Creek Mine, ore C at the Copperfield Mine, ore D at the Douglass Mine, ore E at the Eagle River Mine, and ore F at the Fraser Mine. The company has an order from John Wiley Technology in the US to produce 100 tons of an alloy that contains four metals according to the following specifications: The alloy should contain at least 21% of metal Alpha. The alloy should contain no more than 12% of metal Beta. The alloy should contain no more than 7% of metal Gamma. The alloy should contain between 30% and 65% of metal Delta. We will abstain from naming the metals as it has to do with the customer's technological know- how. Let us call them Alpha, Beta, Gamma, and Delta. The proportion of the four metals in each of the six ores and the level of impurities in each ore are provided in the following table. Ore A B D E F Alpha 19 43 17 20 0 12 Metal (%) Beta Gamma 15 12 10 25 0 0 12 0 10 18 16 Delta 14 7 53 18 31 25 Impurities (%) 40 15 30 50 Cost/ton (S) 2700 2500 3200 2200 2000 2400 24 35 29 When the metals are processed and refined, the impurities are removed. Fisher & MacInroy Mining and Metalwork Company wants to know the amount of each ore they should use to produce 100 tons of the alloy that will minimize the cost the alloy. a. Formulate a linear programming model for this problem. Indicate the decision variables, objective function, and model constraints. b. Solve the problem using the Excel Solver. Provide Excel Answer Report and Excel Sensitivity Report