Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please use Excel to answer, the help is greatly appreciated. Thank you. Drylce Inc.: Drylce, Inc., is a manufacturer of air conditioners that has seen
Please use Excel to answer, the help is greatly appreciated. Thank you.
Drylce Inc.: Drylce, Inc., is a manufacturer of air conditioners that has seen its demand grow significantly. The data file gives information on its suppliers, potential plant and warehouse locations and its customers. Exchange Capacity Fixed cost USA Brazil China UK Japan Rate United $10,000 185 $761 $1,422 $2,161 $1,308| $1,801 $1,431 $2,151 $1,565 $1,380 $1,530 $2,211 $2,322 $1,477 $1,161 $2,423 States $764 $1,538 $1,516 $1,427 $419 $2,200 $1,000 $941 $2,238 $0.90 Germany 475 15,000 1,800,000 $109.45 $4.11 50 Japan Brazil 200 13,000 $988 $70.94 India 80 400,000 Demand 270 200 120 190 100 Management must come up with a plan to decide which facilities are going to be open and how to manage the whole supply chain. 1. Which manufacturing facilities are open? List any unused capacities at the manufacturing facilities. 2. What is the total cost of this supply chainStep 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