BUS 132B – Supply Chain Analytics Assignment #4
供应链作业代写 “Blue Computers, a major server manufacturer in the United States, currently has plants in Kentucky and Pennsylvania. The Kentucky plant···
1.InChapter 5, Exercise 7, your textbook includes the following: 供应链作业代写
“Blue Computers, a major server manufacturer in the United States, currently has plants in Kentucky and Pennsylvania. The Kentucky plant has a capacity of 1 million units a year. And the Pennsylvania plant has a capacity of 1.5 million units a year. The firm divides the United States into five markets: northeast, southeast, midwest, south, and west. Each server sells for
$1,000. The firm anticipates a 50 percent growth in demand (in each region) this year (after which demand will stabilize). And wants to build a plant with a capacity of 1.5 million units per year to accommodate the growth. Potential sites being considered are in North Carolina and California. Currently the firm pays federal, state. And local taxes on the income from each plant. Federal taxes are 20 percent of income. And all state and local taxes are 7 percent of income in each state.
North Carolina has offered to reduce taxes for the next 10 years from 7 percent to 2 percent. Blue Computers would like to take the tax break into consideration when planning its network. Consider income over the next 10 years in your analysis. Assume that all costs remain unchanged over the 10 years. Use a discount factor of 0.1 for your analysis. Annual fixed costs, production and shipping costs per unit, and current regional demand (before the 50 percent growth) are shown in Table 5-12.”
供应链作业代写
- Withminimizing cost as the objective, formulate a capacitated facility location model that could be used to determine where Blue Computers should build the new
- UseExcel Solver to find the optimal Submit your Excel file.
- Reportthe optimal Where should Blue Computers build the new plant and how should the network be structured?
- Reportthe total cost and total profit using the solution from part c).
- Nowassume that Blue Computers sets an objective of maximizing after-tax Modify the optimization model created in part a) to maximize after-tax profits.
- Answerparts b, c, and d using the model created in part e).
AND 供应链作业代写
2.SnapFastmakes the fastest supercomputers in the The production manager has hired you as a consultant to help predict monthly demand. Based on past demand figures. The following table presents the demand figures for the last 5 months.
a.Basedon the pattern of the above demand data, which objective forecasting method(s) would you recommend and why?
b.What will be the demand forecasts for November if a 2-month simple movingaverage is used?
AND 供应链作业代写
c.Basedon the simple exponential smoothing method with a smoothing constant, α= 0.5, calculate forecasted demand for November. Start with an initial forecast of 30 supercomputers in June
d.Basedon Holt’s method with smoothing constants, α = 5, β = 0.1, calculate forecasted demand for November. For June, start with Ft = 30 and Tt = 4.
e.Using the MAD measure, only for months from (including) August to (including)October, compare the accuracy of forecasts generated by simple moving average in part (b), simple exponential smoothing in part (c), and Holt’s method in part (d). Based on your MAD measures, which forecasting method is better in this case?
更多代写：c++程序代写 exam考试代考 英文代写 美国论文代写 英国作业代写 留学生数学作业代写
