A company wants to determine how to allocate its $200,000 advertising budget to market a new cereal. The company is considering newspaper ads, television ads, and radio ads. The following table illustrates the cost of advertising in these different media and the exposure to new customers reached by increasing the number of ads in each medium.

Media and Number of Ads No. of New Customers reached Cost per ad

Newspaper1-5 700 $500

Newspaper: 6-10 500 $400

Television: 1-10 9000 $5000

Television: 11-20 7500 $4000

Radio: 1-10 4000 $2000

Radio: 11-20 300 $1500

Use Excel to formulate and solve this problem to maximize audience exposure. Please use the Excel Solver to solve the above exercise question(s) and upload your Spreadsheet Answer into the folder section.