PLEASE SOLVE USING EXCEL SOLVER. PLEASE SHOW ALL FROMULAS ANDCONSTRAINTS USED.
An oil company produces three brands of oil: regular,multigrade, and supreme. Each brand of oil is composed of one ormore of four crude stocks, each having a different lubricationindex. The relevant data concerning the crude stocks are asfollows. Crude Stock Lubrication Index Cost/Barrel Daily Supply(Barrels) 1 20 7.10 1000 2 40 8.50 1100 3 30 7.70 1200 4 55 9.001100 Each brand of oil must meet a minimum standard for alubrication index, and each brand thus sells at a different price.The relevant data concerning the three brands of oil are
OR
PayPal Gateway not configured
OR
PayPal Gateway not configured