Aggregate price indexes
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 datafor 2003 and 2006 and quantities sold in cases for 2003 follow.
Item 2003 quantity cases Unit prices
Beer 35,000 16.25 17.50
Wine 5,000 64.00 100.00
Soft drink 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.
The mediansales prices for new single-family houses for the years 1998-2001are as follows (Statistical abstract of the United States, 2002)
Year Price ($1000s)
a) Use 1998 as the base year and develop a price index for new single-family homes over this four-year period
b) Use 1999 as the base year and develop a price index for new single- family homes over this four year period
The following table reports the percentage of stocks in a typical portfolio in nine quarters from 2005 and 2007
Quarter Stocks %
A) Use exponential smoothing to forecast this time series. Consider smoothing constants of a=.2, .3and.4. What value of the smoothing constant provides the best forecast?
B) What is the forecast of the percentage of stocks in a typical portfolio for the second quarter of 2007?
The following five years of data show the average minimum balance to avoid fees for checking accounts that pay interest (USA Today, December 6, 2005
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
A) GRAPH THIS TIME SERIES. Dose A linear trend appear to be present?
B) Develop the equation for the linear trend component for the time series.
C) Use the trend equation to forecast the minimum average balance to avoid account fees for Spring 2006
Please see the attachments.
Please note that this is not a hand in …
The solution provides a step by step method for the calculation of index numbers and time series analysis. Formula for the calculation and Interpretations of the results are also included.