Chapter 3 Homework 42 Problem 3-31 (Static) A textbook publishing company has compiled data on total annual sales of its business texts for the preceding nine years: Year Sales (0oo): 40.20 44.50 48.09 52.30 5580 57.10 62.40 69.00 73.70 points Click here for the Excel Data File cBook a. Using an appropriate model, forecast textbook sales for each of the next five years. (Round your intermediate calculations to 3 decimal places and final answers to 2 decimal places.) in References Your 10 11 12 13 14 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 c. Suppose actual sales for the next five years turn out as follows: Year 10 11 12 13 14 Sales (000): 77.20 82. 10 87.80 90.60 98.90 Is the forecast performing adequately? O Yos No