1. Formulate the LP model

2. Find the optimal solution using Excel and explain the meaning of the result.

Page of 2 Problem 2: A company chooses different type of advertising in order to maximize audience reached with a weekly advertisement budget of $8,000. Additional constraints on radio advertisement: maximum dollar spent on radio ad is $1,800; minimum radio ad per week is 5. Media Cost per Ad Decision Variable (No. of Ads) Audience Reached Maximum Ad per week T TV 5,000 $800 12 N Newspaper 8,500 $925 5 $290 25 Radio (Prime 2,400 Time) A 2,800 $380 20 Radio (Afternoon) 1) Formulate the LP model, define the objective function and constraints; 2) Set up the LP model in Solver and solve the results. Print and submit the Excel model layout, and the Answer and Sensitivity reports. Problem 3: A survey company's goal is to minimize survey cost hased on SurYoY