INW

INW + ONESTREAM Case Study

ABOUT INW

INW delivers best-in-class products across the spectrum of health and wellness—offering a comprehensive suite of capabilities including R&D, manufacturing, packaging, logistics, and more.

THE CHALLENGE

INW Replaced numerous Excel models with a single point of data entry for reporting.

Visibility and Executive level reporting took too much time and manipulation, limiting transparency, particularly with transaction data, thus not leaving enough time to spend dissecting what the data was telling about the business.

  • INDUSTRY

    R&D, Manufacturing, Packaging, Logistics

  • REVENUE

    Private Equity Owned

  • FORMER EPM

    Excel

  • EVALUATED

    Oracle

  • BENEFITS SUMMARY

    • Implemented transparent changes during the planning process.

    • READ MORE

ELEMENTS OF SUCCESS

Planning & Forecasting, People Planning, Capital Planning, Data Integration

THE PROJECT

  • The goal was to implement a single source budgeting and forecasting solution.
  • Implemented an automated driver based ‘accordion’ style rolling forecast eliminating the arduous budget process.
  • Delivered driver-based revenue and cogs planning.
  • Created a customized People Planning application with direct syncing of data to the Main Planning application for real-time reporting.
  • Implemented a customized solution to capture Project/Capital, and Expense Planning.
  • Automated Balance Sheet Planning.
  • Optimized existing VB.net scripts.
  • Created OneStream Books to deliver “bursted reporting.”
  • TECHNOLOGY & INTEGRATION

    SAP & Manufacturing Systems

  • BUSINESS CHALLENGES

    INW was acquiring new businesses, the manufacturing company was performing consolidations and budgeting in Excel, and each division had different complex processes.

  • SCOPE

    Driver-based rolling forecasting, capital asset planning, customer level sales by product, revenue, materials, and labor.

KEY BENEFITS

Implemented a Modern and Unified CPM Solution.

Delivered real time reporting allowing for trust in the data and the ability to make transparent changes during the planning process.

Driver Based Revenue and Cogs planning provided real insight for decision making during uncertain times.

Integrated key source systems, such as SAP, Manufacturing data and Excel.

Created Executive visibility with the creation of dashboards and guided reporting.

Delivered “bursted” reporting via OneStream books.

ABOUT BLACK DIAMOND

Black Diamond is the leading Digital Finance Transformation firm and OneStream Diamond Partner. We leverage depth of experience and breadth of knowledge to define client needs. We are industry experts who anticipate current and future challenges and share our experience and knowledge to address them. We seek to have joint development of the solutions we create and remain engaged with clients throughout the entire transformation journey to ensure the greatest value is derived.

Black Diamond Advisory is based in Golden, Colorado.  Our Advisory and Consulting Experts are located throughout the United States and are deployed to each customer location to provide hands-on support through the duration of the implementation process. For more information, visit  www.blackdiamondadvisory.com or on LinkedIn at https://www.linkedin.com/company/blackdiamondadvisory

 

diamonds