Shift roster weighted hourly pay · Calculation guide

Calculate weighted average hourly pay.

Calculation guide

Enter actual hours and full hourly rates, including premiums, for three shift groups. Set unused hours to zero.

weighted = (day*dayrate+eve*everate+night*nightrate)/(day+eve+night); gross = day*dayrate+eve*everate+night*nightrate

Inputs

Day-shift hours

Example entry 20.

Day hourly pay

Example entry 20 (in the selected currency).

Evening-shift hours

Example entry 12.

Evening hourly pay

Example entry 24 (in the selected currency).

Night-shift hours

Example entry 8.

Night hourly pay

Example entry 29 (in the selected currency).

Worked example

InputValue
Day-shift hours20
Day hourly pay20
Evening-shift hours12
Evening hourly pay24
Night-shift hours8
Night hourly pay29
ResultValue
Weighted average hourly pay23
Total shift pay920

Calculation steps

Weighted average hourly pay = ((((Day-shift hours × Day hourly pay) + (Evening-shift hours × Evening hourly pay)) + (Night-shift hours × Night hourly pay)) ÷ ((Day-shift hours + Evening-shift hours) + Night-shift hours))

((((20 × 20) + (12 × 24)) + (8 × 29)) ÷ ((20 + 12) + 8)) = 23

Total shift pay = (((Day-shift hours × Day hourly pay) + (Evening-shift hours × Evening hourly pay)) + (Night-shift hours × Night hourly pay))

(((20 × 20) + (12 × 24)) + (8 × 29)) = 920

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Day-shift hours2022Weighted average hourly pay2322.857143
Day hourly pay2022Weighted average hourly pay2324
Evening-shift hours1213Weighted average hourly pay2323.02439
Evening hourly pay2426Weighted average hourly pay2323.6
Night-shift hours89Weighted average hourly pay2323.146341
Night hourly pay2932Weighted average hourly pay2323.6
Shift roster weighted hourly pay →