Please do it in excel

show all the steps

Problem 1: An advertising agency is trying to determine a TV advertising schedule for an important client. The client would like its advertisements (ads) to be seen by at least 100 million high-income men, 90 million high-income women, and 80 million low-income people. The advertising agency can purchase several types of TV ads, such as ads shown during the following shows: live sports shows, game shows, news shows, reality shows, sitcoms, and soap operas. The advertising costs (in thousands of dollars) and expected audiences (in millions of viewers) of a oneminute ad of each type among other data for this problem are given in Table 1 below. The client requires that at least four one-minute ads be placed on sports shows, on news shows, and on reality shows. Also, it requires that no more than eight one-minute ads be placed on any single type of show. The advertising agency wants to find the TV advertising plan that meets its client's exposure requirements with minimum total cost. Page 2 of 2 agency problem data Table 1. Advertising Page 2 of 2 Please answer the following questions utilizing Spreadsheet / Optimization software Modeling Best Practices described during one of my lectures: (a) Formulate this problem as a LP problem utilizing the 3-step LP formulation technique described during my lectures. Upload the formulated LP problem as a Word document on the Canvas Assignment page. ( 13 points) (b) Solve the LP problem formulated in part (a) using either Excel Solver or LINDO / LINGO software, clearly showing both the Answer Report and the Sensitivity Analysis Report. Upload the working LP Model on the Canwasissignument pager ( 8 points) Problem 1: An advertising agency is trying to determine a TV advertising schedule for an important client. The client would like its advertisements (ads) to be seen by at least 100 million high-income men, 90 million high-income women, and 80 million low-income people. The advertising agency can purchase several types of TV ads, such as ads shown during the following shows: live sports shows, game shows, news shows, reality shows, sitcoms, and soap operas. The advertising costs (in thousands of dollars) and expected audiences (in millions of viewers) of a oneminute ad of each type among other data for this problem are given in Table I below. The client requires that at least four one-minute ads be placed on sports shows, on news shows, and on reality shows. Also, it requires that no more than eight one-minute ads be placed on any single type of show. The advertising agency wants to find the TV advertising plan that meets its client's exposure requirements with minimum total cost. Page 2 of 2 agency problem data Table 1. Advertising Page 2 of 2 Please answer the following questions utilizing Spreadsheet / Optimization software Modeling Best Practices described during one of my lectures: (a) Formulate this problem as a LP problem utilizing the 3-step LP formulation technique described during my lectures. Upload the formulated LP problem as a Word document on the Canvas Assignment page. (13 points) (b) Solve the LP problem formulated in part (a) using either Excel Solver or LINDO / LINGO software, clearly showing both the Answer Report and the Sensitivity Analysis Report. Upload the working L.P Model on the Canvas Assignment page. ( 8 points)