Question

Prepare the payroll of Amal Bros, for the month of January 2016.

• DA – 36% of Basic Pay 
• HRA – Rs 500 
• CCA – 6% of Basic pay

Deduction: 

1. PF subscription – 8% of BP. 

2. Group insurance premium Rs. 200 below basic pay Rs. 6000 and for others Rs. 350. 

3. Tax deducted at source 10% of Gross Pay for employees below gross pay of Rs. 10000 arid for others 20%. Also, find out the total salary payable to employees for the month.

Answer 1

Procedure: 

Step 1 – Open a blank work sheet in LibreOffice Calc 

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

Step 3 – Enter the following formula in the respective cell

Cell	Formula
C2	= B2 * 36%
E2	= B2 * 6%
F2	= SUM(B2: E2)
G2	= B2 * 8%
I2	= IF(B2 < 6000, 200, 350)
J2	= IF(F2 < 10000, F2 * 10%, F2 * 20%)
K2	= SUM(G2: J2)
L2	= F2 – K2

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

Name of Employee	Net Salary
Jaizal Grace	7134
Haizal Rose	7218.80
Joshwin Zian	6688
Anlino Zinan	6359.80