IM0700 Inventory Management ABC Analysis Reports
ABC Analysis Reports
Application Overview
The ABC Analysis Reports application allows you to print a report that shows the inventory in descending order by year‑to‑date usage dollar cost, year-to-date sales dollars, usage dollar cost year‑to‑date, or year-to-date dollar margin (dollar sales ‑ dollar cost). The report also categorizes the items according to percentage figures you enter for inventory classes A, B and C. As an option, you may have the inventory classes in your Inventory Item File set according to the results of this report.
At the end of the report, a summary is printed according to the suggested inventory classes calculated based on your entered percentages.
Run Instructions
Select ABC Analysis Reports from the pull down I/M Reports window. The following screen will then be displayed:
ABC Analysis Report Entry Screen
The following options are available:
- Select the desired mode from the Abc Analysis Reports menu bar
- Enter the data requested on the screen
To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.
Entry Field Descriptions
Name | Type and Description |
1. Percent in Class A | 3 numeric digits. Enter the percentage of the total inventory value that is to be included in each inventory class. These three fields must total 100. The default value is A=80. |
2. Percent in Class B | 3 numeric digits. Enter the percentage of the total inventory value that is to be included in each inventory class. These three fields must total 100. The default value is B=15. |
3. Percent in Class C | 3 numeric digits Enter the percentage of the total inventory value that is to be included in each inventory class. These three fields must total 100. The default value is C=5. |
4. Set Up Inventory Classes ? | Y or N. If Y is entered, the Inventory Class field in the Inventory Item File will be set to the class determined by the above-entered percentages. |
5. Starting Item No | 15 alphanumeric characters. Enter the starting item number for the range of items to be printed. Defaults to All. |
6. Ending Item No | 15 alphanumeric characters. Enter the ending item number for the above range. Defaults to starting item number. |
ABC Analysis Report By YTD Usage
ABC Analysis Report By YTD Sales
ABC Analysis Report By YTD Cost
ABC Analysis Report By YTD Margin
Related Articles
IM0000 Inventory Management Package Overview 3
Reports Usage Exceptions Report Allows you to choose a particular inventory class (A, B, or C), which is defined and entered in Item File Maintenance, and to have a report printed for that class showing all items which have varied from the forecast ...IM03S1 Inventory Management Usage Exception Reports
Reports Usage Exception Reports Application Overview It is often valuable to know which items in an inventory are experieSncing exceptional usage, either much greater, or much less than the forecast usage. The Usage Exceptions Report application ...IM0000 Inventory Management Package Overview: Index
Due to the size of the document entitled "IM0000 Inventory Management Package Overview," we have separated it into several sections within the Knowledge Base. Listed below is an index listing topics contained in each section, as well as a link to ...IM0000 Inventory Management Package Overview 6
Global Setup Application Overview The Inventory Management module has many features and options that not all companies may need. Rather than set these up by default, we give you the option of “Pick & Choose” that which can increase your functionality ...IMCHGBIN Inventory Management Change Bin No/Pick Seq
Change Bin No/Pick Seq Application Overview The Change Bin No/Pick Seq application allows the user to quickly and easily change the Bin Number/Picking Sequence field in the Item File. This corresponds to field 19 in Item Maintenance. Run Instructions ...