Home / Insights

Warehouse operations series · Part 7 of 8

Do We Need a WMS Yet? When Spreadsheets Stop Scaling

Contents
  1. What a WMS actually does
  2. Where the money goes without one
  3. The break-even volume
  4. The example at 300 orders a day
  5. Signs you have outgrown spreadsheets
  6. ERP module or WMS: the questions to ask
  7. A roadmap that works for SMEs
  8. Common mistakes
  9. Measures to track before and after
  10. Key points
  11. Sources

Every warehouse starts on paper. Someone prints the orders, walks the floor, ticks the lines and hands the sheets to the office, where they are keyed into a spreadsheet or the accounting package at the end of the day. With two people and a few hundred SKUs it works, because the people know where everything is.

Then the business grows. More SKUs, more locations, more people, a second shift, an e-commerce channel. The question arrives in every growing distributor sooner or later: do we need a warehouse management system yet? Vendors will say yes. The accountant looks at the subscription and says not yet. This part puts numbers on the question with the same distributor as Parts 1 to 6, at any volume from 50 to 1,200 orders a day.

What a WMS actually does

A WMS is not mainly a stock list. The ERP or accounting system already knows how many of each item the company owns. A WMS knows where each one is, down to the location, and it tells people what to do next: where to put this pallet, which orders to pick together, which route to walk, which location to count today. Every move is confirmed with a scan, so the record changes the moment the stock does.

The options an SME usually weighs:

OptionWhat it isImplementationSubscription in the model
Paper and spreadsheetPaper pick lists, a spreadsheet or the accounting package's stock list. Locations in people's headsNone$100 a month for printing and the spreadsheet
ERP module + scannersThe ERP's inventory module with bin locations and handheld scanners (Business Central, NetSuite, Acumatica, SAP Business One and similar)$25,000$600 a month plus $100 a user
Cloud WMSA cloud WMS linked to the ERP: directed put-away, batch and wave picking, scan at pick and pack, cycle counts, labour reports$45,000$2,000 a month plus $150 a user
Enterprise WMSAn enterprise WMS licensed through a systems integrator, with labour management and advanced slotting$320,000$6,000 a month plus $250 a user, and an IT administrator

The price ranges come from published guides: cloud WMS subscriptions typically run $100 to $500 a user a month, often with a monthly base fee, and small single-site operations commonly spend $25,000 to $75,000 in the first year including implementation, training and hardware. Enterprise systems with an integrator start in the hundreds of thousands. The model spreads implementation over five years and scanners over four.

Where the money goes without one

Software is the easy cost to see. The costs of running without it are spread across the floor and the office, and most of them grow faster than the business:

  • Searching. When locations live in people's heads, every new SKU, location and person adds searching. The model adds 50% to paper's floor time an order for every 1,000 orders a day of volume, against 3% for a WMS that directs every move.
  • Keying. Every pick list, receipt and adjustment is typed in again by someone in the office, and someone answers the phone when a customer asks whether an item is in stock.
  • Counting. Without location records, the only way to fix the books is a wall-to-wall count with the warehouse shut (Part 4).
  • Errors. Without a scan at pick and pack, about 0.75% of orders reach the customer wrong, at $75 each (Part 5).
  • Wrong records. With 92% of locations right, some orders hit a location that is empty or short: a search, a short shipment or a rush order.

The assumptions behind the four options:

OptionFloor time an orderAdded a 1,000 orders a dayOffice time an orderOrders reaching customers wrongStock records rightSystem up to date within
Paper and spreadsheet9.0 min50%1.0 min0.75%92%end of shift
ERP module + scanners9.2 min12%0.6 min0.25%97%a few minutes
Cloud WMS9.0 min3%0.3 min0.12%99.0%seconds
Enterprise WMS8.8 min2%0.3 min0.10%99.5%seconds

\[\text{Cost a year} = \text{software} + \text{floor} + \text{office} + \text{counting} + \underbrace{\text{orders} \times \text{error rate} \times \$75}_{\text{errors}} + \underbrace{\text{lines} \times (1-\text{accuracy}) \times 0.10 \times \$30}_{\text{wrong records}}\]

Floor people are the floor hours a day divided by 7 productive hours a person, as in Part 6. Each floor person needs a scanner and a user licence, plus 2 office users.

The break-even volume

