Case Analysis, Marketing Analysis

Complete the following three marketing analytics problems addressing demand versus pricing and regression analyses.

1. The file Oreos.xlsx gives daily sales of Oreos at a supermarket and whether Oreos were placed 7” from the floor, 6” from the floor, or 5” from the floor. How does shelf position influence Oreo sales?

2. The file Printers.xlsx contains daily sales volume (in dollars) of laser printers, printer cartridges, and school supplies. Find and interpret the correlations between these quantities.

3. You want to determine the correct price for a new weekly magazine. The variable cost of printing and distributing a copy of the magazine is $0.50. You are thinking of charging from $0.50 through $1.30 per copy. The estimated weekly sales of the magazine are shown in the following table. What price should you charge for the magazine?
Price Demand (in Millions)
$0.50        2
$0.90        1.2Complete the following three marketing analytics problems addressing demand versus pricing and regression analyses.

1. The file Oreos.xlsx gives daily sales of Oreos at a supermarket and whether Oreos were placed 7” from the floor, 6” from the floor, or 5” from the floor. How does shelf position influence Oreo sales?

2. The file Printers.xlsx contains daily sales volume (in dollars) of laser printers, printer cartridges, and school supplies. Find and interpret the correlations between these quantities.

3. You want to determine the correct price for a new weekly magazine. The variable cost of printing and distributing a copy of the magazine is $0.50. You are thinking of charging from $0.50 through $1.30 per copy. The estimated weekly sales of the magazine are shown in the following table. What price should you charge for the magazine?
Price Demand (in Millions)
$0.50        2
$0.90        1.2