please answer question 3a and 3b. thank you.

Case Study: Optimization DON'T HESITATE .... VACCINATE With the failure to meet President Biden's target of 70% of the American population having at least one vaccine by July 4th and the spread of the highly contagious delta variant, public health officials around the country are trying to encourage unvaccinated people to get the COVID vaccinc. According to a recent New York Times article (6/28/21), "Federal officials expressed alarm in recent days about low vaccination rates among Americans in their late teens and 20s, and have blamed them for the country's ... failure to reach President Biden's goal of giving 70 percent of adults at least an initial dose by July 4." At the time of the publication, just over one-third of adults ages 18 10 39 reported being vaccinated, with especially low rates ... among people 24 or younger." Public health officials are faced with the challenge of how to reach young adults and encourage them to get the COVID vaccine. Montclair State University MBA students have been recruited to help the public service campaign to gen-z and millennials regarding vaccinations. They are requesting advice on how to distribute this marketing budget across regional Television (including ads on streaming video services), Social Media (Instagram/TikTok), and Outdoor Ads (such as billboards, buses, train stations). The budget has been set at $700,000 The following information is provided about each of these options about the potential effectiveness rating (Exposure Rating) per ad, their estimate of the number of young adults reached per ad, and the cost for each ad. MEDIA Exposure Rating per Ad People Reached per Ad Cost per Ad Television 100 4000 $20,000 Social Media Ads (Outdoors) 1000 $2,000 The exposure rating is a measure of the value of the ad to the viewers. It is a function of such things as image, message, recall, visual and audio appeal, and so on. As expected, the more expensive television advertisements has the highest exposure effectiveness rating along with the greatest potential for users to follow the recommendations. 2000 $8,000 30 15 4:347 Hill LTE M3 - Case Study-... & At this point, it is believed that the data concerning exposure and reach were only applicable to the first few ads in each medium. For Television, the exposure rating of 100 and the 4000 young adults reached per ad were reliable for the first 12 Television ads. After 12 ads, the benefit is expected to decline. It is recommended to reduce the exposure rating to 75 and the estimate of the number of young adults reached 1500 for any Television ads beyond 12. For Social Media, the preceding data arc reliable up to a maximum of 17 ads. Beyond 17 ads, the exposure rating declines to 20 and the number of young adults reached declines to 1200 per ad. Similarly, for Ads (Outdoors), the preceding data are reliable up to a maximum of 25: the exposure rating declines to 8 and the potential number of young adults reached declines to 200 for additional ads. The objective of the marketing campaign would be to maximize total exposure rating across all media. Because the importance of the messaging the campaign must reach at least 100,000 young adults. To balance the campaign and make use of all media, the following guidelines must be incorporated: Use at least twice as many Social Media advertisements as Television advertisements Use no more than 20 Television advertisements The Television budget should be at least 5290.000 The Social Media advertising budget is restricted to a maximum of $280,000 The Ads (Outdoors) budget is to be at least 560,000 Recommend how the $700.000 advertising budget should be allocated among the choices Develop a mathematical programming model that can be used to determine the advertising budget allocation. (HINT you should define two variables for each media option (eg Ti number of Television advertisements with rating of 100 and the 4000 young adults reached and T number of Television advertisements with rating of 75 and 1500 young adults reached, and so on). Enter the problem into Excel and use Solver to solve for the optimal solution. In addition to the Excel file, also prepare an executive summary managerial report. The Executive Summary should include the following sections 1. (10 points) Case Synopsis include a brief summary of the case and the business testets being studied) 2 (20 points) Methodology (including a discussion of what information was provided and how you used this information to analyor the problem organize the available data and type out your full mathematical programming model including defining your decision variables. 3. (50 points) Findings and Conclusion (include nummary of analysts results) Based on your analysis, what is the complete) optimal marketing decision? A schedule showing the recommended number of Television Social Media and Ads (Outdoor) advertisements and the budget allocation for each mydium Show the total exposure rate and indicate the total number of young adults reached. Make sure that your solution is fusible (eg, no partial advertisements) Also, address the following questions a How would the total exposure change if 850.000 MORE were available in the advertising budget? Given the public heath message, the television marketing division offered a 10% discount on television ads (eg. S18K each). (Assume total budget available is the original $700.000) How does this effect the allocation of advertisement methods and the total exposure rate? 4. (20 points) Recommendations. What other factors need to be considered in making the recommendations? Do you agree with the decisions from your quantitative analysis? Why or why not? Using the recommendations you made in the findings and conclusions section and your own management perspective (other issues to consider). what is your recommendation to convince young adults to vaccinate? You should also do some outside research and or base your opinion on your knowledge and/or experience with marketing (be sure to site any outside sources used). NOTE: I am not looking for a debate on whether or not to vaccinate. Please base your discussion on the fact that public health officials are trying to increase the percent of Americans who are vaccinated