One of the more recent features of the DataQlick app is the “Inventory Manager”. The Inventory Manager is designed to give full control of inventory to the user. An image of the Inventory Manager can be seen below.
Once you open the Inventory Manager you will see the inventory data table where a brief overview of the inventory is given. This includes the total cost of the inventory, the quantity of separate active items within the inventory, the quantity of items on order and (most importantly) the quantity of low stock items.
Next you have the two tabs labeled “Inventory Manager View” and “Inventory Control”. The selected tab in the first image is the “Inventory Manager View”. Each item in the inventory is color-coded based on where it stands in relation to stock levels. Red indicates “Low Stock”, yellow indicates “Near Team”, green shows when the stock is at “Proper Levels” and blue indicates when there is an “Over Stock”.
The data contained in the table gives a detailed breakdown of each individual inventory item. A number of columns show the details of each item. These details include:
- Unit Price — How much that item is sold for.
- Purchase Cost — How much that items was purchased for.
- Current Inventory Cost — The total cost of all the full quantity of that item on hand.
- Quantity On-Hand — The quantity of that particular item currently in the inventory.
- Quantity On-Order — The quantity of that particular item that has been ordered.
- Days of Inventory to Minimum Level — This is the number of days before the quantity of that particular item gets to the minimum acceptable level. This is calculated based on an average of sales per day.
The next important section to look at is the “Inventory Controls” Tab. This is the area for complete control of inventory items. Here, you can see sales history, purchase recommendations, visual graphical analysis of inventory data, and many more useful features. The image below shows this tab.
In the inventory control area, the average monthly sales of each item can be seen along with the vendor of that item. Also shown is the “Re-order Point Min” and Re-order Point Max”. The “Re-order Point Min” represents the lowest stock level that this item can get to before a purchase order is created for more. The “Re-order Point Max” is the maximum stock level that this item can be considered for purchase recommendations.
The development of the Inventory Manager in the DataQlick app is very exciting and shows real progression of this handy application.