Microsoft Excel Payroll

Extra compute overtime pay for an overtime worked employee. Apply what if:? increasing 5% to the hourly rate and its? impact.? ? ? ? Design a payroll worksheet for a small company of hourly based salaried employees (weekly computation).? ? ? ? Headings employee name, employee ID, hours worked, hourly rate. The worksheet should compute gross pay , taxamount (be creative to find or apply a reasonaable? taxrate) , netpay. In addition worksheet should compute the total grosspay, number of employee, average grosspay, min and max grosspay? ? ? ? ? overtime pay for an overtime worked employee. increasing 5% to the hourly rate and its? impact. Minimum pay Maximum pay Average