Analytic Vision

Company Background

Based in Jacksonville, FL, PSS has grown into the country's largest provider of medical supplies to the physician market through its commitment to fast service and the belief that "The customer is everything."

Business Challenges

• Spreadsheet based budgeting solution, disconnected from  J.D. Edwards ERP System
• Need for driver based revenue and margin budgeting models with different product lines and customers across multiple subsidiaries
• Poor target setting for product line \ volume based revenues
• Not able to model “what if scenarios” for growth assumptions and targets
• Not able to integrate P&L and Balance Sheet Planning in Excel
• Not able to efficiently model headcount\ human capital costs by segment, while modeling the impact of corporate target setting
• Limited ability to produce consolidated financial reporting & analytics, while modeling consolidations across legal, operational, and divisional views of the business

Solution Implemented

Integrated Hyperion Planning 11 and Hyperion Financial Management 11 Solution

• Oracle Hyperion Planning  11
• Oracle Hyperion Reporting Studio 11
• Oracle Hyperion Essbase Analytics 11
• Oracle Hyperion Financial Data Quality Management 11
• Oracle Hyperion Financial Management 11
   

Business Benefits

• Upgraded all existing Essbase cubes to Hyperion System 9
• Hyperion Planning integrates with J.D. Edward ledger for account level expense planning.  
• Ability to model base level plan from historical run rates
• Driver (volume) based revenue planning by division
• Driver based margins and Cost of Goods modeling
• Integrated P&L and Balance Sheet Planning
• Automated, financial close and consolidation process including financial & management reporting