Anchor | ||||
---|---|---|---|---|
|
...
Calculating actual labor costs | |||
---|---|---|---|
| Formula | Amount | |
Pay rate per hour | $25 | $25 | |
Overhead percentage | 25 x 40% | $10 | |
Fixed overhead per hour | $10 | $10 | |
Total cost per hour | pay rate + overhead% + fix overhead | $45 | |
Total cost to invoice | $45 x 3 | $135 |
...
- Select Microsoft Dynamics GP > Tools > Setup > Service Management > Invoice Setup > Labor Rates.
- Complete the following fields.
- Labor Rate Group Name
Create a name for the labor rate group. - Position
Use the lookup window to select the position to which this labor rate should apply. Pay Code
Pay codes are used to distinguish between labor rate groups with the same name and position. Each group may have multiple billing amounts (rates) for a combination of positions and pay codes. For example, a Preferred labor group may have an overtime rate and a regular time rate for technicians, supervisors, and helpers.Note Position and pay code set up in Microsoft Dynamics GP must match the position and pay code in Service Management's labor rate group.
- Labor Rate Group Name
- Description
Enter a description. For example, Supervisor - Regular or Supervisor - Overtime would differentiate one pay code from another. - Fixed OH per Hour
The fixed overhead per hour is a flat amount charged to recoup overhead costs such as union fringe benefits paid per hour. The amount appears in the Extended Cost + Overhead field of the Added Costs window for labor. It constitutes the overhead portion of the amount - the extended portion is the pay rate multiplied by the number of hours. - OH Percentage
The overhead percentage is a percentage charged to cover overhead costs, such as social security, workers compensation insurance, vehicle operating expenses, or unemployment taxes. Your overhead percentage may include general and administrative expenses that you may wish to apply as a percentage of labor cost. The OH Percentage field can contain up to five numbers. The amount appears in the Extended Cost + Overhead field of the Added Costs window for labor. It constitutes the overhead portion of the amount - the extended portion is the pay rate multiplied by the number of hours. - Billing Amount
The Billing Amount field shows the rate charged for the labor group name, specific position, and corresponding pay code. Leave the field blank to create a zero-dollar billing amount. - Select Save to add the record to the scrolling window and add the labor group name to the Labor Rate Group Name lookup window.
...
Note |
---|
You must mark the setup option in the Service Options window to use overhead amounts from Job Cost. Without marking this setup option, you will not see the Overhead Detail Code window or the Overhead Group Setup window as specified in the following steps. See Choosing Service Options. |
Step 1: Create overhead detail codes.
Overhead detail codes define how overhead amounts are calculated based on payroll costs. You can recognize indirect labor costs, not typically set up as cost codes on an hourly or piecework basis, as overhead. These costs are added to posted amounts for the details and are not identified separately on customer invoices.
- Select Microsoft Dynamics GP > Tools > Service Management > Invoice Setup > Labor Rates > Overhead Detail Code.
- Complete the following fields, as necessary.
- Overhead Code, Description
Enter a name and description for the code. - Allocation Method
From the drop-down list, assign a method of calculating overhead for the detail code. Enter an amount in one of the following fields, depending on the option you chose. - Fixed Portion
Allows you to allocate overhead for payroll transactions on a cost-per-unit basis. For example, if you want to apply hourly overhead to account for the cost of travel to and from a job site, you could add $1.50 per hour (the unit of measure) with an overhead detail code. - Percent Portion
Allows you to allocate overhead for payroll transactions on a percentage basis. For example, you can set up an overhead detail code for the cost of taxes incurred on an employee's pay rate, that which adds 16 percent of the wages.
- Overhead Code, Description
- Select Save.
Note |
---|
If you modify the overhead detail codes in the future, posted transactions will not be affected. |
Step 2: Create overhead groups.
Overhead group codes organize overhead detail codes logically per departments, positions, and pay codes. For example, you could set up detail codes for hourly compensation, overhead, and travel time. These details can be combined under a group code named Hour. The group code is applied to technicians assigned to the installation department.
...
Note |
---|
Overhead groups should be set up with different combinations of department, position, and pay code. For example, the combination of SRV, ENG, and HOUR should not appear in more than one overhead group. |
Step 3: Create labor rate groups.
Labor rate groups are built using overhead groups created from Service Management or Job Cost. Use the Labor Rate Group Setup window to do this. You can also add a billing amount and description to each overhead group record.
...