Updated on 2023-03-07 GMT+08:00

Example

Description

You want to allocate costs across Department A, Department B, and Department C in your company, and the department of most of costs can be identified based on the tags configured for the resources. In addition, Department A uses the Face Recognition Service that does not support tag management, and an EVS is shared across all departments.

Known information: Cost tags are used, the tag key is Group, and key values are Department A, Department B, and Department C.

Step 1: Creating a Cost Category

Create a cost category and define the rules as follows:
Table 1 Rules

Name

Type

Content

Rule 1: Inherited Value - Cost Tags

Inherited

Condition: Select Cost Tag for Inherited Dimension and Group for Tag Key.

Rule 2: Department A

Customized

Condition: Service Type Is FRS Face Recognition Service.

Rule 3: Shared costs

Customized

Condition: Service Type Is Elastic Volume Service.

Uncategorized

-

Costs that do not match the preceding rules.

Figure 1 Creating a rule

Table 2 shows the cost allocation.

Table 2 Cost allocation

Rule Name

Costs Amortized in the Current Month ($)

Department A

100

Department B

200

Department C

50

Shared cost

40

Uncategorized

100

Step 2: Splitting the Shared Cost Across Departments

You can define cost splitting rules 48 hours after the cost category is created to split the shared cost across the departments.

  • Select Custom for Allocation Method to split shared cost and allocate 50% of the shared cost to Department A, 30% for Department B, and 20% for Department C.
  • Select Custom for Allocation Method to split uncategorized cost and allocate 30% of the uncategorized cost to Department A, 30% for Department B, and 40% for Department C.

    Currently, the following allocation modes are supported:

    • Proportionally: Allocate your costs in proportion to the weight of each target value.

      Example: The value of Target B is $800 USD and value of Target C is $200 USD. Target B/Target C = 4:1. 80% of source value will be allocated to Target B and 20% to Target C.

    • Evenly: Allocate your costs evenly across your target values.

      Example: There are two target values (A and B), and the source value is evenly allocated to A and B, (50% each).

    • Custom: Allocate your costs based on a custom percentage for each target value. The percentages must add up to 100%.
    Figure 2 Example splitting rules

    Table 3 Cost splitting rules

    Rule Name

    Source Value

    Target Value

    Allocation Method

    Rule Content

    Associated Cost ($)

    Rule 1

    Uncategorized

    Department A

    Department B

    Department C

    Custom

    Department A: 50%

    Department B: 30%

    Department C: 20%

    Department A: 100 x 50% = 50

    Department B: 100 x 30% = 30

    Department C: 100 x 20% = 20

    Rule 2:

    Shared cost

    Department A

    Department B

    Department C

    Custom

    Department A: 30%

    Department B: 30%

    Department C: 40%

    Department A: 40 x 30% = 12

    Department B: 40 x 30% = 12

    Department C: 40 x 40% = 16

Step 3: Viewing Results

The following table shows the cost statistics for each department after cost splitting (Net Amortized Cost is used as an example).
Table 4 Cost breakdown after split

Item

Net Amortized Cost

Split Amount

Amount Allocated

Proportion

Department A

100

50 + 12

162

33.06%

Department B

200

30 + 12

242

49.39%

Department C

50

20 + 16

86

17.55%