The following sales figures have been recorded by NABANA Electric and Services on the demand for...

Transcribed Image Text:

The following sales figures have been recorded by NABANA Electric and Services on the demand for its washing machines for the last nine months of last year. Sales (units) Month April 320 May 190 June 150 July 200 August 220 September 170 October 410 November December 316 425 The company intends to develop a forecasting method for the demand of its products for the coming years. You are required to develop sales forecasts for the company for the last six months of the year by using the following methods: Hak Cipta Universiti Teknologi MARA CONFIDENTIAL a) b) CONFIDENTIAL BA/JAN 2018/OPM630 By using three-month weighted moving average, calculate the forecast by using. three-month weighted moving average of 0.70, 0.20 and 0.10 to reflect the forecasted months' figure. (10 marks) Calculate using the exponential smoothing with a constant, a = 0.5, where forecasted sales for June this year was 210 units. (10 markel The following sales figures have been recorded by NABANA Electric and Services on the demand for its washing machines for the last nine months of last year. Sales (units) Month April 320 May 190 June 150 July 200 August 220 September 170 October 410 November December 316 425 The company intends to develop a forecasting method for the demand of its products for the coming years. You are required to develop sales forecasts for the company for the last six months of the year by using the following methods: Hak Cipta Universiti Teknologi MARA CONFIDENTIAL a) b) CONFIDENTIAL BA/JAN 2018/OPM630 By using three-month weighted moving average, calculate the forecast by using. three-month weighted moving average of 0.70, 0.20 and 0.10 to reflect the forecasted months' figure. (10 marks) Calculate using the exponential smoothing with a constant, a = 0.5, where forecasted sales for June this year was 210 units. (10 markel