QUESTION 3 20 Marks The Redang Chalet would like to ensure the provided services for year 2020 is excellent. This includes on time services, food quality, perfect utilities and cleanliness. In order to ensure these factors can be fulfilled, the management team need has to estimate number of visitors for next year. According to Tourism agency, the visitors for year 2020 will be increased about 30% to 40%. The potential increasing is influenced by the campaign of visit Malaysia year 2020. It is estimated 20500 visitors will stay in Redang Chalet. Table 2 shows number of guest stayed here from 2017 to 2019. Table 2 The number of visitors from 2017 to 2019 Month April May June July August Sept 2017 1000 1500 1800 2000 2500 2000 2018 1100 1600 2500 1800 2700 1800 2019 1200 1700 2800 2500 3000 2500 a) Determine the seasonal index for each of the month. (8 Marks) b) Forecast the number of potential guess will stay in Redang Chalet in year 2020. (4 Marks) c) What are the main characteristics of accurate forecasts in this situation? (2 Marks) d) The sales department has appointed you to analyse and comment the errors of two forecasting method used by them. Table 3 shows the detail of information gained from past sales and forecasts. Justify your answer. (6 Marks) Table 3 Sales information January to June Moving average Month Jan Feb Mar Sales 120 140 160 190 Exponential smoothing 110 113 121.1 132.7 150 165 Apr May 200 140 163 183 June 210