Examples of Forecast Period Parameters
You create forecasts by setting and submitting period parameters and forecast criteria. These examples show how the period parameter settings affect the forecasting dates.
Quarterly Forecast
Your company holds monthly board meetings on the 11th of every month to review sales forecasts for the next quarter. To prepare, you generate monthly forecasts for the next quarter.
On January 1, you configure a recurring monthly forecast with a due date of the 10th of every month by setting the due date to 80 days (21 days of January +28 Days of February +31 days of March) before the first forecast period start date, which is April 1. The end date of the forecast period will be June 30.
-
Forecast Period: Quarter
-
Frequency: Three
-
Adjustment Period: The Fiscal Period as set in the calendar. In this example it's monthly.
-
Due Date: 80 days before the first forecast period start date
-
Territory Freeze Date: 5 days before the forecast due date
-
Number of Concurrent Forecasts: Not set
Edit the individual due date and freeze date for the one quarter when the calculated date doesn't fall on the correct date.
The forecast period parameters produce these dates:
|
Parameter |
Q2 January 10 |
Q2 February 10 |
Q2 March 10 |
Q3 April 10 |
|---|---|---|---|---|
|
Due Date |
January 10 |
February 10 |
March 10 |
April 10 |
|
Territory Freeze Date |
January 5 |
February 5 |
March 5 |
April 5 |
|
Start Date - End Date |
4/1 to 6/30 |
4/1 to 6/30 |
4/1 to 6/30 |
7/1 to 9/30 |
One Concurrent Forecast
You want one active forecast period at a time, with no overlapping dates or gaps.
-
Forecast Period: Quarter
-
Frequency: Three
-
Adjustment Period: The Fiscal Period as set in the calendar. In this example it's monthly.
-
Due Date: 31 days after the first forecast period start date
-
Territory Freeze Date: 31 days before the forecast due date
-
Number of Concurrent Forecasts: One
The forecast period parameters produce these dates:
|
Forecast Name |
Start Date |
End Date |
Territory Freeze Date |
Due Date |
|---|---|---|---|---|
|
Q3-2018-2018/08/01 |
7/1/2018 |
9/30/2018 |
7/1/2018 |
7/31/2018 |
|
Q3-2018-2018/08/31 |
7/1/2018 |
9/30/2018 |
8/1/2018 |
8/31/2018 |
|
Q3-2018-2018/08/31 |
7/1/2018 |
9/30/2018 |
9/1/2018 |
9/31/2018 |
|
Q4-2018-2018/11/01 |
10/1/2018 |
12/31/2018 |
10/1/2018 |
10/31/2018 |
|
Q4-2018-2018/12/01 |
11/1/2018 |
12/31/2018 |
11/1/2018 |
11/31/2018 |
|
Q4-2018-2018/12/31 |
12/1/2018 |
12/31/2018 |
12/1/2018 |
12/31/2018 |
Two Concurrent Forecasts
You want two active forecast periods at a time, with no overlapping dates or gaps.
-
Forecast Period: Quarter
-
Frequency: Three
-
Adjustment Period: The Fiscal Period as set in the calendar. In this example it's monthly.
-
Due Date: 60 days before the first forecast period start date
-
Territory Freeze Date: 31 days before the forecast due date
-
Number of Concurrent Forecasts: Two
The forecast period parameters produce these dates:
|
Forecast Name |
Start Date |
End Date |
Territory Freeze Date |
Due Date |
|---|---|---|---|---|
|
Q3-2018-2018/08/01 |
7/1/2018 |
9/30/2018 |
7/1/2018 |
7/31/2018 |
|
Q4-2018-2018/08/01 |
10/1/2018 |
12/31/2018 |
7/1/2018 |
7/31/2018 |
|
Q3-2018-2018/08/31 |
7/1/2018 |
9/30/2018 |
8/1/2018 |
8/31/2018 |
|
Q4-2018-2018/08/01 |
10/1/2018 |
12/31/2018 |
8/1/2018 |
8/31/2018 |
|
Q3-2018-2018/08/31 |
7/1/2018 |
9/30/2018 |
9/1/2018 |
9/31/2018 |
|
Q4-2018-2018/08/01 |
10/1/2018 |
12/31/2018 |
9/1/2018 |
9/31/2018 |
|
Q4-2018-2018/11/01 |
10/1/2018 |
12/31/2018 |
10/1/2018 |
10/31/2018 |
|
Q1-2019-2018/11/01 |
1/1/2019 |
3/31/2019 |
10/1/2018 |
10/31/2018 |
|
Q4-2018-2018/12/01 |
11/1/2018 |
12/31/2018 |
11/1/2018 |
11/31/2018 |
|
Q1-2019-2018/11/01 |
1/1/2019 |
3/31/2019 |
11/1/2018 |
11/31/2018 |
|
Q4-2018-2018/12/31 |
12/1/2018 |
12/31/2018 |
12/1/2018 |
12/31/2018 |
|
Q1-2019-2018/11/01 |
1/1/2019 |
3/31/2019 |
12/1/2018 |
12/31/2018 |