Forum Diskusi dan Komunitas Online

We’re getting to the point where looking only at total sales across multiple dispensary locations doesn’t really tell us which stores are actually performing well. One location can bring in more revenue but also run heavier discounts, hold too much inventory, or operate at a lower margin than a smaller store.
While comparing different reporting setups, I came across IndicaOnline POS, and it made me think more about what owners should actually be comparing between locations. Sales are easy to see, but profit seems much harder to understand once several stores, product mixes, promotions, and operating costs are involved.
The question that concerns me most
How do you know whether a high-revenue dispensary is actually more profitable than the other locations?
For example, Store A might generate $120,000 in weekly sales while Store B generates $95,000. At first glance Store A looks stronger.
But what if Store A is:

• discounting much more aggressively;
  
• carrying slower-moving inventory;
  
• selling more low-margin products;
  
• processing more refunds;
  
• using more labor to generate those sales?
  

In that case, sales alone could give a pretty misleading picture.
What I’m trying to compare each week
Ideally, I’d like one dashboard where an owner can compare the same KPIs across every location:

1. Revenue by store
   
2. Gross profit and gross margin
   
3. Average ticket
   
4. Number of transactions
   
5. Discount percentage
   
6. Product and category margin
   
7. Inventory turnover
   
8. Aging or slow-moving inventory
   
9. Refunds and voids
   
10. Week-over-week profit trends
    

The important part for me is being able to start with the company-wide picture and then drill down into one location when something looks unusual.
Discounts make the comparison more complicated
This is probably one of the biggest issues.
A store can show strong revenue because it runs frequent promotions, but that doesn’t necessarily mean those promotions are helping the business.
I’d want to see things like:

• gross sales before discounts;
  
• total discount value;
  
• revenue after discounts;
  
• margin after promotions;
  
• which products are being discounted most often.
  

That would make it easier to tell whether a location is genuinely performing better or simply selling more because prices are lower.
Inventory seems just as important as sales
Another thing I don’t think owners can ignore is how much money is sitting in inventory.
A store may look profitable on a sales report while holding a large amount of product that barely moves.
So I’d also want to compare:

• inventory value by location;
  
• sell-through rate;
  
• days of inventory on hand;
  
• slow-moving products;
  
• frequent stockouts;
  
• product categories tying up the most cash.
  

If one store is doing $100k in sales with lean inventory while another needs twice as much stock to produce similar revenue, that seems like something an owner should know.
Product mix can distort the numbers too
Different stores may sell completely different combinations of products.
One location might sell a lot of high-volume, low-margin items. Another might sell fewer units but make a stronger margin on each transaction.
That makes me think product-level reporting is almost as important as store-level reporting.
It would be useful to compare:

• sales by category;
  
• margin by category;
  
• best-selling SKUs;
  
• highest-margin products;
  
• slow-moving inventory;
  
• products that depend heavily on discounts.
  

Multi-location reporting is where this gets difficult
With two stores, you can probably still compare reports manually.
With five, ten, or more locations, I imagine spreadsheets become a problem pretty quickly.
The reporting system needs to use the same definitions for every store. Revenue, discounts, margin, inventory, and transactions all have to be calculated consistently or the comparison doesn’t really mean anything.
What I’m trying to avoid is a setup where every store has its own reports and somebody at head office spends hours combining everything before the numbers can be compared.
What I’d want from an owner dashboard
At a minimum:

• one view for the entire business;
  
• individual location reporting;
  
• consistent KPIs across stores;
  
• margin alongside revenue;
  
• product and category profitability;
  
• discount tracking;
  
• inventory performance;
  
• historical trends.
  

The dashboard doesn’t need hundreds of charts. It just needs to make differences between locations easy to notice.
The main thing I’m trying to figure out
For anyone operating several dispensaries, what KPIs have actually helped you understand which locations are profitable?
Do you mainly watch revenue and gross margin, or have inventory turnover, discount percentage, product mix, and other numbers turned out to be just as important?
And once you get beyond three or four stores, are you able to track all of this from one dashboard, or do you still end up exporting everything into spreadsheets to understand the real profit by location