Prorate the Forecast

If a demand time fence is being used, prorate the forecast as:

• Forecast days = total number of days in the forecast period from start date to end date inclusive.
• Days left = total number of days from the day after the demand time fence to the forecast period end date inclusive.
• Prorated forecast = forecast period total quantity divided by forecast days multiplied by days left.

The result is always rounded up to accommodate small quantity items.

Example

Demand generation option = Sales orders consume forecast

Demand time fence = 05/01/18

Forecast period = 01/01/18 to 31/01/18

Forecast days = 31

Days left = 26

Forecast total quantity = 500

Prorated forecast = 420 ((500 ÷ 31) x 26) (zero decimals places in this example)

Sales orders after the demand time fence to the end of the forecast period = 200

Gross requirement ex forecast = 220 (420 - 200) and is required by 06/01/18, the day after the demand time fence.