Financial Administration › Financial Matrices › How to Set Up Cost/Rate Matrices › Add and Change Cost/Rate Matrix Rows

Add and Change Cost/Rate Matrix Rows

Use the Matrix Row Properties page to view the rows added to the matrix.

To add or change a row in the matrix

  1. Select Manage Matrix from the Finance menu.

    The Manage Matrix page appears.

  2. Click the matrix name.

    The Matrix Properties: General Information page appears.

  3. Click Edit Matrix Rows from the content menu.

    The Matrix Properties: Edit Matrix Rows page appears.

  4. Click New.
  5. 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.

  6. Select matrix criteria. The fields available for selection will vary based on the columns you assigned. For example, if you selected Location as the assigned column, select a location to define matrix criteria.
  7. 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. This is the cost that is applied in cost reporting.

    Actual Cost

    Defines the actual cost associated with a transaction matches the criteria established in the matrix. This is the cost that 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 multi-currency 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. Click the Browse icon to select the cost plus code.

  8. Click Submit.
  9. To add additional rows as needed and then click Continue to complete the matrix.