avoid month end panic pac webinar - apr 28 2011
DESCRIPTION
April 28th webinar presentation - Six Ways to Avoid Month End Panic.TRANSCRIPT
Presenters: Graham Finney, VP ServicesEric Normand, Director of Services Justin McNeely, Account Executive
Six Ways to Avoid Month End Panic
Webinar Logistics
GoToWebinar Control PanelHide the Control Panel
Full Screen display
Raise your hand
Enter questions via Chat
box – seen only by
Organizers
Dial in information will
be presented on the
control panel
Q&A will be
mailed out to
all attendees,
along with
today’s slides.
Today’s webinar will be recorded.
� Canadian consulting firm focused exclusively on SAP Enterprise Performance
Management solutions
� Implementing SAP BusinessObjects Planning and Consolidation (BPC) since
2003
� Currently support the majority of Canadian customers using BPC
� Consultants located across Canada
� Consultants have Finance background, CA, CGA, CMA, CPA
� Services include: Evaluation, Design, Implementation, Project Management,
Training, and Support
Sample of Canadian SAP BPC
Customers
Introducing SAP BusinessObjects
Planning & Consolidation (BPC)
MS SQL Server
SAPNetWeaver
Month End Panic – Root Causes and
Issues
� Inadequate tools – Excel
� Information Silos
� Non-standardized presentation
� Non-standardized models (calculations, currency translations)
� Difficulty to perform variance analysis
� Lack of audit trails
� Lack of process support
� Lack of confidence in the data, which can potentially result in poor decision making
SAP BPC Approach to Avoiding
Month End Panic
� Centralized database
� Data is assembled in cubes for multidimensional capabilities
� Facilitates a collaborative approach
� Utilizes Excel while removing limitations of an “Excel only” approach
� User focused and process oriented
SAP BusinessObjects Planning and Consolidation
PAC Can Help You Gain Efficiency
and Transparency Now
Financial reporting and analysis
� Ad hoc query and reporting
� Automated variance analysis
� Driver analysis (industry, growth, capacity, etc.)
� Operations Analysis
Forecasting and modeling
� Demand forecasts
� Capacity/constraint models
� Cash flow models
� Rolling forecasts
� Profitability models
Business planning
� Budgeting
� Sales/revenue planning
� Capital expenditure planning
� Headcount/staffing
� Expense planning
Consolidation
� Inter-company matching/reconciliation
� Inter-company eliminations
� Currency conversion
� Management roll-ups
� Legal consolidation
What the Industry Analysts are
saying…
� Gartner SAP is a Market Leader and has the strongest vision
� IDC SAP #1 in Performance Management Tools
� Forrester SAP has the strongest offering in the Business
Performance Solutions market
� Microsoft – SAP press release November 2009
Microsoft Corporation supports the SAP® BusinessObjects™ Planning and
Consolidation application, version for the Microsoft platform, as a preferred
solution for customers running their business applications on the Microsoft
platform.
#1 Lack of a Systematic Approach
Typical Approach
� eMail based process: Loose and
unstructured requiring time to monitor
� Unstructured data
� Lacks multi-dimensional view
� Reports with different formats and layout
floating around
SAP BPC Approach
� Business Process Flows to guide users
step by step
� Real time progress monitoring and
approvals
� Corporate reports are locked down while
ad hoc reports are flexible
� Data aggregation is performed
consistently and across multiple
dimensions for better insight
� Consistent look and feel can be applied
easily to all reports
#2 No Integrated Data Sources
Typical Approach
� Static version of the data
� Understanding what numbers are correct
� Accumulation and consolidation of data is
manual and difficult
� Lack of audit trails
SAP BPC Approach
� Single version of the truth: All data is
stored centrally
� Data accumulation in real time and
automatic aggregation
� Audit of data and application changes
#3 Management and Statutory
Reporting Data Not Synchronized
Typical Approach
� Separate data sets and reports
� Lack of clear responsibility on statutory
results
� Efforts to report on and analyze between
both views
SAP BPC Approach
� Single source of data for ALL reporting
views
� Unified and centralized platform for
financial consolidations
#4 Intercompany Consolidations are
Difficult
Typical Approach
� Performed late in the process
� Requires consolidation adjustments
� Manual
SAP BPC Approach
� Early in the consolidation process
� Adjustment at the source or in BPC
� Real-time validation rules for speed and
accuracy
#5 Challenges with IFRS vs GAAP
Reporting
Typical Approach
� Separate sets of books
� Overlay of excel adjustments
� Different reports per books of record
� Variance analysis requires time and effort
SAP BPC Approach
� Single source of data for ALL reporting
views
� Adjustment automation capability
� Audit trail: IFRS & GAAP adjustments are
isolated
� One set of dynamic reports
#6 Currency Translation Complexity
Typical Approach
� Spreadsheet based – Inconsistent and
error prone
� Inconsistent even between source
systems
SAP BPC Approach
� Centralized rate tables
� Standardized translation rules
� CTA calculation automation
� Real-time capability
Stage 1Vision, benchmark,
and review
Stage 2Implement quick wins
Action Plan
Prepare a detailed
design
Establish timelines
and milestone
Develop and Test
solution
Train staff and
deploy solution
Perform an “as is”
review
Define vision and
benefits
Obtain executive
sponsorship
Stage 3Post implementation
review
Establish framework
for continuous
improvements
Extend financial
reporting excellence
to budgeting,
planning, operations,
etc.
Outcome
• Process Improvement
• Efficient
• Data Integrity
• Better Decisions
PAC can help with your action plan
Situational Review
� 1 hour call to investigate the end-to-end process
� Perform 2 day diagnostic that clarifies areas of strength
and weakness
Key Deliverables
� Benefits Report highlighting key areas for process
improvement
� Recognizable goals and benefits from process/solution
enhancements
� Foundation for a Business Case
� Determine fit to PAC Consolidation Starter Kit
Perform an “as is”
review
Define vision and
benefits
Obtain executive
sponsorship
© SAP 2009 / Page 18
Thank you!
Justin McNeelyAccount Executive
Performance Analytics Corporation
T (905) 599-7001
www.facebook.com/#!/group.php?
gid=128665063821954&ref=ts
www.twitter.com/PAC_Tweets
www.linkedin.com/groups?most
Popular=&gid=3095692