Planning Master Data

Overview

Each demand plan have its own scenario and plan profile. Within each scenario, you can create your own plan structure, establish specific assumptions, and define sequential steps in the planning process.
Sales forecasting scenarios usually use product categories as groups of products that you can easily manage and forecast.

Setting up Planning

To enable planning in the system:
  1. Go to Master data and settings > Planning.
  2. Select the checkboxes of the plans you are going to use:
  • Sales forecasts
  • Sales forecasts by categories
  • Kitting schedules
  • Purchase plans
  • Goods stock plans
  • Inventory consumption plans
The enabled plans will be allowed for creation in the Planning subsystem.

Creating Planning Scenarios

Before you create a particular plan, register a scenario and plan profile for it. They store the main planning parameters, such as the planning frequency, planning horizon, and rules for filling plans. After the settings are done, you can proceed to creating documents.
Scenarios link different plans: sales forecasts, purchase plans, and other. When you create a plan profile, you choose the process you are going to plan with it: sales, purchases, balances, and other.
  1. Go to Planning > Settings and catalogs > Planning scenarios.
  2. Click Create.
  3. On the Main tab, specify the Description.
  4. Select the Time fence: Day, Week, Ten-day period, Month, Quarter, Half-year, or Year.
  5. Select the period display option: Range of dates (for example, 07/08-07/14) or Period number (within a year) (28th week).
  6. Select whether you want to plan Purchase planning and Sales forecasting: Only by quantity or By quantity and amount.
  7. If applicable, specify the planning Currency.
  8. On the Details tab, specify key assumptions for planning at the scenario level.
  9. Click Save.

Creating Plan Profiles

  1. Go to Planning > Settings and catalogs > Planning scenarios.
  2. Open the relevant scenario.
  3. On the Plan structure tab, click Create step, specify its short Description, and select the Demand planning, Supply planning, or Goods stock plan option.
4. Select the Step and click Create to create a new plan profile within the step.
5. On the Main tab, in the Use for field, select the type of plan you want to use this profile for: Purchase plan, Sales forecast by categories, and other.
6. Specify the Description.
7. Assign the User in charge.
8. Select the Cumulative or Substitute option.

Note: Substitute plan replaces the previous plan. For example, if you have one plan according to which you need to buy 100 bottles of water in January and February and another plan for the same quantity of bottles in February and March, you will purchase 100 bottles each of these months. If Cumulative planning is used, you will purchase 100 bottles in January and March and 200 bottles in February because the plans will be summed up.
9. For Purchase plan and Sales forecast, you can select the Apply sales prices checkbox. It allows you to specify payment plans according to the schedule if planning By quantity and amount is selected in the scenario.
10. On the Plan dimensions tab, select the checkboxes of dimensions you want to detail the plan by (for example, select the Warehouse checkbox to specify warehouses in planning documents). For planning documents, you can detail plans by the following parameters:
  • For purchase plans: by business unit, vendor, terms of purchase, and warehouse.
  • For sales forecasts: by business unit, customer, terms of sales, manager, warehouse, and store format.
  • For goods stock plans: by warehouse.
  • For kitting schedules: by warehouse.
  • For inventory consumption plans: by warehouse.
  • For sales forecasts by categories: by business unit, store format, and warehouse.
11. On the Population settings tab, select how you want to fill this tab:
  • Fill in by sources option enables tools to populate plans from any pre-configured infobase data source or your custom data source. Click Default filling rules to set up a single rule for all documents created based on this plan profile or fill it empty to specify rules later in documents.
  • Fill in using formula option allows you to create formulas using built-in operands, operators, and functions. Click Filling settings by default formula to set up a single formula for all documents created based on this plan profile or fill it empty to specify formulas later in documents.
12. To disable rule editing, select the Disable editing the rule checkbox. In this case, the user cannot customize the filling rules.
13. Specify the Number of default periods to define the default periods shown in the entry form. For example, if the Time fence of the scenario is month, and the Number of default periods is 3, the system will automatically set the 3-month planning period in the plan document.
14. On the Details tab, specify key assumptions for planning at the plan profile level.
15. Click Save.

Plan Population Settings

You can automatically fill created plan. There are two options: Fill in by sources and Fill in using formula.
With the Fill in by sources option, you can:
  • Use a wide range of standard plan filling templates (data composition schemas).
  • Import a data composition schema from an external file.
  • Use any infobase data to fill plans (Sales, Available stock, Purchase orders, Customer orders, and other).
  • Use data from previous plans.
  • Use information about minimum and maximum balances.
  • Use data on sales prices and vendor prices to fill plan totals.
  • Create any custom query in the infobase.
  • Use several data sources at the same time and combine them.
  • Customize filters and get data with a different data structure.
  • Use accumulated data for the period; to date; period moved for...
With the Fill in using formula option, you can:
  • Draw up arbitrary formulas using various built-in operands (Available stock, Sales forecast, and other), operators, and functions.
  • Customize operands (the calculation formulas support 1C:Enterprise language).
  • Use a specific formula for each plan item.
  • Use arbitrary data selections.
  • Use accumulated data for the period; to date; period shifted by...
You can configure filling rules for a specific plan profile. The Default filling rules (for Fill in by sources option) or Filling settings by default formula (for Fill in using formula option) hyperlink opens the Fill in plan form. Here you can set up filling rules: select formulas / sources to fill documents and configure filters. The filling rule will be used by default in all plan documents of this plan profile.

Creating Planning Data Sources

Overview

