Question: Please show step by step solution when using the excel solver. A company blends two gasolines from Xena Fuels and Yuri Petrol (inputs) into two

Please show step by step solution when using thePlease show step by step solution when using thePlease show step by step solution when using thePlease show step by step solution when using the excel solver.

A company blends two gasolines from Xena Fuels and Yuri Petrol (inputs) into two commercial products, Super and Regular gasoline (outputs). For the inputs, the octane ratings, the vapour pressures in kilopascals, and the amounts available in cubic metres (ms) and their prices are known. These are: Input Octane Vapour Amount Buying Price Gasoline Rating Pressure (kPa) Available (m) ($ per m) Xena 106 13,500 80 63 21,000 230 36 280 Yuri For the Super and Regular gasolines the requirements are: Output Minimum Gasoline Octane Rating Super Regular 87 Maximum Minimum Selling Vapour Amount Price Pressure (kPa) Required (m) ($ per m) 42 6,000 310 55 15,000 270 94 We define the variables as follows: X and Y are respectively the amount of gasoline in m purchased from Xena Fuels/Yuri Petrol. S and R are respectively the amount of Su- per/Regular gasoline in my blended and sold. XS, XR, YS, and Y R are respectively the amounts in m3 of Xena/Yuri gasoline used to make Super/Regular gasoline. (a) Formulate an algebraic model for the problem. Submit this in Word or pdf. (6) Use the Excel Solver to solve this model. Submit the computer file. (c) State the solution in words. Submit this in Word or pdf

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!