ABC Analysis

ABC Analysis

Are you having trouble streamlining your invetory management processes? Get the most out of Dhyey’s ABC Analysis Add-On

  • Rank items based on Revenue, Gross Profit & Inventory Value
  • Demonstrate data using Graph & Pie Chart
  • Update item card and stock keeping unit card

Now available on Microsoft App Source

Contact Us for a Free Digital Transformation Assessment

    Key Features of ABC Analysis :

    • ABC analysis ranks items based on three models: Revenue, Gross Profit, Inventory Value (COGS).
    • Detailed statistics of calculated values for each ABC model in total amount, count and percentage values for classified items, revenue generated, gross profit earned, inventory valuation of demand/consumption.
    • Graph and Pie chart demonstrates data of amount and % of Total amount, count and % total items for each class individually and cumulative totals.
    • Preview calculation sheet along with statistics either on-screen or download in Excel format to analyze and confirm before update Item card and SKU.
    • Update Item card and Stock keeping unit card with ABC class obtained for each model (separate field for each ABC classification: Revenue, Gross profit and Value/COGS) ) and Warehouse physical inventory counting period code values.
    • Configurable setup to define criteria and percentage for each model and class with accumulation period of calculation.
    • Setup whether to update Warehouse physical inventory counting period code in Item and SKU card, useful for physical counting process.
    • Run ABC calculation for selected date period.
    • Permission setup to setup user rights.
    • MIS: Statistics with Graphs, ABC Analysis Review, item and Item Category wise review, Unclassified Items.

    Find out about our product demo, call us at (+91) 960 111 3407 or chat with us

    Product Capabilities

    Key Outcome

    Gross Profit
    Inventory Value
    Historical data
    Define criteria
    Setup user rights

    On Microsoft Platform

    Microsoft Dynamics 365 Business Central
    Power Apps
    Power Automate
    Power BI
    AI Builder


    Machine Manufacture
    High-tech Electrical Manufacturing



    Streamline your Inventory Management Process

    Dhyey’s ABC Analysis Add-On offers a ranking system for items based on three different models: Revenue, Gross Profit, and Inventory Value (COGS). The Revenue model calculates and assigns a class to items based on the proportion of their revenue compared to the total sales amount during a specified period.The Gross Profit model calculates and assigns a class to items based on the gross profit generated from the quantity invoiced during a specified period. This is determined by subtracting the cost amount (COGS) from the sales amount. The Value/COGS model calculates and assigns a class to items based on the unit cost multiplied by the total quantity consumed (either in production or sold) during a specified period.

    Additionally, this add-on provides detailed statistics for each ABC model, including the total amount, count, and percentage values for classified items. It also provides information on the revenue generated, gross profit earned, and inventory valuation of demand/consumption. Moreover, the best part is that it can be seamlessly integrated with Microsoft Dynamics 365 Business Central.

    Visualize your Data Effectively

    With Dhyey’s  ABC Analysis Add-On, you can easily demonstrate and visualize the data using graphs and pie charts, showcasing the amount and percentage of the total amount, count, and percentage of total items for each individual class, as well as cumulative totals.To ensure accuracy and facilitate analysis, you have the option to preview the calculation sheet on-screen or download it in Excel format. This allows you to thoroughly examine and verify the results before updating the Item card and Stock Keeping Unit (SKU) information.

    Moreover, this add-on enables you to update the Item card and SKU with the corresponding ABC class obtained from each model. Separate fields are available for each ABC classification, including Revenue, Gross Profit, and Value/COGS. Additionally, you can incorporate the Warehouse physical inventory counting period code values into the system.

    Manage your Data Seamlessly

    Dhyey’s ABC Analysis Add-On provides a range of valuable features for inventory management. It allows you to maintain a history of calculated data for each ABC model until the next cycle. You can configure criteria and percentages for models and classes, set accumulation periods, and update Warehouse physical inventory counting codes. The add-on offers last updated date information, allows calculations for specific periods, and includes permission setup. You can access statistics with graphs, review ABC analysis, and identify unclassified items. This comprehensive tool optimizes inventory management and operational efficiency.

    Leading Microsoft Partner in Gujarat

    As a leading Microsoft Partner with over 15 years of experience in Technology Consulting, we at Dhyey Consulting strongly believe in facilitating a holistic and unified “Digital Transformation” for all our clients and partners. We are proud to be able to offer our clients a wide range of services and products that can help them take their businesses to the next level. Whether it’s implementing new ERP systems, migrating to the cloud, or simply streamlining their current processes, we are confident that we can help them achieve their goals.

    Culture of Innovation

    At Dhyey, we foster a culture of Innovation & adhere to the philosophy of “Identify, Innovate & Implement.” Following Microsoft’s vision of democratizing software & technology capabilities, we have developed a wide-range of Add-On solutions like ABC Analysis that not only complement but also seamlessly integrates with modern ERP solutions like Dynamics 365 Business Central.

    Seamless Customer Experience

    At Dhyey Consulting, we believe in creating a seamless customer experience and increasing customer engagement using technology and innovation. Our team of Techno-Functional Consultants are highly skilled and knowledgeable, and provide our clients with round-the-clock support. This way, our clients can focus on what they do best, while we take care of the technical details.

    Arrange one-to-one demo of our product

    Detailed demo would help you to see
    right feature based on your use case.

      Don’t just take our word for it

      Read Some of the Feedback

      We’re excited to announce that we recently migrated our solution to a more modern solution. We wanted to share how this project came about and how we were able to make it happen with a minimal amount of disruption to our customers. We really appreciate Dhyey’s technical team for smooth transition.

      Mr. Hymish Kharag - Director, Pharm-Assay Inc.

      We completed upgrade from legacy to latest version in our organization. And I have learned that it is a process. First of all, Nilesh & Dhyey team identified process gaps. And then together, we remove process gaps. Thats how entire team achieved revamped process.

      Mr. Broudy - President at CK

      Our key challenge during transition from Dynamics AX to D365 Finance was “Data upgrade”, we asked Dhyey to bring historical data from legacy to modern. Team dhyey knows the steps and get the job done. Our newer version gives us many more feature to implement to enhance solution. Latest solution also enable Power BI reporting.

      Poul J. - Director at BCG foods