The Costello Music Company has been in business five years. During that time, its sales of electric organs has grown from 12 units to 76 units per year. Fred Costello, the firm's owner, wants to forecast next year's organ sales. The historical data follow.

a. Construct a chart for this time series on a spreadsheet. 

b. What forecasting method do you recommend and why? Use appropriate Excel templates and tools to justify your recommendation.

c. Use your recommendation to obtain a forecast for Years 6 and 7.

Transcribed Image Text:

Year 1 Sales 12 2 28 3 34 4 50 5 76