Home ] Features ] Order Form ] Download ] Help Desk ] Site Map ] Feedback ]

Inventory Interface MRP Software - Home Page

Inventory Interface ERP software for manufacturing - Logo

Inventory Status

Check out our new LOW Pricing!
Join our mailing list!
Enter your email address below, then click the 'Join' button:
Announcements
Discussion

Bill of Materials
Purchase Orders
Inventory Management
Work Orders
Order Processing
Inventory Status
Accounts Payable
Accounts Receivable
Backorder Status
Price Overrides
Salesperson Analysis

 

Software Summary

bulletYear before last, last year and year to date usage and cost per category.
bulletUser defined period for: average on-hand, turnover, used per day, and cost per day information per item with totals per category

System Overview

One of the big advantages of keeping a computer based inventory system is that the computer is the one that will now do the number crunching for you. II will break down the inventory into its categories and return detailed information as describe as follows.ERP Software - Screen Shot

bulletCategory-> the unique category name found in the inventory database file
bulletRecords-> the number of records found in this category
bulletNo Cost-> the number of records found to have a cost of $0.00
bulletWith Cost-> the number of records in the category having a cost not equal to $0.00
bulletItems-> the sum of On Hand for each record
bulletCost Value->the sum of On Hand x's Cost for each record in the category
bulletRetail Value->the sum of the On Hand x's the selling price for each record in the category
bulletAvg Cost-> column Total Cost divided by column ITEMS
bulletYbl Used-> the quantity of items used 2 years ago starting Jan. 1 to Dec 31
bulletYbl Cost-> the quantity of each item used 2 years ago X its current cost
bulletLy Used-> the quantity of items used 1 year ago starting Jan. 1 to Dec 31
bulletLy Cost-> the quantity of each item used 1 year ago X its current cost
bulletTy Used-> the quantity of items used this year since Jan.1
bulletTy Cost-> the quantity of items used this year since Jan.1 X its current cost
bulletTotal Used-> the grand total of items used in this Category (including information over 2 years)
bulletTotal Cost-> information of Total Used X by its current cost

Each category contains a <List> of the items that are in its category. Oh, don't forget you can hide any column that you do not want printed/exported. You can even set filters to print/view only the information you want.

Category Detail Information

bulletRecord-> The 'record' field is a unique number that identifies the current part in the inventory database. This number is generated by the computer when the part is added to the database and cannot be changed.
bulletPart No-> The 'part no' field is a alphanumeric identifier that is given to the part by the manufacturer and recorded in the inventory database.
bulletEntry Date-> This is the date a part/item was added to the inventory database as recorded in the inventory database file.
bulletDescription-> The description column is used to accurately describe the current part. It may contain information regarding the size, color and use of the part. This is the description as found in the inventory database file.
bulletOn Hand-> This is the actual amount that is available for use as found in the inventory database.
bulletCost-> is the actual current cost as found in the inventory database.
bulletCost*On Hand-> is the inventory cost field multiplied by the inventory amount on hand
bulletUsed-> is the total quantity of parts/items used between the starting and ending period. This information is calculated from the history database.
bulletAvg On Hand-> is the average quantity on hand between the starting and ending period. This information is calculated from the history database.
bulletTurnover-> is the amount specified in the used column divided by the amount specified in the Avg On Hand column.
bulletUsed*Cost-> between the starting and ending dates the daily amount used is multiplied by the cost of that item for that day as specified in the cost history database.
bulletUsed/Day-> is the quantity as described in the used column divided by the number of days between the starting and ending dates.
bulletCost/Day-> is the quantity as described in the Used*Cost field divided by the number of days between the starting and ending dates.
bulletAny other related field

Back Up Next

 

Inventory Interface is a trademark of Gerald Drouillard.  All other products mentioned are registered trademarks or trademarks of their respective companies.
Questions or problems regarding this web site should be directed to
support@InventoryInterface.com.
Copyright 2001 Gerald Drouillard. All rights reserved.
Last modified: Friday December 28, 2001.