Question: Please provide Pareto chart in excel and excel file for solution as well 1. Develop ABC classification/grouping for the below item numbers using excel file.

Please provide Pareto chart in excel and excel file for solution as well
1. Develop ABC classification/grouping for the below item numbers using excel file. 2. Also, develop a pareto chart using excel file.(50 points) 3. You may upload the excel file. Item Annual Number 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,500Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
