Question

You are preparing the weekly payroll for the week ending March 10th. There are four employees and their timecards along with a summary of deductions/benefits are listed below. Overtime is calculated based on Ontario Labour standards. Shift premium is $.97 per hour for afternoons and $1.57 per hour for midnights.

Using the timecards below, calculate the number of hours paid at the regular time, overtime and shift premium hours. Once you have that information calculate their gross earnings for the period. Please show me all your work for full marks.

                       

Mark Meninger        Hourly pay $15.75 per hour

Shift	Sun	Mon	Tues	Wed	Thurs	Fri	Sat
Days		8	8.5
Afternoon				6	7
Midnights						10	8

Kayla Klaussen         Hourly pay $18.25 per hour

Shift	Sun	Mon	Tues	Wed	Thurs	Fri	Sat
Days						9	8
Afternoon		6	5
Midnights				10	10

Doug Dryden             Hourly pay $16.50 per hour

Shift	Sun	Mon	Tues	Wed	Thurs	Fri	Sat
Days				8	9
Afternoon						7	5
Midnights		9	10

Taylor Tuffin             Hourly pay $16.25 per hour

Shift	Sun	Mon	Tues	Wed	Thurs	Fri	Sat
Days		6.5	7.5
Afternoon				8.5	9.5
Midnights						10	10

Answer 1

Mark Meninger        Hourly pay $15.75 per hour
Shift	Hourly Pay rate (per hour)	Sun	Mon	Tues	Wed	Thurs	Fri	Sat	Total	Overtime	Net Hours	Pay
Days	$15.75		8	8.5					16.5	3.5	13	$204.75
Afternoon	$16.72				6	7			13	0	13	$217.36
Midnights	$17.32						10	8	18	0	18	$311.76
Total Hours Worked/ Total Pay									47.5
Overtime hours in excess of 44 hours as per Ontario Labour standards									3.5
Overtime Pay = Overtime rate (1.5 of normal rate i.e. $ 23.625) x ovetime hours									$        82.69			$     82.69
Gross Earning for the period												$816.56
Kayla Klaussen         Hourly pay $18.25 per hour
Shift	Hourly Pay rate (per hour)	Sun	Mon	Tues	Wed	Thurs	Fri	Sat	Total	Overtime	Net Hours	Pay
Days	$          18.25						9	8	17	4	13	$237.25
Afternoon	$          19.22		6	5					11	0	11	$211.42
Midnights	$          19.82				10	10			20	0	20	$396.40
Total Hours Worked/ Total Pay									48
Overtime hours in excess of 44 hours as per Ontario Labour standards									4
Overtime Pay = Overtime rate (1.5 of normal rate i.e. $ 23.625) x ovetime hours									$        94.50			$     94.50
Gross Earning for the period												$939.57
Doug Dryden             Hourly pay $16.50 per hour
Shift	Hourly Pay rate (per hour)	Sun	Mon	Tues	Wed	Thurs	Fri	Sat	Total	Overtime	Net Hours	Pay
Days	$          16.50				8	9			17	4	13	$214.50
Afternoon	$          17.47						7	5	12	0	12	$209.64
Midnights	$          18.07		9	10					19	0	19	$343.33
Total Hours Worked/ Total Pay									48
Overtime hours in excess of 44 hours as per Ontario Labour standards									4
Overtime Pay = Overtime rate (1.5 of normal rate i.e. $ 23.625) x ovetime hours									$        94.50			$     94.50
Gross Earning for the period												$861.97
Taylor Tuffin             Hourly pay $16.25 per hour
Shift	Hourly Pay rate (per hour)	Sun	Mon	Tues	Wed	Thurs	Fri	Sat	Total	Overtime	Net Hours	Pay
Days	16.25		6.5	7.5					14	8	6	$97.50
Afternoon	17.22				8.5	9.5			18	0	18	$309.96
Midnights	17.82						10	10	20	0	20	$356.40
Total Hours Worked/ Total Pay									52
Overtime hours in excess of 44 hours as per Ontario Labour standards									8
Overtime Pay = Overtime rate (1.5 of normal rate i.e. $ 23.625) x ovetime hours									$      189.00			$ 189.00
Gross Earning for the period												$952.86