Function: SUM; Formula: Subtract, Multiply; Cell Referencing
Some cells are merged.
Using Excel to Calculate Payroll				Student Work Area
PROBLEM		Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated.
Susan Little's is paid time and a half for work over 40 hours per week. Susan's Information for the pay period ending March 16 is provided here.
	Regular hours worked each week	40			a.	Calculate Susan's gross and net pay for the pay period.
	Hours worked week ending March 16	48
	Regular hourly wage rate	$ 18.00				Regular pay
	CPP deductions	47.34				Overtime pay
	EI deductions	14.79				Gross pay
	Income tax withholdings	186.00
						Net pay
					b.	What are Susan's employer's costs for CPP, EI, and income tax?
						Employer's costs