Sheets AcademySheets Academy
Premium
Task #72

ABC analysis of products

ABC analysis splits products into three classes by their contribution to revenue: class A brings in the first 80% of revenue, B the next 15%, and C the remaining 5%. The products are already sorted by revenue.

  1. In C2:C16, calculate each product's share of total revenue.
  2. In D2:D16, calculate the cumulative share: the sum of shares from the first product down to the current one.
  3. In E2:E16, show the class: A if the cumulative share is at most 80%, B if it is at most 95%, otherwise C.
Task #72
ABC analysis of products

ABC analysis splits products into three classes by their contribution to revenue: class A brings in the first 80% of revenue, B the next 15%, and C the remaining 5%. The products are already sorted by revenue.

  1. In C2:C16, calculate each product's share of total revenue.
  2. In D2:D16, calculate the cumulative share: the sum of shares from the first product down to the current one.
  3. In E2:E16, show the class: A if the cumulative share is at most 80%, B if it is at most 95%, otherwise C.