RMC Inc is a small firm that produces a variety of chemicalb

RMC, Inc., is a small firm that produces a variety of chemical-based products. In a particular production process, three raw materials are used to produce two products: a fuel additive and a solvent base. The fuel additive is sold to oil companies and is used in the production of gasoline and related fuels. The solvent base is sold to a variety of chemical firms and is used in both home and industrial cleaning products.

Three raw materials are blended to form the fuel additive and solvent base as indicated in Table A. It shows that a ton of fuel additive is a mixture of 0.4 ton of material 1 and 0.6 ton of material 3. A ton of solvent base is a mixture of 0.5 ton of material 1, 0.2 ton of material 2 , and 0.3 ton of material 3.

RMS\'s product is constrained by a limited availability of three raw materials. For the current production period, RMS has available the following quantities of each raw material.

Amount Available

Material for Production

Material 1     20 tons

Material 2       5 tons

Material 3     21 tons

The accounting department analyzed the production figures, assigned all relevant costs, and arrived at prices for both products that will result in a profit contribution of $40.00 for every ton of fuel additive produced and $30.00 for every ton of solvent based producted. Use linear programming to determine the number of tons of fuel additive and the number of tons of solvent base to produce in order to maximize total profit contribution

1. Write out the Linear Programming Model

2. Set up a chart with all the model parameters

3. Create the Solver problem and highlight the appropriate cells as demonstrated in class.

4. Use Solver and Solver the problem. Create the Sensitivity Report.

5. Change the name of the Sensitivity Report to Prob # Sensitivity Report.

I WOULD LIKE A STEP BY STEP SOLUTION PLEASE

Solution

Ans: a)Rmc\'s production is constrained by a limited availability of the three raw materials.

for the current production period, Rmc available the following quantities of each raw material:

products: a fuel additve and a solvent base the fuel additive is sold to oil companies and is used in the production of gasoline and related fuels.

1. Linear programming model:

problem with just two products:

2) chart with all model parameters:

complete the following takes:

Highlight the appropriate cells as demonstrated in class:

solver the problem:

change the name of the sensitivity report:

recall the production planning problem concerned with four variants of the same product which we formulated before as an LP.