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

Answer,

	Calculation of Gross Earnings
		(1)	(2)	(3)	(4)	(5)	(6)	(7)	(8)	(9)   Shift Premium($)		Gross Earnings($) (7)+(8)+(9)
	Name of Employees	Total Hours Worked in a Week	Over Time Hours Worked	Afternoon worked Hours	Midnights Worked Hours	Regular Pay Per Hour($)	Overtime pay per hour(1.5 Times of Regular pay)	Regular Pay($)	Overtime Pay(Ontario Labour Standard)	Afternoon (3) * 0.97$	Midnights (4) * 1.57$
	Mark Meninger	47.5	3.5 ( 47.5 - 44)	13	18	15.75	23.62   (1.5*15.75)	748.125   (47.5 Hours*15.75)	82.6875(3.5 Hours*23.62)	12.61	28.26	871.68
	Kayla Klaussen	48	4 (48-44)	11	20	18.25	27.375 (1.5*18.25)	876 (48 Hours*18.25)	109.5 (4 Hours*27.375)	10.67	31.4	1,027.57
	Dough Dryden	48	4 (48-44)	12	19	16.5	24.75 (1.5*16.5)	792 (48 Hours*16.5)	99 (4 Hours*24.75)	11.64	29.83	932.47
	Taylor Tuffin	52	8 (52-44)	18	20	16.25	24.375 (1.5*16.25)	845 (52 Hours*16.25)	195 (8 Hours*24.375)	17.46	31.4	1,088.86
	Note:-
	1.The Ontario Employment Standards Act requires employers to pay an employee overtime pay of at least one and one-half (1½) times the employee's regular rate for each hour worked in excess of 44 hours per week