Scribd
Upload
38 views2 pages

Delhi Pasand Rice Pricing Analysis

The document provides sales data for Store A, B, and C including MRP, store price, and sales quantities for various Basmati rice products. As the manager of Store A, you need to improve your rice assortment. You identify the following strategies: 1) Reduce the price of items 1, 6, 10, 11, 16, 18, and 19 to improve sales. 2) Increase stock of items 3, 5, 7, 12, 13, 15, and 18 which are selling well but often out of stock. 3) Remove underperforming items 14 and 17 which have very low sales. 4) Add new items 20, 21, 23, 24, and

Uploaded by

No name
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
38 views2 pages

Delhi Pasand Rice Pricing Analysis

The document provides sales data for Store A, B, and C including MRP, store price, and sales quantities for various Basmati rice products. As the manager of Store A, you need to improve your rice assortment. You identify the following strategies: 1) Reduce the price of items 1, 6, 10, 11, 16, 18, and 19 to improve sales. 2) Increase stock of items 3, 5, 7, 12, 13, 15, and 18 which are selling well but often out of stock. 3) Remove underperforming items 14 and 17 which have very low sales. 4) Add new items 20, 21, 23, 24, and

Uploaded by

No name
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

Given below are the MRP, Store price and Sales quantities for 3 stores – A, B and C.

These stores are in the same catchment area. You are the
manager of Store A. Store B and Store C are your 2 major competitors. How will you improve the assortment of Basmati rice for your store.
Store A Store B Store C

Sr. Sales Sales Sales


No Article Desc MRP Price Quantity Price Quantity Price Quantity
1 AMIRA GL DAY TO DAY BASMATI RICE 1kg 130 117 197 96 987 93 1239
2 AMIRA GL DAY TO DAY BASMATI RICE 5kg 555 500 143 494 84 490 69
3 BEST SPECIAL BASMATI RICE 5KG 736 662 347 684 1869 676 2333
4 DAAWAT BIRYANI BASMATI RICE 1KG 160 144 199 156 164 138 127
5 DAAWAT DEVAAYA BASMATI RICE 1kg 88 70 279 72 1434 70 1239
6 DAAWAT SUPER BASMATI 1kg 120 96 198     80 2439
7 INDIA GATE CLASSIC BASMATI RICE 1kg 172 138 243 145 1764    
8 INDIA GATE SUPER BASMATI RICE 1kg 135 108 237 112 54    
9 NEESA POPULAR 5KG 575 460 132     432 127

10 BEST SAHIPAKWAN BASMATI RICE 5KG 421.4 316 1,299 299 1634 294 3527
11 RADIKAL APICA BASMATI RICE 5kg 675.7 507 1,188 464 3523 502 1419
12 RADIKAL ARCTIC BASMATI RICE 1kg 125.6 94 730 93 6845 94 7027
13 RADIKAL ARCTIC BASMATI RICE 5kg 619.0 464 1,235 469 2896 473 3897
14 AMIRA GURU BASMATI RICE 5kg 800 600 25 597 34 620 33
15 DAAWAT DEVAAYA BASMATI RICE 5kg 497 373 69 379 595 384 819
16 DAAWAT SUPER BASMATI 5kg 596 447 26 389 694 379 1265
17 DAAWAT TRADITIONAL BASMATI RICE 5 KG 745 671 20 650 24 657 39
18 HELLO DAILY BASMATI RICE 5KG 600 445 19 449 387 437 1039
19 HELLO ROYAL RICE 5kg 680 544 14 487 876 494 768
20 RAIN DROPS 5KG 725     685 1944 676 2333
21 GOLDEN HARVEST 5 kg 735     700 2876 700 1434
22 EKTAA 1 kg 82     80 63    
23 RAIN DROPS 1 KG 90     90 1776    
24 SHAKTIBHOG BASMATI 5KG 725         687 1937
25 RAIN DROPS ROZANA1KG 135         129 34
26 HIMALYAN CROWN 1 kg 115         108 29
27 NEESA PASAND 5KG 735         717 3834
Total 6755 30523 37007
Item for Price Reduction: 1, 6, 10, 11, 16, 18, 19
Item for improving stock availability: 3, 5, 7, 12, 13, 15, 18
Item for Removal: 14, 17
Item for Addition: 20, 21, 23, 24, 27

You might also like