Given the following information, you need to conduct an ABC analysis on the number of items sold versus the annual value of usage. of Uniti Sold 20 GE? 135 415 11.11 3223233228 LI 15 577 20 539 FC 2.46 12291 TE A10 22 FU 0.00 12.54 2.54 64 11.08 550 Note: you need to make a two-dimensional array as below and specify corresponding items for each cell. Then it would help if you discussed strategic versus non-strategic things. Then interpret and discuss the findings for each cell of the below table. For instance, what would be your suggestion regarding the B-C items? But you need to discuss all cells. Your discussion should be like a brief report to your manager. The threshold for A categories is 80%, B category is 15%, and C category is 5%. Tip: You need to open an excel file. And copy the items twice. Regarding the value analysis, you must first determine the total annual value (NO times Unit Cost) and then sort things based on the yearly value in descending order. In the second table, you need to sort the items in descending order and conduct the ABC analysis for the quantity analysis. Tip: Once you complete the ABC analysis separately for quantity and annual usage value, you complete the below table as we exercised in class. Value B B Quantity C Given the following information, you need to conduct an ABC analysis on the number of items sold versus the annual value of usage. of Uniti Sold 20 GE? 135 415 11.11 3223233228 LI 15 577 20 539 FC 2.46 12291 TE A10 22 FU 0.00 12.54 2.54 64 11.08 550 Note: you need to make a two-dimensional array as below and specify corresponding items for each cell. Then it would help if you discussed strategic versus non-strategic things. Then interpret and discuss the findings for each cell of the below table. For instance, what would be your suggestion regarding the B-C items? But you need to discuss all cells. Your discussion should be like a brief report to your manager. The threshold for A categories is 80%, B category is 15%, and C category is 5%. Tip: You need to open an excel file. And copy the items twice. Regarding the value analysis, you must first determine the total annual value (NO times Unit Cost) and then sort things based on the yearly value in descending order. In the second table, you need to sort the items in descending order and conduct the ABC analysis for the quantity analysis. Tip: Once you complete the ABC analysis separately for quantity and annual usage value, you complete the below table as we exercised in class. Value B B Quantity C
