Careers
How to calculate the ROI of a warehouse, or the return on investment, is another crucial element that needs to be considered when choosing the best storage solution for a company.
Analyzing the cost of an installation and the return on investment is an exercise that can, and must, be included in any project. In most cases it is very simple and warehouse operators or owners can do it themselves. In other cases, the storage solution supplier will need to help its customers with this calculation.
The calculation of ROI consists of deducing the approximate time it will take to get back your initial investment. This calculation must always be performed by comparing at least two scenarios: the current situation compared with the new project (for companies with a warehouse they want to replace) or a comparison of two different solutions (for companies starting from scratch).
When completing the detailed calculation it is essential to consider all investment costs, plus operating costs (direct savings) and estimates of gains to be made in corporate image, customer services, control, etc. (also called indirect savings).
While based on real cases, to make the calculation easier to understand the analysis in this manual has been simplified. Only the largest figures are included, namely civil works (the warehouse building and its annexes), the storage system (racks), handling equipment and its performance and personnel.
To compare two options it is essential to have comparable initial data. In this example, they are as follows:
- A warehouse with a required capacity of 8,000 pallets measuring 31.5" x 47.2" x 57.1".
- It must be possible to move 700 pallets in and another 700 pallets out each day.
- There is no picking.
- In the first phase will use an 8-hour work day.
- The space available for construction is 328 ft long and 196.8 ft wide, within a larger enclosed area.
Here it shows two options to fulfill these needs and limitations. Then, the ROI will be calculated to compare these scenarios. In any case, all costs shown here are approximate in nature, and may vary given when they are calculated and under which circumstance. Amounts are provided here merely to illustrate the calculation.
| OPTION 1. PALLET RACKS WITH REACH TRUCKS |
This first option involves a 275 ft long by 161 ft wide warehouse, with an internal height of 36 ft. It occupies 52,216 ft2, with a 19% expansion margin of the occupied surface area, in respect to the total surface area of the plot. This conventional industrial building has 8 loading docks, and a reception and dispatch area of 7,911 ft2. As requested, the facility has a capacity of 8,000 pallets. The number of movements that can be performed by one forklift is 11 pallets in and 11 out per hour (22 in total), so nine forklifts will be required. With these resources, it will take 7.4 working hours per day to reach the 1,400 required movements (700 in and 700 out). If the warehouse runs 24-hour operations, its capacity for growth is 224%. |
Pallet racks with reach trucks
| Costs of this option ($*) | ||
| Item | Quantities | Total cost ($) |
| Forklift operators | 9 | $244,080 |
| Reach trucks | 9 | $355,950 |
| Racks | 8,000 positions | $352,560 |
| Civil works (warehouse + dispatch) | 52,215.7 ft2 | $1,643,472 |
*Approximate amounts using a three-year $1.13/euro average currency rate.
| OPTION 2. BLOCKS OF PALLET RACKS OPERATED BY DOUBLE-DEEP STACKER CRANES |
This second option uses the same space as the first, but only part of this is used to build the warehouse, leaving the rest available for expansion. The height of the warehouse up to the trusses is 79 ft, inside an industrial building, as the previous option. The total built area is 31,785 ft2, of which 23,874 ft2 is the warehouse and 7,911 ft2 used for reception and dispatch. The capacity obtained is 8,000 pallets, as requested. A stacker crane can perform 29 double cycles per hour (29 pallets in and 29 pallets out), so in this case three stacker cranes will be required. With these resources, it will require 8 working hours per day to carry out the number of movements required per day. Operating 24 hours a day, this installation could grow by 200%. The margin for expansion of the warehouse is 51%. |
Blocks of pallet racks operated by double-depth AS/RS stacker cranes.
| Costs of this option | ||
| Item | Quantities | Total cost ($*) |
| Forklift operator | 2 | $54,240 |
| Stacker cranes | 3 | $966,150 |
| Racks | 8,000 positions | $858,800 |
| Civil works (warehouse + dispatch) | 31,785 ft2 | $1,242,916 |
*Approximate amounts using a three-year $1.13/euro average currency rate.
| CALCULATING THE ROI | |||||||
The simple return on investment table is based on the total accumulative amount spent on the installation each year. With this information, and the workflows, one can determine which installation is best for you from a financial point of view. The calculation uses annual spending, taking into account the one time cost of the installation (included once in the first year) and recurring costs, such as personnel, are included each year. |
|||||||
| Pallet racks operated by reach trucks ($*) | |||||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | |
| Amount from previous year | $2,596,062 | $2,840,142 | $3,084,222 | $3,328,302 | $3,928,332 | $4,172,412 | |
| Forklift operator | $244,080 | $244,080 | $244,080 | $244,080 | $244,080 | $244,080 | $244,080 |
| Forklifts | $355,950 | $355,950 | |||||
| Racks | $352,560 | ||||||
| Civil works (ware.+disp.) | $1,643,472 | ||||||
| Sum total | $2,596,062 | $2,840,142 | $3,084,222 | $3,328,302 | $3,928,332 | $4,172,412 | $4,416,492 |
*Approximate amounts using a three-year $1.13/euro average currency rate.
| Automated warehouse with double-depth stacker cranes ($*) | |||||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | |
| Amount from previous year | $3,020,406 | $3,074,646 | $3,128,886 | $3,183,126 | $3,237,366 | $3,291,606 | |
| Forklift operators | $54,240 | $54,240 | $54,240 | $54,240 | $54,240 | $54,240 | $54,240 |
| Stacker cranes | $966,150 | ||||||
| Racks | $858,800 | ||||||
| Civil works (ware.+ disp.) | $1,242,916 | ||||||
| Sum total | $3,020,406 | $3,074,646 | $3,128,886 | $3,183,126 | $3,237,366 | $3,291,606 | $3,345,846 |
*Approximate amounts using a three-year $1.13/euro average currency rate.
