Tools: Risk Pooling

Let's review. Throughout this chapter we have emphasized two points about uncertainty:

  1. Uncertainty complicates your decision-making regarding inventory management.

  2. Uncertainty drives costs, especially inventory holding and stockout costs.

Simply put, uncertainty is your enemy. As you strive to reduce costs and boost profitability, one of your goals should be to reduce uncertainty. We call efforts that help you reduce uncertainty "." One risk-pooling practice is warehouse (or DC) consolidation. For example, every retailer interested in growing its eCommerce business is trying to figure out how to use fewer, larger DCs to handle both bricks-and-mortar and Internet distribution channels.

Let's take a closer look to see how warehouse consolidation can reduce your uncertainty—and costs. Imagine your firm has two warehouses located relatively close to one another. Both warehouses carry the same products and serve neighboring market areas. This two-warehouse is illustrated in the left-hand panel in Figure 9-9. Each of the two warehouses faces lead time demand uncertainty ( sLD 1 and sLD 2 , respectively). As a result, you need to hold safety stock in each warehouse. The question is, "Can you reduce your costs and improve your service by centralizing the two warehouses into a single stocking location?" Take a look at the right-hand panel of Figure 9-9. In theory, you can reduce your overall safety stock by consolidating warehouses.

Figure 9-9: Warehouse Centralization

Now, consider the following scenario:

On a scorching hot day in London, your London warehouse (#1) has huge demand for electric fans. Stockouts occur and customer demand is lost. On that same day, most of the rest of England enjoys cool, overcast weather. Demand for electric fans in surrounding markets is low. Your Birmingham warehouse (#2) holds more than enough inventory to cover demand.

What are the costs for each warehouse? Your London warehouse incurs stockout costs. Your Birmingham warehouse incurs holding costs. What happens if you pool demand risk across both markets? In other words, what would happen if you could use the inventory from Birmingham to satisfy demand for fans in London? This would be a win-win situation! The following mathematical model supports your intuition by calculating the degree of risk ( sLD c ) after consolidation:

s L D c = s L D 1 2 + s L D 2 2 + 2 s L D 1 s L D 2 p 12

Where ρ12 is the correlation of demands between locations 1 and 2. 1

Let's look at a numerical example where sLD 1 is 250 and sLD 2 is 350. You also need to know that ρ 12 is 0 and you are targeting a 96% in-stock rate, which corresponds to a z value of about 1.75. With these numbers, you can calculate safety stock requirements for both your current two-warehouse system as well as your proposed consolidated, single-warehouse system (see Table 9-2).

Table 9-2
Numerical Illustration Of Warehouse Centralization
Two-warehouse System Consolidated System
London (#1) Birmingham (#2)
sLD 250 350 430.1
ρ12 0
z 1.75 1.75 1.75
Safety stock ( z* sLD) 437.5 612.5 752.7
Sum of safety stocks 1,050 752.7

First, let's do the math for your current two-warehouse system:

London Warehouse (#1) SS 1 = z × sLD 1 = 1.75 × 250 = 437.5
Birmingham Warehouse (#2) SS 2 = z × sLD 2 = 1.75 × 350 = 612.5
Total Safety Stock 1,050

Now, let's run the numbers for the consolidated, one-warehouse system. However, before we can calculate the safety stock, we need to calculate the combined standard deviation of lead time demand: sLD c

s L D c = s L D 1 2 + s L D 2 2 + 2 s L D 1 s L D 2 p 12 = 250 2 + 350 2 + 2 250 350 0 = 430.1 C o n s o l i d a t e d W a r e h o u s e : S S c = z s L D c = 1.75 430.1 = 752.7

Based on your analysis, consolidation allows you to reduce your total safety from 1,050 to 753 units—that's a 28.3% reduction! Pooling risk by consolidating warehouses enables you to partially offset some of the lead time demand fluctuations. Less uncertainty then means lower safety stocks and lower costs.

Now let's do a thought experiment: What would happen if lead time demands between your London and Birmingham warehouse were perfectly positively correlated ( ρ 12 = 1)? By how much could safety stocks be reduced as a result of centralization? As you redo the calculations, you will notice that the safety stock reduction would be zero. This makes sense since there is no "offsetting effect" if lead time demands are simultaneously high in both markets. Conversely, what would happen if lead time demand were perfectly negatively correlated ( ρ 12 = -1)? This negative correlation would imply that lead time demand for London is high when it is low for Birmingham and vice versa. This will maximize the "offsetting effect" and result in greater safety stock savings (-83.3%). Watch the following video for step-by-step instructions.

Want to try our built-in assessments?


Use the Request Full Access button to gain access to this assessment.