3) A toy manufacturer currently has two warehouses (1 and 2) that are operational and meet the demand of backyard play sets at three retail outlets A, B and C. The supply of the play sets at warehouse 1 and 2 are 500 and 400 units respectively. The demand of play sets at warehouses A, B and C are 400, 600, and 350 units respectively. The unit cost of transportation from warehouse 1 and 2 to retail outlets A, B and C are shown in the table below. The toy manufacturer wants to open a third warehouse which will have a supply of 500 units of backyard play sets per week. Two locations, N1 and N2, are being considered for the new warehouse. Transportation costs from location N1 to stores A, B, and C are $6, $8, and $7 per unit, respectively; from location N2, the costs are $10, $6, and $4, respectively. Which of the two locations is the preferred location for the new warehouse? Hint: You will have to model and solve two LP transportation problems. Solve the model using Solver in excel. Warehouse 1 Warehouse 2 Retail Outlet A 8 5 Retail Outlet B 3 10 Retail Outlet C 7 9
3) A toy manufacturer currently has two warehouses (1 and 2) that are operational and meet the demand of backyard play sets at three retail outlets A, B and C. The supply of the play sets at warehouse 1 and 2 are 500 and 400 units respectively. The demand of play sets at warehouses A, B and C are 400, 600, and 350 units respectively. The unit cost of transportation from warehouse 1 and 2 to retail outlets A, B and C are shown in the table below. The toy manufacturer wants to open a third warehouse which will have a supply of 500 units of backyard play sets per week. Two locations, N1 and N2, are being considered for the new warehouse. Transportation costs from location N1 to stores A, B, and C are $6, $8, and $7 per unit, respectively; from location N2, the costs are $10, $6, and $4, respectively. Which of the two locations is the preferred location for the new warehouse? Hint: You will have to model and solve two LP transportation problems. Solve the model using Solver in excel. Warehouse 1 Warehouse 2 Retail Outlet A 8 5 Retail Outlet B 3 10 Retail Outlet C 7 9
Purchasing and Supply Chain Management
6th Edition
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
ChapterC: Cases
Section: Chapter Questions
Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 6 images
Recommended textbooks for you
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
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
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
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,