Title: Applying the 80/20 Rule (Pareto’s Rule) to ABC Classification in Inventory Management: A Case Study of a Small Local Store

Use the 80/20 rule (Paretos’s Rule) to calculate ABC classification. The idea is that you identify 20% of the products that generate 80% of the revenue.
Watch the video below on ABC Analysis in Excel.

Look at the example on page 96 (Figures 5.4 and 5.5) in the Benton 4th edition textbook.
Use the data points provided in the attached Excel file to calculate the following:
Annual Usage – Cumulative Ratio of Annual Usage (%) – Cumulative Ratio of Usage Value (%) and ABC classification.
Part B:
Now that you know how to calculate ABC analysis, go to any small local store and examine the inventory. In your opinion, decide which 10 items sold there would constitute 80% of the revenue for this store.
Requirements
Part A: Excel file with ABC analysis using formulas in the formula bar
ABC Analysis Video
Part B: Word document with the local store assignment, with the name of the store listed. Write this document in APA format, including a cover page and reference page.