Design and create a workbook to keep track of the payroll for hourly employees. Each worksheet will correspond to a different week. You have six employees. List them in a column. Each employee makes a different amount per hour. List the hourly pay for each employee in a new column. Now add a column for each of the seven days of the week. In these columns enter the number of hours worked by each employee each day that week. To the right add columns that give the total number of hours worked by each employee and the gross pay for each employee. The federal government asks you to deduct 20% of gross pay for federal income taxes. Your state or province asks you to deduct 5% of gross pay for state income taxes. Add columns for these. Social security deduction is 6.2% of gross pay. The deduction for medical insurance is $20 per week. Add columns for these. Each employee’s take home pay is the gross pay minus the deductions. Add a column for take home pay. Add a row to total all of the columns. Add appropriate cells with headings for the worksheet.
Now use the worksheet you just created for one week’s payroll to create a workbook for a month (four weeks). You should have an initial worksheet that gives a title and other information. There should be one worksheet for each week. Employees may work different hours from week to week. The final worksheet should be the totals for the four weeks. There should be six worksheets in all.
The only cells in which input is allowed are the employee names, hourly pay rate, and hours worked during each of the seven days. Data entry should not be allowed in any cell containing a formula or header information. Data entry should not be allowed in the totals worksheet. Lock/unlock the appropriate cells in each of the weekly payroll worksheets and the total worksheet. Protect each of the worksheets (do not use a password).