Marketing Analytics: Channel Sales and Profit Amazon Echo and Google Home are two of the market leaders in the rapidly growing digital personal assistant product category. Ophelia is a brand manager for a smaller consumer electronics firm that has been competing for market share with its digital personal assistant, the Russell. While the product has not yet achieved the widespread success of the market leaders, sales for the Russell have increased by an average of 40 percent per year in recent years. Ophelia's boss attributes the product's early success to his distribution strategy of making sure the Russell is readily available in wholesale clubs, department stores, discount stores, and specialty electronic stores. Traditionally, cooperative marketing funding has been split equally between the four distribution channels with each receiving $500,000 in support. Each of the four distributors pays a different price to the manufacturer based primarily on purchase volume and channel power. Ophelia has been evaluating the Russell's distribution strategy and thinks that there is room for improvement. She knows that if she is going to convince her boss to change his strategy, she is going to have to speak his language---marketing metrics. To help her with the evaluation, she gathers data from the Russell's last three years of sales. The goal of this activity is to understand how channel choice affects a firm's sales and profitability using sales and profitability data. Use the spreadsheet provided to help answer the questions that follow. The spreadsheet fields highlighted in yellow can be changed in order to determine possible outcomes. You can find the initial values in the corresponding blue cells in columns G to J. Start by entering the initial values into columns B to E. Then review the questions below and adjust the values in columns B to E to determine the correct answers, H A 1 B C D F G 1 Electronics Worone Department Ivalo Discounts Total Inicial Value Initial Vi Clubs Specialty Stores Discounters Warehouse Clubs Department Stores Stores 5 000 455 705 0 0.000 175,000 1000,000 05 OS OS 20.250.000 12.250.000 5 52.000.000 $ 05 05 05 OS 5 18,050,000 5,075,000 5 29 000 000 1250,000 5 1.250.000 5 1 250 000 $ 1.250.000 55.000.000 1.250.000 $ 1.250.000 5 1.250,000 Initial Electronk Specialty Stores 05 300 000 10 500 000 4 $0 $0 0 5 3,700.000 vanatto conts 1.250.000 Cooperative marketing 5 $0 500,000 $ 500.000 500.000 500.000 5,425,000 $ 21.250,000 5 9,050,000 $1.250.000) 5 (1.250.000) 51.250.000) 5.1.250,000) $ (5,000 000) $ (in fine in try! (infinity 8,650,000 $ 30% NAD Return on sales 4494 01 Na NON Call of quantity old NAN NON 0% 31% 14 39