Perform the ABC (80-20 Curve) Analysis and find the mismatches between USAGE and INVENTORY for a list of products using the data in the "Q1" worksheet of the attached Excel file (1E341-HW1.xlsx). Complete the "Q1" worksheet including the classifications based on USAGE and INVENTORY, Pareto charts for the two classifications, and the list of mismatch observations for each item. Show all your work clearly with the use of proper formulas and explanatory labels. B E N 1 2 4 A B D 1 Item Unit Cost ($) Annual Usage Physical Inventory 56 1.000 11.000 3 2. 17 3.000 200 3 1,25 8.000 1.000 4. 6 1.500 14.000 6 23 2.000 500 7 142 500 8.000 7 7 9.000 10.000 9 8 0,5 8.000 2.000 10 9 11 2.000 500 11 10 4 3.500 400 12 11 6 4.500 800 13 12 1,5 12.000 6.000 14 6 8 LD 00 1 1 1 15