PLEASE SHOW FORMULAS Design a payroll worksheet for a small company of hourly based salaried employees (weekly computation). The following information will be given (make up your own information): employee name, employee ID, hours worked, and hourly rate. The worksheet should compute gross pay, tax amount (be creative to find or apply a reasonable tax rate for now), and net pay. In addition, the worksheet should compute the total gross pay, number of employee, average gross pay, min and max gross pay. This should be based on 3 employees.compute overtime pay for an overtime worked employee.As well as the Variable tax rate, if gross rate greater than a $1000, 30%. Greater than $800, 20% anything else 10%.

Apply what if: increasing 5% to the hourly rate and its impact.

You may choose another similar project such as your research analysis (resume analysis) however, you must inform me by an email.