Full Sail Partners Blog

Everyone seems to have an opinion on how labor cost should be charged to projects. In Vision, there are two ways to charge labor cost to your projects. Some firms prefer to load an hourly rate for both hourly and salaried employees. And some firms prefer to load a salary rate for salaried employees and an hourly rate for hourly employees and use the Adjust Salary Job Cost utility (ASJC) in Vision.

The Adjust Salary Job Cost utility is Vision's way of taking the employee’s salary rate and calculating a cost rate based on the hours worked (instead of standard hours in a period). The ASJC utility is run after timesheets are posted and adjusts the posting so that the costs posted agrees to what is being paid to the employee.

So what does this mean?

First, let’s discuss those firms that load an hourly rate for salaried employees.  Assume that this firm has bi-weekly timesheet and pay periods. Let's look at an example without ASJC:

Example: Mike Jones is a salaried employee and is paid $3,000.00 bi-weekly, and he has an hourly cost rate in the Employee Info center of $37.50/hour ($3,000.00/80 hours). When timesheets are posted, Vision multiplies the actual number of hours worked by the hourly rate from the employee info center record. Vision will post a debit to the direct and/or indirect labor account and credit the Job Cost Variance (JCV) account. Mike’s hours are applied at a cost rate of $37.50 for every hour he works regardless of how many hours he works.  

When payroll is posted, we would see a debit to the JCV account for Mike’s bi-weekly salary - $3,000.00. If Mike had worked 85 hours in an 80 hour timesheet period, the JCV account would be ($187.50) because the credit posted to JCV was $3,187.50 at the time of timesheet posting and the debit posted for payroll is $3,000.00. If Mike had only worked 75 hours during the timesheet period, the JCV account would be a positive $187.00.

Now let’s talk about those firms that load a salary amount in the Employee Info Center. We will use the same bi-weekly timesheet and pay period frequencies as in the first example. When a salaried employee works more or less than 80 hours, Vision handles the cost exactly the same way it does as if an hourly rate was loaded in the Employee Info Center at the time of time sheet posting. To get the cost rate, Vision looks at the salary rate in the employee info center, divides that by the frequency (in this case 80 hours) and multiplies that by the number of hours on the timesheet.

This is where Adjust Salary Job Cost comes into play. Once run, AJSC takes the salary rate and divides it by actual number of hours worked and multiplies the number of hours worked.

Example:  Mary Smith has a bi-weekly salary of $3,000.00 and she has 85 hours on her timesheet. When timesheets are posted, Vision takes her salary rate and divides it by 80 (bi-weekly frequency) and multiplies the result by the actual number of hours on her timesheet.  You would see a debit to direct/indirect labor account and a credit to the JCV account for $3,187.50. Just like the firm using an hourly rate in the employee info center.

Now when ASJC is run, Vision takes the salary rate, divides it by the actual number of hours worked ($3,000.00/85 = $35.29411) and applies the result to the actual number of hours worked ($35.29411 * 85 = $3,000.00). Vision makes an adjustment to the original timesheet posting to credit the direct/indirect labor account and to debit the JCV account in the amount of $187.50.  Since Mary is paid $3,000.00 per pay period, the JCV account would not show a balance when payroll is posted.

How cost rates are loaded in Vision affects the way labor costs are reported on the projects and the General Ledger. Here are some of the differences:

• Load Hourly Rate in Employee Info Center:

  • Time posts to projects at hours worked at standard hourly rate.
  • No additional steps by accounting.
  • Costs posted to direct projects are not consistent with actual payroll paid when employees work more/less than standard hours.  Over/Under balances are carried in the JCV project.
  • Project managers have stable costs to track project performance.
  • General Ledger carries a balance in the JCV account that is reflective of the amount paid to employees over/under the actual hours worked.
     
• Load Salary Rate in Employee Info Center and use ASJC:
• Time posts to projects at hours worked at variable hourly rates for Salaried employees (hourly rate changes on hours worked in any given period).
• Accounting must run the ASJC utility after time sheet postings for salary job costing to occur.
• Costs posted to direct projects are consistent with actual payroll paid when employees work more/less than standard hours.  No balances are carried in the JCV project.
• Project managers have to manage variable costs over which they have no control.
• General Ledger does not carry in the JCV account that is reflective of the amount paid to employees over/under the actual hours worked.

As you can see, both choices have pros and cons, but having a clear understanding of how the ASJC utility works in Vision will help you make the right choice for your firm. Ready to learn more? Empower yourself and your firm by conducting a Navigational Analysis.