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.
Medium

Cost Per Ad

# Reached

Exposure Quality

TV

500

10000

30

Radio

200

3000

40

Newspaper

400

5000

25


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 model that will maximize the number reached and achieve an exposure quality if at least 1000.

Using SOLVER or LINGO, solve the Max Objective Function. Provide copy of the solution spreadsheet.