Destination Destination Destination SupplySource 1758 320Source 26 160131204.Source 36.5Demand160200240Based on the transportation table shown, total transportation cost using North-West Corner Method will be:a. 3040Ob. 4100O c. 2640O d. 1920

Answered: Destination Destination Destination…

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

Ancient history of logistics distribution regarding probability?
Monczka-T rcnt Shipping is t he logistics vendorfor Handfield Manufacturing Co. in Ohio. Handfield has dailyshipments of a power-steering pump from its Ohio plant to an autoassembly line in Alabama. The value of the standard shipment is$250,000. Monczka-Trent has two options: ( I) its standard 2-dayshipment or (2) a subcontractor who will team drive overnightwith an effective delivery of one day. The extra driver costs $175.Handfield's holding cost is 35% annually for this kind of inventory.a) Which option is more economical?b) What productio n issues a re not included in the datapresented?
Q3) The Cure medical distribution center distributes urgent medical equipment for five local hospitals in Washington DC metropolitan area. Cure Medical distribution would like to invest in a new warehouse in Washington DC to minimize the total distance from five major hospitals. The coordinate of the five hospitals is given below: ( (2) 3 Great Fall (C) (47) 122 (121) Fairfax 10 We W Bu (645) -D (-20, 30)- -E (-40, -30) Colesville Fairland Calpen A (10,60) -B (10,-10) Ⓡ South Lourel stuxent search Refuge (MA A (14) tille (214) pha Bowit (00 X -C (45, -20) 201 C a) Use Solver to determine where the new warehouse should be in to minimize the total distance from 5 hospitals. What are the coordinates of the new warehouse? b) Solve your problem again to minimize the maximum distance between hospitals and the new warehouse. What are the coordinates of the new warehouse?
Q2. Pharmaceutical company producing asingle product sold it through five agencies situated in different cities. All of sudden there rouse a demand for the product in another five cities that didn't agency of the company. The company is now facing the problem of deciding on how to assign the existing agencies in order to dispatch the product to needy cities in such a waythat the travelling distance is minimized. The distance between the surplus and deficit cities in kilometer is given the following table. Surplus city Deficit cities Deficit cites A1 160 130 115 190 200 B1 135 120 130 160 175 C1 140 110 125 170 185 D1 50 50 80 80 110 E1 55 35 80 80 105 Determine the optimum assignment schedule.
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)
10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A 25 26 27 28 29 30 B с 1 2 Based on the city distance dataset as follows: 3 4 5 6 7 8 9 1 Boston 2 Chicago 3 Dallas 4 Denver 5 LA 6 Miami 7 Phoenix 8 Seattle D Phoenix Chicago Denver Dallas 0 983 1815 1991 3036 1539 2664 2612 Boston Chicago Dallas Total trip miles by the traveler: Index Cities Seattle LA E Total trip miles 983 0 1205 1050 2112 1390 1729 2052 F Distance 1815 1205 0 801 1425 1332 1027 2404 G Denver LA 1991 1050 801 0 1174 2100 836 1373 H 3036 2112 1425 1174 0 2757 398 1909 I Miami 1539 1390 1332 2100 2757 0 2359 3389 J K Phoenix Seattle 2664 1729 1027 836 398 2359 0 1482 A resident of Seattle is embarking on a road trip that takes her to Los Angeles, Phoenix, Chicago, Denver, Dallas, and finally go back to Seattle. How many miles will she travel on this trip? Hint: Use INDEX and MATCH to answer the above question. 2612 2052 2404 1373 1909 3389 1482 0 L M N
What is the initial total cost of the given transportation model if an Intuitive Approach method is applied? DESTINATION SOURCE DEMAND O 3050 O 3140 O 3045 O 3040 X Y N 4 P 75 8 12 S 11 Q 80 5 8 11 R 120 7 10 10 S 50 11 13 14 SUPPLY 100 125 100 325
Weighted factor methodUse the table to calculate the most ideal X coordinate for supermarket Point Quantity offered/requested Transportation costs Coordinate X Coordinate Y Supermarket 1 3,000 0.04 4 8 Supermarket 2 3,500 0.04 7 2 Supermarket 3 2,000 0.07 3 5 Supermarket 4 1,500 0.07 7 4 Supermarket 5 1,200 0.07 6 8
Q3) A farmers' cooperative association plans to build a new sugar mill in Southwestern Louisiana. The primary objective of the mill is to provide the farmers with a place to take their crop for processing that will reduce their transportation costs. The members of the co-op believe that the center-of-gravity method is appropriate for this objective. While there are over 200 sugar cane farms in the region, they are tightly clustered around six villages. Populate the relevant data using your group number below. Using the data below, use the center-of-gravity method to calculate the coordinates of the best location for this All mileage references use the city of Lake Charles as (0,0). Village Miles East of Lake Charles Miles North of Lake Charles Sugar Cane tonnage Arceneaux 90 10 2400*13 Boudreaux 140 60 3200*13 Cancienne 20 70 4500*13 Darbonne 50 20 1200*13 Evangeline 100 80 6000*13 Fontenot 10 120 14000*13
2) Using the cost table of the transportation problem shown below, do the following: a) Develop the appropriate LP model of the problem. WAREHOUSE PLANT A B C D DEMAND 1 5 10 7 20 200 2 3 12 5 25 400 3 8 10 10 18 600 4 7 8 12 30 1000 SUPPLY 200 500 300 1000
What is multipile logistics regression? What is the duration?
a.Find the starting solution of this transportation model by Least Cost Method. (15P) (Unit transportation costs are given in the table) D1 D2 D3 D4 Supply M1 16 24 14 11 25 M2 21 18 17 9 30 M3 15 13 21 14 40 Demand 25 25 20 25

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

Expert Answers to Latest Homework Questions

Q: in text form with proper workings and explanation for each and every part and steps with concept and…

Q: None

Q: help please answer in text form with proper workings and explanation for each and every part and…

Q: None

Q: in text form with proper workings and explanation for each and every part and steps with concept and…

Q: help please answer in text form with proper workings and explanation for each and every part and…

Q: Don't use chatgpt will upvote

Q: None

Q: Don't Use Chat GPT Will Upvote And Give Solution In 30 Minutes Please

Q: in text form with proper workings and explanation for each and every part and steps with concept and…

Q: The figure below shows a container filled with three fluids, A, B, and C. The tops of the 3 tubes…

Q: None

Q: Give me experts solution only with step by step

Q: 4. ) Find the magnetic field of an infinite uniform surface current K = Kî, flowing over the xy…

Destination Destination Destination Supply Source I 73 8320 Source 2 4. 6 160 Source 3 6.5 3 120 Demand 160 200 240 Based on the transportation table shown, total transportation cost using North- West Corner Method will be: Ga. 3040 b. 4100 O c. 2640 O d. 1920

Expert Answers to Latest Homework Questions