Supply Plan Recap

Q2 2026 — April through June

Adjustable Assumptions

Monthly Demand Multiplier

1.0x

Monthly Capacity (cans)

Lead Time (days)

FG Cost Multiplier

1.00x

Starting Position

3.0M

33,347 cases

Q2 Total Demand

2.6M

3-month forecast

Q2 Production

637K

cans planned

Ending DOS (Jun)

46d

Portfolio average

Ending Inventory

965K

10,718 cases

Capacity Buffer

48%

Tightest: Apr

Financial Impact — Current Inventory

Current Value (Base Cost)

$3.2M

At Adjusted Cost

$3.2M

Delta

$-0.42

Capacity Buffer — Monthly Breakdown

Buffer = (Monthly Capacity − Total Demand) / Monthly Capacity. Below 10% = risk. Below 0% = over-capacity.

Apr26.4%

May56.5%

Jun62.4%

Monthly capacity: 1.7M cans. Adjusted demand multiplier: 1.0x.

Inventory Waterfall — Q2 2026

Now

3.0M

Apr

2.0M

Demand: 1.2MProduction: 322KDOS: 49dCapacity: 19%

May

1.3M

Demand: 733KProduction: 66KDOS: 55dCapacity: 4%

Jun

965K

Demand: 634KProduction: 249KDOS: 46dCapacity: 15%

Ending Inventory Production

Production Schedule

SKU-level production runs at MSI. Min run = 10,350 cans/SKU.

SKU	Apr	May	Jun	Total Cans
Cappuccino-6Cappuccino	79K	—	12K	91K
Cappuccino-8Cappuccino	—	—	18K	18K
MA-4Mango	14K	20K	16K	50K
MA-6Mango	86K	7K	47K	139K
MT-6Mint	144K	20K	61K	225K
WG-6Wintergreen	—	—	33K	33K
WG-8Wintergreen	—	19K	63K	82K
Total	322K	66K	249K	637K

Demand vs. Supply Gap — By Month

Period	Demand	Production	Net Change	Ending Inv	DOS	Capacity
Apr	1.2M	322K	-919K	2.0M	49d	19%
May	733K	66K	-668K	1.3M	55d	4%
Jun	634K	249K	-385K	965K	46d	15%

How It Works

Adjust the assumptions above to run scenarios. Demand multiplier scales all SKU demand. Capacity affects utilization. Cost multiplier updates inventory value. All metrics recalculate in real-time.

Data Sources

Weekly Supply Planning: SP sheet from Weekly_Supply_Planning.xlsx

Inventory Levels: Cin7 stock snapshot and on-hand counts

Production Schedule: MSI Express production reports and batch allocation