C generic logo company MEMORANDUM To: Junior Business Analyst From: Jamila Kanji, CEO Date: Week 6, 202x RE: Questions Junior Business Analyst: Our company is pleased to announce that we will be exploring a potential expansion strategy with cannabis retail locations. Review the dataset - you may want to build a spreadsheet for yourself (try a SparkLine) - and identify the best province or territory to open our first pilot cannabis retail location. 1. Review the consumption data set (2019) first and determine on this data alone which is the ideal location. (Hint: Think about how to effectively use all the data you have access to and what hypotheses could explain the data). 2. Now review the consumer/producer pricing data set from 2018. On this data alone, which province would be the most profitable? 3. Based on your answer to Question 2, would this change our location based on what you answered in Question 1? Why? (Hint: Consider how you might translate the information from Question 1 and Question 2 into estimated profit). 4. Lastly, review the consumption trends quarter over quarter from Q1 2018 to Q4 2019. What are the trends telling us and would we change our location based on trending information? Why? Please send me a memo (no more than two pages) in PDF format outlining your findings no later than 96 hours from now. I've provided a rubric on the assignment drop box which outlines more details about what I'm looking for. Regards, Jamila PS: How do you show trends and aggregated information easily? Do you have tools that make the information easier to interpret and understand?