Must be done in excel; please attach spread sheet.

A committee in charge of promoting a Ladies Professional Golf Association tournament is trying to determine how best to advertise the event during the 2 weeks prior to the tournament. The committee obtained the following information about the three advertising media they are considering using.

Category	(Audience Reached per Advertisement )	(Cost per Advertisement)	(Maximum Number of Advertisements)
TV	200,000	$ 2500	10
Radio	50,000	$ 400	15
Newspaper	100,000	$ 500	20

The last column in this table shows the maximum number of advertisements that can be run during the next 2 weeks; these values should be treated as constraints. The committee has established the following goals for the campaign. Priority Level 1 Goal

Goal 1: Reach at least 4 million people.

Priority Level 2 Goal

Goal 2: The number of television advertisements should be at least 30% of the total number of advertisements. Priority Level 3 Goal Goal 3: The number of radio advertisements should not exceed 20% of the total number of advertisements.

Priority Level 4 Goal

Goal 4: Limit the total amount spent for advertising to $20,000

a) Formulate a goal programming model for this problem. b) Use thegoal programmingcomputer procedure illustratedinSection 14.2 to solve the model formulated in part A. Solve the problem with Excel and

submit the computer output.