Assignment 1
Ques 1. Prepare a detailed generalized Payroll Report for a ltd company employing 10 workers for
the month of March, 2022, given the following information:
Employees are entitled to Basic, DA, HRA, CCA and Bonus.
DA is payable @ 17% on Basic.
HRA paid is $3300 for Basic<15000 and $5500 for others.
CCA is $ 800 for employees living in category ‘A’ cities, $ 500 for employees living in category
‘B’ cities, and $ 300 for employees living in category ‘C’ cities.
Bonus is payable @8.33% of (basic plus DA) and should not exceed $2000.
PF is deductible @10% of basic and DA.
Income Tax is deductible @ 10% of gross salary.
Also plot the Gross salary in the form of composite histogram.
Ques 2. M/s Alpha Ltd pays to its employees the salary on the basis of Basic pay. The Gross salary of
an employee consists of 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 $
5400.
HRA is computed as per the following scale:
Basic Pay HRA ($)
Upto $ 10,000 5,000
From 10,001 to 25,000 7,000
More than 25,000 9,000
Required: Prepare payroll of 10 employees M/s Alpha Ltd for the month of March 2006 , in the
format given below according to above terms of contract .Fill information about Employee
Identification (EmpId), Name of Employees and their Basic Pay on your own.
Payroll for the Month of March 2022
EmpId Name of Employees Basic DA HRA Gross
Total
Page 1
