LeafLink Reports help cannabis procurement teams make informed purchasing decisions that increase margins and liquidity. The Replenishment Insights Report is designed for buyers that are purchasing inventory in bulk for multiple retail stores and buyers who are replenishing inventory at each retail location. This feature is available to customers who use our fulfillment for retail service in California and Michigan. If you don't have this feature, and want it, please contact your account manager or support@leaflink.com.
Use LeafLink's Replenishment Insights Report to Optimize Inventory
1. Login to LeafLink and tap on the Reports Menu.
2. Tap on the Replenishment Insights Report. You'll see four options in the top right corner: Warehouse Buyer, Warehouse Analysis, Store Buyer, and Stale Products.
3. Tap the view to see data relevant to your business objective.
The Warehouse Buyer View
The Warehouse Buyer view provides information about a retail store's upstream supply chain. It is designed for Warehouse Buyers, hence the name. Use this view to see how much working capital is tied up in inventory, days of inventory on hand, SKUs that are below par level, SKUs with more than 30 days of inventory on hand, and unit inventory totals.
Use the filters to find data of interest. You can filter by date, brand, product name, product category, license type, min days on hand, or safety stock days. Tap on the item to display the options. Click on them to select or deselect them.
Data is sourced from Metrc, LeafLink, and our WMS.
In the data rows, find details about a product's Projected out of Stock Date, Store Daily Demand, and the Suggested Warehouse Reorder in terms of cases. See how fast you can get the product from a vendor in the Average Vendor Lead Time column.
Tip: A good rule of thumb is to have a month's worth of inventory on hand at the warehouse. Provide yourself with a 10% buffer, if possible, of safety stock. Safety stock is how much inventory you'd need if there was an unexpected fluctuation in demand. We can help you plan. Just reach out to your account manager for a consultation!
The Warehouse Stats View
The data visualization on the left helps you visualize how much warehouse working capital is invested in products. See the dollar amount by category.
The visualization on the right can be tailored to your interests. The default view is to display the working capital, warehoused inventory, and top product categories. Tap on the pulldown menus above the visual to explore data visualization pairings.
The Store Buyer View
The Store Buyer view aggregates data about all your retail locations.
We pull data in from Metrc, which means the brand names will be what's on file with Metrc. (We're working on streamlining this.) The items will match the item name in Metrc.
This view contains a very similar data set to the Warehouse Buyer view. However, the data is at the store level. The data in this view helps buyers know how many cases to buy based on their projected out of stock date, and the product's demand.
Use the filters on the left side of the screen to see the data you need to succeed.
Note: If something hasn't moved at the warehouse or a store in the past 30 days, it is considered a stale product. Use that filter to find those products.
The default minimum days on hand setting is 28 days. We recommend keeping 7-10 days of inventory on hand per store. But, type the Min Days on Hand that aligns with your replenishment strategy into the Min Days on Hand field. That will adjust your data view.
Note: We do not automatically reorder products for customers. However, if you would like to receive an email alert when stock is low, let your account manager know. We can set this alert up for you.
Order Summary View
Finally the Order Summary view provides a comprehensive view of the inventory that is shipping from the Fulfillment Center to their retail stores. It provides customers with order level insights into the movement of goods to their stores, and which packages and batches are in shipped or delivered status. We think the most useful data for customers are the Batch IDs, Package Tags, and Expiration Dates. Use the filters to find the data you need to accomplish the task at hand.
We hope you enjoyed this introduction to our Replenishment Insights Report. If you have questions, or need help deciphering the data in this report, reach out to support@leaflink.com.