2. (3+3+1+1) Continuing form the problem # 1 Spools'R'Us Manufacturing company produces different types of spools. Demands for bob spools (in 103 units) over last 6 months (2020-2021) are given as follow: Month Demand Sept. 2020 450 Oct. 2020 400 Nov. 2020 550 Dec. 2020 600 Jan. 2021 650 Feb. 2021 750 a) Based on the nature of the values determined as the trend values in the adjusted exponential smoothing technique for forecasting in problem-1, the industrial engineer of Spools'R'Us decided to use linear trend technique for forecasting. From 1st March 2021 to the COB 3/15/2021, the manufacturer sold 570,000 bob spools. Utilizing linear trend forecasting method, how many more bob spools Spools'R'Us expects to sell for the rest of March, 2021? b) Was he/she correct on the decision for utilizing the linear trend forecasting technique for this set of historical sales values? Justify your answer with references from problem-1 and problem-2(a). c) Based on the answers in parts: a and b, is it possible to forecast for the month of July 2021? d) Continuing from part-c, if your answer is yes, then forecast for the month of June 2021. If your answer is "no", then forecast for the month of July 2021 using any appropriate technique discussed during the class. Note: This manufacturing company uses percentage deviation (MAPD) as a tool for justifying and utilizing a specific technique and a set of parameters. 2. (3+3+1+1) Continuing form the problem # 1 Spools'R'Us Manufacturing company produces different types of spools. Demands for bob spools (in 103 units) over last 6 months (2020-2021) are given as follow: Month Demand Sept. 2020 450 Oct. 2020 400 Nov. 2020 550 Dec. 2020 600 Jan. 2021 650 Feb. 2021 750 a) Based on the nature of the values determined as the trend values in the adjusted exponential smoothing technique for forecasting in problem-1, the industrial engineer of Spools'R'Us decided to use linear trend technique for forecasting. From 1st March 2021 to the COB 3/15/2021, the manufacturer sold 570,000 bob spools. Utilizing linear trend forecasting method, how many more bob spools Spools'R'Us expects to sell for the rest of March, 2021? b) Was he/she correct on the decision for utilizing the linear trend forecasting technique for this set of historical sales values? Justify your answer with references from problem-1 and problem-2(a). c) Based on the answers in parts: a and b, is it possible to forecast for the month of July 2021? d) Continuing from part-c, if your answer is yes, then forecast for the month of June 2021. If your answer is "no", then forecast for the month of July 2021 using any appropriate technique discussed during the class. Note: This manufacturing company uses percentage deviation (MAPD) as a tool for justifying and utilizing a specific technique and a set of parameters
