Question: please read thoroughly, and use excel functions, no hand written. thank you The manager of an oil refinery must decide on the optimal number of

please read thoroughly, and use excel functions, no hand written. thank you please read thoroughly, and use excel functions, no hand written. thank you

The manager of an oil refinery must decide on the optimal number of two possible blending processes. Process 1: Requires 5 units of crude oil A and 3 units of crude oil B Produces 6 units of winter gasoline and 8 units of summer gasoline Process 2: Requires 4 units of crude oil A and 5 units of crude oil B Produces 4 units of winter gasoline and 4 units of summer gasoline The maximum amount available of crude A and B is 200 units and 150 units respectively. Market requirements show that at least 100 units of winter gasoline and 90 units of summer gasoline must be produced. The prolits per production run from process 1 and process 2 are 3 million dollars and 4 million dollars, respectively. Construct the Linear Programming model required to maximize the profit. No need to solve for the optimal solution

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!