Question: Please post step by step solutions for excel solver A company blends two gasolines from Xena Fuels and Yuri Petrol (inputs) into two commercial products,



Please post step by step solutions for 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 pdfStep 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
