Question
COST ESTIMATION--High- low method; regression analysis Anna Schaub, the financial manager at the Mangiamo restaurant, is checking to see if there is any relationship between
COST ESTIMATION--High- low method; regression analysis
Anna Schaub, the financial manager at the Mangiamo 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 | $51,000 | $1,500 |
April | 72,000 | 3,500 |
May | 56,000 | 1,000 |
June | 64,000 | 4,000 |
July | 56,000 | 500 |
August | 64,000 | 1,500 |
September | 43,000 | 1,000 |
October | 83,000 | 4,500 |
November | 56,000 | 2,000 |
December | 61,000 | 2,000 |
She estimates the following regression equation:
Monthly revenues = $46,443 + ($6.584 * Advertising costs)
REQUIREMENTS:
1. OPTIONAL: Plot the relationship between advertising costs and revenues. Also draw the regression line and evaluate it using the criteria of economic plausibility, goodness of fit, and slope of the regression line.
2. Use the high-low method to compute the function relating advertising costs and revenues.
3. Should Anna use the regression or the high-low cost estimation method for the restaurant? Explain your response.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started