![Page 1: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/1.jpg)
Contact Us510.818.9480 | www.kpipartners.com
© KPI Partners Inc.
Start Here
David Graeber Director of Global Finance, Colorcon
Heather Tees Manager of Global FP&A, Colorcon
John Ronga Director of Client Services, KPI Partners
Larry Manekin Hyperion Architect, KPI Partners
December 11, 2014
Customer Spotlight:
Hyperion Financial Planning at Colorcon
![Page 2: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/2.jpg)
Agenda
2
![Page 3: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/3.jpg)
Industry: Pharmaceutical
Presence: Global
Projects:
Financial Planning
Workforce Planning
At A Glance
① About Colorcon
② Business Drivers
③ Obstacles
④ Success Criteria
⑤ The Solution
⑥ Results/Return on Investment
⑦ What To Do Differently
⑧ Q & A
Agenda
Customer Spotlight: Hyperion Financial Planning at Colorcon 3
![Page 4: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/4.jpg)
About Colorcon
4
![Page 5: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/5.jpg)
5
About ColorconWorld-Class Supplier of Pharmaceutical
Excipients and Services
Customer Spotlight: Hyperion Financial Planning at Colorcon
![Page 6: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/6.jpg)
Business Drivers
6
![Page 7: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/7.jpg)
Business Drivers
Customer Spotlight: Hyperion Financial Planning at Colorcon 7
Shorten budget cycle & improve accuracy
Improve ability to plan resources and “see around corners”
Create efficiencies in making budget changes
![Page 8: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/8.jpg)
Business Drivers
Customer Spotlight: Hyperion Financial Planning at Colorcon 8
Improved ability to monitor performance against expectations
Improved ability to adjust spending based on budget vs. current expectations
Build a platform to accommodate periodic forecasts during fiscal year
![Page 9: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/9.jpg)
Obstacles
9
![Page 10: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/10.jpg)
Business Drivers
Customer Spotlight: Hyperion Financial Planning at Colorcon 10
Approx. 3,000
person-days to
complete budget
Spreadsheets are labor
intensive, a source of manual
error and require many levels of
mechanical review.
![Page 11: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/11.jpg)
Business Drivers
Customer Spotlight: Hyperion Financial Planning at Colorcon 11
Timing of Budget
Processes
Begins in July & August
Leads to stale data
![Page 12: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/12.jpg)
Business Drivers
Customer Spotlight: Hyperion Financial Planning at Colorcon 12
Inability to make
changes and
reconsolidate results
in an efficient &
timely manner
No consistency with financial statement preparation across regions
Unable to recycle changes such as FX assumptions efficiently
![Page 13: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/13.jpg)
Business Drivers
Customer Spotlight: Hyperion Financial Planning at Colorcon 13
No ability to
perform scenario
analysis, which
would help drive
timely decision-
making
![Page 14: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/14.jpg)
Business Drivers
Customer Spotlight: Hyperion Financial Planning at Colorcon 14
Our Version of Hyperion
Planning Was Outdated
No update in 8+ years
Out-of-the-box solution
Lack of ownership
Lack of on-going development
A table-based repository of disparate
data
![Page 15: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/15.jpg)
Business Drivers
Customer Spotlight: Hyperion Financial Planning at Colorcon 15
Personnel Planning/Headcount Analysis
Was Cumbersome & Disconnected
Inconsistent methods across regions
Different ownership (i.e. Finance vs. HR)
Inconsistency around classification of headcount & workforce (e.g.
temp staff, contractors, etc.)
![Page 16: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/16.jpg)
Business Drivers
Customer Spotlight: Hyperion Financial Planning at Colorcon 16
Needed Structural
Changes To Align
With Current
Organization of Data
Account Structure
KPIs & Metrics
Entity Structure
Multi-Currency
Security
![Page 17: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/17.jpg)
Business Drivers
Customer Spotlight: Hyperion Financial Planning at Colorcon 17
Financial Reporting
Needed To Be
Enhanced To Facilitate
Reports &
Consolidations
Current financial reports were not
built in an optimized way
Not all regions took an initiative
in financial report development
![Page 18: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/18.jpg)
Success Criteria
18
![Page 19: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/19.jpg)
① Leverage and enhance the budgeting and forecasting
tools at our disposal
② Re-engineer certain processes (Sales, RMs, Workforce)
③ Enhance collaboration across organization Improve guidance & harmonize process
④ Develop consistent assumptions and calculations
⑤ Develop consistent driver-based planning features
Success Criteria
Customer Spotlight: Hyperion Financial Planning at Colorcon 19
![Page 20: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/20.jpg)
① Create format to accommodate efficient analysis (instead
of time spent on data manipulation)
② Enable an efficient statement and consolidation process
③ Workforce planning functionality for improved visibility of
headcount and related costs
④ Efficient currency conversion
⑤ Limit the use of Excel as an intermediary step
Success Criteria
Customer Spotlight: Hyperion Financial Planning at Colorcon 20
![Page 21: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/21.jpg)
21
Ultimately, rebuilding the Hyperion
structure would allow us to…
leverage the tool on the front end
eliminate some of the feeder
spreadsheet needs
better support process
enhancement going forward
Customer Spotlight: Hyperion Financial Planning at Colorcon
![Page 22: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/22.jpg)
The Solution
22
![Page 23: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/23.jpg)
The Solution
Customer Spotlight: Hyperion Financial Planning at Colorcon 23
Why Hyperion? Colorcon already licenses the tool
We are an experienced Oracle shop
Why KPI? We have a technology roadmap, which includes
plans for evolving our BI Tools.
KPI brings a variety of skills to the table, in
addition to Hyperion Planning
![Page 24: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/24.jpg)
The Solution
Customer Spotlight: Hyperion Financial Planning at Colorcon 24
Current System Not
Structured The Way
We Look At And
Report Our Data
Accounts
Locations
Etc.
![Page 25: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/25.jpg)
The Solution
Customer Spotlight: Hyperion Financial Planning at Colorcon 25
Foreign Currency
Capabilities Did
Not Mirror How
Colorcon Has
Conducted
Business
![Page 26: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/26.jpg)
The Solution
Customer Spotlight: Hyperion Financial Planning at Colorcon 26
Workforce & Finance
In One Combined
Application
Organizational hierarchy was
built based on
roles/responsibilities vs.
locations.
Inflexible to changes in
personnel responsibilities.
Not intuitive for drill-down
analysis for financial reporting
![Page 27: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/27.jpg)
27Customer Spotlight: Hyperion Financial Planning at Colorcon
PHASE I
Separate
Workforce into
Separate
Application
No previous Workforce
Application
Understand each
location’s budgeting
needs
External Factors taxes
benefits
Internal Factors merit increases
Incentive
headcount
![Page 28: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/28.jpg)
28Customer Spotlight: Hyperion Financial Planning at Colorcon
PHASE I
Rebuild
Dimensions
Within
Finance
Application
Account Structure mirror Oracle structure
build hierarchy based on
financial statement roll-up
include account calculations
include sub-totals/totals
include KPIs
Organizational Structure mirror Oracle structure
build hierarchy based on global
consolidation
Currency Load data in all currencies
Accommodate multi-currency
Security Set at location/department level
![Page 29: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/29.jpg)
29Customer Spotlight: Hyperion Financial Planning at Colorcon
PHASE I
Develop
Reports for
Global &
Regional Use
![Page 30: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/30.jpg)
30Customer Spotlight: Hyperion Financial Planning at Colorcon
PHASE I
Implement
Smart View
Implement Smart View
![Page 31: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/31.jpg)
31Customer Spotlight: Hyperion Financial Planning at Colorcon
PHASE I
Testing &
Training
![Page 32: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/32.jpg)
The Solution
Customer Spotlight: Hyperion Financial Planning at Colorcon 32
Accommodating 5
Different Regions
Each had their own unique
budgeting process.
Balancing current regional
budget processes with a future
streamlined global vision.
![Page 33: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/33.jpg)
The Solution
Customer Spotlight: Hyperion Financial Planning at Colorcon 33
Building Account
Dimension To Align
With Oracle Row Sets
Used in Oracle FSG
Which Support
Financial Reporting
One account can go into multiple
lines on the P&L depending on the
department/cost center (ex. salaries)
![Page 34: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/34.jpg)
The Solution
Customer Spotlight: Hyperion Financial Planning at Colorcon 34
Timing The
Completion Of Phase I
Phase I began at the end of 2014
budget cycle.
Phase I completed before the
start of the 2015 budget cycle.
![Page 35: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/35.jpg)
The Solution
Customer Spotlight: Hyperion Financial Planning at Colorcon 35
Education & Support
Learning an unfamiliar tool and
simultaneously being an “in-house
subject matter expert” to users
needing training.
![Page 36: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/36.jpg)
Results/Return on
Investment
36
![Page 37: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/37.jpg)
Results & ROI
Customer Spotlight: Hyperion Financial Planning at Colorcon 37
Enabled A More
Efficient Financial
Statement And
Consolidation
Process
Time savings for all users
Limited the use of MS-Excel
Single source of truth
Consistent formulas and metric
definitions
![Page 38: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/38.jpg)
Results & ROI
Customer Spotlight: Hyperion Financial Planning at Colorcon 38
Better
Organization of
Data & Ability to
Perform Ad-Hoc
Analysis
More analysis for decision
making vs. time spend on
data manipulation.
Improved transparency.
![Page 39: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/39.jpg)
Results & ROI
Customer Spotlight: Hyperion Financial Planning at Colorcon 39
Ability To Process
Changes In A More
Timely Manner
Limited use of MS-Excel
Immediate currency conversion
and translation
![Page 40: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/40.jpg)
Results & ROI
Customer Spotlight: Hyperion Financial Planning at Colorcon 40
Workforce Planning
Functionality Allowed
Improved Visibility of
Headcount and
Workforce Costs.
![Page 41: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/41.jpg)
What to Do Differently?
41
![Page 42: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/42.jpg)
What To Do Differently?
Customer Spotlight: Hyperion Financial Planning at Colorcon 42
Additional strategic consideration for system performance within the existing infrastructure.
![Page 43: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/43.jpg)
What To Do Differently?
Customer Spotlight: Hyperion Financial Planning at Colorcon 43
Have an organized CRP (Conference Room Pilot) in advance of go-live.
![Page 44: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/44.jpg)
What To Do Differently?
Customer Spotlight: Hyperion Financial Planning at Colorcon 44
System was built for data input at a department level. This is not efficient for certain data points.
Need different solutions for loading data to various departments at one time.
![Page 45: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/45.jpg)
What To Do Differently?
Customer Spotlight: Hyperion Financial Planning at Colorcon 45
Figure out how to have alternative monthly phasing of P&L items.
There is always room for more planning.
![Page 46: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/46.jpg)
Q & A
46
![Page 47: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/47.jpg)
47
2011 Oracle Titan Award
2012 Oracle Specialized Partner of the Year
2013 Oracle Specialized Partner of the Year
![Page 48: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/48.jpg)
Email: [email protected]
Web: kpipartners.com/contact
KPI World Headquarters
39899 Balentine Drive
Suite #375
Newark, CA 94560
Phone: (888) 988-4KPI
Contact Us
The Leader In Cloud Applications & Big Data 48
New York, NY
Boston, MA
Chicago, IL
Minneapolis, MN
Los Angeles, CA
San Francisco, CA
North America Offices
Bangalore, India Hyderabad, India
Global Offices
![Page 49: Customer Spotlight: Hyperion Financial Planning at Colorcon](https://reader033.vdocuments.us/reader033/viewer/2022060203/559ed4291a28abc6678b463c/html5/thumbnails/49.jpg)
www.kpipartners.com
49