The Inventory Tracker for Excel allows small business owners and inventory management professionals to track inventory and view automatic alerts when reordering is necessary.
Key features of the Inventory Tracker for Excel include the ability to pre-define reorder levels and customize reorder tolerance levels. When units in stock are within 10% (or whatever percentage you define) of your pre-determined reorder level, the status field turns yellow and indicates "Reorder Needed". The status field turns green and indicates "In Stock" when units in stock exceed your reorder tolerance level. When no units remain in stock, the status field turns red and indicates "Out of Stock". These color-based alerts provide an easy way to recognize products that need attention.
The Inventory Tracker for Excel includes one spreadsheet that supports 25 products and an additional spreadsheet that supports 20,000 products. Both versions are included with your order so you may use either one based on your needs.
The spreadsheet is flexible and easy to use. It may be expanded to support more than 65,000 products by anyone with a basic knowledge of Excel.
Our software runs on any version of Microsoft Excel from 97-2007.
All recent Microsoft operating systems are supported, including Windows 95, Windows 98, Windows 2000, Windows ME, Windows CE, Windows XP and Vista. Windows Mobile 5.0 and 6.0 are also supported, provided you have Microsoft Excel or Documents-To-Go installed on your mobile device.
It is also fully-compatible with MAC OS and OS X. You must be running Excel 2004 or 2008 for Mac.