Warehouse Expansion Decision
Compare the annualized cost of expanding your warehouse against the cost of overflow storage as demand grows, and see when your current capacity runs out.
Capacity is projected to be exceeded in 1 year(s) at this growth rate.
Sensitivity to growth rate
| Scenario | EAC hold | EAC expand | Annual savings | Strategy |
|---|---|---|---|---|
| Growth -20% | $815,383.91 | $372,199.22 | $443,184.69 | Expand |
| Growth -10% | $977,732.21 | $504,897.14 | $472,835.07 | Expand |
| Base case | $1,153,368.74 | $660,734.35 | $492,634.39 | Expand |
| Growth +10% | $1,342,369.82 | $829,053.95 | $513,315.86 | Expand |
| Growth +20% | $1,545,226.96 | $1,016,986.41 | $528,240.55 | Expand |
Continue Analysis
Based on your results, these related decisions are available.
Resources
How this works
As demand grows, a fixed warehouse eventually runs out of capacity. This engine projects demand forward at a constant compounding growth rate and compares two paths: holding capacity fixed and paying for overflow (off-site storage, 3PL overflow, expediting) as the gap grows, or expanding capacity now. Expansion capital is annualized with the capital recovery factor, the same method used in Repair vs Replace Equipment, so both paths are compared on an equal annual footing over the expansion option's useful life.
The engine also reports when the capacity gap is projected to begin, independent of which option is cheaper, since the timing itself often drives lead-time decisions.
Assumptions
- Demand grows at a constant compounding annual rate
- Overflow cost per unit is constant regardless of overflow volume
- The hold option keeps capacity fixed for the entire analysis horizon
- Expansion capacity is available starting in year one
Limitations
- Single-cycle comparison; does not model a second expansion later if growth eventually outpaces the expanded capacity too
- Does not model financing, taxes, or depreciation
- Does not model lead time to build or service-level risk during a capacity gap, only cost
Sources
The equivalent annual cost method follows Blank and Tarquin, Engineering Economy (8th edition), and NIST Handbook 135. Warehouse capacity planning concepts follow Tompkins, White, Bozer, and Tanchoco, Facilities Planning (4th edition).
Worked example
A facility has 100,000 units of capacity, is already running at 90,000 units a year, and demand is growing 12% a year. Left unexpanded, demand outgrows capacity within a year and keeps compounding, generating well over a million dollars a year in overflow handling cost by the end of a 10-year horizon. A 50,000-unit expansion costing $800,000 and lasting 10 years annualizes to about $80,000 a year in capital cost, plus a much smaller residual overflow cost since the larger facility does not run out of room until several years later. The expansion option comes out hundreds of thousands of dollars a year cheaper than holding once the overflow cost of continued growth is priced in.
Common use cases
- Deciding between owned expansion and ongoing 3PL overflow storage
- Racking or mezzanine additions inside an existing footprint
- New distribution center timing decisions
- Capital budget justification for a warehouse project