Internal Costing Journal

The Internal Costing Journal (ICJ) inquiry page stores labor, equipment, mileage, materials testing usage, interfaced payroll and interfaced equipment information. This inquiry page is updated by the Internal Costing Usage Transaction and the Internal Costing system process.

Once a journal record is selected and processed, the Internal Cost Process Date field is populated by the Internal Cost Update job step (part of the Internal Costing system process). Similarly, when a journal record is processed by the Charge Transaction XML Generation job step (also part of the Internal Costing system process) the Internal Cost Charge Generation Date.

Field InformationField Information

The table below lists only those fields not already mentioned above (the two indications of system processing) and those listed in the Internal Costing Transaction section.

Field Name

Description

Standard Salary

This amount is calculated by multiplying the Regular Labor/Usage Units by the Salary Rate from the Employee Information or Internal Cost Rate. Multiple rates may be used in the calculation when the Usage Dates spanned multiple Employee Information records.

Standard Employee Benefits 1 – 5

These amounts are calculated by multiplying the Standard Salary amount by the applicable Employee Benefits Multiplier rate(s) from Employee Benefits Multiplier or Internal Cost Rate. Multiple rates may be used in the calculation when the Usage Dates spanned multiple records on Employee Benefits Multiplier.

Overtime Salary

This amount is calculated by multiplying the Overtime Labor/Usage Units by the Salary Rate from Employee Information or Internal Cost Rate. Multiple rates may be used in the calculation when the Usage Dates spanned multiple records on Employee Information.

If an Overtime Multiplier Code was specified, then each Salary Rate used in the calculation of Overtime Salary is multiplied by the Overtime Multiplier Rate.

Overtime Employee Benefits 1 - 5

These amounts are calculated by multiplying the Overtime Salary amount by the benefit rates from Internal Cost Rate or Employee Benefits Multiplier. Multiple rates may be used in the calculation when the Usage Dates spanned multiple records on Employee Benefits Multiplier.

Standard Cost

This amount is calculated by one of three ways based on Usage Group:

  • Mileage - Multiplying the Mileage Rate and Regular Labor/Usage Units

  • Materials Testing - Multiplying the Materials Testing Rate and Regular Labor/Usage Units

  • Equipment (either variant) - Multiplying the Equipment Usage Rate from Equipment or Internal Costing Rate and the Regular Labor/Usage Units. Multiple equipment rates may be used in the calculation when the Usage Dates spanned multiple Equipment records.

Fixed Cost

This amount is calculated when the Rate Category is Fixed by multiplying Regular Labor/Usage Units by the Equipment Rate from Equipment or Internal Cost Rate. Multiple rates may be used in the calculation when the Usage Dates spanned multiple records on Equipment.

Equipment Surcharge

This amount is calculated by multiplying the Regular Labor/Usage Units with the Equipment Surcharge Rate from Equipment or Internal Cost Rate. Multiple rates may be used in the calculation when the Usage Dates spanned multiple records on Equipment.

Total Costs

This amount is calculated in one of three ways based on Usage Type:

  • Labor – A summation of Standard Salary, Standard Employee Benefits (1 -5), Overtime Salary and Overtime Employee Benefits (1- 5)

  • Equipment (either variant) – A summation of Standard Cost, Fixed Cost and Equipment Surcharge

  • Materials Testing – Set to equal the Standard Cost amount

  • Mileage – Set to equal the Standard Cost amount

Overhead Basis

This field stores the sum of the Standard Salary, Standard Overtime, Standard Employee Benefits, and Standard Unpaid Employee Benefits fields. The Overhead Basis is multiplied by various overhead rates during the Internal Costing process to determine the overhead amounts.

Overhead Fiscal Year

The fiscal year derived from the Usage From Date.  The Overhead Fiscal Year can differ from the Fiscal Year for Pay Periods 1 and 26.

Division Overhead

Group Overhead

Section Overhead

District Overhead

Bureau Overhead

Unit Overhead

Sitewide Overhead

Overhead 1 - 4

Each is a separate amount updated by the Internal Costing process based on the Usage Group, COA, and rates setup on Internal Cost Overhead Rate (OHRTIC).

For Equipment, Chargebacks, and Other Usage Group, Unit Overhead is not applicable and is set to zero.