<< Click to Display Table of Contents >> Investment KPI - Get started |
A prerequisite for being able to calculate costs for a project is that there are cost catalogs set up. To be able to calculate costs after depreciation, the cost catalogs need to contain depreciation time. This can be set up manually for each cost in the cost catalog or by importing costs with depreciation time.
1.In the menu bar, select Organizer > Show/Hide administration. The south panel opens.
2.Select the Cost catalogs tab.
3.Select the cost catalog to be updated with depreciation time.
4.In the east panel, Catalog content tab, select the cost to be updated and enter the value in the Depreciation field.
1.In the menu bar, select Organizer > Show/Hide administration. The south panel opens.
2.Select the Cost Catalogs tab.
3.Select the cost catalog to be updated with depreciation time.
4.Press Export current selected catalog and select EBR standard with dynamic parameters and depreciation alternatively Norm price list with dynamic parameters and depreciation.
5.In the csv file, update the Depreciation column with the number of years for all rows.
6.In the south panel tab Cost catalogs, press Create new cost catalog and select EBR standard with dynamic parameters and depreciation alternatively Norm price list with dynamic parameters and depreciation.
In order to include the costs of objects in a calculation, the network objects need to be mapped to the costs they will bear. Only costs for objects that match the specified parameters in the mapping group, such as states and attributes, will be included in the calculation. Mappings are managed in the Administrate catalog connections tool.
1.In the menu bar, select Organizer > Show/Hide administration. The south panel opens.
2.Select the Cost catalogs tab.
3.Press Administrate catalog connections.
4.In the Mapping group section, press to create a new mapping group. Objects that should carry the same costs are mapped in a group.
5.In the Object category section, press to select the category of objects to be mapped in the group, for example Electrical objects.
6.In the Object type section, press to select the type of object to be mapped in the group, for example, Cable pillar.
7.In the State section, press to select the stage of objects to be mapped in the group, for example Planned.
8.In the Attributes section, press to select the attributes to be mapped in the group, for example, Cabinet type.
a.Press Select attributes to map.
b.Select the attribute you want to map in the left list and move it to the right list.
c.Fill in the values for the attributes to be mapped in the mapping group, e.g. CDC40 for Cabinet type. Only cable cabinets with type CDC40 will then be cost-bearing in this mapping group.
9.Under Cost catalogs, press to select the cost item for what is mapped in the mapping group.
a.Select the cost catalog in the list on the left and press Load catalog (or double click on the catalog) to load content.
b.Find the cost item in the selected catalog and double-click to link it to the mapping group.
c.When all desired cost items are added, press Close. It is possible to change the value in the Quantity column if an instance of the object is to carry several records of the same cost. It is also possible to enter negative values for Quantity.
In order to calculate the key figure Investment efficiency, calculation templates for Norm Increasing, Norm Decreasing and Investment need to be set up. The calculation templates can then be used in assignment templates or directly in already created task.
Create a new calculation template for each year so that the depreciation period always has the current year. Delete the Cluster usage on the previous year's calculation template, it can then not be used in a new calculation. |
1.In the menu bar, select Organizer > Show/Hide administration. The south panel opens.
2.Select the Calculation templates tab.
3.Press Create new calculation template .
4.Fill in a Template name, for example Norm Increasing.
5.Give the template an ID consisting of capital letters and/or numbers, for example NORM_INC.
6.In the Cluster usage section, press Add to add the utility you want the costing template for, for example Electricity.
7.In the Cost calculation tab, set the following parameters:
oCalculation type: Grid control period 4, project dpPower
oCost components: Default dpPower (or custom)
oDepreciation, year: Current year
oCost catalog: Standard price list
oState: Planned/Projected
oKey figure marker: Norm Increasing
1.In the menu bar, select Organizer > Show/Hide administration. The south panel opens.
2.Select the Calculation templates tab.
3.Press Create new calculation template .
4.Fill in a Template name, for example Norm Decreasing.
5.Give the template an ID consisting of capital letters and/or numbers, for example NORM_DEC.
6.In the Cluster usage section, press Add to add the utility you want the costing template for, for example Electricity.
7.In the Cost calculation tab, set the following parameters:
oCalculation type: Grid control period 4, project dpPower
oCost components: Default dpPower (or custom)
oDepreciation, year: Current year
oCost catalog: Standard price list
oState: In use, planned for destruction/Out of operation, planned for destruction
oKey figure marker: Norm Decreasing
8.In the menu bar, select Organizer > Show/Hide administration. The south panel opens.
9.Select the Calculation templates tab.
10.Press Create new calculation template .
11.Fill in a Template name, for example Norm Decreasing.
12.Give the template an ID consisting of capital letters and/or numbers, for example INV.
13.In the Cluster usage section, press Add to add the utility you want the costing template for, for example Electricity.
14.In the Cost calculation tab, set the following parameters:
oCalculation type: EBR dpPower
oCost components: Default dpPower (or custom)
oDepreciation, year: Current year
oCost catalog: EBR
oState: Planned/Designed
oKey figure marker: Investment