Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 28, 2024

Part II. Sensitivity Analysis in LP Consult the LINDO output to answer the questions below A refinery takes four type of raw gasoline, blends them,

Part II. Sensitivity Analysis in LP Consult the LINDO output to answer the questions below A refinery takes four type of raw gasoline, blends them, and produces three types of fuel Raw Gasoline 1 2 Available (barrels/day) 4200 5550 7900 Price (S/barrel) 30.55 35.11 38.73 Octane Rating 65 88 91 3 4 98 4800 40.15 1/5 Selling Price (S/barrels) 50.71 Demand (barrels/day) 8,000 Any amount can be sold Minimum Fuel Blend TypeOctane Rating 1 93 47.55 2 91 86 45.99 13,000 Raw gasoline not used in blending can be sold at $40.95/barrel if octane rating 2 90 $38.85/barrel if octane rating 2) -28 X11 3) - 21 X13 2 X23 5 X33 12 X43 X11 X12 X13 Yi 9) 8000 10) 13000 END LINDO Output LP OPTIMUM FOUND AT STEP OB JECTIVE FUNCTION VALUE 1) 235674.2 VARIABLE VALUE REDUCED COST 0.000000 0.000000 X21 3900.892822 0.000000 0.000000 3900.892822 0.000000 0.000000 X31 X41 0.000000 0.000000 X12 0.000000 0.000000 0.000000 X22 2.045990 X32 2.312857 X42 2.935549 2551.785645 1649.107178 0.000000 x13 X23 0.000000 X43 7900.000000 0.000000 0.000000 0.000000 899.107117 1648.214233 0.000000 0.000000 9.742143 Y2 Y3 Y4 8.912857 0.000000 11.877857 DUAL PRICES ROW SLACK OR SURPLUS 2) 3) 0.000000 0.423571 0.00000 0.334615 4) 0.0000 -0.423571 5) 0.0000 8.300000 6) 0.000000 13.482142 7) 0.000000 11.132857 8) 9) 0.000000 12.677857 198.214279 0.000000 10) 0.000000 -1.755000 NO. ITERATIONS= 8 RANGES IN WHICH THE BASIS IS UNCHANGED: OBJ COEFFICIENT RANGES VARIABLE CURRENT ALLOWABLE ALLOWABLE INCREASE COEF DECREASE X11 20.160000 0.000001 INFINITY x21 15.600000 NINIT 0.000000 X31 11.980000 0.000001 INFINITY 0.000002 X41 10.560000 0.000000 X12 17.000000 10.903472 8.700000 X22 12.440000 2.045989 INFINITY 8.820000 INFINITY X32 2.312858 X42 7-400000 2.935550 INFINITY X13 15.440000 7.020000 0.000000 X23 10.880000 0.000000 3.471981 X33 7.260000 INFINITY 0.000001 5.840000 0.000000 X43 0.000002 8.300000 8-700000 7.020000 3.740000 INFINITY INFINITY INEIITY 2 9.742143 2.220000 Y3 8.912857 Y4 0.800000 11.877857 RIGHTHAND SIDE RANGES ROW CURRENT ALLOWABLE ALLOWABLE DECREASE RHS INCREASE 0.000000 10945.651367 5549.999512 0.000000 0.000000 42853.570312 0.000000 71449.992188 5549.999512 4200.000000 INFINITY 1648.214233 6 5550.000000 241.304337 2798.484863 7 7900.000000 4800.000000 8000.000000 13000.000000 213.461533 168.181808 7900.000000 2189.130371 INFINITY 198.214279 10 6592.856934 264.285706 THE TABLEAU X22 ROW (BASIS) X11 X21 X31 X41 X12 2.046 0.411 0.000 1 ART 0.000 0.000 0.000 0.000 3.300 0.700 0.000 0.000 2 X21 1.000 0.000 0.000 3 X12 0.000 0.000 1.000 0.115 0.000 4 X13 1.000 0.000 0.000 0.000 0.179 1.000 -0.700 33 0.000 0.000 0.000 0.000 0.000 -3.300 0.000 0.000 0.000 6 X23 0.589 7 X41 -2.300 0.000 0.300 1.000 0.000 0.411 X43 2.300 0.000 0.000 -0.300 0.000 0.000 0-411 SLK 9 9 0.000 0.000 0.000 0.000 -0.821 10 0.000 0.000 0.000 0.000 0.000 0.063 X32 X33 ROW X42 X13 X23 X43 2.313 0.000 0.000 0.000 2.936 0.000 0.000 0.000 0.000 0.000 0.000 0.464 0.000 0.589 -0.269 0.000 0.000 0.000 0.000 0.000 2 3 0.000 0.000 -0.071 0.179 1.000 0.000 0.000 0.000 1.000 0.000 0.000 0.000 1.000 0.000 0.000 0.000 -0.464 -0.589 0.000 1.000 0.000 0.000 0.464 0.589 0.000 0.000 0.000 0.000 0.000 0.000 0.000 8 -0.464 0.411 0.000 0.000 1.000 0.000 0.000 0.000 -1.179 9 -0.929 0.000 0.000 0.000 1.000 10 0.071 0.091 0.000 0.000 0.000 SLK 3 ROW Y2 3 Y4 SLK 2 SLK 4 SLK 5 1 9.742 8.913 11.878 0.424 0.335 0.424 8.300 2 0.411 0.464 0.589 0.118 0.000 0.018 0.000 0.000 3 0.000 0.000 0.000 0.000 0.038 0.000 4 -0.179 -0.071 0.179 0.036 0.000 0.036 0.000 0.000 0.000 0.000 1.000 0.000 0.000 0.000 0.589 0.411 0.464 0.464 -0.589 -0.118 0.000 -0.018 0.000 0.000 0.000 0.082 7 0.589 0.000 0.018 0.411 -1.179 -0.411 0.464 0.082 0.000 -0.018 0.821 -0.929 -0.036 0.000 -0.036 0.000 -0.038 10 0.179 0.071 0.179 -0.036 -0.036 1.000 4/5 ROW SLK 6 SLK 7 SLK 8 SLK 9 SLK 10 RHS 11.133 1.755 13.482 12.678 0.000 0.24E+06 0.411 0.464 0.589 0.000 0.375 3900.893 3 0.000 0.000 0.000 0.000 0.000 0.000 4 -0.179 0.071 0.179 0.000 -0.250 2551.786 7900.000 1649.107 0.000 1.000 0.000 0.000 0.000 0.589 -0.464 -0.589 0.000 -0.375 0.375 0.375 0.411 0.464 0.589 0.000 0.000 3900.893 899.107 8 -0.411 -0.464 0.411 -0.929 -1.179 198.214 -0.821 1.000 -0.750 0.179 0.071 0.250 10 -0-179 0.000 1648.214 Part II. Sensitivity Analysis in LP Consult the LINDO output to answer the questions below A refinery takes four type of raw gasoline, blends them, and produces three types of fuel Raw Gasoline 1 2 Available (barrels/day) 4200 5550 7900 Price (S/barrel) 30.55 35.11 38.73 Octane Rating 65 88 91 3 4 98 4800 40.15 1/5 Selling Price (S/barrels) 50.71 Demand (barrels/day) 8,000 Any amount can be sold Minimum Fuel Blend TypeOctane Rating 1 93 47.55 2 91 86 45.99 13,000 Raw gasoline not used in blending can be sold at $40.95/barrel if octane rating 2 90 $38.85/barrel if octane rating 2) -28 X11 3) - 21 X13 2 X23 5 X33 12 X43 X11 X12 X13 Yi 9) 8000 10) 13000 END LINDO Output LP OPTIMUM FOUND AT STEP OB JECTIVE FUNCTION VALUE 1) 235674.2 VARIABLE VALUE REDUCED COST 0.000000 0.000000 X21 3900.892822 0.000000 0.000000 3900.892822 0.000000 0.000000 X31 X41 0.000000 0.000000 X12 0.000000 0.000000 0.000000 X22 2.045990 X32 2.312857 X42 2.935549 2551.785645 1649.107178 0.000000 x13 X23 0.000000 X43 7900.000000 0.000000 0.000000 0.000000 899.107117 1648.214233 0.000000 0.000000 9.742143 Y2 Y3 Y4 8.912857 0.000000 11.877857 DUAL PRICES ROW SLACK OR SURPLUS 2) 3) 0.000000 0.423571 0.00000 0.334615 4) 0.0000 -0.423571 5) 0.0000 8.300000 6) 0.000000 13.482142 7) 0.000000 11.132857 8) 9) 0.000000 12.677857 198.214279 0.000000 10) 0.000000 -1.755000 NO. ITERATIONS= 8 RANGES IN WHICH THE BASIS IS UNCHANGED: OBJ COEFFICIENT RANGES VARIABLE CURRENT ALLOWABLE ALLOWABLE INCREASE COEF DECREASE X11 20.160000 0.000001 INFINITY x21 15.600000 NINIT 0.000000 X31 11.980000 0.000001 INFINITY 0.000002 X41 10.560000 0.000000 X12 17.000000 10.903472 8.700000 X22 12.440000 2.045989 INFINITY 8.820000 INFINITY X32 2.312858 X42 7-400000 2.935550 INFINITY X13 15.440000 7.020000 0.000000 X23 10.880000 0.000000 3.471981 X33 7.260000 INFINITY 0.000001 5.840000 0.000000 X43 0.000002 8.300000 8-700000 7.020000 3.740000 INFINITY INFINITY INEIITY 2 9.742143 2.220000 Y3 8.912857 Y4 0.800000 11.877857 RIGHTHAND SIDE RANGES ROW CURRENT ALLOWABLE ALLOWABLE DECREASE RHS INCREASE 0.000000 10945.651367 5549.999512 0.000000 0.000000 42853.570312 0.000000 71449.992188 5549.999512 4200.000000 INFINITY 1648.214233 6 5550.000000 241.304337 2798.484863 7 7900.000000 4800.000000 8000.000000 13000.000000 213.461533 168.181808 7900.000000 2189.130371 INFINITY 198.214279 10 6592.856934 264.285706 THE TABLEAU X22 ROW (BASIS) X11 X21 X31 X41 X12 2.046 0.411 0.000 1 ART 0.000 0.000 0.000 0.000 3.300 0.700 0.000 0.000 2 X21 1.000 0.000 0.000 3 X12 0.000 0.000 1.000 0.115 0.000 4 X13 1.000 0.000 0.000 0.000 0.179 1.000 -0.700 33 0.000 0.000 0.000 0.000 0.000 -3.300 0.000 0.000 0.000 6 X23 0.589 7 X41 -2.300 0.000 0.300 1.000 0.000 0.411 X43 2.300 0.000 0.000 -0.300 0.000 0.000 0-411 SLK 9 9 0.000 0.000 0.000 0.000 -0.821 10 0.000 0.000 0.000 0.000 0.000 0.063 X32 X33 ROW X42 X13 X23 X43 2.313 0.000 0.000 0.000 2.936 0.000 0.000 0.000 0.000 0.000 0.000 0.464 0.000 0.589 -0.269 0.000 0.000 0.000 0.000 0.000 2 3 0.000 0.000 -0.071 0.179 1.000 0.000 0.000 0.000 1.000 0.000 0.000 0.000 1.000 0.000 0.000 0.000 -0.464 -0.589 0.000 1.000 0.000 0.000 0.464 0.589 0.000 0.000 0.000 0.000 0.000 0.000 0.000 8 -0.464 0.411 0.000 0.000 1.000 0.000 0.000 0.000 -1.179 9 -0.929 0.000 0.000 0.000 1.000 10 0.071 0.091 0.000 0.000 0.000 SLK 3 ROW Y2 3 Y4 SLK 2 SLK 4 SLK 5 1 9.742 8.913 11.878 0.424 0.335 0.424 8.300 2 0.411 0.464 0.589 0.118 0.000 0.018 0.000 0.000 3 0.000 0.000 0.000 0.000 0.038 0.000 4 -0.179 -0.071 0.179 0.036 0.000 0.036 0.000 0.000 0.000 0.000 1.000 0.000 0.000 0.000 0.589 0.411 0.464 0.464 -0.589 -0.118 0.000 -0.018 0.000 0.000 0.000 0.082 7 0.589 0.000 0.018 0.411 -1.179 -0.411 0.464 0.082 0.000 -0.018 0.821 -0.929 -0.036 0.000 -0.036 0.000 -0.038 10 0.179 0.071 0.179 -0.036 -0.036 1.000 4/5 ROW SLK 6 SLK 7 SLK 8 SLK 9 SLK 10 RHS 11.133 1.755 13.482 12.678 0.000 0.24E+06 0.411 0.464 0.589 0.000 0.375 3900.893 3 0.000 0.000 0.000 0.000 0.000 0.000 4 -0.179 0.071 0.179 0.000 -0.250 2551.786 7900.000 1649.107 0.000 1.000 0.000 0.000 0.000 0.589 -0.464 -0.589 0.000 -0.375 0.375 0.375 0.411 0.464 0.589 0.000 0.000 3900.893 899.107 8 -0.411 -0.464 0.411 -0.929 -1.179 198.214 -0.821 1.000 -0.750 0.179 0.071 0.250 10 -0-179 0.000 1648.214

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

