Using Excel:

A textbook publishing company has compiled data on total annual sales of its business texts for the preceding nine years: Year Sales (000): - 1 37.60 2 42.40 3 49.30 4 53.40 5 55.20 6 7 8 57.7060.80 69.20 9 74.70 a. Using a regression model, forecast textbook sales for each of the next five years using year as a factor. (Round your intermediate calculations to 3 decimal places and final answers to 2 decimal places.) 10 13 14 Year Forecast b. Compute +/- 2s control limits for the control chart for forecast errors using just data from the original nine periods. (Round your intermediate calculations to 4 decimal places and final answer to 2 decimal places.) Control limits are 0 c. Suppose actual sales for the next five years turn out as follows: Year Sales (000): 10 77.20 11 84.10 12 88.50 13 91.50 14 96.50 Is the forecast performing adequately? Yes O No