Hyperion EPM Overview

simpleluncheonΔιαχείριση

10 Νοε 2013 (πριν από 3 χρόνια και 9 μήνες)

77 εμφανίσεις


Hyperion EPM Overview

&

Case Study




Agenda



Introduction



EPM Product Overview



Case Study




Introduction






Use Hyperion?



Oracle Integrated

BI

ERP

FDQM

Acct
Close

Planning

Oracle Integrated


ERP
-

Actual Amounts


FDQM


Load / Map Data


HFM


Consolidated Actual Amounts


HP


Budget / Planning


BI Tools

Financial Close


Hyperion Financial Management (HFM)


Comprehensive, Web
-
based application that delivers
global financial consolidation, reporting & analysis.




Hyperion Financial Close Mgt


Centralizes mgt of all period
-
end close activities,
replacing checklists with dynamic dashboards that
give users ability to immediately view & act on info.



Hyperion Disclosure Mgt


Centralize & effectively manage the development of
XBRL tagged submissions


Planning


Hyperion Planning


Centralized, Excel & Web
-
based planning, budgeting
and forecasting solution that integrates financial &
operational planning processes and improves business
predictability.



Hyperion Workforce Planning


Planning module that makes headcount, salary, &
compensation planning fast and efficient across the
enterprise.


Hyperion Capital Asset Planning


Planning module that automates the planning of capital
assets and capital asset related expenses
,


Case Study



Growing US medical company


Headquarters in Northwest


Multiple sites across country


Annual Budget Process done manually in Excel









Challenges



Extremely time consuming


Build and manage model


What if analysis


Report on data


Comparative reporting Actual vs. Budget


Track versions of budget amounts


Minimal controls in place


Security of data


on laptop


Not easy to share with others


Consolidating amounts



Solution


Jibe Jumpstart Implementation


Implement Hyperion EPM System


Planning


Central repository database


Integrates actual and budget amounts


Standard calculations


Decentralize Planning


Uses multi
-
dimensional hierarchies


Use BI Tools


Financial Reports


Well formatted reports


Excel Smart View


Ad hoc analysis


Project Phases


Requirements / Design


Build / Unit Test


Test


Deploy / Go Live









What is so unique about this project?

Implementation



They built most of the application themselves



For a tiny fraction of the time and cost



In less than

3 months











How is that possible?

Jump Start


Consultant for project involved in sales cycle


Hosted Application


Customized detailed training session


Design session for current and future needs


Prioritize requirements & assign to phases


Keep only ‘must have’ items in phase 1


Detailed design document


Weekly task review sessions


Jibe built initial calculations


Detailed calculation review

Timeline

3/25

-

Initial Sales Meeting

4/1





Scoping discussion

4/12



Customized training

4/14



Design session

4/19



Jibe installs / hosts Hyperion

4/30



Approve detailed design document

5/1



Create Planning application shell

May



Company X builds system

June



Company X tests system

July 1
st




Go Live


Start annual budget process



Phase 1



Finance owns and maintains system


Budget for:


Revenues


Expenses


Individual employee expenses including existing
and new employees


Capital Expenditures


Load current year budget and actual amounts


Comparative Income Statement reporting


Use Department Excel templates

Phase 1 (con’t)



Calculations


Aggregations


Clear Data


Project Allocation


Employee Expenses


Deferred Compensation


Shift Differential


Salary Adjustment


Bonus


401K


Payroll Taxes


Benefits


Temporary Labor




Phase 2
-

Expand


Phase 2
-

< 2 Months


Calculation Training


Add additional calculations


New hire salary


Depreciation


Allocations


Start quarterly forecasting within system


Web Forms


Reports


Calculations


Automate calculations to run nightly


Phase 3



Phase 3
-

< 2 Months


Decentralize data entry to ~45 departments


Expand Budgeting and Reporting


Balance Sheet


Cash Flow


Benefits


Decentralization


Departments took ownership of their data


Provided better understanding of data


Workflow identified bottlenecks


BI Tools


Less mgt emails asking for data


Less time to develop budget & forecasts


More time & improved analysis tools

Key Characteristics


Small Core Team


1
-
2 people who makes decisions


Availability


Committed / Incentive to succeed


Standardized stable hierarchies, data entry,
calculations and reporting




DEMO

Workspace

Planning

Smart View

Reporting

Web Analysis

Ad Hoc Analysis