Develop ABC classification/grouping for the below item numbers using an excel file.(50 Points)
Also, develop a Pareto chart using an excel file. (50 Points)
You may upload the excel file.
Item Number Annual Spend
3 $ 22,500
19 $ 1,200
22 $ 142,500
23 $ 638
27 $ 37,500
36 $ 2,250
41 $ 338
54 $ 11,250
68 $ 112,500
82 $ 19,500