Cities ship products to other cities. There are distances between cities as shown in the first table. There are also supply and demand of products, shown in units, between cities as shown in the second table. There is also a cost per mile distance between cities. What is the minimum shipping cost for the following: • Use only the cities of Austin, El Paso, Topeka, Little Rock, New Orleans • Use a cost per mile of $0.47 per unit shipped Table of Distance - Assume transitive equivalence between cities (Dallas to Ft Worth is the same distance as Ft Worth to Dallas Ft Worth 32 Distance Dallas Dallas Ft Worth Ok City Shreveport Houston Austin El Paso Topeka Little Rock Ok City 205 188 200 222 391 ΕΙ Little Shreveport Houston Austin Paso Rock 195 635 495 319 190 604 490 351 388 721 294 339 335 823 566 213 165 745 735 435 577 678 514 883 953 480 239 262 445 240 Unit Supply and Demand Austin can supply 110 units and demands 140 units El Paso can supply 110 units and demands 100 units Topeka can supply 95 units and demands 60 units Little Rock can supply 75 units and demands 160 units Now Orleans can supply 110 units and demands 10 Topeka New Orleans 505 540 709 327 348 511 1092 903 427

Cities ship products to other cities. There are distances between cities as shown in the first table. There are also supply and demand of products, shown in units, between cities as shown in the second table. There is also a cost per mile distance between cities. What is the minimum shipping cost for the following: • Use only the cities of Austin, El Paso, Topeka, Little Rock, New Orleans • Use a cost per mile of $0.47 per unit shipped Table of Distance - Assume transitive equivalence between cities (Dallas to Ft Worth is the same distance as Ft Worth to Dallas Ft Worth 32 Distance Dallas Dallas Ft Worth Ok City Shreveport Houston Austin El Paso Topeka Little Rock Ok City 205 188 200 222 391 ΕΙ Little Shreveport Houston Austin Paso Rock 195 635 495 319 190 604 490 351 388 721 294 339 335 823 566 213 165 745 735 435 577 678 514 883 953 480 239 262 445 240 Unit Supply and Demand Austin can supply 110 units and demands 140 units El Paso can supply 110 units and demands 100 units Topeka can supply 95 units and demands 60 units Little Rock can supply 75 units and demands 160 units Now Orleans can supply 110 units and demands 10 Topeka New Orleans 505 540 709 327 348 511 1092 903 427

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

What does a logistics provider need to make cross-docking a viable option?
Modes and Legal forms of transportation at each stage Ans: Warehouses at each stage, its type and strategies for warehouse location You are supposed to present a summary of your supply chain design in a matrix form. Ans:
How to Compare the function of distribution Center to cross dock operation and example it?
1. Read each of the following statements and determine which method of transportation is the best option. Provide a reason for your choice. Oil shipping from an oil field in Oklahoma to a refinery in Houston, Texas. a. b. Corn transported from a farm to a local grain elevator. C. Farm equipment manufactured in Canada transported to a warehouse in Wisconsin. d. Cut flowers sent from Hawaii to California.
Describe the reverse logistics system of a beverage company, including the movement of goodsand the flow of payment. What steps does the company take to reduce their costs?
You have been asked to assist in determining freight cost for the following shipment from TuJim Device Mfg in Shanghai, China You have contacted a freight forwarder and they have given you the following main freight rates: Air: $19.25/kg Ocean- $150.00w/m The shipment consists of 5 pallets each 625kg ,each 101.6cmx121.92cmx91.44cm Show all calculations used to determine freight costs
Need answer for no.4 pls, thank you! 4. What are the logistics issues?
According to Pienaar & Vogt, (2016:1) logistics function was therefore essential for a well-coordinated supply chain from the point of origin to the point of consumption.You have been newly appointed as a logistics manager at Hokela Food (SA), One of your major roles would be facilitating the movement of products coming from farmers in the Limpopo province to supermarkets around Gauteng.Question: Explain how you will perform your role as a logistics manager and co-ordinate supply chain activities from the point of origin to the point of consumption.
LVTLS was set up as a local cargo company in 1960 by Mason Delp in pick-up and delivery for numerous intergovernmental trucking businesses in Pennsylvania's Greater Lehigh Valley. The difference between Alentown and Philadelphia has been shown to Mason by enhancing the Interstate Highway System, by upgrading the Pennsylvania Turnpike system, which provides the corridors North-South and East-West together with other improvements and roads. Furthermore, Philadelphia has a certain population, with e-road extensions and renovations which allow transit connectivity to numerous municipalities. Mason's remarks were right and the area has transformed from agricultural to the manufacturers of products and services.The creation of a series of pharmaceutical production facilities and an agglomeration of firms and services to serve the industry have all been very significant developments. • These firms' expansion and success offered Mason Delp the chance to expand its engine carrier service, both…
Discuss five benefits that come from using the principles that are applied in Network Logistics by DELL.
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)
The solution to this problem is shown below. Use it to answer parts (b) through (e). Transportation Problem Optimal Transportation Schedule To Destination From From Origin 1 оооо 2 3 3 1 2 11 19 0 0 0 9 0 0 Origin Excess Supply 34 16 0 6 Total Transportation Cost or Revenue is 347 Note: The Total Supply Exceeds The Todal Demand By 16 0 3 (b) How many chairs are moved from Baker to Business? (c) How many chairs are moved from Tirey to Parsons? (d) How many chairs are moved from Arena to Education? (e) Which site(s) has (have) chairs left? (Select all that apply.) Baker Hall Tirey Hall Arena Business Education Parsons Hall Holmstedt Hall