Saving Amended Values in Forecast Editors

Overview

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
• Currency
• 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

Note
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