Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your company produces three grades of gasolines for industrial distribution. The three grades- premium, regular and economy-are produced by refining a blend of three

 

Your company produces three grades of gasolines for industrial distribution. The three grades- premium, regular and economy-are produced by refining a blend of three types of crude oil: Brent, Dubai and WTI. Each crude oil differs not only in cost per barrel, but in its composition as well. Table 1 below indicates the percentage of three crucial compounds found in each of the crude oils, the cost per barrel for each, and the maximum weekly availability of each. Table 1: Ingredient Data Crude Compound A Oil Type Brent Dubai WTI (%) 35 50 60 Compound B Compound C Cost/Barrel (%) (%) 25 35 30 20 Table 2: Gasoline Data Gasoline Type Premium Regular Economy Compound A Table 2 indicates the weekly demand for each grade of gasoline and the specific conditions on the amounts of the different compounds that each grade of gasoline should contain. The table shows, for example, that in order for gasoline to be classified as premium grade, it must contain at least 55% of compound A, no more than 23% of compound B and no restrictions on compound C. Your company must decide how many barrels of each type of crude oil to buy each week for blending to satisfy demand at minimum cost. > 55% 15 15 40% (S) 86 92 95 23% 25% Compound B Compound C Demand (barrels) 14,000 Availability (barrels) 15,000 32,000 24,000 35% 25% a. Which constraint(s) should you remove from your LP in QI? b. Set up the corresponding LP in Excel and run Solver. 22,000 25,000 1. Write down the linear program to determine the optimal blending plan. (8 marks) 2. Set up the Excel spreadsheet and use Solver to compute the optimal plan. Interpret your Solver's answer report. (8 marks) 3. Your company finds a new crude oil supplier who can sell you unlimited Brent oil at current cost. (2 marks) (2 marks)

Step by Step Solution

3.47 Rating (157 Votes )

There are 3 Steps involved in it

Step: 1

Write down the linear program to determine the optimal blending plan Miimize 86x1 15x2 24x3 Subject ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting A Contemporary Approach

Authors: David Haddock, John Price, Michael Farina

3rd edition

77639731, 978-0077639730

More Books

Students also viewed these Physics questions

Question

In what order do accounts appear in the chart of accounts?

Answered: 1 week ago

Question

What is the standard deviation for Exercise 2?

Answered: 1 week ago