Excep please!

Problem 5 Two advertising media are being considered for promotion of a product. Radio ads cost $400 each, while newspaper ads cost $600 each. The total budget is $7,200 per week. The total number of ads should be at least 15, with at least 2 of each type, and there should be no more than 19 ads in total. The company does not want the number of newspaper ads to exceed the number of radio ads by more than 25 percent. Each newspaper ad reaches 6,000 people, 50 percent of whom will respond; while ench radio ad reaches 2,000 people, 20 percent of whom will respond. The company wishes to reach as many respondents as possible while meeting all the constraints stated 1. Develop the appropriate LP model for determining the number of ads of each type that should be placed 2. Solve the linear system using Excel. 3. Interpret the sensitivity report: a. Calculate the range of optimality (ROO) for each decision variable. b. Interpret the shadow price of each constraint c. Are the constraints binding or non-binding