How Guardian Combines Financial and Operational Drivers for a Truly Integrated Plan Alex Beired Rachel Murphy Chris Loran
About Guardian Industries Manufacturer specializing in ⦿ Float Glass & Automotive Trim 18,000 employees ⦿ 25 countries / 5 continents ⦿ Revenue US$4.0 billion ⦿ HQ in Auburn Hills, MI, USA ⦿ Acquired by Koch ⦿ Industries in 2017
About Guardian Glass Main division of Guardian ⦿ Industries. 10,000 employees ⦿ 25 countries / 5 continents ⦿ Revenue US$2.6 billion ⦿ HQ in Auburn Hills, MI, USA ⦿ … and this is what we do
Our Main Products ⦿ Float ⦿ Pattern ⦿ Vacuum Coated ⦿ Laminated ⦿ Tempered ⦿ Acid Etched ⦿ Mirror
OneStream Evolution at Guardian Financial Complianc Forecasting Planning Reporting e AOP AOP and Long Term Consolidation Gl Glass 3 3 Y Yea ear Q2 Q2 2016 Guardian Tax Q2 2013 Ou Outlook KP KPI Dri river r Based AOP Package Q3 Q3 2017 Co Conso nsolidat ation n Q4 2014 Gl Glass S Seg egmen ent Gl Glass Peo eopl ple e Planni nning ng Q3 Q3 20 2013 Q3 Q3 2017 Re Report Q2 2013 Lo Long ng Ter erm Plan n Q2 2018 Q2 Tax Provision Mo Monthly Forecast Q4 2017 Account SRG Forecast Q2 2018 Q2 Reconciliation Consolidation Pe Perfor ormance Tracking Q3 Q3 2018 Gl Glass S Seg egmen ent Q2 2017 Q1 2014 SRG People Planning Re Report Q3 3 2018 Q3 2018
Scope & Vision By: Alex Beired
Opportunity Statement Our financial planning system was not integrated with all the underlying ⦿ performance assumptions (OpEx bets, headcount, etc…) Regions used their own Excel based tools to model individual business ⦿ assumptions only using OneStream to consolidate results at a global minimum standard. Planning models were different in every region with limited harmonization. ⦿ Regional models were not globally scalable as we grow our business and ⦿ impractical to maintain through Excel. These disconnected models prevented us from doing variance analysis within the ⦿ system and force the region to perform this analysis on the side.
CPM - Vision “Integrated global financial planning system that will allow the business to : plan future performance ⦿ track variances to the underlying assumed KPIs” ⦿
CPM - Vision rated global financial planning system that will allow the business to : “ Integrat plan future performance ⦿ track variances to the underlying assumed KPIs” ⦿ Integrated
CPM - Vision global financial planning system that will allow the business to : “Integrated gl plan future performance ⦿ track variances to the underlying assumed KPIs” ⦿ Global
CPM - Vision global financial planning system that will allow the business to : “Integrated gl plan future performance pl ⦿ rack variances to the underlying assumed KPIs” trac ⦿ Plan and Track Performance
CPM - How Goal- “Integrated global Setting financial planning system that will Analysis & allow the business Planning Modeling to plan future Insight Profitable performance and Action track variances to the underlying assumed KPIs” Consolida- Reporting tion CPM Project Scope
Leveraging OneStream’s SmartCPM TM Platform ü One Product ü One Application ü Multiple Solutions ü Maximize Reuse
◉ ◉ ◉ ◉ ◉ ◉ Project Scope ⦿ 2017 New driver-based planning solution to replace Excel processes 2018 Annual Operating Plan (Budget) generated using new solution ⦿ 2018 Strategic Plan (5 Year Forecast) Monthly Forecast Revisions Align S&P (data warehouse) data with reported OneStream Actuals Improved Walk Reporting with aligned drivers across scenarios
Project Considerations By: Rachel Murphy
We’ve been here before… Forecasting Planning AOP and Long Term Q2 AOP Q2 2016 Glass 3 Gl 3 Y Yea ear O Outlook Conso Co nsolidat ation KPI Driver Based AOP Q3 2017 Q3 20 Q3 2013 Glass People Planning Q3 2017 Long Term Plan Q2 2018 Monthly Forecast Q2 2018 SRG Forecast Consolidation Performance Tracking Q3 2018 Q1 2014 SRG People Planning Q3 2018
So what’s different? We We act ctually lly USE SED On OneStrea eStream
◉ ◉ ◉ Critical Success Factors ⦿ Global Project Team ⦿ User-friendly modeling: Embedded modeling logic that the business can manage ourselves. ⦿ Process / summarize large volume of data ⦿ Workflow management for guided user experience ⦿ Real time calculation: Change drivers or assumptions then immediately see the calculated effect Beyond just data roll-up, businesses need real-time calculation so changes instantly ripple through all connected plans to reveal the impact right across the enterprise—all the way to the profit and loss account and cash flow forecast. ⦿ In order to get here…we had to change our approach
◉ ◉ ◉ ◉ ◉ ◉ ◉ ◉ ◉ Model Requirements ⦿ Metadata Consistency Entity General Ledger Accounts Sa Same as Consolidation ABC Process ⦿ Model Consistency Strategic Plan Same Planning Mo Sa Model Annual Operating Plan Monthly Forecast Revisions ⦿ Financial Reporting Income Statement Sa Same as Consolidation Balance Sheet Cash Flow
◉ ◉ ◉ Model Innovations ⦿ Expanded Product Dimensions Commercial View (UD6) Ul Ultimate G Game C Cha hang nger! Operations View (UD2) Process View (UD3) ⦿ Revisions Dimension ⦿ Customer Type Dimension ⦿ Regional vs Plant Workflows
Model Innovations ⦿ Automated Intercompany Sales Eliminations Tr Trace th the flow of ⦿ Integrated Material Cost in inve ventory y from plan lant to ⦿ Inventory Flow Calculations pl plant nt, pr produc uction, n, co consumptio ion, outsid ide sale sale an and ap apply d ly drive river r Float Coated Warehouse ba based c d cos ost Sale Float Raw Float Purchased Hot End Cold End Storage Shipping Material Produced (IC Material)
Data Integration ⦿ People Planning ⦿ Internal Sales & Profitability Data Warehouse ⦿ Internal Operations Data Warehouse
Implementation Details By: Chris Loran
About Agium EPM European OneStream Platinum partner, based in the Netherlands ⦿ We are passionate about finance and financial systems ⦿ Average EPM experience per consultant > 10 years, some over 25 years in EPM ⦿ Partner since Q1-2014 – one of the first in Europe ⦿ We are true specialists, not generalists ⦿ - All consultants are OneStream trained and OneStream focused 25 OneStream projects in 5 countries ⦿ Regular contributor for ready-to-use modules / starter kits (e.g. IFRS16/ASC842) ⦿
Specialty Apps ⦿ One myth is that you do all your driver calculations only in Specialty Apps, then consolidate the plan using the cube. Consolidation Cube(s)
Specialty Apps ⦿ One myth is that you do all your driver calculations only in Specialty Apps, then consolidate the plan using the cube. ⦿ Actually… Cubes are still a powerful and most suitable place to calculate much of the forecast data. Specialty Apps are usually supplemental to that process.
Planning Considerations ⦿ Enter/modify drivers and instantly see calculated results ⦿ Data spreading and top-down allocations ⦿ Extensible dimensionality ⦿ Data blending with relational data ⦿ Re-use of form items (cube views) for various scenario types ⦿ Calculations are focused on specific accounts (rather than on complete Data Units) ⦿ Span multiple years (rolling fcst and long-term) ⦿ Work mostly with periodic data (instead of YTD)
Instant calculation on data entry ⦿ Demo
Linking Calc Rules to Cube Views ⦿ Dashboard links cube views to business rule functions. ⦿ Allows customer to self-service what calculations get automatically triggered when saving data from specific forms.
Automatic Top-Down Allocations Demo: Immediate top-down allocation/spreading of high-level input data ⦿ Can make good use of Extensible Dimensionality ⦿ Not just through user interface (right-click action) but also through API.Data.Allocate(…). ⦿ Demo: Toggle box for Actual data comparison periods ⦿
Dynamic Row & Column Filtering Matrix-Style control on what products get displayed in each entity ⦿ New feature from v4.2 to show/hide suppressed rows (but this matrix implementation goes further) ⦿ Want to show blank rows, but only for those valid entity/product combinations ⦿ Demo: ⦿
◉ ◉ ◉ Data Blending Users can retrieve a blend of relational and cube data Data is loaded regionally or centrally, users see a filtered view for their own entity/plant. Demo: Filtered stage data Sales detail for this entity
Flexible Seeding ⦿ Dashboard allows regional FP&A to control population of baseline ⦿ Selectable number of actual periods to average
Re-Use of Components ⦿ Various scenarios have different time frequencies Examples Annual Operating Plan Jan-Dec (Monthly) Monthly Forecast Revisions Forecast + Actual Monthly Blend Strategic (5Y) plan Y to Y+6 ; Yearly Input ⦿ All these scenarios are implemented using one set of cube-views… ⦿ Remember copying form designs in previous-generation EPM products?
Recommend
More recommend