RMC, Inc., is a small firm that produces a variety of chemical products. In a particular production 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 0.4 ton of raw material 1 and 0.6 ton of raw material 3. A ton of solvent base is a mixture of 0.5 ton of raw material 1, 0.2 ton of raw material 2, and 0.3 ton of raw material 3. During the upcoming production period, 20 tons of raw material 1, 5 tons of raw material 2, and 21 tons of raw material 3 are available
After deducting relevant costs, the profit contributions are $40 for every ton of fuel additive produced and $30 for every ton of solvent base produced.
Formulate a linear programming model designed to answer the question: What should RMC produce during the next production period?
Solve the linear programming problem using the Microsoft Excel solver