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