IM0700 Inventory Management ABC Analysis Reports

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 sug­gested 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

      • AP1200 Accounts Payable Vendor Analysis Report

        Vendor Analysis Report Application Overview The Vendor Analysis Report provides up-to-date information on the cost of doing business with your vendors. It can be used as the basis for negotiating future contracts, or comparing the total amounts paid ...
      • AP1500 Accounts Payable Job Analysis Report

        Job Analysis Report Application Overview A Job Analysis Report can give you the capability to trade expenses that are being billed. When an invoice is entered into the Accounts Payable package, the invoice amount can be distributed among the ...
      • Feature - Added Product Category Selection Range to ABC Analysis Reports

        Release date: 9/14/18 Added product category selection criteria range to I/M -> Reports -> ABC Analysis Reports. Reports affected: by YTD Usage by YTD Sales by YTD Cost by YTD Margin See sample screen below: The purpose of this enhancement is to ...
      • ARSAMENU Accounts Receivable Sales Analysis Report

        Sales Analysis Report Application Overview There are six Sales Analysis reports that you can obtain. They are the Sales Analysis by Customer Report, Sales Analysis by Customer Type, Sales Analysis by Sales Volume Report, Sales Analysis by Salesman ...
      • ARJBASCN Accounts Receivable Job Analysis Report

        Job Analysis Report Application Overview A job is a particular project or activity for which expenses are being tracked or sales are being billed to. When a sales transaction is entered into the Accounts Receivable package, the sales transaction ...