The data below relates the production of items in a certain factory for a period of 10 months.
|
Month
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
|
Quantity[000]
|
30
|
28
|
36
|
40
|
34
|
48
|
54
|
58
|
56
|
66
|
Required-
A] Compute the linear trend equation using the method of least squares.
B] Compute the trend values of each month using the trend line equation.
C] Compute the monthly demand forecast for 4th month through 11th month using a simple 3-month moving average.
D] Compute the monthly demand forecast for4th month through 11th month using a 3-month weighted moving average. Use weights of 0.6, 0.3, and 0.1.
E] Compute the monthly demand forecast for 4th month through 11th month using a simple 3-month moving average.