You can use planning data sources to fill plans. You can fill a plan by source only if the filling option in its plan profile is set form to Fill in by sources (and not Fill in using formula).
You can create planning data sourced directly from the plan document or go to Planning > Settings and catalogs > Planning data sources.
As sources, you can use any data stored in the infobase (sales and purchases for previous periods, data on current customer orders, expected goods deliveries, available stock, and other). You can use data from previous plans, information about minimum and maximum balances, sales and supplier prices.
Planning data sources are generated based on the Data Composition Schema (DCS). The DCS is a request to an infobase.
You can:
  • Import DCS from an external file.
  • Select one of the predefined DSCs in the system.
  • Create a new template based on a ready-made system template.
  • Create a new template from scratch by writing the query text (arbitrary data composition schema).

Creating Sources from Template

The following predefined DCS templates are available in the system:
  • Sales. Selects sales document turnovers according to the Revenue and COGS accumulation register for goods that are sold from the warehouse.
  • Purchases. Selects purchase document turnovers according to the Purchases accumulation register.
  • Kitting. Selects turnovers of kitting (reverse kitting) turnovers according to the Inventory cost and Company goods lots accumulation registers for goods received to the warehouse.
  • Available inventory. Selects available stock balances, including reserved items.
  • Sales orders. Selects goods that are ready for shipment from the warehouse from sales orders. For example, you can take into account all planned shipments to customers next month.
  • Purchase orders. Selects goods that are ready for receipt to the warehouse from purchase orders.
  • Inventory consumption orders. Selects goods that are ready for shipment from the warehouse from inventory consumption orders.
  • Transfer orders (shipment). Selects goods that are ready for shipment from the warehouse from transfer orders.
  • Transfer orders (receipt). Selects goods that are ready for receipt to the warehouse from transfer orders.
  • Assembly orders (shipment). Selects goods that are ready for shipment from the warehouse from assembly orders.
  • Assembly orders (receipt). Selects goods that are ready for receipt to the warehouse from assembly orders.
  • Sales forecasts. Selects sales forecast turnover according to the Sales forecasts accumulation register.
  • Sales forecasts by categories. Selects turnovers of sales forecasts by categories according to the Sales forecasts by categories accumulation register.
  • Sales targets (components). Selects sales forecast turnover according to the Sales forecasts accumulation register and details them up to components.
  • Assembly schedules (components). Selects the kitting schedule turnovers according to the Components consumption plans accumulation register.
  • Assembly and disassembly schedules (kits). Selects the kitting schedule turnovers according to the Kitting schedule accumulation register.
  • Purchase plans. Selects purchase plan turnovers according to the Purchase plans accumulation register.
  • Goods stock plans. Selects turnovers of goods stock plans according to the Goods stock plans accumulation register.
  • Actual balance. Selects the actual balances according to the Goods in warehouses accumulation register.
  • Goods limitations. Selects the specified values of goods limitations according to the Goods limitations information register. On the Parameters tab, specify the Inventory type: Safety stock, Minimum inventory, Maximum inventory, Consumption rate.
To fill prices in the sales and purchase planning documents, use the following templates:
  • Min vendor price. Selects the minimum price for the item as of the date from the Prices of vendor part numbers information register.
  • Prices of vendor part numbers. Selects prices as of the date from the Prices of vendor part numbers information register.
  • Item prices. Selects prices as of the date from the Item prices information register.

Creating Sources Manually

There are two ways to create a data composition schema: write a query to the database from scratch or editing a predefined template. You can only use them in thick client mode.
To write a query from scratch, select Arbitrary in the Data Composition Schema field and create a new query text by clicking Edit > Edit composition schema. This allows you to get any data from the infobase.
To edit a predefined template, select any template in the Data Composition Schema field and set the rules for generating source data by clicking Edit > Edit composition schema and make all the necessary changes to the query text or other settings.

Configuring Planning Data Sources

To configure the predefined planning data source:
  1. Go to Planning > Settings and catalogs > Planning data sources.
  2. Click Create.
  3. Select any value in the Data Composition Schema field and click Edit.
  4. On the Parameters tab, specify the following parameters:
  • Apply seasonal index. Allows you to adjust the selected data by a seasonal index. The index is calculated as the ratio of the seasonal index for the planning period (the period of the plan document) to the seasonal index for the period of the selected source data. Later this seasonal index is multiplied by the source result.
  • Product range as of date. Allows you to filter the selected source data by product range settings: the goods allowed for purchase or sale, the retail format, and so on. It is necessary to specify the date on which the product range settings and retail format settings are determined.
  • Period offset. Allows you to specify the number of offset periods relative to the planning period in the document.
  • ABCXYZ classification selection. Allows you to select goods according to the ABC and XYZ classification.
According to the source type, specify how data will be selected for this source. Next to Data is selected in the Planning data source form, select one of the following:
  • Over period. Indicates the period for which the source data will be selected when you fill the plan by source. For example, the volume of good sold for the last month or the number of goods planned to be received during the next month.
  • As of. Indicates the date on which the source data is generated when you fill the plan by source. For example, stock balances at the beginning of the planning month.
  • Without restrictions. Indicates that there are no restrictions on dates for the source, all data stored in the infobase will be filled when you fill the plan by source. Use this feature for those data sources that do not have a periodicity. For example, information about the minimum stock balance.
  • With period offset. Indicates that the data will be specified in accordance with the selected period offset value in relation to the current period specified in the plan documents. For example, the sales forecast for the next (relative to the current) month is based on the maximum sales volume for the previous three months. In this case, the period offset is selected, and the offset value is specified for each source: "-1", "-2" and "-3". The data of the current month, last month and the month before the last month will be selected.
After the main sources of planning data are entered, register the rules for filling plans based on the sources. You can specify these rules directly in the plan or in the plan profile as a default filling rule.