4 Week Example: Available to Promise Calculations for Logistics Ops

Isometric four-stage inventory availability illustration

Available-to-promise (ATP) is the uncommitted quantity of inventory a business can safely commit to a customer, plus the date it can be delivered. The core formula is on-hand inventory plus scheduled receipts minus committed demand. ATP lets sales teams promise real orders without cannibalizing inventory already committed elsewhere, though the exact math varies by ERP and WMS platform.


TL;DR:

  • ATP accuracy heavily depends on real-time inventory updates, with delays and outdated data causing discrepancies in promised versus actual availability.
  • Using advanced models like CTP or AATP is advisable for high-mix, build-to-order environments to prevent promising dates the production cannot meet.
  • Shorter batching intervals for ATP checks improve responsiveness and order acceptance but require fast, reliable inventory data feeds.
  • Regular reconciliation between ATP outputs and manual stock counts helps identify system drift and maintain promise reliability.
  • A 3PL provider can significantly enhance ATP precision through live inventory management and same-day fulfillment services.

Envio Logistics, Inc
Bring Inventory Promises Into Focus
ENVIO provides live inventory data and same-day fulfillment services to help growing brands manage orders with greater visibility.
Schedule a Chat

Table of Contents

What Is Available-to-Promise and Why Does It Matter?

ATP draws a hard line between inventory you can sell right now and inventory that’s already spoken for. On the supply side, it counts on-hand stock, open purchase orders, and planned production receipts. On the demand side, it nets out confirmed sales orders and the component requirements those orders trigger downstream. Standard ATP models exclude sales forecasts from committed demand, which is one of the most common sources of confusion for teams new to the ATP calculation discipline. A forecast tells you what might happen. ATP only cares about what’s already been promised.

That distinction drives several practical use cases:

  • Real-time order checks at the point of sale, before a rep confirms a quantity or date
  • Customer service teams validating whether a rush order can actually ship on time
  • Sales and operations planning (S&OP) reviews that reconcile bookings against actual incoming receipts

Get this wrong and you end up overselling SKUs that look available but aren’t, or underselling ones that are.

Push vs. Pull, Multilevel ATP, CTP, and AATP: Which Model Fits?

Not every ATP check works the same way, and picking the wrong model for your product mix creates false confidence in numbers that don’t hold up.

Push ATP allocates inventory against a forecast or master production schedule before real orders arrive, useful for make-to-stock businesses with predictable demand. Pull ATP allocates only against confirmed orders as they land, which fits build-to-order or highly variable demand better.

Multilevel ATP checks availability against existing time-phased supply and demand records and tends to be faster than alternatives that simulate scheduling on the fly, according to SAP’s own comparison of ATP methods.

Capable-to-promise (CTP) kicks in when a plain ATP check fails. It triggers a real-time simulation, creating temporary planned orders and checking both component availability and production capacity to generate a firm delivery date.

Advanced ATP (AATP) re-optimizes across a rolling horizon rather than checking one order at a time. Research on AATP in production scheduling environments found that this approach improves order acceptance rates and profitability, and that the batching interval, how often the system re-runs its optimization, is a major factor in how well it holds up under demand uncertainty.

Pro Tip: If your business runs high-mix, make-to-order production, don’t default to plain ATP because it’s simpler to build. CTP or AATP will cost more in system complexity but will save you from promising dates your shop floor can’t hit.

How Do You Calculate ATP? Formulas and Methods

The formula changes slightly depending on which period you’re calculating and which method your system uses, but the underlying logic stays consistent: available supply minus committed demand.

For the first period, Oracle’s JD Edwards documentation lays out the formula this way:

  1. First-period ATP = On-hand inventory − Safety stock + Work orders + Purchase orders + Planned orders − Sales orders − Other committed demand
  2. After-first-period ATP = Prior period’s ATP + That period’s planned receipts − That period’s committed demand

Three calculation methods show up repeatedly in academic and vendor literature on order promising, according to a widely cited MIT thesis on order promising models:

  • Discrete ATP nets supply and demand within a single, isolated time bucket, with no carryover from earlier periods.
  • Cumulative ATP with look-ahead rolls forward negative balances into future receipts, letting a shortfall in one week borrow against a shipment arriving the next.
  • Cumulative ATP without look-ahead nets period by period without borrowing forward, which produces more conservative, less risky promise dates.

Safety stock gets subtracted from on-hand inventory before anything else happens. Some ERP systems, notably several Oracle configurations, are built to never display a negative ATP figure. Instead they floor the result at zero and flag the shortfall separately, which matters when you’re reconciling system output against a manual spreadsheet check.

Worked Example: Calculating ATP Across Four Weeks

Worked Example: Calculating ATP Across Four Weeks — overview diagram

Here’s a single SKU tracked over four weekly periods, using the after-first-period formula above.

Inputs: Opening on-hand: 500 units. Safety stock: 50 units. Scheduled receipts: 200 units in Week 2, 300 units in Week 4. Confirmed sales orders: 180 (Week 1), 220 (Week 2), 150 (Week 3), 100 (Week 4).

  1. Week 1 ATP = 500 − 50 − 180 = 270 units available to promise
  2. Week 2 ATP = 270 + 200 − 220 = 250 units
  3. Week 3 ATP = 250 + 0 − 150 = 100 units
  4. Week 4 ATP = 100 + 300 − 100 = 300 units

