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