Zero available units. Immediate action required for any SKU with active velocity.
● Below Safety Stock
Stock below the calculated safety buffer. Reorder urgency depends on lead time and velocity.
● Reorder Now
At or below reorder point. Place PO before lead time elapses or stock drops further.
● Healthy
Adequate stock above reorder point and safety stock. No immediate action needed.
● Excess Stock
Available stock significantly above reorder point or very low velocity. Review for promotions or return.
● Slow / Dead Stock
Minimal or zero velocity with stock on hand. Candidate for clearance or write-off review.
Column Glossary
Column
Description
Vel/Day
Adjusted daily velocity: 90-day rolling average, multiplied by seasonality index and promo event uplift factors.
Available
Total available = on-hand + in-transit quantity from open POs.
Safety Stock
Z(1.65) x stddev(monthly demand / 30) x sqrt(lead time). Buffer against demand and supply variability.
DoC
Days of Cover: available units / adjusted daily velocity. How many days of stock remain at current run rate.
Order Qty
Dynamic reorder quantity: max(0, min(velocity x 180 days, coverage target - available - open PO)).
Priority Score
0-100 urgency score. Urgency tier (40pts) + Margin at Risk (30pts) + ABC class (20pts) + Days Cover pressure (10pts).
MAR ($)
Margin at Risk: estimated lost GM2 contribution if stock is not replenished in time.
Daily GM ($)
Daily GM2 contribution based on 24-month average margin per unit x daily velocity.
ABC Classification
A-class: Top 20% of 24-month revenue. Highest priority safety stock and ordering. B-class: Next 30% of revenue. Standard replenishment cycles. C-class: Remaining 50%. Lean inventory targets, longer review cycles.
Movement Profile
Fast: >= 1 unit/day average velocity. Medium: 0.1 to 1 unit/day. Slow: > 0 but under 0.1/day. Used to adjust safety stock buffers and review cadence.
ABC Classification ranks SKUs by 24-month revenue contribution. A-class (top 20% of revenue), B-class (next 30%), C-class (remaining 50%). Used to weight safety stock multipliers and reorder priorities.
Methodology: PQR Margin Tier▼
P = product margin >= 35% · Q = 15-35% · R = <15%. Used alongside ABC class to weight margin-at-risk calculations and prioritise purchase decisions.
🔴 Out of Stock: 3,395 SKUs
Zero available units. Order immediately for any with active velocity.
⏳ Searching...
#
SKU
Dept
Class
ABC
Priority
Vel/day
Available
DoC
Order Qty
MAR $
Vendor
Recommendation
🔴 Below Safety Stock: 309 SKUs
Stock below calculated safety level. Reorder urgency depends on lead time and velocity.
⏳ Searching...
#
SKU
Dept
Class
ABC
Priority
Vel/day
Available
DoC
Order Qty
MAR $
Vendor
Recommendation
🟡 Reorder Now: 3,386 SKUs
Stock at or below reorder point. Place PO before lead time elapses.
⏳ Searching...
#
SKU
Dept
Class
ABC
Priority
Vel/day
Available
DoC
Order Qty
MAR $
Vendor
Recommendation
🟢 Healthy: 1,577 SKUs
Adequate stock relative to reorder point and safety stock.
⏳ Searching...
#
SKU
Dept
Class
ABC
Vel/day
Available
Safety Stock
DoC
Vendor
🔵 Excess Stock: 545 SKUs
Available stock significantly above reorder point or with very low velocity.
⏳ Searching...
#
SKU
Dept
Class
ABC
Vel/day
Available
Safety Stock
DoC
Vendor
● In Stock: 5,840 SKUs
All active SKUs currently in stock (not OOS), ordered by 24-month revenue. Top 200 shown by default.
⏳ Searching...
#
SKU
Dept
Class
ABC
Status
Vel/day
Available
Safety Stock
DoC
Vendor
📈 Demand Analytics
Velocity profiles, trends, and days-of-cover distribution across all 9,327 SKUs.
17,958
Total Units/Day
1.93
Avg Velocity/SKU
2,607
Trending Up
2,576
Trending Down
Days of Cover Distribution
Velocity Profile
Fast (>=1/day)3,607
Medium3,317
No velocity2,364
Slow39
Demand Trends
Stable3,009
Growing2,607
Declining2,576
Movement Profile
Medium2,833
Fast2,767
Slow1,363
No Sales (12m)1,229
📖 Methodology: Adjusted Velocity▼
Adjusted daily velocity is the base 90-day rolling average, multiplied by event uplift factors from the promo calendar and seasonality index. SKUs with <14 days of sales history use the category average as a fallback.
🏭 Vendor Performance
Fill rate, lead time, and OOS exposure by vendor. Min 3 POs to qualify.
Vendor Fill Rate (top 25 by volume)
Vendor
Fill Rate
SKUs
OOS SKUs
Reorder Now
MAR $
Avg Lead
Action SKUs
ℹ️ Are these all product vendors?▼
Yes, all vendors shown are product supply vendors. Service providers like UPS, FedEx, and EasyPost appear as freight cost lines in the GM2 margin waterfall, not as purchasing vendors here.
Lhasa OMS | Flowchart - Collapsible Phases
How every SKU is processed, from data load to purchase recommendation
1
DATA INPUT
Ingest on-hand qty, POs, velocity and ABC classifications
▼
Refresh Cadences
Daily 6:30AM: On-hand snapshot, open POs, OOS flags Weekly Full Rebuild: Velocity recalc, lead time refresh, safety stock recalc Monthly: ABC reclassification, seasonality index update
What do these terms mean?
On-hand: Physical units counted in warehouse Open PO: Ordered but not yet received OOS flag: System flag when available = 0 3 cadences: Balance freshness vs. compute cost
Active only: Exclude Inactive, Phase Out, Discontinued Drop ship: Flagged separately - no warehouse stock expected Unavailable: Suppressed from ordering recommendations Reactivation: Flagged if stock detected on inactive SKU
What do these terms mean?
Why filter? Prevents noise in ordering recommendations Drop ship: Vendor ships direct to customer - not held in warehouse Reactivation: Inactive SKU with positive stock = data anomaly
↓
3
DEMAND VELOCITY
Select best velocity window, apply seasonality and event uplift
▼
Velocity Calculation
Windows: 90 / 180 / 365-day blended, best fit selected Seasonality index: Monthly multiplier from historical pattern Event uplift: Promo calendar factor applied (capped at +50%) Movement profile: Fast / Medium / Slow assigned from result
What do these terms mean?
Velocity: Units sold per day on average Seasonality: Monthly demand index (1.0 = average month) Event uplift: % demand increase during promo events
↓
4
BASE CALCULATIONS
Safety stock, reorder point, days of cover
▼
Formulas
Safety stock: Z(1.65) x sigma(demand) x sqrt(lead time) Reorder point: velocity x (lead time + review cycle) Days of cover: available / adjusted velocity EOQ: sqrt(2 x annual demand x $100 / (cost x 25%))
What do these terms mean?
Safety stock: Buffer against demand spikes and supply delays Reorder point: Stock level that triggers a new order Days of cover: How long current stock lasts at current velocity
↓
5
CLASSIFICATION
OOS risk flag, ABC, PQR - priority order
▼
Flag Assignment Order
1. OUT OF STOCK (available = 0) 2. Below Safety Stock 3. Reorder Now (at/below ROP) 4. Excess Stock (> 2.5x ROP) 5. No Velocity (zero sales) 6. Slow/Dead Stock 7. Healthy (all else)
ABC: 24-month revenue rank | PQR: GM2 margin %
What do these terms mean?
Flag priority: First matching rule wins - order is critical ABC classes: A=top 20% revenue, B=next 30%, C=rest PQR tiers: P=>=35% margin, Q=15-35%, R=<15%
↓
6
PRIORITY SCORE
0-100 urgency score for reorder decisions
▼
Score Components
Urgency tier (40pts): OOS=40, BSS=30, RN=20, RS=10 Margin at Risk (30pts): Scaled to $5,000 = full 30pts ABC class (20pts): A=20, B=13, C=6 Days Cover pressure (10pts): <=7d=10, <=14d=5
Priority Score Badges
85-100: Order Today60-84: This Cycle35-59: MonitorBelow 35: No Action