answer how to solve on excel pls

22. (15 points) A resturant wishes to advertise in different media to promote its sales. The audience exposure (per dollar) is indicated in the table below its total advertising budget is $10,000 and in its effort to reach different audiences it has decided that at least 50% of the budget must be allocated to newspapers. Further, not more than 65% of the budget be allocated to TV. Type out the objective function and constraints. This will enable me to give you partial credit if Solver does not execute. () Set up the problem as a LP problem and solve it using Solver. The Answer Report must be downloaded. Also the solver dialog box should be populated when I open your submission Parameters TV Newspaper 50 Radio 80 120 Audience Exposure Index (per dollar)