Include formulas for the correct answer

Note: The color of some cells changes to green if you get the correct answers after running the Solver. Newspaper 50 Radio 80 Audience Exposure Index (per dollar) Min Allocation Advertising Budget 25% $1,000 Decision Variables Newspaper Radio Dollars Allocated Constraints Allocated Budget Sign Available Budget Spending on newspaper Spending on radio Spending on newspaper Total spent Objective Total Exposure Index 2. (50 points) The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of $1,000 between newspaper advertising and radio advertising. Management decided that at least 25% of the budget must be spent on each type of media and that the amount of money spent on local newspaper advertising must be at least twice the amount spent on radio advertising. A marketing consultant developed an index that measures audience exposure per dollar of advertising on a scale from 0 to 100, with higher values implying greater audience exposure. The value of the index for local newspaper advertising is 50 and the value of the index for spot radio advertising is 80. Formulate and solve a linear programming model that can be used to determine how the restaurant should allocate its advertising budget in order to maximize the value of total audience exposure. Note: The color of some cells changes to green if you get the correct answers after running the Solver. Newspaper 50 Radio 80 Audience Exposure Index (per dollar) Min Allocation Advertising Budget 25% $1,000 Decision Variables Newspaper Radio Dollars Allocated Constraints Allocated Budget Sign Available Budget Spending on newspaper Spending on radio Spending on newspaper Total spent Objective Total Exposure Index 2. (50 points) The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of $1,000 between newspaper advertising and radio advertising. Management decided that at least 25% of the budget must be spent on each type of media and that the amount of money spent on local newspaper advertising must be at least twice the amount spent on radio advertising. A marketing consultant developed an index that measures audience exposure per dollar of advertising on a scale from 0 to 100, with higher values implying greater audience exposure. The value of the index for local newspaper advertising is 50 and the value of the index for spot radio advertising is 80. Formulate and solve a linear programming model that can be used to determine how the restaurant should allocate its advertising budget in order to maximize the value of total audience exposure