Question

TechWidget Incorporated maintains three warehouses located across the United States in order to service to four customers. Warehouse has a supply of 35 units, warehouse 2 has a supply of 50 units, and warehouse 3 has a supply of 40 units. Customer 1 has a demand of 45 units, customer 2 has a demand of 20 units, customer 3 has a demand of 30 units, and customer 4 has a demand of 30 units. Provided below is a balance transportation tableau that includes the transportation cost between each warehouse and customer. TechWidget desires to minimize the total transportation cost while satisfying customer demand. Additionally, an initial BFS, whose values shown in red, has been provided in the tableau. Customer 1 Customer 2 Customer 3 Customer 4 6 10 9 Warehouse 1 35 12 13 Warehouse 2 10 20 20 14 9 16 Warehouse 3 s3 40 10 30 d1 45 d4-30 (a) Use the transportation simplex method to find an optimal solution- show and label all steps. Specify the allocation of supply used to satisfy customer demand. Determine the total transportation cost. (b) Setup and solve this problem in LINGO. Provide the model and corresponding output.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

(a) Optimal solution is determined using transportation simplex method as below:

Customer Supply 35 50 40 0 4 Wh 1 Wh 2 Wh 3 35 Cu2 10 20 20 14 16 10 30 Demand 45 20 30 30 Total Cost1180 Optimisation using transportation simplex method Basic Variables Iteration 1 Calculate reduced cost (Wij) for Non-Basic Variables x12 ultv2 60+11 -65 x13 ul+v3- 10012 10 2 x14 ul+4 901 9 x24 u244- 711 x31 u3+- 144+8 142 x32|u2+v2-91= 4 + 11-9 = 61most positive value, entering variable Wij corresponding to x32 is >0, therefore it is the new basic variable. In the next iteration, we use stepping stone method to assign x32 Customer V2 2 V3 Wh 1 Wh2 Wh 3 4 Supply check 35 50 40 35 12 13 10 10 30 14 16 30 30 10 Demand45 20 30 Total Cost1120 Basic Variables Iteration 2 Calculate reduced cost (Wij) for Non-Basic Variables x12 u1+v2 60 11 -65 most posive value, entering variable x13 u1+v3- 10012 10 2 x14 ul+y4 90 7-9 2 x24 u244 717 x31 u3+1 142+8 14-8 X33 u3+3 16 2+ 12 166 Wij corresponding to x12 is >0, therefore it is the new basic variable. In the next iteration, we use stepping stone method to assign x12

(b) Solution using LINGO is following:

Optimal result:


Variable Value Reduced Cost
X11 0.000000 2.000000
X12 10.00000 0.000000
X13 25.00000 0.000000
X14 0.000000 7.000000
X21 45.00000 0.000000
X22 0.000000 3.000000
X23 5.000000 0.000000
X24 0.000000 2.000000
X31 0.000000 5.000000
X32 10.00000 0.000000
X33 0.000000 3.000000
X34 30.00000 0.000000

Total cost = 1020

