In period 2, however, when subtracting sales orders (300) from scheduled receipts (200), the initial result is negative ATP (-100). The available to promise for period 1 is calculated by subtracting the sales order demand (100) from scheduled receipts (300) giving ATP (200). If ATP goes negative in a period, it rolls backwards to find ATP from a previous period to cover the demand. The ATP calculation based on this plan looks like this: Now assume the following forecast and sales order:Īfter explosion and consumption, the forecast looks like this:Īfter loading the forecast and sales order to an MDS, the schedule looks like this: The planning percentages are:Īlso assume that PF has Forecast Control set to Consume, and I1 and I2 both have Forecast Control set to Consume and derive. Notice that the ATP calculation for a product family item does not consider supply for member items.įor example, consider a product family item, PF, consisting of member items I1 and I2. The ATP formula for a product family item is:ĪTP (member item) = MPS (product family) - SO (all members) + all demand entries specified in the ATP rule for all members An ATP calculation for the product family item takes into account demand for member items.ĭepending on the ATP rule specified in Oracle Inventory, the ATP formula for a member item is:ĪTP (member item) = MPS (member item) - SO (member item) + WIP jobs (member item) + PO (member item) + On-hand (member item) Therefore, the available to promise is 150 minus 40, or 110 for item B in period 1.Īn ATP calculation can be performed at either the product family item level or the member item level. Since the forecast and the manual entry are not considered committed demand, but the sales order is, the total committed demand is 40. The committed demand comes from the following sources: a forecast for 20, a sales order for 40, and a manual entry for 50. To calculate the total available to promise for period 1, subtract all committed demand from the total supply. The scheduled receipts (110), planned orders (20), and nettable quantity on hand (20) equal 150 in total supply for period 1. After running a plan, you get the following information for item A:īeginning Inventory Period 1 Period 2 Period 3 Period 4 Suppose you want to see the available to promise information on item A for period 1. Supply = planned orders, scheduled receipts (purchase orders, purchase requisitions, and discrete jobs), suggested repetitive schedulesĭemand = sales orders, component demand (from planned orders, discrete jobs, and suggested repetitive schedules) excludes forecasted demand or manual entries Oracle Master Scheduling/MRP and Supply Chain Planning does not consider ATP quantities from prior periods as supply in future periods. Also, the amount available during each period is not cumulative. Note: Committed demand does not include forecasted demand or manually entered master demand schedule entries. Oracle Master Scheduling/MRP and Supply Chain Planning calculates the ATP quantity of an item for each day of planned production by adding planned production during the period (planned orders and scheduled receipts) to the quantity on hand, and then subtracting all committed demand for the period (sales orders, component demand from planned orders, discrete jobs, and repetitive schedules). For instructions on viewing or calculating ATP through Oracle Inventory, see: Viewing ATP Information. 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. 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. See: MPS/MRP Planning Attribute Group.ĪTP is based on a specific MPS, DRP or MRP plan and is non-cumulative. The planning process calculates ATP based on the Calculate ATP item attribute. You can monitor and coordinate customer delivery promises using the available to promise information in the Horizontal Plan window and Planning Detail report. Available to Promise (ATP) (MRP and Supply Chain Planning Help)
0 Comments
Leave a Reply. |