INFO 210-Your manager asks you to perform ABC
June 7th, 2024
Need to understand the formulas used for this question in a Excel file please ———Your manager asks you to perform ABC Analysis to increase the efficiency of your company. He provides following data related to hits and total profit for each item; then asks an analysis based on combination of hits and total profit. Perform ABC Analysis for your company with A items = top 55%, B items = next 30%, C items are the remaining ones. Manager believes that profit made from a product is three times more important hits of the product. (Assume , , and )Need the EXCEL file with formulas to understand the answer pls..!ITEMHitsTotal Profit11336023057535140047725567520610545071015008153509368001016125