$0$4$8$12$16$20$24502004006008001,0001,200The example today: 300 a dayPaper and spreadsheetERP module + scannersEnterprise WMSCloud WMSCost an orderOrders a day
Figure 1. Total warehouse cost an order against volume. Each option is cheapest in its own band of volume, shown by the strip along the bottom.

Figure 1 is the answer in one picture. Below about 60 orders a day, paper and a spreadsheet is the cheapest way to run the example's warehouse: the team is small enough to know where everything is, and any software costs more than it saves. From there to about 135, the ERP's own inventory module with scanners wins: most of the benefit comes from the scan, which kills keying and most errors, and it costs little if the ERP is already paid for. Above about 135 orders a day, a cloud WMS is cheapest, and the gap widens with every order.

The enterprise WMS never wins in the SME range. Its cost an order only falls below the cloud WMS at about 2,440 orders a day, eight times the example's volume. Its extra capabilities are real, but an SME pays for them long before it can use them.

Between about 100 and 250 orders a day the ERP module and the cloud WMS are close: at 150 orders a day the gap is $600 a year. In that band, choose on fit, not on price (see the questions below).

Figure 2 runs the example's warehouse through a day on each of the four options. Every pallet is coloured by what the system knows about it: steel blue when the record is right, grey when something has moved that the system does not know about yet, and red when the record is wrong. Pickers with paper carry their lists back to the office, where they wait to be keyed in at the end of the shift; pickers with scanners send each pick to the system as it happens, shown as a cyan spark. Choose an option and a volume, or Compare all, and click the chart to try any volume.

300 orders a day · 06:00
Orders a day
Warehouse cost a year
Cost an order
Floor people
Errors reaching customers a day
Stock records right
System up to date within

Cost an order ($5 to $14) from 50 to 1,200 orders a day. Click to choose a volume.

  • Record right
  • Not in the system yet
  • Record wrong
  • Scan sent to the system
  • Paper pick list
Figure 2. A day in the example's warehouse on each option. The share of red pallets is each option's stock-record error rate, and the grey pallets are the locations picked today that the system has not caught up with. The cost, people and error numbers come from the same model as Figure 1 and the tables.

The example at 300 orders a day

OptionFloor peopleSoftware and devices a yearLabour a yearErrors and wrong recordsTotal a yearCost an orderOne-time costPayback against paper
Paper and spreadsheet8$1,200$574,000$96,000$671,000$8.95None-
ERP module + scanners7$26,000$512,000$34,000$572,000$7.62$44,0007 months
Cloud WMS7$52,000$477,000$14,000$542,000$7.23$68,0009 months
Enterprise WMS7$222,000$463,000$9,000$695,000$9.26$354,0009 years
Software and devicesFloor labour above the lowestOffice keying and checkingCountingErrors reaching customersWrong stock recordsPaper and spreadsheet$231,000ERP module + scanners$131,000Cloud WMS$102,000Enterprise WMS$254,000
Figure 3. Yearly cost of each option at 300 orders a day, without the floor labour all four share. The cloud WMS costs more in software and saves it several times over in labour, errors and records.

A WMS pays for itself at this volume. The cloud WMS costs about $52,000 a year in subscriptions and devices, against about $1,200 for paper. It saves $129,000 a year overall, mostly in floor and office labour, with 1 fewer floor people and fewer errors and wrong records. The one-time cost of $68,000 includes implementation, scanners and a six-week dip in floor pace after go-live, and is repaid about 9 months after signing, counting 3 months to go live.

The ERP module is the cheaper first step. It gets most of the way for less: $572,000 a year, and paid back in about 7 months. For a business below about 135 orders a day, or one still cleaning up its processes, it is a sound start. Its limits show as volume grows: no wave planning, weaker put-away logic and slower records.

The enterprise WMS costs more than paper here. At $695,000 a year it is dearer than running on paper, and its $354,000 one-time cost takes 9 years to repay.

The model is conservative about growth. A business on paper at 300 orders a day needs 8 floor people; at 900 it needs 28, against 20 with a WMS. Hiring and training those extra people, and the space they need, are not counted.

Signs you have outgrown spreadsheets

