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.
RMCinc., is a small firm that produces a variety RMCinc., 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 kilos of material and kilos of material A kilo of solvent base is a mixture of kilos of materials kilos of materials and kilos of material After deducting relevant costs, the profit contribution is for every kilo of fuel additive produced and for every kilo of solvent base produced. RMCs 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 kilos
Material Kilos
Material Kilos
Assuming that RMC is interested in maximising the total profit contribution,
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?
Produce an Excel model and use Solver to replicate the WordProcessed 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 kilos of material and kilos of material A kilo of solvent base is a mixture of kilos of materials kilos of materials and kilos of material After deducting relevant costs, the profit contribution is for every kilo of fuel additive produced and for every kilo of solvent base produced. RMCs 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 kilos
Material Kilos
Material Kilos
Assuming that RMC is interested in maximising the total profit contribution,
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?
Produce an Excel model and use Solver to replicate the WordProcessed calculation.
Step 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
