Question: PLEASE SOLVE IN 1 HOUR FIND THE SENSITIVITY RANGE, QUESTION IS ON THE BOTTOM THX U The problem for World Medicol was solved using Excel

PLEASE SOLVE IN 1 HOUR

FIND THE SENSITIVITY RANGE, QUESTION IS ON THE BOTTOM THX U

PLEASE SOLVE IN 1 HOUR FIND THE SENSITIVITY

The problem for World Medicol was solved using Excel solver, and the following figures show the resulted tables from the sensitivity report. Variable Cells 75 0 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 0 90 5 501E+30 90 0 0 440 1E+30 0 5 0 5 15 2 0 45 550 425 0 250 449 45 250 4290 0 5 0 554 1E+30 5 414 20 543 20 110 633 1E+30 110 0 6181E+30 30 538 1E+30 60 478 1E+30 0 398 50 1E+30 50 5231E+30 50 0 300 683 1E+30 300 85 0 75 45 1E+30 0 10 100 1 E+30 15 12010 70 1251E+30 70 70 0 700 1420 20 30 Cell Name $B$5 Rotterdam Houston $C$5 Rotterdam Newark $D$5 Rotterdam Baltimore $E$5 Rotterdam New York $B$6 Antwerp Houston $C$6 Antwerp Newark $D$6 Antwerp Baltimore $E$6 Antwerp New York $B$7 Hamburg Houston $C$7 Hamburg Newark $D$7 Hamburg Baltimore $E$7 Hamburg New York $B$8 Valencia Houston $C$8 Valencia Newark $D$8 Valencia Baltimore $E$8 Valencia New York $C$20 Houston Dallas $D$20 Houston St. Louis $E$20 Houston Chicago $C$21 Newark Dallas $D$21 Newark St. Louis $E$21 Newark Chicago $C$22 Baltimore Dallas $D$22 Baltimore St. Louis $E$22 Baltimore Chicago $C$23 New York Dallas $D$23 New York St. Louis $E$23 New York Chicago 60 10 0 45 5 0 4 5 110 1E+30 45 0 0 80 10 0 0 1100 10 0 103 140 1E+30 103 0 23751E+30 23 600 82231E+30 Constraints 0 Cell Name $B$10 Shipped to Houston $C$10 Shipped to Newark $D$10 Shipped to Baltimore $E$10 Shipped to New York $C$13 Houston transshipment flow $C$14 Newark transshipment flow $C$15 Baltimore transshipment flow $C$16 New York transshipment flow $C$25 Shipped to Dallas $D$25 Shipped to St. Louis SE$25 Shipped to Chicago $G$5 Shipped from Rotterdam $G$6 Shipped from Antwerp $G$7 Shipped from Hamburg $G$8 Shipped from Valencia Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 100 -45 100 5 70 -85 70 0 5 0 70 1E+30 -118 60 0 588 15 0 608 0 15 0 598 0 15 0 626 0 663 85 70 678 7015 80 708 80 15 60 -83 605 85 15 15 A) Find the sensitivity range of the objective coefficient for the shipment from Antwerp to Houston (use "inf" for infinity): Lower bound Upper bound B) Find the sensitivity range of the constraint quantity for the processing capacity of the warehouse in New York Lower bound Upper bound

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

2. (20 P.) World Medical, lue, importa mekko syringe to the US, from Exopean was Valencia. Ship from the parts dever the yea Watam York, where they are stored in the componeywele centers in Dallas,...

Supply Chain Management: A. Using a spreadsheet model, solve the demand allocation model for TelecomOne assuming that all its facilities are already open (i.e., find which facility of TelecomOne will...

Please Answer all. This is one problem. I will upvote. LP: Certain Sensitivity Analysis Questions must be answered based on the Excel Output below. The sandwich company, Alamo Lone Star (ALS)...

LP: Certain Sensitivity Analysis Questions must be answered based on the Excel Output below. The sandwich company, Alamo Lone Star (ALS) prepares sandwiches for sale in vending machines in various...

answer all cc Question 1: Solow Model (40 points) i. ii. In 3-4 pages, in your own words, delve into a detailed discussion of the three variations of the Solow growth model (the basic Solow model,...

LP: Certain Sensitivity Analysis Questions must be answered based on the Excel Output below. The sandwich company, Alamo Lone Star (ALS) prepares sandwiches for sale in vending machines in various...

1: Directions: 1) Read the entire selection below 2) Answer the questionssee additional notes below.... Selection: Bradley's Food Stand John Bradley is a senior at Tech, and he's investigating...

please answer all parts 2. 20 pt . World Medicol, Inc., importa medical products such as medical stoves, cres, and syringe to the US. from European warchones at ports in Rotterdam, Antwerp, Hamburg...

A law firm is preparing to file a federal estate tax return (Form 706). The estate's executor has elected to use the alternate valuation date. The partner in charge of filing this return is not...

The balanced scorecard measures organizational performance along four dimensions. Is it possible that measures on the customer, internal operations, and innovation and learning dimensions could be...

P9.15 Consider the automatic ship-steering system transfer function. The deviation of the tanker from the straight track is measured by radar and is used to generate the error signal, as shown in...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...