Net Requirements
Once the gross requirement is established, you can calculate the net requirement and planned orders. On-hand, minimum balances and scheduled receipts are considered when determining the planned order quantity.
Example
On-Hand Balance |
25 |
||||||||
---|---|---|---|---|---|---|---|---|---|
Minimum Balance |
20 |
||||||||
|
|
|
Today |
|
|
|
|
|
|
|
19/12/17 |
21/12/17 |
31/12/17 |
01/01/18 |
05/01/18 |
10/01/18 |
|
20/01/18 |
3101/18 |
Gross Requirements |
|
15 |
75 |
40 |
350 |
100 |
|
200 |
|
|
|||||||||
Scheduled Receipts |
5 |
5 |
|
|
|
|
|
|
|
|
|||||||||
Calculated On-Hand |
|
|
-55 |
|
|
|
|
|
|
|
|||||||||
Net Requirement |
|
|
75 |
|
|
|
|
|
|
|
|||||||||
Planned Order |
|
|
75 |
|
|
|
|
|
|
|
|||||||||
Projected On-Hand |
|
|
20 |
|
|
|
|
|
|
On-hand = 25
Gross requirements up to and including today = 90 (15 + 75)
Scheduled Receipts up to and including today = 10 (5 + 5)
Calculated on hand for today = -55 (25 - 90 + 10)
Minimum balance = 20
Calculated planned order = 75 (55 + 20)