View Single Post
 
Old 06-01-2015, 02:37 PM
phowe43 phowe43 is offline Windows 8 Office 2013
Novice
 
Join Date: Jun 2015
Posts: 2
phowe43 is on a distinguished road
Default Formula to determine Earned Hourly Rate

Somewhat complicated...at least for me. Our company does not pay overtime (don't ask....it's a trucking company and falls under Intrastate exemption).

I'm trying to back into the ACTUAL earned hourly rate if an employee WAS paid overtime.

For instance;
Employee "A" earned $1,000 for the week, but worked 50-hours. His current Earned Hourly rate is $20 for ALL hours worked.

If we were to pay O.T at 1.5X, what would his "straight" time be for the first 40-hours?
I.E., Straight time rate = $XX (X) 40-hours
Overtime rate = $XX (X) 10-hours.

Is there a formula that can be built to reflect such?
Reply With Quote