Complete #4 (p. 749).
R&B Beverages, Inc., provides a complete line of beer, wine and soft drink products for distribution through retail outlets in central Iowa. Unit price data for 2003 and 2006 and quantities sold in cases for 2003 follow.

Unit Price($)
Items 2003 Quantity (Cases) 2003 2006
Beer 35,000 16.25 17.50
Wine 5,000 64.00 100.00
Soft Drinks 60,000 7.00 8.00

Compute a weighted aggregate index for the R&B Beverage sales in 2006, with 2003 as the base period.

#17 (p. 762).
The median sales prices for new single family house for the years 1998-2001 are as follows (Statistical Abstract of the United States, 2002).

Year Price ($1000s)
1998 152.5
1999 161.0
2000 169.0
2001 175.2
Complete #29 (p. 802)
The following table reports the percentage of stocks in a typical portfolio in nine quarters from 2005 to 2007.

Quarters Stock %
1st—2005 29.8
2nd –2005 31.0
3rd—2005 29.9
4th—2005 30.1
1st—2006 32.5
2nd—2006 31.5
3rd—2006 32.0
4th—2006 31.9
1st–2007 30.0

Use exponential smoothing to forecast this time series. Consider smoothing constants of a=.2, .3 and .4. What value of the smoothing constant provides the best forecast?
What is the forecast of the percentage of stocks in a typical portfolio for the second quarter of 2007?

#35 (p. 804).
The following five years of data show the average minimum balance to avoid fees for checking the accounts that pay interest (USA Today; December 6, 2005).

Date Balance($)
Spring 2000 1522.41
Fall 2000 1659.63
Spring 2001 1678.34
Fall 2001 1707.55
Spring 2002 1767.36
Fall 2002 1866.17
Spring 2003 2015.04
Fall 2003 2257.82
Spring 2004 2425.83
Fall 2004 2086.93
Spring 2005 2295.85
Fall 2005 2294.61

Graph this time series. Does a linear trend appear to be present?
Develop the equation for the linear trend component for the time series.
Use the trend equation to forecast the minimum average balance to avoid account fees for Spring 2006