As you edit values in IFP forecast editors, no data is saved in the selected target files until you use the Save button on the toolbar.
The saving process varies according to the following option selections:
- Data to Amend
- Data to Enter
- Report Definition
- Level of Detail
- Units option
Processing of Data Types
The calculation logic used in sales databases when saving amended values in target files depends on the options selected for Data to Amend and Data to Enter.
See Forecast Editor Calculation Logic for Sales Databases for details.
Pro Rata Calculations for Grids using Group Level Data
When you work at any level of detail other than full item code, the grid will show totals for the selected (group) level only.
When saving amended group level data IFP automatically divides the total values across all item codes belonging to the group concerned on a pro rata basis, using existing file data for each month. An example is shown below:
Level of detail = Brand
Members of brand = item codes A and B
Current file values = 100 for A and 200 for B
Current total file value for brand = 300
Amended total value in editing grid = 600
Calculated amended file values = 200 for A and 400 for B
If the existing values for all item codes belonging to a group are all zero for a given month, then the amended total for the group will be divided equally across all item codes belonging to that group. Hence, you should always ensure that suitable data exists at item code level first before amending group level data.
Pro Rata Calculations for Grids using Report Definitions
When you work with report definitions, the grid will show totals for each report definition line only. When saving amended group level data IFP automatically divides the total values across all item codes belonging to each line in the report definition on a pro rata basis, using existing file data for each month. Calculation logic used here is identical to that used for group level data above.
Conversion of Currencies
All values are converted from the selected editing currency into the planning currency for each item code when saving amended values in the target file(s). This includes the effect of any selected currency scaling option for the editor.
Conversion into planning currencies uses the selected exchange rate table for each file. An example is shown below:
Editing currency = USD
Planning currency = Euro
Selected exchange rate table for file = Plan Rates
January Plan rate = 1.2
Amended US$ amount = 1,200 USD
Value saved in target file = 1,200/1.2 = 1,000 Euros
Conversion of Units
If you have selected converted units on the Units Tab under Reporting Options then units shown in the editing grid will be standard units multiplied by the Unit Conversion Factor by each item code.
When saving amended data these converted units are automatically converted back into standard units by dividing by this Unit Conversion Factor. An example is shown below:
Standard unit = Packs
Converted units = Tablets (10 tablets per pack)
Conversion Factor = 10
Amended converted units = 1000
Calculated standard units = 1000 / 10 = 100
Rounding of Units
In sales databases units are stored as whole numbers. Hence, any calculated units from the above unit conversion and pro rata calculations are rounded to whole numbers for each item code before being save in the target file(s). This means that the final units and corresponding values may differ slightly from those shown in the editing grid at the time of saving. An example is shown below:
Calculated units = 12.2
ASP per unit = 10.0
Sales value in grid = 122
Rounded units saved in target file = 12
Resulting sales value in target file = 12 x 10.0 = 120
Rounding Logic when Using Converted Units
It is important to understand the rounding logic used by IFP when you edit values using a grid containing converted units. A simple example is as follows:
Current selling units = 40
ASP per selling unit = 200
Current value = 40 x 200 = 8000
UOM Factor = 100
Current converted units = 40 x 100 = 4000
ASP per converted unit = 200 / 100 = 2
Suppose you enter an amended value of 7560
Amended converted units = 7560 / 2 = 3780
Amended selling units = 3780 / 100 = 37.8, which rounds to 38 units
Final amended value after rounding = 38 * 200 = 7600