Question: Find the profit using EXCEL. Show the full work RMC, Inc., is a small firm that produces a variety of chemical products. In a particular

Find the profit using EXCEL.
Show the full work
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 35 ton of material 1 and 35 of material 3. A ton of solvent base is a mixture of 12 ton of material 1,75 ton of material 2, and %0 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. RMC's 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 Production Material 1 20 tons Material 2 5 tons Material 3 21 tons Assuming that RMC is interested in maximizing the total profit contribution, answer the followingStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
