Homework11. The distribution system for the Herman Company consists of three plants, two ware-houses, and four customers. Plant capacities and shipping costs per unit (in S) from eachplant to each warehouse are as follows:c.PlantWarehouseDemand-25131485Customer demand and shipping costs per unit (in S) from each warehouse to each cus-tomer are as follows:a. Develop a network representation of this problem.b.Formulate a linear programming model of the problem.Solve the linear program to determine the optimal shipping plan.1Warehouse3300624CustomerCapacity4506003803003873004400

Answered: Image /qna-images/answer/b89f09bc-1f8e-42af-9082-3daed8cbb14c.jpg

Answered: 11. The distribution system for the…

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

1. Ethan Steel, Inc. has two factories that manufacture steel components for two different rail projects located at two different sites. They would like to determine the number of steel components they need to transport from each factory to each project site. The demand for the steel components for the two projects, Project A, and Project B are 3000, and 4000, respectively. The production and shipping details are as below:Production details:Factory 12Maximum capacity 20005000Shipping details (with per-unit shipping cost in dollars):Project Factory A B 178265Develop a linear programming optimization model to determine the distribution plan (from factories to projects) that minimizes the total transportation cost. (Do NOT solve the model.)
solve the following LP MODELS
h of the following entities may legally sell insurance in the state of Florid Religious institutions required with the state Risk management consultants Law firms specializing in insurance 1. Career agency systems anscribed Image Text: Which of the following entities may legally sell insurance in the state of Florida a. Religious institutions required with the state b. isk management consultants c. Law firms specializing in insurance d. Career agency systems ex L @ W
The Maytubig Water Company purifies drinking water in Luzon and Mindanao, which it plans to distribute to typhoon-hit areas in Tacloban, Ilo-ilo, Ormoc, Northern Cebu, and Eastern Samar. The Luzon filtering plant is expected to produce 85,000 liters and the Mindanao filtering plant is expected to produce 50,000 liters a week. These are estimated weekly water requirement according to DSWD: WHOLESALER LITERS OF PURIFIED WATER Tacloban Ilo-ilo Ormoc Northern Cebu Eastern Samar O None of the above Here is the cost of shipping 1,000 liters of purified drinking water from each filtering plant to each affected area: PLANT WHOLESALER COST Luzon Tacloban P 20 Luzon llo-ilo 30 Luzon Ormoc 50 Luzon Northern Cebu 60 Luzon Eastern Samar 35 Mindanao Tacloban 50 Mindanao Ilo-ilo 60 Mindanao Ormoc 20 Mindanao Northern Cebu 30 Mindanao Eastern Samar 70 The distribution cost for the optimal solution is: OP 3,250,000 OP 3,275,000 OP 3,325,000 45,000 25,000 40,000 OP 3,430,000 12,000 20,000
A fruit juice manufacturer has recently begun negotiations with brokers in the areas where it intends to distribute its products. Before finalizing the agreements, however, the manager wants to determine shipping routes and costs. The firm has three plants with the capacities as shown below: Estimate demands in each of the warehouse localities are: PLANT CAPACITY (PIECES PER WEEK) WAREHOUSE 1 2 3 400 800 600 A B C D DEMAND (PIECES PER WEEK) 900 200 400 300 The estimated ship cost per box for the various routes are: ΤΟ FROM A B C D 1 5 7 9 12 2 10 7 2 3 3 8 9 6 4 Row/Column Opportunity Cost Demand Row/Column Cell Total Cost Opportunity Cost Cost of the above Test of unallocated Cells allocation Supply Amount char
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 ?
A company manufactures a product at its plants in C and D; then ships the product to its four distribution centers in K, L, M, and N. The transportation costs per unit (in dollars per unit) are as follows: from C to K, L, M, and N: 10, 5, 9, and 20. from D to K, L, M, and N: 2, 8, 30, and 10. The monthly demand from K, L., M, and N are: 3000, 1400, 4000, and 1200 units, respectively. On the other hand, the monthly capacity at plants C and D are: 4100 and 5800 units, respectively. Develop a linear programming model that can be used to determine the distribution plan that will minimize total monthly transportation cost. Use Excel Solver to find the optimal solution The optimal solution shows that the total monthly transportation cost is dollars.
i need all parts solution
Consider an assignment issue that has the following cost table. a. Draw a network representation of this assignment problem.b. Formulate this problem as a transport problem by drawing up the appropriate parameter table.c. Determine the optimal assignment solution using the Hungarian method!d. Use Excel Solver to get the optimal solution.
Formulate a linear program using LP Model Formulation. Miguel hauls mangoes between Manila mango plantation and packing plants in Clark. Miguel’s schedule this week calls for 500 boxes with locations and costs as follows.
JN Company manufactures two products that use material 1, material 2, and material 3. Consider the following table: Resources needed Material 1 Material 2 Material 3 Price per Unit in Pesos Requirement per Unit Product 1 2 2 0 150 Product 2 3 1 4 200 a. Write the linear programming model for this problem. b. Present the optimal solution and interpret the result. Maximum Availability (units) 1200 1000 800 c. Determine the status of each resource. d. Determine the dual prices for the materials 1, 2 and 3. Explain each value. e. Determine the feasibility ranges for the dual prices obtained in (d). f. If the available number of material 1 is increased to 1300 units, find the new optimum solution. g. Find the range of optimality for (i.) product 1 and (ii.) product 2 for which the optimal. solution remains valid.
A manufacturing company has 4 factories and 3 warehouses. The costs for transporting its products from factories to ware houses, the supply capacity of factories and demands in warehouses are given respectively by 6 4 81 70 170 4 3 2 C = 130 S = D= 200 2 4 7 100 130 1 5 8 200 a. Use minimum cost method to find an initial feasible solution. b. Determine the amount of products to be transported from factories to warehouses to minimize the cost.

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