ID Name Division Grade Actual Expenses 2_Budget.

Allowance Balance
101 Sachin GT A6 2172 2000 -172
102 Ravi MT A4 1758 1750 -8
103 Akshay GT A2 1155 2400 1245
104 Subhash GT A1 2359 2500 141
105 Sanchit ET A3 1815 1500 -315
106 Prateek CSD A3 1738 1000 -738
107 Ajay GT A4 314 2200 1886
108 Sumit CSD A6 2348 300 -2048
109 Sanjay ET A1 926 2000 1074
110 Sandeep ET A2 1428 1750 322
111 Vineet MT A6 595 1300 705
112 Supriya MT A5 2283 1500 -783
113 Anya MT A4 2247 1750 -497
114 Khoi ET A4 1577 1250 -327

Division Grade Actual Expenses

GT A6 1599
GT A1 815
MT A4 2688
GT A2 1383
GT A4 1680
ET A3 853
ET A1 2262
ET A2 1911
MT A6 2451
MT A5 672
ET A4 2096
CSD A3 2027
CSD A6 1442
Custom ID Name Division Grade
Overspent 101 Sachin GT A6
Overspent 102 Ravi MT A4
Within budget, accept 103 Akshay GT A2
Within budget, accept 104 Subhash GT A1
Overspent 105 Sanchit ET A3
Overspent 106 Prateek CSD A3
Within budget, accept 107 Ajay GT A4
Overspent 108 Sumit CSD A6
Within budget, accept 109 Sanjay ET A1
Within budget, accept 110 Sandeep ET A2
Within budget, accept 111 Vineet MT A6
Overspent 112 Supriya MT A5
Overspent 113 Anya MT A4
Overspent 114 Khoi ET A4
Actual Expenses Division A1 A2 A3 A4 A5
1,940 GT 2,500 2,400 2,300 2,200 2,100
1,212 MT 2,250 2,100 2,000 1,750 1,500
2,245 ET 2,000 1,750 1,500 1,250 1,000
1,079 CSD 1,500 1,200 1,000 750 500
701
584
2,426
488
1,594
2,281
1,369
1,885
1,520
2,236
A6
2,000
1,300
750
300
Which employee is the best performer?

Project Name Industry

Project 101 IT
Project 102 FMCG
Project 103 Banking
Project 104 Banking
Project 105 Industrial
Project 106 Banking
Project 107 Industrial
Project 108 FMCG
Project 109 FMCG
Project 110 IT
s the best performer?

Team Analyst Project Cost (US$)

Rahul Kumar, Sachin Dev, Akshay Saxena 77,578
Sachin Dev, Sanjana Kapoor, Manoj Tiwari, Anjali Parmar 131,783
Anjali Parmar, Manoj Tiwari, Rahul Kumar, Sanjana Kapoor 224,417
Sanjana Kapoor, Sachin Dev 137,060
Sachin Dev, Sanjana Kapoor, Anjali Parmar 76,976
Sanjana Kapoor, Manoj Tiwari, Anjali Parmar, Akshay Saxena 127,310
Rahul Kumar, Sachin Dev, Akshay Saxena, Sanjana Kapoor 232,553
Akshay Saxena, Manoj Tiwari, Sanjana Kapoor 134,754
Anjali Parmar, Akshay Saxena 122,016
Manoj Tiwari, Anjali Parmar, Sachin Dev, Sanjana Kapoor, Askhay Saxena 111,158
Analyst Count_Projects Total_Cost Average_Cost
Sanjana Kapoor 8 340,354 42,544
Sachin Dev 6 233,364 38,894
Anjali Parmar 6 229,776 38,296
Akshay Saxena 5 221,751 44,350
Manoj Tiwari 5 188,027 37,605
Rahul Kumar 3 140,102 46,701
Askhay Saxena 1 22,232 22,232
Create flat file for analysis

Column1 Target Achievement Target2 Achievement3

Apr-22 Apr-22 May-22 May-22
Sahil 258 89 271 101
Aman 243 151 163 104
Manoj 261 248 239 158
Piyush 167 177 97 230
Anant 113 107 289 236
Target/Achivement Month Salesmen Value Sum of Value Target/Achivement
Target 04-2022 Sahil 258 Salesmen Achievement
Target 04-2022 Aman 243 Aman 255
Target 04-2022 Manoj 261 Anant 343
Target 04-2022 Piyush 167 Manoj 406
Target 04-2022 Anant 113 Piyush 407
Achievement 04-2022 Sahil 89 Sahil 190
Achievement 04-2022 Aman 151 Total Result 1601
Achievement 04-2022 Manoj 248
Achievement 04-2022 Piyush 177
Achievement 04-2022 Anant 107
Target 05-2022 Sahil 271
Target 05-2022 Aman 163
Target 05-2022 Manoj 239
Target 05-2022 Piyush 97
Target 05-2022 Anant 289
Achievement 05-2022 Sahil 101
Achievement 05-2022 Aman 104
Achievement 05-2022 Manoj 158
Achievement 05-2022 Piyush 230
Achievement 05-2022 Anant 236
get/Achivement
Target
406
402
500
264
529
2101
Column 1 Column 2 Column 3 Column 4 Column 5 Column 6
Nov'22 Dec'22
Actual Budget Variance ($) Actual
Revenues
Apple iPhone 39,084 32,627 6,457 31,052
Apple iWatch 20,563 39,041 - 18,478 32,949
Apple MacBook 36,768 34,250 2,518 48,723
Total Revenues 96,415 1,05,918 - 9,503 1,12,724

Expenses
Cost of Goods Sold (COGS) 18,603 20,249 - 1,646 22,755
Employee 18,850 16,339 2,511 16,453
Other Operations 16,304 21,896 - 5,592 18,450
Total Expenses 53,757 58,484 - 4,727 57,658
Net Income 42,658 47,434 - 4,776 55,066
Column 7 Column 8 Category Product Date Period Value
Revenues Apple iPhone Nov'22 Actual 39,084
Budget Variance ($) Revenues Apple iPhone Nov'22 Budget 32,627
Revenues Apple iPhone Dec'22 Actual 31,052
48,303 - 17,251 Revenues Apple iPhone Dec'22 Budget 48,303
34,706 - 1,757 Revenues Apple iWatch Nov'22 Actual 20,563
40,360 8,363 Revenues Apple iWatch Nov'22 Budget 39,041
1,23,369 - 10,645 Revenues Apple iWatch Dec'22 Actual 32,949
Revenues Apple iWatch Dec'22 Budget 34,706
Revenues Apple MacBook Nov'22 Actual 36,768
20,856 1,899 Revenues Apple MacBook Nov'22 Budget 34,250
15,204 1,249 Revenues Apple MacBook Dec'22 Actual 48,723
16,318 2,132 Revenues Apple MacBook Dec'22 Budget 40,360
52,378 5,280 Expenses Cost of Goods Sold (COGS) Nov'22 Actual 18,603
70,991 - 15,925 Expenses Cost of Goods Sold (COGS) Nov'22 Budget 20,249
Expenses Cost of Goods Sold (COGS) Dec'22 Actual 22,755
Expenses Cost of Goods Sold (COGS) Dec'22 Budget 20,856
Expenses Employee Nov'22 Actual 18,850
Expenses Employee Nov'22 Budget 16,339
Expenses Employee Dec'22 Actual 16,453
Expenses Employee Dec'22 Budget 15,204
Expenses Other Operations Nov'22 Actual 16,304
Expenses Other Operations Nov'22 Budget 21,896
Expenses Other Operations Dec'22 Actual 18,450
Expenses Other Operations Dec'22 Budget 16,318