Question: Hello, i need an urgent help. explain me the answer to this question step by step explaining each part in descrpitive format as well. RMC

Hello, i need an urgent help. explain me the answer to this question step by step explaining each part in descrpitive format as well.
RMC,inc., is a small firm that produces a variety 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 kilo of fuel additive is a mixture of 0.4 kilos of material 1 and 0.6kilos of material 3. A kilo of solvent base is a mixture of 0.5kilos of materials 1,0.2 kilos of materials 2 and 0.3kilos of material 3. After deducting relevant costs, the profit contribution is 40 for every kilo of fuel additive produced and 30 for every kilo 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 120 kilos
Material 25 Kilos
Material 321 Kilos
Assuming that RMC is interested in maximising the total profit contribution,
1. answer the following:
(a) What is the linear programming model for this problem?
(b) Find the optimal solutions using the graphical solutions procedure. How much kilos 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 there any redundant constraints? If so, which ones?
2. Produce an Excel model and use Solver to replicate the Word-Processed calculation.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 kilo of fuel additive is a mixture of 0.4 kilos of material 1 and 0.6kilos of material 3. A kilo of solvent base is a mixture of 0.5kilos of materials 1,0.2 kilos of materials 2 and 0.3kilos of material 3. After deducting relevant costs, the profit contribution is 40 for every kilo of fuel additive produced and 30 for every kilo 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 120 kilos
Material 25 Kilos
Material 321 Kilos
Assuming that RMC is interested in maximising the total profit contribution,
1. answer the following:
(a) What is the linear programming model for this problem?
(b) Find the optimal solutions using the graphical solutions procedure. How much kilos 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 there any redundant constraints? If so, which ones?
2. Produce an Excel model and use Solver to replicate the Word-Processed calculation.

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!