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

$1.00

Textbook Solution:

Solution Available in MS-Word File.

“Limited Time Offer”

-
+

Description

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 solution


Reviews

There are no reviews yet.

Be the first to review “The monthly sales for Telco Batteries, Inc., were as follows: (a) Plot the monthly sales data”

Your email address will not be published. Required fields are marked *