Client Case Study

Memjet

Automates planning and budgeting with Oracle EPM Cloud

Logo_Memjet PNG

Financial Transformation

  • Industry

    Digital Inkjet Technology

  • Employees

    315

  • HQ

    San Diego, California

  • Website

    www.memjet.com

  • Product & Services used

    Oracle EPM Cloud, Qubix Q.vate™ Methodology

Download case study

Memjet desired automation of their manual budgeting and forecasting solution to replace the manual processes performed in Excel using an endless number of linked files and pivot tables.

 

Memjet is the global leader in providing digital inkjet technology that enables unmatched simplicity, speed and profitability. Driven by a passion for innovation and a desire to change the printing industry, they focus on supplying OEM partners across the world with advanced printhead, module and ink technologies. Together with their OEM partners, they develop the fastest, highest resolution, most flexible digital print solutions for the widest range of market segments—at a remarkably affordable cost. The company maintains its corporate office in San Diego, California and has offices in Dublin, Sydney, Taipei, Singapore and Boise, Idaho.

The project was initiated by Memjet leadership to provide a centralized platform upon which annual budgets, forecasts, near-term and long-range financial plans can be developed and managed. The vision was to replace a decentralized spreadsheet approach which was cumbersome and prone to error. Memjet selected the Oracle EPM Cloud solution to streamline the planning process, free up bandwidth to focus on innovation, create meaningful insights, and accelerate the financial planning process.

"…A centralized approach to planning, budgeting, and forecasting has made our lives easier as well as provided more timely and accurate reports."

Melanie Smith

Melanie Smith
Vice President of Financial Planning and Analysis

 

The overall design and implementation of Oracle EPM Planning Cloud (PBCS) allowed Memjet to address the issues that existed in the current Excel models and processes. The project began with a discovery phase to understand the challenges faced by each of the business areas and legal entities to develop an "as-is" and "to-be" functional specification that ensured the solution delivered met Memjet's project objectives.

Creating an export of the needed data out of NetSuite was out of scope, but the data still had to be input into planning forms. Excel templates connected to Oracle EPM Cloud were created to handle the complexity and flexibility and streamline this process. Alternate account roll-ups were created for many of the working capital accounts, while input accounts were provided to load cash flow items along with beginning and ending balances to ensure balances roll correctly. When the process is completed the ending balances are copied into the pertinent balance sheet accounts.

Alternate period hierarchies were created to make the process seamless, with the actual data copied for analysis and then copied back into the main periods for reporting purposes. This was done in forms and made use of a business rule, eliminating the need to open up closed periods or change security on the version.

Forecasting data was needed at varying levels of detail, so the input levels were created where needed: at the product, project, account, or all three levels. We additionally categorized all the processes into four groups and created rulesets to manage the processing of the data. The actual data is summarized historically into the input accounts, providing necessary trending information for better forecasting. The submitted data was copied back to the relevant base-level members.

The accounts administration is simplified through a simple flowchart - a decision tree stating the type of account and its location in the process. The aim was to provide the data at the needed level and keep administration simple and easy.

We implemented the application using a "sprint-based" approach, releasing functionality iteratively. The delivery was split across 7 Sprints, each sprint including weekly ‘Show & Tells’ and an end of sprint conference room pilot.

This engagement leveraged Qubix's Q.vate™ Methodology to achieve the finance transformation objectives - a best practice approach that combines our deep industry and technical expertise to design, implement and automate FP&A processes in the cloud.

 

Challenges

  • The complexity of the current working capital Excel templates was one of the biggest issues. Compounding it was the fact that data needed for creating key working capital values did not exist in the planning spreadsheets, but only in modules within Memjet's Oracle NetSuite application. To overcome this, reports were run using NetSuite, and then manually input into the Excel templates, which was extremely time-consuming.
  • Indirect Cash flow reports were organized into operating, investing, and financing activities. However, data was only loaded at the balance sheet level in the planning application. To compensate for this, the actual data had to be adjusted to reflect the component pieces of the cash flow activity in a seamless manner. To post the adjustments, closed periods had to be open, creating a real risk of changing the actual published data.

  • Forecasting data was needed at varying levels of detail. Memjet has limited resources and certain dimensions were not necessary to forecast at the lowest level. However, most of the balance sheet was only relevant at the top of the house summary level and therefore forecasted as such. This created a mix of detail and summary level forecasting needs.

Solution

  • Implementation of Oracle EPM Planning Cloud Service (PBCS).
  • Qubix Q.vate™ methodology to accelerate FP&A Automation in the cloud.

Results

  • Eliminated reliance on the large complex spreadsheets and minimised inherent issues of the spreadsheets.
  • Reduced effort in completing the planning process with the elimination of manual processes.
  • Improved data accuracy and user confidence in the Plans and Forecasts.
  • Reduced time needed to manage the process, freeing up more time to analyze data. The Planning tool does all calculations and aggregation of data.
  • Increased data transparency throughout the Planning process.

Share

Why did Memjet choose Qubix?

" The Qubix team is very knowledgeable and patient. We feel that we have the right partner to help us on our journey. "

Melanie Smith

Melanie Smith

Vice President of Financial Planning & Analysis

 Related case studies

How we create client success

Luceco plc products
Finance Transformation

Finds consolidation and reporting efficiency in the cloud

Luceco plc ensures trust and confidence in their reports by reducing their dependency on spreadsheets with Oracle EPM Cloud Consolidation and Close.

Read case study
HS Featured Image - Hyde Housing
Finance Transformation

Streamlines their planning and budgeting processes in the cloud

London's largest housing association partners with Qubix to migrate their on-premises planning and budgeting application to Oracle EPM Planning Cloud in only 3 weeks for new efficiency, scale and insight.

Read case study
Case Study Page - Ocado SEO
Finance Transformation

Adopts planning and budgeting in the cloud to scale for hyper-growth

Ocado adopted integrated planning, budgeting and forecasting solution covering finance, supply chain, and HR to support new business growth.

Read case study

Get in touch with Qubix

Please share some details with us, and we'll get in touch as soon as we can.

Contact Us