Please provide answer in excel format with formulas.

A candidate for mayor in a small town has allocated $40,000 for last-minute advertising in the days preceding the election. Two types of ads will be used: radio and television. Each radio ad costs $200 and reaches an estimated 3,000 people. Each television ad costs $500 and reaches an estimated 7,000 people. In planning the advertising campaign, the campaign manager would like to reach as many people as possible, but she has stipulated that at least 10 ads of each type must be used. Also, the number of radio ads must be at least as great as the number of television ads. How many ads of each type should be used? How many people will this reach? Define the decision variables necessary for the LP formulation as follows: R = number of radio ads T = number of TV ads (a) Formulate appropriately as an LP to maximize the total people reached. Provide the algebraic model formulation in your submission. Must be neatly presented. (b) Input and solve the formulation using Excel. After running Solver, generate sensitivity report. (c) Report how many ads of each type should be used and how many people will be reached.