Supply Chain

profileelee131
BU_610_760_SUPPLYCHAINANALYTICS_G_AYDIN_MODULE4_VIDEO3.pdf

JHU Carey Business School | BU_610.760_SUPPLY CHAIN ANALYTICS_G.AYDIN_MODULE 4_VIDEO 3

INSTRUCTOR: Let's now put these ideas together around inventory pooling. I'm switching to inventory pooling at this point because this is going to be one of the central ideas about distribution networks, the idea of inventory pooling. What do we mean by inventory pooling?

Going with my smaller example, and we're going to generalize from here eventually, but going with my smaller

example, if ABC decides to pool all of its inventory in one location, I'm missing the word one there on that slide, so in one location. They are essentially saying I'll take the East and West warehouses, I'll combine them in one

location. Let's call it the central warehouse. That's-- at this very basic level, is inventory pooling. I'll take two

locations at which are used to keep inventory, I'll put them in one and the same location.

So, when we do this, we can assume that the week demand at the central warehouse will be the sum of the

weekly demands at the East and West warehouses. Whatever demand was coming to the East and the West will now be channeled to the central warehouse. And let's also assume that the lead time from the plants to the

central warehouse will still be three weeks. Remember, when we had two separate warehouses, it was taking

three weeks for the plant to send the shipment to the East or to the West. Let's say to the central warehouse also, it takes three weeks to send the shipment from the plant.

Let's also assume that ABC decided to maintain the same total safety stock as before because in the last part of the example, we calculated if I want 95% cycle service level, here is the safety stock I need in the East. Here is

the safety stock I needed in the West, right? So now I'm saying when they replace the East and the West with

one warehouse called the central warehouse, they decided to keep the same safety stock. So they will add the

two safety stocks together, 65 from the East, 98 from the West, a total of 164 units of safety stock in this new

central warehouse.

The question I'm asking at the end is, what is the cycle service level ABC will achieve at this central warehouse, and how does it compare to the 95% cycle service level ABC was achieving before pooling when it had the East and the West separately? So let's answer this question. What is the cycle service level ABC will achieve at the

central warehouse? To be able to answer it, I'm going to have to remind you again a couple of things from your

statistics classes, probability classes, and so on.

But the key thing we need to figure out before we can answer that question is, what is the weekly demand at the

central warehouse? What do we know about that? Well, what we know about the weekly demand at the central warehouse, let me back up by one slide. It's the sum of the demands in the East and the West. I know the

demand in the East, it's some normal distribution. I know the demand in the West. It's some normal distribution. The demand in the central warehouse is the sum of the two. So it's adding two normal distributions together.

How do we get that resulting demand distribution for the central? So, recall from your statistics courses that if I have x and y and both of them are normally distributed variables and let's say they are statistically independent, meaning there is no correlation between them. Let's say the mean of x is given by mu sub x as notation, and

sigma sub x is the standard deviation of x. So the variance of x would be sigma x squared. Let's say the mean

and standard deviation of y are mu sub y and sigma y. So the variance of y is sigma y squared.

Then here's what I know about when I add x and y together. Here's what I know about x plus y. x plus y would

also be normally distributed. It's mean would be the mean of x plus the mean of y. Makes sense, right? Take the

mean of x, take the mean of y, add the two together, you get the mean of x plus y. And its variance would be the

variance of x plus the variance of y. Again, hopefully that makes sense. Take the variance of x, take the variance

of y, add the two together, you get the variance of x plus y.

By the way, if this is the variance of x plus y, then you know that standard deviation is a square root of variance. So the standard deviation of x plus y would be the square root of that. So we can now apply this to ABC. The

weekly demand at the central warehouse, it's the sum of the East and West demands, right? East demand is

normal, West demand is normal. Therefore, the weekly demand at the central warehouse also has a normal distribution. Its mean would be the mean of East plus the mean of West. Mean of East is 100, mean of West is

100, that's 200. So I know the mean of weekly demand in central warehouse.

Its variance is, OK, that's the variance of East plus the variance of West. What is the variance of East? Well, back

up a couple of slides here. We know the standard deviation in the East. The standard deviation in the East is 20. Therefore, its variance is 20 squared. So the variance of East is 20 squared. Plus, the variance of y. What is the

