How To Calculate Available-to-Sell: Steps For Warehouses And 3PLs

Inventory available for new orders after accounting for reservations, holds, buffers, and allocations.

Available-to-Sell Inventory available for new orders after accounting for reservations, holds, buffers, and allocations. Calculating ATS reliably requires consistent data sources, clear reservation rules, and coordinated processes between sales channels, WMS, and replenishment systems. This article provides a step-by-step approach to compute ATS and operational controls to maintain it.

The foundational premise is simple: start with a trusted physical inventory number and subtract the quantities that are not available for new order commitment. The challenge lies in ensuring every subtraction (reservations, holds, buffers, allocations) is applied consistently and reflected in real-time across all systems that consume ATS.

Step-By-Step Calculation Process

Follow these operational steps to compute ATS accurately:

• Verify On-Hand Quantity: Use the latest cycle counts or a recent full count as the authoritative on-hand value in the WMS.
• Subtract Confirmed Reservations: Remove quantities already allocated to confirmed sales orders, retailer allocations, or cross-dock commitments.
• Subtract On-Hold Inventory: Deduct units quarantined for quality inspection, damage review, or regulatory holds. Ensure each hold reason and duration is codified in the system.
• Apply Buffers/Safety Stock: Enforce configured safety stock levels per SKU or channel. Some operations maintain a single facility-wide buffer; others use channel or customer-specific buffers.
• Account For Allocated Inbound Receipts (Optional): If your policy reserves inbound receipts for specific channels or orders, reduce ATS for the period until receipts are available to general pool.
• Sync With Sales Channels: Push the computed ATS to marketplaces, storefronts, and ERP systems so order acceptance uses the latest number.

System Configuration And Data Sources

Accuracy depends on where each piece of data comes from and how systems treat it:

• Authoritative On-Hand Source: Designate the WMS or inventory service as the master for on-hand counts and ensure other systems defer to it.
• Reservation Timing: Decide whether reservations occur at cart checkout, order placement, or at payment confirmation — each choice changes how often ATS fluctuates.
• Hold Workflows: Integrate quality and returns modules so holds are automatically reflected in inventory calculations.
• Near-Real-Time Sync: Use event-driven APIs for reservations, cancellations, and receipts to keep ATS current across platforms.

Handling Special Cases

Real warehouses face exceptions that require explicit rules:

• Pre-Allocated Inbound Purchase Orders: Reserve inbound units for high-priority customers before physical receipt; these reduce ATS even though not yet on-hand.
• Lot/Serial Restrictions: If certain lots are restricted to specific channels due to compliance, deduct them from ATS for other channels.
• Returns In Transit: Decide whether returns in transit are counted toward ATS; many operations exclude them until processed.
• Damaged Or Obsolete Stock: Exclude items flagged as damaged or obsolete from ATS even if they remain in physical storage.

Practical Example With Calculation Walkthrough

Warehouse B tracks SKU-500 with these values: 2,400 on-hand, 900 reserved to confirmed orders, 100 units on hold for inspection, and a buffer of 200 for upcoming retail replenishment. Additionally, 300 units of an inbound PO are pre-allocated to a VIP customer and considered committed on arrival. The ATS outcome:

ATS = 2,400 (On-Hand) – 900 (Reserved) – 100 (On-Hold) – 200 (Buffer) – 300 (Inbound Allocated) = 900 units available for new orders.

Operational Controls And KPIs To Monitor ATS Health

To keep ATS reliable, track these KPIs and controls:

• Reservation Latency: Time between order placement and reservation creation — lower latency preserves ATS accuracy.
• Hold Turnaround: Average time inventory spends on hold — long holds reduce effective ATS.
• Cycle Count Variance: Discrepancy rates from cycle counts — high variance signals ATS drift from reality.
• Channel Allocation Accuracy: Percentage of allocations that require manual correction — lower is better.

Tips For Implementation

Practical steps when implementing ATS calculations in a WMS or OMS:

• Start Simple: Implement a base ATS formula first, then add optional complexities (inbound allocations, lot rules) once stable.
• Document Rules: Maintain a single source of truth for reservation, hold, and buffer policies to avoid ad hoc changes.
• Test Integrations: Simulate peak events (sales spikes, large returns) to observe ATS behavior under load.
• Communicate Changes: Ensure sales, customer service, and inventory planning teams understand ATS policy changes before rollout.

In short, the Available-to-Sell number equals your on-hand stock minus reservations, holds, buffers, and allocations. Implement it through authoritative data, clear reservation rules, and event-driven synchronization so teams can trust the inventory numbers they use to accept and fulfill orders.