Add a comment
Know the answer?
Add Answer to:
TechWidget Incorporated maintains three warehouses located across the United States in order to service to four...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • please do it in microsoft exel transpo oprtn logitics management Inventory Control Problem In preparation for the wi...

    please do it in microsoft exel transpo oprtn logitics management Inventory Control Problem In preparation for the winter season, a clothing company is manufacturing parka and goose overcoats, insulated pants, and gloves. All products are manufactured in four different departments: cutting, insulating, sewing, and packaging. The company has received firm orders for its products. The contract stipulates a penalty for undelivered items. Devise an optimal production plan for the company based on the following data: Time per n hr ks...

  • 5. A television company ships televisions from three warehouses to three retail stores on a monthly...

    5. A television company ships televisions from three warehouses to three retail stores on a monthly basis. Each warehouse has a fixed supply per month, and each store has a fixed demand per month. The manufacturer wants to know the number of television sets to ship from each warehouse to each store in order to minimize the total cost of transportation. Each warehouse has the following supply of televisions available for shipment per month: Warehouse Supply (member of sets) 1....

  • 1. ABC pharmaceutical Company has four factories supplying four warehouses. The company’s management hires you as...

    1. ABC pharmaceutical Company has four factories supplying four warehouses. The company’s management hires you as consultant to determine a minimum-cost shipping schedule for its monthly output to the warehouses. Factory supply, warehouse demands, and shipping cost per case are shown below. Factory Supply Warehouse Demand Indianapolis 15 Columbus 10 Phoenix 6 St. Louis 12 New York 14 Denver 15 Atlanta 11 Los Angeles 9 Shipping Costs per case (In Dollars0 From To Columbus To St. Louis To Denver To...

  • VOOM has four warehouses 1, 2,3, and 4. VOOM needs to supply 100 Tons to retailer...

    VOOM has four warehouses 1, 2,3, and 4. VOOM needs to supply 100 Tons to retailer P, 300 Tons to retailer Q, and 300 tons to retailer R. The cost of delivery from each warehouse to retailers is provided in the following table. While each of the warehouses has an inventory of 400 tons they can supply, R requires that every warehouse supplies at least 25 tons to R.     There is a special arrangement between Warehouse 4 and R...

  • 3. There are three warehouses (1, 2, 3) and three markets (A,B,C). The supplies and demands of th...

    3. There are three warehouses (1, 2, 3) and three markets (A,B,C). The supplies and demands of the warehouses and markets are given in following table. The costs of supplying each item is also given in this table. 5) Supply 10 150 175 275 12 300 Demand 200 100 a- Formulate the problem as linear programming. b- Solve this problem to minimize the transportation cost. 3. There are three warehouses (1, 2, 3) and three markets (A,B,C). The supplies and...

  • The distribution network consists of two plants, three warehouses and four customers. Plant capacities and shipping...

    The distribution network consists of two plants, three warehouses and four customers. Plant capacities and shipping costs (per unit) from each plant to each warehouse are as follows: Warehouse Plant 1 2 3 Plant Capacity 1 4 7 6 5000 2 8 5 6 6000 Customer demand and shipping costs per unit from each warehouse to each customer are: Customers Warehouse 1 2 3 4 1 6 4 8 4 2 3 6 7 7 3 5 6 8 12...

  • transportation logistics Problem#3 (10 marks) An assembly plant is planned to take components from four suppliers and se...

    transportation logistics Problem#3 (10 marks) An assembly plant is planned to take components from four suppliers and send finished goods to eight regional warehouses.. The locations of these and the amounts supplied or demanded are shown in the following table. Where would you start looking for a site for the assembly plant? Locatlon X,Y co-ordinates Supply/Demand Supplier Supplier 2 7,80 140 85,35 80 Supplier 3 120 9,81 Supplier 4 11,62 70 Supply/Demand Locatlon X,Y co-ordinates Warehouse 1 45 12,42 Warehouse...

  • Find Solution using North-West Corner method, What is the total transportation cost? choose the closest answer....

    Find Solution using North-West Corner method, What is the total transportation cost? choose the closest answer. D1 D2 D3 D4 Supply S1 19 30 50 10 7 S2 70 30 40 60 9 S3 40 8 70 20 18 Demand 5 8 7 14

  • Transportation Problem A firm has four manufacturing plants and four warehouses. It is trying to determine...

    Transportation Problem A firm has four manufacturing plants and four warehouses. It is trying to determine the optimal way to ship from its plants to the warehouses. The plant capacities and warehouse requirements are as follows:      Plant Capacity                      Warehouse requirement    1 = 1200                                     A = 3100          2 = 4200                                      B = 1800          3 = 5000                                      C = 2000          4 = 2000                                      D = 4400 A union requirement prohibits the firm from shipping...

  • To complete this project you have to make a presentation of 10 slides and a written...

    To complete this project you have to make a presentation of 10 slides and a written report on the following: Transportation models and its usage. Analyze the following facility location case and solve it as a linear program formulation. Which of the new locations will yield the lowest cost for the firm in combination with the existing plants and warehouses? The Hardgrave Machine Company produces computer components at its plants in Cincinnati, Salt Lake City, and Pittsburgh. These plants have...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT