Excessive Parts Report
Note: This report utilizes the reorder information in the part master screen MPM or 5111 and the Standard Reorder point setting in SSP or 8117 Line# 22. If you don't have valid reorder information or are using the Calculated method the suggested quantities will not calculate correctly.
This report prints a list of parts that exceed the suggested inventory quantity, which is calculated by using the reorder, point and reorder quantity information in the parts master screen. It also pulls parts over a user inputted "excess" dollar amount. You will be prompted to select the facility, part number range and an x factor for the excess amount.
This report can be used to help reduce overhead and streamline the parts inventory or it can be used to identify parts that may have reorder points set wrong in the part file.
Prints the following:
Report is sorted by: Bin location and part number
Average Year Usage
Suggested on hand quantity (reorder point minus 1 plus reorder quantity)
Inventory value (on hand times average price)
Difference (On hand minus suggested quantity)
Grand Totals: On Inventory value and Excess value