Budgeting, Planning & Forecasting

What are the main functions of Tagetik 4.0 to the budgeting, planning and forecasting process to support:

  • Planning Models: Creation of different planning models, including models based Teiber and use of MDX scripting language for complex calculation rules
  • Scenarios: Definition of different types of data (budget, forecast, medium term planning, ...)
  • Data collection: collection of financial and non-financial data organized by data entry screens available via Web or Excel
  • Workflow: Management of data collection and planning process through appropriate approval process
  • 'What-if' analysis: Creation of alternative scenarios through simulation analysis, allocation or distribution algorithms
  • Charges: Efficient processing of allocations
  • Cash Flow Models:
    - Automatic calculation of cash flow and balance sheet through the use of financial rules such as payment terms (DSO / DPO), ...
    - Management of inter-company / in-plant service accounting, tax, cash pooling, depreciation, devaluation of investments, ...
  • Forecasting: Forecast models for a definition of deterministic processes at different aggregation levels
  • Intercompany Matching: collection and reconciliation of intercompany relationships in the course of the planning process
  • Consolidation of planning data
  • Analysis: Generation of complex OLAP cubes, data mining, analysis and reports by using Microsoft SQL Analysis Services and Reporting Services directly on Tagetik data and the user rights in Tagetik 4.0
  • Cooperation and Communication: A portal to share documents, plan versions and workflows to manage the planning process for all involved business units (Tagetik 4.0 Enabled by Microsoft SharePoint).

Personnel and HR

  • Use of ETL functionality of Tagetik 4.0 for automatic data transfer from any general ledger or payroll system
  • Workflow for the approval or rejection for the transfer of personnel-related costs
  • Driver-based models for automatic calculation of HR-related costs
  • Use of sophisticated reporting capabilities for dynamically creating and managing expense reports
  • User rights and use of user profiles in order to guarantee the confidentiality of sensitive data

Sales

  • Collection of budget data and legacy data from existing source systems (Data Warehouse, CRM, CPM, ERP ...) by using the ETL tools Tagetik 4.0
  • Creation of structured sales budgets through the use of multidimensional models, MDX calculations, assessments and monthly forecasting
  • Workflow for approval process for managing and monitoring a complex planning process through the use of a real-time available and user-friendly dashboard
  • To allow creation of "snapshots" to give users the creation of alternative planning scenarios based on external factors
  • Definition of Web-based registration forms for the efficient collection of data planning and preparation of budgets
  • Use of sophisticated reporting capabilities to display historical data or for further analysis and consolidation in Real Time
  • Production Costs
  • Native management of "Group Approach" (multi-warehouses, multi-plants, etc.)
  • "What If" capabilities to develop alternative scenarios
  • According to different inventory valuation methods (eg weighted average, etc.)
  • MRP-II System Compliance
  • Exact allocation of indirect costs for the contribution margin and pricing analysis
  • Investment costs (CAPEX)
  • Hierarchical structure to manage each investment project and the detailed analysis of each single investment of complex (eg exhibition) to allow up to simple facts (purchase of a printer)
  • Automatic analysis of the budget available at the time of purchase or delivery
  • Comprehensive annual investment management: efforts and acquisition can be very detailed monthly and year are planned
  • Possibility of any planned effort to assign a term of payment position, the automatic calculation of cash flow to dine
  • Version Control with opportunity analysis for different scenarios
  • Automatic calculation of depreciation by asset class for each purchase of analgesia and self-constructed assets.

Links

pmOne is a growing Business Intelligence provider based in Central Europe. The company’s solutions focus on three pillars: data warehousing, performance management applications, and visualization through information design. pmOne develops products that complement Microsoft technology and distributes Tagetik, a leading performance management solution. In addition, MindBusiness GmbH, a member of the pmOne Group, specializes in Microsoft SharePoint solutions and services for Microsoft Office roll-outs.

pmOne currently has 150 employees combining over 900 years of project experience. The company was founded in 2007 and is fully owned by management and staff. pmOne Group has eight offices in Germany, Austria and Switzerland.