Coca-ColaMaterial Risk Agent
PN

Material 360

Citric Acid Ingredient

RM-10482 · Raw material · Atlanta Concentrate Plant

AT RISK

Critical expiry risk

18,400 KG

Available inventory

6 d remaining

Shelf life

$284K

Inventory value at risk

3 orders

Open orders

Shelf-life distribution

Available inventory across ageing buckets

—
0–5 days
23,600 KG
6–15 days
—
16–30 days
24,000 KG
31–60 days
12,600 KG
60+ days

Open orders

Production runs that draw this material

PO-88172LINE 3 · Sep 1218,400 KGAT RISK
PO-88199LINE 3 · Sep 1824,000 KGHEALTHY
PO-88224LINE 1 · Sep 2512,600 KGHEALTHY
PO-88345LINE 4 · Oct 029,800 KGHEALTHY

The ageing batch is not covered by the current plan

BATCH-25-0819 expires before the next run that consumes it.

See the plan conflict →

Where used

Material genealogy from recipe to bottler demand

Material

RM-10482 · Citric Acid Ingredient

Recipe A · Sparkling base

0.42 KG / unit

Recipe D · Still base

0.19 KG / unit

Concentrate Base 4C

Atlanta

Concentrate Base 7A

Dublin

Sparkling Concentrate 1L

Atlanta

Sparkling Concentrate 2L

Shanghai

Coca-Cola Consolidated

Southeast US

Swire Beverages

East China

Inbound supply

Expected consumption and projected closing inventory

Supplier

ChemCo Ingredients

Open PO

PO-442812

Next delivery

Sep 16

Inbound quantity

22,000 KG

Lead time

21 days

Supply risk

Low

Sep 02
41,800 KG
Sep 09
41,800 KG
Sep 16
39,800 KG
Sep 23
27,200 KG
Sep 30
17,400 KG
Available inventoryExpected consumptionInbound supplyProjected closing inventory