Vendor Managed Inventory

AutoSoft Systems

2 Round Hill Court

East Greenwich, RI 02818

401.885.3631

401.884.5653 Fax

401.996.3631 Cell

AMDG

"Once you know it, it's Easy!"

autosoft@aol.com

Commercial and custom computer related products spanning the areas of data acquisition and control, simulation and modeling, numerical analysis, chemical process design and manufacturing management information systems design. 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.

Pharmaceutical & Biotech

Construction Management

AMDG

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:

There is also a summary report of all production requirements for the VMI program:

There is also a "Turns" utility that calculates past and future inventory turns and suggests changes to the stocking levels to optimize turns but still assure sufficient product is available to meet requirements:

AutoSoft Systems | 2 Round Hill Court, East Greenwich, Rhode Island, USA 02818 | 401.885.3631 | Fax: 401.884.5653 | Mobile: 401.996.3631

This web page was last updated at 04/27/2010 06:58 PM and is written in EXCEL!

AXIOM is a Trademark of Consona - USYS is a Trademark of Zumbach - AutoSoft Systems is not affiliated with Consona nor Zumbach