Labor Burden Rates

Does anyone out there use standard labor burden rates?  If so, how did you get the payroll calculation give you the desired result.

Background: In our cost plus contracts we agree with the client on a fixed rate for all our construction personnel that work on a specific project. The payroll portion of Sage 100 contractor will calculate the job costs based on whatever calculations are set up for a particular employee. I need to have the job cost show up in the labor and/or job cost journal at the agreed upon rate.  The concept is the same one used in standard costing. I have been able to approximate these rates by adding in new calculations to get the job cost reflecting the rates but it is not perfect and it can get quite confusing.  I was just wondering if someone else out there has found an easier way to do this and save me a lot of time recreating the wheel.

E-mail address:  [email protected]

Parents
  • 0

    Joe, I need the established rate to show up in the job costs journal as the job cost.  To be more clear I will use a short hypothetical example.  Assume the established rate for your project manager was $50 and his salary comes out to a rate of $30 per hour. Forgetting for now all the other employer related costs that go into making up the actual job cost, I need the rate to show up in the job cost journal at the $50 per hour or fraction there of (1/2 hour would show $25). I understand standard cost and only mentioned that because the concept is similar. In your answer(specifically your second paragraph), you mention Sage payroll calculator.  I assume you are referring to the payroll calculation the  system uses  to determine job costs etc. Do you use a specific payroll calculation to achieve the desired rate? I have, in a test company, put in a payroll calculation that along with the normal calculations will bring the rate up close to  the desired standard rate but have not been able to hit it right on the money all the time. if someone logs in more than 40 hours in a week, that will throw off the calculation.It just may be the best this system can do. Thank you for your help. Richard

  • 0 in reply to RichM

    Hi Rich,

    Do you guys do Progress Billing or T&M Billing?  

    If you use T&M Billing, then the Billable Rate is set up in the T&M Wage Rates 3-10-5.  Assign a $50 for each Laborer, or you could look into using PayGroups for different profiles of Wage Rates depending on the job.  Then calc your labor records and Create the T&M Invoice.

    If you use Progress Billing & and Job-Cost Reports (like Progress Billing Summary by Cost Code or Division), then the Allocations (hidden markup) are rolled up into the Cost Amount in 6-3 Job Cost Records.  

    The Cost Amount will never be exactly $50 per hour because the Actual Calculated Payroll Cost is Sourced from the GL Link.  Also, because tax withholding is different for each payee.  The only way to adjust the Bill Rate within the Job Cost Journal is to go to the specific job cost and click the Time & Materials Billing tab and Override the Billing Amount.

    I think I understand your problem, and I think the simplest answer will depend on how you bill... each job cost record defaults the "Billing Amount" to the "Cost Amount."   You can change the "Billing Amount" in each Job Cost Record, or you can Change the "Cost Amount" by using a Payroll Calculation - which will not ever be a pre-set Bill Rate.  The whole idea of the "Cost Amount" being the Actual Cost," is so that the system can calculate the difference between the Cost and the "Billing Amounts" to determine Real gross profit.

    If my understanding is correct, the solution to your query I think lies in the T&M Wage Rates Table 3-10-5.

    If you are Progress Billing using % Complete Calculation Method and you want Labor Totals to calc on Billable Rate instead of Actual Cost, then I would be curious to know why you are Progress Billing at all...

    Hopefully this is helpful... let me know!

Reply
  • 0 in reply to RichM

    Hi Rich,

    Do you guys do Progress Billing or T&M Billing?  

    If you use T&M Billing, then the Billable Rate is set up in the T&M Wage Rates 3-10-5.  Assign a $50 for each Laborer, or you could look into using PayGroups for different profiles of Wage Rates depending on the job.  Then calc your labor records and Create the T&M Invoice.

    If you use Progress Billing & and Job-Cost Reports (like Progress Billing Summary by Cost Code or Division), then the Allocations (hidden markup) are rolled up into the Cost Amount in 6-3 Job Cost Records.  

    The Cost Amount will never be exactly $50 per hour because the Actual Calculated Payroll Cost is Sourced from the GL Link.  Also, because tax withholding is different for each payee.  The only way to adjust the Bill Rate within the Job Cost Journal is to go to the specific job cost and click the Time & Materials Billing tab and Override the Billing Amount.

    I think I understand your problem, and I think the simplest answer will depend on how you bill... each job cost record defaults the "Billing Amount" to the "Cost Amount."   You can change the "Billing Amount" in each Job Cost Record, or you can Change the "Cost Amount" by using a Payroll Calculation - which will not ever be a pre-set Bill Rate.  The whole idea of the "Cost Amount" being the Actual Cost," is so that the system can calculate the difference between the Cost and the "Billing Amounts" to determine Real gross profit.

    If my understanding is correct, the solution to your query I think lies in the T&M Wage Rates Table 3-10-5.

    If you are Progress Billing using % Complete Calculation Method and you want Labor Totals to calc on Billable Rate instead of Actual Cost, then I would be curious to know why you are Progress Billing at all...

    Hopefully this is helpful... let me know!

Children
No Data