130 likes | 146 Views
Financial Management Systems. FINANCIAL PLANNING TOP-DOWN OR BOTTUM-UP VERSITALITY WHAT IF ANALYSIS. Who Uses Hyperion. “Hyperion provides best-in-class performance management software to over 12,000 customers worldwide, including 91 of the Fortune 100.”
E N D
Financial Management Systems • FINANCIAL PLANNING • TOP-DOWN OR BOTTUM-UP VERSITALITY • WHAT IF ANALYSIS
Who Uses Hyperion • “Hyperion provides best-in-class performance management software to over 12,000 customers worldwide, including 91 of the Fortune 100.” • Letty Ledbetter Oracle Public Relations
Multi-dimensional • Account • Period • Years • Reporting Geography • Business Organization • Scenario • Version • Entity • Basis
What kind of decision or problem is being considered? • Financial Forecasting • Modeling • Decision Making
Who are the decision makers? • Management • Used by lower level planners • Reports generated for CFO and Board
What Options are They Considering? • Growth Rate • Profit Margins • Expenses • Ect.
What kinds of information are necessary to determine the benefits of the options under consideration? • Previous Months Forecast vs Actual data • Previous Years Forecast for that month vs Actual Data • Possibly multiple year forecast to locate a trend • Information about crop yields • Information about other competitors • Information about the weather (they use the farmer’s almanac & look at trends from previous years) • Information about what part of the world the crop grows best in and how it has grown in each specific location in the past • Information from Strategy about where the company is headed.
What kinds of models are necessary to examine that information? • Rolling Forecasts • Actual vs Forecast reports for prior months and years (which are provided by using Hyperion Essbase Reporting) • Special models in excel that provide strategy information and crop yield information • Reports showing competitors reported numbers
What kinds of problems in data collection and/or analysis are likely? • Planner Sandbagging • Excel models • What-if Analysis
How would you address those needs in a DSS? • Hyperion Training • Elimination of Multiple Spreadsheets