Consolidated data
LEAD TIME (PR → PO → GRPO) + realisasi, enriched with PO REPORT fields (currency, Lokal/Impor, vendor…) on the right · hover any column header (ⓘ) for its source · 13,431 row(s)
How the files are consolidated— click to expand
Report months follow the procurement cycle, not the calendar: report month M draws data from the 21st of (M-2) through the 20th of (M-1). For example January = 21 Nov–20 Dec, February = 21 Dec–20 Jan. KPI 1/2/3 window on PO date, KPI 4 on PR date, KPI 7 on vendor creation date.
LEAD TIME is the master sheet (PR → PO → GRPO, one row per PR-line, including PRs not yet converted to a PO). It sets the dashboard's date span, is KPI 4's denominator, and carries the goods-receipt detail: GR date and quantity, the ordered PO quantity, the PO Due Date (ETA), last/current price and PR→PO days.
PO REPORT enriches it with the PO detail that LEAD TIME lacks: the Lokal/Impor flag (the KPI 2 vs KPI 3 split), plus ETA, currency and unit price, joined on PO No.
VENDOR LIST is the vendor master; KPI 7 counts Active vendors whose creation date falls in the window (cumulative per year, target 6).
KPI 2/3 'received' logic is quantity-aware: a PO-item counts as received only when the running sum of GR quantities reaches the ordered quantity; the completion date (the GR that crosses the ordered qty) is compared to ETA + 7 days (Local) / 14 days (Import).
On import each file is upserted by its natural key, so re-uploading an updated export updates rows in place instead of duplicating them. KPI 5 (Quality) and 6 (Substitution) have no source in these files yet — they are seeded with best-case defaults so the scorecard is complete; replace those entries as real data arrives.
Realisasi here uses a 7-day tolerance (local). Each KPI's own formula is on its methodology page — click any KPI title on the dashboard.
| PR Noⓘ | PR Dateⓘ | Item Groupⓘ | Item Codeⓘ | Itemⓘ | Last POⓘ | Last Priceⓘ | PO Noⓘ | PO Date ▼ⓘ | ETAⓘ | ETA (PO Report)ⓘ | Qtyⓘ | Priceⓘ | PR→POⓘ | GRPO Noⓘ | GRPO Dateⓘ | PO→GRPOⓘ | Deadlineⓘ | Realisasiⓘ | L/Iⓘ | Currencyⓘ | Vendorⓘ | Vendor Codeⓘ | Status PRⓘ | Status POⓘ | Required Dateⓘ | Request Byⓘ | UoMⓘ | Total POⓘ | Outstandingⓘ | TOPⓘ | Remarksⓘ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 260400293 | 2026-04-20 | BAHAN PEMBANTU | 2045.0006 | PALLET EXPORT 95*110*13 CM | 260600112 | 77,000 | 260400382 | 2026-04-21 | 2026-05-04 | – | 1,000 | 74,000 | 1 | 260500422 | 2026-05-13 | 22 | 2026-05-11 | Late | – | – | – | – | – | – | – | – | – | – | – | – | – |
| 260400293 | 2026-04-20 | BAHAN PEMBANTU | 2045.0006 | PALLET EXPORT 95*110*13 CM | 260600112 | 77,000 | 260400382 | 2026-04-21 | 2026-05-04 | – | 1,000 | 74,000 | 1 | 260500471 | 2026-05-15 | 24 | 2026-05-11 | Late | – | – | – | – | – | – | – | – | – | – | – | – | – |
| 260400293 | 2026-04-20 | BAHAN PEMBANTU | 2045.0006 | PALLET EXPORT 95*110*13 CM | 260600112 | 77,000 | 260400382 | 2026-04-21 | 2026-05-04 | – | 1,000 | 74,000 | 1 | 260500541 | 2026-05-18 | 27 | 2026-05-11 | Late | – | – | – | – | – | – | – | – | – | – | – | – | – |
| 260400293 | 2026-04-20 | BAHAN PEMBANTU | 2045.0006 | PALLET EXPORT 95*110*13 CM | 260600112 | 77,000 | 260400382 | 2026-04-21 | 2026-05-04 | – | 1,000 | 74,000 | 1 | 260500875 | 2026-05-28 | 37 | 2026-05-11 | Late | – | – | – | – | – | – | – | – | – | – | – | – | – |
| 260400293 | 2026-04-20 | BAHAN PEMBANTU | 2045.0006 | PALLET EXPORT 95*110*13 CM | 260600112 | 77,000 | 260400382 | 2026-04-21 | 2026-05-04 | – | 1,000 | 74,000 | 1 | 260500790 | 2026-05-25 | 34 | 2026-05-11 | Late | – | – | – | – | – | – | – | – | – | – | – | – | – |
| 260400293 | 2026-04-20 | BAHAN PEMBANTU | 2045.0006 | PALLET EXPORT 95*110*13 CM | 260600112 | 77,000 | 260400382 | 2026-04-21 | 2026-05-04 | – | 1,000 | 74,000 | 1 | 260500728 | 2026-05-22 | 31 | 2026-05-11 | Late | – | – | – | – | – | – | – | – | – | – | – | – | – |
| 260400293 | 2026-04-20 | BAHAN PEMBANTU | 2045.0006 | PALLET EXPORT 95*110*13 CM | 260600112 | 77,000 | 260400382 | 2026-04-21 | 2026-05-04 | – | 1,000 | 74,000 | 1 | 260500584 | 2026-05-19 | 28 | 2026-05-11 | Late | – | – | – | – | – | – | – | – | – | – | – | – | – |
| 260410020 | 2026-04-08 | PERSEDIAAN UMUM | 6050.1715 | CUTTING WHEEL 7 INC | 260410120 | 9,909.91 | 260410120 | 2026-04-21 | 2026-04-21 | – | 60 | 9,909.91 | 13 | 260410434 | 2026-04-22 | 1 | 2026-04-28 | On time | – | – | – | – | – | – | – | – | – | – | – | – | – |
| 260410020 | 2026-04-08 | PERSEDIAAN UMUM | 6030.2884 | GERINDA TANGAN GA 7020 7INCH 2200W | 260410119 | 2,162,162.17 | 260410119 | 2026-04-21 | 2026-04-21 | – | 1 | 2,162,162.17 | 13 | 260410433 | 2026-04-22 | 1 | 2026-04-28 | On time | – | – | – | – | – | – | – | – | – | – | – | – | – |
| 260410020 | 2026-04-08 | PERSEDIAAN UMUM | 6050.0405 | GERINDA TANGAN 4 INCH MAKITA M0900B | 260410119 | 337,837.84 | 260410119 | 2026-04-21 | 2026-04-21 | – | 2 | 337,837.84 | 13 | 260410433 | 2026-04-22 | 1 | 2026-04-28 | On time | – | – | – | – | – | – | – | – | – | – | – | – | – |
| 260410045 | 2026-04-17 | PERSEDIAAN UMUM | 6030.2283 | BESI BETON POLOS U24 10MM SNI | 260610095 | 92,000 | 260410126 | 2026-04-21 | 2026-04-21 | – | 20 | 72,000 | 4 | 260410572 | 2026-04-30 | 9 | 2026-04-28 | Late | – | – | – | – | – | – | – | – | – | – | – | – | – |
| 260410051 | 2026-04-20 | BAHAN BAKU BODY | 1010.0045 | FELDSPAR LP-7 BATU max KA 10% | 260410230 | 470 | 260410127 | 2026-04-21 | 2026-04-21 | – | 35,000 | 310 | 1 | 260410503 | 2026-04-27 | 6 | 2026-04-28 | On time | – | – | – | – | – | – | – | – | – | – | – | – | – |
| 260410051 | 2026-04-20 | BAHAN BAKU BODY | 1010.0044 | FELDSPAR LP-1 CRUSHER max KA 10% | 260410230 | 510 | 260410127 | 2026-04-21 | 2026-04-21 | – | 35,000 | 330 | 1 | 260410504 | 2026-04-27 | 6 | 2026-04-28 | On time | – | – | – | – | – | – | – | – | – | – | – | – | – |
| 260410051 | 2026-04-20 | BAHAN BAKU BODY | 1010.0046 | FELDSPAR LP-L LAPUKAN max KA 10% | 260410127 | 300 | 260410127 | 2026-04-21 | 2026-04-21 | – | 35,000 | 300 | 1 | 260410505 | 2026-04-27 | 6 | 2026-04-28 | On time | – | – | – | – | – | – | – | – | – | – | – | – | – |
| 260410052 | 2026-04-20 | BAHAN BAKU GLAZE | 1030.0086 | TOP GLAZE KSG06 | 260610052 | 11,314.1 | 260410123 | 2026-04-21 | 2026-04-21 | – | 63,000 | 10,703.16 | 1 | – | – | – | 2026-04-28 | Overdue | – | – | – | – | – | – | – | – | – | – | – | – | – |
| 260410052 | 2026-04-20 | BAHAN BAKU GLAZE | 1020.0027 | ENGOBE GLAZE KSE04 | 260610052 | 8,399.05 | 260410123 | 2026-04-21 | 2026-04-21 | – | 54,000 | 7,945.52 | 1 | – | – | – | 2026-04-28 | Overdue | – | – | – | – | – | – | – | – | – | – | – | – | – |
| 260300407 | 2026-03-27 | PERSEDIAAN UMUM | 6030.2827 | SEKAT URINOIR | 260400343 | 950,000 | 260400343 | 2026-04-20 | 2026-04-20 | 2026-04-20 | 1 | 950,000 | 24 | 260500602 | 2026-05-19 | 29 | 2026-04-27 | Late | Lokal | IDR | CASH | S1102 | CLOSED | CLOSED | 2026-04-02 | Gita | SET | 950,000 | 0 | - Cash Basic - | KAMAR MANDI KANTOR LAMA |
| 260310014 | 2026-03-05 | SPAREPART | 5011.0566 | BEARING 7311ACM | 260410121 | 119,420 | 260410121 | 2026-04-20 | 2026-04-28 | 2026-04-28 | 30 | 119,420 | 46 | – | – | – | 2026-05-05 | Overdue | Lokal | IDR | ASIAN BEARINDO SEJAHTERA, PT. | S0908 | OPEN | OPEN | 2026-03-12 | Ibnu Darmawan | PCS | 3,582,600 | 30 | Net 30 | REFF : 042/PROD-PK02/III/2026 KEBUTUHAN BODY PREPARATION ATAS PERMINTAAN LIU AIWEN |
| 260310014 | 2026-03-05 | SPAREPART | 5011.0567 | BEARING NJ311EM | 260410121 | 1,013,370 | 260410121 | 2026-04-20 | 2026-04-28 | 2026-04-28 | 20 | 1,013,370 | 46 | – | – | – | 2026-05-05 | Overdue | Lokal | IDR | ASIAN BEARINDO SEJAHTERA, PT. | S0908 | OPEN | OPEN | 2026-03-12 | Ibnu Darmawan | PCS | 20,267,400 | 20 | Net 30 | REFF : 042/PROD-PK02/III/2026 KEBUTUHAN BODY PREPARATION ATAS PERMINTAAN LIU AIWEN |
| 260310018 | 2026-03-07 | PERSEDIAAN UMUM | 6050.0737 | LPG 12KG ( REFILL ) | 260610118 | 230,000 | 260410113 | 2026-04-20 | 2026-04-29 | 2026-04-29 | 1 | 205,000 | 44 | 260410442 | 2026-04-22 | 2 | 2026-05-06 | On time | Lokal | IDR | TOKO SURATNO | S1183 | OPEN | CLOSED | 2026-04-24 | Ibnu Darmawan | TABUNG | 410,000 | 0 | COD | REFF : KEBUTUHAN CONSUMABLE PK2, #PAYMENT MENGGUNAKAN PETTY CASH |