Using the Cost Explorer

Created by Kylah Brown, Modified on Thu, 11 Jun at 4:00 PM by Kylah Brown

Analytics Guide

Using the Cost Explorer

Before you begin: The Cost Explorer is found under Tools in the left navigation. Every figure is pulled from the batch and inventory data you already have in Hashio, so the more accurate your batches and yields are, the more accurate your costs will be. Nothing here changes your data unless you choose to edit a cost or correct a yield, which is covered near the end of this guide.

What Is the Cost Explorer?

The Cost Explorer is one place to see what it costs you to make your products and what your current inventory is worth. It pulls those numbers straight from your batches, yields, and vault items, so you can spot trends, compare time periods, and find the products that cost the most to produce.

It is also a powerful auditing tool. Almost every number you see links back to the exact batch or vault tag it came from, so you can trace a surprising cost to its source and fix the underlying data in real time, without ever leaving the page.

With the Cost Explorer you can:

See your average cost per unit, broken down into material, labor, and allocated (overhead) costs
Compare what you are producing now against an earlier time period
Check the value of everything sitting in your vault as of any date
Drill into a single product to see the batches, yields, and packages behind it
Spot batches or tags with costs that look off, and correct them at the source

Two Ways to View Your Costs

At the top right of the page you choose between two modes. They share the same filters and grouping, but they answer different questions.

Cost to Produce shows what it cost to make product over a date range you choose (a From and a To date). Use it to understand your production costs and how they are trending. This mode also lets you compare against a prior period.

Sitting Inventory shows the value of everything currently in your vault as of a single date. Use it for a point-in-time snapshot of what your inventory is worth.

Tip: Switching modes keeps your filters and grouping in place, so you can flip between “what did it cost to make” and “what is it worth now” without starting over.

Setting Up Your View

Use the controls at the top of the page to focus the Cost Explorer on exactly what you want to see.

Step 1 Open the Cost Explorer

In the left navigation, under Tools, click Cost Explorer.
At the top right, choose your mode: Cost to Produce or Sitting Inventory.

Step 2 Choose your date

In Cost to Produce, set the From and To dates to cover the production period you want to review.
In Sitting Inventory, set the As of date to value your vault as it stood on that day.

Tip: pick the first and last day of a month to review a full month of production.

Step 3 Narrow it down with filters

Click Filters.
Search and select any combination of Product Group, Product, License, Category, Subcategory, or METRC Category.
At the bottom, use the two checkboxes: Include $0 cost items (off by default) and Include items with no yield (on by default).
Click Clear All to reset every filter.

The same filters apply to both Cost to Produce and Sitting Inventory.

Step 4 Group your results

Your results start grouped by Product Group. You can add more groupings to slice the data however you like.

Click the + next to the Group by area.
Choose a dimension to add: Product, Category, METRC Category, Brand, Strain, License, Location, or Batch.
Click Clear to remove all groupings.

Adding Product, for example, expands each group so you can see the individual products inside it.

Step 5 Compare to a prior period (Cost to Produce only)

Turn on the Compare to prior period toggle at the top right.
Hashio automatically compares your selected range to the period right before it and shows you the dates it used.
Percentage changes appear on both the summary cards and each row in the table, so you can see at a glance what went up or down.

This toggle is only available in Cost to Produce. Sitting Inventory is always a single point in time.

Reading the Summary and Table

Across the top you will see four summary cards that total up everything in your current view:

Total Units — the total combined quantity of everything currently in view.
Total Cost (Cost to Produce) or Total Value (Sitting Inventory), with the number of packages shown underneath.
Avg $/Unit — the average cost to make one unit.
Batches — the number of batches, with a quick material / labor / allocated breakdown.

Tip: Total Units adds up every unit in your current view, even when products are measured in different ways (grams, each, pounds, and so on). The more you filter or group your data — ideally down to a single product or unit of measure — the more meaningful this number becomes.

The table below breaks the same information down by whatever you have grouped on. Here is what each column means:

