Instruction: Show step by step using excel.

A XYZ company is about to begin an advertising campaign promoting energy conservation. In trying to budget between television and newspaper advertisements, he sets the following goals in order of importance: i. The total advertising budget of P6,000,000 should not be exceeded. ii. There should be a mix of TV and newspaper ads, with at least 10TV spots (costing P250,000 each) and at least 20 newspaper ads (costing P100,000 each). iii. The total number of people to read or hear the advertisements should be at least 9 million. Each television spot reaches approximately 300,000 people. A newspaper advertisement is read by about 150,000 persons. a. Formulate the problem to find out how many of each type of ad to place. b. Build a spreadsheet model and solve the problem using Excel Solver. What is the optimal solution? What is the optimal objective function value