Problem 1: Here are the monthly sales for National Retail , Inc.
|
Month
|
Sales (000)
|
|
February
|
19
|
|
March
|
18
|
|
April
|
15
|
|
May
|
20
|
|
June
|
18
|
|
July
|
22
|
|
August
|
20
|
a. Forecast September sales as follows:
i. a 5-month moving average
ii. a weighted average using .6 for August, .9 July, and .1 for June
iii. exponential smoothing with a constant of .2, assuming a March forecast of 19(000).
Problem 2: Monthly sales for Telco Battery are as follows:
|
Month
|
Sales
|
|
August
|
18
|
|
September
|
20
|
|
October
|
20
|
|
November
|
21
|
|
December
|
23
|
a. Forecast January sales in the following:
i. 5-month moving average
ii. 4-month weighted average with December at .4 November at .3, October at .2, and September at .1.
iii. exponential smoothing with a constant of .3, and September forecast of 18.