ABC Analysis : Step-by-Step Tutorial in Excel with 500 products

Download my ABC Analysis Excel file here: https://abcsupplychain.com/download-e...

Join my next Supply Chain KPIs Workshop (free): https://abcsupplychain.com/webinar-sc...

►Introduction ABC Analysis:
00:00 Introduction
00:21 What is ABC Analysis ? Pareto's law and 20/80 rule
02:16 How to use ABC Analysis ?
04:21 ABC Analysis example to optimize your Inventory Management

►Excel Step-by-Step tutorial:
6:39 Items Status and Product Portfolio
7:21 Quantity or Value Classification ?
8:23 Sales history or Sales Forecast ?
9:00 Which period to use ?
10:30 Pivot Table creation
12:16 Product Ranking
13:28 Cumulative Percentage of Items
13:58 Cumulative Percentage of Revenues
15:00 ABC Classification per item
17:45 Graph creation
19:03 Update the classification with new values
20:36 Why ABC Analysis is not enough


▬▬▬▬▬▬▬▬▬▬▬▬▬▬ LINKS ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

TOOLS & EXCEL (free): https://abcsupplychain.com/en/tools-e...

MY BLOG: https://abcsupplychain.com

#supplychain #logistics #abcanalysis #inventoryabc #inventorymanagement