Question: I need all the formulas with step by step instructions on an excel file, please. Thank You. Design and create a workbook to keep track

 I need all the formulas with step by step instructions on I need all the formulas with step by step instructions on an excel file, please. Thank You.

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 $30 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. Please help me out with step by step instructions on an excel file along with the screenshots as to how to get it done. Thank You. There should be 6 excel worksheets

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!