Standard payroll cost to Job - actual payroll cost to overhead
Steve Hunt
I am looking for a Profitool solution for the following scenario:
* Superintendent works on job 1234, 40 hours each week, plus occasional OT.
* Weekly time sheet reports time on job 1234.
* Rather than showing actual payroll costs in job 1234, would rather show a standard cost per hour in job 1234.
* Would rather actual payroll costs post to overhead job.
* To prevent overstating overall cost, the above scenario would also require a process to subtract from overhead the standard cost already posted to job 1234.
* The net effect in overhead cost would be any difference between actual and standard.
The only ideas I have so far are...
* Journal entry. Not a good solution as information would be delayed until JE was posted. Prefer an answer that works and posts simultaneously with payroll process.
* 3 lines of data entry for each payroll entry.
o Example:
? Line 1: Superintendent's actual time on job 1234. Use pay rate over ride on this line = Standard Hourly Rate
? Line 2: Superintendent's actual time input as negative hours to overhead job. Use pay rate over ride on this line = Standard Hourly Rate
? Line 3: Superintendent's actual time input into OH. Pay rate over ride NOT used on this line.
o Result of the above 3 lines should be that hours and standard rate post to the actual job. Zero hours post to overhead. Difference between standard and actual cost post to overhead.
o The 3 line entry is cumbersome and subject to human error and omission.
* SA ALLOC RULE. I don't think this function works across companies, so not an option.
Anybody have a similar scenario already solved?
Thanks,
Steve
Tamblyn, Gary M.
Steve,
One piece of information about SA ALLOC RULE, in case it becomes part of a solution, is …
Inter-company Transactions
--------------------------
This selection may be used for generating inter-company
transactions from the allocation entries where applicable. The
selection SA AUTHORIZE ICT is used initially to establish the Job
or Ledger Account that is subsequently used on this screen in the
three different 'Account' fields:
Basis Account
Debit Account
Credit Account
This information, plus a much lengthier description of the control you have over accruals generated by SA ALLOC RULE, can be found in the Help documentation on the SA ALLOC RULE screen.
As usual in Profitool, an intercompany transaction triggered when the a $charge is debited and credited to jobs that are in different coids.
Gary
From: PT_U...@googlegroups.com [mailto:PT_U...@googlegroups.com]
On Behalf Of Steve Hunt
Sent: Tuesday, October 06, 2015 11:19 AM
To: '(pt...@ptug.org)'
Subject: {PTUG} - Standard payroll cost to Job - actual payroll cost to overhead
PTUG –
I am looking for a Profitool solution for the following scenario:
· Superintendent works on job 1234, 40 hours each week, plus occasional OT.
· Weekly time sheet reports time on job 1234.
· Rather than showing actual payroll costs in job 1234, would rather show a standard cost per hour in job 1234.
· Would rather actual payroll costs post to overhead job.
· To prevent overstating overall cost, the above scenario would also require a process to subtract from overhead the standard cost already posted to job 1234.
· The net effect in overhead cost would be any difference between actual and standard.
The only ideas I have so far are…
· Journal entry. Not a good solution as information would be delayed until JE was posted. Prefer an answer that works and posts simultaneously with payroll process.
· 3 lines of data entry for each payroll entry.
o Example:
§ Line 1: Superintendent’s actual time on job 1234. Use pay rate over ride on this line = Standard Hourly Rate
§ Line 2: Superintendent’s actual time input as negative hours to overhead job. Use pay rate over ride on this line = Standard Hourly Rate
§ Line 3: Superintendent’s actual time input into OH. Pay rate over ride NOT used on this line.
o Result of the above 3 lines should be that hours and standard rate post to the actual job. Zero hours post to overhead. Difference between standard and actual cost post to overhead.
o The 3 line entry is cumbersome and subject to human error and omission.
· SA ALLOC RULE. I don’t think this function works across companies, so not an option.
Steve Hunt
Gary,
Thanks for responding. I remember trying SA ALLOC RULE years ago and had great success as long as both sides of the reallocation existed in the same COID. SA ALLOC RULE seemed to ignore the rule if it concerned different COID’s. Very possibly human (me) error in implementation.
I just looked at the SA ALLOC RULE screen again and still don’t think it’s the solution this time. It allows a percentage of the original transaction to be allocated. In my current scenario, I would need something to allocate an hourly rate, regardless of the actual rate. The actual rates vary greatly between superintendents.
Still, good information for another situation, I’m sure.
Thanks so much!
Steve
--
You have received this message, because you are a subscriber of "Profitool User Group" forum. For more information please visit this group at
http://www.ptug.org
To post to this group, send email to PT...@ptug.org
---
You received this message because you are subscribed to the Google Groups "Profitool User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
PT_Users+u...@googlegroups.com.
To post to this group, send email to PT_U...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Varoujan Adamian
115 S Lamer Street, Ste D | Burbank, California | 91506
-------------------------------------------------------------------------------------------