HOW SUNEDISON MANAGES CASH FLOW WITH SAP BUSINESS PLANNING AND CONSOLIDATION
Andrew FresenburgManager, Financial Reporting / Technical Accounting
Speaker:
Learning Points
2
Learn how SunEdison has improved and streamlined their Cash Flow process using BPC
Hear how Sun Edison uses BPC business rules and flow members in the Cash Flow process
Discover how SunEdison has rolled out Cash Flow preparation to their Global Accounting organization significantly reducing the cycle time to produce Consolidated Cash Flow results
Learning Points
3
“Too often we measure everything and understand nothing. The three most important things you need to measure in a business are customer satisfaction, employee satisfaction, and cash flow.”
- Jack Welch
SunEdison Company Overview
4
• Location: St. Peters, MO• Industry: High-tech Manufacturing• Products and Services: Solar Energy and Silicon Wafers• Employees: 5,633• Revenue: $2.5B
Industry Challenges
5
• Solar Energy is a relatively new industry
• The industry has seen periods of rapid growth, expansion as well rapid contraction, restructuring
• Technology driven industry that is constantly evolving and difficult to stay on the cutting edge
Implementation Highlights
6
Planning model for budgeting and forecasting with data sourced from the consolidations model to drive
actual/budget/forecast variance analysis
Financial consolidation model used to generate consolidated financial statements based on legal and
management structures
Data cleansing and mapping of three ERP systems into SAP BW and integration with BPC
SAP RELEASE: BPC 10.0 NW
THE CASH FLOW SOLUTION
7
Cash Flow Challenges & Opportunities
8
Global operations – needed the ability to produce Cash Flow for 40+ consolidation points
Technical accounting standards drive material Balance Sheet reclasses that have to be backed out of the Cash Flow
Time consuming, manual Excel driven process was being used to complete consolidated USD Cash Flow statement
1
2
3
Solution Design Overview
9
SAP Timberline
Oracle
BPC CONSOLIDATIONS MODEL
Automated Business Rules
Cash Flow User Inputs
ConsolidatedCash Flow Reports
Solution Deep Dive – Automated Data Flow
10
• GL data from three source systems is automatically loaded into the consolidations model and flows through to the Cash Flow.
• Changes made at any of the 40+ consolidation points in LC flow to the Consolidated Cash Flow Statement in USD using BPC business rules and data manager functionality.
• Effect of Exchange Rate calculations have been automated through BPC Script logic.
Solution Deep Dive – Global Analysis
11
Global sites now have visibility and have taken ownership of their own Cash Flow Statements
Global users are able to quickly analyze and identify the impact on Cash Flow accounts using a custom input schedule and flow members
Cycle time to produce the consolidated Cash Flow Statement has been dramatically reduced
Lessons Learned
12
• Do not underestimate the effortrequired for design, implementation,and testing.
• Involve the right business resourcesearly in the design process.
• Due to the typical Finance/Accounting calendar, continuous management of resources is necessary.
• Align project priorities with leadership goals and expectations – strong executive sponsorship is key.
Solution Success
13
The right partner and teamwork are keys to success.
Success requires a team effort between business users who understand your company’s operations, challenges, and
objectives & a technology partner who understands the technology and how to implement it.
14
Why SunEdison Chose Akili
• Akili is an SAP Gold Partner IT services firm specializing in:
• Why Akili?
14
2
Expertise
3
Commitment
1
Business Focus
Genuine passion for improving our business
Implementation knowledge
They always deliver
o SAP HANAo Mobilityo Cloud offerings for Afaria, BPC, BI, HANA
o Enterprise Performance Management
o Business Intelligence (BW/BI)o ERP for Upstream Oil & Gas
THANK YOU!
15
WRAP UP & QUESTIONS