A logistics company has been in business for four years and wants to develop monthly indices. Inventory monthly quantities for these years are as follows:

Month	Year 1 (000s)	Year 2 (000s)	Year 3 (000s)	Year 4 (000s)
January	82	82	82	82
February	70	78	84	89
March	85	90	82	77
April	91	90	90	88
May	90	90	123	119
June	89	120	99	99
July	100	99	78	89
August	89	103	93	100
September	86	92	120	86
October	80	84	78	84
November	75	83	99	80
December	78	82	100	82

1. Develop a monthly index. (7 marks)

Estimate Year 5 forecasts for April, July and December if the annual quantity for Year 5 is 1,500,000.