You are the payroll manager at Widget R Us. You need to calculate an employee's Gross and Net pay based on the table below. Sandy worked overtime this past week and would like to know what her Gross and Net Pay will be. Your job is to calculate this using the following data:

Note: The company policy is that she is entitled to time and a half for any hours workrd over 40.

Using Excel calculate Sandy's Gross Pay and Net Pay. You must use a function or formula.

Pay Rate	$10/Hour	Federal Tax Rate:	20%
Hours Worked	50	State Tax Rate:	10%
		FICA	5%
Sandy's Gross Pay		Sandy's Net Pay

1. Calculate Sandy's Gross pay by using Function or formulas.

2. Calculate Sandy's Net Pay by using function and Formulas

Answer rating: 100% (QA)

Net pay Gross pay taxes declaration... View the full answer