1 / 18

Helping Companies Learn From the Past, Manage the Present and Shape the Future.

Helping Companies Learn From the Past, Manage the Present and Shape the Future. How Shutterfly Cut 5 Days Off Their Close Learn how you can shorten your close cycle, gain visibility into profitability and variances (by product, region, customer). Not Necessarily News.

sybil
Download Presentation

Helping Companies Learn From the Past, Manage the Present and Shape the Future.

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Helping Companies Learn From the Past, Manage the Present and Shape the Future. • How Shutterfly Cut 5 Days Off Their Close • Learn how you can shorten your close cycle, • gain visibility into profitability and variances • (by product, region, customer)

  2. Not Necessarily News Most financial analysis still relies on tedious, repetitive, manual, error-prone processes Staff expend days and weeks… compiling, extracting and reconciling data, in support of planning and reporting

  3. Senturus • Corporate Performance Management solutions • Business Intelligence • Enterprise Planning • 300+ customer implementations over past 9 years • Software, professional services and training • San Francisco Business Times “Fast 100”, 4 years running • Success based on: • Blend of business acumen and technical expertise • Field proven practices to maximize user adoption • Packaged code / templates for diverse data sources (JDE, SAP, Oracle, etc.)

  4. Webinar Agenda • Current Situation • Solution Overview • Tom Cadden: Shutterfly Success • Q & A

  5. GL and Plan Data: A Tale of Two Silos • GL data lives in Accounting / ERP system • Plan data lives in enterprise planning system…or in spreadsheets • Significant effort to integrate for financial milestones • Requires manipulation and transformation • Manual errors make data unreliable, requiring more manual effort to validate

  6. Accounting Reports: Too Much Accounting • High level summaries not useful for analysis • Detailed reports—too much raw data, not enough actionable information • Accounting codes not meaningful to business owners • Different requirements, GAAP vs. internal reporting

  7. No Automated Tools • No easy way to harmonize GL and Planning data and make it actionable • No ability to instantly drill down on details: Budget vs. Actual By Department Profitability By Customer or Region Profitability By Product • No easy way to compare results across organization • No ability to automatically highlight variances, rankings, thresholds, trends—specific to each stakeholder

  8. Solution Overview • Finance Data Mart with granular details • Automated planning system • Self-service reporting portal • Drillable analytics tool Profitability, budget vs. actual, variances • Management dashboard Organizational comparisons, rollups, trending

  9. Finance Data Mart Drill to Details Dashboards Reports Scorecards KPIs ERP GL Planning Oracle Host Analytics SAP Cognos Planning Data Mart Great Plains Hyperion Essbase Lawson OutlookSoft Single Source of Truth JD Edwards Spreadsheets Scenarios: “ What If ”, Historical Daily Update of Actuals

  10. Example Dashboard: Sales and Margin Variances Sales & Margin Actuals and Budget details by District and for the total Company.

  11. Example Dashboard: Labor Hours, Budget vs. Actual User can drill through to details to investigate variances and take corrective action

  12. Solution Details • Automated extraction / transformation of GL data to harmonize with Planning data • Auto-population of dashboards (browser-based) • Important variances are highlighted • Clickable “drills” to underlying details • Data displayed is specific to owner (via login) • Sensitive data not displayed

  13. Tom Cadden, • Senior Manager, FP&A • Shutterfly, Inc.

  14. Shutterfly • Leader in Internet-based social expression and personal publishing services • Launched all-digital Internet photo printing service in December,1999 • Rapid growth, dynamic organizational environment, lots of change, organic and via acquisitions • Needed to integrate business owners into budgeting / planning cycle, while keeping staff lean

  15. Shutterfly • Objective = trim 5 - 7 days from quarterly close • Key Steps • Deployed planning system • Built data mart to consolidate ERP and plan data • Built front-end dashboard tool for plan contributors • Technical Solution • Tools leveraged: • Planning system – Cognos Enterprise Planning • Data mart – Microsoft SQL Server 2005 • BI portal – IBM Cognos 8 BI with PowerCubes

  16. Shutterfly • Business Result: Faster, Better Decisions • Visibility into budget variances • Transparency in budgeting process • Facilitation of budget owner accountability • Quarter Close shortened from 15 days to 10 • BvA Scorecard for all departments • FP&A can focus on evaluating projects, business units

  17. Senturus Solution Package • Core solution delivered since 2001 • Pre-packaged code and templates • Package includes: • Requirements analysis • Data mart with linkages to source systems • Customization of reports and dashboards • Delivery of solution, documentation and training • Rapid deployment to maximize business value

  18. Senturus Solution Package Next Steps To discuss how the Senturus Finance Data Mart Solution could work for your organization, please contact James Frazier, Vice President of Sales: jfrazier@senturus.com (650) 949-2921 To request a copy of this presentation, please contact: sales@senturus.com

More Related