Enterprise Edition:Administration: Difference between revisions

From CoPlanner 11
Jump to navigationJump to search
No edit summary
No edit summary
Line 53: Line 53:
==Time frame of the plan==
==Time frame of the plan==


The [[Framework:Szenariomanager|Szenariomanager]] can be used to set a plan time frame for each scenario. The time frame may be 12 months, but may also be a longer or shorter period. A shorter scenario time frame may be advisable in the case of a stub period. A longer scenario time frame allows you to plan on a monthly basis for periods longer than one year or to plan on a rotating basis in which the plan period is continually extended.  
The [[Framework:Scenario_manager|Scenario Manager]] can be used to set a plan time frame for each scenario. The time frame may be 12 months, but may also be a longer or shorter period. A shorter scenario time frame may be advisable in the case of a stub period. A longer scenario time frame allows you to plan on a monthly basis for periods longer than one year or to plan on a rotating basis in which the plan period is continually extended.  
The opening balance sheet is set to the plan-from month (as an opening balance; changes in the balance of the plan-from month are calculated into the plan value of the balance for the plan-from month.
The opening balance sheet is set to the plan-from month (as an opening balance; changes in the balance of the plan-from month are calculated into the plan value of the balance for the plan-from month.



Revision as of 07:47, 7 May 2010

Application properties

The Anwendungseigenschaften are used to store reference values for calculations or processes in CoPlanner. Before you make any changes to this section, please consult your PowerUser or CoPlanner Administrator.

Synchronising dimensions

Profit and loss accounts can be imported in a profit and loss statement aggregate cost method structure or expense distribution sheet structure. To transfer these accounts into the partial dimensions of the Success Planning area, the correct application property must be activated here:

Partial dimensions in profit and loss statement When this setting is activated, the accounts of the success planning dimensions are transferred into the profit and loss statement aggregate cost method structure.

Partial dimensions in expense distribution sheet When this setting is activated, the accounts of the success planning dimensions are transferred into the expense distribution sheet structure.

Profit and loss statement in partial dimensions When this setting is activated, the accounts of the profit and loss statement aggregate cost method structure are transferred into the success Profit and loss statements, aggregate cost method. Additional settings in the attribute fields of the profit and loss statement aggregate cost method structure are necessary for this purpose.

Expense distribution sheet in partial dimensions When this setting is activated, the accounts of the expense distribution sheet structure are transferred into the success cost distribution sheet-structure. Additional settings in the attribute fields of the expense distribution sheet structure are necessary for this purpose.

Hint  Activating these settings causes changes to the mathematical logic and changes the requirements for user-submitted plan data. Any fundamental settings and changes in this area must therefore be discussed with your PowerUser!


Calculation settings

In the calculation settings you can specify whether production planning should be used or whether personnel costs should be linearised in the profit and loss statement.

Hint  Activating these settings will change the calculation processes and the requirements for plan data entry in the variable costs planning section (production planning) and personnel costs planning section (linearised personnel costs in the profit and loss statement).

Any changes in this area must therefore be discussed with your PowerUser!


Calculation elements

The calculation elements contain references to dimension elements for calculation processes in CoPlanner. This area is adjusted during implementation of CoPlanner and should not require any subsequent changes to be made.

Hint  As these settings are used for various calculations and standard reports, any changes in this area must be discussed with your PowerUser!


Actual acquisition period

This section defines the actual period for which the CoPlanner calculation processes should be run (Ist_Von and Ist_Bis). Additionally, the date of theOpening balance sheet is determined here (once). The month entered here cannot be changed later!

Time frame of the plan

The Scenario Manager can be used to set a plan time frame for each scenario. The time frame may be 12 months, but may also be a longer or shorter period. A shorter scenario time frame may be advisable in the case of a stub period. A longer scenario time frame allows you to plan on a monthly basis for periods longer than one year or to plan on a rotating basis in which the plan period is continually extended. The opening balance sheet is set to the plan-from month (as an opening balance; changes in the balance of the plan-from month are calculated into the plan value of the balance for the plan-from month.

Plan time frame and calculations

Depending on the table involved, the plan time frame defined in the Scenario Manager limits the calculations that are initiated by plan data entry. For example, if revenue (“Revenue” table) from outside the plan time frame is entered, no further calculations such as the profit and loss statement or the financial plan are performed.

Please ensure that your data entries correspond to the defined plan time frame!

Nevertheless, the mathematical logic of certain planning areas (e.g. loan planning) does not preclude the possibility of entering data outside the defined plan time frame. The following overview shows the values that are calculated for periods before or after the planning horizon and the values to which the limits of the planning horizon apply.

Table Value before planning horizon Value within planning horizon Value after planning horizon
Revenue   Sales  
Types of revenue reduction   Revenue reduction  
Variable costs   Variable costs  
Personnel costs   Personnel costs  
Other fixed costs and revenues   Other costs/revenues  
Depreciations   Depreciation Depreciation
New investments   Acquisition  
Existing investments   Depreciation  
Disinvestments   Sale proceeds  
Loan master data Borrowing Borrowing Borrowing
Loan Repayment, interest Repayment, interest Repayment, interest
Provisions   Change  
Reserves   Change  
Interest   Interest  
Profit tax master data   Tax rate  
Profit taxes   Tax  
Balance sheet parameters   Value  
Regular tax burden   Receipt, disposal Disposal
Warehouse   Purchase, withdrawal Purchase
Flow statement   Value Value
Balance sheet   Value  
Income statement   Value  
Financial budget – direct method   Value Wert
Financial budget – indirect method   Value Value
Profit and loss structure, aggregate cost method   Value  
Expense distribution sheet   Value  
Services   Value  
Charges for services   Value  


Direct financial plan, indirect financial plan

Values are copied here from other tables, even if the values apply to periods outside the plan time frame. The most important such values are payments after the planning horizon that arise from entries within the planning horizon.

Values not included are depreciations from investment planning and repayment and interest payments from loan planning. These must be recalculated when the plan time frame is extended. The final cash result is calculated within the planning time frame only.

Flow statement

Here the most important calculations are the changes in working capital (accounts receivable and accounts payable) that occur outside the plan time frame. These calculations are performed from other tables whose underlying values lie within the planning time frame.

The following values are calculated within the plan time frame only

By limiting the data entry in tables to the plan time frame:

  • Revenue
  • Revenue reduction
  • Variable costs
  • Personnel costs
  • Other fixed costs and revenues
  • Balance sheet parameters
  • Provisions
  • Reserves

Payments from all these tables are calculated in the appropriate table even for periods after the planning horizon, but not for periods before the planning horizon as this is already included in the opening balance sheet.

Investments

New investments: Only a month within the planning horizon can be specified as the date of acquisition. Depreciations are calculated beyond the planning horizon as well.

Loans

Neither the Loan Master Data table nor the Loans table is limited. The formulas for repayment and interest payments calculate into the Loans table until the end of the life of the loan. Only values within the plan time frame are calculated into the Earnings tables.

Analyses

The following properties will be carried forward up to the planning horizon:

  • Bilanzgewinn_GuV
  • Bilanzgewinn_Bilanz
  • Cashvortrag_DirFP
  • Cashendstand_Bank
  • Cashvortrag_IndirFP