supply
/
planner
↑ New File
dark
☁️
Loading MRP from cloud…
📦
James Supply Planning Report
Drag or click to upload the ERP export
Planning is calculated automatically
.xlsx · ERP Export
📋
Supply Plan
📊
PO Analysis by Supplier
⏱
Lead Times
🏷
Item Status
🏥
Inv. Health
🧱
BOMs
🔚
EOL
Service Factors
SS×
OS×
HOLD
↺ Recalculate
—
Items
—
Below SS
—
OK
—
Overstock
—
Inv Value
—
Open POs Value
—
Inv. Turns/Year
—
Filtered Value
—
Filtered POs
—
Filtered Turns
⬇ Export CSV
—
—
Items
—
Inv Value
—
Open PO $
—
Below SS
POs TO PLACE / MO
View analysis →
All Status
🔴 Below SS
🟢 OK
🟣 Overstock
All Months
All Suppliers
Items:
Active
To Be Disc.
EOL
Non-Plan
Consume First
Discontinued
Custom
Sort: Status
Sort: MOH ↑
Sort: Uso/Mes ↓
Sort: $ Valor ↓
Sort: Item ID
Processing…
All Months
Sort: Supplier A–Z
Sort: # Items ↓
Sort: $ Inventory ↓
Sort: $ PO Total ↓
Only with pending POs
↦ ERP (ya existe)
◈ Sugerido
✎ Manual (editado)
Lead time in
months
. If a supplier has no LT configured, the fallback
3×
MAU is used as SS.
⬇ Export CSV for ERP
🗑 Clear All
—
Suppliers Configured
—
No LT (using 3×)
—
Items with Real LT
—
Items with Override
Supplier
Lead Time
Items
SS Actual
← Select a supplier to view its items
All Suppliers
All Statuses
Active
To Be Discontinued
EOL
Non-Plan
Consume First
Discontinued
Custom
Bulk change for supplier:
— select —
Active
To Be Discontinued
EOL
Non-Plan
Discontinued
Custom
Apply
⬇ Export CSV
⬆ Import CSV
—
Active
—
To Be Discontinued
—
EOL
—
Non-Plan
—
Consume First
—
Discontinued
—
Custom
Item ID
Description
Supplier
On Hand
MAU
Family
MOQ
Status
Target Date
Bill of Materials
+ New BOM
🧱
No BOMs created yet
Click "+ New BOM" to define a bill of materials.
Components will auto-populate from the MRP data.
New BOM
✕
Parent SKU (FG or Sub-Assembly)
Name
Components
Add
Component ID
Description
Qty/Parent
MRP OH
OH Override
MRP Open PO
PO Override
Avail
Max Units
Cancel
Save BOM
EOL Management
All (EOL + TBD)
EOL only
To Be Discontinued only
Families:
Upload Disc. Tracker
Upload BOM (ISS)
Export ISS Dashboard
Save Snapshot
—
EOL Items
—
To Be Disc.
—
BOMs Loaded
—
FGs Available
—
Disc. Tracker Items
Show Calculator
Build Calculator — Enter desired quantities
🔚
No EOL data yet
Mark items as EOL or "To Be Discontinued" in the Item Status tab,
then upload a Discontinuation Tracker or BOM file above.
✕