Final Shadow Constraint Allowable Allowable Name Value Price RH. Side Increase Decrease Sum 3-Atlanta 200 200 50 200 Sum 4-Orlando 175 10 175 25 100 Sum 5-Chicago 125 125 50 100 1- Denver Sum 200 -1 200 100 25 2. 6.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Please explain also

Final
Shadow
Constraint
Allowable
Allowable
Name
Value
Price
R.H. Side
Increase
Decrease
Sum 3-Atlanta
200
200
50
200
Sum 4-Orlando
175
10
175
100
Sum 5-Chicago
125
6.
125
50
100
1- Denver Sum
200
-1
200
100
25
2- Houston Sum
300
350
1E+30
50
(a) Which of the two Supply Origins has any slack?
(b) How many units of slack?
units
(c) How many units are shipped from Denver to Orlando?
units
(d) What is the new shipping cost if you required 20 more units to be shipped to Orlando?S
(e) Does the shipping strategy change if the cost to ship from Houston to Atlanta increases to
$3.75/unit? Yes or no
25
21
Transcribed Image Text:Final Shadow Constraint Allowable Allowable Name Value Price R.H. Side Increase Decrease Sum 3-Atlanta 200 200 50 200 Sum 4-Orlando 175 10 175 100 Sum 5-Chicago 125 6. 125 50 100 1- Denver Sum 200 -1 200 100 25 2- Houston Sum 300 350 1E+30 50 (a) Which of the two Supply Origins has any slack? (b) How many units of slack? units (c) How many units are shipped from Denver to Orlando? units (d) What is the new shipping cost if you required 20 more units to be shipped to Orlando?S (e) Does the shipping strategy change if the cost to ship from Houston to Atlanta increases to $3.75/unit? Yes or no 25 21
The following table is the Sensitivity Output from a simple transportation problem in which you
have two Supplies (nodes 1 and 2) and three Destinations (nodes 3,4, and 5). The minimized
shipping cost is $2700,
Final Reduced Objective Allowable Allowable
Name
Value
Cost
Coefficient Increase
Decrease
1- Denver 3-
3
1E+30
2.
Atlanta
1- Denver 4-
175
9
1E+30
Orlando
1- Denver 5-
25
Chicago
2- Houston 3-
200
1E+30
Atlanta
2- Houston 4-
0.
10
1E+30
Orlando
2- Houston 5-
100
6.
Chicago
Final
Shadow Constraint Allowable Allowable
Name
Value
Price
RH. Side
Increase
Decrease
Sum 3-Atlanta
200
2
200
50
200
Sum 4-Orlando
175
10
175
25
100
Sum 5-Chicago
125
6.
125
50
100
1- Denver Sum
200
-1
200
100
25
2- Houston Sum
300
350
1E+30
50
1.
1.
2.
2.
2.
Transcribed Image Text:The following table is the Sensitivity Output from a simple transportation problem in which you have two Supplies (nodes 1 and 2) and three Destinations (nodes 3,4, and 5). The minimized shipping cost is $2700, Final Reduced Objective Allowable Allowable Name Value Cost Coefficient Increase Decrease 1- Denver 3- 3 1E+30 2. Atlanta 1- Denver 4- 175 9 1E+30 Orlando 1- Denver 5- 25 Chicago 2- Houston 3- 200 1E+30 Atlanta 2- Houston 4- 0. 10 1E+30 Orlando 2- Houston 5- 100 6. Chicago Final Shadow Constraint Allowable Allowable Name Value Price RH. Side Increase Decrease Sum 3-Atlanta 200 2 200 50 200 Sum 4-Orlando 175 10 175 25 100 Sum 5-Chicago 125 6. 125 50 100 1- Denver Sum 200 -1 200 100 25 2- Houston Sum 300 350 1E+30 50 1. 1. 2. 2. 2.
Expert Solution
steps

Step by step

Solved in 5 steps with 4 images

Blurred answer
Knowledge Booster
Investor protection
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.