One Data Layer · IMS · WMS · TMS · FAMS
A finding in one system. Visibility in all four.
IMS surfaces a dormant SKU. WMS shows where it's tying up pallet positions. TMS shows the outbound routes affected. FAMS shows the rack equipment overdue for service. All of it on a single data layer. No other platform in the Philippine mid-market does that today.
IMS
Inventory Management
Total inventory value
₱10.9M
12 SKUs under management
WMS
Warehouse Management
Dead capital identified
₱4.56M
TMS
Transport Management
Routes > 15% cost variance
3
FAMS
Facility Asset Management
Assets > 30 days overdue
3
Cross-system narrative · Metro Manila DC
IMS
₱10.9M of inventory across 12 SKUs is on hand.
WMS
₱4.6M of that is dead stock sitting at WH-MNL.
TMS
outbound routes from WH-MNL are running 24.7% over plan.
FAMS
the rack bays holding that stock have been overdue for service for 42 days.
Recommendation: Liquidate dormant stock first. Free pallet positions release rack bay AST-RR-007 for overdue maintenance, which restores 18% throughput on the affected outbound routes.
IMS Top inventory positions
| SKU | ABC | Value |
|---|---|---|
|
Legacy Display Unit DM-9
SKU-1009
|
C | ₱2,254K |
|
HDPE Resin Pellets 25kg
SKU-1004
|
A | ₱2,240K |
|
Promo Q1 Tarpaulin Pack
SKU-1010
|
C | ₱1,710K |
|
Seasonal Holiday Bundle
SKU-1012
|
C | ₱1,702K |
WMS Dead stock at WH-MNL
| SKU | Trapped | Days |
|---|---|---|
|
Promo Q1 Tarpaulin Pack
SKU-1010
|
₱1,710,000 | 142d |
|
Legacy Display Unit DM-9
SKU-1009
|
₱1,666,000 | 184d |
|
Seasonal Holiday Bundle
SKU-1012
|
₱1,184,000 | 118d |
TMS High-variance routes
| Route | Variance | Carrier |
|---|---|---|
|
Cebu Hub → Davao South Yard
RT-CEB-DAV-01
|
+26.3% | Solomon Fleet |
|
Metro Manila DC → Davao South Yard
RT-MNL-DAV-01
|
+25.4% | LBC Express |
|
Metro Manila DC → Cebu Hub
RT-MNL-CEB-01
|
+22.5% | 2GO Logistics |
FAMS Overdue assets
| Asset | Warehouse | Overdue |
|---|---|---|
|
Selective Pallet Rack Bay 7
AST-RR-007 · Storage
|
WH-MNL | 42d |
|
Toyota Forklift 8FBN25
AST-FK-014 · Material Handling
|
WH-MNL | 35d |
|
Mezzanine Rack Section M-3
AST-RR-019 · Storage
|
WH-DAV | 10d |
Pilot scope · 14 days, read-only access
SQL queries Solomon runs against your systems
- Dead stock: items with zero movement > 90 days
- Logistics variance: routes with > 15% cost deviation
- Asset risk: equipment with maintenance overdue > 30 days
- Supplier risk: POs delayed > 2× average lead time
Pilot offer
Connect Solomon to your existing system for two weeks — no cost, no commitment. We'll show you exactly what Solomon sees in your operations. If what we find is worth acting on, we'll talk about next steps. If not, you keep the report.