Supply Chain Ideas Simple, Clear Supply Chain Learning for Everyone
WORKED SUPPLY CHAIN EXAMPLE · SCI-043 · CRAFT ADHESIVES

Example SCI-043: Stock survives the count not the week — An old lot becomes unusable after the first window.

What goes wrong: Physical stock and later usable stock are different quantities. How we fix it: Move only the customer-approved quantity back before expiry.

Everyday Real-Life Example: Common mistake: thinking "All physical stock remains available for later demand." In reality: Older stock expires between two demand windows.

Interactive calculator loads automatically in modern browsers. All plain-English explanations, units, and tables are shown directly on this page.

Visual Before-and-After Chart (SCI-043)

Bar chart comparing normal day, problem day, and fixed plan for SCI-043

Key Question to Ask: Inspect remaining usable life at the time of customer demand.

How to Fix It: Move only the customer-approved quantity back before expiry.

Simple Summary of This Example

Starting Numbers & Units for SCI-043

Starting Numbers and Allowed Ranges (SCI-043)
Number Name Unit of Measure Starting Value Allowed Range
old lot (old_lot) pieces 120 0 to 1000000 (integer)
fresh lot (fresh_lot) pieces 60 0 to 1000000 (integer)
early demand (early_demand) pieces 120 0 to 1000000 (integer)
late demand (late_demand) pieces 60 0 to 1000000 (integer)
shift to late (shift_to_late) pieces 40 0 to 1000000 (integer)
repair shift back (repair_shift_back) pieces 40 0 to 1000000 (integer)

Compare Normal Day vs. Problem Day vs. Fixed Plan (SCI-043)

Results for Normal Day (Baseline), Problem Day (Stress), and Fixed Plan (Repair)
Result Name Unit Normal Day (Baseline) Problem Day (Stress) Fixed Plan (Repair)
on time units (on_time_units) pieces 180 140 180
late units (late_units) pieces 0 40 0
expired units (expired_units) pieces 0 40 0
ending fresh (ending_fresh) pieces 0 0 0

Other Related Examples on "How Expiry Dates and Late Customer Orders Cause Spoilage and Shortages"