A textbook publishing company has compiled data on total annual sales of its business texts for the preceding nine years: Sales (000): 2 4 5 6 40.20 44.50 48.00 52.30 55.80 37.10 62.40 69.00 73.70 oints Click here for the Excel Data File eBook 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.) 10 Print Year Forecast 12 13 14 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.) Controllimits are c. Suppose actual sales for the next five years turn out as follows: Sales (000): 77.20 22.10 87.80 1a 90.60 14 98.90 Is the forecast performing adequately? Yes O No A textbook publishing company has compiled data on total annual sales of its business texts for the preceding nine years: Sales (000): 2 4 5 6 40.20 44.50 48.00 52.30 55.80 37.10 62.40 69.00 73.70 oints Click here for the Excel Data File eBook 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.) 10 Print Year Forecast 12 13 14 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.) Controllimits are c. Suppose actual sales for the next five years turn out as follows: Sales (000): 77.20 22.10 87.80 1a 90.60 14 98.90 Is the forecast performing adequately? Yes O No