Company Dashboard
Where every open order stands today, and what is stopping the rest.
Order pipeline
Each order lands in one of these four states. Stock is reserved in due-date order — the order due first takes material off the shelf, so later orders see only what is left.
What is blocking production
Ranked by how many motors each shortage holds up, so a 169 KG wire shortfall and a 145 NOS rotor shortfall compare fairly.
Alerts needing attention
Newest and most severe first. Acknowledging hides an alert until the situation changes.
Delivery calendar
Next 60 days. Anything left of the today line is already past its promised date. Hover a marker for that order's coverage.
Orders
Click any order to see exactly which materials it needs and what is missing.
| Order | Customer | Ordered | Due date | Days left | From stock | To make | Buildable | Blocked | Short items | Coverage | Status |
|---|
Inventory
Raw material master for the motor's bill of material. Free is what is left after earlier orders have reserved their share.
| Item no. | Description | Category | UOM | Per motor | Stock | Reserved | Free | Shortfall | Reorder at | Lead | Covers | Status |
|---|
Procurement & Alerts
What to buy, and by when. Order by works backwards from the earliest date the material is needed, minus its lead time and a 3 day buffer.
Purchase requirement
Shortfall summed across every open order.
| Item no. | Description | Shortfall | UOM | Blocks motors | Lead | Needed by | Order by | Days left | Orders affected |
|---|
Alert log
Every warning the planner raised on the current position.
Motor Master
Reference data read straight from the two source workbooks — nothing here is editable.
Bill of material
Acceptance limits for routine test
Pass / fail bands the motor is tested against before dispatch.