Helen Troy, owner of three Sound Haus stereo equipment stores, is deciding what message channel (advertising medium) to use to promote her newest store. Her current promotion blend includes direct-mail ads that are effective for reaching her current customers. She also has knowledgeable salespeople who work well with consumers once they're in the store. However, a key objective in opening a new store is to attract new customers. Her best prospects are professionals in the 25-44 age range with incomes over $38,000 a year. But only some of the people in this group are audiophiles who want the top-of-the-line brands she carries. Troy has decided to use local advertising to reach new customers. Troy narrowed her choice to two advertising media: Pandora, a music streaming service that offers localized advertising services, and a biweekly magazine that focuses on entertainment in her city. Many of the magazine's readers are out-of-town visitors interested in concerts, plays, and restaurants. They usually buy stereo equipment at home. But the magazine's audience research shows that many local professionals do subscribe to the magazine. Troy doesn't think that the objective can be achieved with a single ad. However, she believes that ads in six issues will generate good local awareness with her target market. In addition, the magazine's color format will let he present the prestige image she wants to convey in an ad. She thinks that will help convert aware prospects to buyers. Specialists at a local advertising agency will prepare a high- impact ad for $2,000, and then Troy will pay for the magazine space Pandora can target an audience similar to Troy's own target market. She knows repeated ads will be needed to be sure that most of her target audience is exposed to her ads. Troy thinks it will take daily ads for several months to create adequate awareness among her target market. Pandora will provide an announcer and prepare a recording of Troy's ad for a one-time fee of $200. All she has to do is tell them what the message content for the ad should say. Both Pandora and the magazine gave Troy reports summarizing recent audience research. She decides that comparing the two media in a spreadsheet will help her make a better decision. Spreadsheet The spreadsheet values outlined in yellow can be changed in order to determine possible outcomes. You can find the initial values in the corresponding blue cells in columns E and F. Start by entering the initial values into columns B and C. Then review the questions below and adjust the values in columns B and C to determine the correct answers. Pandora Magazine Total Audience Size (People) Number of "Prospects" in Audience Preparation Cost for Ad 7 2.000.00 10 Insertions Needed to Achieve Objective 11 Total Cost for All Ads 13 Cost per Aware Prospect 14 %Of Aware who iNWBuy 15 Likely Number of Buyers 6 Cest per Bue 1368 Helen Troy, owner of three Sound Haus stereo equipment stores, is deciding what message channel (advertising medium) to use to promote her newest store. Her current promotion blend includes direct-mail ads that are effective for reaching her current customers. She also has knowledgeable salespeople who work well with consumers once they're in the store. However, a key objective in opening a new store is to attract new customers. Her best prospects are professionals in the 25-44 age range with incomes over $38,000 a year. But only some of the people in this group are audiophiles who want the top-of-the-line brands she carries. Troy has decided to use local advertising to reach new customers. Troy narrowed her choice to two advertising media: Pandora, a music streaming service that offers localized advertising services, and a biweekly magazine that focuses on entertainment in her city. Many of the magazine's readers are out-of-town visitors interested in concerts, plays, and restaurants. They usually buy stereo equipment at home. But the magazine's audience research shows that many local professionals do subscribe to the magazine. Troy doesn't think that the objective can be achieved with a single ad. However, she believes that ads in six issues will generate good local awareness with her target market. In addition, the magazine's color format will let he present the prestige image she wants to convey in an ad. She thinks that will help convert aware prospects to buyers. Specialists at a local advertising agency will prepare a high- impact ad for $2,000, and then Troy will pay for the magazine space Pandora can target an audience similar to Troy's own target market. She knows repeated ads will be needed to be sure that most of her target audience is exposed to her ads. Troy thinks it will take daily ads for several months to create adequate awareness among her target market. Pandora will provide an announcer and prepare a recording of Troy's ad for a one-time fee of $200. All she has to do is tell them what the message content for the ad should say. Both Pandora and the magazine gave Troy reports summarizing recent audience research. She decides that comparing the two media in a spreadsheet will help her make a better decision. Spreadsheet The spreadsheet values outlined in yellow can be changed in order to determine possible outcomes. You can find the initial values in the corresponding blue cells in columns E and F. Start by entering the initial values into columns B and C. Then review the questions below and adjust the values in columns B and C to determine the correct answers. Pandora Magazine Total Audience Size (People) Number of "Prospects" in Audience Preparation Cost for Ad 7 2.000.00 10 Insertions Needed to Achieve Objective 11 Total Cost for All Ads 13 Cost per Aware Prospect 14 %Of Aware who iNWBuy 15 Likely Number of Buyers 6 Cest per Bue 1368