Jennifer, the financial manager at Palm Beach restaurant believe that advertising expenses has a good relationship...

 

Transcribed Image Text:

Jennifer, the financial manager at Palm Beach restaurant believe that advertising expenses has a good relationship with the revenue. Therefore she is intended to use the advertising expenses to estimate the sales revenues and the profit of the restaurant. She obtains the following data for the past 9 months: Month Revenues Advertising expenses April $120 000 $52 000 May 270 000 65 000 June 320 000 80 000 July 480 000 90 000 August 430 000 100 000 September 450 000 110 000 October 540 000 120 000 November 670 000 180 000 December 780 000 195 000 She estimates the following regression equation: Monthly revenues = $15 825+ ($3.95 x Advertising expenses) Required: 1. Use the high-low method to calculate the function, relating advertising costs and revenues 2. If Jennifer add advertising expenses $10 000, calculate the additional profit is expected by assuming that other expenses (consider variable costs) is 50% from revenue using: a) the regression equation b) the high-low equation 3. Which method should Jennifer use to predict the effect of advertising costs on revenues? Explain briefly Jennifer, the financial manager at Palm Beach restaurant believe that advertising expenses has a good relationship with the revenue. Therefore she is intended to use the advertising expenses to estimate the sales revenues and the profit of the restaurant. She obtains the following data for the past 9 months: Month Revenues Advertising expenses April $120 000 $52 000 May 270 000 65 000 June 320 000 80 000 July 480 000 90 000 August 430 000 100 000 September 450 000 110 000 October 540 000 120 000 November 670 000 180 000 December 780 000 195 000 She estimates the following regression equation: Monthly revenues = $15 825+ ($3.95 x Advertising expenses) Required: 1. Use the high-low method to calculate the function, relating advertising costs and revenues 2. If Jennifer add advertising expenses $10 000, calculate the additional profit is expected by assuming that other expenses (consider variable costs) is 50% from revenue using: a) the regression equation b) the high-low equation 3. Which method should Jennifer use to predict the effect of advertising costs on revenues? Explain briefly

Answer rating: 100% (QA)

Low point S2000 a high Point 195000 COST eller 780ooo Revenge 120000 62... View the full answer