Automating Job Costing Overtime, an 800 pound gorilla with an attitude

Calculating and distributing employee overtime is a burdensome process that many business owners and payroll administrators have to deal with on a weekly basis.  Everyone has a different opinion on just “HOW” that overtime is to be calculated and distributed.  By everyone, I mean the business owner, the payroll clerk, heck even the Federal and State government.  No wonder it’s just a problematic situation!

job costing overtime - an 800 lb gorillaAt first blush this seems drop dead simple.

Overtime goes to the time worked after 40 hours, or maybe over x hours per day as well.  This seems reasonable, but would it be simpler if overtime were just distributed over all the jobs that the employee worked that week.  That seems fairer, as each job gets a share of the overtime costs for that week.

Then again, maybe the overrun that messed with scheduling to cause overtime in the first place happened at the start of the week, the jobs at the end of the week, just so happen to be all overtime hours because of that job.  So the job that really should have the overtime attributed to it, gets none or only a share of the overtime, while the innocent jobs that went as planned bear a higher, “undue” or “unfair” cost.  Heck the job that caused the delays and overruns might have happened the week before.

One should also consider costing all time at the regular rate, and then costing all overtime to the overhead job.

And now don’t forget to do weighted average overtime after the overtime is initially calculated adds another layer of … well … shall we say obfuscation.

Even on a case by case basis, there often is no clear right or wrong answer.  Maybe there is a reason Job Cost Accounting is consider such a bear by so many and why some accountants avoid it at all costs.

Automatically distributing overtime, like Crew Overtime Entry Solution can do, will either occur after the 40 hours / x hours per day, or it can average weight distribute overtime over all jobs.  Or it can leave your entered hours alone and just make an overtime adjustment to an overhead job.  But even with automation there will be basic tradeoffs that will occur.

For usually straight forward set in stone accounting, this area is decidedly gray.

 

2 thoughts on “Automating Job Costing Overtime, an 800 pound gorilla with an attitude

  • Rebecca,

    Yes, exactly the issues we grappled with when we designed and wrote Crew Overtime Entry Solution. There are 4 main ways it can distribute overtime. Each has at least one drawback and a virtue or two. And dealing with different state rules presents further issues. Like if an employee works 4 or more hours for 5 consecutive days, then the first 8 hours for the rest of the week are overtime and anything over 8 hours is double time.

    One of the nicest things about the program is the ability to enter your pay rate schedule (along with an overtime rate that accounts for cash benefit rates) and have the program make sure that payroll item is in the employee’s record for the pay calculation.

    Ben

  • Yes, overtime is an issue especially now that construciton is in full swing. It is even more complicated when doing prevailing wage jobs. If an employee works on two different prevailing wage jobs in two different areas or job categories, determing the OT rate can be tricky. If OT is calculated by hours worked per day then you can end up with multiple OT rates in the same pay period. If it is calculated by the week the employer may want to make sure the employee is working at a lower rate job by the end of the week to avoid paying a higher hourly rate. We as bookkeepers feel overwhelmed at times, just trying to remember all the rules.

Comments are closed.