SignWhy it matters
Only one or two people know where things areThe warehouse stops when they are away, and it cannot grow past them
Stock records below about 95% rightStockouts, rush orders and customers told "in stock" when it is not (Part 4)
Errors reaching customers above 0.5% of ordersAt $75 each, it adds up quickly (Part 5)
Someone spends hours a day keying in paperworkPaying twice for every transaction, and a day behind
The warehouse shuts for a yearly countLost shipping days and a record that is wrong again within weeks
Lot, expiry or serial numbers must be trackedRecalls and first-expired-first-out are not practical on paper
A second channel or site, or 3PL clientsStock must be split, reserved and billed by client and location
Large customers ask for advance ship notices and labelsEDI and compliant labels need system data at the dock

Three or more of these together usually mean the warehouse has already paid for a WMS in hidden costs.

ERP module or WMS: the questions to ask

  • Does the ERP module direct the work, or only record it? Directed put-away, batch or wave picking and system-chosen cycle counts are where most of a WMS's labour saving comes from.
  • Does it handle your units? Cases, inners and eaches; pallets with mixed items; catch weight.
  • Lot, expiry and serial numbers? At receiving, at picking and on the shipping documents.
  • Shipping integration? Rates, labels and tracking from the carriers you use, without retyping.
  • Scanners on the floor? Real offline-capable handhelds, not a web page on a phone that times out in the back aisles.
  • What happens at 3 times the volume? Users, licences, performance and the price at that size.

A roadmap that works for SMEs

StepWhat to do
1. Fix the process firstSpace and slotting, pick methods, the dock, counting, errors and labour (Parts 1 to 6). A WMS on a messy process automates the mess
2. Clean the dataLabel every location. Clean the item master: dimensions, weights, units, barcodes
3. Write requirements by workflowReceiving, put-away, picking, packing, shipping, counting, returns. What must happen, and who does it
4. Scripted demosShortlist three to five systems and make each demonstrate your workflows with your items and orders
5. Check the linksERP or accounting, shipping, e-commerce and EDI. Integration is where projects go over budget
6. Go live in a quiet monthJanuary to March for most distributors. Never in the run-up to the peak (Part 6)
7. Support and measureVendor on site for the first weeks. Track the same measures before and after

Common mistakes

  • Buying for the business you hope to be in ten years. An enterprise system for a 300-order warehouse costs more than paper.
  • Waiting until it hurts. In the example, staying on paper past 135 orders a day costs more every month.
  • Skipping the data cleanup. Wrong dimensions and missing barcodes stop a go-live faster than any software bug.
  • Customising before using. Run the standard workflows for three months, then change only what the floor really needs.
  • Counting only the subscription. Implementation, scanners, training and the go-live dip often cost more than the first year's fees.

Measures to track before and after

MeasureWhat it shows
Labour hours an order, by zoneThe floor saving, measured the same way as in Part 6
Location accuracyWhether the records can be trusted (Part 4)
Order accuracy at the customerErrors that got through (Part 5)
Dock-to-stock timeHow quickly received goods can be sold (Part 3)
Office hours on warehouse paperworkThe keying saving

Key points

  • A WMS's value is knowing where every item is, and directing the work, not keeping a stock list.
  • In the example, paper is cheapest below about 60 orders a day, the ERP module with scanners up to about 135, and a cloud WMS above that.
  • At 300 orders a day, a cloud WMS saves $129,000 a year against paper, and pays back about 9 months after signing.
  • An enterprise WMS does not pay at SME volumes. In the example it costs more than paper.
  • Fix the process and the data first, choose on your own workflows, and go live in a quiet month.

Earlier in this series: Part 1 space, Part 2 picking, Part 3 the dock, Part 4 stock records, Part 5 errors and Part 6 labour. Next: Part 8 asks when automation pays.

Sources

The distributor, its volumes, labour times, error rates and software prices are an illustrative example built from stated assumptions and published price ranges. Real quotes vary widely by vendor, users and scope. Chmltech does not sell or resell any WMS.

Keep reading

Related articles

All 168 articles

Operational Efficiency

Warehouse operations series · Part 6 of 8

Peak Season Without the Panic: Warehouse Labour Planning

Turn the forecast into hours, look inside the day, and compare overtime, a peak-sized crew, planned temps and cross-training in one warehouse.

Nov 16, 2026 · 11 min read

Operational Efficiency

Warehouse operations series · Part 5 of 8

Mis-Picks, Mis-Ships and the Real Cost of an Error

What a picking error really costs, where to catch it, and which checks pay in an SME warehouse: pack checks, scanning and check scales.

Nov 16, 2026 · 10 min read

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.