We were recently challenged to track several hundred uniforms and musical instruments for a major university’s marching band. The quantity was not the problem…. determining which student musician has what uniform and instrument was. The total value of the equipment is in excess of a million dollars and ‘were given out to 18 – 21 year old college students with no means, other than paper and pencil, to track the assets.’
We proposed Z-Space Technologies’ Check In/Check Out Solution Pack; a configurable software solution built upon a SQL database, Crystal Reports, and Z-Space’s ITScriptnet data collection and development/communications software application. This solution is basically designed to track any asset that is frequently in and out of the hands of people. With minor configurable adjustments, it can be used very effectively for the university’s purpose. When integrated, the software solution allows the user to manage the assets and answers the three fundamental questions of asset tracking – Who has it? What is it? and Where is it?
Once the solution is implemented, the process is very simple. Each student utilizes the university-provided ID card with a bar code associated with the student’s ID number. All of the uniforms have a bar code label inside each piece i.e. pants, jackets, hats, shoes as well as all of the instruments. The bar code contains the university’s asset and serial number for accounting and tracking purposes. Labeling the actual instrument proved a little difficult. However, since each instrument has a case, we bar coded the case instead. The band director is provided a handheld mobile computer, like the Motorola MC55 or Unitech PA968, with the application configured on the device. Now all he needs to do is scan the labels and the student ID barcodes and the application does the rest. To further the cause, we added customized reports and configured the devices and wireless network to communicate in real-time to the host PC.
For more information about this or other Check In/Check Out applications, contact RACO Industries at 1-800-446-1991 or visit us at www.racoindustries.com