1

ECON 6313-001

Fall Semester, 2012
Exam 2

Professor C. Brown

The data (in Excel format)you will need to complete this examination can be found at

Answer all questions. The Exam is due on Wednesday, October24.

  1. This question is worth 35 points—3 points each, except for subparts (a) and (j), which are worth 5 ½ points each. You will need to download data for question 1 from the course web page (see URL above) to complete this question.This file contains 188monthly observations (January 1997 to August 2012) on the following variables:
    Appliances:Sales of new major appliances in the U.S.(seasonally-adjusted, in millionsof dollars).

HS: Monthly Housing Starts (seasonally-adjusted, in thousands of units).
RCO: Revolving consumer credit outstanding (end of the month, seasonally-adjusted, in billions of dollars)

UR: Unemployment rate, civilian labor force, in the U.S. (in percent).

a)Use regression to estimate the following model specification. Report the results of the regression—that is, report your estimates of β0,β1 , β2, and β3.
[1]

b)Are the signs of the (estimated) coefficients consistent with your (prior) expectations? Explain.

c)Monthly housing starts (HS) fell from a peak of 111,400 in March 2007 to 22,700 in January 2009. What was the effect on appliance sales (Appliances), other things being equal, according to your estimates?

d)Recent reports indicate that credit card issuers are applying tougher credit standards on the issue of credit card (revolving) accounts. Is this a welcome development from the point of view of appliance manufacturers and retailers? Explain.

e)Report the t-statistic for the estimate of the UR() parameter. Set up a null and alternative hypothesis for this coefficient. Can you reject the null hypothesis at the .01 (1 percent) significance level? Briefly Explain.

f)Use the equation you estimated above to obtain a fitted value of Appliancesfor September 2001. Is the actual value of Appliances for this month within one standard error of its fitted value for this month? Explain.

g)Prepare a chart illustrating actual and fitted values of Appliancesfor the period May1997 to August 2012.

h)Report the value of R2 and provide a (precise) interpretation.

i)Set up an F-test. Can you reject null hypothesis at the 1 percent (.01)significance level?

j)Use the data contained in “sheet 2” of your spreadsheet to forecast the value of appliance sales November and December2012. Report your results.

  1. This question is worth 35 points—3 points for each part except for subparts (e) and (j), which are worth 5 ½ points each. You will need to download data for question 2 from the website (see URL above) to complete this question. You have 140 monthly values of retail sales of books (Books) in the U.S. beginning in January 2001 and running through August 2012(in millions of dollars, not seasonally adjusted).

a)Forecastretail book sales forOctober 2012using a 4-month prior moving average technique.

b)Compute root mean square error () for the in-sample forecast using the same technique as in part (a) above.

c)Find the 3-decimal point smoothing constant () which gives the best fit for (based on the criterion) for the in-sample forecast usingthe exponential smoothing technique. (Note: the “damping factor” in Excel is equal to).

d)How does for the exponential smoothing technique compare to its value for the 4-period moving average technique?

e)Forecast retail book sales in September 2012 using the exponential smoothing technique (using the smoothing constant you found in part (c)).

f)Estimate and report a linear trend component for theBooks time series using the ordinary least squares (OLS) technique.

g)Compare the trend value of your series for August 2007 with its actual value in that month. What factors might account for the difference between the trend value and the actual value of Books for February 2007?

h)Compute a seasonal index using a 12 month centered moving average of the Booksseries. What are the best months in thebook retailingindustry? What are the worst months?

i)Do an in-sample forecast onBookssales using the multiplicative time series technique (assume the cyclical component is equal to 1 for every month).

j)Use the information contained in following table to perform a forecast of Books for November and December 2012using the multiplicative time series technique (Note: you will need to compute a trend component for these months using the equation you obtained in part (f)).

Month / Trend
Component / Seasonal
Component / Cyclical
Component / Forecast
(in millions of US$)
Nov-12 / ? / Use Nov-11 value / 0.997
Dec-12 / ? / Use Dec-11 value / 1.006
  1. Question 3 is based on the figure below. This question is worth 15 points.

a)When price is $15 and quantity demanded is 1,000, what is the point elasticity of demand?

b)What is the equation for marginal revenue?

c)When quantity demanded is 1,000, what is marginal revenue?

d)When price is $10 and quantity demanded is 2,000, what is the point elasticity of demand?

e)When quantity demanded is 2,000, what is marginal revenue?

f)When price is $5 and quantity demanded is 3,000, what is the point elasticity of demand?

g)When quantity demanded is 3,000, what is marginal revenue?

  1. This question is worth 15 points. Henry Goot is the owner of Discount Books, a bookseller housed in large warehouse. Sales have been growing rapidly since he opened his shop (in much smaller quarters) 4 years ago. Goot has been tracking sales and has observed that compound growth has been 25% a year since opening. At year’s end, gross sales have totaled about $1,250,000.

a)Assuming that demand continues to grow at this rate, what will be gross sales in the next three years?

b) Goot has observed that he needs to rent 1,000 square feet of warehouse space in order to stock sufficiently to sell $100,000 gross sales in a year. He can sign a long-term lease to rent space adjacent to his current space (of 17,000 square feet) and wants to do so in order to prevent overcrowding of the store. When should he arrange to have the space available for stocking books?

c) How reliable is the forecast for the next three years of sales? Explain. Do you see any weaknesses in the forecast?

[1]HS t – 4 means a 4-month lag of housing starts.