The Sales and Advertising Data (2009)

Kramer Smith Case

Kramer Smith owns a dry-cleaning service and is thinking about changing his advertising expenditures for the year. He hires you as a consultant to determine the relationship between sales, consumer incomes, and advertising by means of multiple regression analysis.Smith has gathered the sales, income, and advertising data for the last year, as shown in Table 1.

Click here to view Table 1.

Create a report answering the following questions:

• Construct a scatter graph showing the advertising and sales relationship over the last twelve months.

• Using multiple regressions, conduct an analysis of the firm’s sales revenue, consumer incomes, and advertising.

• Describe how you would explain your results to Smith and what recommendations you would suggest.

• Summarize your recommendations or advice to Smith concerning the relationship between sales, income, and advertising.

Create your report in a 2- to 3-page Microsoft Word document.