(Solved): 2. The marketing director of Chris Doane Automotive company has been trying to determine a budget ...

2. The marketing director of Chris Doane Automotive company has been trying to determine a budget schedule for its TV and radio advertising campaigns. Each TV ad costs $5,000 and each radio ad costs $2,000. Moreover, each TV ad is viewed by approximately 300,000 people, whereas a radio advertisement reaches about 150,000 audience exposures. The director sets the following goals in order of importance (ranked from most important to least important): 1. The total advertising budget of $120,000 should not be exceeded. 2. There should be at least 10 TV ads and at least 20 radio ads. 3. The total number of people to view or hear the advertisements should be at least 9 million. a. Formulate the director's goal programming problem that could be used to find out how many of each type of ad to place. b. Solve the problem using QM for Windows software. Identify the best solution and the total number of audience exposure for both TV and radio ads. Have all the goals been achieved? Which priorities have been satisfied or dissatisfied? Are there any underachieved or overachieved goals? If so, explain via using "Summary" output table.