Find whether advertising dollars are generating sales

Assignment Help Mechanical Engineering

Reference no: EM131173790

Pernavik Dairy produces and sells a wide range of dairy products. Because most of the dairy's costs and prices are set by a government regulatory board, most of the competition between the dairy and its competitors takes place through advertising. The controller of Pernavik has developed the sales and advertising levels for the last 52 weeks. These appear in the file P11_61.xlsx. Note that the advertising levels for the three weeks prior to week 1 are also listed. The controller wonders whether Pernavik is spending too much money on advertising. He argues that the company's contribution-margin ratio is about 10%. That is, 10% of each sales dollar goes toward covering fixed costs. This means that each advertising dollar has to generate at least $10 of sales or the advertising is not cost-effective. Use regression to determine whether advertising dollars are generating this type of sales response.

Reference no: EM131173790

Questions Cloud

Relationship between y and x for these data : Find a 95% confidence interval for the model's slope parameter (β1). What does this confidence interval tell you about the relationship between Y and X for these data?

Which variables in this equation have regression coefficient : Which of the variables in this equation have regression coefficients that are statistically different from zero at the 5% significance level?

Determine probable return on investment : BSBMKGSOIB: Determine probable return on investment and potential competitors and describe and rank marketing opportunities in terms of their viability and likely contnbutico to the business

Why might you be disappointed with the results : How well can you can predict overhead costs on the basis of these variables with a linear regression equation? Why might you be disappointed with the results?

Find whether advertising dollars are generating sales : This means that each advertising dollar has to generate at least $10 of sales or the advertising is not cost-effective. Use regression to determine whether advertising dollars are generating this type of sales response.

When should not one rely on standardized tests : What information you think the standardized test scores can provide? Do you think that it is valid to use student assessments to evaluate effectiveness of teaching? Give reasons in your answer.

Why the coefficient of labor hours is not significant : Run the regression for the first 36 months. Explain briefly why the coefficient of labor hours is not significant.

Discuss the examples of at risk students and online learners : What specific populations might struggle more with self regulation and how can you promote it? Discuss the examples of at risk students and online learners and how self regulation plays an important role in both.

Equation that can be used to predict annual sales of dolls : Determine an equation that can be used to predict annual sales of these dolls. Make sure that all variables in your equation are significant at the 10% level.

User Account

All Pages