Question: 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 10 units) over last

2. (3+3+1+1) Continuing form the problem # 1
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 10 units) over last 6 months (2020-2021) are given as follow: Month Sept. 2020 Oct. 2020 Nov. 2020 Dec. 2020 Jan. 2021 Feb. 2021 Demand 450 400 550 600 650 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 14 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!