Update/Optimize Material Order Point & Maximum values in the Parts Master

Challenge:

Would like to use Materials Automatic Re-order function in Mainsaver, but part Min/Max values are not accurate.

Solution:

A very effective tool for helping set/manage the order point and maximum on hand values is the ABC analysis tool found in the Materials Module. (Materials > Parts Master > Options > ABC Analysis Utility). This tool allows analysis that will effectively show the following:

  • Highest Valued Parts (based on part price x quantity on hand)
  • Highest and lowest usage parts for a given time period based on quantity used
  • Highest and lowest usage parts for a given time period based on value (quantity used x price)

Using this data, the Material Manager can then make better educated decisions on which parts should be stocked at higher levels (higher usage parts), and which may need to be stocked, (or not) at lower levels.
To execute the ABC part analyses, perform the following steps:

  • Navigate to Materials > Parts Master > Options > ABC Analysis Utility
  • For the Part Value Analysis, select “Cost” from the method drop down box and enter percentage values in the A/B/C percent fields to categorize the part into 3 categories. Click on the “OK” button and a report will be generated giving part values sorted from highest to lowest.
  • For the Usage Analysis, select “Usage” from the method drop down box, then enter the number of day to analyze in the “Usage Period” field. Click on “OK” and a report will be generated that shows the highest and lowest usages of parts for the time period based on quantity used.
  • For the Value & Usage Analysis, select “Cost and Usage” from the method drop down box, then enter the number of day to analyze in the “Usage Period” field. Click on “OK” and a report will be generated that shows the highest and lowest usages of parts for the time period based on quantity used x part p