Use Excel Solver

MC, Inc., is a small firm that produces a variety of chemical products. In a particular pro-duction process, three raw materials are blended (mixed together) to produce two products: a fuel additive and a solvent base. Each ton of fuel additive is a mixture of 2/5 ton of material 1 and 3/5 of material 3. A ton of solvent base is a mixture of ton of material 1, 1/5 ton of material 2, and 310 ton of material 3. After deducting relevant costs, the profit contribution is $40 for every ton of fuel additive produced and $30 for every ton of solvent base produced.RMCs production is constrained by a limited availability of the three raw materials. For the current production period, RMC has available the following quantities of each raw material:Raw Material Amount Available for ProductionMaterial 1 20 tonsMaterial 2 5 tonsMaterial 3 21 tonsAssuming that RMC is interested in maximizing the total profit contribution, answer the following:

a. What is the linear programming model for this problem?

b. Find the optimal solution using excel solver. How many tons of each product should be produced, and what is the projected total profit contribution?

c. Is there any unused material? If so, how much?

d. Are any of the constraints redundant? If so, which ones