An ad campaign for a new snack chip will be conducted in a limited geographical area and can use TV time, radio time, and newspaper ads. Information about each medium is shown below. If the number of TV ads cannot exceed the number of radio ads by more than 4, and if the advertising budget is $10000, develop the LP model that will maximize the number reached and achieve an exposure quality if at least 1000. Create the LP in Tab #11 Medium Cost Per # Reached Exposure Ad TV 500 Radio 200 Newspape 400 r 10000 3000 5000 Quality 30 40 25

Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
icon
Related questions
Question

Please show work in excel 

An ad campaign for a new snack chip will be conducted in a limited geographical area and can use TV time, radio time, and newspaper ads. Information about each medium is shown below. If the
number of TV ads cannot exceed the number of radio ads by more than 4, and if the advertising budget is $10000, develop the LP model that will maximize the number reached and achieve an
exposure quality if at least 1000. Create the LP in Tab #11
Medium Cost Per # Reached Exposure
Ad
TV
500
Radio
200
Newspape 400
r
10000
3000
5000
Quality
30
40
25
Transcribed Image Text:An ad campaign for a new snack chip will be conducted in a limited geographical area and can use TV time, radio time, and newspaper ads. Information about each medium is shown below. If the number of TV ads cannot exceed the number of radio ads by more than 4, and if the advertising budget is $10000, develop the LP model that will maximize the number reached and achieve an exposure quality if at least 1000. Create the LP in Tab #11 Medium Cost Per # Reached Exposure Ad TV 500 Radio 200 Newspape 400 r 10000 3000 5000 Quality 30 40 25
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

WHAT OBJECTIVE/CONSTRAINTS DO YOU PUT INTO SOLVER?

Solution
Bartleby Expert
SEE SOLUTION
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Basic Technical Mathematics
Basic Technical Mathematics
Advanced Math
ISBN:
9780134437705
Author:
Washington
Publisher:
PEARSON
Topology
Topology
Advanced Math
ISBN:
9780134689517
Author:
Munkres, James R.
Publisher:
Pearson,