Stock
Exceptions: Stockouts and Lost Sales
Technical Name: 0FRE_C02_Q0001
Use
This query is used to analyze the occurrence of stockouts and lost sales resulting from those stockouts and possible stockouts.
These variables enable the user to enter a selection range of days, products and locations (belongs to Variables Used).
You can use the query to calculate the following key performance indicators (KPIs):
Calculated key figures
Sales price per unit
Moving average cost per unit
Query formulas
Lost Sales (consumption) value
Lost Gross margin
Actual service level
The following KPIs and key figures are displayed in this query:
Number of stockouts
Lost Sales units
Forecasted sales
Sales units (consumption)
Sales Value
Range of coverage in days
Minimum Stock
Stock quantity
Filter
InfoObject |
Description of the InfoObject (or restriction or calculation formula) |
N/A |
|
Free Characteristics
InfoObject |
Name |
0VENDOR |
Vendor |
0SUPP_PLANT |
Supplying plant |
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 |
0FRE_PLNPUR |
Replenishment Planner |
0FRE_RPLTIM |
Total Replenishment Lead Time |
0ABCKEY |
ABC Indicator |
0FRE_SELCLS |
Selling Class |
0FRE_STKEXC |
Stock Exception Type |
0FRE_ROCINV |
Range of Coverage Too High |
Variables Used
Variable |
Name |
0I_DAYS |
(required) Period |
0S_PROD |
Product |
0S_LOC |
Location |
Rows
InfoObject |
Description of the InfoObject (or restriction or calculation formula) |
0CALDAY |
Period |
0MATERIAL |
Product |
0PLANT |
Location |
Columns
InfoObject |
Description of the InfoObject (or restriction or calculation formula) |
0FRE_CNTSO |
Number of Stockouts |
0FRE_CNTPSO |
Number of Possible Stockouts |
0FRE_LSTCSP |
Lost Consumption |
0FRE_LCSVAL |
Lost Sales Value |
0FRE_C02_CK002 |
Lost Gross Margin (Calculated Key Figure) Lost Gross Margin = (‘Lost Comsumption Value’ – ‘Lost Comsumption Cost’) |
0FRE_C02_CK003 |
Actual Service Level (Calculated KeyFigure) Actual Service Level = Daily Consumption %A (Daily Consumption + Lost Consumption) |
0FRE_FCST |
Daily Forecasted Consumption in BuoM (Daily Sales) |
0FRE_CONSMP |
Daily Consumption |
0FRE_CONVAL |
Consumption Value (at Retail Price) |
0FRE_C02_CK001 |
Range of Coverage in Days ROC in Days (Calculated Key Figure) ROC in Days = Range of Coverage in Days / Stockouts + Possible Stockouts |
0FRE_MINSTK |
Minimum Stock |
0FRE_STOCK |
Stock Quantity |
Report Report Interface
Query |
Name |
None |
/ |