Previous | Next | Contents | Index | Navigation | Glossary | Library |
Bucket | Forecast Date | Rate End Date | Forecast Quantity |
---|---|---|---|
Days | 04-JAN | 100 | |
Weeks | 17-JAN | 200 | |
Periods | 31-JAN | 400 | |
Table 1 - 22. Forecast for Repetitive Item |
Schedule Date | Rate End Date | Quantity | Daily Rate |
---|---|---|---|
04-JAN | 04-JAN | 100 | |
17-JAN | 21-JAN | 40 (assuming 5 workdays) | |
31-JAN | 26-FEB | 20 (assuming 20 workdays) | |
Table 1 - 23. Forecast Loaded into Master Schedule |
When you load a forecast entry with an end date into the master schedule for a repetitively planned item, the schedule entry consists of a schedule date, a rate end date, and a daily rate. If the forecast is in daily buckets, the schedule date is the same as the forecast date, and the rate end date is the same as the forecast end date. The forecasted quantity becomes the daily rate. If the forecast is in weekly or periodic buckets, the schedule date is the first day of the week or period, and the schedule end date is the end of that week or period. The daily rate is what was forecast for that week or period divided by the number of days in that time frame.
For example:
Bucket | Forecast Date | Rate End Date | Forecast Quantity |
---|---|---|---|
Days | 04-JAN | 06-JAN | 100 |
Weeks | 17-JAN | 24-JAN | 200 |
Periods | 31-JAN | 28-FEB | 400 |
Table 1 - 24. Forecast for Repetitive Item |
Schedule Date | Rate End Date | Quantity | Daily Rate |
---|---|---|---|
04-JAN | 06-JAN | 100 | |
17-JAN | 21-JAN | 40 (assuming 5 workdays) | |
24-JAN | 28-JAN | 40 | |
31-JAN | 26-FEB | 20 (assuming 20 workdays) | |
28-FEB | 26-MAR | 20 | |
Table 1 - 25. Forecast Loaded into Master Schedule |
If you specify rounding control for an item, the load process does round up any fractional quantities. The load process considers any additional quantity calculated due to rounding as excess when calculating future time buckets.
For example:
Bucket | Forecast Date | Rate End Date | Forecast Quantity |
---|---|---|---|
Days | 08-FEB | 11-FEB | 100 |
Weeks | 14-FEB | 11-MAR | 518 |
Table 1 - 26. Forecast for Repetitive Item with Rounding |
Schedule Date | Rate End Date | Quantity | Daily Rate |
---|---|---|---|
08-FEB | 11-FEB | 100 | |
14-FEB | 18-FEB | 104 | |
21-FEB | 25-FEB | 104 | |
28-FEB | 04-MAR | 103 | |
07-MAR | 11-MAR | 104 | |
Table 1 - 27. Forecast Loaded into Master Schedule with Rounding |
Note the period from 28-FEB through 04-MAR only requires 103 a day since the previous periods spanning 14-FEB through 25-FEB are overestimates due to rounding.
Previous | Next | Contents | Index | Navigation | Glossary | Library |