πŸ“Š
UMS + VGP Analytics
Management Command Center
Loading… β€”
πŸ“ˆ Financial β€” Today
πŸ’°
β€”
Revenue (Today)
β€”
πŸ“Š
β€”
Gross Margin
🏦
β€”
Cash Position (ARβˆ’AP)
β€”
⬆️
β€”
AR Outstanding
Receivable
⬇️
β€”
AP Pending
Payable
🧾
β€”
Invoices Finalized
Today
🏭 Operations β€” Live
πŸ“¦
β€”
Live SKUs
In System
πŸ—ƒοΈ
β€”
Units On Hand
Warehouse
πŸ›’
β€”
Units Sold (Today)
🚒
β€”
Containers Scanned
Today
⚠️
β€”
Match Exceptions
🚨
β€”
Fraud Alerts (High)
βœ… Task Board
πŸ“‹
β€”
Open Tasks
πŸ”΄
β€”
Overdue
⚑
β€”
Critical Priority
Urgent
βœ…
β€”
Done
πŸ“Œ
β€”
Backlog
Queued
πŸ“‰ 30-Day Trends
Cash Position (AR βˆ’ AP)
AP obligation building since Sep 10
β€”
Tasks by Department
Open count
🏒 Department Task Breakdown
DepartmentOpen TasksLoadType
Loading…
πŸ—ΊοΈ Analytics Project β€” Phase Tracker
PHASE 1
Master Tracker
βœ… Complete β€” 148 KPIs mapped
PHASE 2
VGP / UMS Split
βœ… Complete β€” Separated by company
PHASE 3
Data Dictionary
βœ… Complete β€” 124 KPIs defined
PHASE 4
Data Source Map
βœ… Complete β€” 70/15/39 coverage
PHASE 6
Live KPI Tracking
⬜ Pending
PHASE 7
Dept Scorecards
⬜ Pending
PHASE 8
Dashboards
⬜ Pending
PHASE 9+
Automation & Approval
⬜ Pending β€” $5K target
πŸ”Œ KPI Data Coverage β€” Phase 4 Results
70
βœ… Connected & Ready
Pulling live from ERP today
15
🟑 Manual / Partial
Data exists, process needed
39
πŸ”΄ Not Connected
eBay Β· Amazon Β· Shopify Β· Logistics
KPI Connection Progress β€” 124 Total KPIs 56% Ready
Connected (70) Manual/Partial (15) Not Connected (39)
🚧 Top Blockers β€” Action Required
Blocked AreaKPIs BlockedWhat's NeededOwner
eBay API 12 eBay OAuth credentials β†’ Seller Hub API access E-Commerce Team
Amazon SP-API 12 Amazon SP-API credentials β†’ IAM role + Seller Central E-Commerce Team
Shopify Admin API 12 Shopify API key/secret β†’ Admin API 2024-01 E-Commerce Team
Fuel & Mileage Log 3 Build driver daily log β€” Sheet column or ERP entry per driver Logistics / Ops
Driver Labor Cost 2 HR payroll export β€” wage per driver per period HR Team
Market Resale Price 2 Buyers enter expected resale price per SKU in ERP Purchasing Team