A. Below is the average increase in college tuition over the last 10 years. Using 2001 as the base year, calculate the relative indexes:

(Copy into Excel)

Item	Price $(1,000)	Relative Index
2001	57.900
2002	59.908
2003	64.669
2004	70.831
2005	79.623
2006	90.323
2007	99.723
2008	109.938
2009	119.923
2010	123.631

B. Below is the monthly sales revenue in dollars in toliet paper sells. Using = .05 and exponential smoothing, calculate from 2001 to 2010, plus month 2011's revenue.

(Copy into Excel)

Index	$(000)	Exponent.
2001	57	57.00 example
2002	60	57.00 example
2003	65
2004	71
2005	79
2006	90
2007	99
2008	110
2009	119
2010	124
2011