(a) Optimal solution is determined using transportation simplex method as below:
(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
TechWidget Incorporated maintains three warehouses located across the United States in order to service to four...
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 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 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 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 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 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 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. 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 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 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...