Forecast Consumption Calculation
You define forecast consumption periods to represent a period in which selected forecasts are partially or fully consumed, or over-consumed by sales orders. This action enables you to include more than one time series bucket in the calculation of the forecast consumption. That is, you can designate a longer period of time (the forecast consumption period) for the system to compare the gross forecasts to the combined gross sales orders and shipments.
With forecast consumption processing, the system uses these quantity types:
Quantity Type |
Explanation |
|---|---|
-FSCU |
Unadjusted forecast quantity (gross) for a specific item from the detail forecast table. |
-SOU |
Actual sales orders from the sales order detail table. |
-SO |
Portion of total sales orders that consumes the forecast. -SO can exceed the forecast when sales orders are greater than forecast. |
-SHIP |
Shipments that occur within the forecast consumption period. |
-FCST |
Unconsumed forecast (net). |
+WO, +PLO |
Work orders and planned orders: replenishment orders that cover the net requirements. |
In the next example, work orders for 50 and 135 units are open. The forecast is spread through the forecast consumption period and is consumed on a first in first out basis.-SHIP + -SOU = Total Demand (10 + 40 + 175 = 225). Total Demand consumes FIFO; therefore, the beginning forecast is consumed and posted in the -SO line. The net balance of the forecast is posted in the -FCST line. Notice in the first three periods that the -FCST (net) has been reduced by a total of 225 pieces. The -SO indicates the amount that is consumed in each period and also totals 225 pieces. Work order messages suggest increasing +WOU from 50 to 85. Messages suggest expediting and decreasing +WOU in 6-30 from 135 to 100 in period June 17th. The forecast consumption period is monthly and indicated with the asterisk in the period. This feature is turned on when the processing options for the times series are set.
Qty Type |
Weeks |
Weeks |
Weeks |
Weeks |
Weeks |
|---|---|---|---|---|---|
1 |
2 |
3 |
4 |
5 |
|
6-03 |
6-10 |
6-17 |
6-24 |
* 6-30 |
|
+BAU |
75 |
15 |
-35 |
-135 |
-235 |
+BA |
75 |
15 |
|||
+WOU |
50 |
135 |
|||
+WO |
85 |
100 |
|||
-FSCU |
60 |
100 |
100 |
100 |
80 |
-FCST |
35 |
100 |
80 |
||
-SHIP |
10 |
||||
-SOU |
40 |
175 |
|||
-SO |
60 |
100 |
65 |
||
=EAU |
15 |
-35 |
-135 |
-235 |
-180 |
=EA |
15 |
You can set the number of past due time buckets to one or two. The first past due bucket (PD2) includes all activity that is scheduled to occur before the current generation date but within the current forecast consumption period. The second past due bucket (PD1) includes all activity that is scheduled to occur before the beginning of the current forecast consumption period.
If you use at least one past due period, the system calculates unconsumed quantity for the first time bucket as follows:
Past due forecasts (-FCST prior to the generation date, but after the forecast consumption beginning date) are consumed by:
Past due sales orders (that have not shipped) that are within the forecast consumption period.
Sales orders that were shipped within the forecast consumption period, but prior to the generation date.
Any remaining -FCST is added to the -FCST in the first bucket that is not past due.