From the following particulars of employees in Anu Traders, prepare the Pay Roll. Name - Basic pay 1) thomson-8760 2) Nilson - 9340

Question

From the following particulars of employees in Anu Traders, prepare the Pay Roll.

Name	Basic pay
Thomson	8760
Nilson	9340
Shibu	10100
Shyjan	8350
Rejo	11200

Additional information: 

1. DA – 50% of BP 

2. HRA – 10% of BP 

3. A monthly subscription to PF – 15% of BP 

4. Group insurance premium -120 from each employee.

Answer 1

Procedure: 

Step 1 – Open a new worksheet in LibreOffice Calc 

Step 2 – Enter the following details in the following cells.

Step 3 – Enter the following details in the respective cells

Cell	Formula
C3	= B3*50%
D3	= B3*10%
E3	= Sum (B3:D3)
F3	=B3*15%
H3	= F3 + G3
13	= E3 - H3

 

Step 4 – Copy the formula down up to the last employee. 

Output:

Thomson	12582
Nilson	13423
Shibu	14525
Shjo	11030.50
Shyjan	11987.50
Rejo	16120