ATP Calculations
You can call the ATP function to calculate the cumulative ATP quantity for a current or future date using the Item/Product Availability component. When you promise orders using online reservations or the Reserve Materials process from the Order Entry Form component in PeopleSoft Order Management or from PeopleSoft Inventory, the ATP function is called. No matter how the ATP function is called, the ATP quantity is calculated the same way. After gathering the supply and demand data, the ATP quantity is calculated for each schedule date starting at the furthest point in the future and working back to the current date. The cumulative ATP balance, a running total of the ATP for each schedule date, is calculated next, starting with the current date and working forward to the furthest point where supply or demand exists. The cumulative ATP available on a given date is the quantity that can be promised to orders scheduled for shipment on that date.
WARNING:
If concurrent Reserve Materials processes are running or if ATP is being checked online at the same time, over-promising can occur. For example, the Reserve Materials process runs for a particular order line for item A. ATP is checked and there is just enough quantity to promise to the order line. At the same time, another Reserve Materials process is running for a different order line but for the same item. ATP is checked and again there is just enough to promise. However, the two order lines together would result in a negative cumulative ATP balance. Because both order lines are not yet promised when the simultaneous Reserve Materials processes run, they are excluded from the ATP calculation that the two processes perform, resulting in over-promising. Use the Item/Product Availability Inquiry page, along with the Shortage Workbench, to monitor and correct situations of over-promising.
When orders are promised in batch, the ATP quantity is calculated for the schedule date on each order line for ATP-reserved items. If the schedule ship date of the order line falls within the ATP lead days, but outside of the reservation lead days defined for the item or business unit, the full order line quantity is promised if available or nothing is promised. However, if the order line falls within the reservation lead days, the cumulative ATP balance calculated for the schedule date is promised to the order line up to the full requested quantity and a backorder is created for any unpromised quantity (assuming backorders are allowed).
When you promise an order using online reservations, the ATP function also uses the schedule date to calculate the quantity that can be promised. However, if the full quantity cannot be promised on the schedule date, you can opt to change the request quantity, change the schedule date to the next date that the full quantity can be promised, or split the order line into multiple schedule lines with the maximum quantity that can be promised on those dates. In addition, if the order is a critical one and you must promise a certain schedule ship date and quantity regardless of whether there is enough cumulative ATP quantity on that date, you can do so by reserving the order line directly from the Order Entry Form component.
When you calculate the cumulative ATP online using the Item/Product Availability inquiry component, if a requested quantity was entered as a search criterion, the ATP function calculates the first available ship date for the quantity, if possible. The following sections describe the ATP calculations and demonstrate how the cumulative ATP quantity is calculated for a specific example.
Calculating ATP for Each Schedule Date
In PeopleSoft, ATP is calculated for each schedule date. In this context, schedule date refers to any date in the future that the business unit is scheduled to receive supply or fulfill demand for the item. ATP is calculated for each schedule date starting with the latest date where supply or demand exists. Depending on the specified demand options, one of two algorithms is used.
If dependent demand is not included in the ATP calculation, or if dependent demand is included and the Incl WIP in Starting Qty (include work-in-process in starting quantity) option is selected, the ATP quantity is calculated for each schedule date as follows, starting with the latest schedule date and working back to the current date. The ATP balance for a schedule date equals either the net supply or zero, whichever is larger.
Net Supply = Total Supply Qty for the schedule date − Total Demand Qty for the schedule date − Leftover Demand Qty from the next schedule date
where
Total Demand Qty = Finished Good Demand Qty + Dependent Demand Qty,
and where
Leftover Demand Qty = 0 if this is the latest schedule date, 0 if the Net Supply from the next schedule date is greater than or equal to 0; or the absolute value of the next schedule date's Net Supply, if the Net Supply is less than 0.
ATP for the schedule date representing the current date is calculated slightly differently:
ATP for the Current Date = Starting Qty Available + Total Supply Qty for this and any earlier schedule date − Total Demand Qty for this and any earlier schedule date − Leftover Demand Qty from the next schedule date.
Note:
If the Incl WIP in Starting Qty option is selected, the starting quantity available is the current on-hand available quantity for the item (BU_ITEMS_INV.qty_available), plus the total quantity in WIP locations.
If dependent demand is included in the ATP calculation, but the Incl WIP in Starting Qty option is not selected, the ATP balance is calculated for each schedule date as follows, starting with the latest schedule date and working back to the current date. ATP for the schedule date is equal to the net supply or zero, whichever is larger.
Net Supply = Total Supply Qty for the schedule date − Total Finished Good Demand Qty for the schedule date − Non-WIP Dependent Demand for the schedule date − Leftover Demand Qty
where
Leftover Demand Qty = 0 if this is the latest schedule date, 0 if the net supply from the next schedule date was greater than or equal to 0; or the absolute value of the next schedule date's net supply, if the net supply was less than 0.
In the previous calculation, dependent demand is first netted against available WIP quantity. Once the available WIP quantity is exhausted, dependent demand is netted against non-WIP quantity. Non-WIP dependent demand in the previous calculation refers to any dependent demand quantity that could not be netted against available WIP quantity for that given schedule date. (The Item/Product Availability Inquiry page displays the WIP available quantity. Once this value reaches 0, any subsequent dependent demand is considered to be non-WIP dependent demand and affects the ATP calculation.)
ATP for the schedule date representing the current date is calculated slightly differently. In this case, the starting quantity available is the current on-hand available quantity for the item (BU_ITEMS_INV.qty_available):
ATP for the Current Date = Starting Qty Available + Total Supply Qty for this and any earlier schedule date − Total Finished Good Demand Qty for this and any earlier schedule date − Non-WIP Dependent Demand Qty for this and any earlier schedule date − Leftover Demand Qty from the next schedule date.
Calculating Cumulative ATP
Cumulative ATP is a running total of the ATP quantity calculated for each schedule date. After the ATP quantity is calculated for each schedule date, starting with the latest schedule date and working backward, the cumulative ATP balance can be calculated starting with the current date and working forward:
Cumulative ATP = Cumulative ATP for the prior date (or 0 if today's date) + the ATP for the schedule date.
Calculating Available Quantity for Each Schedule Date
The available quantity that appears on the Item/Product Availability Inquiry page is a running total of the available quantity calculated by adding supply or subtracting demand in chronological order. The available quantity calculated for the last schedule date should always match the cumulative ATP; however, available quantity and cumulative ATP values may differ for intermediate schedule dates. The ATP calculation is a more sophisticated approach, netting supply and demand across multiple days to reflect more accurately how much quantity is available to promise on a particular date.
Note:
Available quantity is calculated for display only on the Item/Product Availability inquiry page. This calculation is not performed when promising order lines.
If dependent demand is not included in the ATP calculation, or if dependent demand is included and the Incl WIP in Starting Qty option is selected, the available quantity is calculated for each schedule date as follows, starting with the current schedule date and working forward:
Available Qty = Available Qty for the previous schedule date (or Starting Qty Available for today's date) + Total Supply Qty for the schedule date − Total Demand Qty for the schedule date.
If dependent demand is included in the calculation and the Incl WIP in Starting Qty option is selected, total demand quantity in the previous formula is calculated as follows:
Total Demand Qty = Total Finished Good Demand Qty + Total Dependent Demand.
If dependent demand is included in the ATP calculation, but the Incl WIP in Starting Qty option is not selected, available quantity is calculated for each schedule date as follows, starting with the current schedule date and working forward:
Available Qty = Available Qty for the previous schedule date (or Starting Qty Available for today's date) + Total Supply Qty for the schedule date − Total Finished Good Demand Qty for the schedule date − Non-WIP Dependent Demand for the schedule date.
Calculating the First Available Ship Date
If you specify a quantity requested on the Availability Inquiry Selection page, the ATP function calculates the first available ship date for the specified quantity as follows:
-
The quantity requested is compared with the cumulative ATP starting with today's schedule date and working forward.
-
When the cumulative ATP is equal to or greater than the quantity requested, the schedule date is checked against valid shipping dates for the business unit defined on the Closure Calendar page.
-
The first schedule date on which the cumulative ATP is greater than or equal to the quantity requested and on which the date is valid for shipping operations for the business unit is recorded as the first available ship date.
-
If no available ship date is found with enough cumulative ATP quantity, a message appears.
When you promise an order online using the Order Entry Form component, you provide the order quantity and schedule ship date, and the ATP function determines whether the quantity can be promised on the given ship date. If the ATP function determines that the full quantity cannot be promised on the schedule date, you can change the request quantity, change the schedule date to the first date that the full quantity can be promised (the first available ship date), or split the order lines into multiple schedule lines with the maximum quantity that can be promised on those dates.
Example ATP Calculation
To illustrate how ATP is calculated for a given time period, consider the following picture of demand and supply for an ATP calculation made on May 1.
| Schedule Date | May 1 | May 2 | May 3 | May 4 | May 5 | May 6 | May 7 | May 8 |
|---|---|---|---|---|---|---|---|---|
|
Demand |
||||||||
|
Promised |
50 |
100 |
60 |
50 |
100 |
120 |
40 |
60 |
|
Dependent Demand |
40 |
40 |
20 |
|||||
|
Total Demand |
90 |
100 |
60 |
50 |
140 |
140 |
40 |
60 |
|
Supply: |
||||||||
|
Current Available |
150 |
|||||||
|
Purchase Orders |
100 |
|||||||
|
Transfers |
||||||||
|
Scheduled Production |
200 |
300 |
300 |
|||||
|
Total Supply |
150 |
300 |
0 |
0 |
300 |
300 |
||
|
ATP Per Schedule Date |
60 |
70 |
0 |
0 |
0 |
0 |
0 |
240 |
|
Cumulative ATP |
60 |
130 |
130 |
130 |
130 |
130 |
130 |
370 |
In this sample ATP calculation, the current date is May 1 and the latest scheduled date for both promised demand and incoming supply is May 8. Demand or supply orders exist every day between, providing an eight-day period over which to calculate available future supplies.
The May 1 date represents today's supply and demand, which includes any supply orders scheduled to be received today, any demand orders scheduled to be fulfilled today, and any supply or demand orders that have not been received or fulfilled as scheduled for schedule dates before May 1. The Incl WIP in Starting Qty option is selected in this example, so the available quantity for the item in the business unit (from BU_ITEMS_INV.qty_available), plus the total quantity of the item in WIP locations is captured as part of the supply for the current schedule date. This is the current available quantity in the previous chart.
After supply and demand information has been captured, the ATP balance for each schedule date is calculated, starting with the schedule date at the furthest point in the future and working back to the current date. In this example, the ATP is first calculated for May 8 by subtracting the total demand scheduled for fulfillment on May 8 from the total supply scheduled for receipt: 300 − 60 = 240.
ATP is calculated as the larger of two values: net supply or zero. Therefore, for schedule dates when there is no supply or when demand exceeds supply resulting in a negative net supply, the ATP is zero. For this reason, the ATPs for schedule dates May 7, May 6, May 4, and May 3 are each 0.
For May 5, a total supply of 300 is scheduled for receipt and a total demand of 140 is scheduled for fulfillment. However, in addition to the demand for May 5, the ATP calculation must also account for demand for future dates on which there is no scheduled supply. In our example, total demand from May 6 and May 7 is also subtracted from the May 5 supply to calculate the ATP for May 5: 300 − 140 − 140 − 40 = -20. Since this is less than 0, the ATP quantity is set to 0, with 20 considered as leftover demand quantity.
Demand from May 2, May 3, and May 4, plus any leftover demand quantity is then subtracted from the supply expected on May 2 to calculate the ATP for May 2: 300 −100 − 60 − 50 − 20 = 70. The leftover demand quantity is reset to 0, because there was enough supply to meet the demand. Finally, the ATP for the current date, May 1, can be calculated: 150 − 90 = 60.
Cumulative ATP is a running sum of the ATP quantities calculated for each schedule date. Cumulative ATP for a given date is calculated by adding the ATP for that date to the cumulative ATP of the prior date. The cumulative ATP of the current date will always be the same as its ATP quantity. For example, the ATP (and cumulative ATP) quantity for May 1 is 60 and the ATP quantity for May 2 is 70; therefore, the cumulative ATP for May 2 is 130 (60 + 70 = 130). The cumulative ATP for May 3 is also 130 (130 + 0 = 130).
Related Topics