INSTRUCTIONS:
Question: Your client is a large pharmaceutical company operating and manufacturing globally. The company wants to choose a location to construct a new facility to ramp up the manufacture, production, and sales of vaccines. The company expects a huge demand in new vaccines in the year 2021. 1.Review the data file posted here. This file details the company's most recent 2019 tax provision calculations. a.Add a column to compute net income. b.Use this data to prepare a dashboard in Tableau. 2.The company would like your help in choosing a location to open a new manufacturing facility. The goal is to maximize net income and/or minimize taxes. a.Where do you recommend? Why? b.Consider the industry – what other factors may be important to choose a location? c.Discuss the reasoning for your selection and prove the logic of your recommendation. Prepare a succinct well organized 1-2 page memo to the client explaining your recommendation. Visually integrate results from your analysis into your memo. Provide proof and evidence to support your recommendation.