際際滷

際際滷Share a Scribd company logo

PPT AnalyticsCloud0415

Inspirage
Inspirage

This document provides an overview of Inspirage's Analytics in the Cloud offering. It summarizes the keynote presentations from Joseph Goncu of Inspirage and Carlene Minasian of NBTY. The Analytics in the Cloud offering enables analysis and decision making using Oracle Advanced Planning Command Center hosted in the cloud. It provides pre-built KPIs, dashboards and reports to support both evaluation processes like S&OP as well as execution. NBTY has benefitted from using APCC for integrated business planning and demand management, gaining improved visibility and focus on strategic planning. The document concludes with a demonstration of APCC capabilities.

1 of 24
INSPIRING VALUE CHAIN ADVANTAGE 速 Analytics in the Cloud Offering April 1, 2015
Introductions Joseph Goncu, INSPIRAGE, Practice Director Supply Chain Management Joseph Goncu has over 15 years of experience managing and implementing Demand and Supply Chain Management projects. Project experience covers several functional areas, such as integrated business planning (IBP), sales and operations planning (S&OP), demand management, supply chain planning, trade promotions planning and inventory planning. He has held project management and solution architect roles covering multiple VCP modules, including Demantra, Advanced Supply Chain Planner (ASCP) and Advanced Planning Command Center (APCC). Carlene Minasian, NBTY, Senior Business Intelligence Analyst, IBP Carlene Minasian is Senior Business Intelligence Analyst for NBTY Inc., a leader in nutritional supplements and wellness products. For the past two years Carlene has led efforts to build and introduce tools to facilitate access to data, dashboards and reporting options to help drive this growing business. As part of this role, Carlene is managing on-going continuous improvement efforts for demand analytics as well as leading efforts for APCC for supply during implementation of Oracle ASCP. Carlene has over 20 years of experience in various supply chain related roles, including S&OP, Demand Planning and Inventory Management. Andrew Bargeron, INSPIRAGE, Senior Consulting Manager Andrew Bargeron has over 17 years of experience as a Supply Chain practitioner in various, progressively responsible positions including procurement, finite scheduling, inventory management, sales and operations planning, and global demand planning. He has many successful EBS and VCP implementations in several industries, including distribution, consumer foodstuffs, metals fabrication, and OEM and a deep knowledge of Oracle Process Manufacturing (OPM) coupled with several VCP implementations for process industries, including metals, consumer products, and pharmaceuticals. 2
Agenda Analytics in the Cloud Overview Deployment Benefits NBTY Case Study Inspirages Analytics in the Cloud Demonstration Questions 3
4 Analytics in the Cloud Typical evaluation considerations Am I losing vital intelligence from VCP applications? Do I develop my own data warehouse instead of using standard Oracle product? How will I deal with technology necessary to deploy intelligence on with the VCP products? Inspirages Analytics in the Cloud is designed to provide the intelligence to take actionable responses Inspirages Analytics in the Cloud uses Oracle Advanced Planning Command Center to present the information needed Inspirages Analytics in the Cloud can be provided via a subscription model
Overview Analytics in the Cloud solution enables analysis and decision making in a Cloud-based environment leveraging Oracle Advanced Planning Command Center (APCC). Host Oracle APCC on the private Cloud network with subscription-based payments for licensing, services and infrastructure Integrated with your base VCP applications Seamlessly exchange data between the instances Leading practices, pre-packaged KPIs and reports Enable both evaluation (ex. S&OP / Integrated Business Planning) and execution processes Custom reports and KPIs to identify the specific problem areas and pinpoint the cause of the problem Cloud / Hosted Solution Business Process / KPIs Deployment & Support Quick deployment within 4 to 8 weeks Ongoing value added services such as DBA support and functional / technical help to extend and maintain the base solution New KPI / report development as part of the support model 5
APCC in the Cloud Host Oracle APCC on the private Cloud network integrated with your base VCP applications 6 Integration Approach APCC Get the right answers Self service, pre-built Rich content and KPIs Seamless integration with planning apps Pre-Built Dashboards and Reports Analyze Distribution plans Production plans Manufacturing plans Supply planning Deployment using SaaS Hosted Model Decision making and analysis in a short period of time using Standard and Inspirage built KPIs On-premise Marketing Demand planning Sales Manufacturing
7 Enabling Evaluation and Execution Analytics in the Cloud provides leading practices driven, pre-packaged KPIs, dashboards and reports to enable the evaluation and execution processes EVALUATION (SIOP / S&OP / IBP) EXECUTION Generate the Consensus Forecast Evaluate the supply responses to the latest Consensus Forecast Run simulations to bridge the gaps between demand / supply / financial targets Generate and archive the Operating Plan Review aggregate tactical metrics to identify resource capacity, inventory, and demand fulfillment risks Monitor enhanced, aggregate demand and supply exceptions in a centralized way Assess supply plan effectiveness with key inventory performance and plan attainment metrics OPERATING PLAN
List of Base KPIs, Dashboards and Reports Demand Review Assess the changes to the Consensus Forecast in units and value. Review accuracy and bias metrics. Track the expected sales against the business plans in units and value. Supply Review Evaluate the service levels, capacity loads and projected inventory positions. Assess the options to improve the supply positions for improved service levels. Take actions to reduce the late demands. Financial Reconciliation Assess and reconcile the financial gaps against the business plans for revenue and margins. Executive Review Review the metric scorecard, sales / revenue / margin outlook and alternative plans. Assess the working capital needs and the service levels. Finalize the decisions to drive the operating plan. Exception Management Evaluate the key exceptions for count, days, quantity, and value. Exceptions aggregated at meaningful levels with drill-down capability Capacity Planning View time-series resource loading at aggregate levels. Review loading at standard rates vs. rates with efficiency/utilization defined Inventory Performance Review Inventory Turns and Days on Hand for ASCP plans, at aggregate levels with drill-down capability to more granular attributes such as Planner and Category Excess & Obsolete Summarizes Excess Supply in two ways: via ASCP pegging data and also with user-defined windows for Excess and Obsolete. Results are summarized monetized Operational Performance Review expected fill rate for shipping orgs, with drill-downs. Also contains a Schedule Attainment report. IBP / S&OP Reports Execution Reports 8 Analytics in the Cloud provides leading practices driven, pre-packaged dashboards and reports to enable the evaluation and execution processes
List of Base KPIs, Dashboards and Reports Executive Review has several views (will be demonstrated): Revenue / Margin Outlook Working Capital Sales Outlook Service Levels 9 Executive Review Material Spend Forecast Review ScoreCard Yearly Trend Tactical Support has several views (will be demonstrated): Excess & Obsolete Inventory Via ASCP Pegging Via User-Defined Windows Tactical Support Resource Requirements: demonstrated vs. standard Schedule Attainment The solution adds a number of custom KPIs on top of standard KPIs. Some of the standard KPIs have been fine-tuned.
10 Deployment & Support Standard model Extended model Live 4 6 weeks Live 2 to 3 months Deployment Model Support Model Ongoing value added services such as DBA support and functional / technical help to extend and maintain the base solution Support for the development of new KPIs after go-live Standard model is deployed with the existing VCP install base and provides access to industry specific KPIs Extended model provides custom KPI development Estimations are based on the availability of the data with Demantra and ASCP
11 Analytics in the Cloud Overview & Benefits: 1. Common supply-chain reporting solution for evaluation (S&OP / Integrated Business Planning) and execution processes 2. Access to leading practices driven reports and KPIs 3. Zero time spent on product installation, patching and maintenance, and user and data administration etc. 4. Enables effective S&OP / Integrated Business Planning 5. Support / development model for evolving business processes with new reports and KPIs
Carlene Minasian, Senior Business Intelligence Analyst, IBP NBTY Presentation 12
Company Introduction 孫 Source: IDC HDD and enterprise SSD (Worldwide Hard Disk Drive 2013-2018 Forecast & Worldwide Solid State Storage 2013-2018 Forecast and Analysis) NBTY is the largest nutritional supplement manufacturer and distributor in the United States with $4 billion annual revenue Company has Omni-channel business model selling through: Wholesale (Wal-Mart, Costco, CVS, Target, Walgreens etc.) Retail (400+ owned US stores Vitamin World) Direct to consumer Puritans Pride (online and mail catalog). NBTY has embarked on a large 5+ year transformational project with Oracle SCM products Main objective included one forecast and one system for multiple business segments 13
Supply Chain Planning Before VCP The supply chain planning processes at NBTY lacked the enterprise planning tools that can provide shared visibility to common data reference points, reduce data compilation efforts, and facilitate a truly collaborative, value added planning process. Multiple, non-integrated systems Manual processes Multiple data sources Supply TeamsChannel Leads FinanceDemand Planners No automated integrated views that connect demand planning with supply planning. Significant effort spent running the business, taking focus away from planning the business reactive vs. proactive. 14
Business Benefits from VCP: Stakeholder visibility to the consensus demand forecast and supply planning details Visibility to demand signal building blocks Planning teams focus on value added activity vs. administratively cumbersome data maintenance View includes input from Finance to provide visibility to revenue impact from supply chain planning activities Summary of demand planning output data with pre-calculated KPIs, reports, dashboards as well as archived information for trend analysis and comparison to support executive review, strategic planning, S&OP planning and tactical planning. Upon the deployment of the Demand Management phase of the Value Chain Planning implementation, NBTY business users have a consolidated view of demand on a common planning platform. Demand Management 15 Stakeholders Common Planning Platform Single Source of Truth Channel Leads Demand Planning Supply Chain Demand Signals Product plans Customer Data Revenue Plan/ASP Executive team
Addressing NBTY Challenges with APCC The Solution Analytics enabled demand management 16 One source of truth, frequent on demand reporting and analysis Demand review enabled at various aggregations to support IBP Insightful reports: forecast growth and causes, forecast accuracy, COGS, margin, revenue, budgets Forecast by building block; natural growth, promotion, new products and markets KPIs for all level of users; operational and executive level Granular drill downs on data elements YoY Growth Waterfall Accuracy
System Deployment Options 17 On-premise Hosted/Cloud Marketing Demand Planning/IBP Sales Manufacturing APCC Pre-Built Dashboards and Reports 1. Efficient high availability system 2. Complete turn key solution for NBTY 3. Takes away the system admin overheads 4. Technology challenges with on premise model addressed
Current Status and Future Plans 18 Fully deploy integrated IBP process within APCC Expecting significant benefits from an integrated deployment Fully deploy ASCP and IO using Hosted/Cloud model APCC currently used for demand management and IBP Realizing significant benefits from the initial rollout
Demo 19
20 Tactical Support Dashboard The Tactical Support Dashboard has the following topical pages: Tactical Support has reports and metrics supporting both daily and weekly/monthly supply planning activities Demo will focus on Capacity Planning, Excess and Obsolete Inventory, and Operational Performance Capacity Planning Excess & Obsolete Operational Performance
21 Evaluation Process (S&OP / IBP) Dashboard The IBP / S&OP Dashboard has the following pages: Executive review enables a good number of views including IBP / S&OP Scorecard, Revenue / Margin Outlook, Sales Outlook, Working Capital, Service Level Review, Forecast Review and Year Over Year Progress Executive Review
Summary and Questions 22
23 Analytics in the Cloud Deploy Oracle APCC as a hosted model with subscription- based payments for licensing, services and infrastructure. Host Oracle APCC on the private Cloud network integrated with your base VCP applications. Enable both evaluation (ex. S&OP / IBP) and execution processes using leading practices, pre-packaged KPIs and reports. Build enhancements for client-specific reports and KPIs to pinpoint the opportunities and problem areas Standard deployment can be completed within 4 to 8 weeks. New KPIs, dashboards and reports are added as part of the support model. Ongoing value added services such as DBA support is available. Common supply-chain reporting solution for evaluation (S&OP / IBP) and execution processes Access to leading practices driven reports and KPIs Zero time spent on product installation, patching and maintenance, and user and data administration etc. OVERVIEW & BENEFITS Enables effective S&OP / Integrated Business Planning Support / development model for evolving business processes with new reports and KPIs Customizable KPIs and reports EVALUATION (SIOP / S&OP / IBP) EXECUTIONOPERATING PLAN Standard model Extended model Live ~ 4 weeks Live 2 to 3 months
Contact Information 24 Michael Pearson (630) 902-0655 michael.pearson@inspirage.com Upcoming Inspirage Events Lav Batra (703) 626-1264 lav.batra@inspirage.com Master Production Scheduling Workbench for ASCP Thursday, April 23, 2015 9 am PDT | 12 noon EDT | 18:00 CEST Collaborate 2015 April 1216, 2015 Mandalay Bay Resort and Casino

