MindTap Business Statistics for Ragsdale's Spreadsheet Modeling & Decision Analysis, 8th Edition, [Instant Access], 2 terms (12 months)
8th Edition
ISBN: 9781337274876
Author: Cliff Ragsdale
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year’s program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown:
Constraint
Television
Radio
Online
Audience per advertisement
100,000
18,000
40,000
Cost per advertisement
$2000
$300
$600
Maximum media usage
10
20
10
To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number of advertisements authorized. In addition, television should account for at least 10% of the total number of advertisements authorized.
If the promotional budget is limited to $18,200, how many commercial messages should be run on each medium to maximize total audience contact? What is the allocation of the budget among the three media?
Let
T = number of television spot advertisements
R = number of…
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are underway for this year's program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown:
Constraint
Television
Radio
Online
Audience per advertisement
110,000
17,000
30,000
Cost per advertisement
$2,500
$300
$500
Maximum media usage
10
23
10
To ensure a balanced use of advertising media, radio advertisements must not exceed 40% of the total number of advertisements authorized. In addition, television should account for at least 10% of the total number of advertisements authorized.
(a)
If the promotional budget is limited to $20,500, how many commercial messages should be run on each medium to maximize total audience contact? If your answer is zero enter “0”.
Advertisement Alternatives
No of commercialmessages
Television…
A cosmetic manufacturer wants to understand why users shop online versus in store, and how they might take better advantage of the online channel; the manufacturer wants to make improvements to the company’s website. The manufacturer also wants to find out why Nordstrom.com (a competitor’s website) appeals to cosmetic consumers versus other websites. The cosmetic manufacturer also wants to find ways to improve consumers’ in-store experience. Further, the manufacturer wants to produce a three (3) month sales forecast based on the data produced from the research.
Objectives:
Why users shop online versus in store
How to take advantage of the online channel
How to improve the company’s website
Why does Nordstrom.com (their competitor) appeal to cosmetic consumers versus other websites.
Ways to improve consumers’ in-store experience
Requireed: Produce fictitious findings, chart and dat analysis that relate back to the objectives.
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- Michael is the marketing executive of SHOPEE and he is planning to launch the 2.2.22 online SALE through price discounts, either 40% off or 20% off. He also learned that SHOPEE closest competitor LAZADA , is planning to promote also a 2.22.22 online SALE with price discounts , either 50% off or 30% off. If SHOPEE launches the 40% off, it will gain nothing. If LAZADA launches the 50% off or gain 8,000,000 if LAZADA launches the 30% off. If SHOPEE launches the 20% off, it will lose 2,000,000 if LAZADA launches the 50% off or lose 5,000,000 if LAZADA launches the 30% off. 1.Which strategy is dominated by SHOPEE depending on strategy of LAZADA? A. 50% OFF B. 40% OFF C. 20% OFF D. 30% OFF E. NONE 2.What should be the strategy of LAZADA? A. 50% OFF B. 40% OFF C. 30% OFF D. 20% OFFarrow_forwardThe Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Television Radio Online Audience per advertisement 150,000 17,000 35,000 Cost per advertisement $1,500 $250 $500 Maximum media usage 12 18 11 To ensure a balanced use of advertising media, radio advertisements must not exceed 45% of the total number of advertisements authorized. In addition, television should account for at least 10% of the total number of advertisements authorized. (a) If the promotional budget is limited to $24,000, how many commercial messages should be run on each medium to maximize total audience contact? If your answer is zero enter “0”. Advertisement Alternatives No of commercialmessages Television…arrow_forwardManagement of the Toys R4U Company needs to decide whether to introduce a certain new novelty toy for the upcoming Christmas season, after which it would be discontinued. The total cost required to produce and market this toy would be $500,000 plus $15 per toy produced. The company would receive revenue of $35 for each toy sold. Assuming that every unit of this toy that is produced is sold, write an expression for the profit in terms of the number produced and sold. Then find the break-even point that this number must exceed to make it worthwhile to introduce this toy. Now assume that the number that can be sold might be less than the number produced. Write an expression for the profit in terms of these two numbers. Formulate a spreadsheet that will give the profit in part b for any values of the two numbers. Write a mathematical expression for the constraint that the number produced should not exceed the number that can be sold.arrow_forward
- The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Television Radio Online Audience per advertisement 140,000 18,000 30,000 Cost per advertisement $1,500 $200 $550 Maximum media usage 15 19 12 To ensure a balanced use of advertising media, radio advertisements must not exceed 45% of the total number of advertisements authorized. In addition, television should account for at least 15% of the total number of advertisements authorized. (a) If the promotional budget is limited to $24,100, how many commercial messages should be run on each medium to maximize total audience contact? If your answer is zero enter "0". No of commercial Advertisement Alternatives messages Television Radio Online What is the allocation of the budget…arrow_forwardAndy’s Bicycle Company (ABC) has the hottest new product on the upscale toy market—boys’ and girls’ bikes in bright fashion colors, with oversize hubs and axles; shell design safety tires; strong padded frames; chrome-plated chains, brackets, and valves; and non-slip handlebars. Due to the seller’s market for high-quality toys for the newest baby boomers, ABC can sell all the bicycles it manufactures at the following prices: boys’ bikes, $220; girls’ bikes, $175. This is the price payable to ABC at its Orlando plant. The firm’s accountant, V. R. Dondeti, has determined that direct labor costs will be 45% of the price that ABC receives for the boys’ model and 40% of the price received for the girls’ model. Production costs, other than labor but excluding painting and packaging, are $44 per boys’ bicycle and $30 per girls’ bicycle. Painting and packaging are $20 per bike, regardless of model. The Orlando plant’s overall production capacity is 390 bicycles per day. Each boys’…arrow_forward48- The maximum number of sales that can occur in a given period to an individual or businesses that are willing to sell in a given market is known as: a. Product demand b. Market potential c. Market demand d. All the options are correctarrow_forward
- The owner of a retail store that specializes in school supplies plans to buy TV ad time during the broadcast of Wheel of Fortune, a game show that has a rating of 20. It reaches 15,000 people in the primary target audience and a 30-second spot costs $500. What is the cost per thousand (CPM) of the show? 1) $33 2) $133 3) $30 4) $23 5) $750 Dravinur Dnnarrow_forwardWhat will happen to profits if Harmark discontinues the Kites product line? The profits will drop by _______.arrow_forwardHayworth Corporation has Just segmented last year's income statement into its ten product lines. The chief executive officer (CEO) is curlous as to what effect dropping one of the product lines at the beginning of last year would have had on overall company profit. What is the best number for the CEO to look at to determine the effect of this elimination on the net operating income of the company as a whole? Multiple Choice the product line's sales dollars the product line's contribution margin the product line's segment margin the product line's segment mergin minus an allocated portion of common fixed expensesarrow_forward
- Please don't give image format and no chatgpt answerarrow_forwardRajan wanted a radio from Jacky's. It appears that Rajan is particularly interested in purchasing a Radio from the inexpensive retailer's sales manager for consumer electronics. He tells Jacky, the salesperson at the inexpensive store where he thinks he'll get the best deal, that his old radio died and he wants to listen to his favourite tunes. He wants a replacement radio as quickly as possible. In three and a half weeks, Rajan's favourite model will be 10% off.He suspects Rajan won't wait and will find another job. Jacky will earn less on the lowered price. He thinks that telling Rajan of the sale makes little sense.When Jacky tells Rajan that the radio set he wants is no longer available and won't be for another week, Rajan is enraged. Fearing losing the business, Jacky begs his sales manager, Michelle, to speed up delivery. Michelle says it's impossible and suggests Jacky tell Rajan the store can get the set in 24 hours and sell him the demo model. Michelle says the sample is new…arrow_forwardAs part of a campaign to promote its annual clearance sale, Excelsior Company decided to buy television advertising time on Station KAOS. Excelsior's television advertising budget is $111,000. Morning time costs $3000/min, afternoon time costs $1000/min, and evening (prime) time costs $12,000/min. Because of previous commitments, KAOS cannot offer Excelsior more than 6 min of prime time or more than a total of 25 min of advertising time over the 2 weeks in which the commercials are to be run. KAOS estimates that morning commercials are seen by 200,000 people, afternoon commercials are seen by 100,000 people, and evening commercials are seen by 600,000 people. How much morning, afternoon, and evening advertising time should Excelsior buy to maximize exposure of its commercials? morning min afternoon min evening minarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License