What it costs you to store a pallet is one division: everything the storage space costs in a month, over the pallets you actually have in it. The first number is rent, power, insurance, racking, a pallet jack or forklift, pest control and cleaning. The second is the trap. Divide by the pallet positions you have and you get a flattering figure; divide by the positions you fill, on average, and you get the true one, because an empty rack still pays rent. For the made-up maker below, a unit that costs $2,050 a month with 96 positions, 72 of them full, comes to $28.47 a pallet a month: 95 cents a day, 47 cents a case. A case that sits two and a half months has $1.19 of storage in it before anyone buys it. Below are the sums, what to do with the number, and a calculator.
The short version
- Add up every monthly cost of the space.
- Divide by pallets stored on average, not by positions.
- Cost a pallet a month ÷ cases on a pallet = cost a case a month.
- Times the months stock sits = storage in each case's cost.
- Compare with an outside warehouse's rate by the pallet, and remember theirs has handling fees too.
- TaroStack shows how long each lot has sat and what the stock is worth. More below.
The sum
| Cost | A month |
|---|---|
| Rent and common charges | $1,450.00 |
| Electricity and heat | $160.00 |
| Insurance on building and contents | $90.00 |
| Racking and shelving | $110.00 |
| Pallet jack or forklift | $180.00 |
| Pest control and cleaning | $60.00 |
| Total | $2,050.00 |
| Pallet positions | 96 |
| Filled, on average | 72 (75%) |
| Cost a position a month | $21.35 |
| Cost a pallet stored a month | $28.47 |
| Cost a pallet a day | $0.95 |
| Cases on a pallet | 60 |
| Cost a case a month | $0.47 |
| Months a pallet sits | 2.5 |
| Storage in the cost of a case | $1.19 |
What goes in
Rent. If the store room is part of a larger building, take its share by floor area.
Power. For dry storage it's lights and a little heat. For a cooler or freezer it can be the largest line after rent: give cold storage its own calculation, because a frozen pallet and a dry one don't cost the same.
Racking and equipment. A lease payment goes straight in. For something you bought, divide what you paid by the months it will last: $6,600 of racking over five years is $110 a month.
What stays out. Labor to receive, put away and pick is handling, not storage. It follows pallets moved, not pallets sitting. Work it out separately: hours spent, times the wage, over pallets handled. The cost of the money tied up in the stock is separate again, and is in inventory carrying cost.
Filled, not available
Count pallets on four ordinary days and average them. This maker fills 72 of 96 positions: 75%.
| Filled | Cost a pallet a month |
|---|---|
| 96 (full) | $21.35 |
| 72 | $28.47 |
| 48 (half) | $42.71 |
A half-empty warehouse stores each pallet at twice the cost of a full one. Two conclusions follow, and they pull in opposite directions. If you're half empty, the space is too big, or you could rent out the slack. If you're at 95%, the cost a pallet looks wonderful and you have no room for the next delivery. Most operations want to sit around 80 to 85% so there's room to work; that's this maker's aim, not a rule.
Using the number
To cost a product. Sixty cases on a pallet, two and a half months on the shelf: $1.19 of storage in each case. On a case that sells for $78, that's 1.5%. On a bulky, cheap product (paper goods, bottled water) the same sum can be a tenth of the price, and it's the reason those are ordered little and often.
To compare with an outside warehouse. A third-party warehouse quotes a rate by the pallet and month, plus fees for receiving and for each order picked. Compare storage with storage: their monthly rate against your $28.47, and their handling fees against your own labor. What those rates look like for cold storage is in cold storage rental rates.
To charge for storage. A co-packer or a shared kitchen that keeps other people's pallets should charge at least what a stored pallet costs. If your figure is $28 and you charge $18, every client pallet loses you $10 a month. The charges a co-packer makes are in co-packing fees.
To decide how much to hold. Storage is one of the costs that argue for smaller, more frequent orders. The sum that balances it against ordering cost is in how much inventory to keep on hand.
Slow stock
The average hides the worst of it. A pallet that turns in three weeks carries 33 cents a case of storage. A pallet of last year's seasonal flavor that has sat for eleven months carries $5.22 a case, and it's still taking up a position a faster product could use. A storage cost is a reason to look at stock by how long it's been there, and to sell, discount or dump the pallets at the back.
Get the calculator
Download the warehouse storage cost calculator. A Costs sheet for your monthly costs and a Result sheet that works out the cost of a position, a stored pallet, a day and a case, and the storage in each case for the time it sits. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The calculator gives one average for the building. The decisions are about particular pallets: which have been here since spring, what they're worth, which are close to their dates. That needs to know when each pallet came in and how fast each product leaves, and a rent calculation doesn't hold either.
How TaroStack does it
TaroStack knows when each lot arrived and how fast it moves.
Stock by lot and date. Every lot has the date it was received or made, so the age of each pallet is a fact.
Days of cover, item by item. How long what you have will last at the rate it's selling: eleven months of last year's flavor shows up as a number.
A forecast of what will expire unsold, and what it costs.
Stock value by site and month, so the money sitting in the warehouse is a figure.
First expired, first out by default, so the old pallet goes before the new one.
For a co-packer: a client's goods are kept apart, with a monthly statement by lot. Storage by the pallet-month is added to the charges by hand.
| The job | Calculator | In TaroStack |
|---|---|---|
| Average cost to store a pallet | Yes | Use the calculator |
| Which pallets have sat longest | Walk the racks | Stock by lot and date |
| How many months of each product | A guess | Days of cover |
| What will expire unsold | Found too late | A forecast |
TaroStack doesn't work out your rent or bill storage for you. Stock, lots and expiry are on every plan, from $9.99 a month; more than one site starts at Business, $89 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.
