| BBU | Project Item | Department | Customer Required Date | Engineering Status | Material ATP | Procurement ETA | Production Days | Inspection Days | Dispatch Days | Total Lead Time | ATP Delivery Date | Delay Days | Status | ERP Action | Formula Logic |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BBU-001 | AHU 15000 CFM | HVAC Engineering | 25-May-2026 | Approved | Available | - | 7 | 2 | 2 | 11 | 20-May-2026 | 0 | ON TIME | Release Production WO | Prod + Insp + Dispatch |
| BBU-002 | Chilled Water Pipe | Procurement | 18-May-2026 | Approved | Partial | 15-May-2026 | 4 | 1 | 1 | 10 | 21-May-2026 | 3 | RISK | Expedite Vendor | PO ETA + Production LT |
| BBU-003 | Ducting Package | Production | 30-May-2026 | Approved | Available | - | 15 | 2 | 3 | 20 | 28-May-2026 | 0 | ON TRACK | Continue Production | Current Date + Balance LT |
| BBU-004 | Cooling Tower | Vendor Supply | 22-May-2026 | Approved | Not Available | 28-May-2026 | 0 | 1 | 2 | 11 | 31-May-2026 | 9 | DELAY | Escalate To SCM Head | Vendor ETA + Dispatch LT |
| BBU-005 | Electrical Panel | Electrical | 12-Jun-2026 | Drawing Pending | Available | - | 8 | 2 | 1 | 14 | 18-Jun-2026 | 6 | ENGG HOLD | Generate Design Escalation | Drawing Delay + MFG LT |
| BBU-006 | Fire Dampers | QA/QC | 28-May-2026 | Approved | Available | - | 6 | 5 | 2 | 13 | 29-May-2026 | 1 | QC RISK | Prioritize Inspection | Production + QC + Dispatch |
| Logic | Formula | Purpose |
|---|---|---|
| ATP Quantity | Stock + Incoming Supply - Allocated Qty | Available quantity for customer promise |
| Delivery Date | Material ETA + Production LT + QC LT + Dispatch LT | Customer committed delivery date |
| Delay Days | ATP Date - Customer Required Date | Delay measurement |
| Critical Path | MAX(Engineering, Procurement, Production) | Identify bottleneck |
| Project Completion % | Completed BBU / Total BBU | Project tracking |
| Material Constraint | IF(Material ATP = 0) | Generate SCM escalation |
| Department | ERP Responsibility | ATP Impact |
|---|---|---|
| Engineering | Drawings / BOM Release | Cannot start procurement without approval |
| SCM Procurement | PO / Vendor Follow-up | Controls material availability |
| Stores | Inventory Reservation | ATP stock allocation |
| Production | Manufacturing | Determines fabrication completion |
| QA/QC | Inspection / Testing | Shipment clearance |
| Projects | Site Coordination | Delivery sequencing |
| Logistics | Dispatch Planning | Transit scheduling |
| CRM | Customer Promise Management | Customer communication |
| Trigger | AI Ticket | Department |
|---|---|---|
| Engineering Drawing Pending | Urgent Design Approval | Engineering |
| Material Shortage | Immediate Procurement | SCM |
| Vendor Delay | Vendor Escalation | Purchase |
| Production Overload | Capacity Balancing | Production |
| Inspection Delay | QA Priority Inspection | QA/QC |
| Dispatch Risk | Transport Planning Alert | Logistics |
| Customer Delivery Delay | CRM Customer Intimation | CRM |