(2) Find an optimal solution for the following transportation problem. To Valley Town (5 (7) FROM Madison (35) Yonkers (3 Pittsburgh 10 Demand 350 FROM To Valley (155) 350 Madison (M) Yonkers Madison (M) Yonkers (35 Pittsburgh FROM Using the Stepping Stone method to find an optimal plan, Town Junction Madison The above feasible plan is obtained by applying the Northwest Corner Rule (eg, 300 from M to V, etc.), and its total cost 350(58) +50(510)+150(512)+250(54)+200($11)+250(514)-SIL800 Yonkers SK Pittsburgh 10 Demand SIS 350 Valley (5) 50 150 SK 58 50 150 $10 150 56 Town (7) $10 Demand Part(a) Find the new TC Part(e) Determine the next improved plan, To Valley (52) 200 $6 Town (7) $10 Pittsburgh Demand 200 250 We focus on cell PT (index=9). Its closed path is: PT to PB to Y to YT, and back to PT. To increase the quantity in PT, we need to adjust PB down, Yup, and YT down. Therefore, the next improved plan is To $6 Junction Burg (8) $10 Part (d) Find the new TC = Part() is the current solution optimal? 250 $11 Junction (5) 250 200 250 450 Junction Explain 314 Burg (8) 200 250 450 100 56 $14 Burg (85 Burg (8) Supply 400 250 1,250 56 Supply 400 600 250 1.250 The improvement indices below are determined as follows: row M first, then sows and P) MA: 9-4+12-10-2 MB: 6-11-12-10 5-12+10-8-8- 400 PP: 15-14-11-12-10-8 PT: 6-14+11-12-2 PA 11-14+11-4-4 Part (b) Find the indices (show steps) Supply Row Mf first, then sows and P the "most negative index" 600 600 250 1.250 Asterisk the "most negative index" (show steps) Part (e) Find the indices (show steps) Supply Row Mf first, then rows and P 400 250 1.250 Asterisk the "most negative index" (show steps).

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...
Question
(2) Find an optimal solution for the following transportation problem.
Town
Junction Bury
FROM
Madison
(M)
Yonkers
(1)
Pittsburgh
Demand
350
200
The above feasible plan is obtained by applying the Northwest Corner Rule (e.g., 300 from M to V, etc.), and
its total cost = 350($8) +50($10)+150(512) +250(54)+200($11)+250($14) = $11.800
To Valley
(5)
350
FROM
Madison
(M)
Yonkers
(5)
To Valley
(5
Pittsburgh
(P)
Demand
FROM
Madison
(M)
Yonkers
350
Madison
$15
Yonkers
$8
$5
Using the Stepping-Stone method to find an optimal plan.
Town
Junction
Burg
Pittsburgh
(P)
Demand
350
$8
$5
$15
Valley
(1)
Pittsburgh
Demand
350
Part (a) Find the new TC=
$8
$5
$15
50
150
$8
$5
SIS
50
150
$10
50
Town
(7)
150
200
$6
$10
$12
Part (e) Determine the next improved plan.
To Valley
(5
200
$6
Town
(7)
$10
$12
350
200
250
the "most negative index"
We focus on cell PT (index=-9). Its closed path is: PT to PB to YB to YT, and back to PT. To increase the quantity in
PT, we need to adjust PB down, YB up, and YT down. Therefore, the next improved plan is:
To
Junction Burg
$6
250
$10
$12
$6
350
Part (d) Find the new TC =
Part (1) is the current solution optimal?_
250
250
$9
$4
$11
250
$9
250
$11
Junction
200
59
250
450
Explain
200
250
450
$11
350
100
450
$6
450
$11
$14
$6
$14
Burg
(8)
Supply
400
600
$6
$11
$14
2:50
1.250
Supply
400
600 PP: 15-14+11-12+10-8=2
PT: 6-14+11-12=
250 PA 11-14+11-4-4
1.250
Part (b) Find the indices (show steps)
Supply Row M first, then rows Y and P
400
The improvement indices below
are determined as follows:
row M first, then sows Y and P)
MJ: 9-4+12-10-2
MB: 6-11+12-10-3
rv: 5-12+10-8=-5
600
250
1.250 Asterisk the "most negative index"
(show steps).
Part(e) Find the indices (show steps)
Supply Row M first, then rows Y and P
400
600
250
1.250 Asterisk the "most negative index"
_(show steps).
Transcribed Image Text:(2) Find an optimal solution for the following transportation problem. Town Junction Bury FROM Madison (M) Yonkers (1) Pittsburgh Demand 350 200 The above feasible plan is obtained by applying the Northwest Corner Rule (e.g., 300 from M to V, etc.), and its total cost = 350($8) +50($10)+150(512) +250(54)+200($11)+250($14) = $11.800 To Valley (5) 350 FROM Madison (M) Yonkers (5) To Valley (5 Pittsburgh (P) Demand FROM Madison (M) Yonkers 350 Madison $15 Yonkers $8 $5 Using the Stepping-Stone method to find an optimal plan. Town Junction Burg Pittsburgh (P) Demand 350 $8 $5 $15 Valley (1) Pittsburgh Demand 350 Part (a) Find the new TC= $8 $5 $15 50 150 $8 $5 SIS 50 150 $10 50 Town (7) 150 200 $6 $10 $12 Part (e) Determine the next improved plan. To Valley (5 200 $6 Town (7) $10 $12 350 200 250 the "most negative index" We focus on cell PT (index=-9). Its closed path is: PT to PB to YB to YT, and back to PT. To increase the quantity in PT, we need to adjust PB down, YB up, and YT down. Therefore, the next improved plan is: To Junction Burg $6 250 $10 $12 $6 350 Part (d) Find the new TC = Part (1) is the current solution optimal?_ 250 250 $9 $4 $11 250 $9 250 $11 Junction 200 59 250 450 Explain 200 250 450 $11 350 100 450 $6 450 $11 $14 $6 $14 Burg (8) Supply 400 600 $6 $11 $14 2:50 1.250 Supply 400 600 PP: 15-14+11-12+10-8=2 PT: 6-14+11-12= 250 PA 11-14+11-4-4 1.250 Part (b) Find the indices (show steps) Supply Row M first, then rows Y and P 400 The improvement indices below are determined as follows: row M first, then sows Y and P) MJ: 9-4+12-10-2 MB: 6-11+12-10-3 rv: 5-12+10-8=-5 600 250 1.250 Asterisk the "most negative index" (show steps). Part(e) Find the indices (show steps) Supply Row M first, then rows Y and P 400 600 250 1.250 Asterisk the "most negative index" _(show steps).
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 11 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
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.