Gross Margin Return on Investment Report 
Query: 0FRE_MC04_Q0001 and 0FRE_MC24_Q0001
You can use this query to analyze the development of the average stock and weekly consumption for a product/location combination for a given period of time, as well as other important key performance indicators (KPIs) such as gross margin return on investment, inventory turns, and gross margin percentage. Variables are provided so you can enter a selection range of periods, products, and locations (calendar week is mandatory).
The query can be used as a basis for ABC classification of products. The key figures in this query are designed to be displayed at the most detailed level of: product, location, and calendar week.
This query is not designed to support the summarization of its key figure values at different levels. Key figure values at summarization levels could result in invalid calculations.
Note
Data for the F&R Weekly Figures InfoProvider (0FRE_C05) is collected on a weekly basis and contains the following time characteristics: 0CALWEEK, 0CALMONTH, 0CALYEAR, 0FISCPER, 0FISCVARNT and 0FISCYEAR. In this query, BI summarizes the key figure data from this InfoProvider, based on the first day of the calendar week.
For example, assume you have the following weekly records:
The total for June is 360. Consumption for calendar week 22, which includes five days in June, is not included in the June summary line. This is because only the first day of the week is used to determine the month to which the weekly information belongs.
This limitation applies to all reports based on the F&R Weekly Figures InfoProvider (0FRE_C05).
The following KPIs and key figures are calculated in this query:
Weekly average stock at POS cost
Weekly average stock at POS retail
Weekly consumption at POS cost
Weekly consumption at POS retail
Inventory turns
Gross margin percentage
Gross margin return on investment (GMROI)
The following KPIs and key figures are displayed in this query:
Weekly average stock (in BUoM)
Weekly consumption (in BUoM)
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| N/A |
- |
Object Type | Name | Technical Name |
|---|---|---|
| Description |
InfoObject |
| N/A | |
| Production Substitution Type |
0FRE_REPLTY |
Object Type | Name | Technical Name |
|---|---|---|
| Description |
Variable |
| Calendar year/week |
0I_CWEEK |
| Product |
0S_PROD |
| Location |
0S_LOC |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Calendar Year/Week |
0CALWEEK |
- |
| Product |
0MATERIAL |
- |
| Location |
0PLANT |
- |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Inventory Turns – (Calculated Key Figure) |
0FRE_MC04_CK009 |
= NDIV0 (‘Weekly Consumption at POS Retail’ / ‘Weekly Average Stock at POS Retail’) |
| Gross Margin Percentage – (Calculated Key Figure) |
0FRE_MC04_CK010 |
NODIM (NDIV0 ((‘Weekly Consumption at POS Retail’ – ‘Weekly Consumption at POS Cost’) / ‘Weekly Consumption at POS Retail’)) |
| Gross Margin Return on Investment – (Calculated Key Figure) |
0FRE_MC04_CK011 |
‘Gross Margin Percentage’ * ‘Inventory Turns’ |
| Weekly Average Stock (in BUoM) |
0FRE_WKAVST |
- |
| Weekly Average Stock Cost at POS Cost – (Calculated Key Figure) |
0FRE_MC04_CK005 |
NODIM (‘Weekly Average Stock’) * ‘POS Cost Currency Only’ |
| Weekly Average Stock Cost at POS Retail – (Calculated Key Figure) |
0FRE_MC04_CK006 |
NODIM (‘Weekly Average Stock’) * ‘POS Retail Price Currency Only’ |
| Weekly Consumption |
0FRE_CONSWK |
- |
| Weekly Consumption at POS Cost – (Calculated Key Figure) |
0FRE_MC04_CK007 |
NODIM (‘Weekly Consumption’) * ‘POS Cost Currency Only’ |
| Weekly Consumption at POS Retail – (Calculated Key Figure) |
0FRE_MC04_CK008 |
NODIM (‘Weekly Consumption’) * ‘POS Retail Price Currency Only’ |