1 / 18

Vendor Managed Inventory Malnove’s Standard Approach

Vendor Managed Inventory Malnove’s Standard Approach. VMI Process. Steps Involved:

jermaine-burris
Download Presentation

Vendor Managed Inventory Malnove’s Standard Approach

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Vendor Managed InventoryMalnove’s Standard Approach

  2. VMI Process Steps Involved: 1. Create a standardized spreadsheet2. Save spreadsheet to a specific location with specific name in CSV format3. Open web form and select “As of Date”, Customer #, and Plant4. Upload Customer CSV file5. Merge in Radius data6. Analyze data7. Download data for further analysis.

  3. VMI Process • Starts with a standard format spreadsheet

  4. VMI Process • CS Rep saves the spreadsheet as a CSV (Comma Separated Value) file in a specific location with a specific file name • Filename is Plant # + Customer # (ex: 113719.csv)

  5. VMI Process • Open the Web form and select the “As of Date”, Customer #, and Plant

  6. VMI Process • Import the customer information saved in the standardized CSV file format • Program looks for file based upon selected Plant# and Customer # Click here

  7. VMI Process • A successful load of data will look like the following • Now, update the file with Radius data (Qty on Hand, Qty In Transit, Qty Released, etc.) Click Here

  8. VMI Process • Merge of Radius data will look like the following • Now you can do some on-line analysis using the “click and sort” columns and filters

  9. VMI Process • Clicking on “Customer QOH” column heading sorts the data by that value. Clicking again will toggle between ascending and descending order.

  10. VMI Process • Clicking on “QOH + Ship Out Date” column heading sorts the data by that value. Clicking again will toggle between ascending and descending order.

  11. VMI Process • Filters can be used to limit the data you want to see based upon selected filter criteria.

  12. VMI Process • You can download the filtered data to your PC Click Here

  13. VMI Process • You can download the filtered data to your PC

  14. VMI Process • Open the spreadsheet and start your analysis

  15. VMI Process • You can produce an Actuate summary report of the filtered data. Click Here

  16. VMI Process • Sample of the Actuate summary report.

  17. VMI Process • On-Line help is available in PDF format Click Here

  18. VMI Process • On-Line help is available in PDF format

More Related