Text Size:   A+ A- A   •   Text Only
Find     
Site Image

Calculating Weighted Average Overtime
Wage and Hour: Prevailing Wage
 
Appendix C
________________________
 
Calculating Weighted Average Overtime
 
In all of these examples, overtime is being computed as though there is a five-day work schedule. Daily overtime is computed for hours worked after eight in a day.
 
If a contractor or subcontractor adopts a work schedule of four consecutive days, rather than five (Monday through Thursday, or Tuesday through Friday), daily overtime would be computed for hours worked after ten in a day, rather than eight.  The following examples work for any situation:
 
EXAMPLE 1:
 
John Doe worked on a public works contract during the period July 15 to July 31.  Doe’s base rate of pay as determined by BOLI was $12.50 per hour.  His fringe benefits amount to $3.50 for a total of $16.00 per hour.  The contractor pays the fringe benefits to a trustee pursuant to a bona fide plan.
 
 
WEEK #1
 S
 M
 T
W
 T
F
 S
Total
 
 
 
 
 
 
 
15
 
16
 
17
 
18
 
 
 
 
 
8
 
7
 
10
 
 
25
 
Doe worked 10 hours on Friday, July 17 (two overtime hours).  He did not work on Saturday or over 40 hours during the week.  There were no holidays worked. The $3.50 per hour fringe benefit is not included with the hourly rate for overtime computation purposes.  Doe’s earnings in Week #1 are therefore:
 
$12.50/hr x 25 hrs
=
$312.50
$6.25/hr x 2 hrs
=
$12.50
Gross Wages Earned
=
$325.00
 
 
WEEK #2
 S
 M
 T
W
 T
F
 S
Total
 
19
 
20
 
21
 
22
 
23
 
24
 
25
 
 
 
6
 
4
 
10
 
13
 
2
 
5
 
40
 
Doe worked 40 hours during the week, seven of which were hours worked over eight in one day (July 22 and July 23) and five of which were worked on Saturday, July 25 (total of 12 overtime hours).  As in Week #1, fringe benefits are excluded from the overtime computation.  Doe’s earnings in Week #2 are therefore:
 
$12.50/hr x 40 hrs
=
$500.00
$6.25/hr x 12 hrs
=
$75.00
Gross Wages Earned
=
$575.00
 
 
WEEK #3
 S
 M
 T
W
 T
F
 S
Total
 
26
 
27
 
28
 
29
 
30
 
31
 
 
 
 
6
 
10
 
10
 
10
 
10
 
4
 
 
 
50
 
Doe worked 50 hours during the week, eight of which were hours worked over eight per day and six of which were hours worked on Sunday, July 26, which is a holiday as defined in ORS 279C.540 (total of 14 overtime hours).  As in Week #1, fringe benefits are excluded from the overtime computations.  Doe’s earnings in Week #3 are therefore:
 
$12.50/hr x 50 hrs
=
$625.00
$6.25/hr x 14 hrs
=
$87.50
Gross Wages Earned
=
$712.50
 
EXAMPLE 2:
 
Assume John Doe’s hours worked and fringe benefits paid were the same as in Example 1 above. Assume, however, that Doe’s hourly base rates varied because he was employed in more than one classification, as follows:
WEEK #1
 S
 M
 T
W
 T
F
 S
Total
 
 
 
 
 
 
 
15
 
16
 
17
 
18
 
 
 
 
 
8
 
7
 
10
 
 
25
 
Doe worked all of Wednesday and Thursday (July 15-16) at $12.50 per hour.  On Friday, July 17, he worked seven hours at $12.50 per hour and three hours at $13.10 per hour.  As required by OAR 839-025-0050(2)(b), because Doe worked two hours overtime on Friday and worked that day at two different rates, the weighted average of his base rates of pay must be calculated in order to compute his overtime rate for that day.  Doe’s weekly earnings would be as follows:
 
Straight time:
 
 
 
$12.50/hr x 22 hrs

$275.00
 
$13.10/hr x 3 hrs
=
$39.30
 
 
 
$314.30
$314.30
 
 
 
+
Overtime:
 
 
 
*$6.34/hr x 2 hrs
=
$12.68
$12.68
 
Gross wages earned
 
=
 
 
$326.98
 
      *To calculate 1/2 the weighted average:
 
($12.50/hr x 7 hrs) + ($13.10/hr x 3 hrs)
=
$126.80
$126.80 ¸ 10 hrs
=
$12.68
$12.68 x .5
=
$6.34
 
 
WEEK #2
 S
 M
 T
W
 T
F
 S
Total
 
19
 
