For my first High Intelligence blog posting, I’m going to focus on some data found in the WSLCB Traceability database that I’ve used to estimate the level of retail markup across the State. My thanks to David Busby of WeedTraQR for helping me to correctly extract the underlying data (David’s a good guy, and very talented. He’s also based locally and provides great customer service – unlike some other traceability vendors. Go WeedTraQR! … Go Hawks!)
As you may know, I’ve been banging my head against the WSLCB Traceability database for the better part of 7 months and have only had limited success in getting the data it apparently contains into a form where useful analytic work could be done.
Will and the Cannabis Transparency Project team that Dr. Corva put together initially whetted my analytic appetite by cracking the lab test result data into a form that allowed comparison across the labs. In the meantime, my efforts to create a useful form of sales- data out of the database have been consistently frustrated. Shortly after a brief meeting with David & Eric from WeedTraQR, an elegant piece of SQL came my way that ended that frustration. Thank-you, David!
What follows is a brief summary of some work I’ve done using Busby-enabled-data from the first 12 months of the market (through July 31, 2015) showing the variability of retail markups across the State.
Let me start with defining “Markup”. There seems to be a good deal of confusion over what one means when one says “markup”.
What I mean in this blog (and generally) when I say “markup” is the following:
Markup = (Retail Price – Wholesale Price) / (Wholesale Price) … (ignoring all taxes)
(and 1 + Markup = the retail sales “multiplier”)
In English, if a store buys a gram for $4.33 and sells it for $10.00, that would be considered to be a markup of 1.31 (or 131%). This means that the retail store is selling the product for 2.31 TIMES what they paid for the product at wholesale (or their pre-tax “gain” is 1.31 times the amount they paid for the product). This “gain” ignores all taxes and all of the other costs of doing business such as lease, utilities, wages, etc.
I use this example because, across all stores and across all counties for the entire time period through July 31 of this year (the first 12 full months of the I-502 market), this is the actual overall State-wide markup that occurred. The average Retailer across that time, on average, charged $10.00 (pre-tax) to the customer for every $4.33 they paid to their processor(s).
This is across all product types (flower, extracts for inhalation, solid & liquid medibles and topicals) and just does a brute-force totaling of all wholesale purchases by retail and all retail sales by retail. It does not take into account different product turnover times across stores or product lines or, really, any of the many relevant factors. It is just a brute-force overall calculation.
What is interesting here is that, with the average Retail markup at 131%, it is not uncommon to see overall markup levels in excess of 200% at the individual store level. On the other hand, there are quite a few stores that have overall markups of less than 100% (e.g., the processor is grossing more from the product than the retailer is, when you subtract their cost for the product).
At the county level, there are 6 counties with average markups over 150%, while there are 7 with average markups that are below 100%. The following map displays markups summarized at the county level (red being high markups, and green being low markups).
I’ll let the interested reader peruse this for deeper insight, and I welcome any thoughts you wish to share.
I will, however, comment that is nice to see that it seems to be, differentially, Oregonians, Idahoers, and British Columbians that have been supporting the higher-than-average retail markups in our fair State. Our islanders and rain-forest dwellers also appear to be getting some very good deals from their local retailers.
I’ll also comment on the swatch of “no retail data” that exists in the Eastern third of the State. For areas that grow as much State-legal Cannabis as those counties are growing, it seems rather odd that they don’t have a single functioning retail store 13 months after the market opened.
I’d appreciate hearing what you think about this … and hope you’ll stop back this Friday, when I expect to post a chart that shows INDIVIDUAL STORE-LEVEL markup data. The variability across stores is amazing (as it is across product types).
I’ll try to respond to comments promptly (if I can get them working, that is).