You work for a local construction firm, “DeVry Engineering Group” and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions:
Note: This is a one part question.
• Each employee could have a standard hourly rate between $10.00 and $30.00 per hour.
• Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours.
• Each employee will have a standard 7.65% deduction for social security
• Each employee will have a standard 14.00% deduction for Federal Taxes
• Each employee will have a standard 5.33% deduction for State Taxes
