The square root law says that when you spread the same sales over more stocking locations, the total safety stock you need grows with the square root of the number of locations. Go from one warehouse to two and safety stock goes up by about 41%, not 100% and not zero. Go from one to four and it doubles. Run it backward and it's the case for consolidating: three warehouses into one cuts safety stock by about 42%.
Safety stock after = safety stock now × √(locations after ÷ locations now)
It's a rule of thumb with conditions attached, and it's about safety stock only. Below is the formula, where the square root comes from, a made-up hot sauce maker's numbers, when the law misleads, and a calculator.
The short version
- Safety stock after = safety stock now × √(locations after ÷ locations now).
- One location to two: × 1.41. One to four: × 2. Three to one: × 0.58.
- It applies to safety stock, not to the stock that turns between deliveries.
- It assumes each location's demand doesn't move with the others'.
- When demand rises and falls everywhere at once, it overstates the change.
- Use it to price a decision before making it, then check with real numbers.
- TaroStack keeps stock by site, with levels for each item at each site. More below.
The numbers
| Change | Safety stock now | Locations now | Locations after | Safety stock after | Change | Change | At $3.20 a bottle |
|---|---|---|---|---|---|---|---|
| Add a second warehouse | 400 | 1 | 2 | 566 | 166 | 41% | $530.19 |
| Go from one to four | 400 | 1 | 4 | 800 | 400 | 100% | $1,280.00 |
| Go from two to three | 566 | 2 | 3 | 693 | 127 | 22% | $407.06 |
| Close two of three | 693 | 3 | 1 | 400 | −293 | −42% | −$937.27 |
This maker holds 400 bottles of safety stock in its one warehouse. A second warehouse makes that 566 between the two, 283 in each: 166 more bottles, $530.19 at cost, sitting on shelves to cover the same sales. That's for one product. Across a range, multiply.
Where the square root comes from
Safety stock covers the swings in demand while you wait for a delivery. One common formula is:
Safety stock = Z × standard deviation of daily demand × √(lead time in days)
It's worked through in safety stock formula. The part that matters here is the standard deviation, the measure of how much demand swings from day to day.
Say the one warehouse sees demand that swings by 100 bottles a day. Split its customers evenly between two warehouses. Each now sees half the sales, but not half the swing. If the two halves rise and fall independently, each one swings by 100 ÷ √2, about 71 bottles. Each warehouse needs safety stock for its own 71, so together they hold cover for 141. That's √2 times the 100 the single warehouse covered.
The reason is the same one that makes a single warehouse efficient. A busy day for the east is often an ordinary day for the west, and in one building the two cancel. In two buildings, each has to be ready for its own busy day.
With n locations each swing is 100 ÷ √n, there are n of them, and the total is 100 × √n. That's the law.
Where it misleads
It's about safety stock only. The stock that turns over between deliveries depends on how much you sell and how often you're resupplied, not on this law. A second warehouse may also mean two smaller deliveries in place of one large one, which is a separate sum.
It assumes independence. If demand jumps everywhere at once, in a holiday week or after a mention on television, the two halves don't cancel in one building either, and splitting them costs less than the law says. The more your regions move together, the smaller the real change.
It assumes an even split. A second warehouse that takes a fifth of the sales adds less safety stock than one that takes half.
It assumes the same lead time and the same standard. If the new warehouse is resupplied faster, or you accept running short there a little more often, the sum changes.
It prices one side of a decision. A second warehouse is opened to reach customers faster or ship to them for less. The law tells you what that costs in stock: here, $530.19 a product. Whether that's worth it is the other side: see warehouse storage cost calculator and, for a warehouse run by someone else, food fulfillment center.
Using it
- Take the safety stock you hold now for a product. If you don't know it, it's your reorder point less what you sell during the lead time: see reorder point example.
- Multiply by √(locations after ÷ locations now).
- Multiply the change by the unit cost, and add up across products.
- After the change, set each location's level from its own sales, and compare the total with what the law said.
Keeping a balance for each place, and moving stock between them, is in multi-location inventory.
Get the calculator
Download the square root law calculator. One sheet and a read-me: type the safety stock now, the locations now and after and a unit cost, and it works out the safety stock after, the change in units and percent, and the change in stock value. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The law gives one number before the move. After it, the question is what each warehouse actually holds and whether that's right, product by product. A spreadsheet with one row a product can't show that the east has 300 bottles of the mild and the west has 40, or that the west ran out twice last month while the total looked fine.
How TaroStack does it
TaroStack keeps stock by site, so each warehouse's own numbers are there to check the law against.
Sites and transfers, on Business. Each warehouse is a site. A transfer moves named lots from one to another.
Stock by lot, by site, with dates, and stock value by site and month.
Reorder points suggested from how stock actually moves, and a reorder list in days of cover with each supplier's lead time.
Planning, on Growth: safety stock and min/max for each item at each site, and what to move between sites, in plain words.
Counting works on a phone, one site at a time. A count shows what each difference is worth.
What ships is recorded by lot, from the site it left.
| The question | Spreadsheet | In TaroStack |
|---|---|---|
| What each warehouse holds | One total | Stock by site |
| What the second warehouse added, in dollars | The law's estimate | Stock value by site and month |
| Where a product ran short | Not visible in the total | Each site's stock |
| Moving stock between them | Two edits | A transfer |
TaroStack doesn't apply the square root law for you: it shows what each site holds and uses, which is what the law is checked against. Sites and transfers are on Business at $89 a month. Stock, lots and reordering are on every plan, from $9.99 a month. The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
