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.
Output
- One row per at-risk product and warehouse
- Columns:
product_id, product_name, warehouse_id, snapshot_date, on_hand_qty, inbound_qty, projected_qty, reorder_point, visibility_status
- Include only the latest inventory snapshot and products below their reorder point
- Order by
projected_qty ascending, then product_name, then warehouse_id
Output details
- Treat inbound shipments with statuses
Confirmed or In Transit as qualifying.
- Include shipments whose expected arrival is on or before
2025-02-28.
- Treat missing inbound quantities as
0 and calculate projected_qty as on_hand_qty + inbound_qty.
- When snapshot dates tie, select the snapshot with the greatest
snapshot_id.
- Sort
projected_qty, product_name, and warehouse_id in ascending order.
- Label rows
Stockout when projected_qty is less than or equal to 0; otherwise label them Below Reorder Point.
