Resource Cost and Price Hierarchies

Resource pricing hierarchies are used to determine the Resource Cost or Price based on certain data entered in Timesheets, Time Journals, Project Journals, or Sales Orders and Sales Invoices. The data that is used to retrieve the Resource Cost or Price includes:

  • Start Date
  • Project Number
  • Task (price only)
  • Work Type
  • Currency
  • Unit of Measure (UOM)
  • Resource Number or Resource Group, or Resource Sub Group, or All

The hierarchy that a Resource Cost or Resource Price is selected on a given transaction goes from the most detailed parameter to the least detailed.

For example, when a time entry is created, the system first evaluates based on data entered in the transaction to determine whether a Resource Price Plan or a Resource Cost Plan exists that matches what was entered (i.e., Start Date, Project Number and/or Task, Work Type, Currency, Unit of Measure, Resource Group,Resource SubGroup. It also evaluates the transaction data based on Type – e.g., Resource, Group (Resource), Sub Group (Resource), or All.

Hierarchy Rule 1 - Project Specific Resource Price

If there is a price that is specific to a Project (or Project/Task) and Resource, that price will be used.

Example - Time Journal - Rule 1

  • Posting Date: 1/1/2019
  • Project No.: TM01
  • Project Task No.: 100.10
  • Resource No.: PM0001
  • Work Type: blank
  • Unit of Measure: HOUR
  • Resource Group No.: PROJMAN
  • Unit Price retrieved: $110.00

Time Entry - Rule 1

Timesheet Entry

Price Plan Used - Rule 1

Resource Price Plan

Conclusion - Rule 1

There is no Price Plan for Project TM01; There is no Price Plan for Work Type = blank; therefore, it will use the Price Plan for Resource PM0001 at $110.00.

Hierarchy Rule 2 - Project specific Resource Group Price

If there is no price applicable to the Resource, if a price is setup for a Resource Group that the Resource belongs to, then that Resource Group price will be used.

Example - Time Journal - Rule 2

  • Posting Date: 1/1/2022
  • Project No.: TM05
  • Project Task No.: 100.10
  • *Resource No.: PM0001
  • Work Type: blank
  • Unit of Measure: HOUR
  • Resource Group No.: PROJMAN
  • Unit Price retrieved: $70.00

Time Entry - Rule 2

Timesheet Entry

Price Plan Used - Rule 2

Resource Price Plan

Conclusion - Rule 2

The Price Plan for Project TM05, Task Code 20110, Resource Group PROJMAN was used, and the Price inserted was $70.00. This is because there was no Price Plan with Resource PM0001 specified, but there was a Price Plan for Project TM05.

Hierarchy Rule 3 - Resource Price or Resource Price with Work Type or Unit of Measure

If there is a Price that is specific to a Resource and\or with Work Type and\or Unit of Measure, that Price will be used.

Example - Time Journal - Rule 3

  • Posting Date: 1/1/2019
  • Project No.: TM01
  • Resource No.: PM0001
  • Work Type: TRAVEL
  • Unit of Measure: HOUR
  • Resource Group No.: PROJMAN
  • Unit Price retrieved: $108.00

Time Entry - Rule 3

Timesheet Entry

Price Plan Used - Rule 3

Resource Price Plan

Conclusion - Rule 3

If there is a Price that is specific to a Resource and\or with Work Type and\or Unit of Measure, that Price will be used. The transaction entered used Project TM01 and Resource PM0001 with a Work Type Travel Code, and a Unit of Measure Code. There was a Price Plan set up for Resource PM0001, Unit of Measure Code HOUR,

Hierarchy Rule 4 - Resource Group price or Resource Group price with Work Type\Unit of Measure

If there is no Price applicable to the Resource, if a Price is set up for a Resource Group that the Resource belongs to, then the Resource Group Price will be used.

Example - Time Journal - Rule 4

Example where there is no Price Plan set up for the Resource used on the time entry, so it will look for a Price Plan with the Resource Group to which the Resource is a member.

  • Posting Date: 1/19/2019
  • Project No.: PGS001
  • Project Task No.: 10110
  • Resource No.: KB003
  • Work Type: blank
  • Unit of Measure: HOUR
  • Resource Group No.: PROJMAN
  • Unit Price retrieved: $125.00

Resource Card - Resource Group

Time Entry - Rule 4

Timesheet Entry

Price Plan Used - Rule 4

Resource Price Plan

Conclusion - Rule 4

Because there is no Price Plan for Resource KB003, it attempts to find a line with a Resource Group that matches the time entry line. KB003 is in the PROJMAN Resource group. uses Price = 125.00.

Hierarchy - Example 5 - Transaction Date

The system looks for a Price Plan for parameters such as Project, Task Code, Resource, Resource Group, etc. and also looks at the Date of the transaction to find a Price Plan that matches that Date.

Example - Time Journal - Rule 5

  • Posting Date: 1/4/2023
  • Project No.: TM05
  • Project Task No.: 100.10
  • Resource No.: PM0001
  • Work Type: blank
  • Unit of Measure: HOUR
  • Resource Group No.: PROJMAN
  • Unit Price retrieved: $140.00

Time Entry - Rule 5

Timesheet Entry

Price Plan Used - Rule 5

Resource Price Plan

Conclusion - Rule 5

Uses the Price Plan for Project TM05 and Resource PM0001 for a price of $140 because the date of the Timesheet is or after the date of 1/1/23.

Hierarchy - Example 6 - Transaction Date

The system looks for a Price Plan for parameters such as Project, Task Code, Resource, Resource Group, etc. and also looks at the Date of the transaction to find a Price Plan that matches that Date.

Example - Time Journal - Example 6

  • Posting Date: 1/1/2019
  • Project No.: TM05
  • Task Code: 100.10
  • Resource No.: PM0001
  • Work Type: blank
  • Unit of Measure: HOUR
  • Resource Group No.: PROJMAN
  • Unit Price retrieved: $105.00

Time Entry - Rule 6

Timesheet Entry

Price Plan Used - Rule 6

Resource Price Plan

Conclusion - Rule 6

Uses Resource line PM0001 and Price of $105.00 because the date of the Timesheet is prior to the date of 1/1/22 and there are no Price Plans for Project TM05 and Resource PM0001 prior to 1/1/2022.

Hierarchy - Example 7 - ALL Resources

Example - Time Journal - Example 7

A Price Plan with Resource = ALL will be used when there is no other Price Plan specific to the Resource, or other parameters.

  • Posting Date: 1/2/2020
  • Project No.: TM05
  • Project Task Code: 100.10
  • Resource No.: KB003
  • Work Type: blank
  • Unit of Measure: HOUR
  • Resource Group No.: ADMIN AD
  • Unit Price retrieved: $67.00

Time Entry - Rule 7

Timesheet Entry

Price Plan Used - Rule 7

Resource Price Plan

Conclusion - Rule 7

Because the system found Project TM05, and there is no other Price Plan for this Date for Resource KB003, it used the Price Plan for Resource= ALL - Price = 67.00.