please fully explain and write out answer

5. John Peterson, marketing director for Upper Power Corporation, is about to begin an advertising campaign promoting energy conservation. In trying to budget between television and newspaper advertisements, he sets the following goals. (1) The total advertising budget of $120,000 should not be exceeded. (2) There should be a mix of TV and newspaper ads, with at least 10TV spots (costing $5,000 each) and 20 newspaper spots (\$2,000 each). (3) The total number of people to read or hear the advertisements should be at least 9 million. Each television spot reaches approximately 300,000 people. A newspaper advertisement is read by about 150,000 people. (a) Suppose the weights for the three goals are respectively 100,75 , and 40 per 100,000 people, formulate a goal programming problem to find out how many of each type of ad to place. Solve using either Excel or Lingo. How many people, in total, will read or hear the advertisement? (b) If the above three goals are listed according to their ranks. Set up and solve a goal programming model again using the ranked goals approach. How many of each type of ad should be placed