Homework Help is Here – Start Your Trial Now!
Math
Advanced Math
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

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

College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
12th Edition
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:R. David Gustafson, Jeff Hughes
Chapter6: Linear Systems
Section6.8: Linear Programming
Problem 5SC: If during the following year it is predicted that each comedy skit will generate 30 thousand and...
See similar textbooks
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

SEE SOLUTIONCheck out a sample Q&A here
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
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Algebra for College Students
Algebra for College Students
Algebra
ISBN:
9781285195780
Author:
Jerome E. Kaufmann, Karen L. Schwitters
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS