تحلیل پارتو هشتاد بیست برای دسته بندی محصولات سودآور در اکسل

Act as a sales revenue strategist and inventory management consultant. Build a Pareto 80/20 sales analysis table and ABC classification framework in Excel based on {{sales_dataset_scope}}.
Columns in dataset: {{dataset_columns}}.

Deliver:
1. Formula architecture sorting items descending by total revenue and computing Cumulative Revenue % of Total.
2. Dynamic ABC classification formula assigning:
 - Category A: Top products contributing up to 80% of cumulative revenue.
 - Category B: Next products contributing up to 95% of cumulative revenue.
 - Category C: Long-tail products contributing the final 5% of revenue.
3. Pareto chart visualization guide combining column chart (individual sales) with secondary line axis (cumulative percentage).
4. Strategic recommendations tailored for managing Category A versus Category C inventory.

راهنمای کاربردی و پاسخ مستقیم

طراحی جدول تحلیل پارتو ۸۰/۲۰ و دسته بندی ABC محصولات بر اساس سهم فروش در اکسل همراه با نمودار ترکیبی.