QRG Rate Calculator Template - Final Setup

​

Purpose

The purpose of this quick reference guide is to step through the process of completing the Final Setup of the Rate Calculator Template. The intended audience for this document is System Administrators / Standard Users. The final setup of a Rate Calculator Template consists of the following tasks:

• Add or Exclude Project Codes
• Add Mark Up / Margin Record
• Add Pay Rates
• Add Pay Rate Loadings
• Calculate and Manage Rate Calculator Lines

Project Codes enable the creation of additional Rate Calculator Lines related to the selected Project Codes/Timesheet Activities. The Mark Up / Margin Rates populated within a Rate Calculator define the calculation method and the amount that will be applied to each Rate Calculator line. The Pay Rates populated within a Rate Calculator define the Rate that will be applied to Pay Codes in each Rate Calculator Line. The Pay Rate Loadings populated within a Rate Calculator record define the Shift or Casual Loading Rates to be applied to Pay Codes in addition to the defined Pay Rates. Rate Calculator Lines are the records that utilise the information captured within Rate Calculators to calculate Invoice Rates, and other associated costs for each Rate Calculator, once the Rate Calculator record has been created and populated with at least one of each of the following records:

• Location
• Employment Cost
• Interpretation Rule(s) and related Pay Code(s)
• Mark Up / Margin
• Pay Rate

​

Steps

Prerequisites You must complete the initial setup of a Rate Template before using this QRG. For more information, please refer to the QRG Rate Calculator Template - Initial Setup. Add or Exclude Project Codes To add or exclude Project Codes to a Rate Calculator Template, follow the steps below:

2. Navigate to the Manage Pay and Project Codes section of the Manager page (see Figure 6).
3. To filter available Project Codes for selection, populate an Assignment or Account from the Search Assignments and Search Accounts lookup fields (see Figure 6).

6. To save the changes made to Project Codes, click on the Save button (see Figure 9). The Rate Calculator will be updated with Project Codes Available or Excluded.

​

add a Mark Up / Margin

To add a Mark Up / Margin Rate to a Rate Calculator Template, follow the steps below:

2. In the new line that appears, populate the following required fields to define the Rate Type and amount (see Figure 11):
   1. To define when this applies from, populate the Effective Date field.
   2. To define the Calculation Method, select from the available picklist options in the Calculation Method field.
   3. To define the rate or amount for the Mark Up / Margin Rate, populate the Rate 1 field.
3. Populate the following optional fields as required (see Figure 11):
   1. Calculation Type
   2. Calculation Description
   3. To calculate a second Invoice Rate, populate the Rate 2 field.

7. Once all required Mark Up / Margin Rates have been added, click on the Save All button to update the Rate Calculator (see Figure 14).

​

Add Pay Rates

To add a Pay Rate to a Rate Calculator, follow the steps below:

1. To add a single Pay Rate that will apply to all Pay Codes defined in this Rate Calculator:
   1. Navigate to the Pay Rates section and click the Select All button, then click on the + Add button (see Figure 15).

   
   2. In the new line that appears, populate the following required fields to define the Rate Type and the Rate amount (see Figure 16):
      1. Effective Date
      2. Rate Type
         • Base Pay Rate
         • Pay Rate
         • Total Pay Rate
         • Charge Rate
      3. Populate the Pay Rate in the Entered Rate field.
   
   3. Click on the Save button (see Figure 17).

   
2. Alternatively, to add a Pay Rate and apply it to Pay Codes individually:
   1. Navigate to the Pay Rates section and select the Pay Codes the new Pay Rate will be applied to (see Figure 18).
   
   2. Click on the + Add button (see Figure 19).

   
   3. In the new line which appears, populate the following fields to define the Rate Type and the Rate amount (see Figure 20):
      1. Effective Date
      2. Rate Type
         • Base Pay Rate
         • Pay Rate
         • Total Pay Rate
         • Charge Rate
      3. Populate the Pay Rate in the Entered Rate field.
   
   4. Click on the Save button (see Figure 21).

   

5. Once all required Pay Rates have been added, click on the Save All button to update the Rate Calculator (see Figure 23).

​

Add Pay Rate Loadings

To add a Pay Rate Loading to a Pay Code, follow the steps below:

1. Navigate to the Pay Rate Loading section and click the Apply Pay Code button (see Figure 24).

4. The Pay Codes Applied field will now be updated with the selected Pay Codes (see Figure 27).

5. Repeat steps 1-4 for all required Pay Rate Loadings.

​

Calculate and Manage Rate Calculator Lines

​

Calculate Lines for Rate Calculators

To calculate Rate Calculator Lines, follow the steps below:

1. Identify the Rate Calculator Lines section within the Rate Calculator Builder (see Figure 28).

2. If no existing Rate Calculator Line are displayed, or to update existing Rate Calculator Lines, click on the Save and Calculate button. (see Figure 29). OR If existing Rate Calculator Lines have failed calculation, click on the Update Failed to Ready button and click Save and Calculate (see Figure 30).

To apply rounding to a Rate Calculator Line:

1. Click the drop-down next to a Rate Calculator Line and select Apply Rounding (see Figure 31).
   OR
   Select the Apply Bulk Rounding button to display and apply rounding to all Rate Calculator Lines (see Figure 31).
   
2. To round up the Pay Rate, enter the rounding value in the Pay Rate Rounding fields. To round down, enter the rounding value with a minus - symbol in front of it (see Figure 32).
3. To round up the Invoice Rate, enter the rounding value in the Invoice Rate Rounding fields. To round down, enter the rounding value with a minus - symbol in front of it (see Figure 32).
4. To remove any unsaved changes made to values on Pay Rate and Invoice Rate Rounding fields, click on the Undo button. To remove any saved changes made to values on Pay Rate and Invoice Rate Rounding fields, click on the Reset button (see Figure 32).
5. To apply the rounding changes to Pay Rates and/or Invoice Rates, click on the Apply Rounding button (see Figure 32). In the event of a change to a Rate Calculator Line, any applied rounding will remain on the Rate Calculator Line. If rounding is no longer required, it must be removed by applying rounding again using a value that negates the previous rounding applied.

The Rate Calculator Lines will now be updated with rounding for Pay Rates and/or Invoice Rates. Override Rate Calculator Rates To override the values for any of the Rate or Total Cost fields on a Rate Calculator Line:

1. Click the drop-down next to a Rate Calculator Line and select Apply Override (see Figure 33).
   OR
   Select the Apply Bulk Overriding button to display and apply overrides to all Rate Calculator Lines (see Figure 33).
   
2. In the window that appears, enter the override value(s) in the applicable Override Rate fields (see Figure 34).
3. To apply the updated values to Rate fields, click the Apply Overriding button (see Figure 34). To remove any unsaved changes made on Override Rate fields, click on the Undo or Reset button as required.

4. The Rate Calculator Lines will now be updated with the overridden Rates.

​

Field descriptions

​

Further information