Exercise set
Supply Chain Inventory Policy EOQ, Reorder Point, and Safety Stock Exercises
Solved inventory-policy exercises for EOQ, reorder points, safety stock, service level, MOQ exposure, inventory turns and release gates.
These exercises practise inventory-policy decisions for engineered supply chains: economic order quantity, reorder point, safety stock, lead-time demand, service level, minimum order quantity, cycle stock, days of supply, inventory turns, stockout exposure and policy release gates.
The goal is to decide whether inventory rules protect production without hiding cost, obsolescence, shelf-life or shortage risk. Gross stock is not enough; the policy must specify which units are quality-cleared, unallocated, revision-correct and usable inside the planning horizon.
Assume simplified planning models unless an exercise states otherwise. Real inventory release should also check BOM revision, demand phase, forecast bias, allocation conflicts, shelf life, storage limits, ERP accuracy, quality holds, supplier lead-time distribution and shortage consequence.
Release Evidence Notes
Inventory evidence should state item number, planning horizon, demand basis, lead-time boundary and inventory state. On-hand stock, available-to-promise stock, quality-cleared stock and allocated stock are different numbers.
EOQ evidence should be treated as a cost screen. Final policy may be governed by MOQ, shelf life, supplier lot size, price breaks, packaging multiple, storage capacity or shortage criticality.
Safety-stock evidence should state whether demand variability, lead-time variability or both are included. If lead time has heavy tails or intermittent demand, a normal approximation may be weak.
Release evidence should check that the chosen policy is executable in the ERP and visible to planners, purchasing, receiving, inspection and production release.
Engineering Boundary Notes
This page covers inventory policy and stock protection. Kanban cards, unit loads, line-side replenishment and inspection release belong in the material replenishment exercise set. Supplier lead-time service, disruption recovery and supplier release gates belong in the supplier performance exercise set.
Critical maintenance spares have additional asset-criticality, repairability and shelf-life concerns; use the critical spare-parts exercise set for that narrower reliability-spares decision.
Scenario Map
| Scenario | Exercises | Primary check | Engineering decision |
|---|---|---|---|
| Order quantity and cost | 1-4 | EOQ, annual cost, cycle stock and MOQ exposure | Set economic but feasible order rules. |
| Reorder and safety stock | 5-10 | lead-time demand, demand variation, z margin and service level | Set reorder points and stock buffers. |
| Inventory health | 11-15 | days of supply, turns, allocation, stockout cost and obsolescence | Decide whether policy is usable. |
| Policy release | 16-18 | forecast bias, shelf-life exposure and hard gates | Release, restrict or revise the inventory policy. |
Exercise 1: Economic Order Quantity
Annual demand is:
Order cost is:
Annual holding cost is:
Calculate EOQ.
Solution
Use:
Substitute:
Round:
Engineering Comment
EOQ minimizes a simplified ordering and holding-cost model. It does not check shelf life, MOQ, packaging multiple or supplier capacity.
Plausibility Check
Demand is high and holding cost is modest, so an order above one thousand units is plausible.
Exercise 2: Annual Ordering Cost at EOQ
Using:
estimate annual ordering cost.
Solution
Number of orders per year:
Ordering cost:
Engineering Comment
Fractional orders are acceptable in annual cost screening. Actual execution must use whole orders and approved lot sizes.
Plausibility Check
About eighteen orders per year at 85 each gives a cost a little above 1500.
Exercise 3: Annual Holding Cost at EOQ
Using:
estimate annual cycle-stock holding cost.
Solution
Average cycle stock:
Holding cost:
Engineering Comment
At EOQ, ordering and holding costs should be similar. If not, check units, annualization and cost assumptions.
Plausibility Check
The holding cost is nearly equal to Exercise 2 ordering cost, which is expected at EOQ.
Exercise 4: MOQ Exposure
Monthly demand is:
Supplier minimum order quantity is:
Find months of supply and average cycle stock.
Solution
Months of supply:
Average cycle stock:
Engineering Comment
Four months of supply may create engineering-change, shelf-life and cash exposure even when unit price looks favorable.
Plausibility Check
At six hundred units per month, twenty-four hundred units last four months.
Exercise 5: Reorder Point with Safety Stock
Average demand is:
Average lead time is:
Safety stock is:
Find reorder point.
Solution
Lead-time demand:
Reorder point:
Engineering Comment
The calculation should use usable inventory, not gross stock. Inspection holds and allocations can invalidate the trigger.
Plausibility Check
Five days of demand is twelve hundred units; adding safety stock gives fourteen eighty.
Exercise 6: Lead-Time Demand Variation
Daily demand standard deviation is:
Lead time is:
Assuming constant lead time, estimate lead-time demand standard deviation.
Solution
For independent daily demand:
So:
Engineering Comment
This excludes lead-time variability. If supplier lead time varies, safety stock can be much larger.
Plausibility Check
Six independent days increase standard deviation by \sqrt{6}, not by six.
Exercise 7: Safety Stock from Demand Variation
Use:
Find safety stock.
Solution
Safety stock:
Round up:
Engineering Comment
Rounding up is appropriate for release screening. Rounding down creates a small but avoidable service-level loss.
Plausibility Check
One and two thirds times eighty-six is a little above one hundred forty.
Exercise 8: Safety Stock with Lead-Time Variation
Daily demand is:
Demand standard deviation:
Average lead time:
Lead-time standard deviation:
Use z=1.65.
Solution
Combined standard deviation:
Safety stock:
Round:
Engineering Comment
Lead-time variability dominates. The corrective action may be supplier stabilization rather than more inventory.
Plausibility Check
Including lead-time variation raises safety stock far above the demand-only case.
Exercise 9: Service-Level Z Margin
Lead-time demand has:
Reorder point is:
Find z margin.
Solution
Use:
Substitute:
Engineering Comment
Z margin is a service-level screen. It should not be used blindly for intermittent or heavy-tail demand.
Plausibility Check
The buffer is 350 units, or a little more than one and a half standard deviations.
Exercise 10: Stockout Probability from Z
For:
use a one-sided normal tail of:
Find coverage probability.
Solution
Coverage is:
So:
Engineering Comment
Coverage should be compared with shortage consequence. A ninety-five percent rule may be weak for a line-stopping engineered component.
Plausibility Check
A z value near 1.65 normally corresponds to about ninety-five percent one-sided coverage.
Exercise 11: Days of Supply
Usable inventory is:
Average demand is:
Find days of supply.
Solution
Days of supply:
Engineering Comment
Days of supply should use usable inventory and a current demand rate. Old averages can hide launch or shutdown changes.
Plausibility Check
Four hundred fifty units per day consumes thirty-six hundred units in eight days.
Exercise 12: Inventory Turns
Annual demand value is:
Average inventory value is:
Find annual inventory turns.
Solution
Turns:
Engineering Comment
High turns can be good, but not if they create repeated shortage risk on constrained engineered parts.
Plausibility Check
Inventory value is one eighth of annual demand value, so turns are eight.
Exercise 13: Available Inventory after Allocations
Gross on-hand stock is:
Inspection hold is:
Allocated stock is:
Find usable inventory.
Solution
Usable inventory:
Engineering Comment
Inventory policy must act on usable inventory. Gross stock can make a shortage invisible until release.
Plausibility Check
Blocked and allocated stock total 680, leaving 1520.
Exercise 14: Expected Stockout Cost
Stockout probability during lead time is:
Cost of a stockout is:
Find expected stockout exposure.
Solution
Expected exposure:
Engineering Comment
Expected cost may understate safety or contractual consequences. Some stockouts require hard maximum risk.
Plausibility Check
About five percent of eighteen thousand is just under nine hundred.
Exercise 15: Periodic Review Order-Up-To Level
Average demand is:
Review period is:
Lead time is:
Safety stock is:
Find order-up-to level.
Solution
Protection period:
Order-up-to level:
Engineering Comment
Periodic review needs more stock than continuous review because it protects through the review period plus lead time.
Plausibility Check
Twelve days of demand is 2400 units; adding 320 gives 2720.
Exercise 16: Forecast Bias Impact on Inventory
Forecast demand is:
Actual demand is consistently:
For a four-week policy horizon, find hidden shortage from bias.
Solution
Weekly bias:
Four-week shortage:
Engineering Comment
Safety stock can be consumed by bias before random variation occurs. Correct the forecast before increasing buffers blindly.
Plausibility Check
Eighty units per week for four weeks gives three hundred twenty units.
Exercise 17: Shelf-Life Exposure from Policy
Order quantity is:
Monthly demand is:
Shelf life is:
Check whether the order is fully consumed before expiry.
Solution
Months of supply:
Since:
the order quantity exceeds shelf-life coverage.
Engineering Comment
MOQ or EOQ can conflict with shelf life. A smaller lot, supplier concession or demand-sharing plan may be needed.
Plausibility Check
The lot lasts four months, but shelf life is only three months.
Exercise 18: Inventory Policy Release Gate
An inventory policy has:
| Gate | Requirement | Current result |
|---|---|---|
| service coverage | at least 95\% | 95.2\% |
| usable stock basis | required | pass |
| shelf-life exposure | no expiry before use | fail |
| forecast bias action | closed | open |
Decide whether to release.
Solution
Service coverage and stock basis pass:
Shelf-life and forecast-bias gates fail. The policy is not releasable.
Engineering Comment
Inventory release is not only a service-level calculation. Shelf life and forecast bias can invalidate an otherwise acceptable reorder rule.
Plausibility Check
Two hard gates fail, so release should be held or restricted.
Validation Package Checklist
A strong inventory-policy solution should check:
- whether inventory state is usable, quality-cleared and unallocated;
- whether EOQ is reconciled with MOQ, packaging and shelf life;
- whether reorder point includes lead-time demand and approved safety stock;
- whether demand and lead-time variability are both considered when relevant;
- whether service level is appropriate for shortage consequence;
- whether forecast bias is corrected before adding buffer;
- whether ERP triggers match the approved policy;
- whether release gates include shelf life, allocation and evidence closure.
Common Release Mistakes
Common mistakes include using gross stock as usable stock, treating EOQ as a release rule, ignoring MOQ exposure, excluding lead-time variation from safety stock, applying a normal service level to intermittent demand, using forecast MAPE while ignoring bias, accepting high inventory turns while stockouts increase, and releasing a policy that passes service level but fails shelf-life or evidence gates.