Question 4.6 follows: The monthly sales for Yazici Batteries, Inc., were as MONTH January February March April May June July August September October November December SALES 20 21 15 14 13 16 17 a) Plot the monthly sales data. b) Forecast January sales using each of the following: i) Naive method. ii) A 3-month moving average. iii) A 6-month weighted average using .1..1..1..2, 2, and.3, with the heaviest weights applied to the most recent months. iv) Exponential smoothing using an a = 3 and a September forecast of 18. v) A trend projection. e) With the data given, which method would allow you to fore- cast next March's sales? PX 18 20 20 21 23

TWJODQ The Asker · Management

Transcribed Image Text: 4.6 follows: The monthly sales for Yazici Batteries, Inc., were as MONTH January February March April May June July August September October November December SALES 20 21 15 14 13 16 17 a) Plot the monthly sales data. b) Forecast January sales using each of the following: i) Naive method. ii) A 3-month moving average. iii) A 6-month weighted average using .1..1..1..2, 2, and.3, with the heaviest weights applied to the most recent months. iv) Exponential smoothing using an a = 3 and a September forecast of 18. v) A trend projection. e) With the data given, which method would allow you to fore- cast next March's sales? PX 18 20 20 21 23
More
Transcribed Image Text: 4.6 follows: The monthly sales for Yazici Batteries, Inc., were as MONTH January February March April May June July August September October November December SALES 20 21 15 14 13 16 17 a) Plot the monthly sales data. b) Forecast January sales using each of the following: i) Naive method. ii) A 3-month moving average. iii) A 6-month weighted average using .1..1..1..2, 2, and.3, with the heaviest weights applied to the most recent months. iv) Exponential smoothing using an a = 3 and a September forecast of 18. v) A trend projection. e) With the data given, which method would allow you to fore- cast next March's sales? PX 18 20 20 21 23
Community Answer
ZTTZV2

PLEASE PLEASE LIKE THIS ANSWER PLEASE I  REALLY APPRECIATE YOUR SUPPORT. a. Plot the monthly sales data Sales b. 1. Projection for January using Nau00efve method: In Nau00efve method, the value for the following month is simply that of the most recent month So projection for January = Sales of December = 23 2. 3 month moving average Forecast for January = (Actual of Oct + Actual of Nov + Actual of Dec)/3 = (20+21+23)/3 = 21.33 3. 6 month moving average Forecast for January = 0.1*July actuals + 0.1*Aug actuals + 0.1*Sep actuals + 0.2*Oct actuals + 0.2*Nov actuals + 0.3* Dec actuals                                   ... See the full answer