117k views
3 votes
This exercise contains only parts b and c. b) Forecast January sales using each of the following methods. i) Compute the January sales forecast using naive method. The January sales forecast using the naive method= 24 sales. (Enter your response as a whole number.) ii) Compute the January sales forecast using a 3-month moving average. The January sales forecast using a 3-month moving average approach = 22 sales. (Round your response to two decimal places.) iii) Compute the January sales forecast using a 3-month weighted average with weights of 0.10, 0.30, and 0.60 with the heaviest weights applied to the most recent months. The January sales forecast using a 3-month weighted average = 23.10 sales. (Round your response to two decimal places.) iv) Compute the January sales forecast using exponential smoothing with α = 0.30 and a starting forecast for September being 19. The January sales forecast using exponential smoothing= 21.42 sales. (Round your response to two decimal places.) v) Compute the January sales forecast using a trend projection. Using a method of trend projection, the forecast for January sales = 25.50 sales. (Round your response to two decimal places.) c) The method that can be used for making a forecast for the month of March is a trend projection

1 Answer

1 vote

The forecast for January sales is as follows:i) Compute the January sales forecast using naive method. The January sales forecast using the naive method = 24 sales. (Enter your response as a whole number.)ii) Compute the January sales forecast using a 3-month moving average. The January sales forecast using a 3-month moving average approach = 22 sales. (Round your response to two decimal places.)iii) Compute the January sales forecast using a 3-month weighted average with weights of 0.10, 0.30, and 0.60 with the heaviest weights applied to the most recent months. The January sales forecast using a 3-month weighted average = 23.10 sales. (Round your response to two decimal places.)iv) Compute the January sales forecast using exponential smoothing with α = 0.30 and a starting forecast for September being 19. The January sales forecast using exponential smoothing = 21.42 sales. (Round your response to two decimal places.)v) Compute the January sales forecast using a trend projection. Using a method of trend projection, the forecast for January sales = 25.50 sales. (Round your response to two decimal places.)Therefore, the value of January sales forecast using Naive method is 24 sales, while the forecast for January sales using a 3-month moving average approach is 22 sales. The value of January sales forecast using a 3-month weighted average is 23.10 sales. The value of January sales forecast using exponential smoothing with α = 0.30 is 21.42 sales. Finally, the forecast for January sales using the trend projection method is 25.50 sales.As for part c of the question, the method that can be used for making a forecast for the month of March is trend projection.

User Npgall
by
8.6k points