3. The NextGen distribution is working on improving inventory management by performing an ABC Analysis. The management team considers the following factors for the analysis: revenue, hits, and criticality to operations. One of your colleague finished the initial ABC analysis for revenue and hits, and the criticality to operations has been calculated using the Analytical Hierarchy Process (AHP) by an outside consultant. Criticality needs to be ranked based on absolute ranking (A items are those with criticality point of 225 or higher, Citems have criticality point of less than 99, the rest are B items. Your task is to complete the ABC analysis for the criticality and then determine the final ABC rankings for products using relative ranking. A items = top 60%, B items = next 25%, C items are the remaining ones. In addition, the management would you like to use 1.6, 0.2, and 0.5 as weights for revenue, hits, and criticality respectively. For the final ABC analysis, assume A is 3, B is 2, and C is 1 point. (Use three decimal place accuracy for ratio and cumulative ratio calculations when needed, e.g., 0.123) a. Perform ABC Analysis for criticality (5 Points) b. Perform the final ABC Analysis by combining revenue, hits, and criticality. (25 Points) Item Revenue Hits Criticality H A C 176 C 135 N C 3 A B 720 4 C C 100 UT B A 250 C 60 B 11 CO A 190 9 A C 145 10 B C 40