b) The table below shows the order (RM000) received by a pharmaceutical company in the first...

 

Transcribed Image Text:

b) The table below shows the order (RM000) received by a pharmaceutical company in the first 16 weeks of 2020. Week 1 2 3 Jan 250 218 210 255 4 Feb 250 230 Month March 267 250 245 325 April 300 225 300 (All the answers MUST correct to TWO decimal places) i) Compute the trend values using the moving average method. ii) Determine the seasonal indices for each week. iii) Explain the meaning of the seasonal index for the 2nd week. iv) Forecast the order (RM'000) for the third week of June 2020. 298 306 350 (5 marks) (6 marks) (1 mark) (3 marks) b) The table below shows the order (RM000) received by a pharmaceutical company in the first 16 weeks of 2020. Week 1 2 3 Jan 250 218 210 255 4 Feb 250 230 Month March 267 250 245 325 April 300 225 300 (All the answers MUST correct to TWO decimal places) i) Compute the trend values using the moving average method. ii) Determine the seasonal indices for each week. iii) Explain the meaning of the seasonal index for the 2nd week. iv) Forecast the order (RM'000) for the third week of June 2020. 298 306 350 (5 marks) (6 marks) (1 mark) (3 marks)

Answer rating: 100% (QA)

Compute the trend values using the moving average method The trend values are as follows Week 1 250 ... View the full answer