Question
Whirlpool Inc. anticipates refrigerator demands for the following regions: South: 180,000 Midwest: 120,000 East: 110,000 West: 100,000 Logistics Directors are designing the manufacturing network and
Whirlpool Inc. anticipates refrigerator demands for the following regions:
South: 180,000
Midwest: 120,000
East: 110,000
West: 100,000
Logistics Directors are designing the manufacturing network and they have selected four potential plant locations: NY, ATL, CHI, and SD. These potential plant sites could have capacities of either 200,000 or 400,000.
The fixed costs, and the cost of manufacturing and transporting a refrigerator is listed in the table below.
Using excel and solver, develop a linear programming model that answers the following questions:
- Where should Whirlpool Inc. build its plant facilities?
- How large in terms of capacity should each facility be?
- What is the total cost for the optimal solution?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started