You work at an advertising firm and you're managing the account of a client. You're helping...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You work at an advertising firm and you're managing the account of a client. You're helping them plan their advertising for the next month. They have a budget of $30,000 and want you to design an ad campaign that: Includes at least 10 TV commercials Reaches at least 50,000 people • Allocates no more than $18,000 to TV ads ● Maximizes the total Exposure Quality Units ● The following table shows the number of people reached per ad, the cost per ad, the number of available ads, and the Exposure Quality Units (which measures the ad's effectiveness) per ad for the four available types of media. Daytime TV Evening TV Daily Paper Radio Reach 1000 2000 1500 300 Cost 1500 3000 400 100 Available Exposure Quality Units 15 12 25 30 65 90 40 20 a) Write out the formulation of a linear optimization model to help you determine the number of each type of ad to purchase in order to maximize the total Exposure Quality Units of the campaign. b) What is the optimal solution, and what is the value of the objective function? Use Excel Solver to solve this problem. You work at an advertising firm and you're managing the account of a client. You're helping them plan their advertising for the next month. They have a budget of $30,000 and want you to design an ad campaign that: Includes at least 10 TV commercials Reaches at least 50,000 people • Allocates no more than $18,000 to TV ads ● Maximizes the total Exposure Quality Units ● The following table shows the number of people reached per ad, the cost per ad, the number of available ads, and the Exposure Quality Units (which measures the ad's effectiveness) per ad for the four available types of media. Daytime TV Evening TV Daily Paper Radio Reach 1000 2000 1500 300 Cost 1500 3000 400 100 Available Exposure Quality Units 15 12 25 30 65 90 40 20 a) Write out the formulation of a linear optimization model to help you determine the number of each type of ad to purchase in order to maximize the total Exposure Quality Units of the campaign. b) What is the optimal solution, and what is the value of the objective function? Use Excel Solver to solve this problem.
Expert Answer:
Answer rating: 100% (QA)
a Formulation of the linear optimization model Let x1 number of Daytime TV ads to purchas... View the full answer
Related Book For
Modern Advanced Accounting In Canada
ISBN: 9781259066481
7th Edition
Authors: Hilton Murray, Herauf Darrell
Posted Date:
Students also viewed these accounting questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Given a sorted array of Comparable items, write functions floor () and ceiling () that return the index of the largest (or smallest) item not larger (or smaller) than an argument item in logarithmic...
-
If 2200 J of heat are added to a 190-g object, its temperature increases by 12 C. (a) What is the heat capacity of this object? (b) What is the object's specific heat?
-
Arrange the following compounds in order of increasing boiling point. Explain your answer in terms of the intermolecular forces in each compound. (a) (b) (c) (d)
-
Consider the gasoline mileage performance data in Table B.3. a. Use the all-possible-regressions approach to find an appropriate regression model. b. Use stepwise regression to specify a subset...
-
The following occurred during June at Hicks Family Counseling. INSTRUCTIONS Analyze each transaction. Use T accounts to record these transactions and be sure to put the name of the account on the top...
-
Constructing Balance Sheets and Determining Income Following is balance sheet information for Lynch Services at the end of Year 2 (the most recent year) and Year 1. December 31,Year 2 December...
-
You are to post a summation of a newspaper, journal, magazine or Internet article that pertains to a recently reported ethical issue in the healthcare profession. The article must relate to a news...
-
Sum the two results to find the total displacement. LEARN MORE Remarks To find the displacement while braking, we could have used the two kinematics equations involving time, namely, Ax = vot + 1/2...
-
Calculate the Schwarzschild radius for the Sun. Here's what to do: 1 . Use M = 1 solar mass = _ _ _ _ _ _ kg , use the number you looked up in the previous problem. 2 . To get an answer in meters,...
-
A planet experiences a force of 2.65 x 1012 N from it's moon (mass of 2.77 x 1017 kg). If the moon is 3.05 x 109 m away from the planet and their radii can be neglected, what is the planet's mass? a....
-
The first questions are about estimates. Please see your class notes for details and remember: ( i ) an estimate is not a guess, and ( ii ) the best approach is to break down the problem into small...
-
Gravitational Fields Use the gravitational field equations to solve the problems below. 1. A 485 kg sphere sits at 14.0 km due North of a 852 kg sphere. What is the force of gravity on the first...
-
New trade theory explains the location of firms in one city rather than another by using the concepts of economies of scale and first-mover advantage. Explain the argument made by new trade theory.
-
Citing a scientific article, explain in your own words, how DNA fingerprinting has been used in forensic science to solve crimes and why it may not always be accurate or effective.
-
Baskin purchased 20,000 common shares (20%) of Robbin on January 1, Year 5, for $275,000 and classified the investment as FVTPL. Robbin reported net income of $85,000 in Year 5 and $90,000 in Year 6,...
-
Hil Company purchased 10,000 common shares (10%) of Ton Inc. on January 1, Year 4, for $345,000, when Ton's shareholders' equity was $2,600,000, and it classified the investment as a FVTPL security....
-
Explain the difference in the calculation of consolidated net income attributable to shareholders of parent and consolidated retained earnings depending on whether the preferred shares of a...
-
A \(0.010-\mathrm{kg}\) bullet is fired from a \(5.0-\mathrm{kg}\) gun with a muzzle velocity of \(250 \mathrm{~m} / \mathrm{s}\). (a) While the bullet is traveling in the barrel, what is the ratio...
-
A \(1500-\mathrm{kg}\) car going at \(6.32 \mathrm{~m} / \mathrm{s}\) collides with a \(3000-\mathrm{kg}\) truck at rest. If the collision is totally inelastic and takes place over an interval of...
-
On a low-friction track, a \(0.66-\mathrm{kg}\) cart initially going at \(1.85 \mathrm{~m} / \mathrm{s}\) to the right collides with a cart of unknown inertia initially going at \(2.17 \mathrm{~m} /...
Study smarter with the SolutionInn App