PLEASE SHOW THE EXACT TABLE COMPLETE WITH DATA THAT SHOULD BE ENTERED IN EXCEL, AND WHAT EXACTLY SHOULD BE ENTERED IN THE SOLVER EACH TIME.

PLEASE SHOW THE EXACT TABLE COMPLETE WITH DATA THAT SHOULD BE ENTERED IN EXCEL, AND WHAT EXACTLY SHOULD BE ENTERED IN THE SOLVER EACH TIME.

The Green Corporation is a software start-up company in need of a marketing plan for exposure in the marketplace. The Green Company has hired your marketing firm to assist in making these management decisions. Your marketing firm has provided the following information about the industry exposure effectiveness rating per ad, their estimate of the number of potential new customers reached per ad, and the cost for each ad in the table below. Exposure Rating per Medium The exposure rating is based on the value of the ad to potential new customers. It is a function of a variety of variables such as image, message recall, visual and audio appeal. As shown in the above chart, TV advertisement has the highest exposure effectiveness rating along with the greatest potential for reaching new customers up to the first 10 ads. Both the exposure rating and new customers per ad decrease for more than 10 ads but cost the same as the first 10 ads. Radio Exposure The next medium, radio, is more effective on both exposure and new customers per ad on the first 15 ads and decreases to the numbers shown in the chart above for more than 15 ads at the same cost per ad. Internet The last medium proposed, internet, is more effective on both exposure and new customer per ad on the first 20 ads, decreasing on both variables for ads of more than 20 at the same cost. Budget and Guidelines The Green Corporation's marketing budget is limited to $300,000 in total. To balance the advertising campaign and make use of all advertising media, The Green Corporation management team also has adopted the following guidelines: - Use at least twice as many radio advertisements as television advertisements. - Use no more than 20 television advertisements. - The television advertising budget should be at least $150,000. - The radio advertising budget is restricted to a maximum of $105,000. - The internet advertising budget is to be at least $45,000. - At least 100,000 potential customers must be reached. Your marketing firm has agreed to work within these guidelines and provide a recommendation as to how the $300,000 advertising budget should be allocated among television, radio, and internet advertising for the Green Corporation. 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 exposure rating across all media of the advertising campaign. 2. 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. 3. 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. 4. 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