We've recently revamped our Par Levels Report to provide a more robust view of your inventory and offer strategic insights into managing orders and intake.
For a quick tutorial on how to run the Par Level Report, watch this video:
What is a Par Level?
A par level is the minimum quantity of a product that is in stock. This is a helpful tool for best-selling or high-selling products to ensure they remain in stock at all times. You can set par levels for individual products in Flowhub to track and manage your inventory.
How to Set Up a Par Level
Par levels are set at the product level in "Company Management." The par level feature is not available for flower inventory items.
Sign into Flowhub Classic, then select the small up arrow "^" next to your name on the left side of the navigation menu.
This will open up more menu options. Select "Manage" and then "Company Management."
"Products" is the first page under "Company Management." From here, you can search for a product to edit or choose to add a new product.
The par level can be set here by entering a quantity in the "Default Par Level" option field.
Click the "+ Add Another Location-based Par Level" to specify a par level for a specific location.
Once par levels and all relevant information has been added, choose to update/save the product.
How to Create Par Level Report
Once you've set your par levels, you can generate a Par Levels custom report to view your current inventory.
Sign into Flowhub Classic through the Google Chrome browser.
Select "Dashboards" from the left side of the navigation menu.
Click the "+" button in the upper right to add a new custom report.
Enter a name and description, and select "Par Levels" from the "Report Type" drop-down. Select "Next."
Note: The name and description are completely up to you. All custom reports will be specific to your Flowhub profile and will not be available for other users.
You'll notice the updated Par Level report offers new fields to select which we'll cover in more depth below. Select the fields you want in the report by checking the corresponding box.
Once done, select "Next."
Here you can select the filters for the report.
You should now see the report available to run in the "Reports" section of dashboards. This report can now be run or scheduled for delivery via email.
Description of Fields
The updated Par Levels report offers several new fields to assist with your inventory management and planning. The new fields are based on two specific time frames: 7 days and 30 days. This is designed to provide key insights into product activity over those time frames. Below are a few brief descriptions of how these fields are calculated and displayed on the report:
Average number of units per sale (7 or 30 days)
Equation: Number of units sold in the last 7 or 30 days divided by the number of transactions in the last 7 or 30 days.
Estimated days until par level will be reached (7 or 30 days)
Equation: Current Quantity minus Par Level divided by (Average number of units sold in the last 7 or 30 divided by 7 or 30).
Estimated days until zero quantity will be reached (7 or 30 days)
Equation: Current Quantity divided by (Average number of units sold in the last 7 or 30 days divided by 7 or 30).
Note: Accessories do not have package tags and will therefore not be included in the "Number of packages with inventory" field.
Blank or Negative Numbers?
You may find that certain fields show either blank or negative numbers when generating the report. A field will be blank if no activity took place within the 7 and 30-day time frames.
A field will be negative if a product's par level or current quantity has already been reached before the report is generated.
Scenario: An edible has a Current Quantity of 0 and a Par Level of 15. The product has sales that pre-date the 7 and 30 day time frames. The product reached its par level and zero quantity before the 7 and 30-day timeframes.
The Current Quantity - Par Level field will display -15 as it's 15 below the set par level.
The "Number of units sold," "Average number of units sold," "Date reached par level," and "Date reached zero quantity" will all be blank as no activity took place during those time frames.
The "Estimated days until par level/zero quantity" fields will display a negative number. This is to show how far back in time the product reached those fields. This allows you to have a better understanding of products that need to be focused on more and ordered more frequently.