AutoSave Off Hvo 2021 - MGMT-6082 - MODULE 09 - CHAPTER 12.docx - Protected View - Saved to this PC- kurian jose KU File Home Insert Draw Design Layout References Mailings Review View Help Share Comments PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X 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. 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. Post your Excel fille into the Submission box by the due date and time. 3. Part No. Unit Costs 1 2 3 4 5 6 7 8 9 Annual Unit Supplier Category Usage Piet Inc Electrical 100 Jan Inc Chemical 20 Murphy Inc. Mechanical 50 Murphy Inc. Hardware 90 Piet Inc Hardware 110 Jan Inc Hardware 120 Howard Inc. Electrical 125 Howard Inc. Electrical 150 Champ Inc Chemical 200 Scott's Inc Chemical 250 Scott's Inc Mechanical 450 Champ Inc Mechanical 550 Piet Inc Electrical 550 Champ Inc Chemical 700 Jan Inc Mechanical 90 Jan Inc Hardware 10 Murphy Inc. Hardware 1200 Piet Inc Electrical 1200 Murphy Inc. Chemical 1400 Champ Inc Mechanical 1400 10 $2.00 $80.00 $4.00 $1.00 $10.00 $25.00 $2.00 $20.00 $2.00 $1.00 $2.00 $35.00 $2.00 $1.00 $60.00 $35.00 $3.00 $3.00 $2.00 $1.00 11 12 13 14 15 16 17 18 19 20 Page 1 of 2 144 words Focus 23 + 90% 1 Type here to search > * W 2 o 5) ENG 8:55 AM 2021-03-19 59