Forecasting: The sales datafor the lone star Sports Apparel Company for the last 12 years are as follows:
2001 $400,000
2002 440,000
2003 480,000
2004 518,000
2005 554,000
2006 587,000
2007 617,000
2008 654,000
2009 700,000
2010 756,000
2011 824,000
2012 906,000
Questions:
a. What is the 2001- 2012 compound growth rate?
b. Using the result obtained in part a, what is your 2013 projections?
c. If you were to make your own projections, what would you forecast?
This solution solves a problem based on forecasting using the compound annual growth rate and linear regression. The solution is provided in an Excel document.