ATP with Forward Consumption (Oracle Inventory Help)


	Previous	Next		Contents	Index	Glossary	Library

ATP with Forward Consumption

Periods	1	2	3	4	5	6	7	8
Total Supply	6	4	2	4	8	4	4	4
Total Demand	6	2	3	6	6	1	2	2
Projected QOH	0	2	1	(-1)	1	4	6	8
Period ATP	6-6	4-2=2	2-3= -1	4-6= -2	8-6=2	4-1=3	4-2=2	4-2=2
Forward Consumption			-1->	(-1)+ (-2)= (-3)->	2-(3)=-1 ->	3-1=4
ATP	0	2	0	0	0	2	2	2
New Demand		2
New ATP	0	0	0	0	0	2	2	2

As always, period demand is subtracted from period supply as long as sufficient supply is available. If supply is insufficient to meet demand in a given period, ATP nets the excess demand from a future period's excess supply. Forward consumption begins in period 3, where demand exceeds supply by 1. ATP moves forward to period 4, where demand exceeds supply by 2. Moving into period 5, excess demand totalling 3 is carried from prior periods. This 3 consumes the net supply quantity of 2 for period 5, leaving an ATP of zero in period 5.

Next, an excess demand of 1 is carried into period 6, reducing period 6 ATP quantity to 2. Note that with forward ATP, no negative ATP periods exist as long as excess supply exists anywhere in the ATP horizon. Forward ATP nets any excess demand in one period from the surplus supply in a future period, with no limit on the time or number of periods into the future. With this rule, backward consumption is off, and accumulate available is off, so the available quantity in period 2 is not used for demand falling into future periods.

ATP check for a new order: any check for a quantity greater than 2 for any period fails, as 2 is the most that can be promised in any one period. For an ATP check for a quantity of 2 in period 4, ATP returns an earliest ATP of 2 in period 2, but indicates that there is no available to promise on the date requested. We can change the order date to period 2, or choose a date out in the future that also has availability to promise.

ATP with Forward Consumption

See Also