The setup of columns for both types of EDS—dimension statement and cost statement—is the same except in the setup of dimensions or divisions for each column.

You can set up a different dimension for each column in the dimension statement. You set up dimensions on the tab, which is active only for column types , , , and .

To set up a division for the column instead of a dimension, enable the check box, and then select the appropriate division.

In both types of EDS reports you can set up a period for each column on the tab.

To set up columns

  1. Go to > > ,and click .

  2. On the tab, view the , which is the automatically entered number of the column.

  3. Enter the , which is the description of the column and , which is the name that is printed on the report.

  4. Select the , which specifies the type of the column. For example, it specifies whether the column displays the name of the report lines or if it displays costs or quantity. See the table of column types and their description below.

  5. Select the , which you define only for the costs (fixed, variable, or total) and quantity column types. Select between the following value types:

    • Budget costs

    • Basic plan costs

    • Flexible plan costs

    • Target costs

    • Actual costs

  6. Select the , which has to be defined for all value types except for actual costs.

  7. Use the tab and tab to select some additional settings.

Column types

The expense distribution sheet contains the following column types:

Column Type

Description

Line number

Number of the column.

Name

Description of the column.

Costs (fixed, variable, total)

Column with cost amounts. For this column type you have to select and or on the tab, but only for dimension statement.

Quantity

Column with the quantity of services. For this column type you have to select and or on the tab, but only for dimension statement.

Column calculation

Create calculations. For example, calculate the sum of all columns. Calculations are set up on the , which is enabled only for this column type. To calculate the sum of all columns select the appropriate , and enter the and .

100%

Column with 100%. By selecting this column type the tab is enabled. Select and . For more information about 100% columns, see Example of a 100% column set up later in this topic.

Example of a 100% column set up

If the column type is set up to 100% for column C, and column A is chosen as the reference column, and Line 4 is chosen as the reference line, values for column C are calculated as follows:

  • C1 = A1/A4 * C4

  • C2 = A2/A4 * C4

  • C3 = A3/A4 * C4

  • C4 = A4/A4 * C4 = 1 * C4 = 100%

Line number

Column A = REF

Column B

Column C = 100%

Line 1

A1

B1

C1

Line 2

A2

B2

C2

Line 3

A3

B3

C3

Line 4 = REF

A4

B4

C4

See Also