I need an answer to this question, Excel template attached; 8-6 Sheet. Please include equation in answer. Thanks. Eddie Kelly is running for reelection as mayor of a small town in Alabama. Jessica Martinez, Kelly’s campaign manager during this election, is planning the marketing campaign, and there is some stiff competition. Martinez has selected four ways to advertise: television ads, radio ads, billboards, and newspaper ads. The costs of these, the audience reached by each type of ad, and the maximum number of each is shown in the following table: Problem 8-6 Template Inputs Type of Ad Cost per Ad Audience Reached/Ad Maximum Number TV (T) $800 30,000 10 Radio (R) $400 22,000 10 Billboards (B) $500 24,000 10 Newspapers (N) $100 8,000 10 Number of Ads TV (T) 7.00 Radio (R) 10.00 Billboards (B) 9.00 Newspapers (N) 10.00 Ingredient Constraints Constraints Values Objective to maximize Number of People to Reach

I need an answer to this question, Excel template attached; 8-6 Sheet. Please include equation in answer. Thanks.

Eddie Kelly is running for reelection as mayor of a
small town in Alabama. Jessica Martinez, Kelly’s
campaign manager during this election, is planning
the marketing campaign, and there is some stiff
competition. Martinez has selected four ways to advertise:
television ads, radio ads, billboards, and
newspaper ads. The costs of these, the audience
reached by each type of ad, and the maximum number
of each is shown in the following table: 

Problem 8-6 Template											
											
Inputs											
Type of Ad	Cost per Ad	Audience Reached/Ad	Maximum Number								
TV (T)	$800 	30,000	10								
Radio (R)	$400 	22,000	10								
Billboards (B)	$500 	24,000	10								
Newspapers (N)	$100 	8,000	10								
											
											
Number of Ads 											
											
TV (T)	7.00										
Radio (R)	10.00										
Billboards (B)	9.00										
Newspapers (N)	10.00										
											
Ingredient Constraints											
	Constraints		Values								
											
											
											
											
											
											
											
											
											
Objective to maximize											
Number of People to Reach