How do you leverage ERP systems to improve supply chain visibility or efficiency at Anheuser-Busch?
For this SQL exercise, use the provided ERP tables to identify active products whose projected inventory remains below the reorder level after qualifying inbound shipments due by 2025-02-28.
product_id, product_name, warehouse_id, snapshot_date, on_hand_qty, inbound_qty, projected_qty, reorder_point, visibility_statusprojected_qty ascending, then product_name, then warehouse_id| Column | Type | Description |
|---|---|---|
| product_idPK | INT | ERP product identifier |
| product_name | VARCHAR(100) | Product name |
| category | VARCHAR(50) | Product category |
| reorder_point | INT | Minimum desired inventory level |
| is_active | BOOLEAN | Whether the product is currently active |
| Column | Type | Description |
|---|---|---|
| snapshot_idPK | INT | Inventory snapshot identifier |
| product_id | INT | Referenced ERP product |
| warehouse_id | VARCHAR(20) | Warehouse identifier |
| snapshot_date | DATE | Date of the inventory snapshot |
| on_hand_qty | INT | Quantity available in the warehouse |
| Column | Type | Description |
|---|---|---|
| shipment_idPK | INT | Inbound shipment identifier |
| product_id | INT | Referenced ERP product |
| warehouse_id | VARCHAR(20) | Destination warehouse |
| quantity | INT | Shipment quantity |
| status | VARCHAR(30) | Shipment status |
| expected_arrival | DATE | Expected arrival date |