(2) Find an optimal solution for the following transportation problem.ToTown(7)FROMMadison(M)Yonkers(1)Pittsburgh(P)DemandFROMMadison(M)Yonkers(Y)PittsburghFROMValley(1)350To Valley(1)ToFROMMadison(M)Yonkers(Y)350Pittsburgh(P)Demand$8$15$5350$8Valley(1)Using the Stepping-Stone method to find an optimal plan.TownJunction(7)(J)$5$15Madison(M)Yonkers(1)Pittsburgh(P)Demand350Part (a) Find the new TC=_$850150350200250The above feasible plan is obtained by applying the Northwest Corner Rule (e.g., 300 from M to V, etc.), andits total cost = 350($8) +50($10)+150($12) +250($4) +200($11) +250($14) = $11.800.$5$15$8$5$1550150$10Town(T)50$12150200$6200$10$12$6Part (c) Determine the next improved plan.To ValleyTown(7)$10$12$6$10Junction$12250$6350Part (d) Find the new TC =Part (1) Is the current solution optimal?250$9$11$4Demand350200250We 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 inPT, we need to adjust PB down, YB up, and YT down. Therefore, the next improved plan is:250250$9Junction(J)250$4$11$9$4$11Junction$9$4Burg(B) Supply$6200$11250450Explain200Burg(B)250450$11$14350100450$11Burg(B)$6$14$11Burg(B)$6$14450$6$11400$146002501,250Supply (row M first, then rows Y and P)MJ: 9-4+12-10-74006002501,250400Part (b) Find the indices (show steps)Supply Row M first, then rows Y and P600The improvement indices beloware determined as follows:2501,250MB: 6−11+12–10 =-3YV: 5-12+10-8-5PV: 15−14+11−12+10-8-2PT: 6-14+11-12--9PJ: 11-14+11-4-4* the "most negative index"400600Part (e) Find the indices (show steps)Supply Row M first, then rows Y and PAsterisk the "most negative index"(show steps).2501,250 Asterisk the "most negative index"(show steps).(hint: see Online Module 8, p.M8-4).

The transportation model is used to calculate the minimum cost of the route by selecting different…

Answered: Part (a) Find the new TC- Part (c)…

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...

See similar textbooks

Similar questions

