Ending Available Calculation
Ending Available (EA) is the amount of product that is available at the end of a time bucket after the system calculates the effect of all supplies and all demands for the time bucket. The system uses the planning time-fence rule and the calculation to calculate the ending available amount:
Add within the time bucket.
Calculate Beginning Available (+BA):
For the first time period, +BA = quantity on hand − safety stock.
For remaining time periods, +BA = ending available from the previous time period (=EA).
Subtract according to the planning time fence rule:
Forecast (-FCST).
Customer demand (sales orders and interplant demand).
Equals ending available (EA).
The following table displays how the system calculates the amount of product that is available at the end of a time period. Assume that the order policy code equals lot for lot, safety stock equals 20, time fence rule for planning equals C, and lead time equals 1. The planning fence is between periods 4 and 5.
For example:
On hand (80) − safety (20) = Period 1 + BA (60)
Period 1 + BA (60) − S0(20) = EA (40)
Product |
Period |
Period |
Period |
Period |
Period |
Period |
Period |
Period |
|---|---|---|---|---|---|---|---|---|
On Hand = 80 |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
+BA |
60 |
40 |
25 |
25 |
0 |
0 |
0 |
0 |
–FCST |
20 |
20 |
20 |
20 |
20 |
20 |
20 |
20 |
–SO |
20 |
15 |
40 |
45 |
||||
=EA |
40 |
25 |
25 |
0 |
0 |
0 |
0 |
0 |
+DRP |
15 |
20 |
20 |
45 |
20 |
|||
(order start) |
15 |
20 |
20 |
45 |
20 |