3 A product is produced at three plants and shipped to three warehouses (the transportationcosts per unit are shown in the following table).WarehousePlantW,W2W3Plant CapacityP,P2P32016243001010500121810100Warehouse demand200400300a. Show a network representation of the problem.b. Develop a linear programming model for minimizing transportation costs; solve thismodel to determine the minimum cost solution.c. Suppose that the entries in the table represent profit per unit produced at plant i andsold to warehouse j. How does the model change from that in part (b)?

Answered: 3 A product is produced at three plants…

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.)
The City of Boston is taking bids on four construction projects. Four companies have made the bids as shown in the following table: Company 1 2 3 4 Bids Project 1 Project 2 Project 3 Project 4 $4000 $5000 $4000 - $3000 $2000 $4000 $4000 $5000 a. Each bidder can be assigned only I route. Use the assignment method (Hungarian Method) to minimize the cost of assigning the four project contracts.
Please refer to the attached file:
(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.
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
Please how to find the total cost using the transportation method.
Boysen produces enamel and acrylic paint from two particular raw materials M1 and M2. The following data provides the data regarding the production restrictions.
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.
2.) Your business provides technical support for very complex and specialized machinery used by companies throughout the country, and you currently have support centers at 5 locations. However, due to a poor market, you have been forced to close your centers in Houston and San Diego. You will have to relocate all of your technicians in these two centers to your other three centers in Cleveland, Seattle, and Charlotte. Due to the varying costs of living in each city, and travel and retraining times, the cost for relocating an employee varies depending on where the employee is moving. These costs are given in the following table: To: From: Cleveland Seattle Charlotte $5,000 | $7,000 $7,000 $4,000 $6,000 $8,000 Houston San Diego You currently have 40 employees in Houston and 55 employees in San Diego, which all need to be relocated. Cleveland is able to take in at most 35 relocated employees, Seattle can take in at most 32 employees, and Charlotte is able to take in at most 50 employees.…
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.
6 see pictures to solve

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