Calculate Estimated Gross

The Calculate Estimated Gross process determines the estimated gross for each row contained in the Intermediate Payable Time Table when you set the Calc Estimated Gross field on the TL Installation page to Y (yes).

The system uses the following formula to calculate the gross:

TL_QUANTITY X (COMPRATE + FACTOR_RATE_ADJ) X FACTOR_MULT

The components of this formula are defined as follows:

Components/Fields Definition

TL_QUANTITY

The quantity entered by the time reporter or taken from the time reporter's schedule.

COMPRATE

Either a rate or a compensation rate code. The derivation of the rate code is explained in Step 1 under Calculate Estimated Gross.

FACTOR_RATE_ADJ

The Rate Adjustment Factor defined for the TRC on the TRC 1 page.

FACTOR_MULT

The Multiplication Factor defined for the TRC on the TRC 1 page.

To calculate estimated gross:

  1. Derive the Comp Rate.

    The Time Administration process derives the Rate in the Comp Rate variable as follows:

    1. When a time reporter enters an override rate on the time reporting pages, the system uses this rate. This rate resides in the Intermediate Payable Time Table TL_IPT1.

    2. When a time reporter enters a comp rate code on the time reporting pages, the system attempts to derive the rate in the Comp Rate Code (CRC) from the following locations in this order:

  2. The Comp Rate Code Table (PS_COMP_RATECD_TBL). If the comp rate is not there, it then checks:

  3. The Compensation Table (PS_COMPENSATION); if the comp rate is not there, it then checks:

  4. The Job Code Table (more specifically, the PS_JOBCD_COMP_RATE field on PS_JOB).

    1. If no rate or comp rate code is reported, the system checks for a rate on the TRC Table.

      Note:

      If the Comp Rate Code (CRC) is HF (hourly + flat), the reported rates are added to the amount on the CRC and then inserted into the basic formula. If the CRC is PH (percent of hourly), the percent is calculated against the reported rate before inserting into the basic formula.

    2. If the system finds nothing in these locations, it uses the hourly rate associated with the TRC in the Intermediate Payable Time Table TL_IPT1.

      Note:

      When a TRC is of type Amount, the Quantity (QTY) is placed into the Estimated Gross field in Intermediate Payable Time. Other calculations are bypassed. If the TRC is of type Amount and is mapped to a NA Payroll Earnings Code where Mult Factor = 0, then the amount passed to IPT for Est Gross will be 0.

    3. If the system cannot find the information in the previous locations, it takes the hourly rate from the JOB Table to use in the calculation.

  5. Calculate Estimated Gross.

    If Reported Hours is not zero, the Estimated Gross amount is calculated using this formula:

    TL_QUANTITY X (COMPRATE + FACTOR_RATE_ADJ) X FACTOR_MULT

    The Estimated Gross amount is written to the Estimated Gross work Table (TL_W2_EST_GRS) to be used in the final step.

    Note:

    If a reported amount is populated in the Intermediate Payable Time Table, this amount automatically becomes the Estimated Gross amount. No further calculation is needed.

  6. Update IPT Estimated Gross.

    This step populates the Estimated Gross field on the TL_IPT1 record with the Estimated Gross amount contained on the Estimated Gross Work Table.