variance of y? Its standard deviation is 30, if you remember from the example, the variance of the West warehouse. Multiply-- take the square of that. So the variance of the central warehouse demand is going to be if you do the algebra there, that algebra comes out to 1,300. And therefore, the standard deviation at the central warehouse is the square root of 1,300, which gives me 36.1.

So there is my answer to the question about what is the weekly demand at the central warehouse? It's normally

distributed. It's mean is 200, its standard deviation is 36.1. And now that I have that, I can go back and calculate

the cycle service level we are achieving at the central warehouse, and this gives me one more opportunity to

repeat once more the mechanics of going from an order-up-to level to going from an order-up-to level or safety

stock to a cycle service level. So at the central warehouse, here's what I know is my input data. I calculate the

safety stock that I must have at the central warehouse, right? It was the safety stock of the East plus the safety

stock of the West. So we calculated that earlier to be 164 units.

We know that the lead time there is three weeks, and we know that we just calculated the standard deviation of weekly demand at the central warehouse is 36.1 units. So what is sigma sub L? Again, remember what sigma

sub L means. If sigma is standard deviation of per-period demand, the standard deviation of weekly demand, let's say, sigma sub L is standard deviation of total demand during L plus 1 periods. And that is square root of L

plus 1 times the sigma itself.

L is 3 plus 1 times sigma, we calculated earlier 36.1. If you do the algebra there, that comes out to be 72.2. Now I can calculate z, what we're calling the safety factor. The formula for safety factor is here. Take the safety stock

divided by sigma sub L. Safety stock is here, 164.5 divided by sigma sub L is here, 72.2. That comes out to be

2.27. And finally, the cycle service level, I can calculate that by plugging into this Excel function NORMSDIST, short for normal standard distribution. Plug the z value in there. It will give you 98.8%.

Now notice the result. At the central warehouse, the cycle service there will be 98.8%. When we were keeping

the inventory separately in the East and the West, the cycle service level in each was 95%. So by putting the two

together, we improved our cycle service level even though we did not increase our overall safety stock. We just combined it in one place and the formulas tell us that the cycle service level will improve. Why is this happening?

Well, because in general, inventory pooling, we expect will improve customer service level by combining safety

stocks in one location. The intuition behind this is similar to diversifying your portfolio of investments. You don't put all your money in GameStop, because if GameStop goes down, then you lose all your money. You don't put all of your money in crypto, because if crypto goes down, then you lose all your money. Instead, you diversify

your portfolio of investments so you're not too vulnerable to changes in one stock only.

The idea is similar here. When we pool our inventory to meet the demands from multiple sources-- in this case, East and the West-- there will be times when the East demand is high and the West demand is low, and there will be times when the West demand is high and East demand is low. Now you add the two together, those are-- the

sum is sort of curves, the peaks and valleys that you see in each. It leads to a more stable demand pattern

overall, and when you have a more stable pattern overall, it becomes easier to offer better service to your

customers.

So that's the intuition behind why the cycle service level went from 95% when we had two separate locations, to

98% when we combine those two in the same location. But, of course, inventory pooling can have lots of disadvantages that our small example did not really account for. So, for example, you might have some

customers in the far side of the East and the far side of the West, and they might say, you know what? You took

away my warehouse and you put it in the center. It's too far away from me now, so I'll stop buying from you. So

that would be one possible disadvantage of consolidating two warehouses from-- in the center.

It's also true that you're now going to be transporting over larger distances by shipping to customers. When you

had East and the West, East was serving only East customers, West was serving only West customers. Now

central will have to serve customers both in the East and the West. So your customers, your shipments from your

warehouse to your customers, will travel longer distances which might mean that your transportation costs will go up. So those are some possible disadvantages of inventory pooling. And we'll see some of those in our next two cases.

But at this point, the fundamental trade-off in designing distribution networks, generally, we expect that when we

pool the inventory at different locations, it helps us serve our customers better with even less safety stock. So

that's a good thing. Let's say stocks, better service, win-win, by pooling inventory in fewer locations. But also, it puts us further away from our customers if we have fewer locations. And that could have disadvantages. So how

do we manage this trade-off? This is some of what we will see as we move on to cases to look at more elaborate

examples of this inventory pooling idea and distribution networks.