BUS 132B – Supply Chain Analytics Assignment #3
供应链分析作业代写 “DryIce, Inc., is a manufacturer of air conditioners that has seen its demand grow significantly. The company anticipates nationwide demand···
1.InChapter 5, Exercise 2, your textbook includes the following: 供应链分析作业代写
“DryIce, Inc., is a manufacturer of air conditioners that has seen its demand grow significantly. The company anticipates nationwide demand for the next year to be 180,000 units in the South, 120,000 units in the Midwest, 110,000 units in the East, and 100,000 units in theWest. Managers at DryIce are designing the manufacturing network.
And have selected four potential sites-New York, Atlanta, Chicago, and San Diego. Plants could have a capacity of either 200,000 or 400,000 units. The annual fixed costs at the four locations are shown in Table 5-5, along with the cost of producing and shipping an air conditioner to each of the four markets.”
1.Formulate a capacitated facility location model that could be used to determine whereDryIce should build its factories including how large each facility should be.
2.UseExcel Solver to find the optimal Submit your Excel file.
3.Report the optimal solution. Where should DryIce build its factories and how largeshould they be?
4.Reportthe optimal value of the objective
2.Recallthe Sun Oil example from 供应链分析作业代写
1.Ifa plant must be built in Europe, what constraint(s) would you add to the model?
2.Re-runSolver with your updated model from part Submit your Excel file.
3.Whatis the new optimal solution with the updated model from part a?
4.Whatis the minimum cost of the optimal solution using the model from part a?
3.Recallthe Sun Oil example from 供应链分析作业代写
1.Ifa plant must be built in every market, what constraint(s) would you add to the model?
2.Re-runSolver with your updated model from part Submit your Excel file.
3.Whatis the new optimal solution with the updated model from part a?
4.Whatis the minimum cost of the optimal solution using the model from part a?
更多代写:cs写作 CS计算机代考 discussion代写 空间设计essay代写 留学paper代写 管理科学建模代写