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
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

9.4m questions

12.2m answers

Categories