1. Using the center-of-gravity method, compute the centralized coordinates among the following locations, which are indicated via black cells with white text in LOCATION.xlsx: 7,1 10,1 4,2 2,5 6,6 9,6 2,8 6,10 2. Using the weighted average center-of-gravity, which accounts for quantities to be shipped from locations, compute the centralized coordinates among the following locations: 7,1 10,1 4,2 2,5 6,6 9,6 2,8 6,10 *Quantities to be shipped are listed within the existing locations (i.e. Location 7,1 ships 17 units) in LOCATION.xlsx
A larger and more modern main post office is to be constructed at a new location in Davis, California. Growing suburbs caused a shift in the population density from where it was 40 years ago, when the current facility was built. Annette Werk, the postmaster, asked her assistants to draw a grid map of the seven points where mail is picked up and delivered in bulk. The coordinates and trips per day to and from the seven mail source points and the current main post office, M, are shown in the following table. M will continue to act as a mail source point after relocation. Mail Source Point Round trips per day x, y, Coordinates (miles) 4 (4, 6) (8, 4) (3, 14) (6, 10) (12, 11) (13, 5) (13, 6) (14, 10) 2 1 11 5 7 6 7 3 M 8 a. Calculate the center of gravity as a possible location for the new facility. (Enter your responses rounded to the nearest whole number.) The center of gravity "X" coordinate = 9 The center of gravity "Y" coordinate = 8. b. Compare the load-distance scores for the…
A larger and more modern main post office is to be constructed at a new location in Davis, California. Growing suburbs caused a shift in the population density from where it was 40 years ago, when the current facility was built. Annette Werk, the postmaster, asked her assistants to draw a grid map of the seven points where mail is picked up and delivered in bulk. The coordinates and trips per day to and from the seven mail source points and the current main post office, M, are shown in the following table. M will continue to act as a mail source point after relocation. Mail Source Point Round trips per day x, y, Coordinates (miles) 1 4 (4, 6) 7 (8, 4) (3, 14) (6, 10) (12, 11) (13, 5) (13, 6) (14, 10) 3 1 4 11 7 3 7 3 M 8 a. Calculate the center of gravity as a possible location for the new facility. (Enter your responses rounded to the nearest whole number.) The center of gravity "X" coordinate = The center of gravity "Y" coordinate =
A larger and more modern main post office is to be constructed at a new location in Davis, California. Growing suburbs caused a shift in the population density from where it was 40 years ago, when the current facility was built. Annette Werk, the postmaster, asked her assistants to draw a grid map of the seven points where mail is picked up and delivered in bulk. The coordinates and trips per day to and from the seven mail source points and the current main post office, M, are shown in the following table. M will continue to act as a mail source point after relocation. Mail Source Point Round trips per day x, y, Coordinates (miles) 1 8 2 2 1 6 3 4 6 7 M 2 4 8 The center of gravity "X" coordinate = 10 The center of gravity "Y" coordinate = 6 (11,5) (15,5) (1, 13) (2, 1) (4, 14) (16, 12) (15,5) (14,2) a. Calculate the center of gravity as a possible location for the new facility. (Enter your responses rounded to the nearest whole number.) b. Compare the load-distance scores for the…
Microserve provides computer repair service on a contract basis to customers in five sections of the city. The five sections, the number of service contracts in each section, and the x and y coordinates of each section are as follows: Section Parkview Mt. Airy Valley Norwood Southgate No. of Contracts 90 220 60 3.4 14.2 290 17.7 160 14.0 Use the center-of-gravity method to determine an ideal location for a service center. Round your answers to two decimal places. Cx: Cy: Choose the correct graph representing the center of gravity. The correct graph is -Select- v A. C. Center of Gravity 20 Y- Coordinate y- 16- 12- 8 4+ 20- 16- 12 ● ● • 12 x- Coordinate Center of Gravity y- Coordinate: 16 ● B. D. -20+ -16- 12 8+ 20 16- 12 Center of Gravity y- Coordinate 8 12 x- Coordinate Center of Gravity y- Coordinate ● 16 Coordinates X Y 6.2 11.9 4.2 5.3 4.4 10.9
Contrast the location of a food distributor and a supermar-ket. (The distributor sends truckloads of food, meat, produce, etc., to the supermarket.) Show the relevant considerations(factors) they share; show those where they differ.
(2) Find an optimal solution for the following transportation problem. Town To Valley FROM Madison (M) Yonkers (1) Pittsburgh (P) Demand FROM Madison (M) Yonkers Pittsburgh FROM 3.50 Madison (M) Yonkers FROM $8 350 Madison (M) Yonkers (1) Pittsburgh $5 SIS 350 Valley (5) $8 $5 $15 Using the Stepping-Stone method to find an optimal plan. Tol Valley Town Junction (7) $8 Pittsburgh Demand 350 Part (a) Find the new TC= $5 $15 50 350 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($12) +250($4)+200($11) +250($14) = $11.800, 150 $8 200 $5 The improvement indices below are determined as follows: Supply row M first, then sows Y and P) MJ: 9-4+12-10-2 400 MB: 6-11+12-10=-3 rv: 5-12+10-8-5 600 PP: 15-14+11-12-10-8-2 PT: 6-14+11-12- PA 11-14+11-4-4 Demand 350 200 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…
A company has a manufacturing plant that supply three markets in city A, B, and C. Management is looking for a place to locate a single distribution that will minimize total transportation costs. The plant is estimated to move (send) a total of shipment of 12,700 ton per month to the new distribution center. The transportation rate of moving shipment from the plant to the distribution center is $ 0.08 per ton per mile. Market A will receive a total shipment of 6,200 ton per month, market B will receive a total shipment of 2,000 ton per month, and market C will receive a total shipment of 4,500 ton per month. The transportation rate between the distribution center and the markets are as follows: $0.19 per ton per mile to market A, $0.37 per ton per mile to market B, and $0.25 per ton per mile to market C. The horizontal and vertical coordinates of the plants and markets are follows: Plant, 25, 75 Market A, 30, 5 Market B, 36, 24 Market C, 15, 40 Use the Center-of-Gravity method to find…
2 For a destination region with which you are familiar, conduct a critical analysis of VIC provision. . Consider the location (s) involved, the appropriateness of the buildings, the level of staffing, the services available and the hours of operation. What improvements would you suggest?
b. A food manufacturer wants to locate a warehouse to serve its major customers. The customers, annual volume and the X and Y coordinates are shown in the table below. Customer Judy inc. Zac Supermarket Harry Inc. Sky Productions Annual Volume X-Coordinate Y-Coordinate 3 7 5 2 8 4 1 5 25 13 6 4 i. Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products.
A clothing manufacturer produces women’s clothes at four locations in Mexico. Relative locationshave been determined, as shown in the table below. The location of a central shipping pointfor bolts of cloth must now be determined. Weekly quantities to be shipped to each location arealso shown in the table. Determine the coordinates of the location that will minimize distributioncosts. Location (x,y) WeeklyQuantityA 5,7 15B 6,9 20C 3,9 25D 9,4 30
A food manufacturer wants to locate a warehouse to serve its major The customers, annual volume, and the X and Y coordinates are shown in the table below. Customer Annual Volume X-Coordinate Y-Coordinate Judy inc. 25 3 7 Zac Supermarket 13 5 2 Harry Inc. 6 8 4 Sky Productions 4 1 5 Using the center of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

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

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS