8. The monthly sales for Telco Batteries, Inc., were as follows: Month Sales D Jan Feb...

 

Transcribed Image Text:

8. The monthly sales for Telco Batteries, Inc., were as follows: Month Sales D Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec 20 21 15 12 15 16 17 19 20 20 23 22 This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method=sales (round your response to a whole number). The forecast for the next period (Jan) using a 3-month moving average approach = sales (round your response to two decimal places). The forecast for the next period (Jan) using a 6-month weighted average with weights of 0.10, 0.10, 0.10, 0.20, 0.20, and 0.30, where the heaviest weights are applied to the most recent month sales (round your response to one decimal place). Using exponential smoothing with a = 0.30 and a September forecast of 18.00, the forecast for the next period (Jan) = sales (round your response to two decimal places). Using a method of trend projection, the forecast for the next month (Jan) - 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 3-month moving average a 6-month weighted moving average exponential smoothing the naive method a trend projection Page 8 8. The monthly sales for Telco Batteries, Inc., were as follows: Month Sales D Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec 20 21 15 12 15 16 17 19 20 20 23 22 This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method=sales (round your response to a whole number). The forecast for the next period (Jan) using a 3-month moving average approach = sales (round your response to two decimal places). The forecast for the next period (Jan) using a 6-month weighted average with weights of 0.10, 0.10, 0.10, 0.20, 0.20, and 0.30, where the heaviest weights are applied to the most recent month sales (round your response to one decimal place). Using exponential smoothing with a = 0.30 and a September forecast of 18.00, the forecast for the next period (Jan) = sales (round your response to two decimal places). Using a method of trend projection, the forecast for the next month (Jan) - 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 3-month moving average a 6-month weighted moving average exponential smoothing the naive method a trend projection Page 8

Answer rating: 100% (QA)

b Forecast for JAN using naive method Actual Demand for December 22 F... View the full answer