Question: A textbook publishing company has compiled data on total annual sales of its business texts for the preceding nine years: table [ [ Year

A textbook publishing company has compiled data on total annual sales of its business texts for the preceding nine years:
\table[[Year,,1,2,3,4,5,6,7,8,9],[Sales (000):,38.40,44.50,48.00,53.40,56.20,57.10,62.80,68.10,74.80,]]
Click here for the Excel Data File
a. Using an appropriate model, forecast textbook sales fr each of the next five years. (Round your intermediate calculations to 3 decimal places and final answers to 2 decimal places.)
\table[[Year,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
0+-
c. Suppose actual sales for the next five years turn out as follows:
\table[[Year,10,11,12,13,14],[Sales (000):,78.40,82.00,87.00,92.10,96.60]]
Is the forecast performing adequately?
 A textbook publishing company has compiled data on total annual sales

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!