Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, Could you please upload an excel file for the answer but if not then could you please explain in detail on how to add
Hello, Could you please upload an excel file for the answer but if not then could you please explain in detail on how to add the formulas on the excel file to get the answers. Thank you. Here is the zoomed in photo. Thanks. A B D E F G H 1 M N DryIce Inc. Facilities Planning Dryice Inc. is an air conditioner manufacturer experiencing significant growth. Anticipated demand is 180,000 units in the South, 110,000 units from the East, 120,000 units from the Midwest, and 100,000 units from the West. Supply Chain Managers are designing the manufacturing networkand have selected four potential sitos - New York, Atlanta, Chicago or San Diego. Plants can have capacity of other 200,000 or 400,000 units. Annual food costs and per unit production and transportation costs are below. Use solver to determine where the factories should be built and how large they should be to minimize total costs Shipped tom NY New York Snipped from Alat tom San Atanta Shipped from Chicago Chicago 6.000.000 10.000.000 5.500.000 9.200.000 5.600.000 300.000 6.100.000 10 200.000 Fixed Costs 200k plant 400k plant Variabile Costa East South Midwest West - 211 2:32 240 300 232 212 230 20 230 215 270 290 280 270 225 110.000 10.00 120.000 100.000 0.000.000 5.500 000 5.600.000 6.100.000 3 1 000 000 5.500.000 5.000.000 6100 000 23.200.000 TOTAL SYSTEM COST QE Practice Problem Insert Draw Page Layout Formulas Data Review View Tell me X Arul 10AA General 2 Wro Test Merge & Center 27 int- We 27 3 8 TV $% 9 Conditional Format Cell Formatting as Table Styles El Format B D E F G H 1 J L M DryIce Inc. Facilities Planning Dryice Inc. is an air conditioner manufacturer experiencing significant growth. Anticipated demand is 180,000 units in the South, 110,000 units from the East, 120,000 units from the Midwest, and 100,000 units from the West. Supply Chain Managers are designing the manufacturing networkand have selected four potential sites - New York, Atlanta, Chicago or San Diego. Plants can have capacity of either 200,000 or 400,000 units. Annual fixed costs and per unit production and transportation costs are below. Use solver to determine where the factories should be built and how large they should be to minimize total costs. Shipped from Shipped from NY Shipped from Chicago Shipped from San Diego New York Atlanta Atlanta Chicago San Diego Requirements Supply 6,000,000 10.000.000 5,500,000 9,200,000 5,600,000 9.300,000 6,100,000 10,200,000 Fixed Costs 200k plant 400k plant Variable Coats East South Midwest West 238 299 230 211 232 240 300 232 212 230 280 110,000 180,000 120,000 100.000 280 270 225 215 270 6.000.000 5,500,000 5.600.000 6.100,000 6.000.000 5,500,000 5.600.000 6.100.000 23,200,000 TOTAL SYSTEM COST Dryte Sheet1
Hello,
Could you please upload an excel file for the answer but if not then could you please explain in detail on how to add the formulas on the excel file to get the answers.
Thank you.
Here is the zoomed in photo. Thanks.
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