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

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 following

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!