SUN Finance is a leading fintech b2b SAAS platform.

The attached data is pertaining to Sales executive (key account manager sales) performance.
The National Sales Head of SUN finance has asked you to prepare report for Monthly sales review with the zonal sales head covering following points

1 Zone wise target vs achievment

2 Total revenue, Average sales price by each zone
3 Sales funnel of each zone (Inbound Leads--> Qualified leads--> Opportunities---> Deals
4 Best performing KAM from each zone
5 Any other insights
s) performance.
ing following points
 Math Science
Naman 100 70
Rajesh 90 60
Shivam 80 100

Math Science
Naman 1 2
Rajesh 2 3
Shivam 3 1
1.5
2.5
2
Zone Sum of Inbound leads
E 2988
N 2908
S 2885
W 2838
Total Res 11619

Deals Revenuefinal conversionaverage order

Data
Zone ID Sum of Deals Sum of Avg Sales Price (INR)
E E1001 105 11063
E1002 134 10942
E1003 121 12723
E1004 137 10844
E1005 129 11026
E1006 118 14354
E1007 153 13454
E1008 152 14278
E1009 107 10950
E1010 160 11846
E1011 142 13173
E1012 124 12293
E1013 89 13143
E1014 140 10510
E1015 155 11771
E1016 132 14108
E1017 101 13480
E1018 141 13501
E1019 95 11092
E1020 98 12220
E Result 2533 246771
N N1001 154 13080
N1002 143 13812
N1003 92 10815
N1004 102 12431
N1005 105 13608
N1006 112 14647
N1007 118 14661
N1008 114 13324
N1009 114 10362
N1010 99 13888
N1011 132 14381
N1012 122 12779
 N1013 80 14198
N1014 97 12987
N1015 112 10300
N1016 107 10570
N1017 162 10636
N1018 167 12821
N1019 169 10272
N1020 119 14847
N Result 2420 254419
S S1001 92 12975
S1002 104 11604
S1003 94 11464
S1004 139 13501
S1005 113 10488
S1006 86 10745
S1007 118 12497
S1008 104 10773
S1009 103 13615
S1010 133 11587
S1011 155 13068
S1012 101 14265
S1013 126 11432
S1014 145 11458
S1015 137 10862
S1016 142 12397
S1017 150 14521
S1018 120 14410
S1019 108 11580
S1020 145 13936
S Result 2415 247178
W W1001 89 11417
W1002 153 13144
W1003 115 10834
W1004 89 10026
W1005 107 11033
W1006 152 13852
W1007 106 14107
W1008 113 10893
W1009 137 11579
W1010 110 11670
W1011 100 13471
W1012 168 13849
W1013 118 13930
W1014 119 12121
W1015 130 13567
W1016 131 12131
W1017 100 12870
W1018 147 13383
 W1019 115 11907
W1020 86 11646
W Result 2385 247430
Total Result 9753 995798
 Data
Zone ID Sum of Deals Sum of Avg Sales Price (INR) #VALUE!
E E1001 105 11063 3722.667
E1002 134 10942 3692
E1003 121 12723 4281.333
E1004 137 10844 3660.333
E1005 129 11026 3718.333
E1006 118 14354 4824
E1007 153 13454 4535.667
E1008 152 14278 4810
E1009 107 10950 3685.667
E1010 160 11846 4002
E1011 142 13173 4438.333
E1012 124 12293 4139
E1013 89 13143 4410.667
E1014 140 10510 3550
E1015 155 11771 3975.333
E1016 132 14108 4746.667
E1017 101 13480 4527
E1018 141 13501 4547.333
E1019 95 11092 3729
E1020 98 12220 4106
E Result 2533 246771 83101.33
N N1001 154 13080 4411.333
N1002 143 13812 4651.667
N1003 92 10815 3635.667
N1004 102 12431 4177.667
N1005 105 13608 4571
N1006 112 14647 4919.667
N1007 118 14661 4926.333
N1008 114 13324 4479.333
N1009 114 10362 3492
N1010 99 13888 4662.333
N1011 132 14381 4837.667
N1012 122 12779 4300.333
 N1013 80 14198 4759.333
N1014 97 12987 4361.333
N1015 112 10300 3470.667
N1016 107 10570 3559
N1017 162 10636 3599.333
N1018 167 12821 4329.333
N1019 169 10272 3480.333
N1020 119 14847 4988.667
N Result 2420 254419 85613
S S1001 92 12975 4355.667
S1002 104 11604 3902.667
S1003 94 11464 3852.667
S1004 139 13501 4546.667
S1005 113 10488 3533.667
S1006 86 10745 3610.333
S1007 118 12497 4205
S1008 104 10773 3625.667
S1009 103 13615 4572.667
S1010 133 11587 3906.667
S1011 155 13068 4407.667
S1012 101 14265 4788.667
S1013 126 11432 3852.667
S1014 145 11458 3867.667
S1015 137 10862 3666.333
S1016 142 12397 4179.667
S1017 150 14521 4890.333
S1018 120 14410 4843.333
S1019 108 11580 3896
S1020 145 13936 4693.667
S Result 2415 247178 83197.67
W W1001 89 11417 3835.333
W1002 153 13144 4432.333
W1003 115 10834 3649.667
W1004 89 10026 3371.667
W1005 107 11033 3713.333
W1006 152 13852 4668
W1007 106 14107 4737.667
W1008 113 10893 3668.667
W1009 137 11579 3905.333
W1010 110 11670 3926.667
W1011 100 13471 4523.667
W1012 168 13849 4672.333
W1013 118 13930 4682.667
W1014 119 12121 4080
W1015 130 13567 4565.667
W1016 131 12131 4087.333
W1017 100 12870 4323.333
W1018 147 13383 4510
 W1019 115 11907 4007.333
