Executive Overview
May 2026 · MTD · Synced 2 min ago
Tap any card to open its tab
Store Tiers —
| # | Store | District | GM | Last Mo | This Mo | Tier | Trend |
|---|
Pace to Goal
—
on track
Projected vs Goal
—
month-close projection
Supplier Balance Due
—
outstanding
Next Meeting
—
System Health —
→ System Health
Checking endpoints…
Store Visits —
→ Store Visits
Loading visits…
Products to Fix COST · RETAIL · BRAND
→ Product Cost
Loading product data…
All Entities —
→ All Entities Details
Loading entities…
New Stores Opening 2026
→ New Locations
Loading…
Disposables · Last 3 Months UNITS · TOP BRANDS
→ Nic Disposables
Loading disposables…
Net Revenue (VC) vs Purchases (SI) LAST 6 MONTHS
purchases = SI sales · $M
This Month at a Glance —
→ Daily Pulse
Top Earners 2026 · TOP 20
→ Payroll tab
Top Categories —
→ Product Mix
Annual Revenue 2026 → 2020 · with monthly by year
Latest Week Payroll
→ Payroll tab
Revenue Trend MONTHLY
Top Locations MTD · TOP 30
→ Locations tab
| # | Store | Net Sales | Purchase | Gross Profit | Margin | Trans. | Trend 6mo |
|---|
6-Month Movers ALL STORES · LAST 3 MO vs PRIOR 3 · tap a store → Store Trend
Loading store sales…
District Performance MTD · YTD · YoY
Delta & Kratom · Last 3 Months UNITS · TOP BRANDS
→ Delta & Kratom
Loading…
CBD Additives · Last 3 Months UNITS · TOP BRANDS
→ CBD Additives
Loading…
Product Mix · Top Categories TOP 5
→ Other Mix Products
Loading…
Bonus · Stores Hit Goal LAST 6 MONTHS
→ Bonus
Loading…
Store Turnover · Net Sale by District LAST 6 MONTHS
→ Districts
Loading…
Daily Performance
May 2026 DAILY NET SALE
● HIGH
● AVG
● LOW
CURRENT MONTH SALE
$5.070M
15 of 31 days · May 2026
PROJECTED EOM
$11.220M
end-of-month estimate
vs LAST MONTH
—
comparison loading…
▲ BEST DAY
$451.6K
May 1 · Friday
▼ LOWEST DAY
$319.0K
May 5 · Tuesday
PER-STORE AVG (TREND)
$48.6K
181 locations · projected EOM
▲ HIGHEST PER-STORE
—
all-time best month
PER-STORE DAILY AVG
$2,026
per location · per day
▲ HIGHEST DAILY AVG
—
all-time best
Monthly Sales Comparison
3M
6M
9M
12M
All-Time Records
SINCE JAN 2024
▲ TOP 6 MONTHS
▲ TOP 6 DAYS
💡 Click any day to see all same-weekday sales from last 3–6 months →
Day-of-Week Breakdown
SAT
3M
6M
9M
12M
▲ HIGHEST
—
—
▼ LOWEST
—
—
All SAT's · -- dates · 6M
DATE · AMOUNT
Top 30 Locations —
SINGLE-DAY SALES · RANKED 1–30
Top 30 Locations —
SINGLE-DAY SALES · RANKED 1–30
Location Performance
— locations · vs last year
Location Sales Lookup MONTH-BY-MONTH · 2022 → NOW
Top 30 Performers
▲ GROWING
YoY %
Bottom 30 Underperformers
▼ DECLINING
YoY %
— = no prior-year baseline (opened in 2026)
Goal Tracking —
✓ TRENDING TO HIT GOAL
#STORESALESPREDGOALTREND
#STORESALESPREDGOALTREND
STORES 1–100
#STORESALESPREDGOALTREND
STORES 101–181
#STORESALESPREDGOALTREND
Store Tiers
— stores · tier by last complete month
Tier Roster —
TIER = last full month · TREND = current-month projection
| # | Store | District | GM | DM | Eff. Mgr | Last Month | This Month | Tier | Current Trend |
|---|---|---|---|---|---|---|---|---|---|
| Loading store tiers… | |||||||||
Product Performance
LAST 6 MONTHS
LAST 12 MONTHS
Disposables
Delta & Kratom
CBD Additive
Brand Lookup UNIT SALES BY MONTH
TOTAL UNITS SOLD
—
last 6 months
AVG PER MONTH
—
across 6 months
AVG PER DAY
—
daily average
Disposables Monthly Trend 6 MONTHS
DATE RANGE · UNITS · DAILY AVG
Top 30 Brands BY UNITS
SHOWING: —
UNITS · /DAY · % OF MONTH
Monthly Rankings ALL DISPOSABLES · AS ON SHEET
Each column = one month, full ranked product list · scroll →
Payroll & Operations
Weekly tracking · Week-over-Week comparison
Employee Lookup NAME OR COMPANY ID
MONTHLY
YEARLY
MONTH TOTAL
—
— weeks
AVG / WEEK
—
weekly average
▲ HIGHEST WEEK
—
—
▼ LOWEST WEEK
—
—
PAYROLL % OF REV
—
location revenue only
ACTIVE EMPLOYEES · 2026
—
EMPLOYEE GROSS · YTD
—
AVG WEEKLY PAY
—
CASH PAYROLL
—
Weekly Payroll MAY 2026
▲ UP vs prev wk
▼ DOWN vs prev wk
Pay week runs Wed→Tue · released Friday
Top Earners 2026 · YTD
10
30
60
100
All
All Entity Payroll MAY 2026
CURRENT WK
WK 1
WK 2
WK 3
WK 4
WK 5
CURRENT MONTH
3M
6M
9M
12M
TOTAL PAYROLL—
Pay Spikes — flagged
latest wk vs avg ≥
10%
20%
30%
40%
50%
CUSTOM
Payroll · Year over Year YEARLY
Same week number each year · "st" = locations reporting that week · helps read payroll vs location count
Bonus & Targets
Loading bonus data…
Payout Tier Breakdown —
STORES PER TIER
Net Sales vs Goal —
Year-by-Year —
Year-over-Year Comparison
FY2025 vs FY2026
New-Store Openings by month · region
Loading…
Record Months 31-day normalized
Loading…
Record Days single-day highs
Loading…
Per-Location Avg best months
Loading…
Monthly Revenue 2020 → 2026 · $M
tap a year in legend to toggle
Annual Revenue 2026 → 2020
Disposables units share
Delta & Kratom units share
CBD Additive units share
Other Products all other categories
Transaction Comparison
Same-day, week-over-week · by district
Loading…
Executive Scorecard
Company health at a glance — graded from live signals
Location Pulse
Loading…
All Locations BY NET SALE
Select a location
MONTH
3M
6M
9M
12M
—
P&L Waterfall
Key Metrics & Unit Economics
Per-Day Average Sales CURRENT + LAST 2 MONTHS
Month-by-Month P&L BY MONTH · day-range shown
Monthly Trend NET SALE & GROSS PROFIT · $
Category Mix —
Product Mix
Loading…
Location → Its Mix SEARCH A STORE
MONTH
3M
6M
9M
12M
Search a location to see its category breakdown.
Category → Top Locations SEARCH A CATEGORY
MONTH
3M
6M
9M
12M
Search a category to see the top locations driving it.
Category Leaderboard —
#CATEGORYREVENUE
MoM
Category Trend —
REVENUE
UNITS
Tap a category on the left to chart it · months with no data are skipped (CBD starts Apr)
Monthly Category Report REVENUE
3M
6M
9M
12M
REVENUE
UNITS
Each column = one month · sorted by total over the window · scroll →
Monthly Category Detail UNITS & REVENUE
—
To-Do & Action Items 0 open
My Calendar DEMO
Meetings & schedule
Supplier & Purchase
Yearly supplier purchases
Total Purchases
—
Paid
—
Balance Due
—
this year
Balance Forward
—
prior years
Grand Balance Due
—
total open
Suppliers
—
vendors
| # | Supplier | No. of Purchases | Grand Total | Paid | Balance Due |
|---|---|---|---|---|---|
| Loading… | |||||
Team
GMs & DMs · district-wise
| Loading… |
All Employees BY YEAR
Loading employees…
Surveillance
Google Nest camera directory · which account opens each store
Loading surveillance directory…
VC Operations
🏬
VC Ops Hub
ops.vapecity.us ↗
Live Reporting Tracker — Store Visit / Packing / Day End, hours & day-offs by district.
Loading Track Record…
Store Visits
Field visits by person · month-wise
Total Visits
—
This Month
—
Active Visitors
—
Stores Covered
—
Visits by Person — active this year, A–Z · tap a name to see their stores
| Loading… |
Recent Activity
Loading…
Visitor × Month
| Loading… |
District Performance
Jan → date · by month
| Loading… |
5-Year YTD by District
YTD Jan → date · 2022–2026 · YoY
Entities
Multi-company · demo — sheets connect one by one
Chairman AI CHECKING…
Ask about your numbers · powered by Claude · read-only
Notes & Suggestions auto
Open this tab to generate observations…
Ask the Chairman AI
Ask anything about the dashboard — e.g. “Which suppliers have the biggest balance due?” or “How is May tracking vs goal?”
Chairman's Notes of the Day write · voice · search
Note
Saved Daily Notes
Open this tab to load notes…
Meeting Notes record · transcribe · summarize
Transcript / Notes
AI Summary
Record or paste notes, then click Summarize — you'll get a summary, key decisions, and action items.
Recent Saved Notes
Open this tab to load saved notes…
Stores Directory
Loading locations…
All Locations
New Locations to Open
Locations Permits Update
Location Weekly Hours
| Loading… |
| Loading… |
Expired
≤30 days
≤90 days
Valid
| Loading… |
| Loading… |
Close Stores
Closed locations · pull-inventory log
Loading closed stores…
Store Tasks
Task responses · District Routes sheet
Store Map
Pick a district to plot its stores. Each pin shows the store name; click for address & map links.
Lightspeed
Lightspeed Retail (X-Series) · opens in a new tab. Sign in with your own Lightspeed username & password — the dashboard never stores it.
▶ Open Lightspeed
Dashboard Health
Endpoint status & sync
—
Data Sources sheets & connections