Question # One

v Based on the following data for the past 10 months, the operation manager of the company wants to be certain that enough cars are available to deliver orders.

Month

Jan.

Feb.

Mar.

Apr.

May.

Jun.

Jul.

Aug.

Sep.

Oct.

Orders

120

90

100

75

110

50

75

130

110

90

1.Plot the above data

2.Compute the demand forecast for Aug. through Oct using a three - month weighted moving average. Use weights of 0.5, 0.17.and 0.33, with the heavier weights on the more recent months.

3.Compute the demand forecast for Aug. through Oct using a three - month weighted moving average. Use three month moving average

4.Which Method is much better? Why

5.Given TS 2by using 2MA method? Do you agree or disagree to use it next time? Why

6.Which Methods can be used to Forecast November car sales ?

7.Explain.R between the Car Sales and the advertising fees is .80