Question

1. An employee is working 6 days a week from Monday to Saturday. Assume the   

     overtime for the employee is double after 40 hours. The following

     table shows his working hours.  

1. Complete the table below (Show your work) (please make answer clear not handwriting)

M       T       W        Th           F        Sa	Total Hours	Regular Hours	Overtime Hours	Regular Rate	Overtime Rate
10hr   10hr    10hr    10hr     10hr    2 hr	??	??	??	$ 12.50	??

2. Find the gross earning of the employee. (please make answer clear not handwriting)

Answer 1

Answer A a.:

Regular hours = 40 hours (as after 40 hours Overtime is applicable)

Overtime rate double after 40 hours = Regular Rate*2

The filled table is as under:

M	T	W	Th	F	Sa	Total Hours	Regular Hours	Overtime Hours	Regular Rate	Overtime Rate
10hr	10hr	10hr	10hr	10hr	2hr	52	40	12	$ 12.50	$ 25.00

-----------------------------------------

Answer:

Gross Earning of the employee:

Gross Earning of the employee = (Regular Hours*Regular Rate)+(Overtime hours*Overtime Rate)
Gross Earning of the employee	= (40*$ 12.50)+(12*$ 25.00) = $ 800.00

------------------------

Excel working is as under: