Question: A textbook publishing company has compiled data on total annual sales of its business textbooks for the preceding eight years: Year: Sales (000): 1 1

A textbook publishing company has compiled dataA textbook publishing company has compiled data

A textbook publishing company has compiled data on total annual sales of its business textbooks for the preceding eight years: Year: Sales (000): 1 1 38.10 2 43.70 3 3 49.20 4 51.90 5 55.30 6 58.10 7 62.50 8 69.50 a-1. Select the correct data chart and fit an appropriate model to it. Chart A Chart B Chart C y = 4.094x + 35.114 y = 4.058x + 35.150 y = 4.062x + 34.771 75.0 75.0 70.0 70.0 65.0 75.0 70.0 65.0 60.0 65.0 60.0 55.0 60.0 55.0 50.0 55.0 50.0 45.0 50.0 45.0 45.0 40.0 40.0 + 40.0 35.0 Sale Sales (000) ( Linear (Sales (000)) 35.0 -Sales (000) -Linear (Sales (000) 35.0 30.0 Line 30.0 30.0 + 1 2 3 4 5 6 7 8 1 2 3 4 5 6 7 8 1 2 3 4 5 5 6 (Click to select) a-2. Forecast the preceding eight years, and determine the forecast errors. (Negative answers should be indicated by a minus sign. Do not round intermediate calculations and round your final answer to 2 decimal places.) Forecast Error Error2 Year Sales (000) 1 38.10 2 43.70 3 49.20 4 51.90 5 55.30 6 58.10 7 62.50 8 8 69.50 a-2. Forecast the preceding eight years, and determine the forecast errors. (Negative answers should be indicated by a minus sign. Do not round intermediate calculations and round your final answer to 2 decimal places.) Forecast Error Error2 Year Sales (000) 1 38.10 2 43.70 3 49.20 4 4 51.90 5 55.30 6 58.10 62.50 7 8 8 69.50 a-3. Construct 2s control limits. (Round the final answer to 2 decimal places.) 2s control limits are + 1 b. Using the model, forecast textbook sales for each of the next five years. (Round the final answers to 1 decimal place.) Forecast Error Year Sales (000) 9 74.70 10 79.10 11 82.40 12 87.10 13 92.10 c. Suppose actual sales for the next five years turn out as follows: Year: Sales (000): 9 9 74.70 10 11 79.10 82.40 12 87.10 13 92.10 Calculate the forecast errors for years 9 to 13. Is the forecasting process in control? (Click to select)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!