If you sell products, you have inventory. And inventory costs you money. If you have every struggled with
- Unexpectedly running out of products ("sorry sir, we're out of that)
- Tying up your cash in products that don't move
- Wondering how many products to order
- Wrestling with complex calculations related to your supplier minimums
- Being afraid to place orders because you're really just guessing
- Dreading the idea (and expense) of purchasing a complex inventory management program
The Inventory Management Worksheet Package is for you.
If you like the idea of managing your inventory in Excel, but you don't have the confidence or time to set up the worksheet yourself, you'll love our worksheet package because along with the worksheet itself, you also get complete instructions on how it works along with background information on how and why the worksheet works.
When you buy our Inventory Management Worksheet package, you receive:
- InventoryTracking.xls - a Microsoft Excel file that helps you figure out how many items you need to order. It contains cell formulas described in our Computor Companion article along with a product ID cell so you can note the product's part number, bulk quantity cells so you can order by the case or other bulk unit of measure, and support for vendor-mandated minimum order quantity.
- Inventory Management.pdf - This white paper provides basic instructions on how to use the worksheet as well as an explanation of the inventory management theory behind the calculations.
- InvInstallationUnzip.pdf - a PDF file with unzipping installation instructions.
All of this information is conveniently packaged in a Zip (compressed) folder, which you download. If you aren't sure how to open a Zip file, the quick, easy instructions are located on our Help Page. The information on where to put your package on your computer and how to work with your worksheet is in the PDF file.
(Note that the worksheet should work in PC Microsoft Excel versions 95-2003. Although the worksheet may work, the instructions are NOT designed for Excel 2007.)