Question

From the following particulars, prepare a payroll of employees of a firm by using LibreOffice Calc.

• DA = 70% of Basic pay 
• HRA = 10% of Basic pay Contributions to 
• PF at 15% of Basic pay

Answer 1

Step 1 – Enter the following

Cell	Content
A1	Name of employee
B1	Basic pay
C1	DA
D1	HRA
E1	Gross salary
F1	PF
G1	Net salary

Step 2

Cell	Formula
C2	= B1*70%
D2	= B1*10%
E2	= B2 +C2 + D2
F2	= B1*15%
G2	= E2 - F2

Step 3 – Copy this formula to the remaining cells