W1020 86 11646 3910.667
W Result 2385 247430 83271.67
Total Result 9753 995798 335183.7
 ID Zone Inbound leads Qualified leads opportunities Deals Target Avg Sales Price (INR)
E1001 E 126 120 117 105 150 11063
E1002 E 158 152 150 134 150 10942
E1003 E 153 151 146 121 150 12723
E1004 E 170 162 157 137 150 10844
E1005 E 164 157 157 129 150 11026
E1006 E 131 130 126 118 150 14354
E1007 E 175 166 161 153 150 13454
E1008 E 185 185 181 152 150 14278
E1009 E 134 127 127 107 150 10950
E1010 E 181 176 172 160 150 11846
E1011 E 158 155 153 142 150 13173
E1012 E 136 131 131 124 150 12293
E1013 E 109 108 108 89 150 13143
E1014 E 166 161 157 140 150 10510
E1015 E 186 182 182 155 150 11771
E1016 E 155 147 144 132 150 14108
E1017 E 114 111 109 101 150 13480
E1018 E 158 150 148 141 150 13501
E1019 E 116 116 113 95 150 11092
E1020 E 113 110 107 98 150 12220
W1001 W 105 104 104 89 150 11417
W1002 W 198 190 186 153 150 13144
W1003 W 150 143 140 115 150 10834
W1004 W 113 107 104 89 150 10026
W1005 W 131 131 129 107 150 11033
W1006 W 171 166 162 152 150 13852
W1007 W 141 134 131 106 150 14107
W1008 W 145 141 138 113 150 10893
W1009 W 162 154 154 137 150 11579
W1010 W 124 123 121 110 150 11670
W1011 W 113 111 108 100 150 13471
W1012 W 197 197 193 168 150 13849
W1013 W 130 130 128 118 150 13930
W1014 W 137 133 129 119 150 12121
W1015 W 146 140 138 130 150 13567
W1016 W 154 149 147 131 150 12131
W1017 W 110 109 105 100 150 12870
W1018 W 176 167 161 147 150 13383
W1019 W 131 126 122 115 150 11907
W1020 W 104 100 100 86 150 11646
S1001 S 109 107 104 92 150 12975
S1002 S 113 112 109 104 150 11604
S1003 S 113 111 107 94 150 11464
S1004 S 151 146 146 139 150 13501
S1005 S 139 136 136 113 150 10488
S1006 S 100 95 93 86 150 10745
S1007 S 144 140 140 118 150 12497
S1008 S 123 118 115 104 150 10773
S1009 S 131 127 127 103 150 13615
S1010 S 153 151 151 133 150 11587
S1011 S 179 174 172 155 150 13068
S1012 S 129 128 126 101 150 14265
S1013 S 144 138 133 126 150 11432
S1014 S 167 160 158 145 150 11458
S1015 S 158 156 151 137 150 10862
S1016 S 163 160 156 142 150 12397
S1017 S 190 188 188 150 150 14521
S1018 S 158 150 150 120 150 14410
S1019 S 136 132 128 108 150 11580
S1020 S 185 183 181 145 150 13936
N1001 N 169 167 167 154 150 13080
N1002 N 176 172 166 143 150 13812
N1003 N 111 108 108 92 150 10815
N1004 N 135 130 126 102 150 12431
N1005 N 132 125 122 105 150 13608
N1006 N 141 141 138 112 150 14647
N1007 N 135 130 130 118 150 14661
N1008 N 126 126 123 114 150 13324
N1009 N 144 141 141 114 150 10362
N1010 N 127 124 124 99 150 13888
N1011 N 174 165 163 132 150 14381
N1012 N 141 135 133 122 150 12779
N1013 N 101 101 99 80 150 14198
N1014 N 112 108 108 97 150 12987
N1015 N 139 135 135 112 150 10300
N1016 N 140 134 134 107 150 10570
N1017 N 176 176 172 162 150 10636
N1018 N 196 196 196 167 150 12821
N1019 N 198 192 188 169 150 10272
N1020 N 135 134 129 119 150 14847
Total Revenue generated(INR)
1161615
1466228
1539483
1485628
1422354
1693772
2058462
2170256
1171650
1895360
1870566
1524332
1169727
1471400
1824505
1862256
1361480
1903641
1053740
1197560
1016113
2011032
1245910
892314
1180531
2105504
1495342
1230909
1586323
1283700
1347100
2326632
1643740
1442399
1763710
1589161
1287000
1967301
1369305
1001556
1193700
1206816
1077616
1876639
1185144
924070
1474646
1120392
1402345
1541071
2025540
1440765
1440432
1661410
1488094
1760374
2178150
1729200
1250640
2020720
2014320
1975116
994980
1267962
1428840
1640464
1729998
1518936
1181268
1374912
1898292
1559038
1135840
1259739
1153600
1130990
1723032
2141107
1735968
1766793