Supply Chain Management Homework 2 ■ Homework submission deadline:20:00,2014-Nov-14 The homework must be completed and submitted on an individual basis.If two or more students submit identical homework solutions,each student will get only a fraction of the grade for this assignment. ◆ Late policy:first late day will reduce your assignment grade by 40%.Additional days will reduce the entire homework grade to 0.If you have a special circumstance,please contact jianjun.gao@vip.163.com ahead of the submission deadline. Submission Policy:Please email your answer to jianjun.gao@vip.163.com.The title of your email should be in the following format "SCM-id-name",e.g.,"SCM-10000000-Zhangxiaoguang". Question 1(25) Consider monthly demand for the ABC Corporation as shown in the following Table.Forecast the monthly demand for Year 6 using the static method for forecasting.Evaluate the bias,TS,MAD, MAPE,and MSE.Evaluate the quality of the forecast.Please also submit the excel file) Sales Year 1 Year 2 Year 3 Year 4 Year 5 January 2,000 3,000 2.000 5.000 5.000 February 3,000 4,000 5.000 4,000 2,000 March 3.000 3.000 5.000 4,000 3,000 April 3.000 5.000 3.000 2.000 2000 May 4000 5.000 4.000 5.000 7.000 June 6.000 8,000 6.000 7.000 6.000 July 7,000 3,000 7.000 10,000 8.000 August 6,000 8,000 10.000 14.000 10.000 September 10,000 12,000 15.000 16.000 20.000 October 12,000 12.000 15.000 16.000 20.000 November 14,000 16.000 18.000 20.000 22.000 December 8,000 10.000 8.000 12.000 8.000 Total 78,000 89,000 98.000 115,000 113.000 Question 2(25) Prefab,a furniture manufacturer,uses 20,000 square feet of plywood per month.Its trucking company charges Prefab $400 per shipment,independent of the quantity purchased.The manufacturer offers an all unit quantity discount with a price of $1 per square foot for orders under 20,000 square feet,$0.98 per square foot for orders between 20,000 square feet and 40,000 square feet,and $0.96 per square foot for orders larger than 40,000 square feet.Prefab incurs a holding cost of 20 percent.What is the optimal lot size for Prefab?What is the annual cost of such a policy?What is the cycle inventory of plywood at Prefab? How does it compare with the cycle inventory if the manufacturer does not offer a quantity discount but sells all plywood at $0.96 per square foot? Question 3(25) Motorola obtains cell phones from its contract manufacturer located in China to serve the U.S. market.The U.S.market is served from a warehouse located in Memphis,Tennessee.Daily demand at the Memphis warehouse is normally distributed,with a mean of 5,000 and a standardSupply Chain Management Homework 2  Homework submission deadline: 20:00, 2014-Nov-14  The homework must be completed and submitted on an individual basis. If two or more students submit identical homework solutions, each student will get only a fraction of the grade for this assignment.  Late policy: first late day will reduce your assignment grade by 40%. Additional days will reduce the entire homework grade to 0. If you have a special circumstance, please contact jianjun.gao@vip.163.com ahead of the submission deadline.  Submission Policy: Please email your answer to jianjun.gao@vip.163.com. The title of your email should be in the following format “SCM-id-name”, e.g., “SCM-10000000-Zhangxiaoguang”. Question 1 (25) Consider monthly demand for the ABC Corporation as shown in the following Table. Forecast the monthly demand for Year 6 using the static method for forecasting. Evaluate the bias, TS, MAD, MAPE, and MSE. Evaluate the quality of the forecast. ( Please also submit the excel file) Question 2(25) Prefab, a furniture manufacturer, uses 20,000 square feet of plywood per month. Its trucking company charges Prefab $400 per shipment, independent of the quantity purchased. The manufacturer offers an all unit quantity discount with a price of $1 per square foot for orders under 20,000 square feet, $0.98 per square foot for orders between 20,000 square feet and 40,000 square feet, and $0.96 per square foot for orders larger than 40,000 square feet. Prefab incurs a holding cost of 20 percent. What is the optimal lot size for Prefab? What is the annual cost of such a policy? What is the cycle inventory of plywood at Prefab? How does it compare with the cycle inventory if the manufacturer does not offer a quantity discount but sells all plywood at $0.96 per square foot? Question 3(25) Motorola obtains cell phones from its contract manufacturer located in China to serve the U.S. market. The U.S. market is served from a warehouse located in Memphis, Tennessee. Daily demand at the Memphis warehouse is normally distributed, with a mean of 5,000 and a standard