Answer this Please and youll get like sure shot..

Please don't give wrong amswer...

From the data in the attached spreadsheet please conduct an ABC Analysis (Also referred to as Pareto or Spend Analysis) on the data by category. Please use Excel to do all of the calculations - do not type in numbers. See the virtual in class example in Module 4. Requirements: 1. Complete the following in Excel ABC Analysis by Category 2 in 2 to 4 sentences describe what the analysis is telling us and what would you recommendation on minimizing the number of suppliers, based on your analysis. Also, ensure you cite all references. Ensure your name is in the file name: 3. Post your Excel file into the Submission box by the due date and time. Annual Unit Part No. Supplier Category Unit Costs Usage 1 Piet Inc Electrical 100 $2.00 2 Jan Inc Chemical 20 $80.00 3 Murphy Inc. Mechanical 50 $4.00 4 Murphy Inc. Hardware 90 $1.00 5 Piet Inc Hardware 110 $10.00 6 Jan Inc Hardware 120 $25.00 7 Howard Inc. Electrical 125 $2.00 8 Howard Inc. Electrical 150 $20.00 9 Champ Inc Chemical 200 $2.00 10 Scott's Inc Chemical 250 $1.00 11 Scott's Inc Mechanical 450 $2.00 12 Champ Inc Mechanical 550 $35.00 13 Piet Inc Electrical 550 $2.00 14 Champ Inc Chemical 700 $1.00 15 Jan Inc Mechanical 90 $60.00 16 Jan Inc Hardware 10 $35.00 17 Murphy Inc. Hardware 1200 $3.00 18 Piet Inc Electrical 1200 $3.00 19 Murphy Inc. Chemical 1400 $2.00 20 Champ Inc Mechanical 1400 $1.00 Marking Scheme: Details Total Excel Analysis & spreadsheets interpretation 6 Score: 10