20
 
21
 
22
 
23
 
24
 
25
 
 
 
6
 
4
 
10
 
13
 
2
 
5
 
40
 
Doe worked at $12.50 per hour, except four hours on Wednesday, July 22, where he worked at $11.75 per hours, and five hours on Saturday, July 25, at $12.10 per hour.  Doe’s weekly earnings are as follows:
 
Straight time:
 
 
 
$12.50/hr x 31 hrs

$387.50
 
$11.75/hr x 4 hrs
=
$47.00
 
$12.10/hr x 5 hrs
=
60.50
 
 
 
$495.00
$495.00
 
 
 
+
Overtime:
 
 
 
$6.25/hr x 5 hrs
=
$31.25
(July 23)
*$6.10/hr x 2 hrs
=
$12.20
(July 22)
**$6.05/hr x 5 hrs
=
$30.25
(July 25)
 
 
$73.70
$73.70
 
Gross wages earned
 
=
 
 
$568.70
 
      *To calculate 1/2 the weighted average on July 22:
 
($12.50/hr x 6 hrs) + ($11.75/hr x 4 hrs)
=
$122.00
$122.00 ¸ 10 hrs
=
$12.20
$12.20 x .5
=
$6.10
 
      **All work performed on Saturday, July 25, is overtime, as defined in ORS 279C.540.  Therefore, Doe is paid overtime pay for the entire five hours that he worked.
 
 
WEEK #3
 S
 M
 T
W
 T
F
 S
Total
 
26
 
27
 
28
 
29
 
30
 
31
 
 
 
 
6
 
10
 
10
 
10
 
10
 
4
 
 
 
50
 
On Sunday, July 26, Doe worked six hours at $10.50 per hour.  Since Sunday is a holiday as defined in ORS 279C.540, he is paid overtime for the entire day.  Doe worked at $12.50 per hour July 27-30.  On each of those days he worked two hours overtime, totaling eight hours of overtime pay.  On July 31 he worked four hours at $11.00 per hour.  Doe’s weekly earnings are as follows:
 
Straight time:
 
 
 
$12.50/hr x 40 hrs

$500.00
 
$10.50/hr x 6 hrs
=
$63.00
 
$11.00/hr x 4 hrs
=
44.00
 
 
 
$607.00
$607.00
 
 
 
+
Overtime:
 
 
 
$6.25/hr x 8 hrs
=
$50.00
 
$5.25/hr x 6 hrs
=
$31.50
(July 26)
 
 
$81.50
$81.50
 
Gross wages earned
 
=
 
 
$688.50
 
 
EXAMPLE 3:
 
For the example week ending June 3, John Doe worked a total of 61.5 hours.  Thirty of the hours in the example week were non-PWR, worked at the rate of $9.50 per hour; 31.5 hours were PWR, earned at the base rate of $16.99 and fringe rate of $5.97 per hour.  OAR 839-025-0050(2)(b) requires that when an employee works at multiple rates of pay and earns overtime, the overtime rate must be calculated using a weighted-average method based on all rates earned, as shown in this example.
 
 
S
M
T
W
T
F
S
Total
>40
 
28
 
29
 
30
 
31
 
1
 
2
 
3
 
 
PWR
Non-PWR
 
12
10
9.5
 
10
 
10
 
10
31.5
30
14
 
 
There were 7.5 hours of daily PWR overtime earned from June 29-31.  The 7.5 hours were subtracted from the 61.5 hours worked, leaving 54 hours that week.  Of these 54 hours, 14 were overtime hours over 40 in the workweek.
 
Straight time:
 
 
 
$9.50/hr x 30 hrs

$285.00
non-PWR
$16.99/hr x 31.5 hrs
=
+$535.19
+ PWR
 
 
$820.19
$820.19
Overtime:
 
 
 
*$820.19 ¸ 61.5
=
$13.34
 
**$13.34 x .5
=
$6.67
 
***$6.67 x 14
=
$93.38
 
 
 
 
 
*    Divide the total straight-time wages earned by the  total number of hours worked;
**   Multiply *  rate by .5; and
*** Multiply **  rate by the number of hours over 40 = weighted average portion of overtime still owed.
 
Total Wages Earned
=
$820.19
 
Weighted Ave. OT
=
$93.38
 
PWR Daily OT
=
$63.75
† (see below)
PWR Fringe Benefits
=
$188.06
‡ (see below)
 
Gross wages earned
 
 
                   $1,165.38

 
† (($16.99/hr x .5) x 7.5 hours daily PWR OT
‡ ($5.97/hr x 31.5 PWR hours)