Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 11, Problem 9P
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:
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.
- a. 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, and what is the total audience reached?
- b. By how much would audience contact increase if an extra $100 were allocated to the promotional budget?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Righetti Homes, a custom home builder in Arizona, is currently offering three models in a newly developed residential neighborhood in Scottsdale. The accompanying Specs worksheet includes the information about the three models, including selling prices, material costs, labor costs, buyer incentives (percent of the selling price), and average buyer upgrades (percent of the selling price). Righetti Homes plans to build 50 homes in the neighborhood, and it would like to estimate its total sales and profits in the new residential neighborhood.
Model A
Model B
Model C
Selling Price
399,990
499,990
649,990
Material Costs
120,000
150,000
200,000
Labor Costs
150,000
200,000
330,000
Buyer Incentives (percent of the selling price)
3%
5%
6%
Average Buyer Upgrades (percent of the selling price)
12%
10%
8%
1. Build a spreadsheet model to help Righetti Homes estimate its total sales and profits in the new residential neighborhood. If Righetti Homes builds 10 Model A homes, what are…
The vintage Restaurant is located on Captiva Island, a resort community located near Fort Meyers, Florida. The restaurant, which is owned and operated by Karen Payne, has just completed its third year of operation. During this time, Karen sought to establish a reputation for the restaurant as a high-quality dining establishment that specializes in fresh seafood. The efforts made by Karen and her staff have proved successful, and her restaurant has become one of the best and fastest-growing restaurants on the island.
Karen has just concluded that to plan better for the growth of the restaurant in the future, it is necessary to develop a system that will enable her to forecast food and beverage sales by the month for up to 1 year in advance. Karen has the following data available on the total food and beverage sales that were realized during the previous 3 years of operation.
Food and Beverage Sales for the Vintage Restaurant ($1000s)
Month First Year Second Year Third YearJanuary 242…
Direct Materials Purchases Budget
Romano’s Frozen Pizza Inc. has determined from its production budget the following estimated production volumes for 12'' and 16'' frozen pizzas for September:
Chapter 11 Solutions
Essentials of Business Analytics (MindTap Course List)
Ch. 11 - Kelson Sporting Equipment, Inc., makes two types...Ch. 11 - The Sea Wharf Restaurant would like to determine...Ch. 11 - Blair Rosen. Inc. (BR) is a brokerage firm that...Ch. 11 - Round Tree Manor is a hotel that provides two...Ch. 11 - Industrial Designs has been awarded a contract to...Ch. 11 - Vollmer Manufacturing makes three components for...Ch. 11 - Photon Technologies, Inc., a manufacturer of...Ch. 11 - The Westchester Chamber of Commerce periodically...Ch. 11 - The management of Hartman Company is trying to...Ch. 11 - The employee credit union at State University is...
Ch. 11 - The Atlantic Seafood Company (ASC) is a buyer and...Ch. 11 - The Silver Star Bicycle Company will manufacture...Ch. 11 - The Clark County Sheriff’s Department schedules...Ch. 11 - Bay Oil produces two types of fuel (regular and...Ch. 11 - Consider the following network representation of a...Ch. 11 - Refer to the transportation problem described in...Ch. 11 - Aggie Power Generation supplies electrical power...Ch. 11 - The Calhoun Textile Mill is in the process of...Ch. 11 - Refer to the Calhoun Textile Mill production...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- The Ashland MultiComm Services (AMS) marketing department wants to increase subscriptions for its 3-For-All telephone, cable, and Internet combined service. To ensure that as many trial subscriptions to the 3-For-All service as possible are converted to regular subscriptions, the marketing department works closely with the customer support department to accomplish a smooth initial process for the trial subscription customers. To assist in this effort, the marketing department needs to accurately forecast the monthly total of new regular subscriptions. A team consisting of managers from the marketing and customer support departments was convened to develop a better method of forecasting new subscriptions. Previously, after examining new subscription data for the prior three months, a group of three managers would develop a subjective forecast of the number of new subscriptions. Livia Salvador, who was recently hired by the company to provide expertise in quantitative forecasting…arrow_forward(a) Complete the following transportation tableau using the minimum cell cost methodarrow_forwardAdirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home loans, personal loans, and automobile loans. The annual rates of return for the three types of loans are 7% for home loans, 12% for personal loans, and 9% for automobile loans. The bank’s planning committee has decided that at least 40% of the new funds must be allocated to home loans. In addition, the planning committee has specified that the amount allocated to personal loans cannot exceed 60% of the amount allocated to automobile loans. Assume that ASB has the original $1 million in new funds available and that the planning committee has agreed to relax the requirement that at least 40% of the new funds must be allocated to home loans by 1%. How much would the annual return change? How much would the annual percentage return change? Discuss. *arrow_forward
- Given that sales volumes are forecast to stay steady at 2,000,000 units, the best option is _________________. Group of answer choices 1. Manual Production Line 2. Semi-automatic Production Line 3. Fully Automatic Production Linearrow_forwardThe Megabuck Hospital Corp. is to build a state-subsidized nursing home catering to homeless patients as well as high-income patients. State regulations require that every subsidized nursing home must house a minimum of 760 homeless patients and no more than 800 high-income patients in order to qualify for state subsidies. The overall capacity of the hospital is to be 2,100 patients. The board of directors, under pressure from a neighborhood group, insists that the number of homeless patients should not exceed twice the number of high-income patients. Due to the state subsidy, the hospital will make an average profit of $9,800 per month for every homeless patient it houses, whereas the profit per high-income patient is estimated at $7,800 per month. How many of each type of patient should it house in order to maximize profit? (If an answer does not exist, enter DNE.) high-income patients homeless patients profitarrow_forwardThe production level needed from the agricultural sector, the manufacturing sector, and the energy sector is ..... ....... ....... units.arrow_forward
- Based on the results of the cost driver analysis, which cost drivers should be used for Bob’s delivery? - Miles and Time - Miles and weight - Miles, time & weight - Time & weightarrow_forwardThe Megabuck Hospital Corp. is to build a state-subsidized nursing home catering to homeless patients as well as high-income patients. State regulations require that every subsidized nursing home must house a minimum of 750 homeless patients and no more than 900 high-income patients in order to qualify for state subsidies. The overall capacity of the hospital is to be 1,800 patients. The board of directors, under pressure from a neighborhood group, insists that the number of homeless patients should not exceed twice the number of high-income patients. Due to the state subsidy, the hospital will make an average profit of $9,500 per month for every homeless patient it houses, whereas the profit per high-income patient is estimated at $8,000 per month. How many of each type of patient should it house in order to maximize profit? HINT [See Example 3.] (If an answer does not exist, enter DNE.) high-income patients: homeless: profit:arrow_forwardThe Megabuck Hospital Corp. is to build a state-subsidized nursing home catering to homeless patients as well as high-income patients. State regulations require that every subsidized nursing home must house a minimum of 700 homeless patients and no more than 620 high-income patients in order to qualify for state subsidies. The overall capacity of the hospital is to be 1,800 patients. The board of directors, under pressure from a neighborhood group, insists that the number of homeless patients should not exceed twice the number of high-income patients. Due to the state subsidy, the hospital will make an average profit of $13,000 per month for every homeless patient it houses, whereas the profit per high-income patient is estimated at $9,000 per month. How many of each type of patient should it house in order to maximize profit? Group of answer choices A)700 homeless patients and 1,100 high-income patients B)1,200 homeless patients and 600 high-income patientsC)700 homeless patients…arrow_forward
- Fowle Marketing Research, Inc., bases charges to a client on the assumption that telephone surveys can be completed within an average time of 14 minutes or less. If more time is required, a premium rate is charged. I need help with 3 and 4.arrow_forwardCrystal, Incorporated, has prepared the following budgets for March. In March, budgeted production is 1,100 units, budgeted sales is 1,300 units, and direct materials inventory will stay constant. Monthly costs are budgeted as follows: Direct materials $ 4.25 per unit Direct labor 7.40 per unit Variable manufacturing overhead 10.10 per unit Variable selling and administrative expense 8.25 per unit Fixed manufacturing overhead 6,100 Fixed selling and administrative expense 7,535 What is the budgeted cost of goods sold for March?arrow_forwardDoes the new training program appear to be more effective than the older training program in lowering the weight of its new prospects?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSON
The Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. Freeman
Introduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
2.1 Introduction to inequalities; Author: Oli Notes;https://www.youtube.com/watch?v=D6erN5YTlXE;License: Standard YouTube License, CC-BY
GCSE Maths - What are Inequalities? (Inequalities Part 1) #56; Author: Cognito;https://www.youtube.com/watch?v=e_tY6X5PwWw;License: Standard YouTube License, CC-BY
Introduction to Inequalities | Inequality Symbols | Testing Solutions for Inequalities; Author: Scam Squad Math;https://www.youtube.com/watch?v=paZSN7sV1R8;License: Standard YouTube License, CC-BY