Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Utilise the data in the sheet titled Section 1 to answer the following questions: 1. Generate the following forecasts for the 101st week from the
Utilise the data in the sheet titled "Section 1" to answer the following questions:
1. Generate the following forecasts for the 101st week from the data provided:
a. Moving average (n=3) (worth 2 marks)
b. Moving average (n=8) (worth 2 marks)
c. Exponential Smoothing (a=0.3) (worth 2 marks)
d. Exponential Smoothing (a=0.8) (worth 2 marks)
e. Simple linear regression (worth 2 marks)
2. Which of the forecasts generated in (1) would be most appropriate for this supply
chain? Why?