Use this screen to generate reports ranking parts by one of five different value/usage algorithms and optionally update the part master with these rankings. Use it before you perform a cycle count and update it on a regular basis.
Select the radio button to indicate how this report will be printed, either by ABC Class Ranking or Part.
Select the range of projects to be classified. The system-defined selections are "All," "One," "Range," "From Beginning," or "To End."
Enter, or use Lookup to select, the range of inventory projects that will be the starting and/or ending points to be ranked. The system will use only the inventory and cost values for the projects selected. We suggest that all projects be selected for ABC classification purposes.
Use this group box to determine the type of parts that will be included in the count.
Select this checkbox to include Make parts in this count. If you do not select this checkbox, Make parts will not be included.
Select this checkbox to include Buy parts in this count. If you do not select this checkbox, Buy parts will not be included.
From the drop-down box, select one of five different value/usage algorithms that will be used to rank the parts for the ABC classification:
Cost - Select this option to rank parts in descending order by cost using the option selected in the Cost Method field.
Cost * Future Demand - If you select this option, parts are ranked in descending order of their selected cost multiplied by the sum of the reserved quantities for the selected projects. If you have licensed the Master Production Scheduling module, open forecast quantities will be included in future demand calculations.
Cost * Past Usage - If you select this option, parts are ranked in descending order of their selected cost multiplied by last year's usage quantity plus the year-to-date usage quantity for the selected projects.
Cost * (Future Demand + Past Usage) - If you select this option, parts are ranked in descending order of their selected cost multiplied by the sum of the reserved quantities plus last year's usage quantity plus the year-to-date usage quantity for the selected projects. If you have licensed the Master Production Scheduling module, open forecast quantities will be included in future demand calculations.
Cost * On-Hand Inventory - If you select this option, parts are ranked in descending order of their selected cost multiplied by the current on-hand quantities for the selected projects.
From the drop-down box, select the cost method to value the parts. The available methods are "Average Actual," "Last," "Reference," and "Standard."
Average Actual - Select this method to use the weighted average cost for all inventory abbreviations for the selected projects for that part. If you selected "Acceptance" in the Inventory Recognition Point field in the Inventory Settings screen, On-Hand and Shipping quantities will be included. If you set the Inventory Recognition Point to "Receipt," all quantities except On-Hold will be included.
Last - Select this method to use the last cost of the project if only one project is selected; otherwise, the item last cost will be used.
Reference - Select this method to use the reference cost of the project if one project is selected; otherwise, the item reference cost will be used.
Standard - Select this method to use the standard cost of the project if one project is selected; otherwise, the item standard cost will be used.
Enter the percentage of the total number of parts ranked that will be classified in each category. The sum of percentages must add up to 100 percent. Any ties in rankings will be assigned to the higher ranking, but any overflow assigned to the higher ranking will be counted against the lower ranking's percentage.
You can use this screen to update the ABC codes in the parts master only if you have selected one of the checkboxes in this group box.
Select this checkbox to overwrite any non-zero count frequencies for any selected part. If you do not select this checkbox, non-zero count frequencies will not be overwritten.
Select this checkbox to overwrite any non-zero count tolerance for any selected part. If you do not select this checkbox, non-zero count tolerance will not be overwritten.
Select this button on the toolbar to update the ABC code on the parts master for the parts selected.
Select this button on the toolbar to print and update in one process.
The information that is entered in this screen and saved as a parameter is stored in the PARMS_INPPCABC table. This screen also relies on the settings in the ITEM_SETTINGS_CORP table. Information for executing ABC analyses is also stored in and/or pulled from the following tables: ABC_CLASSIF, INVT, INVT_PROJ, ITEM, ITEM_CST, ITEM_PROJ_CST, PART, PART_PROJ, PROJ, S_CST_MTHD_CD, S_ITEM_CST_TYPE, VIN_ABC.
This application utilizes the following worktables when processing data: Z_IN_ABC, Z_IN_ABC2.