**PLEASE DON'T USE EXCEL TO SOLVE THIS**

45. A text book publishing company has complied data on total annual sales of its business texts for the preceding nine years: 15 Years: 1 2 3 4 5 6 7 8 9 Sales (000): 40.2 44.5 48.0 52.3 55.8 57.1 62.4 69.0 73.7 i) Using an appropriate model, forecast textbook sales for each of the next five years ii) Prepare a control chart for the forecast using the original data. Use 2s limits ili) Suppose actual sales for the next five years turn out as follows: Years: 10 11 Sales (000): 77.2 82.1 12 87.8 13 14 90.6 98.9 Is the forecast performing adequately? Explain