Question: Please provide the Excel process/formulations. Thank you! Solve the following problems using a computer application (Excel, Excel QM, QM or Excel Solver, etc.) For all

Please provide the Excel process/formulations.Please provide the Excel process/formulations.Please provide the Excel process/formulations. Thank you!

Solve the following problems using a computer application (Excel, Excel QM, QM or Excel Solver, etc.) For all the problems, make sure the following are included: o Complete solutions, the complete Linear Programming formulation or model, and the FINAL answers (highlighted in yellow or any other color you wish.) 3) Three types of gasoline are manufactured by a company - Regular, Super, and Extra. Regular should have at least 11percent additive 1 and 17 percent additive 2. Super should have at least 13 percent additive 1 and 22 percent additive 2. Extra should have at least 17 percent additive 1 and 19 percent additive 2. These are made by using two crudes - A and B. Crude A cost $28 per barrel and is 14 percent additive 1 and 18 percent additive 2. Crude B costs $30 per barrel and is 20 percent additive 1 and 24 percent additive 2. The demand for Regular is projected to be 1,000 barrels, while each of the others has a demand of 2,000 barrels. Formulate this as a linear programming problem to minimize cost while meeting all constraints. Remember to carefully define all decision variables and do not forget to indicate the optimal answer! (Blending application)

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!