Question

Prepare a pay roll of Jayakumar Associates for the month of June 2016 from the following details

Additional Information’s 

1. DA – 50% of Basic pay earned 

2. HRA – Manager – 30%, Accountant – 20%, clerk 10%, no HRA for saleswoman/Salesman and driver. 

3. Transport allowance – 1500 for saleswoman, 2500 for salesman and 1000 for driver 

4. PF contribution – 6% of BP for all employees except the driver.

Answer 1

Procedure: 

Step 1 – Open a blank worksheet in LibreOffice Calc 

Step 2 – Enter the following text/formula in the following way

Step 3 – Enter the given formula in F2 F2 = 30 – E2 Copy the formula down to the last employee 

Step 4 – Enter the given formula in G2 G2 = D2*F2 ÷ 30 Copy the formula down to the last employee.

Step 5 – Enter the text for formula in the following cells.

Step 6 – Copy the formula down to the last employee. 

Output: