Available to promise (ATP) is the quantity of an item you can offer a new customer without breaking a promise you already made. It is not the same as stock on hand: some of that stock belongs to orders you have not shipped yet. This guide gives the formula, a worked example and the mistakes to avoid.
ATP vs on hand vs available
| Term | What it counts | What it answers |
|---|---|---|
| On hand | Units on the shelf | What do we have? |
| Available | On hand less what open orders have already taken | What is not spoken for today? |
| Available to promise | On hand plus purchase orders arriving, less open orders, checked day by day | What can I promise a new customer, and for when? |
The ATP formula
Supply − orders on a day = supply ready by that day − open orders due by that day
Supply is the stock on hand plus the purchase orders (or production) that will be ready by that day. Work it out for each day something changes: a purchase order arrives or an order falls due. Then apply one more rule, the look ahead:
Available to promise on a day = the lowest “supply − orders” on that day or any later day
Without the look ahead you would promise stock today that a later order needs.
A worked example
You have 100 units on hand. A purchase order for 50 is ready on day 10. Two customer orders are open: 80 units due on day 5 and 60 units due on day 20.
| Day | Supply ready | Orders due | Supply − orders |
|---|---|---|---|
| Today | 100 | 0 | 100 |
| Day 5 | 100 | 80 | 20 |
| Day 10 | 150 | 80 | 70 |
| Day 20 | 150 | 140 | 10 |
The lowest figure from today onward is 10, so 10 units are available to promise today. It looks as if 100 are free today and 20 after day 5, but selling more than 10 now would leave the day 20 order short. A new order for 10 can ship today. A new order for 11 needs a new purchase order.
How to promise a date for an open order
- List the supply for the item in date order: stock today, then each open purchase order on the day it is ready to ship, not the day it is due at the dock.
- List the open orders in due-date order. Overdue orders come first.
- Give supply to orders in that order. An order can ship on the day its last unit is ready.
- Compare with the due date. If it is later, tell the customer now and ask the supplier to pull the purchase order in.
- If supply runs out, the order needs a new purchase order: the earliest date is today plus the lead time.
Common mistakes
- Promising from stock on hand. The shelf looks full because earlier orders have not shipped yet.
- Trusting purchase order due dates. A promise built on a late purchase order is late too. Confirm the dates with your suppliers.
- Forgetting the time from the dock to the truck. Add the days to receive, inspect and pick.
- Counting stock twice, when two people promise from the same screen on the same day.
- Leaving dead orders in the list. An overdue order still takes stock: ship it or cancel it.
Measure it
Track the share of order lines that shipped on or before the date you promised. It tells you whether your promises are worth anything. Fill rate and service level measure whether the stock was there; on time to promise measures whether you kept your word.
Spreadsheet or software?
A spreadsheet works for one item at a time, which is how most customer service teams use it. It gets slow when one purchase order feeds ten orders and a date moves. Order promising software does every open line at once and lists the purchase orders to expedite. For a quick check on one item, use the free available to promise calculator.
See order promising on sample data
The live demo needs no account. Use the sample company or load your own files, which stay in your browser tab.
Frequently asked questions
What does available to promise mean?
The quantity of an item that can be promised to a new customer order for a given date without making an existing order late.
What is the ATP formula?
Supply ready by a date (stock on hand plus purchase orders arriving) less the open orders due by that date. The amount you can promise is the lowest of that figure on the date and on every later date.
What is the difference between ATP and CTP?
Available to promise uses stock and supply already on order. Capable to promise also asks whether more could be made or bought in time, using capacity and lead times.
Try the Statadventure live tools
Inventory tools for US manufacturers: reorder point, safety stock, EOQ and landed cost, with the inputs and assumptions shown.
Open the live tools