Your company produces three grades of gasolines for industrial distribution. The three grades- premium, regular and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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) 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)
Expert Answer:
Answer rating: 100% (QA)
Write down the linear program to determine the optimal blending plan Miimize 86x1 15x2 24x3 Subject ... View the full answer
Related Book For
College Accounting A Contemporary Approach
ISBN: 978-0077639730
3rd edition
Authors: David Haddock, John Price, Michael Farina
Posted Date:
Students also viewed these physics questions
-
The Low Knock Oil Company produces two grades of cut-rate gasoline for industrial distribution. The grades, regular and economy, are produced by refining a blend of two types of crude oil, type X100...
-
Raptor Fuels produces three grades of gasoline Regular, Premium, and Super. All of these are produced by blending two types of crude oil Crude A and Crude B. The two types of crude contain specific...
-
OILCO produces three grades of gasoline (regular, premium, and super) by blending three types of crude oil. All three types of crude oil contain two important ingredients (X and Y) required to...
-
Let Z[] be the following set of rational numbers { a Z, k N} (and recall that N = {0, 1, 2,...} in this class). Let the addition and multiplication for Z[] be the usual addition and multiplication...
-
A movie theater has had a poor accounting system. The manager has no idea how many large containers of popcorn are sold per movie showing. She knows that the amounts vary by day of the week and hour...
-
Calculate the range, variance, and standard deviation for the following samples: a. 39, 42, 40, 37, 41 b. 100, 4, 7, 96, 80, 3, 1, 10, 2 c. 100, 4, 7, 30, 80, 30, 42, 2 Discuss.
-
Eco-efficiency provides necessary but not sufficient indicators of environmental performance. What is environmental performance? Provide an example of another type of information that is important...
-
Indicate whether each of these equations applies to a service organization (SER), a retail organization (RET), or a manufacturing organization (MANF): 1. Cost of Goods Sold Beginning Merchandise...
-
Assuming the following information, prepare the necessary adjusting journal entries. Accounts Receivable Balance Net Credit Sales Allowance for Doubtful Accounts Bad Debts Expense $ 10,000 (debit)...
-
The CitruSun Corporation ships frozen orange juice concentrate from processing plants in Eustis and Clermont to distributors in Miami, Orlando, and Tallahassee. Each plant can produce 20 tons of...
-
TAL Apparel Limited, a small and weak member of the apparel industry, proved its capability to sustain competitiveness by deploying technologies to improve its supply chain management. The company...
-
Explain s everal re asons for te rmination of l eases.
-
Indicate whether each of the following statements is true or false by writing T or F i n t he a nswer c olumn. A landlord is liable for all injuries that occur on the leased premises.
-
Indicate whether each of the following statements is true or false by writing T or F i n t he a nswer c olumn. A tenant usually has the right to assign or sublease the leased property with the...
-
A judicial body empowered by law to review the findings of a lower judicial body. a. administrative law b. appellate court c. civil law d. common law e. criminal law f. defendants g. express powers...
-
Court decisions that later courts tend to follow. a. administrative law b. appellate court c. civil law d. common law e. criminal law f. defendants g. express powers h. implied powers i. original...
-
how a java class called Quadrilaterals can construct Quadrilateral objects given the coordinates of the 4 vertices. The subprograms should calculate the properties of a quadrilateral, as specified...
-
Suppose the concentration of glucose inside a cell is 0.1 mm and the cell is suspended in a glucose solution of 0.01 mm. a. What would be the free energy change involved in transporting 10-o mole of...
-
A chart of accounts varies with each type of business as well as each company. In a group, compare and contrast the accounts that would appear in Coles Real Estate Office, Sarahs Clothing Emporium,...
-
Good to Go Auto Products distributes automobile parts to service stations and repair shops. The adjusted trial balance data that follows is from the firms worksheet for the year ended December 31,...
-
In what order do accounts appear in the chart of accounts?
-
Several sources of GAAP consulted by an auditor are in conflict as to the application of an accounting principle. Which of the following should the auditor consider the most authoritative? a. FASB...
-
In the opening paragraph of the standard audit report, auditors acknowledge their responsibility to a. Conduct their audit in accordance with generally accepted auditing standards. b. Evaluate the...
-
The auditor's standard report should be titled, and the title should include the word a. Standard. c. Independent. b. Opinion. d. Audit.
Study smarter with the SolutionInn App