KKobin GroupProcurement KPI
ConsolidatedLEAD TIMEPO REPORTVENDOR LIST

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)

Export CSV
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ⓘ
2512000632025-12-01BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512000802025-12-042025-12-152025-12-15180,0007,342.532512003642025-12-1282025-12-22On timeLokalIDRKASMAJI INTI UTAMA PT.S0014CLOSEDCLOSED2025-12-14Moch Firdaus Fasa ZulfikiriKG1,321,650,0000Net 120Partial Delivery: - 06/12 (40 ton) - 09/12 (40 ton) - 11/12 (40 ton) - 13/12 (40 ton) - 15/12 (20 ton)
2512000632025-12-01BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512000802025-12-042025-12-152025-12-15180,0007,342.532512005852025-12-17132025-12-22On timeLokalIDRKASMAJI INTI UTAMA PT.S0014CLOSEDCLOSED2025-12-14Moch Firdaus Fasa ZulfikiriKG1,321,650,0000Net 120Partial Delivery: - 06/12 (40 ton) - 09/12 (40 ton) - 11/12 (40 ton) - 13/12 (40 ton) - 15/12 (20 ton)
2512000632025-12-01BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512000802025-12-042025-12-152025-12-15180,0007,342.532512002122025-12-0842025-12-22On timeLokalIDRKASMAJI INTI UTAMA PT.S0014CLOSEDCLOSED2025-12-14Moch Firdaus Fasa ZulfikiriKG1,321,650,0000Net 120Partial Delivery: - 06/12 (40 ton) - 09/12 (40 ton) - 11/12 (40 ton) - 13/12 (40 ton) - 15/12 (20 ton)
2512000632025-12-01BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512000802025-12-042025-12-152025-12-15180,0007,342.532512003152025-12-1062025-12-22On timeLokalIDRKASMAJI INTI UTAMA PT.S0014CLOSEDCLOSED2025-12-14Moch Firdaus Fasa ZulfikiriKG1,321,650,0000Net 120Partial Delivery: - 06/12 (40 ton) - 09/12 (40 ton) - 11/12 (40 ton) - 13/12 (40 ton) - 15/12 (20 ton)
2512000642025-12-01BAHAN BAKU GLAZE1030.0027SILICA 200 ID2606000381,3162512000892025-12-042025-12-292025-12-2996,0001,22532512007492025-12-22182026-01-05On timeLokalIDRSIBELCO LAUTAN MINERALS PT.S0003OPENCLOSED2025-12-14Moch Firdaus Fasa ZulfikiriKG117,600,0000Net 60Partial Delivery: - 09/12 (24 Ton) - 15/12 (24 Ton) - 22/12 (24 Ton) - 29/12 (24 Ton)
2512000642025-12-01BAHAN BAKU GLAZE1030.0027SILICA 200 ID2606000381,3162512000892025-12-042025-12-292025-12-2996,0001,22532512003142025-12-1062026-01-05On timeLokalIDRSIBELCO LAUTAN MINERALS PT.S0003OPENCLOSED2025-12-14Moch Firdaus Fasa ZulfikiriKG117,600,0000Net 60Partial Delivery: - 09/12 (24 Ton) - 15/12 (24 Ton) - 22/12 (24 Ton) - 29/12 (24 Ton)
2512000642025-12-01BAHAN BAKU GLAZE1030.0027SILICA 200 ID2606000381,3162512000892025-12-042025-12-292025-12-2996,0001,22532512008472025-12-24202026-01-05On timeLokalIDRSIBELCO LAUTAN MINERALS PT.S0003OPENCLOSED2025-12-14Moch Firdaus Fasa ZulfikiriKG117,600,0000Net 60Partial Delivery: - 09/12 (24 Ton) - 15/12 (24 Ton) - 22/12 (24 Ton) - 29/12 (24 Ton)
2512000642025-12-01BAHAN BAKU GLAZE1030.0027SILICA 200 ID2606000381,3162512000892025-12-042025-12-292025-12-2996,0001,22532512005792025-12-17132026-01-05On timeLokalIDRSIBELCO LAUTAN MINERALS PT.S0003OPENCLOSED2025-12-14Moch Firdaus Fasa ZulfikiriKG117,600,0000Net 60Partial Delivery: - 09/12 (24 Ton) - 15/12 (24 Ton) - 22/12 (24 Ton) - 29/12 (24 Ton)
2512000652025-12-01BAHAN BAKU GLAZE1030.0002TRANSPARENT FRIT IT-1413A26060005310,466.42512000862025-12-042025-12-242025-12-24180,00010,014.632512003162025-12-1062025-12-31On timeLokalIDRCHINA GLAZE INDONESIA PT.S0009CLOSEDCLOSED2025-12-14Moch Firdaus Fasa ZulfikiriKG1,802,628,0000Net 90Acuan kurs bulanan: 16,691 Partial delivery: - 09/12 (40 ton) - 13/12 (40 ton) - 17/12 (40 ton) - 22/12 (60 ton)
2512000652025-12-01BAHAN BAKU GLAZE1030.0002TRANSPARENT FRIT IT-1413A26060005310,466.42512000862025-12-042025-12-242025-12-24180,00010,014.632512007562025-12-22182025-12-31On timeLokalIDRCHINA GLAZE INDONESIA PT.S0009CLOSEDCLOSED2025-12-14Moch Firdaus Fasa ZulfikiriKG1,802,628,0000Net 90Acuan kurs bulanan: 16,691 Partial delivery: - 09/12 (40 ton) - 13/12 (40 ton) - 17/12 (40 ton) - 22/12 (60 ton)
2512000652025-12-01BAHAN BAKU GLAZE1030.0002TRANSPARENT FRIT IT-1413A26060005310,466.42512000862025-12-042025-12-242025-12-24180,00010,014.632512005802025-12-17132025-12-31On timeLokalIDRCHINA GLAZE INDONESIA PT.S0009CLOSEDCLOSED2025-12-14Moch Firdaus Fasa ZulfikiriKG1,802,628,0000Net 90Acuan kurs bulanan: 16,691 Partial delivery: - 09/12 (40 ton) - 13/12 (40 ton) - 17/12 (40 ton) - 22/12 (60 ton)
2512000652025-12-01BAHAN BAKU GLAZE1030.0002TRANSPARENT FRIT IT-1413A26060005310,466.42512000862025-12-042025-12-242025-12-24180,00010,014.632512005812025-12-17132025-12-31On timeLokalIDRCHINA GLAZE INDONESIA PT.S0009CLOSEDCLOSED2025-12-14Moch Firdaus Fasa ZulfikiriKG1,802,628,0000Net 90Acuan kurs bulanan: 16,691 Partial delivery: - 09/12 (40 ton) - 13/12 (40 ton) - 17/12 (40 ton) - 22/12 (60 ton)
2512000652025-12-01BAHAN BAKU GLAZE1030.0002TRANSPARENT FRIT IT-1413A26060005310,466.42512000862025-12-042025-12-242025-12-24180,00010,014.632512007602025-12-22182025-12-31On timeLokalIDRCHINA GLAZE INDONESIA PT.S0009CLOSEDCLOSED2025-12-14Moch Firdaus Fasa ZulfikiriKG1,802,628,0000Net 90Acuan kurs bulanan: 16,691 Partial delivery: - 09/12 (40 ton) - 13/12 (40 ton) - 17/12 (40 ton) - 22/12 (60 ton)
2512000652025-12-01BAHAN BAKU GLAZE1030.0002TRANSPARENT FRIT IT-1413A26060005310,466.42512000862025-12-042025-12-242025-12-24180,00010,014.632512003992025-12-1392025-12-31On timeLokalIDRCHINA GLAZE INDONESIA PT.S0009CLOSEDCLOSED2025-12-14Moch Firdaus Fasa ZulfikiriKG1,802,628,0000Net 90Acuan kurs bulanan: 16,691 Partial delivery: - 09/12 (40 ton) - 13/12 (40 ton) - 17/12 (40 ton) - 22/12 (60 ton)
2512000662025-12-01BAHAN BAKU GLAZE1099.0019KAOLIN NOODLE KS-022606000472,5402512000852025-12-042025-12-202025-12-20175,0002,50032601016072026-02-14722025-12-27LateLokalIDRGRAHA JAYA SENTOSA CV.S0001OPENOPEN2025-12-14Moch Firdaus Fasa ZulfikiriKG437,500,0001,540Net 60–
2512000662025-12-01BAHAN BAKU GLAZE1099.0019KAOLIN NOODLE KS-022606000472,5402512000852025-12-042025-12-202025-12-20175,0002,50032601016092026-02-14722025-12-27LateLokalIDRGRAHA JAYA SENTOSA CV.S0001OPENOPEN2025-12-14Moch Firdaus Fasa ZulfikiriKG437,500,0001,540Net 60–
2512000662025-12-01BAHAN BAKU GLAZE1099.0019KAOLIN NOODLE KS-022606000472,5402512000852025-12-042025-12-202025-12-20175,0002,50032601001462026-01-06332025-12-27LateLokalIDRGRAHA JAYA SENTOSA CV.S0001OPENOPEN2025-12-14Moch Firdaus Fasa ZulfikiriKG437,500,0001,540Net 60–
2512000662025-12-01BAHAN BAKU GLAZE1099.0019KAOLIN NOODLE KS-022606000472,5402512000852025-12-042025-12-202025-12-20175,0002,50032601002462026-01-08352025-12-27LateLokalIDRGRAHA JAYA SENTOSA CV.S0001OPENOPEN2025-12-14Moch Firdaus Fasa ZulfikiriKG437,500,0001,540Net 60–
2512000662025-12-01BAHAN BAKU GLAZE1099.0019KAOLIN NOODLE KS-022606000472,5402512000852025-12-042025-12-202025-12-20175,0002,50032601016062026-02-14722025-12-27LateLokalIDRGRAHA JAYA SENTOSA CV.S0001OPENOPEN2025-12-14Moch Firdaus Fasa ZulfikiriKG437,500,0001,540Net 60–
2512000662025-12-01BAHAN BAKU GLAZE1099.0019KAOLIN NOODLE KS-022606000472,5402512000852025-12-042025-12-202025-12-20175,0002,50032601002422026-01-08352025-12-27LateLokalIDRGRAHA JAYA SENTOSA CV.S0001OPENOPEN2025-12-14Moch Firdaus Fasa ZulfikiriKG437,500,0001,540Net 60–
← PrevPage 57 of 672Next →Rows per page:1020501005001000