Previous | Next | Contents | Index | Navigation | Glossary | Library |
ATP is based on a specific MPS, DRP or MRP plan and is non-cumulative. Changes to on-hand quantities, scheduled receipts, and demands made after the planning process is completed are not reflected in ATP until the next time the material plan is executed.
Note: Any ATP calculation done through Oracle Master Scheduling/MRP and Oracle Supply Chain Planning does not consider the ATP rules you define in Oracle Inventory. For instructions on viewing or calculating ATP through Oracle Inventory, see: Viewing ATP Information.
Note: Committed demand does not include forecasted demand or manually entered master demand schedule entries. Also, the amount available during each period is not cumulative. Oracle Master Scheduling/MRP and Supply Chain Planning does not consider ATP quantities from prior periods as supply in future periods.
The Available to Promise formula is:
Beginning Inventory | Period 1 | Period 2 | Period 3 | Period 4 | |
---|---|---|---|---|---|
Forecasts | 20 | 40 | 40 | ||
Manual Entries | 50 | 40 | 10 | ||
Sales Orders | 40 | 20 | 50 | ||
Scheduled Receipts | 110 | 40 | 30 | 50 | |
Planned Orders | 20 | 50 | |||
Nettable On Hand | 20 | ||||
ATP | 110 | 20 | 30 | 50 | |
Table 1 - 51. MRP Plan for Item A (Page 1 of 1) |
The scheduled receipts (110), planned orders (20), and nettable quantity on hand (20) equal 150 in total supply for period 1. To calculate the total available to promise for period 1, subtract all committed demand from the total supply. The committed demand comes from the following sources: a forecast for 20, a sales order for 40, and a manual entry for 50. Since the forecast and the manual entry are not considered committed demand, but the sales order is, the total committed demand is 40. Therefore, the available to promise is 150 minus 40, or 110 for item B in period 1.
Depending on the ATP rule specified in Oracle Inventory, the ATP formula for a member item is:
ATP (member item) = MPS (member item) - SO (member item) + WIP jobs (member item) + PO (member item) + On-hand (member item)
The ATP formula for a product family item is:
ATP (member item) = MPS (product family) - SO (all members) + all demand entries specified in the ATP rule for all members
Notice that the ATP calculation for a product family item does not consider supply for member items.
For example, consider a product family item, PF, consisting of member items I1 and I2. The planning percentages are:
Now assume the following forecast and sales order:
Consider the following simple example:
Beginning Inventory | Period 1 | Period 2 | Period 3 | Period 4 | |
---|---|---|---|---|---|
Sales Orders | 100 | 300 | |||
Scheduled Receipts | 300 | 200 | |||
ATP (before adjustment) | 200 | -100 | |||
ATP | 100 | 0 | |||
Table 1 - 52. Available to Promise (Page 1 of 1) |
The available to promise for period 1 is calculated by subtracting the sales order demand (100) from scheduled receipts (300) giving ATP (200). In period 2, however, when subtracting sales orders (300) from scheduled receipts (200), the initial result is negative ATP (-100). Oracle Master Scheduling/MRP borrows available ATP from the previous period to compensate for the negative quantity.
Suggestion: You should re-plan the master schedule or material requirements to get the latest ATP information.
Choose whether to display ATP information for an item in the Horizontal Plan window and on the Planning Detail report with the ATP calculation option. Set this option when you define an item.
Phases of the Planning Process
Locking Tables within the Snapshot
Locking Tables within the Snapshot Example
Previous | Next | Contents | Index | Navigation | Glossary | Library |