Total value across all principals · last selected day
—
—
—
Daily Total Value — All Principals
Sum of SOH value across every principal for each day in the selected range.
Total Value per Principal
SOH value per principal on the last selected day, sorted largest first.
Daily Stock Movement
Line chart of daily SOH value. Pick a principal to focus.
Value Distribution per Principal
Each principal's share of total value on the last selected day.
— —
SOH Movement · Week-on-Week Per Product
SKU Performance Dashboard
Connecting to Google Sheets…
—
Period—
Stock Movement by Product Performance — Week on Week
Lines show SOH movement for each performance category from week to week.
SOH Current vs SOH After PO
Comparison of current SOH against projected SOH if a PO is placed that week, per performance category.
SOH CurrentSOH After PO
SOH Composition (latest week)
Distribution of stock across categories in the latest week.
DOI by category (latest week)
Days of Inventory — the higher it is, the longer stock sits idle.
Detail table — Week on Week
SOH per category per week, with Δ SOH showing the change from the previous week to the latest week.
Insights
Automatically generated from the selected principal's data.
—
SKU Detail
—
Data week —
SKU ranking
SKUs in this category ranked by SOH.
SKU detail table
All SKUs in this category. Click a column header to sort.
Insights
Automatically generated from the SKU-level data.
As of — Deadline 30 Sep 2026 · Targets: Slow ≤ 14 · Rat ≤ 10 DOI
Hyper-Monitor · Slow Moving & Rationalization
SKU DOI Burn-Down Monitor
Cadence
Update twice weekly (Data Lead — Mon & Thu): append this week's DOI to each SKU's history and refresh stock & velocity. Targets are fixed by policy: Slow = 14 days · Rationalization = 10 days by the deadline. Everything recalculates on save.
Period—
Daily movement · Rationalization & Slow moving
Total SKU and stock value per day, so the burn-down is visible as a curve — a falling line means we are clearing stock.
Summary by principal
SKU count and stock value at cost, for the SKUs matching the current filter
SKU burn-down by principal
Trend (solid) · projection at current velocity (dashed) · target (green line)
Escalations
Auto-generated from the burn-down rules
Projection logic: at current velocity and zero PO, DOI falls ~7 days per week; the dashed line shows that path to the deadline. Target pcs/day = stock ÷ target DOI — the pace that puts DOI on target straight away and clears the stock inside the target window (10 days rationalization · 14 days slow moving); the deadline plays no part in it. Uplift × answers the softer question — the velocity multiple needed to reach target DOI by the 30 Sep deadline (≤1.0 = on track at current pace), so it always reads lower than the Target pcs/day ask. Cash locked = value of stock above target level. Escalation rules: uplift > 2× → change mechanic (deeper discount / bundle / channel switch) within 7 days · zero velocity for 14 days → dead: principal return or write-off decision · rationalization SKU still above 10 DOI at deadline → auto-kill review · expiry < 6 months → overrides everything, move first.
As of — loading…
Loading · sell-in governance
PO Governance Dashboard
CADENCEWeekly update (Data Lead): refresh days elapsed, MTD sell-out, PO issued and DOI now in the data block — everything below recalculates automatically.
Brand heat map
Sell-out vs gate · DOI vs 30-day target · PO ceiling utilization
Brand
SO Target (Rp jt)
SO MTD
Ach vs Pace
Run-rate Needed
DOI (marker = 30D)
DOI Days
Max SI
PO Issued
Outstanding
Ceiling Used
Memuat data…
DOI bar scale 0–120 days; the green marker is the 30-day target. All values in Rp jt.
Active alerts
Auto-generated from the decision matrix
Rules: DOI > 45 = automatic PO stop · sell-out < 80% of run-rate = 48h corrective review ·
PO > Max Allowed = CEO signature only · cash variance > 5% = freeze non-critical purchases.
Source: July 2026 Strategic Operating Plan + Command Center workbook.
— Akun & hak akses
Administration · Users, roles and principal scope
User Management
AKSESRole menentukan halaman yang boleh dibuka; principal scope menentukan baris data yang
boleh dilihat. Keduanya ditegakkan di backend — menyembunyikan menu saja tidak membatasi apa pun.
Users
Ubah role, scope, atau reset password. Perubahan yang mempersempit akses langsung mengakhiri sesi user tersebut.
Audit trail
Siapa membuka endpoint apa, untuk principal mana, dan hasilnya. Termasuk percobaan yang ditolak.
memuat… Window 60 hari · sumber BigQuery
Bundle Recommendation · Slow Moving & Rasionalisasi → Fast Movers
Rekomendasi Bundle SKU
Sebaran rekomendasi per principal
Jumlah pasangan yang lolos uji, dipecah per kelas keputusan. Grafik ini sengaja
tidak ikut filter principal di atas — inilah peta untuk memilih principal-nya.
A · Dorong bundle yang sudah ada
0
B · Buat bundle baru
0
C · Uji dulu
0
Catatan
Hal-hal yang mengubah cara membaca daftar di atas.
Metode perhitungan
Bagaimana angka di atas dihitung, dan apa yang sengaja dibuang.
Semua ambang di bawah dibaca langsung dari query yang barusan dijalankan.