How Expiry Dates and Late Customer Orders Cause Spoilage and Shortages
When customers delay their early-week orders into next week, older stock on your shelf expires before it can be used—causing both wasted expired goods and a shortage next week.
Interactive calculator loads automatically in modern browsers. All plain-English explanations, units, and tables are shown directly on this page.
How This Rule Works in Simple Steps
What We Want to Achieve: expose expiry and service tradeoffs — Older stock expires between two demand windows.
- Serve early demand FEFO; expire old remainder; serve late from fresh.
- Expired units never satisfy a later customer commitment.
- Old-lot consumption cannot exceed the pre-expiry demand.
- Keep pure calculation code separate from storage and UI.
Three Simple Steps We Compare on This Page
- 1. Normal Day (Baseline Plan): Apply the baseline policy to the frozen input state.
- 2. Problem Day (When Something Goes Wrong): Move specified early demand to the post-expiry window.
- 3. Fixed Plan (How We Solve It): Move only the customer-approved quantity back before expiry.
Important Things to Remember Before Using in Real Life
- Synthetic nonregulated product; repair needs customer consent.
- Passing this model does not validate a complete real supply chain.
- A case must disclose every assumption used in the calculation.
7 Worked Examples of "How Expiry Dates and Late Customer Orders Cause Spoilage and Shortages"
Click any of the 7 worked examples below to open its own separate page with step-by-step numbers and a visual bar chart:
- SCI-043: Stock survives the count not the week — An old lot becomes unusable after the first window. (Physical stock and later usable stock are different quantities.)
- SCI-044: Promotion after best use window — A promotional window follows lot expiry. (Inventory for an earlier window cannot serve the later promotion.)
- SCI-045: Customer postpones the aging lot — A customer postpones demand past the lot cutoff. (The same order quantity requires a different usable supply mix.)
- SCI-046: Fresh lot used too early — Fresh stock is consumed before usable old stock. (The baseline contract uses FEFO to preserve later usable supply.)
- SCI-047: Earlier delivery needs agreement — Customers can accept a documented earlier delivery. (The repair cannot simply invent extra demand before expiry.)
- SCI-048: Short receiving life — An incoming lot has less life than the planning horizon. (A nominal receipt quantity overstates later availability.)
- SCI-049: Returned lot life remains short — Returned usable stock retains its original age. (The return does not create a new usable-life window.)