- Contents
- Index
- Search
Display results with all search words
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
|
21/12/17 |
31/12/17 |
01/01/18 |
05/01/18 |
Time Fence |
06/01/18 |
|
20/01/18 |
21/01/18 |
|
|---|---|---|---|---|---|---|---|---|---|
|
Forecast |
|
|
<--------------------------------- 500 ---------------------------------> |
||||||
|
|
|
||||||||
|
Sales Orders |
15 |
75 |
40 |
350 |
|
|
|
200 |
|
|
|
|
||||||||
|
Gross Req. ex Sales Orders |
15 |
75 |
40 |
350 |
|
|
200 |
|
|
|
|
|
||||||||
|
Gross Req. ex Forecast |
|
|
|
|
220 |
|
|
|
|
|
|
|
||||||||
|
Total Gross Requirements |
15 |
75 |
40 |
350 |
|
220 |
|
200 |
|
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.