Previous Topic: VendorsNext Topic: Company Profiles


Financial Matrices

A matrix is composed of the following:

You can define a Cost/Rate matrix used during financial transaction processing to determine costs and billing or charge rates. You can create cost and rate matrices for labor, materials, equipment, and expense resource types.

You can establish default matrices at the system level, entity level, and investment level. CA Clarity PPM looks for and applies matrices first at the investment level, then at the entity level, and finally at the system level. You can set default rate locations at either the entity level or system level. If a matrix cannot be matched, you can enter costs and rates manually when you create transactions.

Set up currency before creating a cost/rate matrix.

More information:

Cost/Rate Matrices

How to Set Up Cost/Rate Matrices

Cost Plus Codes and Rules

Create Cost/Rate Matrices

Assign Columns in Cost/Rate Matrices

Add and Change Cost/Rate Matrix Rows

Increase the Rate for Cost/Rate Matrices

Copy Cost/Rate Matrix Rows

Copy Cost/Rate Matrices

Unlock Matrices

Entities

Set Project Transaction Entry Defaults

Cost/Rate Matrices

Use rate matrices to specify direct costs to investments. When you apply cost or billing rates to transactions, the correct rate is automatically selected from possible rates and is used during rate calculation. You can add matrices for use only with costs or rates.

How to Set Up Cost/Rate Matrices

The matrix rows govern the whole rate structure to cover all the pricing scenarios. You can set up one cost/rate matrix per project.

Use the following process to set up your cost/rate matrices:

More information:

Financial Matrices

Cost/Rate Matrices

Create Cost/Rate Matrices

Unlock Matrices

Cost Plus Codes and Rules

The cost plus mechanism is used to apply mark-ups. A cost plus code is a set of cost plus rules.

Cost plus rules allow for the mark-up of actual or standard costs. Project managers can associate cost plus rules to their projects to allow mark-up to be calculated using the multiplier (factor), burden, and overhead methods.

Cost plus rules are added to cost plus codes to make up cost plus. Cost plus is used in an existing cost/rate matrix.

More information:

How to Enable Cost Plus Codes

How to Enable Cost Plus Codes

To enable a cost plus code, you must:

  1. Create the cost plus code.
  2. Define at least one cost plus rule for each code and add it to the cost plus code. You can define unlimited cost plus codes or rules.

To delete a cost plus code, select the check box next to it and click Delete. If a cost plus code has been used in a transaction, you cannot delete it.

More information:

Create Cost Plus Codes

Create Cost Plus Rules and Add to Cost Plus Codes

Create Cost Plus Codes

Follow these steps:

  1. Open Administration, and from Finance, click Cost Plus Codes.

    The list page appears.

  2. Click New.

    The properties page appears.

  3. Define the following fields:
    Cost Plus Code

    Defines the unique ID for the cost plus code.

    Limits: 8 characters

    Description

    Defines the detailed description of the cost plus code.

    Limits: 40 characters

    Short Description

    Defines the brief description of the cost plus code.

    Limits: 15 characters

    Applies To

    Defines the cost type to which the cost plus code applies from the list.

    Values:

    • Actual. The actual amount paid for transactions.
    • Standard. The blended or burdened rate.
  4. Save the changes.
Create Cost Plus Rules and Add to Cost Plus Codes

The cost plus rules you add to the cost plus code specify the conditions and amounts that are applied for markups. Cost plus rules are added to cost plus codes to make up cost plus. Cost plus is used in an existing cost/rate matrix.

To delete a cost plus rule after adding, do the following:

Follow these steps:

  1. Open Administration, and from Finance, click Cost Plus Codes.

    The list page appears.

  2. Click the cost plus code to add a cost plus rule.

    The properties page appears.

  3. In the Rules in effect section, click New.

    The create page appears.

  4. Complete the following fields:
    Units From

    Defines the beginning value for which this rule is invoked.

    Multiplier

    Defines the type of markup to apply for the actual or standard cost.

    Default: Percent

    Burden

    Defines the type of markup to apply to burden.

    Default: Percent

    Overhead

    Defines the mark-up variable for overhead.

    Default: Percent

    Sequence

    Displays the range of units to which the mark-up applies.

    Applies To

    Displays what the mark-up applies to (for example, cost, rate, or actual).

    To

    Defines the end of the range for invoking the rule.

    Multiplier Amount

    Defines the percentage amount for the multiplier markup. When this cost plus rule is invoked, the multiplier amount is included in the calculation for the total transaction amount.

    Default: 0

    Burden Amount

    Defines the percentage amount for the burden markup. The burden equals cost (actual or standard) times the burden amount. When this cost plus rule is invoked, the burden amount is included in the calculation for the total transaction amount.

    Default: 0

    Overhead Amount

    Defines the percentage amount for the overhead markup. Overhead is the operational costs of a business and equals cost (actual or standard) times the overhead amount. When this cost plus rule is invoked, the overhead amount is included in the total transaction amount.

    Default: 0

  5. Save the changes.

Create Cost/Rate Matrices

Create as many cost matrices as needed for each entity. Once you have defined the general properties, assign columns to the matrix.

Follow these steps:

  1. Open Administration, and from Finance, click Manage Matrix.

    The manage matrix page appears.

  2. Click New.

    The properties page appears.

  3. Complete the following fields:
    Matrix Name

    Defines the unique name for the matrix.

    Limits: 40 characters

    Matrix Type

    Defines the matrix type as Cost/Rate.

    Matrix Default Currency

    Defines the default currency for this matrix. This field only appears if multicurrency is enabled.

    Default: System Currency

    Location

    Defines the location used in the matrix.

    Entity

    Defines the entity used in the matrix.

    Private

    Specifies whether this matrix is restricted to particular users.

    Default: Cleared

    Notes

    Defines any additional information specific to this matrix.

  4. Save the changes.

More information:

Company Profiles

Financial Matrices

Cost/Rate Matrices

How to Set Up Cost/Rate Matrices

Add and Change Cost/Rate Matrix Rows

Unlock Matrices

Assign Columns in Cost/Rate Matrices

You can set up the conditions under which rates are applied. You can assign and remove, order, and reorder up to ten columns for the cost/rate matrix. As you process transactions, the matrix columns are used to determine the rates and costs.

The order of the columns determines the weighting and filtering driving the rates. When the matrix is named during transaction processing, the columns are read from left to right. For example, if the first column is “Client”, and the second is “Project”, only projects associated with the client run against this cost/rate matrix.

Follow these steps:

  1. Open the cost/rate matrix.

    The properties page appears.

  2. Assign columns to your matrix as follows and click Save:

    The columns are assigned to the cost/rate matrix.

More information:

Vendors

Create Cost/Rate Matrices

Add and Change Cost/Rate Matrix Rows

Follow these steps:

  1. Open the cost/rate matrix.

    The properties page appears.

  2. Click Edit Matrix Rows

    The edit matrix rows page appears.

  3. Click New.

    The matrix row properties appear.

  4. Complete the following fields:
    From Date

    Defines the beginning of the effective date range for this row. Any transaction processed within the range is applied the rates/costs from this matrix.

    To Date

    Defines the end of the effective date range for this row.

  5. Select matrix criteria. The fields available for selection vary based on the columns you assigned. For example, if you selected Location as the assigned column, select a location to define matrix criteria.
  6. Complete the following:
    Rate

    Defines the billing rate applied to the transaction. A value of at least 0.00 is required. Entering a bill rate over 0.00 adds a rates matrix.

    For equipment, materials, and expenses, rate is equal to quantity. For example, if the cost of a single server is $1,000.00, then the rate set to 1.

    Standard Cost

    Defines the standard cost associated with any transaction matching the criteria established in the matrix. Standard Cost is applied in cost reporting.

    Actual Cost

    Defines the actual cost associated with a transaction matches the criteria established in the matrix. Actual Cost is applied for billing.

    Currency

    Specifies the currency for the row in the matrix. This value can be different for each row in the matrix and is assigned when a transaction match occurs. Displayed only when multicurrency is enabled.

    Default: Matrix Default Currency

    Cost Plus Code

    Specifies the cost plus code used when a transaction matches the criteria established in the matrix.

  7. Save the changes.

