The key figures that are described below are calculated when executing the standard analyses and are therefore not saved in any information structure.

A margin is the percentage difference between the retail and cost prices, in relation to the sales value.

The margin is calculated as follows:

The following margins can be evaluated in the Retail Information System:

• Order margin

• On-order stock margin

• Goods receipt margin

• Sales margin

• Promotion sales margin

• Stock margin

• Sales order margin

• Third-party order margin

• Third-party sales margin

• Stock transfer margin

• Transport order margin

The margin always has two values:

• Margin with tax

• Margin without tax

The range of coverage shows the stock left at the end of the period selected compared to the average issues in that period. It is calculated as follows:

The average issues are calculated as follows:

The inventory turn is calculated from the quotient of the sum of the issues in the period selected and the average stock in the period selected.

The issues are calculated as follows:

The average stock is calculated as follows:

The annual inventory turn is calculated as follows:

If you choose a year as your selection period, then the inventory turn is identical to the annual inventory turn.

The GMROI key figure represents the relationship between the value-based annual inventory turn and the issue margin achieved:

The issues are calculated as follows:

This key figure aids the weighting of the inventory turn and margin of an article and helps you to ascertain that the article is not necessarily successful, despite the high margin achieved, if only a minimal annual inventory turn is reached.

The retail price with tax forms the basis for calculating the value-based annual inventory turn.

Key figure that shows how many days an article has already been in the valuated stock of a store.

The key figure is calculated as follows:

The receipt date is recorded when the article is first issued/received in the respective store and remains unchanged.

This key figure shows what sales/stocks would have been reached if the original retail price with tax had been adhered to.

This key figure is calculated by multiplying the sales quantity/valuated stock quantity by the original retail price.

The original retail price is the retail price of the first purchase order or change involving stocks in the store in question.

This key figure is calculated as follows:

The sales quota can be displayed in terms of quantity and value (retail price with tax).

The sales quota for seasonal articles is between 0% and 100%.

Key figure that shows what stock is available at the end of the season. The end of the season is determined by the end of the selection period at the start of the analysis.

Note that in analyses of the current season, the end date lies in the future.

This key figure is displayed in a variety of versions (volume, quantity, weight, cost, rtlT, rtl).

The end of season stock is calculated as follows:

The on-order stock is the sum of all open purchase orders involving external vendors.

The issues up to the end of the selection period are calculated as follows:

The issues (Sales, GI DC) from the start of the selection period up until the evaluation date are used in the calculation of the average issue.