These components are the basis for the entire Profitability Analysis tool in DC1 Analyser and will later be used when defining the parameters for the report (see About building the Profitability Analysis report). When defining the balance components you also decide how the value for the component shall be retrieved. The different options are as follows:
- From a single balance type and/or budget value
- From a formula (calculation) combining Balance types,
or based on a
- Fixed value
Note: All components you define must have a unique name.
When you build the report, thereby defining all the parameters for the report you want to eventually create, you can build a simple report for single balance types or define a calculation for the different balance components. The latter is done if you want to create a report on a more detailed level.
- Select the Manage balance components menu item.
- Click the New icon or File/New from the menu bar.
- You access PA component edit view. Complete the following fields:
- Code
- Enter a unique code for the component you are adding.
- Description
- Enter the description of the code.
- Category
- If you have defined a component category, use the drop down list to retrieve the category under which this component belongs.
- Tip: If the category you want does not exist, click Edit. You access the PA component categories window where you can add a new. (See Define the balance component categories for the Profitability Analysis report for instructions).
- Balance type
- If you checked Balance type under section Value, click the arrow to pull down a list where you can select the applicable balance type.
- Use budget value
- If the value for the component should be retrieved from a budget, rather than the Balance file, check this box. You specify what budget to use when you create a Profitability Analysis definition (see Define the definition information for the Profitability Analysis report for instructions).
- Formula
- If you checked Formula under section Value, click the arrow to pull down a list where you can create the applicable formula.
- Fixed value
- If you checked Fixed value under section Value, enter the value for the Balance component.
- Icon file
- If you want to assign an icon to the Balance component, enter the name of the file in this field, or alternatively click Select and select from the list of available icons. If you do not complete this field, the default “component” icon will be associated with this component.
- Preferred operation
- Depending on the component you are defining, you can pre-define a preferred operation for the component (e.g., Add, Subtract, Multiply by, Divide by). Click the arrow beside the field to pull down a list and make the applicable selection.
- Note: You always have the option to change this operation when you are building the report.
Value
Under this section you can choose whether you want to retrieve the value for the component from an existing Balance type, via a Formula or as a Fixed value.
Note: Depending on your choice, only the applicable fields will be open for input.
Retrieving from Balance types
Creating a Formula
You access the following Formula view window.
In the left hand box, click on the arrow beside the applicable balance group to expand the list of balance types. When you have found the applicable balance type double click it to add it to the bottom section of the window. Manually enter the mathematical character for the formula you are creating (e.g., +, -, *, etc) or alternatively use the calculator to the right of the window. Repeat for all balance types you want in the formula.
Note: If you want to add a percentage in the formula, click on the arrow beside the Percentage field to pull down a list of pre-defined percentages in DC1.
When finished click OK. You return to the PA component edit view window where the formula is updated in the Formula field.
Entering fixed value
Optional information
Click Save to save the information. Repeat steps 2 and 3 for all components you want to create.