« RFID Opens the Doors for new uses of Information | Main | The Impact of RFID on the Data Warehouse »
November 19, 2005
RFID for Cheap Data Acquisition
"How many more boxes are in the stock room?", the supervisor asked me. I pushed the door of the stock room open just enough to get a quick glance. I positioned my body so that she couldn't see disaster area the stock room had become.
"I dunno... a lot?", I said letting the door close without letting her get a good glance.
It was 1986 and my fellow stock-boys and I spent the entire weekend doing an inventory cycle count. It was a semi-annual occasion where they actually shut down the entire store while we hand-counted every piece of merchandise in the store. And it wasn't just us stock boys that had to come in - all the sales people and managers had to come help as well. The "suits" - as we called them - were especially annoyed by these events. The sales folks normally relied on commissions as their primary income... but on stock day, they were here for the same lousy minimum wage as us. And the managers... well, they were salaried so they were essentially working for free. To make matters worse, they were managed against sales figures. With the store closed for inventory, they would have to work extra hard to recoup the lost revenue.
And us stock boys ... we didn't like it either. We actually got paid time and a half for coming in on the weekend. However, the sheer brainless monotony of a cycle count was enough to make one go insane. The only tools we had were clipboards, paper forms, and pencils. Our hands cramped from writing hundreds of 16-digit sku numbers. By midnight our eyes ached from reading the size 10 courier font packing labels. We had to move every box from one side of the stock room to the other to segregate the counted from the yet-to-be-counted. Most boxes had to be completely emptied to count its contents.
By 1am we were losing it and - I have to admit - our counting practices were getting pretty sloppy. We were tired and ready to go home. We began to lose count, so we started estimating. When estimating became too tedious, we guessed. Even the manager, who was notably spent, started getting sloppy. "Just count cases from now on", she said. "Assume they're all full." Finally at 3am we called it quits. A few things were not counted, but the manager declared it "good enough".
The output of this exercise was a stack of paper forms that listed sku numbers and the quantities of product on-hand. What would this be used for? To this day, I don't know. While no one doubts the value of good inventory data, this was not yet "data"... it was just paper. And the cost of data entry to input the contents of the paper forms into - what I suppose at the time would have been a mainframe - seemed prohibitive. And, even if it were entered into a system, I don't think anyone that participated in the cycle count would have considered it "good" data.
19 years later, I found myself standing in the distribution center of a large garment manufacturer. It's cycle count weekend - a once-per-quarter event for this company. As in 1986, the operations of this facility are halted for the weekend so the employees can record every bit of inventory in this 100,000 square foot warehouse. However, each warehouse clerk is equipped with a handheld barcode scanner. The clerks go up and down the warehouse racks scanning every box. Each box has to be touched, and most moved entirely to get to those behind it. Often it takes 2-3 scans before a barcode reads. Then employees wear knee pads as they are constantly kneeling down to reach for boxes in the backs of the bins. Another team stands on top of pallets lifted by forklifts so that they can scan the boxes on the upper racks.
So what has changed since 1987? Well, the handheld barcode scanners eliminated the need manually write down skus and counts, saving hours or days of time. And the accuracy is no doubt much improved over the hand scribed sku numbers. And, all the scans are instantly transformed to data the moment the handhelds are placed back in their docking stations where they can synchronize their contents to a central database.
These are huge gains, to be sure. However, operations still had to be stopped, and employees still had to come in on the weekend, and every piece of inventory had to be touched. And therefore the cost of acquiring the inventory information is still high enough to warrant only a once-per-quarter draw.
But I was called to this facility to do a feasibility study on using RFID for inventory management. The idea is to mount RFID readers throughout the warehouse. With tags affixed to every unit of inventory, an accurate count can be obtained automatically. No disruption to operations, no weekend overtime, no inaccurate counts due to dwindling employee attention. Effectively, the cost of obtaining inventory information is free. With cost out of the equation, how often will inventory counts be taken? What new analyses can be done to track product movement throughout every process in the warehouse and DC? What hidden bottlenecks will be uncovered by the abundance of new data? The doors are opening wide for new uses of BI as the cost of data acquisition is falling thanks to RFID.
Posted by Eric Colson at November 19, 2005 12:45 AM
Trackback Pings
TrackBack URL for this entry:
http://www.beyeblogs.com/mt/mt-tb.cgi/89
