ABC Inventory Analysis
Segment A
Segment B
Segment C
Category
Date
For Segment A, 14 Products with 70% contribution amounts to 3,422K
For Segment B, 5 Products with 20% contribution amounts to 916K
For Segment C, 4 Products with 70% contribution amounts to 639K
Products Segmentation On Sales
Products Total Sales Share in Sales Sales Segmentation
Biscuits 200.404 4.03% A
Breads & Buns 268.250 5.39% A
Cakes 217.420 4.37% A
Chocolates 259.448 5.21% A
Cookies 255.367 5.13% A
Edible Oil & Ghee 204.81 4.11% A
Eggs 203.018 4.08% A
Fish 210.452 4.23% A
Health Drinks 356.324 7.16% A
Masalas 230.869 4.66% A
Mutton 205.858 4.14% A
Noodles 257.661 5.18% A
Soft Drinks 350.604 7.04% A
Spices 201.924 4.06% A
Atta & Flour 186.976 3.76% B
Dals & Pulses 181.274 3.64% B
Fresh Fruits 185.468 3.73% B
Fresh Vegetables 180.453 3.63% B
Organic Staples 181.753 3.65% B
Chicken 137.935 2.77% C
Organic Fruits 177.666 3.57% C
Organic Vegetables 163.087 3.28% C
Total 4977.512 100%
Product Categories Contribution
Product Categories Contribution
Product Count vs Sales Amount
Segments
Segment A
Segment B
Segment C
Category
Date
For Segment A, 14 Products with 70% contribution amounts to 3,422K
For Segment B, 5 Products with 20% contribution amounts to 916K
For Segment C, 4 Products with 70% contribution amounts to 639K
Products Segmentation On Purchase
Products Total Purchase Share in Purchase Purchase Segmentation
Biscuits 200.404 4.03% A
Breads & Buns 268.250 5.39% A
Cakes 217.420 4.37% A
Chocolates 259.448 5.21% A
Cookies 255.367 5.13% A
Edible Oil & Ghee 204.81 4.11% A
Eggs 203.018 4.08% A
Fish 210.452 4.23% A
Health Drinks 356.324 7.16% A
Masalas 230.869 4.66% A
Mutton 205.858 4.14% A
Noodles 257.661 5.18% A
Soft Drinks 350.604 7.04% A
Spices 201.924 4.06% A
Atta & Flour 186.976 3.76% B
Dals & Pulses 181.274 3.64% B
Fresh Fruits 185.468 3.73% B
Fresh Vegetables 180.453 3.63% B
Organic Staples 181.753 3.65% B
Chicken 137.935 2.77% C
Organic Fruits 177.666 3.57% C
Organic Vegetables 163.087 3.28% C
Total 4977.512 100%
Product Categories Contribution
Product Categories Contribution
Product Count vs Sales Amount
Segments
Segment A
Segment B
Segment C
Category
Date
Segment A
Sales 3M
147K Purchase
Segment B
Sales 916K
39K Purchase
Segment C
Sales 639K
25K Purchase
Product Segment Comparison
Year
Products January February March April May June July August September October November December January February March April May June July August September October November December
Atta & Flour
Sales C C C C C B A C B C C A A C C A A A C A A B A B
Purchase C C C C C B A C B C C A A C C A A A C A A B A B
Biscuits
Sales C C C C C B A C B C C A A C C A A A C A A B A B
Purchase C C C C C B A C B C C A A C C A A A C A A B A B
Breads & Buns
Sales C C C C C B A C B C C A A C C A A A C A A B A B
Purchase C C C C C B A C B C C A A C C A A A C A A B A B
Cakes
Sales C C C C C B A C B C C A A C C A A A C A A B A B
Purchase C C C C C B A C B C C A A C C A A A C A A B A B
Sales and Inventroy Status
Products with Same Segments
Products without Same Segments
Products Count
Segment A
Segment B
Segment C