excal assignment
ASSIGNMENT
MS-EXCEL
A. M/s Alpha Ltd pays to its employees the salary on the basis of Basic pay. The Gross salary of an employee consists of Basic Pay, Dearness Pay (D.P) and House Rent Allowance (H.R.A). The components of salary are computed according to the following terms of contract of service:
Dearness Allowance is paid @10% of basic pay subject to a maximum of Rs. 5400
HRA is computed as per the following scale: Basic Pay HRA(Rs.) Up to 10,000 5,000 From 10,001 to. 25,000 7,000 More than 25,000 9,000
Required: Prepare payroll of 10 employees of MIs Alpha Ltd for the month of March 2009 , in the format given below according to above terms of contract .FiII information about Employee Identification (Empld), Name of Employees and their Basic Pay on your own.
Payroll for the Month of March 2006.
EmpId
Name of Employees
Basic
DA
HRA
Gross
Total
B. M/s Beta Ltd pays to its employees the salary on the basis of Basic pay. The Gross salary of an employee consists of Basic Pay, Dearness Pay (D.P) and House Rent Allowance (H.R.A). The components of salary are computed according to the following terms of contract of service: Dearness Allowance is paid @ 10% of basic pay subject to a maximum of Rs. 5400. .
HRA is computed as per the following scale:
Category HRA
A 25%
B 30%
C 35%
Required: Prepare payroll of 10 employees of MIs Beta Ltd for the month of April 2009, in the format given below according to above terms of contract .FiII information about Employee Identification (Empld), Name of Employees and their Basic Pay on your own.
Payroll for the Month of April 2009.
EmpId
Name of Employees
Category
Basic
DA
HRA
Gross
Total
C. M/s Gamma Ltd pays to its employees the salary on the basis of Basic pay. The Gross salary of an employee
MS-EXCEL
A. M/s Alpha Ltd pays to its employees the salary on the basis of Basic pay. The Gross salary of an employee consists of Basic Pay, Dearness Pay (D.P) and House Rent Allowance (H.R.A). The components of salary are computed according to the following terms of contract of service:
Dearness Allowance is paid @10% of basic pay subject to a maximum of Rs. 5400
HRA is computed as per the following scale: Basic Pay HRA(Rs.) Up to 10,000 5,000 From 10,001 to. 25,000 7,000 More than 25,000 9,000
Required: Prepare payroll of 10 employees of MIs Alpha Ltd for the month of March 2009 , in the format given below according to above terms of contract .FiII information about Employee Identification (Empld), Name of Employees and their Basic Pay on your own.
Payroll for the Month of March 2006.
EmpId
Name of Employees
Basic
DA
HRA
Gross
Total
B. M/s Beta Ltd pays to its employees the salary on the basis of Basic pay. The Gross salary of an employee consists of Basic Pay, Dearness Pay (D.P) and House Rent Allowance (H.R.A). The components of salary are computed according to the following terms of contract of service: Dearness Allowance is paid @ 10% of basic pay subject to a maximum of Rs. 5400. .
HRA is computed as per the following scale:
Category HRA
A 25%
B 30%
C 35%
Required: Prepare payroll of 10 employees of MIs Beta Ltd for the month of April 2009, in the format given below according to above terms of contract .FiII information about Employee Identification (Empld), Name of Employees and their Basic Pay on your own.
Payroll for the Month of April 2009.
EmpId
Name of Employees
Category
Basic
DA
HRA
Gross
Total
C. M/s Gamma Ltd pays to its employees the salary on the basis of Basic pay. The Gross salary of an employee