please solve correct + i want excel slover report sheet

For these problems you necd to answer sensitivity analysis questions using excel. These questions appear in ifalic foris. The excel files are available on the course website. Problem 1. Media Selection. The Westchester Clamber of Commcree periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising altematives include television, radio, and newspaper. Audicnce estimates, costs, and maximum media usage limitations are as shown. To ensure a bulanced use of advertising media, rulio advertisements mast not exeeed 50% of the toral rumber of advertisenents authocized. It addition, telovision should account for at least 10% of flue total number of advertisements authorized. a. If the promotional budget is limited to 518,200 , how many commercial messages should be run on each medium to maximize total audience contact? What is the allocation of the budget ansong the three modia, and what is the total asdience reached? b. By. bow nuch mould andience contact increase if an extra $/00 were allocered to the adverising budget? Problem 2. Investment and loanc- The cmployee credit union at State University is planning the allocation of funds for the coming year. The credit union makes four types of loans to its members. In addition, the credit union invests in risk-free securities to sabilize income. The varisus revenite-producing investrisents together with annual rates of return are as follows. The crodit union will have $2,000,000 availablo for izveatment during the coaning year. State Laws and crefit union policies impose the following restrictions on the composition of the loans and investments. 1. Risk-free securities may not exceed 30% of the total funds available for itvestment. 2. Signature loans may not exceed 10% of the funds iavested in all loans faustomobile, fimiture, and other securad and kignature leans). 3. Furniture loans plus other socured loans may not exceed the susomobile loans: 4. Other secured loans plus signature loans may not exceed the funds invested in risk-free securitici. How should the $2,000,000 be allocsted to each of the loan irvestreeat altematives to maximize total annial return? What is the projected tocel annual return