Make Better Decisions Faster Dr. Kitipan Kitbamroong, Director, Sherwood Group Consulting www.shernox.com
About Sherwood Group Consulting
Sherwood Group Consulting, (Est . 1993 Thai 2002) 1. Specialist advisory team focused on business growth and related productivity 2. Our Expertise is creating under-pinning operations & finance based performance reporting and analytics. 3. We understand business and what drives it. 4. We use CPM / BI solutions in our work & recommend Infor 5. We are Independent & focus to exploit best technologies
Information Management for the Modern CFO
Planning
Analytics & BI
Business plans Budgeting Forecasting Business case evaluation
Performance against plan Opportunity analysis Information requests
Company Strategy
3
Reporting
Managing Risk
Internal accountability External bodies Country-specific requirements
Access to information Segregation of duties Audit costs Scenario planning
Copyright © 2011 Infor. All rights reserved.
The Planning Perspective – Challenges Takes too long to complete budgeting and/or forecasting cycles Planning processes are cumbersome, inefficient, and often manual Closing the books and reporting takes too long Difficulty getting buy-in from key stakeholders Too much time is spent on gathering data, not enough on analyzing it Different spreadsheets that aren’t centralized or controlled
4
Copyright © 2012 Infor. All rights reserved.
Budgeting And Forecasting Are Time Consuming At The Majority of Companies
Source: Financial Planning: Realizing the Value of Budgeting and Forecasting, 2011
5
Copyright Š 2012 Infor. All rights reserved.
Forecasting Accuracy is a Challenge
6
Copyright Š 2012 Infor. All rights reserved.
Need to Tie Planning to Execution
Loose linkage between strategies and budgets/operational plans Forecasts and plans don’t consistently match actual performance
Require more collaborative and enhanced planning processes
7
Copyright © 2012 Infor. All rights reserved.
Budgeting & Planning Best Practices 1. Make planning part of the fabric of your business
2. Link strategic initiatives to financial budgets & plans 3. Ensure you have collaboration on plans enterprise-wide 4. Implement a rolling planning process to ensure plans are timely and accurate 5. Ensure you do both top-down and bottom-up planning
6. Keep pace with business change 7. Base plans on the key factors that drive your business
8. Integrate your budgeting, forecasting, strategic planning, financial consolidation, reporting and analysis 8
Copyright Š 2012 Infor. All rights reserved.
Value of Performance Management Solutions
Time to decision in best in class companies has decreased 23% over the past year as opposed to a 2% decrease for others Best in class organizations are 54% more likely to update plans/forecasts on a monthly basis, than all other organizations Operating profit margin was17% for best in class organizations vs. 14% for all other organizations
9
Copyright © 2012 Infor. All rights reserved.
Universal Studios Hollywood Challenges PROFILE Media and entertainment Theme park operations Subsidiary of NBC Universal
Weren't able to perform some of the critical tasks like category and channel management, labor scheduling optimization, and providing on-demand visibility into KPIs Spreadsheet-based budgeting and reporting system couldn’t handle the rising demand for financial and operational analysis as the business grew
Results Reduced budgeting cycle by 50% Real-time visibility into both leading and lagging KPIs, as well as detailed category and sales channel penetration Scenario-enabled modeling with detail on both risk management and variance analysis
10
Copyright © 2012 Infor. All rights reserved.
Common Customer Challenges Difficulties using spreadsheets to plan & report the business Closing the books and reporting takes too long Need a flexible system to pull all financial information together, in a timely manner to meet management and regulatory reporting requirements Require more operational buy-in and enhanced planning processes Need to reduce time and effort involved with budgeting and/or forecasting cycles Loose linkage between strategies and budgets/operational plans Too much time is spent on gathering budget/forecast data and not enough on analyzing the information Forecasts and plans don’t consistently match to actual performance Difficult to do what-if and/or rolling planning Take a look and replace Common Challenges with your Specific ones your will find many the same 11
Copyright © 2012 Infor. All rights reserved.
Infor10 Corporate Performance Management
Data Management
Closed-Loop Performance Management
ERP
Web Views
Strategy Planning
Financials
Management Reporting &Analysis
Excel Views
Budgeting CRM ION & Business Vault Other Data ION & Business VaultSources
12
Forecasting Security
Structure
Cubes
Databases
Copyright Š 2012 Infor. All rights reserved.
Consolidation
Workflow Approvals Exception Web Rules Text Comments
Infor10 Workspace In-context BI | Collaboration | Mash-ups | Activity Streams | Pulse | Search | Experience | Security
Budgeting & Forecasting
Reporting & Analysis
Financial Consolidation
Zero based, historical, rolling and other planning processes Collection, tracking, and approval process Employee, assets, ad-hoc detail budgets and forecasts Trend analysis and predictions Scenario planning and version tracking Currency translations
Multi-reporting capabilities - management, legal entity, business segments, tax & other reporting Financial & operational reports, KPIs, scorecards, dashboards & other information End-user ad-hoc analysis, drill- down, drillback Present information in multiple formats (web, Excel, PDF, etc.)
Legal/statutory consolidation Multi-reporting & multi-entity consolidations (corporate/local GAAP, IFRS, etc.) Ownership/ Inter-company eliminations XBRL reporting Audit reports and controls Currency translation gains/losses Loading, workflow and approval process
Strategic Planning
Planning
Infor Extended Business Solutions
Develop strategic plans Link strategies to operational plans Measure and monitor strategic initiatives by sponsor, business unit and other ways Supports multiple methodologies including: Six Sigma, Economic Value Added (EVA), Balanced Scorecard and Hoshin
Driver based business modeling Set high level business targets “What if” scenario planning Approval processes Currency modeling Allocation rules
Business Intelligence Expense Management Continuous Control Monitoring ERP Core Financials HCM Others
ESB | Integration | BPM | BI | Business Vault | MDM | Extensibility | Mobile | Cloud
Infor10 ION Services Platform
Infor CPM – Greif Systems
PROFILE Leading industrial packaging product and services company Company involved in industrial packaging since 1877 $3.5B net sales for FY’10 & publically traded company More than 200 operating locations in over 50 countries More than 12,000 employees
14
Copyright © 2012 Infor. All rights reserved.
Challenges
Handling growth by acquisition strategy Global business reporting & analysis Need enhanced budgeting/planning capabilities More back-office standardization and centralized processing Need to reduce costs and business complexity Simplify financial consolidation process
Infor Solution Overview Infor CPM Budgeting, Planning, Financial Consolidation, Reporting & Analysis Consolidation & Financial Reporting is a Oracle/Hyperion replacement Customer also replaced home grown expense management system with Infor XM
Infor CPM – Gordon Food Service
PROFILE North America's largest family-owned broadline foodservice distributor $7B in annual revenues In the food business 100+ years.
Gordon Food Service is committed to growing both today and in the future. We actively manage today's business by constantly measuring ourselves against targeted key performance metrics….We pursue tomorrow's success via disciplined strategic and financial planning. - From Gordon Web Site (Deb 2011)
Solution Overview Infor CPM Budgeting, Forecasting, Financial Consolidation and Management Reporting & Analysis Leverage Lawson GL and Core Financials 650 Infor CPM Budgeting, Planning & Reporting users across US and Canadian Business Units Management team leverages CPM for reporting & analysis Infor CPM for Financial Reporting & Consolidations for US and Canadian Businesses CPM help customer manage its complex financial data in the most efficient way
Results Easy financial data loading to Infor CPM for consolidation, analysis, and reporting Web-based access to one source of global numbers Ability to slice and dice data and perform multicurrency accounting Significant improvement in overall accountability
15
Copyright © 2012 Infor. All rights reserved.
Infor CPM/BI – BAE Systems
Challenges PROFILE Global defense and security company. Sales of more than $34 billion in 2010 Customers in over 100 countries “With tighter budgets and greater demands from defense customers around the world, our business is facing significant challenges but also a range of exciting opportunities in all our markets… supported by Infor10, this transformation program will drive our competitiveness and ensure BAE Systems MAI is more efficient and responsive to market conditions.” - Adrian Fallows, head of strategic business systems, BAE Systems MAI
16
Copyright © 2012 Infor. All rights reserved.
Need for increased visibility and ‘one version of the truth’. Difficult because of reliance on spreadsheets and separate systems. Multi-currency and statutory reporting Solution that would minimize disruption and risk to the business The need for more transparency and ability to drilldown into sales, cash, inventory variances, product line profitability and other key business information. Need for enhanced management reporting and ability to deliver information direct to managers in the format and depth required to enable timely, accurate decision making.
Solution Overview Infor10 CPM Budgeting, Financial Consolidation, Reporting & Analysis Solution includes Infor10 ION BI, Infor ERP LN, Infor10 ION, Infor Barcode, Infor Supply Web and other Infor Solutions
Infor CPM Customers
Hospitality & Entertainment
17
Financial Services
Copyright Š 2012 Infor. All rights reserved.
Healthcare
Manufacturing
Oil & Gas & Utilities
Retail, Wholesale & Distribution
Note: Customers are not a comprehensive list of companies or industries
Infor10 CPM – Budgeting & Forecasting
Zero based, historical, rolling and other planning processes Collection, tracking & approval process Employee, assets, ad-hoc detail budgets and forecasts Trend analysis and predictions Scenario planning and version tracking Currency translations 18
Copyright © 2012 Infor. All rights reserved.
“As soon as the budget system is closed for input, we produce an actionable P&L statement within hours. The critical bottom-line benefits for us resulting from using Infor FPM are improved financial accountability and enhanced business performance. Everyone from top management down is happy with the process and the results.” - Marlena Ward, VP Financial Planning Dana-Farber
Infor10 CPM – Reporting & Analysis Multi-reporting capabilities - management, legal entity, business segments, tax & other reporting Financial & operational reports, KPIs, scorecards, dashboards & other information End-user ad-hoc analysis Present information in multiple formats (web, Excel, PDF, etc.)
19
Copyright © 2012 Infor. All rights reserved.
“On-demand reporting gives our department managers the information they need to make the right decisions. Now they can see when to make course corrections—before small problems turn into big ones.” - Cathy Kellers, Assistant Controller, Foxwoods Resort & Casino
Infor10 CPM - Financial Consolidation
Legal/statutory consolidation Multi-reporting & multi-entity consolidations (corporate/local GAAP, IFRS, etc.) Ownership/ Inter-company eliminations XBRL reporting Audit reports and controls Currency translation gains/losses Loading, workflow and approval process
“The consolidation process takes much less time and effort … and provides tremendous help to users everywhere to get financial data in a timely way." - Larry Johnson, Senior Finance Director for Global Operations & Reporting World Vision
20
Copyright © 2012 Infor. All rights reserved.
Infor10 CPM – Strategic Planning
Strategic Planning Cycle
Develop strategic plans Link strategies to operational plans Measure and monitor strategic initiatives by sponsor, business unit and other ways Supports multiple methodologies: Six Sigma, Economic Value Added (EVA), Balanced Scorecard, Hoshin & others 21
Copyright © 2012 Infor. All rights reserved.
"All too often we see companies budgeting back-to-front deciding what activities they can afford to do against the budget. Instead we have taken our corporate strategy and developed clearly defined operational plans and individual targets. We then set the budget to finance these activities. As a result we have an effective collaborative budgeting process which resources the plans that meet our strategic goal.“ - Callie Masson, CFO, Professional Provident Society
Infor10 CPM - Planning
Planning Cycle
Driver based business modeling Set high level business targets “What if” scenario planning Approval processes Currency modeling Allocation rules 22
Copyright © 2012 Infor. All rights reserved.
“We needed a planning tool to create individual financial store plans with online contributions from our field-based Operations teams. We are able to quickly update plans as business needs change and model multiple scenarios to achieve key strategies. Infor FPM allows fast and easy scenario modeling which will save us considerable amounts of time.” - Paul Brannan, Planning Manager KFC Great Britain
Infor CPM – “Hot” Vendor in Analyst Evaluation
Infor CPM receives a top 3 “Hot” vendor rating from Ventana Research
Source: The Ventana Research Value Index: Financial Performance Management, November 2010
23
Copyright © 2012 Infor. All rights reserved.
Industries of Sherwood’s Significant Clients
Oil & Gas Exploration/Production - PTTEP, Chevron Manufacturing & Distribution
24
- Behringer, Faulding, Ingram Micro
Mining / Engineering
- CRA, RTZ
Hospitality
- Centara Hotels & Convention Ctrs
Financial Services
- KrungThaiAxa, Tokio Marine.
Logistics and Transport
- OnTime Group -
Retail
- ColesMyer,Electrolux
Copyright © 2012 Infor. All rights reserved.
In Summary Value Our Customers Got using Infor CPM as the enabler “We reduced our end-of-month close process from 100 hours to 3 hours.”
“We now measure performance, at the manager level, against the strategic plan.”
“We reduced our budgeting cycle by 50%.”
“We improved our close process from over five days to a ‘virtual close’ in less than 2 days.”
“We reduced our forecasting process from 13 days to 4 days.”
“We reduced the time to report key information from the subsidiaries to less than one day.” “We became 95% more efficient in producing product line P&L forecasts.”
25
Copyright © 2012 Infor. All rights reserved.
What should you to do next …..
Business in Thailand becoming uncertain again When you leave today consider How you can lift your issues into focus fast to let you concentrate priorities. (Sherwood Mosaic Metaphor) How a small investment can give kick that off with big bang for your buck quickly with a big capability to react and do much more. Talk to us about how we can do a fast track fast start for value to say get your budgets done this year. (E.g. to do it faster you can even use our servers until you are ready) And if it is just sensible view of your data to model your costs you want, we can help to link it to our BI / tools
For all that we use Infor CPM & BI as enablers 26
Copyright © 2012 Infor. All rights reserved.
Thank you & questions
Thank you & Your questions are welcome 27
Copyright Š 2012 Infor. All rights reserved.
Resume Kitipan Kitbamroong Phd
Graduated with Ph D (Chemical Engineering) Director Sherwood Consulting Group Founder and Director Benox Company Limited
Effective in – English and Thai language communities Experienced Corporate and business process solutions consultant in Thailand and aboard Hands on expert advisor and lead in Infor 10 CPM solutions
Participation in thought leader programs for better business 28
Copyright © 2012 Infor. All rights reserved.