Limit by Week/Consume Earliest Forecast
The Default Consume Forecast by Period Method is Limit by Ship-By Date Week, and the Consume Earliest Forecast Demand option is selected.
You enter a sales order for 700 units to ship by 7/30/08. The production week for that ship-by date is 7/27/2008 (Sunday) to 8/02/2008 (Saturday).
The forecast that is earliest within the same production week (the 7/29 forecast) is consumed first and moved to the sales order demand quantity.
The 7/29 open forecast quantity of 200 is insufficient to meet the sales order demand of 700; 500 units remain. The next 200 units are consumed from the next earliest date within the same production week (7/30), followed by 7/31 and 8/1. Because only part of the open forecast quantity is consumed for 8/1, the 8/1 forecast is left with an open sales forecast quantity of 100.
| Date | Open sales forecast | SO line demand |
|---|---|---|
| 6/01/08
(out of limit) |
200 | 0 |
| 6/10/08
(out of limit) |
200 | 0 |
| 7/29/08 | 0 | 0 |
| 7/30/08 | 0 | 0 |
| 7/31/08 | 0 | 0 |
| 8/01/08 | 100 | 700 |
| 8/02/08 | 200 | 0 |
| 8/06/08
(out of limit) |
200 | 0 |