Inventory is money sitting around in a different form. Rhonda Abrams
Tip
Warehouse management can inform inventory management decisions by identifying fast-, medium-, slow-, non-moving, and obsolete stock (Richards 2014; “Warehouse Vs. Inventory” 2025).
How to keep the right amount of inventory on hand?
Major inventory management approaches:
Independent
Dependent
Pull approach
Push approach
EOQ-based systems in evidence today are hybrid approaches that include elements of both pull- and push-based strategies.
Single-facility approach. Release orders from a single facility (e.g., DC) to a specific supplier for inventory replenishment. Example:
Decisions to set an inventory policy:
| Symbol | Description |
|---|---|
| \(R\) | Annual rate of demand (units) |
| \(Q\) | Quantity ordered (units) |
| \(\frac{1}{2}Q\) | Avg. number of units during order cycle |
| \(A\) | Cost of placing an order |
| \(V\) | Cost of one unit of inventory |
| \(W\) | Carrying cost/unit of inventory/year (%) |
| \(S\) | = \(VW\). Inventory carrying cost per unit per year |
| \(t\) | Order cycle time (days) |
| \(TAC\) | Total annual cost |
The total annual cost (TAC) is:
\[ TAC = \overbrace{\frac{1}{2}QVW}^{\substack{\text{Carrying}\\\text{costs}}} + \overbrace{A\frac{R}{Q}}^{\substack{\text{Ordering}\\\text{costs}}} \]
Where:
| Symbol | Description |
|---|---|
| \(R\) | Annual rate of demand (units) |
| \(Q\) | Quantity ordered (units) |
| \(\frac{1}{2}Q\) | Avg. number of units during order cycle |
| \(A\) | Cost of placing an order |
| \(V\) | Cost of one unit of inventory |
| \(W\) | Carrying cost/unit of inventory/year (%) |
| \(S\) | = \(VW\). Inventory carrying cost per unit per year |
| \(t\) | Order cycle time (days) |
| \(TAC\) | Total annual cost |
The total annual cost balances inventory carrying and ordering costs:
\[ TAC = \overbrace{\frac{1}{2}QVW}^{\substack{\text{Carrying}\\\text{costs}}} + \overbrace{A\frac{R}{Q}}^{\substack{\text{Ordering}\\\text{costs}}} \]
To find the optimal \(Q\):
Under the assumptions of certainty, an organization needs only enough inventory to last during the replenishment time or lead time.
Replenishment time consists of:
Given a lead time, we have:
\[ \text{Reorder point} = \text{Lead time} \times \text{daily demand} \]
Example:
Most organizations do not operate under conditions of certainty:
Figure 6: Inventory designed for a 95% service level (King 2011)
EOQ model with certainty
The reorder point is the on-hand inventory level needed to satisfy demand during lead time.
EOQ model under uncertainty
The reorder point is the average daily demand during lead time plus the safety stock.
How much product customers will demand during a constant/known lead time when usage rate is varying?
The reorder level must balance:
If the reorder level is:
Different reorder points are considered for possible demands within the lead time:
Input: Expected demand prob. distribution
| Demand (units) |
Prob. |
|---|---|
| 100 | 0.01 |
| 110 | 0.06 |
| 120 | 0.24 |
| 130 | 0.38 |
| 140 | 0.24 |
| 150 | 0.06 |
| 160 | 0.01 |
Possible units of inventory in shortage or excess:
| Actual demand |
100 | 110 | 120 | 130 | 140 | 150 | 160 |
|---|---|---|---|---|---|---|---|
| 100 | 0 | 10 | 20 | 30 | 40 | 50 | 60 |
| 110 | -10 | 0 | 10 | 20 | 30 | 40 | 50 |
| 120 | -20 | -10 | 0 | 10 | 20 | 30 | 40 |
| 130 | -30 | -20 | -10 | 0 | 10 | 20 | 30 |
| 140 | -40 | -30 | -20 | -10 | 0 | 10 | 20 |
| 150 | -50 | -40 | -30 | -20 | -10 | 0 | 10 |
| 160 | -60 | -50 | -40 | -30 | -20 | -10 | 0 |
Expected number of units in short or in excess:
| Actual demand | Prob. | 100 | 110 | 120 | 130 | 140 | 150 | 160 |
|---|---|---|---|---|---|---|---|---|
| 100 | 0.01 | 0.0 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 |
| 110 | 0.06 | -0.6 | 0.0 | 0.6 | 1.2 | 1.8 | 2.4 | 3 |
| 120 | 0.24 | -4.8 | -2.4 | 0.0 | 2.4 | 4.8 | 7.2 | 9.6 |
| 130 | 0.38 | -11.4 | -7.6 | -3.8 | 0.0 | 3.8 | 7.6 | 11.4 |
| 140 | 0.24 | -9.6 | -7.2 | -4.8 | -2.4 | 0.0 | 2.4 | 4.8 |
| 150 | 0.06 | -3.0 | -2.4 | -1.8 | -1.2 | -0.6 | 0.0 | 0.6 |
| 160 | 0.01 | -0.6 | -0.5 | -0.4 | -0.3 | -0.2 | -0.1 | 0.0 |
Input: EOQ variables
The lowest-cost reorder point minimizes annual stockout and carrying costs:
| Calculation of lowest cost reorder point | 100 | 110 | 120 | 130 | 140 | 150 | 160 |
|---|---|---|---|---|---|---|---|
| 1. Expected excess/cycle (\(e\)) | 0 | 0.1 | 0.8 | 3.9 | 10.8 | 20.1 | 30 |
| 2. Expected carrying cost/year (\(eVW\)) | $0 | $2.50 | $20.00 | $97.50 | $270 | $502.50 | $750 |
| 3. Expected shorts/cycle (\(g\)) | 30 | 20.1 | 10.8 | 3.9 | 0.8 | 0.1 | 0 |
| 4. Expected stockout cost/cycle (\(gk\)) = \(G\) | $300 | $201 | $108 | $39 | $8 | $1 | $0 |
| 5. Expected stockout cost/year (\(G\frac{R}{Q}\)) | $4,500 | $3,015 | $1,620 | $585 | $120 | $15 | $0 |
| 6. Expected total cost/year (2. + 5.) | $4,500 | $3,017.50 | $1,640 | $682.50 | $390 | $517.50 | $750 |
| Symbol | Description |
|---|---|
| \(R\) | Annual rate of demand (units) |
| \(Q\) | Quantity ordered (units) |
| \(\frac{1}{2}Q\) | Avg. number of units during order cycle |
| \(A\) | Cost of placing an order |
| \(V\) | Cost of one unit of inventory |
| \(W\) | Carrying cost/unit of inventory/year (%) |
| \(e\) | Expected excess in units |
| \(g\) | Expected shorts in units |
| \(k\) | Stockout cost in dollars per unit stocked out |
| \(G=gk\) | Expected stockout cost per cycle |
| \(G\frac{R}{Q}\) | Expected stockout cost per year |
| \(eVW\) | Expected carrying cost per year for excess inventory |
To find the optimal \(Q\):
Calculate the total annual cost: \[ \begin{align} TAC = \overbrace{\frac{1}{2}QVW}^{\substack{\text{Carrying}\\\text{costs}}} + \overbrace{A\frac{R}{Q}}^{\substack{\text{Ordering}\\\text{costs}}} + \overbrace{(eVW)}^{\substack{\text{Safety}\\\text{cost}}} + \overbrace{\left(G\frac{R}{Q}\right)}^{\substack{\text{Stockout}\\\text{cost}}} \end{align} \]
Differentiate the \(TAC\) function: \[ \begin{align} \frac{\partial(TAC)}{\partial Q} = \frac{1}{2}VW - \frac{R(A+G)}{Q^2} \end{align} \]
Set \(\frac{\partial(TAC)}{\partial Q}=0\) and solve for \(Q\): \[ \begin{align} Q & = \sqrt{\frac{2R(A+G)}{VW}} \end{align} \]
| Symbol | Description | Value |
|---|---|---|
| \(R\) | Annual rate of demand (units) | 3,600 |
| \(A\) | Cost of placing an order | $200 |
| \(V\) | Cost of one unit of inventory | $100 |
| \(W\) | Carrying cost/unit of inventory/year (%) | 25% |
| \(e\) | Expected excess in units | 10.8 |
| \(g\) | Expected shorts in units | 0.8 |
| \(k\) | Stockout cost in dollars per unit stocked out | $10 |
| \(G=gk\) | Expected stockout cost per cycle | $8 |
New value of \(Q\) considering reorder point = 140:
\[ \begin{align} Q & = \sqrt{\frac{2R(A+G)}{VW}}\\ & = \sqrt{\frac{2\times3,600\times(200+8)}{\$100\times 25\%}}\\ & = 245\; \text{units (approximately)} \end{align} \]
The annual total combines carrying, ordering, safety-stock, and stockout costs:
\[ \begin{align} TAC =\;& \frac{1}{2}QVW + A\frac{R}{Q} + eVW + G\frac{R}{Q} \\ =\;& \left(\frac{1}{2} \times 245 \times \$100 \times 25\% \right) + \left(200\times\frac{3,600}{245}\right)\\ & + \left(10.8\times\$100\times25\%\right) + \left(8\times\frac{3,600}{245}\right)\\ =&\; \$3,062.50 + \$2,938.78 + \$270 + \$117.55\\ =&\; \$6,389\\ \end{align} \]
Example:
| Symbol | Description | Value |
|---|---|---|
| \(R\) | Average replenishment cycle (days) | 8 |
| \(\sigma_{R}\) | Standard deviation of replenishment cycle (days) | 2 |
| \(S\) | Average daily demand (units) | 20 |
| \(\sigma_{S}\) | Standard deviation of daily demand (units) | 4 |
| \(\bar{X}\) | = \(SR\). Average demand during lead time (units) | 160 |
| \(\sigma\) | = \(\sqrt{R(\sigma_{S})^2 + (S\sigma_{R})^2}\)1 Standard deviation of demand during lead time (units) | ~42 |
| Reorder point | Probability of no stockout occurring | Probability of a stockout situation |
|---|---|---|
| \(\bar{X} + 1\sigma = 202\) | 84.13% | 15.87% |
| \(\bar{X} + 2\sigma = 244\) | 97.72% | 2.28% |
| \(\bar{X} + 3\sigma = 286\) | 99.87% | 0.13% |
Under uncertainty, increasing the reorder point has the same effect as increasing the safety stock commitment.
Figure 7: An organization selling 2,500 units before its next order will have to reorder 2,500 units plus the units it anticipates selling during the lead time. The amount ordered differs from one five-week period to the next (Coyle et al. 2020)
How to optimize the inventory policies of thousands of SKUs?
Automatically, with warehouse management systems (WMSs).
Warehousing - M-IEM - Breno A. Beirigo