Find an initial solution to the following transportation problem for Supply Chain Manager Gabriela Valdez. From Mexico City Detroit Ottawa Demand The starting solution using northwest-corner method is: From Mexico City Detroit Los Angeles $6 $17 $20 50 Ottawa (Note: You must enter a shipment in every cell, even if the shipment is 0.) To Los Angeles Calgary Demand ☐ □ 50 $6 $17 To Calgary $18 $13 $10 80 $20 80 Panama City $8 $19 $24 70 $18 $13 $10 Panama City Supply $8 100 ■ 70 Supply 100 60 40 $19 $24 60 40

Find an initial solution to the following transportation problem for Supply Chain Manager Gabriela Valdez. From Mexico City Detroit Ottawa Demand The starting solution using northwest-corner method is: From Mexico City Detroit Los Angeles $6 $17 $20 50 Ottawa (Note: You must enter a shipment in every cell, even if the shipment is 0.) To Los Angeles Calgary Demand ☐ □ 50 $6 $17 To Calgary $18 $13 $10 80 $20 80 Panama City $8 $19 $24 70 $18 $13 $10 Panama City Supply $8 100 ■ 70 Supply 100 60 40 $19 $24 60 40

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. For the following problems, provide your written solutions within this template. Do not create a new file. Show all steps used in arriving at the final answers. Incomolete solutions will receive partial credit. 3. Provide formulas using Equation Editor and diagrems using Drawing Tool. 4. Use the Solver to obiain computer solutions in an Excel workbook. 5. Submit the Word and Excel workbook(s) separately as attachments. 2. Problern 1 The following network describes a transportation scenario in which there are four sources A, B, C, and D, and three destinations P, Q, and R. (The numbers next to each arrow represent the cost of transporting one unit from that particular source to the destination located at the other end of that arrow}. Sources (Supplies) Destinations (Demands) 2500 2900 4 A000 3800 8. 3800 .... **.** 9. R. at 2700 12 3700 oce D. a) Write the mathematical formulation of the problem. b} Use the Excel Solver to solve the problem. Generate the answer and sensitivity…
Determine the suitable location of a distribution centre with the below data, minimizing the transportation dollars spent on managing inbound and outbound shipments. Plot the location of the Vendors, Customers and the location of the new DC in a chart Vendor V1 V2 V3 V4 Customer C1 C2 C3 C4 Rate $ per Ton Mile $ $ $ $ 4.75 3.75 3.15 4.75 Rate $ per Ton Mile $ $ $ $ 3.50 3.75 4.25 5.00 Volume in Tons 1000 1000 1600 1400 Volume in Tons 760 640 800 500 Vendor Location Coordinates (miles) Horizontal 525 600 412.5 300 Vertical 300 750 750 630 Customer Location Coordinates(miles) Vertical 450 900 1050 975 Horizontal 900 900 825 1050
3. Figure 1 Daily Subway and Bus Use in Five Major Cities 0.75 0.5 0.25 Subway OBus London Tokyo Singapore Hong Kong Figure 2 Subway vs. Bus Ridership, New York City OBus Subway 1970 1980 1990 2000 2010 Information in figure I suggests that public transportation users in London Information in Figure I supports the author's point that buses are growing in popularity as a means of urban transport by indicating that A) take subways and buses at similar rates. B) are unusually reliant on buses. C) take at least one subway trip daily. D) take subways at about the same rate as people A) many people around the world take at least one bus trip every day. B) bus ridership surpasses subway ridership in some major cities. C) people in Tokyo make far more trips by bus daily than they do trips by subway. D) the number of bus trips taken by people in major cities has substantially increased. in New York. 2 Which of the following statements about bus use in New York City is best supported by…
Using the information about customer vehicle traffic to and from a proposed new sports stadium (not built yet), find the best location for the stadium that minimizes total distance travelled using the center-of-gravity method. Zip Code Location Options 2 3 4 Coordinates of Location X 2 9 12 13 y 4 5 6 12 Vehicles per Stadium Event 4,300 4,700 1,100 2,000 Use the center-of-gravity method to determine an ideal location for a service center. Round your answers to two decimal places. Cx: Cy:
Consider the transportation table below for answering question number 21-25. From To Quezon city Bataan Php 7 Visayas Mindanao Php 10 Php 6 Demand 100 Manila Taguig Supply Php 5 Php 9 Php 12|Php 10 150 200 Php 3 Php 14 50 80 220 400 21. Using Northwest Corner Rule, how many must be supplied from Visayas to Taguig? (a) 170 (b) 180 (c) 190 (d) 200 22. Using Northwest Corner Rule, how many must be supplied from Mindanao to Taguig? (a) 45 (b) 50 (c) 55 (d) 60 23. Using Minimum Cost Method, how many must be supplied from Visayas to QC? (a) 200 (b) 210 (c) 220 (d) 230 24. Using Minimum Cost Method, how many must be supplied from Mindanao to Manila? (a) 35 (b) 40 (c) 50 (d) 55 25. Using Vogel's Approximation Method, how many must be supplied from Bataan to Taguig? (a)20 (b) 25 (c) 30 (d) 40
Suppose that you are an engineer tasked with finding a new location for your distribution center (let's say you work as an industrial engineer at a cosmetics company). You have a good idea of who your customers are and how many tons of cosmetics you must ship per week. Using your company headquarters as the origin, you plot out the following table: Customer x-location (miles) y-location (miles) Quantity (tons/week) JC Penney 10 280 3 BB&B 70 180 7 Target 80 160 4 Bath&Body Works 170 20 5 Walmart…
Explain the relationship between the number of facilities and transportation cost and draw the graph
Using the “Transportation Matrix”, solve the transportation problem below using the Northwest Corner and Intuitive Lowest-Cost methods. Use the Northwest Corner method result as the starting point and solve for the optimal solution using the Stepping-Stone method. Show all steps and all calculations when doing the Stepping-Stone method. Plants Supply Destination Demand Kansas City 35 Chicago 30 Omaha 50 St louis 65 Des Moines 50 Cincinnati 40 Total 135 Tons Total 135 Tons transport cost form Plants to Destinations ($/Ton) Plants Chicago St louis Cincinnati Kansas city $ 4.00 $ 3.00 $ 3.00 Omaha $ 6.00 $ 7.00 $ 6.00 Des Moines $ 8.00 $ 2.00 $ 5.00 A. Northwest Corner method B. Intuitive Lowest-Cost method C. Stepping-Stone method
7. Novelis at Oswego NY supplies rolled aluminum sheets to Ford Motor's Kansas City plant to make F150 truck. The transportation manager of Novelis needs to choose from rail, waterway, and truck. The following information are gathered to make the transportation mode decision: Transportation Mode Transit Time, Days Rate $/cwt Shipment Size, cwt Rail 15 $2.50 12,000 Waterway 20 $0.80 200,000 4 $12.50 4,000 Truck The annual transportation volume is 2.5 million cwt. The value of aluminum is $500 per cwt. Inventory carrying cost for both companies is 20% per year. Please calculate the total logistics costs (transportation, inventory at Novelis, inventory at Ford, inventory in transit), and decide which transportation mode should be selected. (20 points)
We have four major customers, and want to find the location that minimizes the average distance traveled to deliver products to them. Customer X coord Y coord Demand A 10 10 100 B 15 40 20 C 35 12 20 D 38 40 150 What is the optimal X coordinate for our location?
Find the shortest route for a delivery truck going from the PLANT, to the warehouse, then delivery to points 3, 4, and 5 (can be interchanged), and back to the plant again. Plant 1 100 200 50 3 200 100 40 5 150 100 100 6 Warehouse
On a daily basis, the Vampire Van is dispatched from Maplewood Hospital to pickup blood and platelet donations made at its local donation centers. The distances in miles between all locations may be found in Table.a. The Vampire Van travels from Maplewood Hospital (A) to (B) to (C) to (D) to (E) and then returns to the hospital (A). What is the total number of miles that the van must travel using this route?b. Using Maplewood Hospital as the beginning location, create a route using the NN heuristic. What is the total number of miles that the van must travel using this route?c. Using Valley Hills (E) as the beginning location, create a route using the NN heuristic. What is the total number of miles that the van must travel using this route?