WEAR A MASK CAMPAIGN In light of the 2nd/3rd wave of COVID-19 in the US as we approach the holidays, the American Hospital Association is launching a Wear a Mask Campaign. They are encouraging people across the country to continue to practice safe measures to stop the spread of COVID-19. Their "campaign aims to offer resources on proper mask-wearing and care practices in addition to advice from health leaders to better equip our nation with the information they need to keep themselves, their family, and their communities safe." They are encouraging people "to follow science: continue social distancing, washing hands for at least 20 seconds, and most importantly, to wear a face covering when outside the home." https://www.aha.org/wearamask The AHA is looking for assistance from Montclair State University MBA students to help further the public service campaign to millennials throughout the country regarding the continued importance of wearing masks in public and maintaining social distancing to help reduce the spread of COVID-19. The AHA is requesting advice on how to distribute this marketing budget across 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 $3,750,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 millennials reached per ad, and the cost for each ad. MEDIA Exposure Rating per Ad # People Reached per Ad Cost per Ad Television 97.2 700K $100,000 Social Media 51.3 320K $40,000 Ads (Outdoors) 2.7 60K $10,000 The exposure rating is a measure of the value of the ad to the listeners/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. 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 97.2 and the 700K millennials reached per ad were reliable for the first 17 Television ads. After 17 ads, the benefit is expected to decline. It is recommended to reduce the exposure rating to 59.4 and the estimate of the number of people reached 380K for any Television ads beyond 17. For Social Media, the preceding data are reliable up to a maximum of 33 ads. Beyond 33 ads, the exposure rating declines to 32.4 and the number of millennials reached declines to 200K per ad. Similarly, for Ads (Outdoors), the preceding data are reliable up to a maximum of 40; the exposure rating declines to 1.1 and the potential number of people reached declines to 25K 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 25 million millennials. 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 less than $1,600,000 The Social Media advertising budget is restricted to a maximum of $2,000,000 The Ads (Outdoors) budget is to be at least $300,000 Recommend how the $3,750,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. T1 = number of Television advertisements with rating of 97.2 and the 700K millennials reached and T2 = number of Television advertisements with rating of 59.4 and 380K millennials reached, and so on). Enter the problem into Excel and use Solver to solve for the optimal solution. In addition to the Excel file, include 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 issue(s)being studied) 2. (20 points) Methodology (including a discussion of what information was provided and how you used this information to analyze the problem) organize the available data and type out your full mathematical programming model including defining your decision variables. 3. (50 points) Findings and Conclusions (include summary of analysis 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 medium. Show the total exposure rate and indicate the total number of millennials reached. Make sure that your solution is feasible (eg. no partial advertisements). Also, address the following three questions: a. How would the total exposure change if $1,000,000 MORE were available in the advertising budget? b. Given that the debates and elections are over, there is less demand for television ads. As a result, the AHA Marketing Director believes that he can secure television ads for just $70K each. (Assume total budget available is the original $3,750,000.) How does this effect the allocation of advertisement methods and the total exposure rate? c. After reviewing the recommendation, the AHA Marketing Director realized that given all of the COVID costs, he may need to reconsider his budget. If his new objective is to minimize his expenses (budget) but needed to make sure that the campaigns still reach at least 25 million millennials. How would the recommendation change if the objective was to minimize the expenses? Develop the media schedule under this objective. What is the total expenditure and what is the exposure rate? (Assume television ads still cost $100K each.) 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 millennials to adhere to the social distancing and proper mask-wearing recommendations? You should also do some outside research and/or base your opinion on your knowledge and/or experience with marketing and your thoughts on how to curb the spread of COVID-19 amongst millennials and the impact on other generations (be sure to site any outside sources used).