National Vision Enhances SAP Business Planning and Consolidation with SAP Analytics Cloud

National Vision, a leader in the U.S. optical industry, is a retailer that has seen tremendous growth since it was founded in 1990. National Vision turned to their long-standing partner, Protiviti, to extend the capabilities of SAP Business Planning and Consolidation, their full financial reporting, budgeting and forecasting tool, with SAP Analytics Cloud for planning.

National Vision is one of the largest and fastest growing U.S. value optical retailers, with a diverse portfolio of 1,185 retail stores across five brands, and 19 consumer websites. Their family of retail brands includes America’s Best, Eyeglass World, Vista Optical, and Walmart Vision Centers, all which promise to deliver high-quality eyewear and eyecare to customers across the nation at affordable prices.

100% improvement in calculation performance
60% increase in reporting and planning accuracy
20% reduction in planning cycle times

Defining the Data Problem

Behind its success, however, the company was facing inefficiencies in integrating its disparate systems and outside data sources. This, combined with complicated and slow calculations in their current financial environment, resulted in processing delays and difficulty updating existing calculations. The company needed to increase efficiency in its financial planning cycle and gain ease of collaboration.

To address these challenges, National Vision decided to extend the capabilities of its SAP Business Planning and Consolidation software by adding SAP Analytics Cloud. Together, the two technology applications would allow the company to gain a clearer view into its financial reporting. The company’s integrated solution incorporated:

  • SAP Business Planning and Consolidation (SAP BPC), a solution that delivers planning, budgeting, forecasting and financial consolidation capabilities
  • SAP Analytics Cloud, a cloud-based next-generation solution that integrates, in one platform, financial planning, reporting, analytics and predictive capabilities to extract actionable insights

National Vision turned to Protiviti, a long-standing SAP Gold partner who has garnered a reputation as a leader in finance transformation, analytics and risk management. Protiviti’s SAP experts worked with the National Vision project team to modernize and implement a comprehensive financial planning and analysis (FP&A) strategy that would enable the company to make its financial process more collaborative and efficient.

Protiviti has partnered with National Vision for nearly 15 years, supporting the company’s overall strategy to be the leading US Optical Retailer. With the addition of SAP Analytics Cloud, National Vision has the tools necessary to simplify the planning process, efficiently model different business scenarios, and understand the potential impact on the organization, enabling the best business decisions for optimal success.

Taylor Courtnay, Managing Director, Protiviti

Sign up now to get started with your free trial of SAP Analytics Cloud.

try for free

The Motivation to Move to the Cloud

It was important for National Vision to engage with its stores and encourage participation in the planning process, as well as to receive input on revenue and payroll and to learn from local stores.  Across the company’s 1,000-plus stores, more than 120 users are involved in the planning process, including district managers, administrators, senior managers and executives, and the core FP&A team. By integrating SAP Analytics Cloud for planning, users throughout the organization can easily share feedback and critical data. This creates opportunities for increased collaboration and maximizing the value of the technology’s powerful features.

With the addition of SAP Analytics Cloud, National Vision has a full suite of technology that enables scenario forecasting to see real-time impact of key business drivers. The primary users are the company’s core FP&A operations team and Field Management. National Vision uses Microsoft as its ERP system, along with SAP Data Services for data integration and SAP BusinessObjects for enterprise analytics. Its core FP&A platform is SAP Business Planning and Consolidation combined with SAP Analytics Cloud for planning. This covers all National Visions’ financial reporting needs, including gap, management and operations reporting.

Since the beginning of our partnership in 2006, Protiviti has provided the business and technical expertise that we needed to maximize the value of our SAP landscape and optimize our FP&A processes. With the addition of SAP Analytics Cloud, we can quickly run simulated models to make the optimal business decisions for our company’s success, with almost instant response time and easy creation and manipulation of new forecast and planning versions.

Karma Bevelhimer, Vice President, Retail Financial Operations

Extending SAP Business Planning and Consolidation to SAP Analytics Cloud for planning

For National Vision, collaboration within SAP Analytics Cloud for planning allows their FP&A administrators the visibility to see feedback from their stores in a central place. The ability for users to comment on cells allows them to clarify details around what collaborators think about the insights gathered, which collaborators contributed, and which specific cell(s) are being discussed.

Now, instead of making hundreds of calls to individual stores to seek clarification or context, FP&A administrators at National Vision have a single platform to collaborate, allowing the process to be vastly more efficient.  Connectivity challenges were alleviated across the organization, resulting in more efficient collaboration among disparate and widely dispersed personnel.

By using SAP Business Planning and Consolidation in their retail planning, National Vision can give stores access to input data regarding payroll and other aspects. It consolidates that data into its corporate planning, as well as in cash flow statements and balance sheets.

Calculations that would have taken hours to run previously now take seconds. SAP Analytics Cloud for planning can sum calculations directly from the SAP HANA-based model and provide the ability to create scenarios on the fly, allowing National Vision’s financial planners to test different versions of scenarios and models. Since the data is not published until the user specifies it, users have the freedom to make changes and improve scenarios until the desired outcome is reached. The ability to access immediate results, along with inputs, calculations and allocations from various stores, provides an instant feedback loop. From a usability standpoint, this creates an extremely easy process for their financial planning. The improved real-time, top-down and bottom-up planning capabilities enabled National Vision to reduce planning cycle times by 20 percent or more.

For National Vision, another advantage to complementing SAP Business Planning and Consolidation with SAP Analytics Cloud for planning was that there was now support for disparate users who did not have the required Excel add-ins. Additionally, from a finance user’s perspective, the inclusion of SAP Analytics Cloud for planning means that the power to take part in every aspect of the FP&A process is now put in their hands. Finance teams can build the FP&A process together and work on allocations, building content, workflows and more.

Building for the Future

Protiviti’s SAP experts worked with National Vision to guide the overall business and technical strategy, enabling National Vision to develop a new planning process that:

  • Removes silos so users are empowered to participate in every aspect of the process
  • Encourages collaborative enterprise planning at all levels
  • Provides access to all users via a cloud-based architecture
  • Provides real time calculations harnessing the power of SAP HANA
  • Allows for deeper analysis through SAP Analytics Cloud for planning

As a result of the extended capabilities of its SAP solution, National Vision saw a significant reduction in data collection time, yielding improved decision-making and extended high-level data analysis and insight. Calculation performance was improved by 100-fold, and reporting and planning accuracy increased by as much as 60 percent.

National Vision considers itself to be in the first phase of its plan to extend its financial planning. National Vision is anticipating taking advantage of the readily available predictive capabilities for SAP Analytics Cloud for planning and creating an automated FP&A process. For now, National Vision’s new reporting and planning landscape allows the company to clearly see what’s in store.

With the combination of SAP Business Planning and Consolidation and SAP Analytics Cloud, we have been able to visualize the results of critical planning decisions early in the planning process, including the impact on specific accounts, and have reduced calculation times from hours to minutes or less, helping us drive performance and gain a competitive advantage.

Karma Bevelhimer, Vice President, Retail Financial Operations

Ready to see what SAP Analytics Cloud can do for you? Sign up for the free trial today.

try for free