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.