If a new order for 350 units arrives in Week 3, the system either rejects the full quantity, splits it into a partial fulfillment against the 100 available, or pushes the remainder to Week 4 where supply reopens. Mapping this to a live ERP ATP check works the same way: pull the same four data points (on-hand, safety stock, receipts, confirmed demand) and the module runs the identical math, just faster and across more SKUs at once.

Where Does ATP Sit in the Tech Stack?

ATP isn’t a standalone report. It’s a live check that has to touch order entry, your ERP’s planning module, and whatever OMS or WMS feeds it real inventory positions.

  • Order entry is where the check actually happens, at the moment a rep or a customer tries to confirm a quantity and date.
  • ERP planning modules hold the scheduled receipts, safety stock rules, and component pegging that feed the calculation.
  • WMS and live inventory feeds keep on-hand numbers accurate in near real time, which matters more than almost anything else in the formula.

Batching interval, how often the system re-optimizes, has a direct effect on both order acceptance and profitability, particularly under volatile demand conditions. Shorter intervals generally help responsiveness, though there’s a practical ceiling based on how fast your data actually updates. Watch three signals to catch drift early: promise reliability (percentage of dates actually hit), order rejection rates, and periodic reconciliation tests between system ATP and a manual recount.

Common ATP Pitfalls and Best Practices

The most expensive ATP mistakes are quiet ones. Someone treats a forecast as committed demand, or the team confuses cumulative ATP with a daily snapshot, and nobody notices until a customer calls asking where their order went.

  • Treating forecast demand as committed demand inflates promised availability that doesn’t exist.
  • Ignoring lot sizes or rounding rules can promise fractional quantities that never ship as ordered.
  • Skipping capacity checks in make-to-order environments leads to dates the shop floor can’t hit, which is exactly the gap CTP exists to close.

CTP adds real value when you need a time-specific commitment and can absorb the added system complexity. It’s overkill for a fast-moving make-to-stock SKU where multilevel ATP already answers the question in milliseconds.

Pro Tip: Run a monthly reconciliation between your ERP’s ATP output and a manual spreadsheet pull on your highest-volume SKUs. If the numbers drift by more than a few units, you’ve likely got a stale scheduled-receipts feed, not a formula problem.

Document your ATP rules in plain language that sales, planning, and finance all read the same way, and set batching intervals deliberately rather than accepting whatever the default install shipped with.

A 3PL Operator’s View on ATP Reliability

Every ATP formula assumes accurate inputs, and that’s exactly where most breaks happen. A perfect calculation running against a three-day-old on-hand number produces a confident, wrong answer. Fast receiving and live inventory visibility close that gap faster than any formula tweak. Same-day shipping cutoffs and SKU-level profitability data also help teams prioritize which products deserve tighter allocation rules and which don’t. A simple reconciliation test, comparing promised ship dates against actual ship dates weekly, tells you more about your ATP health than any dashboard.

— Claudio Saenz

How Envio Supports Reliable Order Promises

A 3PL closes the gap between what your ATP formula says and what actually ships by giving you live inventory data that many in-house systems lack. Instead of juggling separate vendors for warehousing, marketplace prep, and DTC orders, all of which can obscure real-time stock positions, Some 3PL providers combine warehousing, marketplace prep, and direct-to-consumer order fulfillment functions under one roof. They often do so without requiring long-term contracts.

Envio Logistics, Inc

If your ATP numbers keep drifting from reality, the fix usually isn’t a better formula. It’s faster, more visible receiving and shipping data feeding that formula. Envio’s live inventory portal and same-day shipping cutoff for orders placed by 1PM CST shrink the lag between “on-hand” and “actually available,” while Amazon and Walmart prep services keep marketplace lead times out of your promise dates. Check current service pricing and options and request a quote to see where a fulfillment reconciliation gap might be costing you promised orders.

Sources

For vendor-level detail, Oracle’s ATP calculation documentation and SAP’s ATP vs. CTP comparison cover the operational mechanics. For academic depth on optimization-based and advanced ATP, see the MIT thesis on order promising and recent AATP research on batching interval effects.

FAQ

What Is the Difference Between Available-to-Promise and Capable-to-Promise?

ATP checks existing supply records, on-hand inventory and scheduled receipts, against committed demand without running any new simulation. CTP goes further: when ATP comes up short, it simulates production scheduling in real time, checking both component availability and capacity constraints to generate a firm delivery date.

What Does “Available to Promise” Mean in SAP?

In SAP, available-to-promise refers to the multilevel ATP check that verifies stock and planned receipts against demand across a bill of materials, typically faster than a CTP simulation for straightforward orders. SAP’s PP/DS module escalates to CTP when a time-specific commitment requires a scheduling check the standard ATP can’t provide.

What Does ATP Stand for in Sales and Order Management?

ATP stands for available-to-promise, the quantity of inventory a sales team can commit to a customer order without breaking a commitment already made elsewhere. It’s calculated as on-hand stock plus scheduled receipts minus committed demand, and it excludes uncommitted forecast demand by default.

How Does a 3PL Like Envio Support ATP Accuracy?

A 3PL improves ATP accuracy mainly by tightening the lag between physical inventory changes and system records. Envio Logistics, Inc offers a live inventory portal and same-day shipping for orders placed by 1PM CST, which narrows the window where promised quantities and actual stock positions can drift apart.

0 comments

Leave a comment