Inventory Management Spreadsheet

This file allows you to monitor and automatically update inventory levels for any product.

It also displays an indicator of when to make a restock from a specific product and what is the optimal quantity you need to order.

How to use:

1. Enter item name and code in tab "item code" and other required data in the white cells only.
2. Go to tab "Inventory Management" fill in the purchases of each items.
3. All changes will be updated on tab "item code" to know the quantity remaining, stock value, item cost, when to reorder and quantity to reorder for each item.