Step: 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

Essentials Of Managerial Finance

Authors: Scott Besley, Eugene F. Brigham

13th Edition

0324258755, 9780324258752

More Books

Students also viewed these Finance questions

Question

★★★★★

A magnifier is rated at 3.5 for a normal eye focusing on an image at the near point. (a) What is its focal length? (b) What is its focal length if the 3.5 refers to a relaxed eye?

Answered: 1 week ago

Question

★★★★★

6.51 Pepsi's Market Share Two of the biggest soft drink rivals, Pepsi and Coke, are very concerned about their market shares. The pie chart that follows claims that PepsiCo's share of the beverage...

Answered: 1 week ago

Question

★★★★★

You have been shopping for a new home. You have a choice of financing. You can choose either a $200,000 mortgage at 4.75 percent for 30 years, or a $200,000 mortgage at 3.5 percent for 15 years. a....

Answered: 1 week ago

Question

★★★★★

This is a short answer type of question that is related to Business Cmmunication. - Typed answers only (no hand writting) 4. Define groupthink and list 5 strategies to combat it

Answered: 1 week ago

Question

★★★★★

Long-run real interest rates are expected to increase. An accountant and an MBA student (who just finished his course of Managerial Economics) were interviewed regarding the effect of this increase....

Answered: 1 week ago

