Coca-ColaDATATRUST AI
Coca-Cola
Inventory OptimizationIO Inputs : Data Quality Scorecard

Region

Country

Plant

Inventory Program

IO Material Type

MRP Controller

Rule #IO.001

Beverage Product / Product ID with no Target Service Level = ZERO, NULL or 0.5

10.28K

10,280 defects out of 16,160 products

Owner : IO Data Steward

Rule #IO.002

KIT / Product where Abs (Demand Gap) > 50%

11

11 defects out of 15 products

50%

Owner : IO Data Steward

Rule #IO.003

Product ID with missing Production Lead Time [PART]

1.45K

1,450 defects out of 9,320 products

Owner : IO Data Steward

Rule #IO.004

Product ID with missing Production Lead Time [INTERMEDIATE and STOCKING INTERMEDIATE]

864

864 defects out of 5,140 products

Owner : IO Data Steward

Rule #IO.005

Product ID with missing Transportation (Procurement) Lead Time [INGREDIENT]

2.11K

2,110 defects out of 7,480 products

Owner : IO Data Steward

Rule #IO.006

Products missing network echelon (PSH/PSI) [Procurement Type = Produced (E)]

1.27K

1,270 defects out of 6,900 products

Owner : IO Data Steward

Rule #IO.007

Products missing network echelon (PSH/PSI) [Procurement Type = Procured (F)]

3.42K

3,420 defects out of 11,050 products

Owner : IO Data Steward

Rule #IO.008

Products missing network echelon (PSH/PSI) [Procurement Type = Both Produced and Procured (X)]

612

612 defects out of 2,380 products

Owner : IO Data Steward

Rule #IO.009

Products missing network echelon (PSH/PSI) [Procurement Type = Blank / Null]

1.98K

1,980 defects out of 4,760 products

Owner : IO Data Steward

Rule #IO.010

Produced Products [Procurement Type = E] with records in Location Source and Transport Ratio = 1

742

742 defects out of 6,900 products

Owner : IO Data Steward

Rule #IO.011

Procured Products [Procurement Type = F] with records in Production Source Header and Production Ratio = 1

935

935 defects out of 11,050 products

Owner : IO Data Steward

Rule #IO.012

Procured or Produced Products [Procurement Type = E | F] with records in Production Source Header and Location Source and Both Transport Ratio = 1 and Production Ratio = 1

418

418 defects out of 17,950 products

Owner : IO Data Steward

Rule #IO.013

Products where a source record exists but; Both Transport Ratio = 0 and Production Ratio = 0

1.06K

1,060 defects out of 17,950 products

Owner : IO Data Steward

Rule #IO.014

Products where a source record exists but; Both Transport Ratio = 0 and Production Ratio = 0

1.06K

1,060 defects out of 17,950 products

Owner : IO Data Steward

Rule #IO.015

Location-Product combinations with NO records in Location Source AND NO records in Production Source Header (absent from both sources)

2.84K

2,840 defects out of 21,300 combinations

Owner : IO Data Steward

Rule #IO.016

STO Products Missing SPK

586

586 defects out of 3,940 products

Owner : IO Data Steward

Rule #IO.017

Products with Missing or Invalid Total Shelf Life

4.37K

4,370 defects out of 16,160 products

Owner : IO Data Steward

Rule #IO.018

Products where Total Shelf Life > 50 Days

8

8 defects out of 14 products

50 Days

Owner : IO Data Steward

Rule #IO.019

—

—

Owner : Undefined

Rule #IO.020

—

—

Owner : Undefined

Rule #IO.021

—

—

Owner : Undefined

Rule #IO.022

—

—

Owner : Undefined

Rule #IO.023

—

—

Owner : Undefined

Rule #IO.024

—

—

Owner : Undefined

Rule #IO.025

—

—

Owner : Undefined

Rule #IO.026

—

—

Owner : Undefined

Rule #IO.027

—

—

Owner : Undefined

Rule #IO.028

—

—

Owner : Undefined

Rule #IO.029

—

—

Owner : Undefined

Rule #IO.030

—

—

Owner : Undefined