Description
This is a presentation that has sales mix, sales-times mix, customer mix, margin mix in a retail super market.
SALES MIX
SALES MIX
IN A SUPERMARKET
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
17 18 19 20 21 22 23 24 25 26 27 28 29
CATEGORIES FOOD Grocery Oil,Ghee, Vanaspati Spices & Masala (whole / branded) Tea, Coffee Sugar & Salt Biscuits and Bakery products Farsan & Chikki BabyFood, Health Food, Health Drinks Instant, Ready to Eat Upvas items Jam, Jelly & Ketchups Confectionery Dairy Products & Frozen Food Coldrinks, Fruit Drink & Water Dry Fruits Papad, Fryums , Pickles NON FOOD Detergent and Washing Soaps Bath Soaps and Liquid Soaps Dental Care Hair Care Beauty Care Sanitary Napkins & Diapers Cleaning Material Insecticides & Repellents Shaving Aids Miscellaneous Items Talcum Powder Pooja Items Party Items
Abb.
%
GR 22.5 OI 12 MA 5 TE 5 SU 3 BI 3 FA 3 BF 3 RE 3 UP 2.5 JA 2 CF 2 DP 2 CS 2 DF 2 PA 1.5
DT SO DE HR BC SN CM IN SH MS TL PO PT
7 3 2.5 2 2 2 2 2 1.5 1 0.5 0.5 0.5
MARGIN MIX
IN A SUPERMARKET
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
CATEGORIES FOOD Grocery Oil,Ghee, Vanaspati Spices & Masala (whole / branded) Tea, Coffee Sugar & Salt Biscuits and Bakery products Farsan & Chikki BabyFood, Health Food, Health Drinks Instant, Ready to Eat Upvas items Jam, Jelly & Ketchups Confectionery Dairy Products & Frozen Food Coldrinks, Fruit Drink & Water Dry Fruits Papad, Fryums , Pickles NON FOOD Detergent and Washing Soaps Bath Soaps and Liquid Soaps Dental Care Hair Care Beauty Care Sanitary Napkins & Diapers Cleaning Material Insecticides & Repellents Shaving Aids Miscellaneous Items Talcum Powder Pooja Items Party Items
Abb. GR OI MA TE SU BI FA BF RE UP JA CF DP CS DF PA
15 to 18 4 to 8 25 to 35 10 to 15 4 to 6 10 to 12 20 to 35 8 to 15 10 to 15 10 to 18 12 to 18 12 to 15 8 to 9 10 to 12 20 to 35 12 to 15
17 18 19 20 21 22 23 24 25 26 27 28 29
DT SO DE HR BC SN CM IN SH MS TL PO PT
10 to 12 8 to 10 10 to 12 10 to 15 12 to 15 12 to 15 12 to 15 10 to 15 12 to 15 15 to 18 10 to 15 20 to 30 20 to 30
CUSTOMER MIX
IN A SUPERMARKET
Figure in Bracket % Foot fall to Total
Month Upto 5th Upto 10th Upto 15th Upto 20th Upto 25th
JUN (04) 736 (12)1s JUL (04) 1183 (16)1s AUG (04) 1183 (16)1s SEP (04) 1413 (20)1s OCT (04) 1413 NOV (04) 1261 DEC (04) 1051 JAN (05) 1831 (19)1s 2402 (17)1s 2400 (17)2s 2524 (16)1s 2631 2774 2008 2406 3044 (21)2s 3799 (19)2s 3569 (16)3s 3836 (19)2s 3726 4036 3100 3847 (14)3s 4967 (16)3s 4650 (14)3s 5185 (26)3s 4831 4846 4694 (14)3s 6114 (16)4s 5814 (15)4s 6046 (12)3s 5901 5827 5139 5620
Total
5815 (19)4s 7332 (16)4s 7417 (21)5s 7003 (12)4s 7168 6994 6375 6979
Salt Sale/Bill
415 1066 523 476 644 594 502 593 135.22 148.98 149.38 152.75 154.59 171.57 146.93 153.33
Month Upto 5th Upto 10th Upto 15th Upto 20th Upto 25th
JUN (04) JUL (04) AUG (04) SEP (04) OCT (04) NOV (04) DEC (04) JAN (05)
Total
Salt Sale/Bill
1000 1000 1000 1000 1000 1000 1000 1000 235.22 248.98 249.38 252.75 254.59 271.57 246.93 253.33
10% TO 15% OF CUSTOMER CONTRIBUTESTO 50% TO 60% OF SALE
CUSTOMER MIX
IN A SUPERMARKET
Bill Amount 250> 501> 751> 1000> 1501> 2001> 2501> 3001> Number of Percentage Sale Percentage Customers of Customers Amount of Sale 2249 24.00 1550176 63.00 1213 13.00 1176538 48.00 729 8.00 878546 36.00 396 4.00 589288 24.00 138 1.90 279122 11.00 55 0.60 139793 6.00 21 0.20 64631 3.00 9 0.10 32250 1.50
10% TO 15% OF CUSTOMER CONTRIBUTESTO 50% TO 60% OF SALE
SALES/TIME MIX
IN A SUPERMARKET
TIME Dec 9 to 10 10 to 11 11 to12 12 to 13 13 to 14 14 to 15 15 to 16 16 to 17 17 to 18 18 to 19 19 to 20 20 to 21 13287.75 43137.25 1.48 4.81 66337 55695.75 41575.75 7.39 6.20 4.63 25797.5 25228.25 44739.75 62356.75 140285.8 184276.8 194894.8 2.87 2.81 4.98 6.95 15.63 20.53 21.71
Bet 9 am to 1 pm Bet 5pm to 9 pm Bet 5pm to 9 pm
(4 Hr) (4 Hr) (4 Hr)
OCT DEC JAN_05 20.63% 19.88% 17.82 12.53% 15.30% 12.84 66.85% 64.82% 66.45
20% 15% 65%
COMPANYWISE SALES MIX
AFTER DEDUCTING GROCERY 15% TO 18 % 5% 3% TO 4% 2% 1% HLL MARICO P&G NESTLE PARLE AMUL CADBURY BRITANIA
GODREJ COLGATE ONE OIL GELLETE SATNAM AHMED ONE OIL SMITH KLINE EVEREST SUNDROP GUINEA PEPSI WIPRO (if van.) RICKETT BENK MTR SOCEITY
(+) 1/2 %
DABUR JOHNSON COKE BADSHAH TATA TEA GIRNAR DUNCAN GARNIER MDH HEINZ MORTIEN KARAMCHAND GARDEN HALDIRAM BALSARA PRIYAGOLDHINDUS QUEENS RECK-PIRAMAL MYSORE SANDAL TROPICANA VIJAYA BHARAT VVF ITC HIMALAYA
(-) 1/2 %
TOP 100 SKU
IN A SUPERMARKET
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
CATEGORIES FOOD Grocery Oil,Ghee, Vanaspati Spices & Masala (whole / branded) Tea, Coffee Sugar & Salt Biscuits and Bakery products Farsan & Chikki BabyFood, Health Food, Health Drinks Instant, Ready to Eat Upvas items Jam, Jelly & Ketchups Confectionery Dairy Products & Frozen Food Coldrinks, Fruit Drink & Water Dry Fruits Papad, Fryums , Pickles NON FOOD Detergent and Washing Soaps Bath Soaps and Liquid Soaps Dental Care Hair Care Beauty Care Sanitary Napkins & Diapers Cleaning Material Insecticides & Repellents Shaving Aids Miscellaneous Items Talcum Powder Pooja Items Party Items
Abb. GR OI MA TE SU BI FA BF RE UP JA CF DP CS DF PA
32 16 4 7 4 6 2 2 5 3 1 3
17 18 19 20 21 22 23 24 25 26 27 28 29
DT SO DE HR BC SN CM IN SH MS TL PO PT
16 2 2 2 1 4 1 1
MARGIN = S.P. – C.P. X 100 S.P. MARK UP = S.P. – C.P. X 100 C.P. MARK UP = MRP 1.XX MARK UP of HLL (LUX) Soap = 8 % if MRP is Rs 19/MARK UP = Rs 19 = Rs 17.59 1.08
MARK–UP STRUCTURE
Sr 1 Company HLL Product Name All Soap & Detergent (Except Breeze & Jay ) Almost All Product / Product Categories Such As Face Creams Lotions Deodorants, All Food Product ( In Tea,It Is Less 5%) Kotex. 2 Nestle Ghee. Yoghurt Milk,Baby Food, Coffee & milo. Butter . Cheese. Noodles Ketch-Up, Chocolates,Munch,Fox. Curds, Fruit & drink. Speciality And Impported Item. Creame Mark-Up 8% 10% 15% 4% 6.50% 9% 9.50% 10% 11.50% 12% 19% 8% 6% 5% 8.50% 9% 12% 20%
3
Amul (GCMMF) Dhara Edible oil. Ghee. Butter . Cheese. Dahi, Milk. All Ice Creames (Except a Particular One)
MARK–UP STRUCTURE
4 Marico All Edible Oil (Sweekar, Saffola) All Sizes of Parachute Oil Sil, Mixed Jam Hiar & Care , Hair Oil, Revive Starch Sil All Product Drinking Chocolates Bournvita All Chocolates Costing Rs.1/- to Rs.15/Top Reman All Chocolates Costing Rs.16/Éclair Soaps All Tooth Powder/Past & Tooth Brush (Tooth Brushes Have Always Big Schemes) Shaving Cream. After Shave Lotion. All Tea All Soap & Detergent All Shampoo. All Sanitary, Napkins On All Shoe Polish & Bilcream All Blades / Resers Batterise Tooth Brush 5% 8.50% 9% 10% 7.50% 9% 10% 11% 14% 15% 7.50% 10% 12% 15% 5 Cadbury
6
Colgate
7 8
Society Tea P&G
6% 8% 11% 15% 8% 12% 15% 17%
9 10
T.T.K Gillet
doc_988870618.ppt
This is a presentation that has sales mix, sales-times mix, customer mix, margin mix in a retail super market.
SALES MIX
SALES MIX
IN A SUPERMARKET
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
17 18 19 20 21 22 23 24 25 26 27 28 29
CATEGORIES FOOD Grocery Oil,Ghee, Vanaspati Spices & Masala (whole / branded) Tea, Coffee Sugar & Salt Biscuits and Bakery products Farsan & Chikki BabyFood, Health Food, Health Drinks Instant, Ready to Eat Upvas items Jam, Jelly & Ketchups Confectionery Dairy Products & Frozen Food Coldrinks, Fruit Drink & Water Dry Fruits Papad, Fryums , Pickles NON FOOD Detergent and Washing Soaps Bath Soaps and Liquid Soaps Dental Care Hair Care Beauty Care Sanitary Napkins & Diapers Cleaning Material Insecticides & Repellents Shaving Aids Miscellaneous Items Talcum Powder Pooja Items Party Items
Abb.
%
GR 22.5 OI 12 MA 5 TE 5 SU 3 BI 3 FA 3 BF 3 RE 3 UP 2.5 JA 2 CF 2 DP 2 CS 2 DF 2 PA 1.5
DT SO DE HR BC SN CM IN SH MS TL PO PT
7 3 2.5 2 2 2 2 2 1.5 1 0.5 0.5 0.5
MARGIN MIX
IN A SUPERMARKET
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
CATEGORIES FOOD Grocery Oil,Ghee, Vanaspati Spices & Masala (whole / branded) Tea, Coffee Sugar & Salt Biscuits and Bakery products Farsan & Chikki BabyFood, Health Food, Health Drinks Instant, Ready to Eat Upvas items Jam, Jelly & Ketchups Confectionery Dairy Products & Frozen Food Coldrinks, Fruit Drink & Water Dry Fruits Papad, Fryums , Pickles NON FOOD Detergent and Washing Soaps Bath Soaps and Liquid Soaps Dental Care Hair Care Beauty Care Sanitary Napkins & Diapers Cleaning Material Insecticides & Repellents Shaving Aids Miscellaneous Items Talcum Powder Pooja Items Party Items
Abb. GR OI MA TE SU BI FA BF RE UP JA CF DP CS DF PA
15 to 18 4 to 8 25 to 35 10 to 15 4 to 6 10 to 12 20 to 35 8 to 15 10 to 15 10 to 18 12 to 18 12 to 15 8 to 9 10 to 12 20 to 35 12 to 15
17 18 19 20 21 22 23 24 25 26 27 28 29
DT SO DE HR BC SN CM IN SH MS TL PO PT
10 to 12 8 to 10 10 to 12 10 to 15 12 to 15 12 to 15 12 to 15 10 to 15 12 to 15 15 to 18 10 to 15 20 to 30 20 to 30
CUSTOMER MIX
IN A SUPERMARKET
Figure in Bracket % Foot fall to Total
Month Upto 5th Upto 10th Upto 15th Upto 20th Upto 25th
JUN (04) 736 (12)1s JUL (04) 1183 (16)1s AUG (04) 1183 (16)1s SEP (04) 1413 (20)1s OCT (04) 1413 NOV (04) 1261 DEC (04) 1051 JAN (05) 1831 (19)1s 2402 (17)1s 2400 (17)2s 2524 (16)1s 2631 2774 2008 2406 3044 (21)2s 3799 (19)2s 3569 (16)3s 3836 (19)2s 3726 4036 3100 3847 (14)3s 4967 (16)3s 4650 (14)3s 5185 (26)3s 4831 4846 4694 (14)3s 6114 (16)4s 5814 (15)4s 6046 (12)3s 5901 5827 5139 5620
Total
5815 (19)4s 7332 (16)4s 7417 (21)5s 7003 (12)4s 7168 6994 6375 6979
Salt Sale/Bill
415 1066 523 476 644 594 502 593 135.22 148.98 149.38 152.75 154.59 171.57 146.93 153.33
Month Upto 5th Upto 10th Upto 15th Upto 20th Upto 25th
JUN (04) JUL (04) AUG (04) SEP (04) OCT (04) NOV (04) DEC (04) JAN (05)
Total
Salt Sale/Bill
1000 1000 1000 1000 1000 1000 1000 1000 235.22 248.98 249.38 252.75 254.59 271.57 246.93 253.33
10% TO 15% OF CUSTOMER CONTRIBUTESTO 50% TO 60% OF SALE
CUSTOMER MIX
IN A SUPERMARKET
Bill Amount 250> 501> 751> 1000> 1501> 2001> 2501> 3001> Number of Percentage Sale Percentage Customers of Customers Amount of Sale 2249 24.00 1550176 63.00 1213 13.00 1176538 48.00 729 8.00 878546 36.00 396 4.00 589288 24.00 138 1.90 279122 11.00 55 0.60 139793 6.00 21 0.20 64631 3.00 9 0.10 32250 1.50
10% TO 15% OF CUSTOMER CONTRIBUTESTO 50% TO 60% OF SALE
SALES/TIME MIX
IN A SUPERMARKET
TIME Dec 9 to 10 10 to 11 11 to12 12 to 13 13 to 14 14 to 15 15 to 16 16 to 17 17 to 18 18 to 19 19 to 20 20 to 21 13287.75 43137.25 1.48 4.81 66337 55695.75 41575.75 7.39 6.20 4.63 25797.5 25228.25 44739.75 62356.75 140285.8 184276.8 194894.8 2.87 2.81 4.98 6.95 15.63 20.53 21.71
Bet 9 am to 1 pm Bet 5pm to 9 pm Bet 5pm to 9 pm
(4 Hr) (4 Hr) (4 Hr)
OCT DEC JAN_05 20.63% 19.88% 17.82 12.53% 15.30% 12.84 66.85% 64.82% 66.45
20% 15% 65%
COMPANYWISE SALES MIX
AFTER DEDUCTING GROCERY 15% TO 18 % 5% 3% TO 4% 2% 1% HLL MARICO P&G NESTLE PARLE AMUL CADBURY BRITANIA
GODREJ COLGATE ONE OIL GELLETE SATNAM AHMED ONE OIL SMITH KLINE EVEREST SUNDROP GUINEA PEPSI WIPRO (if van.) RICKETT BENK MTR SOCEITY
(+) 1/2 %
DABUR JOHNSON COKE BADSHAH TATA TEA GIRNAR DUNCAN GARNIER MDH HEINZ MORTIEN KARAMCHAND GARDEN HALDIRAM BALSARA PRIYAGOLDHINDUS QUEENS RECK-PIRAMAL MYSORE SANDAL TROPICANA VIJAYA BHARAT VVF ITC HIMALAYA
(-) 1/2 %
TOP 100 SKU
IN A SUPERMARKET
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
CATEGORIES FOOD Grocery Oil,Ghee, Vanaspati Spices & Masala (whole / branded) Tea, Coffee Sugar & Salt Biscuits and Bakery products Farsan & Chikki BabyFood, Health Food, Health Drinks Instant, Ready to Eat Upvas items Jam, Jelly & Ketchups Confectionery Dairy Products & Frozen Food Coldrinks, Fruit Drink & Water Dry Fruits Papad, Fryums , Pickles NON FOOD Detergent and Washing Soaps Bath Soaps and Liquid Soaps Dental Care Hair Care Beauty Care Sanitary Napkins & Diapers Cleaning Material Insecticides & Repellents Shaving Aids Miscellaneous Items Talcum Powder Pooja Items Party Items
Abb. GR OI MA TE SU BI FA BF RE UP JA CF DP CS DF PA
32 16 4 7 4 6 2 2 5 3 1 3
17 18 19 20 21 22 23 24 25 26 27 28 29
DT SO DE HR BC SN CM IN SH MS TL PO PT
16 2 2 2 1 4 1 1
MARGIN = S.P. – C.P. X 100 S.P. MARK UP = S.P. – C.P. X 100 C.P. MARK UP = MRP 1.XX MARK UP of HLL (LUX) Soap = 8 % if MRP is Rs 19/MARK UP = Rs 19 = Rs 17.59 1.08
MARK–UP STRUCTURE
Sr 1 Company HLL Product Name All Soap & Detergent (Except Breeze & Jay ) Almost All Product / Product Categories Such As Face Creams Lotions Deodorants, All Food Product ( In Tea,It Is Less 5%) Kotex. 2 Nestle Ghee. Yoghurt Milk,Baby Food, Coffee & milo. Butter . Cheese. Noodles Ketch-Up, Chocolates,Munch,Fox. Curds, Fruit & drink. Speciality And Impported Item. Creame Mark-Up 8% 10% 15% 4% 6.50% 9% 9.50% 10% 11.50% 12% 19% 8% 6% 5% 8.50% 9% 12% 20%
3
Amul (GCMMF) Dhara Edible oil. Ghee. Butter . Cheese. Dahi, Milk. All Ice Creames (Except a Particular One)
MARK–UP STRUCTURE
4 Marico All Edible Oil (Sweekar, Saffola) All Sizes of Parachute Oil Sil, Mixed Jam Hiar & Care , Hair Oil, Revive Starch Sil All Product Drinking Chocolates Bournvita All Chocolates Costing Rs.1/- to Rs.15/Top Reman All Chocolates Costing Rs.16/Éclair Soaps All Tooth Powder/Past & Tooth Brush (Tooth Brushes Have Always Big Schemes) Shaving Cream. After Shave Lotion. All Tea All Soap & Detergent All Shampoo. All Sanitary, Napkins On All Shoe Polish & Bilcream All Blades / Resers Batterise Tooth Brush 5% 8.50% 9% 10% 7.50% 9% 10% 11% 14% 15% 7.50% 10% 12% 15% 5 Cadbury
6
Colgate
7 8
Society Tea P&G
6% 8% 11% 15% 8% 12% 15% 17%
9 10
T.T.K Gillet
doc_988870618.ppt