eye.jpg
 
                      AutoSoft Systems
        AutoSoft Systems 2 Round Hill Court
        East Greenwich, RI 02818
        401.885.3631
        401.884.5653 Fax
                        401.996.3631 Cell
AMDG       Decision Ready Information! autosoft@aol.com
Commercial & custom multi-user computer software for a variety of applications including performance metrics, statistical analysis, data extraction and merger from multiple large databases, computer simulation and management information systems.  Founded in 1982.
We know Excel! Whenever possible, Excel is the user interface, VBA is the programming language, ODBC connects to the database of your choice.
Home About Us Literature Wire & Cable Pharmaceutical & Biotech Construction Management Commercial Products Custom Solutions
Contact Us Events Downloads
                            AMDG
MCj00905530000[1]
Vendor Managed Inventory
There are two distinctly different VMI problems.
1. Your vendors manage the raw materials they supply to your facility.
2. You manage the inventory you supply to your customer's facility.
1. Your vendors manage the raw materials they supply to your facility.
                       
                               
                               
                               
Here, you pick an AXIOM stockroom from a drop down menu:  
         
You can edit the information in the blue if you hit the DARK RED button.
You specify the date ranges you wish.  This date picker is quite cool in that it is written totally natively in Excel with no finicky ActiveX controls. 
When all is step, you click the  BLUE  button to generate the report.  This take a few minute to run, but the program provide you with plenty of feedback as to what it is doing:
The final report looks like:              
 
                           
                             
                           
                             
                             
And is sent to the vendor via email. Click here to view a sample report.            
2. You manage the inventory you supply to your customer's facility.
 
                           
                             
                             
EDI (Electronic Data Interchange) files are received from the customers on a daily basis which provide inventory levels of your parts.  These files are imported into the application with a complete log file and exception reporting of the transactions.  Reports are generated periodically and sent to the customers.  A summary report:
 
                           
                             
                             
There is a detail report for each inventory item showing the usage over the last 6 months and using these usage quantities to determine shipments over the next 6 months.
 
                           
                             
                             
                             
There is a summary report for all future shipments: