Home / Insights

Warehouse layout series · Part 5 of 5

From Layout to Cash: Inventory Turns and a Layout Payback Calculator

Contents
  1. Three ways a layout turns into cash
  2. Inventory turns and days of stock
  3. Can the dock take more deliveries?
  4. When more deliveries pay
  5. The calculator
  6. The two examples
  7. What the calculator leaves out
  8. The series in one table
  9. Key points
  10. Sources

Parts 1 to 4 measured what a layout does to walking, waiting, dock time, space and line stops. This last part turns those results into cash: how much a better layout frees each year, how much it frees once, how fast it pays back, and what it does to inventory turns.

The honest answer is that most of the cash from a layout comes from people and space, not from inventory. A layout raises inventory turns only when you use what it makes possible: a dock that can take smaller, more frequent deliveries, and a re-layout that clears out dead stock. The calculator below keeps the three apart, so you can see which part of the case is carrying the result.

Three ways a layout turns into cash

Table 1. Where the cash comes from

SourceCash every year or onceWhat the series showed
Running costs: labour, truck detention, overtimeEvery yearPart 1: about $150,000 of picking labour and $45,000 of detention a year (averages of ten simulated days). Part 4: $178,000 of overtime a year.
Space: rent avoided or a move put offEvery yearPart 3: narrower aisles fit up to 1,440 more pallet positions instead of leasing more space.
Inventory: less stock for the same salesOnce, plus a smaller carrying cost every yearOnly if deliveries become smaller and more frequent, or dead stock is cleared. This part.

Inventory turns and days of stock

Inventory turns compare what you sell, at cost, with what you hold:

\[\text{Turns} = \frac{\text{Cost of goods sold}}{\text{Average inventory}}\]

\[\text{Days of stock} = \frac{365}{\text{Turns}}\]

The illustrative distributor sells $18M a year at cost and holds $3.0M of stock on average: 6 turns, or 61 days of stock. Carrying costs are usually quoted at 20% to 30% of inventory value a year: capital, space, insurance, handling, shrinkage and obsolescence. But when stock falls, only part of that becomes cash. The capital, insurance and shrinkage go; the space and handling go only if rent or labour actually fall. The calculator therefore starts at 10% for the cash part, and you can raise it if the space would really be released.

A layout changes neither number on its own. Picking faster does not shrink the stock, and putting pallets away an hour sooner frees a few thousand dollars at most. What does shrink it:

  • Smaller, more frequent deliveries. Between deliveries, stock falls from a full order to nothing, so on average you hold half an order: the cycle stock. Receive twice as often in half the quantity, and that cycle stock halves. But every extra delivery needs dock time, and a congested dock is the usual reason a business buys in big lots.
  • Dead stock cleared. A re-layout means touching every pallet, which is the moment to find and sell, return or scrap the stock that has not moved for a year.

Can the dock take more deliveries?

To test the first lever, the Part 1 distributor received the same pallets in more, smaller deliveries: from 14 trucks a day up to 28, averaged over five simulated days.

0204060801001418212428Inbound deliveries a day (the same pallets, in smaller loads)Minutes a truck is on siteAs-is layoutRedesigned layout
Figure 1. Minutes a truck spends on site as the same pallets arrive in more, smaller deliveries. The redesigned dock absorbs the extra trucks; the as-is dock does not.
  • The as-is layout already cannot keep up. With equal loads, trucks spend 86 minutes on site at 14 deliveries and still 74 at 28; detention stays between $43,000 and $69,000 a year, and about 22 pallets are still not put away at the end of the shift at every number of deliveries. (With Part 1's own mix of full and part loads, the as-is trucks spend 75 minutes on site, averaged over ten days; 86 on Part 1's example day.)
  • The redesigned layout can. Trucks spend 32 minutes on site at 14 deliveries and 16 at 28, with no detention and every pallet put away.
  • The bottleneck is the forklift behind the dock, not the doors. Give the as-is layout a second forklift and its trucks spend 32 and 16 minutes on site, the same as the redesign. A second forklift is another way to free the dock, though it does nothing for the pickers' walking, and a driver for a full shift (about $80,000 a year at $40 an hour, before the truck itself) costs more than the $45,000 a year of detention it would save.

So the redesign (or a second forklift) does not raise turns by itself, but it removes the dock as the reason to keep buying in big lots. Whether to receive more often is then a buying decision: it depends on what each extra delivery costs.

When more deliveries pay

The cycle stock freed, and the break-even freight per extra delivery, are

\[\text{Freed} = I \times s \times \left(1 - \frac{1}{f}\right)\]

\[\text{Break-even} = \frac{\text{Freed} \times c}{n}\]

where \(I\) is average inventory, \(s\) the share of it that is cycle stock of the suppliers that change, \(f\) how many times as often they deliver, \(c\) the carrying cost rate and \(n\) the extra deliveries a year. For the distributor, the suppliers behind 7 of its 14 daily trucks, holding 20% of the inventory as cycle stock, deliver twice as often: 35 extra deliveries a week. That frees $300,000 once, over the next few delivery cycles, and saves $30,000 a year in carrying cost at 10%. So the extra deliveries pay for themselves only if each costs less than $16 in extra freight ($41 if the full 25% carrying cost would really be saved). At the $40 a delivery in the example, they cost $43,000 a year more than they save. They are still worth considering when cash is tight, because they bring in $300,000 up front; with a supplier's own trucks on fixed routes, the extra cost can be close to nothing.

