Weekly Service Level Development
Technical Name: 0FRE_MC02_Q0001
Use
This query is used to analyze the development of the actual service level – for stores and DCs - for a product / location combination, over a certain period of time.
The actual service level for a store is the percentage of time a product is available at the store for the customer to purchase. For a distribution center (DC), this key performance indicator represents the percentage of time a product is available at the DC for delivery to the store.
You can use this query to compare the actual service level reached for a product/location against the target service level defined in the master data for the product/location.
Replenishment managers can use this query to monitor the actual service level, and to take corrective action to minimize the differences between that key performance indicator, and the target service level.
You can also use the query to monitor trends as they develop, with respect to the actual service levels.
Most of the following key figures are derived from the differences between the actual service level and the target service level:
- Actual Service Level
- Target Service Level
- Percentage Deviation
- Stock Cost
- Consumption Units
- Consumption Value
- Lost Consumption Units
- Lost Consumption Value
You can drill down to include additional information, as well as filter the information in the query by the following additional characteristics:
- Location Type
- Product Category
- Stock Planner
- ABC Indicator
- Selling Class
The following KPIs and key figures are calculated within this query:
Calculated Key Figures:
Actual Service Level
Service Level Deviation
Percentage Deviation
Query Formulas
Target Service Level
The following KPIs and key figures are displayed in this query:
Weekly Average Stock
Average Stock Cost
Weekly Consumption
Weekly Consumption Value
Lost Consumption
Lost Consumption Value
Filter
InfoObject |
Description of the InfoObject (or restriction or calculation formula) |
N/A |
|
Free Characteristics
InfoObject |
Name |
0PLANT_PLANTCAT |
Location Type |
0MATERIAL__0MATL_GROUP |
Merchandise Category |
0MATERIAL__ORPA_WGH1 |
Merchandise Category Level 1 |
0MATERIAL__ORPA_WGH2 |
Merchandise Category Level 2 |
0MATERIAL__ORPA_WGH3 |
Merchandise Category Level 3 |
0MATERIAL__ORPA_WGH4 |
Merchandise Category Level 4 |
0MAT_PLANT__0FRE_PLNPUR |
Replenishment Planner |
0MAT_PLANT_0ABCKEY |
ABC Indicator |
0MAT_PLANT_0FRE_SELCLS |
Selling Class |
Variables Used
Variable |
Name |
0I_CWEEK |
(required) Calendar week |
0S_PROD |
Product |
0S_LOC |
Location |
Rows
InfoObject |
Description of the InfoObject (or restriction or calculation formula) |
|
0CALWEEK |
Calendar week |
|
0MATERIAL |
Product |
|
0PLANT |
Location |
|
Columns
InfoObject |
Decription of the InfoObject (or restriction or calculation formula) |
0FRE_MC02_CK004 |
Target Service Level – (Calculated Key Figure) Target Service Level = ‘Target Service Level’ / ‘General Counter’ |
0FRE_MC02_CK001 |
Actual Service Level – (Calculated Key Figure) Actual Service Level = NDIV0 (‘Weekly Consumption’ / (Weekly Consumption’ + ‘Lost Consumption’)) * 100 |
0FRE_MC02_CK002 |
Service Level Absolute Deviation – (Calculated Key Figure) Service Level Absolute Deviation = ABS (‘Actual Service Level’ – ‘Target Service Level’) Note: Calculate Results as = Average of all values (mean absolute deviation) |
0FRE_MC02_CK003 |
Percentage Deviation – (Calculated Key Figure) Percentage Deviation = ‘Service Level Deviation’ %A ‘Target Service Level’ |
0FRE_WKAVST |
Weekly Average Stock |
0FRE_AVSTCS |
Average Stock Cost |
0FRE_CONSWK |
Weekly Consumption |
0FRE_CONVWK |
Weekly Consumption Value |
0FRE_LSTCSP |
Lost Consumption |
0FRE_LSCVAL |
Lost Consumption Value |
Report Report Interface
Query |
Name |
None |
/ |