Enterprise Edition:Administration: Difference between revisions
No edit summary |
No edit summary |
||
| Line 53: | Line 53: | ||
==Time frame of the plan== | ==Time frame of the plan== | ||
The [[Framework: | 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