Excel Full course.xlsx

	B	C	D	E	F	G	H	I	J	K	L	P	Q
1	Rayhan Tanjim and Company
2	Sales data for the months of January, February,March,April and May - 2023
3
4	Information of Employee		Sales						Report		Bonus
5	Serial No	Employee Name	Employee ID	January	February	March	April	May	Total	Average Sales	Bonus		177000
6	1	Atif Akash	RT1001	30000	30000	25000	46000	46000	177000	35400	Applicable
7	2	Rabbe Rafi	RT1002	35000	34000	30000	26000	26000	151000	30200	Applicable		177000
8	3	Saleh Hasn	RT1003	40000	38000	35000	30000	30000	173000	34600	Applicable
9	4	Robiul Islam	RT1004	25000	25000	34000	5000	22250	111250	22250	Not Applicable
10	5	Asif Akash	RT1005	15000	10000	10000	500	25000	60500	12100	Not Applicable
11	6	Siddique Raji	RT1006	25000	26000	15000	25000	30000	121000	24200	Not Applicable
12	7	Zafi Kader	RT1007	30000	30000	25000	30000	35000	150000	30000	Not Applicable
13	8	Yemain Kazi	RT1008	35000	34000	30000	35000	40000	174000	34800	Applicable
14	9	Sahin Molla	RT1009	40000	38000	35000	40000	45000	198000	39600	Applicable
15	10	Mamun Sheikh	RT1010	25000	25000	34000	5000	50000	139000	27800	Not Applicable
16	11	Humayoun Hasan	RT1011	15000	10000	10000	2500	25000	62500	12500	Not Applicable
17	12	Saiful Islam	RT1012	25000	26000	15000	25000	30000	121000	24200	Not Applicable
18	13	Akshik Khorshded	RT1013	30000	30000	25000	30000	35000	150000	30000	Not Applicable	Less than 30000 Tk
19	14	Habij Abdullah	RT1014	35000	34000	30000	35000	40000	174000	34800	Applicable
20	15	Ziaur Rahman	RT1015	40000	38000	35000	40000	45000	198000	39600	Applicable
21	16	Jahid Hasan	RT1016	25000	25000	34000	5000	50000	139000	27800	Not Applicable
22	17	Sumon Reza	RT1017	15000	10000	10000	500	25000	60500	12100	Not Applicable
23	18	Siraz Haider	RT1018	25000	26000	15000	25000	30000	121000	24200	Not Applicable
24	19	Shofiul Islam	RT1019	30000	30000	25000	30000	35000	150000	30000	Not Applicable
25	20	Ripon Karmakar	RT1020	35000	34000	30000	35000	40000	174000	34800	Applicable
26	21	Riazul Rafi	RT1021	40000	38000	35000	40000	45000	198000	39600	Applicable
27	22	Zizvi Haider	RT1022	25000	25000	34000	5000	50000	139000	27800	Not Applicable
28	23	Siddique Bari	RT1023	15000	10000	10000	4582	25000	64582	12916.4	Not Applicable
29			Total	655000	626000	581000	520082	824250	824250
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100