========================================================================================== SPRING WEEKEND BLOWOUT — PROMOTIONAL REPLENISHMENT PLAN ========================================================================================== Event: April 17–19, 2026 (Fri–Sun, 3-day weekend) Plan Date: April 13, 2026 (Monday) PO Deadline: EOD Today Prepared by: Demand Planning ────────────────────────────────────────────────────────────────────────────────────────── EXECUTIVE SUMMARY ────────────────────────────────────────────────────────────────────────────────────────── Total POs required: 15 line items across 6 vendors Total PO units: 3,726 Total PO value (cost): $12,821.40 CRITICAL stockout risks: 9 SKU-DC combos HIGH stockout risks: 3 SKU-DC combos No PO needed: 8 SKU-DC combos (adequate coverage) *** CRITICAL ALERTS *** !!! SKU-1003 Cold Brew Coffee 32oz @ DC-East: stocks out Apr 20-26 (dip week) IP=410, promo wk demand=328, LT=28d PO of 852 units placed today won't arrive until ~28 days !!! SKU-1003 Cold Brew Coffee 32oz @ DC-West: stocks out Apr 20-26 (dip week) IP=290, promo wk demand=251, LT=28d PO of 672 units placed today won't arrive until ~28 days !!! SKU-1006 Trail Mix Cranberry 24oz @ DC-East: stocks out ~Apr 27 (week 3) IP=195, promo wk demand=112, LT=21d PO of 120 units placed today won't arrive until ~21 days !!! SKU-1006 Trail Mix Cranberry 24oz @ DC-West: stocks out ~Apr 27 (week 3) IP=140, promo wk demand=80, LT=21d PO of 84 units placed today won't arrive until ~21 days !!! SKU-1008 Kombucha Ginger 16oz @ DC-East: stocks out Apr 20-26 (dip week) IP=175, promo wk demand=116, LT=28d PO of 288 units placed today won't arrive until ~28 days !!! SKU-1008 Kombucha Ginger 16oz @ DC-West: stocks out Apr 20-26 (dip week) IP=110, promo wk demand=84, LT=28d PO of 228 units placed today won't arrive until ~28 days !!! SKU-1009 Coconut Water 12pk @ DC-West: stocks out Apr 20-26 (dip week) IP=250, promo wk demand=192, LT=14d PO of 180 units placed today won't arrive until ~14 days !!! SKU-1011 Dark Chocolate Bar 3.5oz @ DC-East: stocks out ~May 11 (week 5) IP=310, promo wk demand=99, LT=35d PO of 240 units placed today won't arrive until ~35 days !!! SKU-1012 Mixed Nuts Roasted 16oz @ DC-West: stocks out ~Apr 27 (week 3) IP=240, promo wk demand=138, LT=21d PO of 204 units placed today won't arrive until ~21 days >> ACTION: Contact Pacific Roasters (VND-118) and NorthStar Foods (VND-201) for expedited/partial shipments on critical items. Explore DC-to-DC transfers or substitute sourcing for bridge coverage. ────────────────────────────────────────────────────────────────────────────────────────── DEMAND FORECAST BY SKU × DC ────────────────────────────────────────────────────────────────────────────────────────── SKU DC Base/wk σ_d Lift Promo Wk Dip Wk Dip% ---------------------------------------------------------------------- SKU-1001 DC-East 185 5.5 1.70 241 167 10% SKU-1001 DC-West 142 3.1 1.70 185 128 10% SKU-1002 DC-East 308 8.4 1.55 381 284 8% SKU-1002 DC-West 225 6.8 1.55 278 207 8% SKU-1003 DC-East 216 10.5 2.20 328 191 12% SKU-1003 DC-West 165 6.6 2.20 251 146 12% SKU-1004 DC-East 94 3.2 1.60 118 85 10% SKU-1004 DC-West 72 2.4 1.60 91 65 10% SKU-1005 DC-East 420 10.2 1.65 537 378 10% SKU-1005 DC-West 308 6.8 1.65 395 278 10% SKU-1006 DC-East 76 3.2 2.10 112 67 12% SKU-1006 DC-West 54 2.2 2.10 80 48 12% SKU-1007 DC-East 153 4.7 1.60 193 138 10% SKU-1007 DC-West 119 2.8 1.60 150 107 10% SKU-1008 DC-East 86 3.3 1.80 116 80 8% SKU-1008 DC-West 62 2.9 1.80 84 57 8% SKU-1009 DC-East 195 5.6 1.70 254 176 10% SKU-1009 DC-West 147 3.6 1.70 192 133 10% SKU-1010 DC-East 109 3.1 1.40 128 104 5% SKU-1010 DC-West 84 3.2 1.40 99 80 5% SKU-1011 DC-East 64 3.6 2.30 99 56 12% SKU-1012 DC-East 138 3.1 1.75 183 128 8% SKU-1012 DC-West 104 3.2 1.75 138 96 8% ────────────────────────────────────────────────────────────────────────────────────────── SAFETY STOCK (recalculated with updated lead times) ────────────────────────────────────────────────────────────────────────────────────────── SKU DC SL% Z LT(d) σ_LT SS Notes -------------------------------------------------------------------------------- SKU-1001 DC-East 95% 1.65 21d 4d 176 ** EXTENDED SKU-1001 DC-West 95% 1.65 21d 4d 134 ** EXTENDED SKU-1002 DC-East 95% 1.65 7d 1d 74 SKU-1002 DC-West 95% 1.65 7d 1d 55 SKU-1003 DC-East 95% 1.65 28d 6d 308 ** EXTENDED SKU-1003 DC-West 95% 1.65 28d 6d 235 ** EXTENDED SKU-1004 DC-East 95% 1.65 21d 4d 89 ** EXTENDED SKU-1004 DC-West 95% 1.65 21d 4d 68 ** EXTENDED SKU-1005 DC-East 95% 1.65 10d 2d 199 SKU-1005 DC-West 95% 1.65 10d 2d 147 SKU-1006 DC-East 90% 1.28 21d 4d 56 ** EXTENDED SKU-1006 DC-West 90% 1.28 21d 4d 40 ** EXTENDED SKU-1007 DC-East 95% 1.65 18d 3d 110 SKU-1007 DC-West 95% 1.65 18d 3d 85 SKU-1008 DC-East 90% 1.28 28d 6d 95 ** EXTENDED SKU-1008 DC-West 90% 1.28 28d 6d 69 ** EXTENDED SKU-1009 DC-East 95% 1.65 14d 3d 139 SKU-1009 DC-West 95% 1.65 14d 3d 105 SKU-1010 DC-East 99% 2.33 28d 5d 182 SKU-1010 DC-West 99% 2.33 28d 5d 141 SKU-1011 DC-East 90% 1.28 35d 7d 82 SKU-1012 DC-East 95% 1.65 21d 4d 131 ** EXTENDED SKU-1012 DC-West 95% 1.65 21d 4d 99 ** EXTENDED ────────────────────────────────────────────────────────────────────────────────────────── INVENTORY POSITION & COVERAGE ANALYSIS ────────────────────────────────────────────────────────────────────────────────────────── SKU DC OnHand InTrns IP CovDmd SS Req Gap Risk ------------------------------------------------------------------------------------- SKU-1001 DC-East 620 240 860 593 176 769 0 LOW SKU-1001 DC-West 480 0 480 454 134 588 108 WATCH * SKU-1002 DC-East 540 192 732 381 74 455 0 WATCH * SKU-1002 DC-West 390 192 582 278 55 333 0 WATCH * SKU-1003 DC-East 410 0 410 950 308 1,258 848 CRITICAL *** SKU-1003 DC-West 290 0 290 726 235 961 671 CRITICAL *** SKU-1004 DC-East 310 144 454 296 89 385 0 LOW SKU-1004 DC-West 220 0 220 227 68 295 75 HIGH ** SKU-1005 DC-East 880 320 1,200 699 199 898 0 LOW SKU-1005 DC-West 610 320 930 514 147 661 0 LOW SKU-1006 DC-East 195 0 195 254 56 310 115 CRITICAL *** SKU-1006 DC-West 140 0 140 181 40 221 81 CRITICAL *** SKU-1007 DC-East 380 160 540 419 110 529 0 LOW SKU-1007 DC-West 270 0 270 325 85 410 140 MODERATE SKU-1008 DC-East 175 0 175 367 95 462 287 CRITICAL *** SKU-1008 DC-West 110 0 110 264 69 333 223 CRITICAL *** SKU-1009 DC-East 360 216 576 429 139 568 0 LOW SKU-1009 DC-West 250 0 250 324 105 429 179 CRITICAL *** SKU-1010 DC-East 280 120 400 450 182 632 232 HIGH ** SKU-1010 DC-West 190 120 310 346 141 487 177 HIGH ** SKU-1011 DC-East 310 0 310 346 82 428 118 CRITICAL *** SKU-1012 DC-East 350 192 542 449 131 580 38 LOW SKU-1012 DC-West 240 0 240 337 99 436 196 CRITICAL *** ────────────────────────────────────────────────────────────────────────────────────────── PURCHASE ORDER RECOMMENDATIONS (submit by EOD April 13) ────────────────────────────────────────────────────────────────────────────────────────── VENDOR: Pacific Roasters (VND-118) *** LEAD TIME EXTENDED: 28d (σ=6d) *** ─────────────────────────────────────────────────────────────────────────── SKU DC PO Qty Packs Unit$ PO Value Risk ----------------------------------------------------------------- SKU-1003 DC-East 852 71x12 $ 2.85 $ 2,428.20 CRITICAL SKU-1003 DC-West 672 56x12 $ 2.85 $ 1,915.20 CRITICAL SKU-1008 DC-East 288 24x12 $ 2.40 $ 691.20 CRITICAL SKU-1008 DC-West 228 19x12 $ 2.40 $ 547.20 CRITICAL ----------------------------------------------------------------- VENDOR TOTAL: 2,040 units $ 5,581.80 >> ESCALATION: Request expedited/partial shipment for: - SKU-1003 Cold Brew Coffee 32oz @ DC-East: stocks out Apr 20-26 (dip week) - SKU-1003 Cold Brew Coffee 32oz @ DC-West: stocks out Apr 20-26 (dip week) - SKU-1008 Kombucha Ginger 16oz @ DC-East: stocks out Apr 20-26 (dip week) - SKU-1008 Kombucha Ginger 16oz @ DC-West: stocks out Apr 20-26 (dip week) VENDOR: NorthStar Foods (VND-201) *** LEAD TIME EXTENDED: 21d (σ=4d) *** ─────────────────────────────────────────────────────────────────────────── SKU DC PO Qty Packs Unit$ PO Value Risk ----------------------------------------------------------------- SKU-1001 DC-West 120 10x12 $ 3.45 $ 414.00 WATCH SKU-1004 DC-West 84 7x12 $ 4.10 $ 344.40 HIGH SKU-1006 DC-East 120 10x12 $ 3.75 $ 450.00 CRITICAL SKU-1006 DC-West 84 7x12 $ 3.75 $ 315.00 CRITICAL SKU-1012 DC-East 96 8x12 $ 4.25 $ 408.00 LOW SKU-1012 DC-West 204 17x12 $ 4.25 $ 867.00 CRITICAL ----------------------------------------------------------------- VENDOR TOTAL: 708 units $ 2,798.40 >> ESCALATION: Request expedited/partial shipment for: - SKU-1004 Almond Butter 12oz @ DC-West: stocks out ~Apr 27 (week 3) - SKU-1006 Trail Mix Cranberry 24oz @ DC-East: stocks out ~Apr 27 (week 3) - SKU-1006 Trail Mix Cranberry 24oz @ DC-West: stocks out ~Apr 27 (week 3) - SKU-1012 Mixed Nuts Roasted 16oz @ DC-West: stocks out ~Apr 27 (week 3) VENDOR: FreshDairy Co (VND-305) ─────────────────────────────────────────────────────────────────────────── No PO required — all SKUs adequately covered. VENDOR: ClearSpring Beverage (VND-440) ─────────────────────────────────────────────────────────────────────────── No PO required — all SKUs adequately covered. VENDOR: FitFuel Inc (VND-522) ─────────────────────────────────────────────────────────────────────────── SKU DC PO Qty Packs Unit$ PO Value Risk ----------------------------------------------------------------- SKU-1007 DC-West 144 18x8 $ 6.50 $ 936.00 MODERATE ----------------------------------------------------------------- VENDOR TOTAL: 144 units $ 936.00 VENDOR: TropiSource (VND-610) ─────────────────────────────────────────────────────────────────────────── SKU DC PO Qty Packs Unit$ PO Value Risk ----------------------------------------------------------------- SKU-1009 DC-West 180 30x6 $ 3.60 $ 648.00 CRITICAL ----------------------------------------------------------------- VENDOR TOTAL: 180 units $ 648.00 >> ESCALATION: Request expedited/partial shipment for: - SKU-1009 Coconut Water 12pk @ DC-West: stocks out Apr 20-26 (dip week) VENDOR: MediterraImports (VND-715) ─────────────────────────────────────────────────────────────────────────── SKU DC PO Qty Packs Unit$ PO Value Risk ----------------------------------------------------------------- SKU-1010 DC-East 234 39x6 $ 5.80 $ 1,357.20 HIGH SKU-1010 DC-West 180 30x6 $ 5.80 $ 1,044.00 HIGH ----------------------------------------------------------------- VENDOR TOTAL: 414 units $ 2,401.20 >> ESCALATION: Request expedited/partial shipment for: - SKU-1010 Olive Oil Extra Virgin 25oz @ DC-East: stocks out ~May 04 (week 4) - SKU-1010 Olive Oil Extra Virgin 25oz @ DC-West: stocks out ~May 04 (week 4) VENDOR: EuroSweets GmbH (VND-830) ─────────────────────────────────────────────────────────────────────────── SKU DC PO Qty Packs Unit$ PO Value Risk ----------------------------------------------------------------- SKU-1011 DC-East 240 10x24 $ 1.90 $ 456.00 CRITICAL ----------------------------------------------------------------- VENDOR TOTAL: 240 units $ 456.00 >> ESCALATION: Request expedited/partial shipment for: - SKU-1011 Dark Chocolate Bar 3.5oz @ DC-East: stocks out ~May 11 (week 5) ────────────────────────────────────────────────────────────────────────────────────────── STOCKOUT RISK SUMMARY & BRIDGE ORDER RECOMMENDATIONS ────────────────────────────────────────────────────────────────────────────────────────── [CRITICAL] SKU-1003 Cold Brew Coffee 32oz @ DC-East Current IP: 410 | Promo wk demand: 328 | LT: 28d Estimated stockout: Apr 20-26 (dip week) Bridge qty needed: ~540 units to cover gap until PO arrives >> Recommend: expedited partial ship / DC transfer / alternate source [CRITICAL] SKU-1003 Cold Brew Coffee 32oz @ DC-West Current IP: 290 | Promo wk demand: 251 | LT: 28d Estimated stockout: Apr 20-26 (dip week) Bridge qty needed: ~436 units to cover gap until PO arrives >> Recommend: expedited partial ship / DC transfer / alternate source [CRITICAL] SKU-1006 Trail Mix Cranberry 24oz @ DC-East Current IP: 195 | Promo wk demand: 112 | LT: 21d Estimated stockout: ~Apr 27 (week 3) Bridge qty needed: ~59 units to cover gap until PO arrives >> Recommend: expedited partial ship / DC transfer / alternate source [CRITICAL] SKU-1006 Trail Mix Cranberry 24oz @ DC-West Current IP: 140 | Promo wk demand: 80 | LT: 21d Estimated stockout: ~Apr 27 (week 3) Bridge qty needed: ~41 units to cover gap until PO arrives >> Recommend: expedited partial ship / DC transfer / alternate source [CRITICAL] SKU-1008 Kombucha Ginger 16oz @ DC-East Current IP: 175 | Promo wk demand: 116 | LT: 28d Estimated stockout: Apr 20-26 (dip week) Bridge qty needed: ~192 units to cover gap until PO arrives >> Recommend: expedited partial ship / DC transfer / alternate source [CRITICAL] SKU-1008 Kombucha Ginger 16oz @ DC-West Current IP: 110 | Promo wk demand: 84 | LT: 28d Estimated stockout: Apr 20-26 (dip week) Bridge qty needed: ~154 units to cover gap until PO arrives >> Recommend: expedited partial ship / DC transfer / alternate source [CRITICAL] SKU-1009 Coconut Water 12pk @ DC-West Current IP: 250 | Promo wk demand: 192 | LT: 14d Estimated stockout: Apr 20-26 (dip week) Bridge qty needed: ~74 units to cover gap until PO arrives >> Recommend: expedited partial ship / DC transfer / alternate source [CRITICAL] SKU-1011 Dark Chocolate Bar 3.5oz @ DC-East Current IP: 310 | Promo wk demand: 99 | LT: 35d Estimated stockout: ~May 11 (week 5) Bridge qty needed: ~36 units to cover gap until PO arrives >> Recommend: expedited partial ship / DC transfer / alternate source [CRITICAL] SKU-1012 Mixed Nuts Roasted 16oz @ DC-West Current IP: 240 | Promo wk demand: 138 | LT: 21d Estimated stockout: ~Apr 27 (week 3) Bridge qty needed: ~97 units to cover gap until PO arrives >> Recommend: expedited partial ship / DC transfer / alternate source [HIGH] SKU-1004 Almond Butter 12oz @ DC-West Current IP: 220 | Promo wk demand: 91 | LT: 21d Estimated stockout: ~Apr 27 (week 3) >> Recommend: request expedited shipment, monitor daily POS [HIGH] SKU-1010 Olive Oil Extra Virgin 25oz @ DC-East Current IP: 400 | Promo wk demand: 128 | LT: 28d Estimated stockout: ~May 04 (week 4) >> Recommend: request expedited shipment, monitor daily POS [HIGH] SKU-1010 Olive Oil Extra Virgin 25oz @ DC-West Current IP: 310 | Promo wk demand: 99 | LT: 28d Estimated stockout: ~May 04 (week 4) >> Recommend: request expedited shipment, monitor daily POS [WATCH] SKU-1001 Organic Granola 16oz @ DC-West Current IP: 480 | Promo wk demand: 185 | LT: 21d Estimated stockout: Tight buffer — any demand spike breaks SS >> Recommend: monitor daily POS, prepare contingency reorder [WATCH] SKU-1002 Greek Yogurt Variety 12pk @ DC-East Current IP: 732 | Promo wk demand: 381 | LT: 7d Estimated stockout: Tight buffer — any demand spike breaks SS >> Recommend: monitor daily POS, prepare contingency reorder [WATCH] SKU-1002 Greek Yogurt Variety 12pk @ DC-West Current IP: 582 | Promo wk demand: 278 | LT: 7d Estimated stockout: Tight buffer — any demand spike breaks SS >> Recommend: monitor daily POS, prepare contingency reorder ────────────────────────────────────────────────────────────────────────────────────────── SPECIAL COORDINATION NOTES ────────────────────────────────────────────────────────────────────────────────────────── 1. DAIRY (SKU-1002 Greek Yogurt): No PO needed — ample stock at both DCs. However, coordinate with FreshDairy Co on shelf-life dating for promo units. Ensure units arriving have >14 days remaining shelf life for weekend event. 2. PACIFIC ROASTERS (SKU-1003, SKU-1008): 28-day lead time means today's PO arrives ~May 11. Current stock covers only ~1.5-2 weeks. CRITICAL gap. Escalate to supply chain director per protocol (vendor LT increase >25%). 3. NORTHSTAR FOODS (SKU-1001, 1004, 1006, 1012): 21-day lead time (was 14d). SKU-1006 and SKU-1012 West have tight coverage through lead time. NorthStar POs should include a request for earliest possible ship date. 4. POST-PROMO WEEK (Apr 20-26): Dip expected across all SKUs. Do NOT reorder aggressively during dip week — let inventory normalize before next cycle. ────────────────────────────────────────────────────────────────────────────────────────── LIFT ESTIMATION METHODOLOGY ────────────────────────────────────────────────────────────────────────────────────────── Lifts derived from own-item promo history with recency weighting, adjusted for: - Promo type (BOGO > % Off at equivalent depth) - Display type (Floor Stack/Endcap > Shelf Talker) - Circular feature (adds ~10-15% incremental lift) - Seasonal timing (spring wellness trend supports protein/health items) 3-day weekend scaling: lift multiplier applies to Fri-Sun only. Promo week = baseline × (4/7 + 3/7 × lift), NOT baseline × lift. Post-promo dip: based on historical observed dip %, scaled by promo depth and product storability. BOGO on shelf-stable = higher dip (12%). Perishables/low-depth = lower dip (5-8%). Confidence interval: ±20-25% on lift estimates. Safety stock sized accordingly. ==========================================================================================