2023 Sale Value
Dist. Name JAN FEB MAR APR MAY JUN JUL AUG
AMRIT SONS 8041202 10833037 13463052 14147912 12559802 16701073 12085503 13580644
A. J. ENTERPRISES 2386179 2400000 2480000 47000 54805 48000 2141750 2300800
ANAND AGENCIES 2676987 3140170 2148669 2008263 1913386 2871839 2738800 2622115
APOORVA ENTERPRISES 3550871 3455943 3646497 60259 52878 47147 721399 3202470
B B ENTERPRISES 2516525 3573493 3001826 2914241 4042236 3121190 4770166 4245976
4 S TRADE CENTRE-SST 6551209 5992001 5248006 6563517 6741528 7204950 6822412 7809720
AMIT ENTERPRISES 3408590 3993553 3762751 71014 74461 87194 2759056 3138405
ANIKET ENTERPRISES 3003306 2840269 5326283 126084 132128 148008 6311271 5732535
BALAK SALES AGENCIES 4037127 5400928 8495919 7194737 7434466 8158375 6915961 6554590
ANKITA ENTERPRISE 1389776 4772546 1366470 1561139 1519000 1564000 1495289 1620000
BANSAL AGENCIES 6028500 10010482 13082569 5456979 6600000 6231547 4132394 5776778
AKASH AGENCIES 5238451 3356855 3935250 4698895 3100604 3790416 3706642 3941372
ARIHANT AGENCIES 1603000 1506956 1670000 31640 30558 34232 1666616 1700164
2024 Sale Value
SEP OCT NOV DEC JAN FEB MAR APR MAY JUN
13786974 12878288 12441261 13809104 11600854 14997204 13543052 282958 251196 334021
2300000 2367393 2550000 2000000 2312558 4778999 2400000 2350000 2740269 2400000
3407754 1784754 1982615 2624801 2779092 2996610 2228669 40165 38268 57437
2462415 2219202 -261862 6112383 3167204 3255081 3566497 3012935 2643918 2357334
4310655 3015151 3354902 3188543 3024388 4293453 3081826 58285 80845 62424
6016842 2614252 5884504 6346685 3055263 3471081 5328006 131270 134831 144099
3108589 2990347 3209617 3847146 3498592 3105333 3682751 3550685 3723036 4359707
2412837 3705209 6095384 3640059 6034052 5284174 5246283 6304180 6606392 7400394
9696475 4829296 5968250 5910202 7765967 7878613 8575919 143895 148689 163168
1441000 1420000 1575212 1487434 1197370 1477000 1446470 31223 30380 31280
5423789 5785724 6208301 3058792 5100000 3199686 13162569 109140 132000 124631
4232112 4181406 3674190 8870735 4422879 4096355 4015250 93978 62012 75808
1300515 1596189 1887000 1817974 1554000 5087721 1590000 1582000 1527901 1711584
Note: Please update Growth%
From Jan to JUN
YTD Growth %
-34736792 -45.86%
9565842 128.99%
-6619073 -44.85%
7189374 66.48%
-8568291 -44.70%
-26036661 -67.98%
10522541 92.32%
25299398 218.55%
-16045301 -39.40%
-7959208 -65.38%
-25582051 -53.96%
-11354189 -47.07%
8176820 167.68%
<80%- 0
81% to 90%- 500
Criteria
91% to 100% -1000,
If Condition Above 100%-1200
CBD Name Target Achivement Ach % Incentive Amt.
Maulik Pandya 500000 480000 96% 1000
Sandeep Gaikwad 450000 388000 86% 500
Sandesh Shirke 300000 150000 50% 0
Vasant Gaikwad 400000 220000 55% 0
Gurdeep Saini 600000 650000 108% 1200
Amol Gupta 550000 560000 102% 1200
Pramod Mishra 650000 600000 92% 1000
Sandesh Gole 800000 300000 38% 0
Umang Jariwala 400000 220000 55% 0
Total 4900
Note: please update incentive amt. using IF condition as per above Criteria
Customer code Customer Name State Sales Value Note: use Vlookup and update Sales
3431 AAKANSHA MARKETING-MAH MAH 142857.28
12549 AASHIRWAD AGENCY-MAH MAH 86577.12
223 AKANKSHA ENTERPRISES-MAH MAH 178574.56
5668 ARAMBAGH FOOD MART PVT LTD-WEB WEB 122732.8
5701 AUDDY AGENCY-WEB WEB 136014.6
11682 BHOWMICK ENTERPRISE-WEB WEB 38191.08
3997 DELTA SOLUTIONS-DEL DEL 139347.95
17448 GANAPATHY AGENCIES TND 18760.92
12121 SRINIVAS ENTRER PRISE TEL 0
17605 JOGESHWARI SALES MAH 18353.5
16734 NUTAN ENTERPRISES - MAH MAH 59270.55
10023 RAHUL MARKETING-MAH MAH 94556.72
5552 S.A ENTERPRISES-TND TND 34252.08
3070 S.S TRADERS-MAH MAH 92561.47
12020 SRI GOPAL ENTERPRISES-WEB WEB 172001.14
Vlookup and update Sales value as per Sheet 4 data
Cust code Cust Name INVOICE # Sales Value
5668 ARAMBAGH FOOD MART PVT LTD-WEB MK19041209 98214
223 AKANKSHA ENTERPRISES-MAH MK19040804 90058
5701 AUDDY AGENCY-WEB WO19013043 85826
223 AKANKSHA ENTERPRISES-MAH MK19041085 81993
3997 DELTA SOLUTIONS-DEL PB19022872 62580
5701 AUDDY AGENCY-WEB WO19013282 50188
5668 ARAMBAGH FOOD MART PVT LTD-WEB WO19013221 49131
3997 DELTA SOLUTIONS-DEL PB19022264 44700
5668 ARAMBAGH FOOD MART PVT LTD-WEB WO19013008 44681
3431 AAKANSHA MARKETING-MAH MK19041316 34916
3997 DELTA SOLUTIONS-DEL BO19055420 32068
5668 ARAMBAGH FOOD MART PVT LTD-WEB WO19012788 28922
3431 AAKANSHA MARKETING-MAH MK19041552 9727
223 AKANKSHA ENTERPRISES-MAH MK19041086 6524
Cust code Cust Name Sales Value Note: Please use Sumif and update sales valu
3431 AAKANSHA MARKETING-MAH 44643
223 AKANKSHA ENTERPRISES-MAH 178575
5701 AUDDY AGENCY-WEB 136015
3997 DELTA SOLUTIONS-DEL 139348
5668 ARAMBAGH FOOD MART PVT LTD-WEB 220947
mif and update sales value as per above data
Outlet Name Please hilight in red color text for Duplicate outlet Name
Mansukhlal And Sons-GUJ007395
Vasudev Inetrprise-GUJ007399
Dalvani Bajar-GUJ007404
eshawar super
bhagvan das and sons
Nav Durga Kirana Store-GUJ007401
Nav Durga Kirana Store-GUJ007401
nirmam treders
lapsiwala
Mahesh Janral Store-GUJ007396
Aashish Traders-GUJ007403
Jalaram Kirana-GUJ007406
Umiya Sales-GUJ007407
geeta trading
raj crockery
shepta supaer
bhagya laxmi super
chodhri kirana
chandan supear
lapsiwala
lapsiwala
Mansukhlal And Sons-GUJ007395
lapsiwala
Nav Durga Kirana Store-GUJ007401
National Store-GUJ007409
Mahesh Janral Store-GUJ007396
Me Bhavnage Wala-GUJ007397
Jalaram Kirana-GUJ007406
Me Bhavnage Wala-GUJ007397
Jalaram Kirana-GUJ007406
Mahakali Genral Store-GUJ007400
Me Bhavnage Wala-GUJ007397
maha bachat
maha bachat
Mahesh Janral Store-GUJ007396
BHAVANI DEPARTMENT STORE
or Duplicate outlet Names
Customer code Customer Name State Sales Value
10023 RAHUL MARKETING-MAH MAH 94557
8390 T.M. TRADERS-WEB WEB 13068
5701 AUDDY AGENCY-WEB WEB 136015
5668 ARAMBAGH FOOD MART PVT LTD-WEB WEB 122733
5552 S.A ENTERPRISES-TND TND 34252
3997 DELTA SOLUTIONS-DEL DEL 139348
3431 AAKANSHA MARKETING-MAH MAH 142857
3070 S.S TRADERS-MAH MAH 92561
223 AKANKSHA ENTERPRISES-MAH MAH 178575
11682 BHOWMICK ENTERPRISE-WEB WEB 38191
12020 SRI GOPAL ENTERPRISES-WEB WEB 172001
12549 AASHIRWAD AGENCY-MAH MAH 86577
16734 NUTAN ENTERPRISES - MAH MAH 59271
17448 GANAPATHY AGENCIES TND 18761
17605 JOGESHWARI SALES MAH 18354
