Table of Content
SAP BPC Overview SAP BPC Annual Budgeting Process SAP BPC Monthly Submission
2007 ABeam Consulting Technical Proposal 2011 ABeam Consulting
CONFIDENTIAL DOCUMENT
SAP BPC - Business Planning and Consolidation Overview
Familiar and easy to use
Familiar and easy to use interfaces reduce learning curve and increase adoption
Choice of Word, PowerPoint, web and Excel interfaces Excel without spreadsheet hell - live access to central data repository creates a single version of truth, ensuring organizational alignment Allows use of native Excel functions, formatting, and formula preservation, reducing training time and costs Easy adoption of existing Excel templates as planning schedules
April 2011
2011 ABeam Consulting
Familiar and easy to use
Setup by IT owned and managed by business users
IT Responsibility
Hardware Security and Authentication
Users Roles Privileges
Business User Responsibility
Application Security
Users Roles Privileges
Hierarchies and Roll Ups Business Process Flows
Modification of Packaged Process Flows Creation of New Process Flows
Data and Application Infrastructure
Database Server Application Server OLAP Structure
Report Templates Excel, Word, PowerPoint Templates Create and Modify Metrics and Measures
April 2011
Self-service financial reporting ensures any user can create information on the fly Wizard-driven interfaces simplify content creation and administration processes
2011 ABeam Consulting
Process-centric
Customizable business process flows ensure consistency and minimize training
Step-by-step guidance through planning processes Enforce policies and procedures - track process status and completion Out-of-the box templates for sales and revenue planning, CAPEX planning, workforce planning, budgeted financial statement reports, forecasting and more
April 2011
2011 ABeam Consulting
Unified
Integrated planning
Business planning Budgeting Sales/revenue planning Capital expenditure planning Headcount/staffing Expense planning Cash flow planning Financial reporting and analysis Ad hoc Automated variance analysis Driver analysis (industry, growth, capacity, etc.)
April 2011
2011 ABeam Consulting
Table of Content
SAP BPC Overview SAP BPC Annual Budgeting Process SAP BPC Consolidation SAP BPC Monthly Submission
April 2011
2011 ABeam Consulting
SAP BPC Annual Budgeting Process
Streamlines Planning Processes
8
Consolidation & Review Business Process Centric
2 7
Balance Sheet
Streamline Planning
3 6
Initial Budget
Revenue & COS
Capital Expenditure Budget
4 5
HR Budget Expense Budget
April 2011
2011 ABeam Consulting
Business Process Flow At a Glance Status of All Steps in a Process
April 2011
2011 ABeam Consulting
Business Process Flow
Ensure consistency and minimize training
April 2011
2011 ABeam Consulting
Business Process Flow
Steps Completion Control
April 2011
2011 ABeam Consulting
Annual Budgeting Process
Initial Budget & Set Target
1. Initial Budget & Set Target 2. Revenue & COS Budget 3. HR Budget 4. Expense Budget 5. CAPEX Budget 6. Balance Sheet & Cash Flow 7. Consolidation & Review
Seeding new budget version based on existing version Setting up standard assumptions for budgeting drivers (HR rate, standard Capex rate etc.) Set target and perform topdown allocation
April 2011
2011 ABeam Consulting
Annual Budgeting Process
Initial Budget & Set Target
1. Initial Budget & Set Target 2. Revenue & COS Budget 3. HR Budget 4. Expense Budget 5. CAPEX Budget 6. Balance Sheet & Cash Flow 7. Consolidation & Review
Seeding new budget version based on existing version Setting up standard assumptions for budgeting drivers (HR rate, standard Capex rate etc.) Set target and perform topdown allocation
April 2011
2011 ABeam Consulting
Annual Budgeting Process
Revenue & Cost of Sales Budget
1. Initial Budget & Set Target 2. Revenue & COS Budget 3. HR Budget 4. Expense Budget 5. CAPEX Budget 6. Balance Sheet & Cash Flow 7. Consolidation & Review
Enter budget for revenue and cost of sale by products
April 2011
2011 ABeam Consulting
Annual Budgeting Process
Revenue & Cost of Sales Budget
1. Initial Budget & Set Target 2. Revenue & COS Budget 3. HR Budget 4. Expense Budget 5. CAPEX Budget 6. Balance Sheet & Cash Flow 7. Consolidation & Review
Enter budget for revenue and cost of sale by products
April 2011
2011 ABeam Consulting
Annual Budgeting Process
Human Resources Budget
1. Initial Budget & Set Target 2. Revenue & COS Budget 3. HR Budget 4. Expense Budget 5. CAPEX Budget 6. Balance Sheet & Cash Flow 7. Consolidation & Review
Enter planning data for individual employee by department (new hire, transfer, promotion etc.) Review and approve transfer and promotion
April 2011
2011 ABeam Consulting
Annual Budgeting Process
Expenses Budget
1. Initial Budget & Set Target 2. Revenue & COS Budget 3. HR Budget 4. Expense Budget 5. CAPEX Budget 6. Balance Sheet & Cash Flow 7. Consolidation & Review
Enter budget for non driver base accounts
April 2011
2011 ABeam Consulting
Annual Budgeting Process
Capital Expenditure Budget
1. Initial Budget & Set Target 2. Revenue & COS Budget 3. HR Budget 4. Expense Budget 5. CAPEX Budget 6. Balance Sheet & Cash Flow 7. Consolidation & Review
Enter budget for capital expenditure by department and calculation of depreciation
April 2011
2011 ABeam Consulting
Annual Budgeting Process
Capital Expenditure Budget
1. Initial Budget & Set Target 2. Revenue & COS Budget 3. HR Budget 4. Expense Budget 5. CAPEX Budget 6. Balance Sheet & Cash Flow 7. Consolidation & Review
April 2011
2011 ABeam Consulting
Annual Budgeting Process
Balance Sheet & Cash Flow
1. Initial Budget & Set Target 2. Revenue & COS Budget 3. HR Budget 4. Expense Budget 5. CAPEX Budget 6. Balance Sheet & Cash Flow 7. Consolidation & Review
Balance Sheet adjustment with drivers such as DSO (Days Sales Outstanding) for A/R budget, DPO (Days Payable Outstanding) for A/P budget, Inventory Turn to drive inventory balance
April 2011
2011 ABeam Consulting
Annual Budgeting Process
Balance Sheet & Cash Flow
1. Initial Budget & Set Target 2. Revenue & COS Budget 3. HR Budget 4. Expense Budget 5. CAPEX Budget 6. Balance Sheet & Cash Flow 7. Consolidation & Review
Real time result of Cash Flow Statement
April 2011
2011 ABeam Consulting
Annual Budgeting Process Budget Consolidation & Review
1. Initial Budget & Set Target 2. Revenue & COS Budget 3. HR Budget 4. Expense Budget 5. CAPEX Budget 6. Balance Sheet & Cash Flow 7. Consolidation & Review
Perform allocation of entity based expenses to product level Review reports
April 2011
2011 ABeam Consulting
Annual Budgeting Process Budget Consolidation & Review
1. Initial Budget & Set Target 2. Revenue & COS Budget 3. HR Budget 4. Expense Budget 5. CAPEX Budget 6. Balance Sheet & Cash Flow 7. Consolidation & Review
April 2011
2011 ABeam Consulting
Annual Budgeting Process Budget Consolidation & Review
1. Initial Budget & Set Target 2. Revenue & COS Budget 3. HR Budget 4. Expense Budget 5. CAPEX Budget 6. Balance Sheet & Cash Flow 7. Consolidation & Review
April 2011
2011 ABeam Consulting
Table of Content
SAP BPC Overview SAP BPC Annual Budgeting Process SAP BPC Consolidation SAP BPC Monthly Submission
April 2011
25
2011 ABeam Consulting
SAP BPC Monthly Submission
26
Business Process Flow
Monthly Submission
Monthly Submission process allows users to submit their monthly/quarterly information to the group/sub-group Monthly Submission BPF consist of steps: Enter Data. Actual data loading from transactional system into BPC. For most customers, this is an automated process. However, some customers are unable to load data from the source system and need to manually input the data. This can easily be accomplished through Excel input schedules. Enter Local Adjustment. Adjustment can be made to fulfill statutory, regulatory and financial reporting requirements such as GAAP, IFRS, IAS Reporting. Generating reports and submission process
April 2011
2011 ABeam Consulting
Monthly Submission
Enter Data
1. Enter Data 2. Enter Local Adjustment 3. Reporting
Data Loading can be made manually or system automated
April 2011
2011 ABeam Consulting
Monthly Submission
Enter Data
1. Enter Data 2. Enter Local Adjustment 3. Reporting
PL report as result of data loading
April 2011
2011 ABeam Consulting
Monthly Submission
Enter Data
1. Enter Data 2. Enter Local Adjustment 3. Reporting
Validation checks is configurable validation to provide controls to prevent a user from overlooking a validation error
April 2011
2011 ABeam Consulting
Monthly Submission
Enter Local Adjustment
1. Enter Data 2. Enter Local Adjustment 3. Reporting
Often local site managers need to make adjustments for GAAP or other standards. For example, the Italy office would need to enter adjustments for reporting under US GAAP if the group reports in the US.
April 2011
2011 ABeam Consulting
Monthly Submission
Reporting
1. Enter Data 2. Enter Local Adjustment 3. Reporting
Provide reports of P/L, B/S, Cash Flow, etc
April 2011
2011 ABeam Consulting
2007 ABeam Consulting Technical Proposal 2011 ABeam Consulting
33
CONFIDENTIAL DOCUMENT