Question: A textbook publishing company has compiled data on total annual sales of its business textbooks for the preceding eight years: Year: 1 2 3 4

A textbook publishing company has compiled data on total annual sales of its business textbooks for the preceding eight years:
Year: 12345678
Sales(000): 37.6042.4049.3053.4055.2057.7060.8069.20
a-1. Select the correct data chart and fit an appropriate model to it.
Chart A Chart B Chart C
picture
picture
picture
(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.)
Year Sales(000) Forecast Error Error\Lambda 2
137.60
242.40
349.30
453.40
555.20
657.70
760.80
869.20
a-3. Construct 2s control limits.(Round the final answer to 2 decimal places.)
2s control limits are \pm
b. Using the model, forecast textbook sales for each of the next five years. (Round the final answers to 1 decimal place.)
Year Sales(000) Forecast Error
974.70
1077.20
1184.10
1288.50
1391.50
c. Suppose actual sales for the next five years turn out as follows:
Year: 910111213
Sales(000): 74.7077.2084.1088.5091.50
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!