Basic Information
| BW Server | WBP |
|---|---|
| Application | IM Stocks |
| Query Name | BW - Turn Evolution - 3 month (Core Query) |
| Query Technical Name | BW_QRY_MPR_IC001_0028 |
| Core/Specific Scope | Core - Can be used by everyone. |
| Provider Name | Material Stock MPR_IC001 |
| Usage type | Direct execution via Analysis |
| Expected users | Supply chain |
Purpose of this query
The objectif of this query is to display the inventory turnover (Turn) and days of supply (DOS) to identify materials in inventory that have a slow turnover and then take action.
In this query, the turnover is calculated based on 3 month period of stock issues.
Important information
- This query calculates the Turnover at PLANT level and for each material.
This query cannot be used to calculate a turnover at GBU or company level since transfers from one plant to another are considered as stock issues.
- As the objective of the report is to identify slow moving stocks, movements related to scrapping are excluded (otherwise scrapped materials will show with a good turnover).
Variables screen
| Variable Name | Authorization Object | Description |
|---|---|---|
| Company Code | Yes | The company code owning the stock |
| Calendar Year/Month | No | Only 1 month can be selected by the key figures will be shown for Month to Month-3 |
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| Infoprovider | <> CUB_COPC1 Material Prices | This so that the data from the material prices cube are not included in this query (not needed) |
Characteristics
| Characteristic Name | Characteristic code | Explanation |
|---|---|---|
| Country | 0COUNTRY | Country of the customer |
Key Figures
M DOS
Description
Days of supplies calculated for month M. It's the number of days of supplies left considering the end of month M inventory and the average stock issues in the past 3 months.
Calculation rule detail
It's the number of days in the year divided by the turnover.
M DOS = 365 / M TURN
Exemple
If you have turnover is 365 , then DOS will be 365/365 = 1 --> You only have stock for 1 more day.
If you have a turnover of 100, then DOS will be 365/100 = 36.5 --> You have 36,5 days of stock left.
if you have a turnover of 1, then DOS will be 365/1 = 365 --> You have 1 year of stock left.
M Turn
Description
Text/name of the variable and explanation
Calculation rule detail
Turn of month M = (Annualized Stock Issues M) / (End of M stock value)
= (Stock issues of month M + Stock issues of month M-1 + Stock issues of month M-2) * 4 / (end of M stock value)
Annualized Stock Issues M (K Currency)
Description
It's the amount of the stock issues from M-2 to M multiplied by 4 (annualized).
Amount is in thousands (Kilo currency).
Are considered issues the following material movement types :
Calculation rule detail
Annualized Stock Issues M (K Currency) =
Ex : The annualized stock issues of February 2015 is equal to the stock issues of (February 2015 + January 2015 + December 2015) multiplied by 4.
Currency Conversion
There is no currency conversion in this query as it's intended to be used usually for a single plant or single legal entity.
Conditional Formatting
See how to use in the Formatting page.
| Condition Name | Rule |
|---|---|
| TURN <> 0 | Shows only the lines for which the TURN is not equal to 0 (Usually materials without inventory) |
| TURN = 0 |
FAQ
Question : What does the X value mean in DOS ?
A "X" value in BW means that the calculation couldn't be done due to a division by 0. In the case of the DOS, it means the TURN was equal to 0.
Question : How can I remove all the lines where TURN is empty (Lines where the material has no stock) ?
You can activate one of the BEX Conditions to filter on the data
