Computer Science, asked by sjshashankgupta2010, 5 months ago

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. .

Attachments:

Answers

Answered by nitusain1878

Answer:

To find minimum basic and displayed in B11.

Answered by probrainsme101

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

Previous Question

Next Question