Tax Analytics
(don’t worry about word counting as long you answer all the questions) 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. Review the data file posted here. This file details the company’s most recent 2019 tax provision calculations. Add a column to compute net income. Use this data to prepare a dashboard in Tableau. 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. Where do you recommend? Why? Consider the industry what other factors may be important to choosing a location? Discuss the reasoning for your selection and prove the logic of your recommendation. Prepare a succinct well organized 1-2 page memo (max 1000 words) to the client explaining your recommendation. Visually integrate results from your analysis into your memo. Provide proof and evidence to support your recommendation. Attach a pdf of the dashboard as an appendix to the memo as support. Grammar, spelling and punctuation will be considered in your grade. Deliverables: Memo with analysis, support and recommendation Dashboard prepared in Tableau – save and attach a PDF (NOT the Tableau file) This is an INDIVIDUAL project! (You may alternatively use Power BI instead of Tableau. However, Power BI is a windows application and does not work with mac os.)
