QUESTION 2(22 Marks)

2.2 New car sales for a dealer in Cook County, Illinois, for the past year are shown in the following table,

along with monthly indexes (seasonal relatives), which are supplied to the dealer by the regional distributor.

Month Units sold

Jan 640

Feb 648

Mar 630

Apr 761

May 735

Jun 850

Jul 765

Aug 805

Sep 840

Oct 828

Nov 840

Dec 800

a) Capture this data in excel and plot the data. You should take a snapshot of the graph you created

and paste it into your assignment. [2 marks]

b) Does there seem to be a pattern? Explain. ]

c) What forecasting technique will you suggest for the above data? Justify your answer [ 3marks]

2.3 Give three practical scenarios where you will be required to use qualitative techniques and three

scenarios where you will be required to use quantitative techniques. [12 marks]