Rolling planning is a planning method that allows you to substitute overlapping plans within one period. With rolling planning, you can edit values of previous plans and keep plans up-to-date during certain periods. The previous plans become irrelevant.
Rolling planning is available within a plan profile with the selected Substitute check box. Within one planning scenario, you can use any number of substitute plan profiles.
Substitute plans displace/replace values of previous plans of the relevant period. When using rolling planning, it is recommended that you set period-end closing for previous plans (of previous periods) (the Period-end closing dates setting).
With rolling planning, data is substituted for all plan lines. That is why you need to specify all products of the previous plan in the relevant plan, and not just corrective products. Such planning does not lead to loss of the previous plan data.
To edit quantity of the relevant plan, click Change quantity — Change by percentage above the tabular section of the plan. This allows you to change the quantity by a certain percent for one or several plan periods.
The diagram shows an example of rolling planning.
Plan 1 document for July and August is used as an example. The planned data is filled in with some values for Product 1 and Product 2. Update data of Product 1 for July and August, and plan a new period — September. The planned quantity of Product 2 for July and August remains unchanged. Generate a new Plan 2 document for July, August, and September where:
- Fill in previously planned data for Product 1 and Product 2 for July and August (data by Plan 1). As data is replaced with a new plan for all lines of the previous plan, specify all previously planned goods in the plan.
- Edit a quantity value of Product 1 for July and August by changing the quantity by a fixed percent (click Change quantity — Change by percentage in the plan tabular section). Values of the previous Plan 1 become irrelevant for all lines of the product items of Product 1 and Product 2.
- Fill in new planned period September for Product 1 and Product 2 with a value of previous period August. Fill it in using the formula set for September (click Change quantity — Specify arbitrary formula). Use the following formula: ColumnValue(CurrentColumnNumber() - 1). September period will be filled in with a value of the previous column of August period using the set formula.
Rolling planning allows you to accurately substitute plans of the relevant periods and then save information on substituted and substitute plans.
Algorithm of substituting plans of the relevant periods:
- Plans are substituted taking into account statuses and dates of plans.
- A plan with a higher status and/or a greater date substitutes for previous plans of the relevant periods with a lower status and/or an earlier date.
- Substitution is carried out by matching plan detail attributes (plan header attributes).
In the diagram, you can see an example of plan substitution in case of rolling planning.
According to the diagram, plans with a higher status and/or a later date substitute for plans with a lower status and/or an earlier date:
- Plan 2 with a greater date and a higher status substitutes for Plan 1 with an earlier date and a lower status.
- Plan 3 with a greater date and a higher status substitutes for Plan 1 and Plan 2 with earlier dates and lower statuses.
- Plan 4 with a greater date substitutes for Plan 1 with an earlier date and a lower status, and Plan 2 with an earlier date and the same status as in Plan 4.
- Plan 3 is up-to-date.
When writing and posting a new plan, the following is carried out automatically:
- Search for previously generated plans of the relevant periods that are substituted with a new relevant plan (substituted plans).
- Search for previously generated plans that substitute for the current plan of the relevant planning period (substitute plans).
Information on available substituted and substitute plans is displayed in the plan header as links Substituted "Plan quantity" and Substitute "Plan quantity" based on document writing and posting results. Whenever you click the respective link, the Plan substitution form appears. Here you can find information on plan substitution:
- The Substitute plans tab contains a list of plans that will substitute for previous plans of the relevant planning period.
- The Substituted plans tab contains a list of plans that will be substituted with a new plan of the relevant planning period.
Each planning period of a product item is marked as (replaced) in the tabular section of substituted plans. The substituted quantity of product items is highlighted with a transparent color and is irrelevant.
Depending on the set period display option (click More actions — Periods), the (replaced) substitution mark can be shown in the plan tabular section as follows:
- Periods in columns — each planning period is marked as (replaced).
- Periods in lines — a substituted period can be selected (in the Shipment date field). As a result, in the Substituted column, there is showing that the product item quantity has been substituted with a new plan of the relevant period.
When planning sales and purchases, data on planned payment schedule steps is substituted. When goods are substituted in the plan, payment steps are also substituted (on the Payment tab). The correlation between goods data and payment schedule data is ensured by the Shipment date field (on the Goods and Payment tabs).
You can also substitute production plans. When substituting manufactured products, semi-finished products that were planned together with the manufactured products are also substituted. Production plans are substituted by planning periods of manufactured products. A planning period of semi-finished products is not recorded as semi-finished products do not substitute for manufactured products in other plans. For correct substitution of semi-finished products planned manually, recount them.
When editing plan accounting dimensions, a planning period, or a document status, substituted plans are recounted and updated automatically.
If there are no substituted or substitute plans for the document, Without substitution appears in the header of this document.
There are times when sales (purchases or production) are already planned for a certain period, and you need to forecast new sales (purchases or production) for subsequent periods while also considering values of previous plans. To access this feature, select the Cumulative check box in the plan profile. This ensures cumulative planning whereby all values of previous plans over this period are summed up.
The diagram shows an example of cumulative planning.
A cumulative plan is generated as an example in the following way. For example, the following documents are generated: Sales plan 1 (January — 100 units, February — 200 units, March — 300 units) and Sales plan 2 for February, March and April (200 units for each month). Generate Sales plan 3 for the next three months (March, April, and May) and fill it in based on the previous sales plans: Sales plan 1 and Sales plan 2. 500 product units will be planned in a new Sales plan 3 document for March. A total quantity of products for March in Sales plan 1 and Sales plan 2 is 300 units and 200 units respectively.
Cumulative values of documents Sales plan 1, Sales plan 2, and Sales plan 3 are shown in reports of plan fulfillment control (in this example, in the Sales plan fulfillment by departments report): February (400 units), March (1,000 units), April (400 units).