Merged data
The merged procurement sheet (PR → PO → GRPO) with the realisasi status used by KPI 2/3 · 13,488 row(s)
How the three files are consolidated— click to expand
Three SAP exports are combined. The SPINE is PR TO PO TO GRPO — the master PR list (one row per PR-item, including PRs not yet converted to a PO). It sets the dashboard's date span and is KPI 4's denominator.
PO.csv enriches it with the PO details that only it carries: the Lokal/Impor flag (the KPI 2 vs KPI 3 split), the ETA, currency and unit price, joined on PO No.
LEAD TIME PR TO GR adds the goods-receipt detail: one row per GR with its date and quantity, plus the ordered PO quantity, last/current price and PR→PO days. This is what makes the quantity-aware completion possible.
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), 6 (Substitution) and 7 (New Vendor) 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 | Qty | Price | PR→PO | GRPO No | GRPO Date | PO→GRPO | Deadline | Realisasi |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 251110101 | 2025-11-29 | PERSEDIAAN UMUM | 6030.2437 | WIREMESH M8 (7.7) LS | 251210006 | 531,531.53 | 251210006 | 2025-12-01 | 2025-12-01 | 1,555 | 531,531.53 | 2 | – | – | – | 2025-12-08 | Overdue |
| 251110101 | 2025-11-29 | PERSEDIAAN UMUM | 6030.2439 | PLAT HITAM 9 MM | 251210006 | 2,005,181.91 | 251210006 | 2025-12-01 | 2025-12-01 | 5 | 2,005,181.91 | 2 | – | – | – | 2025-12-08 | Overdue |
| 251110101 | 2025-11-29 | PERSEDIAAN UMUM | 6030.2283 | BESI BETON POLOS U24 10MM SNI | 260610095 | 92,000 | 251210006 | 2025-12-01 | 2025-12-01 | 138 | 62,286.16 | 2 | – | – | – | 2025-12-08 | Overdue |
| 251200114 | 2025-12-01 | PERSEDIAAN UMUM | 6030.0985 | BESI CNP 125 X 50 X 2.3 X 6000 MM | 260410178 | 328,828.83 | 251200128 | 2025-12-01 | 2025-12-01 | 90 | 311,711.71 | – | – | – | – | 2025-12-08 | Overdue |
| 251200114 | 2025-12-01 | PERSEDIAAN UMUM | 6030.0412 | BESI BETON ULIR 19 MM | 251200128 | 230,990.99 | 251200128 | 2025-12-01 | 2025-12-01 | 80 | 230,990.99 | – | 251200527 | 2025-12-16 | 15 | 2025-12-08 | Late |
| 251200114 | 2025-12-01 | PERSEDIAAN UMUM | 6030.0413 | BESI BETON ULIR 13 MM | 260400477 | 119,932.43 | 251200128 | 2025-12-01 | 2025-12-01 | 20 | 107,207.21 | – | 251200527 | 2025-12-16 | 15 | 2025-12-08 | Late |
| 251200114 | 2025-12-01 | PERSEDIAAN UMUM | 6030.2281 | BESI BETON U24 8 MM SNI | 251200128 | 40,540.54 | 251200128 | 2025-12-01 | 2025-12-01 | 42 | 40,540.54 | – | 251200527 | 2025-12-16 | 15 | 2025-12-08 | Late |
| 251200114 | 2025-12-01 | PERSEDIAAN UMUM | 6030.1553 | BESI BETON ULIR 10 MM | 260400477 | 71,000 | 251200128 | 2025-12-01 | 2025-12-01 | 110 | 62,500 | – | 251200527 | 2025-12-16 | 15 | 2025-12-08 | Late |
| 251200114 | 2025-12-01 | PERSEDIAAN UMUM | 6030.2102 | BESI BETON ULIR 16 MM | 260410106 | 185,000 | 251200128 | 2025-12-01 | 2025-12-01 | 110 | 162,837.84 | – | 251200527 | 2025-12-16 | 15 | 2025-12-08 | Late |
| 251200114 | 2025-12-01 | PERSEDIAAN UMUM | 6030.0051 | KAWAT BENDRAT | 260610017 | 17,640 | 251200128 | 2025-12-01 | 2025-12-01 | 40 | 10,540.54 | – | 251200527 | 2025-12-16 | 15 | 2025-12-08 | Late |
| 251200115 | 2025-12-01 | PERSEDIAAN UMUM | 6050.028 | BESI PLAT 10X1200X2400 MM | 260510206 | 2,695,000 | 251200131 | 2025-12-01 | 2025-12-01 | 8 | 2,036,126.13 | – | 251200633 | 2025-12-18 | 17 | 2025-12-08 | Late |
| 251200115 | 2025-12-01 | PERSEDIAAN UMUM | 6030.1225 | BESI PLAT 6MM X 1200MM X 2400MM | 251200131 | 1,267,567.57 | 251200131 | 2025-12-01 | 2025-12-01 | 10 | 1,267,567.57 | – | 251200633 | 2025-12-18 | 17 | 2025-12-08 | Late |
| 251200115 | 2025-12-01 | PERSEDIAAN UMUM | 6030.0166 | KAWAT LAS RB 26 2.6 MM | 260600013 | 33,333.33 | 251200131 | 2025-12-01 | 2025-12-01 | 40 | 28,963.96 | – | 251200633 | 2025-12-18 | 17 | 2025-12-08 | Late |
| 251200116 | 2025-12-01 | PERSEDIAAN UMUM | 6030.0507 | THINER B | 260100398 | 23,100 | 251200145 | 2025-12-01 | 2025-12-12 | 60 | 23,100 | – | 251200467 | 2025-12-13 | 12 | 2025-12-19 | On time |
| 251200116 | 2025-12-01 | PERSEDIAAN UMUM | 6030.2466 | AVIAN BELMAS ZINCHROMATE 724 GREY @20 KG | 260610139 | 885,077 | 251200145 | 2025-12-01 | 2025-12-12 | 3 | 654,000 | – | 251200467 | 2025-12-13 | 12 | 2025-12-19 | On time |
| 251100306 | 2025-11-22 | BAHAN PEMBANTU | 20OT.0001 | PAC POWDER | 260400507 | 9,000 | 251200008 | 2025-12-02 | 2025-12-06 | 4,700 | 9,000 | 10 | 251200175 | 2025-12-05 | 3 | 2025-12-13 | On time |
| 251100354 | 2025-11-21 | PERSEDIAAN UMUM | 6020.0375 | FLEXIBLE TAPE TZE 9 MM (WARNA HIJAU) | 260600184 | 195,500 | 251200025 | 2025-12-02 | 2025-12-20 | 2 | 265,000 | 11 | 251200830 | 2025-12-24 | 22 | 2025-12-27 | On time |
| 251100354 | 2025-11-21 | PERSEDIAAN UMUM | 6020.0377 | FLEXIBLE TAPE TZE 24 MM (WARNA HIJAU) | 260600185 | 370,000 | 251200025 | 2025-12-02 | 2025-12-20 | 2 | 399,000 | 11 | 251200830 | 2025-12-24 | 22 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0717 | MAP PLASTIK / MAP SCHOOL BAG | 260400257 | 11,700 | 251200021 | 2025-12-02 | 2025-12-20 | 2 | 11,000 | 7 | 251200297 | 2025-12-10 | 8 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0143 | CLIP TRIGONAL | 260500261 | 1,500 | 251200021 | 2025-12-02 | 2025-12-20 | 4 | 1,600 | 7 | 251200297 | 2025-12-10 | 8 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.019 | BUKU TULIS SIDU(16*21) 16 X 21 CM | 260600027 | 4,600 | 251200021 | 2025-12-02 | 2025-12-20 | 2 | 4,500 | 7 | 251200297 | 2025-12-10 | 8 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0122 | BOLPOIN HITAM | 260600027 | 1,300 | 251200020 | 2025-12-02 | 2025-12-20 | 12 | 2,000 | 7 | 251200689 | 2025-12-22 | 20 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0184 | MAP PLASTIK L TRANSPARAN, F4 | 260500419 | 1,600 | 251200021 | 2025-12-02 | 2025-12-20 | 36 | 1,542 | 7 | 251200297 | 2025-12-10 | 8 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0541 | MAP CLEAR HOLDER (MAP SNELL) | 260100560 | 30,000 | 251200021 | 2025-12-02 | 2025-12-20 | 1 | 30,000 | 7 | 251200297 | 2025-12-10 | 8 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0001 | KERTAS A4 | 260600244 | 43,000 | 251200021 | 2025-12-02 | 2025-12-20 | 5 | 43,000 | 7 | 251200297 | 2025-12-10 | 8 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | PERSEDIAAN UMUM | 6010.0575 | MOUSE LAPTOP WIRELESS | 260500321 | 119,000 | 251200020 | 2025-12-02 | 2025-12-20 | 5 | 115,000 | 7 | 251200689 | 2025-12-22 | 20 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0714 | KERTAS A3 | 260600145 | 77,000 | 251200020 | 2025-12-02 | 2025-12-20 | 1 | 76,700 | 7 | 251200689 | 2025-12-22 | 20 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0251 | BOX FILE | 260100142 | 32,000 | 251200020 | 2025-12-02 | 2025-12-20 | 3 | 32,000 | 7 | 251200689 | 2025-12-22 | 20 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0127 | SPIDOL BOARDMARKER HITAM - BOARDMARKER, HITAM/BLACK | 260610151 | 8,998 | 251200020 | 2025-12-02 | 2025-12-20 | 1 | 6,700 | 7 | 251200689 | 2025-12-22 | 20 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0444 | TINTA EPSON 003 CYAN 65ML | 260600027 | 83,000 | 251200020 | 2025-12-02 | 2025-12-20 | 2 | 83,000 | 7 | 251200689 | 2025-12-22 | 20 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0442 | TINTA EPSON 003 YELLOW 65ML | 260600027 | 83,000 | 251200020 | 2025-12-02 | 2025-12-20 | 2 | 83,000 | 7 | 251200689 | 2025-12-22 | 20 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0441 | TINTA EPSON 003 BLACK 65ML | 260600027 | 83,000 | 251200020 | 2025-12-02 | 2025-12-20 | 2 | 83,000 | 7 | 251200689 | 2025-12-22 | 20 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0443 | TINTA EPSON 003 MAGENTA 65ML | 260600027 | 83,000 | 251200020 | 2025-12-02 | 2025-12-20 | 2 | 83,000 | 7 | 251200689 | 2025-12-22 | 20 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | PERSEDIAAN UMUM | 6020.005 | KALKULATOR | 260600027 | 65,000 | 251200021 | 2025-12-02 | 2025-12-20 | 2 | 55,000 | 7 | 251200297 | 2025-12-10 | 8 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0539 | LAKBAN BENING 2 INCI / 48MM | 260500322 | 8,000 | 251200020 | 2025-12-02 | 2025-12-20 | 20 | 8,500 | 7 | 251200689 | 2025-12-22 | 20 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.015 | ISI CUTTER BESAR L-150 | 260610060 | 6,500 | 251200021 | 2025-12-02 | 2025-12-20 | 2 | 1,200 | 7 | 251200297 | 2025-12-10 | 8 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0172 | BINDER CLIP NO. 107 NO. 107 | 260610060 | 3,500 | 251200020 | 2025-12-02 | 2025-12-20 | 6 | 2,500 | 7 | 251200689 | 2025-12-22 | 20 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0667 | ISOLASI MEJA 1 INCHI | 260400206 | 3,200 | 251200021 | 2025-12-02 | 2025-12-20 | 6 | 4,300 | 7 | 251200297 | 2025-12-10 | 8 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0716 | ISI CUTTER A-300 | 260510023 | 34,120 | 251200021 | 2025-12-02 | 2025-12-20 | 2 | 2,500 | 7 | 251200297 | 2025-12-10 | 8 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0243 | PAPER CLIP NO 5 | 260400207 | 4,000 | 251200021 | 2025-12-02 | 2025-12-20 | 5 | 4,000 | 7 | 251200297 | 2025-12-10 | 8 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0168 | GUNTING | 260600027 | 6,200 | 251200021 | 2025-12-02 | 2025-12-20 | 1 | 8,900 | 7 | 251200297 | 2025-12-10 | 8 | 2025-12-27 | On time |
| 251100365 | 2025-11-25 | STATIONERY | 6010.0173 | BINDER CLIP NO. 111 NO. 111 | 260600027 | 3,800 | 251200020 | 2025-12-02 | 2025-12-20 | 7 | 3,800 | 7 | 251200689 | 2025-12-22 | 20 | 2025-12-27 | On time |
| 251100403 | 2025-11-26 | PERSEDIAAN UMUM | 6050.012 | BAN LUAR 7.50X16 | 251200024 | 1,390,000 | 251200024 | 2025-12-02 | 2025-12-20 | 2 | 1,390,000 | 6 | 251200250 | 2025-12-09 | 7 | 2025-12-27 | On time |
| 251100403 | 2025-11-26 | PERSEDIAAN UMUM | 6050.0153 | BAN DALAM 7.50X16 | 251200024 | 185,000 | 251200024 | 2025-12-02 | 2025-12-20 | 2 | 185,000 | 6 | 251200250 | 2025-12-09 | 7 | 2025-12-27 | On time |
| 251100408 | 2025-11-25 | BAHAN BAKAR | 4010.0001 | SOLAR | 260600111 | 20,720.72 | 251200013 | 2025-12-02 | 2025-12-16 | 8,000 | 13,378.38 | 7 | 251200174 | 2025-12-05 | 3 | 2025-12-23 | On time |
| 251100413 | 2025-11-28 | STATIONERY | 6010.012 | COUNTINOUS FORM 2 PLY | 251200028 | 305,000 | 251200028 | 2025-12-02 | 2025-12-10 | 1 | 305,000 | 4 | 251200115 | 2025-12-05 | 3 | 2025-12-17 | On time |
| 251100415 | 2025-11-28 | SPAREPART | 5032.1411 | SOLID TYRE | 251200010 | 17,000,000 | 251200010 | 2025-12-02 | 2025-12-02 | 4 | 17,000,000 | 4 | 260600231 | 2026-06-06 | 186 | 2025-12-09 | Late |
| 251100415 | 2025-11-28 | SPAREPART | 5032.1411 | SOLID TYRE | 251200010 | 17,000,000 | 251200010 | 2025-12-02 | 2025-12-02 | 4 | 17,000,000 | 4 | 260500028 | 2026-05-02 | 151 | 2025-12-09 | Late |
| 251100415 | 2025-11-28 | SPAREPART | 5032.141 | SIDE SHIFTER | 251200010 | 31,000,000 | 251200010 | 2025-12-02 | 2025-12-02 | 4 | 31,000,000 | 4 | 260500028 | 2026-05-02 | 151 | 2025-12-09 | Late |
| 251100415 | 2025-11-28 | SPAREPART | 5032.141 | SIDE SHIFTER | 251200010 | 31,000,000 | 251200010 | 2025-12-02 | 2025-12-02 | 4 | 31,000,000 | 4 | 260600231 | 2026-06-06 | 186 | 2025-12-09 | Late |