Scene 5 / 7 11:00 WITA — Sabtu, 2 Mei 2026 · Odoo Inventory menyimpan 1.240 SKU spare parts senilai IDR 3,8 M. Foxel tambahkan ABC analysis otomatis, reorder point cerdas berdasarkan consumption trend + OEM lead time, dan visualisasi BOM per unit (EX1200 punya 840 part hirarki). 11:00 WITA — Saturday, 2 May 2026 · Odoo Inventory holds 1,240 SKUs worth IDR 3.8 B. Foxel adds automatic ABC analysis, intelligent reorder points based on consumption trend + OEM lead time, and per-unit BOM visualisation (EX1200 has 840 hierarchical parts).
Spare Parts + Odoo Inventory IntegrationIntegration
1.240 SKU aktif · 6 warehouse · auto-sync Odoo stock → Foxel consumption1,240 active SKUs · 6 warehouses · auto-sync Odoo stock → Foxel consumption
Pak Dwi Hartono
Maintenance Manager
DH
Total SKU aktifActive SKUs
1.240
OEM + aftermarket + consumableOEM + aftermarket + consumable
Nilai stokStock value
IDR 3,82 M
turnover 4,2× per tahun4.2× annual turnover
Item kritis lowCritical items low
8
reorder perlu · class Areorder required · class A
Reorder otomatis bulan iniAuto-reorders this month
42
PO ke 6 vendorPOs to 6 vendors
Dead stock (>2 thn)Dead stock (>2 yrs)
IDR 420 jt
review perlureview required

ABC Analysis — 1.240 SKUABC Analysis — 1,240 SKUs

Pareto 80/2080/20 Pareto
A
124 SKU · nilaivalue IDR 3,05 M (80%)
Pompa, engine parts, hydraulic cylinder, undercarriage. Reorder point ketat (3× std dev), review weekly.Pumps, engine parts, hydraulic cylinders, undercarriage. Tight reorder point (3× std dev), reviewed weekly.
B
310 SKU · nilaivalue IDR 570 jt (15%)
Filter, belt, hose, bearing generik. Reorder bulanan.Filters, belts, hoses, generic bearings. Monthly reorder.
C
806 SKU · nilaivalue IDR 200 jt (5%)
Consumable (grease, wiper, bulb), bolt kecil, tag. Reorder triwulanan.Consumables (grease, wipers, bulbs), small bolts, tags. Quarterly reorder.

8 Item Kritis Class A · Low Stock8 Critical Class-A Items · Low Stock

PNDeskripsiOEMStokReorderLead timeLeadStatus
4D4GH88AHyd pump EX1200Hyd pump EX1200Hitachi1 of 2221dPO pending
6V-4500Engine oil coolerEngine oil coolerKomatsu3 of 2214dOK
UC-D85Track shoe D85Track shoe D85Berco0 of 8830dKritisCritical
B-5T20Bucket tooth 5THensley4 of 667dLow
TY-29R25Tyre 29.5R25 DTBridgestone2 of 4445dPO sent
BR-7718SKF bearing 23180SKF3 of 6414dLow
P-HD465Pad remBrake padKomatsu12814dOK
SK-FS20Starter motorStarter motorDenso1 of 3221dOrder

BOM EX1200 — Top 10 AssemblyEX1200 BOM — Top 10 Assembly

840 parts
📦 EX1200 Hitachi — 840 parts
⚙ Hydraulic system — 184 parts
4D4GH88A Main pump
9A8-1034 Seal kit major
├ 12× H5-6610 HP hoses
└ 4× cylinders
⚙ Engine 6WG1 — 312 parts
6V-4500 oil cooler
ISF-880 injector × 6
TC-880 turbo
⚙ Undercarriage — 108 parts
├ 76× track pads
├ 42× rollers
└ idlers × 2
⚙ Electrical — 92 parts
⚙ Cab & controls — 94 parts
⚙ Other — 50 parts

Trend Konsumsi 6 Bulan — PN 4D4GH88A6-month Consumption — PN 4D4GH88A

Historical: 2 pump per tahun. Tapi 2026 YTD sudah 2 pump (Jan + April). Trend naik signifikan → reorder point dinaikkan dari 1 ke 2 unit stock.Historical: 2 pumps/year. But 2026 YTD already 2 pumps (Jan + April). Significant upward trend → reorder point raised from 1 to 2 units.
Saran Foxel:Foxel advises: EX-04 & EX-05 overhaul major scheduled Q3 2026 — pre-order 3 pump assembly sebelum end of May. EX-04 & EX-05 major overhauls scheduled Q3 2026 — pre-order 3 pump assemblies before end of May.