Gross Margin Return On Investment
Technical name: 0RT_C01_Q0009
Use
This Query provides an overview of the Gross Margin Return on Investment key figure. This key figure represents weighting the inventory turn with the sales margin in the stores.
Rows
InfoObject |
Description of the InfoObject (also restrictions or calculation formulas) |
0MATERIAL__0MATL_GROUP |
Merchandise Category |
Columns
InfoObject |
Description of the InfoObject (also restrictions or calculation formulas) |
0CPBAINSABU |
Sales / BUn |
0RT_C01_CK0010 |
Average Daily Stock / BUn (see formulas) |
0RT_C01_CK006 |
Margin – Sales at Retail Value (see formulas) |
0RT_C01_CK007 |
Margin – Sales at Retail Value with Tax (see formulas) |
0RT_C01_CK0008 |
GMROI Rtl (see formulas) |
0RT_C01_CK0014 |
GMROI RtlT (see formulas) |
0RT_C01_CK0015 |
Store Inventory Turn (Sales Quantity) per Day (see formulas) |
Formulas:
Average Daily Stock in the Base Unit of Measure=
Last Total Stock Calculated in the Base Unit of Measure
The Margin key figure is calculated from the sales (or promotion sales), cost and retail value (with or without tax):
Margin with Tax =
100 ´ (Sales in Retail Value with Tax – Sales in Cost Value)
¸ Sales in Retail Value with Tax
Inventory Turn in Base Unit of Measure =
Total Issues from Valuated Stock in BUn ¸ Average Daily Stock in BUn
Store Inventory Turn in Base Unit of Measure =
Sales in BUn ¸ Average Daily Stock in BUn
The GMROI is calculated from the Inventory Turn in BUn per Day key figure and the Sales at Retail (with or without tax) margin, for example:
GMROI in Retail Value =
Inventory Turn in BUn per Day x Sales at Retail margin