The monthly sales for Telco Batteries, Inc., were as follows: (a) Plot the monthly sales data

QUESTION:

The monthly sales for Telco Batteries, Inc., were as follows:

Month                                               Sales

January…..…………………………..20

February ……………………….……21

March… ……………………….…….15

April…………………………………..14

May………………………….………..13

June…………………………….…….16

July …………………………………..17

August……………………………….18

September…………………………20

October……………………….…….20

November………………………..…21

December…………………….……..23

(a) Plot the monthly sales data.

(b) Forecast January sales using each of the following:

(i) Naïve 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 α = .3 and a September forecast of 18.

(v) A trend projection.

(c) With the data given, which method would allow you to forecast next March’s sales?


You must be registered and logged in to an account to download the solution

Purchase
 

That is so great to hear. We really try our best to provide you the quality content. And thank you so much for taking the time to provide your feedback. AnsTutors.com Help-Desk!


 
0 / 5

Your page rank: