The MIS Inventory system is a feature rich module designed to help you manage (not just track) your inventory.
Inventory File Information
The Item file contains the following information: Product ID, primary description,
secondary description, look-up description, product classification, primary
substitute item ID, unit of measure, packing, general ledger numbers (sales,
inventory, cost), favorite vendor, manufacturer code and model, reorder
point, quantity after reorder (order multiple or order up to if desired),
safety stock level, average lead time (see also statistics), sales commission
and category, quantity per unit, shelf life, weight, calculation code, gross
margin percent, costs (user, average, LIFO), freight costs, price category,
5 price columns, quantity price break controls, item type indicators (standard,
serialized, lot/reel/roll), cycle count ID, how purchased/priced/sold
ratios, order/sell status indicator, non-stock indicator, order type and
repricing category.
Also contained in the
file is:
Quantity on-hand, quantity committed, net quantity available for sale, quantity
on-order, quantity on backorder.
Related Inventory Files
•Customer cross reference file
•Vendor cross reference file
•Extended product description file
•Competitive price file
•Product interchange file
•Overflow location file
•On-site warehouse file
Purchase and Stock Management
The MIS Purchase Manager subsystem was designed to organize many of the
functions performed by the department responsible for purchasing and stocking
the goods which a company resells. These functions include review screens
for inventory statistics to determine which items are being sold, item profitability,
special stocking conditions, reports assisting in developing orders and
definable product performance ranking functions.
Inventory
statistics are
compiled and maintained by the system. The statistics are used to aid in
the ordering (what to order), stocking (what to stock) and notification
of slow- moving or dead stock. The following statistics are kept on each
item:
•Sales, Profit, Units, and Cost Rankings
•Stock Out Occurrences over last 24 months
•Last Stock Out Date
•Last Stock Days (number of days)
•Performance/ABCD Code
•Turns
•Lead Days (average, last, best, worst)
•Highest in-stock amount and date
•Highest one-time sale amount and date (single customer dependency)
•Average unit sale per month
•Stock sufficiency/customer service levels (in-stock or backorder situation per month)
Click on image for larger view
What To Order
The system uses the valuable statistics to determine what to order. Some
of the reports that are available for ordering are:
•Suggested Order Report
•Just-In-Time Ordering Report
•Reorder Point Report
Click on image for larger view
The above reports can automatically send results to the MIS Purchase Manager subsystem. The Purchase Manager allows you to edit the system-generated figures, optimize the order amounts (based upon vendor terms and products with multiple units of measures), send a system-generated RFP and automatically update the MIS Purchase Order module
To Stock, Not to
Stock, Dispose
Several reports are available in order to determine stocking levels.
•Inventory Slow-mover Report
•Overstocked Inventory Report
•Item Performance Report
•Hot Mover Report
Item Pricing and
Costing
There are several options within the MIS system that can help establish
and maintain selling prices and user costs (vendor-published costs).
•Inventory Cost/Price Matrix
•Class/Type Percentage Update
•Item Pre-Pricing (future price changes)
•Electronic updates from your vendor
