The Thor International Company operates four factories that ship products to five warehouses. The shipping costs, requirements, and capacities are shown in the tableau below. Use the transportation method to find the shipping schedule that minimizes shipping cost. Shipping Cost per Case to each Warehouse W2 Factory Сарacity W1 W3 W4 W5 Dummy $5 $4 $5 $4 $7 $0 F1 60,000 $4 $5 $4 $6 $8 $0 F2 80,000 $6 $5 $7 $4 $5 $0 F3 80,000 $5 $9 $6 $7 $4 $0 F4 40,000 Demand 45,000 40,000 30,000 35,000 50,000 60,000 260,000 The minimum shipping cost is $ (Enter your response as a whole number.)

The Thor International Company operates four factories that ship products to five warehouses. The shipping costs, requirements, and capacities are shown in the tableau below. Use the transportation method to find the shipping schedule that minimizes shipping cost. Shipping Cost per Case to each Warehouse W2 Factory Сарacity W1 W3 W4 W5 Dummy $5 $4 $5 $4 $7 $0 F1 60,000 $4 $5 $4 $6 $8 $0 F2 80,000 $6 $5 $7 $4 $5 $0 F3 80,000 $5 $9 $6 $7 $4 $0 F4 40,000 Demand 45,000 40,000 30,000 35,000 50,000 60,000 260,000 The minimum shipping cost is $ (Enter your response as a whole number.)

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

The Bright Company wants to figure out the best way to ship their new product, Flying Widgets, from their factories through their warehouses to their retail outlets. They would like to set up a Transhipment table so they can use POM to find the least cost shipping routes. They have hired you to set up the Transhipment table based on the information below. You will be paid handsomely if you can come up with the correct table. Shipping Costs Shipping Costs 01 02 03 04 Wi W2 W3 W1 4. 2 F1 4 W2 4 F2 4 2 W3 4. 3. 4. Also, Flying Widgets can be shipped from Factory 1 to Factory 2 for $3 per unit. Factory 1 can produce 300 units and factory 2 can produce 100 units. Outlet 1 demand is 50 units, Outlet 2 is 150 units, Outlet 3 is 100 units, and Outlet 4 is 100 units.
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
The Thor International Company operates four factories that ship products to five warehouses. The shipping costs, requirements, and capacities are shown in the tableau below. Use the transportation method to find the shipping schedule that minimizes shipping cost. Factory Shipping Cost per Case to each Warehouse Capacity W1 W2 W3 W4 W5 Dummy F1 $4 $5 $4 $3 $6 $0 50,000 F2 $3 $4 $4 $5 $7 $0 80,000 F3 $3 $4 $5 $3 $5 $0 90,000 F4 $4 $6 $5 $6 $3 $0 40,000…
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
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.
Evaluate the current China/Taiwan logistics costs. Assume a current total volume of 190,000CBM and that 89 percent is shipped direct from the supplier plants in containers. Use the datafrom the case and assume that the supplier-loaded containers are 85 percent full. Assume thatconsolidation centers are run at each of the four port locations. The consolidation centers useonly 40-foot containers and fill them to 96 percent capacity. Assume that it costs $480 to ship a20-foot container and $600 to ship a 40-foot container. What is the total cost to get thecontainers to the United States? Do not include U.S. port costs in this part of the analysis
Using the intuitive least cost method for the given transportation problem, answer the following: Cleveland Dayton Erie Supply Allentown $22 $16 $21 100 Philadelphia $28 $27 $18 150 Harrisburg Demand $25 $23 $19 175 175 175 175 What is the maximum quantity that can be shipped from Allentown to Erie? [ Select] What is the maximum quantity that can be shipped from Harrisburg to Cleveland? [ Select] What is the maximum quantity that can be shipped from Harrisburg to Dayton? [ Select ] Which demand location will have an unmet demand? [Select ]
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
9. Solve the following transportation problem using Excel. Factory A E K Demand B 6 5 8 35 Warehouse C 8 11 9 28 D 8 9 7 32 M 5 7 13 25 Supply 30 40 50
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
1. Central Construction Company moves materials between three plants and three projects. Project A requires 72 truckloads each week, project B requires 102, and project C requires 41. Plant W can supply 56 loads, plant X can supply 82, and plant Y can supply 77. Using the cost information given in the following table, compute the optimum transportation cost using the stepping stone method. COST INFORMATION From To Project A To Project B To Project C Plant w P 4.00 8.00 8.00 Plant X 16.00 24.00 16.00 Plant Y 8.00 16.00 24.00
critically discuss the logistics risks that GEW can be exposed to when it locates to any of the provided options