0% found this document useful (0 votes)
294 views3 pages

Dynamic Pricing Excel

The document contains sales data over 4 months (March to June) for 30 medical stores, including the number of items sold, total sales, and average price per item. The stores saw significant variation in total sales and items sold over the months, with some stores selling thousands of items while others sold hundreds, and total sales ranging from tens of thousands to millions of rupees. Overall store performance fluctuated considerably month to month.

Uploaded by

ShivamKhare
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
294 views3 pages

Dynamic Pricing Excel

The document contains sales data over 4 months (March to June) for 30 medical stores, including the number of items sold, total sales, and average price per item. The stores saw significant variation in total sales and items sold over the months, with some stores selling thousands of items while others sold hundreds, and total sales ranging from tens of thousands to millions of rupees. Overall store performance fluctuated considerably month to month.

Uploaded by

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

number stores March april may june

1 New Patidar store 120000 600000 450000 330000


2 shankar medical 280000 1875000 1100000 560000
3 balaji medicines 285000 2000000 1520000 360000
4 malhotra medical store 216000 874800 864000 282000
5 chaudhri super baazaar 150000 866250 750000 238000
6 Bhopal medical 160000 1258000 832000 285000
7 vijay super bazaar 150000 660000 420000 215600
8 vishal medical store 195000 675000 726000 184800
9 Ak store 76500 972500 700000 355500
10 lakshmi medical 112500 675000 434000 165000
11 Nath medical 83125 464400 390000 152600
12 kamal medical store 70200 660600 400000 130000
13 gurjar medico 125000 1040000 860000 390000
14 om shivay Ayurvedic 52400 308000 384000 180000
15 shri ram medical 217500 1244100 760000 240000
16 chaturvedi medical 98000 424000 428400 182000
17 palak medical 40000 105600 93600 60000
18 om surgicals 48800 197100 221200 50000
19 mool chand medical store 127520 515460 312000 132000
20 yadav chemist 162000 530000 468000 270000
21 darshan medical 280000 1695000 961400 300000
22 royal medical 174000 1060200 765000 120000
23 agrawal medical 72000 243600 144000 45000
24 yadav chemist 90000 460000 187500 89000
25 asha medico 51300 307500 192500 123200
26 my pharma 70000 474000 196000 180000
27 dube medical 91200 261000 210000 300000
28 Max care 105600 336000 360000 216000
29 Pharma medico 72750 375000 262500 237600
30 pratap medical 91800 558000 252000 176000
averagr price
number stores March april may june number

1 New Patidar store 80 150 150 150 1


2 shankar medical 100 250 220 140 2
3 balaji medicines 95 250 200 120 3
4 malhotra medical store 120 180 180 120 4
5 chaudhri super baazaar 100 175 150 140 5
6 Bhopal medical 80 170 160 150 6
7 vijay super bazaar 125 200 200 140 7
8 vishal medical store 130 200 220 120 8
9 Ak store 85 250 200 150 9
10 lakshmi medical 90 150 140 150 10
11 Nath medical 95 180 150 140 11
12 kamal medical store 90 180 160 130 12
13 gurjar medico 100 200 200 150 13
14 om shivay Ayurvedic 80 140 150 120 14
15 shri ram medical 150 220 200 120 15
16 chaturvedi medical 100 160 180 130 16
17 palak medical 100 120 120 120 17
18 om surgicals 80 135 140 100 18
19 mool chand medical store 160 220 200 120 19
20 yadav chemist 180 200 200 150 20
21 darshan medical 200 250 220 150 21
22 royal medical 120 180 150 120 22
23 agrawal medical 80 145 100 90 23
24 yadav chemist 90 200 150 100 24
25 asha medico 95 250 175 160 25
26 my pharma 100 300 200 180 26
27 dube medical 120 180 150 200 27
28 Max care 120 160 150 180 28
29 Pharma medico 75 200 175 180 29
30 pratap medical 85 180 150 160 30
quantity
stores March april may june

New Patidar store 1500 4000 3000 2200


shankar medical 2800 7500 5000 4000
balaji medicines 3000 8000 7600 3000
malhotra medical store 1800 4860 4800 2350
chaudhri super baazaar 1500 4950 5000 1700
Bhopal medical 2000 7400 5200 1900
vijay super bazaar 1200 3300 2100 1540
vishal medical store 1500 3375 3300 1540
Ak store 900 3890 3500 2370
lakshmi medical 1250 4500 3100 1100
Nath medical 875 2580 2600 1090
kamal medical store 780 3670 2500 1000
gurjar medico 1250 5200 4300 2600
om shivay Ayurvedic 655 2200 2560 1500
shri ram medical 1450 5655 3800 2000
chaturvedi medical 980 2650 2380 1400
palak medical 400 880 780 500
om surgicals 610 1460 1580 500
mool chand medical store 797 2343 1560 1100
yadav chemist 900 2650 2340 1800
darshan medical 1400 6780 4370 2000
royal medical 1450 5890 5100 1000
agrawal medical 900 1680 1440 500
yadav chemist 1000 2300 1250 890
asha medico 540 1230 1100 770
my pharma 700 1580 980 1000
dube medical 760 1450 1400 1500
Max care 880 2100 2400 1200
Pharma medico 970 1875 1500 1320
pratap medical 1080 3100 1680 1100

You might also like