Information system in management

It should be done in excel programm. I can also provode with examples.

Design a payroll worksheet for a small company of hourly based salaried employees (weekly computation). The following information will be given: 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 10 employees.

Extra: compute overtime pay for an overtime worked employee.

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