Contents
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
| Source | Cash every year or once | What the series showed |
|---|---|---|
| Running costs: labour, truck detention, overtime | Every year | Part 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 off | Every year | Part 3: narrower aisles fit up to 1,440 more pallet positions instead of leasing more space. |
| Inventory: less stock for the same sales | Once, plus a smaller carrying cost every year | Only 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.
- 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
The two examples
Table 2. The two examples in the calculator, at the low and high end of the one-off cost
| Measure | Distributor (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 only | 4.6 to 15.3 months | 0.9 to 1.3 months |
| Cycle stock freed by more frequent deliveries | $300,000 | None |
| Extra freight a year | $73,000 | None |
| Dead stock sold (written off) | $36,000 ($84,000) | None |
| Extra stock at the lines | None | $7,000 |
| Cash every year, all moves | $159,000 | $177,000 |
| Payback, all moves | covered by the stock freed | 1.4 to 1.8 months |
| Inventory turns | 6.0 → 7.0 | 4.00 → 3.95 |
| Days of stock | 61 → 52 | 91 → 92 |
- 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
| Part | Question | Finding in the example |
|---|---|---|
| 1 | What does a bad layout cost? | Walking per order fell from 233 to 70 m; picker-hours from 32.9 to 17.7 a day. |
| 2 | U-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. |
| 3 | Wide, 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. |
| 4 | How 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. |
| 5 | What 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
- BDC: Inventory turnover ratio (turns as cost of goods sold over average inventory, and days of stock)
- NetSuite: Inventory carrying costs (carrying costs often 20% to 30% of inventory value)
- Cleverence: What is cycle stock? (average cycle stock is half the order quantity)
- Tony Wild: Delivery quantities (more frequent deliveries can raise transport costs)
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.
