Question

3. Read the tables given below and answer the following question
4 marks
5 marks 5 marks
a. To calculate the DA as 25% of BASIC + HRA for each employee and display in column D. b. To calculate the NET SALARY as BASIC + HRA+ DA – PF for each employee and display in Column F. c. To Find Maximum NET SALARY and display in F9. d. To count the number of employees and display in cell B10 . e. To find Minimum BASIC and displayed in B11. .​

Answer 1

Answer:

To find minimum basic and displayed in B11.

Answer 2

Answer:

           A                  B                 C                 D          E                      F

1        NAME        BASIC          HRA              DA        PF           NET SALARY

2     Surinder      50000       20000          17500     600            86900

3     Kanika         56000       20000          19000     600            94400

4     Ashish         35000        15000          12500     400             62100

5    Harjit           45000        15000          15000     500             74500

6   Abhijit          60000        25000          21250     700            105550

7    Jyoti            75000         30000         26250    700             130550

8     Amita          25000         10000          8750      300              43450

9   Maximum                                                                                 130550

10 No. of Emp.      7

11  Minimum       25000

Explanation:

Calculating DA -

Surinder =

$25\% \ of \ (BASIC+HRA)\\ =25/100 \times (50000+20000)\\=0.25\times 70000\\=17500$

Kanika =

$25\% \ of \ (BASIC+HRA)\\ =25/100 \times (56000+20000)\\=0.25\times 76000\\=19000$

Ashish =

$25\% \ of \ (BASIC+HRA)\\ =25/100 \times (35000+15000)\\=0.25\times 50000\\=12500$

Harjit =

$25\% \ of \ (BASIC+HRA)\\ =25/100 \times (45000+15000)\\=0.25\times 60000\\=15000$

Abhijit =

$25\% \ of \ (BASIC+HRA)\\ =25/100 \times (60000+25000)\\=0.25\times 85000\\=21250$

Jyoti =

$25\% \ of \ (BASIC+HRA)\\ =25/100 \times (75000+30000)\\=0.25\times 105000\\=26250$

Amita =

$25\% \ of \ (BASIC+HRA)\\ =25/100 \times (25000+10000)\\=0.25\times 35000\\=8750$

#SPJ2