Question

★★★★★

The lesson begins by saying how work conflict is different than personal conflict. Why do you think conflict at work is often more difficult to resolve? Have you ever had a conflict with someone at...

Answered: 1 week ago

Question

★★★★★

6. Maintaining inventory accuracy must be an integral part of the attitude of the organization. They must be detected so inventory accuracy is maintained. 8 points in total a) What are the two basic...

Answered: 1 week ago

Question

★★★★★

Derek was the director of the Southside Athletic Ciub when the COVID-19 pandemic hit. At the time the club had approximately Boo dues-paying members, The state ordered the club shut down, and the...

Answered: 1 week ago

Question

★★★★★

Select an existing organization preferably, a manufacturer, and develop improvement plan of operations keeping in view the following steps. 1. Do process mapping (time functions mapping and value...

Answered: 1 week ago

Question

★★★★★

Jim Cash sat in a seat six rows behind the dugout at a Maine Bears baseball game. Between the third and fourth innings, Sluggerr, the team mascot, performed the "Hot Dog Launch," a promotional event...

Answered: 1 week ago

Question

★★★★★

1. Within the walls of a sterile prison Vickie Stringer began changing her life. Describe what mental processes were available to her in this environment.

Answered: 1 week ago

Question

★★★★★

1. If Ms. Perez displays the characteristics of the Director communication style, how should Eric conduct himself during the meeting? Be specific as you analyze those behaviors that would be admired...

Answered: 1 week ago

Question

★★★★★

3. It is not a good idea to put a label on someone and then assume the label tells us everything about the person. As Eric attempts to build rapport with Ms Perez, what other personal characteristics...

Answered: 1 week ago

Previous Question Next Question