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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 260400083 | 2026-04-08 | SPAREPART | 5028.0181 | PULLEY CURVA D-ZW-ZP-01-04 DIA. 2,25 INCH | 260600237 | 3 | 260600237 | 2026-06-12 | 2026-09-30 | 40 | 3 | 65 | – | – | – | 2026-10-07 | Outstanding |
| 260400084 | 2026-04-08 | SPAREPART | 5021.0386 | ROUND BELT HIJAU D-ZW-ZP-09 | 260600237 | 2 | 260600237 | 2026-06-12 | 2026-09-30 | 100 | 2 | 65 | – | – | – | 2026-10-07 | Outstanding |
| 260400084 | 2026-04-08 | SPAREPART | 5021.039 | ROUND BELT MERAH | 260600237 | 1.5 | 260600237 | 2026-06-12 | 2026-09-30 | 200 | 1.5 | 65 | – | – | – | 2026-10-07 | Outstanding |
| 251210078 | 2025-12-31 | PERSEDIAAN UMUM | 6050.1233 | HD EXIT TILE TURNING SYNCHRONOUS BELT MODEL 820H150 | 260610136 | 535,000 | 260610136 | 2026-06-11 | 2026-06-11 | 2 | 535,000 | 162 | – | – | – | 2026-06-18 | Outstanding |
| 260310020 | 2026-03-09 | PERSEDIAAN UMUM | 6020.0765 | WIFI USB ADAPTOR | 260610152 | 76,000 | 260610152 | 2026-06-11 | 2026-06-22 | 3 | 76,000 | 94 | – | – | – | 2026-06-29 | Outstanding |
| 260410045 | 2026-04-17 | PERSEDIAAN UMUM | 6030.0415 | MATA BOR BESI 13 MM | 260610157 | 172,500 | 260610157 | 2026-06-11 | 2026-06-22 | 5 | 172,500 | 55 | – | – | – | 2026-06-29 | Outstanding |
| 260410045 | 2026-04-17 | PERSEDIAAN UMUM | 6030.013 | MATA BOR BESI M10 | 260610157 | 99,000 | 260610157 | 2026-06-11 | 2026-06-22 | 5 | 99,000 | 55 | – | – | – | 2026-06-29 | Outstanding |
| 260410045 | 2026-04-17 | PERSEDIAAN UMUM | 6030.1363 | MATA BOR BESI M 14 | 260610157 | 316,200 | 260610157 | 2026-06-11 | 2026-06-22 | 5 | 316,200 | 55 | – | – | – | 2026-06-29 | Outstanding |
| 260110085 | 2026-02-05 | PERSEDIAAN UMUM | 6050.1335 | STRONG ADHESIVE (DEXTONE) | 260610117 | 13,692 | 260610117 | 2026-06-10 | 2026-06-19 | 20 | 13,692 | 125 | – | – | – | 2026-06-26 | Outstanding |
| 260310029 | 2026-03-11 | PERSEDIAAN UMUM | 6060.0501 | PIPA CARBON STEEL BLACKSTEEL Ø 2,5 INCH ASTM SCH.40 SEAMLESS | 260610123 | 1,030,000 | 260610123 | 2026-06-10 | 2026-06-10 | 160 | 1,030,000 | 91 | 260610466 | 2026-06-17 | 7 | 2026-06-17 | On time |
| 260310029 | 2026-03-11 | PERSEDIAAN UMUM | 6060.0501 | PIPA CARBON STEEL BLACKSTEEL Ø 2,5 INCH ASTM SCH.40 SEAMLESS | 260610123 | 1,030,000 | 260610123 | 2026-06-10 | 2026-06-10 | 160 | 1,030,000 | 91 | 260610467 | 2026-06-17 | 7 | 2026-06-17 | On time |
| 260310029 | 2026-03-11 | PERSEDIAAN UMUM | 6030.28 | TEE BESI LAS CARBON BLACKSTEEL ASTM SCH 40 SEAMLESS DIAMETER 2,5 INC | 260610122 | 113,000 | 260610122 | 2026-06-10 | 2026-06-10 | 25 | 113,000 | 91 | 260610343 | 2026-06-12 | 2 | 2026-06-17 | On time |
| 260410045 | 2026-04-17 | PERSEDIAAN UMUM | 6030.2353 | U-BOLT 4 INCH | 260610124 | 7,207.21 | 260610124 | 2026-06-10 | 2026-06-10 | 50 | 7,207.21 | 54 | – | – | – | 2026-06-17 | Overdue |
| 260410045 | 2026-04-17 | PERSEDIAAN UMUM | 6030.2267 | U-BOLT 5 INCHI | 260610124 | 7,657.66 | 260610124 | 2026-06-10 | 2026-06-10 | 10 | 7,657.66 | 54 | – | – | – | 2026-06-17 | Overdue |
| 260410045 | 2026-04-17 | PERSEDIAAN UMUM | 6030.2933 | U BOLT 8 INC GALVANIS | 260610124 | 12,612.61 | 260610124 | 2026-06-10 | 2026-06-10 | 10 | 12,612.61 | 54 | – | – | – | 2026-06-17 | Overdue |
| 260410045 | 2026-04-17 | PERSEDIAAN UMUM | 6030.1831 | U-BOLT 1 INCH | 260610124 | 1,801.8 | 260610124 | 2026-06-10 | 2026-06-10 | 100 | 1,801.8 | 54 | – | – | – | 2026-06-17 | Overdue |
| 260410045 | 2026-04-17 | PERSEDIAAN UMUM | 6030.1829 | U-BOLT 2 INCH | 260610124 | 3,153.15 | 260610124 | 2026-06-10 | 2026-06-10 | 100 | 3,153.15 | 54 | – | – | – | 2026-06-17 | Overdue |
| 260410046 | 2026-04-17 | PERSEDIAAN UMUM | 6030.1829 | U-BOLT 2 INCH | 260610124 | 3,153.15 | 260610124 | 2026-06-10 | 2026-06-10 | 10 | 3,153.15 | 54 | – | – | – | 2026-06-17 | Overdue |
| 260300452 | 2026-03-31 | PERSEDIAAN UMUM | 6050.0034 | LPG 50 KG | 260600166 | 1,300,000 | 260600166 | 2026-06-09 | 2026-06-15 | 1 | 1,300,000 | 70 | 260600372 | 2026-06-10 | 1 | 2026-06-22 | On time |
| 260310018 | 2026-03-07 | PERSEDIAAN UMUM | 6050.1633 | ATS HYDRAULIC BOTTLE JACK (DONGKRAK BOTOL) 3TON | 260610113 | 225,226 | 260610113 | 2026-06-09 | 2026-06-18 | 2 | 225,226 | 94 | 260610338 | 2026-06-12 | 3 | 2026-06-25 | On time |
| 260410032 | 2026-04-14 | SPAREPART | 5023.157 | POMPA FEEDING FILTER PRESS TYPE 50SyA DAN MOTOR 22KW TYPE YVF2_180L_4 | 260610102 | 2,800 | 260610102 | 2026-06-09 | 2026-06-09 | 2 | 2,800 | 56 | – | – | – | 2026-06-16 | Overdue |
| 260410045 | 2026-04-17 | PERSEDIAAN UMUM | 6030.2932 | U BOLT 6 INC GALVANIS | 260610057 | 10,810.81 | 260610057 | 2026-06-06 | 2026-06-06 | 10 | 10,810.81 | 50 | – | – | – | 2026-06-13 | Overdue |
| 260410045 | 2026-04-17 | PERSEDIAAN UMUM | 6030.2601 | U BOLT GALVANISH 3 INCH | 260610096 | 6,036.03 | 260610057 | 2026-06-06 | 2026-06-06 | 50 | 6,036.04 | 50 | 260610252 | 2026-06-09 | 3 | 2026-06-13 | On time |
| 260110119 | 2026-02-20 | SPAREPART | 5029.0492 | DUMPER VALVE+FLANGE+BOLT,RING,NUT M14X70MM DUCTING DIAMETER 1100 | 260610093 | 12,683,061 | 260610093 | 2026-06-05 | 2026-06-17 | 2 | 12,683,061 | 105 | – | – | – | 2026-06-24 | Outstanding |
| 260400072 | 2026-04-07 | FIXED ASSETS | AST02741 | AC PANASONIC 2 PK (INDOOR + OUTDOOR) R.PANEL PN1 | 260600084 | 6,830,000 | 260600084 | 2026-06-05 | 2026-06-05 | 3 | 6,830,000 | 59 | 260600489 | 2026-06-12 | 7 | 2026-06-12 | On time |
| 260300075 | 2026-03-07 | SPAREPART | 5032.1476 | WIRE ASSY, ACCELERATOR FLEXIBLE 26620-N3170-71 | 260600109 | 750,000 | 260600109 | 2026-06-04 | 2026-06-22 | 2 | 750,000 | 89 | – | – | – | 2026-06-29 | Outstanding |
| 260300217 | 2026-03-12 | SPAREPART | 5029.0371 | HELICAL GEAR Z25 (MAT=SCM-415 HARDEN) | 260600091 | 363,000 | 260600091 | 2026-06-04 | 2026-07-04 | 4 | 363,000 | 84 | – | – | – | 2026-07-11 | Outstanding |
| 260300217 | 2026-03-12 | SPAREPART | 5022.041 | PINION GEAR Z9 (MAT=SCM-415 HARDEN) | 260600091 | 354,000 | 260600091 | 2026-06-04 | 2026-07-04 | 4 | 354,000 | 84 | – | – | – | 2026-07-11 | Outstanding |
| 260300217 | 2026-03-12 | SPAREPART | 5022.0364 | HELICAL GEAR Z63 (MAT=SCM-415 HARDEN) | 260600091 | 827,000 | 260600091 | 2026-06-04 | 2026-07-04 | 4 | 827,000 | 84 | – | – | – | 2026-07-11 | Outstanding |
| 260300217 | 2026-03-12 | SPAREPART | 5022.0363 | HELICAL GEAR Z73(MAT=SCM-415 HARDEN) | 260600091 | 800,000 | 260600091 | 2026-06-04 | 2026-07-04 | 4 | 800,000 | 84 | – | – | – | 2026-07-11 | Outstanding |
| 260310003 | 2026-03-03 | SPAREPART | 5031.0999 | IMPACT CRUSHER WEAR PLATE, MODEL VSI9526_3_102 | 260610037 | 3,000,000 | 260610037 | 2026-06-04 | 2026-06-04 | 25 | 3,000,000 | 93 | – | – | – | 2026-06-11 | Overdue |
| 260310014 | 2026-03-05 | SPAREPART | 5014.0044 | 304 STAINLESS STEEL SIEVE MESH 100 MESH X 1,3M WIDTH @30 MTR/ROLL | 260610033 | 3,325,000 | 260610033 | 2026-06-04 | 2026-06-13 | 5 | 3,325,000 | 91 | – | – | – | 2026-06-20 | Outstanding |
| 260310014 | 2026-03-05 | SPAREPART | 5014.0033 | 304 STAINLESS STEEL MESH 60 MESH X 1,3M WIDTH @30 MTR | 260610033 | 3,776,250 | 260610033 | 2026-06-04 | 2026-06-13 | 5 | 3,776,250 | 91 | – | – | – | 2026-06-20 | Outstanding |
| 260310014 | 2026-03-05 | SPAREPART | 5014.0031 | 304 STAINLESS STEEL MESH 80 MESH X 1,3M WIDTH @30 MTR | 260610033 | 3,752,500 | 260610033 | 2026-06-04 | 2026-06-13 | 5 | 3,752,500 | 91 | – | – | – | 2026-06-20 | Outstanding |
| 260410010 | 2026-04-07 | PERSEDIAAN UMUM | 6050.1709 | RIGHT LIFTING CYLINDER REPAIR KIT A2A35N450-4-000-KIT | 260610035 | 1,700,000 | 260610035 | 2026-06-04 | 2026-06-11 | 1 | 1,700,000 | 58 | – | – | – | 2026-06-18 | Outstanding |
| 260410032 | 2026-04-14 | SPAREPART | 5014.0042 | 304 STAINLESS STEEL SIEVE MESH 90 MESH X 1,3M WIDTH @30 MTR/ ROLL | 260610032 | 5,620,000 | 260610032 | 2026-06-04 | 2026-06-13 | 5 | 5,620,000 | 51 | 260610223 | 2026-06-09 | 5 | 2026-06-20 | On time |
| 260410032 | 2026-04-14 | SPAREPART | 5014.0032 | 304 STAINLESS STEEL MESH 70 MESH X 1,3M WIDTH @30 MTR | 260610032 | 5,620,000 | 260610032 | 2026-06-04 | 2026-06-13 | 5 | 5,620,000 | 51 | 260610223 | 2026-06-09 | 5 | 2026-06-20 | On time |
| 260100063 | 2026-01-07 | PERSEDIAAN UMUM | 6030.1561 | BETON READYMIX MUTU K300 | 260600062 | 780,000 | 260600062 | 2026-06-03 | 2026-06-09 | 23.2 | 780,000 | 147 | 260600254 | 2026-06-08 | 5 | 2026-06-16 | On time |
| 260410045 | 2026-04-17 | PERSEDIAAN UMUM | 6030.0898 | BESI UNP 100X50X5MM (@ 6000MM) SNI | 260610067 | 576,000 | 260610019 | 2026-06-03 | 2026-06-03 | 200 | 475,000 | 47 | – | – | – | 2026-06-10 | Overdue |
| 260300452 | 2026-03-31 | PERSEDIAAN UMUM | 6050.0034 | LPG 50 KG | 260600166 | 1,300,000 | 260600074 | 2026-06-02 | 2026-06-13 | 3 | 1,300,000 | 63 | 260600130 | 2026-06-04 | 2 | 2026-06-20 | On time |
| 260310029 | 2026-03-11 | PERSEDIAAN UMUM | 6050.0245 | REGULATOR OXYGEN | 260610001 | 135,135.14 | 260610001 | 2026-06-01 | 2026-06-01 | 1 | 135,135.14 | 82 | 260610247 | 2026-06-09 | 8 | 2026-06-08 | Late |
| 260410030 | 2026-04-13 | PERSEDIAAN UMUM | 6030.29 | TEE PVC AW 10 INCH | 260610003 | 831,600 | 260610003 | 2026-06-01 | 2026-06-01 | 6 | 831,600 | 49 | 260610350 | 2026-06-12 | 11 | 2026-06-08 | Late |
| 260410030 | 2026-04-13 | PERSEDIAAN UMUM | 6030.2345 | FLEXIBLE CONDUIT 2 INCH | 260610003 | 756,000 | 260610003 | 2026-06-01 | 2026-06-01 | 1 | 756,000 | 49 | 260610350 | 2026-06-12 | 11 | 2026-06-08 | Late |
| 260410030 | 2026-04-13 | PERSEDIAAN UMUM | 6030.2899 | PIPA PVC RUCIKA AW 10 INCH | 260610002 | 2,700,000 | 260610002 | 2026-06-01 | 2026-06-01 | 10 | 2,700,000 | 49 | – | – | – | 2026-06-08 | Overdue |
| 260410030 | 2026-04-13 | PERSEDIAAN UMUM | 6030.2904 | FLEXIBLE CONDUIT 3/4 INCH | 260610003 | 567,000 | 260610003 | 2026-06-01 | 2026-06-01 | 1 | 567,000 | 49 | 260610350 | 2026-06-12 | 11 | 2026-06-08 | Late |
| 260410030 | 2026-04-13 | PERSEDIAAN UMUM | 6030.2905 | FLEXIBLE CONDUIT 1/2 INCH | 260610003 | 441,000 | 260610003 | 2026-06-01 | 2026-06-01 | 1 | 441,000 | 49 | 260610350 | 2026-06-12 | 11 | 2026-06-08 | Late |
| 260410030 | 2026-04-13 | PERSEDIAAN UMUM | 6030.2903 | FLEXIBLE CONDUIT 1 INCH | 260610003 | 693,000 | 260610003 | 2026-06-01 | 2026-06-01 | 1 | 693,000 | 49 | 260610350 | 2026-06-12 | 11 | 2026-06-08 | Late |
| 260110011 | 2026-01-06 | PERSEDIAAN UMUM | 6030.2534 | NIKKO STEEL KAWAT LAS BAJA TAHAN KARAT NSN-308 (STAINLESS STEEL) 2.6MM 1PACK(4KG) | 260610070 | 128,800 | 260510286 | 2026-05-30 | 2026-05-30 | 200 | 128,800 | 144 | 260610104 | 2026-06-04 | 5 | 2026-06-06 | On time |
| 260110011 | 2026-01-06 | PERSEDIAAN UMUM | 6030.2533 | NSN-309 KAWAT LAS STAINLESS STELL 309 3,2MM 3,2 MM NIKKO STEEL | 260510286 | 166,400 | 260510286 | 2026-05-30 | 2026-05-30 | 200 | 166,400 | 144 | 260610104 | 2026-06-04 | 5 | 2026-06-06 | On time |
| 260310003 | 2026-03-03 | SPAREPART | 5021.0375 | BELT C-3500 2YZS1860 VIBRATING SIEVE | 260510294 | 12 | 260510294 | 2026-05-30 | 2026-05-30 | 50 | 12 | 88 | – | – | – | 2026-06-06 | Overdue |