More information:

Create Cost/Rate Matrices

Assign Columns in Cost/Rate Matrices

Increase the Rate for Cost/Rate Matrices

A rate increase affects the entire matrix. At least one matrix row must exist for you to complete this procedure.

Follow these steps:

  1. Open the cost/rate matrix.

    The edit matrix rows page appears.

  2. Select the box next to the row in which to increase the rate.
  3. Click Rate Increase.
  4. Change any of the following:
    Rate %

    Defines the percent increase to apply to the rate for the period specified.

    Standard Cost %

    Defines the percent increase to apply to the standard cost for the period specified.

    Actual Cost %

    Defines the percent increase to apply to the actual cost for the period specified.

    Source Date From

    Defines the beginning of the date range for the matrix rows affected by the rate change.

    Source Date To

    Defines the end of the date range for the matrix rows affected by the rate change.

    New Date From

    Defines the beginning of the effective date range for the new matrix row.

    New Date To

    Defines the end of the effective date range for the new matrix row.

  5. Click Preview and test the matrix.

Copy Cost/Rate Matrix Rows

Rates are date sensitive. You cannot overlap the dates when you copy matrix rows.

Follow these steps:

  1. Open the cost/rate matrix.
  2. Select the check box next to the row you want to copy and click Copy.
  3. Enter or change the following:
    From Date

    Defines the beginning of the effective date range for this row. Any transaction processed within the range is applied the rates/costs from this matrix.

    To Date

    Defines the end of the effective date range for this row.

  4. Select matrix criteria. The fields available for selection vary based on the columns you assigned. For example, if you selected Location as the assigned column, select a location to define matrix criteria.
  5. Enter or edit the following:
    Rate

    Defines the billing rate applied to the transaction. A value of at least 0.00 is required. Entering a bill rate over 0.00 adds a rates matrix.

    For equipment, materials, and expenses, rate is equal to quantity. For example, if the cost of a single server is $1,000.00, then the rate set to 1.

    Standard Cost

    Defines the standard cost associated with any transaction matching the criteria established in the matrix. Standard Cost is applied in cost reporting.

    Actual Cost

    Defines the actual cost associated with a transaction matches the criteria established in the matrix. Actual Cost is applied for billing.

    Currency

    Specifies the currency for the row in the matrix. This value can be different for each row in the matrix and is assigned when a transaction match occurs. Displayed only when multicurrency is enabled.

    Default: Matrix Default Currency

    Cost Plus Code

    Specifies the cost plus code used when a transaction matches the criteria established in the matrix.

  6. Save the changes.

Copy Cost/Rate Matrices

Copying a cost/rate matrix adds a new matrix using the defined properties of the existing matrix.

Follow these steps:

  1. Select the check box next to the matrix you want to copy, and click Copy.

    The properties page appears.

  2. Complete the following:
    Name

    Defines the unique name for the matrix.

    Limits: 40 characters

    Type

    Specifies the matrix types.

    Values: Cost/Rate

    Matrix Default Currency

    Defines the default currency for this matrix. This field only appears if multicurrency is enabled.

    Default: System Currency

    Location

    Defines the location used in the matrix.

    Entity

    Defines the entity used in the matrix.

    Private

    Specifies whether this matrix is restricted to particular users.

    Default: Cleared

    Notes

    Defines any additional information specific to this matrix.

    Number of Columns

    Displays the number of columns in the matrix.

    Number of Rows

    Displays the number of rows in the matrix.

  3. Click Save and Continue.

    The assign columns page appears.

  4. Assign columns, edit matrix rows, and click Finish.

    The finish page appears.

  5. Click Return.

    A new copy of the cost/rate matrix is created.

More information:

Copy Cost/Rate Matrix Rows

Create Cost/Rate Matrices

Unlock Matrices

Matrices that are currently being viewed or changed are locked and therefore other user cannot view or change them.

Follow these steps:

  1. Select Manage Matrix from the Finance menu.
  2. Click Locked Matrices.
  3. Select the matrix you want to unlock.
  4. Click Unlock.