Name5) Consider the transportation problem having the units shipping cost shown in the table below.SourceABDemandA.16530B₂DDestination2(3)78403OFormulate a network model for this problem as a minimum cost flow problem by drawing anetwork model.AB. Formulate and solve a spreadsheet model for this problem.4630Supply4060

The transportation problem is a special kind of linear programming problem, where the optimal…

Answered: 5) Consider the transportation problem…

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

short solution
4. Consider the following to illustrate a transshipment (Min) problem. Supply (1,000 tons) Fr\To F G H Fr\To D E D $23 $15 $29 A $15 $20 75 E $20 $17 $24 B $18 $16 108 Demand 93 83 123 C $22 $24 86 (1,000 tons) B. Identify a starting solution using Northwest Corner Method. Show complete solution.
Develop a LP model for the transportation problem (cost problem). Solve the LP model to find the optimal solution and the minimum total cost.
a. Goods have to be transported from sources S1, S2 and S3, to destinations D1, D2 and D3. The transportation cost per unit capacities of the sources and requirements of destinations are given in the following table: Destination Source S1 S2 S4 D1 8 15 3 150 D2 5 10 9 Demand 80 50 Determine the transportation schedule so that cost is minimized. D3 6 12 10 Supply 120 80 80
Given the following transportation tableau-where the numbers in each cell represent transportation costs from the specific source to the specific destination-with supply figures corresponding to each source and demand figures corresponding to each destination: Source A B Demand 1 $22 2.4 2.1 350 Destination 2 3.4 3.2 3.6 400 3 1.9 1.8 2.1 200 Supply 200 300 450 A. According to the Northwest Corner method, the initial solution would have a total transportation cost of B. According to the Northwest Corner method, the initial solution would give to cell B2 a loading of C. According to the Vogel's Approximation Method, the initial solution would give to cell B2 a loading of D. According to the Vogel's Approximation Method, the initial solution would have a total transportation cost of E. According to the minimum cell cost method, the initial solution would give to cell C1 a loading of F. According to the minimum cell cost method, the initial solution would have a total transportation cost…
The objective function of a transportation problem is to: A. maximize transportation cost B. maximize supply quantities C. minimize total shipping cost D. minimize total demand Don't answer by pen paper and don't use chatgpt otherwise we will give dounvote
Briefly describe how supply chain planning and control is managed in an ERP system.
Here is the initial tableau (by the NorthWest method) of a Min transportation problem. 1 2 3 Demand 19 Dual(v) 1 15 9 S1: 11 10 14 0 S2: 0 S3: B 0 B 3 N 15 Demanders 2 8 0 9 12 188 15 9 21 5 N 0 B 0 B 13 10 8 8 20 3 0 20 -4 N -6 N 0 B 17 7 5 4 0 0 1 -14 N -8 N 0 B Supply Dual(u) 0 (188 188 188 188 Using the Loop method fill in the values of the next tableau Each 2x2 matrix is the relevant square in the tableau. 9 (For grading convenience, in bottom right corner of each box use 1 for "B" and 0 for "N") 22 188 188 188 30 -4 2
Oranges are grown, picked and then stored in warehouses in Tampa, Miami, and Fresno.Theses warehouses supply oranges to markets in New York, Philadelphia, Chicago, and Boston.The following table shows the shipping costs per truckload (in hundreds of dollars), supply, anddemand. Because of an agreement between distributors, shipments are prohibited from Miamito Chicago:To (cost, in $100)From New York Philadelphia Chicago Boston SupplyTampa 9 14 12 17 150Miami 11 10 6 10 250Fresno 12 8 15 7 200Demand 110 250 140…
(Problem 1) A manager of Drexel Clothing Company has to make a decision on shipping. There are two shippers, A and B. Both offer a two-day rate: A for $500 and B for $525. In addition, A offers a three-day rate of $450 and a nine-day rate of $325 and B offers a four-day rate of $400 and a seven-day rate for $375. Annual holding costs are 25% of unit price. Four hundred boxes are to be shipped, and each box has a price of $250. The shipping charges are for the entire batch of 400 boxes. Which shipping alternative would you recommend? Explain.
2. By using the data below, use a transportation method to : COST in $ Assembly Plant Supply 210 Factory 2 A 8 9 400 10 6 12 8 190 Demand 120 620 60 A. Formulate this linear programming model B. If you are using VAM and NorthWest corner method, which solution is the best and how much is the best total cost ?
Paragraph D F S A 3 8 600 B 5 7 9 400 C 4 4 4 700 Styles 1- Find initial feasible solution by west-corner rule. 2- Find initial feasible solution by Vogel's Approximation method. 3- Find the minimum transportation cost solution by stepping-stone method. 500 800 400

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