What is Inventory Software?
guide to inventory control
optimize inventory replenishment operations
New Material Handling System to Track Equipment and Inventory
Johnson Controls Pioneers Automated Inventory Replenishment Program for
INVENTORY OF MOVABLE EQUIPMENT
Inventory/Property Management
Enfold Systems delivers scalable open source Lab Inventory Management System
Hazardous Materials Inventory Systems
CHEMICAL INVENTORY - Web based software
Inventory Replenishment Policies for Systems with a Fixed Emergency Order Cost
WISP Inventory Management
Building a Chemical Industry Management System ?The Successful Development of
Tracking inventory is a problem that is not unique to WISPs. However, the
value of radio equipment is typically higher than similarly sized inventory in
other networks. This makes inventory especially important to WISPs. Tracking is
made more difficult by that fact that WISPs often own inventory outside their
direct control some of it far off the ground.
Inventory tracking problems evolve slowly. Small WISPs usually launch in just
one market. There is usually one installer. Maintaining inventory is as simple
as the accountant recording the receivers and serial numbers in a spreadsheet.
Installers pretty much know where everything actually is in their heads.
Success brings problems. At first, everybody is concentrating on serving new
customers. As the business grows, installation personnel change, new cities open
up and vehicles and storage locations move around. Inventory tracking gets
postponed for more pressing needs. Compounding this problem, new WISPs make snap
business decisions to sell equipment or barter or trade gear. Keeping track of
all this gets pretty hard.
Fixed wireless is still a pretty maintenance intensive business.
Old-fashioned customer service causes one of the biggest problems. When troubles
arise, it's usually easiest to program a radio and rush it over to swap or
"trade out" a customer or hotspot location's problem unit. This is great service
and usually the right thing to do but just how many of those product serial
numbers actually get recorded and transferred in the records is anybody's guess.
Sometimes the company sells equipment, but still needs to support it.
However, it is important to not count the sold product as an asset by mistake.
For small companies, this may seem nothing to worry about. However, when
providers move to the next step of investment or the owners wish to exit by
selling, it becomes a big problem. During due diligence, a very tight (usually
audited) inventory is required. Having to go to every customer site in multiple
towns in the middle of a due diligence process while still doing business is a
daunting task.
So, this begs the question how can inventory problems be addressed
early?
Physical controls help
Maintaining
inventory records is pretty simple if it is the company's culture. Starting up
with a good documentation and physical control process ensures a tight
inventory. However, if you're an existing business with hundreds of thousands of
dollars in inventory already spread over five or six cities, how do you begin?
It begins with physical controls. Commence by organizing each equipment room
and installation vehicle. Inventory everything. Record the distributor,
manufacturer, serial number, model number, wholesale cost, length or other
pertinent facts. During this process organize each room or vehicle for a quick
inventory. Put up organizers, hang things, set up racks for cable, whatever
works best to keep it neat. Then lock the door. Audit as many customer sites as
possible (all if possible, a large percentage if not).
Decide on who gets keys and limit access to those people. Delegate
responsibility for reconciling any inventory discrepancies to them. Assigning
accountability to those who touch the inventory is key.
Documentation is the next step. Small WISPs cannot get too bogged down by
documentation if they want to survive, so keep it simple. A clipboard hung on
the equipment room door or the install truck front seat is fine. Record each
piece of equipment going out, the quantity, a serial number, where it is going,
which installer took it, and the date. Note any recovered equipment exactly the
same way. This is simple and sufficient. One person later enters this in a
spreadsheet, database, or master log, preferably at the end of the day.
It's essential to do regular inventories. Once a month is good. If there are
discrepancies, those responsible must track them down. This is effective in
encouraging daily documentation. After the first big hunt for discrepancies, no
one will want to do it again.
What about
software?
Inventory resides in equipment rooms, storage buildings,
installation vans, trucks trailers, or warehouses. Any item there is easy to
find. However, WISPs also deploy inventory at customer sites, on towers, and in
buildings.
A building may have rooftop equipment for multipoint relays. The same
building probably contains distribution gear as well as customer premise units.
Some will be owned by the WISP and some won't. Either way, the WISP is may be
responsible for supporting it. Keeping track of which deployed products are
really your own assets gets complex quickly.
Software is one solution. Even a spreadsheet can help. However, spreadsheets
are labor intensive. Commercial inventory packages exist, but are pricey and few
are optimized for WISPs. Some firms choose to build their own tracking
databases.
Whether your WISP is selecting software or building it there are some basics.
Secured Web-accessible software is mandatory for multi-city operations.
Associating equipment with a contact record is important. It is useful to track
actual ownership piece by piece. Look for a system built around entering
inventory details when it's first received. Transferring inventory later should
be easy. Select a product allowing user-defined information for each unit, such
as IP and MAC addresses,
firmware version, and standard service set identifier (SSID).
Conclusion
It is possible to control inventory. Simple
really is best in this case. Employees will do simple things to prevent having
to do hard things like reconciling an inventory every month. With just a bit of
effort you can take control of that slippery stock.
Tim Sanders is founder of The Final Mile, a fixed wireless
consulting group. His learned the trade running a multi-state fixed wireless
ISP. He will be a featured speaker and moderator at the 802.11 Planet
Conference & Expo, Dec. 3-5 in Santa Clara, Calif. One of his workshops
will cover Integrating Smaller WISPs into Larger Networks.