SAP BPC is a tool that can be customised to facilitate planning, budgeting and forecasting processes for different functional areas such as Revenue, Human Capital Management, Operating Expenses, and Capital Expenditure. In this blog we will talk about how to integrate these functional areas into one unified BPC reporting model, for fully integrated planning.
The different functional areas require different data structures and consequently we will need to use a separate BPC model for each area. To give some common examples:
The Revenue model may, depending on the modelling requirements, need to have Product dimensionality in order to plan the sales volumes and calculate planned revenue according to the price by product, and a Customer dimension to plan sales and analyse the outstanding payments by customer or channel.
The Labour planning, or HCM model may need to include a role dimension, in order to plan the salary by role or grade, or an Employee dimension to enable planning by employee or job grade.
The Operating Expenses or OPEX model should enable the user to plan the expense related General Ledger accounts at the required level of detail, for example, by collecting the number of flights and hotel nights and using forecast unit costs to calculate travel expenses.
The Capital Expenditure or CAPEX model should include an asset dimension which will include the company’s asset list and allow the user to plan new asset purchases and the corresponding depreciation for the planning period.