Create a cost model with the Cost Model form

You can create multiple cost models to process allocations. Use the Cost Model form to configure all possible settings available to the cost model.

Before you begin

Role required: cost_transparency_admin

About this task

You can select a cost model in the The Data Definition stage when you set up allocations. You can also create a basic cost model from the workbench.

Procedure

  1. Navigate to Cost Transparency > Cost Models > All
  2. Click New.
  3. Fill in the form fields (see table).
  4. Click Submit.
    Figure 1. Financial Model form
    The financial model form
    Table 1. Financial Model form fields
    Field Description
    Name Name of the cost model.
    Description Description of the cost model.
    Used by Cost Allocation Check box to specify if the model is to be used for cost allocation.
    Model Owner The user who created the cost model.
    Data Source The source from where the data is taken.

    Data Source field is editable until cost transparency actions are not done.

    The application is preconfigured to point to the Budget Staged table as a data source for the Default Budget Cost Model as it is linked to ITFM Budget staged expenses.

    You also have the option not to select a data source. In such a case, the Workbench stages will not have the data cleansing stage as there is no financial data source to pull the expense lines from. Amounts would then be keyed in manually at the bucketing stage.

    Used by Budgeting Check box if the model is being used for budgets.
    Cost Transparency
    Fiscal Unit Defines the fiscal unit to be a month, quarter, or a period based on the fiscal calendar.
    Generate Controlled Cost Lines

    (Recommended). Helps in performance and saves database space.

    Check box to generate minimal cost lines aggregated at the account level only, in the itfm_allocation_aggregate table.

    You can define specific breakdown relationship between the segments required for business. Additional breakdown lines are generated in itfm_allocation_breakdown table between the segments.

    Include Sub-Bucket info The Include Sub-Bucket info check box option is available when Generate Controlled Cost Lines check box is selected.

    If enabled, the generated cost lines and breakdown lines will hold sub-bucket information.

    User Group The user group selected is associated with the cost model. This restricts the cost model being accessed by other user groups who are not associated with the user group of type ITFM.

    Users with cost_transparency_analyst role can access default cost model and the cost model associated to his/her user group only.

    Users with cost_transparency_admin and system administrator roles can access all the cost models, including the default cost model.

    If the Used by Budgeting check box is enabled for the cost model, then users with appropriate budgeting role can view all the budget models.

    If the cost model is used for purposes of both budgeting and generating cost allocation lines, that is, if Used by Cost Allocation and Used by Budgeting check boxes are enabled, then the cost model can be accessed by all users.

    Choose Segments for GL Expense Lines The Choose Segments for GL Expense Lines field is available only when Generate Controlled Cost Lines check box is enabled. You can choose segments to generate the GL expense lines in the itfm_allocation table.

What to do next

The buckets that use this cost model are shown in the Buckets related list.

You can also create an account bucket.

Map a unit cost metric to a segment of a cost model to generate unit costs.

The breakdown relationship to explicitly generate breakdown cost lines in itfm_allocation_breakdown table for a given segment-segment mapping are shown in the Breakdown Relationships related list.

You can also define a sibling relationship to roll up accounts at the sibling level.