ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
LBRCE MBA - JANUARY
2
 NOEMPLOYEES'S NAMEEMPLOYEE'S ID NOEMPLOYEE'S BASIC SALARYINCREMENT (10%)INCREAMENTFOOD ALLOWANCEOVERTIME ALLOWANCEGROSS SALARYADVANCE NET SALARYPER DAY GROSS SALARY
3
1ARJUN0000001 40,000 0.10 2,000 3,100 2,000 -
4
2ROHIT0000002 42,000 0.10 2,200 3,150 1,000 -
5
3VIKAS0000003 60,000 0.10 2,400 3,200 2,500 -
6
4SAI KUMAR0000004 46,000 0.10 3,000 3,400 3,000 -
7
5RAHUL0000005 48,000 0.10 2,800 3,300 4,200 -
8
6NAVEEN0000006 55,000 0.10 3,000 3,350 5,200 -
9
7PRAVEEN0000007 52,000 0.10 4,000 3,500 7,000 -
10
8SURESH0000008 54,000 0.10 3,400 3,450 500 -
11
9KIRAN0000009 34,000 0.10 3,600 3,500 900 -
12
10ADITYA0000010 58,000 0.10 5,000 3,550 6,000 -
13
TOTAL - -
14
NOTE -GROSS SALARY =EM. BASIC SALARY +INCREMENT +FOOD ALLOWANCES +OVERTIME ALLOWANCES
15
NET SALARY =GROSS SALARY-ADVANCE
16
INCREAMENT FOR EACH EMPLOYEES 10% FROM THEIR BASIC SALARY
17
Q1) CALCULATE THE GROSS SALARY, INCREAMENT AMOUNT AND NET SALARY OF EACH EMPLOYEES BY USING FORMULAS?
18
Q2) CALCULATE THE PER DAY GROSS SALARY OF EACH EMPLOYEES BY USING FORMULAS?
19
Q3) CALCULATE TOTAL EMPLOYEE'S BASIC SALARY , INCREAMENT AMOUNT ,FOOD ALLOWANCE,OVERTIME ALLOWANCE,GROSS SALARY ,ADVANCE, NET SALARY BY USING FORMULAS ?
20
21
22
23
24
25
26
27
28
29
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