The calculator

Start from either example, then put in your own numbers. All amounts are in Canadian dollars.

Try it: layout to cash

Start from:

1. What the layout saves every year
2. Smaller, more frequent deliveries
3. Dead stock and carrying cost
Cash every yearsavings, less extra freight
Cash oncestock freed and dead stock sold, less the cost of the change
Payback, layout onlyfrom section 1 alone
Payback, all moves
Cash over 3 yearsundiscounted
Inventory turns
Cycle stock freed

The two examples

Table 2. The two examples in the calculator, at the low and high end of the one-off cost

MeasureDistributor (Parts 1 to 3)Ridgeline Coatings (Part 4)
Yearly savings from the layout$196,000$178,000
One-off cost of the change$75,000 to $249,000$13,000 to $20,000
Payback, layout only4.6 to 15.3 months0.9 to 1.3 months
Cycle stock freed by more frequent deliveries$300,000None
Extra freight a year$73,000None
Dead stock sold (written off)$36,000 ($84,000)None
Extra stock at the linesNone$7,000
Cash every year, all moves$159,000$177,000
Payback, all movescovered by the stock freed1.4 to 1.8 months
Inventory turns6.0 → 7.04.00 → 3.95
Days of stock61 → 5291 → 92
Every yearPicking labour saved$150,000Truck detention saved$45,000Carrying cost on stock freed$30,000Holding cost on dead stock cleared$6,000Extra freight for more deliveries−$73,000OnceCycle stock freed (once)$300,000Dead stock sold (once)$36,000
Figure 2. Where the distributor's cash comes from. The yearly cash is mostly labour and detention; inventory adds a one-off sum and a small yearly saving, less the extra freight.
  • The distributor's layout pays back on running costs alone, in 4.6 to 15.3 months, from $150,000 of picking labour and $45,000 of detention a year (averages of Part 1's ten simulated days). The one-off cost is moving about 3,360 pallet positions of racking at the Part 3 rates, plus engineering, permits and labels.
  • The inventory moves bring cash forward but cost a little every year. More frequent deliveries free $300,000 and clearing dead stock brings in $36,000, enough to cover the one-off cost once deliveries change. But the extra freight outweighs the carrying cost saved, so the yearly cash falls from $196,000 to $159,000. Turns rise from 6.0 to 7.0 and days of stock fall from 61 to 52; without the dead stock, turns would reach 6.67. Clearing dead stock does not need a new layout, and it means an $84,000 write-off: that cash was lost when the stock was bought, not when it is cleared.
  • Ridgeline pays back in about 0.9 to 1.3 months on overtime alone (1.4 to 1.8 months after the extra stock at the lines), and its turns fall slightly, from 4.00 to 3.95: the second bin at each line adds $7,000 of stock. Not every good layout change raises turns; some trade a little stock for a lot of uptime.

What the calculator leaves out

  • Labour savings are cash only when hours are cut or the freed time replaces overtime, temporary staff or hiring. Time freed and kept on the payroll is capacity, not cash.
  • Disruption. A re-layout stops or slows the warehouse for days. Put the lost output or overtime into the one-off cost.
  • Safety stock. More frequent deliveries can also reduce safety stock (see setting safety stock), but only if the supplier's lead time and reliability improve too; the calculator counts cycle stock only.
  • Tax, financing and the time value of money. The 3-year cash is undiscounted. For longer projects, use a discounted payback, as in the OEE project payback post.
  • Which stock to change. Start with the A items of an ABC analysis: they carry most of the value, so more frequent deliveries free the most cash for the fewest extra trucks.

The series in one table

Table 3. What each part found

PartQuestionFinding in the example
1What does a bad layout cost?Walking per order fell from 233 to 70 m; picker-hours from 32.9 to 17.7 a day.
2U-shape, straight-through or L-shape?Laid out well, all three pick at about the same cost; where receiving sits next to the fast movers matters more.
3Wide, narrow or very narrow aisles?Narrower aisles fit 720 to 1,440 more positions and pay back against leasing, but only if the positions are needed.
4How should materials reach a line?Calling before a material runs out, with a second load at the line, removed the waiting; the supermarket and milk run cut the handling.
5What is it worth in cash?Mostly labour and space; inventory turns rise only when the dock is used to buy smaller and dead stock is cleared.

Key points

  • A layout frees cash mainly through labour, truck detention, overtime and space. In the distributor example it paid back in 4.6 to 15.3 months on running costs alone.
  • Inventory turns rise only when the business uses the layout: smaller, more frequent deliveries that the redesigned dock can now take, and dead stock cleared during the move.
  • More frequent deliveries free cash once, but pay every year only when each extra delivery costs less than the carrying cost it saves: here, about $16 a delivery.
  • Count labour as cash only when hours are actually cut or replace paid work.

The whole series: Part 1, what a bad layout costs; Part 2, flow patterns; Part 3, aisle widths; Part 4, feeding the production line. The Layout Lab runs all of them.

Sources

The distributor and Ridgeline Coatings are illustrative examples: their inventory, cost of goods sold, delivery costs, dead stock and project costs are stated assumptions, and the operating savings come from the simplified Layout Lab model. Put your own numbers in the calculator before you make a decision. This is not financial advice.

Keep reading

Related articles

All 186 articles

Ready to find your next improvement?

Book a strategy call. We will talk through your goals, pain points and where AI, systems or process work can make the biggest difference.