Question: how to do abc analysis of inventory in excel?
Answer: Arrange the inventory data in Excel. ... , Calculate extra columns needed for ABC classification. ... , Create Inventory Distribution Chart. ... , Set up ABC classification thresholds. ... , Add the ABC items & % total cost columns to chart. ... , Add Error bars to the ABC markers to get boxes.