Column	What it tells you
# Packages	How many vault packages are included.
# Batches	How many production batches contributed.
Units	The total quantity (for example, grams or each).
Avg $/Unit	The average cost to produce one unit.
Material $/Unit	The material (input) portion of that cost.
Labor $/Unit	The labor portion of that cost.
Allocated $/Unit	Any overhead spread across the units.
Wholesale	The wholesale price set on the product, when one is set.
Margin %	Your margin, shown when a wholesale price is set.
Total Cost	The total cost (or value) for that row.

Tip: Click any column header to sort by it — handy for finding your highest-cost products or your best margins. The Total Cost column sits at the far right, so scroll right if you don’t see it.

Digging Into the Details

To go deeper, click any row in the table. A detail panel opens on the right with everything behind that number. This is where the Cost Explorer becomes an auditing tool: almost everything in the panel links back to where the data lives in Hashio.

Here is what each part of the panel does:

Insights views

Near the top, an Insights area lets you switch between views — Cost over time, Product mix, By product, and Material vs Labor — so you can look at the same data whichever way is most useful. You will also see the cost breakdown for your selection and a note about how many packages have a yield.

Products in the group

When you have grouped by Product Group on its own, the panel summarizes the whole group and lists the individual products in that group. Click any product in that list to open a second panel focused on just that product. (If you have also grouped by Product, clicking a product row opens that product’s panel directly.)

Materials breakdown

The Materials section shows what actually went into making the product.

Group it by Category (the default) or by Material to see the individual inputs.
Switch between Table, Pie, and Bar views. The Bar view can show Total Cost, Quantity, or # Batches.

This makes it easy to see which materials are driving the cost of a product.

Batches, Yields & Vault tabs

These tabs let you trace the numbers all the way down to their source:

Batches & Yields — these two tabs show the same work from different angles. Batches lists each production batch with its cost per unit and a status badge; Yields lists every tagged yield of this product with its amount and cost per unit. In either tab, click a batch — in Yields it is the blue link in the Batch column — to open the same Batch Detail window.
Vault — the individual package tags, with units, cost per unit, and total cost. Greyed-out tags are no longer active. In Sitting Inventory, only active tags appear.

Auditing and Correcting Your Data

Because every figure links back to its source, the Cost Explorer is a fast way to catch and fix data issues.

Spotting outliers. On the Batches tab, each batch shows a badge such as “1.9× median” or “3.2× median.” This compares that batch’s cost per unit to the typical (median) batch for the product. A batch far above or below the median is worth a closer look — it often points to a yield or a cost that was entered incorrectly. You may also see a flag like “No labor logged,” which points out a batch that is missing its labor costs.

Step 6 Look inside a batch

On the Batches tab, click a batch to open its Batch Detail window.
Review the cost breakdown — the material consumed, the labor cost, and the total — along with the yields the batch produced.
Click Open batch to open the full batch page in a new tab if you need to make changes there.

Step 7 Trace and correct a vault tag

Open the Vault tab and click a tag to open its detail window.
Review How this got its cost. This shows the batch the tag came from and how its cost splits between material, labor, and allocated.
To fix a yield amount that was entered on the batch, find it under Yielded from and click Correct, then update the amount (and, optionally, set a fixed cost).
To change the tag’s cost directly, use the Edit Unit Cost section near the bottom.
Click Open to open the tag’s full page in the vault.

Tip: Correcting a yield or editing a unit cost updates that tag and automatically flows the new cost down to any related (child) tags. Because this changes your data, double-check the number before you save.

Exporting Your View

Step 8 Export to Excel

Set up the view you want — mode, dates, filters, and grouping.
Click Export at the top right of the table.
Hashio downloads an Excel file that matches exactly what is on screen, including a header row that notes the mode, the date range, and the grouping you used.

The export captures the main table only (not the detail panel) and uses full, unrounded numbers.

That is the Cost Explorer. Start with the summary cards to see what stands out, then click into any row to trace the number all the way back to its source — and correct it on the spot when something looks off.

Related guides:

Converting Items in the Vault (Coming Soon)
Understanding the Product Detail Page (Coming Soon)
Building and Using Dashboards