Page 1 of 1
QUESTION 3 [TOTAL MARKS: 25] A company has replaced a production machine and they want to forecast with seasonal adjustm
Posted: Sun Oct 03, 2021 11:06 am
by answerhappygod
- Question 3 Total Marks 25 A Company Has Replaced A Production Machine And They Want To Forecast With Seasonal Adjustm 1 (88.3 KiB) Viewed 45 times
QUESTION 3 [TOTAL MARKS: 25] A
company has replaced a production machine and they want to forecast with seasonal adjustments the production levels that might be required in the future based on historic data as presented in the table below. With your help they can decide if another production machine is required to meet forecasted demands. Production Levels per year 2019 (years) 2020 ( year 2) 2021 (year 3) Q1 Q2 Q3 Q4Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 900 1100 1300 800 1000 1200 1400 600 1100 1400 1600 400 You are required to: a) Calculate the moving average trend values for machine production. (7 marks) b) Calculate the seasonal variation values for each time point (8 marks) c) Adjust the data for seasonal variation (2 marks) d) Forecast production levels for 2022 Q1-Q4 (8 marks) [End of Question 3]