Question: answer please You work as an operations manager for XYZ Berhad. You intend to use a variety of forecasting methods to forecast the company's sales

answer please answer please You work as an operations manager
answer please You work as an operations manager
You work as an operations manager for XYZ Berhad. You intend to use a variety of forecasting methods to forecast the company's sales for the budgeting plan. The data below represents actual three-quarter company sales (units) for 2020. Month Sales ('000) 165 170 January February March 130 120 April 170 May 270 Jun 150 125 July August September 130 a) Calculate the forecasted October 2020 sales and the Mean Absolute Deviation (MAD) using the following methods: a) Calculate the forecasted October 2020 sales and the Mean Absolute Deviation (MAD) using the following methods: i) 4-month weighted moving average with weights of 0.40, 0.30, 0.20, and 0.10 (most recent to oldest month). (3 marks) ii) Exponential smoothing with smoothing constant (a) = 0.30. Assume that May's 2020 forecast sales were 90,000 units. (5 marks) iii) Exponential smoothing with trend. Assume that the previous smoothed forecast (F) sales and the previous trend component (T) sales for May 2020 were 85,000 units and 5000 units, respectively. The alpha (a) = 0.3 and beta (B) = 0.2. (5 marks) b) which of the methods in (a) is the most reliable for forecasting your company's sales in October 2020 and why? (2 marks) TOTAL 15 MARKS 9:04 PM

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!