Inventory Order Packs
Turns stock shortages into whole supplier pack orders from inventory.csv, keeps zero-shortage items at zero, and provides a downloadable purchasing view with reusable Run, Change, and Reset lifecycles.
About this Model
Inventory Order Packs converts inventory stock gaps into whole supplier pack quantities while preventing orders for items already at or above target stock. Using inventory.csv as its sole preserved source, it retains every source row and column, calculates nonnegative shortage units, and rounds required quantities up to full packs. The model produces one reusable Order Packs transform and one downloadable Purchase Quantities view with direct source lineage. Run creates or reuses the current generated state without duplicates. Change adds one safety pack only to items with a positive shortage while preserving existing identities and calculations. Reset removes generated transform, view, and attached dataset state while retaining the source, folder, specification, and agent hierarchy. A subsequent Run restores the original pack calculation and source-only lineage.
- Calculates shortage as the greater of zero and target stock minus on-hand stock.
- Rounds positive shortages up to whole supplier packs and retains all source rows and columns.
- Provides one downloadable Purchase Quantities view backed by the Order Packs transform.
- Change adds one safety pack only where shortage is positive.
- Run reuses generated state without duplicates; Reset returns to the preserved source-only baseline.
- Preserves direct lineage from inventory.csv through Order Packs to Purchase Quantities.