Using Excel Solver, develop a linear programming model that can be used to determine the advertising budget allocation for the Green Corporation where the objective function is to maximize the total exposure rating across all media of the advertising campaign.

Present a schedule summarizing the recommended number of television, radio, and internet ads and the budget allocation for each medium. Show the total exposure and indicate the total number of potential new customers reached based on your linear programming model developed in question $1.$

Using Excel Solver, develop a linear programming model that can be used to determine the advertising budget allocation for the Green Corporation where the objective function is to maximize the total number of new customers reached across all media of the advertising campaign.

Present a schedule summarizing the recommended number of television, radio, and internet ads and the budget allocation for each medium. Show the total exposure and indicate the total number of potential new customers reached based on your linear programming model developed in question $3.$

Compare and contrast the results obtained from your linear programming models and schedules in questions $1$ through $4.$ Then, make a recommendation to the Green Corporation for its advertising campaign based on the results of all of your calculations. Do you recommend basing the advertising campaign on maximizing total exposure rating or based on maximizing the total number of customers? Fully explain your recommendations.