More Related Content

PPT AnalyticsCloud0415

  • 1. INSPIRING VALUE CHAIN ADVANTAGE 速 Analytics in the Cloud Offering April 1, 2015
  • 2. Introductions Joseph Goncu, INSPIRAGE, Practice Director Supply Chain Management Joseph Goncu has over 15 years of experience managing and implementing Demand and Supply Chain Management projects. Project experience covers several functional areas, such as integrated business planning (IBP), sales and operations planning (S&OP), demand management, supply chain planning, trade promotions planning and inventory planning. He has held project management and solution architect roles covering multiple VCP modules, including Demantra, Advanced Supply Chain Planner (ASCP) and Advanced Planning Command Center (APCC). Carlene Minasian, NBTY, Senior Business Intelligence Analyst, IBP Carlene Minasian is Senior Business Intelligence Analyst for NBTY Inc., a leader in nutritional supplements and wellness products. For the past two years Carlene has led efforts to build and introduce tools to facilitate access to data, dashboards and reporting options to help drive this growing business. As part of this role, Carlene is managing on-going continuous improvement efforts for demand analytics as well as leading efforts for APCC for supply during implementation of Oracle ASCP. Carlene has over 20 years of experience in various supply chain related roles, including S&OP, Demand Planning and Inventory Management. Andrew Bargeron, INSPIRAGE, Senior Consulting Manager Andrew Bargeron has over 17 years of experience as a Supply Chain practitioner in various, progressively responsible positions including procurement, finite scheduling, inventory management, sales and operations planning, and global demand planning. He has many successful EBS and VCP implementations in several industries, including distribution, consumer foodstuffs, metals fabrication, and OEM and a deep knowledge of Oracle Process Manufacturing (OPM) coupled with several VCP implementations for process industries, including metals, consumer products, and pharmaceuticals. 2
  • 3. Agenda Analytics in the Cloud Overview Deployment Benefits NBTY Case Study Inspirages Analytics in the Cloud Demonstration Questions 3
  • 4. 4 Analytics in the Cloud Typical evaluation considerations Am I losing vital intelligence from VCP applications? Do I develop my own data warehouse instead of using standard Oracle product? How will I deal with technology necessary to deploy intelligence on with the VCP products? Inspirages Analytics in the Cloud is designed to provide the intelligence to take actionable responses Inspirages Analytics in the Cloud uses Oracle Advanced Planning Command Center to present the information needed Inspirages Analytics in the Cloud can be provided via a subscription model
  • 5. Overview Analytics in the Cloud solution enables analysis and decision making in a Cloud-based environment leveraging Oracle Advanced Planning Command Center (APCC). Host Oracle APCC on the private Cloud network with subscription-based payments for licensing, services and infrastructure Integrated with your base VCP applications Seamlessly exchange data between the instances Leading practices, pre-packaged KPIs and reports Enable both evaluation (ex. S&OP / Integrated Business Planning) and execution processes Custom reports and KPIs to identify the specific problem areas and pinpoint the cause of the problem Cloud / Hosted Solution Business Process / KPIs Deployment & Support Quick deployment within 4 to 8 weeks Ongoing value added services such as DBA support and functional / technical help to extend and maintain the base solution New KPI / report development as part of the support model 5
  • 6. APCC in the Cloud Host Oracle APCC on the private Cloud network integrated with your base VCP applications 6 Integration Approach APCC Get the right answers Self service, pre-built Rich content and KPIs Seamless integration with planning apps Pre-Built Dashboards and Reports Analyze Distribution plans Production plans Manufacturing plans Supply planning Deployment using SaaS Hosted Model Decision making and analysis in a short period of time using Standard and Inspirage built KPIs On-premise Marketing Demand planning Sales Manufacturing
  • 7. 7 Enabling Evaluation and Execution Analytics in the Cloud provides leading practices driven, pre-packaged KPIs, dashboards and reports to enable the evaluation and execution processes EVALUATION (SIOP / S&OP / IBP) EXECUTION Generate the Consensus Forecast Evaluate the supply responses to the latest Consensus Forecast Run simulations to bridge the gaps between demand / supply / financial targets Generate and archive the Operating Plan Review aggregate tactical metrics to identify resource capacity, inventory, and demand fulfillment risks Monitor enhanced, aggregate demand and supply exceptions in a centralized way Assess supply plan effectiveness with key inventory performance and plan attainment metrics OPERATING PLAN
  • 8. List of Base KPIs, Dashboards and Reports Demand Review Assess the changes to the Consensus Forecast in units and value. Review accuracy and bias metrics. Track the expected sales against the business plans in units and value. Supply Review Evaluate the service levels, capacity loads and projected inventory positions. Assess the options to improve the supply positions for improved service levels. Take actions to reduce the late demands. Financial Reconciliation Assess and reconcile the financial gaps against the business plans for revenue and margins. Executive Review Review the metric scorecard, sales / revenue / margin outlook and alternative plans. Assess the working capital needs and the service levels. Finalize the decisions to drive the operating plan. Exception Management Evaluate the key exceptions for count, days, quantity, and value. Exceptions aggregated at meaningful levels with drill-down capability Capacity Planning View time-series resource loading at aggregate levels. Review loading at standard rates vs. rates with efficiency/utilization defined Inventory Performance Review Inventory Turns and Days on Hand for ASCP plans, at aggregate levels with drill-down capability to more granular attributes such as Planner and Category Excess & Obsolete Summarizes Excess Supply in two ways: via ASCP pegging data and also with user-defined windows for Excess and Obsolete. Results are summarized monetized Operational Performance Review expected fill rate for shipping orgs, with drill-downs. Also contains a Schedule Attainment report. IBP / S&OP Reports Execution Reports 8 Analytics in the Cloud provides leading practices driven, pre-packaged dashboards and reports to enable the evaluation and execution processes
  • 9. List of Base KPIs, Dashboards and Reports Executive Review has several views (will be demonstrated): Revenue / Margin Outlook Working Capital Sales Outlook Service Levels 9 Executive Review Material Spend Forecast Review ScoreCard Yearly Trend Tactical Support has several views (will be demonstrated): Excess & Obsolete Inventory Via ASCP Pegging Via User-Defined Windows Tactical Support Resource Requirements: demonstrated vs. standard Schedule Attainment The solution adds a number of custom KPIs on top of standard KPIs. Some of the standard KPIs have been fine-tuned.
  • 10. 10 Deployment & Support Standard model Extended model Live 4 6 weeks Live 2 to 3 months Deployment Model Support Model Ongoing value added services such as DBA support and functional / technical help to extend and maintain the base solution Support for the development of new KPIs after go-live Standard model is deployed with the existing VCP install base and provides access to industry specific KPIs Extended model provides custom KPI development Estimations are based on the availability of the data with Demantra and ASCP
  • 11. 11 Analytics in the Cloud Overview & Benefits: 1. Common supply-chain reporting solution for evaluation (S&OP / Integrated Business Planning) and execution processes 2. Access to leading practices driven reports and KPIs 3. Zero time spent on product installation, patching and maintenance, and user and data administration etc. 4. Enables effective S&OP / Integrated Business Planning 5. Support / development model for evolving business processes with new reports and KPIs
  • 12. Carlene Minasian, Senior Business Intelligence Analyst, IBP NBTY Presentation 12
  • 13. Company Introduction 孫 Source: IDC HDD and enterprise SSD (Worldwide Hard Disk Drive 2013-2018 Forecast & Worldwide Solid State Storage 2013-2018 Forecast and Analysis) NBTY is the largest nutritional supplement manufacturer and distributor in the United States with $4 billion annual revenue Company has Omni-channel business model selling through: Wholesale (Wal-Mart, Costco, CVS, Target, Walgreens etc.) Retail (400+ owned US stores Vitamin World) Direct to consumer Puritans Pride (online and mail catalog). NBTY has embarked on a large 5+ year transformational project with Oracle SCM products Main objective included one forecast and one system for multiple business segments 13
  • 14. Supply Chain Planning Before VCP The supply chain planning processes at NBTY lacked the enterprise planning tools that can provide shared visibility to common data reference points, reduce data compilation efforts, and facilitate a truly collaborative, value added planning process. Multiple, non-integrated systems Manual processes Multiple data sources Supply TeamsChannel Leads FinanceDemand Planners No automated integrated views that connect demand planning with supply planning. Significant effort spent running the business, taking focus away from planning the business reactive vs. proactive. 14
  • 15. Business Benefits from VCP: Stakeholder visibility to the consensus demand forecast and supply planning details Visibility to demand signal building blocks Planning teams focus on value added activity vs. administratively cumbersome data maintenance View includes input from Finance to provide visibility to revenue impact from supply chain planning activities Summary of demand planning output data with pre-calculated KPIs, reports, dashboards as well as archived information for trend analysis and comparison to support executive review, strategic planning, S&OP planning and tactical planning. Upon the deployment of the Demand Management phase of the Value Chain Planning implementation, NBTY business users have a consolidated view of demand on a common planning platform. Demand Management 15 Stakeholders Common Planning Platform Single Source of Truth Channel Leads Demand Planning Supply Chain Demand Signals Product plans Customer Data Revenue Plan/ASP Executive team
  • 16. Addressing NBTY Challenges with APCC The Solution Analytics enabled demand management 16 One source of truth, frequent on demand reporting and analysis Demand review enabled at various aggregations to support IBP Insightful reports: forecast growth and causes, forecast accuracy, COGS, margin, revenue, budgets Forecast by building block; natural growth, promotion, new products and markets KPIs for all level of users; operational and executive level Granular drill downs on data elements YoY Growth Waterfall Accuracy
  • 17. System Deployment Options 17 On-premise Hosted/Cloud Marketing Demand Planning/IBP Sales Manufacturing APCC Pre-Built Dashboards and Reports 1. Efficient high availability system 2. Complete turn key solution for NBTY 3. Takes away the system admin overheads 4. Technology challenges with on premise model addressed
  • 18. Current Status and Future Plans 18 Fully deploy integrated IBP process within APCC Expecting significant benefits from an integrated deployment Fully deploy ASCP and IO using Hosted/Cloud model APCC currently used for demand management and IBP Realizing significant benefits from the initial rollout
  • 20. 20 Tactical Support Dashboard The Tactical Support Dashboard has the following topical pages: Tactical Support has reports and metrics supporting both daily and weekly/monthly supply planning activities Demo will focus on Capacity Planning, Excess and Obsolete Inventory, and Operational Performance Capacity Planning Excess & Obsolete Operational Performance
  • 21. 21 Evaluation Process (S&OP / IBP) Dashboard The IBP / S&OP Dashboard has the following pages: Executive review enables a good number of views including IBP / S&OP Scorecard, Revenue / Margin Outlook, Sales Outlook, Working Capital, Service Level Review, Forecast Review and Year Over Year Progress Executive Review
  • 23. 23 Analytics in the Cloud Deploy Oracle APCC as a hosted model with subscription- based payments for licensing, services and infrastructure. Host Oracle APCC on the private Cloud network integrated with your base VCP applications. Enable both evaluation (ex. S&OP / IBP) and execution processes using leading practices, pre-packaged KPIs and reports. Build enhancements for client-specific reports and KPIs to pinpoint the opportunities and problem areas Standard deployment can be completed within 4 to 8 weeks. New KPIs, dashboards and reports are added as part of the support model. Ongoing value added services such as DBA support is available. Common supply-chain reporting solution for evaluation (S&OP / IBP) and execution processes Access to leading practices driven reports and KPIs Zero time spent on product installation, patching and maintenance, and user and data administration etc. OVERVIEW & BENEFITS Enables effective S&OP / Integrated Business Planning Support / development model for evolving business processes with new reports and KPIs Customizable KPIs and reports EVALUATION (SIOP / S&OP / IBP) EXECUTIONOPERATING PLAN Standard model Extended model Live ~ 4 weeks Live 2 to 3 months
  • 24. Contact Information 24 Michael Pearson (630) 902-0655 michael.pearson@inspirage.com Upcoming Inspirage Events Lav Batra (703) 626-1264 lav.batra@inspirage.com Master Production Scheduling Workbench for ASCP Thursday, April 23, 2015 9 am PDT | 12 noon EDT | 18:00 CEST Collaborate 2015 April 1216, 2015 Mandalay Bay Resort and Casino