Inventory Bar Code Software, Inc.

Coco Cola is one of the largest known companies in the world and uses "Bar Code Software, Inc" as their source of inventory. They are able to track each of their products through a tracking system in which lets them know when to reorder whatever product for each vending machine that is located in the United States. The actually system itself is called "Track-it.", and they were able to access all the information on locations of each vending machine through computers at Coco Cola. Track it consists of specialized software that pulls the information from Coke’s mainframe database and transfers it to handheld terminals with built-in laser scanners. Printed bar code labels are generated and placed on every machine, old and new. The bar code indicates the machine’s special asset number, as assigned by Coke. When it is time to perform a physical inventory, Track It pulls information on existing inventory from Coke’s mainframe using “queries” and “ODBC” drivers. This process generates a record on each piece of machinery with all pertinent information.

Next, this information is transferred from the PC in its entirety to each handheld scanning terminal using Track It’s specialized software. Multiple terminals are used simultaneously to scan the bar codes on each machine throughout Coke’s remanufacturing facilities. As each vending machine’s bar code is scanned, the asset number is compared to each number on the list that had been downloaded from Track It. A report listing those assets found and not found is then displayed on the handheld terminal’s display. The new information is then transferred from all of the portable terminals back to Track It, and the database on the PC is automatically updated. Reconciliation inquiries and reports are now available at the click of a mouse.