Table Structure: T2 (Client, Cur_Money, Total_Money, Level
Schedule (II) XX Month Customer ABC Analysis Table
Customer sales accumulation sales amount Level customer sales Accumulated sales amount level number name amount Name amount Push 131,000 131,000 a United 18,000 813,000 B S thinking 66,00 197,000 A Fengxiang 17,000 830,000 B Zhuying 54,000 251,000 A Yuan Tai 17,000 847,000 B seven round 48,000 299,000 A Cunde 16,000 863,000 B too Chang 44,000 343,000 A Gimcheon 16,000 879,000 B-rich word 39,000 382,000 A Jialiang 16,000 895,000 C even glory 37,000 419,000 A good homes 15,000 910,000 C East 34,000 453,000 A Dexing Manulife 28,000 481,000 15,000 925,000 C a new 13,000 938,000 C culture 28,000 509,000 a Cheung Tak 11,000 949,000 C East Market 27,000 536,000 a-margin 11,000 960,000 C Man Kee 27,000 563,000 a Rueilong 10,000 970,000 C Shun Cheong central 26,000 589,000 B 10,000 980,000 C Li yuan 26,000 615,000 B one into 10,000 990,000 C being issued 25,000 640,000 B Hitomi 10,000 1,000,000 C-jen record 25,000 665,000 B Yongchang 9,000 1,009,000 C Beipu 24,000 689,000 B Santai 8,000 1,017,000 C Sunbeam 22,000 711,000 B Taisho 6,000 1,023,000 C Ka and the new 21,000 732,000 B Taiping 6,000 1,029,000 C Daishin 21,000 753,000 B 10,000 1,035,000 C Taichang 21,000 774,000 B Rongrong 5,000 1,040,000 c believe 21,000 795,000 B
ABC customer analysis description:
(1) Align customers in order of performance.
(2) Accumulate the amount of all customers.
(3) The cumulative total amount is called a Class A customer within 55%.
At 55% - 85% of customers called B customers.
At 85% -100% of customers called Class C customers.
(4) In theory, the most standard type is: "Class A customers: B customer: Class C customers" ratio = "Class A customer: B customer: C customers" family ratio is also The same is 55%: 30%: 15% = 55%: 30%: 15%
In this standard type, that is: each customer's purchase amount is the same. Therefore, the highest efficiency is the smallest.
