Marketing decisions. Refer to the Jewels-4-U example in the book. Now assume that for the second month planning, there are some changes that are being made to the structure. First, the total advertising budget is now down to $30,000 but the media outlets remain the same. The table is shown here again on how the various media outlets contribute to exposure ratings, customer outreach, and related costs and number of advertisements available per month. Advertising Media Potential customers reached Cost ($) per advertisement Maximum Availability per month Exposure Rating (out of 100) 1 Television (1 min) local stations 2000 1000 10 50 2 Television (30 sec) Cable station 5000 4000 5 75 3 Radio (peak traffic times) 800 100 30 25 4 Social Media Ads (customized) 8000 2000 15 80 5 Sunday Newspaper Magazine 1500 1000 4 60 With the slash in the budget, the Marketing Manager decides that in Month 2 it is more critical to focus on the potential customers reached instead of the exposure rating and decides to refocus their efforts under a new direction. Find out what combination of advertising will maximize the customer outreach given the following constraints: The total amount spent on Social Media is still 50% of the total budget The total exposure rating must be higher than 1800 No less than 6 total advertisements should be on TV outlets a. Rewrite the LP to meet these new requirements, run it using Solver, and fill in the following Table to show what the optimal number of ads in each media outlet are for Jewels-4-U company to maximize their customer outreach: Advertising Media Advertisements Placed Television (1 min) local stations __ ? Television (30 sec) Cable station ? Radio (peak traffic times) ? Social Media Ads (customized) ? Sunday Newspaper Magazine ? b. The total number of customers reached by using this advertisement strategy = _?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

100%

Marketing decisions. Refer to the Jewels-4-U example in the book. Now assume that for the second month planning, there are some changes that are being made to the structure. First, the total advertising budget is now down to $30,000 but the media outlets remain the same. The table is shown here again on how the various media outlets contribute to exposure ratings, customer outreach, and related costs and number of advertisements available per month.

	Advertising Media	Potential customers reached	Cost ($) per advertisement	Maximum Availability per month	Exposure Rating (out of 100)
1	Television (1 min) local stations	2000	1000	10	50
2	Television (30 sec) Cable station	5000	4000	5	75
3	Radio (peak traffic times)	800	100	30	25
4	Social Media Ads (customized)	8000	2000	15	80
5	Sunday Newspaper Magazine	1500	1000	4	60

With the slash in the budget, the Marketing Manager decides that in Month 2 it is more critical to focus on the potential customers reached instead of the exposure rating and decides to refocus their efforts under a new direction. Find out what combination of advertising will maximize the customer outreach given the following constraints:

The total amount spent on Social Media is still 50% of the total budget
The total exposure rating must be higher than 1800
No less than 6 total advertisements should be on TV outlets

a. Rewrite the LP to meet these new requirements, run it using Solver, and fill in the following Table to show what the optimal number of ads in each media outlet are for Jewels-4-U company to maximize their customer outreach:

Advertising Media	Advertisements Placed
Television (1 min) local stations	______ ?
Television (30 sec) Cable station	______ ?
Radio (peak traffic times)	______ ?
Social Media Ads (customized)	______ ?
Sunday Newspaper Magazine	______ ?

b. The total number of customers reached by using this advertisement strategy = _____?

Expert Solution

Step 1

Decision Variable:

$S u p p o s e - X_{1} b e N o . o f a d s i n t h e T e l e v i s i o n (1 m i n) l o c a l s t a t i o n s X_{2} b e N o . o f a d s i n t h e T e l e v i s i o n (30 s e c) C a b l e s t a t i o n X_{3} b e N o . o f a d s o n t h e R a d i o (p e a k t r a f f i c t i m e s) X_{4} b e N o . o f a d s i n t h e S o c i a l M e d i a A d s (c u s t o m i z e d) X_{5} b e N o . o f a d s i n t h e S u n d a y N e w s p a p e r M a g a z i n e$