Bulk Inventory Planner

How the result is calculated

Each row is calculated independently with the same conservative logic as the Reorder Planner:

• On-hand days = on-hand units ÷ average daily sales; the estimated stockout date is today plus the whole days of cover.
• Reorder point = average daily sales × supplier lead time. The bulk schema has no per-SKU safety-stock column, so the reorder point here is lead-time demand only; add your buffer when reviewing.
• Projected inventory at PO arrival = on-hand − (sales × lead time), plus confirmed inbound only when it arrives by the new PO arrival.
• Recommended order = target (sales × target coverage) − projected inventory, floored by MOQ and rounded up to whole case packs.
• Estimated purchase cost = recommended order × unit cost; blank unit cost leaves it unavailable.

Assumptions

Blank inbound quantity means zero. Arrival days are required whenever inbound quantity is greater than zero and are ignored otherwise. All timing is an estimate in whole days and does not guarantee same-day receiving. Results are planning estimates from the numbers in your file, not purchase instructions.

When not to rely on this result alone

Demand in the file is treated as constant, and lead time as fixed, for every SKU. Seasonality, promotions, shelf life, storage limits, cash constraints, and supplier reliability are not modeled here.

Review each “Order now” row before purchasing, especially high-cost lines. Rows with warnings need a second look; rows with errors are excluded from recommendations until fixed.

Open the Reorder Planner for a single-SKU deep dive, or read the planning basics.