Anna Martinez, the financial manager at the Casa Real restaurant - 74802

Solution Posted by
yousafbhutta

yousafbhutta

Rating : (28)C
Solution Detail
Price: $5.00
  • From: Business,
  • Posted on: Wed 17 Sep, 2014
  • Request id: None
  • Purchased: 0 time(s)
  • Average Rating: No rating
Request Description

10-33 High-low method; regression analysis. (CIMA, adapted) Anna Martinez, the financial manager at the Casa Real restaurant, is checking to see if there is any relationship between newspaper advertising and sales revenues at the restaurant. She obtains the following data for the past 10 months:
Month Revenues Advertising Costs
March $50,000 $2,000
April 70,000 3,000
May 55,000 1,500
June 65,000 3,500
July 55,000 1,000
August 65,000 2,000
September 45,000 1,500
October 80,000 4,000
November 55,000 2,500
December 60,000 2,500
She estimates the following regression equation:
Monthly revenues = $39,502 + ($8.723 * Advertising costs)
1. Plot the relationship between advertising costs and revenues. Required
2. Draw the regression line and evaluate it using the criteria of economic plausibility, goodness of fit, and
slope of the regression line.
3. Use the high-low method to compute the function, relating advertising costs and revenues.
4. Using (a) the regression equation and (b) the high-low equation, what is the increase in revenues for
each $1,000 spent on advertising within the relevant range? Which method should Martinez use to predict
the effect of advertising costs on revenues? Explain briefly.

Solution Description

Anna Martin

Attachments
10-33 solution.xlsx
10-33 solution....