Percent Burden and Payroll Overhead in Cost Center Companies

Question

How does Spectrum treat Percentage Burden and Payroll Overhead in a cost center company? The best way to explain this is to use an example.

Setup Job Details: Job 800 is assigned to cost center 401. It also has a 15% burden, and a 10% payroll overhead set up on it. This job has one phase, 01-0200 with cost types (L)abor, (B)urden, (M)aterials and (O)ther. The phase has no cost center assigned to it.

Employee: My employee has a home cost center of 201.

Payroll Cash Account: My payroll cash account has a cost center of 101.

Payroll Department: This is the information found in the PR Department File.

Labor

10-5100 (Direct Labor)

Burden Components

40-9200 (Indirect PR Taxes)

% PR Burden DR

10-5200 (Direct PR Taxes)

% PR Burden

CR 40-9250 (Allocated Burden)

% Overhead DR

10-5255 (Direct OH)

% Overhead CR

40-9255 (Allocated OH)

Cost Centers "Approved" to use: All

Processing Steps

  • Create a new pay cycle using: Employee Cost Group: ALL Check Cost Group: 101 Bank Account: 5 (defaulted to this account per setup) Shut off all add-ons and deductions as this makes it easier to reconcile.

  • In Time Card Entry, charge 40 hours to job 800, phase 01-0200, cost type L.

  • Calculate the pay cycle, print reports and review findings.

Findings

Direct Labor

Direct labor is charged to the job's cost center. The offset is inter-post.

JE # 1

CC

GL Code

DR

CR

DR

401

Direct Labor

$1,400.00

CR

401

Inter-Post

$1,400.00

Actual Taxes, Workmen's Comp and Union Fringes (aka Indirects)

The actual taxes, workmen's comp and union fringes will be charged to the job's cost center with an offset to inter-post.

JE # 2

CC

GL Code

DR

CR

DR

401

Indirect PR Taxes

$182.43

CR

401

Inter-Post

$182.43

JE # 3

DR

101

Inter-Post

$182.43

CR

101

PR Taxes Payable

$182.43

Employer's Portion of Taxes Expanded

CC

GL Code

DR

CR

CR

101

PR Taxes Payable

$107.10

CR

101

PR Taxes Payable

$28.00

CR

101

PR Taxes Payable

$7.84

CR

101

PR Taxes Payable

$4.90

CR

101

PR Taxes Payable

$34.59

JE # 4

DR

101

Inter-Post

$1,400.00

CR

101

Cash

$1,105.69

CR

101

PR Taxes Payable

$294.31

Employee's Portion of Taxes Expanded

These amounts are offset by the reduction of the cash outlay to employee, also within the same cost center, 101. In other words, no inter-post entries are needed for this portion of the journal entry.

CC

GL Code

DR

CR

CR

101

PR Taxes Payable

$154.00

CR

101

PR Taxes Payable

$107.10

CR

101

PR Taxes Payable

$10.50

CR

101

PR Taxes Payable

$22.71

Percentage Burden Calculations

The job was properly charged 15% of direct labor ($1,400 x 15% = $210.00). As we charged the actual burden items to cost center 401, we must also credit them out using cost center 401.

JE # 5

CC

GL Code

DR

CR

DR

401

Direct PR Taxes

$210.00

CR

401

Inter-Post

$210.00

Payroll Overhead (% Method)

The job was properly charged 10%. ($1,400 + $210 = $1,610. $1,610 x 10% = $161.00).

JE # 6

CC

GL Code

DR

CR

DR

401

Direct overhead

$161.00

CR

401

Inter-Post

$161.00

Note that the pool of costs that are to be allocated to jobs must also be charged to cost center 401!

Assets

Cash - 101

Inter-Post - 101

Inter-Post - 401

1,105.69

4

1,400.00

1

3

182.43

182.43

2

4

1,400.00

Liabilities

PR Taxes Payable - 101

182.43

3

294.31

4

Direct Cost Section

Direct Labor - 401

Direct Burden - 401

Direct Overhead - 401

1

1,400.00

5

210.00

6

161.00

Indirect Cost Section

Indirect Burden - 401

Indirect OH - 401

2

182.43

210.00

5

161.00

6