To: Junior Business Analyst From: Jamila Kanji, CEO Date: Week 6, 202x RE: Questions Junior Business...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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? 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? 3. 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? 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? 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? 3. 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?
Expert Answer:
Answer rating: 100% (QA)
The trends and aggregated information must be shown in a... View the full answer
Related Book For
Posted Date:
Students also viewed these operating system questions
-
Based on your answer to question 4, should Mesa consider hedging its exchange rate risk? If so, explain how it could hedge using forward contracts, futures contracts, and currency options.
-
Based on your answer to question 2, how would the marketing actions differ for each product and the classification to which you assigned it? Question 2, Are Nature Valley Granola bars and Eddie Bauer...
-
Based on your answer to Question 5-17, if Pennsylvania's government aims to correct the steel market's negative externality via an effluent fee, is the appropriate fee higher or lower now that steel...
-
In Exercises 3538, evaluate C F dr. F(x, y, z) = xi + yj + zk C: r(t) = 2 cos ti + 2 sin tj + tk, 0t 2
-
If a firm drops a product line, it will lose the revenue from that product. This loss is controllable and direct with respect to the decision to keep or drop the product. Dropping a product might...
-
Should something that has such a large impact on the economy as monetary policy be handed over to a central bank rather than decided by elected politicians? Central banks control short-term interest...
-
In a test of homogeneity, the alternate hypothesis says that the distributions in the rows are the same. In Exercises 68, determine whether the statement is true or false. If the statement is false,...
-
The comparative balance sheets of Susan Saboda Design Studio, Inc., at June 30, 2012 and 2011, and transaction data for fiscal 2012, are as follows: Transaction data for the year ended June 30, 2012,...
-
Why do you think Fink has made this written announcement declaring BlackRock's view on linking purpose to profits? (on the page 10 of case)...
-
The Davis Lamp Company (DLC) is a wholesale company that purchases lamps from the manufacturer and resells them to retail stores. The company has three inventory items: desk lamps, table lamps, and...
-
Describe how the male role has changed since the 1950s. Discuss gender expectations today.
-
At what pressure will water boil at $65^{\circ} \mathrm{C}$ ? The vapor pressure of water can be determined from the Antoine equation: \[\frac{P(P a)}{1 \times...
-
Eyeglass lenses made of crown glass \((n=1.52)\) are given a thin coating of magnesium fluoride \((n=1.38)\) to minimize reflection of light from the lens surface. What is the minimum coating...
-
In Figure P1.8, atmospheric pressure is $101.3 \mathrm{kPa}$, the pressure gauge atop the tank reads $42 \mathrm{kPa}$ above atmospheric, and the vapor pressure of water at the temperature of the...
-
The U2 spy plane was designed to fly at altitudes of up to $21,000 \mathrm{~m}$. Its wing span was so large that special wheels were incorporated within the wings to keep them from scraping the...
-
An atmospheric inversion has taken place such that the temperature at the surface is $5^{\circ} \mathrm{C}$ while the temperature at $4,000 \mathrm{~m}$ is a balmy $20^{\circ} \mathrm{C}$. Assuming a...
-
Consider the following scenario, assuming Mobile IP and IP version 4. A mobile host (MH) has a home address of 71.13.204.20; the address space for its home network is 71.13.204.0/24 and the home...
-
What are the 5 Cs of marketing channel structure?
-
Tailor Ltd. is seeking to expand its share of the pet care market and has negotiated to acquire the operations of Flathead Ltd. and the shares of Flexon Ltd. At January 1, 2013, the trial balances of...
-
On December 1, 2013, Mayberry Inc. purchased inventory on account from a U.S. supplier for U.S. $40,000 when the exchange rate was U.S. $1 = C$0.97. The inventory was still on hand at Mayberrys year...
-
Lachlan Corp. establishes Serouya Ltd. for the sole purpose of developing a new product to be manufactured and marketed by Lachlan. Lachlan engages Mr. Jiang to lead the team to develop the new...
-
Which do you mean by a static force?
-
The lengths of crank and connecting rod of a slider crank mechanism are \(40 \mathrm{~mm}\) and \(100 \mathrm{~mm}\), respectively. It is subjected to piston force of \(2000 \mathrm{~N}\). Determine...
-
A four-bar mechanism is loaded as shown in Fig.11.36. \(A B=C D=300 \mathrm{~mm}\). \(B C=250 \mathrm{~mm}, A E=C G=150 \mathrm{~mm}, B F=100 \mathrm{~mm}, A D=500 \mathrm{~mm}\) Determine the...
Study smarter with the SolutionInn App