Details
-
Story
-
Resolution: Completed
-
Medium
-
None
-
None
-
None
-
GxP
-
IMDP Sprint 139
Description
Acceptance Criteria1: Click on any of SKU and section Key Data for SKU is displayed with below fields and respective values.
Brand:
Market:
BU:
Sub BU:
Source:
Below data is displayed
SKU Customer Service Level for last 12 months -> Tableau Report (we used it last time)
Brand/Site Perspective | Customer Service Level -> Tableau Report
(we used it last time)
12-month Forecast Bias -> -ve or +ve (Calculation shown by Naito San) ----> Bias error quantity (UDH)
SIMS data | Stock out (Mavis) - from UDH table - PGSUDH_CDM.BI_SIMS_EVENTS (pls refer to the SIMS tab) & PGSUDH_CDM.BI_SIMS_REASON_CODE
Acceptance Criteria2: Model TDOS Calculation section Recommended TDOS, Forecast Uncertainty and Supply Uncertainty are displayed and values are correct
Acceptance Criteria3: Below sections, respective fields and values are displayed
Forecast Uncertainty (FC) section
Basic Data
Mat Code
Category
Service Level
LT
Forecast Error (Absolute %)
FEB 23
MAR 2023
APR 2023
MAY 2023
JUN 2023
JUL 2023
AUG 2023
SEP 2023
OCT 2023
NOV 2023
DEC 2023
JAN 2024
Calculation
Std Dev
Std * SQRT(30)
Model DOS (FC)
Verify that Supply Uncertainty (SC) section and values for the fields Batch information, Months, Current TDOS are displayed.
Table Batch Information displays information in below columns.
Batch
Qty
Date
Table Months displays information in below columns.
Month
Min DOS
Gap
Table Current TDOS displays information in below columns.
Std Dev
Value
Acceptance Criteria4: Recommendation History section -
Table displays information in below columns.
Role - Regional Inventory Lead, BSL, Market Planner
TDOS Recommendation
Recommended by
Reason for Recommendation
Date/Time