Who asked: Niko, the stock coordinator at fictional Greenline Garden Supply.
Why: a weekly reorder list needs to account for demand during supplier lead time, then add a small cover period. Orders must be in complete packs.
Data: Inventory contains six stock records. Catalog contains item names, lead days, and pack sizes. G-999 is absent from Catalog and must be held for review. One known item has no demand, and another sits exactly at its reorder point.
Deliverable: names and lead times from Catalog, reorder points, suggested units, explicit statuses, a positive-order list, totals, whole packs, a checked readiness message, and highlighted rows needing review. An unknown item must never become a guessed purchase.
A reorder point answers when to order: the demand expected while stock is in transit. The suggested quantity answers how much: enough to cover that lead time plus the extra cover period, less what is already on hand. Keep those two questions separate.
The boundary matters. This team's rule is to review items at or below the reorder point. A zero-demand item can meet that boundary but still need zero units. A missing catalog key is a data issue, not evidence that its lead time is truly zero; the name and status keep that distinction visible.
The final steps turn suggested units into whole supplier packs and a readiness message. Later formulas read your earlier work, so keep the workbook consistent rather than typing a separate answer for each step.