Supply Chain Ideas Simple, Clear Supply Chain Learning for Everyone
WORKED SUPPLY CHAIN EXAMPLE · SCI-040 · MAINTENANCE INVENTORY

Example SCI-040: Spare part replenishment lot — A small shortage triggers a large purchase lot.

What goes wrong: The feasible purchase protects service while increasing holdings. How we fix it: Use an already approved pooled purchase arrangement.

Everyday Real-Life Example: Common mistake: thinking "Net material requirement equals the actual purchase quantity." In reality: Order constraints create cash and stock exposure beyond net need.

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-040)

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

Key Question to Ask: Review remaining stock after demand as well as the immediate service.

How to Fix It: Use an already approved pooled purchase arrangement.

Simple Summary of This Example

Starting Numbers & Units for SCI-040

Starting Numbers and Allowed Ranges (SCI-040)
Number Name Unit of Measure Starting Value Allowed Range
demand (demand) pieces 170 0 to 1000000 (integer)
opening stock (opening_stock) pieces 40 0 to 1000000 (integer)
minimum order (minimum_order) pieces 300 0 to 1000000 (integer)
order multiple (order_multiple) pieces 100 1 to 1000000 (integer)
pooled minimum (pooled_minimum) pieces 200 0 to 1000000 (integer)
pooled multiple (pooled_multiple) pieces 50 1 to 1000000 (integer)
unit cost (unit_cost) synthetic currency units per piece 12 0 to 1000000 (number)

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

Results for Normal Day (Baseline), Problem Day (Stress), and Fixed Plan (Repair)
Result Name Unit Normal Day (Baseline) Problem Day (Stress) Fixed Plan (Repair)
order units (order_units) pieces 130 300 200
ending units (ending_units) pieces 0 170 70
purchase cost (purchase_cost) synthetic currency units 1560 3600 2400
excess over requirement (excess_over_requirement) pieces 0 170 70

Other Related Examples on "Why Supplier Minimum Order Rules (MOQ) Leave You With Extra Leftover Stock"