Inventory Planner
What do I reorder today, how much, and which Min–Max settings are wrong?
1. Use identical stock before buying
The part is needed, but the same item (identical description and unit) is held under another material number above that number's own reorder point. Transfer or substitute instead of buying.
| Material | On hand | Transfer from | Rec. Min | Stockout risk | Purchase avoided | Transfer qty | Decision |
|---|---|---|---|---|---|---|---|
| A4100086306then buy 10Long-lead FILTER ELEMENT,LUBE OIL,25MICRON,P/N FE- | 0 | 4100087655 | 14 | 100% | Rp 14.6M | ||
| A4100108685No purchase needed OIL,LUBRICANT,ISO VG 32,MINERAL,1L | 0 | 4100107132 | 12 | 100% | Rp 3.6M | ||
| A4100075392then buy 58Long-lead CERAMIC FIBER,BLANKET,25T,96KG/M3,1430C | 0 | 4100076909 | 36 | 93% | Rp 9.5M | ||
| A4100072317then buy 1,954 FIREBRICK,INSUL,26,65T,114W,230L | 104 | 4100072687, 4100072072 | 1,600 | 91% | Rp 1.7M | ||
| A4100073634then buy 821Long-lead CASTABLE,REFRACTORY,LW,1300DEG C | 0 | 4100074336 | 493 | 91% | Rp 4.3M | ||
| A4100075709No purchase needed CERAMIC FIBER,BLANKET,25T,96KG/M3,1260C | 1 | 4100076240, 4100076970 | 12 | 90% | Rp 35.9M | ||
| A4100073702No purchase needed CASTABLE,REFRACTORY,INSUL,1500DEG C | 0 | 4100073754, 4100073441, 4100073873 | 335 | 87% | Rp 34.0M | ||
| A4100074010then buy 35,113 CASTABLE,REFRACTORY,DENSE,1600DEG C | 0 | 4100073384 | 30,000 | 86% | Rp 1.9M | ||
| A4100075550No purchase needed CERAMIC FIBER,BLANKET,50T,96KG/M3,1430C | 0 | 4100076053 | 10 | 84% | Rp 33.0M | ||
| A4100071926No purchase needed FIREBRICK,INSUL,23,76T,114W,230L | 133 | 4100073289, 4100072939 | 2,000 | 71% | Rp 221.2M | ||
| A4100075597No purchase needed CERAMIC FIBER,BLANKET,50T,96KG/M3,1430C | 2 | 4100076053 | 14 | 68% | Rp 37.3M | ||
| A4100072573then buy 1,085Long-lead FIREBRICK,INSUL,28,76T,114W,230L | 22 | 4100073049 | 1,000 | 62% | Rp 19.1M |
2. Approve reorders
Inventory position (on hand + on order) at or below the dynamic reorder point. Quantities already exclude identical stock. Approved lines go to Procurement; buys above Rp 1.0B (22 today) first need Management sign-off. Safety-critical (SCE) parts always keep at least one spare.
| Material | On hand | On order | Rec. Min | Stockout risk | Value | Order qty | Decision |
|---|---|---|---|---|---|---|---|
| A4100047065Critical DIAPHRAGM,ACTUATOR,MODEL QM616,VITON | 0 | 0 | 2 | 100% | Rp 13.2M | ||
| A4100045110CriticalSCE PACKING SET,VALVE,MODEL ZC545,INCOLOY | 0 | 0 | 7 | 100% | Rp 46.1M | ||
| A4100045612Critical PACKING SET,VALVE,MODEL AN310,A105 | 0 | 0 | 4 | 100% | Rp 23.0M | ||
| A4100047125Critical DIAPHRAGM,ACTUATOR,SIZE GY129,VITON | 0 | 0 | 6 | 100% | Rp 43.8M | ||
| A4300038212Critical TRIM SET,CONTROL VALVE,DWG.593-3697,FOR | 2 | 0 | 4 | 100% | Rp 235.5M | ||
| A4100047259Critical DIAPHRAGM,ACTUATOR,SIZE VP853,VITON | 2 | 0 | 4 | 100% | Rp 21.9M | ||
| A4100045934CriticalSCE PACKING SET,VALVE,SIZE FP49,A105 | 0 | 0 | 2 | 100% | Rp 15.4M | ||
| A4100086306CriticalLong-lead FILTER ELEMENT,LUBE OIL,25MICRON,P/N FE- | 0 | 0 | 14 | 100% | Rp 7.7M | ||
| A4100087504Critical FILTER ELEMENT,FUEL GAS,3MICRON,P/N FE-4 | 0 | 0 | 3 | 100% | Rp 13.9M | ||
| A4100084849Critical SEAL,LABYRINTH,TYPE EJ394,SS304 | 0 | 0 | 1 | 100% | Rp 189.2M | ||
| A4300057645Critical SEAL,LABYRINTH,DWG.220-7491,FOR KC-235D | 0 | 0 | 1 | 100% | Rp 189.2M | ||
| A4100089076CriticalNeeds sign-off BLADE,ROTOR,SIZE IB841,SS316 | 0 | 0 | 2 | 100% | Rp 1.1B |
Top 400 of 1,160 by priority; the full list is in Recommendations.
3. Approve dynamic Min–Max updates
Replace static parameters with the recommended reorder point (Min) and Max. Approved changes download as a list for the ERP (e.g. SAP MM02).
| Material | Today Min / Max | Rec. Min / Max | Safety stock | Service level | Decision |
|---|---|---|---|---|---|
| A4100047065→ Stock Item DIAPHRAGM,ACTUATOR,MODEL QM616,VITON | 0 / 0 | 2 / 3 | 2 | 100.0% | |
| A4100045110→ Stock ItemSCE PACKING SET,VALVE,MODEL ZC545,INCOLOY | 0 / 0 | 7 / 12 | 6 | 99.9% | |
| A4100045612→ Stock Item PACKING SET,VALVE,MODEL AN310,A105 | 0 / 0 | 4 / 6 | 3 | 100.0% | |
| A4100047125→ Stock Item DIAPHRAGM,ACTUATOR,SIZE GY129,VITON | 0 / 0 | 6 / 10 | 4 | 99.9% | |
| A4300038212→ Stock Item TRIM SET,CONTROL VALVE,DWG.593-3697,FOR | 0 / 0 | 4 / 5 | 2 | 99.9% | |
| A4100047259→ Stock Item DIAPHRAGM,ACTUATOR,SIZE VP853,VITON | 0 / 0 | 4 / 7 | 2 | 100.0% | |
| A4100045934→ Stock ItemSCE PACKING SET,VALVE,SIZE FP49,A105 | 0 / 0 | 2 / 4 | 2 | 100.0% | |
| A4100086306→ Stock ItemLong-lead FILTER ELEMENT,LUBE OIL,25MICRON,P/N FE- | 0 / 0 | 14 / 29 | 10 | 100.0% | |
| A4100087504 FILTER ELEMENT,FUEL GAS,3MICRON,P/N FE-4 | 5 / 12 | 3 / 5 | 3 | 99.9% | |
| A4100084849→ Stock Item SEAL,LABYRINTH,TYPE EJ394,SS304 | 0 / 0 | 1 / 2 | 1 | 98.3% | |
| A4300057645→ Stock Item SEAL,LABYRINTH,DWG.220-7491,FOR KC-235D | 0 / 0 | 1 / 2 | 1 | 98.3% | |
| A4100089076 BLADE,ROTOR,SIZE IB841,SS316 | 10 / 25 | 2 / 3 | 2 | 99.7% |
4. Approve excess reductions
Stop replenishing and run down, return or transfer stock above the recommended maximum. Released value is reported to Management. Reductions above Rp 1.0B or of a safety-critical part (985 today) need Management sign-off; an SCE part never goes below its minimum spare.
| Material | On hand | Rec. Max | Excess qty | Excess value | Decision |
|---|---|---|---|---|---|
| A4300005012Non-movingNeeds sign-off VALVE,GOVERNOR,DWG.250-6485,FOR KT-460B | 988 | 1 | 987 | Rp 235.2B | |
| A4300004481Non-movingNeeds sign-off BLADE,ROTOR,DWG.831-1269,FOR KT-397A | 610 | 1 | 609 | Rp 232.3B | |
| S4300033228Potentially obsoleteNeeds sign-off BLADE,ROTOR,DWG.933-4759,FOR KT-624A | 461 | 0 | 461 | Rp 175.9B | |
| A4300039461Non-movingLong-leadNeeds sign-off BEARING,THRUST PAD,DWG.563-7426,FOR KT-4 | 862 | 1 | 861 | Rp 168.6B | |
| S4300035679Potentially obsoleteNeeds sign-off BEARING,JOURNAL,DWG.565-7375,FOR KC-422A | 617 | 0 | 617 | Rp 135.3B | |
| A4300040482Non-movingNeeds sign-off SEAL,LABYRINTH,DWG.274-3179,FOR KT-419A | 1,159 | 1 | 1,158 | Rp 109.5B | |
| A4300003237Non-movingLong-leadNeeds sign-off BLADE,ROTOR,DWG.232-7091,FOR KT-397A | 207 | 1 | 206 | Rp 94.9B | |
| S4100088232Potentially obsoleteNeeds sign-off BLADE,ROTOR,SIZE GR627,SS304 | 245 | 0 | 245 | Rp 93.5B | |
| A4300070721Non-movingNeeds sign-off SEAL,LABYRINTH,DWG.296-1883,FOR KT-513 | 848 | 1 | 847 | Rp 80.1B | |
| A4300040089Non-movingNeeds sign-off BEARING,JOURNAL,DWG.351-2096,FOR KT-419A | 350 | 1 | 349 | Rp 76.5B | |
| A4100005933Non-movingNeeds sign-off SEAL,MECHANICAL,SIZE GD908,GRAPHITE | 727 | 1 | 726 | Rp 68.7B | |
| S4300030402Potentially obsoleteNeeds sign-off BLADE,ROTOR,DWG.238-4820,FOR KT-447 | 169 | 0 | 169 | Rp 64.5B |