Question: how to do abc analysis on 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.