Input Required
0 items
Run Summary
Masters
Generates pallet moves from JWL Racks to Picking Zone based on dispatch demand. Most order types: picking zone first, then racks oldest-first (FEFO, min 65% shelf life). General-Trade & Retail are an exception — freshest first (LEFO), rack stock only, and only pallets manufactured within the last 15 days.
Lists every PO still in open/pending status beyond the selected age threshold after PO punching
(Emiza and Prozo order types excluded).
An automatic summary email also goes to stakeholders daily at 7:00 PM IST (at the default 72h threshold).
JWL Consolidated Inventory
Upload CSV Files
Upload CSVs from another device to run the bot without Filflo download
Order Report
order_data_latest.csv — Required for Dispatch List & Pipeline
JWL Picking Zone
jwl_picking_zone_latest.csv — Required for Picklist
JWL Racks
jwl_racks_latest.csv — Required for Picklist & Inventory
Manesar Inventory
manesar_inventory_latest.csv — Required for full Pipeline
JWL Inventory
jwl_inventory_latest.csv — Required for full Pipeline
Currently Available Files
Loading...
Inventory Health Dashboard
—
Score
Inventory Score
Capture a snapshot to see your score
Shelf Health
40%
—
Avg Shelf Life
30%
—
Picking Lean
30%
—
Dead Stock
-1.5x
—
80+ Excellent
60–79 Good
40–59 Needs Work
0–39 Critical
Picking Zone Stock
—
Total Units
—
SKUs
—
vs Yesterday
Pallets Below 70% Shelf Life
—
of total pallets
—
Units at Risk
—
Avg Shelf Life
7-Day Trend
No trend data yet. Capture snapshots over multiple days.
Picking Zone Units
Pallets Below 70%
Shelf Life Distribution (Current Snapshot)
No data yet.
Daily Log
| Date | Picking Units | SKUs | Pallets | Below 70% | Avg Shelf | Score |
|---|---|---|---|---|---|---|
| No snapshots recorded yet. | ||||||
Plan vs Actual & Sales Loss
Powered by the Filflo Sales dashboard
Stock Thresholds
3-month rolling dispatch run-rate → 15 & 20-day stock cover
KPI Control Tower — SKU Stock & Cost
Total Stock Cost
—
at Price Per Unit (incl. picking + racks)
SKUs in Stock
—
Pallets Utilised
—
distinct racks pallets in use
Picking Casepacks
—
casepacks staged in picking zone
Casepacks in Racks
—
casepacks held in JWL racks
SKU-wise Inventory
| SKU | Product | Picking CP | Rack CP | Total CP | Pallets | Price/Unit | Stock Cost | Cost/Pallet | Mo. Avg Dispatch |
|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||
KPI Control Tower — Fill Rate by Platform
Period
Trend
Category
Platforms
Overall Fill Rate
—
dispatched ÷ ordered units
Ordered Units
—
across all platforms
Units Short
—
ordered but never dispatched
POs Measured
—
closed POs only
In Flight (excluded)
—
not shipped yet — no fill rate
Fill Rate — Each Platform Separately
click a platform to filter the SKU breakdown below
Fill Rate Trend by Platform
Platform Detail
sortable — click any column header
| Platform | POs | SKUs | Ordered | Dispatched | Short | Fill Rate | Δ vs prev Month | Full POs | Short POs |
|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||
SKU Breakdown — All Platforms
| SKU | Product | Category | Ordered | Dispatched | Short | Fill Rate |
|---|---|---|---|---|---|---|
| Loading… | ||||||
KPI Control Tower — Stock Ageing
Total Stock Value
—
across all JWL rack pallets
Avg Shelf-Life Left
—
% of total shelf life remaining
Value At Risk (<70%)
—
Critical + At Risk buckets
Pallets At Risk (<70%)
—
need dispatch priority
Total Pallets
—
rack pallet-lots
Ageing Distribution by Shelf-Life Bucket
SKU-wise Ageing (value ₹ · casepacks per bucket)
| SKU | Product | Worst % | Pallets | Total CP | Total Value | Critical | At Risk | Ageing | Healthy | Fresh |
|---|---|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||||
Pallet-Lot Drill-Down (oldest first)
| Shelf-Life | Days→Exp | Pallet | Rack | SKU | Batch | CP | Mfg | Expiry | Value |
|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||
KPI Control Tower — Pending Orders
Pending Value
—
open orders, at Price Per Unit
Pending Units
—
Order − Fulfilled, individual units
Open POs
—
across customers
Shortfall vs JWL
—
demand JWL stock can't cover
Fully Coverable
—
SKUs JWL can fully ship
Open Orders by SKU (click a row for PO / customer drill-down)
| SKU | Product | Pending | JWL Avail | After Dispatch | vs Target | Shortfall | Fill Rate | Pending Value | POs | Oldest | Nearest Exp | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||||||
Inventory → FPOP/FPCL
Plan SKUs (FPOP/FPCL)
—
after casepack → unit conversion
Total Individual Units
—
CP##/OP## expanded × case size
Unmapped SKUs
—
not CP/OP/FPCL/FPOP — excluded
FPOP/FPCL SKU-wise stock vs target thresholds
| Plan SKU (FPOP/FPCL) | Product | Total Units | Target Min | Target Max | vs Target | Source Casepacks → units |
|---|---|---|---|---|---|---|
| Loading… | ||||||
FPOP/FPCL Inventory — After Approved Dispatch
Current Units
—
JWL FPOP/FPCL stock (plan units)
Approved to Dispatch
—
approved orders not yet shipped
Projected Units
—
stock left after approved dispatch
Below Min After
—
SKUs breaching min → reorder
Impacted SKUs
—
have approved orders
Projected FPOP/FPCL stock once approved orders ship
| Plan SKU (FPOP/FPCL) | Product | Current | Approved Dispatch | Projected | Target Min | Target Max | vs Target |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
KPI Control Tower — RM Thresholds
Raw Materials
—
distinct RM codes consumed
Liquid RM (3mo)
—
15-day threshold —
Dry RM (3mo)
—
15-day threshold —
Basis
—
3-month dispatch run-rate
RM Thresholds — 8-Day Lower / 15-Day Upper (by Raw Material)
| RM Code | Unit | SKUs | Dispatch 3mo | RM Consumed (3mo) | Monthly Avg | Daily Avg | 8-Day (Lower) | 15-Day (Upper) |
|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||
SKU → RM Breakdown
| SKU | RM | Vol/Unit | Dispatch 3mo (units) | RM Consumed (3mo) |
|---|
Priority Control Tower
Earmark specific SKUs for a marketplace so the planner allocates them there first.
| Rank | SKU(s) — search & pick (blank = any) | Marketplace | Customer (blank = any) | Reserve Cases blank = all |
On | |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Lower rank claims stock first. Reserved cases are set aside for matched POs before normal allocation, and matched POs also sort ahead of others within their approval tier (Approved orders are never displaced by an Open one). Unused reserve is released back to the general pool after matched POs are served. GT/Retail marketplaces only ever reserve fresh ≤15-day stock.
Marketplace Block List
Stop the planner from allocating any inventory to a marketplace (or specific SKUs) on the next run.
| SKU(s) — search & pick (blank = ALL SKUs) | Marketplace | Customer (blank = any) | On | |
|---|---|---|---|---|
| Loading… | ||||
A block forces the planner to allocate zero JWL/Manesar inventory to matching POs. Leave SKU(s) blank to block the whole marketplace (e.g. Amazon / ARIPL). Blocked demand still appears as shortage so you can see what went unfilled, and the freed stock flows to other POs. Set a Marketplace or Customer on every block. Applies on the next pipeline run.
Last Run — Reservations Outcome
| Rank | Marketplace | Customer | SKU | Reserved | Used by Matched | Released | Utilization |
|---|---|---|---|---|---|---|---|
| Run the pipeline to see reservation results. | |||||||