Bisatumbuh SOH & PO Performance

Sign in to open the dashboard

Internal use only · BisaTumbuh Distribution
bisatumbuh

Command Center · Historical Stock-On-Hand

SOH Command Center

Connecting to Google Sheets…
Period
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.
bisatumbuh

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 Current SOH 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.
BisaTumbuh Inventory Dashboard · Live from Google Sheet "All Principal" (columns A–L) · BisaTumbuh brand color guideline

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.
bisatumbuh
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.
bisatumbuh
As of —
loading…
Loading · sell-in governance

PO Governance Dashboard

CADENCE Weekly 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.
bisatumbuh

Akun & hak akses
Administration · Users, roles and principal scope

User Management

AKSES Role 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.
bisatumbuh
memuat…
Window 60 hari · sumber BigQuery
Bundle Recommendation · Slow Moving & Rasionalisasi → Fast Movers

Rekomendasi Bundle SKU

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.