Please provide excel with formulas and values both, upvote will be given CASE 4.1 BLENDING AVIATION GASOLINE
Fantastic news! We've Found the answer you've been seeking!
Question:
Please provide excel with formulas and values both, upvote will be given
Transcribed Image Text:
CASE 4.1 BLENDING AVIATION GASOLINE AT JANSEN GAS ansen Gas creates three types of aviation gaso- line (avgas), labeled A, B, and C. It does this by blending four feedstocks: Alkylate; Catalytic Cracked Gasoline; Straight Run Gasoline; and Isopentane. Jansen s production manager, Dave Wagner, has compiled the data on feedstocks and Table 4.6 Data on Feedstocks Feedstock Gallons available (1000s) Value per gallon Reid vapor pressure Octane (low TEL) Octane (high TEL) Table 4.7 Data on Gasoline Gasoline Gallons required (1000s) Price per gallon Max Reid pressure Min octane TEL level Alkylate 140 $4.50 5 98 107 A 120 $3.00 7 90 Low Note that each feedstock can have either a low or a high level of TEL, which stands for tetraethyl lead. This is measured in units of milliliters per gallon, so that a low level might be 0.5 and a high level might be 4.0. (For this problem, the actual numbers do not matter.) As indicated in Table 4.6, the TEL level af- fects only the octane rating, not the Reid vapor pres- sure. Also, gas A is always made with a low TEL level, whereas gas types B and C are always made with a high TEL level. As indicated in Table 4.7, each gasoline has two requirements: a maximum allowable Reid vapor pressure and a minimum required octane rating. In addition to these requirements, the company wants to ensure that the amount of gas A produced is at least as large as the amount of gas B produced. gas types in Tables 4.6 and 4.7. Table 4.6 lists the availabilities and values of the feedstocks, as well as their key chemical properties, Reid vapor pres- sure, and octane rating. Table 4.7 lists the gallons required, the prices, and chemical requirements of the three gas types. CCG 130 $2.50 8 87 93 B 130 $3.50 7 97 High SRG 140 $2.25 4 83 89 Isopentane 110 $2.35 20 101 108 C 120 $4.00 7 100 High Dave believes that Jansen can sell all of the gaso- line it produces at the given prices. If any feedstocks are left over, they can be sold for the values indicated in Table 4.6. He wants to find a blending plan that meets all the requirements and maximizes the revenue from selling gasoline and leftover feedstocks. To help Dave with this problem, you should develop an LP op- timization model and then use Solver to find the opti- mal blending plan. Then, using this model as a starting point, you should answer the following questions: I. Dave is not absolutely sure that the side con- straint of at least as much gas A as gas B is nec- essary. What is this constraint costing the com- pany? That is, how much more revenue could Jansen earn if this constraint were ignored? 2. Dave consults the chemical experts, and they suggest that gas B could be produced with a medium level of TEL. The octane ratings for each feedstock with this medium level would be halfway between their low and high TEL octane ratings. Would this be a better option in terms of its optimal revenue? 3. Suppose that because of air pollution concerns, Jansen might have to lower the Reid vapor pres- sure maximum on each gas type (by the same amount). Use Solver Table to explore how such a change would affect Jansen s optimal revenue. 4. Dave believes the minimum required octane rat- ing for gas A is too low. He would like to know how much this minimum rating could be increased before there would be no feasible solution (still assuming that gas A uses the low TEL level). 5. Dave suspects that only the relative prices mat- ter in the optimal blending plan. Specifically, he believes that if all unit prices of the gas types and all unit values of the feedstocks increase by the same percentage, then the optimal blending plan will remain the same. Is he correct? CASE 4.1 BLENDING AVIATION GASOLINE AT JANSEN GAS ansen Gas creates three types of aviation gaso- line (avgas), labeled A, B, and C. It does this by blending four feedstocks: Alkylate; Catalytic Cracked Gasoline; Straight Run Gasoline; and Isopentane. Jansen s production manager, Dave Wagner, has compiled the data on feedstocks and Table 4.6 Data on Feedstocks Feedstock Gallons available (1000s) Value per gallon Reid vapor pressure Octane (low TEL) Octane (high TEL) Table 4.7 Data on Gasoline Gasoline Gallons required (1000s) Price per gallon Max Reid pressure Min octane TEL level Alkylate 140 $4.50 5 98 107 A 120 $3.00 7 90 Low Note that each feedstock can have either a low or a high level of TEL, which stands for tetraethyl lead. This is measured in units of milliliters per gallon, so that a low level might be 0.5 and a high level might be 4.0. (For this problem, the actual numbers do not matter.) As indicated in Table 4.6, the TEL level af- fects only the octane rating, not the Reid vapor pres- sure. Also, gas A is always made with a low TEL level, whereas gas types B and C are always made with a high TEL level. As indicated in Table 4.7, each gasoline has two requirements: a maximum allowable Reid vapor pressure and a minimum required octane rating. In addition to these requirements, the company wants to ensure that the amount of gas A produced is at least as large as the amount of gas B produced. gas types in Tables 4.6 and 4.7. Table 4.6 lists the availabilities and values of the feedstocks, as well as their key chemical properties, Reid vapor pres- sure, and octane rating. Table 4.7 lists the gallons required, the prices, and chemical requirements of the three gas types. CCG 130 $2.50 8 87 93 B 130 $3.50 7 97 High SRG 140 $2.25 4 83 89 Isopentane 110 $2.35 20 101 108 C 120 $4.00 7 100 High Dave believes that Jansen can sell all of the gaso- line it produces at the given prices. If any feedstocks are left over, they can be sold for the values indicated in Table 4.6. He wants to find a blending plan that meets all the requirements and maximizes the revenue from selling gasoline and leftover feedstocks. To help Dave with this problem, you should develop an LP op- timization model and then use Solver to find the opti- mal blending plan. Then, using this model as a starting point, you should answer the following questions: I. Dave is not absolutely sure that the side con- straint of at least as much gas A as gas B is nec- essary. What is this constraint costing the com- pany? That is, how much more revenue could Jansen earn if this constraint were ignored? 2. Dave consults the chemical experts, and they suggest that gas B could be produced with a medium level of TEL. The octane ratings for each feedstock with this medium level would be halfway between their low and high TEL octane ratings. Would this be a better option in terms of its optimal revenue? 3. Suppose that because of air pollution concerns, Jansen might have to lower the Reid vapor pres- sure maximum on each gas type (by the same amount). Use Solver Table to explore how such a change would affect Jansen s optimal revenue. 4. Dave believes the minimum required octane rat- ing for gas A is too low. He would like to know how much this minimum rating could be increased before there would be no feasible solution (still assuming that gas A uses the low TEL level). 5. Dave suspects that only the relative prices mat- ter in the optimal blending plan. Specifically, he believes that if all unit prices of the gas types and all unit values of the feedstocks increase by the same percentage, then the optimal blending plan will remain the same. Is he correct?
Expert Answer:
Answer rating: 100% (QA)
Answer 1 The side constraint of at least as much gas A as gas B is costing the company in terms of revenue By including this constraint the company is not able to maximize the amount of revenue earned ... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
Create a balanced scorecard for the case study Value - Driven Project and Portfolio Management in the Pharmaceutical Industry that represents an analysis of program management using the four...
-
Some companies create a Balanced Scorecard by taking some current objectives and key performance indicators (KPI) and assigning them to the four Balanced Scorecard perspectives. Describe the...
-
Describe the various types of financial intermediaries, including the sources of their funds and the types of investments they make.
-
In Exercises verify the identity. coshx = 1 + cosh 2x 2
-
How do markets for loans use signaling and screening to cope with private information?
-
The Fowler Martial Arts Academy trains young boys and girls in self-defense. Joan Fowler, the owner of the academy, notes that monthly revenue is higher when school is in session but quite low when...
-
Reach a conclusion as to whether number of years of training makes a good chef (and the higher the better on the Chef's Score).
-
Use exponential smoothing with a smoothing constant of 0.3 to forecast the demand for fertilizer given in Problem 5-15. Assume that last period's forecast for year 1 is 5,000 bags to begin the...
-
Like the formal region, a perceptual region is objectively defined, but it has unity in its active connectivity, not its static content
-
"Part 1: The Performance Lawn Equipment database contains data needed to develop a pro forma income statement. Dealers selling PLE products all receive 18% of sales revenue for their part of doing...
-
With its conference championship win on November 15th, tiny Faber College in Cottage Grove, Oregon, has clinched its first-ever berth in the collegiate lacrosse championship. Kent Dorfman, the intern...
-
Bingo Oil Corporation recently acquired a truck costing $60,000 with an estimated life of five years (ignore salvage value). The foreman drives the truck to oversee operations on seven leases, all in...
-
The cost structure (%) of an article with a selling price of 45,000 is as follows: An increase of 15 per cent in the cost of material and of 25 per cent in the cost of labour is anticipated. These...
-
A manufacturer can sell part of the output of process 1 as it is or process it further in process 2. What cost are relevant in a decision to sell it as it is or to process it further? What costs are...
-
A company wants to purchase a plant for its expanding operations. The desired plant is available at 3,00,000 in cash or 4,50,000 to be paid in 5 equal annual instalments due at the end of each year....
-
The Libby Oil Corporation incurs unproved property (Lease A) costs of $60,000 on April 1, 2018. An 8% loan is obtained on April 1, 2018 for $500,000 to finance a drilling program. Libby started a...
-
FIRM H owns and operates one the largest storage facility businesses in the United States. It provides storage space for small businesses and individuals. The following data present key ratios for...
-
Read the Forecasting Supply Chain Demand Starbucks Corporation case in your text Operations and Supply Chain Management on pages 484-485, then address the four questions associated with the...
-
After a 5-for-1 stock split, the Swenson Company paid a dividend of $0.75 per new share, which represents a 9 percent increase over last years presplit dividend. What was last years dividend per...
-
Your broker offers to sell you a note for $13,250 that will pay $2,345.05 per year for 10 years. If you buy the note, what rate of interest (to the closest percent) will you be earning?
-
A few days ago, Deanna Watson purchased 100 shares of Microsoft common stock for$35per share. Deanna is single, and her taxable income (after all deductions and exemptions) is $75,000.Compute the...
-
If lizards adapt their behavior to the fire ants, then lizards from the invaded habitats should flee from the fire ants faster than lizards from the uninvaded habitats. Test this hypothesis. The...
-
If lizards adapt their behavior to the fire ants, then lizards from the invaded habitats should twitch more than lizards from uninvaded habitats when exposed to red imported fire ants (twitching...
-
Exercise 2.153 describes a study to compare the cost of restaurant meals when people pay individually versus splitting the bill as a group. In the experiment 48 subjects were randomly assigned to...
Study smarter with the SolutionInn App