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.
- Save time by using a pre-designed template to
manage your inventory.
- Reduce costly stock
shortages by setting reorder tolerance levels appropriate for your business.
- Color
coded alerts ensure that you are alerted to reorder before stock gets too
low.
- Save money by spending your time on
running your business instead of creating spreadsheets to manage inventory.
-
Two versions of the Inventory Tracker for Excel are included in your order.
One supports 25 products and the other supports 20,000 products. Each
spreadsheet can be expanded to support more than 65,000 products.
| Click the thumbnails below for partial
screenshots of the Inventory Tracker for
Excel. |
25 Product Version
(Purchase also includes a 20,000 product version) |
The Inventory Tracker for Excel runs on any version of Excel from 97-2007.
It is fully compatible with Microsoft Windows 7, Windows Vista and Windows XP.
This product is also compatible with Excel 2004 and Excel 2008 for Mac running
on Mac OSX Leopard or Tiger.
