Reference no: EM13835745
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.