Details of this Paper

DeVry Engineering Group" and your supervisor wants to test your knowledge and skills

Description

solution


Question

Question;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

 

Paper#36941 | Written in 18-Jul-2015

Price : $22
SiteLock